Vlookup = Vheadache: Lookup returning previous row cell data

leeman

New Member
Joined
Feb 9, 2010
Messages
11
Hi guys,

I have the most unusual problem i just cant find a solution for. I have used Vlookup sucessfully for a while but today I have met my match!!.

I have a list of airport codes and I need to look up these 2 digit codes and find the relevant airport and country.

For some reason when I use the lookup function it is finding the correct lookup value but returning the column cell in the previous row.

Any ideas?
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Welcome to the board,

Could you show us the formula you are using? also could you post some sample data?
 
Upvote 0
The formula (in cell B1) is this: =VLOOKUP(A1,$D$1:$F$1041,2)

in column A I have a list of 2 letter IATA airline codes (Starting at cell A1).

9W
AA
AB
AM
DL
QF

and then in the lookp array from columns D to F I have

Column D
1A
2H
A9
AA
AB
DL
QF


Column E
Amadeus Global Travel Distribution, S.A.
Thalys International
Georgian Airways
American Airlines
Air Berlin GmbH & Co. Luftverkehrs KG
Delta Air Lines, Inc.
Qantas Airways Ltd.

and in column F I have the country

Spain
Belguim
Georgia
United States
Germany
United States
Australia


For Vlookup "AA" i would expect the "American Airlines" but it is returning "Georgian Airways", the value from the row above.
 
Upvote 0
Hi!

Enter false as a last argument for exact match

Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 249px"><COL style="WIDTH: 64px"><COL style="WIDTH: 25px"><COL style="WIDTH: 280px"><COL style="WIDTH: 99px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">9W</TD><TD>#N/A</TD><TD> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">1A</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Amadeus Global Travel Distribution, S.A.</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Spain</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">AA</TD><TD>American Airlines</TD><TD> </TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">2H</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Thalys International</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Belguim</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">AB</TD><TD>Air Berlin GmbH & Co. Luftverkehrs KG</TD><TD> </TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">A9</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Georgian Airways</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Georgia</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">AM</TD><TD>#N/A</TD><TD> </TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">AA</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">American Airlines</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">United States</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">DL</TD><TD>Delta Air Lines, Inc.</TD><TD> </TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">AB</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Air Berlin GmbH & Co. Luftverkehrs KG</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Germany</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">QF</TD><TD>Qantas Airways Ltd.</TD><TD> </TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">DL</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Delta Air Lines, Inc.</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">United States</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD> </TD><TD> </TD><TD> </TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">QF</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Qantas Airways Ltd.</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Australia</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>B1</TD><TD>=VLOOKUP(A1,$D$1:$F$7,2,FALSE)</TD></TR><TR><TD>B2</TD><TD>=VLOOKUP(A2,$D$1:$F$7,2,FALSE)</TD></TR><TR><TD>B3</TD><TD>=VLOOKUP(A3,$D$1:$F$7,2,FALSE)</TD></TR><TR><TD>B4</TD><TD>=VLOOKUP(A4,$D$1:$F$7,2,FALSE)</TD></TR><TR><TD>B5</TD><TD>=VLOOKUP(A5,$D$1:$F$7,2,FALSE)</TD></TR><TR><TD>B6</TD><TD>=VLOOKUP(A6,$D$1:$F$7,2,FALSE)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
 
Upvote 0
=VLOOKUP(A1,$D$1:$F$1041,2,FALSE) should do it.
 
Upvote 0
thanks Guys, yes this works in the small example , but in the larger spreadsheet i have the formula return the previous cell than what is expected.

Its a very weird problem. i wish i could send the attachment.

When i add the FALSE in the formula all of the vlookup reutrn cells are shown as "N/A", even though I know that there are exact matches available for all lookup values
 
Upvote 0
ok i will add the text here....

This is the list containing the lookup values:

9W
AA
AB
AC
AF
AI
AM
AS
AT
AY
AZ
BA
BD
BP
CA
CM
CO
CX
CZ
DJ
DL
EI
EK
EY
FJ
FM
FQ
GA
HA
HVN
IB
IC
IE
IT
JJ
JL
JP
JQ
KA
KE
KL
KN
KQ
LA
LH
LO
LP
LX
MF
MH
MI
MU
NH
NW
NZ
OA
OF
OS
OT
OU
PR
PX
PZ
QF
SA
SB
SK
SN
SQ
TG
TL
TN
TP
UA
UN
US
VT
XR
 
Upvote 0
And here is the array i want to lookup:

