Hmmph, my sunroof also started leaking after the recent wet weather. It's clearly done it before, since the sunroof had sealant all around it. I think I'll keep scouring a well known auction site for a seal, since I don't think my local dealer will be of much use for a daft bit like that.
For the powered aerial, you could always grab one from a different car of similar size, and wire the motor up to a flick switch in the cabin.