anything
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email
?
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Home
Help
Search
Login
Register
AirNav Systems Forum
»
AirNav Radar
»
AirNav Radar Discussion
(Moderator:
Runway 31
) »
IATA - ICAO code translation
« previous
next »
Print
Pages: [
1
]
Author
Topic: IATA - ICAO code translation (Read 18553 times)
0 Members and 1 Guest are viewing this topic.
Pinza
Full Member
Posts: 248
IATA - ICAO code translation
«
on:
December 21, 2009, 09:29:41 PM »
Just started a project to update my database with the full routes for scheduled flights to/from Birmingham International (BHX/EGBB)
(downloaded from
http://www.birminghamairport.co.uk/showpage.aspx?id=64
)
However all Airlines and Airports are in IATA format rather than ICAO format.
ie bmibaby shows as WW rather than BMI, Monarch appears as ZB rather than MON etc (for airlines) and first entry in timetable (Aberdeen) shows as ABZ rather than EGPD etc.
Found
http://www.airlinecodes.co.uk/
to be useful resource, but any chance of ANRB being more flexible in which code to use?
(Or including a translation in the help pages?)
Was so much easier when printed timetables were readily available rather than Googling for pdf's!
Logged
RodBearden
Hero Member
Posts: 9206
Re: IATA - ICAO code translation
«
Reply #1 on:
December 22, 2009, 01:02:42 AM »
Chris
RadarBox is pretty flexible regarding Airline codes - in Database Explorer we have the Airlines table which converts IATA codes to the ICAO codes used for displaying logos. That's why I always give IATA codes where I can for ICAO codes in the logos thread.
www.airframes.org
has its Airlines page which does conversions from one to the other, and will be more up to date than any Help gages in a manual.
I know that routes are a bit of a problem - RB wants ICAO codes - so BA123 won't show, while BAW123 will, but in my experience that's not a major problem.
BTW,
www.ch-aviation.ch
is good for the latest updates to European ICAO and IATA airline codes.
Hope that helps.
Rod
«
Last Edit: December 22, 2009, 01:04:59 AM by RodBearden
»
Logged
Rod
ACW367
Guest
Re: IATA - ICAO code translation
«
Reply #2 on:
December 22, 2009, 01:26:28 AM »
Wiki also has a reasonable page here
http://en.wikipedia.org/wiki/Airline_codes-All
You can then do a CTRL-F search on the code you have to get the tie-up. If you do a conventional wiki search for the airline name, on each airlines wiki page is a box on the righthand side which gives IATA, ICAO and Callsign.
For airport codes there is a direct read across IATA-ICAO on the A-Z lists here
http://en.wikipedia.org/wiki/International_Air_Transport_Association_airport_code
PS don't forget that a lot of the timetabled flightnumbers are not used as the radio/mode S callsign. Often they will be converted into Alpha-numeric numbers, BMIBaby and FlyBE both do this amoungst others.
«
Last Edit: December 22, 2009, 01:48:38 AM by ACW367
»
Logged
ACW367
Guest
Re: IATA - ICAO code translation
«
Reply #3 on:
December 22, 2009, 02:07:11 AM »
Further help
KLM alpha-numerics here -
http://www.airliners.nl/Schiphol/klmnumcall.pdf
Logged
Pinza
Full Member
Posts: 248
Re: IATA - ICAO code translation
«
Reply #4 on:
December 22, 2009, 05:12:05 PM »
Rod and ACW367,
Many thanks! Lots of useful info in your replies and will bookmark all your suggested links.
Cheers
Chris
Logged
Chris11
Hero Member
Posts: 1052
Re: IATA - ICAO code translation
«
Reply #5 on:
October 18, 2010, 01:36:13 PM »
A year has gone by since this topic. Which is the best (ie up to date) source for a list of airline ICAOvs IATA codes?
There are some websites with a very good look up feature but I am looking for a complete list on txt or csv
Logged
RodBearden
Hero Member
Posts: 9206
Re: IATA - ICAO code translation
«
Reply #6 on:
October 18, 2010, 01:44:19 PM »
Chris
Wikipedia has airline codes listed in table form, so they can be copied and pasted into a spreadsheet. I can't vouch for their accuracy or up-to-date-ness, though.
To paste them into Excel, use Paste Special and choose the Text option.
HTH
Rod
Logged
Rod
Chris11
Hero Member
Posts: 1052
Re: IATA - ICAO code translation
«
Reply #7 on:
October 18, 2010, 01:52:32 PM »
Done that but is is very out of date :(
Logged
Chris11
Hero Member
Posts: 1052
Re: IATA - ICAO code translation
«
Reply #8 on:
October 18, 2010, 01:57:26 PM »
Found one - on the IATA site
http://www.iata.org/membership/Pages/airline_members_list.aspx?All=true
Logged
RodBearden
Hero Member
Posts: 9206
Re: IATA - ICAO code translation
«
Reply #9 on:
October 18, 2010, 02:07:14 PM »
Good find, but a tabular list of ICAO codes would be even better - I've never found one of those :-(
Rod
Logged
Rod
Chris11
Hero Member
Posts: 1052
Re: IATA - ICAO code translation
«
Reply #10 on:
October 18, 2010, 02:29:24 PM »
And the IATA is not complete :(
...and a download costs $1159
«
Last Edit: October 18, 2010, 02:33:42 PM by Chris11
»
Logged
Chris11
Hero Member
Posts: 1052
Re: IATA - ICAO code translation
«
Reply #11 on:
October 18, 2010, 03:25:22 PM »
Ok Rod - here is the best I can do without paying $1159
«
Last Edit: October 20, 2010, 10:11:40 AM by Chris11
»
Logged
RodBearden
Hero Member
Posts: 9206
Re: IATA - ICAO code translation
«
Reply #12 on:
October 18, 2010, 04:08:19 PM »
Useful list - thanks fpr that, Chris.
Rod
Logged
Rod
Chris11
Hero Member
Posts: 1052
Re: IATA - ICAO code translation
«
Reply #13 on:
October 19, 2010, 05:03:42 AM »
Added one and deleted a few and uploaded again
Logged
Chris11
Hero Member
Posts: 1052
Re: IATA - ICAO code translation
«
Reply #14 on:
October 20, 2010, 10:14:41 AM »
A slow process - I have added a number of airlines to the list and am up to about 900. There are another 400 airlines odd that I am checking as to validity (they are in hidden rows). During the checking so far I have found a large number that are defunct of renamed, etc so I assume that a fair percentage will be dropped off.
I have uploaded the spreadsheet again to the post above to save server space.
Logged
Print
Pages: [
1
]
« previous
next »
AirNav Systems Forum
»
AirNav Radar
»
AirNav Radar Discussion
(Moderator:
Runway 31
) »
IATA - ICAO code translation