1A AGT Amadeus Global Travel Distribution, S.A. Spain
1B Abacus International Pte. Ltd. Singapore
1C EDS Information Business GmbH Switzerland
1D Radixx Solutions International, Inc. United States of America
1E Travelsky Technology Limited China
1F INFINI Travel Information, Inc. Japan
1G Galileo International LLC United States of America
1H Siren-Travel Closed Joint Stock Company Russian Federation
1I EJA Netjets Aviation, Inc. United States of America
1I NVR Nova Airlines AB Sweden
1I PZR Sky Trek International Airlines United States of America
1I Sierra Nevada Airways United States of America
1I AMB Deutsche Rettungsflugwacht Germany
1I PGT Pegasus Hava Tasimaciligi A.S. Turkey
1J Axess International Network, Inc. Japan
1K Sutra, Inc. United States of America
1K Southern Cross Distribution Systems Australia
1L Open Skies, Inc. United States of America
1M JSC Transport Automated Information Systems Russian Federation
1N Navitaire United States of America
1P WSP WorldSpan United States of America
1Q Joint-Stock Company International Technological Corp. Sirena Russian Federation
1R Hainan Phoenix Information Systems Ltd. China
1S SBG Sabre, Inc. United States of America
1T 1Time Airline South Africa
1U Polyot Sirena Russian Federation
1U ITA Software, Inc. United States of America
1V Galileo International United States of America
1W World Air Leasing United States of America
1Y Electronic Data Systems Corporation United States of America
1Z APD Sabre Pacific Australia
2A DBB Deutsche Bahn AG Germany
2B ARD ATA Aerocondor Transportes Aéreos Lda. Portugal
2C TGV SNCF France
2D AOG Aero VIP, S.A. Argentina
2D FDE Federico II Airways, S.p.A. Italy
2E Smokey Bay Air, Inc. United States of America
2F FTA Frontier Flying Service, Inc. United States of America
2F IRP Payam (IPTAS) Iran
2G MRR West Isle Air, Inc. d/b/a San Juan Airlines United States of America
2H Thalys International Belgium
2J VBW Air Burkina Burkina Faso
2K GLG Aerolineas Galapagos S.A. Aerogal Ecuador
2L OAW Helvetic Airways AG Switzerland
2L Lineas Aereas Entre Rios Sociedad Del Estado Argentina
2M MDV Moldavian Airlines Moldova, Republic of
2N UMK Aviation Transport Company Yuzmashavia Ukraine
2P GAP Air Philippines Corporation Philippines
2Q SNC Air Cargo Carriers, Inc. United States of America
2R VRR VIA Rail Canada, Inc. Canada
2S SDY Island Express United States of America
2S Satgur Air Transport Liberia
2T TUX Tulpar Air Service Kazakhstan
2T HAM Haiti Ambassador Airlines Haiti
2U GIP Air Guinee Express S.A. Guinea
2V Amtrak United States of America
2W WLC Welcome Air Luftfahert GmbH & Co. KG Austria
2Y Air Andaman Corporation Limited Thailand
2Y ULD Rental Netherlands
2Z Joint Stock Company Voronszh Aircraft Russian Federation
2Z Express Rail Link SDN BHD Malaysia
3A AFJ Kenosha Aero. Inc. d/b/a Alliance Airlines United States of America
3A Chu Kong Passanger Transport Co. Ltd. t/a Alliance Airlines Hong Kong
3B BFR Burkina Airlines Burkina Faso
3C CEA Corporate Airlines United States of America
3D DNM Denim Air Netherlands
3D APG Air People International Co. Ltd. Thailand
3E EMU East Asia Airlines Limited Macao
3F Pacific Airways, Inc. United States of America
3G AYZ Atlant-Soyuz Airlines Russian Federation
3H AIE Air Inuit Ltd/Ltee. Canada
3J WZP Zip Air, Inc. Canada
3K VTS Tatonduk Outfitters Ltd. d/b/a Everts Air United States of America
3M GFT Gulfstream International Airlines, Inc. United States of America
3N URG Air Urga Ukraine
3P TCU Inter Tropical Aviation Suriname
3P TPV Thai Pacific Airlines Business Company Ltd. Thailand
3Q CYH China Yunnan Airlines China
3R ARB Avia Air N.V. Aruba
3S Air Guyane S.P. Guyana
3S Shun Tak-China Travel Ship Mgmt. Ltd. Hong Kong
3T URN Turan Air Airline Company Azerbaijan
3U CSC Sichuan Airlines Co. Ltd. China
3U NCH Chanchangi Airlines Nigeria Limited Nigeria
3V TAY TNT Airways, S.A. Belgium
3W EMX Woodgate Executive Air Charter UK Ltd. d/b/a Euromanx United Kingdom
3W VNR Wanair French Polynesia
3X JAC Japan Air Commuter Co. Ltd. Japan
3X Premier Trans Aire, Inc. United States of America
3Y XBO Baseops International, Inc. United States of America
3Y OSA Team Ltd. d/b/a Uniways Netherlands
3Z NEC Necon Air Ltd. Nepal
4A EYE F.S. Air Service, Inc. United States of America
4A Air Kiribati Limited Kiribati
4B Olson Air Service, Inc. United States of America
4C ARE Aires, Aerovias de Integracion Regional, S.A. Colombia
4C CTP Tashkent Aircraft Production Corporation Uzbekistan
4D ASD Air Sinai Egypt
4E TNR Tanana Air Service United States of America
4F ECE Air City Germany
4G CSZ Shenzhen Airlines China
4G Advance Leasing Company United States of America
4G GZP Gazpromavia Aviation Company Limited Russian Federation
4H FLB Fly S.A. Linhas Aereas Brazil
4I KNX Knighthawk Air Express Ltd. Canada
4J NWZ Nationwide Airlines (Zambia) Ltd. Zambia
4K KBA Kenn Borek Air Ltd. Canada
4L KZR Air Astana Kazakhstan
4M LNC Líneas Aéreas Nacionales de Navegación Dominicana, S.A (LAN Dominicana) Dominican Republic
4M ASG African Star Airways (PTY) Ltd. South Africa
4N ANT Air North Charter Canada
4O KMO Ocean Airlines Comoros
4P Business Aviation Congo, Democratic Republic of
4Q Anderson Airlink (AC-Coach Ops, Inc.) United States of America
4R OEG Orient Eagle Airways Kazakhstan
4R HHI Hamburg International Luftverkehirsgesellschaft mbH Germany
4S East West Travel Trade Links Ltd. d/b/a East West Airlines India
4S HON Aero Hunduras, S.A. d/b/a Sol Air Honduras
4T BHP Belair Airlines AG Switzerland
4U GWI Germanwings GmbH Germany
4U TVJ Tavaj Transportes Aereos Regulares S/A Brazil
4V BDY Birdy Airlines S.A. Belgium
4W WAV Warbelow's Air Ventures, Inc. United States of America
4X MEC Mercury Air Cargo, Inc. d/b/a Air Mercury United States of America
4X Atlantic Express Airlines The Gambia
4Y UYA Flight Alaska Inc, d/b/a Yute Air Alaska, Inc. United States of America
4Z LNK SA Airlink d/b/a South African Airlink South Africa
5A AIP Alpine Aviation, Inc. United States of America
5A EUK Air Atlanta Europe Ltd. United Kingdom
5B EAK Euro-Asia International, JSC Kazakhstan
5C ICL Cavei Avir Lemitanim / Cargo Air Lines Israel
5C Travelair d/b/a Nature Air Costa Rica
5D SLI Aerolitoral S.A. de C.V. Mexico
5D UDD Air Company Donbass Airlines Ukraine
5E EKA Equaflight Service Congo
5F CIR Arctic Circle Air Service, Inc. United States of America
5G SSV Skyservice Airlines, Inc. Canada
5H STQ Star Air Indonesia
5J CEB CEBU Pacific Air Philippines
5K ODS State Air Company Odessa Airlines Ukraine
5L ASU Compania Boliviana de Transporte Aereo Privado Aerosur, S.A. Bolivia
5M SIB Joint Stock Company SIAT (Sibaviatrans) Russian Federation
5N AUL Aeroflot Russian Federation
5P HSK Sky Europe Airlines Hungary Hungary
5Q JFK Keenair Charter Ltd. United Kingdom
5R CTT Custom Air Transport, Inc. United States of America
5R KAJ Karthago Airlines Tunisia
5S PSV Servicios Aereos Profesionales, S.A. Dominican Republic
5T Air Norterra Inc, d/b/a Canadian North Canada
5U LDE Lineas Aereas Del Estado (LADE) Argentina
5V UKW Lviv Airlines Ukraine
5W AEU Astraeus Ltd. United Kingdom
5W ITM Itapemirim Transportes Aereos S.A. Brazil
5X UPS United Parcel Service Company (UPS) United States of America
5Y GTI Atlas Air, Inc. United States of America
5Y IOS Isles of Scilly Skybus Ltd. United Kingdom
5Z BML Bismillah Airlines Ltd. Bangladesh
6A CHP AVIACSA-Consorcio Aviaxsa, S.A. de C.V. Mexico
6B BLX Britannia Airways AB Sweden
6C CMY Cape Smythe Air United States of America
6D PAS P.T. Pelita Air Service Indonesia
6E CIP City Air Germany AG Germany
6F PFO Aerotrans Airlines Ltd. Cyprus
6G AWW Air Wales Limited United Kingdom
6H ISR Israir Airlines and Tourism Ltd. Israel
6J SNJ Skynet Asia Airways Japan
6K RIT Asian Spirit Philippines
6K INX Inter Express Hava Tasimacilik A.S. Turkey
6L AKK Aklak Air, Inc. Canada
6M MJC Majestic Air P/L Zimbabwe
6M EUP Euroair Ltd. Greece
6N NRD Nordic NR Regional AB Sweden
6N TRQ Trans Travel Airlines (TTA) Netherlands
6P Air Tracia Romania
6P ISG Clubair Sixgo S.p.A. Italy
6Q SLL Slovak Airlines, Inc. Slovakia
6R TNO Aerotransporte de Carga Union, S.A. de C.V. Mexico
6S KAT Kato Air AS Norway
6T Air Mandalay Ltd. Myanmar
6T LMT Almaty Aviation OJSC Aircompany Kazakhstan
6U UKR Air Ukraine Ukraine
6V VGA AVI Inc. d/b/a Air Vegas Inc. United States of America
6V AXY Axis Airways France
6W SOV Saratov Airlines Joint Stock Company Russian Federation
6Y LTC Latcharter Latvia
6Z PNV Panavia, S.A. Panama
6Z UKS Ukrainian Cargo Airways Ukraine
7A AFF Afric'Air Charter, S.A. Benin
7B KJC Krasnoyarsk Airlines d/b/a KRASAIR Russian Federation
7C Columbia Pacific Airlines United States of America
7C COY Coyne Airways Ltd. United Kingdom
7D UDC Utility Enterprise DonbassAero Airline Ukraine
7E AWU Aeroline GmbH Germany
7F FAB First Air Canada
7G MKA MK Airlines Limited Ghana
7G Bellair, Inc. United States of America
7H ERH ERA Aviation United States of America
7I CSV Coastal Travels Limited Tanzania, United Republic of
7J TJK State Air Company Tajikistan d/b/a Tajikair Tajikistan
7K KGL Kogalymavia Airlines JSC Russian Federation
7L CRN Empresa Aerocaribbean S.A. d/b/a Aero Caribbean Cuba
7L ERO Sun d'Or International Airlines Israel
7M TYM Tyumen Airlines Russian Federation
7N Inland Aviation Services, Inc. United States of America
7P BTV Batavia Air Indonesia
7Q TLR Tibesti Air Libya Libyan Arab Jamahiriya
7Q VZA Air Venezuela, Linea de Transporte Aereo Lta., C.A. Venezuela
7S RYA Arctic Transportation Services United States of America
7T RTM Aero Express Del Ecuador Trans AM Ecuador
7U ERG Aviaenergo Russian Federation
7V PDF Pelican Air Services CC d/b/a Pelican Air South Africa
7W Scan Con Travel ApS Denmark
7Y NYL Mid Airlines Sudan
7Z LBH Laker Airways (Bahamas) Limited. United States of America
8A BMM Atlas Blue Morocco
8B GFI Caribbean Star Airlines Limited Antigua and Barbuda
8C ATN Air Transport International LLC United States of America
8C Air Horizon S.A. C.A. Togo
8D EXV Expo Aviation (Pvt.) Limited Sri Lanka
8D Servant Air, Inc. United States of America
8D SUW Astair Russian Federation
8E BRG Bering Air, Inc. United States of America
8F FFR Fischer Air s.r.o. Czech Republic
8G NGE Angel Airlines Co., Ltd. Thailand
8H HFR Heli France France
8J KMV Komiinteravia Joint-Stock Company Russian Federation
8L Cargo Plus Aviation, Inc. United Arab Emirates
8L RHC Redhill Aviation Ltd. United Kingdom
8M UBA Myanmar Airways International Company Ltd. Myanmar
8M MXL Maxair Sweden
8N NKF Nordkalottflyg AB Sweden
8O West Coast Air Canada
8P PCO Pacific Coastal Airlines Limited Canada
8Q OHY Onur Air Tasimacilik A/S Turkey
8Q BAJ Baker Aviation, Inc. United States of America
8R TRIP Transporte Aereo Regional do Interior Paulista Ltda. Brazil
8R EDW Edelweiss Air AG Switzerland
8S SCP Scorpio Aviation Egypt
8T Air Tindi Ltd. Canada
8U AAW Afriqiyah Airways Libyan Arab Jamahiriya
8V WRT Wright Air Service, Inc. United States of America
8W BAX Global, Inc. United States of America
8Y PBU Air Burundi Burundi
8Z LER Linea Aerea de Servicio Ejecutivo Regional, C.A. Venezuela
9A Visa Airways Private Ltd. India
9B n/a Norwegian State Railways d/b/a AccesRail Inc. Canada
9C Haiti Caribbean Airlines S.A., Inc. Haiti
9C Wimbi Dira Airways Congo, The Democratic Republic of
9D CND Aero Continente Dominicana Dominican Republic
9E FLG Pinnacle Airlines, Inc. d/b/a Northwest Airlink United States of America
9F n/a Eurostar (U.K.) Limited United Kingdom
9G 9G Rail Limited United Kingdom
9H Dutch Eagle Express N.V. Netherlands
9H DEI Ecoair International Algeria
9J PSA Pacific Island Aviation, Inc. Northern Mariana Islands
9K KAP Cape Air United States of America
9L CJC Colgan Air United States of America
9M GLR Central Mountain Air Ltd. Canada
9N NSE SATENA Servicio Aereo a Territorios Nacionales Colombia
9Q PBA PB Air Company Limited Thailand
9R VAP Phuket Airlines Co. Ltd. Thailand
9S SOO Southern Air, Inc. United States of America
9T ABS Transwest Air Limited Canada
9U MLD Air Moldova Moldova, Republic of
9V ALS Atlantis Airlines Senegal
9V ROI Aviones de Oriente, C.A. (AVIOR) Venezuela
9W JAI Jet Airways (India) Private Limited India
9X Diamond International Airlines, Inc. United States of America
9X ACL Itali Airlines s.r.l. Italy
9Y KZK Air Kazakstan Kazakhstan
A0 THJ Thai Jet International Thailand
A2 CIU Cielos del Peru, S.A. Argentina
A3 AEE Aegean Airlines, S.A. Greece
A4 SWD Southern Winds, S.A. Argentina
A5 RLA Airlinair France
A6 LPV AAA Austria
A7 MPD Air Comet, S.A. Spain
A8 BGL Benin Golf Air SA Benin
A9 TGZ Georgian Airways Georgia
AA AAL American Airlines United States of America
AB BER Air Berlin GmbH & Co. Luftverkehrs KG Germany
AC ACA Air Canada Canada
AD PRZ PT. Air Paradise International Indonesia
AE MDA Mandarin Airlines Ltd. Taiwan
AF AFR Air France France
AG ABR Air Contractors (Ireland) Limited Ireland
AH DAH Air Algerie Algeria
AI AIC Air-India Limited India
AJ NIG Aero Contractors Company of Nigeria Ltd. Nigeria
AK AXM Air Asia Sen Bhd. Malaysia
AL SYX Skyway Airlines, Inc. d/b/a Midwest Connect United States of America
AL TXC Transaviaexport Cargo Airline Belarus
AM AMX Aeromexico Aerovias de Mexico S.A. de C.V. Mexico
AO AUZ Australian Airlines Ltd. Australia
AP ADH Air One Italy
AQ AAH Aloha Airlines, Inc. United States of America
AR ARG Aerolineas Argentinas Argentina
AS ASA Alaska Airlines, Inc. United States of America
AT RAM Royal Air Maroc Morocco
AU AUT Cielos del Sur S.A. d/b/a Austral Lineas Aereas S.A. Argentina
AV AVA Avianca Colombia
AW SCH Schreiner Airways B.V. Netherlands
AW DIR P.T. Dirgantara Air Services Indonesia
AX LOF Trans State Airlines, Inc. d/b/a American Connection United States of America
AY FIN Finnair Oyj Finland
AZ AZA Alitalia Italy
B2 BRU Belavia Belarus
B3 BLV Beliview Airlines Ltd. Nigeria
B4 BCF B.A.C.H. Flugbetriebs GmbH Austria
B4 BKA Bankair, Inc. United States of America
B5 East African Safari Air Express Ltd. Kenya
B6 JBU Jetblue Airways Corporation United States of America
B7 UIA UNI Airways Corporation Taiwan
B8 ERT Eritrean Airlines Eritrea
B9 IRB Iran Air Tours Co. Iran
B9 BGD Air Bangladesh (Pvt.) Limited Bangladesh
BA BAW British Airways P.L.C. United Kingdom
BB Seaborne Airlines United States of America
BC SKY Skymark Airlines Co. Ltd. Japan
BD BMA British Midland Airways Ltd. d/b/a bmi United Kingdom
BE BEE Jersey European Airways Limited d/b/a Flybe United Kingdom
BF BBD Bluebird Cargo Ltd. Iceland
BF RSR Aero-Service Colombia
BG BBC Biman Bangladesh Airlines Bangladesh
BH Hawkair Aviation Services Ltd. Canada
BI RBA Royal Brunei Airlines SDN BHD Brunei
BJ LBT Nouvelair Tunisia Tunisia
BK PDC Potomac Air, Inc. United States of America
BL PIC Pacific Airlines Co. Ltd. Vietnam
BM SIC Air Sicilia S.p.A. Italy
BM BYU Bayu Indonesia Air P.T. Indonesia
BN Forward Air International Airlines, Inc. United States of America
BN HZA Horizon Airlines Pty Ltd. Australia
BO BOU PT Bouraq Indonesia Airlines Indonesia
BP BOT Air Botswana Corporation Botswana
BQ ROM Aeromar Airlines Dominican Republic
BR EVA EVA Airways Corporation Taiwan
BS BIH British International Helicopters Ltd. United Kingdom
BT BTI Air Baltic Corporation S/A Latvia
BU BRA Braathens ASA Norway
BV BPA Blue Panorama Airlines S.p.A. Italy
BW BWA BWIA West Indies Airways Limited Trinidad and Tobago
BX CST Coast Air K.S. Norway
BY BAL Britannia Airways Limited United Kingdom
BZ KEE Keystone Air Service Canada
BZ BDA Blue Dart Aviation Ltd India
C2 ALU Air Luxor STP Sao Tome and Principe
C3 IPR Independent Carrier (ICAR) Ukraine
C4 IMX Zimex Aviation Limited Switzerland
C5 UCA Champlain Enterprises, Inc. United States of America
C6 CJA Canjet Airlines Canada
C7 RLE Rico Linhas Aereas Brazil
C8 WDY Chicago Express Airlines, Inc. United States of America
C9 RUS Cirrus Airlines Luftfahrtgesellschaft mbH Germany
CA CCA Air China International Corporation China
CB SAY Suckling Airways t/a ScotAirways United Kingdom
CC ABD Air Atlanta Icelandic Iceland
CC MCK Macair Airlines Australia
CD LLR Alliance Air India
CE NTW Nationwide Airlines (Pty) Ltd. South Africa
CF SDR City Airline AB Sweden
CG Airlines of Papua New Guinea Limited Papua New Guinea
CH BMJ Bemidji Airlines United States of America
CI CAL China Airlines Taiwan
CJ CBF China Northern Airlines China
CK CKK China Cargo Airlines Ltd. China
CL CLH Lufthansa CityLine Germany
CM CMP Compania Panamena de Aviacion, S.A. (COPA) Panama
CN Westward Airways, Inc. United States of America
CN Islands Nationair Papua New Guinea
CO COA Continental Air Lines, Inc. United States of America
CQ EXL Sunshine Express Airlines Pty. Ltd. d/b/a Sunshine Express Airline Australia
CR ABC OAG Worldwide United Kingdom
CR OAG Official Airline Guide, Inc. - Official Airline Guide, Inc. -
CR XCR Miscellaneous Auxiliary Calegory United States of America
CS CMI Continental Micronesia, Inc. Guam
CT SFB Air Sofia Bulgaria
CU CUB Cubana de Aviacion, S.A. Cuba
CV CLX Cargolux Airlines International, S.A. Luxembourg
CV CVA Air Chathams New Zealand
CW MRS Air Marshall Islands, Inc. Marshall Islands
CX CPA Cathay Pacific Airways Ltd. Hong Kong
CY CYP Cyprus Airways Ltd. Cyprus
CZ CSN China Southern Airlines China
D0 DHK DHL Air Limited United Kingdom
D2 Severstal Aircompany Ltd. Russian Federation
D3 DAO Daallo Airlines Djibouti
D4 LID Alidaunia S.R.L. Italy
D5 DAE DHL Aero Expreso, S.A. Panama
D6 ILN Inter-Aviation Services d/b/a Interair South Africa South Africa
D8 DJB Djibouti Airlines Djibouti
D9 DNV Joint stock Aviation Company Donavia Russian Federation
DB BZH Brit Air France
DC GAO Golden Air Flyg AB Sweden
DD Sky Asia Co. Ltd. Thailand
DE CFG Condor Flugdienst GmbH Germany
DF ABH Aerolineas de Baleares Aebal Spain
DF DER Deer Jet Co. Ltd. China
DG SRQ South East Asian Airlines Philippines
DH IDE Independence Air United States of America
DI BAG Dba Lufttahrtgesellschaft mbH Germany
DJ VOZ Virgin Blue Airlines PTY Ltd. Australia
DK VKG MyTravel Airways A/S Denmark
DK ELA Eastland Air Australia
DL DAL Delta Air Lines, Inc. United States of America
DM DAN Maersk Air A/S Denmark
DN Piper Aztec Inc, d/b/a Aztec Airways United States of America
DN DKN Air Deccan India
DN MPS Metropolis Noord I.B.V. Netherlands
DO RVL Air Vallee S.p.A. Italy
DP FCA First Choice Airways Limited. United Kingdom
DQ CXT Coastal Air Transport Virgin Islands, US
DR Mediterranean Air Service Tunisia
DR Air Link Pty Ltd. Australia
DS EZS Easyjet Switzerland S.A. Switzerland
DS Das Nordisk Ltd. Hong Kong
DT DTA TAAG Angola
DU HMS Hemus Air Bulgaria
DV VSV PLL Scat Aircompany Kazakhstan
DV LTF Lufttaxi Fluggesellschaft mbH Germany
DW UCR Aero-Charter Ukraine
DX DTR Danish Air Transport Denmark
DY DJU Air Djibouti Djibouti
DY NAX Norwegian Air Shuttle A.S. Norway
DZ NOE Transcaraibes Air International France
E2 GRN Edelweiss Holdings, Inc. d/b/a Rio Grande Air United States of America
E3 DMO Domodedovo Airlines Joint Stock Aircompany Russian Federation
E4 RSO Aero Asia International (Private) Ltd. Pakistan
E5 BRZ Samara Airlines Russian Federation
E7 EAF European Aviation Air Charter Limited d/b/a European Air Charter United Kingdom
E7 ESF Estafeta Carga Aerea, S.A. de C.V. Mexico
E8 ELG ALPI Eagles S.p.A. Italy
E9 CXS Boston-Maine Airways Corp. d/b/a Pan Am Clipper Connection United States of America
EA EAE European Air Express Germany
EC TWN Avialeasing Aviation Company Uzbekistan
ED ABQ Airblue Limited Pakistan
EE EAY Aero Airlines A.S. Estonia
EF FEA Far Eastern Air Transport Corp. Taiwan
EG JAA Japan Asia Airways Co. Ltd. Japan
EH AKX Air Nippon Network Co. Ltd. Japan
EH SET Sociedad Ecuatoriana de Transporles Aereos (SAETA), S.A. Colombia
EI EIN Aer Lingus Limited Ireland
EJ NEA New England Airlines United States of America
EK UAE Emirates United Arab Emirates
EL ANK Air Nippon Co. Ltd. Japan
EM CFS Empire Airlines United States of America
EM AEB Aero Benin S.A. Benin
EN DLA Air Dolomiti S.p.A. Aeree Regionali Europee Italy
EO LHN Express One International, Inc. United States of America
EO ALX Hewa Bora Airways Congo, The Democratic Republic of
EP IRC Iran Asseman Airlines Iran
EQ TAE TAME Linea Aerea del Ecuador Ecuador
ER DHL Astar Air Cargo, Inc. United States of America
ES DHX DHL International E.C. Bahrain
ET ETH Ethiopian Airlines Enterprise Ethiopia
EU EEA Ecuatoriana de Aviacion, S.A. Ecuador
EV CAA Atlantic Southeast Airlines, Inc. United States of America
EW EWG Eurowings AG Germany
EX SDO Aerolineas Santo Domingo, S.A. Dominican Republic
EY ETD Etihad Airways United Arab Emirates
EY EFL Eagle Air Ltd. Tanzania, United Republic of
EZ EIA Evergreen International Airlines, Inc. United States of America
EZ SUS Sun Air of Scandinavia A/S Denmark
F2 FLM Fly Havayolu Tasimacilik A.S. Turkey
F2 FAO Falcon Air Express, Inc. United States of America
F3 FSW Faso Airways SARL Burkina Faso
F3 SGB Sky King, Inc. d/b/a Fly First Class United States of America
F4 NBK Albarka Air Plc Nigeria
F5 COZ Cosmic Air PVT. Ltd. Nepal
F6 CAG China National Aviation Corporation (CNAC) China
F6 FCC First Cambodia Airlines Co. Ltd. Cambodia
F7 BBO Flybaboo SA Switzerland
F7 Valls Lineas Aereas Y Servicios SRL Kaiken Lineas Aereas Argentina
F8 AMO Air Montreal (Air Holdings Inc.) Canada
F8 FDM Freedom Airlines, Inc. United States of America
F9 FFT Frontier Airlines, Inc. United States of America
FA FreshAer Airlines Limited United Kingdom
FA Airline Airways Limited Ireland
FA SFR Safair (PTY) Ltd. South Africa
FB LZB Bulgaria Air Bulgaria
FC Finnish Commuter Airlines Oy Finland
FC Falcon Express Cargo Airlines United Arab Emirates
FD Thai AirAsia Co. Ltd. Thailand
FE WCP Primaris Airlines, Inc. United States of America
FF Airshop B.V. Netherlands
FG AFG Ariana Afghan Airlines Afghanistan
FH FUA Futura International Airways Spain
FI ICE Icelandair Iceland
FJ FJI Air Pacific Ltd. Fiji
FK WTA Africa West Togo
FK Keewatin Air Ltd. Canada
FL TRS AirTran Airways, Inc. United States of America
FM CSH Shanghai Airlines Co. Ltd. China
FN RGL Regional Air Lines Morocco
FO Circle Air Freight Corp. United States of America
FO ATM Airlines Of Tasmania Pty Ltd. Australia
FP FPG TAG Aviation, S.A. Switzerland
FP Aerotechnology Pty Ltd d/b/a Par-Avion Australia
FP FRE Aviation Services, Ltd. d/b/a Freedom Air Guam
FQ Brindabella Airlines PTY Ltd. Australia
FQ TCW Thomas Cook Airline Belgium
FR RYR Ryanair Ltd. Ireland
FS Mission Aviation Fellowship Australia
FS STU Servicios de Transportes Aereos Fueguinos, S.A. Argentina
FT SRH Siem Reap Airways International Cambodia
FV PLK Pulkovo Aviation Enterprise Russian Federation
FW FRI Fair, Inc. Japan
FX FDX Federal Express Corporation d/b/a FedEx United States of America
FY NWR Northwest Regional Airlines Australia
FZ Air Facilities Australia
FZ BBG Alisea Airlines S.p.A. Italy
G1 Gorkha Airlines Nepal
G2 DOB Dobrolet Airlines Russian Federation
G2 VXG Avirex Gabon
G3 CIX City Connexion Airlines Burundi
G4 AAY Allegiant Air, Inc. United States of America
G5 ENK Joint Stock Company Enkor Russian Federation
G6 BSR Guine Bissau Airlines Guinea Bissau
G7 GNF Gandalf Airlines S.p.A. Italy
G8 GUJ Gujarat Airways Limited India
G8 AGB Air Service Gabon Gabon
G9 ABY Air Arabia United Arab Emirates
G9 GLO GOL Transportes Aeros Ltda. Brazil
GA GIA Garuda Indonesia Indonesia
GB ABX Air, Inc. United States of America
GC GNR Gambia International Airlines Ltd. The Gambia
GD AHA Air Alpha Greenland A/S Greenland
GE TNA Transasia Airways Corporation Taiwan
GF GFA Gulf Air Company G.S.C. Bahrain
GG Air Comores International Comoros
GG GUY Air Guyane SP. French Guiana
GH GHA Ghana Airways Corp. Ghana
GI IKA Air Company Itek-Air Ltd. Kyrgyzstan
GJ EEZ Eurofly S.P.A. Italy
GJ MXC Mexicargo, S.A. de C.V. Mexico
GK Go One Airways United Kingdom
GL GRL Air Greenland A/S Greenland
GL BSK Miami Air International, Inc. United States of America
GM SVK Air Slovakia BWJ, Ltd. Slovakia
GN AGN Air Gabon Gabon
GO GOE Go Fly Ltd. United Kingdom
GP Palau Trans Pacific Airlines, Inc. Palau
GP GES Gestair, S.A. Spain
GQ BSY Big Sky Airlines United States of America
GR AUR Aurigny Air Services Ltd. United Kingdom
GR GCO Gemini Air Cargo LLC United States of America
GS UPA Air Foyle Limited United Kingdom
GS Grant Aviation, Inc. United States of America
GT GBL GB Airways Ltd. United Kingdom
GV ARF Aero Flight GmbH & Co Germany
GW Golden West Airlines, Inc. United States of America
GW KIL Air Lines of Kuban Russian Federation
GX JXX JetX Airlines Iceland
GX PFR Pacific Airways Corporation (Pacificair) Philippines
GY GYA Guyana Airways d/b/a Guyana Airways 2000 Inc. Guyana
GY TMG Tri-MG Intra Asia Airlines PT Indonesia
GZ Air Rarotonga Cook Islands
H2 SKU Sky Service S.A. d/b/a Sky Airline Chile
H3 Harbour Air Ltd. Canada
H4 IIN Inter Islands Airlines Cape Verde Islands
H4 HLI Heli Securite Helicopter Airlines France
H5 MVL Magadan Airlines Russian Federation
H6 HAG Hageland Aviation Services, Inc United States of America
H7 EGU Eagle Air Ltd. Uganda
H8 KHB Dalavia Russian Federation
H9 HAD Haiti Aviation S.A. d/b/a Air D'Ayiti Haiti
H9 SUL TAM Express S/A Brazil
HA HAL Hawaiian Airlines United States of America
HB HAR Harbor Airlines United States of America
HB Homer Air, Inc. United States of America
HC ATI Lip-Air Pty. Ltd. d/b/a Aero-Tropics Air Services Australia
HD ADO Hokkaido International Airlines Co., Ltd. Japan
HE LGW LGW-Luftfahrtgesellschaft Walter GmbH Germany
HF HLF Hapag Lloyd Fluggessellschaft mbH Germany
HG HRB Haiti International Airline Haiti
HG NLY flyniki / NL Luftfahrt GmbH Austria
HH ICB Islandsflug HF Iceland
HI Papillon Airways, Inc. United States of America
HJ AXF Asian Express Airlines Pty Limited Australia
HK FSC Four Star Aviation Virgin Islands, US
HK Yangon Airways Limited Myanmar
HL n/a Hotels/Motels United States of America
HM SEY Air Seychelles Limited Seychelles
HN PTH Proteus Helicopters France
HN HVY Heavylift Cargo Airlines Pty Ltd. Australia
HO DJA Antinea Airlines Algeria
HP AWE America West Airlines, Inc. United States of America
HQ HMY HMY Airways, Inc. d/b/a Harmony Airways Canada
HR HHN Hahn Air Line Germany
HS HSV Svenska Direktflyg AB Sweden
HT AHW Aeromist Ukraine
HT MOD Modiluft Limited India
HU CHH Hainan Airlines Company Limited China
HV TRA Transavia Netherlands
HV TRA Basiq Air Netherlands
HW NWL North-Wright Airways Ltd. Canada
HX Trans North Aviation Ltd. United States of America
HY UZB Uzbekistan Havo Yullary Uzbekistan
HZ SHU Sakhalinskie Aviatrassy, SAT Russian Federation
I2 Aeroturwismo y Publicidad S.A.C. Peru
I9 IBU Air-Serv, Inc d/b/a Indigo United States of America
IA IAW Iraqi Airways Iraq
IB IBE Iberia Spain
IC IAC Indian Airlines Corporation India
ID ITK Interlink Airlines (Pty) Ltd. South Africa
IE SOL Solomon Airlines Solomon Islands
IF ISW Islas Airways Spain
IG ISS Meridiana S.p.A. Italy
IH FCN Falcon Air AB Sweden
II CSQ IBC Airways, Inc. United States of America
IK ITX IMAIR Airline Azerbaijan
IL LKN Lankair Private Limited Sri Lanka
IM MNJ Menajet United Arab Emirates
IN MAK Macedonian Airlines Macedonia
IO IAA PT Indonesian Airlines Av iapatria Indonesia
IP JOL Atyrau Aue Joly Kazakhstan
IQ AUB Augsburg Airways GmbH Germany
IR IRA Iran Air Iran
IS ISA Island Airlines, Inc. United States of America
IT IRT Irtysh Avia Kazakhstan
IU Ibis Air Pty, Ltd. Australia
IV JET Wind Jet S.p.A. Italy
IX Select Air Luftverkehrsges mbH Austria
IY IYE Yemenia Yemen
IZ AIZ Arkia Israel
J2 AHY Azerbaijan Hava Yollary Azerbaijan
J3 PLR Northwestern Air Lease Ltd. Canada
J4 BFL Buffalo Airways Ltd. Canada
J5 Alaska Seaplane Service, L.L.C. United States of America
J6 AOC Joint-Stock Holding Co. Aviation Commercial Russian Federation
J6 Larry's Flying Service, Inc. United States of America
J7 CVC Centre-Avia Airlines, JSC Russian Federation
J8 BVT Berjaya Air Sdn. Bhd. Malaysia
J9 GIF Guinee Airlines, S.A. Guinea
JB JBA Helijet International, Inc. Canada
JC JEX JAL Express Japan
JF LAB L.A.B. Flying Service, Inc. United States of America
JG n/a Airline Container Leasing, Inc. United States of America
JH NES Nordeste-Linhas Aereas Regionais, S.A. Brazil
JH HLQ Harlequin Air Corporation Japan
JI Cool Tours d/b/a San Juan Aviation Puerto Rico
JJ BLC TAM Linhas Aeras Brazil
JK JKK Spanair, S.A. Spain
JL JAL Japan Airlines International Co. Ltd. Japan
JM AJM Air Jamaica Jamaica
JN XLA Excel Airways United Kingdom
JO JAZ JALWays Japan
JP ADR Adria Airways Slovenia
JQ JMX Air Jamaica Express Limited Jamaica
JQ JST Jetstar Airways Pty Limited d/b/a Impulse Airlines Australia
JR SER Aero California Mexico
JS KOR Air Koryo Korea, Democratic People's Republic of
JT Lessbrook PTY Ltd., d/b/a Transair Australia
JT LNI Lion Airlines Indonesia
JU JAT Jat Airways Serbia and Montenegro
JV BLS Bearskin Airlines Canada
JW APW Arrow Air, Inc. United States of America
JW Skippers Aviation Pty Ltd. Australia
JX Nice Helicopteres France
JY IWY Interisland Airways Limited Turks And Caicos Islands
JZ SKX Skyways Express AB Sweden
K2 ELO Eurolot, S.A. Poland
K3 Taquan Air Services, Inc. United States of America
K4 CKS Kalitta Air LLC United States of America
K4 Kronflyg Sweden
K5 WAK Wings Of Alaska United States of America
K7 TMP Arizona Express Airlines, Inc. United States of America
K8 DCE Dutch Caribbean Airline N.V. Netherlands Antilles
K9 SGK Skyward Aviation Ltd. Canada
K9 KRI Krylo Airlines Russian Federation
KA HDA Hong Kong Dragon Airlines Limited Hong Kong
KB DRK Druk Air Corporation Ltd. Bhutan
KC Trans Atlantic Airlines United States of America
KD KNI Kaliningradavia Open Joint Sotck Company Russian Federation
KE KAL Korean Air Lines Co. Ltd. Korea, Republic of
KF BLF Blue1 Oy Finland
KG Aerogaviota S.A. Cuba
KG BNX Linea Aerea I.A.A.C.A. (L.A.I.) Venezuela
KH Kyrgyz Airways Limited Kyrgyzstan
KI DHI Adam SkyConnection Airlines PT Indonesia
KJ LAJ British Mediterranean Airways Limited United Kingdom
KK OGE Atlasjet Uuslararasi Havacilik A/S Turkey
KL KLM KLM Royal Dutch Airlines (Koninklijke Luchtvaart Maatschappij N.V.) Netherlands
KM AMC Air Malta p.l.c. Malta
KN Nantay Pty Ltd., d/b/a Maroomba Airlines Australia
KO AER Alaska Central Express, Inc. United States of America
KP KIA Kiwi International Air Lines United States of America
KQ KQA Kenya Airways Kenya
KR KMZ Comores Aviation Comoros
KR KHA Kitty Hawk Aircargo, Inc. United States of America
KS PEN Penair United States of America
KU KAC Kuwait Airways Kuwait
KV MVD State United Venture Kavminvodyavia Russian Federation
KW KSD KAS Air Company Kyrgyzstan
KW KSK Kas Air Company Kazakhstan
KW Kelowna Flightcraft Air Charter Ltd. Canada
KX CAY Cayman Airways Ltd. Cayman Islands
KY EQL Linhas Aereas de Air Sao Tome And Principe Sao Tome And Principe
KZ NCA Nippon Cargo Airlines Japan
L2 LYC Lynden Air Cargo, LLC United States of America
L3 LTO LTU Billa Lufttransport Unternehmen GmbH Austria
L3 Air Ketchum, Idaho, Inc. United States of America
L3 JOS DHL de Guatemala, S.A. Guatemala
L4 LDI Lauda Air S.p.A. Italy
L5 HKS CHC Helikopter Service AS Norway
L6 VNZ Tbilaviamsheni Georgia
L7 LPN Laoag International Airlines Philippines
L8 LXG Air Luxor GB, Lda Guinea-Bissau
L9 TLW Teamline Air Luftfahrt GmbH Austria
LA LAN LAN Airlines, S.A. Chile
LB LLB Lloyd Aereo Boliviano S.A. (LAB) Bolivia
LC VLO Varig Logistica, S/A Brazil
LD TUY Linea Turistica Aereotuy Lta, C.A. Venezuela
LD AHK AHK Air Hong Kong Ltd. Hong Kong
LE Laparkan Airways, Inc. Guyana
LF NDC Nordic East Airlink AB Sweden
LG LGL Luxair Luxembourg
LH DLH Deutsche Lufthansa AG Germany
LH GEC Lufthansa Cargo AG Germany
LI LIA Leeward Islands Air Transport (1974) Ltd. (LIAT) Antigua and Barbuda
LJ SLA Sierra National Airlines Sierra Leone
LK LXR Air Luxor, S.A. Portugal
LL GRO Lineas Aereas Allegro, S.A. de C.V. Mexico
LM LVG Livingston S.p.A. Italy
LM ALM ALM 1997 Airline Inc., d/b/a Air ALM Netherlands Antilles
LN LAA Jamahirya Libyan Arab Airlines Libyan Arab Jamahiriya
LO LOT LOT Poland
LP LPE Lan Peru, S.A. Peru
LQ LAQ Lebanese Air Transport Lebanon
LQ Air Guinea Cargo, S.A. Equatorial Guinea
LR LRC Lineas Aereas Costarricenses S.A. (LACSA) Costa Rica
LS EXS Channel Express Air Services Ltd. United Kingdom
LT LTU LTU International Airways Germany
LV LBC Albanian Airlines MAK S.H.P.K. Albania
LW ANV Pacific Wings United States of America
LX SWR Swiss International Airlines Ltd. d/b/a Swiss Switzerland
LY ELY El Al Israel Airlines Ltd. Israel
LZ LAZ Balkan Bulgaria
M2 MZS Mahfooz Aviation (Gambia) Ltd. Saudi Arabia
M2 Mario's Air, Inc. United States of America
M3 TUS ABSA Brazil
M3 NFA North Flying A/S Denmark
M3 SPJ Air Service Macedonia
M4 AXX Avioimpex A.D.p.o. Macedonia
M5 Kenmore Air United States of America
M6 AJT Amerijet International, Inc. United States of America
M7 SUK Superior Aviation Services Ltd. Kenya
M7 TBG Tropical Airways D'Haiti Haiti
M8 MKN Mekong Airlines Co. Ltd. Cambodia
M9 MSI Motor-Sich, JSC Ukraine
MA MAH MALEV Hungarian Airlines Limited Hungary
MB MNB MNG Airlines Turkey
MB EXA Execaire, Inc. Canada
MC RCH Air Mobility Command (AMC) United States of America
MD MDG Air Madagascar Madagascar
ME MEA Middle East Airlines Lebanon
MF CXA Xiamen Airlines China
MG CCP Grand Holdings, Inc. d/b/a Champion Air United States of America
MH MAS Malaysia Airline System Berhad Malaysia
MI SLK SilkAir (S) Pte. Ltd. Singapore
MJ LPR Lineas Aereas Privadas Argentinas (LAPA) Argentina
MK MAU Air Mauritius Mauritius
ML Air Micronesia, Inc. Guam
ML ETC African Transport Trading And Investment Co. (ATTICO) Sudan
MM SAM Sociedad Aeronautica de Medellin Consolidada S.A. (SAM) Colombia
MM MMZ EuroAtlantic Airways, S.A. Portugal
MN CAW Comair Ltd. South Africa
MO CAV Calm Air International Ltd. Canada
MO AUH Abu Dhabi Amiri Flight United Arab Emirates
MP MPH Martinair Holland N.V. Netherlands
MR MRT Air Mauritanie Mauritania
MS MSR Egyptair Egypt
MT TCX Thomas Cook Airlines U.K. Ltd. United Kingdom
MU CES China Eastern Airlines China
MV RML Armenian International Airways Armenia
MW MYD Maya Island Air Belize
MX MXA Compania Mexicana de Aviacion S.A. de C.V. Mexico
MY MAA Aerotransportes Mas de Carga, S.A. de C.V. Mexico
MY MWA Midwest Airlines Egypt
MZ MNA PT. Merpati Nusantara Indonesia
N2 LNT Aerolineas Internacionales S.A. de C.V. Mexico
N3 OMS Omskavia Airline, Public Joint-Stock Society Russian Federation
N4 MTC Minerva Airlines Italy
N5 SGY Skagway Air Service, Inc. United States of America
N5 KYL Kyrgyz International Airlines Kyrgyzstan
N6 ACQ Nuevo Continente, S.A. Peru
N7 JEV Lagun Air, S.L. Spain
N8 SEK Salaam Express Air Srevices Kenya
N8 CRK CR Airways Limited Hong Kong
N9 NCN Niger Air Continental Niger
N9 AOH North Coast Aviation Papua New Guinea
NA NAO North American Airlines, Inc. United States of America
NB SNB Sterling European Kommanditaktieselskab Denmark
NC NJS National Jet Systems Pty. Ltd. Australia
NC NAC Northern Air Cargo, Inc. United States of America
ND Airlink Limited Papua New Guinea
NE ESK Skyeurope Airlines Slovakia
NF AVN Air Vanuatu (Operations) Limited Vanuatu
NG LDA Lauda Air Luftfahrt AG Austria
NH ANA All Nippon Airways Co. Ltd. Japan
NI PGA Portugalia Portugal
NJ Nordisk Aviation Products, Inc. United States of America
NK NKS Spirit Airlines, Inc. United States of America
NL SAI Shaheen Air International Pakistan
NM DRI Air Madrid Lineas Aereas, S.A. Spain
NM NZM The Mount Cook Group Ltd. New Zealand
NN MOV VIM Airlines Russian Federation
NO AUZ Aus-Air (Australian Air Charterers Pty Ltd.) Australia
NO NOS Neos S.p.A. Italy
NP Skytrans Australia
NQ AJX Air Japan Company Ltd. Japan
NR PIR Pamir Air Afghanistan
NS SRJ Caucasus Airlines Georgia
NT IBB Binter Canarias Spain
NU JTA Japan Transocean Air Co. Ltd. Japan
NV Nakanihon Airlines Co. Ltd, Japan
NW NWA Northwest Airlines, Inc. United States of America
NX AMU Air Macau Company Limited Macau
NY FNA Air Iceland (Flugfelag Islands) Iceland
NZ ANZ Air New Zealand Limited New Zealand
OA OAL Olympic Airlines Greece
OB ASZ Astrakhan Airlines Russian Federation
OC OAV Omni Portugal
OD Natalco Airlines Limited Congo, The Democratic Republic of
OE AOT Asia Overnight Express Corporation Philippines
OF FIF Air Finland Ltd. Finland
OF TML Transports et Travaux Aériens de Madagascar Madagascar
OH COM Comair, Inc. United States of America
OI Aspiring Air Limited New Zealand
OJ OLA Overland Airways Limited Nigeria
OK CSA Czech Airlines A.S. , CSA Czech Republic
OL OLT OLT-Ostfriesische Lufttransport Germany
OM MGL MIAT Mongolia
ON RON Air Nauru Nauru
OO SKW SkyWest Airlines United States of America
OP CHK Flying Boat Inc. d/b/a Chalk's International Airines United States of America
OQ QNA Aeronaves Queen S.A. (Queen Air) Dominican Republic
OS AUA Austrian Airlines, Osterreichische Luftverkehrs AG d/b/a/ Austrian Austria
OT PEL Aeropelican Air Services Pty Ltd. Australia
OU CTN Croatia Airlines Croatia
OV ELL Estonian Air Estonia
OW EGF Executive Airlines, Inc. United States of America
OW EXW Executive Airlines, Inc. United States of America
OX OEA Orient Thai Airlines Thailand
OY SDE Oy Soder Air Ltd. Finland
OY OAE Omni Air International, Inc. d/b/a Omni Air Express United States of America
OZ AAR Asiana Airlines, Inc. Korea, Republic of
P2 TMN Utair Aviation Joint-Stock Company Russian Federation
P2 PIT Panair S.p.A. Italy
P3 PHG Phoenix Aviation Kyrgyzstan
P4 Aero Lineas Sosa Honduras
P5 RPB Aero Republica, S.A. Colombia
P6 MUI Trans Air United States of America
P7 ESL Joint-Stock Company East Line Airlines Russian Federation
P8 PTN Pantanal Linhas Aereas Sul-Matogrossenses, S.A. Brazil
P9 NCM Nas Air, S.A. Mali
P9 PGP Perm State Air Enterprise Russian Federation
PA FCL Florida Coastal Airlines, Inc. United States of America
PB Provincial Airlines Canada
PC FAJ Air Fiji Ltd. Fiji
PC PVV Joint Stock Company Continental Airways Russian Federation
PD Palau Rock Island Air Palau
PD PEM Pemair Canada
PE AEL Air Europe S.p.A. Italy
PF PNW Palestinian Airlines Occupied Palestinian Territory
PG BKP Bangkok Airways Co. Ltd. Thailand
PH PAO Polynesian Limited Samoa
PI SUF Sun Air (Pacific) Limited. Fiji
PJ SPM Air St. Pierre St. Pierre and Miquelon
PK PIA Pakistan International Airlines Pakistan
PL ASE Airstars, Airways Company Russian Federation
PL PLI Aeroperu Peru
PL Southern Air Charters Co. Ltd. Bahamas
PM TOS Tropic Air Limited Belize
PN PAA Pan American Airways Corp. United States of America
PO PAC Polar Air Cargo, Inc. United States of America
PP PJS Jet Aviation Business Jets AG Switzerland
PQ PNF Panafrican Airways Cote D'Ivoire
PR PAL Philippine Airlines, Inc. Philippines
PS AUI Ukraine International Airlines Ukraine
PT SWN West Air Sweden AB Sweden
PT CCI Capital Cargo International Airlines, Inc. United States of America
PU PUA Pluna Lineas Aereas Urugauyas, S.A. Uruguay
PV PNR PAN AIR Lineas Aereas, S.A. Spain
PV BTH Air Saint Barthelemy Saint Barthelemy
PW PRF Precision Air Services Ltd. Tanzania, United Republic of
PX ANG Air Niugini Pty Limited d/b/a Air Niugini Papua New Guinea
PY SLM Surinam Airways Ltd. Suriname
PZ LAP TAM Paraguay
Q2 Island Aviation Services Ltd. Maldives
Q3 MBN Zambian Airways Zambia
Q4 SWX Steffen Air Charter Services d/b/a Swazi Express Airways Swaziland
Q5 MLA 40-Mile Air, Ltd. United States of America
Q6 CDP Aero-Condor, S.A. Peru
Q8 PEC Pacific East Asia Cargo Airlines, Inc. Philippines
Q8 TSG Trans Air Congo (TAC) Congo
Q9 AFU Afrinat (Gambia) International Airlines, Inc. Ghana
QA CBE Aerocaribe Mexico
QB Georgian National Airlines Georgia
QC CRD Air Corridor Mozambique
QD QCL Air Class Lineas Aereas (Aerovip Ltda) Uruguay
QE ECC ECA (Europe Continental Airways) d/b/a/ Crossair Europe Switzerland
QF QFA Qantas Airways Ltd. Australia
QH LYN Altyn Air Airlines Kyrgyzsatn
QI CIM Cimber Air A/S Denmark
QJ Jet Airways, Inc. United States of America
QJ LTP LATPASS Airlines Latvia
QK JZA Air Canada Jazz Canada
QL RNL Aero Lanka (Pvt) Ltd. Sri Lanka
QM AML Air Malawi Limited Malawi
QN Air Armenia Armenia
QO MPX Aeromexpress S.A. de C.V. Mexico
QO OGN Origin Pacific Airways Limited New Zealand
QP Airkenya Aviation Ltd. d/b/a Regional Air Kenya
QQ QQA Alliance Airlines PTY Limited Australia
QR QTR Qatar Airways (W.L.L.) Qatar
QS TVS Travel Service A.S. Czech Republic
QT TPA Transportes Aereos Mercantiles Panamericanos S.A., (TAMPA) Colombia
QT Regional Air PTY Ltd. Papua New Guinea
QU UGX East Afrian Airlines Limited Uganda
QV LAO Lao Airlines Lao People's Democratic Republic
QW TCI Turks & Caicos Airways Turks and Caicos Islands
QW BWG Blue Wings AG Germany
QX QXE Horizon Air United States of America
QY BCS European Air Transport Belgium
R2 ORB State Unitary Avia Enterprise d/b/a Orenburg Airlines Russian Federation
R4 SDM State Transport Company of Russia Russian Federation
R5 MAC Malta Air Charter Company Limited Malta
R6 SBK Air Srpska Bosnia Hercegovina
R7 OCA Aserea Airlines, C.A. Venezuela
R8 KGA Kyrghyzstan Airlines / National Airline Kyrgyzstan
R9 CAM Village Aviation Inc. d/b/a Camai Air United States of America
RA RNA Royal Nepal Airlines Corporation Nepal
RB SYR Syrian Arab Airlines Syrian Arab Republic
RC FLI Atlantic Airways Faroe Islands Faroe Islands
RE REA Cornharbairl Gaillimh Teo d/b/a Aer Arann Ireland
RF FWL Florida West International Airways, Inc. United States of America
RF Ord Air Charter Ply. Ltd. Australia
RG VRG Varig S.A. (Viacao Aerea Rio-Grandense) Brazil
RH RPH PT. Republic Express Airlines Indonesia
RI MDL Mandala Airlines Indonesia
RJ RJA Royal Jordanian (Alia Jordan
RK RKH Royal Khymer Airlines Cambodia
RL Air Charter, Inc. Puerto Rico
RL PPW Royal Phnom Penh Airways Cambodia
RM Regional Air Ltd Kenya
RN EUH Air Horizons France
RN ERL Euralair International France
RN Sum Air Services, Inc. United States of America
RO ROT TAROM Romania
RP CHQ Chautauqua Airlines, Inc. d/b/a USAir Express United States of America
RQ KMR Kam Air Afghanistan
RR RFR Royal Air Force United Kingdom
RS ICT Intercontinental colombia Colombia
RS ORF Royal Flight of Oman Oman
RT LRT Airlines of South Australia Australia
RU SKI TCI Skyking Ltd. United States of America
RV CPN Caspian Airlines Service Company Ltd. Iran
RV AFI Redair Limited The Gambia
RX AEH Aviaexpress Plc. Hungary
RY EXC European Executive Express Sweden
RZ LRS Servicios Aereos Nacionales S.A. SANSA Costa Rica
S2 SHD Sahara Airlines Limited India
S3 BBR Santa Barbara Airlines, C.A. Venezuela
S4 RZO SATA International Servicos e Transportes Aereos, S.A. Portugal
S5 TCF Shuttle America United States of America
S6 Mountain Bird, Inc. d/b/a Salmon Air United States of America
S7 SBI Siberia Airlines Russian Federation
S8 SWW Shovkoviy Shlyah Ltd. Airlines Ukraine
S8 CAH Chari Aviation Services South Africa
SA SAA South African Airways South Africa
SB ACI Air Caledonie International New Caledonia
SC CDG Shandong Airlines China
SD SUD Sudan Airways Co. Ltd. Sudan
SE SEU STAR Airlines France
SE Samoa Aviation, Inc. American Samoa
SF DTH Tassili Airlines Algeria
SG JGO Jetsgo Corporation Canada
SG SSR P.T. Sempati Air Indonesia
SH FLY FlyMe Sweden AB Sweden
SI SIH Skynet Airlines Limited Ireland
SJ FOM South Pacific Air Charters Ltd. t/a Freedom Air International New Zealand
SJ VND Aviandina S.A.C. Peru
SK SAS Scandinavian Airlines System (SAS) Sweden
SL RSL Rio Sul Linhas Aereos, S.A. Brazil
SM SRL Swedline Express AB Sweden
SN SAB SN Brussels Airlines Belgium
SO HKA Superior Aviation, Inc. United States of America
SP SAT SATA Portugal
SQ SIA Singapore Airlines Limited Singapore
SS CRL Corse Air International France
ST GMI Germania Fluggesellschaft mbH Germany
SU AFL Aeroflot Russian Airlines Russian Federation
SV SVA Saudi Arabian Airlines Saudi Arabia
SW NMB Air Namibia Namibia
SX AJO Aeroejecutivo S.A. de C.V. Mexico
SY SCX Sun Country Airlines United States of America
SZ Air Nepal International Pvt. Ltd. Nepal
T1 Sysops, Inc. United States of America
T2 TCG Thai Air Cargo Co., Ltd. Thailand
T2 Nakina Outpost Camp & Air Service Ltd. d/b/a Nakina Air Service Canada
T3 EZE Eastern Airways Limited United Kingdom
T4 HEJ Hellas Jet S.A. Greece
T4 TRL Transeast Airlines Ltd. Latvia
T5 TUA Turkmenistan Airlines Turkmenistan
T6 TVR Tavrey Aircompany Ukraine
T7 SRT Aircompany Trans Asian Airlines Kazakhstan
T7 TJT Twin Jet France
T8 NQN Transportes Aereos Neuquen Sociedad Anonima Argentina
T8 STA Mali
T9 TRZ Prime Air, Inc. d/b/a Transmeridian Airlines United States of America
TA TAI TACA International Airlines, S.A. El Salvador
TB TUB TUI Airlines Belgium Belgium
TC ATC Air Tanzania Company Ltd. Tanzania, United Republic of
TD LUR Atlantis European Airways Armenia
TD TLP Tulip Air B.V. Netherlands
TE LIL Lithuanian Airlines Lithuania
TF SCW Malmo Aviation AB Sweden
TF Tasman Australia Airlines Australia
TG THA Thai Airways International Public Company Ltd. Thailand
TH TSE Transmile Air Services Sdn. Bhd. Malaysia
TH BRT British Airways CitiExpress Limited United Kingdom
TI TOL Tol Air Services, Inc. Puerto Rico
TJ ELV Transportes Aereos Nacionales de Selva (TANS) Peru
TK THY Turkish Airlines, Inc. Turkey
TL TMA Trans Mediterranean Airways (TMA) Lebanon
TL ANO Airnorth Regional Australia
TM LAM LAM Mozambique
TN THT Air Tahiti Nui French Polynesia
TO PSD President Airlines Cambodia
TP TAP TAP Portugal
TQ TDM Tandem Aero Ltd. Moldova, Republic of
TR TGW Tiger Airways Singapore
TS TSC Air Transat Canada
TT KLA Air Lithuania Lithuania
TU TAR Tunisair Tunisia
TV VEX Virgin Express Belgium
TX FWI Air Caraibes Gaudeloupe
TY TPC Air Caledonie New Caledonia
TY IWD Iberworld Airlines Spain
TZ AMT ATA Airlines, Inc. d/b/a ATA United States of America
U2 UFS UFS, Inc. United States of America
U2 EZY Easyjet Airline Company Limited United Kingdom
U3 AIA Avies Estonia
U4 PMT Progress Multitrade Co. Ltd. Cambodia
U5 IBZ International Business Air Sweden
U5 GWY Brendan Airways, LLC d/b/a USA 3000 United States of America
U6 SVR Ural Airlines Russian Federation
U7 NKA Northern Dene Airways Ltd. Canada
U8 RNV Armavia Armenia
U9 KAZ Tatarstan JSC Aircompany Russian Federation
UA UAL United Airlines, Inc. United States of America
UB UBA Myanmar Airways Myanmar
UC LCO Ladeco S.A. d/b/a LANExpress Chile
UD HER Hex'Air France
UE Air Euroamerica S.A. (Uair) Uruguay
UE TEP Transeuropean Airlines Russian Federation
UF UKM Ukrainian Mediterranean Airlines Ltd. Ukraine
UG TUI Tuninter, S.A. Tunisia
UH EUS Eurasia Aircompany, JSC Russian Federation
UI ECA Eurocypria Airlines Ltd. Cyprus
UJ Montair Aviation, Inc. Canada
UL ALK SriLankan Airlines Limited Sri Lanka
UM AZW Air Zimbabwe (PVT) Ltd. Zimbabwe
UN TSO Transaero Airlines Russian Federation
UQ OCM O'Connor Airlines Australia
US USA US Airways, Inc. United States of America
US PDT Piedmont Airlines, Inc. d/b/a USAir Express United States of America
US ALO Allegheny Commuter Airlines, Inc. d/b/a USAirways Express United States of America
UT ORT Air Orient France
UU REU Air Austral Reunion Island
UV UVA Universal Airways, Inc. United States of America
UV HSE Helicopteros del Sureste, S.A. Spain
UW UVG Universal Airlines, Inc. Guyana
UX AEA Air Europa Lineas Aereas, S.A. Spain
UY UYC Cameroon Airlines Cameroon
UZ BRQ Buraq Air Transport (BRQ) Libyan Arab Jamahiriya
UZ TIS Aviation Enterprise TESIS Limited Russian Federation
V2 AKT Karat Joint Stock Company Russian Federation
V3 KRP Carpatair, S.A. Romania
V4 Vensecar Internacional, C.A. Venezuela
V5 RYL Royal Aruban Airlines N.V. Aruba
V7 SNG Air Senegal International Senegal
V8 VAS ATRAN-Aviatrans Cargo Airlines Russian Federation
V8 TPS Transportes Aereos Petroleros S.A. / TAPSA Argentina
V8 IAR Iliamna Air Taxi, Inc. United States of America
V9 BTC Bashkir Airlines (BAL) Russian Federation
VA VLE Volare Airlines S.p.A. Italy
VC SVV Servicios Avensa S.A. (SERVIVENSA) Venezuela
VD BBB Swedjet Airways AB Sweden
VE AVE Aerovias Venezolanas, S.A. (AVENSA) Venezuela
VE EUJ EU Jet Ireland
VF VLU Valuair Ltd. Singapore
VG VLM Vlaamse Luchtvaart Maatschappij wings of flanders Belgium
VH LAV Aeropostal Alas de Venezuela, C.A. Venezuela
VI VDA Volga-Dnepr Airline Joint Stock Russian Federation
VJ JTY Jatayu Gelang Sejahtera Indonesia
VK Val Air, Inc. Canada
VL VIM Air VIA Bulgarian Airways Bulgaria
VL International Express Air Charter Ltd. n/a Regency Express Flight Operations Canada
VM VOA Viaggio Air Bulgaria
VN HVN Vietnam Airlines Corporation Vietnam
VO TYR Tyrolean Airways Tiroler Luftfahrt GmbH Austria
VP VSP Viacao Aerea Sao Paulo, S.A. (VASP) Brazil
VQ Vintage Props & Jets, Inc. United States of America
VR TCV Transportes Aereos de Cabo Verde (TACV) Cape Verde Islands
VS VIR Virgin Atlantic Airways Limited United Kingdom
VT VTA Air Tahiti French Polynesia
VU VUN Société Nouvelle Air Ivoire Cote D'Ivoire
VV AEW Aerosvit Airlines Ukraine
VW TAO Transportes Aeromar, S.A. de C.V. Mexico
VX VBA V BIRD Airlines Netherlands B.V. Netherlands
VY VLG Vueling Airlines S.A. Spain
VZ LIZ MyTravel Lite United Kingdom
VZ MYT MyTravel Airways United Kingdom
W2 Canadian Western Airlines Canada
W3 Flyhy Cargo Airlines Ltd Thailand
W4 BES Aero Services Executive S.A.R.L. France
W4 MN Aviation, Inc. Puerto Rico
W5 IRM Mahan Airlines Iran
W6 WIL West Isle Air, Inc. United States of America
W6 WZZ Wizz Air Ltd. Hungary
W7 SAH Sayakhat Airlines Kazakhstan
W8 CJT Cargojet Airways Ltd. Canada
W8 KFA Kelowna Flightcraft International Air Cargo Ltd. d/b/a Winnport Air Cargo Canada
W9 Sky Service Bvba United Kingdom
W9 SGR Eastwind Airlines, Inc. United States of America
WA KLC KLM Cityhopper B.V. (KLM Commuter) Netherlands
WB SAN Servicios Aereos Naccionales (SAN), S.A. Ecuador
WB RWD Rwandair Express Rwanda
WC ISV Islena de Inversiones S.A. de C.V. d/b/a Islena Airlines Honduras
WD DAZ Dairo air Service Ltd. Kenya
WE CWC Centurion Air Cargo, Inc. United States of America
WF WIF Wideroe's Flyveselskap A/S Norway
WG WSG Wasaya Airways L.P. Canada
WH CNW China Northwest Airlines China
WJ LAL Labrador Airways Limited Canada
WK AFB American Falcon, S.A. Argentina
WL APP Aerolineas Pacifico Atlantico, S.A. (Apair) Panama
WM WIA Windward Islands Airways Netherlands Antilles
WN SWA Southwest Airlines Co. United States of America
WO WOA World Airways, Inc. United States of America
WP PRI Hawaii Island Air. Inc d/b/a Island Air United States of America
WQ RMV Romanian Aviation Company ROMAVIA R.A. Romania
WR HRH Royal Tongan Airlines Tonga
WS WJA Westjet Canada
WT NGA Nigeria Airways Ltd. Nigeria
WU TKC Tikal Jets, S.A. Guatemala
WV SWV Swe Fly AB Sweden
WW BMI bmibaby Limited United Kingdom
WX BCY Cityjet Ireland
WY OAS Oman Aviation Services Co. (SAOG) Oman
WZ WSF West African Airlines Benin
WZ RRM Acvila Air Romania
X3 HLX Hapag-Lloyd Express GmbH Germany
X4 Vanair Limited Vanuata
X5 Afrique Airlines, S.A. Benin
X5 FBN Afrique Airlines Limited Benin
X7 Air Service Gabon
X8 Icaro S.A. Ecuador
X9 KHO Khors Aircompany Ltd. Ukraine
XA XAA ARINC (Aeronautical Radio, Inc.) United States of America
XB IAT International Air Transport Association Canada
XC KDC K.D. Air Corporation Canada
XD XXD OAG Worldwide. United States of America
XD ATA Air Transport Association of America (ATA) United States of America
XE ALT SBS Aircraft Kazakhstan
XF VLK Vladivostok Air JSC Russian Federation
XG KLB Air Mali International Mali
XH XXH Special Ground Handling Service United States of America
XI XXI Aeronautical Telecommunications Ltd. (AEROTEL) Jamaica
XJ MES Mesaba Aviation, Inc. United States of America
XK CCM CCM Airlines France
XL Lan Ecuador Ecuador
XM SMX Alitalia Express Italy
XM XME Australian Air Express Pty. Ltd. Australia
XO LTE LTE International Airways Spain
XO CXJ China Xinjiang Airlines China
XP CXP T.E.M. Enterprises Inc. d/b/a Casino Express United States of America
XQ SXS SunExpress Turkey
XR SkyWest Airlines Pty. Ltd. Australia
XS SIT SITA Belgium
XT AXL Air Exel Netherlands B.V. Netherlands
XU AXK African Express Airways (K) Ltd. Kenya
XV IVW Ivoire Airways Cote D'Ivoire
XW ORX Orbit Express Airlines Hava Yollair A.s. (Orex) Turkey
XY Air Nigeria Nigeria
Y3 Driessen Services, Inc. United States of America
Y4 EQA Eagle Aviation Ltd. Kenya
Y6 KHM Cambodia Airlines Co. Ltd. Cambodia
Y7 TNB Trans Air Benin Benin
Y8 YZR Yangtze River Express Airlines Co. Ltd. China
Y8 SYL Sayany Airlines Russian Federation
Y9 IRK Kish Air Iran
YA Yeti Airlines (P) Ltd. Nepal
YB EXY South African Express Airways (Pty) Ltd. South Africa
YC Caverton Helicopters Ltd. Nigeria
YD GOM State Enterprise Gomelavia Belarus
YE Yanda Airlines Australia
YG OTL South Airlines Ukraine
YH WCW West Caribbean Airways, S.A. Colombia
YI RSI Air Sunshine, Inc. United States of America
YK KYV Kibris Turk Hava Yollari Turkey
YL LLM Yamal Airlines Russian Federation
YM MGX Montenegro Airlines Yugoslavia
YN CRQ Air Creebec (1994), Inc. Canada
YO MCM Heli Air Monaco Monaco
YQ SCO Helikopterservice AB, Euro Air Sweden
YR EGJ Eagle Canyon Airlines, Inc. United States of America
YS RAE Régional Compagnie Aérienne Européenne France
YT TGA Air Togo S.A. Togo
YU ADM Aerolineas Dominicanas S.A. d/b/a Dominair Dominican Republic
YV ASH Mesa Airlines, Inc. United States of America
YW ANS Air Nostrum L.A.M.S.A. Spain
YX MEP Midwest Airlines, Inc. United States of America
YZ TACA Ecuador, S.A. Ecuador
YZ HXL ATR Leasing VI B.V. (Holland Exel) Netherlands
Z2 STY Styrian Airways GmbH Austria
Z3 Promech, Inc. United States of America
Z4 BZW Zircon Airways Benin, S.A. Benin
Z4 OOM Zoom Airlines, Inc. Canada
Z5 GMG Airlines Ltd. Bangladesh
Z6 UDN Dnieproavia Ukraine
Z7 ADK Aviation Development Company Plc Nigeria
Z8 MTZ Mali Airways S.A. Mali
Z9 RZL Aero Zambia Zambia
ZB MON Monarch Airlines United Kingdom
ZC RSN Royal Swazi National Airways Corp. Swaziland
ZE LCD Lineas Aereas Azteca, S.A. de C.V. Mexico
ZE AZE Cosmos Air Luftfahrtunternehmen GmbH Germany
ZF HHA Atlantic Airlines de Honduras, S de R.L. Honduras
ZG AEJ Air Express Limited Tanzania, United Republic of
ZI AAF Aigle Azur France
ZJ ARC Air Routing International Corp. United States of America
ZK GLA Great Lakes Aviation Ltd. United States of America
ZL HZL Hazelton Airlines d/b/a Regional Express Australia
ZN BUB Air Bourbon Reunion Island
ZO GRP Ozark Air Lines, Inc. d/b/a/ Great Plains Airlines United States of America
ZP STT Air St. Thomas Virgin Islands, US
ZP AZQ Silk Way Airlines Azerbaijan
ZQ Caribbean Sun Airlines, Inc. United States of America
ZR AZS Aviacon Zitotrans Air Company JSC Russian Federation
ZS AZI AZZURRA Air S.p.A. Italy
ZT TZT Air Zambezi Zimbabwe
ZT VRN Voronezhavia Russian Federation
ZU HCY Helios Airways Ltd. Cyprus
ZV AMW Air Midwest, Inc. United States of America
ZW AWI Air Wisconsin Airlines Corporation (AWAC) United States of America
ZX GGN Air Georgian Ltd. d/b/a Air Alliance Canada
ZY ADE Ada Air Albania
 
Upvote 0
Try with index/match like in B1

=INDEX($D$1:$D$7,MATCH(A1,$C$1:$C$7,0))
 
Upvote 0
When i use the following function in cell B1:

=VLOOKUP(A1,'IATA Airline Designator'!A2:D1251,3)

The return value is " Aviones de Oriente, C.A. (AVIOR) "

It should be " Jet Airways (India) Private Limited "

if i use the formula =VLOOKUP(A1,'IATA Airline Designator'!A2:D1251,3,FALSE)

the return value is: "N/A'

both these results are incorrect
 
Upvote 0

Forum statistics

Threads
1,223,937
Messages
6,175,511
Members
452,650
Latest member
Tinfish

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top