Hi Syd, with 225,000 routes in the database some of which as you state are no longer used, for me to manually go through each one to delete would take a life time. In addition some of the routes from 2011, 2012 etc are still in use for example with BA and some of the established legacy airlines and if we removed all the ones from that time I would have to add them back in again.
Each route entry, deletion, amendment is done manually by me apart from the ones the automatic routines do and I tend to give my time to routes with no data and incorrect data. It is amazing how quickly flight ID's change and not just on the usual summer/winter timetable change overs. Wizz Air for example seemed to be changing some flight ID's on a near weekly basis for a while. nightmare to keep on track of. The auto routine is quite good at deleting routes it thinks are incorrect but quite often gets it wrong and I have to add them back in when they come to my attention which in some cases is nearly a daily basis especially for short haul routes.
Some routes including for example the AEA ones to Edinburgh you forwarded are very short lasting. These ones were used on the route twice bringing and taking away passengers for a cruise and will probably be used on another route the next time we see them.
The good thing is that as the out of date routes are no longer used they dont show up on screen and they dont take up much memory but to delete them would take up an extraordinary amount of time.
Regarding the ones tied to frames such as business jets/ RCH flight etc as soon as they are removed the auto routine adds in the next flight it sees the frame do and is able to determine its route and it stays that way until it is deleted again.
I have requested Airnav to see if they can find some way for the auto routine to ignore such callsigns and hopefully they will manage it someday, however there are more pressing matters which need their attention more.
In the mean time thanks very much for taking the time to gather these together and send them in.
Alan
