Most aerial sockets are attached to the Tuner directly and usually requires replacement of the Tuner unit.
You could try removing the Tuner and soldering the socket back on but it may or may not work and will never be as strong as it was.
Some earlier televisions used a socket attached to the Tuner via a lead called an Aerial Isolator assembly but this has become rare as most use the Tuner directly.
sparky, December 2005