jpatokal / openflights

Website for storing flight information, rendering paths on a zoomable world map and calculating statistics, with plenty of free airline, airport and route data.
http://openflights.org
GNU Affero General Public License v3.0
1.39k stars 390 forks source link

[Bug] Adding New AIrlines [sf#159] #159

Open jpatokal opened 9 years ago

jpatokal commented 9 years ago

*Reported by anonymous on 2013-07-02 10:13 UTC** I added a new airline today (British Caledonian) which is no longer active. I added the IATA and ICAO codes that it used when active in order to create a complete record however the database would not accept the codes as they are now in use by other airlines.

It should be possible to allow duplicate IATA/ICAO codes so long as the codes are attached to only one airline that is active, with all others being attached to inactive airlines.

jpatokal commented 9 years ago

*Commented by anonymous on 2013-12-08 06:34 UTC** Concur with this problem.

I am attempting to add Trans-Australia Airways (IATA:TN ICAO:TAA) which was also named Australian Airlines (IATA:TN) later in its life. The airline was eventually subsumed into Qantas. The problem is that I can't add either of these INACTIVE airlines due to Air Tahiti Nui now using the IATA code TN.

I also cannot add Australian Airlines as there is another inactive airline of the same name which Qantas decided to 'rebirth' for a short period. That version was Australian Airlines (IATA: AO ICAO: AUZ)

jpatokal commented 9 years ago

*Commented by anonymous on 2014-07-11 20:38 UTC** Another one: new airline Thai AirAsia X uses XJ/TAX which (the now defunct?) travel air used. So; travel air is preventing adding of thai airasia x.