Sponsor Message:
Civil Aviation Forum
My Starred Topics | Profile | New Topic | Forum Index | Help | Search 
Dual-duty Designators - Besides DEN?  
User currently offlineAirstud From United States of America, joined Nov 2000, 2685 posts, RR: 3
Posted (7 years 1 day 4 hours ago) and read 1843 times:

Problematically, my database of Airports I've Landed At can't use the IATA designator as the primary key, because I've landed at (meaning I've been on flights that have landed at; no pilot, I) both Stapleton and Denver International; both of which of course were DENignated.

Any other triglyphs that have referred to more than one airport in their lifetimes?

I have departed from, but not landed at, RNO and YHZ. Airports aren't allowed on my list if I haven't landed there.


Pancakes are delicious.
15 replies: All unread, jump to last
 
User currently offlineYOWza From Canada, joined Jul 2005, 4900 posts, RR: 15
Reply 1, posted (7 years 1 day 2 hours ago) and read 1786 times:

BKK springs to mind. When they switched ops to Suvarnabhumi from Don Muang they moved the BKK designation.

YOWza



12A whenever possible.
User currently offlineTCFC424 From United States of America, joined Nov 2003, 517 posts, RR: 2
Reply 2, posted (7 years 1 day 2 hours ago) and read 1768 times:

AUS, it was Robert Mueller Municipal, and now is Austin-Bergstrom International.

User currently offlineAlexPorter From , joined Dec 1969, posts, RR:
Reply 3, posted (7 years 1 day 2 hours ago) and read 1754 times:

HKG is probably the most obvious example outside of the United States.

User currently onlineN1120A From United States of America, joined Dec 2003, 26601 posts, RR: 75
Reply 4, posted (7 years 1 day 2 hours ago) and read 1746 times:

MUC is a good example after the switch from Riem to Strauss.


Mangeons les French fries, mais surtout pratiquons avec fierte le French kiss
User currently offlineRivet42 From United Kingdom, joined Aug 2005, 818 posts, RR: 1
Reply 5, posted (7 years 1 day 2 hours ago) and read 1719 times:

Quoting Airstud (Thread starter):
Airports aren't allowed on my list if I haven't landed there.

... I think you need to redesign your database, then!!  Smile

Why not make this field a 4-character field, so that you can designate the previous use of a code with a suitable suffix (e.g. BKKX, HKGX, etc)...

Riv' (database designer)



I travel, therefore I am.
User currently offlineBOSSAN From United States of America, joined Aug 2004, 255 posts, RR: 0
Reply 6, posted (7 years 1 day ago) and read 1662 times:

Since the designators date back to 2-letter US National Weather Service city codes, it seems likely that the oldest designators applied to the largest airport in each city, since that's where the weather would be read and then distributed around the country by Telex. However, I don't know if airlines used them systematically in the days of the first standardized airline tickets (1936 on), pre-mag stripe.

I can't find a reference for it, but it seems likely that the LAX designator moved from Grand Central Airport in Glendale to Mines Field in Westchester some time after 1946.


User currently onlineN1120A From United States of America, joined Dec 2003, 26601 posts, RR: 75
Reply 7, posted (7 years 19 hours ago) and read 1472 times:

Quoting Rivet42 (Reply 5):

Why not make this field a 4-character field, so that you can designate the previous use of a code with a suitable suffix (e.g. BKKX, HKGX, etc)...

For non-aviation enthusiasts, 4 letter codes are difficult to comprehend.



Mangeons les French fries, mais surtout pratiquons avec fierte le French kiss
User currently offlineRivet42 From United Kingdom, joined Aug 2005, 818 posts, RR: 1
Reply 8, posted (7 years 12 hours ago) and read 1389 times:

Quoting N1120A (Reply 7):
For non-aviation enthusiasts, 4 letter codes are difficult to comprehend.

...ah, no, I didn't mean the ICAO codes, they would indeed be baffling, even to some of us enthusiasts! No, I just meant where you might have BKK twice, for example, you make the current one BKK, and the previous airport BKKX. I note that this is what www.flightmemory.com do, so that when you enter historical data you can determine which was the correct airport at the time.

Riv'



I travel, therefore I am.
User currently offlineRDUDDJI From Lesotho, joined Jun 2004, 1516 posts, RR: 3
Reply 9, posted (7 years 12 hours ago) and read 1378 times:

Quoting Rivet42 (Reply 8):
...ah, no, I didn't mean the ICAO codes, they would indeed be baffling, even to some of us enthusiasts! No, I just meant where you might have BKK twice, for example, you make the current one BKK, and the previous airport BKKX. I note that this is what www.flightmemory.com do, so that when you enter historical data you can determine which was the correct airport at the time.

...add to that the fact that the ICAO codes also changed when the IATA ones changed, i.e. KDEN (DEN) moved from Stapeton to DIA. VHHH (HKG) moved from Kai Tak to the new airport. etc. etc.



