List of military bases by ICAO?
Posted: 09 May 2021, 17:36
Hi everybody -
I'm presently trying to create a variation on the Excel-based flightplanner by Rysiek Winawer (with his blessing) and have chosen to re-jig it so that it isn't base-centric but aircraft-centric. By this I mean that a long list of aircraft can be provided with basing information appended to the aircraft's details in the spreadsheet. It can thus create fleet-based plans for aircraft with each of them based at different places.
I'm doing this as a side-project for a helicopter package using several of JY's magnif models (albeit in military configuration in some cases), some UTT, some Just Flight etc. It involves 800 civilian helicopters across the UK, at least for my purposes.
There are extensions to the original idea, one being to flag airports that are military bases of whatever service and avoid civilian traffic being routed there by flags set per-airport, but this needs there to be a whole host of airports to flag up as military. I've tried to automate some of this in Excel from the airports I have so far (e.g. if the names contain "Air Base" in the name then they get flagged as unavailable to civilian traffic).
I've seen several lists, including those at Airportcodes, etc, but was wondering whether there is some definitive list of every military base by ICAO ID that might avoid me having to edit the status of airfields manually. So far the airport database is just European, and I'm dreading extending this out further afield when a definitive list could reduce the job to 10 minutes.
If necessary, I may do that, I'd just prefer not to, or I may just leave countries outside of Europe for others to set up as they need to. The list could simply be the ICAOs with no other data, since they are referred to other data, and just the ICAOs presence in a list of military airfields is enough to let me set up the info in the other airfield list where all of this stuff is gathered up.
This question was previously asked back in 2008, but the links given there are now defunct.
I'm presently trying to create a variation on the Excel-based flightplanner by Rysiek Winawer (with his blessing) and have chosen to re-jig it so that it isn't base-centric but aircraft-centric. By this I mean that a long list of aircraft can be provided with basing information appended to the aircraft's details in the spreadsheet. It can thus create fleet-based plans for aircraft with each of them based at different places.
I'm doing this as a side-project for a helicopter package using several of JY's magnif models (albeit in military configuration in some cases), some UTT, some Just Flight etc. It involves 800 civilian helicopters across the UK, at least for my purposes.
There are extensions to the original idea, one being to flag airports that are military bases of whatever service and avoid civilian traffic being routed there by flags set per-airport, but this needs there to be a whole host of airports to flag up as military. I've tried to automate some of this in Excel from the airports I have so far (e.g. if the names contain "Air Base" in the name then they get flagged as unavailable to civilian traffic).
I've seen several lists, including those at Airportcodes, etc, but was wondering whether there is some definitive list of every military base by ICAO ID that might avoid me having to edit the status of airfields manually. So far the airport database is just European, and I'm dreading extending this out further afield when a definitive list could reduce the job to 10 minutes.
If necessary, I may do that, I'd just prefer not to, or I may just leave countries outside of Europe for others to set up as they need to. The list could simply be the ICAOs with no other data, since they are referred to other data, and just the ICAOs presence in a list of military airfields is enough to let me set up the info in the other airfield list where all of this stuff is gathered up.
This question was previously asked back in 2008, but the links given there are now defunct.