FSX-MS Extracting airport data from FSX... need help

[briansommers 74]

I'm familiar with MakeRunways and I've used that, that gives me the ICAO and airport name, 

 

I'm looking for something that would pull out the country, city, state data as well so I could put in into a spreadsheet.

 

How do I do this?

 

Thanks.

[fs4fun 366]

Maybe AI Flight Planner? I think it extracts this information and puts it in a file called airportlist.dat.

[Pete Dowson 558]

I'm familiar with MakeRunways and I've used that, that gives me the ICAO and airport name, .

 

The "Runways..xml" file it creates also gives ypu the City name, where present in the scenery files.

 

I'm looking for something that would pull out the country, city, state data as well

 

Hmm. The XML file could probably include the country and state if it's there. The city is already included as I say.

 

No one has ever asked for it before, that's all. I never saw point in making files large just for the sake of it! ;-)

 

Pete

[realm174 4]

Sorry for the late revival of this thread, but I've been googling for 2 days, looking for the same information as Brian. Although I wasn't familiar with MakeRwys (well, familiar enough to know it existed, but that's pretty much it), I downloaded it (v 4.678), copy it to my main FSX folder, and ran it. It created a bunch of files, however, I cannot locate Runways.xml in that folder.  Am I missing something obvious?

 

thanks

 

Edit: I actually found something here... Updated daily. It has csv files of different information. I realize this might not include everything one has locally, but that's a heck of a good start I think.

 

http://ourairports.com/data/

 

So by taking the airports file and the regions file (if you're familiar with excel) you can easily do a vlookup and merge the information into one larger file.