Hello FH.
Does the Comet have a chunky arse where it broke from the mounting? Is it fat enough to drill and tap a thread? Is the mounting easily removed so a thread can be cut? It looks fairly cylindrical at the tip?
If it's possible, that would keep it in the air forever!