/
airport.sql
6200 lines (6199 loc) · 647 KB
/
airport.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
CREATE TABLE airline.airport (
code character(3) NOT NULL,
name character varying(55) NOT NULL,
city character varying(65) NOT NULL,
market character varying(65) NOT NULL,
country character varying(2) NOT NULL,
state character(2) DEFAULT NULL::bpchar,
lat double precision,
long double precision,
tz double precision
);
INSERT INTO airline.airport ( code, name, city, market, country, state, lat, long, tz )
VALUES
( '02A','Afognak Lake Airport','Afognak Lake, AK','Afognak Lake, AK','US','AK',58.10944444,-152.9066667,null ),
( '03A','Bear Creek Mining Strip','Granite Mountain, AK','Granite Mountain, AK','US','AK',65.54805556,-161.0716667,null ),
( '04A','Lik Mining Camp','Lik, AK','Lik, AK','US','AK',68.08333333,-163.1666667,null ),
( '05A','Little Squaw Airport','Little Squaw, AK','Little Squaw, AK','US','AK',67.57,-148.1838889,null ),
( '06A','Kizhuyak Bay','Kizhuyak, AK','Kizhuyak, AK','US','AK',57.74527778,-152.8827778,null ),
( '07A','Klawock Seaplane Base','Klawock, AK','Klawock, AK','US','AK',55.55472222,-133.1016667,null ),
( '08A','Elizabeth Island Airport','Elizabeth Island, AK','Elizabeth Island, AK','US','AK',59.15694444,-151.8291667,null ),
( '09A','Augustin Island','Homer, AK','Homer, AK','US','AK',59.36277778,-153.4305556,null ),
( '1B1','Columbia County','Hudson, NY','Hudson, NY','US','NY',42.29138889,-73.71027778,-5 ),
( '1G4','Grand Canyon West','Peach Springs, AZ','Peach Springs, AZ','US','AZ',35.98611111,-113.8169444,-7 ),
( '1N7','Blairstown Airport','Blairstown, NJ','Blairstown, NJ','US','NJ',40.97111111,-74.9975,-5 ),
( '1NY','Penn Yan Airport','Penn Yan, NY','Penn Yan, NY','US','NY',42.63694444,-77.05277778,-5 ),
( '6B0','Middlebury State','Middlebury, VT','Middlebury, VT','US','VT',43.98555556,-73.09555556,-5 ),
( '7AK','Akun Airport','Akun, AK','Akun, AK','US','AK',54.14472222,-165.6041667,-9 ),
( '8F3','Crosbyton Municipal','Crosbyton, TX','Crosbyton, TX','US','TX',33.62388889,-101.2408333,null ),
( 'A01','Blair Lake','Fairbanks/Ft. Wainwright, AK','Fairbanks, AK','US','AK',64.36361111,-147.3638889,null ),
( 'A02','Deadmans Bay Airport','Deadmans Bay, AK','Deadmans Bay, AK','US','AK',57.06666667,-153.9377778,null ),
( 'A03','Hallo Bay Airport','Hallo Bay, AK','Hallo Bay, AK','US','AK',58.4575,-154.0233333,null ),
( 'A04','Red Lake Airport','Red Lake, AK','Red Lake, AK','US','AK',57.27722222,-154.3422222,null ),
( 'A05','Shell Lake Airport','Shell Lake, AK','Shell Lake, AK','US','AK',61.96388889,-151.5558333,null ),
( 'A06','Navigator Airstrip','Kougarok, AK','Kougarok, AK','US','AK',65.65555556,-165.3563889,null ),
( 'A07','Roland Norton Memorial','Selawik, AK','Selawik, AK','US','AK',66.76611111,-160.1527778,null ),
( 'A08','Pillar Bay Airport','Pillar Bay, AK','Pillar Bay, AK','US','AK',56.59805556,-134.2427778,null ),
( 'A09','Johnstone Point Airport','Johnstone Point, AK','Johnstone Point, AK','US','AK',60.48166667,-146.5841667,null ),
( 'A11','Bell Creek Airport','Bell Creek, AK','Bell Creek, AK','US','AK',60.78388889,-159.5402778,null ),
( 'A12','Cinnabar Airport','Cinnabar, AK','Cinnabar, AK','US','AK',60.78527778,-158.8644444,null ),
( 'A13','Mountaintop Mine Airport','Mountaintop Mine, AK','Mountaintop Mine, AK','US','AK',61.39027778,-157.9955556,null ),
( 'A14','Whitebear Airport','Whitebear, AK','Whitebear, AK','US','AK',61.18888889,-159.8583333,null ),
( 'A16','Arley Lake Airport','Arley Lake, AK','Arley Lake, AK','US','AK',70.74694444,-155.3608333,null ),
( 'A17','Port Vita Airport','Port Vita, AK','Port Vita, AK','US','AK',58.06555556,-153.0725,null ),
( 'A18','Kantishna Airport','Kantishna, AK','Kantishna, AK','US','AK',63.54111111,-150.995,null ),
( 'A1K','Point Thomson Airstrip','Deadhorse1, AK','Deadhorse1, AK','US','AK',70.13611111,-146.29,-9 ),
( 'A20','Alpine Airstrip','Alpine, AK','Alpine, AK','US','AK',70.34416667,-150.9447222,null ),
( 'A21','Serpentine Airport','Serpentine, AK','Serpentine, AK','US','AK',65.85138889,-164.7027778,null ),
( 'A22','Driftwood Bay Airport','Driftwood Bay, AK','Driftwood Bay, AK','US','AK',53.97277778,-166.8569444,null ),
( 'A23','Bradley Lake Airport','Bradley Lake, AK','Bradley Lake, AK','US','AK',59.77611111,-151.9636111,null ),
( 'A24','Chilkat Lake Airport','Chilkat Lake, AK','Chilkat Lake, AK','US','AK',59.33166667,-135.8966667,null ),
( 'A25','Nugget Creek Airport','Nugget Creek, AK','Nugget Creek, AK','US','AK',59.28833333,-136.1738889,null ),
( 'A26','Ivotuk Airstrip','Ivotuk, AK','Ivotuk, AK','US','AK',68.48333333,-155.7333333,null ),
( 'A27','Pogo Mines Airport','Pogo Mines, AK','Pogo Mines, AK','US','AK',64.44,-144.9363889,null ),
( 'A28','Ayakulik River Airport','Ayakulik River, AK','Ayakulik River, AK','US','AK',57.25388889,-154.4222222,null ),
( 'A29','Kiluda Bay Airport','Kiluda Bay, AK','Kiluda Bay, AK','US','AK',57.32305556,-153.1494444,null ),
( 'A30','Terror Lake Airport','Terror Lake, AK','Terror Lake, AK','US','AK',57.96388889,-153.0583333,null ),
( 'A31','Selief Bay Airport','Selief Bay, AK','Selief Bay, AK','US','AK',58.98277778,-153.1833333,null ),
( 'A34','Laura Lake Airport','Laura Lake, AK','Laura Lake, AK','US','AK',58.36194444,-152.3122222,null ),
( 'A35','Bullen Point AFS','Kaktovik, AK','Kaktovik, AK','US','AK',70.17277778,-146.8361111,-9 ),
( 'A36','Deep Bay Airport','Deep Bay, AK','Deep Bay, AK','US','AK',55.56027778,-131.6555556,null ),
( 'A37','Kako Airport','Kako, AK','Kako, AK','US','AK',61.89888889,-161.4397222,null ),
( 'A38','Molly Creek Airport','Molly Creek, AK','Molly Creek, AK','US','AK',64.09722222,-143.2666667,null ),
( 'A39','Ptarmigan Lake Airport','Ptarmigan Lake, AK','Ptarmigan Lake, AK','US','AK',61.86611111,-141.1597222,null ),
( 'A3K','Smith Bay Airport','Smith Bay, AK','Smith Bay, AK','US','AK',70.76583333,-154.2308333,-9 ),
( 'A40','Cape Simpson Airport','Cape Simpson, AK','Cape Simpson, AK','US','AK',71.05694444,-154.7283333,null ),
( 'A42','Teshepkuk Lake Airport','Teshepkuk Lake, AK','Teshepkuk Lake, AK','US','AK',70.35833333,-153.1966667,null ),
( 'A43','Trident Basin Seaplane Base','Kodiak Island, AK','Kodiak Island, AK','US','AK',57.78083333,-152.3911111,null ),
( 'A45','Lake Florence Airport','Lake Florence, AK','Lake Florence, AK','US','AK',57.81666667,-134.5833333,null ),
( 'A46','Lake Hasselborg Airport','Lake Hasselborg, AK','Lake Hasselborg, AK','US','AK',57.7,-134.2666667,null ),
( 'A47','Distin Lake Airport','Distin Lake, AK','Distin Lake, AK','US','AK',57.61666667,-134.3666667,null ),
( 'A48','Port Hobron Airport','Port Hobron, AK','Port Hobron, AK','US','AK',57.15,-153.15,null ),
( 'A49','Mooseville Airstrip Airport','Mooseville Airstrip, AK','Mooseville Airstrip, AK','US','AK',70.28444444,-152.2119444,null ),
( 'A4K','Dune Lake Airport','Dune Lake, AK','Dune Lake, AK','US','AK',64.42138889,-149.8944444,-9 ),
( 'A50','Big Bay Airport','Big Bay, AK','Big Bay, AK','US','AK',58.5625,-152.5961111,null ),
( 'A51','Wien Lake Airport','Wien Lake, AK','Wien Lake, AK','US','AK',64.35277778,-151.275,null ),
( 'A52','Silver Salmon Creek Airport','Silver Salmon Creek, AK','Silver Salmon Creek, AK','US','AK',59.96388889,-152.6822222,null ),
( 'A53','Blear Lake Airport','Blear Lake, AK','Blear Lake, AK','US','AK',64.33333333,-147.5,null ),
( 'A54','Cannery Bay Airport','Cannery Bay, AK','Cannery Bay, AK','US','AK',53.68333333,-166.75,null ),
( 'A56','Johnsons Landing','Bear Lake, AK','Bear Lake, AK','US','AK',56.03666667,-160.2661111,null ),
( 'A57','International Seafoods Airport','International Seafoods, AK','International Seafoods, AK','US','AK',58.26666667,-157.5333333,null ),
( 'A58','Cosna River Airport','Cosna River, AK','Cosna River, AK','US','AK',64.5,-151.6666667,null ),
( 'A59','Ivatuk Airport','Ivatuk, AK','Ivatuk, AK','US','AK',68.48777778,-155.7575,null ),
( 'A61','Cape Sarichef Airport','Cape Sarichef, AK','Cape Sarichef, AK','US','AK',54.5825,-164.9144444,null ),
( 'A62','Taylor Mountain','Taylor Mountain Mine, AK','Taylor Mountain Mine, AK','US','AK',60.86777778,-157.3919444,null ),
( 'A63','Coal Creek','Yukon Charley Rivvers, AK','Yukon Charley Rivvers, AK','US','AK',65.31166667,-143.1341667,null ),
( 'A65','Karluk Portage Airport','Karluk Portage, AK','Karluk Portage, AK','US','AK',57.53833333,-154.1644444,null ),
( 'A66','Hope Airport','Hope, AK','Hope, AK','US','AK',60.90722222,-149.6227778,null ),
( 'A67','Viekoda Bay Airport','Viekoda Bay, AK','Viekoda Bay, AK','US','AK',57.84944444,-153.1152778,null ),
( 'A69','Cathedral Strip','Cold Bay, AK','Cold Bay, AK','US','AK',55.74,-162.1252778,null ),
( 'A70','Village Islands Airport','Village Islands, AK','Village Islands, AK','US','AK',57.77416667,-153.5447222,null ),
( 'A71','Bear Cove Farm','Homer, AK','Homer, AK','US','AK',59.73833333,-151.03,null ),
( 'A72','Chinitna Bay Airport','Chinitna Bay, AK','Chinitna Bay, AK','US','AK',59.83333333,-152.5847222,null ),
( 'A73','McKinley National Park','McKinley Park, AK','McKinley Park, AK','US','AK',63.7325,-148.9105556,null ),
( 'A74','Dog Fish Bay','Nanwalek, AK','Nanwalek, AK','US','AK',59.24111111,-151.8772222,null ),
( 'A75','Malina Bay Airport','Malina Bay, AK','Malina Bay, AK','US','AK',58.17194444,-152.8941667,null ),
( 'A76','Red Fox Bay Airport','Red Fox Bay, AK','Red Fox Bay, AK','US','AK',58.46444444,-152.5930556,null ),
( 'A77','Shearwater Airport','Shearwater, AK','Shearwater, AK','US','AK',57.34333333,-152.8972222,null ),
( 'A78','Lake','Cape Simpson, AK','Cape Simpson, AK','US','AK',71.03,-154.4436111,null ),
( 'A79','Cape Simpson No. 1','Cape Simpson, AK','Cape Simpson, AK','US','AK',71.50166667,-154.0338889,null ),
( 'A80','Cape Simpson No. 7','Cape Simpson, AK','Cape Simpson, AK','US','AK',70.57388889,-155.3213889,null ),
( 'A81','Cape Simpson #1','Aglaq, AK','Aglaq, AK','US','AK',70.66277778,-154.8366667,null ),
( 'A82','Nikiski Private Airstrip','Nikiski, AK','Nikiski, AK','US','AK',60.69027778,-151.2888889,null ),
( 'A83','Petrof Point Airport','Petrof Point, AK','Petrof Point, AK','US','AK',59.37638889,-150.765,null ),
( 'A84','Denali West Lodge Private','Denali, AK','Denali, AK','US','AK',63.75555556,-147.93,null ),
( 'A85','Big River Airport','Big River, AK','Big River, AK','US','AK',61.85944444,-154.2766667,null ),
( 'A87','Carry Inlet Airport','Carry Inlet, AK','Carry Inlet, AK','US','AK',58.58305556,-152.4458333,null ),
( 'A89','Montague Island Airport','Montague Island, AK','Montague Island, AK','US','AK',59.925,-147.5166667,null ),
( 'A90','Shannon Pond Airport','Shannon Pond, AK','Shannon Pond, AK','US','AK',59.03916667,-158.4638889,null ),
( 'A91','Omalik Lagoon Airport','Omalik Lagoon, AK','Omalik Lagoon, AK','US','AK',69.15555556,-163.4972222,null ),
( 'A92','Omolik Lagoon Airport','Omolik Lagoon, AK','Omolik Lagoon, AK','US','AK',69.14805556,-163.5102778,null ),
( 'A93','Bradley Lake Project Airport','Bradley Lake Project, AK','Bradley Lake Project, AK','US','AK',59.79166667,-151.2666667,null ),
( 'A94','Ice Strip','Barrow, AK','Barrow, AK','US','AK',70.57416667,-155.3180556,null ),
( 'A95','Ice Strip','Barrow, AK','Barrow, AK','US','AK',70.31194444,-153.2491667,null ),
( 'A96','Ice Strip','Barrow, AK','Barrow, AK','US','AK',70.98083333,-157.095,null ),
( 'A97','Akulik Air Strip','Akulik, AK','Akulik, AK','US','AK',68.98555556,-163.4797222,null ),
( 'A98','Deadfall Air Strip','Deadfall, AK','Deadfall, AK','US','AK',69.17083333,-163.2563889,null ),
( 'A99','Eagle Creek Airport','Eagle Creek, AK','Eagle Creek, AK','US','AK',68.67666667,-162.6469444,null ),
( 'AA1','Ice Kong','Bethel, AK','Bethel, AK','US','AK',59.95277778,-162.6169444,null ),
( 'AA2','Icicle Seafoods','Naknek-1, AK','Naknek-1, AK','US','AK',58.70944444,-157.0713889,-9 ),
( 'AA4','Glacier Split','Kachemak Bay, AK','Kachemak Bay, AK','US','AK',59.63333333,-151.2083333,null ),
( 'AA5','Selby Lake Airport','Selby Lake, AK','Selby Lake, AK','US','AK',66.95583333,-155.615,null ),
( 'AA7','Independence Creek Airport','Independence Creek, AK','Independence Creek, AK','US','AK',65.67361111,-162.4641667,-9 ),
( 'AA8','Badami','Deadhorse, AK','Deadhorse, AK','US','AK',70.1375,-147.0305556,null ),
( 'AAA','Anaa Airport','Anaa, French Polynesia','Anaa, French Polynesia','PF',' ',-17.3525,-145.51,-10 ),
( 'AAB','Arrabury Station','Arrabury, Australia','Arrabury, Australia','AU',' ',-26.7,141.0416667,10 ),
( 'AAC','El Arish International','El Arish, Egypt','El Arish, Egypt','EG',' ',31.07333333,33.83583333,2 ),
( 'AAD','Ad-Dabbah Airport','Ad-Dabbah, Sudan','Ad-Dabbah, Sudan','SD',' ',18.05,30.93361111,3 ),
( 'AAE','Rabah Bitat','Annaba, Algeria','Annaba, Algeria','DZ',' ',36.82222222,7.80944444,1 ),
( 'AAF','Apalachicola Regional Cleve Randolph Field','Apalachicola, FL','Apalachicola, FL','US','FL',29.7275,-85.0275,-5 ),
( 'AAH','Aachen/Merzbruck','Aachen, Germany','Aachen, Germany','DE',' ',50.82305556,6.1875,1 ),
( 'AAI','Arraias Airport','Arraias, Brazil','Arraias, Brazil','BR',' ',-13.02583333,-46.88361111,-3 ),
( 'AAL','Aalborg Airport','Aalborg, Denmark','Aalborg, Denmark','DK',' ',57.09277778,9.84916667,1 ),
( 'AAM','Malamala','Mala Mala, South Africa','Mala Mala, South Africa','ZA',' ',-24.81694444,31.54416667,2 ),
( 'AAN','Al Ain International','Al Ain, United Arab Emirates','Al Ain, United Arab Emirates','AE',' ',24.26194444,55.6075,4 ),
( 'AAO','Anaco Airport','Anaco, Venezuela','Anaco, Venezuela','VE',' ',9.43,-64.47083333,-4.5 ),
( 'AAQ','Anapa Airport','Anapa, Russia','Anapa, Russia','RU',' ',45.00222222,37.34722222,4 ),
( 'AAR','Aarhus Airport','Aarhus, Denmark','Aarhus, Denmark','DK',' ',56.3,10.61888889,1 ),
( 'AAU','Asau W Sam','Asau, Samoa','Asau, Samoa','WS',' ',-13.51666667,-172.65,13 ),
( 'AAX','Araxa Airport','Araxa, Brazil','Araxa, Brazil','BR',' ',-19.56333333,-46.96027778,-3 ),
( 'ABA','Abakan Airport','Abakan, Russia','Abakan, Russia','RU',' ',53.74,91.38527778,8 ),
( 'ABD','Abadan Airport','Abadan, Iran','Abadan, Iran','IR',' ',30.36527778,48.23305556,3.5 ),
( 'ABE','Lehigh Valley International','Allentown/Bethlehem/Easton, PA','Allentown/Bethlehem/Easton, PA','US','PA',40.65222222,-75.44055556,-5 ),
( 'ABI','Abilene Regional','Abilene, TX','Abilene, TX','US','TX',32.41138889,-99.68194444,-6 ),
( 'ABJ','Felix Houphouet Boigny Abidjan International','Abidjan, Cote d`Ivoire','Abidjan, Cote d`Ivoire','CI',' ',5.26138889,-3.92583333,null ),
( 'ABK','Kebri Dahar','Kabri Dar, Ethiopia','Kabri Dar, Ethiopia','ET',' ',6.73277778,44.24138889,3 ),
( 'ABL','Ambler River','Ambler, AK','Ambler, AK','US','AK',67.0875,-157.8458333,-9 ),
( 'ABQ','Albuquerque International Sunport','Albuquerque, NM','Albuquerque, NM','US','NM',35.03888889,-106.6083333,-7 ),
( 'ABR','Aberdeen Regional','Aberdeen, SD','Aberdeen, SD','US','SD',45.44833333,-98.4225,-6 ),
( 'ABS','Abu Simbel Airport','Abu Simbel, Egypt','Abu Simbel, Egypt','EG',' ',22.37583333,31.61166667,2 ),
( 'ABT','Al-Baha Airport','Al-Baha, Saudi Arabia','Al-Baha, Saudi Arabia','SA',' ',20.29611111,41.63416667,3 ),
( 'ABV','Abuja Nnamdi Azikiwe International','Abuja, Nigeria','Abuja, Nigeria','NG',' ',9.00666667,7.26305556,1 ),
( 'ABX','Albury Airport','Albury, Australia','Albury, Australia','AU',' ',-36.06777778,146.9580556,10 ),
( 'ABY','Southwest Georgia Regional','Albany, GA','Albany, GA','US','GA',31.53555556,-84.19444444,-5 ),
( 'ABZ','Aberdeen Dyce','Aberdeen, United Kingdom','Aberdeen, United Kingdom','GB',' ',57.2025,-2.19805556,null ),
( 'ACA','General Juan N Alvarez International','Acapulco, Mexico','Acapulco, Mexico','MX',' ',16.75694444,-99.75388889,-6 ),
( 'ACB','Antrim County','Bellaire, MI','Bellaire, MI','US','MI',44.98861111,-85.19833333,-5 ),
( 'ACC','Accra Kotoka International','Accra, Ghana','Accra, Ghana','GH',' ',5.60444444,-0.1675,null ),
( 'ACE','Lanzarote','Arrecife, Spain','Arrecife, Spain','ES',' ',28.94555556,-13.60527778,null ),
( 'ACH','St Gallen Altenrhein','Altenrhein, Switzerland','Altenrhein, Switzerland','CH',' ',47.485,9.56,1 ),
( 'ACI','Alderney Airport','Alderney, United Kingdom','Alderney, United Kingdom','GB',' ',49.70666667,-2.21444444,null ),
( 'ACK','Nantucket Memorial','Nantucket, MA','Nantucket, MA','US','MA',41.25305556,-70.06,-5 ),
( 'ACT','Waco Regional','Waco, TX','Waco, TX','US','TX',31.61222222,-97.23027778,-6 ),
( 'ACU','Achutupo Airport','Achutupo, Panama','Achutupo, Panama','PA',' ',8.43333333,-77.96666667,-5 ),
( 'ACV','Arcata','Arcata/Eureka, CA','Eureka/Arcata, CA','US','CA',40.97777778,-124.1083333,-8 ),
( 'ACY','Atlantic City International','Atlantic City, NJ','Atlantic City, NJ','US','NJ',39.4575,-74.57722222,-5 ),
( 'ADA','Adana International','Adana, Turkey','Adana, Turkey','TR',' ',36.98222222,35.28027778,2 ),
( 'ADB','Adnan Menderes','Izmir, Turkey','Izmir, Turkey','TR',' ',38.29222222,27.15583333,2 ),
( 'ADC','Andakombe Airport','Andakombe, Papua New Guinea','Andakombe, Papua New Guinea','PG',' ',-7.13638889,145.7438889,10 ),
( 'ADD','Bole International','Addis Ababa, Ethiopia','Addis Ababa, Ethiopia','ET',' ',8.97805556,38.79944444,3 ),
( 'ADE','Aden International','Aden, Yemen','Aden, Yemen','YE',' ',12.82944444,45.02888889,3 ),
( 'ADJ','Marka International','Amman, Jordan','Amman, Jordan','JO',' ',31.97277778,35.99166667,2 ),
( 'ADK','Adak','Adak Island, AK','Adak Island, AK','US','AK',51.87805556,-176.6458333,-10 ),
( 'ADL','Adelaide International','Adelaide, Australia','Adelaide, Australia','AU',' ',-34.945,138.5305556,9.5 ),
( 'ADM','Ardmore Municipal','Ardmore, OK','Ardmore, OK','US','OK',34.30416667,-97.02055556,-6 ),
( 'ADN','Andes Airport','Andes, Colombia','Andes, Colombia','CO',' ',5.69777778,-75.88027778,-5 ),
( 'ADQ','Kodiak Airport','Kodiak, AK','Kodiak, AK','US','AK',57.75,-152.4938889,-9 ),
( 'ADS','Addison','Dallas, TX','Dallas/Fort Worth, TX','US','TX',32.96861111,-96.83638889,-6 ),
( 'ADT','Ada Municipal','Ada, OK','Ada, OK','US','OK',34.80416667,-96.67111111,-6 ),
( 'ADW','Joint Base Andrews','Camp Springs, MD','Camp Springs, MD','US','MD',38.81083333,-76.86694444,-5 ),
( 'ADX','RAF Leuchars','St Andrews, United Kingdom','St Andrews, United Kingdom','GB',' ',56.37277778,-2.86861111,null ),
( 'ADZ','Gustavo Rojas Pinilla','San Andres Island, Colombia','San Andres Island, Colombia','CO',' ',12.58361111,-81.71138889,-5 ),
( 'AE1','Liwa Airbase','Liwa, United Arab Emirates','Liwa, United Arab Emirates','AE',' ',23.65138889,53.82333333,4 ),
( 'AED','Aleneva Airport','Aleneva, AK','Aleneva, AK','US','AK',58.03333333,-152.9,-9 ),
( 'AEG','Aek Godang','Padang Sidempuan, Indonesia','Padang Sidempuan, Indonesia','ID',' ',1.4,99.43055556,7 ),
( 'AEH','Abeche Airport','Abeche, Chad','Abeche, Chad','TD',' ',13.8475,20.84333333,1 ),
( 'AEO','Aioun El Atrouss Airport','Aioun El Atrouss, Mauritania','Aioun El Atrouss, Mauritania','MR',' ',16.71138889,-9.63777778,null ),
( 'AEP','Aeroparque Jorge Newbery','Buenos Aires, Argentina','Buenos Aires, Argentina','AR',' ',-34.55916667,-58.41583333,-3 ),
( 'AER','Adler/Sochi Airport','Adler/Sochi, Russia','Adler/Sochi, Russia','RU',' ',43.45,39.93333333,4 ),
( 'AES','Vigra','Aalesund, Norway','Aalesund, Norway','NO',' ',62.56027778,6.11027778,1 ),
( 'AET','Allakaket Airport','Allakaket, AK','Allakaket, AK','US','AK',66.55194444,-152.6222222,-9 ),
( 'AEX','Alexandria International','Alexandria, LA','Alexandria, LA','US','LA',31.3275,-92.54861111,-6 ),
( 'AEY','Akureyri Airport','Akureyri, Iceland','Akureyri, Iceland','IS',' ',65.65666667,-18.07194444,null ),
( 'AF2','Bastion Airfield','Lashkar Gah, Afghanistan','Lashkar Gah, Afghanistan','AF',' ',31.85027778,64.22361111,4.5 ),
( 'AF3','Dwyer Airport','Dwyer, Afghanistan','Dwyer, Afghanistan','AF',' ',31.09194444,64.06694444,4.5 ),
( 'AF4','Shindand Airport','Shindand, Afghanistan','Shindand, Afghanistan','AF',' ',33.39222222,62.26111111,4.5 ),
( 'AFA','San Rafael Airport','San Rafael, Argentina','San Rafael, Argentina','AR',' ',-34.58861111,-68.40277778,-3 ),
( 'AFF','USAF Academy Airfield','Colorado Springs, CO','Colorado Springs, CO','US','CO',38.97416667,-104.8177778,-7 ),
( 'AFK','Nebraska City Municipal','Nebraska, NE','Nebraska, NE','US','NE',40.60666667,-95.86666667,null ),
( 'AFO','Afton Municipal','Afton, WY','Afton, WY','US','WY',42.70888889,-110.9422222,-7 ),
( 'AFP','Anson County','Wadesboro, NC','Wadesboro, NC','US','NC',35.02055556,-80.07722222,-5 ),
( 'AFW','Fort Worth Alliance','Dallas/Fort Worth, TX','Dallas/Fort Worth, TX','US','TX',32.98777778,-97.31888889,-6 ),
( 'AFY','Afyon Airport','Afyon, Turkey','Afyon, Turkey','TR',' ',38.72638889,30.60111111,2 ),
( 'AGA','Inezgane','Agadir, Morocco','Agadir, Morocco','MA',' ',30.38138889,-9.54611111,null ),
( 'AGB','Augsburg Airport','Augsburg, Germany','Augsburg, Germany','DE',' ',48.42527778,10.93194444,1 ),
( 'AGC','Allegheny County','Pittsburgh, PA','Pittsburgh, PA','US','PA',40.35444444,-79.92916667,-5 ),
( 'AGF','Agen La Garenne','Agen, France','Agen, France','FR',' ',44.17472222,0.59055556,1 ),
( 'AGG','Angoram Airport','Angoram, Papua New Guinea','Angoram, Papua New Guinea','PG',' ',-4.06583333,144.0738889,10 ),
( 'AGH','Angelholm','Angelholm/Helsingborg, Sweden','Angelholm/Helsingborg, Sweden','SE',' ',56.29166667,12.855,1 ),
( 'AGK','Kagua Airport','Kagua, Papua New Guinea','Kagua, Papua New Guinea','PG',' ',-6.40333333,143.8466667,10 ),
( 'AGL','Wanigela Airport','Wanigela, Papua New Guinea','Wanigela, Papua New Guinea','PG',' ',-9.3375,149.1555556,10 ),
( 'AGN','Angoon Seaplane Base','Angoon, AK','Angoon, AK','US','AK',57.50388889,-134.5833333,-9 ),
( 'AGP','Malaga Costa del Sol','Malaga, Spain','Malaga, Spain','ES',' ',36.68,-4.49583333,1 ),
( 'AGQ','Agrinion Airport','Agrinion, Greece','Agrinion, Greece','GR',' ',38.60194444,21.35111111,2 ),
( 'AGR','Agra Airport','Agra, India','Agra, India','IN',' ',27.15777778,77.96083333,5.5 ),
( 'AGS','Augusta Regional at Bush Field','Augusta, GA','Augusta, GA','US','GA',33.37,-81.96444444,-5 ),
( 'AGT','Guarani International','Ciudad del Este, Paraguay','Ciudad del Este, Paraguay','PY',' ',-25.45555556,-54.84361111,-4 ),
( 'AGU','Jesus Teran International','Aguascalientes, Mexico','Aguascalientes, Mexico','MX',' ',21.70083333,-102.3180556,-6 ),
( 'AGV','Oswaldo Guevara Mujica','Acarigua, Venezuela','Acarigua, Venezuela','VE',' ',9.55333333,-69.2375,-4.5 ),
( 'AGX','Agatti Island Airport','Agatti Island, India','Agatti Island, India','IN',' ',10.83333333,72.2,5.5 ),
( 'AHB','Abha Airport','Abha, Saudi Arabia','Abha, Saudi Arabia','SA',' ',18.24027778,42.65638889,3 ),
( 'AHD','Ardmore Downtown Executive','Ardmore, OK','Ardmore, OK','US','OK',34.14694444,-97.12277778,-6 ),
( 'AHN','Athens/Ben Epps','Athens, GA','Athens, GA','US','GA',33.94861111,-83.32583333,-5 ),
( 'AHO','Alghero','Alghero/Sassari, Italy','Alghero/Sassari, Italy','IT',' ',40.63222222,8.29083333,1 ),
( 'AHS','Auas','Ahuas, Honduras','Ahuas, Honduras','HN',' ',15.47277778,-84.35305556,-6 ),
( 'AHT','Amchitka','Amchitka Island, AK','Amchitka Island, AK','US','AK',51.37861111,179.2586111,-10 ),
( 'AHU','Cherif El Idrissi International','Al Hoceima, Morocco','Al Hoceima, Morocco','MA',' ',35.17722222,-3.83944444,null ),
( 'AIA','Alliance Municipal','Alliance, NE','Alliance, NE','US','NE',42.05333333,-102.8036111,-7 ),
( 'AIB','Anita Bay Airport','Anita Bay, AK','Anita Bay, AK','US','AK',56.19,-132.4458333,-9 ),
( 'AID','Anderson Municipal-Darlington Field','Anderson, IN','Anderson, IN','US','IN',40.10861111,-85.61305556,-5 ),
( 'AIK','Aiken Municipal','Aiken, SC','Aiken, SC','US','SC',33.64944444,-81.685,-5 ),
( 'AIN','Wainwright Airport','Wainwright, AK','Wainwright, AK','US','AK',70.63805556,-159.9947222,-9 ),
( 'AIT','Aitutaki Airport','Aitutaki, Cook Islands','Aitutaki, Cook Islands','CK',' ',-18.8375,-159.7611111,-10 ),
( 'AIZ','Lee C Fine Memorial','Lake of the Ozarks, MO','Lake of the Ozarks, MO','US','MO',38.09611111,-92.54944444,-6 ),
( 'AJA','Ajaccio Napoleon Bonaparte','Ajaccio, France','Ajaccio, France','FR',' ',41.92388889,8.8025,1 ),
( 'AJF','Al Jouf','Jouf, Saudi Arabia','Jouf, Saudi Arabia','SA',' ',29.785,40.1,3 ),
( 'AJJ','Akjoujt Airport','Akjoujt, Mauritania','Akjoujt, Mauritania','MR',' ',19.72805556,-14.38527778,null ),
( 'AJL','Lengpui','Aizwal, India','Aizwal, India','IN',' ',23.84055556,92.61972222,5.5 ),
( 'AJN','Ouani','Anjouan, Comoros','Anjouan, Comoros','KM',' ',-12.13111111,44.43055556,3 ),
( 'AJR','Arvidsjaur Airport','Arvidsjaur, Sweden','Arvidsjaur, Sweden','SE',' ',65.59027778,19.28194444,1 ),
( 'AJU','Santa Maria','Aracaju, Brazil','Aracaju, Brazil','BR',' ',-10.98388889,-37.07027778,-3 ),
( 'AJY','Mano Dayak','Agades, Niger','Agades, Niger','NE',' ',16.96611111,8,1 ),
( 'AK1','Kelly Creek Airstrip','Seward Peninsula, AK','Seward Peninsula, AK','US','AK',65.77277778,-165.8902778,-9 ),
( 'AK2','Bear Fish Camp Airport','Bear Fish Camp, AK','Bear Fish Camp, AK','US','AK',60.71027778,-151.7211111,-9 ),
( 'AK3','Gold King Creek','Fairbanks, AK','Fairbanks, AK','US','AK',64.19805556,-147.9286111,-9 ),
( 'AK4','Squaw Lake Airport','Squaw Lake, AK','Squaw Lake, AK','US','AK',67.58055556,-148.1647222,-9 ),
( 'AK5','Qugruc Airport','Qugruc, AK','Qugruc, AK','US','AK',70.37027778,-150.4211111,-9 ),
( 'AK6','Gold King 2 Airport','Gold King 2, AK','Gold King 2, AK','US','AK',64.07138889,-148,-9 ),
( 'AK7','Hunter Creek','Rampart, AK','Rampart, AK','US','AK',65.47722222,-150.0508333,-9 ),
( 'AK8','Zips Airport','Zips, AK','Zips, AK','US','AK',60.43333333,-151.4833333,-9 ),
( 'AK9','Tolstoi Bay Airport','Tolstoi Bay, AK','Tolstoi Bay, AK','US','AK',55.73333333,-132.4333333,-10 ),
( 'AKB','Atka Airport','Atka, AK','Atka, AK','US','AK',52.22055556,-174.2061111,-10 ),
( 'AKC','Akron Fulton International','Akron, OH','Cleveland, OH (Metropolitan Area)','US','OH',41.0375,-81.46694444,-5 ),
( 'AKF','Kufra','Kufrah, Libya','Kufrah, Libya','LY',' ',24.17888889,23.31388889,2 ),
( 'AKH','Prince Sultan AB','Al Kharj, Saudi Arabia','Al Kharj, Saudi Arabia','SA',' ',24.06805556,47.58194444,3 ),
( 'AKI','Akiak Airport','Akiak, AK','Akiak, AK','US','AK',60.90277778,-161.2305556,-9 ),
( 'AKJ','Asahikawa Airport','Asahikawa, Japan','Asahikawa, Japan','JP',' ',43.67083333,142.4475,9 ),
( 'AKK','Akhiok Airport','Akhiok, AK','Akhiok, AK','US','AK',56.93861111,-154.1825,-9 ),
( 'AKL','Auckland International','Auckland, New Zealand','Auckland, New Zealand','NZ',' ',-37.00805556,174.7916667,12 ),
( 'AKN','King Salmon Airport','King Salmon, AK','King Salmon, AK','US','AK',58.67638889,-156.6486111,-9 ),
( 'AKO','Colorado Plains Regional','Akron, CO','Akron, CO','US','CO',40.17555556,-103.2219444,-7 ),
( 'AKP','Anaktuvuk Pass Airport','Anaktuvuk Pass, AK','Anaktuvuk Pass, AK','US','AK',68.13361111,-151.7433333,-9 ),
( 'AKR','Akure Airport','Akure, Nigeria','Akure, Nigeria','NG',' ',7.24666667,5.30111111,1 ),
( 'AKS','Auki Airport','Auki, Solomon Islands','Auki, Solomon Islands','SB',' ',-8.7025,160.6816667,11 ),
( 'AKT','Akrotiri Airport','Akrotiri, Cyprus','Akrotiri, Cyprus','CY',' ',34.59027778,32.98777778,2 ),
( 'AKX','Aktyubinsk Airport','Aktyubinsk, Kazakhstan','Aktyubinsk, Kazakhstan','KZ',' ',50.25,57.21666667,5 ),
( 'AKY','Sittwe Airport','Sittwe, Burma','Sittwe, Burma','MM',' ',20.13277778,92.8725,6.5 ),
( 'AL1','Albertville Regional-Thomas J Brumlik Field','Albertville, AL','Albertville, AL','US','AL',34.22916667,-86.25583333,-6 ),
( 'AL2','Shelby County','Alabaster, AL','Alabaster, AL','US','AL',33.17777778,-86.78333333,-6 ),
( 'AL3','Huntsville Executive Airport Tom Sharp Jr','Huntsville, AL','Huntsville, AL','US','AL',34.85944444,-86.5575,-6 ),
( 'AL4','South Alabama Regional at Bill Benton Field','Andalusia/Opp, AL','Andalusia/Opp, AL','US','AL',31.30833333,-86.39222222,-6 ),
( 'AL5','Demopolis Regional','Demopolis, AL','Demopolis, AL','US','AL',32.46388889,-87.95416667,-6 ),
( 'AL6','H. L. Sonny Callahan','Fairhope, AL','Fairhope, AL','US','AL',30.46055556,-87.87694444,-6 ),
( 'AL7','Walker County Bevill Field','Jasper, AL','Jasper, AL','US','AL',33.90194444,-87.31388889,-6 ),
( 'ALA','Almaty Airport','Almaty, Kazakhstan','Almaty, Kazakhstan','KZ',' ',43.35555556,77.04388889,6 ),
( 'ALB','Albany International','Albany, NY','Albany, NY','US','NY',42.74916667,-73.80194444,-5 ),
( 'ALC','Alicante Elche','Alicante, Spain','Alicante, Spain','ES',' ',38.28222222,-0.55805556,1 ),
( 'ALE','Alpine Casparis Municipal','Alpine, TX','Alpine, TX','US','TX',30.38416667,-103.6836111,-6 ),
( 'ALF','Alta Airport','Alta, Norway','Alta, Norway','NO',' ',69.97611111,23.37166667,1 ),
( 'ALG','Houari Boumediene','Algiers, Algeria','Algiers, Algeria','DZ',' ',36.6925,3.215,1 ),
( 'ALH','Albany Airport','Albany, Australia','Albany, Australia','AU',' ',-34.94333333,117.8088889,8 ),
( 'ALI','Alice International','Alice, TX','Alice, TX','US','TX',27.74083333,-98.02694444,-6 ),
( 'ALJ','Alexander Bay Airport','Alexander Bay, South Africa','Alexander Bay, South Africa','ZA',' ',-28.575,16.53333333,2 ),
( 'ALK','Asela Airport','Asela, Ethiopia','Asela, Ethiopia','ET',' ',7.58333333,39.06666667,3 ),
( 'ALM','Alamogordo White Sands Regional','Alamogordo, NM','Alamogordo, NM','US','NM',32.84138889,-105.9888889,-7 ),
( 'ALN','St. Louis Regional','Alton, IL','St. Louis, MO','US','IL',38.89,-90.04611111,-6 ),
( 'ALO','Waterloo Regional','Waterloo, IA','Waterloo, IA','US','IA',42.55694444,-92.40027778,-6 ),
( 'ALP','Aleppo International','Aleppo, Syria','Aleppo, Syria','SY',' ',36.18055556,37.22444444,2 ),
( 'ALR','Alexandra Airport','Alexandra, New Zealand','Alexandra, New Zealand','NZ',' ',-45.21138889,169.3716667,12 ),
( 'ALS','San Luis Valley Regional/Bergman Field','Alamosa, CO','Alamosa, CO','US','CO',37.435,-105.8677778,-7 ),
( 'ALT','Alenquer Airport','Alenquer, Brazil','Alenquer, Brazil','BR',' ',-1.94055556,-54.74027778,-3 ),
( 'ALU','Alula Airport','Alula, Somalia','Alula, Somalia','SO',' ',11.98333333,50.78333333,3 ),
( 'ALW','Walla Walla Regional','Walla Walla, WA','Walla Walla, WA','US','WA',46.09527778,-118.2858333,-8 ),
( 'ALX','Thomas C. Russell Field','Alexander City, AL','Alexander City, AL','US','AL',32.91472222,-85.96305556,-6 ),
( 'ALY','Alexandria International','Alexandria, Egypt','Alexandria, Egypt','EG',' ',31.18361111,29.94861111,2 ),
( 'ALZ','Alitak Seaplane Base','Lazy Bay, AK','Lazy Bay, AK','US','AK',56.89583333,-154.2458333,-9 ),
( 'AMA','Rick Husband Amarillo International','Amarillo, TX','Amarillo, TX','US','TX',35.21944444,-101.7058333,-6 ),
( 'AMD','Ahmedabad Airport','Ahmedabad, India','Ahmedabad, India','IN',' ',23.07722222,72.63444444,5.5 ),
( 'AMF','Ama Airport','Ama, Papua New Guinea','Ama, Papua New Guinea','PG',' ',-4.10166667,141.6697222,10 ),
( 'AMG','Amboin Airport','Amboin, Papua New Guinea','Amboin, Papua New Guinea','PG',' ',-4.6,143.5,10 ),
( 'AMH','Arba Minch Airport','Arba Minch, Ethiopia','Arba Minch, Ethiopia','ET',' ',6.03944444,37.59083333,3 ),
( 'AMI','Selaparang','Mataram, Indonesia','Mataram, Indonesia','ID',' ',-8.56083333,116.0947222,8 ),
( 'AMK','Animas Air Park','Durango, CO','Durango, CO','US','CO',37.20305556,-107.8691667,-7 ),
( 'AML','Puerto Armuelles Airport','Puerto Armuelles, Panama','Puerto Armuelles, Panama','PA',' ',8.2675,-82.86472222,-5 ),
( 'AMM','Queen Alia International','Amman, Jordan','Amman, Jordan','JO',' ',31.72333333,35.99416667,2 ),
( 'AMN','Gratiot Community','Alma, MI','Alma, MI','US','MI',43.32222222,-84.68805556,-5 ),
( 'AMO','Mao Airport','Mao, Chad','Mao, Chad','TD',' ',14.14638889,15.31527778,1 ),
( 'AMP','Ampanihy Airport','Ampanihy, Madagascar','Ampanihy, Madagascar','MG',' ',-24.69944444,44.73277778,3 ),
( 'AMQ','Pattimura','Ambon, Indonesia','Ambon, Indonesia','ID',' ',-3.71027778,128.0897222,9 ),
( 'AMS','Schiphol','Amsterdam, Netherlands','Amsterdam, Netherlands','NL',' ',52.30861111,4.76388889,1 ),
( 'AMW','Ames Municipal','Ames, IA','Ames, IA','US','IA',41.99194444,-93.62194444,-6 ),
( 'AMX','Ammaroo Station','Ammaroo, Australia','Ammaroo, Australia','AU',' ',-21.74,135.24,9.5 ),
( 'AMY','Ambatomainty Airport','Ambatomainty, Madagascar','Ambatomainty, Madagascar','MG',' ',-17.68611111,45.625,3 ),
( 'ANA','Anaheim-Disneyland HP','Anaheim, CA','Anaheim, CA','US','CA',33.81666667,-117.9333333,-8 ),
( 'ANB','Anniston Regional','Anniston, AL','Anniston, AL','US','AL',33.58805556,-85.85805556,-6 ),
( 'ANC','Ted Stevens Anchorage International','Anchorage, AK','Anchorage, AK','US','AK',61.17416667,-149.9980556,-9 ),
( 'AND','Anderson Regional','Anderson, SC','Anderson, SC','US','SC',34.49444444,-82.70944444,-5 ),
( 'ANE','Angers Marce','Angers, France','Angers, France','FR',' ',47.56027778,-0.31277778,1 ),
( 'ANF','Cerro Moreno International','Antofagasta, Chile','Antofagasta, Chile','CL',' ',-23.44444444,-70.445,-4 ),
( 'ANG','Angouleme Brie Champniers','Angouleme, France','Angouleme, France','FR',' ',45.72944444,0.21833333,1 ),
( 'ANI','Aniak Airport','Aniak, AK','Aniak, AK','US','AK',61.58166667,-159.5430556,-9 ),
( 'ANK','Etimesgut','Ankara, Turkey','Ankara, Turkey','TR',' ',39.95194444,32.68611111,2 ),
( 'ANM','Antsirabato','Antalaha, Madagascar','Antalaha, Madagascar','MG',' ',-14.99944444,50.32027778,3 ),
( 'ANN','Annette Island','Annette, AK','Annette, AK','US','AK',55.04222222,-131.5708333,-9 ),
( 'ANO','Angoche Airport','Angoche, Mozambique','Angoche, Mozambique','MZ',' ',-16.1825,39.94527778,2 ),
( 'ANP','Lee','Annapolis, MD','Annapolis, MD','US','MD',38.94277778,-76.56833333,-5 ),
( 'ANR','Deurne','Antwerp, Belgium','Antwerp, Belgium','BE',' ',51.18944444,4.46027778,1 ),
( 'ANS','Andahuaylas Airport','Andahuaylas, Peru','Andahuaylas, Peru','PE',' ',-13.70888889,-73.35138889,-5 ),
( 'ANU','V C Bird International','St. Johns, Antigua and Barbuda','St. Johns, Antigua and Barbuda','AG',' ',17.13611111,-61.79388889,-4 ),
( 'ANV','Anvik Airport','Anvik, AK','Anvik, AK','US','AK',62.64722222,-160.19,-9 ),
( 'ANX','Andoya','Andeness, Norway','Andeness, Norway','NO',' ',69.2925,16.14416667,1 ),
( 'AOH','Lima Allen County','Lima, OH','Lima, OH','US','OH',40.70833333,-84.02694444,-5 ),
( 'AOI','Falconara','Ancona, Italy','Ancona, Italy','IT',' ',43.61638889,13.36222222,1 ),
( 'AOJ','Aomori Airport','Aomori, Japan','Aomori, Japan','JP',' ',40.73333333,140.6886111,9 ),
( 'AOK','Karpathos Airport','Karpathos, Greece','Karpathos, Greece','GR',' ',35.42083333,27.14555556,2 ),
( 'AOL','Paso de Los Libres Airport','Paso de Los Libres, Argentina','Paso de Los Libres, Argentina','AR',' ',-29.68944444,-57.15194444,-3 ),
( 'AOO','Altoona-Blair County','Altoona, PA','Altoona, PA','US','PA',40.29638889,-78.32,-5 ),
( 'AOR','Sultan Abdul Halim','Alor Setar, Malaysia','Alor Setar, Malaysia','MY',' ',6.18972222,100.3983333,8 ),
( 'AOS','Amook Bay Airport','Amook Bay, AK','Amook Bay, AK','US','AK',57.45472222,-153.8130556,-9 ),
( 'APA','Centennial','Denver, CO','Denver, CO','US','CO',39.57,-104.8494444,-7 ),
( 'APB','Apolo Airport','Apolo, Bolivia','Apolo, Bolivia','BO',' ',-14.73888889,-68.41111111,-4 ),
( 'APC','Napa County','Napa, CA','Napa, CA','US','CA',38.21305556,-122.2805556,-8 ),
( 'APE','San Juan Aposento Airport','San Juan Aposento, Peru','San Juan Aposento, Peru','PE',' ',-15.35,-75.16666667,-5 ),
( 'APF','Naples Municipal','Naples, FL','Naples, FL','US','FL',26.1525,-81.77555556,-5 ),
( 'APG','Phillips AAF','Aberdeen, MD','Aberdeen, MD','US','MD',39.46611111,-76.16888889,-5 ),
( 'API','Gomez Nino Apiay AB','Villavicencio, Colombia','Villavicencio, Colombia','CO',' ',4.07611111,-73.56277778,-5 ),
( 'APK','Apataki Airport','Apataki, French Polynesia','Apataki, French Polynesia','PF',' ',-15.57527778,-146.4130556,-10 ),
( 'APL','Nampula Airport','Nampula, Mozambique','Nampula, Mozambique','MZ',' ',-15.10555556,39.28166667,2 ),
( 'APN','Alpena County Regional','Alpena, MI','Alpena, MI','US','MI',45.07805556,-83.56027778,-5 ),
( 'APO','Apartado Airport','Apartado, Colombia','Apartado, Colombia','CO',' ',7.03333333,-77.2,-5 ),
( 'APR','April River Airport','April River, Papua New Guinea','April River, Papua New Guinea','PG',' ',-4.67361111,142.5377778,10 ),
( 'APT','Marion County Brown Field','Jasper, TN','Jasper, TN','US','TN',35.06055556,-85.58527778,-6 ),
( 'APV','Apple Valley Airport','Apple Valley, CA','Apple Valley, CA','US','CA',34.57527778,-117.1861111,-8 ),
( 'APW','Faleolo International','Apia, Samoa','Apia, Samoa','WS',' ',-13.83,-172.0083333,13 ),
( 'AQI','Al Qaisumah','Qaisumah, Saudi Arabia','Hafr Al Batin, Saudi Arabia','SA',' ',28.33527778,46.125,3 ),
( 'AQJ','Aqaba King Hussein International','Aqaba, Jordan','Aqaba, Jordan','JO',' ',29.61111111,35.01777778,2 ),
( 'AQP','Rodriguez Ballon International','Arequipa, Peru','Arequipa, Peru','PE',' ',-16.34055556,-71.57083333,-5 ),
( 'AQS','Saqani Airport','Saqani, Fiji','Saqani, Fiji','FJ',' ',-16.75,179.35,12 ),
( 'AQY','Girdwood Airport','Girdwood, AK','Girdwood, AK','US','AK',60.96888889,-149.1194444,-9 ),
( 'AR1','Russellville Regional','Russellville, AR','Russellville, AR','US','AR',35.25916667,-93.09333333,-6 ),
( 'AR2','Dennis F Cantrell Field','Conway, AR','Conway, AR','US','AR',35.08111111,-92.42444444,-6 ),
( 'ARA','Acadiana Regional','New Iberia, LA','New Iberia, LA','US','LA',30.03777778,-91.88388889,-6 ),
( 'ARB','Ann Arbor Municipal','Ann Arbor, MI','Ann Arbor, MI','US','MI',42.22305556,-83.74555556,-5 ),
( 'ARC','Arctic Village Airport','Arctic Village, AK','Arctic Village, AK','US','AK',68.11472222,-145.5794444,-9 ),
( 'ARD','Arcadia Municipal','Alor, Indonesia','Alor, Indonesia','ID',' ',-8.25,124.75,8 ),
( 'ARE','Antonio/Nery/Juarbe Pol','Arecibo, PR','Arecibo, PR','US','PR',18.45083333,-66.67555556,-4 ),
( 'ARG','Walnut Ridge Regional','Walnut Ridge, AR','Walnut Ridge, AR','US','AR',36.12472222,-90.925,-6 ),
( 'ARH','Arkhangelsk Airport','Arkhangelsk, Russia','Arkhangelsk, Russia','RU',' ',64.60027778,40.71666667,4 ),
( 'ARI','Chacalluta','Arica, Chile','Arica, Chile','CL',' ',-18.34861111,-70.33861111,-4 ),
( 'ARK','Arusha Airport','Arusha, Tanzania','Arusha, Tanzania','TZ',' ',-3.36666667,36.62555556,3 ),
( 'ARM','Armidale Airport','Armidale, Australia','Armidale, Australia','AU',' ',-30.52805556,151.6172222,10 ),
( 'ARN','Arlanda','Stockholm, Sweden','Stockholm, Sweden','SE',' ',59.65194444,17.91861111,1 ),
( 'ARP','Aragip Airport','Aragip, Papua New Guinea','Aragip, Papua New Guinea','PG',' ',-9.87083333,149.4841667,10 ),
( 'ARQ','Arauquita Airport','Arauquita, Colombia','Arauquita, Colombia','CO',' ',7.02111111,-71.38888889,-5 ),
( 'ARS','Aragarcas Airport','Aragarcas, Brazil','Aragarcas, Brazil','BR',' ',-15.89944444,-52.24111111,-3 ),
( 'ART','Watertown International','Watertown, NY','Watertown, NY','US','NY',43.99194444,-76.02055556,-5 ),
( 'ARU','Aracatuba Airport','Aracatuba, Brazil','Aracatuba, Brazil','BR',' ',-21.14138889,-50.42472222,-3 ),
( 'ARV','Lakeland/Noble F. Lee Memorial Field','Minocqua/Woodruff, WI','Minocqua/Woodruff, WI','US','WI',45.92805556,-89.73083333,-6 ),
( 'ARW','Arad Airport','Arad, Romania','Arad, Romania','RO',' ',46.17666667,21.26194444,2 ),
( 'ARY','Ararat Airport','Ararat, Australia','Ararat, Australia','AU',' ',-37.30944444,142.9886111,10 ),
( 'ARZ','Nzeto Airport','N`zeto, Angola','N`zeto, Angola','AO',' ',-7.25888889,12.8625,1 ),
( 'ASA','Assab International','Assab, Eritrea','Assab, Eritrea','ER',' ',13.07166667,42.645,3 ),
( 'ASB','Ashgabat Airport','Ashgabat, Turkmenistan','Ashgabat, Turkmenistan','TM',' ',37.98694444,58.36111111,5 ),
( 'ASC','Ascension Airport','Ascension, Bolivia','Ascension, Bolivia','BO',' ',-15.91666667,-63.15,-4 ),
( 'ASD','Fresh Creek','Andros Town, The Bahamas','Andros Town, The Bahamas','BS',' ',24.69805556,-77.79555556,-5 ),
( 'ASE','Aspen Pitkin County Sardy Field','Aspen, CO','Aspen, CO','US','CO',39.22194444,-106.8683333,-7 ),
( 'ASF','Narimanova','Astrakhan , Russia','Astrakhan , Russia','RU',' ',46.28277778,48.01083333,3 ),
( 'ASG','Ashburton Airport','Ashburton, New Zealand','Ashburton, New Zealand','NZ',' ',-43.90277778,171.7997222,12 ),
( 'ASH','Boire Field','Nashua, NH','Nashua, NH','US','NH',42.7825,-71.51416667,-5 ),
( 'ASI','Ascension Aux Af','Ascension Island, Saint Helena, Ascension, and Tristan da Cunha','Ascension Island, Saint Helena, Ascension, and Tristan da Cunha','SH',' ',-7.96972222,-14.39361111,null ),
( 'ASJ','Amami','Amami O Shima, Japan','Amami O Shima, Japan','JP',' ',28.43055556,129.7125,9 ),
( 'ASK','Yamoussoukro Airport','Yamoussoukro, Cote d`Ivoire','Yamoussoukro, Cote d`Ivoire','CI',' ',6.90305556,-5.36611111,null ),
( 'ASL','Harrison County','Marshall, TX','Marshall, TX','US','TX',32.52055556,-94.30777778,-6 ),
( 'ASM','Asmara International','Asmara, Eritrea','Asmara, Eritrea','ER',' ',15.29194444,38.91111111,3 ),
( 'ASN','Talladega Municipal','Talladega, AL','Talladega, AL','US','AL',33.56944444,-86.05111111,-6 ),
( 'ASO','Asosa Hidase','Asosa, Ethiopia','Asosa, Ethiopia','ET',' ',10.02055556,34.58222222,3 ),
( 'ASP','Alice Springs Airport','Alice Springs, Australia','Alice Springs, Australia','AU',' ',-23.80833333,133.9008333,9.5 ),
( 'ASQ','Austin Airport','Austin, NV','Austin, NV','US','NV',39.46805556,-117.1975,-8 ),
( 'ASR','Kayseri Airport','Kayseri, Turkey','Kayseri, Turkey','TR',' ',38.77027778,35.49555556,2 ),
( 'AST','Astoria Regional','Astoria/Seaside, OR','Astoria/Seaside, OR','US','OR',46.15805556,-123.8786111,-8 ),
( 'ASU','Silvio Pettirossi International','Asuncion, Paraguay','Asuncion, Paraguay','PY',' ',-25.24111111,-57.51694444,-4 ),
( 'ASW','Aswan International','Aswan, Egypt','Aswan, Egypt','EG',' ',23.96444444,32.82,2 ),
( 'ASX','John F Kennedy Memorial','Ashland, WI','Ashland, WI','US','WI',46.54861111,-90.91888889,-6 ),
( 'ASY','Ashley Municipal','Ashley, ND','Ashley, ND','US','ND',46.02388889,-99.3525,-6 ),
( 'ATA','Anta Huaraz','Anta, Peru','Anta, Peru','PE',' ',-9.34722222,-77.6,-5 ),
( 'ATB','Atbara Airport','Atbara, Sudan','Atbara, Sudan','SD',' ',17.70972222,34.05722222,3 ),
( 'ATC','Arthur=`s Town Airport','Arthur`s Town, The Bahamas','Arthur`s Town, The Bahamas','BS',' ',24.62944444,-75.67388889,-5 ),
( 'ATE','Antlers Municipal','Antlers, OK','Antlers, OK','US','OK',34.1925,-95.64972222,-6 ),
( 'ATH','Eleftherios Venizelos International','Athens, Greece','Athens, Greece','GR',' ',37.93666667,23.94444444,2 ),
( 'ATI','Artigas International','Artigas, Uruguay','Artigas, Uruguay','UY',' ',-30.40083333,-56.50777778,-3 ),
( 'ATK','Atqasuk Edward Burnell Sr. Memorial','Atqasuk, AK','Atqasuk, AK','US','AK',70.46722222,-157.4355556,-9 ),
( 'ATL','Hartsfield-Jackson Atlanta International','Atlanta, GA','Atlanta, GA (Metropolitan Area)','US','GA',33.63666667,-84.42777778,-5 ),
( 'ATM','Altamira Airport','Altamira, Brazil','Altamira, Brazil','BR',' ',-3.25305556,-52.25388889,-3 ),
( 'ATN','Namatanai Airport','Namatanai, Papua New Guinea','Namatanai, Papua New Guinea','PG',' ',-3.66972222,152.4380556,10 ),
( 'ATO','Ohio University','Athens, OH','Athens, OH','US','OH',39.21194444,-82.22916667,-5 ),
( 'ATP','Aitape Airport','Aitape, Papua New Guinea','Aitape, Papua New Guinea','PG',' ',-3.1425,142.3466667,10 ),
( 'ATQ','Amritsar Airport','Amritsar, India','Amritsar, India','IN',' ',31.71138889,74.79638889,5.5 ),
( 'ATR','Atar Airport','Atar, Mauritania','Atar, Mauritania','MR',' ',20.50666667,-13.04305556,null ),
( 'ATS','Artesia Municipal','Artesia, NM','Artesia, NM','US','NM',32.85166667,-104.4672222,-7 ),
( 'ATT','Atmautluak Airport','Atmautluak, AK','Atmautluak, AK','US','AK',60.86777778,-162.2741667,-9 ),
( 'ATU','Casco Cove CGS','Attu, AK','Attu, AK','US','AK',52.8325,173.1755556,-10 ),
( 'ATV','Ati Airport','Ati, Chad','Ati, Chad','TD',' ',13.23972222,18.31555556,1 ),
( 'ATW','Appleton International','Appleton, WI','Appleton, WI','US','WI',44.25805556,-88.51916667,-6 ),
( 'ATY','Watertown Regional','Watertown, SD','Watertown, SD','US','SD',44.91388889,-97.15472222,-6 ),
( 'ATZ','Assiut Airport','Assiut, Egypt','Assiut, Egypt','EG',' ',27.04638889,31.07861111,2 ),
( 'AU1','Scherger','Weipa, Australia','Weipa, Australia','AU',' ',-12.62388889,142.0872222,10 ),
( 'AUA','Reina Beatrix International','Aruba, Aruba','Aruba, Aruba','AW',' ',12.50138889,-70.01555556,-4 ),
( 'AUC','Santiago Perez','Arauca, Colombia','Arauca, Colombia','CO',' ',7.06888889,-70.73694444,-5 ),
( 'AUD','Augustus Downs Airport','Augustus Downs, Australia','Augustus Downs, Australia','AU',' ',-18.51555556,139.8786111,10 ),
( 'AUG','Augusta State','Augusta/Waterville, ME','Augusta/Waterville, ME','US','ME',44.32055556,-69.79722222,-5 ),
( 'AUH','Abu Dhabi International','Abu Dhabi, United Arab Emirates','Abu Dhabi, United Arab Emirates','AE',' ',24.44333333,54.65277778,4 ),
( 'AUI','Aua Island Airport','Aua Island, Papua New Guinea','Aua Island, Papua New Guinea','PG',' ',-1.46222222,143.0644444,10 ),
( 'AUK','Alakanuk Airport','Alakanuk, AK','Alakanuk, AK','US','AK',62.68305556,-164.7222222,-9 ),
( 'AUM','Austin Municipal','Austin/Albert Lea, MN','Austin/Albert Lea, MN','US','MN',43.66277778,-92.93305556,-6 ),
( 'AUN','Auburn Municipal','Auburn, CA','Auburn, CA','US','CA',38.95472222,-121.0816667,-8 ),
( 'AUO','Auburn University Regional','Auburn, AL','Auburn, AL','US','AL',32.615,-85.43388889,-6 ),
( 'AUP','Aguan Papua N.G.','Aguan, Papua New Guinea','Aguan, Papua New Guinea','PG',' ',-9.91666667,149.3333333,10 ),
( 'AUQ','Hiva Oa/Atuona','Atuona, French Polynesia','Atuona, French Polynesia','PF',' ',-9.76583333,-139.0097222,-9.5 ),
( 'AUR','Aurillac Airport','Aurillac, France','Aurillac, France','FR',' ',44.89111111,2.42194444,1 ),
( 'AUS','Austin - Bergstrom International','Austin, TX','Austin, TX','US','TX',30.19444444,-97.67,-6 ),
( 'AUW','Wausau Downtown','Wausau, WI','Wausau/Mosinee/Stevens Point, WI','US','WI',44.92638889,-89.62666667,-6 ),
( 'AUX','Araguaina Airport','Araguaina, Brazil','Araguaina, Brazil','BR',' ',-7.22777778,-48.24055556,-3 ),
( 'AUY','Aneityum Airport','Aneityum, Vanuatu','Aneityum, Vanuatu','VU',' ',-20.24944444,169.7708333,11 ),
( 'AUZ','Aurora Municipal','Aurora, IL','Aurora, IL','US','IL',41.77194444,-88.47555556,-6 ),
( 'AVB','Aviano AB','Aviano, Italy','Aviano, Italy','IT',' ',46.03111111,12.59638889,1 ),
( 'AVI','Maximo Gomez','Ciego de Avila, Cuba','Ciego de Avila, Cuba','CU',' ',22.02694444,-78.78972222,-5 ),
( 'AVL','Asheville Regional','Asheville, NC','Asheville, NC','US','NC',35.43444444,-82.54277778,-5 ),
( 'AVN','Avignon Caumont','Avignon, France','Avignon, France','FR',' ',43.90666667,4.90194444,1 ),
( 'AVO','Avon Park Executive','Avon Park, FL','Avon Park, FL','US','FL',27.59138889,-81.52888889,-5 ),
( 'AVP','Wilkes Barre Scranton International','Scranton/Wilkes-Barre, PA','Scranton/Wilkes-Barre, PA','US','PA',41.33833333,-75.72333333,-5 ),
( 'AVV','Avalon Airport','Avalon, Australia','Avalon, Australia','AU',' ',-38.03944444,144.4694444,10 ),
( 'AVW','Marana Regional','Tucson, AZ','Tucson, AZ','US','AZ',32.40944444,-111.2183333,-7 ),
( 'AWA','Lake Awasa','Awasa, Ethiopia','Awasa, Ethiopia','ET',' ',7.06666667,38.49055556,3 ),
( 'AWK','Wake Island Airfield','Wake Island, TT','Wake Island, TT','US','TT',19.2825,166.6366667,12 ),
( 'AWM','West Memphis Municipal','West Memphis, AR','West Memphis, AR','US','AR',35.135,-90.23444444,-6 ),
( 'AWR','Awar Airport','Awar, Papua New Guinea','Awar, Papua New Guinea','PG',' ',-4.12416667,144.8702778,10 ),
( 'AWX','Andrews County','Andrews, TX','Andrews, TX','US','TX',32.33083333,-102.5297222,null ),
( 'AWZ','Ahwaz Airport','Ahwaz, Iran','Ahwaz, Iran','IR',' ',31.3375,48.76194444,3.5 ),
( 'AXA','Clayton J. Lloyd','The Valley, Anguilla','The Valley, Anguilla','AI',' ',18.20472222,-63.05388889,-4 ),
( 'AXB','Maxson Airfield','Alexandria Bay, NY','Alexandria Bay, NY','US','NY',44.31666667,-75.89972222,-5 ),
( 'AXC','Aramac Airport','Aramac, Australia','Aramac, Australia','AU',' ',-22.96333333,145.2516667,10 ),
( 'AXD','Dimokritos','Alexandroupolis, Greece','Alexandroupolis, Greece','GR',' ',40.85583333,25.95611111,2 ),
( 'AXM','El Eden','Armenia, Colombia','Armenia, Colombia','CO',' ',4.45083333,-75.76666667,-5 ),
( 'AXN','Chandler Field','Alexandria, MN','Alexandria, MN','US','MN',45.86638889,-95.39472222,-6 ),
( 'AXP','Spring Point Airport','Spring Point, The Bahamas','Spring Point, The Bahamas','BS',' ',22.44194444,-73.97055556,-5 ),
( 'AXS','Altus/Quartz Mountain Regional','Altus, OK','Altus, OK','US','OK',34.69888889,-99.33833333,-6 ),
( 'AXT','Akita Airport','Akita, Japan','Akita, Japan','JP',' ',39.61555556,140.2186111,9 ),
( 'AXU','Axum Airport','Axum, Ethiopia','Axum, Ethiopia','ET',' ',14.14694444,38.7725,3 ),
( 'AXV','Neil Armstrong','Wapakoneta, OH','Wapakoneta, OH','US','OH',40.49361111,-84.29805556,-5 ),
( 'AXX','Angel Fire','Eagle Nest, NM','Eagle Nest, NM','US','NM',36.42194444,-105.29,-7 ),
( 'AYL','Anthony Lagoon Airport','Anthony Lagoon, Australia','Anthony Lagoon, Australia','AU',' ',-18.01666667,135.55,9.5 ),
( 'AYP','Coronel FAP Alfredo Mendivil Duarte','Ayacucho, Peru','Ayacucho, Peru','PE',' ',-13.15472222,-74.20444444,-5 ),
( 'AYQ','Ayers Rock Connellan','Ayers Rock, Australia','Ayers Rock, Australia','AU',' ',-25.18611111,130.9755556,9.5 ),
( 'AYR','Ayr Airport','Ayr, Australia','Ayr, Australia','AU',' ',-19.59666667,147.325,10 ),
( 'AYS','Waycross-Ware County','Waycross, GA','Waycross, GA','US','GA',31.24833333,-82.39527778,-5 ),
( 'AYT','Antalya Airport','Antalya, Turkey','Antalya, Turkey','TR',' ',36.89861111,30.80055556,2 ),
( 'AYW','Ayawasi Airport','Ayawasi, Indonesia','Ayawasi, Indonesia','ID',' ',-1.15972222,132.4633333,9 ),
( 'AZ1','Valle','Grand Canyon, AZ','Grand Canyon, AZ','US','AZ',35.65055556,-112.1480556,-7 ),
( 'AZ2','H. A. Clark Memorial Field','Williams, AZ','Williams, AZ','US','AZ',35.30555556,-112.1944444,-7 ),
( 'AZ3','Glendale Municipal','Glendale, AZ','Phoenix, AZ','US','AZ',33.52694444,-112.2952778,-7 ),
( 'AZ4','Sheepy Hollow Ranch','Salome, AZ','Salome, AZ','US','AZ',33.7875,-113.6425,-7 ),
( 'AZ5','Springerville Municipal','Springerville, AZ','Springerville, AZ','US','AZ',34.12944444,-109.3108333,-7 ),
( 'AZ6','Gila Bend Municipal','Gila Bend, AZ','Gila Bend, AZ','US','AZ',32.96027778,-112.6736111,-7 ),
( 'AZA','Phoenix - Mesa Gateway','Phoenix, AZ','Phoenix, AZ','US','AZ',33.30777778,-111.6555556,-7 ),
( 'AZD','Shahid Sadooghi','Yazd, Iran','Yazd, Iran','IR',' ',31.905,54.27638889,3.5 ),
( 'AZG','Pablo L. Sidar','Apatzingan, Mexico','Apatzingan, Mexico','MX',' ',19.09361111,-102.3936111,-6 ),
( 'AZI','Al Bateen Executive','Abu Dhabi, United Arab Emirates','Abu Dhabi, United Arab Emirates','AE',' ',24.42833333,54.45805556,4 ),
( 'AZO','Kalamazoo/Battle Creek International','Kalamazoo, MI','Kalamazoo, MI','US','MI',42.23444444,-85.55166667,-5 ),
( 'AZS','El Catey International','Samana, Dominican Republic','Samana, Dominican Republic','DO',' ',19.26944444,-69.73694444,-4 ),
( 'B19','Biddeford Municipal','Biddeford, ME','Biddeford, ME','US','ME',43.46416667,-70.4725,-5 ),
( 'B1C','Blackfish Lodge','Baker Island, Canada','Baker Island, Canada','CA','BC',50.75194444,-126.5872222,-8 ),
( 'B21','Sugarloaf Regional','Carrabassett, ME','Carrabassett, ME','US','ME',45.08555556,-70.21638889,-5 ),
( 'B2C','Blind Channel Water Aerodrome','Blind Channel, Canada','Blind Channel, Canada','CA','BC',50.40194444,-125.4191667,-8 ),
( 'B3C','Minstrel Island Water Aerodrome','Minstrel Island, Canada','Minstrel Island, Canada','CA','BC',50.61888889,-126.3177778,-8 ),
( 'B4C','Simoom Sound Water Aerodrome','Simoom Sound, Canada','Simoom Sound, Canada','CA','BC',50.75194444,-126.5011111,-8 ),
( 'IAB','McConnell AFB','Wichita, KS','Wichita, KS','US','KS',37.62305556,-97.2675,-6 ),
( 'BAA','Bialla Airport','Bialla, Papua New Guinea','Bialla, Papua New Guinea','PG',' ',-5.33055556,151.0080556,10 ),
( 'BAB','Beale AFB','Marysville, CA','Marysville, CA','US','CA',39.13611111,-121.4366667,-8 ),
( 'BAC','Barranca de Upia Airport','Barranca de Upia, Colombia','Barranca de Upia, Colombia','CO',' ',4.56916667,-72.96722222,-5 ),
( 'BAD','Barksdale AFB','Shreveport, LA','Shreveport, LA','US','LA',32.50194444,-93.6625,-6 ),
( 'BAE','Barcelonnette Airport','Barcelonnette, France','Barcelonnette, France','FR',' ',44.38333333,6.63333333,1 ),
( 'BAF','Westfield Barnes Regional','Westfield, MA','Westfield, MA','US','MA',42.15805556,-72.71583333,-5 ),
( 'BAG','Baguio Airport','Baguio, Philippines','Baguio, Philippines','PH',' ',16.375,120.6188889,8 ),
( 'BAH','Bahrain International','Manama, Bahrain','Manama, Bahrain','BH',' ',26.27083333,50.63361111,3 ),
( 'BAI','Buenos Aires Airport','Buenos Aires, Costa Rica','Buenos Aires, Costa Rica','CR',' ',9.16361111,-83.33,-6 ),
( 'BAK','Baku Metropolitan Area','Baku, Azerbaijan','Baku, Azerbaijan','AZ',' ',40.4675,50.04666667,4 ),
( 'BAL','Batman Airport','Batman, Turkey','Batman, Turkey','TR',' ',37.92888889,41.11666667,2 ),
( 'BAM','Battle Mountain Airport','Battle Mountain, NV','Battle Mountain, NV','US','NV',40.59916667,-116.8744444,-8 ),
( 'BAO','Udorn AB','Ban Mak Khaeng, Thailand','Ban Mak Khaeng, Thailand','TH',' ',17.38305556,102.8,7 ),
( 'BAQ','Ernesto Cortissoz','Barranquilla, Colombia','Barranquilla, Colombia','CO',' ',10.88944444,-74.78055556,-5 ),
( 'BAR','Baker AAF','Baker Island, AK','Baker Island, AK','US','AK',55.36666667,-133.6,-9 ),
( 'BAT','Chafei Amsei','Barretos, Brazil','Barretos, Brazil','BR',' ',-20.58444444,-48.59416667,-3 ),
( 'BAU','Bauru-Arealva','Bauru, Brazil','Bauru, Brazil','BR',' ',-22.16111111,-49.07,null ),
( 'BAV','Baotou Airport','Baotou, China','Baotou, China','CN',' ',40.55944444,109.9983333,8 ),
( 'BAX','Barnaul Airport','Barnaul, Russia','Barnaul, Russia','RU',' ',53.36333333,83.53972222,7 ),
( 'BAY','Baia Mare Airport','Baia Mare, Romania','Baia Mare, Romania','RO',' ',47.65833333,23.46611111,2 ),
( 'BAZ','Barcelos Airport','Barcelos, Brazil','Barcelos, Brazil','BR',' ',-0.98111111,-62.91833333,-4 ),
( 'BBA','Balmaceda Airport','Balmaceda, Chile','Balmaceda, Chile','CL',' ',-45.91611111,-71.68944444,-4 ),
( 'BBC','Bay City Municipal','Bay City, TX','Bay City, TX','US','TX',28.97333333,-95.86333333,-6 ),
( 'BBD','Curtis Field','Brady, TX','Brady, TX','US','TX',31.17916667,-99.32388889,-6 ),
( 'BBI','Bhubaneswar Airport','Bhubaneswar, India','Bhubaneswar, India','IN',' ',20.24444444,85.81777778,5.5 ),
( 'BBO','Berbera International','Berbera, Somalia','Berbera, Somalia','SO',' ',10.38916667,44.94138889,3 ),
( 'BBQ','Cocoa Point','Barbuda, Antigua and Barbuda','Barbuda, Antigua and Barbuda','AG',' ',17.55555556,-61.765,-4 ),
( 'BBR','Baillif','Basse Terre, Guadeloupe','Basse Terre, Guadeloupe','GP',' ',16.01361111,-61.74305556,-4 ),
( 'BBS','Blackbushe Airport','Blackbushe, United Kingdom','Blackbushe, United Kingdom','GB',' ',51.32388889,-0.8475,null ),
( 'BBT','Berberati Airport','Berberati, Central African Republic','Berberati, Central African Republic','CF',' ',4.22166667,15.78638889,1 ),
( 'BBU','Baneasa Aurel Vlaicu','Bucharest, Romania','Bucharest, Romania','RO',' ',44.50333333,26.10277778,2 ),
( 'BBW','Broken Bow Municipal Kieth Glaze Field','Broken Bow, NE','Broken Bow, NE','US','NE',41.43638889,-99.64222222,-6 ),
( 'BBX','Wings Field','Blue Bell, PA','Blue Bell, PA','US','PA',40.1375,-75.26527778,-5 ),
( 'BBY','Bambari Airport','Bambari, Central African Republic','Bambari, Central African Republic','CF',' ',5.84694444,20.64972222,1 ),
( 'BBZ','Zambezi Airport','Zambezi, Zambia','Zambezi, Zambia','ZM',' ',-13.5375,23.10777778,2 ),
( 'BC1','Port Harvey Water Aerodrome','Port Harvey, Canada','Port Harvey, Canada','CA','BC',50.56888889,-126.2747222,-8 ),
( 'BC2','Farewell Harbour','Berry Island, Canada','Berry Island, Canada','CA','BC',50.60833333,-126.8444444,-8 ),
( 'BC3','Bliss Landing Water Aerodrome','Bliss Landing, Canada','Bliss Landing, Canada','CA','BC',50.03333333,-124.8222222,-8 ),
( 'BC4','Cordero Lodge Airport','Cordero Lodge, Canada','Cordero Lodge, Canada','CA','BC',50.44666667,-125.4527778,-8 ),
( 'BC5','Dent Island Lodge','Dent Island , Canada','Dent Island , Canada','CA','BC',50.41111111,-125.1833333,-8 ),
( 'BC6','Egmont Water Aerodrome','Egmont, Canada','Egmont, Canada','CA','BC',49.75277778,-123.9302778,-8 ),
( 'BC7','Sonora Resort','Sonora Island, Canada','Sonora Island, Canada','CA','BC',50.38305556,-125.1552778,-8 ),
( 'BC8','Pacific Outback Resort','Hanson Island, Canada','Hanson Island, Canada','CA','BC',50.58416667,-126.7516667,-8 ),
( 'BC9','Mink Island Water Aerodrome','Mink Island, Canada','Mink Island, Canada','CA','BC',50.11666667,-124.75,-8 ),
( 'BCA','Gustavo Rizo','Baracoa, Cuba','Baracoa, Cuba','CU',' ',20.36527778,-74.50611111,-5 ),
( 'BCB','Virginia Tech/Montgomery Executive','Blacksburg, VA','Blacksburg, VA','US','VA',37.20777778,-80.40777778,-5 ),
( 'BCC','Bear Creek Airport','Bear Creek, AK','Bear Creek, AK','US','AK',57.6175,-155.8672222,-9 ),
( 'BCD','Bacolod Airport','Bacolod, Philippines','Bacolod, Philippines','PH',' ',10.77666667,123.0191667,8 ),
( 'BCE','Bryce Canyon Airport','Bryce Canyon, UT','Bryce Canyon, UT','US','UT',37.70638889,-112.1458333,-7 ),
( 'BCH','Cakung','Baucau, Timor-Leste','Baucau, Timor-Leste','TL',' ',-8.48555556,126.3994444,9 ),
( 'BCI','Barcaldine Airport','Barcaldine, Australia','Barcaldine, Australia','AU',' ',-23.56527778,145.3066667,10 ),
( 'BCJ','Baca Grande','Crestone, CO','Crestone, CO','US','CO',37.96666667,-105.7666667,-7 ),
( 'BCL','Barra del Colorado Airport','Barra del Colorado, Costa Rica','Barra del Colorado, Costa Rica','CR',' ',10.76861111,-83.58555556,-6 ),
( 'BCM','Bacau Airport','Bacau, Romania','Bacau, Romania','RO',' ',46.52194444,26.91027778,2 ),
( 'BCN','Barcelona-El Prat','Barcelona, Spain','Barcelona, Spain','ES',' ',41.29694444,2.07833333,1 ),
( 'BCS','Southern Seaplane','Belle Chasse, LA','Belle Chasse, LA','US','LA',29.86611111,-90.02222222,-6 ),
( 'BCT','Boca Raton Public','Boca Raton, FL','Boca Raton, FL','US','FL',26.37083333,-80.10833333,-5 ),
( 'BCY','Bulchi Airport','Bulchi, Ethiopia','Bulchi, Ethiopia','ET',' ',6.29222222,36.88722222,3 ),
( 'BDA','L. F. Wade International','Hamilton, Bermuda','Hamilton, Bermuda','BM',' ',32.36416667,-64.67861111,-4 ),
( 'BDB','Bundaberg Airport','Bundaberg, Australia','Bundaberg, Australia','AU',' ',-24.90388889,152.3186111,10 ),
( 'BDE','Baudette International','Baudette, MN','Baudette, MN','US','MN',48.72833333,-94.61222222,-6 ),
( 'BDG','Blanding Municipal','Blanding, UT','Blanding, UT','US','UT',37.58333333,-109.4833333,-7 ),
( 'BDH','Bandar Lengeh Airport','Bandar Lengeh, Iran','Bandar Lengeh, Iran','IR',' ',26.53222222,54.82472222,3.5 ),
( 'BDI','Bird Island Airport','Bird Island, Seychelles','Bird Island, Seychelles','SC',' ',-3.72416667,55.20555556,4 ),
( 'BDJ','Syamsudin Noor','Bandjarmasin, Indonesia','Bandjarmasin, Indonesia','ID',' ',-3.44222222,114.7627778,8 ),
( 'BDK','Bondoukou/Soko','Bondoukou, Cote d`Ivoire','Bondoukou, Cote dIvoire','CI',' ',8.0175,-2.76222222,null ),
( 'BDL','Bradley International','Hartford, CT','Hartford, CT','US','CT',41.93916667,-72.68333333,-5 ),
( 'BDM','Bandirma Airport','Bandirma, Turkey','Bandirma, Turkey','TR',' ',40.31805556,27.97777778,2 ),
( 'BDN','Talhar','Badin, Pakistan','Badin, Pakistan','PK',' ',24.84194444,68.83833333,5 ),
( 'BDO','Husein Sastranegara','Bandung, Indonesia','Bandung, Indonesia','ID',' ',-6.90194444,107.575,7 ),
( 'BDP','Chandragadhi','Bhadrapur/Chandragadhi, Nepal','Bhadrapur/Chandragadhi, Nepal','NP',' ',26.57083333,88.07888889,5.75 ),
( 'BDQ','Vadodara Airport','Vadodara, India','Vadodara, India','IN',' ',22.33611111,73.22638889,5.5 ),
( 'BDR','Igor I Sikorsky Memorial','Bridgeport, CT','Bridgeport, CT','US','CT',41.16333333,-73.12611111,-5 ),
( 'BDS','Casale','Brindisi, Italy','Brindisi, Italy','IT',' ',40.65833333,17.94694444,1 ),
( 'BDU','Bardufoss Airport','Bardufoss, Norway','Bardufoss, Norway','NO',' ',69.05583333,18.53888889,1 ),
( 'BDY','Bandon State','Bandon, OR','Bandon, OR','US','OR',43.08638889,-124.4077778,-8 ),
( 'BEB','Benbecula Airport','Benbecula, United Kingdom','Benbecula, United Kingdom','GB',' ',57.48055556,-7.36388889,null ),
( 'BEC','Beech Factory','Wichita, KS','Wichita, KS','US','KS',37.69388889,-97.215,-6 ),
( 'BED','Laurence G Hanscom Field','Bedford, MA','Bedford, MA','US','MA',42.47,-71.28888889,-5 ),
( 'BEF','Bluefields Airport','Bluefields, Nicaragua','Bluefields, Nicaragua','NI',' ',11.99083333,-83.77416667,-6 ),
( 'BEG','Beograd','Belgrade, Serbia','Belgrade, Serbia','RS',' ',44.81833333,20.30916667,1 ),
( 'BEH','Southwest Michigan Regional','Benton Harbor/St. Joseph, MI','Benton Harbor/St. Joseph, MI','US','MI',42.12861111,-86.42611111,-5 ),
( 'BEL','Val de Cans International','Belem, Brazil','Belem, Brazil','BR',' ',-1.37916667,-48.47638889,-3 ),
( 'BEN','Benina International','Benghazi, Libya','Benghazi, Libya','LY',' ',32.09694444,20.26944444,2 ),
( 'BEO','Aeropelican','Newcastle, Australia','Newcastle, Australia','AU',' ',-33.06611111,151.6463889,10 ),
( 'BER','Berlin Metropolitan Area','Berlin, Germany','Berlin, Germany','DE',' ',52.51166667,13.40138889,1 ),
( 'BES','Brest Bretagne','Brest, France','Brest, France','FR',' ',48.44777778,-4.41861111,1 ),
( 'BET','Bethel Airport','Bethel, AK','Bethel, AK','US','AK',60.77861111,-161.8372222,-9 ),
( 'BEU','Bedourie North','Bedourie, Australia','Bedourie, Australia','AU',' ',-24.23,139.445,10 ),
( 'BEV','Teyman','Beersheba, Israel','Beersheba, Israel','IL',' ',31.28666667,34.72305556,2 ),
( 'BEW','Beira Airport','Beira, Mozambique','Beira, Mozambique','MZ',' ',-19.79638889,34.90777778,2 ),
( 'BEY','Rafic Hariri International','Beirut, Lebanon','Beirut, Lebanon','LB',' ',33.81916667,35.49,2 ),
( 'BFB','Blue Fox Bay Airport','Blue Fox Bay, AK','Blue Fox Bay, AK','US','AK',58.18333333,-152.1333333,-9 ),
( 'BFD','Bradford Regional','Bradford, PA','Bradford, PA','US','PA',41.80305556,-78.64,-5 ),
( 'BFF','Western Neb. Regional/William B. Heilig Field','Scottsbluff, NE','Scottsbluff, NE','US','NE',41.87416667,-103.5955556,-7 ),
( 'BFI','Boeing Field/King County International','Seattle, WA','Seattle, WA','US','WA',47.53,-122.3019444,-8 ),
( 'BFK','Buckley AFB','Aurora, CO','Denver, CO','US','CO',39.70166667,-104.7516667,-7 ),
( 'BFL','Meadows Field','Bakersfield, CA','Bakersfield, CA','US','CA',35.43388889,-119.0577778,-8 ),
( 'BFM','Mobile Downtown','Mobile, AL','Mobile, AL','US','AL',30.62666667,-88.06805556,-6 ),
( 'BFN','Bram Fischer International','Bloemfontein, South Africa','Bloemfontein, South Africa','ZA',' ',-29.09277778,26.3025,2 ),
( 'BFO','Buffalo Range Airport','Buffalo Range, Zimbabwe','Buffalo Range, Zimbabwe','ZW',' ',-21.00805556,31.57861111,2 ),
( 'BFP','Beaver County','Beaver Falls, PA','Beaver Falls, PA','US','PA',40.7725,-80.39138889,-5 ),
( 'BFQ','Bahia de Pinas Airport','Bahia de Pinas, Panama','Bahia de Pinas, Panama','PA',' ',7.58333333,-78.2,-5 ),
( 'BFR','Virgil I Grissom Municipal','Bedford, IN','Bedford, IN','US','IN',38.84,-86.44527778,-5 ),
( 'BFS','Belfast Aldergrove','Belfast, United Kingdom','Belfast, United Kingdom','GB',' ',54.6575,-6.21583333,null ),
( 'BFT','Beaufort County','Beaufort, SC','Beaufort, SC','US','SC',32.41222222,-80.63444444,-5 ),
( 'BGA','Palonegro','Bucaramanga, Colombia','Bucaramanga, Colombia','CO',' ',7.12666667,-73.18472222,-5 ),
( 'BGB','Booue Airport','Booue, Gabon','Booue, Gabon','GA',' ',-0.1075,11.94361111,1 ),
( 'BGD','Hutchinson County','Borger, TX','Borger, TX','US','TX',35.70083333,-101.3936111,-6 ),
( 'BGE','Decatur County Industrial Air Park','Bainbridge, GA','Bainbridge, GA','US','GA',30.97166667,-84.63694444,-5 ),
( 'BGF','Bangui-M`Poko','Bangui, Central African Republic','Bangui, Central African Republic','CF',' ',4.39944444,18.51944444,1 ),
( 'BGH','Abbaye','Bogue, Mauritania','Bogue, Mauritania','MR',' ',16.63333333,-14.2,null ),
( 'BGI','Grantley Adams International','Barbados/Bridgetown, Barbados','Barbados/Bridgetown, Barbados','BB',' ',13.07472222,-59.49222222,-4 ),
( 'BGL','Baglung Airport','Baglung, Nepal','Baglung, Nepal','NP',' ',28.21361111,83.66611111,5.75 ),
( 'BGM','Greater Binghamton/Edwin A. Link Field','Binghamton, NY','Binghamton, NY','US','NY',42.20833333,-75.97972222,-5 ),
( 'BGN','Bruggen Airport','Bruggen, Germany','Bruggen, Germany','DE',' ',51.19972222,6.13222222,1 ),
( 'BGO','Flesland','Bergen, Norway','Bergen, Norway','NO',' ',60.29333333,5.21805556,1 ),
( 'BGQ','Big Lake Airport','Big Lake, AK','Big Lake, AK','US','AK',61.53472222,-149.8125,-9 ),
( 'BGR','Bangor International','Bangor, ME','Bangor, ME','US','ME',44.8075,-68.82805556,-5 ),
( 'BGS','Big Spring McMahon-Wrinkle','Big Spring, TX','Big Spring, TX','US','TX',32.2125,-101.5216667,-6 ),
( 'BGT','Bagdad Airport','Bagdad, AZ','Bagdad, AZ','US','AZ',34.59277778,-113.1719444,-7 ),
( 'BGU','Bangassou Airport','Bangassou, Central African Republic','Bangassou, Central African Republic','CF',' ',4.78611111,22.7825,1 ),
( 'BGW','Al Muthana','Baghdad, Iraq','Baghdad, Iraq','IQ',' ',33.33277778,44.36388889,3 ),
( 'BGX','Comandante Gustavo Kraemer','Bage, Brazil','Bage, Brazil','BR',' ',-31.39055556,-54.11222222,-3 ),
( 'BGY','Bergamo Orio Al Serio','Bergamo, Italy','Milan, Italy','IT',' ',45.66888889,9.70416667,1 ),
( 'BH1','Isa AB','Shaikh Isa, Bahrain','Shaikh Isa, Bahrain','BH',' ',25.91833333,50.59055556,3 ),
( 'BHB','Hancock County-Bar Harbor','Bar Harbor, ME','Bar Harbor, ME','US','ME',44.44972222,-68.36166667,-5 ),
( 'BHD','Belfast City','Belfast, United Kingdom','Belfast, United Kingdom','GB',' ',54.61805556,-5.8725,null ),
( 'BHE','Woodbourne','Blenheim, New Zealand','Blenheim, New Zealand','NZ',' ',-41.51777778,173.8694444,12 ),
( 'BHG','Araslaya','Brus Laguna, Honduras','Brus Laguna, Honduras','HN',' ',15.73555556,-84.54277778,-6 ),
( 'BHH','Bisha Airport','Bisha, Saudi Arabia','Bisha, Saudi Arabia','SA',' ',19.98416667,42.62305556,3 ),
( 'BHI','Comandante Espora','Bahia Blanca, Argentina','Bahia Blanca, Argentina','AR',' ',-38.72555556,-62.16888889,-3 ),
( 'BHJ','Bhuj Airport','Bhuj, India','Bhuj, India','IN',' ',23.28805556,69.67027778,5.5 ),
( 'BHK','Bukhara Airport','Bukhara, Uzbekistan','Bukhara, Uzbekistan','UZ',' ',39.77527778,64.48222222,5 ),
( 'BHL','Bahia de Los Angeles North','Bahia de Los Angeles, Mexico','Bahia de Los Angeles, Mexico','MX',' ',28.97666667,-113.5602778,-8 ),
( 'BHM','Birmingham-Shuttlesworth International','Birmingham, AL','Birmingham, AL','US','AL',33.56388889,-86.75222222,-6 ),
( 'BHN','Beihan Airport','Beihan, Yemen','Beihan, Yemen','YE',' ',14.78222222,45.71972222,3 ),
( 'BHO','Raja Bhoj','Bhopal, India','Bhopal, India','IN',' ',23.28888889,77.33,5.5 ),
( 'BHQ','Broken Hill Airport','Broken Hill, Australia','Broken Hill, Australia','AU',' ',-32.00138889,141.4716667,9.5 ),
( 'BHR','Bharatpur Airport','Bharatpur, Nepal','Bharatpur, Nepal','NP',' ',27.67694444,84.42833333,5.75 ),
( 'BHS','Bathurst Airport','Bathurst, Australia','Bathurst, Australia','AU',' ',-33.40944444,149.6519444,10 ),
( 'BHT','Brighton Downs Airport','Brighton Downs, Australia','Brighton Downs, Australia','AU',' ',-23.35,141.55,10 ),
( 'BHU','Bhavnagar Airport','Bhavnagar, India','Bhavnagar, India','IN',' ',21.75222222,72.18555556,5.5 ),
( 'BHV','Bahawalpur International','Bahawalpur, Pakistan','Bahawalpur, Pakistan','PK',' ',29.34833333,71.71805556,5 ),
( 'BHX','Birmingham Airport','Birmingham, United Kingdom','Birmingham, United Kingdom','GB',' ',52.45388889,-1.74805556,null ),
( 'BHY','Beihai Airport','Beihai, China','Beihai, China','CN',' ',21.53944444,109.2938889,8 ),
( 'BHZ','Belo Horizonte Metropolitan Area','Belo Horizonte, Brazil','Belo Horizonte, Brazil','BR',' ',-19.91666667,-43.93333333,null ),
( 'BIA','Bastia Poretta','Bastia, France','Bastia, France','FR',' ',42.5525,9.48361111,1 ),
( 'BIC','Big Creek Airport','Big Creek, AK','Big Creek, AK','US','AK',57.66666667,-157.5833333,-9 ),
( 'BID','Block Island State','Block Island, RI','Block Island, RI','US','RI',41.16805556,-71.57777778,-5 ),
( 'BIE','Beatrice Municipal','Beatrice, NE','Beatrice, NE','US','NE',40.30138889,-96.75416667,-6 ),
( 'BIF','Biggs AAF','El Paso, TX','El Paso, TX','US','TX',31.84944444,-106.38,-7 ),
( 'BIG','Allen AAF','Big Delta, AK','Big Delta, AK','US','AK',63.99472222,-145.7202778,-9 ),
( 'BIH','Bishop Airport','Bishop, CA','Bishop, CA','US','CA',37.37305556,-118.3636111,-8 ),
( 'BII','Bikini Atoll Airport','Bikini Atoll, Marshall Islands','Bikini Atoll, Marshall Islands','MH',' ',11.52166667,165.5644444,12 ),
( 'BIK','Manuhua','Biak, Indonesia','Biak, Indonesia','ID',' ',-1.18666667,136.0855556,9 ),
( 'BIL','Billings Logan International','Billings, MT','Billings, MT','US','MT',45.80777778,-108.5427778,-7 ),
( 'BIM','Bimini International','Bimini, The Bahamas','Bimini, The Bahamas','BS',' ',25.69944444,-79.26555556,-5 ),
( 'BIN','Bamyan Airport','Bamyan, Afghanistan','Bamyan, Afghanistan','AF',' ',34.80944444,67.81888889,4.5 ),
( 'BIO','Bilbao Airport','Bilbao, Spain','Bilbao, Spain','ES',' ',43.30111111,-2.91055556,1 ),
( 'BIP','Bulimba Airport','Bulimba, Australia','Bulimba, Australia','AU',' ',-16.88305556,143.4813889,10 ),
( 'BIQ','Biarritz Bayonne Anglet','Biarritz, France','Biarritz, France','FR',' ',43.46833333,-1.52333333,1 ),
( 'BIR','Biratnagar Airport','Biratnagar, Nepal','Biratnagar, Nepal','NP',' ',26.48222222,87.26361111,5.75 ),
( 'BIS','Bismarck Municipal','Bismarck/Mandan, ND','Bismarck/Mandan, ND','US','ND',46.77277778,-100.7458333,-6 ),
( 'BIV','Bria Airport','Bria, Central African Republic','Bria, Central African Republic','CF',' ',6.52833333,21.98888889,1 ),
( 'BIX','Keesler AFB','Biloxi, MS','Biloxi, MS','US','MS',30.41055556,-88.92444444,-6 ),
( 'BJC','Rocky Mountain Metro','Broomfield, CO','Broomfield, CO','US','CO',39.90888889,-105.1172222,-7 ),
( 'BJI','Bemidji Regional','Bemidji, MN','Bemidji, MN','US','MN',47.51083333,-94.93472222,-6 ),
( 'BJJ','Wayne County','Wooster, OH','Wooster, OH','US','OH',40.87472222,-81.88833333,-5 ),
( 'BJL','Banjul International','Banjul, The Gambia','Banjul, The Gambia','GM',' ',13.33777778,-16.65222222,null ),
( 'BJM','Bujumbura International','Bujumbura, Burundi','Bujumbura, Burundi','BI',' ',-3.32388889,29.31861111,2 ),
( 'BJR','Bahir Dar Airport','Bahir Dar, Ethiopia','Bahir Dar, Ethiopia','ET',' ',11.60833333,37.32166667,3 ),
( 'BJU','Bajura Airport','Bajura, Nepal','Bajura, Nepal','NP',' ',29.50277778,81.66861111,5.75 ),
( 'BJV','Imsik','Bodrum, Turkey','Bodrum, Turkey','TR',' ',37.14,27.66944444,2 ),
( 'BJX','Guanajuato International','Leon/Guanajuato, Mexico','Leon/Guanajuato, Mexico','MX',' ',20.99333333,-101.4808333,-6 ),
( 'BJZ','Badajoz Airport','Badajoz, Spain','Badajoz, Spain','ES',' ',38.89138889,-6.82138889,1 ),
( 'BKC','Buckland Airport','Buckland, AK','Buckland, AK','US','AK',65.98166667,-161.1491667,-9 ),
( 'BKE','Baker City Municipal','Baker, OR','Baker, OR','US','OR',44.83722222,-117.8091667,-8 ),
( 'BKF','Brooks Lake Airport','Brooks Lake, AK','Brooks Lake, AK','US','AK',58.6,-156.2333333,-9 ),
( 'BKG','Branson Airport','Branson, MO','Branson, MO','US','MO',36.53194444,-93.20055556,-6 ),
( 'BKH','Barking Sands PMRF','Kekaha, Kauai, HI','Kekaha, Kauai, HI','US','HI',22.02277778,-159.785,-10 ),
( 'BKI','Kota Kinabalu International','Kota Kinabalu, Malaysia','Kota Kinabalu, Malaysia','MY',' ',5.93388889,116.0497222,8 ),
( 'BKK','Suvarnabhumi International','Bangkok, Thailand','Bangkok, Thailand','TH',' ',13.68083333,100.7477778,7 ),
( 'BKL','Burke Lakefront','Cleveland, OH','Cleveland, OH (Metropolitan Area)','US','OH',41.51777778,-81.68277778,-5 ),
( 'BKM','Bakelalan Airport','Bakelalan, Malaysia','Bakelalan, Malaysia','MY',' ',3.97444444,115.6166667,8 ),
( 'BKO','Senou','Bamako, Mali','Bamako, Mali','ML',' ',12.53777778,-7.94333333,null ),
( 'BKQ','Blackall Airport','Blackall, Australia','Blackall, Australia','AU',' ',-24.42777778,145.4286111,10 ),
( 'BKS','Fatmawati Soekarno','Bengkulu, Indonesia','Bengkulu, Indonesia','ID',' ',-3.86111111,102.3394444,7 ),
( 'BKU','Betioky Airport','Betioky, Madagascar','Betioky, Madagascar','MG',' ',-23.73361111,44.39083333,3 ),
( 'BKW','Raleigh County Memorial','Beckley, WV','Beckley, WV','US','WV',37.78722222,-81.12416667,-5 ),
( 'BKX','Brookings Regional','Brookings, SD','Brookings, SD','US','SD',44.30444444,-96.81888889,-6 ),
( 'BKY','Bukavu Kavumu','Bukavu, Congo (Kinshasa)','Bukavu, Congo (Kinshasa)','CD',' ',-2.30888889,28.80888889,2 ),
( 'BKZ','Bukoba Airport','Bukoba, Tanzania','Bukoba, Tanzania','TZ',' ',-1.33138889,31.82055556,3 ),
( 'BLA','General Jose Antonio Anzoategui International','Barcelona, Venezuela','Barcelona, Venezuela','VE',' ',10.10722222,-64.68916667,-4.5 ),
( 'BLC','Bali Airport','Bali, Cameroon','Bali, Cameroon','CM',' ',5.89166667,10.025,1 ),
( 'BLD','Boulder City Municipal','Boulder City, NV','Boulder City, NV','US','NV',35.9475,-114.8613889,-8 ),
( 'BLE','Borlange Airport','Borlange, Sweden','Borlange, Sweden','SE',' ',60.42194444,15.51527778,1 ),
( 'BLF','Mercer County','Princeton/Bluefield, WV','Princeton/Bluefield, WV','US','WV',37.29583333,-81.20777778,-5 ),
( 'BLG','Belaga Airport','Belaga, Malaysia','Belaga, Malaysia','MY',' ',2.63611111,113.7605556,8 ),
( 'BLH','Blythe Airport','Blythe, CA','Blythe, CA','US','CA',33.61916667,-114.7169444,-8 ),
( 'BLI','Bellingham International','Bellingham, WA','Bellingham, WA','US','WA',48.79277778,-122.5375,-8 ),
( 'BLJ','Mostepha Ben Boulaid','Batna, Algeria','Batna, Algeria','DZ',' ',35.75194444,6.30944444,1 ),
( 'BLK','Blackpool Airport','Blackpool, United Kingdom','Blackpool, United Kingdom','GB',' ',53.77166667,-3.02861111,null ),
( 'BLL','Billund Airport','Billund, Denmark','Billund, Denmark','DK',' ',55.74027778,9.15166667,1 ),
( 'BLM','Monmouth Executive','Belmar/Farmingdale, NJ','Belmar/Farmingdale, NJ','US','NJ',40.18666667,-74.12444444,-5 ),
( 'BLO','Blonduos Airport','Blonduos, Iceland','Blonduos, Iceland','IS',' ',65.645,-20.2875,null ),
( 'BLP','Bellavista 1','Bellavista, Peru','Bellavista, Peru','PE',' ',-7.06027778,-76.58222222,-5 ),
( 'BLQ','Bologna Airport','Bologna, Italy','Bologna, Italy','IT',' ',44.53555556,11.28861111,1 ),
( 'BLR','Kempegowda International','Bangalore, India','Bangalore, India','IN',' ',13.20694444,77.70444444,5.5 ),
( 'BLT','Blackwater Airport','Blackwater, Australia','Blackwater, Australia','AU',' ',-23.60305556,148.8069444,10 ),
( 'BLV','Scott AFB/MidAmerica','Belleville, IL','Belleville, IL','US','IL',38.54527778,-89.83527778,-6 ),
( 'BLZ','Chileka International','Blantyre, Malawi','Blantyre, Malawi','MW',' ',-15.67888889,34.97388889,2 ),
( 'BMA','Bromma','Stockholm, Sweden','Stockholm, Sweden','SE',' ',59.35444444,17.94166667,1 ),
( 'BMB','Bumba Airport','Bumba, Congo (Kinshasa)','Bumba, Congo (Kinshasa)','CD',' ',2.18333333,22.47972222,2 ),
( 'BMC','Brigham City Airport','Brigham City, UT','Brigham City, UT','US','UT',41.55444444,-112.0622222,-7 ),
( 'BMD','Belo Sur Tsiribihina','Belo, Madagascar','Belo, Madagascar','MG',' ',-19.68666667,44.54222222,3 ),
( 'BME','Broome International','Broome, Australia','Broome, Australia','AU',' ',-17.94472222,122.2316667,8 ),
( 'BMG','Monroe County','Bloomington, IN','Bloomington, IN','US','IN',39.14611111,-86.61666667,-5 ),
( 'BMH','Bomai Airport','Bomai, Papua New Guinea','Bomai, Papua New Guinea','PG',' ',-6.37472222,144.6355556,10 ),
( 'BMI','Central Illinois Regional','Bloomington/Normal, IL','Bloomington/Normal, IL','US','IL',40.47722222,-88.91583333,-6 ),
( 'BMJ','Baramita Airport','Baramita, Guyana','Baramita, Guyana','GY',' ',7.37083333,-60.48972222,-4 ),
( 'BML','Berlin Regional','Berlin, NH','Berlin, NH','US','NH',44.57527778,-71.17583333,-5 ),
( 'BMM','Bitam Airport','Bitam, Gabon','Bitam, Gabon','GA',' ',2.07722222,11.49222222,1 ),
( 'BMO','Banmaw','Bhamo, Burma','Bhamo, Burma','MM',' ',24.27083333,97.24722222,6.5 ),
( 'BMP','Brampton Island Airport','Brampton Island, Australia','Brampton Island, Australia','AU',' ',-20.80333333,149.27,10 ),
( 'BMV','Buon Ma Thuot','Ban Me Thout, Vietnam','Ban Me Thout, Vietnam','VN',' ',12.66833333,108.1202778,7 ),
( 'BMW','Bordj Mokhtar','Bordj Badji Mokhtar, Algeria','Bordj Badji Mokhtar, Algeria','DZ',' ',21.37777778,0.92611111,1 ),
( 'BMX','Big Mountain AFS','Big Mountain, AK','Big Mountain, AK','US','AK',59.36111111,-155.2588889,-9 ),
( 'BNA','Nashville International','Nashville, TN','Nashville, TN','US','TN',36.12444444,-86.67805556,-6 ),
( 'BNB','Boende Airport','Boende, Congo (Kinshasa)','Boende, Congo (Kinshasa)','CD',' ',-0.28666667,20.88333333,1 ),
( 'BND','Bandar Abbas International','Bandar Abbas, Iran','Bandar Abbas, Iran','IR',' ',27.21833333,56.37777778,3.5 ),
( 'BNE','Brisbane International','Brisbane, Australia','Brisbane, Australia','AU',' ',-27.38416667,153.1175,10 ),
( 'BNF','Warm Spring Bay Seaplane Base','Baranof, AK','Baranof, AK','US','AK',57.08916667,-134.8313889,-9 ),
( 'BNG','Banning Municipal','Banning, CA','Banning, CA','US','CA',33.9225,-116.8508333,-8 ),
( 'BNI','Benin City Airport','Benin City, Nigeria','Benin City, Nigeria','NG',' ',6.32388889,5.60166667,1 ),
( 'BNK','Ballina Byron Gateway','Ballina, Australia','Ballina, Australia','AU',' ',-28.83388889,153.5625,10 ),
( 'BNL','Barnwell Regional','Barnwell, SC','Barnwell, SC','US','SC',33.25777778,-81.38833333,-5 ),
( 'BNN','Bronnoy','Bronnoysund, Norway','Bronnoysund, Norway','NO',' ',65.46111111,12.2175,1 ),
( 'BNO','Burns Municipal','Burns, OR','Burns, OR','US','OR',43.59194444,-118.9555556,-8 ),
( 'BNS','Barinas Airport','Barinas, Venezuela','Barinas, Venezuela','VE',' ',8.61972222,-70.22111111,-4.5 ),
( 'BNX','Banja Luka Airport','Banja Luka, Bosnia and Herzegovina','Banja Luka, Bosnia and Herzegovina','BA',' ',44.94138889,17.2975,1 ),
( 'BNZ','Banz Airport','Banz, Papua New Guinea','Banz, Papua New Guinea','PG',' ',-5.80833333,144.6113889,10 ),
( 'BOA','Boma Airport','Boma, Congo (Kinshasa)','Boma, Congo (Kinshasa)','CD',' ',-5.85388889,13.06388889,1 ),
( 'BOB','Bora Bora Motu Mute','Bora Bora, French Polynesia','Bora Bora, French Polynesia','PF',' ',-16.44444444,-151.7513889,-10 ),
( 'BOC','Bocas del Toro International','Bocas del Toro, Panama','Bocas del Toro, Panama','PA',' ',9.34083333,-82.25083333,-5 ),
( 'BOD','Bordeaux Merignac','Bordeaux, France','Bordeaux, France','FR',' ',44.82861111,-0.71527778,1 ),
( 'BOG','El Dorado International','Bogota, Colombia','Bogota, Colombia','CO',' ',4.70166667,-74.14694444,-5 ),
( 'BOH','Bournemouth Airport','Bournemouth, United Kingdom','Bournemouth, United Kingdom','GB',' ',50.78,-1.8425,null ),
( 'BOI','Boise Air Terminal','Boise, ID','Boise, ID','US','ID',43.56444444,-116.2227778,-7 ),
( 'BOJ','Burgas Airport','Burgas, Bulgaria','Burgas, Bulgaria','BG',' ',42.57,27.51527778,2 ),
( 'BOK','Brookings Airport','Brookings, OR','Brookings, OR','US','OR',42.07444444,-124.29,-8 ),
( 'BOM','Chhatrapati Shivaji International','Mumbai, India','Mumbai, India','IN',' ',19.08861111,72.86777778,5.5 ),
( 'BON','Flamingo International','Bonaire, Bonaire, Sint Eustatius, and Saba','Bonaire, Bonaire, Sint Eustatius, and Saba','BQ',' ',12.13083333,-68.2675,-4 ),
( 'BOO','Bodo Airport','Bodo, Norway','Bodo, Norway','NO',' ',67.26916667,14.36527778,1 ),
( 'BOQ','Boku Airport','Boku, Papua New Guinea','Boku, Papua New Guinea','PG',' ',-6.54305556,155.3430556,10 ),
( 'BOS','Logan International','Boston, MA','Boston, MA (Metropolitan Area)','US','MA',42.36305556,-71.00638889,-5 ),
( 'BOW','Bartow Municipal','Bartow, FL','Bartow, FL','US','FL',27.94333333,-81.78333333,-5 ),
( 'BOX','Borroloola Airport','Borroloola, Australia','Borroloola, Australia','AU',' ',-16.07527778,136.3022222,9.5 ),
( 'BOY','Bobo Dioulasso Airport','Bobo Dioulasso, Burkina Faso','Bobo Dioulasso, Burkina Faso','BF',' ',11.15972222,-4.33111111,null ),
( 'BPH','Bislig Airport','Bislig, Philippines','Bislig, Philippines','PH',' ',8.19527778,126.3213889,8 ),
( 'BPI','Miley Memorial Field','Big Piney, WY','Big Piney, WY','US','WY',42.58222222,-110.1088889,-7 ),
( 'BPN','Sepinggan','Balikpapan, Indonesia','Balikpapan, Indonesia','ID',' ',-1.26833333,116.8944444,8 ),
( 'BPS','Porto Seguro Airport','Porto Seguro, Brazil','Porto Seguro, Brazil','BR',' ',-16.43861111,-39.08083333,-3 ),
( 'BPT','Jack Brooks Regional','Beaumont/Port Arthur, TX','Beaumont/Port Arthur, TX','US','TX',29.95083333,-94.02055556,-6 ),
( 'BQA','Baler Airport','Baler, Philippines','Baler, Philippines','PH',' ',15.72972222,121.5002778,8 ),
( 'BQH','Biggin Hill','London, United Kingdom','London, United Kingdom','GB',' ',51.33083333,0.0325,null ),
( 'BQK','Brunswick Golden Isles','Brunswick, GA','Brunswick, GA','US','GA',31.25916667,-81.46638889,-5 ),
( 'BQN','Rafael Hernandez','Aguadilla, PR','Aguadilla, PR','US','PR',18.49472222,-67.12944444,-4 ),
( 'BQS','Blagoveshchensk','Blagoveschensk, Russia','Blagoveschensk, Russia','RU',' ',50.42555556,127.4125,10 ),
( 'BQU','J. F. Mitchell','Bequia, Saint Vincent and the Grenadines','Bequia, Saint Vincent and the Grenadines','VC',' ',12.98861111,-61.26222222,-4 ),
( 'BQV','Bartlett Cove Seaplane Base','Bartlett Cove, AK','Bartlett Cove, AK','US','AK',58.45527778,-135.8852778,-9 ),
( 'BR1','Pato Branco','Parana, Brazil','Parana, Brazil','BR',' ',-26.21722222,-52.69444444,null ),
( 'BR2','Costa Esmeralda','Porto Belo, Brazil','Porto Belo, Brazil','BR',' ',-27.16666667,-48.62166667,-3 ),
( 'BRA','Barreiras Airport','Barreiras, Brazil','Barreiras, Brazil','BR',' ',-12.07916667,-45.00944444,-3 ),
( 'BRC','San Carlos de Bariloche Airport','San Carlos de Bariloche, Argentina','San Carlos de Bariloche, Argentina','AR',' ',-41.15111111,-71.15777778,-3 ),
( 'BRD','Brainerd Lakes Regional','Brainerd, MN','Brainerd, MN','US','MN',46.40416667,-94.13361111,-6 ),
( 'BRE','Bremen Airport','Bremen, Germany','Bremen, Germany','DE',' ',53.0475,8.78666667,1 ),
( 'BRG','Whitesburg Municipal','Whitesburg, KY','Whitesburg, KY','US','KY',37.11666667,-82.81666667,-5 ),
( 'BRI','Bari Airport','Bari, Italy','Bari, Italy','IT',' ',41.1375,16.75722222,1 ),
( 'BRK','Bourke Airport','Bourke, Australia','Bourke, Australia','AU',' ',-30.03916667,145.9516667,10 ),
( 'BRL','Southeast Iowa Regional','Burlington, IA','Burlington, IA','US','IA',40.78333333,-91.12555556,-6 ),
( 'BRM','Barquisimeto International','Barquisimeto, Venezuela','Barquisimeto, Venezuela','VE',' ',10.04222222,-69.36055556,-4.5 ),
( 'BRN','Bern/Belp','Berne, Switzerland','Berne, Switzerland','CH',' ',46.91333333,7.49805556,1 ),
( 'BRO','Brownsville South Padre Island International','Brownsville, TX','Brownsville, TX','US','TX',25.90694444,-97.42583333,-6 ),
( 'BRQ','Turany','Brno, Czech Republic','Brno, Czech Republic','CZ',' ',49.15138889,16.69444444,1 ),
( 'BRR','Barra Airport','Barra, United Kingdom','Barra, United Kingdom','GB',' ',57.02361111,-7.44166667,null ),
( 'BRS','Bristol Airport','Bristol, United Kingdom','Bristol, United Kingdom','GB',' ',51.38277778,-2.71916667,null ),
( 'BRT','Bathurst Island Airport','Bathurst Island, Australia','Bathurst Island, Australia','AU',' ',-11.76916667,130.6197222,9.5 ),
( 'BRU','Brussels National','Brussels, Belgium','Brussels, Belgium','BE',' ',50.90138889,4.48444444,1 ),
( 'BRV','Bremerhaven Airport','Bremerhaven, Germany','Bremerhaven, Germany','DE',' ',53.50722222,8.57277778,1 ),
( 'BRW','Wiley Post/Will Rogers Memorial','Barrow, AK','Barrow, AK','US','AK',71.28472222,-156.7686111,-9 ),
( 'BRX','Barahona Habanero','Barahona, Dominican Republic','Barahona, Dominican Republic','DO',' ',18.25277778,-71.12,-4 ),
( 'BRY','Samuels Field','Bardstown, KY','Bardstown, KY','US','KY',37.81444444,-85.49972222,-5 ),
( 'BSA','Bosaso Airport','Bosaso, Somalia','Bosaso, Somalia','SO',' ',11.27555556,49.15777778,3 ),
( 'BSB','Presidente Juscelino Kubitschek International','Brasilia, Brazil','Brasilia, Brazil','BR',' ',-15.86944444,-47.91777778,-3 ),
( 'BSD','Baoshan Airport','Baoshan, China','Baoshan, China','CN',' ',25.05194444,99.1675,8 ),
( 'BSG','Bata Airport','Bata, Equatorial Guinea','Bata, Equatorial Guinea','GQ',' ',1.9025,9.80583333,1 ),
( 'BSK','Mohamed Khider','Biskra, Algeria','Biskra, Algeria','DZ',' ',34.79333333,5.73833333,1 ),
( 'BSL','EuroAirport','Mulhouse, France','Mulhouse, France','FR',' ',47.59,7.52888889,null ),
( 'BSO','Basco Airport','Basco, Philippines','Basco, Philippines','PH',' ',20.45138889,121.9802778,8 ),
( 'BSQ','Bisbee Municipal','Bisbee, AZ','Bisbee, AZ','US','AZ',31.36388889,-109.8830556,-7 ),
( 'BSR','Basrah International','Basra, Iraq','Basra, Iraq','IQ',' ',30.54888889,47.6625,3 ),
( 'BSS','Balsas Airport','Balsas, Brazil','Balsas, Brazil','BR',' ',-7.52527778,-46.05333333,-3 ),
( 'BSU','Basankusu Airport','Basankusu, Congo (Kinshasa)','Basankusu, Congo (Kinshasa)','CD',' ',1.22527778,19.78805556,1 ),
( 'BSW','Boswell Bay Airport','Boswell Bay, AK','Boswell Bay, AK','US','AK',60.42305556,-146.1458333,-9 ),
( 'BTA','Bertoua Airport','Bertoua, Cameroon','Bertoua, Cameroon','CM',' ',4.55,13.72583333,1 ),
( 'BTC','Batticaloa Airport','Batticaloa, Sri Lanka','Batticaloa, Sri Lanka','LK',' ',7.70527778,81.67722222,5.5 ),
( 'BTE','Bonthe Airport','Bonthe, Sierra Leone','Bonthe, Sierra Leone','SL',' ',7.53194444,-12.51861111,null ),
( 'BTH','Batu Besar Airport','Batu Besar, Indonesia','Batu Besar, Indonesia','ID',' ',1.13055556,104.1341667,7 ),
( 'BTI','Barter Island Airport','Barter Island, AK','Barter Island, AK','US','AK',70.13388889,-143.5819444,-9 ),
( 'BTJ','Sultan Iskandar Muda','Banda Aceh, Indonesia','Banda Aceh, Indonesia','ID',' ',5.51694444,95.42,7 ),
( 'BTK','Bratsk Airport','Bratsk, Russia','Bratsk, Russia','RU',' ',56.37055556,101.6983333,9 ),
( 'BTL','W K Kellogg','Battle Creek, MI','Battle Creek, MI','US','MI',42.30638889,-85.25,-5 ),
( 'BTM','Bert Mooney','Butte, MT','Butte, MT','US','MT',45.95472222,-112.4975,-7 ),
( 'BTP','Butler County/K. W. Scholter Field','Butler, PA','Butler, PA','US','PA',40.77666667,-79.95111111,-5 ),
( 'BTR','Baton Rouge Metropolitan/Ryan Field','Baton Rouge, LA','Baton Rouge, LA','US','LA',30.53305556,-91.15,-6 ),
( 'BTS','M. R. Stefanik International','Bratislava, Slovakia','Bratislava, Slovakia','SK',' ',48.17,17.21277778,1 ),
( 'BTT','Bettles Airport','Bettles, AK','Bettles, AK','US','AK',66.91388889,-151.5291667,-9 ),
( 'BTU','Bintulu Airport','Bintulu, Malaysia','Bintulu, Malaysia','MY',' ',3.12416667,113.0197222,8 ),
( 'BTV','Burlington International','Burlington, VT','Burlington, VT','US','VT',44.47194444,-73.15333333,-5 ),
( 'BTY','Beatty Airport','Beatty, NV','Beatty, NV','US','NV',36.86111111,-116.7863889,-8 ),
( 'BTZ','Bursa Airport','Bursa, Turkey','Bursa, Turkey','TR',' ',40.23333333,29.00916667,2 ),
( 'BUA','Buka','Buka Islands, Papua New Guinea','Buka Islands, Papua New Guinea','PG',' ',-5.42222222,154.6727778,10 ),
( 'BUC','Burketown Airport','Burketown, Australia','Burketown, Australia','AU',' ',-17.74861111,139.5344444,10 ),
( 'BUD','Budapest Liszt Ferenc International','Budapest, Hungary','Budapest, Hungary','HU',' ',47.43944444,19.26194444,1 ),
( 'BUE','Buenos Aires Metropolitan Area','Buenos Aires, Argentina','Buenos Aires, Argentina','AR',' ',-34.68944444,-58.475,-3 ),
( 'BUF','Buffalo Niagara International','Buffalo, NY','Buffalo, NY','US','NY',42.94055556,-78.73055556,-5 ),
( 'BUG','17 de Setembro','Benguela, Angola','Benguela, Angola','AO',' ',-12.60638889,13.40555556,1 ),
( 'BUH','Bucharest Metropolitan Area','Bucharest, Romania','Bucharest, Romania','RO',' ',44.43305556,26.1,2 ),
( 'BUL','Bulolo Airport','Bulolo, Papua New Guinea','Bulolo, Papua New Guinea','PG',' ',-7.21611111,146.6491667,10 ),
( 'BUM','Butler Memorial','Butler, MO','Butler, MO','US','MO',38.28972222,-94.34027778,-6 ),
( 'BUN','Gerardo Tobar Lopez','Buenaventura, Colombia','Buenaventura, Colombia','CO',' ',3.81944444,-76.99,-5 ),
( 'BUO','Burao Airport','Burao, Somalia','Burao, Somalia','SO',' ',9.52944444,45.55666667,3 ),
( 'BUQ','J. M. Nkomo International','Bulawayo, Zimbabwe','Bulawayo, Zimbabwe','ZW',' ',-20.01527778,28.62277778,2 ),
( 'BUR','Bob Hope','Burbank, CA','Los Angeles, CA (Metropolitan Area)','US','CA',34.20055556,-118.3586111,-8 ),
( 'BUS','Batumi Airport','Batumi, Georgia','Batumi, Georgia','GE',' ',41.61027778,41.59944444,4 ),
( 'BUU','Buyo Airport','Buyo, Cote d`Ivoire','Buyo, Cote d`Ivoire','CI',' ',6.26666667,-7.05,null ),
( 'BUV','Bella Union Airport','Bella Union, Uruguay','Bella Union, Uruguay','UY',' ',-30.31972222,-57.55888889,-3 ),
( 'BUX','Bunia Airport','Bunia, Congo (Kinshasa)','Bunia, Congo (Kinshasa)','CD',' ',1.57166667,30.21277778,2 ),
( 'BUY','Bunbury Airport','Bunbury, Australia','Bunbury, Australia','AU',' ',-33.37833333,115.6766667,8 ),
( 'BUZ','Bushehr Airport','Bushehr, Iran','Bushehr, Iran','IR',' ',28.94472222,50.83472222,3.5 ),
( 'BVA','Beauvais Tille','Beauvais, France','Beauvais, France','FR',' ',49.45444444,2.11277778,1 ),
( 'BVB','Atlas Brasil Cantanhede','Boa Vista, Brazil','Boa Vista, Brazil','BR',' ',2.84638889,-60.69,-4 ),
( 'BVD','Beaver Inlet Seaport','Beaver Inlet, AK','Beaver Inlet, AK','US','AK',53.8325,-166.3025,-9 ),
( 'BVI','Birdsville Airport','Birdsville, Australia','Birdsville, Australia','AU',' ',-25.8975,139.3475,10 ),
( 'BVO','Bartlesville Municipal','Bartlesville, OK','Bartlesville, OK','US','OK',36.76333333,-96.01111111,-6 ),
( 'BVR','Beaver Island','St. James, MI','St. James, MI','US','MI',45.69222222,-85.56666667,null ),
( 'BVU','Beluga Airport','Beluga, AK','Beluga, AK','US','AK',61.17305556,-151.0455556,-9 ),
( 'BVX','Batesville Regional','Batesville, AR','Batesville, AR','US','AR',35.72611111,-91.6475,-6 ),
( 'BVY','Beverly Municipal','Beverly, MA','Beverly, MA','US','MA',42.58416667,-70.91611111,-5 ),
( 'BW1','Thebephatshwa','Tebepahwa, Botswana','Tebepahwa, Botswana','BW',' ',-24.22111111,25.34722222,2 ),
( 'BWA','Gautam Buddha','Bhairawa, Nepal','Bhairawa, Nepal','NP',' ',27.50583333,83.41638889,5.75 ),
( 'BWD','Brownwood Regional','Brownwood, TX','Brownwood, TX','US','TX',31.79361111,-98.95638889,-6 ),
( 'BWE','Braunschweig/Wolfsburg','Braunschweig, Germany','Braunschweig, Germany','DE',' ',52.31944444,10.55888889,1 ),
( 'BWG','Bowling Green-Warren County Regional','Bowling Green, KY','Bowling Green, KY','US','KY',36.96444444,-86.41972222,-6 ),
( 'BWH','Butterworth Airport','Butterworth, Malaysia','Penang, Malaysia','MY',' ',5.4675,100.3916667,8 ),
( 'BWI','Baltimore/Washington International Thurgood Marshall','Baltimore, MD','Washington, DC (Metropolitan Area)','US','MD',39.17583333,-76.66888889,-5 ),
( 'BWJ','Bawan Airport','Bawan, Papua New Guinea','Bawan, Papua New Guinea','PG',' ',-6.39666667,146.8819444,10 ),
( 'BWM','Bowman Municipal','Bowman, ND','Bowman, ND','US','ND',46.18694444,-103.4280556,-7 ),
( 'BWN','Brunei International','Bandar Seri Begawan, Brunei','Bandar Seri Begawan, Brunei','BN',' ',4.94416667,114.9283333,8 ),
( 'BWT','Wynyard','Burnie, Australia','Burnie, Australia','AU',' ',-40.99888889,145.7311111,10 ),
( 'BXC','Sheraton Inn Heliport','Boxborough, MA','Boxborough, MA','US','MA',42.48472222,-71.54444444,-5 ),
( 'BXD','Bade Airport','Bade, Indonesia','Bade, Indonesia','ID',' ',-7.17611111,139.5833333,9 ),
( 'BXE','Bakel Airport','Bakel, Senegal','Bakel, Senegal','SN',' ',14.84722222,-12.46833333,null ),
( 'BXS','Borrego Valley','Borrego Springs, CA','Borrego Springs, CA','US','CA',33.25916667,-116.3208333,-8 ),
( 'BXU','Bancasi','Butuan, Philippines','Butuan, Philippines','PH',' ',8.95138889,125.4838889,8 ),
( 'BYA','Boundary Airport','Boundary, AK','Boundary, AK','US','AK',64.07833333,-141.1133333,-9 ),
( 'BYC','Yacuiba Airport','Yacuiba, Bolivia','Yacuiba, Bolivia','BO',' ',-21.96083333,-63.65166667,-4 ),
( 'BYF','Albert Bray','Albert, France','Albert, France','FR',' ',49.97027778,2.6925,1 ),
( 'BYG','Johnson County','Buffalo, WY','Buffalo, WY','US','WY',44.38111111,-106.7216667,-7 ),
( 'BYH','Arkansas International','Blytheville, AR','Blytheville, AR','US','AR',35.96444444,-89.94388889,-6 ),
( 'BYI','Burley Municipal','Burley/Rupert, ID','Burley/Rupert, ID','US','ID',42.5425,-113.7716667,-7 ),
( 'BYK','Bouake Airport','Bouake, Cote d`Ivoire','Bouake, Cote d`Ivoire','CI',' ',7.73888889,-5.07388889,null ),
( 'BYN','Bayankhongor Airport','Bayankhongor, Mongolia','Bayankhongor, Mongolia','MN',' ',46.1625,100.7047222,8 ),
( 'BYT','Bantry Airport','Bantry, Ireland','Bantry, Ireland','IE',' ',51.67722222,-9.48694444,null ),
( 'BYU','Bayreuth Airport','Bayreuth, Germany','Bayreuth, Germany','DE',' ',49.98472222,11.64,1 ),
( 'BYW','Blakely Island Airport','Blakely Island, WA','Blakely Island, WA','US','WA',48.57888889,-122.8263889,-8 ),
( 'BZA','Bonanza Airport','Bonanza, Nicaragua','Bonanza, Nicaragua','NI',' ',14.03305556,-84.62444444,-6 ),
( 'BZE','Philip S. W. Goldson International','Belize City, Belize','Belize City, Belize','BZ',' ',17.54,-88.30472222,-6 ),
( 'BZG','Szwederowo','Bydgoszcz, Poland','Bydgoszcz, Poland','PL',' ',53.09666667,17.97777778,1 ),
( 'BZI','Balikesir Airport','Balikesir, Turkey','Balikesir, Turkey','TR',' ',39.61916667,27.92611111,2 ),
( 'BZN','Bozeman Yellowstone International','Bozeman, MT','Bozeman, MT','US','MT',45.7775,-111.1519444,-7 ),
( 'BZO','Bolzano Airport','Bolzano, Italy','Bolzano, Italy','IT',' ',46.46027778,11.32638889,1 ),
( 'BZR','Beziers Vias','Beziers, France','Beziers, France','FR',' ',43.32333333,3.35472222,1 ),
( 'BZT','Eagle Air Park','Brazoria, TX','Brazoria, TX','US','TX',28.98222222,-95.57972222,-6 ),
( 'BZV','Maya Maya','Brazzaville, Congo (Brazaville)','Brazzaville, Congo (Brazaville)','CG',' ',-4.25055556,15.25305556,1 ),
( 'BZZ','Brize Norton Airport','Brize Norton, United Kingdom','Brize Norton, United Kingdom','GB',' ',51.75,-1.58305556,null ),
( 'C01','Camarillo Airport','Camarillo, CA','Camarillo, CA','US','CA',34.21361111,-119.0944444,-8 ),
( 'C02','Bakersfield Municipal','Bakersfield, CA','Bakersfield, CA','US','CA',35.32472222,-118.9961111,-8 ),
( 'C1A','Del Mar Farms','Patterson, CA','Patterson, CA','US','CA',37.54638889,-121.1586111,-8 ),
( 'CA1','Koala Mine Airport','Koala Mine, Canada','Koala Mine, Canada','CA','NT',64.69,-110.62,null ),
( 'CA2','Lake Simcoe Airport','Lake Simcoe, Canada','Lake Simcoe, Canada','CA','ON',44.48611111,-79.55555556,null ),
( 'CA3','Thetford Mines Airport','Thetford Mines, Canada','Thetford Mines, Canada','CA','QC',46.05222222,-71.2575,null ),
( 'CA4','Pelee Island Airport','Pelee Island, Canada','Pelee Island, Canada','CA','ON',41.7775,-82.67805556,null ),
( 'CA5','Calgary Springbank','Calgary, Canada','Calgary, Canada','CA','AB',51.10527778,-114.3713889,-7 ),
( 'CA6','Chemehuevi Valley Airport','Chemehuevi Valley, CA','Chemehuevi Valley, CA','US','CA',34.52888889,-114.4319444,-8 ),
( 'CA7','Tracy Municipal','Tracy, CA','Tracy, CA','US','CA',37.68888889,-121.4416667,-8 ),
( 'CA9','Steep Island Lodge','Steep Island, Canada','Steep Island, Canada','CA','BC',50.08138889,-125.2533333,-8 ),
( 'CAB','Cabinda Airport','Cabinda, Angola','Cabinda, Angola','AO',' ',-5.59694444,12.18833333,1 ),
( 'CAC','Cascavel Airport','Cascavel, Brazil','Cascavel, Brazil','BR',' ',-25.00027778,-53.50083333,-3 ),
( 'CAD','Wexford County','Cadillac, MI','Cadillac, MI','US','MI',44.27527778,-85.41888889,-5 ),
( 'CAE','Columbia Metropolitan','Columbia, SC','Columbia, SC','US','SC',33.93888889,-81.11944444,-5 ),
( 'CAF','Carauari Airport','Carauari, Brazil','Carauari, Brazil','BR',' ',-4.87138889,-66.8975,-4 ),
( 'CAG','Elmas','Cagliari, Italy','Cagliari, Italy','IT',' ',39.25138889,9.05416667,1 ),
( 'CAH','Ca Mau Airport','Ca Mau, Vietnam','Ca Mau, Vietnam','VN',' ',9.1775,105.1777778,7 ),
( 'CAI','Cairo International','Cairo, Egypt','Cairo, Egypt','EG',' ',30.11527778,31.41388889,2 ),
( 'CAJ','Canaima Airport','Canaima, Venezuela','Canaima, Venezuela','VE',' ',6.23194444,-62.85472222,-4.5 ),
( 'CAK','Akron-Canton Regional','Akron, OH','Cleveland, OH (Metropolitan Area)','US','OH',40.915,-81.44361111,-5 ),
( 'CAL','Campbeltown Airport','Campbeltown, United Kingdom','Campbeltown, United Kingdom','GB',' ',55.4375,-5.68805556,null ),
( 'CAM','Choreti','Camiri, Bolivia','Camiri, Bolivia','BO',' ',-20.01111111,-63.56111111,-4 ),
( 'CAN','Baiyun International','Guangzhou, China','Guangzhou, China','CN',' ',23.39083333,113.305,8 ),
( 'CAP','Cap-Haitien International','Cap-Haitien, Haiti','Cap-Haitien, Haiti','HT',' ',19.72722222,-72.19944444,-5 ),
( 'CAR','Caribou Municipal','Caribou, ME','Caribou, ME','US','ME',46.87166667,-68.01805556,-5 ),
( 'CAT','New Bight Airport','New Bight, The Bahamas','New Bight, The Bahamas','BS',' ',24.31527778,-75.4525,-5 ),
( 'CAW','Bartolomeu Lisandro','Campos, Brazil','Campos, Brazil','BR',' ',-21.69833333,-41.30166667,-3 ),
( 'CAX','Carlisle Airport','Carlisle, United Kingdom','Carlisle, United Kingdom','GB',' ',54.9375,-2.80916667,null ),
( 'CAY','Cayenne Felix Eboue','Cayenne, French Guiana','Cayenne, French Guiana','GF',' ',4.82,-52.36111111,-3 ),
( 'CAZ','Cobar Airport','Cobar, Australia','Cobar, Australia','AU',' ',-31.53833333,145.7938889,10 ),
( 'CBA','Corner Bay Airport','Corner Bay, AK','Corner Bay, AK','US','AK',57.73777778,-135.1255556,-9 ),
( 'CBB','Jorge Wilstermann International','Cochabamba, Bolivia','Cochabamba, Bolivia','BO',' ',-17.41833333,-66.17722222,-4 ),
( 'CBE','Greater Cumberland Regional','Cumberland, MD','Cumberland, MD','US','MD',39.61555556,-78.76083333,-5 ),
( 'CBF','Council Bluffs Municipal','Council Bluffs, IA','Council Bluffs, IA','US','IA',41.26,-95.75861111,-6 ),
( 'CBG','Cambridge Airport','Cambridge, United Kingdom','Cambridge, United Kingdom','GB',' ',52.205,0.175,null ),
( 'CBH','Bechar/Leger','Colomb-Bechar, Algeria','Colomb-Bechar, Algeria','DZ',' ',31.64777778,-2.25972222,1 ),
( 'CBK','Murray','Colby, KS','Colby, KS','US','KS',39.40388889,-101.0466667,-6 ),
( 'CBL','Ciudad Bolivar Airport','Ciudad Bolivar, Venezuela','Ciudad Bolivar, Venezuela','VE',' ',8.12222222,-63.53694444,-4.5 ),
( 'CBM','Columbus AFB','Columbus, MS','Columbus, MS','US','MS',33.64527778,-88.44583333,-6 ),
( 'CBO','Cotabato Airport','Cotabato, Philippines','Cotabato, Philippines','PH',' ',7.16472222,124.2102778,8 ),
( 'CBQ','Calabar Airport','Calabar, Nigeria','Calabar, Nigeria','NG',' ',4.97611111,8.34722222,1 ),
( 'CBR','Canberra Airport','Canberra, Australia','Canberra, Australia','AU',' ',-35.30694444,149.195,10 ),
( 'CBV','Coban Airport','Coban, Guatemala','Coban, Guatemala','GT',' ',15.46916667,-90.40666667,-6 ),
( 'CBY','Canobie Airport','Canobie, Australia','Canobie, Australia','AU',' ',-19.47861111,140.9261111,10 ),
( 'CCC','Jardines del Rey International','Cayo Coco, Cuba','Cayo Coco, Cuba','CU',' ',22.46083333,-78.32861111,-5 ),
( 'CCE','Grand Case Airport','Grand Case, Saint Martin','Grand Case, Saint Martin','MF',' ',18.1,-63.04722222,-4 ),
( 'CCF','Carcassonne Salvaza','Carcassonne, France','Carcassonne, France','FR',' ',43.21611111,2.30583333,1 ),
( 'CCH','Chile Chico Airport','Chile Chico, Chile','Chile Chico, Chile','CL',' ',-46.58305556,-71.68666667,-4 ),
( 'CCI','Olavo Cecco Rigon','Concordia, Brazil','Concordia, Brazil','BR',' ',-27.18055556,-52.05277778,-3 ),
( 'CCJ','Calicut Airport','Calicut, India','Calicut, India','IN',' ',11.13777778,75.95055556,5.5 ),
( 'CCK','Cocos Keeling Island','West Island, Cocos (Keeling) Islands','Cocos (Keeling) Islands, Cocos (Keeling) Islands','CC',' ',-12.18861111,96.83055556,6.5 ),
( 'CCM','Criciuma','Crisciuma, Brazil','Crisciuma, Brazil','BR',' ',-28.72388889,-49.42083333,-3 ),
( 'CCN','Chakhcharan Airport','Chakhcharan, Afghanistan','Chakhcharan, Afghanistan','AF',' ',34.52666667,65.27138889,4.5 ),
( 'CCP','Carriel Sur International','Concepcion, Chile','Concepcion, Chile','CL',' ',-36.77138889,-73.06222222,-4 ),
( 'CCR','Buchanan Field','Concord, CA','San Francisco, CA (Metropolitan Area)','US','CA',37.98972222,-122.0569444,-8 ),
( 'CCS','Simon Bolivar International','Caracas, Venezuela','Caracas, Venezuela','VE',' ',10.60305556,-66.99138889,-4.5 ),
( 'CCU','Netaji Subhash Chandra Bose International','Kolkata, India','Kolkata, India','IN',' ',22.65472222,88.44666667,5.5 ),
( 'CCX','Caceres Airport','Caceres, Brazil','Caceres, Brazil','BR',' ',-16.04361111,-57.63,-4 ),
( 'CCY','Northeast Iowa Regional','Charles City, IA','Charles City, IA','US','IA',43.0725,-92.61083333,-6 ),
( 'CCZ','Chub Cay Airport','Chub Cay, The Bahamas','Chub Cay, The Bahamas','BS',' ',25.41722222,-77.88083333,-5 ),
( 'CDB','Cold Bay Airport','Cold Bay, AK','Cold Bay, AK','US','AK',55.20527778,-162.7244444,-9 ),
( 'CDC','Cedar City Regional','Cedar City, UT','Cedar City, UT','US','UT',37.70083333,-113.0988889,-7 ),
( 'CDF','Cortina d`Ampezzo Airport','Cortina d`Ampezzo, Italy','Cortina d`Ampezzo, Italy','IT',' ',46.57777778,12.11361111,1 ),
( 'CDG','Paris Charles de Gaulle','Paris, France','Paris, France','FR',' ',49.01277778,2.55,1 ),
( 'CDH','Harrell Field','Camden, AR','Camden, AR','US','AR',33.62277778,-92.76333333,-6 ),
( 'CDJ','Conceicao Do Araguaia Airport','Conceicao Do Araguaia, Brazil','Conceicao Do Araguaia, Brazil','BR',' ',-8.34777778,-49.30055556,-3 ),
( 'CDL','Candle 2','Candle, AK','Candle, AK','US','AK',65.90777778,-161.9263889,-9 ),
( 'CDN','Woodward Field','Camden, SC','Camden, SC','US','SC',34.28361111,-80.56472222,-5 ),
( 'CDR','Chadron Municipal','Chadron, NE','Chadron, NE','US','NE',42.8375,-103.0952778,-7 ),
( 'CDV','Merle K Mudhole Smith','Cordova, AK','Cordova, AK','US','AK',60.49166667,-145.4775,-9 ),
( 'CDW','Essex County','Caldwell, NJ','Caldwell, NJ','US','NJ',40.87527778,-74.28138889,-5 ),
( 'CEA','Cessna Aircraft Field','Wichita, KS','Wichita, KS','US','KS',37.64861111,-97.25055556,-6 ),
( 'CEB','Mactan-Cebu International','Lapu-Lapu City, Philippines','Cebu, Philippines','PH',' ',10.3075,123.9794444,8 ),
( 'CEC','Jack McNamara Field','Crescent City, CA','Crescent City, CA','US','CA',41.78027778,-124.2366667,-8 ),
( 'CED','Ceduna Airport','Ceduna, Australia','Ceduna, Australia','AU',' ',-32.13055556,133.7097222,9.5 ),
( 'CEF','Westover ARB Metropolitan','Chicopee Falls, MA','Chicopee Falls, MA','US','MA',42.19388889,-72.53472222,-5 ),
( 'CEG','Hawarden','Chester, United Kingdom','Chester, United Kingdom','GB',' ',53.17805556,-2.97777778,null ),
( 'CEI','Chiang Rai Airport','Chiang Rai, Thailand','Chiang Rai, Thailand','TH',' ',19.88555556,99.82555556,7 ),
( 'CEK','Chelyabinsk Airport','Chelyabinsk, Russia','Chelyabinsk, Russia','RU',' ',55.30583333,61.50361111,6 ),
( 'CEL','Cape Eleuthera Airport','Cape Eleuthera, The Bahamas','Cape Eleuthera, The Bahamas','BS',' ',24.78666667,-76.29861111,-5 ),
( 'CEM','Central Airport','Central, AK','Central, AK','US','AK',65.57388889,-144.7808333,-9 ),
( 'CEN','Ciudad Obregon International','Ciudad Obregon, Mexico','Ciudad Obregon, Mexico','MX',' ',27.39277778,-109.8330556,-7 ),
( 'CEO','Waco Kungo Airport','Waco Kungo, Angola','Waco Kungo, Angola','AO',' ',-11.42638889,15.10138889,1 ),
( 'CEP','Concepcion Airport','Concepcion, Bolivia','Concepcion, Bolivia','BO',' ',-16.14333333,-62.02611111,-4 ),
( 'CEQ','Cannes Mandelieu','Cannes, France','Cannes, France','FR',' ',43.54638889,6.95416667,1 ),
( 'CER','Cherbourg Maupertus','Cherbourg, France','Cherbourg, France','FR',' ',49.65083333,-1.47527778,1 ),
( 'CET','Cholet Le Pontreau','Cholet, France','Cholet, France','FR',' ',47.08222222,-0.87694444,1 ),
( 'CEU','Oconee County Regional','Clemson, SC','Clemson, SC','US','SC',34.67222222,-82.88583333,-5 ),
( 'CEV','Mettel Field','Connersville, IN','Connersville, IN','US','IN',39.69805556,-85.13111111,-5 ),
( 'CEW','Bob Sikes','Crestview, FL','Crestview, FL','US','FL',30.77888889,-86.52222222,-6 ),
( 'CEX','Chena Hot Springs Airport','Chena Hot Springs, AK','Chena Hot Springs, AK','US','AK',65.05194444,-146.0475,-9 ),
( 'CEY','Kyle-Oakley Field','Murray, KY','Murray, KY','US','KY',36.66444444,-88.37277778,-6 ),
( 'CEZ','Cortez Municipal','Cortez, CO','Cortez, CO','US','CO',37.30305556,-108.6280556,-7 ),
( 'CFA','Coffee Point Airport','Coffee Point, AK','Coffee Point, AK','US','AK',58.21666667,-157.5,-9 ),
( 'CFB','Cabo Frio Airport','Cabo Frio, Brazil','Cabo Frio, Brazil','BR',' ',-22.92138889,-42.07166667,-3 ),
( 'CFE','Clermont Ferrand Auvergne','Clermont-Ferrand, France','Clermont-Ferrand, France','FR',' ',45.78666667,3.17,1 ),
( 'CFG','Jaime Gonzalez','Cienfuegos, Cuba','Cienfuegos, Cuba','CU',' ',22.14972222,-80.41444444,-5 ),
( 'CFQ','Silver City Airport','Silver City, Canada','Silver City, Canada','CA','YT',61.02888889,-138.4075,-8 ),
( 'CFR','Caen Carpiquet','Caen, France','Caen, France','FR',' ',49.17333333,-0.45,1 ),
( 'CFS','Coffs Harbour Airport','Coffs Harbour, Australia','Coffs Harbour, Australia','AU',' ',-30.32055556,153.1163889,10 ),
( 'CFT','Greenlee County','Clifton, AZ','Clifton, AZ','US','AZ',32.95694444,-109.2111111,-7 ),
( 'CFU','Ioannis Kapodistrias International','Corfu, Greece','Corfu, Greece','GR',' ',39.60194444,19.91222222,2 ),
( 'CFV','Coffeyville Municipal','Coffeyville, KS','Coffeyville, KS','US','KS',37.09388889,-95.57194444,-6 ),
( 'CGA','Craig Seaplane Base','Craig, AK','Craig, AK','US','AK',55.47916667,-133.1461111,-9 ),
( 'CGB','Marechal Rondon International','Cuiaba, Brazil','Cuiaba, Brazil','BR',' ',-15.65305556,-56.11666667,-4 ),
( 'CGC','Cape Gloucester Airport','Cape Gloucester, Papua New Guinea','Cape Gloucester, Papua New Guinea','PG',' ',-5.45277778,148.4236111,10 ),
( 'CGE','Cambridge-Dorchester','Cambridge, MD','Cambridge, MD','US','MD',38.53944444,-76.03027778,-5 ),
( 'CGF','Cuyahoga County','Cleveland, OH','Cleveland, OH (Metropolitan Area)','US','OH',41.565,-81.48638889,-5 ),
( 'CGH','Congonhas','Sao Paulo, Brazil','Sao Paulo, Brazil','BR',' ',-23.62666667,-46.65527778,-3 ),
( 'CGI','Cape Girardeau Regional','Cape Girardeau, MO','Cape Girardeau, MO','US','MO',37.22527778,-89.57083333,-6 ),
( 'CGK','Soekarno-Hatta International','Jakarta, Indonesia','Jakarta, Indonesia','ID',' ',-6.12583333,106.6563889,7 ),
( 'CGM','Camiguin Airport','Camiguin, Philippines','Camiguin, Philippines','PH',' ',9.25388889,124.7086111,8 ),
( 'CGN','Koln Bonn','Cologne, Germany','Cologne/Dusseldorf, Germany','DE',' ',50.86583333,7.14277778,1 ),
( 'CGO','Xinzheng','Zhengzhou, China','Zhengzhou, China','CN',' ',34.51833333,113.84,8 ),
( 'CGP','Chittagong Airport','Chittagong, Bangladesh','Chittagong, Bangladesh','BD',' ',22.2575,91.82555556,6 ),
( 'CGQ','Longjia','Changchun, China','ChangchunJilin City, China','CN',' ',43.99638889,125.6852778,8 ),