# phpMyAdmin MySQL-Dump
# version 2.2.2
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: localhost
# Generation Time: Jan 08, 2003 at 11:53 PM
# Server version: 3.23.45
# PHP Version: 4.1.2
# --------------------------------------------------------

#
# Table structure for table `metars`
#

CREATE TABLE metars (
  icao varchar(4) NOT NULL default '',
  metar varchar(255) NOT NULL default '',
  timestamp timestamp(14) NOT NULL,
  PRIMARY KEY  (icao),
  UNIQUE KEY icao (icao)
) TYPE=MyISAM;

#
# Table structure for table `pmetars`
#

CREATE TABLE pmetars (
  icao varchar(4) NOT NULL default '',
  metar varchar(255) NOT NULL default '',
  timestamp timestamp(14) NOT NULL,
  PRIMARY KEY  (icao),
  UNIQUE KEY icao (icao)
) TYPE=MyISAM;

#
# Table structure for table `stations`
#

CREATE TABLE stations (
  icao varchar(4) NOT NULL default '',
  name varchar(255) NOT NULL default '',
  cc char(2) NOT NULL default '',
  country varchar(128) NOT NULL default '',
  locshort varchar(40) default NULL,
  zone varchar(6) default NULL,
  PRIMARY KEY  (icao),
  UNIQUE KEY icao (icao),
  KEY cc (cc)
) TYPE=MyISAM;

#
# Dumping data for table `stations`
#

