Excel VBA and AirNav

[Cap'n Jack]

The attached ZIP file contains an XL file containg VBA programs.

I was curious what percent of operationswere military- Airnav lists the percent of various operations at airports-I wrote a program that reads AirNav using the airport list from the FAA- the results:
General Aviation: 71%
Commercial: 22%
Military: 6%

I assume Airnav considers a takeoff or landing to be an operation. Data is from 2007 and 2007.

Where does Airnav get their data?

This analysis also suggests at least 6% of the FAA funding be from the general fund to support military operations.

It would be interesting how many operations require FAA facilities and ATC.

Next- I'll write a similar program that reads METAR or TAF data locally and I can get a virtual graphing barometer. Reading about 2x per hour should be sufficient.

 

[mikea]

...I assume Airnav considers a takeoff or landing to be an operation. Data is from 2007 and 2007.

Where does Airnav get their data?

This analysis also suggests at least 6% of the FAA funding be from the general fund to support military operations.

It would be interesting how many operations require FAA facilities and ATC.

Next- I'll write a similar program that reads METAR or TAF data locally and I can get a virtual graphing barometer. Reading about 2x per hour should be sufficient.

It's the FAA ATA-100 data, but AirNav thanks you for crediting him for the public info.

It was available on CD-ROM by mail subscription. Maybe from NACO. I can't find out how you get it now. A few sites had it on the but none since 2006. Like: http://data.pilotage.com/software/cd_faa/

AirNav used to offer a copy,. too. Maybe the FAA changed the name or format since then. In any case I can't see how you get it. Good luck Googling.


To answer your question what is considered a landing, and what's GA, commercial or military etc. ,it's whatever the airport operator or tower reports. The towers have a clicker to count TOs and landings so they can justify being there. Ask EdFred how he reports to the FAA.

 

[EdFred]

We just guesstimate. Takeoff = 1 op, landing = 1 op.

 

[mikea]

We just guesstimate. Takeoff = 1 op, landing = 1 op.

I meant how you report it. You send a survey form back every so often?

 

[EdFred]

I meant how you report it. You send a survey form back every so often?

I send an excel file to the feds that they ignore. I've been trying to get them to update information for 3 years and they don't/won't.