Moderators: richierich, ua900, PanAm_DC10, hOMSaR

 
815253
Topic Author
Posts: 401
Joined: Mon Jun 28, 2021 2:56 am

IATA codes that are the same FAA LID code of another airport?

Thu Jul 29, 2021 4:04 pm

For example:

Hilton Head Island aiport:
FAA LID: HXD
That's the IATA code for an airport in China

Ceiba, Puerto Rico
FAA LID: RVR
That's the IATA code of Green River in Utah

Is it possible to get a list of all airports where this is the case?

The background is that this produces bugs on kiwi.com:
https://www.kiwi.com/ee/search/results/ ... /no-return
This flight is not from Green River, but from Ceiba.
 
jplatts
Posts: 6618
Joined: Sat Mar 18, 2017 6:42 pm

Re: IATA codes that are the same FAA LID code of another airport?

Thu Jul 29, 2021 4:13 pm

Henderson Executive Airport:
FAA LID: HND (IATA airport code for Tokyo Haneda)
IATA Airport Code: HSH
 
MO11
Posts: 2355
Joined: Sun Jan 08, 2017 5:07 pm

Re: IATA codes that are the same FAA LID code of another airport?

Thu Jul 29, 2021 5:04 pm

I don't think such a list exists. FAA/ICAO functions use FAA/ICAO, IATA functions use IATA codes. Except for Allegiant: you look for flight availability from Phoenix/Mesa, AZ (AZA). Once you select your city pair and date, on the next screen at the top of the page, it says IWA to [XXX] Round Trip.

Anyway, the list would be extensive.
 
815253
Topic Author
Posts: 401
Joined: Mon Jun 28, 2021 2:56 am

Re: IATA codes that are the same FAA LID code of another airport?

Thu Jul 29, 2021 5:29 pm

For the HND airport kiwi.com shows it correctly.

Wiki says "Most U.S. airports use the same three-letter location identifier for the FAA and IATA"

It should be possible to do all IATA and FAA LID codes into an excel sheet and use the VLOOKUP() function.

Is there a way to get a list of all airports with the corresponding IATA and FAA LID code?
 
classicjets
Posts: 547
Joined: Fri Jun 24, 2011 1:15 am

Re: IATA codes that are the same FAA LID code of another airport?

Fri Jul 30, 2021 12:28 am

I made such a comparison a while back but I don't think I saved the file anywhere. I used the airports.csv file as my source from the following link as my source: https://ourairports.com/data/
It has local/FAA codes in column O and IATA codes is column N. I don't think it is perfect or totally complete, but it was the best I could find at the time.
 
815253
Topic Author
Posts: 401
Joined: Mon Jun 28, 2021 2:56 am

Re: IATA codes that are the same FAA LID code of another airport?

Fri Jul 30, 2021 1:18 am

thank you!
 
N1120A
Posts: 28017
Joined: Sun Dec 14, 2003 5:40 pm

Re: IATA codes that are the same FAA LID code of another airport?

Wed Feb 23, 2022 10:26 am

CMA in the US is the extremely busy Camarillo Airport, which serves GA only. The IATA code CMA is the much smaller aerodrome in Cunnamulla, AU.
CRQ is the FAA LID for McClellan-Palomar Airport in Carlsbad, CA - CLD in the IATA world. CRQ is the IATA for Caravelas, Brazil.

Who is online

Users browsing this forum: ehaase, rjsampson, twicearound and 13 guests

Popular Searches On Airliners.net

Top Photos of Last:   24 Hours  •  48 Hours  •  7 Days  •  30 Days  •  180 Days  •  365 Days  •  All Time

Military Aircraft Every type from fighters to helicopters from air forces around the globe

Classic Airliners Props and jets from the good old days

Flight Decks Views from inside the cockpit

Aircraft Cabins Passenger cabin shots showing seat arrangements as well as cargo aircraft interior

Cargo Aircraft Pictures of great freighter aircraft

Government Aircraft Aircraft flying government officials

Helicopters Our large helicopter section. Both military and civil versions

Blimps / Airships Everything from the Goodyear blimp to the Zeppelin

Night Photos Beautiful shots taken while the sun is below the horizon

Accidents Accident, incident and crash related photos

Air to Air Photos taken by airborne photographers of airborne aircraft

Special Paint Schemes Aircraft painted in beautiful and original liveries

Airport Overviews Airport overviews from the air or ground

Tails and Winglets Tail and Winglet closeups with beautiful airline logos