INSERT INTO stations VALUES ('KABR', 'Aberdeen, Aberdeen Regional Airport', 'US', 'United States', 'Aberdeen', 'SDZ006'),
('KABI', 'Abilene, Abilene Regional Airport', 'US', 'United States', 'Abilene', 'TXZ127'),
('KVJI', 'Abingdon', 'US', 'United States', 'Abingdon', 'VAZ008'),
('PADK', 'Adak, Naval Air Station', 'US', 'United States', 'Adak', 'AKZ020'),
('KADG', 'Adrian, Lenawee County Airport', 'US', 'United States', NULL, NULL),
('KANW', 'Ainsworth Municipal', 'US', 'United States', 'Ainsworth', 'NEZ008'),
('KAFF', 'Air Force Academy', 'US', 'United States', 'Air Force', 'COZ071'),
('KAIT', 'Aitkin NDB Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KCAK', 'Akron, Akron-Canton Regional Airport', 'US', 'United States', 'Akron', 'OHZ021'),
('KAKO', 'Akron, Akron-Washington County Airport', 'US', 'United States', 'Akron', 'COZ049'),
('KEET', 'Alabaster, Shelby County Airport', 'US', 'United States', NULL, NULL),
('KNGZ', 'Alameda Naval Air Station', 'US', 'United States', NULL, NULL),
('KALM', 'Alamogordo-White', 'US', 'United States', NULL, NULL),
('KALS', 'Alamosa, San Luis Valley Regional Airport', 'US', 'United States', 'Alamosa', 'COZ063'),
('KALB', 'Albany, Albany County Airport', 'US', 'United States', 'Albany', 'NYZ052'),
('KABY', 'Albany, Southwest Georgia Regional Airport', 'US', 'United States', 'Albany', 'GAZ125'),
('KAEL', 'Albert Lea Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KABQ', 'Albuquerque, Albuquerque International Airport', 'US', 'United States', 'Albuquerque', 'NMZ009'),
('KESF', 'Alexandria, Alexandria Esler Regional Airport', 'US', 'United States', 'AlexandriaEsler', 'LAZ028'),
('KAEX', 'Alexandria, Alexandria International Airport', 'US', 'United States', 'Alexandria', 'LAZ028'),
('KAXN', 'Alexandria, Chandler Field', 'US', 'United States', 'Alexandria', 'MNZ041'),
('KAXA', 'Algona', 'US', 'United States', 'Algona', 'IAZ005'),
('KALI', 'Alice, Alice International Airport', 'US', 'United States', 'Alice', 'TXZ241'),
('KABE', 'Allentown, Lehigh Valley International Airport', 'US', 'United States', 'Allentown', 'PAZ061'),
('KAIA', 'Alliance, Alliance Municipal Airport', 'US', 'United States', 'Alliance', 'NEZ003'),
('KAMG', 'Alma, Bacon County Airport', 'US', 'United States', 'Alma', 'GAZ134'),
('KAPN', 'Alpena, Alpena County Regional Airport', 'US', 'United States', 'Alpena', 'MIZ024'),
('KALN', 'Alton / St. Louis Regional', 'US', 'United States', 'Alton', 'ILZ100'),
('KAOO', 'Altoona, Altoona-Blair County Airport', 'US', 'United States', 'Altoona', 'PAZ025'),
('KO00', 'Alturas', 'US', 'United States', NULL, NULL),
('KLTS', 'Altus Air Force Base', 'US', 'United States', 'Altus', 'OKZ036'),
('KAMA', 'Amarillo, Amarillo International Airport', 'US', 'United States', 'Amarillo', 'TXZ017'),
('PAFM', 'Ambler', 'US', 'United States', 'Ambl\\er', 'AKZ003'),
('K7R3', 'Amelia / Lake Palourd', 'US', 'United States', 'Amelia', ''),
('KAMW', 'Ames, Ames Municipal Airport', 'US', 'United States', 'Ames', 'IAZ048'),
('PAKP', 'Anaktuvuk Pass', 'US', 'United States', 'Anaktuvuk', 'AKZ001'),
('PAED', 'Anchorage / Elmendorf Air Force Base', 'US', 'United States', 'Anchorage / Elmendorf AFB', 'AKZ015'),
('PANC', 'Anchorage, Anchorage International Airport', 'US', 'United States', 'Anchorage', 'AKZ015'),
('KAID', 'Anderson Municipal', 'US', 'United States', NULL, NULL),
('KAND', 'Anderson, Anderson County Airport', 'US', 'United States', 'Anderson', 'SCZ010'),
('K12N', 'Andover, Aeroflex-Andover Airport', 'US', 'United States', NULL, NULL),
('KLBX', 'Angleton / Lake Jackson, Brazoria County Airport', 'US', 'United States', 'Angleton', ''),
('PAGN', 'Angoon', 'US', 'United States', NULL, NULL),
('PANI', 'Aniak', 'US', 'United States', 'Aniak', 'AKZ010'),
('KARB', 'Ann Arbor, Ann Arbor Municipal Airport', 'US', 'United States', 'Ann Arbor', 'MIZ075'),
('PANT', 'Annette Island', 'US', 'United States', 'Annette', ''),
('KANB', 'Anniston, Anniston Metropolitan Airport', 'US', 'United States', 'Anniston', 'ALZ019'),
('KAIG', 'Antigo - Lang Automatic Weather Observing / Reporting System', 'US', 'United States', 'Antigo', 'WIZ019'),
('KAQQ', 'Apalachicola, Apalachicola', 'US', 'United States', 'Apalachicola', 'FLZ015'),
('KATW', 'Appleton / Outagamie', 'US', 'United States', 'Appleton', 'WIZ038'),
('KACV', 'Arcata / Eureka, Arcata Airport', 'US', 'United States', 'Arcata', 'CAZ001'),
('PARC', 'Arctic Village', 'US', 'United States', NULL, NULL),
('KADM', 'Ardmore Municipal', 'US', 'United States', 'Ardmore', 'OKZ046'),
('KAWO', 'Arlington Municipal', 'US', 'United States', NULL, NULL),
('KGKY', 'Arlington, Arlington Municipal Airport', 'US', 'United States', NULL, NULL),
('KAVL', 'Asheville, Asheville Regional Airport', 'US', 'United States', 'Asheville', 'NCZ053'),
('KOFP', 'Ashland, Hanover County Municipal Airport', 'US', 'United States', 'Ashland', 'VAZ063'),
('KASX', 'Ashland, Kennedy Memorial Airport', 'US', 'United States', NULL, NULL),
('KHZY', 'Ashtabula, Ashtabula County Airport', 'US', 'United States', NULL, NULL),
('KASE', 'Aspen, Aspen-Pitkin County Airport', 'US', 'United States', 'Aspen', 'COZ010'),
('KAST', 'Astoria, Astoria Regional Airport', 'US', 'United States', 'Astoria', 'ORZ001'),
('KAHN', 'Athens, Athens Airport', 'US', 'United States', 'Athens', 'GAZ036'),
('KPDK', 'Atlanta, De Kalb-Peachtree Airport', 'US', 'United States', 'Dekalb/Peachtree', ''),
('KFTY', 'Atlanta, Fulton County Airport-Brown Field', 'US', 'United States', 'West Atlanta', 'GAZ033'),
('KATL', 'Atlanta, Hartsfield Atlanta International Airport', 'US', 'United States', 'Atlanta', 'GAZ033'),
('KFFC', 'Atlanta, Peachtree City-Falcon Field', 'US', 'United States', NULL, NULL),
('KAIO', 'Atlantic', 'US', 'United States', 'Atlantic', 'IAZ070'),
('KACY', 'Atlantic City, Atlantic City International Airport', 'US', 'United States', 'Atlantic City', 'NJZ022'),
('KLEW', 'Auburn-Lewiston', 'US', 'United States', 'Lewiston', 'MEZ020'),
('KAUO', 'Auburn-Opelika Airport', 'US', 'United States', 'Auburn', 'ALZ047'),
('KAUG', 'Augusta, Augusta State Airport', 'US', 'United States', 'Augusta', 'MEZ021'),
('KAGS', 'Augusta, Bush Field', 'US', 'United States', 'Augusta', 'GAZ065'),
('KDNL', 'Augusta, Daniel Field', 'US', 'United States', NULL, NULL),
('KARR', 'Aurora, Aurora Municipal Airport', 'US', 'United States', 'Aurora', 'ILZ013'),
('KUAO', 'Aurora, Aurora State Airport', 'US', 'United States', NULL, NULL),
('KU31', 'Austin', 'US', 'United States', 'Austin', 'NVZ012'),
('KAUM', 'Austin Municipal', 'US', 'United States', NULL, NULL),
('KAUS', 'Austin, Mueller Municipal Airport', 'US', 'United States', 'Austin', 'TXZ192'),
('KAVX', 'Avalon, Catalina Airport', 'US', 'United States', 'Avalon', ''),
('KAGR', 'Avon Park Gunnery Range', 'US', 'United States', NULL, NULL),
('KBKE', 'Baker, Baker Municipal Airport', 'US', 'United States', 'Baker City', 'ORZ020'),
('KBFL', 'Bakersfield, Meadows Field', 'US', 'United States', 'Bakersfield', 'CAZ021'),
('KMTN', 'Baltimore / Martin', 'US', 'United States', 'Baltimore', 'MDZ011'),
('KBWI', 'Baltimore, Baltimore-Washington International Airport', 'US', 'United States', 'BaltimoreGlen Burnie', 'MDZ014'),
('KDMH', 'Baltimore, Inner Harbor', 'US', 'United States', NULL, NULL),
('KBGR', 'Bangor, Bangor International Airport', 'US', 'United States', 'Bangor', 'MEZ015'),
('KBHB', 'Bar Harbor Automatic Weather Observing / Reporting System', 'US', 'United States', 'Bar Harbor', 'MEZ029'),
('KBAD', 'Barksdale Air Force Base', 'US', 'United States', 'Barksdale', ''),
('KN78', 'Barnegat Coast Guard Station', 'US', 'United States', NULL, NULL),
('KMPV', 'Barre / Montpelier, Knapp State Airport', 'US', 'United States', 'Montpelier', 'VTZ008'),
('PABR', 'Barrow, Post Rogers Memorial Airport', 'US', 'United States', 'Barrow', 'AKZ001'),
('PABA', 'Barter Island', 'US', 'United States', 'Barter Island', ''),
('KBVO', 'Bartlesville, Bartlesville Municipal Airport', 'US', 'United States', 'Bartlesville', 'OKZ054'),
('KBOW', 'Bartow Municipal', 'US', 'United States', 'Bartow', ''),
('KBVX', 'Batesville Automatic Weather Observing / Reporting System', 'US', 'United States', 'Batesville', 'ARZ016'),
('KBTR', 'Baton Rouge, Baton Rouge Metropolitan, Ryan Field', 'US', 'United States', 'Baton Rouge', 'LAZ048'),
('KBTL', 'Battle Creek, Kellogg Airport', 'US', 'United States', 'Battle Creek', 'MIZ073'),
('KB23', 'Battle Mountain', 'US', 'United States', NULL, NULL),
('KBDE', 'Baudette, Baudette International Airport', 'US', 'United States', NULL, NULL),
('KBAB', 'Beale Air Force Base / Marysvile', 'US', 'United States', 'MarysvilleBeale AFB', 'CAZ016'),
('KBIE', 'Beatrice Municipal', 'US', 'United States', 'Beatrice', 'NEZ089'),
('KNBC', 'Beaufort, Marine Corps Air Station', 'US', 'United States', 'Beaufort', 'SCZ048'),
('KMRH', 'Beaufort, Smith Field', 'US', 'United States', NULL, NULL),
('KBUO', 'Beaumont', 'US', 'United States', 'Beaumont', 'CAZ056'),
('KBPT', 'Beaumont / Port Arthur, Jefferson County Airport', 'US', 'United States', 'BeaumontPort Arthur', 'TXZ215'),
('KBVI', 'Beaver Falls Airport', 'US', 'United States', NULL, NULL),
('KBKW', 'Beckley, Raleigh County Memorial Airport', 'US', 'United States', 'Beckley', 'WVZ035'),
('KBED', 'Bedford, Hanscom Field', 'US', 'United States', 'Bedford', 'MAZ005'),
('KEFC', 'Belle Fourche', 'US', 'United States', NULL, NULL),
('KBLI', 'Bellingham, Bellingham International Airport', 'US', 'United States', 'Bellingham', 'WAZ002'),
('KBLM', 'Belmar-Farmdale', 'US', 'United States', 'BelmarFarmingdale', 'NJZ013'),
('KBJI', 'Bemidji', 'US', 'United States', 'Bemidji', 'MNZ009'),
('KDDH', 'Bennington, Bennington Morse State Airport', 'US', 'United States', NULL, NULL),
('KBBB', 'Benson Municipal', 'US', 'United States', NULL, NULL),
('KBEH', 'Benton Harbor, Southwest Michigan Regional Airport', 'US', 'United States', 'Benton Harbor', ''),
('KVBT', 'Bentonville Automatic Weather Observing / Reporting System', 'US', 'United States', 'Bentonville', 'ARZ001'),
('KBSM', 'Bergstrom, Austin-Bergstrom International Airport', 'US', 'United States', 'Bergstrom AFB', 'TXZ192'),
('KBML', 'Berlin, Berlin Municipal Airport', 'US', 'United States', 'Berlin', 'NHZ002'),
('PABE', 'Bethel / Bethel Airport', 'US', 'United States', 'Bethel', 'AKZ010'),
('PABT', 'Bettles', 'US', 'United States', 'Bettles', 'AKZ004'),
('KBVY', 'Beverly, Beverly Municipal Airport', 'US', 'United States', 'Beverly', 'MAZ007'),
('KBYS', 'Bicycle Lake U. S. Army Airfield, Ca', 'US', 'United States', 'Bicycle Lake', ''),
('KBPI', 'Big Piney, Big Piney-Marbleton Airport', 'US', 'United States', 'Big Piney', 'WYZ020'),
('PALV', 'Big River Lake', 'US', 'United States', 'Big River Lake', 'AKZ001'),
('KBIL', 'Billings, Billings Logan International Airport', 'US', 'United States', 'Billings', 'MTZ035'),
('KBGM', 'Binghamton, Binghamton Regional Airport', 'US', 'United States', 'Binghamton', 'NYZ056'),
('KBHM', 'Birmingham, Birmingham International Airport', 'US', 'United States', 'Birmingham', 'ALZ024'),
('KBIH', 'Bishop, Bishop Airport', 'US', 'United States', 'Bishop', 'CAZ026'),
('KBIS', 'Bismarck, Bismarck Municipal Airport', 'US', 'United States', 'Bismarck', 'NDZ035'),
('K4BL', 'Blanding', 'US', 'United States', 'Blanding', 'UTZ022'),
('KBID', 'Block Island Automatic Weather Observing / Reporting System', 'US', 'United States', 'Block Island', 'RIZ006'),
('KBMI', 'Bloomington / Normal', 'US', 'United States', 'Bloomington', 'ILZ038'),
('KBMG', 'Bloomington, Monroe County Airport', 'US', 'United States', 'Bloomington', 'INZ062'),
('KBLF', 'Bluefield, Mercer County Airport', 'US', 'United States', 'Bluefield', 'WVZ042'),
('KBLH', 'Blythe, Blythe Airport', 'US', 'United States', 'Blythe', 'CAZ031'),
('KHKA', 'Blytheville, Blytheville Municipal Airport', 'US', 'United States', NULL, NULL),
('KBOI', 'Boise, Boise Air Terminal', 'US', 'United States', 'Boise', 'IDZ014'),
('KBNW', 'Boone Municipal', 'US', 'United States', 'Boone', 'IAZ047'),
('KBVE', 'Boothville', 'US', 'United States', NULL, NULL),
('KBGD', 'Borger, Hutchinson County Airport', 'US', 'United States', 'Borger', 'TXZ008'),
('KOVS', 'Boscobel, Boscobel Airport', 'US', 'United States', NULL, NULL),
('KBOS', 'Boston, Logan International Airport', 'US', 'United States', 'Boston', 'MAZ015'),
('KBWG', 'Bowling Green, Bowling Green-Warren County Regional Airport', 'US', 'United States', 'Bowling Green', 'KYZ071'),
('KBZN', 'Bozeman, Gallatin Field', 'US', 'United States', 'Bozeman', 'MTZ015'),
('KBFD', 'Bradford, Bradford Regional Airport', 'US', 'United States', 'Bradford', 'PAZ005'),
('PHSF', 'Bradshaw Army Air Field / Hawaii', 'US', 'United States', 'Bradshaw Field', ''),
('KBRD', 'Brainerd, Brainerd-Crow Wing County Regional Airport', 'US', 'United States', 'Brainerd', 'MNZ034'),
('KPWT', 'Bremerton National Automatic Weather Observing / Reporting System', 'US', 'United States', 'Bremerton', 'WAZ010'),
('KHDE', 'Brewster Field Airport', 'US', 'United States', NULL, NULL),
('KBDR', 'Bridgeport, Sikorsky Memorial Airport', 'US', 'United States', 'Bridgeport', 'CTZ009'),
('KTRI', 'Bristol / Johnson / Kingsport, Tri-City Regional Airport', 'US', 'United States', 'Bristol', 'TNZ017'),
('KBBW', 'Broken Bow Municipal', 'US', 'United States', 'Broken Bow', 'NEZ038'),
('K4BK', 'Brookings', 'US', 'United States', 'Brookings', 'ORZ003'),
('KBKX', 'Brookings Automatic Weather Observing / Reporting System', 'US', 'United States', 'Brookings', 'SDZ040'),
('KBKV', 'Brooksville, Hernando County Airport', 'US', 'United States', 'Brooksville', 'FLZ048'),
('KBJC', 'Broomfield / Jeffco', 'US', 'United States', 'DenverBroomfield', 'COZ040'),
('KBRO', 'Brownsville, Brownsville / South Padre Island International Airport', 'US', 'United States', 'Brownsville', 'TXZ255'),
('KBQK', 'Brunswick / Glynco', 'US', 'United States', NULL, NULL),
('KSSI', 'Brunswick, McKinnon Airport', 'US', 'United States', 'St Simon\'s Island', 'GAZ154'),
('KNHZ', 'Brunswick, Naval Air Station', 'US', 'United States', 'Brunswick', 'MEZ024'),
('KBCE', 'Bryce Canyon, Bryce Canyon Airport', 'US', 'United States', 'Bryce Canyon', 'UTZ020'),
('PABL', 'Buckland, Buckland Airport', 'US', 'United States', NULL, NULL),
('KBKF', 'Buckley Air National Guard Base / Denver', 'US', 'United States', 'DenverAurora Buckley Air Force Base', 'COZ040'),
('K2WX', 'Buffalo', 'US', 'United States', NULL, NULL),
('KBUF', 'Buffalo, Greater Buffalo International Airport', 'US', 'United States', 'Buffalo', 'NYZ010'),
('KBYG', 'Buffalo, Johnson County Airport', 'US', 'United States', NULL, NULL),
('KU17', 'Bullfrog Marina', 'US', 'United States', 'Bullfrog', 'UTZ021'),
('KBUR', 'Burbank, Burbank-Glendale-Pasadena Airport', 'US', 'United States', 'Burbank', 'CAZ047'),
('KBYI', 'Burley, Burley Municipal Airport', 'US', 'United States', 'Burley', 'IDZ022'),
('K75S', 'Burlington / Mt Vern', 'US', 'United States', 'Burlington', 'WAZ005'),
('KBUY', 'Burlington, Burlington Alamance Regional Airport', 'US', 'United States', NULL, NULL),
('KBTV', 'Burlington, Burlington International Airport', 'US', 'United States', 'Burlington', 'VTZ005'),
('KBRL', 'Burlington, Burlington Regional Airport', 'US', 'United States', 'Burlington', 'IAZ089'),
('KITR', 'Burlington, Carson County Airport', 'US', 'United States', NULL, NULL),
('KBMQ', 'Burnet, Burnet Municipal Craddock Field', 'US', 'United States', 'Burnet', ''),
('KBNO', 'Burns, Burns Municipal Airport', 'US', 'United States', 'Burns', 'ORZ022'),
('KBTP', 'Butler County Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KBTM', 'Butte, Mooney Airport', 'US', 'United States', 'Butte', 'MTZ007'),
('KCAD', 'Cadillac / Wexford County', 'US', 'United States', NULL, NULL),
('KCPS', 'Cahokia / St. Louis, St. Louis Downtown-Parks Airport', 'US', 'United States', 'East St Louis', 'ILZ101'),
('KOZR', 'Cairns Army Air Field / Ozark', 'US', 'United States', 'Ozark', 'ALZ066'),
('KEUL', 'Caldwell Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KCDW', 'Caldwell, Essex County Airport', 'US', 'United States', 'Caldwell', 'NJZ005'),
('KP38', 'Caliente', 'US', 'United States', 'Caliente', 'NVZ015'),
('KCMA', 'Camarillo Automatic Weather Observing / Reporting System', 'US', 'United States', 'Camarillo', 'CAZ040'),
('KCBG', 'Cambridge Municipal', 'US', 'United States', NULL, NULL),
('K7R5', 'Cameron Heliport', 'US', 'United States', 'Cameron', 'LAZ051'),
('KADW', 'Camp Springs / Andrews Air Force Base', 'US', 'United States', 'Andrews AFB', 'MDZ013'),
('KCZZ', 'Campo', 'US', 'United States', 'Campo', 'CAZ058'),
('KCVS', 'Cannon Air Force Base / Clovis', 'US', 'United States', 'ClovisCannon AFB', 'NMZ021'),
('PATW', 'Cantwell', 'US', 'United States', 'Cantwell', 'AKZ004'),
('KCGI', 'Cape Girardeau, Cape Girardeau Regional Airport', 'US', 'United States', 'Cape Girardeau', 'MOZ087'),
('KHAT', 'Cape Hatteras', 'US', 'United States', 'Cape Hatteras', 'NCZ047'),
('KXMR', 'Cape Kennedy', 'US', 'United States', NULL, NULL),
('PALU', 'Cape Lisburne Airways Facilities Sector', 'US', 'United States', 'Cape Lisburne', ''),
('PAEH', 'Cape Newenham Airways Facilities Sector', 'US', 'United States', 'Cape Newenham', ''),
('PACZ', 'Cape Romanzoff Airways Facilities Sector', 'US', 'United States', 'Cape Romanzoff', ''),
('PACP', 'Cape Saint Elias', 'US', 'United States', NULL, NULL),
('KMDH', 'Carbondale / Murphysboro, Southern Illinois Airport', 'US', 'United States', 'Carbondale', 'ILZ084'),
('KCAR', 'Caribou, Caribou Municipal Airport', 'US', 'United States', 'Caribou', 'MEZ002'),
('KCNM', 'Carlsbad, Cavern City Air Terminal', 'US', 'United States', 'Carlsbad', 'NMZ028'),
('KCRQ', 'Carlsbad, McClellan-Palomar Airport', 'US', 'United States', 'Carlsbad', 'CAZ043'),
('KCIN', 'Carroll', 'US', 'United States', 'Carroll', 'IAZ045'),
('KCGZ', 'Casa Granda Automatic Weather Observing / Reporting System', 'US', 'United States', 'Casa Grande', 'AZZ028'),
('KCZK', 'Cascade Locks State', 'US', 'United States', 'Cascade', 'ORZ015'),
('KCPR', 'Casper, Natrona County International Airport', 'US', 'United States', 'Casper', 'WYZ064'),
('KNZC', 'Cecil, Naval Air Station', 'US', 'United States', 'Cecil Field NAS', 'FLZ025'),
('KCDC', 'Cedar City, Cedar City Municipal Airport', 'US', 'United States', 'Cedar City', 'UTZ016'),
('KCID', 'Cedar Rapids, Cedar Rapids Municipal Airport', 'US', 'United States', 'Cedar Rapids', 'IAZ052'),
('KCKL', 'Centreville', 'US', 'United States', NULL, NULL),
('KCDR', 'Chadron, Chadron Municipal Airport', 'US', 'United States', 'Chadron', 'NEZ002'),
('KU15', 'Challis, Challis Airport', 'US', 'United States', 'Challis', 'IDZ018'),
('KE33', 'Chama', 'US', 'United States', NULL, NULL),
('K9V9', 'Chamberlain, Chamberlain Municipal Airport', 'US', 'United States', 'Chamberlain', 'SDZ057'),
('KCMI', 'Champaign / Urbana, University Of Illinois-Willard Airport', 'US', 'United States', 'Champaign', 'ILZ045'),
('PALR', 'Chandalar Lake', 'US', 'United States', 'Chandalar Lake', 'AKZ004'),
('KCNU', 'Chanute, Chanute Martin Johnson Airport', 'US', 'United States', 'Chanute', 'KSZ096'),
('KCNC', 'Chariton', 'US', 'United States', 'Chariton', 'IAZ084'),
('KCCY', 'Charles City', 'US', 'United States', 'Charles City', 'IAZ018'),
('KCHS', 'Charleston, Charleston Air Force Base', 'US', 'United States', 'Charleston', 'SCZ050'),
('KCRW', 'Charleston, Yeager Airport', 'US', 'United States', 'Charleston', 'WVZ015'),
('KCLT', 'Charlotte, Charlotte / Douglas International Airport', 'US', 'United States', 'Charlotte', 'NCZ071'),
('KCHO', 'Charlottesville, Charlottesville-Albemarle Airport', 'US', 'United States', 'Charlottesville', 'VAZ037'),
('KCHH', 'Chatham', 'US', 'United States', NULL, NULL),
('KCQX', 'Chatham, Chatham Municipal Airport', 'US', 'United States', 'Chatham', 'MAZ022'),
('KCHA', 'Chattanooga, Lovell Field', 'US', 'United States', 'Chattanooga', 'TNZ099'),
('KCWF', 'Chenault Airpark', 'US', 'United States', NULL, NULL),
('KNKT', 'Cherry Point, Marine Corps Air Station', 'US', 'United States', 'Cherry Point', ''),
('KCYS', 'Cheyenne, Cheyenne Airport', 'US', 'United States', 'Cheyenne', 'WYZ069'),
('KCGX', 'Chicago / Meigs', 'US', 'United States', 'ChicagoLakefront', 'ILZ014'),
('KUGN', 'Chicago / Waukegan', 'US', 'United States', NULL, NULL),
('KDPA', 'Chicago / West Chicago, Dupage Airport', 'US', 'United States', 'ChicagoDuPage', 'ILZ014'),
('KPWK', 'Chicago / Wheeling, Pal-Waukee Airport', 'US', 'United States', NULL, NULL),
('KMDW', 'Chicago, Chicago Midway Airport', 'US', 'United States', 'ChicagoMidway', 'ILZ014'),
('KORD', 'Chicago, Chicago-O\\\'Hare International Airport', 'US', 'United States', 'ChicagoO\'Hare', 'ILZ013'),
('KCIC', 'Chico Municipal', 'US', 'United States', 'Chico', 'CAZ016'),
('KCEF', 'Chicopee Falls / Westover Air Force Base', 'US', 'United States', 'Chicopee Falls', ''),
('KCDS', 'Childress, Childress Municipal Airport', 'US', 'United States', 'Childress', 'TXZ026'),
('KCDJ', 'Chillicothe, Chillicothe Agri-Science Center', 'US', 'United States', NULL, NULL),
('KNID', 'China Lake, Naval Air Facility', 'US', 'United States', 'China Lake', 'CAZ028'),
('KCNO', 'Chino, Chino Airport', 'US', 'United States', 'Chino', 'CAZ048'),
('KCIU', 'Chippewa International Automatic Weather Observing / Reporting System', 'US', 'United States', 'Chippewa County', 'MIZ008'),
('PAEC', 'Chulitna', 'US', 'United States', 'Chulitna', ''),
('KLUK', 'Cincinnati, Cincinnati Municipal Airport Lunken Field', 'US', 'United States', 'Cincinnati', 'OHZ077'),
('PACR', 'Circle City Airport', 'US', 'United States', 'Circle City', 'AKZ004'),
('K01R', 'Claiborne Range, Airways Facilit', 'US', 'United States', NULL, NULL),
('KICL', 'Clarinda', 'US', 'United States', 'Clarinda', 'IAZ091'),
('KCAV', 'Clarion', 'US', 'United States', 'Clarion', 'IAZ025'),
('KCKB', 'Clarksburg, Benedum Airport', 'US', 'United States', 'Clarksburg', 'WVZ031'),
('K40B', 'Clayton Lake', 'US', 'United States', 'Clayton Lake', ''),
('KCAO', 'Clayton, Clayton Municipal Airpark', 'US', 'United States', 'Clayton', 'NMZ007'),
('KN97', 'Clearfield, Clearfield-Lawrence Airport', 'US', 'United States', NULL, NULL),
('KCGF', 'Cleveland / Cuyahoga', 'US', 'United States', 'Cleveland/Cuyahoga', 'OHZ011'),
('KBKL', 'Cleveland, Burke Lakefront Airport', 'US', 'United States', 'ClevelandLakefront', 'OHZ011'),
('KCLE', 'Cleveland, Cleveland-Hopkins International Airport', 'US', 'United States', 'Cleveland', 'OHZ011'),
('KCQC', 'Clines Corner', 'US', 'United States', NULL, NULL),
('KCWI', 'Clinton Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Clinton', 'IAZ066'),
('KCSM', 'Clinton, Clinton-Sherman Airport', 'US', 'United States', 'Clinton', 'OKZ016'),
('KCOQ', 'Cloquet Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KCVN', 'Clovis Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KCOF', 'Cocoa / Patrick Air Force Base', 'US', 'United States', 'Cocoa Beach', 'FLZ047'),
('KCOD', 'Cody', 'US', 'United States', 'Cody', 'WYZ002'),
('KCOE', 'Coeur D\\\'Alene Automatic Weather Observing / Reporting System', 'US', 'United States', 'Coeur d\'Alene', 'IDZ002'),
('KCFV', 'Coffeyville, Coffeyville Municipal Airport', 'US', 'United States', NULL, NULL),
('PACD', 'Cold Bay, Cold Bay Airport', 'US', 'United States', 'Cold Bay', 'AKZ020'),
('KCLL', 'College Station, Easterwood Field', 'US', 'United States', 'College Station', 'TXZ196'),
('KCOS', 'Colorado Springs, City Of Colorado Springs Municipal Airport', 'US', 'United States', 'Colorado Springs', 'COZ071'),
('KCAE', 'Columbia, Columbia Metropolitan Airport', 'US', 'United States', 'Columbia', 'SCZ028'),
('KCUB', 'Columbia, Columbia Owens Downtown Airport', 'US', 'United States', NULL, NULL),
('KCOU', 'Columbia, Columbia Regional Airport', 'US', 'United States', 'Columbia', 'MOZ041'),
('KBAK', 'Columbus / Balkalar', 'US', 'United States', NULL, NULL),
('KCBM', 'Columbus Air Force Base', 'US', 'United States', 'ColumbusW PointStarkville', 'MSZ031'),
('KOLU', 'Columbus Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Columbus', 'NEZ042'),
('KCSG', 'Columbus, Columbus Metropolitan Airport', 'US', 'United States', 'Columbus', 'GAZ089'),
('KOSU', 'Columbus, Ohio State University Airport', 'US', 'United States', 'ColumbusOSU', 'OHZ055'),
('KCMH', 'Columbus, Port Columbus International Airport', 'US', 'United States', 'ColumbusGahanna', 'OHZ055'),
('KCQV', 'Colville Municipal', 'US', 'United States', NULL, NULL),
('KCCR', 'Concord, Buchanan Field', 'US', 'United States', 'Concord', 'CAZ007'),
('KCON', 'Concord, Concord Municipal Airport', 'US', 'United States', 'Concord', 'NHZ008'),
('KCNK', 'Concordia, Blosser Municipal Airport', 'US', 'United States', 'Concordia', 'KSZ020'),
('KCXO', 'Conroe, Montgomery County Airport', 'US', 'United States', 'Conroe', ''),
('KP59', 'Copper Harbor', 'US', 'United States', 'Copper Harbor', 'MIZ003'),
('PACV', 'Cordova / Mile 13', 'US', 'United States', 'Cordova', 'AKZ017'),
('K4CR', 'Corona / Lincoln', 'US', 'United States', 'Corona', 'NMZ016'),
('KCRP', 'Corpus Christi, Corpus Christi International Airport', 'US', 'United States', 'Corpus Christi', 'TXZ243'),
('KNGP', 'Corpus Christi, Naval Air Station', 'US', 'United States', 'Corpus Christi NAS', 'TXZ243'),
('KCRS', 'Corsicana, Campbell Field-Corsicana Municipal Airport', 'US', 'United States', 'Corsicana', 'TXZ146'),
('KCEZ', 'Cortez, Cortez-Montezuma County Airport', 'US', 'United States', 'Cortez', 'COZ021'),
('KCVO', 'Corvallis Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KCOT', 'Cotulla, Cotulla-La Salle County Airport', 'US', 'United States', 'Cotulla', 'TXZ229'),
('KCBF', 'Council Bluffs', 'US', 'United States', 'Council Bluffs', 'IAZ069'),
('KCVG', 'Covington / Cincinnati, Cincinnati / Northern Kentucky International Airport', 'US', 'United States', 'Covington', 'KYZ092'),
('KCAG', 'Craig, Craig-Moffat Airport', 'US', 'United States', 'Craig', 'COZ002'),
('KCEC', 'Crescent City', 'US', 'United States', 'Crescent City', 'CAZ001'),
('KCSQ', 'Creston', 'US', 'United States', 'Creston', 'IAZ082'),
('KCEW', 'Crestview, Sikes Airport', 'US', 'United States', 'Crestview', 'FLZ006'),
('KCKN', 'Crookston Municipal Field', 'US', 'United States', NULL, NULL),
('KCTY', 'Cross City, Cross City Airport', 'US', 'United States', 'Cross City', 'FLZ034'),
('KCSV', 'Crossville, Crossville Memorial Airport', 'US', 'United States', 'Crossville', 'TNZ066'),
('K4CB', 'Cuddleback Gunnery Range', 'US', 'United States', NULL, NULL),
('K0V1', 'Custer, Custer County Airport', 'US', 'United States', 'Custer', 'SDZ029'),
('KCTB', 'Cut Bank Automatic Weather Observing / Reporting System', 'US', 'United States', 'Cut Bank', 'MTZ010'),
('KDAG', 'Daggett, Barstow-Daggett Airport', 'US', 'United States', 'Daggett', 'CAZ028'),
('KDHT', 'Dalhart, Dalhart Municipal Airport', 'US', 'United States', 'Dalhart', 'TXZ001'),
('KADS', 'Dallas / Addison Airport', 'US', 'United States', 'DallasAddison', 'TXZ119'),
('KDFW', 'Dallas / Fort Worth, Dallas / Fort Worth International Airport', 'US', 'United States', 'DallasFort Worth', 'TXZ119'),
('KDAL', 'Dallas, Dallas Love Field', 'US', 'United States', 'DallasLove Field', 'TXZ119'),
('KRBD', 'Dallas, Redbird Airport', 'US', 'United States', 'DallasRedbird', 'TXZ119'),
('KDXR', 'Danbury, Danbury Municipal Airport', 'US', 'United States', 'Danbury', 'CTZ009'),
('KDAN', 'Danville, Danville Regional Airport', 'US', 'United States', 'Danville', 'VAZ044'),
('K2DP', 'Dare County Gunnery Range', 'US', 'United States', 'Stumpy Point', ''),
('KDVN', 'Davenport, Davenport Municipal Airport', 'US', 'United States', 'Davenport', 'IAZ068'),
('KDMA', 'Davis-Monthan Air Force Base', 'US', 'United States', 'TucsonDavis AFB', 'AZZ033'),
('KFFO', 'Dayton / Wright-Patterson Air Force Base', 'US', 'United States', 'DaytonFairborn', 'OHZ061'),
('KDAY', 'Dayton, Cox Dayton International Airport', 'US', 'United States', 'Dayton', 'OHZ061'),
('KMGY', 'Dayton, Dayton General Airport South Airport', 'US', 'United States', 'DaytonSouth Airport', 'OHZ061'),
('KDAB', 'Daytona Beach, Daytona Beach Regional Airport', 'US', 'United States', 'Daytona Beach', 'FLZ041'),
('PASC', 'Deadhorse', 'US', 'United States', 'Dead Horse', 'AKZ001'),
('KDEC', 'Decatur, Decatur Airport', 'US', 'United States', 'Decatur', 'ILZ053'),
('KDCU', 'Decatur, Pryor Field', 'US', 'United States', 'Decatur', ''),
('KDEH', 'Decorah', 'US', 'United States', 'Decorah', 'IAZ010'),
('KDEW', 'Deer Park, Deer Park Airport', 'US', 'United States', NULL, NULL),
('PADE', 'Deering', 'US', 'United States', NULL, NULL),
('KDFI', 'Defiance, Defiance Memorial Airport', 'US', 'United States', NULL, NULL),
('KDRT', 'Del Rio, Del Rio International Airport', 'US', 'United States', 'Del Rio', 'TXZ183'),
('KU24', 'Delta', 'US', 'United States', 'Delta', 'UTZ015'),
('KDMN', 'Deming, Deming Municipal Airport', 'US', 'United States', 'Deming', 'NMZ031'),
('KDNS', 'Denison', 'US', 'United States', 'Denison', 'IAZ044'),
('KDTO', 'Denton, Denton Municipal Airport', 'US', 'United States', 'Denton', ''),
('KDNR', 'Denver / Stapleton International', 'US', 'United States', NULL, NULL),
('KAPA', 'Denver, Centennial Airport', 'US', 'United States', 'Denver Centennial Airport', 'COZ040'),
('KDEN', 'Denver, Denver International Airport', 'US', 'United States', 'Denver International Airport', 'COZ040'),
('KDSM', 'Des Moines, Des Moines International Airport', 'US', 'United States', 'Des Moines', 'IAZ060'),
('KDTS', 'Destin, Destin-Ft. Walton Beach Airport', 'US', 'United States', 'Destin', ''),
('KDTL', 'Detroit Lakes Automatic Weather Observing / Reporting System', 'US', 'United States', 'Detroit Lakes', 'MNZ027'),
('KDET', 'Detroit, Detroit City Airport', 'US', 'United States', 'Detroit', 'MIZ076'),
('KDTW', 'Detroit, Detroit Metropolitan Wayne County Airport', 'US', 'United States', 'DetroitTaylor', 'MIZ076'),
('KYIP', 'Detroit, Willow Run Airport', 'US', 'United States', 'Ypsilanti', 'MIZ075'),
('KP11', 'Devils Lake', 'US', 'United States', 'Devils Lake (2)', 'NDZ015'),
('KDVL', 'Devils Lake Automatic Weather Observing / Reporting System', 'US', 'United States', 'Devils Lake', 'NDZ015'),
('K44W', 'Diamond Shoals Coast Guard Stati', 'US', 'United States', NULL, NULL),
('KDIK', 'Dickinson, Dickinson Municipal Airport', 'US', 'United States', 'Dickinson', 'NDZ033'),
('PADL', 'Dillingham Municipal, Ak', 'US', 'United States', 'Dillingham', 'AKZ010'),
('KDLN', 'Dillon, Dillon Airport', 'US', 'United States', 'Dillon', 'MTZ008'),
('KDDC', 'Dodge City, Dodge City Regional Airport', 'US', 'United States', 'Dodge City', 'KSZ078'),
('KDHN', 'Dothan, Dothan Airport', 'US', 'United States', 'Dothan', 'ALZ066'),
('KDUG', 'Douglas Bisbee International', 'US', 'United States', 'Douglas', 'AZZ030'),
('KDGW', 'Douglas, Converse County Airport', 'US', 'United States', NULL, NULL),
('KDOV', 'Dover Air Force Base', 'US', 'United States', 'Dover', 'DEZ002'),
('K3DU', 'Drummond', 'US', 'United States', 'Drummond', 'MTZ006'),
('KDUJ', 'Du Bois Automatic Weather Observing / Reporting System', 'US', 'United States', 'Du Bois', 'PAZ017'),
('KPSK', 'Dublin / New River Valley', 'US', 'United States', 'Dublin', 'VAZ013'),
('KDBQ', 'Dubuque, Dubuque Regional Airport', 'US', 'United States', 'Dubuque', 'IAZ042'),
('KDPG', 'Dugway Proving Grounds', 'US', 'United States', 'Dugway', 'UTZ005'),
('KEGI', 'Duke Field / Eglin Auxiliary', 'US', 'United States', 'ValparaisoEglin AFB', 'FLZ006'),
('KDLH', 'Duluth, Duluth International Airport', 'US', 'United States', 'Duluth', 'MNZ019'),
('KDKK', 'Dunkirk, Chautauqua County / Dunkirk Airport', 'US', 'United States', NULL, NULL),
('KDRO', 'Durango, Durango-La Plata County Airport', 'US', 'United States', 'Durango', 'COZ022'),
('PADU', 'Dutch Harbor', 'US', 'United States', 'Dutch Harbor', 'AKZ020'),
('KDYR', 'Dyersburg Automatic Weather Observing / Reporting System', 'US', 'United States', 'Dyersburg', 'TNZ019'),
('KEGE', 'Eagle County Regional', 'US', 'United States', 'Eagle', 'COZ010'),
('KBYH', 'Eaker Air Force Base', 'US', 'United States', NULL, NULL),
('KEPO', 'Eastport', 'US', 'United States', NULL, NULL),
('KEAU', 'Eau Claire County Airport', 'US', 'United States', 'Eau Claire', 'WIZ028'),
('KEDW', 'Edwards Air Force Base', 'US', 'United States', 'Edwards AFB', 'CAZ025'),
('PAII', 'Egegik Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KNJK', 'El Centro, Naval Air Facility', 'US', 'United States', 'El Centro', 'CAZ033'),
('KELD', 'El Dorado, South Arkansas Regional Airport', 'US', 'United States', 'El Dorado', 'ARZ073'),
('KEMT', 'El Monte', 'US', 'United States', 'El Monte', 'CAZ047'),
('KELP', 'El Paso, El Paso International Airport', 'US', 'United States', 'El Paso', 'TXZ055'),
('PAEL', 'Elfin Cove Seaplane', 'US', 'United States', 'Elfin Cove', 'AKZ022'),
('KECG', 'Elizabeth City, Elizabeth City Coast Guard Air Station', 'US', 'United States', 'Elizabeth City', 'NCZ016'),
('K1K5', 'Elkhart / Elkhart-Morton County', 'US', 'United States', 'Elkhart', 'KSZ084'),
('KEHA', 'Elkhart Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KEKM', 'Elkhart Municipal', 'US', 'United States', 'Elkhart', 'INZ005'),
('KEKN', 'Elkins, Elkins-Randolph County-Jennings Randolph Field', 'US', 'United States', 'Elkins', 'WVZ047'),
('KEKO', 'Elko, Elko Municipal-Harris Field', 'US', 'United States', 'Elko', 'NVZ008'),
('KELN', 'Ellensburg, Bowers Field', 'US', 'United States', NULL, NULL),
('KRCA', 'Ellsworth Air Force Base', 'US', 'United States', 'Rapid CityEllsworth AFB', 'SDZ031'),
('KELM', 'Elmira, Elmira / Corning Regional Airport', 'US', 'United States', 'Elmira', 'NYZ024'),
('KELO', 'Ely Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Ely', 'MNZ019'),
('KELY', 'Ely, Ely Airport', 'US', 'United States', 'Ely', 'NVZ011'),
('KBLU', 'Emigrant Gap, Blue Canyon Nyack Airport', 'US', 'United States', 'Blue Canyon', ''),
('PAEM', 'Emmonak', 'US', 'United States', 'Emmonak', ''),
('KEMP', 'Emporia, Emporia Municipal Airport', 'US', 'United States', 'Emporia', 'KSZ054'),
('KWDG', 'Enid / Woodring Municipal', 'US', 'United States', 'Enid/Woodring', 'OKZ012'),
('KEPH', 'Ephrata, Ephrata Municipal Airport', 'US', 'United States', 'Ephrata', 'WAZ033'),
('KERI', 'Erie, Erie International Airport', 'US', 'United States', 'Erie', 'PAZ002'),
('KESC', 'Escanaba', 'US', 'United States', 'Escanaba', 'MIZ013'),
('KEST', 'Estherville, Estherville Municipal Airport', 'US', 'United States', 'Estherville', 'IAZ004'),
('KEUG', 'Eugene, Mahlon Sweet Field', 'US', 'United States', 'Eugene', 'ORZ008'),
('PAZK', 'Eureka', 'US', 'United States', NULL, NULL),
('KEKA', 'Eureka', 'US', 'United States', NULL, NULL),
('KEVW', 'Evanston, Evanston-Uinta County Burns Field', 'US', 'United States', 'Evanston', 'WYZ021'),
('KEVV', 'Evansville, Evansville Regional Airport', 'US', 'United States', 'Evansville', 'INZ086'),
('KEVM', 'Eveleth Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KPAE', 'Everett, Snohomish County Airport', 'US', 'United States', 'Everett', 'WAZ006'),
('KGZH', 'Evergreen, Middleton Field', 'US', 'United States', 'Evergreen', ''),
('KFFL', 'Fair Field', 'US', 'United States', 'Fairfield', 'IAZ087'),
('PAEI', 'Fairbanks / Eielson Air Force Base', 'US', 'United States', 'Farbanks/Eielson AFB', 'AKZ007'),
('PAFA', 'Fairbanks, Fairbanks International Airport', 'US', 'United States', 'Fairbanks', 'AKZ007'),
('KSKA', 'Fairchild Air Force Base', 'US', 'United States', 'Fairchild', ''),
('KSUU', 'Fairfield / Travis Air Force Base', 'US', 'United States', 'Fairfield', 'CAZ018'),
('KFRM', 'Fairmont Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Fairmont', 'MNZ091'),
('KD07', 'Faith', 'US', 'United States', NULL, NULL),
('KNFL', 'Fallon, Naval Air Station', 'US', 'United States', 'Fallon', 'NVZ004'),
('KFNB', 'Falls City / Brenner', 'US', 'United States', 'Falls City', 'NEZ093'),
('K50Q', 'Farallon Island', 'US', 'United States', NULL, NULL),
('KFAR', 'Fargo, Hector International Airport', 'US', 'United States', 'Fargo', 'NDZ039'),
('KFBL', 'Faribault Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KFRG', 'Farmingdale, Republic Airport', 'US', 'United States', 'Farmingdale', 'NYZ077'),
('KFAM', 'Farmington Airport', 'US', 'United States', NULL, NULL),
('KFMN', 'Farmington, Four Corners Regional Airport', 'US', 'United States', 'Farmington', 'NMZ001'),
('KFVX', 'Farmville', 'US', 'United States', 'Farmville', 'VAZ061'),
('KFYV', 'Fayetteville, Drake Field', 'US', 'United States', 'Fayetteville', 'ARZ010'),
('KFAY', 'Fayetteville, Fayetteville Regional Airport', 'US', 'United States', 'Fayetteville', 'NCZ088'),
('KFFM', 'Fergus Falls Automatic Weather Observing / Reporting System', 'US', 'United States', 'Fergus Falls', 'MNZ031'),
('KFDY', 'Findlay Automatic Weather Observing / Reporting System', 'US', 'United States', 'Findlay', 'OHZ017'),
('KFIT', 'Fitchburg, Fitchburg Municipal Airport', 'US', 'United States', 'Fitchburg', ''),
('KFLG', 'Flagstaff, Flagstaff Pulliam Airport', 'US', 'United States', 'Flagstaff', 'AZZ015'),
('KFNT', 'Flint, Bishop International Airport', 'US', 'United States', 'Flint', 'MIZ061'),
('KFLP', 'Flippin Automatic Weather Observing / Reporting System', 'US', 'United States', 'Flippin', 'ARZ004'),
('KFLO', 'Florence, Florence Regional Airport', 'US', 'United States', 'Florence', 'SCZ032'),
('KFLD', 'Fond Du Lac, Fond Du Lac County Airport', 'US', 'United States', 'Fond Du Lac', 'WIZ051'),
('KDAA', 'Fort Belvoir', 'US', 'United States', 'Fort Belvoir', 'VAZ053'),
('KLSF', 'Fort Benning', 'US', 'United States', 'Fort Benning', 'GAZ090'),
('KO64', 'Fort Bragg', 'US', 'United States', NULL, NULL),
('KFBG', 'Fort Bragg / Simmons Army Airfield', 'US', 'United States', 'Fort Bragg', 'NCZ088'),
('KHOP', 'Fort Campbell U. S. Army Airfield', 'US', 'United States', 'Fort Campbell', 'KYZ017'),
('KFCS', 'Fort Carson', 'US', 'United States', 'Fort Carson', 'COZ071'),
('KFNL', 'Fort Collins Automatic Weather Observing / Reporting System', 'US', 'United States', 'Fort Collins/Lovel', 'COZ035'),
('KFOD', 'Fort Dodge', 'US', 'United States', 'Fort Dodge', 'IAZ035'),
('KGTB', 'Fort Drum / Wheeler-Sack U. S. Army Airfield', 'US', 'United States', 'Fort Drum', 'NYZ007'),
('KFAF', 'Fort Eustis / Felker', 'US', 'United States', 'Fort Eustis', ''),
('PABI', 'Fort Greely / Allen U. S. Army Airfield, Ak', 'US', 'United States', 'Fort Greely/Allen AAF', ''),
('KHLR', 'Fort Hood', 'US', 'United States', 'KilleenFt Hood', 'TXZ158'),
('KGRK', 'Fort Hood / Gray U. S. Army Airfield', 'US', 'United States', 'KilleenGray AAF', 'TXZ158'),
('KFHU', 'Fort Huachuca', 'US', 'United States', 'Fort Huachuca', 'AZZ035'),
('KFTK', 'Fort Knox', 'US', 'United States', 'Fort Knox', 'KYZ028'),
('KFLL', 'Fort Lauderdale, Fort Lauderdale / Hollywood International Airport', 'US', 'United States', 'Fort Lauderdale (International)', 'FLZ072'),
('KFXE', 'Fort Lauderdale, Fort Lauderdale Executive Airport', 'US', 'United States', 'Fort Lauderdale', 'FLZ072'),
('KFLV', 'Fort Leavenworth', 'US', 'United States', NULL, NULL),
('KTBN', 'Fort Leonard Wood', 'US', 'United States', 'Fort Leonard', 'MOZ070'),
('KGRF', 'Fort Lewis / Gray U. S. Army Airfield', 'US', 'United States', 'Fort Lewis', 'WAZ008'),
('KFSW', 'Fort Madison', 'US', 'United States', 'Fort Madison', 'IAZ099'),
('KFMY', 'Fort Myers, Page Field', 'US', 'United States', 'Fort Myers (Page Field)', 'FLZ065'),
('KRSW', 'Fort Myers, Southwest Florida International Airport', 'US', 'United States', 'Fort Myers (Southwest Florida Internatio', 'FLZ065'),
('KFPR', 'Fort Pierce, St. Lucie County International Airport', 'US', 'United States', NULL, NULL),
('KPOE', 'Fort Polk', 'US', 'United States', 'Fort PolkLeesville', 'LAZ027'),
('KFRI', 'Fort Riley', 'US', 'United States', 'Fort Riley', 'KSZ036'),
('KJWX', 'Fort Ritchie', 'US', 'United States', NULL, NULL),
('KFSI', 'Fort Sill', 'US', 'United States', 'Fort Sill', 'OKZ038'),
('KFSM', 'Fort Smith, Fort Smith Regional Airport', 'US', 'United States', 'Fort Smith', ''),
('KFST', 'Fort Stockton, Fort Stockton-Pecos County Airport', 'US', 'United States', 'Fort Stockton', 'TXZ075'),
('KFWA', 'Fort Wayne, Fort Wayne International Airport', 'US', 'United States', 'Fort Wayne', 'INZ018'),
('KFWD', 'Fort Worth', 'US', 'United States', NULL, NULL),
('KAFW', 'Fort Worth, Fort Worth Alliance Airport', 'US', 'United States', 'Fort WorthAlliance', 'TXZ118'),
('KFTW', 'Fort Worth, Meacham International Airport', 'US', 'United States', 'Fort WorthMeacham', 'TXZ118'),
('KNFW', 'Fort Worth, Naval Air Station', 'US', 'United States', 'Fort Worth NAS', 'TXZ118'),
('PFYU', 'Fort Yukon', 'US', 'United States', NULL, NULL),
('KFSE', 'Fosston Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('K9F2', 'Fourchon Supplementary Aviation Weather Reporting Station', 'US', 'United States', 'Fourchon', ''),
('KFFT', 'Frankfort, Capital City Airport', 'US', 'United States', 'Frankfort', 'KYZ035'),
('KFKN', 'Franklin / J B Rose', 'US', 'United States', 'Franklin', 'VAZ092'),
('KFKL', 'Franklin Automatic Weather Observing / Reporting System', 'US', 'United States', 'Franklin', 'PAZ008'),
('KFDR', 'Frederick, Frederick Municipal Airport', 'US', 'United States', NULL, NULL),
('KFET', 'Fremont Municipal Airport', 'US', 'United States', NULL, NULL),
('KFVE', 'Frenchville, Northern Aroostook Regional Airport', 'US', 'United States', 'Frenchville', 'MEZ002'),
('KFAT', 'Fresno, Fresno Air Terminal', 'US', 'United States', 'Fresno', 'CAZ020'),
('KFCH', 'Fresno-Chandler', 'US', 'United States', 'FresnoChandler', 'CAZ020'),
('KFHR', 'Friday Harbor, Friday Harbor Airport', 'US', 'United States', 'Friday Harbor', 'WAZ001'),
('KIZG', 'Fryeburg, Eastern Slopes Regional Airport', 'US', 'United States', 'Fryeburg', ''),
('PAFR', 'Ft. Richardson / Bryant U. S. Ar', 'US', 'United States', NULL, NULL),
('KLHW', 'Ft. Stewart', 'US', 'United States', 'Fort Stewart', 'GAZ138'),
('KFUL', 'Fullerton, Fullerton Municipal Airport', 'US', 'United States', 'Fullerton', 'CAZ042'),
('KGAD', 'Gadsden Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Gadsden', 'ALZ018'),
('KGAG', 'Gage, Gage Airport', 'US', 'United States', 'Gage', 'OKZ009'),
('KGNV', 'Gainesville, Gainesville Regional Airport', 'US', 'United States', 'Gainesville', 'FLZ036'),
('KGVL', 'Gainesville, Gilmer Memorial Airport', 'US', 'United States', NULL, NULL),
('PAGB', 'Galbraith Lake', 'US', 'United States', 'Galbraith Lake', ''),
('PAGA', 'Galena A.', 'US', 'United States', 'Galena', ''),
('KGUP', 'Gallup, Gallup Municipal Airport', 'US', 'United States', 'Gallup', 'NMZ008'),
('KGLS', 'Galveston, Scholes Field', 'US', 'United States', 'Galveston', 'TXZ238'),
('PAGM', 'Gambell Automatic Weather Observing / Reporting System', 'US', 'United States', 'Gambell', 'AKZ006'),
('KGCK', 'Garden City, Garden City Regional Airport', 'US', 'United States', 'Garden City', 'KSZ063'),
('KN60', 'Garrison', 'US', 'United States', NULL, NULL),
('KGYY', 'Gary Regional', 'US', 'United States', 'Gary', 'INZ001'),
('KAKH', 'Gastonia, Gastonia Municipal Airport', 'US', 'United States', NULL, NULL),
('KGLR', 'Gaylord, Otsego County Airport', 'US', 'United States', NULL, NULL),
('KGTU', 'Georgetown Automatic Weather Observing / Reporting System', 'US', 'United States', 'Georgetown', 'TXZ173'),
('KGED', 'Georgetown, Sussex County Airport', 'US', 'United States', NULL, NULL),
('KGBN', 'Gila Bend U. S. Army Airfield', 'US', 'United States', 'Gila Bend', 'AZZ027'),
('KGCC', 'Gillette, Gillette-Campbell County Airport', 'US', 'United States', 'Gillette', 'WYZ054'),
('KGGW', 'Glasgow, Glasgow International Airport', 'US', 'United States', 'Glasgow', 'MTZ017'),
('KGDV', 'Glendive Automatic Weather Observing / Reporting System', 'US', 'United States', 'Glendive', 'MTZ025'),
('KGFL', 'Glens Falls, Warren County Airport', 'US', 'United States', 'Glens Falls', 'NYZ042'),
('KGHW', 'Glenwood Automatic Surface Observing System', 'US', 'United States', NULL, NULL),
('KGTR', 'Golden Tri Automatic Weather Observing / Reporting System', 'US', 'United States', 'Columbus', 'MSZ031'),
('KGLD', 'Goodland, Renner Field', 'US', 'United States', 'Goodland', 'KSZ013'),
('KGYR', 'Goodyear Municipal', 'US', 'United States', 'PhoenixGoodyear', 'AZZ023'),
('KGSH', 'Goshen, Goshen Municipal Airport', 'US', 'United States', NULL, NULL),
('KGCN', 'Grand Canyon, Grand Canyon National Park Airport', 'US', 'United States', 'Grand Canyon', 'AZZ006'),
('KRDR', 'Grand Forks Air Force Base', 'US', 'United States', NULL, NULL),
('KGFK', 'Grand Forks, Grand Forks International Airport', 'US', 'United States', 'Grand Forks', 'NDZ027'),
('KGRI', 'Grand Island, Central Nebraska Regional Airport', 'US', 'United States', 'Grand Island', 'NEZ062'),
('KAXO', 'Grand Isle Supplementary Aviation Weather Reporting Station', 'US', 'United States', 'Grand Isle', 'LAZ061'),
('KGJT', 'Grand Junction, Walker Field', 'US', 'United States', 'Grand Junction', 'COZ006'),
('KP61', 'Grand Marais', 'US', 'United States', 'Grand Marais', 'MNZ021'),
('KGNA', 'Grand Marais, The Bay of Grand Marais', 'US', 'United States', NULL, NULL),
('KGPZ', 'Grand Rapids Automatic Weather Observing / Reporting System', 'US', 'United States', 'Grand Rapids', 'MNZ026'),
('KGRR', 'Grand Rapids, Kent County International Airport', 'US', 'United States', 'Grand Rapids', 'MIZ057'),
('KS80', 'Grangeville', 'US', 'United States', 'Grangeville', 'IDZ007'),
('KGNT', 'Grants, Grants-Milan Municipal Airport', 'US', 'United States', 'Grants', 'NMZ008'),
('K3RN', 'Graying Air Force Range', 'US', 'United States', NULL, NULL),
('KGBD', 'Great Bend Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KGTF', 'Great Falls, Great Falls International Airport', 'US', 'United States', NULL, NULL),
('KGXY', 'Greeley / Weld Automatic Weather Observing / Reporting System', 'US', 'United States', 'Greeley', 'COZ043'),
('KGRB', 'Green Bay, Austin Straubel International Airport', 'US', 'United States', 'Green Bay', 'WIZ039'),
('KU28', 'Green River Range', 'US', 'United States', 'Green River', 'UTZ013'),
('KGSO', 'Greensboro, Piedmont Triad International Airport', 'US', 'United States', 'Greensboro', 'NCZ022'),
('KGVT', 'Greenville / Majors', 'US', 'United States', 'Greenville', ''),
('KGMU', 'Greenville, Greenville Downtown Airport', 'US', 'United States', 'Greenville', 'SCZ006'),
('KGLH', 'Greenville, Greenville Municipal Airport', 'US', 'United States', 'Greenville', ''),
('KGWO', 'Greenwood, Greenwood-LeFlore Airport', 'US', 'United States', 'Greenwood', 'MSZ025'),
('KGSP', 'Greer, Greenville-Spartanburg Airport', 'US', 'United States', 'GreenvilleSpartanburg', 'SCZ007'),
('KGEY', 'Greybull, South Big Horn County Airport', 'US', 'United States', NULL, NULL),
('KRME', 'Griffiss Air Force Base / Rome', 'US', 'United States', 'Griffiss AFB', ''),
('KGUS', 'Grissom Air Force Base / Peru', 'US', 'United States', 'Peru', 'INZ023'),
('KGON', 'Groton / New London, Groton-New London Airport', 'US', 'United States', 'Groton', 'CTZ012'),
('KGPT', 'Gulfport, Gulfport-Biloxi Regional Airport', 'US', 'United States', 'Gulfport', 'MSZ081'),
('PAGK', 'Gulkana / Intl. Fld.', 'US', 'United States', 'Gulkana', 'AKZ015'),
('KGUC', 'Gunnison Automatic Weather Observing / Reporting System', 'US', 'United States', 'Gunnison', 'COZ012'),
('PAGS', 'Gustavus', 'US', 'United States', 'Gustavus', 'AKZ024'),
('KGOK', 'Guthrie, Guthrie Municipal Airport', 'US', 'United States', NULL, NULL),
('KGUY', 'Guymon / Guymon Municipal Airport', 'US', 'United States', 'Guymon', ''),
('KHGR', 'Hagerstown, Washington County Regional Airport', 'US', 'United States', 'Hagerstown', 'MDZ003'),
('KSUN', 'Hailey / Friedman Memorial', 'US', 'United States', 'HaileySun Valley', 'IDZ018'),
('PAHN', 'Haines', 'US', 'United States', 'Haines', 'AKZ002'),
('KHMM', 'Hamilton / Ravalli County', 'US', 'United States', NULL, NULL),
('KHAO', 'Hamilton, Hamilton-Fairfield Airport', 'US', 'United States', 'Hamilton', 'OHZ070'),
('KCMX', 'Hancock, Houghton County Memorial Airport', 'US', 'United States', 'Hancock', 'MIZ003'),
('KHMS', 'Hanford', 'US', 'United States', NULL, NULL),
('KO18', 'Hanford, Hanford Municipal Airport', 'US', 'United States', NULL, NULL),
('K4HV', 'Hanksville', 'US', 'United States', 'Hanksville', 'UTZ013'),
('KHRL', 'Harlingen, Rio Grande Valley International Airport', 'US', 'United States', 'Harlingen', 'TXZ255'),
('K3HT', 'Harlowton', 'US', 'United States', 'Harlowton', 'MTZ028'),
('KCXY', 'Harrisburg, Capital City Airport', 'US', 'United States', 'Harrisburg', 'PAZ057'),
('KMDT', 'Harrisburg, Harrisburg International Airport', 'US', 'United States', 'Middletown', 'PAZ057'),
('KHRO', 'Harrison, Boone County Airport', 'US', 'United States', 'Harrison', 'ARZ003'),
('KHFD', 'Hartford, Hartford-Brainard Airport', 'US', 'United States', 'Hartford', 'CTZ002'),
('KHSI', 'Hastings, Hastings Municipal Airport', 'US', 'United States', 'Hastings', 'NEZ075'),
('KHSE', 'Hatteras, Mitchell Field', 'US', 'United States', NULL, NULL),
('KHVR', 'Havre, Havre City-County Airport', 'US', 'United States', 'Havre', 'MTZ011'),
('KHHR', 'Hawthorne, Hawthorne Municipal Airport', 'US', 'United States', 'Hawthorne', 'CAZ041'),
('KHDN', 'Hayden / Yampa Automatic Weather Observing / Reporting System', 'US', 'United States', 'Hayden', 'COZ005'),
('PAHZ', 'Hayes River', 'US', 'United States', 'Hayes River', ''),
('KHYS', 'Hays Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Hays', 'KSZ031'),
('KHWD', 'Hayward, Hayward Air Terminal', 'US', 'United States', 'Hayward', 'CAZ007'),
('KHYR', 'Hayward, Hayward Municipal Airport', 'US', 'United States', 'Hayward', 'WIZ008'),
('PAHV', 'Healy River Airport', 'US', 'United States', 'Healy River', 'AKZ004'),
('KHLN', 'Helena, Helena Regional Airport', 'US', 'United States', 'Helena', 'MTZ014'),
('KEHR', 'Henderson City', 'US', 'United States', 'Henderson', 'KYZ018'),
('KF10', 'Henryetta Municipal', 'US', 'United States', NULL, NULL),
('KS22', 'Hermiston, Hermiston Municipal Airport', 'US', 'United States', NULL, NULL),
('KHEI', 'Hettinger, Hettinger Municipal Airport', 'US', 'United States', NULL, NULL),
('KHIB', 'Hibbing, Chisholm-Hibbing Airport', 'US', 'United States', 'Hibbing', 'MNZ019'),
('KHKY', 'Hickory, Hickory Regional Airport', 'US', 'United States', 'Hickory', 'NCZ056'),
('KHIF', 'Hill Air Force Base / Ogden', 'US', 'United States', 'OgdenHill AFB', 'UTZ002'),
('KHLC', 'Hill City, Hill City Municipal Airport', 'US', 'United States', 'Hill City', 'KSZ016'),
('KHLX', 'Hillsville', 'US', 'United States', 'GalaxHillsville', 'VAZ016'),
('PHTO', 'Hilo, Hilo International Airport', 'US', 'United States', 'Hilo', 'HIZ004'),
('KHBR', 'Hobart, Hobart Municipal Airport', 'US', 'United States', 'Hobart', 'OKZ035'),
('KHOB', 'Hobbs / Lea County', 'US', 'United States', 'Hobbs', 'NMZ029'),
('KBIV', 'Holland, Tulip City Airport', 'US', 'United States', NULL, NULL),
('KHMN', 'Holloman Air Force Base', 'US', 'United States', 'Alamogordo', 'NMZ024'),
('PAHO', 'Homer', 'US', 'United States', 'Homer', 'AKZ017'),
('PAHD', 'Homer / Municipal', 'US', 'United States', NULL, NULL),
('KHST', 'Homestead Air Force Base', 'US', 'United States', 'Homestead AFB', 'FLZ074'),
('KH92', 'Hominy Municipal', 'US', 'United States', NULL, NULL),
('KHDO', 'Hondo, Hondo Municipal Airport', 'US', 'United States', 'Hondo', 'TXZ204'),
('PHNL', 'Honolulu, Honolulu International Airport', 'US', 'United States', 'Honolulu', 'HIZ002'),
('PAOH', 'Hoonah Seaplane', 'US', 'United States', 'Hoonah', 'AKZ026'),
('KHQM', 'Hoquiam, Bowerman Airport', 'US', 'United States', 'Hoquiam', 'WAZ016'),
('KHSP', 'Hot Springs / Ingalls', 'US', 'United States', 'Hot Springs', 'VAZ020'),
('KHOT', 'Hot Springs, Memorial Field', 'US', 'United States', 'Hot Springs', 'ARZ042'),
('KHTL', 'Houghton Lake, Roscommon County Airport', 'US', 'United States', 'Houghton Lake', 'MIZ034'),
('KHUL', 'Houlton, Houlton International Airport', 'US', 'United States', 'Houlton', 'MEZ002'),
('KHUM', 'Houma-Terrebonne', 'US', 'United States', 'Houma', 'LAZ066'),
('KEFD', 'Houston / Ellington', 'US', 'United States', 'HoustonEllington Field', 'TXZ213'),
('KT02', 'Houston, Clover Field', 'US', 'United States', 'HoustonClover', 'TXZ213'),
('KHOU', 'Houston, Hobby Airport', 'US', 'United States', 'HoustonHobby', 'TXZ213'),
('KDWH', 'Houston, Hooks Memorial Airport', 'US', 'United States', 'HoustonHooks', 'TXZ213'),
('KIAH', 'Houston, Houston Intercontinental Airport', 'US', 'United States', 'HoustonBush', 'TXZ213'),
('KSVN', 'Hunter U. S. Army Airfield', 'US', 'United States', 'SavannahHunter AAF', 'GAZ119'),
('KHNB', 'Huntingburg', 'US', 'United States', NULL, NULL),
('KHTS', 'Huntington, Tri-State Airport', 'US', 'United States', 'Huntington', 'WVZ006'),
('KHSV', 'Huntsville, Huntsville International / Jones Field', 'US', 'United States', 'Huntsville', 'ALZ006'),
('KUTS', 'Huntsville, Huntsville Municipal Airport', 'US', 'United States', 'Huntsville', ''),
('KHRT', 'Hurlburt Field', 'US', 'United States', 'Hurlburt Field', ''),
('KHON', 'Huron, Huron Regional Airport', 'US', 'United States', 'Huron', 'SDZ038'),
('PAHS', 'Huslia', 'US', 'United States', NULL, NULL),
('KHCD', 'Hutchinson Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KHUT', 'Hutchinson, Hutchinson Municipal Airport', 'US', 'United States', 'Hutchinson', 'KSZ067'),
('KHYA', 'Hyannis, Barnstable Municipal-Boardman Airport', 'US', 'United States', 'Hyannis', 'MAZ022'),
('PAHY', 'Hydaburg Seaplane', 'US', 'United States', NULL, NULL),
('KIDA', 'Idaho Falls, Fanning Field', 'US', 'United States', 'Idaho Falls', 'IDZ020'),
('PAIL', 'Iliamna / Iliamna Airport', 'US', 'United States', 'Iliamna', 'AKZ010'),
('KNRS', 'Imperial Beach, Naval Auxiliary Landing Field', 'US', 'United States', 'Imperial Beach', 'CAZ043'),
('KIML', 'Imperial Municipal', 'US', 'United States', 'Imperial', 'NEZ069'),
('KIPL', 'Imperial, Imperial County Airport', 'US', 'United States', 'Imperial', 'CAZ033'),
('PAIM', 'Indian Mountain Airways Facilities Sector', 'US', 'United States', NULL, NULL),
('KINS', 'Indian Springs Gunnery Range', 'US', 'United States', NULL, NULL),
('KIDI', 'Indiana / Stewart Field', 'US', 'United States', NULL, NULL),
('KEYE', 'Indianapolis, Eagle Creek Airpark', 'US', 'United States', NULL, NULL),
('KIND', 'Indianapolis, Indianapolis International Airport', 'US', 'United States', 'Indianapolis', 'INZ047'),
('KINL', 'International Falls, Falls International Airport', 'US', 'United States', 'International Falls', 'MNZ010'),
('K7R4', 'Intracoastal City', 'US', 'United States', 'Intercostal', 'LAZ052'),
('KIYK', 'Inyokern', 'US', 'United States', 'Inyokern', 'CAZ025'),
('KIOW', 'Iowa City, Iowa City Municipal Airport', 'US', 'United States', 'Iowa City', 'IAZ064'),
('KIMT', 'Iron Mountain / Kingsford, Ford Airport', 'US', 'United States', 'Iron Mountain', 'MIZ011'),
('KIWD', 'Ironwood Automatic Weather Observing / Reporting System', 'US', 'United States', 'Ironwood', 'MIZ009'),
('KISP', 'Islip, Long Island Mac Arthur Airport', 'US', 'United States', 'Islip', 'NYZ080'),
('KITH', 'Ithaca / Tompkins County', 'US', 'United States', 'Ithaca', 'NYZ025'),
('KJXN', 'Jackson / Reynolds', 'US', 'United States', 'Jackson', 'MIZ074'),
('KJAC', 'Jackson Hole Automatic Weather Observing / Reporting System', 'US', 'United States', 'Jackson', 'WYZ006'),
('KMJQ', 'Jackson Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KJKL', 'Jackson, Carroll Airport', 'US', 'United States', 'Jackson', 'KYZ112'),
('KJAN', 'Jackson, Jackson International Airport', 'US', 'United States', 'Jackson', 'MSZ048'),
('KMKL', 'Jackson, McKellar-Sipes Regional Airport', 'US', 'United States', 'Jackson', 'TNZ052'),
('KOAJ', 'Jacksonville Automatic Weather Observing / Reporting System', 'US', 'United States', 'Jacksonville', 'NCZ098'),
('KCRG', 'Jacksonville, Craig Municipal Airport', 'US', 'United States', 'JacksonvilleCraig Airport', 'FLZ025'),
('KJAX', 'Jacksonville, Jacksonville International Airport', 'US', 'United States', 'Jacksonville', 'FLZ025'),
('KNIP', 'Jacksonville, Naval Air Station', 'US', 'United States', 'Jacksonville NAS', 'FLZ025'),
('KNCA', 'Jacksonville, New River, Marine Corps Air Station', 'US', 'United States', 'New River', 'NCZ098'),
('KAFN', 'Jaffrey, Jaffrey Municipal-Silver Ranch Airport', 'US', 'United States', 'Jaffrey', 'NHZ011'),
('KJHW', 'Jamestown Automatic Weather Observing / Reporting System', 'US', 'United States', 'Jamestown', 'NYZ019'),
('KJMS', 'Jamestown, Jamestown Municipal Airport', 'US', 'United States', 'Jamestown', 'NDZ037'),
('KJVL', 'Janesville / Rock County', 'US', 'United States', 'Janesville', 'WIZ069'),
('KJEF', 'Jefferson City, Jefferson City Memorial Airport', 'US', 'United States', 'Jefferson City', 'MOZ048'),
('KU73', 'Jerome, Jerome County Airport', 'US', 'United States', NULL, NULL),
('KJST', 'Johnstown, Johnstown-Cambria County Airport', 'US', 'United States', 'Johnstown', 'PAZ024'),
('KJBR', 'Jonesboro, Jonesboro Municipal Airport', 'US', 'United States', 'Jonesboro', 'ARZ026'),
('KJLN', 'Joplin, Joplin Regional Airport', 'US', 'United States', 'Joplin', 'MOZ088'),
('KJDN', 'Jordan, Jordan Airport', 'US', 'United States', 'Jordan', 'MTZ022'),
('KJCT', 'Junction, Kimble County Airport', 'US', 'United States', 'Junction', 'TXZ169'),
('PAJN', 'Juneau, Juneau International Airport', 'US', 'United States', 'Juneau', 'AKZ025'),
('PHOG', 'Kahului, Kahului Airport', 'US', 'United States', 'Kahului', 'HIZ003'),
('PHKO', 'Kailua / Kona, Keahole Airport', 'US', 'United States', 'KailuaKona', 'HIZ002'),
('KAIZ', 'Kaiser Memorial Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('PAFE', 'Kake Seaplane Base', 'US', 'United States', 'Kake', 'AKZ026'),
('KAZO', 'Kalamazoo, Kalamazoo / Battle Creek International Airport', 'US', 'United States', 'Kalamazoo', 'MIZ072'),
('KFCA', 'Kalispell, Glacier Park International Airport', 'US', 'United States', 'Kalispell', 'MTZ003'),
('PAKV', 'Kaltag, Kaltag Airport', 'US', 'United States', NULL, NULL),
('PHNG', 'Kaneohe, Marine Corps Air Station', 'US', 'United States', 'Kaneohe', 'HIZ002'),
('KMKC', 'Kansas City, Kansas City Downtown Airport', 'US', 'United States', 'Kansas City', 'MOZ037'),
('KMCI', 'Kansas City, Kansas City International Airport', 'US', 'United States', 'Kansas City', 'MOZ029'),
('KGVW', 'Kansas City, Richards-Gebaur Airport', 'US', 'United States', 'Grandview', 'MOZ037'),
('KEAR', 'Kearney Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Kearney', 'NEZ061'),
('KEEN', 'Keene / Dillant Automatic Weather Observing / Reporting System', 'US', 'United States', 'Keene', 'NHZ011'),
('KBIX', 'Keesler Air Force Base / Biloxi', 'US', 'United States', NULL, NULL),
('PHBK', 'Kekaha, Pacific Missile Test Facility Barking Sands', 'US', 'United States', 'Barking Sand', ''),
('KSKF', 'Kelly Air Force Base', 'US', 'United States', 'San AntonioKelly AFB', 'TXZ205'),
('KKLS', 'Kelso-Longview Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('PAEN', 'Kenai, Kenai Municipal Airport', 'US', 'United States', 'Kenai', 'AKZ017'),
('KENW', 'Kenosha, Kenosha Regional Airport', 'US', 'United States', 'Kenosha', 'WIZ072'),
('KEOK', 'Keokuk Municipal', 'US', 'United States', 'Keokuk', ''),
('PAKT', 'Ketchikan, Ketchikan International Airport', 'US', 'United States', 'Ketchikan', 'AKZ027'),
('KEYW', 'Key West, Key West International Airport', 'US', 'United States', 'Key West', 'FLZ075'),
('KNQX', 'Key West, Naval Air Station', 'US', 'United States', 'Key West NAS', 'FLZ075'),
('KILE', 'Killeen Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Killeen', 'TXZ158'),
('PAKN', 'King Salmon, King Salmon Airport', 'US', 'United States', 'King Salmon', 'AKZ016'),
('KIGM', 'Kingman, Kingman Airport', 'US', 'United States', 'Kingman', 'AZZ003'),
('KNQI', 'Kingsville, Naval Air Station', 'US', 'United States', 'Kingsville', 'TXZ242'),
('KISO', 'Kinston / Stallings', 'US', 'United States', 'Kinston', 'NCZ091'),
('KIRK', 'Kirksville, Kirksville Regional Airport', 'US', 'United States', 'Kirksville', 'MOZ017'),
('PAVL', 'Kivalina, Kivalina Airport', 'US', 'United States', NULL, NULL),
('KLMT', 'Klamath Falls, Klamath Falls International Airport', 'US', 'United States', 'Klamath Falls', 'ORZ012'),
('PAKW', 'Klawock', 'US', 'United States', 'Klawock', ''),
('KOXV', 'Knoxville', 'US', 'United States', 'Knoxville', ''),
('KTYS', 'Knoxville, McGhee Tyson Airport', 'US', 'United States', 'Knoxville', 'TNZ069'),
('PADQ', 'Kodiak', 'US', 'United States', 'Kodiak', 'AKZ018'),
('PAOT', 'Kotzebue, Wien Memorial Airport', 'US', 'United States', 'Kotzebue', 'AKZ003'),
('KLSE', 'La Crosse, La Crosse Municipal Airport', 'US', 'United States', 'La Crosse', 'WIZ041'),
('KLGD', 'La Grande Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KLHX', 'La Junta, La Junta Municipal Airport', 'US', 'United States', 'La Junta', 'COZ076'),
('KPOC', 'La Verne / Brackett', 'US', 'United States', 'La Verne', 'CAZ047'),
('KLCI', 'Laconia Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Laconia', 'NHZ009'),
('KLFT', 'Lafayette, Lafayette Regional Airport', 'US', 'United States', 'Lafayette', 'LAZ044'),
('KLAF', 'Lafayette, Purdue University Airport', 'US', 'United States', 'Lafayette', 'INZ029'),
('PHJH', 'Lahaina / West Maui', 'US', 'United States', 'Lahaina', 'HIZ003'),
('KLCH', 'Lake Charles, Lake Charles Regional Airport', 'US', 'United States', 'Lake Charles', 'LAZ041'),
('PALH', 'Lake Hood Seaplane', 'US', 'United States', 'Lake Hood', ''),
('KNEL', 'Lakehurst Naval Air Station', 'US', 'United States', 'Lakehurst', ''),
('KLAL', 'Lakeland Regional', 'US', 'United States', 'Lakeland', 'FLZ052'),
('K4LW', 'Lakeview', 'US', 'United States', 'Lakeview', 'ORZ015'),
('KLKV', 'Lakeview Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KLAA', 'Lamar, Lamar Municipal Airport', 'US', 'United States', NULL, NULL),
('KLWD', 'Lamoni, Lamoni Municipal Airport', 'US', 'United States', NULL, NULL),
('PHNY', 'Lanai City Airport', 'US', 'United States', 'Lanai', 'HIZ003'),
('KWJF', 'Lancaster / Fox Field', 'US', 'United States', 'Lancaster', 'CAZ059'),
('KLHQ', 'Lancaster, Fairfield County Airport', 'US', 'United States', 'Lancaster', 'OHZ067'),
('KLNS', 'Lancaster, Lancaster Airport', 'US', 'United States', 'Lancaster', 'PAZ066'),
('KLND', 'Lander', 'US', 'United States', 'Lander', 'WYZ012'),
('KLFI', 'Langley Air Force Base', 'US', 'United States', 'Langley AFB', 'VAZ094'),
('KLAN', 'Lansing, Capital City Airport', 'US', 'United States', 'Lansing', 'MIZ066'),
('KLAR', 'Laramie, Laramie Regional Airport', 'US', 'United States', 'Laramie', 'WYZ066'),
('KLRD', 'Laredo International Airport', 'US', 'United States', 'Laredo', 'TXZ239'),
('KLRU', 'Las Cruces International', 'US', 'United States', NULL, NULL),
('KLVS', 'Las Vegas, Las Vegas Municipal Airport', 'US', 'United States', 'Las Vegas', 'NMZ005'),
('KLAS', 'Las Vegas, McCarran International Airport', 'US', 'United States', 'Las Vegas', 'NVZ020'),
('KLBE', 'Latrobe / Westmorland', 'US', 'United States', 'Latrobe', 'PAZ030'),
('KDLF', 'Laughlin, Laughlin Air Force Base Auxiliary Airfield', 'US', 'United States', 'Laughlin', ''),
('KLWM', 'Lawrence, Lawrence Municipal Airport', 'US', 'United States', 'Lawrence', 'MAZ007'),
('KLWV', 'Lawrenceville, Lawrenceville-Vincennes International Airport', 'US', 'United States', NULL, NULL),
('KLAW', 'Lawton, Lawton Municipal Airport', 'US', 'United States', 'Lawton', 'OKZ038'),
('KLRJ', 'Le Marine Aviation Reporting Station', 'US', 'United States', 'Le Marine', ''),
('KLXV', 'Leadville, Lake County Airport', 'US', 'United States', 'Leadville', 'COZ012'),
('KLEB', 'Lebanon, Lebanon Municipal Airport', 'US', 'United States', 'Lebanon', 'NHZ003'),
('KJYO', 'Leesburg / Godfrey', 'US', 'United States', 'Leesburg', 'VAZ042'),
('KLEE', 'Leesburg, Leesburg Municipal Airport', 'US', 'United States', 'Leesburg', ''),
('KY22', 'Lemmon', 'US', 'United States', 'Lemmon', 'SDZ002'),
('KNLC', 'Lemoore, Naval Air Station', 'US', 'United States', 'Lemoore', 'CAZ021'),
('KLWB', 'Lewisburg / Greenbrier', 'US', 'United States', 'Lewisburg', 'WVZ045'),
('KLWS', 'Lewiston, Lewiston-Nez Perce County Airport', 'US', 'United States', 'Lewiston', 'IDZ003'),
('KLWT', 'Lewistown Municipal', 'US', 'United States', 'Lewistown', 'MTZ013'),
('KLEX', 'Lexington, Blue Grass Airport', 'US', 'United States', 'Lexington', 'KYZ041'),
('KLBL', 'Liberal Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Liberal', 'KSZ086'),
('KP67', 'Lidgerwood Remote Automatic Meteorological Observing System', 'US', 'United States', 'Lidgerwood', 'NDZ053'),
('PHLI', 'Lihue, Lihue Airport', 'US', 'United States', 'Lihue', 'HIZ001'),
('KAOH', 'Lima, Lima Allen County Airport', 'US', 'United States', NULL, NULL),
('KLIC', 'Limon, Limon Municipal Airport', 'US', 'United States', 'Limon', 'COZ047'),
('KLNK', 'Lincoln, Lincoln Municipal Airport', 'US', 'United States', 'Lincoln', 'NEZ066'),
('KLXL', 'Little Falls Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KLRF', 'Little Rock Air Force Base', 'US', 'United States', 'Little Rock AFB', 'ARZ044'),
('KLIT', 'Little Rock, Adams Field', 'US', 'United States', 'Little Rock', 'ARZ044'),
('KLVK', 'Livermore, Livermore Municipal Airport', 'US', 'United States', 'Livermore', 'CAZ007'),
('KLVM', 'Livingston, Mission Field', 'US', 'United States', 'Livingston', 'MTZ028'),
('KLGU', 'Logan, Logan-Cache Airport', 'US', 'United States', 'Logan', 'UTZ001'),
('KLPC', 'Lompoc Automatic Weather Observing / Reporting System', 'US', 'United States', 'Lompoc', 'CAZ035'),
('KLOZ', 'London, London-Corbin Airport-Magee Field', 'US', 'United States', 'London', ''),
('KLNR', 'Lone Rock, Tri-County Regional Airport', 'US', 'United States', 'Lone Rock', 'WIZ055'),
('KLGB', 'Long Beach, Long Beach Airport', 'US', 'United States', 'Long Beach', 'CAZ041'),
('KGGG', 'Longview, Gregg County Airport', 'US', 'United States', 'Longview', 'TXZ138'),
('KLPR', 'Lorain / Elyria, Lorain County Regional Airport', 'US', 'United States', NULL, NULL),
('KLAM', 'Los Alamos', 'US', 'United States', 'Los Alamos', 'NMZ002'),
('KLAX', 'Los Angeles, Los Angeles International Airport', 'US', 'United States', 'Los Angeles', 'CAZ041'),
('KLOU', 'Louisville, Bowman Field', 'US', 'United States', 'Louisville', 'KYZ030'),
('KSDF', 'Louisville, Standiford Field', 'US', 'United States', 'LouisvilleStandiford Field', 'KYZ030'),
('KLOL', 'Lovelock, Derby Field', 'US', 'United States', 'Lovelock', 'NVZ004'),
('KP69', 'Lowell', 'US', 'United States', 'Elk City', 'IDZ006'),
('KLBB', 'Lubbock, Lubbock International Airport', 'US', 'United States', 'Lubbock', 'TXZ035'),
('KLFK', 'Lufkin, Angelina County Airport', 'US', 'United States', 'Lufkin', 'TXZ165'),
('KLUF', 'Luke Air Force Base / Phoenix', 'US', 'United States', 'PhoenixLuke AFB', 'AZZ023'),
('KLBT', 'Lumberton, Lumberton Municipal Airport', 'US', 'United States', NULL, NULL),
('KLYH', 'Lynchburg, Lynchburg Regional Airport', 'US', 'United States', 'Lynchburg', 'VAZ045'),
('KMCF', 'Macdill Air Force Base, Fl.', 'US', 'United States', 'TampaMacdill AFB', 'FLZ051'),
('KHFF', 'Mackall U. S. Army Airfield', 'US', 'United States', 'Hoffman', ''),
('KMCN', 'Macon, Middle Georgia Regional Airport', 'US', 'United States', 'Macon', 'GAZ082'),
('KMAE', 'Madera, Madera Municipal Airport', 'US', 'United States', NULL, NULL),
('KMSN', 'Madison, Dane County Regional-Truax Field', 'US', 'United States', 'Madison', 'WIZ063'),
('KMLD', 'Malad City', 'US', 'United States', 'Malad City', 'IDZ022'),
('K77M', 'Malta', 'US', 'United States', 'Malta', 'IDZ022'),
('KMMH', 'Mammoth / June Lakes', 'US', 'United States', 'Mammoth Lakes', 'CAZ073'),
('KHEF', 'Manassas Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Manassas', 'VAZ052'),
('KMHT', 'Manchester, Manchester Airport', 'US', 'United States', 'Manchester', 'NHZ012'),
('KMHK', 'Manhattan, Manhattan Municipal Airport', 'US', 'United States', 'Manhattan', 'KSZ022'),
('KMBL', 'Manistee Automatic Weather Observing / Reporting System', 'US', 'United States', 'Manistee', 'MIZ031'),
('KP75', 'Manistique', 'US', 'United States', 'Seul Choix Pt', ''),
('KMTW', 'Manitowoc Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Manitowoc', 'WIZ050'),
('KMKT', 'Mankato Automatic Weather Observing / Reporting System', 'US', 'United States', 'Mankato', 'MNZ083'),
('PAML', 'Manley Hot Springs', 'US', 'United States', NULL, NULL),
('KMFD', 'Mansfield, Mansfield Lahm Municipal Airport', 'US', 'United States', 'Mansfield', 'OHZ029'),
('KMQI', 'Manteo / Dare County Regional', 'US', 'United States', NULL, NULL),
('KMTH', 'Marathon, Marathon Airport', 'US', 'United States', 'Marathon', 'FLZ075'),
('KMRF', 'Marfa', 'US', 'United States', NULL, NULL),
('KMAI', 'Marianna, Marianna Municipal Airport', 'US', 'United States', 'Marianna', 'FLZ011'),
('KMGE', 'Marietta / Dobbins Air Force Base', 'US', 'United States', 'Marietta', 'GAZ032'),
('KMKJ', 'Marion / Wytheville', 'US', 'United States', 'MarionWytheville', 'VAZ009'),
('KMWA', 'Marion Regional', 'US', 'United States', 'Marion', 'ILZ085'),
('KMNN', 'Marion, Marion Municipal Airport', 'US', 'United States', NULL, NULL),
('KMQT', 'Marquette', 'US', 'United States', 'Marquette', 'MIZ005'),
('KMMO', 'Marseilles Island', 'US', 'United States', 'Marseilles', 'ILZ019'),
('KMML', 'Marshall / Ryan Automatic Weather Observing / Reporting System', 'US', 'United States', 'Marshall', 'MNZ072'),
('KMIW', 'Marshalltown, Marshalltown Municipal Airport', 'US', 'United States', 'Marshalltown', 'IAZ049'),
('KMFI', 'Marshfield, Marshfield Municipal Airport', 'US', 'United States', 'Marshfield', 'WIZ035'),
('KMRB', 'Martinsburg, Eastern West Virginia Regional Airport', 'US', 'United States', 'Martinsburg', 'WVZ052'),
('KMTV', 'Martinsville', 'US', 'United States', 'Martinsville', 'VAZ043'),
('KMYV', 'Marysville, Yuba County Airport', 'US', 'United States', 'Marysville', 'CAZ016'),
('KMCW', 'Mason City, Mason City Municipal Airport', 'US', 'United States', 'Mason City', 'IAZ017'),
('KMSS', 'Massena, Massena International-Richards Field', 'US', 'United States', 'Massena', 'NYZ026'),
('KMHR', 'Mather Field', 'US', 'United States', NULL, NULL),
('KMTO', 'Mattoon / Charleston, Coles County Memorial Airport', 'US', 'United States', 'Mattoon', 'ILZ056'),
('KMEB', 'Maxton, Laurinburg-Maxton Airport', 'US', 'United States', NULL, NULL),
('KMXF', 'Maxwell Air Force Base / Montgomery', 'US', 'United States', 'MontgomeryMaxwell AFB', 'ALZ044'),
('KNRB', 'Mayport, Naval Air Facility', 'US', 'United States', 'Mayport', 'FLZ025'),
('KPWG', 'Mc Gregor Automatic Weather Observing / Reporting System', 'US', 'United States', 'Mc Gregor', ''),
('KMLC', 'McAlester, McAlester Regional Airport', 'US', 'United States', 'McAlester', 'OKZ073'),
('KMFE', 'McAllen, Miller International Airport', 'US', 'United States', 'McAllen', 'TXZ253'),
('KMYL', 'McCall, McCall Airport', 'US', 'United States', 'McCall', 'IDZ011'),
('PAMX', 'McCarthy', 'US', 'United States', 'McCarthy', 'AKZ017'),
('KMCC', 'McClellan Air Force Base', 'US', 'United States', 'McClellan', ''),
('KMCB', 'McComb, McComb / Pike County Airport', 'US', 'United States', 'McComb', 'MSZ070'),
('KIAB', 'McConnell Air Force Base', 'US', 'United States', 'WichitaMcConnell AFB', 'KSZ083'),
('KMCK', 'McCook, McCook Municipal Airport', 'US', 'United States', 'McCook', 'NEZ081'),
('KMMT', 'McEntire Air National Guard Weather Facility Base', 'US', 'United States', 'ColumbiaMcEntire', 'SCZ028'),
('PAMC', 'McGrath', 'US', 'United States', 'McGrath', 'AKZ004'),
('PAIN', 'McKinley Park', 'US', 'United States', NULL, NULL),
('KTKI', 'McKinney, McKinney Municipal Airport', 'US', 'United States', NULL, NULL),
('KMMV', 'McMinnville, McMinnville Municipal Airport', 'US', 'United States', NULL, NULL),
('KWRI', 'Mcguire Air Force Base', 'US', 'United States', 'Wrightstown / Mcguire AFB', 'NJZ019'),
('KMEH', 'Meacham, Meacham', 'US', 'United States', 'Meacham', 'ORZ017'),
('KMFR', 'Medford, Rogue Valley International Airport', 'US', 'United States', 'Medford', 'ORZ008'),
('KP28', 'Medicine Lodge, Medicine Lodge', 'US', 'United States', 'Medicine Lodge', 'KSZ090'),
('KEEO', 'Meeker, Meeker Airport', 'US', 'United States', NULL, NULL),
('PAMY', 'Mekoryuk', 'US', 'United States', 'Mekoryuk', 'AKZ010'),
('KMLB', 'Melbourne, Melbourne International Airport', 'US', 'United States', 'Melbourne', 'FLZ047'),
('KMFV', 'Melfa / Accomack Airport', 'US', 'United States', 'Melfa', 'VAZ099'),
('K4MR', 'Melrose Gunnery Range', 'US', 'United States', NULL, NULL),
('KMEM', 'Memphis, Memphis International Airport', 'US', 'United States', 'Memphis', 'TNZ088'),
('KMNM', 'Menominee Automatic Weather Observing / Reporting System', 'US', 'United States', 'Menominee', 'MIZ012'),
('KMER', 'Merced / Castle Air Force Base', 'US', 'United States', NULL, NULL),
('KMCE', 'Merced, Merced Municipal Airport', 'US', 'United States', 'Merced', 'CAZ020'),
('KDRA', 'Mercury, Desert Rock Airport', 'US', 'United States', 'Desert Rock', ''),
('KMEI', 'Meridian, Key Field', 'US', 'United States', 'Meridian', 'MSZ052'),
('KNMM', 'Meridian, Naval Air Station', 'US', 'United States', 'MeridianLauderdale', 'MSZ052'),
('PAMR', 'Merrill Field', 'US', 'United States', 'Merril Field', ''),
('KFFZ', 'Mesa / Falcon Field', 'US', 'United States', 'MesaFalcon Field', 'AZZ023'),
('KTMB', 'Miami, Kendall-Tamiami Executive Airport', 'US', 'United States', 'MiamiKendall', 'FLZ074'),
('KMIA', 'Miami, Miami International Airport', 'US', 'United States', 'Miami', 'FLZ074'),
('KOPF', 'Miami, Opa Locka Airport', 'US', 'United States', 'MiamiOpa Locka', 'FLZ074'),
('PAMD', 'Middleton Island, Ak', 'US', 'United States', 'Middleton Island', ''),
('KMAF', 'Midland, Midland International Airport', 'US', 'United States', 'Midland', 'TXZ062'),
('PMDY', 'Midway Island Naval Air Facility', 'US', 'United States', NULL, NULL),
('KMLS', 'Miles City, Wiley Field', 'US', 'United States', 'Miles City', 'MTZ032'),
('KMLF', 'Milford, Milford Municipal Airport', 'US', 'United States', 'Milford', 'UTZ016'),
('KMLT', 'Millinocket, Millinocket Municipal Airport', 'US', 'United States', 'Millinocket', 'MEZ015'),
('KMIV', 'Millville, Millville Municipal Airport', 'US', 'United States', 'Millville', 'NJZ021'),
('KNSE', 'Milton, Whiting Field North', 'US', 'United States', 'Milton', 'FLZ004'),
('KMWC', 'Milwaukee / Timmerman', 'US', 'United States', 'MilwaukeeTimmerman', 'WIZ066'),
('KMKE', 'Milwaukee, General Mitchell International Airport', 'US', 'United States', 'Milwaukee', 'WIZ066'),
('PAMH', 'Minchumina', 'US', 'United States', 'Minchumina', ''),
('KMWL', 'Mineral Wells, Mineral Wells Airport', 'US', 'United States', 'Mineral Wells', 'TXZ117'),
('KANE', 'Minneapolis / Blaine', 'US', 'United States', NULL, NULL),
('KMIC', 'Minneapolis, Crystal Airport', 'US', 'United States', 'Minneapolis [3]', 'MNZ060'),
('KFCM', 'Minneapolis, Flying Cloud Airport', 'US', 'United States', 'Minneapolis [2]', 'MNZ060'),
('KMSP', 'Minneapolis, Minneapolis-St. Paul International Airport', 'US', 'United States', 'Minneapolis', 'MNZ060'),
('KARV', 'Minocqua / Woodruff', 'US', 'United States', 'Minocqua', 'WIZ010'),
('KMIB', 'Minot Air Force Base', 'US', 'United States', 'Minot AFB', 'NDZ011'),
('KMOT', 'Minot, Minot International Airport', 'US', 'United States', 'Minot', 'NDZ011'),
('KMSO', 'Missoula, Missoula International Airport', 'US', 'United States', 'Missoula', 'MTZ005'),
('KMHE', 'Mitchell Automatic Weather Observing / Reporting System', 'US', 'United States', 'Mitchell', 'SDZ059'),
('KCNY', 'Moab, Canyonlands Field', 'US', 'United States', NULL, NULL),
('KBFM', 'Mobile, Mobile Downtown Airport', 'US', 'United States', 'Mobile Downtown', 'ALZ061'),
('KMOB', 'Mobile, Mobile Regional Airport', 'US', 'United States', 'Mobile Regional Airport', 'ALZ061'),
('KY26', 'Mobridge', 'US', 'United States', 'Mobridge', 'SDZ009'),
('KMBG', 'Mobridge, Mobridge Municipal Airport', 'US', 'United States', NULL, NULL),
('KMOD', 'Modesto, Modesto City-County-Sham Field', 'US', 'United States', 'Modesto', 'CAZ019'),
('KMHV', 'Mojave', 'US', 'United States', 'Mojave', 'CAZ024'),
('KMLI', 'Moline, Quad-City Airport', 'US', 'United States', 'MolineQuad Cities', 'ILZ015'),
('PHMK', 'Molokai Automatic Meteorological Observing System', 'US', 'United States', 'Molokai', 'HIZ005'),
('KEQY', 'Monroe, Monroe Airport', 'US', 'United States', NULL, NULL),
('KMLU', 'Monroe, Monroe Regional Airport', 'US', 'United States', 'Monroe', 'LAZ014'),
('KSIY', 'Montague / Siskiyou', 'US', 'United States', 'Montague', 'CAZ011'),
('KMTP', 'Montauk, Montauk Airport', 'US', 'United States', NULL, NULL),
('KMRY', 'Monterey, Monterey Peninsula Airport', 'US', 'United States', 'Monterey', 'CAZ009'),
('KMVE', 'Montevideo Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KMGM', 'Montgomery, Dannelly Field', 'US', 'United States', 'Montgomery', 'ALZ044'),
('KMGJ', 'Montgomery, Orange County Airport', 'US', 'United States', 'Montgomery', 'NYZ067'),
('KMSV', 'Monticello Automatic Weather Observing / Reporting System', 'US', 'United States', 'Monticello', 'NYZ062'),
('KMXO', 'Monticello Municipal', 'US', 'United States', 'Monticello', 'IAZ053'),
('KLLQ', 'Monticello, Monticello Municipal Airport', 'US', 'United States', NULL, NULL),
('KMTJ', 'Montrose, Montrose Regional Airport', 'US', 'United States', 'Montrose', 'COZ017'),
('KVAD', 'Moody Air Force Base', 'US', 'United States', 'ValdostaMoody AFB', 'GAZ160'),
('KMGW', 'Morgantown, Morgantown Municipal-Hart Field', 'US', 'United States', 'Morgantown', 'WVZ022'),
('K4MY', 'Moriarty', 'US', 'United States', 'Moriarty', 'NMZ011'),
('KMOX', 'Morris Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KMMU', 'Morristown Municipal', 'US', 'United States', 'Morristown', 'NJZ008'),
('KMVL', 'Morrisville, Morrisville-Stowe State Airport', 'US', 'United States', NULL, NULL),
('KMWH', 'Moses Lake, Grant County Airport', 'US', 'United States', 'Moses Lake', 'WAZ033'),
('KCWA', 'Mosinee / Central Wisconsin', 'US', 'United States', 'Mosinee', 'WIZ030'),
('KVAY', 'Mount Holly, South Jersey Regional Airport', 'US', 'United States', 'Mount Holly', ''),
('KMWT', 'Mount Ida', 'US', 'United States', NULL, NULL),
('KMHS', 'Mount Shasta', 'US', 'United States', 'Mount Shasta', 'CAZ011'),
('KMVN', 'Mount Vernon Automatic Weather Observing / Reporting System', 'US', 'United States', 'Mount Vernon', 'ILZ075'),
('KMWN', 'Mount Washington', 'US', 'United States', 'Mt Washington', ''),
('KMWS', 'Mount Wilson', 'US', 'United States', 'Mount Wilson', 'CAZ047'),
('KMUO', 'Mountain Home Air Force Base', 'US', 'United States', 'Mountain Home', 'IDZ014'),
('KBPK', 'Mountain Home, Baxter County Regional Airport', 'US', 'United States', NULL, NULL),
('KNUQ', 'Mountain View, Moffett Field', 'US', 'United States', 'Mountain View', 'CAZ006'),
('KMUI', 'Muir Army Air Field / Indiantown', 'US', 'United States', 'Muir', 'PAZ058'),
('KMLP', 'Mullan Pass, Mullan Pass Vor', 'US', 'United States', NULL, NULL),
('KMIE', 'Muncie, Delaware County-Johnson Field', 'US', 'United States', 'Muncie', 'INZ041'),
('KMUT', 'Muscatine', 'US', 'United States', 'Muscatine', 'IAZ067'),
('KMSL', 'Muscle Shoals, North West Alabama Regional Airport', 'US', 'United States', 'Muscle Shoals', 'ALZ002'),
('KMKG', 'Muskegon, Muskegon County Airport', 'US', 'United States', 'Muskegon', 'MIZ050'),
('KMKO', 'Muskogee, Davis Field', 'US', 'United States', NULL, NULL),
('KMYR', 'Myrtle Beach Air Force Base', 'US', 'United States', 'Myrtle Beach', 'SCZ034'),
('KOQU', 'N. Kingston / Quonset', 'US', 'United States', 'North Kingston', 'RIZ006'),
('KTTS', 'NASA Shuttle Facility', 'US', 'United States', 'Nasa Shuttle', ''),
('PABN', 'Nabesna / Devil Mountain', 'US', 'United States', 'Nabesna/Devil Mt.', ''),
('KOCH', 'Nacogdoches Automatic Weather Observing / Reporting System', 'US', 'United States', 'Nacogdoches', 'TXZ152'),
('KACK', 'Nantucket, Nantucket Memorial Airport', 'US', 'United States', 'Nantucket', 'MAZ024'),
('KAPC', 'Napa, Napa County Airport', 'US', 'United States', 'Napa', 'CAZ064'),
('KAPF', 'Naples Municipal', 'US', 'United States', 'Naples', 'FLZ069'),
('KASH', 'Nashua / Boire Field', 'US', 'United States', 'Nashua', 'NHZ012'),
('KBNA', 'Nashville, Nashville International Airport', 'US', 'United States', 'Nashville', 'TNZ027'),
('KHEZ', 'Natchez / Hardy Automatic Weather Observing / Reporting System', 'US', 'United States', 'Natchez', 'MSZ060'),
('KEED', 'Needles Airport', 'US', 'United States', 'Needles', 'CAZ029'),
('KLSV', 'Nellis Air Force Base', 'US', 'United States', 'N Las Vegas', 'NVZ020'),
('PANN', 'Nenana / Mun.', 'US', 'United States', 'Nenana', 'AKZ004'),
('KEWB', 'New Bedford, New Bedford Regional Airport', 'US', 'United States', 'New Bedford', 'MAZ017'),
('KEWN', 'New Bern, Craven County Regional Airport', 'US', 'United States', 'New Bern', 'NCZ093'),
('KBAX', 'New Braunfels, New Braunfels Municipal Airport', 'US', 'United States', NULL, NULL),
('KHVN', 'New Haven, Tweed-New Haven Airport', 'US', 'United States', 'New Haven', 'CTZ010'),
('KARA', 'New Iberia, Acadiana Regional Airport', 'US', 'United States', 'New Iberia', 'LAZ053'),
('KNEW', 'New Orleans, Lakefront Airport', 'US', 'United States', 'New OrleansLakefront', 'LAZ062'),
('KNBG', 'New Orleans, Naval Air Station', 'US', 'United States', 'New Orleans NAS', 'LAZ062'),
('KMSY', 'New Orleans, New Orleans International Airport', 'US', 'United States', 'New Orleans', 'LAZ062'),
('KPHD', 'New Philadelphia, Harry Clever Field', 'US', 'United States', NULL, NULL),
('KRRF', 'New Port Richey, Tampa Bay Executive Airport', 'US', 'United States', 'New Port Richey', 'FLZ051'),
('KULM', 'New Ulm Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KJFK', 'New York, Kennedy International Airport', 'US', 'United States', 'New YorkJFK Arpt', 'NYZ076'),
('KLGA', 'New York, La Guardia Airport', 'US', 'United States', 'New YorkLa Guardia', 'NYZ076'),
('KVTA', 'Newark, Newark Heath Airport', 'US', 'United States', NULL, NULL),
('KEWR', 'Newark, Newark International Airport', 'US', 'United States', 'Newark', 'NJZ005'),
('KSWF', 'Newburgh / Stewart', 'US', 'United States', 'Newburgh', 'NYZ067'),
('KJNW', 'Newport', 'US', 'United States', NULL, NULL),
('KMHX', 'Newport', 'US', 'United States', NULL, NULL),
('K9B2', 'Newport', 'US', 'United States', 'St Johnsbury', 'VTZ007'),
('KONP', 'Newport Municipal', 'US', 'United States', 'Newport', 'ORZ002'),
('KPHF', 'Newport News, Newport News / Williamsburg International Airport', 'US', 'United States', 'Newport News', 'VAZ093'),
('KUUU', 'Newport, Newport State Airport', 'US', 'United States', NULL, NULL),
('KEWK', 'Newton Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KTNU', 'Newton Municipal', 'US', 'United States', 'Newton', 'IAZ061'),
('KIAG', 'Niagara Falls, Niagara Falls International Airport', 'US', 'United States', 'Niagara Falls', 'NYZ001'),
('PAKO', 'Nikolski', 'US', 'United States', NULL, NULL),
('PAWN', 'Noatak', 'US', 'United States', NULL, NULL),
('K13A', 'Nogales Automatic Meteorological Observing System', 'US', 'United States', 'Nogales', 'AZZ034'),
('PAOM', 'Nome, Nome Airport', 'US', 'United States', 'Nome', 'AKZ006'),
('KNGU', 'Norfolk, Naval Air Station', 'US', 'United States', 'Norfolk NAS', 'VAZ093'),
('KORF', 'Norfolk, Norfolk International Airport', 'US', 'United States', 'Norfolk', 'VAZ093'),
('KOFK', 'Norfolk, Stefan Memorial Airport', 'US', 'United States', 'Norfolk', 'NEZ031'),
('KOUN', 'Norman / Max Westheimer', 'US', 'United States', NULL, NULL),
('KAQW', 'North Adams, Harriman-And-West Airport', 'US', 'United States', NULL, NULL),
('KOTH', 'North Bend Automatic Weather Observing / Reporting System', 'US', 'United States', 'North Bend', 'ORZ003'),
('KLZK', 'North Little Rock, North Little', 'US', 'United States', NULL, NULL),
('KCRE', 'North Myrtle Beach, Grand Strand Airport', 'US', 'United States', 'N Myrtle Beach', 'SCZ034'),
('KLBF', 'North Platte, North Platte Regional Airport', 'US', 'United States', 'North Platte', 'NEZ059'),
('KE28', 'Northrup Landing Strip', 'US', 'United States', NULL, NULL),
('PAOR', 'Northway, Northway Airport', 'US', 'United States', 'Northway', 'AKZ007'),
('KSBD', 'Norton Air Force Base / San Bern', 'US', 'United States', NULL, NULL),
('KOWD', 'Norwood, Norwood Memorial Airport', 'US', 'United States', 'Norwood', 'MAZ013'),
('PAQT', 'Nuiqsut, Nuiqsut Airport', 'US', 'United States', NULL, NULL),
('KONL', 'O\\\'Neill / Baker Field', 'US', 'United States', 'O\'Neill', 'NEZ010'),
('PHNA', 'Oahu, Barbers Point, Naval Air Station', 'US', 'United States', 'Barbers Point', 'HIZ002'),
('PHJR', 'Oahu, Kalaeloa Airport', 'US', 'United States', NULL, NULL),
('K76S', 'Oak Harbor Airpark', 'US', 'United States', 'Oak Harbor', 'WAZ009'),
('KOAK', 'Oakland, Metropolitan Oakland International Airport', 'US', 'United States', 'Oakland', 'CAZ007'),
('KOCF', 'Ocala Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Ocala', 'FLZ040'),
('KW30', 'Ocean City', 'US', 'United States', NULL, NULL),
('KNFG', 'Oceanside, Camp Pendleton, Marine Corps Air Station', 'US', 'United States', 'Oceanside', 'CAZ043'),
('KODO', 'Odessa, Odessa-Schlemeyer Field', 'US', 'United States', NULL, NULL),
('KOLZ', 'Oelwen', 'US', 'United States', 'Oelwen', 'IAZ029'),
('KOGD', 'Ogden, Ogden-Hinckley Airport', 'US', 'United States', 'Ogden', 'UTZ002'),
('KOGS', 'Ogdensburg International', 'US', 'United States', 'Ogdensburg', 'NYZ026'),
('KPWA', 'Oklahoma City, Wiley Post Airport', 'US', 'United States', 'Oklahoma CityBethany', 'OKZ025'),
('KOKC', 'Oklahoma City, Will Rogers World Airport', 'US', 'United States', 'Oklahoma City', 'OKZ025'),
('KOJC', 'Olathe, Johnson County Executive Airport', 'US', 'United States', 'Olathe', 'KSZ105'),
('KIXD', 'Olathe, New Century Aircenter', 'US', 'United States', 'Olathe/Ind.', 'KSZ105'),
('POLI', 'Oliktok Distant Early Warning', 'US', 'United States', NULL, NULL),
('KOLM', 'Olympia, Olympia Airport', 'US', 'United States', 'Olympia', 'WAZ008'),
('KOFF', 'Omaha / Offutt Air Force Base', 'US', 'United States', 'OmahaBellevue', 'NEZ052'),
('KOMA', 'Omaha, Eppley Airfield', 'US', 'United States', 'Omaha', 'NEZ052'),
('KOMK', 'Omak, Omak Airport', 'US', 'United States', NULL, NULL),
('KONT', 'Ontario, Ontario International Airport', 'US', 'United States', 'Ontario', 'CAZ048'),
('KONO', 'Ontario, Ontario Municipal Airport', 'US', 'United States', 'Ontario', 'ORZ021'),
('KORC', 'Orange City', 'US', 'United States', 'Orange City', 'IAZ012'),
('KORE', 'Orange, Orange Municipal Airport', 'US', 'United States', 'Orange', ''),
('KOGB', 'Orangeburg, Orangeburg Municipal Airport', 'US', 'United States', NULL, NULL),
('KODX', 'Ord / Sharp Field', 'US', 'United States', 'OrdSharp', 'NEZ039'),
('KSFB', 'Orlando / Sanford Airport', 'US', 'United States', 'Sanford', 'FLZ046'),
('KORL', 'Orlando, Orlando Executive Airport', 'US', 'United States', 'Orlando', 'FLZ045'),
('KMCO', 'Orlando, Orlando International Airport', 'US', 'United States', 'Orlando (Orlando International)', 'FLZ045'),
('KOVE', 'Oroville, Oroville Municipal Airport', 'US', 'United States', NULL, NULL),
('KORB', 'Orr', 'US', 'United States', NULL, NULL),
('KOSH', 'Oshkosh, Wittman Regional Airport', 'US', 'United States', 'Oshkosh', 'WIZ048'),
('KFMH', 'Otis Air National Guard Base', 'US', 'United States', 'FalmouthOtis AFB', 'MAZ022'),
('KOTM', 'Ottumwa, Ottumwa Industrial Airport', 'US', 'United States', 'Ottumwa', 'IAZ086'),
('KOWA', 'Owatonna Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KOWB', 'Owensboro / Daviess', 'US', 'United States', 'Owensboro', 'KYZ019'),
('KOXC', 'Oxford Automatic Weather Observing / Reporting System', 'US', 'United States', 'Oxford', 'CTZ010'),
('KOXR', 'Oxnard, Oxnard Airport', 'US', 'United States', 'Oxnard', 'CAZ040'),
('KPAH', 'Paducah, Barkley Regional Airport', 'US', 'United States', 'Paducah', 'KYZ005'),
('KPGA', 'Page, Page Municipal Airport', 'US', 'United States', 'Page', 'AZZ005'),
('KPSX', 'Palacios Municipal', 'US', 'United States', 'Palacios', 'TXZ236'),
('KPSP', 'Palm Springs, Palm Springs Regional Airport', 'US', 'United States', 'Palm Springs', 'CAZ061'),
('KTRM', 'Palm Springs, Thermal Airport', 'US', 'United States', NULL, NULL),
('KPMD', 'Palmdale, Palmdale Production Flight Plant', 'US', 'United States', 'Palmdale', 'CAZ054'),
('PAAQ', 'Palmer', 'US', 'United States', 'Palmer', 'AKZ015'),
('KPAO', 'Palo Alto Airport', 'US', 'United States', 'Palo Alto', 'CAZ006'),
('KPFN', 'Panama City, Panama City-Bay County International Airport', 'US', 'United States', 'Panama City', 'FLZ012'),
('KPRX', 'Paris / Cox Field', 'US', 'United States', 'Paris', 'TXZ095'),
('KPKF', 'Park Falls', 'US', 'United States', NULL, NULL),
('KPKD', 'Park Rapids, Park Rapids Municipal Airport', 'US', 'United States', NULL, NULL),
('KPKB', 'Parkersburg / Wilson', 'US', 'United States', 'Parkersburg', 'WVZ009'),
('KPPF', 'Parsons, Tri-City Airport', 'US', 'United States', NULL, NULL),
('KPQL', 'Pascagoula, Lott International Airport', 'US', 'United States', NULL, NULL),
('KPSC', 'Pasco, Tri-Cities Airport', 'US', 'United States', 'Pasco', 'WAZ028'),
('KPRB', 'Paso Robles, Paso Robles Municipal Airport', 'US', 'United States', 'Paso Robles', 'CAZ037'),
('KPTN', 'Patterson Memorial', 'US', 'United States', 'Patterson', ''),
('KNHK', 'Patuxent River, Naval Air Station', 'US', 'United States', 'Patuxent River', 'MDZ014'),
('KSFZ', 'Pawtucket Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('PAXK', 'Paxson', 'US', 'United States', 'Paxson', 'AKZ017'),
('K0E4', 'Payson', 'US', 'United States', 'Payson', 'AZZ018'),
('KPSM', 'Pease Air Force Base / Portsmouth', 'US', 'United States', 'Portsmouth', 'NHZ013'),
('KPLN', 'Pellston, Pellston Regional Airport', 'US', 'United States', 'Pellston', 'MIZ016'),
('KPDT', 'Pendleton, Eastern Oregon Regional At Pendleton Airport', 'US', 'United States', 'Pendleton', 'ORZ017'),
('KPEO', 'Penn Yan, Penn Yan Airport', 'US', 'United States', 'Penn Yan', ''),
('KNPA', 'Pensacola, Naval Air Station', 'US', 'United States', 'Pensacola NAS', 'FLZ002'),
('KPNS', 'Pensacola, Pensacola Regional Airport', 'US', 'United States', 'Pensacola', 'FLZ002'),
('KPIA', 'Peoria, Greater Peoria Regional Airport', 'US', 'United States', 'Peoria', 'ILZ029'),
('KP39', 'Pequot Lake', 'US', 'United States', 'Pequot Lakes', 'MNZ034'),
('K40J', 'Perry-Foley, Perry-Foley Airport', 'US', 'United States', 'PerryFoley', ''),
('PAPG', 'Petersburg', 'US', 'United States', 'Petersburg', 'AKZ026'),
('KPTB', 'Petersburg Automatic Weather Observing / Reporting System', 'US', 'United States', 'Petersburg', 'VAZ081'),
('KPNE', 'Philadelphia, Northeast Philadelphia Airport', 'US', 'United States', 'Northeast Philadelphia', 'PAZ071'),
('KPHL', 'Philadelphia, Philadelphia International Airport', 'US', 'United States', 'Philadelphia', 'PAZ071'),
('KPHP', 'Philip, Philip Airport', 'US', 'United States', 'Philip', 'SDZ032'),
('KPBH', 'Phillips / Price County', 'US', 'United States', 'Phillips', 'WIZ009'),
('KAPG', 'Phillips Army Air Field / Aberdeen', 'US', 'United States', 'Aberdeen', ''),
('KPHX', 'Phoenix, Phoenix Sky Harbor International Airport', 'US', 'United States', 'Phoenix', 'AZZ023'),
('KDVT', 'Phoenix, Phoenix-Deer Valley Municipal Airport', 'US', 'United States', 'PhoenixDeer Valley', 'AZZ023'),
('KPIR', 'Pierre, Pierre Regional Airport', 'US', 'United States', 'Pierre', 'SDZ035'),
('K5I3', 'Pikeville Remote Automatic Meteorological Observing System', 'US', 'United States', 'Pikeville', 'KYZ120'),
('KPIB', 'Pine Belt Regional Automatic Weather Observing / Reporting System', 'US', 'United States', 'Laurel', 'MSZ066'),
('KPBF', 'Pine Bluff, Grider Field', 'US', 'United States', 'Pine Bluff', 'ARZ056'),
('KIEN', 'Pine Ridge, Pine Ridge Airport', 'US', 'United States', NULL, NULL),
('KGDP', 'Pine Springs, Guadalupe Mountains National Park', 'US', 'United States', 'Guadalupe Pass', 'TXZ234'),
('KPQN', 'Pipestone Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KPGV', 'Pitt-Greenville Airport', 'US', 'United States', NULL, NULL),
('KAGC', 'Pittsburgh, Allegheny County Airport', 'US', 'United States', 'PittsburghWest Mifflin', 'PAZ021'),
('KPIT', 'Pittsburgh, Pittsburgh International Airport', 'US', 'United States', 'Pittsburgh', 'PAZ021'),
('KPSF', 'Pittsfield, Pittsfield Municipal Airport', 'US', 'United States', NULL, NULL),
('KPLB', 'Plattsburgh, Clinton County Airport', 'US', 'United States', NULL, NULL),
('KPYM', 'Plymouth, Plymouth Municipal Airport', 'US', 'United States', 'Plymouth', 'MAZ018'),
('KPIH', 'Pocatello, Pocatello Regional Airport', 'US', 'United States', 'Pocatello', 'IDZ021'),
('K2PJ', 'Poinsett Range, Sumpter', 'US', 'United States', 'Sumter (2)', 'SCZ031'),
('PAPO', 'Point Hope Automatic Weather Observing / Reporting System', 'US', 'United States', 'Point Hope', 'AKZ001'),
('PPIZ', 'Point Lay', 'US', 'United States', 'Point Lay', 'AKZ001'),
('KNTD', 'Point Mugu, Naval Air Warfare Center', 'US', 'United States', 'Point Mugu', ''),
('K87Q', 'Point Piedras Blanca', 'US', 'United States', 'Point Piedras Blanca', ''),
('KPMP', 'Pompano Beach, Pompano Beach Airpark', 'US', 'United States', 'Pompano Beach', ''),
('KPNC', 'Ponca City, Ponca City Municipal Airport', 'US', 'United States', 'Ponca City', 'OKZ008'),
('KPTK', 'Pontiac, Oakland County International Airport', 'US', 'United States', 'Pontiac', 'MIZ069'),
('KPOB', 'Pope Air Force Base', 'US', 'United States', 'Pope AFB', 'NCZ088'),
('KP02', 'Poplar Bluff, Mo.', 'US', 'United States', 'Poplar Bluff', 'MOZ109'),
('KPOF', 'Poplar Bluff, Poplar Bluff Municipal Airport', 'US', 'United States', NULL, NULL),
('PAAP', 'Port Alexander', 'US', 'United States', 'Port Alexander', 'AKZ026'),
('PALJ', 'Port Alsworth', 'US', 'United States', 'Port Alsworth', ''),
('KNOW', 'Port Angeles Coast Guard Air Sta', 'US', 'United States', NULL, NULL),
('KCLM', 'Port Angeles, William R. Fairchild International Airport', 'US', 'United States', 'Port Angeles', 'WAZ013'),
('PAPC', 'Port Clarence', 'US', 'United States', NULL, NULL),
('PAPH', 'Port Heiden', 'US', 'United States', 'Port Heiden', 'AKZ010'),
('KP58', 'Port Hope', 'US', 'United States', 'Harbor Beach', 'MIZ049'),
('KT31', 'Port Isabel, Port Isabel-Cameron County Airport', 'US', 'United States', NULL, NULL),
('KPTV', 'Porterville Automatic Weather Observing / Reporting System', 'US', 'United States', 'Porterville', 'CAZ021'),
('KPDX', 'Portland, Portland International Airport', 'US', 'United States', 'Portland', 'ORZ006'),
('KPWM', 'Portland, Portland International Jetport', 'US', 'United States', 'Portland', 'MEZ024'),
('KHIO', 'Portland, Portland-Hillsboro Airport', 'US', 'United States', 'Hillsboro', 'ORZ004'),
('KTTD', 'Portland, Portland-Troutdale Airport', 'US', 'United States', 'Troutdale', 'ORZ004'),
('KPTW', 'Pottstown, Pottstown Limerick Airport', 'US', 'United States', NULL, NULL),
('KPOU', 'Poughkeepsie, Dutchess County Airport', 'US', 'United States', 'Poughkeepsie', 'NYZ065'),
('KPTT', 'Pratt Municipal', 'US', 'United States', NULL, NULL),
('KPRC', 'Prescott, Love Field', 'US', 'United States', 'Prescott', 'AZZ008'),
('KPQI', 'Presque Isle', 'US', 'United States', 'Presque Isle', 'MEZ002'),
('KPUC', 'Price, Carbon County Airport', 'US', 'United States', 'PriceCarbon', 'UTZ012'),
('KPNM', 'Princeton', 'US', 'United States', NULL, NULL),
('KPVD', 'Providence, Green State Airport', 'US', 'United States', 'Providence', 'RIZ002'),
('KPVC', 'Provincetown Automatic Weather Observing / Reporting System', 'US', 'United States', 'Provincetown', ''),
('KPVU', 'Provo Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Provo', 'UTZ004'),
('KPUB', 'Pueblo, Pueblo Memorial Airport', 'US', 'United States', 'Pueblo', 'COZ073'),
('KPUW', 'Pullman / Moscow, Pullman / Moscow Regional Airport', 'US', 'United States', 'Pullman', 'WAZ032'),
('KPGD', 'Punta Gorda, Charlotte County Airport', 'US', 'United States', 'Punta Gorda', ''),
('PAPT', 'Puntilla', 'US', 'United States', 'Puntilla Lake', ''),
('KNYG', 'Quantico, Marine Corps Air Facility', 'US', 'United States', 'Quantico', 'VAZ052'),
('KUIL', 'Quillayute, Quillayute State Airport', 'US', 'United States', 'Quillayute', ''),
('KUIN', 'Quincy Municipal / Baldwin', 'US', 'United States', 'Quincy', 'ILZ095'),
('KRAC', 'Racine, Batten International Airport', 'US', 'United States', NULL, NULL),
('KRDU', 'Raleigh / Durham, Raleigh-Durham International Airport', 'US', 'United States', 'RaleighDurham', 'NCZ041'),
('KRNM', 'Ramona, Ramona Airport', 'US', 'United States', NULL, NULL),
('KRND', 'Randolph Air Force Base', 'US', 'United States', 'Randolph AFB', ''),
('KRAP', 'Rapid City, Rapid City Regional Airport', 'US', 'United States', 'Rapid City', 'SDZ031'),
('KRTN', 'Raton, Raton Municipal / Crews Field Airport', 'US', 'United States', NULL, NULL),
('KRWL', 'Rawlins Municipal', 'US', 'United States', 'Rawlins', 'WYZ061'),
('KRDG', 'Reading, Reading Regional Airport', 'US', 'United States', 'Reading', 'PAZ060'),
('KRBL', 'Red Bluff, Red Bluff Municipal Airport', 'US', 'United States', 'Red Bluff', 'CAZ015'),
('KRDK', 'Red Oak', 'US', 'United States', 'Red Oak', 'IAZ080'),
('KRDD', 'Redding, Redding Municipal Airport', 'US', 'United States', 'Redding', 'CAZ013'),
('KRDM', 'Redmond Automatic Weather Observing / Reporting System', 'US', 'United States', 'Redmond', 'ORZ014'),
('KRWF', 'Redwood Falls, Redwood Falls Municipal Airport', 'US', 'United States', 'Redwood Falls', 'MNZ073'),
('KRNO', 'Reno, Reno Tahoe International Airport', 'US', 'United States', 'Reno', 'NVZ003'),
('KRNT', 'Renton, Renton Municipal Airport', 'US', 'United States', 'Renton', 'WAZ007'),
('KRXE', 'Rexburg, Rexburg-Madison County Airport', 'US', 'United States', NULL, NULL),
('KRHI', 'Rhinelander, Rhinelander-Oneida County Airport', 'US', 'United States', 'Rhinelander', 'WIZ010'),
('KRIC', 'Richmond, Richmond International Airport', 'US', 'United States', 'Richmond', 'VAZ071'),
('KLCK', 'Rickenbacker Air National Guard Base', 'US', 'United States', 'Rickenbacker', 'OHZ070'),
('KRIL', 'Rifle, Garfield County Regional Airport', 'US', 'United States', NULL, NULL),
('KRIV', 'Riverside / March Air Force Base', 'US', 'United States', 'Riverside/March AFB', 'CAZ061'),
('KRAL', 'Riverside, Riverside Municipal Airport', 'US', 'United States', 'Riverside', 'CAZ048'),
('KRIW', 'Riverton, Riverton Regional Airport', 'US', 'United States', 'Riverton', 'WYZ013'),
('KRZZ', 'Roanoke Rapids, Halifax County Airport', 'US', 'United States', NULL, NULL),
('KROA', 'Roanoke, Roanoke Regional Airport', 'US', 'United States', 'Roanoke', 'VAZ022'),
('KROC', 'Rochester, Greater Rochester International Airport', 'US', 'United States', 'Rochester', 'NYZ003'),
('KRST', 'Rochester, Rochester Municipal Airport', 'US', 'United States', 'Rochester', 'MNZ087'),
('KUZA', 'Rock Hill, Rock Hill - York County Airport', 'US', 'United States', NULL, NULL),
('KRKS', 'Rock Springs', 'US', 'United States', 'Rock Springs', 'WYZ022'),
('KRFD', 'Rockford, Greater Rockford Airport', 'US', 'United States', 'Rockford', 'ILZ003'),
('KRKD', 'Rockland / Knox Automatic Weather Observing / Reporting System', 'US', 'United States', 'Rockland', 'MEZ027'),
('KRKP', 'Rockport, Aransas County Airport', 'US', 'United States', 'Rockport', 'TXZ245'),
('KRWI', 'Rocky Mount, Rocky Mount-Wilson Airport', 'US', 'United States', 'Rocky Mount', 'NCZ028'),
('KROG', 'Rogers Automatic Weather Observing / Reporting System', 'US', 'United States', 'Rogers', 'ARZ001'),
('KVIH', 'Rolla / Vichy, Rolla National Airport', 'US', 'United States', 'VichyRolla', 'MOZ058'),
('KP88', 'Rome Automatic Meteorological Observing System', 'US', 'United States', NULL, NULL),
('KRMG', 'Rome, R. B. Russell Airport', 'US', 'United States', 'RomeRussell', 'GAZ019'),
('KREO', 'Rome, Rome', 'US', 'United States', NULL, NULL),
('KU67', 'Roosevelt', 'US', 'United States', 'Roosevelt', 'UTZ011'),
('TJNR', 'Roosevelt Roads, Naval Station', 'US', 'United States', NULL, NULL),
('KROX', 'Roseau Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KRBG', 'Roseburg, Roseburg Regional Airport', 'US', 'United States', 'Roseburg', 'ORZ007'),
('KP24', 'Roseglen', 'US', 'United States', 'Roseglen', 'NDZ021'),
('KROW', 'Roswell, Roswell Industrial Air Center Airport', 'US', 'United States', 'Roswell', 'NMZ019'),
('KSRR', 'Ruidoso Regional', 'US', 'United States', NULL, NULL),
('KRUM', 'Rumford', 'US', 'United States', NULL, NULL),
('KRSL', 'Russell, Russell Municipal Airport', 'US', 'United States', 'Russell', 'KSZ032'),
('KRUE', 'Russellville, Russellville Municipal Airport', 'US', 'United States', NULL, NULL),
('KFQD', 'Rutherfordton, Rutherford County-Marchman Field Airport', 'US', 'United States', NULL, NULL),
('KRUT', 'Rutland State Automatic Weather Observing / Reporting System', 'US', 'United States', 'Rutland', 'VTZ011'),
('KRPE', 'Sabine Pass', 'US', 'United States', 'Sabine Pass', ''),
('KSAC', 'Sacramento, Sacramento Executive Airport', 'US', 'United States', 'Sacramento', 'CAZ017'),
('KSMF', 'Sacramento, Sacramento Metropolitan Airport', 'US', 'United States', 'SacramentoWoodland', 'CAZ017'),
('KE74', 'Safford Automatic Meteorological Observing System', 'US', 'United States', NULL, NULL),
('KSAD', 'Safford, Safford Municipal Airport', 'US', 'United States', 'SaffordMunicipal Airport', 'AZZ030'),
('KMBS', 'Saginaw, MBSy International Airport', 'US', 'United States', 'Saginaw', 'MIZ053'),
('KSGU', 'Saint George Automatic Weather Observing / Reporting System', 'US', 'United States', 'St. George', 'UTZ019'),
('K1V4', 'Saint Johnsbury', 'US', 'United States', NULL, NULL),
('PASM', 'Saint Mary\\\'s Automatic Weather Observing / Reporting System', 'US', 'United States', 'Saint Mary\'s', 'AKZ010'),
('PASN', 'Saint Paul', 'US', 'United States', 'Saint Paul', ''),
('KSLE', 'Salem, McNary Field', 'US', 'United States', 'Salem', 'ORZ007'),
('KSLO', 'Salem, Salem-Leckrone Airport', 'US', 'United States', 'Salem', 'ILZ070'),
('KSLN', 'Salina, Salina Municipal Airport', 'US', 'United States', 'Salina', 'KSZ049'),
('KSNS', 'Salinas, Salinas Municipal Airport', 'US', 'United States', 'Salinas', 'CAZ009'),
('KSBY', 'Salisbury, Salisbury-Wicomico County Regional Airport', 'US', 'United States', 'Salisbury', 'MDZ022'),
('K27U', 'Salmon', 'US', 'United States', 'Salmon (2)', 'IDZ009'),
('KSMN', 'Salmon / Lemhi Automatic Weather Observing / Reporting System', 'US', 'United States', 'Salmon', 'IDZ009'),
('KSLC', 'Salt Lake City, Salt Lake City International Airport', 'US', 'United States', 'Salt Lake City', 'UTZ003'),
('KP92', 'Salt Point', 'US', 'United States', 'Salt Point', ''),
('KSJT', 'San Angelo, Mathis Field', 'US', 'United States', 'San Angelo', 'TXZ072'),
('KSAT', 'San Antonio, San Antonio International Airport', 'US', 'United States', 'San Antonio', 'TXZ205'),
('KSSF', 'San Antonio, Stinson Municipal Airport', 'US', 'United States', 'San AntonioStinson', 'TXZ205'),
('KSQL', 'San Carlos Airport', 'US', 'United States', 'San Carlos', 'CAZ006'),
('KSEE', 'San Diego / Gillespie', 'US', 'United States', 'San DiegoSantee', 'CAZ050'),
('KSDM', 'San Diego, Brown Field Municipal Airport', 'US', 'United States', 'San DiegoBrown', 'CAZ050'),
('KNKX', 'San Diego, Miramar, Naval Air Station', 'US', 'United States', 'San DiegoMiramar', 'CAZ043'),
('KMYF', 'San Diego, Montgomery Field', 'US', 'United States', 'San DiegoMontgomery', 'CAZ043'),
('KNZY', 'San Diego, North Island, Naval Air Station', 'US', 'United States', 'San DiegoNorth Island', ''),
('KSAN', 'San Diego, San Diego International-Lindbergh Field', 'US', 'United States', 'San Diego', 'CAZ043'),
('KSFO', 'San Francisco, San Francisco International Airport', 'US', 'United States', 'San Francisco', 'CAZ006'),
('KRHV', 'San Jose / Reid / Hillv', 'US', 'United States', NULL, NULL),
('KSJC', 'San Jose, San Jose International Airport', 'US', 'United States', 'San JoseSanta Clara', 'CAZ008'),
('KSBP', 'San Luis Obispo, San Luis Obispo County-Mc Chesney Field', 'US', 'United States', 'San Luis Obispo', 'CAZ034'),
('KNSI', 'San Nicholas Island', 'US', 'United States', 'San Nicholas Island', 'CAZ039'),
('PASD', 'Sand Point', 'US', 'United States', 'Sand Point', 'AKZ020'),
('KSDB', 'Sandberg', 'US', 'United States', 'Sandberg', ''),
('KP07', 'Sanderson', 'US', 'United States', 'Sanderson', 'TXZ082'),
('KSFM', 'Sanford Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Sanford', 'MEZ023'),
('KSNA', 'Santa Ana, John Wayne Airport-Orange County Airport', 'US', 'United States', 'Santa Ana', 'CAZ042'),
('KSBA', 'Santa Barbara, Santa Barbara Municipal Airport', 'US', 'United States', 'Santa Barbara', 'CAZ039'),
('KSAF', 'Santa Fe, Santa Fe County Municipal Airport', 'US', 'United States', 'Santa Fe', 'NMZ011'),
('KSMX', 'Santa Maria, Santa Maria Public Airport', 'US', 'United States', 'Santa Maria', 'CAZ035'),
('KSMO', 'Santa Monica, Santa Monica Municipal Airport', 'US', 'United States', 'Santa Monica', 'CAZ041'),
('KSTS', 'Santa Rosa, Sonoma County Airport', 'US', 'United States', 'Santa Rosa', 'CAZ005'),
('KEPZ', 'Santa Teresa', 'US', 'United States', NULL, NULL),
('KSLK', 'Saranac Lake, Adirondack Regional Airport', 'US', 'United States', 'Saranac Lake', 'NYZ027'),
('KSRQ', 'Sarasota / Bradenton, Sarasota-Bradenton International Airport', 'US', 'United States', 'Sarasota', 'FLZ060'),
('KANJ', 'Sault Ste. Marie', 'US', 'United States', NULL, NULL),
('KSAV', 'Savannah, Savannah International Airport', 'US', 'United States', 'Savannah', 'GAZ119'),
('PASA', 'Savoonga Airport', 'US', 'United States', NULL, NULL),
('KSPB', 'Scappoose, Scappoose Industrial Airpark', 'US', 'United States', NULL, NULL),
('KSCH', 'Schenectady Airport', 'US', 'United States', 'Schenectady', 'NYZ049'),
('KBLV', 'Scott Air Force Base / Belleville', 'US', 'United States', 'Belleville', 'ILZ101'),
('KBFF', 'Scottsbluff, Heilig Field', 'US', 'United States', 'Scottsbluff', 'NEZ019'),
('KSDL', 'Scottsdale, Scottsdale Airport', 'US', 'United States', 'Scottsdale', 'AZZ023'),
('KBFI', 'Seattle, Seattle Boeing Field', 'US', 'United States', 'SeattleBoeing', 'WAZ007'),
('KSEA', 'Seattle, Seattle-Tacoma International Airport', 'US', 'United States', 'Seattle', 'WAZ007'),
('KDMO', 'Sedalia, Sedalia Memorial Airport', 'US', 'United States', NULL, NULL),
('PASK', 'Selawik', 'US', 'United States', 'Selanik', 'AKZ003'),
('KMTC', 'Selfridge Air National Guard Base', 'US', 'United States', 'Mount Clemens', 'MIZ070'),
('KSEG', 'Selinsgrove, Penn Valley Airport', 'US', 'United States', NULL, NULL),
('PAWD', 'Seward', 'US', 'United States', 'Seward', 'AKZ017'),
('KSXT', 'Sexton Summit,', 'US', 'United States', 'Sexton Summit', 'ORZ008'),
('KGSB', 'Seymour-Johnson Air Force Base', 'US', 'United States', 'Goldsboro', 'NCZ078'),
('KEZF', 'Shannon Airport', 'US', 'United States', 'Shannon Airport', ''),
('KSSC', 'Shaw Air Force Base', 'US', 'United States', 'Sumter', 'SCZ031'),
('KSBM', 'Sheboygan, Sheboygan County Memorial Airport', 'US', 'United States', 'Sheboygan', 'WIZ052'),
('KGEZ', 'Shelbyville, Shelbyville Municipal Airport', 'US', 'United States', NULL, NULL),
('KSHL', 'Sheldon', 'US', 'United States', 'Sheldon', 'IAZ012'),
('KO87', 'Shelter Cove', 'US', 'United States', 'Shelter Cove', 'CAZ001'),
('KSHN', 'Shelton, Sanderson Field', 'US', 'United States', 'Shelton', 'WAZ010'),
('PASY', 'Shemya, Eareckson As', 'US', 'United States', NULL, NULL),
('KSDA', 'Shenandoah Municipal', 'US', 'United States', 'Shenandoah', 'IAZ091'),
('KSHR', 'Sheridan, Sheridan County Airport', 'US', 'United States', 'Sheridan', 'WYZ099'),
('KF39', 'Sherman-Denison', 'US', 'United States', 'ShermanDenison', 'TXZ093'),
('PASH', 'Shishmaref Automatic Weather Observing / Reporting System', 'US', 'United States', 'Shishmaref', 'AKZ006'),
('KSOW', 'Show Low Municipal', 'US', 'United States', 'Show Low', 'AZZ017'),
('KDTN', 'Shreveport, Shreveport Downtown Airport', 'US', 'United States', 'Shreveport Downtown', 'LAZ001'),
('KSHV', 'Shreveport, Shreveport Regional Airport', 'US', 'United States', 'Shreveport Regional', 'LAZ001'),
('KSNY', 'Sidney, Sidney Municipal Airport', 'US', 'United States', 'Sidney', 'NEZ055'),
('KSDY', 'Sidney-Richland', 'US', 'United States', 'Sidney', 'MTZ024'),
('KSLG', 'Siloam Spring Automatic Weather Observing / Reporting System', 'US', 'United States', 'Siloam Springs', 'ARZ001'),
('KBFW', 'Silver Bay', 'US', 'United States', NULL, NULL),
('KSVC', 'Silver City / Grant', 'US', 'United States', 'Silver City', 'NMZ022'),
('KSUX', 'Sioux City, Sioux Gateway Airport', 'US', 'United States', 'Sioux City', 'IAZ031'),
('KFSD', 'Sioux Falls, Foss Field', 'US', 'United States', 'Sioux Falls', 'SDZ062'),
('K8D3', 'Sisseton, Sisseton Municipal Airport', 'US', 'United States', NULL, NULL),
('PASI', 'Sitka, Sitka Airport', 'US', 'United States', 'Sitka', 'AKZ023'),
('PAGY', 'Skagway', 'US', 'United States', 'Skagway', 'AKZ026'),
('PASW', 'Skwentna', 'US', 'United States', 'Skwentna', 'AKZ015'),
('PADT', 'Slana Airport', 'US', 'United States', 'Slana', ''),
('KLIX', 'Slidell', 'US', 'United States', NULL, NULL),
('KASD', 'Slidell, Slidell Airport', 'US', 'United States', NULL, NULL),
('KMQY', 'Smyrna', 'US', 'United States', 'Smyrna', 'TNZ062'),
('PALK', 'Snowshoe Lake', 'US', 'United States', 'Snowshoe Lake', ''),
('KONM', 'Socorro Municipal', 'US', 'United States', 'Socorro', 'NMZ015'),
('KU78', 'Soda Springs / Tigert', 'US', 'United States', 'Soda Springs', 'IDZ023'),
('PASX', 'Soldotna', 'US', 'United States', 'Soldotna', 'AKZ017'),
('KSME', 'Somerset Automatic Weather Observing / Reporting System', 'US', 'United States', 'Somerset', 'KYZ079'),
('KN52', 'Somerville, Somerset Airport', 'US', 'United States', NULL, NULL),
('KSBN', 'South Bend, Michiana Regional Airport', 'US', 'United States', 'South Bend', 'INZ004'),
('PHWH', 'South Kona / Hawaii', 'US', 'United States', NULL, NULL),
('KTVL', 'South Lake Tahoe, Lake Tahoe Airport', 'US', 'United States', 'Tahoe Valley', ''),
('K7R8', 'South Marsh Island', 'US', 'United States', 'South Marsh Island', 'LAZ053'),
('KS58', 'South Timbalier', 'US', 'United States', 'South Timbalier', ''),
('KSOP', 'Southern Pines Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('PASV', 'Sparrevohn Airways Facilities Sector', 'US', 'United States', 'Sparrevohn', ''),
('KSPA', 'Spartanburg Memorial', 'US', 'United States', NULL, NULL),
('KSPF', 'Spearfish / Clyde Ice', 'US', 'United States', NULL, NULL),
('KSPW', 'Spencer, Spencer Municipal Airport', 'US', 'United States', 'Spencer', 'IAZ014'),
('KP35', 'Spickard', 'US', 'United States', 'Spickard', 'MOZ015'),
('KSFF', 'Spokane, Felts Field', 'US', 'United States', 'SpokaneParkwater', 'WAZ034'),
('KGEG', 'Spokane, Spokane International Airport', 'US', 'United States', 'Spokane', 'WAZ034'),
('KASG', 'Springdale Municipal', 'US', 'United States', NULL, NULL),
('KSPI', 'Springfield, Capital Airport', 'US', 'United States', 'Springfield', 'ILZ051'),
('KSPD', 'Springfield, Comanche National Grassland', 'US', 'United States', NULL, NULL),
('KVSF', 'Springfield, Hartness State Springfield Airport', 'US', 'United States', 'Springfield', 'VTZ012'),
('KSGF', 'Springfield, Springfield Regional Airport', 'US', 'United States', 'Springfield', 'MOZ095'),
('KSET', 'St. Charles, St. Charles County Smartt Airport', 'US', 'United States', NULL, NULL),
('KPHN', 'St. Clair County International', 'US', 'United States', NULL, NULL),
('KSTC', 'St. Cloud, St. Cloud Municipal Airport', 'US', 'United States', 'St Cloud', 'MNZ051'),
('KSTJ', 'St. Joseph, Rosecrans Memorial Airport', 'US', 'United States', 'St Joseph', 'MOZ020'),
('KSTL', 'St. Louis, Lambert-St. Louis International Airport', 'US', 'United States', 'St Louis', 'MOZ064'),
('KSUS', 'St. Louis, Spirit Of St. Louis Airport', 'US', 'United States', 'St LouisSpirit', 'MOZ064'),
('KSTP', 'St. Paul, St. Paul Downtown Holman Field', 'US', 'United States', 'St Paul', 'MNZ062'),
('KPIE', 'St. Petersburg / Clearwater, St. Petersburg / Clearwater International Airport', 'US', 'United States', 'St Petersburg / Clearwater', 'FLZ050'),
('KSPG', 'St. Petersburg, Whitted Airport', 'US', 'United States', 'St Petersburg', 'FLZ050'),
('KSMP', 'Stampede Pass', 'US', 'United States', 'Stampede Pass', ''),
('KUNV', 'State College', 'US', 'United States', 'State College', 'PAZ019'),
('KSHD', 'Staunton / Shenandoah', 'US', 'United States', 'Waynesboro', 'VAZ025'),
('KSBS', 'Steamboat Springs', 'US', 'United States', 'Steamboat Springs', 'COZ005'),
('KSEP', 'Stephenville / Clark Field Munic', 'US', 'United States', NULL, NULL),
('KSQI', 'Sterling Rockfalls', 'US', 'United States', NULL, NULL),
('KSWO', 'Stillwater, Stillwater Municipal Airport', 'US', 'United States', 'Stillwater', 'OKZ020'),
('KSCK', 'Stockton, Stockton Metropolitan Airport', 'US', 'United States', 'Stockton', 'CAZ019'),
('KSLB', 'Storm Lake', 'US', 'United States', 'Storm Lake', 'IAZ022'),
('KSUE', 'Sturgeon Bay', 'US', 'United States', 'Sturgeon Bay', 'WIZ022'),
('KSGT', 'Stuttgart Automatic Weather Observing / Reporting System', 'US', 'United States', 'Stuttgart', 'ARZ057'),
('KF30', 'Sulphur Municipal', 'US', 'United States', NULL, NULL),
('K4SU', 'Superior Valley Gunnery Range', 'US', 'United States', NULL, NULL),
('KFWN', 'Sussex, Sussex Airport', 'US', 'United States', NULL, NULL),
('PAJV', 'Sutton', 'US', 'United States', 'Sutton', ''),
('KNJM', 'Swansboro, Bogue Field, Marine Corps Auxiliary Landing Field', 'US', 'United States', NULL, NULL),
('KSYR', 'Syracuse, Syracuse Hancock International Airport', 'US', 'United States', 'Syracuse', 'NYZ018'),
('KTCM', 'Tacoma / McChord Air Force Base', 'US', 'United States', 'TacomaLakewood', 'WAZ007'),
('KTIW', 'Tacoma, Tacoma Narrows Airport', 'US', 'United States', 'Tacoma', 'WAZ007'),
('PATK', 'Talkeetna', 'US', 'United States', 'Talkeetna', 'AKZ015'),
('KTLH', 'Tallahassee, Tallahassee Regional Airport', 'US', 'United States', 'Tallahassee', 'FLZ017'),
('KTBW', 'Tampa Bay Area', 'US', 'United States', NULL, NULL),
('KTPA', 'Tampa, Tampa International Airport', 'US', 'United States', 'Tampa', 'FLZ051'),
('PATA', 'Tanana', 'US', 'United States', 'Tanana', 'AKZ004'),
('KSKX', 'Taos Municipal Airport Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('PATL', 'Tatalina Automatic Weather Observing / Reporting System', 'US', 'United States', 'Tatalina', ''),
('KTAN', 'Taunton, Taunton Municipal Airport', 'US', 'United States', NULL, NULL),
('KTQE', 'Tekamah, Tekamah Municipal Airport', 'US', 'United States', NULL, NULL),
('KTEX', 'Telluride Regional', 'US', 'United States', NULL, NULL),
('KTPL', 'Temple / Miller Automatic Weather Observing / Reporting System', 'US', 'United States', 'Temple', 'TXZ158'),
('KHUF', 'Terre Haute, Hulman Regional Airport', 'US', 'United States', 'Terre Haute', 'INZ051'),
('KTRL', 'Terrell, Terrell Municipal Airport', 'US', 'United States', 'Terrell', ''),
('KTEB', 'Teterboro, Teterboro Airport', 'US', 'United States', 'Teterboro', 'NJZ003'),
('KTXK', 'Texarkana, Texarkana Regional-Webb Field', 'US', 'United States', 'Texarkana', 'ARZ070'),
('KDLS', 'The Dalles, The Dalles Municipal Airport', 'US', 'United States', 'The Dalles', 'ORZ010'),
('KTVF', 'Thief River Automatic Weather Observing / Reporting System', 'US', 'United States', 'Thief River Falls', 'MNZ013'),
('K3TH', 'Thompson Falls', 'US', 'United States', 'Thompson Falls', 'MTZ004'),
('PATC', 'Tin City Airways Facilities Sector', 'US', 'United States', 'Tin City', ''),
('KTIK', 'Tinker Air Force Base', 'US', 'United States', 'Oklahoma CityMidwest City', 'OKZ025'),
('KTIX', 'Titusville', 'US', 'United States', 'Titusville', 'FLZ047'),
('PATG', 'Togiac Village Automatic Weather Observing / Reporting System', 'US', 'United States', 'Togiak Village', 'AKZ010'),
('KTDZ', 'Toledo, Metcalf Field', 'US', 'United States', NULL, NULL),
('KTOL', 'Toledo, Toledo Express Airport', 'US', 'United States', 'Toledo', 'OHZ003'),
('KTDO', 'Toledo-Winlock Memorial', 'US', 'United States', 'Toledo', 'WAZ020'),
('KTPH', 'Tonopah, Tonopah Airport', 'US', 'United States', 'Tonopah', 'NVZ014'),
('KT62', 'Tooele', 'US', 'United States', NULL, NULL),
('KFOE', 'Topeka, Forbes Field', 'US', 'United States', 'TopekaForbes Field', 'KSZ039'),
('KTOP', 'Topeka, Philip Billard Municipal Airport', 'US', 'United States', 'Topeka', 'KSZ039'),
('KTOA', 'Torrance Municipal', 'US', 'United States', 'Torrance', 'CAZ042'),
('K4SL', 'Torreon', 'US', 'United States', 'Cuba Awrs', 'NMZ002'),
('KTOR', 'Torrington, Torrington Municipal Airport', 'US', 'United States', NULL, NULL),
('KTVC', 'Traverse City, Cherry Capital Airport', 'US', 'United States', 'Traverse City', 'MIZ020'),
('KTTN', 'Trenton, Mercer County Airport', 'US', 'United States', 'Trenton', 'NJZ015'),
('KTAD', 'Trinidad / Animas Co.', 'US', 'United States', 'Trinidad', 'COZ077'),
('KTOI', 'Troy, Troy Municipal Airport', 'US', 'United States', NULL, NULL),
('KTRK', 'Truckee-Tahoe', 'US', 'United States', 'Truckee', 'CAZ072'),
('KTCS', 'Truth Or Consequences, Truth Or Consequences Municipal Airport', 'US', 'United States', 'Truth or Consequences', 'NMZ023'),
('KTUS', 'Tucson, Tucson International Airport', 'US', 'United States', 'Tucson', 'AZZ033'),
('KTCC', 'Tucumcari, Tucumcari Municipal Airport', 'US', 'United States', 'Tucumcari', 'NMZ013'),
('KRVS', 'Tulsa, Jones Jr. Airport', 'US', 'United States', NULL, NULL),
('KTUL', 'Tulsa, Tulsa International Airport', 'US', 'United States', 'Tulsa', 'OKZ060'),
('KTUP', 'Tupelo, Tupelo Municipal-Lemons Airport', 'US', 'United States', 'Tupelo', 'MSZ016'),
('KTCL', 'Tuscaloosa, Tuscaloosa Municipal Airport', 'US', 'United States', 'Tuscaloosa', 'ALZ023'),
('KNXP', 'Twenty-Nine Palms, Marine Corps Air-Ground Combat Center', 'US', 'United States', 'Twentynine Palms', 'CAZ028'),
('KTWF', 'Twin Falls, Joslin Field-Magic Valley Regional Airport', 'US', 'United States', 'Twin Falls', 'IDZ015'),
('KTWM', 'Two Harbors', 'US', 'United States', NULL, NULL),
('KTYR', 'Tyler, Tyler Pounds Field', 'US', 'United States', 'Tyler', 'TXZ136'),
('KPAM', 'Tyndall Air Force Base', 'US', 'United States', 'Tyndall AFB', ''),
('KUKI', 'Ukiah Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Ukiah', 'CAZ003'),
('PAUM', 'Umiat', 'US', 'United States', 'Umiat', 'AKZ001'),
('PAUN', 'Unalakleet', 'US', 'United States', 'Unalakleet', 'AKZ006'),
('KUCA', 'Utica, Oneida County Airport', 'US', 'United States', 'Utica', 'NYZ037'),
('KVCB', 'Vacaville, Nut Tree Airport', 'US', 'United States', NULL, NULL),
('PAVD', 'Valdez 2', 'US', 'United States', 'Valdez 2', 'AKZ017'),
('KVLD', 'Valdosta Regional', 'US', 'United States', 'Valdosta', 'GAZ160'),
('KVTN', 'Valentine, Miller Field', 'US', 'United States', 'Valentine', 'NEZ005'),
('KOAX', 'Valley', 'US', 'United States', NULL, NULL),
('KVPS', 'Valparaiso / Eglin Air Force Base', 'US', 'United States', 'Valparaiso', 'FLZ006'),
('KVPZ', 'Valparaiso, Porter County Municipal Airport', 'US', 'United States', NULL, NULL),
('KVNY', 'Van Nuys, Van Nuys Airport', 'US', 'United States', 'Van Nuys', 'CAZ047'),
('KEND', 'Vance Air Force Base / Enid', 'US', 'United States', 'Enid', 'OKZ012'),
('KVUO', 'Vancouver, Pearson Airpark', 'US', 'United States', NULL, NULL),
('KVBG', 'Vandenberg Air Force Base', 'US', 'United States', 'Vandenberg Range', 'CAZ039'),
('KXVW', 'Vandenberg Range', 'US', 'United States', NULL, NULL),
('K7R1', 'Venice, Venice Heliport', 'US', 'United States', 'Venice', ''),
('KVEL', 'Vernal, Vernal Airport', 'US', 'United States', 'Vernal', 'UTZ024'),
('KVRB', 'Vero Beach, Vero Beach Municipal Airport', 'US', 'United States', 'Vero Beach', 'FLZ054'),
('KTVR', 'Vicksburg, Vicksburg / Tallulah Regional Airport', 'US', 'United States', 'Vicksburg', 'MSZ047'),
('KVCT', 'Victoria, Victoria Regional Airport', 'US', 'United States', 'Victoria', 'TXZ234'),
('KMVY', 'Vineyard Haven, Marthas Vineyard Airport', 'US', 'United States', 'Marthas Vineyard', 'MAZ023'),
('KNTU', 'Virginia Beach, Oceana, Naval Air Station', 'US', 'United States', 'Virginia Beach', 'VAZ098'),
('KBCB', 'Virginia Tech Airport', 'US', 'United States', 'Virginia Tech Airport', 'VAZ014'),
('KVIS', 'Visalia Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', 'Visalia', 'CAZ021'),
('KVOK', 'Volk / Camp Douglas', 'US', 'United States', 'Volk Field', ''),
('KACT', 'Waco, Waco Regional Airport', 'US', 'United States', 'Waco', 'TXZ159'),
('PAWI', 'Wainwright Distant Early Warning', 'US', 'United States', NULL, NULL),
('PAFB', 'Wainwright U. S. Army Airfield', 'US', 'United States', 'Wainwright', 'AKZ001'),
('KAKQ', 'Wakefield, Wakefield Municipal Airport', 'US', 'United States', 'Wakefield', 'VAZ088'),
('KALW', 'Walla Walla, Walla Walla Regional Airport', 'US', 'United States', 'Walla Walla', 'WAZ029'),
('KWAL', 'Wallops Island, Wallops Flight Facility Airport', 'US', 'United States', 'Wallops Island', ''),
('KARG', 'Walnut Ridge Automatic Weather Observing / Reporting System', 'US', 'United States', 'Walnut Ridge', 'ARZ017'),
('KWRB', 'Warner Robins Air Force Base', 'US', 'United States', 'Warner Robins', 'GAZ095'),
('KD45', 'Warroad', 'US', 'United States', 'Warroad', 'MNZ005'),
('KAWG', 'Washington', 'US', 'United States', 'Washington', 'IAZ077'),
('KAFJ', 'Washington Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KDCA', 'Washington DC, Reagan National Airport', 'US', 'United States', 'Washington', 'DCZ013'),
('KIAD', 'Washington DC, Washington-Dulles International Airport', 'US', 'United States', 'Washington/Dulles', 'DCZ013'),
('KALO', 'Waterloo, Waterloo Municipal Airport', 'US', 'United States', 'Waterloo', 'IAZ039'),
('KRYV', 'Watertown', 'US', 'United States', NULL, NULL),
('KART', 'Watertown, Watertown International Airport', 'US', 'United States', 'Watertown', 'NYZ007'),
('KATY', 'Watertown, Watertown Municipal Airport', 'US', 'United States', 'Watertown', 'SDZ020'),
('KWVL', 'Waterville Automatic Weather Observing / Reporting System', 'US', 'United States', 'Waterville', 'MEZ021'),
('KWVI', 'Watsonville, Watsonville Municipal Airport', 'US', 'United States', NULL, NULL),
('KAUW', 'Wausau, Wausau Downtown Airport', 'US', 'United States', 'Wausau', 'WIZ030'),
('KAYS', 'Waycross / Ware County, Ga', 'US', 'United States', 'Waycross', 'GAZ151'),
('KEBS', 'Webster City', 'US', 'United States', 'Webster City', ''),
('KEAT', 'Wenatchee, Pangborn Memorial Airport', 'US', 'United States', 'Wenatchee', 'WAZ038'),
('KENV', 'Wendover / Air Force Auxillary Field', 'US', 'United States', 'Wendover', 'UTZ005'),
('KPBI', 'West Palm Beach, Palm Beach International Airport', 'US', 'United States', 'West Palm Beach', 'FLZ068'),
('KUNO', 'West Plains, West Plains Municipal Airport', 'US', 'United States', NULL, NULL),
('KWYS', 'West Yellowstone', 'US', 'United States', 'West Yellowstone', 'MTZ015'),
('KBAF', 'Westfield, Barnes Municipal Airport', 'US', 'United States', 'Westfield', 'MAZ011'),
('KFOK', 'Westhampton Beach, The Gabreski Airport', 'US', 'United States', 'Westhampton', 'NYZ080'),
('KETH', 'Wheaton NDB Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('PHHI', 'Wheeler Air Force Base / Oahu', 'US', 'United States', 'Oahu', 'HIZ002'),
('KHLG', 'Wheeling, Wheeling Ohio County Airport', 'US', 'United States', 'Wheeling', 'WVZ004'),
('KNUW', 'Whidbey Island, Naval Air Station', 'US', 'United States', 'Whidbey Island', 'WAZ009'),
('KHPN', 'White Plains, Westchester County Airport', 'US', 'United States', 'White Plains', 'NYZ070'),
('K2C2', 'White Sands', 'US', 'United States', NULL, NULL),
('KHIE', 'Whitefield, Mount Washington Regional Airport', 'US', 'United States', 'Whitefield', ''),
('KSZL', 'Whiteman Air Force Base', 'US', 'United States', 'Sedalia', 'MOZ045'),
('PAWR', 'Whittier', 'US', 'United States', 'Whittier', 'AKZ015'),
('KSPS', 'Wichita Falls, Sheppard Air Force Base', 'US', 'United States', 'Wichita Falls', 'TXZ086'),
('KAAO', 'Wichita, Colonel James Jabara Airport', 'US', 'United States', NULL, NULL),
('KICT', 'Wichita, Wichita Mid-Continent Airport', 'US', 'United States', 'Wichita', 'KSZ083'),
('KAWH', 'Wildhorse Reservation / Elko', 'US', 'United States', NULL, NULL),
('KWWD', 'Wildwood Automatic Weather Observing / Reporting System', 'US', 'United States', 'Wildwood', 'NJZ024'),
('KAVP', 'Wilkes-Barre - Scranton, Wilkes-Barre / Scranton International Airport', 'US', 'United States', 'Wilkes / Barre', 'PAZ047'),
('KIWA', 'Williams Air Force Base / Chandler', 'US', 'United States', 'Chandler', 'AZZ015'),
('KIPT', 'Williamsport, Williamsport-Lycoming County Airport', 'US', 'United States', 'Williamsport', 'PAZ046'),
('KIJD', 'Willimantic, Windham Airport', 'US', 'United States', NULL, NULL),
('KISN', 'Williston, Sloulin Field International Airport', 'US', 'United States', 'Williston', 'NDZ009'),
('KILL', 'Willmar / Rice Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KLNN', 'Willoughby', 'US', 'United States', 'Willoughby', 'OHZ012'),
('PAUO', 'Willow Airport', 'US', 'United States', 'Willow Airport', 'AKZ015'),
('KNXX', 'Willow Grove, Naval Air Station', 'US', 'United States', NULL, NULL),
('KILN', 'Wilmington, Airborne Airpark Airport', 'US', 'United States', 'Wilmington', 'OHZ072'),
('KILG', 'Wilmington, New Castle County Airport', 'US', 'United States', 'Wilmington', 'DEZ001'),
('KILM', 'Wilmington, New Hanover International Airport', 'US', 'United States', 'Wilmington', 'NCZ101'),
('KOKV', 'Winchester Regional', 'US', 'United States', 'Winchester', 'VAZ028'),
('KRQE', 'Window Rock, Window Rock Airport', 'US', 'United States', NULL, NULL),
('KBDL', 'Windsor Locks, Bradley International Airport', 'US', 'United States', 'Windsor Locks', 'CTZ002'),
('KWLD', 'Winfield / Arkansas City, Strother Field', 'US', 'United States', NULL, NULL),
('KINK', 'Wink, Winkler County Airport', 'US', 'United States', 'Wink', 'TXZ060'),
('KWMC', 'Winnemucca, Winnemucca Municipal Airport', 'US', 'United States', 'Winnemucca', 'NVZ006'),
('KSFD', 'Winner - Bob Wiley Field', 'US', 'United States', NULL, NULL),
('KONA', 'Winona Municipal Automatic Weather Observing / Reporting System', 'US', 'United States', NULL, NULL),
('KINW', 'Winslow, Winslow Municipal Airport', 'US', 'United States', 'Winslow', 'AZZ013'),
('KINT', 'Winston Salem, Smith Reynolds Airport', 'US', 'United States', 'WinstonSalem', 'NCZ021'),
('KGIF', 'Winter Haven, Winter Haven\\\'s Gilbert Airport', 'US', 'United States', 'Winter Haven', ''),
('KIWI', 'Wiscasset, Wiscasset Airport', 'US', 'United States', 'Wiscasset', 'MEZ026'),
('KISW', 'Wisconsin Rapids, Alexander Field South Wood County Airport', 'US', 'United States', 'Wisconsin Rapids', 'WIZ035'),
('KLNP', 'Wise / Lonesome Pine', 'US', 'United States', 'Wise', 'VAZ002'),
('KOLF', 'Wolf Point, Clayton Airport', 'US', 'United States', 'Wolf Point', 'MTZ020'),
('KWWR', 'Woodward, West Woodward Airport', 'US', 'United States', NULL, NULL),
('KBJJ', 'Wooster, Wayne County Airport', 'US', 'United States', 'Wooster', 'OHZ031'),
('KORH', 'Worcester, Worcester Regional Airport', 'US', 'United States', 'Worcester', 'MAZ012'),
('KWRL', 'Worland, Worland Municipal Airport', 'US', 'United States', 'Worland', 'WYZ009'),
('KOTG', 'Worthington Automatic Weather Observing / Reporting System', 'US', 'United States', 'Worthington', 'MNZ089'),
('PAWG', 'Wrangell', 'US', 'United States', 'Wrangell', 'AKZ026'),
('KOSC', 'Wurtsmith Air Force Base', 'US', 'United States', 'Oscoda', 'MIZ036'),
('PACY', 'Yakataga', 'US', 'United States', NULL, NULL),
('KYKM', 'Yakima, Yakima Air Terminal', 'US', 'United States', 'Yakima', 'WAZ025'),
('PAYA', 'Yakutat', 'US', 'United States', 'Yakutat', 'AKZ022'),
('KYKN', 'Yankton Automatic Weather Observing / Reporting System', 'US', 'United States', 'Yankton', 'SDZ069'),
('KP60', 'Yellowstone Lake', 'US', 'United States', 'Yellowstone', 'WYZ001'),
('KTHV', 'York, York Airport', 'US', 'United States', NULL, NULL),
('KYNG', 'Youngstown, Youngstown-Warren Regional Airport', 'US', 'United States', 'Youngstown', 'OHZ033'),
('KYUM', 'Yuma / Yuma International', 'US', 'United States', NULL, NULL),
('KNYL', 'Yuma, Marine Corps Air Station', 'US', 'United States', 'Yuma MCAS', 'AZZ025'),
('KZZV', 'Zanesville, Zanesville Municipal Airport', 'US', 'United States', 'Zanesville', 'OHZ057'),
('PGUM', 'Agana, Guam, Mariana Islands', 'UM', 'United States Minor Outlying Islands', NULL, NULL),
('PGUA', 'Andersen Air Force Base', 'UM', 'United States Minor Outlying Islands', NULL, NULL),
('PGAC', 'Guam, Mariana Island', 'UM', 'United States Minor Outlying Islands', NULL, NULL),
('PJON', 'Johnston Island', 'UM', 'United States Minor Outlying Islands', NULL, NULL),
('NSTU', 'Pago Pago / Int. Airp.', 'UM', 'United States Minor Outlying Islands', NULL, NULL),
('PGWT', 'Peipeinimaru', 'UM', 'United States Minor Outlying Islands', NULL, NULL),
('PGRO', 'Rota Intl / Rota Island', 'UM', 'United States Minor Outlying Islands', NULL, NULL),
('PGSN', 'Saipan / Isley Coast Guard Station', 'UM', 'United States Minor Outlying Islands', NULL, NULL);
# --------------------------------------------------------

#
# Table structure for table `vlwusers`
#

CREATE TABLE vlwusers (
  userid int(5) unsigned NOT NULL default '0',
  icao char(4) NOT NULL default '',
  format char(15) NOT NULL default 'both_imperial',
  PRIMARY KEY  (userid),
  UNIQUE KEY userid (userid)
) TYPE=MyISAM;