Sometimes we don't realize the good times when we're in them
User currently offlineKempa From Brazil, joined Aug 2003, 373 posts, RR: 0
Reply 10, posted (7 years 10 hours ago) and read 1324 times:

ATH designation moved from old Hellenikon to Eleftherios Venizelos.

User currently offlineScottB From United States of America, joined Jul 2000, 6793 posts, RR: 32
Reply 11, posted (7 years 6 hours ago) and read 1270 times:

Not to steal user Centrair's fire, but NGO moved from Komaki to the current Chubu Centrair International Airport.

User currently offlineAirstud From United States of America, joined Nov 2000, 2685 posts, RR: 3
Reply 12, posted (7 years 6 hours ago) and read 1259 times:

Rivy-baby:

The idea of the databasoid is that a user can enter a FAMILIAR trigraph; which of course is the IATA code. If they enter RNO, then the record pops up with "Reno-Taco International Airport" in the "Official Name" field. However, if they enter DEN, then the "Official Name" field gets highlighted and the status line (yes LINE, for this is an old-fashioned 24x80 greenscreen) says something like "DISCERNMENT NEEDED." Same if they enter "US" in the airline designator field, my db wants to know whether they mean real USAir of old, or fake USAirways of today.

No database designer I; which is probably clear to you. This puppy will be hosted on a VAXstation and implemented in DEC C.

(I like vintage things, in case you can't tell)



Pancakes are delicious.
User currently offlineRivet42 From United Kingdom, joined Aug 2005, 818 posts, RR: 1
Reply 13, posted (7 years 3 hours ago) and read 1202 times:

Quoting Airstud (Reply 12):
The idea of the databasoid is that a user can enter a FAMILIAR trigraph; which of course is the IATA code

.... what kind of user are you aiming this at? It sounds a little bit clunky for the GUI age...!  Smile Seriously, though, I think you could get a few ideas from the website I mentioned above, they've got this sorted out very well, and are proving themselves to be very popular (there was a massive thread on them a while ago).

Riv'



I travel, therefore I am.
User currently offlineAirstud From United States of America, joined Nov 2000, 2685 posts, RR: 3
Reply 14, posted (7 years 3 hours ago) and read 1188 times:

I am anti-GUI!!!

The target user is a DEChead!! Anti-GUI, pro-VAX, pro-Rainbow100 DECheads, I say!!

Really I'm just keeping the ol' VAXstation alive; plus I need something spitting out DECnet layer 3 packets so my multiprotocol Cisco router gets put through its paces.

This isn't some legitimate, professional database; if that's what you're worrying. It's just a kewl vintage way to store - and build - my personal flight memory.

Cuz and Tapicus and even other airline buffs might join the user community someday, and then of course I'll have to design an HTML interface ew yuk. But already we're too far off-topic, for this forum is about airlines.

And one of the great things about airlines is that they still find use for green-screen COBOL applimacations, and in some places even still have 1970's terminals with black alphabetical keys and bright red, blue, green, and white function keys; VT52-style.

WHICH IS EXACTLY WHAT COMPUTERS ARE SUPPOSED TO LOOK LIKE.



Pancakes are delicious.
User currently offlineTimz From United States of America, joined Sep 1999, 6871 posts, RR: 7
Reply 15, posted (7 years 2 hours ago) and read 1180 times:

Quoting BOSSAN (Reply 6):
it seems likely that the LAX designator moved from Grand Central Airport in Glendale to Mines Field in Westchester some time after 1946.

You think "LAX" existed in 1946? I don't see any mention of three-letter codes in 1946 OAGs.

I'll see if I can find which airport "LA" was.


Top Of Page
Forum Index

This topic is archived and can not be replied to any more.

Printer friendly format

Similar topics:More similar topics...
Ted To Use Dual Jetbridges In DEN posted Fri Apr 7 2006 15:22:03 by Web
Duty Free Liquids FRA-PHL-LAX posted Sun Oct 7 2007 11:36:04 by Adools
PIA-DEN Service Resumes posted Sat Oct 6 2007 08:00:46 by EXAAUADL
UA828 Diverted To DEN? posted Sat Sep 22 2007 03:25:40 by Transpac787
DEN Overtakes LAX In Busiest US Airport Rankings posted Fri Sep 14 2007 23:30:18 by Brick
Stapleton (DEN) History Help posted Sun Sep 9 2007 17:43:31 by Cross757
How Are The DEN LH Loads? posted Wed Sep 5 2007 07:44:08 by Stburke
UA Express DEN-CPR-DEN Route posted Thu Aug 30 2007 06:19:12 by IADCRJ
L1011 Tristar @ DEN Today? posted Mon Aug 27 2007 02:55:15 by USAFHummer
Any Other Airlines Using Huds Besides WN? posted Fri Aug 24 2007 05:37:36 by Amazonphil