number of errors=237
number of warnings=0
Group=ckgGrpAirpIcao
select geoname.geonameid,geoname.countrycode,geoname.name,featurecode,icao.name,iata.name,priority,weatherstation.icao,weatherstation.iata from weatherstation,geoname,alternatename iata,alternatename icao where geoname.geonameid = iata.geonameid and geoname.geonameid=icao.geonameid and icao.namelocale='icao' and iata.namelocale='iata' and featureclass='S' and weatherstation.iata<>iata.name and weatherstation.icao=icao.name and weatherstation.iata is not null order by geoname.countrycode,geoname.geonameid
http://www.iata.org/publications/Pages/code-search.aspx
geonameid countrycode name featurecode name name priority icao iata 7668737 AU Latrobe Regional Airport AIRP YLTV TGN null YLTV LTB 7730274 AU Shark Bay Airport AIRP YSHK MJK null YSHK DNM 7731137 AU Shute Harbour Airport AIRP YSHR WSY null YSHR JHQ 7731137 AU Shute Harbour Airport AIRP YWHI JHQ null YWHI WSY 7731270 AU Margaret River Airport AIRP YMGT MQZ null YMGT MGV 7731347 AU Noosa Airport AIRP YNSH NSA null YNSH NSV 7668476 BR União da Vitória Airport AIRP SSUV UVI null SSUV QVB 7731425 BR Canela Airport AIRP SSCN CEL null SSCN QCN 7731430 BR Guaíra Airport AIRP SSGY GGJ null SSGY QGA 7731446 BR São Borja João Manoel Airport AIRP SSSB JBS null SSSB QOJ 7731451 BR Cachoeiro do Itapemirim Airport AIRP SNKI CDI null SNKI QXD 12402419 BR Planalto Serrano Regional Airport AIRP SNCP EEA null SNCP CTP 3571819 BS New Bight Airport AIRP MYCB TBI null MYCB CAT 5882474 CA Kangiqsualujjuaq Georges River Airport AIRP CYLU XGR 7 CYLU YLU 5882482 CA Nemiscau Airport AIRP CYHH YNS 7 CYHH YHH 6296029 CA Squamish Airport AIRP CWSK YSE 7 CWSK WSK 6296158 CA Bella Coola Airport AIRP CYBD QBC 7 CYBD YBD 6296188 CA Makkovik Airport AIRP CYFT YMN 7 CYFT YFT 6296198 CA Quaqtaq Airport AIRP CYHA YQC 6 CYHA YHA 6296208 CA Digby/Annapolis Regional Airport AIRP CYID YDG 7 CYID YID 6296214 CA Aklavik/Freddie Carmichael Airport AIRP CYKD LAK 7 CYKD YKD 6296219 CA Akulivik Airport AIRP CYKO AKV 7 CYKO YKO 6296222 CA Aupaluk Airport AIRP CYLA YPJ 7 CYLA YLA 6296226 CA Lutselk'e Airport AIRP CYLK YSG 7 CYLK YLK 6296235 CA Umiujaq Airport AIRP CYMU YUD 7 CYMU YMU 6296249 CA Allan J. MacEachen Port Hawkesbury Airport AIRP CYPD YPS 7 CYPD YPD 6296356 CA Pincher Creek Airport AIRP CZPC WPC 7 CZPC ZPC 6301480 CA St. Catharines/Niagara District Airport AIRP CYSN YCM 6 CYSN YSN 7730043 CA Boundary Bay Airport AIRP CZBB YDT null CZBB ZBD 7730044 CA Kelsey Airport AIRP CZEE KES null CZEE ZEE 7730045 CA Pukatawagan Airport AIRP CZFG XPK null CZFG ZFG 7730048 CA South Indian Lake Airport AIRP CZSN XSI null CZSN ZSN 7730049 CA Lac Brochet Airport AIRP CZWH XLB null CZWH ZWH 7910211 CA Kangirsuk Airport AIRP CYAS YKG 7 CYAS YAS 7910228 CA Kangiqsujuaq (Wakeham Bay) Airport AIRP CYKG YWB 7 CYKG YKG 8260846 CA La Grande-3 Airport AIRP CYAD YAR 7 CYAD YAD 8299200 CA Poplar River Airport AIRP CZNG XPP null CZNG ZNG 6301382 CN Ganzhou Huangjin Airport AIRP ZSGZ KOW 7 ZSGZ CI2 6324585 CN Kai Tak Airport AIRQ VHHX HKG null VHHX HGK 3681167 CO Hacaritama Airport AIRP SKAG HAY null SKAG ACL 7731410 CO Captain Germán Olano Moreno Air Base AIRP SKPQ PAL null SKPQ PQE 7730112 CR Nosara Airport AIRP MRNS NOB null MRNS NOM 7730679 CR Playa Sámara Carillo Airport AIRP MRSR RIK null MRSR PLD 7730679 CR Playa Sámara Carillo Airport AIRP MRCR PLD null MRCR RIK 3208529 DE Norden-Norddeich AIRF EDWS NOD null EDWS NOE 3380401 GF Saint-Georges-de-l'Oyapock Airport AIRP SOOG OYP null SOOG OXP 7730417 GL Kangersuatsiaq Heliport AIRH BGKS KGQ null BGKS KAQ 7730418 GL Illorsuit Heliport AIRH BGLL IOT null BGLL ILL 7730419 GL Qeqertaq Heliport AIRH BGQE PQT null BGQE QQT 6301804 GT Mundo Maya International Airport AIRP MGMM FRS null MGMM MCR 6301280 ID Sultan Muhammad Salahudin Airport AIRP WADB PBW null WADB BMU 7731464 ID Rokot Airport AIRP WIBR RKI null WIBR RKO 11749267 ID APT Pranoto Airport AIRP WALS AAP null WALS SRI 12059870 ID Gatot Subroto Airport AIRP WIPO WTX null WIPO WYK 12750420 ID Singkawang Airport AIRP WIOD SKJ null WIOD TJQ 7668589 IN Daporijo Airport AIRP VEDZ DEP null VEDZ DAE 7603289 IQ Baghdad International Airport AIRP ORBI SDA null ORBI BGW 7730143 IQ Sulaymaniyah International Airport AIRP ORSU ISU null ORSU OSO 7730141 IR Persian Gulf International Airport AIRP OIBP PGU null OIBP YEH 7730184 KZ Semey Airport AIRP UASS PLX null UASS DLX 7730209 LK Ampara Airport AIRP VCCG ADP null VCCG GOY 7731283 LK Hingurakgoda Minneriya Airport AIRP VCCH HIM null VCCH MNH 8260875 MM Naypyidaw Airport AIRP VYNT NYT null VYNT NMT 3992617 MX Piedras Negras International Airport AIRP MMPG PDS 6 MMPG PNG 6299827 MX Del Norte International Airport AIRP MMAN NTR 5 MMAN MAN 6299837 MX Chichen Itza International Airport AIRP MMCT CZA 8 MMCT MCT 6299846 MX Colima Airport AIRP MMIA CLQ 6 MMIA IMA 6299848 MX Ixtepec Airport AIRP MMIT IZT 7 MMIT MIT 6299851 MX Del Bajío International Airport AIRP MMLO BJX 6 MMLO LEO 6299858 MX Venustiano Carranza International Airport AIRP MMMV LOV 1 MMMV MOV 7730668 MX San Cristóbal de las Casas National Airport AIRP MMSC SZT 8 MMSC SOC 12541722 MX Felipe Carrillo Puerto International Airport AIRP MMTL TQO 7 MMTL TCG 8394117 OM Duqm International Airport AIRP OODQ JNJ null OODQ DQM 7730176 PE Maria Reiche Neuman Airport AIRP SPZA NZC null SPZA NZA 6355143 PF Atuona Airport AIRP NTMN AUQ null NTMN HIX 8299033 PG Haelogo Airport AIRP AYHG SUZ null AYHG HEO 1705453 PH Lubang Airport AIRP RPLU QPX null RPLU LBX 1705453 PH Lubang Airport AIRP RPLU QPY null RPLU LBX 6301846 PH Danilo Atienza Air Base AIRB RPLS SGL null RPLS NSP 7668422 PH Sanga Sanga Airport AIRP RPMN TWT null RPMN SGS 7668426 PH Borongan Airport AIRP RPVW BPA null RPVW BPR 8531888 PK Sawan Airport AIRP OPSW RZS null OPSW SWN 6299479 PM Saint-Pierre Airport AIRP LFVP FSP 8 LFVP FVP 7668331 TR Sinop Airport AIRP LTCM NOP null LTCM SIC 11838481 TR Istanbul Airport AIRP LTFM IST null LTFM ISL 12519099 TZ Geita Airport AIRP HTGE GTC null HTGE GIT 7730187 UA Sevastopol International Airport AIRP UKFB UKS null UKFB BQB 4069428 US Jack Edwards Airport AIRP KJKA GUF 7 KJKA JKA 4100583 US Ozark Regional Airport AIRP KBPK WMH 7 KBPK BPK 4121301 US Mena Intermountain Municipal Airport AIRP KMEZ UMZ 8 KMEZ MEZ 4132103 US Springdale Municipal Airport AIRP KASG SPZ 7 KASG ASG 4153191 US Destin Executive Airport AIRP KDTS DSI 7 KDTS DTS 4169015 US Pompano Beach Airpark AIRP KPMP PPM 7 KPMP PMP 4170895 US Northeast Florida Regional Airport AIRP KSGJ UST 7 KSGJ SGJ 4188990 US Columbus Airport AIRP KCSG CSJ 6 KCSG CSG 4256039 US Columbus Bakalar Municipal Airport AIRP KBAK CLU 7 KBAK BAK 4273642 US New Century AirCenter AIRP KIXD JCI 7 KIXD IXD 4364313 US Ocean City Municipal Airport AIRP KOXB OCE 7 KOXB OXB 4378226 US Branson Airport AIRP KBBG BKG 7 KBBG BBG 4455993 US Billy Mitchell Airport AIRP KHSE HNC 1 KHSE HSE 4475348 US Laurinburg-Maxton Airport AIRP KMEB MXE 7 KMEB MEB 4477895 US Dare County Regional Airport AIRP KMQI MEO 7 KMQI MQI 4489164 US Rowan County Airport AIRP KRUQ SRW 7 KRUQ RUQ 4499128 US Wilkes County Airport AIRP KUKF IKB 7 KUKF UKF 4500995 US South Jersey Regional Airport AIRP KVAY LLY 7 KVAY VAY 4520361 US Ohio University Airport-Snyder Field AIRF KUNI ATO 8 KUNI UNI 4529103 US Ada Municipal Airport AIRP KADH ADT 7 KADH ADH 4557135 US Chester County G O Carlson Airport AIRP KMQS CTH 7 KMQS MQS 4570293 US Beaufort County Airport AIRP KARW BFT 7 KARW ARW 4574417 US Cheraw Municipal Airport/Lynch Bellinger Field AIRF KCQW HCW 8 KCQW CQW 4576791 US Donaldson Center Airport AIRP KGYH GDC 7 KGYH GYH 4581827 US Hilton Head Airport AIRP KHXD HHH 7 KHXD HXD 4586302 US Marlboro County Jetport - HE Avent Field AIRF KBBP BTN 8 KBBP BBP 4597966 US Sumter Airport AIRP KSMS SUM 8 KSMS SMS 4672665 US Bay City Municipal Airport AIRP KBYY BBC 8 KBYY BYY 4676138 US Texas Gulf Coast Regional Airport AIRP KLBX LJN 7 KLBX LBX 4680612 US Cherokee County Airport AIRP KJSO JKV 7 KJSO JSO 4694711 US North Texas Regional Airport AIRP KGYI PNX 7 KGYI GYI 4699544 US Huntsville Municipal Airport AIRP KUTS HTV 7 KUTS UTS 4703151 US Kickapoo Downtown Airport AIRP KCWC KIP 8 KCWC CWC 4771410 US Manassas Regional Airport AIRF KHEF MNZ 7 KHEF HEF 4794129 US Winchester Regional Airport AIRP KOKV WGO 7 KOKV OKV 4846611 US Algona Municipal Airport AIRP KAXA AXG 8 KAXA AXA 4857523 US Fort Madison Municipal Airport AIRP KFSW FMS 8 KFSW FSW 4883831 US Chicago/Aurora Municipal Airport AIRP KARR AUZ 7 KARR ARR 4919990 US Elkhart Municipal Airport AIRP KEKM EKI 7 KEKM EKM 4963465 US Fryeburg/Eastern Slopes Regional Airport AIRP KIZG FRY 7 KIZG IZG 4973761 US Northern Aroostook Regional Airport AIRP KFVE WFK 7 KFVE FVE 4983360 US Wiscasset Airport AIRP KIWI ISS 7 KIWI IWI 4991195 US Drummond Island Airport AIRP KDRM DRE 7 KDRM DRM 5007362 US Roben-Hood Airport AIRP KRQB WBR 7 KRQB RQB 5009005 US Sault Ste Marie Municipal Airport AIRP KANJ SSM 0 KANJ ANJ 5025636 US Ely Municipal Airport AIRP KELO LYU 7 KELO ELO 5047595 US Slayton Municipal Airport AIRP KDVP NSL 8 KDVP DVP 5052922 US Willmar Municipal Airport AIRP KBDH ILL 8 KBDH BDH 5058404 US Breckenridge-Wahpeton Interstate Airport AIRP KBWP WAH 8 KBWP BWP 5073146 US Millard Airport AIRP KMLE MIQ 7 KMLE MLE 5110293 US Brookhaven Calabro Airport AIRP KHWV WSH 7 KHWV HWV 5145491 US Akron Fulton International Airport AIRP KAKR AKC 7 KAKR AKR 5146093 US Ashtabula County Airport AIRP KHZY JFN 7 KHZY HZY 5179455 US Beaver County Airport AIRP KBVI BFP 6 KBVI BVI 5183176 US Capital City Airport AIRP KCXY HAR 7 KCXY CXY 5206946 US Port Meadville Airport AIRP KGKJ MEJ 7 KGKJ GKJ 5216775 US Penn State University Park Airport AIRP KUNV SCE 3 KUNV UNV 5218077 US Washington County Airport AIRP KAFJ WSG 7 KAFJ AFJ 5223619 US Newport State Airport AIRP KUUU NPT 7 KUUU UUU 5224229 US Quonset State Airport AIRP KOQU NCO 7 KOQU OQU 5229527 US Madison Municipal Airport AIRP KMDS XMD 7 KMDS MDS 5234480 US Caledonia County Airport AIRP KCDA LLX 8 KCDA CDA 5267942 US Prairie du Chien Municipal Airport AIRP KPDC PCD 7 KPDC PDC 5275452 US Taylor County Airport AIRP KMDZ MDF 7 KMDZ MDZ 5294459 US Falcon Field AIRP KFFZ MSC 7 KFFZ FFZ 5308306 US Payson Airport AIRP KPAN PJB 9 KPAN PAN 5313458 US Scottsdale Airport AIRP KSDL SCF 7 KSDL SDL 5313668 US Sedona Airport AIRP KSEZ SDX 8 KSEZ SEZ 5321107 US Phoenix-Mesa Gateway Airport AIRP KIWA AZA 3 KIWA IWA 5322066 US Yuma International Airport AIRP KNYL YUM 6 KNYL NYL 5334969 US Catalina Airport AIRP KAVX SXC 7 KAVX AVX 5334969 US Catalina Airport AIRP KAVX CIB 7 KAVX AVX 5352553 US Gnoss Field AIRF KDVO NOT 7 KDVO DVO 5357493 US Hollister Municipal Airport AIRP KCVH HLI 8 KCVH CVH 5371378 US McClellan–Palomar Airport AIRP KCRQ CLD 6 KCRQ CRQ 5378781 US Oceanside Municipal Airport AIRP KOKB OCN 7 KOKB OKB 5391732 US San Bernardino International Airport AIRP KSBD SBT 8 KSBD SBD 5393389 US Santa Ynez Airport AIRP KIZA SQA 7 KIZA IZA 5403683 US Truckee Tahoe Airport AIRP KTRK TKF 6 KTRK TRK 5415293 US Buckley Space Force Base AIRP KBKF BFK 2 KBKF BKF 5491390 US Sierra Blanca Regional Airport AIRP KSRR RUI 7 KSRR SRR 5493794 US Taos Regional Airport AIRP KSKX TSM 7 KSKX SKX 5500543 US Boulder City Municipal Airport AIRP KBVU BLD 8 KBVU BVU 5501375 US Carson Airport AIRP KCXP CSN 8 KCXP CXP 5512477 US Henderson Executive Airport AIRP KHND HSH 6 KHND HND 5513823 US Tonopah Test Range Airport AIRP KTNX XSD 8 KTNX TNX 5517068 US Big Spring McMahon-Wrinkle Airport AIRP KBPG HCA 8 KBPG BPG 5527561 US Odessa-Schlemeyer Field AIRF KODO ODT 7 KODO ODO 5554568 US Klawock Airport AIRP PAKW KLW 7 PAKW AKW 5556494 US Port Alexander Seaplane Base AIRP PAAP PTD 7 PAAP AHP 5576076 US Craig-Moffat Airport AIRP KCAG CIG 4 KCAG CAG 5588525 US Challis Airport AIRP KLLJ CHL 7 KLLJ LLJ 5654296 US Glacier Park International Airport AIRP KGPI FCA 6 KGPI GPI 5688131 US Bowman Municipal Airport AIRP KBPP BWM 8 KBPP BPP 5731078 US Hermiston Municipal Airport AIRP KHRI HES 7 KHRI HRI 5756778 US Tillamook Airport AIRP KTMK OTK 7 KTMK TMK 5767941 US Pine Ridge Airport AIRP KIEN XPR 7 KIEN IEN 5786501 US Bay View Airport AIRP KBVS MVW 7 KBVS BVS 5795094 US Friday Harbor Airport AIRP KFHR FRD 7 KFHR FHR 5805791 US Orcas Island Airport AIRP KORS ESD 7 KORS ORS 5835906 US Ralph Wenz Field AIRP KPNA PWY 8 KPNA PNA 5847638 US Kalaeloa Airport AIRP PHJR NAX 6 PHJR JRF 5858173 US Buckland Airport AIRP PABL BKC 7 PABL BVK 5859417 US Circle City Airport AIRP PACR IRC 7 PACR CRC 5860513 US Deering Airport AIRP PADE DRG 7 PADE DEE 5861420 US Egegik Airport AIRP PAII EGX 7 PAII EII 5861669 US Emmonak Airport AIRP PAEM EMK 7 PAEM ENM 5863075 US Golovin Airport AIRP PAGL GLV 7 PAGL N93 5864134 US Holy Cross Airport AIRP PAHC HCR 7 PAHC HCA 5866392 US Kipnuk Airport AIRP PAKI KPN 8 PAKI IIK 5868245 US Manokotak Airport AIRP PAMB KMO 7 PAMB MBA 5868503 US McCarthy Airport AIRP PAMX MXY 7 PAMX 15Z 5868581 US McKinley National Park Airport AIRP PAIN MCL 7 PAIN INR 5868953 US Minchumina Airport AIRP PAMH LMA 7 PAMH MHM 5869869 US Koliganek Airport AIRP PAJZ KGK 8 PAJZ JZZ 5869873 US St. George Airport AIRP PAPB STG 7 PAPB PBV 5869877 US Wasilla Airport AIRP PAWS WWA 7 PAWS IYS 5869964 US Nikolai Airport AIRP PAFS NIB 7 PAFS FSP 5870433 US Nuiqsut Airport AIRP PAQT NUI 6 PAQT AQT 5871599 US Pilot Point Airport AIRP PAPN PIP 8 PAPN PNP 5871907 US Port Alsworth Airport AIRP PALJ PTA 7 PALJ TPO 5872534 US Red Dog Airport AIRP PADG RDB 7 PADG DGG 5873816 US Shaktoolik Airport AIRP PFSH SKK 8 PFSH 2C7 5877108 US Ugnu-Kuparuk Airport AIRP PAKU UUK 7 PAKU UBW 5877544 US Wainwright Airport AIRP PAWI AIN 7 PAWI AWI 5878103 US Willow Airport AIRP PAUO WOW 7 PAUO UUO 5879298 US Ambler Airport AIRP PAFM ABL 7 PAFM AFM 5879733 US Atka Airport AIRP PAAK AKB 7 PAAK AKA 6297593 US Grant County Regional Airport AIRP KGCD JDA 7 KGCD GCD 6297596 US Wharton Regional Airport AIRP KARM WHT 8 KARM ARM 6297621 US Caro, Tuscola Area Airport AIRP KCFS TZC 8 KCFS CFS 6298496 US Concord-Padgett Regional Airport AIRP KJQF USA 7 KJQF JQF 6298549 US Ft. Stewart AIRF KLHW LIY 7 KLHW LHW 6298551 US Louisburg, Franklin County Airport AIRP KLHZ LFN 7 KLHZ LHZ 6298555 US Louisa, Louisa County Airport/Freeman Field AIRF KLKU LOW 7 KLKU LKU 6298828 US Mount Pleasant Regional Airport AIRP KOSA MPS 8 KOSA OSA 6299041 US Sawyer International Airport AIRP KSAW MQT 8 KSAW SAW 6299232 US Rock Hill, Rock Hill - York County Airport AIRP KUZA RKH 7 KUZA UZA 6301657 US Wings Field AIRP KLOM BBX 7 KLOM LOM 6301663 US Naval Air Station Joint Reserve Base Fort Worth AIRB KNFW FWH 6 KNFW NFW 6301707 US Rice Lake, Rice Lake Regional-Carl's Field Airport AIRP KRPD RIE 7 KRPD RPD 6301742 US Tunica Municipal Airport AIRP KUTA UTM 8 KUTA UTA 7702012 US AJ Eisenberg Airport AIRP KOKH ODW 8 KOKH OKH 8113387 US Trent Lott International Airport AIRP KPQL PGL 7 KPQL PQL 8260366 US Joint Base Andrews AIRB KADW NSF 6 KADW ADW 6301009 UZ Urgench International Airport AIRP UTNU UGC 8 UTNU URG 6301011 UZ Samarkand Airport AIRP UTSS SKD 6 UTSS SMD 7668545 UZ Fergana International Airport AIRP UTFF FEG 6 UTFF FRG 7730721 VU North West Santo Airport AIRP NVSZ OLJ null NVSZ OLZ 7730076 ZM Kasompe Airport AIRP FLKE CGJ null FLKE ZKP