Added IATA codes for US airports in the Kxxx range missing them

[mborsetti]

Programmatically tested all ICAO codes starting with "K" (US mainland) against an IATA database of 9088 Location Codes obtained from https://www.iata.org/en/publications/directories/code-search and found 679 instances where the cities matched. Added the IATA code to those 679 instances.

As a result of doing so programmatically, json file has lost trailing zeros after the decimal point, increasing the number of diffs beyond 679 but not affecting precision of data.

database: KAVX city: Avalon                 IATA: AVX city: Avalon
database: KBAM city: Battle Mountain        IATA: BAM city: Battle Mountain
database: KBDG city: Blanding               IATA: BDG city: Blanding
database: KBJJ city: Wooster                IATA: BJJ city: Wooster
database: KBLM city: Belmar/Farmingdale     IATA: BLM city: Belmar/Farmingdale
database: KBTP city: Butler                 IATA: BTP city: Butler
database: KBYG city: Buffalo                IATA: BYG city: Buffalo
database: KBYH city: Blytheville            IATA: BYH city: Blytheville
database: KCEA city: Wichita                IATA: CEA city: Wichita
database: KCEU city: Clemson                IATA: CEU city: Clemson
database: KCEV city: Connersville           IATA: CEV city: Connersville
database: KCEW city: Crestview              IATA: CEW city: Crestview
database: KCEY city: Murray                 IATA: CEY city: Murray
database: KCFD city: Bryan                  IATA: CFD city: Bryan
database: KCFT city: Clifton/Morenci        IATA: CFT city: Clifton/Morenci
database: KCFV city: Coffeyville            IATA: CFV city: Coffeyville
database: KCGE city: Cambridge              IATA: CGE city: Cambridge
database: KCGF city: Cleveland              IATA: CGF city: Cleveland
database: KCGS city: College Park           IATA: CGS city: College Park
database: KCGZ city: Casa Grande            IATA: CGZ city: Casa Grande
database: KCHK city: Chickasha              IATA: CHK city: Chickasha
database: KCIC city: Chico                  IATA: CIC city: Chico
database: KCIN city: Carroll                IATA: CIN city: Carroll
database: KCIR city: Cairo                  IATA: CIR city: Cairo
database: KCKA city: Cherokee               IATA: CKA city: Cherokee
database: KCKM city: Clarksdale             IATA: CKM city: Clarksdale
database: KCKN city: Crookston              IATA: CKN city: Crookston
database: KCKV city: Clarksville            IATA: CKV city: Clarksville
database: KCLI city: Clintonville           IATA: CLI city: Clintonville
database: KCLK city: Clinton                IATA: CLK city: Clinton
database: KCLR city: Calipatria             IATA: CLR city: Calipatria
database: KCLS city: Chehalis               IATA: CLS city: Chehalis
database: KCMY city: Sparta                 IATA: CMY city: Sparta
database: KCNH city: Claremont              IATA: CNH city: Claremont
database: KCNK city: Concordia              IATA: CNK city: Concordia
database: KCNO city: Chino                  IATA: CNO city: Chino
database: KCNU city: Chanute                IATA: CNU city: Chanute
database: KCNW city: Waco                   IATA: CNW city: Waco
database: KCNY city: Moab                   IATA: CNY city: Moab
database: KCOE city: Coeur d'Alene          IATA: COE city: Coeur d'Alene
database: KCOF city: Cocoa Beach            IATA: COF city: Cocoa Beach
database: KCOI city: Merritt Island         IATA: COI city: Merritt Island
database: KCOM city: Coleman                IATA: COM city: Coleman
database: KCON city: Concord                IATA: CON city: Concord
database: KCOT city: Cotulla                IATA: COT city: Cotulla
database: KCPM city: Compton                IATA: CPM city: Compton
database: KCRG city: Jacksonville           IATA: CRG city: Jacksonville
database: KCRS city: Corsicana              IATA: CRS city: Corsicana
database: KCRT city: Crossett               IATA: CRT city: Crossett
database: KCRX city: Corinth                IATA: CRX city: Corinth
database: KCSM city: Clinton                IATA: CSM city: Clinton
database: KCSQ city: Creston                IATA: CSQ city: Creston
database: KCSV city: Crossville             IATA: CSV city: Crossville
database: KCTB city: Cut Bank               IATA: CTB city: Cut Bank
database: KCTK city: Canton                 IATA: CTK city: Canton
database: KCTY city: Cross City             IATA: CTY city: Cross City
database: KCTZ city: Clinton                IATA: CTZ city: Clinton
database: KCUB city: Columbia               IATA: CUB city: Columbia
database: KCUH city: Cushing                IATA: CUH city: Cushing
database: KCVS city: Clovis                 IATA: CVS city: Clovis
database: KCWI city: Clinton                IATA: CWI city: Clinton
database: KCXL city: Calexico               IATA: CXL city: Calexico
database: KCXO city: Houston                IATA: CXO city: Houston
database: KCZT city: Carrizo Springs        IATA: CZT city: Carrizo Springs
database: KDKK city: Dunkirk                IATA: DKK city: Dunkirk
database: KDLF city: Del Rio                IATA: DLF city: Del Rio
database: KDLN city: Dillon                 IATA: DLN city: Dillon
database: KDLS city: The Dalles             IATA: DLS city: The Dalles
database: KDMA city: Tucson                 IATA: DMA city: Tucson
database: KDMN city: Deming                 IATA: DMN city: Deming
database: KDMO city: Sedalia                IATA: DMO city: Sedalia
database: KDNN city: Dalton                 IATA: DNN city: Dalton
database: KDNS city: Denison                IATA: DNS city: Denison
database: KDNV city: Danville               IATA: DNV city: Danville
database: KDOV city: Dover                  IATA: DOV city: Dover
database: KDRA city: Mercury                IATA: DRA city: Mercury
database: KEAN city: Wheatland              IATA: EAN city: Wheatland
database: KECS city: Newcastle              IATA: ECS city: Newcastle
database: KEDE city: Edenton                IATA: EDE city: Edenton
database: KEDW city: Edwards                IATA: EDW city: Edwards
database: KEED city: Needles                IATA: EED city: Needles
database: KEFD city: Houston                IATA: EFD city: Houston
database: KEFW city: Jefferson              IATA: EFW city: Jefferson
database: KEGI city: Crestview              IATA: EGI city: Crestview
database: KEGV city: Eagle River            IATA: EGV city: Eagle River
database: KEKN city: Elkins                 IATA: EKN city: Elkins
database: KEKX city: Elizabethtown          IATA: EKX city: Elizabethtown
database: KELA city: Eagle Lake             IATA: ELA city: Eagle Lake
database: KELK city: Elk City               IATA: ELK city: Elk City
database: KELN city: Ellensburg             IATA: ELN city: Ellensburg
database: KELY city: Ely                    IATA: ELY city: Ely
database: KELZ city: Wellsville             IATA: ELZ city: Wellsville
database: KEMM city: Kemmerer               IATA: EMM city: Kemmerer
database: KEMP city: Emporia                IATA: EMP city: Emporia
database: KEMT city: El Monte               IATA: EMT city: El Monte
database: KENL city: Centralia              IATA: ENL city: Centralia
database: KENV city: Wendover               IATA: ENV city: Wendover
database: KENW city: Kenosha                IATA: ENW city: Kenosha
database: KEOK city: Keokuk                 IATA: EOK city: Keokuk
database: KEOS city: Neosho                 IATA: EOS city: Neosho
database: KEPH city: Ephrata                IATA: EPH city: Ephrata
database: KERR city: Errol                  IATA: ERR city: Errol
database: KERV city: Kerrville              IATA: ERV city: Kerrville
database: KESC city: Escanaba               IATA: ESC city: Escanaba
database: KESF city: Alexandria             IATA: ESF city: Alexandria
database: KESN city: Easton                 IATA: ESN city: Easton
database: KEST city: Estherville            IATA: EST city: Estherville
database: KESW city: Easton                 IATA: ESW city: Easton
database: KETB city: West Bend              IATA: ETB city: West Bend
database: KETN city: Eastland               IATA: ETN city: Eastland
database: KEUF city: Eufaula                IATA: EUF city: Eufaula
database: KEVM city: Eveleth                IATA: EVM city: Eveleth
database: KFAF city: Fort Eustis            IATA: FAF city: Fort Eustis
database: KFAM city: Farmington             IATA: FAM city: Farmington
database: KFBL city: Faribault              IATA: FBL city: Faribault
database: KFBR city: Fort Bridger           IATA: FBR city: Fort Bridger
database: KFBY city: Fairbury               IATA: FBY city: Fairbury
database: KFCH city: Fresno                 IATA: FCH city: Fresno
database: KFCY city: Forrest City           IATA: FCY city: Forrest City
database: KFDK city: Frederick              IATA: FDK city: Frederick
database: KFDR city: Frederick              IATA: FDR city: Frederick
database: KFDY city: Findlay                IATA: FDY city: Findlay
database: KFEP city: Freeport               IATA: FEP city: Freeport
database: KFET city: Fremont                IATA: FET city: Fremont
database: KFFA city: Kill Devil Hills       IATA: FFA city: Kill Devil Hills
database: KFFL city: Fairfield              IATA: FFL city: Fairfield
database: KFFM city: Fergus Falls           IATA: FFM city: Fergus Falls
database: KFFO city: Dayton                 IATA: FFO city: Dayton
database: KFFT city: Frankfort              IATA: FFT city: Frankfort
database: KFKL city: Franklin               IATA: FKL city: Franklin
database: KFKN city: Franklin               IATA: FKN city: Franklin
database: KFLD city: Fond du Lac            IATA: FLD city: Fond du Lac
database: KFLP city: Flippin                IATA: FLP city: Flippin
database: KFLV city: Fort Leavenworth       IATA: FLV city: Fort Leavenworth
database: KFLX city: Fallon                 IATA: FLX city: Fallon
database: KFMH city: Falmouth               IATA: FMH city: Falmouth
database: KFMN city: Farmington             IATA: FMN city: Farmington
database: KFMY city: Fort Myers             IATA: FMY city: Fort Myers
database: KFNL city: Fort Collins/Loveland  IATA: FNL city: Fort Collins/Loveland
database: KFOK city: Westhampton Beach      IATA: FOK city: Westhampton Beach
database: KFRG city: Farmingdale            IATA: FRG city: Farmingdale
database: KFRR city: Front Royal            IATA: FRR city: Front Royal
database: KFSK city: Fort Scott             IATA: FSK city: Fort Scott
database: KFST city: Fort Stockton          IATA: FST city: Fort Stockton
database: KFSU city: Fort Sumner            IATA: FSU city: Fort Sumner
database: KFTK city: Fort Knox              IATA: FTK city: Fort Knox
database: KFTY city: Atlanta                IATA: FTY city: Atlanta
database: KFXE city: Fort Lauderdale        IATA: FXE city: Fort Lauderdale
database: KFXY city: Forest City            IATA: FXY city: Forest City
database: KFYM city: Fayetteville           IATA: FYM city: Fayetteville
database: KGAD city: Gadsden                IATA: GAD city: Gadsden
database: KGAI city: Gaithersburg           IATA: GAI city: Gaithersburg
database: KGBG city: Galesburg              IATA: GBG city: Galesburg
database: KGBR city: Great Barrington       IATA: GBR city: Great Barrington
database: KGCY city: Greeneville            IATA: GCY city: Greeneville
database: KGDM city: Gardner                IATA: GDM city: Gardner
database: KGDW city: Gladwin                IATA: GDW city: Gladwin
database: KGED city: Georgetown             IATA: GED city: Georgetown
database: KGEY city: Greybull               IATA: GEY city: Greybull
database: KGFL city: Glens Falls            IATA: GFL city: Glens Falls
database: KGGE city: Georgetown             IATA: GGE city: Georgetown
database: KGHM city: Centerville            IATA: GHM city: Centerville
database: KGIF city: Winter Haven           IATA: GIF city: Winter Haven
database: KGKT city: Sevierville            IATA: GKT city: Sevierville
database: KGLD city: Goodland               IATA: GLD city: Goodland
database: KGLE city: Gainesville            IATA: GLE city: Gainesville
database: KGLR city: Gaylord                IATA: GLR city: Gaylord
database: KGLW city: Glasgow                IATA: GLW city: Glasgow
database: KGNG city: Gooding                IATA: GNG city: Gooding
database: KGNT city: Grants                 IATA: GNT city: Grants
database: KGOK city: Guthrie                IATA: GOK city: Guthrie
database: KGPZ city: Grand Rapids           IATA: GPZ city: Grand Rapids
database: KGQQ city: Galion                 IATA: GQQ city: Galion
database: KGRD city: Greenwood              IATA: GRD city: Greenwood
database: KGRE city: Greenville             IATA: GRE city: Greenville
database: KGRN city: Gordon                 IATA: GRN city: Gordon
database: KGSB city: Goldsboro              IATA: GSB city: Goldsboro
database: KGSH city: Goshen                 IATA: GSH city: Goshen
database: KGTG city: Grantsburg             IATA: GTG city: Grantsburg
database: KGUS city: Peru                   IATA: GUS city: Peru
database: KGUY city: Guymon                 IATA: GUY city: Guymon
database: KGVL city: Gainesville            IATA: GVL city: Gainesville
database: KGWO city: Greenwood              IATA: GWO city: Greenwood
database: KGWS city: Glenwood Springs       IATA: GWS city: Glenwood Springs
database: KGXY city: Greeley                IATA: GXY city: Greeley
database: KGYR city: Goodyear               IATA: GYR city: Goodyear
database: KHAB city: Hamilton               IATA: HAB city: Hamilton
database: KHAF city: Half Moon Bay          IATA: HAF city: Half Moon Bay
database: KHAI city: Three Rivers           IATA: HAI city: Three Rivers
database: KHAO city: Hamilton               IATA: HAO city: Hamilton
database: KHBR city: Hobart                 IATA: HBR city: Hobart
database: KHDE city: Holdrege               IATA: HDE city: Holdrege
database: KHEZ city: Natchez                IATA: HEZ city: Natchez
database: KHFD city: Hartford               IATA: HFD city: Hartford
database: KHFF city: Camp Mackall           IATA: HFF city: Camp Mackall
database: KHHR city: Hawthorne              IATA: HHR city: Hawthorne
database: KHIE city: Whitefield             IATA: HIE city: Whitefield
database: KHIF city: Ogden                  IATA: HIF city: Ogden
database: KHII city: Lake Havasu City       IATA: HII city: Lake Havasu City
database: KHIO city: Portland               IATA: HIO city: Portland
database: KHKA city: Blytheville            IATA: HKA city: Blytheville
database: KHKS city: Jackson                IATA: HKS city: Jackson
database: KHLB city: Batesville             IATA: HLB city: Batesville
database: KHLC city: Hill City              IATA: HLC city: Hill City
database: KHLG city: Wheeling               IATA: HLG city: Wheeling
database: KHLM city: Holland                IATA: HLM city: Holland
database: KHMN city: Alamogordo             IATA: HMN city: Alamogordo
database: KHMT city: Hemet                  IATA: HMT city: Hemet
database: KHNB city: Huntingburg            IATA: HNB city: Huntingburg
database: KHOB city: Hobbs                  IATA: HOB city: Hobbs
database: KHPT city: Hampton                IATA: HPT city: Hampton
database: KHPY city: Baytown                IATA: HPY city: Baytown
database: KHSB city: Harrisburg             IATA: HSB city: Harrisburg
database: KHSI city: Hastings               IATA: HSI city: Hastings
database: KHSP city: Hot Springs            IATA: HSP city: Hot Springs
database: KHST city: Homestead              IATA: HST city: Homestead
database: KHTH city: Hawthorne              IATA: HTH city: Hawthorne
database: KHTL city: Houghton Lake          IATA: HTL city: Houghton Lake
database: KHTO city: East Hampton           IATA: HTO city: East Hampton
database: KHUL city: Houlton                IATA: HUL city: Houlton
database: KHUM city: Houma                  IATA: HUM city: Houma
database: KHUT city: Hutchinson             IATA: HUT city: Hutchinson
database: KHVE city: Hanksville             IATA: HVE city: Hanksville
database: KHVS city: Hartsville             IATA: HVS city: Hartsville
database: KHWD city: Hayward                IATA: HWD city: Hayward
database: KHWO city: Hollywood              IATA: HWO city: Hollywood
database: KHYR city: Hayward                IATA: HYR city: Hayward
database: KHZL city: Hazleton               IATA: HZL city: Hazleton
database: KICL city: Clarinda               IATA: ICL city: Clarinda
database: KIDG city: Ida Grove              IATA: IDG city: Ida Grove
database: KIDI city: Indiana                IATA: IDI city: Indiana
database: KIDP city: Independence           IATA: IDP city: Independence
database: KIFA city: Iowa Falls             IATA: IFA city: Iowa Falls
database: KIJX city: Jacksonville           IATA: IJX city: Jacksonville
database: KIKK city: Kankakee               IATA: IKK city: Kankakee
database: KILN city: Wilmington             IATA: ILN city: Wilmington
database: KIML city: Imperial               IATA: IML city: Imperial
database: KIMM city: Immokalee              IATA: IMM city: Immokalee
database: KINK city: Wink                   IATA: INK city: Wink
database: KINS city: Indian Springs         IATA: INS city: Indian Springs
database: KINW city: Winslow                IATA: INW city: Winslow
database: KIOW city: Iowa City              IATA: IOW city: Iowa City
database: KIRS city: Sturgis                IATA: IRS city: Sturgis
database: KISM city: Orlando                IATA: ISM city: Orlando
database: KISO city: Kinston                IATA: ISO city: Kinston
database: KISQ city: Manistique             IATA: ISQ city: Manistique
database: KISW city: Wisconsin Rapids       IATA: ISW city: Wisconsin Rapids
database: KIWD city: Ironwood               IATA: IWD city: Ironwood
database: KIWS city: Houston                IATA: IWS city: Houston
database: KJAS city: Jasper                 IATA: JAS city: Jasper
database: KJCT city: Junction               IATA: JCT city: Junction
database: KJDN city: Jordan                 IATA: JDN city: Jordan
database: KJEF city: Jefferson City         IATA: JEF city: Jefferson City
database: KJHW city: Jamestown              IATA: JHW city: Jamestown
database: KJOT city: Joliet                 IATA: JOT city: Joliet
database: KJVL city: Janesville             IATA: JVL city: Janesville
database: KJXN city: Jackson                IATA: JXN city: Jackson
database: KKIC city: King City              IATA: KIC city: King City
database: KKLS city: Kelso                  IATA: KLS city: Kelso
database: KKNB city: Kanab                  IATA: KNB city: Kanab
database: KLAA city: Lamar                  IATA: LAA city: Lamar
database: KLAL city: Lakeland               IATA: LAL city: Lakeland
database: KLAM city: Los Alamos             IATA: LAM city: Los Alamos
database: KLBT city: Lumberton              IATA: LBT city: Lumberton
database: KLCI city: Laconia                IATA: LCI city: Laconia
database: KLCK city: Columbus               IATA: LCK city: Columbus
database: KLCQ city: Lake City              IATA: LCQ city: Lake City
database: KLDJ city: Linden                 IATA: LDJ city: Linden
database: KLDM city: Ludington              IATA: LDM city: Ludington
database: KLEE city: Leesburg               IATA: LEE city: Leesburg
database: KLEM city: Lemmon                 IATA: LEM city: Lemmon
database: KLFI city: Hampton                IATA: LFI city: Hampton
database: KLFK city: Lufkin                 IATA: LFK city: Lufkin
database: KLGD city: La Grande              IATA: LGD city: La Grande
database: KLGU city: Logan                  IATA: LGU city: Logan
database: KLHV city: Lock Haven             IATA: LHV city: Lock Haven
database: KLIC city: Limon                  IATA: LIC city: Limon
database: KLKP city: Lake Placid            IATA: LKP city: Lake Placid
database: KLKV city: Lakeview               IATA: LKV city: Lakeview
database: KLMS city: Louisville             IATA: LMS city: Louisville
database: KLNA city: West Palm Beach        IATA: LNA city: West Palm Beach
database: KLND city: Lander                 IATA: LND city: Lander
database: KLNN city: Willoughby             IATA: LNN city: Willoughby
database: KLNP city: Wise                   IATA: LNP city: Wise
database: KLNR city: Lone Rock              IATA: LNR city: Lone Rock
database: KLOL city: Lovelock               IATA: LOL city: Lovelock
database: KLOU city: Louisville             IATA: LOU city: Louisville
database: KLPC city: Lompoc                 IATA: LPC city: Lompoc
database: KLQK city: Pickens                IATA: LQK city: Pickens
database: KLRF city: Jacksonville           IATA: LRF city: Jacksonville
database: KLRJ city: Le Mars                IATA: LRJ city: Le Mars
database: KLSB city: Lordsburg              IATA: LSB city: Lordsburg
database: KLSK city: Lusk                   IATA: LSK city: Lusk
database: KLSN city: Los Banos              IATA: LSN city: Los Banos
database: KLSV city: Las Vegas              IATA: LSV city: Las Vegas
database: KLTS city: Altus                  IATA: LTS city: Altus
database: KLVK city: Livermore              IATA: LVK city: Livermore
database: KLVL city: Lawrenceville          IATA: LVL city: Lawrenceville
database: KLVM city: Livingston             IATA: LVM city: Livingston
database: KLVS city: Las Vegas              IATA: LVS city: Las Vegas
database: KLWC city: Lawrence               IATA: LWC city: Lawrence
database: KLWL city: Wells                  IATA: LWL city: Wells
database: KLWM city: Lawrence               IATA: LWM city: Lawrence
database: KLWV city: Lawrenceville          IATA: LWV city: Lawrenceville
database: KLXN city: Lexington              IATA: LXN city: Lexington
database: KLXV city: Leadville              IATA: LXV city: Leadville
database: KLYO city: Lyons                  IATA: LYO city: Lyons
database: KLZU city: Lawrenceville          IATA: LZU city: Lawrenceville
database: KMAC city: Macon                  IATA: MAC city: Macon
database: KMAE city: Madera                 IATA: MAE city: Madera
database: KMAW city: Malden                 IATA: MAW city: Malden
database: KMBG city: Mobridge               IATA: MBG city: Mobridge
database: KMBL city: Manistee               IATA: MBL city: Manistee
database: KMBY city: Moberly                IATA: MBY city: Moberly
database: KMCC city: Sacramento             IATA: MCC city: Sacramento
database: KMCD city: Mackinac Island        IATA: MCD city: Mackinac Island
database: KMCF city: Tampa                  IATA: MCF city: Tampa
database: KMDD city: Midland                IATA: MDD city: Midland
database: KMEV city: Minden                 IATA: MEV city: Minden
database: KMFD city: Mansfield              IATA: MFD city: Mansfield
database: KMFI city: Marshfield             IATA: MFI city: Marshfield
database: KMFV city: Melfa                  IATA: MFV city: Melfa
database: KMGC city: Michigan City          IATA: MGC city: Michigan City
database: KMGE city: Marietta               IATA: MGE city: Marietta
database: KMGJ city: Montgomery             IATA: MGJ city: Montgomery
database: KMGR city: Moultrie               IATA: MGR city: Moultrie
database: KMGY city: Dayton                 IATA: MGY city: Dayton
database: KMHE city: Mitchell               IATA: MHE city: Mitchell
database: KMHL city: Marshall               IATA: MHL city: Marshall
database: KMHR city: Sacramento             IATA: MHR city: Sacramento
database: KMIB city: Minot                  IATA: MIB city: Minot
database: KMIO city: Miami                  IATA: MIO city: Miami
database: KMIT city: Shafter                IATA: MIT city: Shafter
database: KMIV city: Millville              IATA: MIV city: Millville
database: KMIW city: Marshalltown           IATA: MIW city: Marshalltown
database: KMJQ city: Jackson                IATA: MJQ city: Jackson
database: KMJX city: Toms River             IATA: MJX city: Toms River
database: KMKO city: Muskogee               IATA: MKO city: Muskogee
database: KMKT city: Mankato                IATA: MKT city: Mankato
database: KMLD city: Malad City             IATA: MLD city: Malad City
database: KMLF city: Milford                IATA: MLF city: Milford
database: KMLJ city: Milledgeville          IATA: MLJ city: Milledgeville
database: KMLT city: Millinocket            IATA: MLT city: Millinocket
database: KMMI city: Athens                 IATA: MMI city: Athens
database: KMML city: Marshall               IATA: MML city: Marshall
database: KMMS city: Marks                  IATA: MMS city: Marks
database: KMNM city: Menominee              IATA: MNM city: Menominee
database: KMNN city: Marion                 IATA: MNN city: Marion
database: KMOP city: Mount Pleasant         IATA: MOP city: Mount Pleasant
database: KMOR city: Morristown             IATA: MOR city: Morristown
database: KMOX city: Morris                 IATA: MOX city: Morris
database: KMPJ city: Morrilton              IATA: MPJ city: Morrilton
database: KMPO city: Mount Pocono           IATA: MPO city: Mount Pocono
database: KMPZ city: Mount Pleasant         IATA: MPZ city: Mount Pleasant
database: KMQB city: Macomb                 IATA: MQB city: Macomb
database: KMQY city: Smyrna                 IATA: MQY city: Smyrna
database: KMRB city: Martinsburg            IATA: MRB city: Martinsburg
database: KMRF city: Marfa                  IATA: MRF city: Marfa
database: KMRN city: Morganton              IATA: MRN city: Morganton
database: KMSV city: Monticello             IATA: MSV city: Monticello
database: KMTC city: Mount Clemens          IATA: MTC city: Mount Clemens
database: KMTH city: Marathon               IATA: MTH city: Marathon
database: KMTN city: Baltimore              IATA: MTN city: Baltimore
database: KMTO city: Mattoon/Charleston     IATA: MTO city: Mattoon/Charleston
database: KMTP city: Montauk                IATA: MTP city: Montauk
database: KMUL city: Moultrie               IATA: MUL city: Moultrie
database: KMUO city: Mountain Home          IATA: MUO city: Mountain Home
database: KMUT city: Muscatine              IATA: MUT city: Muscatine
database: KMVC city: Monroeville            IATA: MVC city: Monroeville
database: KMVE city: Montevideo             IATA: MVE city: Montevideo
database: KMVN city: Mount Vernon           IATA: MVN city: Mount Vernon
database: KMWA city: Marion                 IATA: MWA city: Marion
database: KMWC city: Milwaukee              IATA: MWC city: Milwaukee
database: KMWH city: Moses Lake             IATA: MWH city: Moses Lake
database: KMWL city: Mineral Wells          IATA: MWL city: Mineral Wells
database: KMWM city: Windom                 IATA: MWM city: Windom
database: KMWO city: Middletown             IATA: MWO city: Middletown
database: KMXA city: Manila                 IATA: MXA city: Manila
database: KMXF city: Montgomery             IATA: MXF city: Montgomery
database: KMXO city: Monticello             IATA: MXO city: Monticello
database: KMYF city: San Diego              IATA: MYF city: San Diego
database: KMYV city: Marysville             IATA: MYV city: Marysville
database: KMZJ city: Marana                 IATA: MZJ city: Marana
database: KMZZ city: Marion                 IATA: MZZ city: Marion
database: KNBG city: New Orleans            IATA: NBG city: New Orleans
database: KNEN city: Jacksonville           IATA: NEN city: Jacksonville
database: KNEW city: New Orleans            IATA: NEW city: New Orleans
database: KNFL city: Fallon                 IATA: NFL city: Fallon
database: KNGP city: Corpus Christi         IATA: NGP city: Corpus Christi
database: KNGU city: Norfolk                IATA: NGU city: Norfolk
database: KNGW city: Corpus Christi         IATA: NGW city: Corpus Christi
database: KNHK city: Patuxent River         IATA: NHK city: Patuxent River
database: KNIP city: Jacksonville           IATA: NIP city: Jacksonville
database: KNKX city: San Diego              IATA: NKX city: San Diego
database: KNLC city: Lemoore                IATA: NLC city: Lemoore
database: KNPA city: Pensacola              IATA: NPA city: Pensacola
database: KNQA city: Millington             IATA: NQA city: Millington
database: KNQI city: Kingsville             IATA: NQI city: Kingsville
database: KNQX city: Key West               IATA: NQX city: Key West
database: KNRB city: Mayport                IATA: NRB city: Mayport
database: KNRS city: Imperial Beach         IATA: NRS city: Imperial Beach
database: KNSE city: Milton                 IATA: NSE city: Milton
database: KNTU city: Virginia Beach         IATA: NTU city: Virginia Beach
database: KNUN city: Pensacola              IATA: NUN city: Pensacola
database: KNUQ city: Mountain View          IATA: NUQ city: Mountain View
database: KNUW city: Oak Harbor             IATA: NUW city: Oak Harbor
database: KNVD city: Nevada                 IATA: NVD city: Nevada
database: KNYG city: Quantico               IATA: NYG city: Quantico
database: KNZY city: San Diego              IATA: NZY city: San Diego
database: KOBE city: Okeechobee             IATA: OBE city: Okeechobee
database: KOCF city: Ocala                  IATA: OCF city: Ocala
database: KOCH city: Nacogdoches            IATA: OCH city: Nacogdoches
database: KOCW city: Washington             IATA: OCW city: Washington
database: KOEO city: Osceola                IATA: OEO city: Osceola
database: KOFF city: Omaha                  IATA: OFF city: Omaha
database: KOFK city: Norfolk                IATA: OFK city: Norfolk
database: KOGA city: Ogallala               IATA: OGA city: Ogallala
database: KOGB city: Orangeburg             IATA: OGB city: Orangeburg
database: KOGD city: Ogden                  IATA: OGD city: Ogden
database: KOIC city: Norwich                IATA: OIC city: Norwich
database: KOKK city: Kokomo                 IATA: OKK city: Kokomo
database: KOKM city: Okmulgee               IATA: OKM city: Okmulgee
database: KOKS city: Oshkosh                IATA: OKS city: Oshkosh
database: KOLE city: Olean                  IATA: OLE city: Olean
database: KOLF city: Wolf Point             IATA: OLF city: Wolf Point
database: KOLS city: Nogales                IATA: OLS city: Nogales
database: KOLU city: Columbus               IATA: OLU city: Columbus
database: KOLV city: Olive Branch           IATA: OLV city: Olive Branch
database: KOMK city: Omak                   IATA: OMK city: Omak
database: KONA city: Winona                 IATA: ONA city: Winona
database: KONL city: O'Neill                IATA: ONL city: O'Neill
database: KONM city: Socorro                IATA: ONM city: Socorro
database: KONO city: Ontario                IATA: ONO city: Ontario
database: KONP city: Newport                IATA: ONP city: Newport
database: KONY city: Olney                  IATA: ONY city: Olney
database: KOOA city: Oskaloosa              IATA: OOA city: Oskaloosa
database: KOPF city: Miami                  IATA: OPF city: Miami
database: KOPL city: Opelousas              IATA: OPL city: Opelousas
database: KORL city: Orlando                IATA: ORL city: Orlando
database: KOSC city: Oscoda                 IATA: OSC city: Oscoda
database: KOSU city: Columbus               IATA: OSU city: Columbus
database: KOSX city: Kosciusko              IATA: OSX city: Kosciusko
database: KOTG city: Worthington            IATA: OTG city: Worthington
database: KOUN city: Norman                 IATA: OUN city: Norman
database: KOVE city: Oroville               IATA: OVE city: Oroville
database: KOWA city: Owatonna               IATA: OWA city: Owatonna
database: KOWD city: Norwood                IATA: OWD city: Norwood
database: KOWK city: Norridgewock           IATA: OWK city: Norridgewock
database: KOXC city: Oxford                 IATA: OXC city: Oxford
database: KOXD city: Oxford                 IATA: OXD city: Oxford
database: KOZA city: Ozona                  IATA: OZA city: Ozona
database: KOZR city: Fort Rucker/Ozark      IATA: OZR city: Fort Rucker/Ozark
database: KPAM city: Panama City            IATA: PAM city: Panama City
database: KPAO city: Palo Alto              IATA: PAO city: Palo Alto
database: KPBF city: Pine Bluff             IATA: PBF city: Pine Bluff
database: KPDT city: Pendleton              IATA: PDT city: Pendleton
database: KPEQ city: Pecos                  IATA: PEQ city: Pecos
database: KPGD city: Punta Gorda            IATA: PGD city: Punta Gorda
database: KPGR city: Paragould              IATA: PGR city: Paragould
database: KPHD city: New Philadelphia       IATA: PHD city: New Philadelphia
database: KPHK city: Pahokee                IATA: PHK city: Pahokee
database: KPHN city: Port Huron             IATA: PHN city: Port Huron
database: KPHP city: Philip                 IATA: PHP city: Philip
database: KPHT city: Paris                  IATA: PHT city: Paris
database: KPIM city: Pine Mountain          IATA: PIM city: Pine Mountain
database: KPKD city: Park Rapids            IATA: PKD city: Park Rapids
database: KPKF city: Park Falls             IATA: PKF city: Park Falls
database: KPLR city: Pell City              IATA: PLR city: Pell City
database: KPMB city: Pembina                IATA: PMB city: Pembina
database: KPMH city: Portsmouth             IATA: PMH city: Portsmouth
database: KPNC city: Ponca City             IATA: PNC city: Ponca City
database: KPNE city: Philadelphia           IATA: PNE city: Philadelphia
database: KPNN city: Princeton              IATA: PNN city: Princeton
database: KPOC city: La Verne               IATA: POC city: La Verne
database: KPOE city: Fort Polk              IATA: POE city: Fort Polk
database: KPOF city: Poplar Bluff           IATA: POF city: Poplar Bluff
database: KPOH city: Pocahontas             IATA: POH city: Pocahontas
database: KPPA city: Pampa                  IATA: PPA city: Pampa
database: KPPF city: Parsons                IATA: PPF city: Parsons
database: KPRB city: Paso Robles            IATA: PRB city: Paso Robles
database: KPRO city: Perry                  IATA: PRO city: Perry
database: KPRX city: Paris                  IATA: PRX city: Paris
database: KPSB city: Philipsburg            IATA: PSB city: Philipsburg
database: KPSF city: Pittsfield             IATA: PSF city: Pittsfield
database: KPSK city: Dublin                 IATA: PSK city: Dublin
database: KPSN city: Palestine              IATA: PSN city: Palestine
database: KPSX city: Palacios               IATA: PSX city: Palacios
database: KPTB city: Petersburg             IATA: PTB city: Petersburg
database: KPTN city: Patterson              IATA: PTN city: Patterson
database: KPTS city: Pittsburg              IATA: PTS city: Pittsburg
database: KPTT city: Pratt                  IATA: PTT city: Pratt
database: KPTV city: Porterville            IATA: PTV city: Porterville
database: KPTW city: Pottstown              IATA: PTW city: Pottstown
database: KPUC city: Price                  IATA: PUC city: Price
database: KPVC city: Provincetown           IATA: PVC city: Provincetown
database: KPVF city: Placerville            IATA: PVF city: Placerville
database: KPVU city: Provo                  IATA: PVU city: Provo
database: KPVW city: Plainview              IATA: PVW city: Plainview
database: KPWA city: Oklahoma City          IATA: PWA city: Oklahoma City
database: KPWD city: Plentywood             IATA: PWD city: Plentywood
database: KPYM city: Plymouth               IATA: PYM city: Plymouth
database: KRAC city: Racine                 IATA: RAC city: Racine
database: KRAL city: Riverside              IATA: RAL city: Riverside
database: KRBD city: Dallas                 IATA: RBD city: Dallas
database: KRBG city: Roseburg               IATA: RBG city: Roseburg
database: KRBL city: Red Bluff              IATA: RBL city: Red Bluff
database: KRBW city: Walterboro             IATA: RBW city: Walterboro
database: KRCA city: Rapid City             IATA: RCA city: Rapid City
database: KRCK city: Rockdale               IATA: RCK city: Rockdale
database: KRCR city: Rochester              IATA: RCR city: Rochester
database: KRDR city: Grand Forks            IATA: RDR city: Grand Forks
database: KREO city: Rome                   IATA: REO city: Rome
database: KRFG city: Refugio                IATA: RFG city: Refugio
database: KRHV city: San Jose               IATA: RHV city: San Jose
database: KRID city: Richmond               IATA: RID city: Richmond
database: KRIF city: Richfield              IATA: RIF city: Richfield
database: KRIL city: Rifle                  IATA: RIL city: Rifle
database: KRIV city: Riverside              IATA: RIV city: Riverside
database: KRIW city: Riverton               IATA: RIW city: Riverton
database: KRKP city: Rockport               IATA: RKP city: Rockport
database: KRKR city: Poteau                 IATA: RKR city: Poteau
database: KRKW city: Rockwood               IATA: RKW city: Rockwood
database: KRLD city: Richland               IATA: RLD city: Richland
database: KRME city: Rome                   IATA: RME city: Rome
database: KRMG city: Rome                   IATA: RMG city: Rome
database: KRNH city: New Richmond           IATA: RNH city: New Richmond
database: KRNT city: Renton                 IATA: RNT city: Renton
database: KROG city: Rogers                 IATA: ROG city: Rogers
database: KROX city: Roseau                 IATA: ROX city: Roseau
database: KRPX city: Roundup                IATA: RPX city: Roundup
database: KRRL city: Merrill                IATA: RRL city: Merrill
database: KRRT city: Warroad                IATA: RRT city: Warroad
database: KRSL city: Russell                IATA: RSL city: Russell
database: KRSN city: Ruston                 IATA: RSN city: Ruston
database: KRTN city: Raton                  IATA: RTN city: Raton
database: KRVS city: Tulsa                  IATA: RVS city: Tulsa
database: KRWF city: Redwood Falls          IATA: RWF city: Redwood Falls
database: KRWL city: Rawlins                IATA: RWL city: Rawlins
database: KRZZ city: Roanoke Rapids         IATA: RZZ city: Roanoke Rapids
database: KSAA city: Saratoga               IATA: SAA city: Saratoga
database: KSAC city: Sacramento             IATA: SAC city: Sacramento
database: KSAD city: Safford                IATA: SAD city: Safford
database: KSAR city: Sparta                 IATA: SAR city: Sparta
database: KSBD city: San Bernardino         IATA: SBD city: San Bernardino
database: KSBM city: Sheboygan              IATA: SBM city: Sheboygan
database: KSBS city: Steamboat Springs      IATA: SBS city: Steamboat Springs
database: KSBX city: Shelby                 IATA: SBX city: Shelby
database: KSCB city: Scribner               IATA: SCB city: Scribner
database: KSCH city: Schenectady            IATA: SCH city: Schenectady
database: KSDM city: San Diego              IATA: SDM city: San Diego
database: KSEF city: Sebring                IATA: SEF city: Sebring
database: KSEG city: Selinsgrove            IATA: SEG city: Selinsgrove
database: KSEM city: Selma                  IATA: SEM city: Selma
database: KSEP city: Stephenville           IATA: SEP city: Stephenville
database: KSER city: Seymour                IATA: SER city: Seymour
database: KSFF city: Spokane                IATA: SFF city: Spokane
database: KSFM city: Sanford                IATA: SFM city: Sanford
database: KSFZ city: Pawtucket              IATA: SFZ city: Pawtucket
database: KSGH city: Springfield            IATA: SGH city: Springfield
database: KSGR city: Houston                IATA: SGR city: Houston
database: KSGT city: Stuttgart              IATA: SGT city: Stuttgart
database: KSHN city: Shelton                IATA: SHN city: Shelton
database: KSIK city: Sikeston               IATA: SIK city: Sikeston
database: KSIV city: Sullivan               IATA: SIV city: Sullivan
database: KSJN city: St Johns               IATA: SJN city: St Johns
database: KSKA city: Spokane                IATA: SKA city: Spokane
database: KSKF city: San Antonio            IATA: SKF city: San Antonio
database: KSKY city: Sandusky               IATA: SKY city: Sandusky
database: KSLB city: Storm Lake             IATA: SLB city: Storm Lake
database: KSLE city: Salem                  IATA: SLE city: Salem
database: KSLG city: Siloam Springs         IATA: SLG city: Siloam Springs
database: KSLO city: Salem                  IATA: SLO city: Salem
database: KSLR city: Sulphur Springs        IATA: SLR city: Sulphur Springs
database: KSMD city: Fort Wayne             IATA: SMD city: Fort Wayne
database: KSME city: Somerset               IATA: SME city: Somerset
database: KSMN city: Salmon                 IATA: SMN city: Salmon
database: KSMO city: Santa Monica           IATA: SMO city: Santa Monica
database: KSNK city: Snyder                 IATA: SNK city: Snyder
database: KSNL city: Shawnee                IATA: SNL city: Shawnee
database: KSNS city: Salinas                IATA: SNS city: Salinas
database: KSNY city: Sidney                 IATA: SNY city: Sidney
database: KSPF city: Spearfish              IATA: SPF city: Spearfish
database: KSPW city: Spencer                IATA: SPW city: Spencer
database: KSRC city: Searcy                 IATA: SRC city: Searcy
database: KSSC city: Sumter                 IATA: SSC city: Sumter
database: KSSF city: San Antonio            IATA: SSF city: San Antonio
database: KSSI city: Brunswick              IATA: SSI city: Brunswick
database: KSTE city: Stevens Point          IATA: STE city: Stevens Point
database: KSTJ city: St Joseph              IATA: STJ city: St Joseph
database: KSTK city: Sterling               IATA: STK city: Sterling
database: KSUA city: Stuart                 IATA: SUA city: Stuart
database: KSUD city: Stroud                 IATA: SUD city: Stroud
database: KSUE city: Sturgeon Bay           IATA: SUE city: Sturgeon Bay
database: KSUS city: St Louis               IATA: SUS city: St Louis
database: KSUU city: Fairfield              IATA: SUU city: Fairfield
database: KSUW city: Superior               IATA: SUW city: Superior
database: KSVE city: Susanville             IATA: SVE city: Susanville
database: KSVH city: Statesville            IATA: SVH city: Statesville
database: KSVN city: Savannah               IATA: SVN city: Savannah
database: KSWW city: Sweetwater             IATA: SWW city: Sweetwater
database: KSYI city: Shelbyville            IATA: SYI city: Shelbyville
database: KSYV city: Sylvester              IATA: SYV city: Sylvester
database: KSZL city: Knob Noster            IATA: SZL city: Knob Noster
database: KTBR city: Statesboro             IATA: TBR city: Statesboro
database: KTCC city: Tucumcari              IATA: TCC city: Tucumcari
database: KTCM city: Tacoma                 IATA: TCM city: Tacoma
database: KTDO city: Toledo                 IATA: TDO city: Toledo
database: KTDW city: Amarillo               IATA: TDW city: Amarillo
database: KTDZ city: Toledo                 IATA: TDZ city: Toledo
database: KTEB city: Teterboro              IATA: TEB city: Teterboro
database: KTHA city: Tullahoma              IATA: THA city: Tullahoma
database: KTHM city: Thompson Falls         IATA: THM city: Thompson Falls
database: KTHP city: Thermopolis            IATA: THP city: Thermopolis
database: KTHV city: York                   IATA: THV city: York
database: KTIK city: Oklahoma City          IATA: TIK city: Oklahoma City
database: KTIW city: Tacoma                 IATA: TIW city: Tacoma
database: KTIX city: Titusville             IATA: TIX city: Titusville
database: KTLR city: Tulare                 IATA: TLR city: Tulare
database: KTMA city: Tifton                 IATA: TMA city: Tifton
database: KTNP city: Twentynine Palms       IATA: TNP city: Twentynine Palms
database: KTNT city: Miami                  IATA: TNT city: Miami
database: KTNU city: Newton                 IATA: TNU city: Newton
database: KTOA city: Torrance               IATA: TOA city: Torrance
database: KTOC city: Toccoa                 IATA: TOC city: Toccoa
database: KTOI city: Troy                   IATA: TOI city: Troy
database: KTOP city: Topeka                 IATA: TOP city: Topeka
database: KTOR city: Torrington             IATA: TOR city: Torrington
database: KTPF city: Tampa                  IATA: TPF city: Tampa
database: KTPH city: Tonopah                IATA: TPH city: Tonopah
database: KTRL city: Terrell                IATA: TRL city: Terrell
database: KTRX city: Trenton                IATA: TRX city: Trenton
database: KTSP city: Tehachapi              IATA: TSP city: Tehachapi
database: KTTD city: Portland               IATA: TTD city: Portland
database: KTVF city: Thief River Falls      IATA: TVF city: Thief River Falls
database: KTVI city: Thomasville            IATA: TVI city: Thomasville
database: KUBS city: Columbus               IATA: UBS city: Columbus
database: KUCY city: Union City             IATA: UCY city: Union City
database: KUDD city: Palm Springs           IATA: UDD city: Palm Springs
database: KUES city: Waukesha               IATA: UES city: Waukesha
database: KUKI city: Ukiah                  IATA: UKI city: Ukiah
database: KUKT city: Quakertown             IATA: UKT city: Quakertown
database: KULM city: New Ulm                IATA: ULM city: New Ulm
database: KUNU city: Juneau                 IATA: UNU city: Juneau
database: KUOS city: Sewanee                IATA: UOS city: Sewanee
database: KUOX city: Oxford                 IATA: UOX city: Oxford
database: KUVA city: Uvalde                 IATA: UVA city: Uvalde
database: KVBG city: Lompoc                 IATA: VBG city: Lompoc
database: KVCV city: Victorville            IATA: VCV city: Victorville
database: KVDI city: Vidalia                IATA: VDI city: Vidalia
database: KVEL city: Vernal                 IATA: VEL city: Vernal
database: KVGT city: Las Vegas              IATA: VGT city: Las Vegas
database: KVHN city: Van Horn               IATA: VHN city: Van Horn
database: KVIH city: Rolla/Vichy            IATA: VIH city: Rolla/Vichy
database: KVIS city: Visalia                IATA: VIS city: Visalia
database: KVJI city: Abingdon               IATA: VJI city: Abingdon
database: KVKS city: Vicksburg              IATA: VKS city: Vicksburg
database: KVLA city: Vandalia               IATA: VLA city: Vandalia
database: KVNC city: Venice                 IATA: VNC city: Venice
database: KVOK city: Camp Douglas           IATA: VOK city: Camp Douglas
database: KVPZ city: Valparaiso             IATA: VPZ city: Valparaiso
database: KVQQ city: Jacksonville           IATA: VQQ city: Jacksonville
database: KVTN city: Valentine              IATA: VTN city: Valentine
database: KVYS city: Peru                   IATA: VYS city: Peru
database: KWDG city: Enid                   IATA: WDG city: Enid
database: KWDR city: Winder                 IATA: WDR city: Winder
database: KWHP city: Los Angeles            IATA: WHP city: Los Angeles
database: KWJF city: Lancaster              IATA: WJF city: Lancaster
database: KWLD city: Winfield/Arkansas City IATA: WLD city: Winfield/Arkansas City
database: KWLW city: Willows                IATA: WLW city: Willows
database: KWMC city: Winnemucca             IATA: WMC city: Winnemucca
database: KWRB city: Warner Robins          IATA: WRB city: Warner Robins
database: KWSD city: White Sands            IATA: WSD city: White Sands
database: KWST city: Westerly               IATA: WST city: Westerly
database: KWVI city: Watsonville            IATA: WVI city: Watsonville
database: KWVL city: Waterville             IATA: WVL city: Waterville
database: KWWD city: Wildwood               IATA: WWD city: Wildwood
database: KWWR city: Woodward               IATA: WWR city: Woodward
database: KWYS city: West Yellowstone       IATA: WYS city: West Yellowstone
database: KYKN city: Yankton                IATA: YKN city: Yankton

[mborsetti]

Quick question: are you planning on merging these 679 airports?

[mborsetti]

This PR has been implemented in fork of this project housed at https://github.com/mborsetti/airportsdata, which is also available for those using Python over pip:

pip install airportsdata

To load the data into a dict:

import airportsdata
airports = airportsdata.load()  # key is ICAO code

or

import airportsdata
airports = airportsdata.load('IATA')  # key is IATA code