DVA13608
Captain, A320
Joined on January 26 2019
Moose Club
Century Club
Eurocap Club
Toulouse Century Club
Online Century Club
Edmonton, AB Canada
143 legs, 242.3 hours
140 legs,
235.1 hours online
140 legs,
238.3 hours ACARS
|
Posted onPost created on
April 08 2020 19:07 ET by Gerard Beekmans
|
When viewing the "Accomplishment Eligibility" list in Pilot Center, it lists name and ICAO. When viewing the PDF file, it lists IATA but no names so it's hard to correlate the two.
Is it possible to add ICAO instead or (or in addition to) the IATA codes in the DVA Master List of Accomplishments PDF file? When it concerns the Canadian and US airports it's easy enough to put "C" or "K" in front of it respectively but for other accomplishments it's not so straight-forward such as IATA "ANU" vs ICAO "TAPA".
My personal purpose is importing all these accomplishments into my own database so I can be more selective when choosing a flight. For example my last flight was into Cleveland. Rather than pick a random destination out Cleveland, I query my own database to show me a list of everything out of Cleveland that will have me land at an airport that's also on the list of one or more accomplishments/clubs.
If you don't have an easy way to do this then I can run it all through a script instead. I already have loaded into my SQL database the global airports database but I only thought to include the ICAO codes as I never thought I'd care about the IATA counterparts (until just now). I have all the pieces but I'm missing the Python code to convert it. I was hoping to save some time if you have a quicker way of updating the PDF.
Also, I can't copy and paste out of the PDF file. Is that done on purpose? Typing it all out manually is tedious.
Gerard BeekmansCaptain, A320
|
|
