I just uploaded the February 19, 2004 ATA-100 data.
http://aviationtoolbox.org/raw_data/...0/20040219.zip

I've been asked several times (and twice this week) how I decode this data
for the delimited views
http://aviationtoolbox.org/old/ATA-100/
so I decided to take a pass at rewriting the ugly Perl code I originally
wrote to do this. The result is a very basic (and horribly inefficient)
Python class.
http://aviationtoolbox.org/old/FAA_ATA100.py
It should be enough to give you the data in an easy-to-use format so that
it can be placed in your choice of database.

The module includes some simple code to exercise it. Right now it looks
at the APT files and generates output about airports and runways.
ADK ADAK ISLAND AK -176.646030556 51.8779638889
05/23 7790 200
18/36 7605 200
AKK AKHIOK AK -154.182555556 56.9386908333
04/22 3320 60
Z13 AKIACHAK AK -161.422444444 60.9048333333
11/29 1649 40
KKI AKIACHAK AK -161.435077222 60.9078647222
E/W 5000 300
NW/SE 5000 500
AKI AKIAK AK -161.230583333 60.9028888889
03/21 3196 75
KQA AKUTAN AK -165.785311111 54.1324669444
E/W 10000 1000

It should work on all of the files that are described in the standard way
and on any of the record types. If it fails for something you need, tell
me.

It only takes a few lines of simple Python code to use this. Even if you
haven't touched Python, don't hesitate to give it a shot. It's not just
for people who want to maintain their own databases; you can use it to
answer questions like "Where's the shortest (gravel) runway with an ILS?"

Enjoy.

--kyler