-
Notifications
You must be signed in to change notification settings - Fork 0
/
dutinfopw201624.sql
7415 lines (7380 loc) · 988 KB
/
dutinfopw201624.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
-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jan 21, 2019 at 10:37 AM
-- Server version: 5.7.23
-- PHP Version: 7.2.10
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `dutinfopw201624`
--
-- --------------------------------------------------------
--
-- Table structure for table `aeroport`
--
DROP TABLE IF EXISTS `aeroport`;
CREATE TABLE IF NOT EXISTS `aeroport` (
`idAeroport` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`nomAeroport` varchar(66) NOT NULL,
`villeAeroport` varchar(33) NOT NULL,
`paysAeroport` varchar(32) NOT NULL,
`longitude` decimal(34,13) DEFAULT NULL,
`latitude` decimal(34,14) DEFAULT NULL,
`codeAITA` varchar(3) DEFAULT NULL,
`codeOACI` varchar(4) DEFAULT NULL,
`photoBaseAeroport` text NOT NULL,
`vue` int(11) NOT NULL,
`altitude` int(5) DEFAULT NULL,
`noteGlobaleMoyenne` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`idAeroport`),
UNIQUE KEY `idAerport` (`idAeroport`)
) ENGINE=InnoDB AUTO_INCREMENT=12058 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `aeroport`
--
INSERT INTO `aeroport` (`idAeroport`, `nomAeroport`, `villeAeroport`, `paysAeroport`, `longitude`, `latitude`, `codeAITA`, `codeOACI`, `photoBaseAeroport`, `vue`, `altitude`, `noteGlobaleMoyenne`) VALUES
(1, 'Goroka Airport', 'Goroka', 'Papua New Guinea', '145.3919982910000', '-6.08168983459000', 'GKA', 'AYGA', 'base.jpg', 0, 5282, 0),
(2, 'Madang Airport', 'Madang', 'Papua New Guinea', '145.7890014650000', '-5.20707988739000', 'MAG', 'AYMD', 'base.jpg', 0, 20, 0),
(3, 'Mount Hagen Kagamuga Airport', 'Mount Hagen', 'Papua New Guinea', '144.2960052490234', '-5.82678985595703', 'HGU', 'AYMH', 'base.jpg', 0, 5388, 0),
(4, 'Nadzab Airport', 'Nadzab', 'Papua New Guinea', '146.7259770000000', '-6.56980300000000', 'LAE', 'AYNZ', 'base.jpg', 0, 239, 0),
(5, 'Port Moresby Jacksons International Airport', 'Port Moresby', 'Papua New Guinea', '147.2200012207031', '-9.44338035583496', 'POM', 'AYPY', 'base.jpg', 0, 146, 0),
(6, 'Wewak International Airport', 'Wewak', 'Papua New Guinea', '143.6690063480000', '-3.58383011818000', 'WWK', 'AYWK', 'base.jpg', 0, 19, 0),
(7, 'Narsarsuaq Airport', 'Narssarssuaq', 'Greenland', '-45.4259986877000', '61.16049957280000', 'UAK', 'BGBW', 'base.jpg', 0, 112, 0),
(8, 'Godthaab / Nuuk Airport', 'Godthaab', 'Greenland', '-51.6781005859000', '64.19090271000000', 'GOH', 'BGGH', 'base.jpg', 0, 283, 0),
(9, 'Kangerlussuaq Airport', 'Sondrestrom', 'Greenland', '-50.7116031647000', '67.01222189920000', 'SFJ', 'BGSF', 'base.jpg', 0, 165, 0),
(10, 'Thule Air Base', 'Thule', 'Greenland', '-68.7032012939000', '76.53119659420000', 'THU', 'BGTL', 'base.jpg', 0, 251, 0),
(11, 'Akureyri Airport', 'Akureyri', 'Iceland', '-18.0727005004883', '65.66000366210938', 'AEY', 'BIAR', 'base.jpg', 0, 6, 0),
(12, 'Egilsstaðir Airport', 'Egilsstadir', 'Iceland', '-14.4013996124268', '65.28330230712890', 'EGS', 'BIEG', 'base.jpg', 0, 76, 0),
(13, 'Hornafjörður Airport', 'Hofn', 'Iceland', '-15.2272000000000', '64.29560100000000', 'HFN', 'BIHN', 'base.jpg', 0, 24, 0),
(14, 'Húsavík Airport', 'Husavik', 'Iceland', '-17.4260010000000', '65.95230100000000', 'HZK', 'BIHU', 'base.jpg', 0, 48, 0),
(15, 'Ísafjörður Airport', 'Isafjordur', 'Iceland', '-23.1352996826172', '66.05809783935547', 'IFJ', 'BIIS', 'base.jpg', 0, 8, 0),
(16, 'Keflavik International Airport', 'Keflavik', 'Iceland', '-22.6056003570560', '63.98500061035200', 'KEF', 'BIKF', 'base.jpg', 0, 171, 0),
(17, 'Patreksfjörður Airport', 'Patreksfjordur', 'Iceland', '-23.9650000000000', '65.55580100000000', 'PFJ', 'BIPA', 'base.jpg', 0, 11, 0),
(18, 'Reykjavik Airport', 'Reykjavik', 'Iceland', '-21.9405994415000', '64.12999725340000', 'RKV', 'BIRK', 'base.jpg', 0, 48, 0),
(19, 'Siglufjörður Airport', 'Siglufjordur', 'Iceland', '-18.9167000000000', '66.13330100000000', 'SIJ', 'BISI', 'base.jpg', 0, 10, 0),
(20, 'Vestmannaeyjar Airport', 'Vestmannaeyjar', 'Iceland', '-20.2789001464844', '63.42430114746094', 'VEY', 'BIVM', 'base.jpg', 0, 326, 0),
(21, 'Sault Ste Marie Airport', 'Sault Sainte Marie', 'Canada', '-84.5093994140625', '46.48500061035156', 'YAM', 'CYAM', 'base.jpg', 0, 630, 0),
(22, 'Winnipeg / St. Andrews Airport', 'Winnipeg', 'Canada', '-97.0325012207000', '50.05640029910000', 'YAV', 'CYAV', 'base.jpg', 0, 760, 0),
(23, 'Halifax / CFB Shearwater Heliport', 'Halifax', 'Canada', '-63.4994010925000', '44.63970184330000', 'YAW', 'CYAW', 'base.jpg', 0, 144, 0),
(24, 'St. Anthony Airport', 'St. Anthony', 'Canada', '-56.0830993652000', '51.39189910890000', 'YAY', 'CYAY', 'base.jpg', 0, 108, 0),
(25, 'Tofino / Long Beach Airport', 'Tofino', 'Canada', '-125.7755830000000', '49.07983300000000', 'YAZ', 'CYAZ', 'base.jpg', 0, 80, 0),
(26, 'Kugaaruk Airport', 'Pelly Bay', 'Canada', '-89.8080980000000', '68.53440100000000', 'YBB', 'CYBB', 'base.jpg', 0, 56, 0),
(27, 'Baie Comeau Airport', 'Baie Comeau', 'Canada', '-68.2043991088867', '49.13249969482422', 'YBC', 'CYBC', 'base.jpg', 0, 71, 0),
(28, 'CFB Bagotville', 'Bagotville', 'Canada', '-70.9963989257813', '48.33060073852539', 'YBG', 'CYBG', 'base.jpg', 0, 522, 0),
(29, 'Baker Lake Airport', 'Baker Lake', 'Canada', '-96.0777969360000', '64.29889678960001', 'YBK', 'CYBK', 'base.jpg', 0, 59, 0),
(30, 'Campbell River Airport', 'Campbell River', 'Canada', '-125.2710037231445', '49.95080184936523', 'YBL', 'CYBL', 'base.jpg', 0, 346, 0),
(31, 'Brandon Municipal Airport', 'Brandon', 'Canada', '-99.9518970000000', '49.91000000000000', 'YBR', 'CYBR', 'base.jpg', 0, 1343, 0),
(32, 'Cambridge Bay Airport', 'Cambridge Bay', 'Canada', '-105.1380004880000', '69.10810089110000', 'YCB', 'CYCB', 'base.jpg', 0, 90, 0),
(33, 'Nanaimo Airport', 'Nanaimo', 'Canada', '-123.8698625560000', '49.05497022490000', 'YCD', 'CYCD', 'base.jpg', 0, 92, 0),
(34, 'Castlegar/West Kootenay Regional Airport', 'Castlegar', 'Canada', '-117.6320037840000', '49.29639816280000', 'YCG', 'CYCG', 'base.jpg', 0, 1624, 0),
(35, 'Miramichi Airport', 'Chatham', 'Canada', '-65.4492030000000', '47.00780100000000', 'YCH', 'CYCH', 'base.jpg', 0, 108, 0),
(36, 'Charlo Airport', 'Charlo', 'Canada', '-66.3302990000000', '47.99079900000000', 'YCL', 'CYCL', 'base.jpg', 0, 132, 0),
(37, 'Kugluktuk Airport', 'Coppermine', 'Canada', '-115.1439971920000', '67.81670379639999', 'YCO', 'CYCO', 'base.jpg', 0, 74, 0),
(38, 'Coronation Airport', 'Coronation', 'Canada', '-111.4449996950000', '52.07500076290000', 'YCT', 'CYCT', 'base.jpg', 0, 2595, 0),
(39, 'Chilliwack Airport', 'Chilliwack', 'Canada', '-121.9390029910000', '49.15280151370000', 'YCW', 'CYCW', 'base.jpg', 0, 32, 0),
(40, 'Clyde River Airport', 'Clyde River', 'Canada', '-68.5167007446000', '70.48609924320000', 'YCY', 'CYCY', 'base.jpg', 0, 87, 0),
(41, 'Coral Harbour Airport', 'Coral Harbour', 'Canada', '-83.3593978882000', '64.19329833980000', 'YZS', 'CYZS', 'base.jpg', 0, 210, 0),
(42, 'Dawson City Airport', 'Dawson', 'Canada', '-139.1280059814453', '64.04309844970703', 'YDA', 'CYDA', 'base.jpg', 0, 1215, 0),
(43, 'Burwash Airport', 'Burwash', 'Canada', '-139.0410003662109', '61.37110137939453', 'YDB', 'CYDB', 'base.jpg', 0, 2647, 0),
(44, 'Princeton Airport', 'Princeton', 'Canada', '-120.5110015870000', '49.46810150150000', 'YDC', 'CYDC', 'base.jpg', 0, 2298, 0),
(45, 'Deer Lake Airport', 'Deer Lake', 'Canada', '-57.3913993835449', '49.21080017089844', 'YDF', 'CYDF', 'base.jpg', 0, 72, 0),
(46, 'Dease Lake Airport', 'Dease Lake', 'Canada', '-130.0319976810000', '58.42219924930000', 'YDL', 'CYDL', 'base.jpg', 0, 2600, 0),
(47, 'Dauphin Barker Airport', 'Dauphin', 'Canada', '-100.0520019531250', '51.10079956054688', 'YDN', 'CYDN', 'base.jpg', 0, 999, 0),
(48, 'Dawson Creek Airport', 'Dawson Creek', 'Canada', '-120.1829986572266', '55.74229812622070', 'YDQ', 'CYDQ', 'base.jpg', 0, 2148, 0),
(49, 'Edmonton International Airport', 'Edmonton', 'Canada', '-113.5800018310000', '53.30970001220000', 'YEG', 'CYEG', 'base.jpg', 0, 2373, 0),
(50, 'Arviat Airport', 'Eskimo Point', 'Canada', '-94.0708007812000', '61.09420013430000', 'YEK', 'CYEK', 'base.jpg', 0, 32, 0),
(51, 'Estevan Airport', 'Estevan', 'Canada', '-102.9660034180000', '49.21030044560000', 'YEN', 'CYEN', 'base.jpg', 0, 1905, 0),
(52, 'Edson Airport', 'Edson', 'Canada', '-116.4649963380000', '53.57889938349999', 'YET', 'CYET', 'base.jpg', 0, 3043, 0),
(53, 'Eureka Airport', 'Eureka', 'Canada', '-85.8142013550000', '79.99469757080000', 'YEU', 'CYEU', 'base.jpg', 0, 256, 0),
(54, 'Inuvik Mike Zubko Airport', 'Inuvik', 'Canada', '-133.4830017090000', '68.30419921880001', 'YEV', 'CYEV', 'base.jpg', 0, 224, 0),
(55, 'Iqaluit Airport', 'Iqaluit', 'Canada', '-68.5558013916000', '63.75640106200000', 'YFB', 'CYFB', 'base.jpg', 0, 110, 0),
(56, 'Fredericton Airport', 'Fredericton', 'Canada', '-66.5372009277344', '45.86890029907227', 'YFC', 'CYFC', 'base.jpg', 0, 68, 0),
(57, 'Forestville Airport', 'Forestville', 'Canada', '-69.0971984863281', '48.74610137939453', '\\N', 'CYFE', 'base.jpg', 0, 293, 0),
(58, 'Flin Flon Airport', 'Flin Flon', 'Canada', '-101.6819992065430', '54.67810058593750', 'YFO', 'CYFO', 'base.jpg', 0, 997, 0),
(59, 'Fort Resolution Airport', 'Fort Resolution', 'Canada', '-113.6900024410000', '61.18080139160000', 'YFR', 'CYFR', 'base.jpg', 0, 526, 0),
(60, 'Fort Simpson Airport', 'Fort Simpson', 'Canada', '-121.2369995117188', '61.76020050048828', 'YFS', 'CYFS', 'base.jpg', 0, 555, 0),
(61, 'Kingston Norman Rogers Airport', 'Kingston', 'Canada', '-76.5969009399414', '44.22529983520508', 'YGK', 'CYGK', 'base.jpg', 0, 305, 0),
(62, 'La Grande Rivière Airport', 'La Grande Riviere', 'Canada', '-77.7042007446289', '53.62530136108398', 'YGL', 'CYGL', 'base.jpg', 0, 639, 0),
(63, 'Gaspé (Michel-Pouliot) Airport', 'Gaspe', 'Canada', '-64.4785995483000', '48.77529907230000', 'YGP', 'CYGP', 'base.jpg', 0, 112, 0),
(64, 'Geraldton Greenstone Regional Airport', 'Geraldton', 'Canada', '-86.9393997192383', '49.77830123901367', 'YGQ', 'CYGQ', 'base.jpg', 0, 1144, 0),
(65, 'Îles-de-la-Madeleine Airport', 'Iles De La Madeleine', 'Canada', '-61.7780990600586', '47.42470169067383', 'YGR', 'CYGR', 'base.jpg', 0, 35, 0),
(66, 'Hudson Bay Airport', 'Hudson Bay', 'Canada', '-102.3109970090000', '52.81669998170000', 'YHB', 'CYHB', 'base.jpg', 0, 1175, 0),
(67, 'Dryden Regional Airport', 'Dryden', 'Canada', '-92.7442016601563', '49.83169937133789', 'YHD', 'CYHD', 'base.jpg', 0, 1354, 0),
(68, 'Ulukhaktok Holman Airport', 'Holman Island', 'Canada', '-117.8059997558594', '70.76280212402344', 'YHI', 'CYHI', 'base.jpg', 0, 117, 0),
(69, 'Gjoa Haven Airport', 'Gjoa Haven', 'Canada', '-95.8497009277000', '68.63559722900000', 'YHK', 'CYHK', 'base.jpg', 0, 152, 0),
(70, 'John C. Munro Hamilton International Airport', 'Hamilton', 'Canada', '-79.9349975586000', '43.17359924320000', 'YHM', 'CYHM', 'base.jpg', 0, 780, 0),
(71, 'Montréal / Saint-Hubert Airport', 'Montreal', 'Canada', '-73.4169006348000', '45.51750183110000', 'YHU', 'CYHU', 'base.jpg', 0, 90, 0),
(72, 'Hay River / Merlyn Carter Airport', 'Hay River', 'Canada', '-115.7829971310000', '60.83969879150000', 'YHY', 'CYHY', 'base.jpg', 0, 541, 0),
(73, 'Halifax / Stanfield International Airport', 'Halifax', 'Canada', '-63.5085983276000', '44.88079833980000', 'YHZ', 'CYHZ', 'base.jpg', 0, 477, 0),
(74, 'Atikokan Municipal Airport', 'Atikokan', 'Canada', '-91.6386032104000', '48.77389907840000', 'YIB', 'CYIB', 'base.jpg', 0, 1408, 0),
(75, 'Pond Inlet Airport', 'Pond Inlet', 'Canada', '-77.9666976929000', '72.68329620360000', 'YIO', 'CYIO', 'base.jpg', 0, 181, 0),
(76, 'St Jean Airport', 'St. Jean', 'Canada', '-73.2810974121094', '45.29439926147461', 'YJN', 'CYJN', 'base.jpg', 0, 136, 0),
(77, 'Stephenville Airport', 'Stephenville', 'Canada', '-58.5499992370606', '48.54420089721680', 'YJT', 'CYJT', 'base.jpg', 0, 84, 0),
(78, 'Kamloops Airport', 'Kamloops', 'Canada', '-120.4440002440000', '50.70220184330000', 'YKA', 'CYKA', 'base.jpg', 0, 1133, 0),
(79, 'Waterloo Airport', 'Waterloo', 'Canada', '-80.3786010742000', '43.46080017089999', 'YKF', 'CYKF', 'base.jpg', 0, 1055, 0),
(80, 'Schefferville Airport', 'Schefferville', 'Canada', '-66.8052978515625', '54.80530166625977', 'YKL', 'CYKL', 'base.jpg', 0, 1709, 0),
(81, 'Kindersley Airport', 'Kindersley', 'Canada', '-109.1809997560000', '51.51750183110000', 'YKY', 'CYKY', 'base.jpg', 0, 2277, 0),
(82, 'Buttonville Municipal Airport', 'Toronto', 'Canada', '-79.3700027465820', '43.86220169067383', 'YKZ', 'CYKZ', 'base.jpg', 0, 650, 0),
(83, 'Chapleau Airport', 'Chapleau', 'Canada', '-83.3467025756836', '47.81999969482422', 'YLD', 'CYLD', 'base.jpg', 0, 1470, 0),
(84, 'Meadow Lake Airport', 'Meadow Lake', 'Canada', '-108.5230026245117', '54.12530136108398', 'YLJ', 'CYLJ', 'base.jpg', 0, 1576, 0),
(85, 'Lloydminster Airport', 'Lloydminster', 'Canada', '-110.0729980468750', '53.30920028686523', 'YLL', 'CYLL', 'base.jpg', 0, 2193, 0),
(86, 'Alert Airport', 'Alert', 'Canada', '-62.2806015015000', '82.51779937740001', 'YLT', 'CYLT', 'base.jpg', 0, 100, 0),
(87, 'Kelowna International Airport', 'Kelowna', 'Canada', '-119.3779983520000', '49.95610046390000', 'YLW', 'CYLW', 'base.jpg', 0, 1421, 0),
(88, 'Mayo Airport', 'Mayo', 'Canada', '-135.8679962158203', '63.61640167236328', 'YMA', 'CYMA', 'base.jpg', 0, 1653, 0),
(89, 'Moose Jaw Air Vice Marshal C. M. McEwen Airport', 'Moose Jaw', 'Canada', '-105.5589981079102', '50.33029937744141', 'YMJ', 'CYMJ', 'base.jpg', 0, 1892, 0),
(90, 'Fort McMurray Airport', 'Fort Mcmurray', 'Canada', '-111.2220001220000', '56.65330123900000', 'YMM', 'CYMM', 'base.jpg', 0, 1211, 0),
(91, 'Moosonee Airport', 'Moosonee', 'Canada', '-80.6078033447266', '51.29109954833984', 'YMO', 'CYMO', 'base.jpg', 0, 30, 0),
(92, 'Maniwaki Airport', 'Maniwaki', 'Canada', '-75.9906005859000', '46.27280044560000', 'YMW', 'CYMW', 'base.jpg', 0, 656, 0),
(93, 'Montreal International (Mirabel) Airport', 'Montreal', 'Canada', '-74.0386962891000', '45.67950057980000', 'YMX', 'CYMX', 'base.jpg', 0, 270, 0),
(94, 'Natashquan Airport', 'Natashquan', 'Canada', '-61.7891998291016', '50.18999862670898', 'YNA', 'CYNA', 'base.jpg', 0, 39, 0),
(95, 'Ottawa / Gatineau Airport', 'Gatineau', 'Canada', '-75.5635986328000', '45.52170181270000', 'YND', 'CYND', 'base.jpg', 0, 211, 0),
(96, 'Matagami Airport', 'Matagami', 'Canada', '-77.8028030395508', '49.76169967651367', 'YNM', 'CYNM', 'base.jpg', 0, 918, 0),
(97, 'Old Crow Airport', 'Old Crow', 'Canada', '-139.8390045166016', '67.57060241699219', 'YOC', 'CYOC', 'base.jpg', 0, 824, 0),
(98, 'CFB Cold Lake', 'Cold Lake', 'Canada', '-110.2789993286133', '54.40499877929688', 'YOD', 'CYOD', 'base.jpg', 0, 1775, 0),
(99, 'High Level Airport', 'High Level', 'Canada', '-117.1650009155273', '58.62139892578125', 'YOJ', 'CYOJ', 'base.jpg', 0, 1110, 0),
(100, 'Ottawa Macdonald-Cartier International Airport', 'Ottawa', 'Canada', '-75.6691970825195', '45.32249832153320', 'YOW', 'CYOW', 'base.jpg', 0, 374, 0),
(101, 'Prince Albert Glass Field', 'Prince Albert', 'Canada', '-105.6729965210000', '53.21419906620000', 'YPA', 'CYPA', 'base.jpg', 0, 1405, 0),
(102, 'Peace River Airport', 'Peace River', 'Canada', '-117.4469985961914', '56.22689819335938', 'YPE', 'CYPE', 'base.jpg', 0, 1873, 0),
(103, 'Southport Airport', 'Portage-la-prairie', 'Canada', '-98.2738170000000', '49.90309900000000', 'YPG', 'CYPG', 'base.jpg', 0, 885, 0),
(104, 'Pitt Meadows Airport', 'Pitt Meadows', 'Canada', '-122.7099990844727', '49.21609878540039', '\\N', 'CYPK', 'base.jpg', 0, 11, 0),
(105, 'Pickle Lake Airport', 'Pickle Lake', 'Canada', '-90.2142028808594', '51.44639968872070', 'YPL', 'CYPL', 'base.jpg', 0, 1267, 0),
(106, 'Port Menier Airport', 'Port Menier', 'Canada', '-64.2885971069336', '49.83639907836914', 'YPN', 'CYPN', 'base.jpg', 0, 167, 0),
(107, 'Peterborough Airport', 'Peterborough', 'Canada', '-78.3632965087891', '44.22999954223633', 'YPQ', 'CYPQ', 'base.jpg', 0, 628, 0),
(108, 'Prince Rupert Airport', 'Prince Pupert', 'Canada', '-130.4450073240000', '54.28609848020000', 'YPR', 'CYPR', 'base.jpg', 0, 116, 0),
(109, 'Fort Chipewyan Airport', 'Fort Chipewyan', 'Canada', '-111.1169967651367', '58.76720046997070', 'YPY', 'CYPY', 'base.jpg', 0, 761, 0),
(110, 'Muskoka Airport', 'Muskoka', 'Canada', '-79.3032989501953', '44.97470092773438', 'YQA', 'CYQA', 'base.jpg', 0, 925, 0),
(111, 'Quebec Jean Lesage International Airport', 'Quebec', 'Canada', '-71.3933030000000', '46.79110000000000', 'YQB', 'CYQB', 'base.jpg', 0, 244, 0),
(112, 'Red Deer Regional Airport', 'Red Deer Industrial', 'Canada', '-113.8939971923828', '52.18220138549805', 'YQF', 'CYQF', 'base.jpg', 0, 2968, 0),
(113, 'Windsor Airport', 'Windsor', 'Canada', '-82.9555969238281', '42.27560043334961', 'YQG', 'CYQG', 'base.jpg', 0, 622, 0),
(114, 'Watson Lake Airport', 'Watson Lake', 'Canada', '-128.8220062255859', '60.11640167236328', 'YQH', 'CYQH', 'base.jpg', 0, 2255, 0),
(115, 'Kenora Airport', 'Kenora', 'Canada', '-94.3630981445313', '49.78829956054688', 'YQK', 'CYQK', 'base.jpg', 0, 1332, 0),
(116, 'Lethbridge County Airport', 'Lethbridge', 'Canada', '-112.8000030520000', '49.63029861450000', 'YQL', 'CYQL', 'base.jpg', 0, 3048, 0),
(117, 'Greater Moncton International Airport', 'Moncton', 'Canada', '-64.6785964965820', '46.11220169067383', 'YQM', 'CYQM', 'base.jpg', 0, 232, 0),
(119, 'Comox Airport', 'Comox', 'Canada', '-124.8870010375977', '49.71080017089844', 'YQQ', 'CYQQ', 'base.jpg', 0, 84, 0),
(120, 'Regina International Airport', 'Regina', 'Canada', '-104.6660003662109', '50.43190002441406', 'YQR', 'CYQR', 'base.jpg', 0, 1894, 0),
(121, 'Thunder Bay Airport', 'Thunder Bay', 'Canada', '-89.3238983154297', '48.37189865112305', 'YQT', 'CYQT', 'base.jpg', 0, 653, 0),
(122, 'Grande Prairie Airport', 'Grande Prairie', 'Canada', '-118.8850021360000', '55.17969894410000', 'YQU', 'CYQU', 'base.jpg', 0, 2195, 0),
(123, 'Yorkton Municipal Airport', 'Yorkton', 'Canada', '-102.4619979858398', '51.26470184326172', 'YQV', 'CYQV', 'base.jpg', 0, 1635, 0),
(124, 'North Battleford Airport', 'North Battleford', 'Canada', '-108.2440032958984', '52.76919937133789', 'YQW', 'CYQW', 'base.jpg', 0, 1799, 0),
(125, 'Gander International Airport', 'Gander', 'Canada', '-54.5680999755859', '48.93690109252930', 'YQX', 'CYQX', 'base.jpg', 0, 496, 0),
(126, 'Sydney / J.A. Douglas McCurdy Airport', 'Sydney', 'Canada', '-60.0477981567000', '46.16139984130000', 'YQY', 'CYQY', 'base.jpg', 0, 203, 0),
(127, 'Quesnel Airport', 'Quesnel', 'Canada', '-122.5100021362305', '53.02610015869141', 'YQZ', 'CYQZ', 'base.jpg', 0, 1789, 0),
(128, 'Resolute Bay Airport', 'Resolute', 'Canada', '-94.9693984985000', '74.71690368650000', 'YRB', 'CYRB', 'base.jpg', 0, 215, 0),
(129, 'Rivière-du-Loup Airport', 'Riviere Du Loup', 'Canada', '-69.5847015380859', '47.76440048217773', 'YRI', 'CYRI', 'base.jpg', 0, 427, 0),
(130, 'Roberval Airport', 'Roberval', 'Canada', '-72.2656021118164', '48.52000045776367', 'YRJ', 'CYRJ', 'base.jpg', 0, 586, 0),
(131, 'Rocky Mountain House Airport', 'Rocky Mountain House', 'Canada', '-114.9039993290000', '52.42969894410000', 'YRM', 'CYRM', 'base.jpg', 0, 3244, 0),
(132, 'Rankin Inlet Airport', 'Rankin Inlet', 'Canada', '-92.1157989502000', '62.81140136720000', 'YRT', 'CYRT', 'base.jpg', 0, 94, 0),
(133, 'Sudbury Airport', 'Sudbury', 'Canada', '-80.7988967895508', '46.62500000000000', 'YSB', 'CYSB', 'base.jpg', 0, 1141, 0),
(134, 'Sherbrooke Airport', 'Sherbrooke', 'Canada', '-71.6913986206055', '45.43859863281250', 'YSC', 'CYSC', 'base.jpg', 0, 792, 0),
(135, 'Saint John Airport', 'St. John', 'Canada', '-65.8902969360352', '45.31610107421875', 'YSJ', 'CYSJ', 'base.jpg', 0, 357, 0),
(136, 'Fort Smith Airport', 'Fort Smith', 'Canada', '-111.9619979858398', '60.02030181884766', 'YSM', 'CYSM', 'base.jpg', 0, 671, 0),
(137, 'Nanisivik Airport', 'Nanisivik', 'Canada', '-84.6136020000000', '72.98220100000000', 'YSR', 'CYSR', 'base.jpg', 0, 2106, 0),
(138, 'Summerside Airport', 'Summerside', 'Canada', '-63.8335990905762', '46.44060134887695', 'YSU', 'CYSU', 'base.jpg', 0, 56, 0),
(139, 'Sachs Harbour (David Nasogaluak Jr. Saaryuaq) Airport', 'Sachs Harbour', 'Canada', '-125.2429962160000', '71.99389648440000', 'YSY', 'CYSY', 'base.jpg', 0, 282, 0),
(140, 'Cape Dorset Airport', 'Cape Dorset', 'Canada', '-76.5267028809000', '64.23000335690000', 'YTE', 'CYTE', 'base.jpg', 0, 164, 0),
(141, 'Thompson Airport', 'Thompson', 'Canada', '-97.8641967773438', '55.80110168457031', 'YTH', 'CYTH', 'base.jpg', 0, 729, 0),
(142, 'CFB Trenton', 'Trenton', 'Canada', '-77.5280990600586', '44.11890029907227', 'YTR', 'CYTR', 'base.jpg', 0, 283, 0),
(143, 'Timmins/Victor M. Power', 'Timmins', 'Canada', '-81.3767013550000', '48.56969833370000', 'YTS', 'CYTS', 'base.jpg', 0, 967, 0),
(144, 'Billy Bishop Toronto City Centre Airport', 'Toronto', 'Canada', '-79.3962020000000', '43.62749900000000', 'YTZ', 'CYTZ', 'base.jpg', 0, 252, 0),
(145, 'Tuktoyaktuk Airport', 'Tuktoyaktuk', 'Canada', '-133.0260009765625', '69.43329620361328', 'YUB', 'CYUB', 'base.jpg', 0, 15, 0),
(146, 'Montreal / Pierre Elliott Trudeau International Airport', 'Montreal', 'Canada', '-73.7407989502000', '45.47060012820000', 'YUL', 'CYUL', 'base.jpg', 0, 118, 0),
(147, 'Repulse Bay Airport', 'Repulse Bay', 'Canada', '-86.2247009277000', '66.52140045170000', 'YUT', 'CYUT', 'base.jpg', 0, 80, 0),
(148, 'Hall Beach Airport', 'Hall Beach', 'Canada', '-81.2425000000000', '68.77610015869999', 'YUX', 'CYUX', 'base.jpg', 0, 30, 0),
(149, 'Rouyn Noranda Airport', 'Rouyn', 'Canada', '-78.8356018066406', '48.20610046386719', 'YUY', 'CYUY', 'base.jpg', 0, 988, 0),
(150, 'La Ronge Airport', 'La Ronge', 'Canada', '-105.2620010380000', '55.15140151980000', 'YVC', 'CYVC', 'base.jpg', 0, 1242, 0),
(151, 'Vermilion Airport', 'Vermillion', 'Canada', '-110.8239974980000', '53.35580062870000', 'YVG', 'CYVG', 'base.jpg', 0, 2025, 0),
(152, 'Qikiqtarjuaq Airport', 'Broughton Island', 'Canada', '-64.0314025879000', '67.54579925540000', 'YVM', 'CYVM', 'base.jpg', 0, 21, 0),
(153, 'Val-d\'Or Airport', 'Val D\'or', 'Canada', '-77.7827987671000', '48.05329895020000', 'YVO', 'CYVO', 'base.jpg', 0, 1107, 0),
(154, 'Kuujjuaq Airport', 'Quujjuaq', 'Canada', '-68.4269027709961', '58.09609985351563', 'YVP', 'CYVP', 'base.jpg', 0, 129, 0),
(155, 'Norman Wells Airport', 'Norman Wells', 'Canada', '-126.7979965209961', '65.28160095214844', 'YVQ', 'CYVQ', 'base.jpg', 0, 238, 0),
(156, 'Vancouver International Airport', 'Vancouver', 'Canada', '-123.1839981080000', '49.19390106200000', 'YVR', 'CYVR', 'base.jpg', 0, 14, 0),
(157, 'Buffalo Narrows Airport', 'Buffalo Narrows', 'Canada', '-108.4179992680000', '55.84189987180000', 'YVT', 'CYVT', 'base.jpg', 0, 1423, 0),
(158, 'Wiarton Airport', 'Wiarton', 'Canada', '-81.1072010000000', '44.74580000000000', 'YVV', 'CYVV', 'base.jpg', 0, 729, 0),
(159, 'Petawawa Airport', 'Petawawa', 'Canada', '-77.3191986083984', '45.95220184326172', 'YWA', 'CYWA', 'base.jpg', 0, 427, 0),
(160, 'Winnipeg / James Armstrong Richardson International Airport', 'Winnipeg', 'Canada', '-97.2398986816000', '49.90999984740000', 'YWG', 'CYWG', 'base.jpg', 0, 783, 0),
(161, 'Wabush Airport', 'Wabush', 'Canada', '-66.8644027709961', '52.92190170288086', 'YWK', 'CYWK', 'base.jpg', 0, 1808, 0),
(162, 'Williams Lake Airport', 'Williams Lake', 'Canada', '-122.0540008540000', '52.18310165410000', 'YWL', 'CYWL', 'base.jpg', 0, 3085, 0),
(163, 'Wrigley Airport', 'Wrigley', 'Canada', '-123.4369964599609', '63.20940017700195', 'YWY', 'CYWY', 'base.jpg', 0, 489, 0),
(164, 'Cranbrook/Canadian Rockies International Airport', 'Cranbrook', 'Canada', '-115.7819976806600', '49.61080169677700', 'YXC', 'CYXC', 'base.jpg', 0, 3082, 0),
(165, 'Edmonton City Centre (Blatchford Field) Airport', 'Edmonton', 'Canada', '-113.5210037230000', '53.57249832150000', 'YXD', 'CYXD', 'base.jpg', 0, 2202, 0),
(166, 'Saskatoon John G. Diefenbaker International Airport', 'Saskatoon', 'Canada', '-106.6999969482422', '52.17079925537109', 'YXE', 'CYXE', 'base.jpg', 0, 1653, 0),
(167, 'Medicine Hat Airport', 'Medicine Hat', 'Canada', '-110.7210006713867', '50.01890182495117', 'YXH', 'CYXH', 'base.jpg', 0, 2352, 0),
(168, 'Fort St John Airport', 'Fort Saint John', 'Canada', '-120.7399978637695', '56.23809814453125', 'YXJ', 'CYXJ', 'base.jpg', 0, 2280, 0),
(169, 'Sioux Lookout Airport', 'Sioux Lookout', 'Canada', '-91.9052963256836', '50.11389923095703', 'YXL', 'CYXL', 'base.jpg', 0, 1258, 0),
(170, 'Pangnirtung Airport', 'Pangnirtung', 'Canada', '-65.7136001587000', '66.14499664310000', 'YXP', 'CYXP', 'base.jpg', 0, 75, 0),
(171, 'Earlton (Timiskaming Regional) Airport', 'Earlton', 'Canada', '-79.8473453522000', '47.69740065460000', 'YXR', 'CYXR', 'base.jpg', 0, 800, 0),
(172, 'Prince George Airport', 'Prince George', 'Canada', '-122.6790008540000', '53.88940048220000', 'YXS', 'CYXS', 'base.jpg', 0, 2267, 0),
(173, 'Northwest Regional Airport Terrace-Kitimat', 'Terrace', 'Canada', '-128.5760090000000', '54.46849800000000', 'YXT', 'CYXT', 'base.jpg', 0, 713, 0),
(174, 'London Airport', 'London', 'Canada', '-81.1539000000000', '43.03559900000000', 'YXU', 'CYXU', 'base.jpg', 0, 912, 0),
(175, 'Abbotsford Airport', 'Abbotsford', 'Canada', '-122.3610000610352', '49.02529907226563', 'YXX', 'CYXX', 'base.jpg', 0, 195, 0),
(176, 'Whitehorse / Erik Nielsen International Airport', 'Whitehorse', 'Canada', '-135.0670013430000', '60.70959854130000', 'YXY', 'CYXY', 'base.jpg', 0, 2317, 0),
(177, 'North Bay Airport', 'North Bay', 'Canada', '-79.4227981567383', '46.36360168457031', 'YYB', 'CYYB', 'base.jpg', 0, 1215, 0),
(178, 'Calgary International Airport', 'Calgary', 'Canada', '-114.0199966430000', '51.11389923100000', 'YYC', 'CYYC', 'base.jpg', 0, 3557, 0),
(179, 'Smithers Airport', 'Smithers', 'Canada', '-127.1829986572266', '54.82469940185547', 'YYD', 'CYYD', 'base.jpg', 0, 1712, 0),
(180, 'Fort Nelson Airport', 'Fort Nelson', 'Canada', '-122.5970001220000', '58.83639907840000', 'YYE', 'CYYE', 'base.jpg', 0, 1253, 0),
(181, 'Penticton Airport', 'Penticton', 'Canada', '-119.6019973754883', '49.46310043334961', 'YYF', 'CYYF', 'base.jpg', 0, 1129, 0),
(182, 'Charlottetown Airport', 'Charlottetown', 'Canada', '-63.1211013793945', '46.29000091552734', 'YYG', 'CYYG', 'base.jpg', 0, 160, 0),
(183, 'Taloyoak Airport', 'Spence Bay', 'Canada', '-93.5766983032000', '69.54669952390000', 'YYH', 'CYYH', 'base.jpg', 0, 92, 0),
(184, 'Victoria International Airport', 'Victoria', 'Canada', '-123.4260025020000', '48.64690017700000', 'YYJ', 'CYYJ', 'base.jpg', 0, 63, 0),
(185, 'Lynn Lake Airport', 'Lynn Lake', 'Canada', '-101.0759963989258', '56.86389923095703', 'YYL', 'CYYL', 'base.jpg', 0, 1170, 0),
(186, 'Swift Current Airport', 'Swift Current', 'Canada', '-107.6910018920000', '50.29190063479999', 'YYN', 'CYYN', 'base.jpg', 0, 2680, 0),
(187, 'Churchill Airport', 'Churchill', 'Canada', '-94.0650024414063', '58.73920059204102', 'YYQ', 'CYYQ', 'base.jpg', 0, 94, 0),
(188, 'Goose Bay Airport', 'Goose Bay', 'Canada', '-60.4258003235000', '53.31919860840000', 'YYR', 'CYYR', 'base.jpg', 0, 160, 0),
(189, 'St. John\'s International Airport', 'St. John\'s', 'Canada', '-52.7518997192000', '47.61859893800000', 'YYT', 'CYYT', 'base.jpg', 0, 461, 0),
(190, 'Kapuskasing Airport', 'Kapuskasing', 'Canada', '-82.4674987792969', '49.41389846801758', 'YYU', 'CYYU', 'base.jpg', 0, 743, 0),
(191, 'Armstrong Airport', 'Armstrong', 'Canada', '-88.9096984863281', '50.29029846191406', 'YYW', 'CYYW', 'base.jpg', 0, 1058, 0),
(192, 'Mont Joli Airport', 'Mont Joli', 'Canada', '-68.2080993652344', '48.60860061645508', 'YYY', 'CYYY', 'base.jpg', 0, 172, 0),
(193, 'Lester B. Pearson International Airport', 'Toronto', 'Canada', '-79.6305999756000', '43.67720031740000', 'YYZ', 'CYYZ', 'base.jpg', 0, 569, 0),
(194, 'Downsview Airport', 'Toronto', 'Canada', '-79.4655990600586', '43.74250030517578', 'YZD', 'CYZD', 'base.jpg', 0, 652, 0),
(195, 'Gore Bay Manitoulin Airport', 'Gore Bay', 'Canada', '-82.5678024291992', '45.88529968261719', 'YZE', 'CYZE', 'base.jpg', 0, 635, 0),
(196, 'Yellowknife Airport', 'Yellowknife', 'Canada', '-114.4400024414063', '62.46279907226563', 'YZF', 'CYZF', 'base.jpg', 0, 675, 0),
(197, 'Slave Lake Airport', 'Slave Lake', 'Canada', '-114.7770004270000', '55.29309844970000', 'YZH', 'CYZH', 'base.jpg', 0, 1912, 0),
(198, 'Sandspit Airport', 'Sandspit', 'Canada', '-131.8139953610000', '53.25429916379999', 'YZP', 'CYZP', 'base.jpg', 0, 21, 0),
(199, 'Chris Hadfield Airport', 'Sarnia', 'Canada', '-82.3088989257813', '42.99940109252930', 'YZR', 'CYZR', 'base.jpg', 0, 594, 0),
(200, 'Port Hardy Airport', 'Port Hardy', 'Canada', '-127.3669967651367', '50.68059921264648', 'YZT', 'CYZT', 'base.jpg', 0, 71, 0),
(201, 'Whitecourt Airport', 'Whitecourt', 'Canada', '-115.7870025634766', '54.14390182495117', 'YZU', 'CYZU', 'base.jpg', 0, 2567, 0),
(202, 'Sept-Îles Airport', 'Sept-iles', 'Canada', '-66.2656021118164', '50.22330093383789', 'YZV', 'CYZV', 'base.jpg', 0, 180, 0),
(203, 'Teslin Airport', 'Teslin', 'Canada', '-132.7429962158203', '60.17279815673828', 'YZW', 'CYZW', 'base.jpg', 0, 2313, 0),
(204, 'CFB Greenwood', 'Greenwood', 'Canada', '-64.9169006347656', '44.98440170288086', 'YZX', 'CYZX', 'base.jpg', 0, 92, 0),
(205, 'Faro Airport', 'Faro', 'Canada', '-133.3760070800781', '62.20750045776367', 'ZFA', 'CZFA', 'base.jpg', 0, 2351, 0),
(206, 'Fort Mcpherson Airport', 'Fort Mcpherson', 'Canada', '-134.8609924316406', '67.40750122070312', 'ZFM', 'CZFM', 'base.jpg', 0, 116, 0),
(207, 'Blida Airport', 'Blida', 'Algeria', '2.8141698837280', '36.50360107421875', '\\N', 'DAAB', 'base.jpg', 0, 535, 0),
(208, 'Bou Saada Airport', 'Bou Saada', 'Algeria', '4.2063899040222', '35.33250045776367', '\\N', 'DAAD', 'base.jpg', 0, 1506, 0),
(209, 'Soummam Airport', 'Bejaja', 'Algeria', '5.0699200630200', '36.71200180050000', 'BJA', 'DAAE', 'base.jpg', 0, 20, 0),
(210, 'Houari Boumediene Airport', 'Algier', 'Algeria', '3.2154099941254', '36.69100189208984', 'ALG', 'DAAG', 'base.jpg', 0, 82, 0),
(211, 'Djanet Inedbirene Airport', 'Djanet', 'Algeria', '9.4524402618400', '24.29280090330000', 'DJG', 'DAAJ', 'base.jpg', 0, 3176, 0),
(212, 'Boufarik Airport', 'Boufarik', 'Algeria', '2.8761100000000', '36.54579900000000', 'QFD', 'DAAK', 'base.jpg', 0, 335, 0),
(213, 'Reggane Airport', 'Reggan', 'Algeria', '0.2856470048428', '26.71010017395020', '\\N', 'DAAN', 'base.jpg', 0, 955, 0),
(214, 'Illizi Takhamalt Airport', 'Illizi', 'Algeria', '8.6226501464800', '26.72349929810000', 'VVZ', 'DAAP', 'base.jpg', 0, 1778, 0),
(215, 'Ain Oussera Airport', 'Ain Oussera', 'Algeria', '2.8787100315094', '35.52539825439453', '\\N', 'DAAQ', 'base.jpg', 0, 2132, 0),
(216, 'Aguenar – Hadj Bey Akhamok Airport', 'Tamanrasset', 'Algeria', '5.4510798454300', '22.81150054930000', 'TMR', 'DAAT', 'base.jpg', 0, 4518, 0),
(217, 'Jijel Ferhat Abbas Airport', 'Jijel', 'Algeria', '5.8736100196800', '36.79510116580000', 'GJL', 'DAAV', 'base.jpg', 0, 36, 0),
(218, 'Mecheria Airport', 'Mecheria', 'Algeria', '-0.2423530071970', '33.53590011600000', '\\N', 'DAAY', 'base.jpg', 0, 3855, 0),
(219, 'Relizane Airport', 'Relizane', 'Algeria', '0.6262720227242', '35.75220108032227', '\\N', 'DAAZ', 'base.jpg', 0, 282, 0),
(220, 'Annaba Airport', 'Annaba', 'Algeria', '7.8091697692871', '36.82220077514648', 'AAE', 'DABB', 'base.jpg', 0, 16, 0),
(221, 'Mohamed Boudiaf International Airport', 'Constantine', 'Algeria', '6.6203899383545', '36.27600097656250', 'CZL', 'DABC', 'base.jpg', 0, 2265, 0),
(222, 'Cheikh Larbi Tébessi Airport', 'Tebessa', 'Algeria', '8.1207199096700', '35.43159866330000', 'TEE', 'DABS', 'base.jpg', 0, 2661, 0),
(224, 'Hassi R\'Mel Airport', 'Tilrempt', 'Algeria', '3.3115398883820', '32.93040084838867', 'HRM', 'DAFH', 'base.jpg', 0, 2540, 0),
(225, 'Bou Chekif Airport', 'Tiaret', 'Algeria', '1.4631500244100', '35.34109878540000', 'TID', 'DAOB', 'base.jpg', 0, 3245, 0),
(226, 'Bou Sfer Airport', 'Bou Sfer', 'Algeria', '-0.8053889870644', '35.73540115356445', '\\N', 'DAOE', 'base.jpg', 0, 187, 0),
(227, 'Tindouf Airport', 'Tindouf', 'Algeria', '-8.1670999527000', '27.70039939880000', 'TIN', 'DAOF', 'base.jpg', 0, 1453, 0),
(228, 'Ech Cheliff Airport', 'Ech-cheliff', 'Algeria', '1.3317699432400', '36.21269989010000', 'QAS', 'DAOI', 'base.jpg', 0, 463, 0),
(229, 'Tafaraoui Airport', 'Oran', 'Algeria', '-0.5322780013084', '35.54240036010742', 'TAF', 'DAOL', 'base.jpg', 0, 367, 0),
(230, 'Zenata – Messali El Hadj Airport', 'Tlemcen', 'Algeria', '-1.4500000476800', '35.01670074460000', 'TLM', 'DAON', 'base.jpg', 0, 814, 0),
(231, 'Es Senia Airport', 'Oran', 'Algeria', '-0.6211829781530', '35.62390136720000', 'ORN', 'DAOO', 'base.jpg', 0, 295, 0),
(232, 'Sidi Bel Abbes Airport', 'Sidi Bel Abbes', 'Algeria', '-0.5932750105860', '35.17179870610000', '\\N', 'DAOS', 'base.jpg', 0, 1614, 0),
(233, 'Ghriss Airport', 'Ghriss', 'Algeria', '0.1471419930458', '35.20769882202148', 'MUW', 'DAOV', 'base.jpg', 0, 1686, 0),
(234, 'Touat Cheikh Sidi Mohamed Belkebir Airport', 'Adrar', 'Algeria', '-0.1864140033722', '27.83760070800781', 'AZR', 'DAUA', 'base.jpg', 0, 919, 0),
(235, 'Biskra Airport', 'Biskra', 'Algeria', '5.7382302284200', '34.79330062870000', 'BSK', 'DAUB', 'base.jpg', 0, 289, 0),
(236, 'El Golea Airport', 'El Golea', 'Algeria', '2.8595900535583', '30.57130050659180', 'ELG', 'DAUE', 'base.jpg', 0, 1306, 0),
(237, 'Noumérat - Moufdi Zakaria Airport', 'Ghardaia', 'Algeria', '3.7941100597382', '32.38410186767578', 'GHA', 'DAUG', 'base.jpg', 0, 1512, 0),
(238, 'Oued Irara Airport', 'Hassi Messaoud', 'Algeria', '6.1404399871800', '31.67300033570000', 'HME', 'DAUH', 'base.jpg', 0, 463, 0),
(239, 'In Salah Airport', 'In Salah', 'Algeria', '2.5120201110800', '27.25099945070000', 'INZ', 'DAUI', 'base.jpg', 0, 896, 0),
(240, 'Touggourt Sidi Madhi Airport', 'Touggourt', 'Algeria', '6.0886697769165', '33.06779861450195', 'TGR', 'DAUK', 'base.jpg', 0, 279, 0),
(241, 'Laghouat Airport', 'Laghouat', 'Algeria', '2.9283399581900', '33.76440048220000', 'LOO', 'DAUL', 'base.jpg', 0, 2510, 0),
(242, 'Timimoun Airport', 'Timimoun', 'Algeria', '0.2760330140590', '29.23710060120000', 'TMX', 'DAUT', 'base.jpg', 0, 1027, 0),
(243, 'Ain el Beida Airport', 'Ouargla', 'Algeria', '5.4127798080444', '31.91720008850098', 'OGX', 'DAUU', 'base.jpg', 0, 492, 0),
(244, 'In Aménas Airport', 'Zarzaitine', 'Algeria', '9.6429100036600', '28.05150032040000', 'IAM', 'DAUZ', 'base.jpg', 0, 1847, 0),
(245, 'Cadjehoun Airport', 'Cotonou', 'Benin', '2.3843500614166', '6.35723018646240', 'COO', 'DBBB', 'base.jpg', 0, 19, 0),
(246, 'Ouagadougou Airport', 'Ouagadougou', 'Burkina Faso', '-1.5124200582504', '12.35319995880127', 'OUA', 'DFFD', 'base.jpg', 0, 1037, 0),
(247, 'Bobo Dioulasso Airport', 'Bobo-dioulasso', 'Burkina Faso', '-4.3309698104858', '11.16009998321533', 'BOY', 'DFOO', 'base.jpg', 0, 1511, 0),
(248, 'Kotoka International Airport', 'Accra', 'Ghana', '-0.1667860001326', '5.60518980026245', 'ACC', 'DGAA', 'base.jpg', 0, 205, 0),
(249, 'Tamale Airport', 'Tamale', 'Ghana', '-0.8632140159607', '9.55718994140625', 'TML', 'DGLE', 'base.jpg', 0, 553, 0),
(250, 'Wa Airport', 'Wa', 'Ghana', '-2.5076899528503', '10.08269977569580', '\\N', 'DGLW', 'base.jpg', 0, 1060, 0),
(251, 'Sunyani Airport', 'Sunyani', 'Ghana', '-2.3287599086761', '7.36183023452759', 'NYI', 'DGSN', 'base.jpg', 0, 1014, 0),
(252, 'Takoradi Airport', 'Takoradi', 'Ghana', '-1.7747600078583', '4.89605998992920', 'TKD', 'DGTK', 'base.jpg', 0, 21, 0),
(253, 'Port Bouet Airport', 'Abidjan', 'Cote d\'Ivoire', '-3.9262900352478', '5.26139020919800', 'ABJ', 'DIAP', 'base.jpg', 0, 21, 0),
(254, 'Bouaké Airport', 'Bouake', 'Cote d\'Ivoire', '-5.0736699104309', '7.73880004882813', 'BYK', 'DIBK', 'base.jpg', 0, 1230, 0),
(255, 'Daloa Airport', 'Daloa', 'Cote d\'Ivoire', '-6.4731898307800', '6.79280996322632', 'DJO', 'DIDL', 'base.jpg', 0, 823, 0),
(256, 'Korhogo Airport', 'Korhogo', 'Cote d\'Ivoire', '-5.5566601753200', '9.38718032837000', 'HGO', 'DIKO', 'base.jpg', 34, 1214, 0),
(257, 'Man Airport', 'Man', 'Cote d\'Ivoire', '-7.5873599052429', '7.27206993103027', 'MJC', 'DIMN', 'base.jpg', 3, 1089, 0),
(258, 'San Pedro Airport', 'San Pedro', 'Cote d\'Ivoire', '-6.6608200073242', '4.74671983718872', 'SPY', 'DISP', 'base.jpg', 12, 26, 2),
(259, 'Yamoussoukro Airport', 'Yamoussoukro', 'Cote d\'Ivoire', '-5.3655800819400', '6.90317010880000', 'ASK', 'DIYO', 'base.jpg', 0, 699, 0),
(260, 'Nnamdi Azikiwe International Airport', 'Abuja', 'Nigeria', '7.2631697654724', '9.00679016113281', 'ABV', 'DNAA', 'base.jpg', 0, 1123, 0),
(261, 'Akure Airport', 'Akure', 'Nigeria', '5.3010101318359', '7.24673986434937', 'AKR', 'DNAK', 'base.jpg', 0, 1100, 0),
(262, 'Benin Airport', 'Benin', 'Nigeria', '5.5995001792908', '6.31697988510132', 'BNI', 'DNBE', 'base.jpg', 0, 258, 0),
(263, 'Margaret Ekpo International Airport', 'Calabar', 'Nigeria', '8.3472003936768', '4.97601985931397', 'CBQ', 'DNCA', 'base.jpg', 0, 210, 0),
(264, 'Akanu Ibiam International Airport', 'Enugu', 'Nigeria', '7.5619602203369', '6.47426986694336', 'ENU', 'DNEN', 'base.jpg', 0, 466, 0),
(265, 'Gusau Airport', 'Gusau', 'Nigeria', '6.6961097717285', '12.17169952392578', 'QUS', 'DNGU', 'base.jpg', 0, 1520, 0),
(266, 'Ibadan Airport', 'Ibadan', 'Nigeria', '3.9783298969269', '7.36246013641357', 'IBA', 'DNIB', 'base.jpg', 0, 725, 0),
(267, 'Ilorin International Airport', 'Ilorin', 'Nigeria', '4.4939198493958', '8.44021034240723', 'ILR', 'DNIL', 'base.jpg', 0, 1126, 0),
(268, 'Yakubu Gowon Airport', 'Jos', 'Nigeria', '8.8690500259399', '9.63982963562012', 'JOS', 'DNJO', 'base.jpg', 0, 4232, 0),
(269, 'Kaduna Airport', 'Kaduna', 'Nigeria', '7.3201098442078', '10.69600009918213', 'KAD', 'DNKA', 'base.jpg', 0, 2073, 0),
(270, 'Mallam Aminu International Airport', 'Kano', 'Nigeria', '8.5246200561523', '12.04759979248047', 'KAN', 'DNKN', 'base.jpg', 0, 1562, 0),
(271, 'Maiduguri International Airport', 'Maiduguri', 'Nigeria', '13.0809001922607', '11.85529994964600', 'MIU', 'DNMA', 'base.jpg', 0, 1099, 0),
(272, 'Makurdi Airport', 'Makurdi', 'Nigeria', '8.6139402389526', '7.70387983322144', 'MDI', 'DNMK', 'base.jpg', 0, 371, 0),
(273, 'Murtala Muhammed International Airport', 'Lagos', 'Nigeria', '3.3211600780487', '6.57737016677856', 'LOS', 'DNMM', 'base.jpg', 0, 135, 0),
(274, 'Minna Airport', 'Minna', 'Nigeria', '6.4622597694397', '9.65217018127441', 'MXJ', 'DNMN', 'base.jpg', 0, 834, 0),
(275, 'Port Harcourt International Airport', 'Port Hartcourt', 'Nigeria', '6.9495902061462', '5.01549005508423', 'PHC', 'DNPO', 'base.jpg', 0, 87, 0),
(276, 'Sadiq Abubakar III International Airport', 'Sokoto', 'Nigeria', '5.2071900367737', '12.91629981994629', 'SKO', 'DNSO', 'base.jpg', 0, 1010, 0),
(277, 'Yola Airport', 'Yola', 'Nigeria', '12.4303998947144', '9.25755023956299', 'YOL', 'DNYO', 'base.jpg', 0, 599, 0),
(278, 'Zaria Airport', 'Zaria', 'Nigeria', '7.6858100891113', '11.13020038604736', 'ZAR', 'DNZA', 'base.jpg', 0, 2170, 0),
(279, 'Maradi Airport', 'Maradi', 'Niger', '7.1267499923706', '13.50249958038330', 'MFQ', 'DRRM', 'base.jpg', 0, 1240, 0),
(280, 'Diori Hamani International Airport', 'Niamey', 'Niger', '2.1836099624634', '13.48149967193604', 'NIM', 'DRRN', 'base.jpg', 0, 732, 0),
(281, 'Tahoua Airport', 'Tahoua', 'Niger', '5.2653598785400', '14.87569999694824', 'THZ', 'DRRT', 'base.jpg', 0, 1266, 0),
(282, 'Mano Dayak International Airport', 'Agadez', 'Niger', '8.0001096725464', '16.96599960327148', 'AJY', 'DRZA', 'base.jpg', 0, 1657, 0),
(283, 'Dirkou Airport', 'Dirkou', 'Niger', '12.8687000274658', '18.96870040893555', '\\N', 'DRZD', 'base.jpg', 0, 1273, 0),
(284, 'Diffa Airport', 'Diffa', 'Niger', '12.6267004013062', '13.37290000915527', '\\N', 'DRZF', 'base.jpg', 0, 994, 0),
(285, 'Zinder Airport', 'Zinder', 'Niger', '8.9837598800659', '13.77900028228760', 'ZND', 'DRZR', 'base.jpg', 0, 1516, 0),
(286, 'Monastir Habib Bourguiba International Airport', 'Monastir', 'Tunisia', '10.7546997070313', '35.75809860229492', 'MIR', 'DTMB', 'base.jpg', 0, 9, 0),
(287, 'Tunis Carthage International Airport', 'Tunis', 'Tunisia', '10.2271995544434', '36.85100173950195', 'TUN', 'DTTA', 'base.jpg', 0, 22, 0),
(288, 'Sidi Ahmed Air Base', 'Bizerte', 'Tunisia', '9.7914495468100', '37.24539947510000', '\\N', 'DTTB', 'base.jpg', 0, 20, 0),
(289, 'Remada Air Base', 'Remada', 'Tunisia', '10.3821001052856', '32.30619812011719', '\\N', 'DTTD', 'base.jpg', 0, 1004, 0),
(290, 'Gafsa Ksar International Airport', 'Gafsa', 'Tunisia', '8.8225002288818', '34.42200088500977', 'GAF', 'DTTF', 'base.jpg', 0, 1060, 0),
(291, 'Gabès Matmata International Airport', 'Gabes', 'Tunisia', '10.1033000946045', '33.87689971923828', 'GAE', 'DTTG', 'base.jpg', 0, 26, 0),
(292, 'Borj El Amri Airport', 'Bordj El Amri', 'Tunisia', '9.9431495666504', '36.72129821777344', '\\N', 'DTTI', 'base.jpg', 0, 110, 0),
(293, 'Djerba Zarzis International Airport', 'Djerba', 'Tunisia', '10.7755002975464', '33.87500000000000', 'DJE', 'DTTJ', 'base.jpg', 0, 19, 0),
(294, 'El Borma Airport', 'El Borma', 'Tunisia', '9.2546195983887', '31.70429992675781', 'EBM', 'DTTR', 'base.jpg', 0, 827, 0),
(295, 'Sfax Thyna International Airport', 'Sfax', 'Tunisia', '10.6909999847412', '34.71799850463867', 'SFA', 'DTTX', 'base.jpg', 0, 85, 0),
(296, 'Tozeur Nefta International Airport', 'Tozeur', 'Tunisia', '8.1105604171753', '33.93970108032227', 'TOE', 'DTTZ', 'base.jpg', 0, 287, 0),
(297, 'Niamtougou International Airport', 'Niatougou', 'Togo', '1.0912499427795', '9.76733016967773', 'LRL', 'DXNG', 'base.jpg', 0, 1515, 0),
(298, 'Lomé-Tokoin Airport', 'Lome', 'Togo', '1.2545100450516', '6.16560983657837', 'LFW', 'DXXX', 'base.jpg', 0, 72, 0),
(299, 'Antwerp International Airport (Deurne)', 'Antwerp', 'Belgium', '4.4602799415600', '51.18939971920000', 'ANR', 'EBAW', 'base.jpg', 0, 39, 0),
(300, 'Beauvechain Air Base', 'Beauvechain', 'Belgium', '4.7683300971985', '50.75859832763672', '\\N', 'EBBE', 'base.jpg', 0, 370, 0),
(301, 'Kleine Brogel Air Base', 'Kleine Brogel', 'Belgium', '5.4700000000000', '51.16830100000000', '\\N', 'EBBL', 'base.jpg', 0, 200, 0),
(302, 'Brussels Airport', 'Brussels', 'Belgium', '4.4844398498500', '50.90140151980000', 'BRU', 'EBBR', 'base.jpg', 0, 184, 0),
(303, 'Jehonville Air Base', 'Bertrix', 'Belgium', '5.2238898277283', '49.89170074462891', '\\N', 'EBBX', 'base.jpg', 0, 1514, 0),
(304, 'Brussels South Charleroi Airport', 'Charleroi', 'Belgium', '4.4538202285800', '50.45920181270000', 'CRL', 'EBCI', 'base.jpg', 0, 614, 0),
(305, 'Chièvres Air Base', 'Chievres', 'Belgium', '3.8310000896454', '50.57580184936523', '\\N', 'EBCV', 'base.jpg', 0, 194, 0),
(306, 'Koksijde Air Base', 'Koksijde', 'Belgium', '2.6527800559998', '51.09030151367188', '\\N', 'EBFN', 'base.jpg', 0, 20, 0),
(307, 'Florennes Air Base', 'Florennes', 'Belgium', '4.6458301544200', '50.24330139160000', '\\N', 'EBFS', 'base.jpg', 0, 935, 0),
(308, 'Wevelgem Airport', 'Kortrijk-vevelgem', 'Belgium', '3.2047200202900', '50.81719970700000', 'QKT', 'EBKT', 'base.jpg', 0, 64, 0),
(309, 'Liège Airport', 'Liege', 'Belgium', '5.4432201385498', '50.63740158081055', 'LGG', 'EBLG', 'base.jpg', 0, 659, 0),
(310, 'Ostend-Bruges International Airport', 'Ostend', 'Belgium', '2.8622200489000', '51.19889831539999', 'OST', 'EBOS', 'base.jpg', 0, 13, 0),
(311, 'Zutendaal Air Base', 'Zutendaal', 'Belgium', '5.5905599594116', '50.94749832153320', '\\N', 'EBSL', 'base.jpg', 0, 312, 0),
(312, 'Limburg Regional Airport', 'Sint-truiden', 'Belgium', '5.2016701698300', '50.79190063479999', '\\N', 'EBST', 'base.jpg', 0, 246, 0),
(313, 'Saint Hubert Air Base', 'St.-hubert', 'Belgium', '5.4408102035522', '50.03440093994141', '\\N', 'EBSU', 'base.jpg', 0, 1930, 0),
(314, 'Ursel Air Base', 'Ursel', 'Belgium', '3.4755599498749', '51.14419937133789', '\\N', 'EBUL', 'base.jpg', 0, 95, 0),
(315, 'Weelde Air Base', 'Weelde', 'Belgium', '4.9601898193359', '51.39479827880859', '\\N', 'EBWE', 'base.jpg', 0, 105, 0),
(316, 'Oostmalle Air Base', 'Zoersel', 'Belgium', '4.7533300000000', '51.26470200000000', '\\N', 'EBZR', 'base.jpg', 0, 53, 0),
(317, 'Bautzen Airport', 'Bautzen', 'Germany', '14.5197219848633', '51.19361114501953', '\\N', 'EDAB', 'base.jpg', 0, 568, 0),
(318, 'Altenburg-Nobitz Airport', 'Altenburg', 'Germany', '12.5063886642456', '50.98194503784180', 'AOC', 'EDAC', 'base.jpg', 0, 640, 0),
(319, 'Dessau Airport', 'Dessau', 'Germany', '12.1909618378000', '51.83169354100000', '\\N', 'EDAD', 'base.jpg', 0, 187, 0),
(320, 'Eisenhüttenstadt Airport', 'Eisenhuettenstadt', 'Germany', '14.5875300000000', '52.19585600000000', '\\N', 'EDAE', 'base.jpg', 0, 144, 0),
(322, 'Großenhain Airport', 'Suhl', 'Germany', '13.5555562973022', '51.30805587768555', '\\N', 'EDAK', 'base.jpg', 0, 417, 0),
(323, 'Merseburg Airport', 'Muehlhausen', 'Germany', '11.9408333000000', '51.36305560000000', '\\N', 'EDAM', 'base.jpg', 0, 341, 0),
(324, 'Halle-Oppin Airport', 'Halle', 'Germany', '12.0538890000000', '51.55222300000000', '\\N', 'EDAQ', 'base.jpg', 0, 348, 0),
(325, 'Riesa-Göhlis Airport', 'Riesa', 'Germany', '13.3561105728000', '51.29360961910000', '\\N', 'EDAU', 'base.jpg', 0, 322, 0),
(326, 'Rechlin-Lärz Airport', 'Rechlin-laerz', 'Germany', '12.7522220612000', '53.30638885500000', '\\N', 'EDAX', 'base.jpg', 0, 220, 0),
(327, 'Strausberg Airport', 'Strausberg', 'Germany', '13.9166669845581', '52.58055496215820', '\\N', 'EDAY', 'base.jpg', 0, 262, 0),
(328, 'Schönhagen Airport', 'Schoenhagen', 'Germany', '13.1563892365000', '52.20360946660000', '\\N', 'EDAZ', 'base.jpg', 0, 131, 0),
(329, 'Barth Airport', 'Barth', 'Germany', '12.7105150000000', '54.33825300000000', 'BBH', 'EDBH', 'base.jpg', 0, 23, 0),
(330, 'Jena-Schöngleina Airport', 'Jena', 'Germany', '11.7144441604614', '50.91527938842773', '\\N', 'EDBJ', 'base.jpg', 0, 1247, 0),
(331, 'Kyritz Airport', 'Kyritz', 'Germany', '12.4252777099609', '52.91888809204102', '\\N', 'EDBK', 'base.jpg', 0, 131, 0),
(332, 'Magdeburg \\City\\ Airport', 'Magdeburg', 'Germany', '11.6263890000000', '52.07361200000000', '\\N', 'EDBM', 'base.jpg', 0, 259, 0),
(333, 'Rothenburg/Görlitz Airport', 'Rothenburg/ol', 'Germany', '14.9499998092651', '51.36333465576172', '\\N', 'EDBR', 'base.jpg', 0, 518, 0),
(334, 'Anklam Airport', 'Anklam', 'Germany', '13.6686105728149', '53.83277893066406', '\\N', 'EDCA', 'base.jpg', 0, 16, 0),
(335, 'Cottbus-Drewitz Airport', 'Cottbus', 'Germany', '14.5319440000000', '51.88944200000000', '\\N', 'EDCD', 'base.jpg', 0, 272, 0),
(336, 'Kamenz Airport', 'Kamenz', 'Germany', '14.1274995803833', '51.29694366455078', '\\N', 'EDCM', 'base.jpg', 0, 495, 0),
(337, 'Berlin-Schönefeld International Airport', 'Berlin', 'Germany', '13.5225000381470', '52.38000106811500', 'SXF', 'EDDB', 'base.jpg', 0, 157, 0),
(338, 'Dresden Airport', 'Dresden', 'Germany', '13.7672004699707', '51.13280105590820', 'DRS', 'EDDC', 'base.jpg', 0, 755, 0),
(339, 'Erfurt Airport', 'Erfurt', 'Germany', '10.9581003189087', '50.97980117797852', 'ERF', 'EDDE', 'base.jpg', 0, 1036, 0),
(340, 'Frankfurt am Main International Airport', 'Frankfurt', 'Germany', '8.5705556000000', '50.03333330000000', 'FRA', 'EDDF', 'base.jpg', 0, 364, 0),
(341, 'Münster Osnabrück Airport', 'Munster', 'Germany', '7.6848301887500', '52.13460159300000', 'FMO', 'EDDG', 'base.jpg', 0, 160, 0),
(342, 'Hamburg Airport', 'Hamburg', 'Germany', '9.9882297515869', '53.63040161132800', 'HAM', 'EDDH', 'base.jpg', 0, 53, 0),
(343, 'Berlin-Tempelhof International Airport', 'Berlin', 'Germany', '13.4039001464844', '52.47299957275391', 'THF', 'EDDI', 'base.jpg', 0, 167, 0),
(344, 'Cologne Bonn Airport', 'Cologne', 'Germany', '7.1427397728000', '50.86589813230000', 'CGN', 'EDDK', 'base.jpg', 0, 302, 0),
(345, 'Düsseldorf International Airport', 'Duesseldorf', 'Germany', '6.7667798995972', '51.28950119018555', 'DUS', 'EDDL', 'base.jpg', 0, 147, 0),
(346, 'Munich International Airport', 'Munich', 'Germany', '11.7861003875730', '48.35380172729500', 'MUC', 'EDDM', 'base.jpg', 0, 1487, 0),
(347, 'Nuremberg Airport', 'Nuernberg', 'Germany', '11.0780556000000', '49.49869900000000', 'NUE', 'EDDN', 'base.jpg', 0, 1046, 0),
(348, 'Leipzig Halle Airport', 'Leipzig', 'Germany', '12.2363889000000', '51.42388890000000', 'LEJ', 'EDDP', 'base.jpg', 0, 465, 0),
(349, 'Saarbrücken Airport', 'Saarbruecken', 'Germany', '7.1095099449200', '49.21459960940000', 'SCN', 'EDDR', 'base.jpg', 0, 1058, 0),
(350, 'Stuttgart Airport', 'Stuttgart', 'Germany', '9.2219600677500', '48.68989944460000', 'STR', 'EDDS', 'base.jpg', 0, 1276, 0),
(351, 'Berlin-Tegel International Airport', 'Berlin', 'Germany', '13.2876996994000', '52.55970001220000', 'TXL', 'EDDT', 'base.jpg', 0, 122, 0),
(352, 'Hannover Airport', 'Hannover', 'Germany', '9.6850795745800', '52.46110153200000', 'HAJ', 'EDDV', 'base.jpg', 0, 183, 0),
(353, 'Bremen Airport', 'Bremen', 'Germany', '8.7866697311400', '53.04750061040000', 'BRE', 'EDDW', 'base.jpg', 0, 14, 0),
(354, 'Frankfurt-Egelsbach Airport', 'Egelsbach', 'Germany', '8.6458330154419', '49.95999908447266', 'QEF', 'EDFE', 'base.jpg', 0, 384, 0),
(355, 'Frankfurt-Hahn Airport', 'Hahn', 'Germany', '7.2638897895800', '49.94869995120001', 'HHN', 'EDFH', 'base.jpg', 0, 1649, 0),
(356, 'Mannheim-City Airport', 'Mannheim', 'Germany', '8.5141668319702', '49.47305679321289', 'MHG', 'EDFM', 'base.jpg', 0, 308, 0),
(357, 'Allendorf/Eder Airport', 'Allendorf', 'Germany', '8.6808328628540', '51.03499984741211', '\\N', 'EDFQ', 'base.jpg', 0, 1158, 0),
(358, 'Worms Airport', 'Worms', 'Germany', '8.3683330000000', '49.60694500000000', '\\N', 'EDFV', 'base.jpg', 0, 295, 0),
(359, 'Mainz-Finthen Airport', 'Mainz', 'Germany', '8.1472220000000', '49.96749900000000', '\\N', 'EDFZ', 'base.jpg', 0, 525, 0),
(360, 'Eisenach-Kindel Airport', 'Eisenach', 'Germany', '10.4797300000000', '50.99160400000000', '\\N', 'EDGE', 'base.jpg', 0, 1112, 0),
(361, 'Siegerland Airport', 'Siegerland', 'Germany', '8.0829696655273', '50.70769882202148', '\\N', 'EDGS', 'base.jpg', 0, 1966, 0),
(362, 'Hamburg-Finkenwerder Airport', 'Hamburg', 'Germany', '9.8355560302734', '53.53527832031250', 'XFW', 'EDHI', 'base.jpg', 0, 23, 0),
(363, 'Kiel-Holtenau Airport', 'Kiel', 'Germany', '10.1452779769897', '54.37944412231445', 'KEL', 'EDHK', 'base.jpg', 0, 102, 0),
(364, 'Lübeck Blankensee Airport', 'Luebeck', 'Germany', '10.7192001343000', '53.80540084840000', 'LBC', 'EDHL', 'base.jpg', 0, 53, 0),
(365, 'Flugplatz Dahlemer Binz', 'Dahlemer Binz', 'Germany', '6.5288891792000', '50.40555572500000', '\\N', 'EDKV', 'base.jpg', 0, 1896, 0),
(366, 'Meinerzhagen Airport', 'Meinerzhagen', 'Germany', '7.5999999046326', '51.09999847412109', '\\N', 'EDKZ', 'base.jpg', 0, 1549, 0),
(367, 'Arnsberg-Menden Airport', 'Arnsberg', 'Germany', '7.8983330726624', '51.48389053344727', 'ZCA', 'EDLA', 'base.jpg', 0, 794, 0),
(368, 'Essen Mulheim Airport', 'Essen', 'Germany', '6.9373297691345', '51.40230178833008', 'ESS', 'EDLE', 'base.jpg', 0, 424, 0),
(369, 'Bielefeld Airport', 'Bielefeld', 'Germany', '8.5444440841700', '51.96472167970000', '\\N', 'EDLI', 'base.jpg', 0, 433, 0),
(370, 'Mönchengladbach Airport', 'Moenchengladbach', 'Germany', '6.5044441223145', '51.23027801513672', 'MGL', 'EDLN', 'base.jpg', 0, 125, 0),
(371, 'Paderborn Lippstadt Airport', 'Paderborn', 'Germany', '8.6163196563700', '51.61410140990000', 'PAD', 'EDLP', 'base.jpg', 0, 699, 0),
(372, 'Stadtlohn-Vreden Airport', 'Stadtlohn', 'Germany', '6.8405561447144', '51.99583435058594', '\\N', 'EDLS', 'base.jpg', 0, 157, 0),
(373, 'Dortmund Airport', 'Dortmund', 'Germany', '7.6122398376500', '51.51829910279999', 'DTM', 'EDLW', 'base.jpg', 0, 425, 0),
(374, 'Augsburg Airport', 'Augsburg', 'Germany', '10.9316670000000', '48.42527800000000', 'AGB', 'EDMA', 'base.jpg', 0, 1516, 0),
(375, 'Biberach a.d. Riß Airport', 'Biberach', 'Germany', '9.7627782821655', '48.11111068725586', '\\N', 'EDMB', 'base.jpg', 0, 1903, 0);
INSERT INTO `aeroport` (`idAeroport`, `nomAeroport`, `villeAeroport`, `paysAeroport`, `longitude`, `latitude`, `codeAITA`, `codeOACI`, `photoBaseAeroport`, `vue`, `altitude`, `noteGlobaleMoyenne`) VALUES
(376, 'Eggenfelden Airport', 'Eggenfelden', 'Germany', '12.7236108779907', '48.39611053466797', '\\N', 'EDME', 'base.jpg', 0, 1342, 0),
(377, 'Mindelheim-Mattsies Airport', 'Mindelheim', 'Germany', '10.5249996185303', '48.10694503784180', '\\N', 'EDMN', 'base.jpg', 0, 1857, 0),
(378, 'Oberpfaffenhofen Airport', 'Oberpfaffenhofen', 'Germany', '11.2831001281738', '48.08140182495117', 'OBF', 'EDMO', 'base.jpg', 0, 1947, 0),
(379, 'Straubing Airport', 'Straubing', 'Germany', '12.5166673660278', '48.90083312988281', 'RBM', 'EDMS', 'base.jpg', 0, 1047, 0),
(380, 'Vilshofen Airport', 'Vilshofen', 'Germany', '13.1955556869507', '48.63499832153320', '\\N', 'EDMV', 'base.jpg', 0, 991, 0),
(381, 'Leutkirch-Unterzeil Airport', 'Leutkirch', 'Germany', '10.0141668319702', '47.85889053344727', '\\N', 'EDNL', 'base.jpg', 0, 2100, 0),
(382, 'Friedrichshafen Airport', 'Friedrichshafen', 'Germany', '9.5114898681600', '47.67129898069999', 'FDH', 'EDNY', 'base.jpg', 0, 1367, 0),
(383, 'Schwerin Parchim Airport', 'Parchim', 'Germany', '11.7834000000000', '53.42699800000000', 'SZW', 'EDOP', 'base.jpg', 0, 166, 0),
(384, 'Stendal-Borstel Airport', 'Stendal', 'Germany', '11.8186111450195', '52.62888717651367', 'ZSN', 'EDOV', 'base.jpg', 0, 184, 0),
(385, 'Aalen-Heidenheim/Elchingen Airport', 'Aalen-heidenheim', 'Germany', '10.2647218704224', '48.77777862548828', '\\N', 'EDPA', 'base.jpg', 0, 1916, 0),
(386, 'Bayreuth Airport', 'Bayreuth', 'Germany', '11.6400003433228', '49.98500061035156', 'BYU', 'EDQD', 'base.jpg', 0, 1601, 0),
(387, 'Burg Feuerstein Airport', 'Burg Feuerstein', 'Germany', '11.1336107254030', '49.79416656494100', '\\N', 'EDQE', 'base.jpg', 0, 1673, 0),
(388, 'Hof-Plauen Airport', 'Hof', 'Germany', '11.8563890457153', '50.28861236572266', 'HOQ', 'EDQM', 'base.jpg', 0, 1959, 0),
(389, 'Haßfurt-Schweinfurt Airport', 'Hassfurt', 'Germany', '10.5294437408447', '50.01805496215820', '\\N', 'EDQT', 'base.jpg', 0, 719, 0),
(390, 'Koblenz-Winningen Airport', 'Koblenz', 'Germany', '7.5286111831665', '50.32555770874023', 'ZNV', 'EDRK', 'base.jpg', 0, 640, 0),
(391, 'Trier-Föhren Airport', 'Trier', 'Germany', '6.7874999046326', '49.86388778686523', 'ZQF', 'EDRT', 'base.jpg', 0, 666, 0),
(392, 'Speyer Airport', 'Speyer', 'Germany', '8.4513893127441', '49.30472183227539', 'ZQC', 'EDRY', 'base.jpg', 0, 312, 0),
(393, 'Zweibrücken Airport', 'Zweibruecken', 'Germany', '7.4005599021912', '49.20940017700195', 'ZQW', 'EDRZ', 'base.jpg', 0, 1132, 0),
(394, 'Donaueschingen-Villingen Airport', 'Donaueschingen', 'Germany', '8.5222215652500', '47.97333145139999', 'ZQL', 'EDTD', 'base.jpg', 0, 2231, 0),
(395, 'Freiburg i. Br. Airport', 'Freiburg', 'Germany', '7.8324999809300', '48.02277755740001', '\\N', 'EDTF', 'base.jpg', 0, 801, 0),
(396, 'Mengen-Hohentengen Airport', 'Mengen', 'Germany', '9.3727779388428', '48.05389022827148', '\\N', 'EDTM', 'base.jpg', 0, 1818, 0),
(397, 'Adolf Würth Airport', 'Schwaebisch Hall', 'Germany', '9.7838888168300', '49.11833190920000', '\\N', 'EDTY', 'base.jpg', 0, 1299, 0),
(398, 'Finsterwalde/Schacksdorf Airport', 'Soest', 'Germany', '13.7436110000000', '51.60749800000000', '\\N', 'EDUS', 'base.jpg', 0, 384, 0),
(399, 'Braunschweig Wolfsburg Airport', 'Braunschweig', 'Germany', '10.5561000000000', '52.31919900000000', 'BWE', 'EDVE', 'base.jpg', 0, 295, 0),
(400, 'Kassel-Calden Airport', 'Kassel', 'Germany', '9.3849670000000', '51.41727300000000', 'KSF', 'EDVK', 'base.jpg', 0, 820, 0),
(401, 'Hildesheim Airport', 'Hildesheim', 'Germany', '9.9463891983032', '52.18138885498047', '\\N', 'EDVM', 'base.jpg', 0, 292, 0),
(402, 'Bremerhaven Airport', 'Bremerhaven', 'Germany', '8.5727780000000', '53.50694300000000', 'BRV', 'EDWB', 'base.jpg', 0, 10, 0),
(403, 'Emden Airport', 'Emden', 'Germany', '7.2274999618530', '53.39110946655273', 'EME', 'EDWE', 'base.jpg', 0, 3, 0),
(404, 'Leer-Papenburg Airport', 'Leer', 'Germany', '7.4416670799255', '53.27194213867188', '\\N', 'EDWF', 'base.jpg', 0, 3, 0),
(405, 'Wilhelmshaven-Mariensiel Airport', 'Wilhelmshaven', 'Germany', '8.0522222518921', '53.50222015380859', 'WVN', 'EDWI', 'base.jpg', 0, 16, 0),
(406, 'Borkum Airport', 'Borkum', 'Germany', '6.7091670036300', '53.59638977050000', 'BMK', 'EDWR', 'base.jpg', 0, 3, 0),
(407, 'Norderney Airport', 'Norderney', 'Germany', '7.2300000190735', '53.70694351196289', 'NRD', 'EDWY', 'base.jpg', 0, 7, 0),
(408, 'Flensburg-Schäferhaus Airport', 'Flensburg', 'Germany', '9.3788890838623', '54.77333450317383', 'FLF', 'EDXF', 'base.jpg', 0, 131, 0),
(409, 'Rendsburg-Schachtholm Airport', 'Rendsburg', 'Germany', '9.5994443893433', '54.22000122070313', '\\N', 'EDXR', 'base.jpg', 0, 23, 0),
(410, 'Westerland Sylt Airport', 'Westerland', 'Germany', '8.3404703140300', '54.91320037840000', 'GWT', 'EDXW', 'base.jpg', 0, 51, 0),
(411, 'Ämari Air Base', 'Armari Air Force Base', 'Estonia', '24.2084999084473', '59.26029968261719', '\\N', 'EEEI', 'base.jpg', 0, 65, 0),
(412, 'Kärdla Airport', 'Kardla', 'Estonia', '22.8306999206543', '58.99079895019531', 'KDL', 'EEKA', 'base.jpg', 0, 18, 0),
(413, 'Kuressaare Airport', 'Kuressaare', 'Estonia', '22.5095005035400', '58.22990036010742', 'URE', 'EEKE', 'base.jpg', 0, 14, 0),
(414, 'Pärnu Airport', 'Parnu', 'Estonia', '24.4727993011475', '58.41899871826172', 'EPU', 'EEPU', 'base.jpg', 0, 47, 0),
(415, 'Lennart Meri Tallinn Airport', 'Tallinn-ulemiste International', 'Estonia', '24.8327999115000', '59.41329956049999', 'TLL', 'EETN', 'base.jpg', 0, 131, 0),
(416, 'Tartu Airport', 'Tartu', 'Estonia', '26.6903991699000', '58.30749893190000', 'TAY', 'EETU', 'base.jpg', 0, 219, 0),
(417, 'Enontekio Airport', 'Enontekio', 'Finland', '23.4242992401120', '68.36260223388700', 'ENF', 'EFET', 'base.jpg', 0, 1005, 0),
(418, 'Eura Airport', 'Eura', 'Finland', '22.2014007568359', '61.11610031127930', '\\N', 'EFEU', 'base.jpg', 0, 259, 0),
(419, 'Halli Airport', 'Halli', 'Finland', '24.7866860000000', '61.85603900000000', 'KEV', 'EFHA', 'base.jpg', 0, 479, 0),
(420, 'Helsinki Malmi Airport', 'Helsinki', 'Finland', '25.0428009033203', '60.25460052490234', 'HEM', 'EFHF', 'base.jpg', 0, 57, 0),
(421, 'Helsinki Vantaa Airport', 'Helsinki', 'Finland', '24.9633007049560', '60.31719970703100', 'HEL', 'EFHK', 'base.jpg', 0, 179, 0),
(422, 'Hameenkyro Airport', 'Hameenkyro', 'Finland', '23.0736999511719', '61.68970108032227', '\\N', 'EFHM', 'base.jpg', 0, 449, 0),
(423, 'Hanko Airport', 'Hanko', 'Finland', '23.0835990905762', '59.84889984130859', '\\N', 'EFHN', 'base.jpg', 0, 20, 0),
(424, 'Hyvinkää Airfield', 'Hyvinkaa', 'Finland', '24.8810997009000', '60.65439987180000', 'HYV', 'EFHV', 'base.jpg', 0, 430, 0),
(425, 'Kiikala Airport', 'Kikala', 'Finland', '23.6525001526000', '60.46250152590000', '\\N', 'EFIK', 'base.jpg', 0, 381, 0),
(426, 'Immola Airport', 'Immola', 'Finland', '28.9036998748779', '61.24919891357422', '\\N', 'EFIM', 'base.jpg', 0, 338, 0),
(427, 'Kitee Airport', 'Kitee', 'Finland', '30.0736010000000', '62.16610000000000', '\\N', 'EFIT', 'base.jpg', 0, 364, 0),
(428, 'Ivalo Airport', 'Ivalo', 'Finland', '27.4053001403810', '68.60729980468800', 'IVL', 'EFIV', 'base.jpg', 0, 481, 0),
(429, 'Joensuu Airport', 'Joensuu', 'Finland', '29.6075000762940', '62.66289901733400', 'JOE', 'EFJO', 'base.jpg', 0, 398, 0),
(430, 'Jyvaskyla Airport', 'Jyvaskyla', 'Finland', '25.6783008575440', '62.39950180053700', 'JYV', 'EFJY', 'base.jpg', 0, 459, 0),
(431, 'Kauhava Airport', 'Kauhava', 'Finland', '23.0513990000000', '63.12710200000000', 'KAU', 'EFKA', 'base.jpg', 0, 151, 0),
(432, 'Kemi-Tornio Airport', 'Kemi', 'Finland', '24.5820999145510', '65.77870178222700', 'KEM', 'EFKE', 'base.jpg', 0, 61, 0),
(433, 'Kajaani Airport', 'Kajaani', 'Finland', '27.6923999786380', '64.28549957275400', 'KAJ', 'EFKI', 'base.jpg', 0, 483, 0),
(434, 'Kauhajoki Airport', 'Kauhajoki', 'Finland', '22.3931007385000', '62.46250152590000', '\\N', 'EFKJ', 'base.jpg', 0, 407, 0),
(435, 'Kokkola-Pietarsaari Airport', 'Kruunupyy', 'Finland', '23.1431007385250', '63.72119903564500', 'KOK', 'EFKK', 'base.jpg', 0, 84, 0),
(436, 'Kemijarvi Airport', 'Kemijarvi', 'Finland', '27.1567990000000', '66.71289800000000', '\\N', 'EFKM', 'base.jpg', 0, 692, 0),
(437, 'Kuusamo Airport', 'Kuusamo', 'Finland', '29.2394008636470', '65.98760223388700', 'KAO', 'EFKS', 'base.jpg', 0, 866, 0),
(438, 'Kittilä Airport', 'Kittila', 'Finland', '24.8467998504640', '67.70099639892600', 'KTT', 'EFKT', 'base.jpg', 0, 644, 0),
(439, 'Kuopio Airport', 'Kuopio', 'Finland', '27.7978000640870', '63.00709915161100', 'KUO', 'EFKU', 'base.jpg', 0, 323, 0),
(440, 'Lahti Vesivehmaa Airport', 'Vesivehmaa', 'Finland', '25.6935010000000', '61.14419900000000', '\\N', 'EFLA', 'base.jpg', 0, 502, 0),
(441, 'Lappeenranta Airport', 'Lappeenranta', 'Finland', '28.1447430000000', '61.04460100000000', 'LPP', 'EFLP', 'base.jpg', 0, 349, 0),
(442, 'Mariehamn Airport', 'Mariehamn', 'Finland', '19.8981990814210', '60.12220001220700', 'MHQ', 'EFMA', 'base.jpg', 0, 17, 0),
(443, 'Menkijarvi Airport', 'Menkijarvi', 'Finland', '23.5188999176025', '62.94670104980469', '\\N', 'EFME', 'base.jpg', 0, 331, 0),
(444, 'Mikkeli Airport', 'Mikkeli', 'Finland', '27.2017990000000', '61.68660000000000', 'MIK', 'EFMI', 'base.jpg', 0, 329, 0),
(445, 'Nummela Airport', 'Nummela', 'Finland', '24.2964000702000', '60.33390045170000', '\\N', 'EFNU', 'base.jpg', 0, 367, 0),
(446, 'Oulu Airport', 'Oulu', 'Finland', '25.3546009063720', '64.93009948730500', 'OUL', 'EFOU', 'base.jpg', 0, 47, 0),
(447, 'Piikajarvi Airport', 'Piikajarvi', 'Finland', '22.1933994293213', '61.24560165405273', '\\N', 'EFPI', 'base.jpg', 0, 148, 0),
(448, 'Pori Airport', 'Pori', 'Finland', '21.7999992370610', '61.46170043945300', 'POR', 'EFPO', 'base.jpg', 0, 44, 0),
(449, 'Pudasjärvi Airport', 'Pudasjarvi', 'Finland', '26.9468994141000', '65.40219879150000', '\\N', 'EFPU', 'base.jpg', 0, 397, 0),
(450, 'Pyhäsalmi Airport', 'Pyhasalmi', 'Finland', '25.9263000488000', '63.73189926150000', '\\N', 'EFPY', 'base.jpg', 0, 528, 0),
(451, 'Raahe Pattijoki Airport', 'Pattijoki', 'Finland', '24.6958007812000', '64.68810272220000', '\\N', 'EFRH', 'base.jpg', 0, 118, 0),
(452, 'Rantasalmi Airport', 'Rantasalmi', 'Finland', '28.3565006256000', '62.06549835210000', '\\N', 'EFRN', 'base.jpg', 0, 292, 0),
(453, 'Rovaniemi Airport', 'Rovaniemi', 'Finland', '25.8304004669190', '66.56479644775400', 'RVN', 'EFRO', 'base.jpg', 0, 642, 0),
(454, 'Rayskala Airport', 'Rayskala', 'Finland', '24.1077995300293', '60.74470138549805', '\\N', 'EFRY', 'base.jpg', 0, 407, 0),
(455, 'Savonlinna Airport', 'Savonlinna', 'Finland', '28.9451007843020', '61.94309997558600', 'SVL', 'EFSA', 'base.jpg', 0, 311, 0),
(456, 'Selanpaa Airport', 'Selanpaa', 'Finland', '26.7989006042480', '61.06240081787109', '\\N', 'EFSE', 'base.jpg', 0, 417, 0),
(457, 'Sodankyla Airport', 'Sodankyla', 'Finland', '26.6191005707000', '67.39499664310000', 'SOT', 'EFSO', 'base.jpg', 0, 602, 0),
(458, 'Tampere-Pirkkala Airport', 'Tampere', 'Finland', '23.6044006347660', '61.41410064697300', 'TMP', 'EFTP', 'base.jpg', 0, 390, 0),
(459, 'Teisko Airport', 'Teisko', 'Finland', '24.0270000000000', '61.77330000000000', '\\N', 'EFTS', 'base.jpg', 0, 515, 0),
(460, 'Turku Airport', 'Turku', 'Finland', '22.2628002166750', '60.51409912109400', 'TKU', 'EFTU', 'base.jpg', 0, 161, 0),
(461, 'Utti Air Base', 'Utti', 'Finland', '26.9384002685550', '60.89640045166000', 'QVY', 'EFUT', 'base.jpg', 0, 339, 0),
(462, 'Vaasa Airport', 'Vaasa', 'Finland', '21.7621994018550', '63.05070114135700', 'VAA', 'EFVA', 'base.jpg', 0, 19, 0),
(463, 'Varkaus Airport', 'Varkaus', 'Finland', '27.8686008453370', '62.17110061645500', 'VRK', 'EFVR', 'base.jpg', 0, 286, 0),
(464, 'Ylivieska Airfield', 'Ylivieska-raudaskyla', 'Finland', '24.7252778000000', '64.05472220000000', '\\N', 'EFYL', 'base.jpg', 0, 252, 0),
(465, 'Belfast International Airport', 'Belfast', 'United Kingdom', '-6.2158298492400', '54.65750122070000', 'BFS', 'EGAA', 'base.jpg', 0, 268, 0),
(466, 'St Angelo Airport', 'Enniskillen', 'United Kingdom', '-7.6516699790955', '54.39889907836914', 'ENK', 'EGAB', 'base.jpg', 0, 155, 0),
(467, 'George Best Belfast City Airport', 'Belfast', 'United Kingdom', '-5.8724999427795', '54.61809921264648', 'BHD', 'EGAC', 'base.jpg', 0, 15, 0),
(468, 'City of Derry Airport', 'Londonderry', 'United Kingdom', '-7.1611099243164', '55.04280090332031', 'LDY', 'EGAE', 'base.jpg', 0, 22, 0),
(469, 'Birmingham International Airport', 'Birmingham', 'United Kingdom', '-1.7480299472800', '52.45389938349999', 'BHX', 'EGBB', 'base.jpg', 0, 327, 0),
(470, 'Coventry Airport', 'Coventry', 'United Kingdom', '-1.4797199964500', '52.36970138550000', 'CVT', 'EGBE', 'base.jpg', 0, 267, 0),
(471, 'Leicester Airport', 'Leicester', 'United Kingdom', '-1.0319399833679', '52.60779953002930', '\\N', 'EGBG', 'base.jpg', 0, 469, 0),
(472, 'Gloucestershire Airport', 'Golouchestershire', 'United Kingdom', '-2.1672201156616', '51.89419937133789', 'GLO', 'EGBJ', 'base.jpg', 0, 101, 0),
(474, 'Wolverhampton Halfpenny Green Airport', 'Halfpenny Green', 'United Kingdom', '-2.2594399452209', '52.51750183105469', '\\N', 'EGBO', 'base.jpg', 0, 283, 0),
(475, 'Cotswold Airport', 'Pailton', 'United Kingdom', '-2.0569400000000', '51.66809500000000', '\\N', 'EGBP', 'base.jpg', 0, 433, 0),
(476, 'Turweston Airport', 'Turweston', 'United Kingdom', '-1.0955599546400', '52.04079818730000', '\\N', 'EGBT', 'base.jpg', 0, 448, 0),
(477, 'Wellesbourne Mountford Airport', 'Wellesbourne', 'United Kingdom', '-1.6144399642944', '52.19219970703125', '\\N', 'EGBW', 'base.jpg', 0, 159, 0),
(478, 'Manchester Airport', 'Manchester', 'United Kingdom', '-2.2749500274658', '53.35369873046875', 'MAN', 'EGCC', 'base.jpg', 0, 257, 0),
(479, 'Manchester Woodford Airport', 'Woodfort', 'United Kingdom', '-2.1488900000000', '53.33810000000000', '\\N', 'EGCD', 'base.jpg', 0, 295, 0),
(480, 'Royal Marines Base Chivenor Airport', 'Chivenor', 'United Kingdom', '-4.1503400802612', '51.08720016479492', '\\N', 'EGDC', 'base.jpg', 0, 27, 0),
(481, 'Newquay Cornwall Airport', 'Newquai', 'United Kingdom', '-4.9954099655151', '50.44060134887695', 'NQY', 'EGHQ', 'base.jpg', 0, 390, 0),
(482, 'RAF Lyneham', 'Lyneham', 'United Kingdom', '-1.9934300000000', '51.50510000000000', 'LYE', 'EGDL', 'base.jpg', 0, 513, 0),
(483, 'MoD Boscombe Down Airport', 'Boscombe Down', 'United Kingdom', '-1.7474100589752', '51.15219879150391', '\\N', 'EGDM', 'base.jpg', 0, 407, 0),
(484, 'RNAS Culdrose', 'Culdrose', 'United Kingdom', '-5.2557101249695', '50.08610153198242', '\\N', 'EGDR', 'base.jpg', 0, 267, 0),
(485, 'MOD St. Athan', 'St. Athan', 'United Kingdom', '-3.4357500076294', '51.40480041503906', '\\N', 'EGDX', 'base.jpg', 0, 163, 0),
(486, 'RNAS Yeovilton', 'Yeovilton', 'United Kingdom', '-2.6388199329376', '51.00939941406250', 'YEO', 'EGDY', 'base.jpg', 0, 75, 0),
(487, 'Haverfordwest Airport', 'Haverfordwest', 'United Kingdom', '-4.9611101150513', '51.83309936523438', '\\N', 'EGFE', 'base.jpg', 0, 159, 0),
(488, 'Cardiff International Airport', 'Cardiff', 'United Kingdom', '-3.3433299064636', '51.39670181274414', 'CWL', 'EGFF', 'base.jpg', 0, 220, 0),
(489, 'Swansea Airport', 'Swansea', 'United Kingdom', '-4.0678300857544', '51.60530090332031', 'SWS', 'EGFH', 'base.jpg', 0, 299, 0),
(490, 'Bristol Airport', 'Bristol', 'United Kingdom', '-2.7190900000000', '51.38270200000000', 'BRS', 'EGGD', 'base.jpg', 0, 622, 0),
(491, 'Liverpool John Lennon Airport', 'Liverpool', 'United Kingdom', '-2.8497200012207', '53.33359909057617', 'LPL', 'EGGP', 'base.jpg', 0, 80, 0),
(492, 'London Luton Airport', 'London', 'United Kingdom', '-0.3683330118656', '51.87469863891602', 'LTN', 'EGGW', 'base.jpg', 0, 526, 0),
(493, 'Plymouth City Airport', 'Plymouth', 'United Kingdom', '-4.1058300000000', '50.42279800000000', 'PLH', 'EGHD', 'base.jpg', 0, 476, 0),
(494, 'Bournemouth Airport', 'Bournemouth', 'United Kingdom', '-1.8424999713898', '50.77999877929688', 'BOH', 'EGHH', 'base.jpg', 0, 38, 0),
(495, 'Southampton Airport', 'Southampton', 'United Kingdom', '-1.3567999601364', '50.95029830932617', 'SOU', 'EGHI', 'base.jpg', 0, 44, 0),
(496, 'Lasham Airport', 'Lasham', 'United Kingdom', '-1.0334999561310', '51.18719863891602', 'QLA', 'EGHL', 'base.jpg', 0, 618, 0),
(497, 'Alderney Airport', 'Alderney', 'Guernsey', '-2.2147200107574', '49.70610046386719', 'ACI', 'EGJA', 'base.jpg', 0, 290, 0),
(498, 'Guernsey Airport', 'Guernsey', 'Guernsey', '-2.6019699573517', '49.43500137329102', 'GCI', 'EGJB', 'base.jpg', 0, 336, 0),
(499, 'Jersey Airport', 'Jersey', 'Jersey', '-2.1955099105835', '49.20790100097656', 'JER', 'EGJJ', 'base.jpg', 0, 277, 0),
(500, 'Shoreham Airport', 'Shoreham By Sea', 'United Kingdom', '-0.2972219884396', '50.83560180664063', 'ESH', 'EGKA', 'base.jpg', 0, 7, 0),
(501, 'London Biggin Hill Airport', 'Biggin Hill', 'United Kingdom', '0.0324999988079', '51.33079910279999', 'BQH', 'EGKB', 'base.jpg', 0, 598, 0),
(502, 'London Gatwick Airport', 'London', 'United Kingdom', '-0.1902779936790', '51.14810180664063', 'LGW', 'EGKK', 'base.jpg', 0, 202, 0),
(503, 'London City Airport', 'London', 'United Kingdom', '0.0552780000000', '51.50529900000000', 'LCY', 'EGLC', 'base.jpg', 0, 19, 0),
(504, 'Farnborough Airport', 'Farnborough', 'United Kingdom', '-0.7763329744340', '51.27579879760000', 'FAB', 'EGLF', 'base.jpg', 0, 238, 0),
(505, 'Chalgrove Airport', 'Chalsgrove', 'United Kingdom', '-1.0808299779892', '51.67610168457031', '\\N', 'EGLJ', 'base.jpg', 0, 240, 0),
(506, 'Blackbushe Airport', 'Blackbushe', 'United Kingdom', '-0.8475000262260', '51.32389831542969', 'BBS', 'EGLK', 'base.jpg', 0, 325, 0),
(507, 'London Heathrow Airport', 'London', 'United Kingdom', '-0.4619410000000', '51.47060000000000', 'LHR', 'EGLL', 'base.jpg', 0, 83, 0),
(508, 'Southend Airport', 'Southend', 'United Kingdom', '0.6955559849739', '51.57139968872070', 'SEN', 'EGMC', 'base.jpg', 0, 49, 0),
(509, 'Lydd Airport', 'Lydd', 'United Kingdom', '0.9391670227051', '50.95610046386719', 'LYX', 'EGMD', 'base.jpg', 0, 13, 0),
(510, 'Kent International Airport', 'Manston', 'United Kingdom', '1.3461100000000', '51.34220100000000', 'MSE', 'EGMH', 'base.jpg', 0, 178, 0),
(511, 'Brough Airport', 'Brough', 'United Kingdom', '-0.5663330000000', '53.71970000000000', '\\N', 'EGNB', 'base.jpg', 0, 12, 0),
(512, 'Carlisle Airport', 'Carlisle', 'United Kingdom', '-2.8091700077057', '54.93750000000000', 'CAX', 'EGNC', 'base.jpg', 0, 190, 0),
(513, 'Retford Gamston Airport', 'Repton', 'United Kingdom', '-0.9513890147209', '53.28060150146484', '\\N', 'EGNE', 'base.jpg', 0, 91, 0),
(514, 'Blackpool International Airport', 'Blackpool', 'United Kingdom', '-3.0286099910736', '53.77170181274414', 'BLK', 'EGNH', 'base.jpg', 0, 34, 0),
(515, 'Humberside Airport', 'Humberside', 'United Kingdom', '-0.3508329987526', '53.57440185546875', 'HUY', 'EGNJ', 'base.jpg', 0, 121, 0),
(516, 'Barrow Walney Island Airport', 'Barrow Island', 'United Kingdom', '-3.2675000000000', '54.12861110000000', 'BWF', 'EGNL', 'base.jpg', 0, 173, 0),
(517, 'Leeds Bradford Airport', 'Leeds', 'United Kingdom', '-1.6605700254440', '53.86589813232422', 'LBA', 'EGNM', 'base.jpg', 0, 681, 0),
(518, 'Warton Airport', 'Warton', 'United Kingdom', '-2.8830599784851', '53.74509811401367', '\\N', 'EGNO', 'base.jpg', 0, 55, 0),
(519, 'Hawarden Airport', 'Hawarden', 'United Kingdom', '-2.9777801036835', '53.17810058593750', 'CEG', 'EGNR', 'base.jpg', 0, 45, 0),
(520, 'Isle of Man Airport', 'Isle Of Man', 'Isle of Man', '-4.6238899230957', '54.08330154418945', 'IOM', 'EGNS', 'base.jpg', 0, 52, 0),
(521, 'Newcastle Airport', 'Newcastle', 'United Kingdom', '-1.6916699409485', '55.03749847412109', 'NCL', 'EGNT', 'base.jpg', 0, 266, 0),
(522, 'Durham Tees Valley Airport', 'Teesside', 'United Kingdom', '-1.4294099807739', '54.50920104980469', 'MME', 'EGNV', 'base.jpg', 0, 120, 0),
(523, 'East Midlands Airport', 'East Midlands', 'United Kingdom', '-1.3280600309400', '52.83110046390000', 'EMA', 'EGNX', 'base.jpg', 0, 306, 0),
(524, 'Llanbedr Airport', 'Llanbedr', 'United Kingdom', '-4.1235799789429', '52.81169891357400', '\\N', 'EGOD', 'base.jpg', 0, 30, 0),
(525, 'RAF Ternhill', 'Ternhill', 'United Kingdom', '-2.5335600376129', '52.87120056152344', '\\N', 'EGOE', 'base.jpg', 0, 272, 0),
(526, 'RAF Shawbury', 'Shawbury', 'United Kingdom', '-2.6680400371552', '52.79819869995117', '\\N', 'EGOS', 'base.jpg', 0, 249, 0),
(528, 'RAF Woodvale', 'Woodvale', 'United Kingdom', '-3.0555200576800', '53.58160018920000', '\\N', 'EGOW', 'base.jpg', 0, 37, 0),
(529, 'Kirkwall Airport', 'Kirkwall', 'United Kingdom', '-2.9049999713898', '58.95780181884766', 'KOI', 'EGPA', 'base.jpg', 0, 50, 0),
(530, 'Sumburgh Airport', 'Sumburgh', 'United Kingdom', '-1.2955600023270', '59.87889862060547', 'LSI', 'EGPB', 'base.jpg', 0, 20, 0),
(531, 'Wick Airport', 'Wick', 'United Kingdom', '-3.0930600166321', '58.45890045166016', 'WIC', 'EGPC', 'base.jpg', 0, 126, 0),
(532, 'Aberdeen Dyce Airport', 'Aberdeen', 'United Kingdom', '-2.1977798938751', '57.20190048217773', 'ABZ', 'EGPD', 'base.jpg', 0, 215, 0),
(533, 'Inverness Airport', 'Inverness', 'United Kingdom', '-4.0475001335144', '57.54249954223633', 'INV', 'EGPE', 'base.jpg', 0, 31, 0),
(534, 'Glasgow International Airport', 'Glasgow', 'United Kingdom', '-4.4330601692200', '55.87189865110000', 'GLA', 'EGPF', 'base.jpg', 0, 26, 0),
(535, 'Edinburgh Airport', 'Edinburgh', 'United Kingdom', '-3.3724999427795', '55.95000076293945', 'EDI', 'EGPH', 'base.jpg', 0, 135, 0),
(536, 'Islay Airport', 'Islay', 'United Kingdom', '-6.2566699981689', '55.68190002441406', 'ILY', 'EGPI', 'base.jpg', 0, 56, 0),
(537, 'Glasgow Prestwick Airport', 'Prestwick', 'United Kingdom', '-4.5866699218750', '55.50939941406250', 'PIK', 'EGPK', 'base.jpg', 0, 65, 0),
(538, 'Benbecula Airport', 'Benbecula', 'United Kingdom', '-7.3627800941467', '57.48109817504883', 'BEB', 'EGPL', 'base.jpg', 0, 19, 0),
(539, 'Scatsta Airport', 'Scatsta', 'United Kingdom', '-1.2961100339890', '60.43280029296875', 'SCS', 'EGPM', 'base.jpg', 0, 81, 0),
(540, 'Dundee Airport', 'Dundee', 'United Kingdom', '-3.0258300304413', '56.45249938964844', 'DND', 'EGPN', 'base.jpg', 0, 17, 0),
(541, 'Stornoway Airport', 'Stornoway', 'United Kingdom', '-6.3311100006104', '58.21559906005859', 'SYY', 'EGPO', 'base.jpg', 0, 26, 0),
(542, 'Tiree Airport', 'Tiree', 'United Kingdom', '-6.8691701889038', '56.49919891357422', 'TRE', 'EGPU', 'base.jpg', 0, 38, 0),
(543, 'RAF Leuchars', 'Leuchars', 'United Kingdom', '-2.8684399127960', '56.37289810180664', 'ADX', 'EGQL', 'base.jpg', 0, 38, 0),
(544, 'RAF Lossiemouth', 'Lossiemouth', 'United Kingdom', '-3.3391699790955', '57.70520019531250', 'LMO', 'EGQS', 'base.jpg', 0, 42, 0),
(545, 'Cambridge Airport', 'Cambridge', 'United Kingdom', '0.1749999970200', '52.20500183110000', 'CBG', 'EGSC', 'base.jpg', 0, 47, 0),
(546, 'Peterborough Business Airport', 'Peterborough', 'United Kingdom', '-0.2511110007763', '52.46810150146484', '\\N', 'EGSF', 'base.jpg', 0, 26, 0),
(547, 'Norwich International Airport', 'Norwich', 'United Kingdom', '1.2827800512300', '52.67580032350000', 'NWI', 'EGSH', 'base.jpg', 0, 117, 0),
(548, 'London Stansted Airport', 'London', 'United Kingdom', '0.2349999994040', '51.88499832150000', 'STN', 'EGSS', 'base.jpg', 0, 348, 0),
(549, 'North Weald Airport', 'North Weald', 'United Kingdom', '0.1541669964790', '51.72169876100000', '\\N', 'EGSX', 'base.jpg', 0, 321, 0),
(550, 'Sheffield City Heliport', 'Fowlmere', 'United Kingdom', '-1.3884900000000', '53.39429900000000', '\\N', 'EGSY', 'base.jpg', 0, 231, 0),
(551, 'Cranfield Airport', 'Cranfield', 'United Kingdom', '-0.6166669726370', '52.07220077510000', '\\N', 'EGTC', 'base.jpg', 0, 358, 0),
(552, 'Exeter International Airport', 'Exeter', 'United Kingdom', '-3.4138898849487', '50.73440170288086', 'EXT', 'EGTE', 'base.jpg', 0, 102, 0),
(553, 'Bristol Filton Airport', 'Bristol', 'United Kingdom', '-2.5908300876600', '51.51940155030000', 'FZO', 'EGTG', 'base.jpg', 0, 226, 0),
(554, 'Oxford (Kidlington) Airport', 'Oxford', 'United Kingdom', '-1.3200000524500', '51.83689880370000', 'OXF', 'EGTK', 'base.jpg', 0, 270, 0),
(555, 'RAF Benson', 'Benson', 'United Kingdom', '-1.0958299636800', '51.61640167240000', '\\N', 'EGUB', 'base.jpg', 0, 226, 0),
(556, 'RAF Lakenheath', 'Lakenheath', 'United Kingdom', '0.5609999895100', '52.40930175779999', '\\N', 'EGUL', 'base.jpg', 0, 32, 0),
(557, 'RAF Mildenhall', 'Mildenhall', 'United Kingdom', '0.4864059984684', '52.36190032958984', 'MHZ', 'EGUN', 'base.jpg', 0, 33, 0),
(558, 'RAF Wattisham', 'Wattisham', 'United Kingdom', '0.9562640190120', '52.12730026250000', '\\N', 'EGUW', 'base.jpg', 0, 284, 0),
(559, 'RAF Wyton', 'Wyton', 'United Kingdom', '-0.1078329980370', '52.35720062260000', '\\N', 'EGUY', 'base.jpg', 0, 135, 0),
(560, 'RAF Fairford', 'Fairford', 'United Kingdom', '-1.7900300025900', '51.68220138550000', 'FFD', 'EGVA', 'base.jpg', 0, 286, 0),
(561, 'RAF Brize Norton', 'Brize Norton', 'United Kingdom', '-1.5836200000000', '51.75000000000000', 'BZZ', 'EGVN', 'base.jpg', 0, 288, 0),
(562, 'RAF Odiham', 'Odiham', 'United Kingdom', '-0.9428250193600', '51.23410034180000', 'ODH', 'EGVO', 'base.jpg', 0, 405, 0),
(563, 'DCAE Cosford Air Base', 'Cosford', 'United Kingdom', '-2.3055800000000', '52.63999900000000', '\\N', 'EGWC', 'base.jpg', 0, 272, 0),
(564, 'RAF Northolt', 'Northolt', 'United Kingdom', '-0.4181669950490', '51.55300140380000', 'NHT', 'EGWU', 'base.jpg', 0, 124, 0),
(565, 'RAF Coningsby', 'Coningsby', 'United Kingdom', '-0.1660140007730', '53.09299850460000', 'QCY', 'EGXC', 'base.jpg', 0, 25, 0),
(566, 'RAF Dishforth', 'Dishforth', 'United Kingdom', '-1.4202500581700', '54.13719940190000', '\\N', 'EGXD', 'base.jpg', 0, 117, 0),
(567, 'Leeming Airport', 'Leeming', 'United Kingdom', '-1.5354000000000', '54.29240000000000', '\\N', 'EGXE', 'base.jpg', 0, 132, 0),
(568, 'Leeds East Airport', 'Church Fenton', 'United Kingdom', '-1.1955000000000', '53.83430100000000', '\\N', 'EGXG', 'base.jpg', 0, 29, 0),
(569, 'RAF Honington', 'Honington', 'United Kingdom', '0.7729390263557', '52.34260177612305', 'BEQ', 'EGXH', 'base.jpg', 0, 174, 0),
(570, 'RAF Cottesmore', 'Cottesmore', 'United Kingdom', '-0.6487690000000', '52.73569900000000', '\\N', 'EGXJ', 'base.jpg', 0, 461, 0),
(571, 'RAF Scampton', 'Scampton', 'United Kingdom', '-0.5508329868320', '53.30780029300000', '\\N', 'EGXP', 'base.jpg', 0, 202, 0),
(572, 'RAF Wittering', 'Wittering', 'United Kingdom', '-0.4764530062680', '52.61259841920000', '\\N', 'EGXT', 'base.jpg', 0, 273, 0),
(573, 'RAF Linton-On-Ouse', 'Linton-on-ouse', 'United Kingdom', '-1.2527500391000', '54.04890060420000', 'HRT', 'EGXU', 'base.jpg', 0, 53, 0),
(574, 'RAF Waddington', 'Waddington', 'United Kingdom', '-0.5238109827040', '53.16619873050000', 'WTN', 'EGXW', 'base.jpg', 0, 231, 0),
(575, 'RAF Topcliffe', 'Topcliffe', 'United Kingdom', '-1.3820899725000', '54.20550155639999', '\\N', 'EGXZ', 'base.jpg', 0, 92, 0),
(576, 'RAF Cranwell', 'Cranwell', 'United Kingdom', '-0.4832420051100', '53.03030014040000', '\\N', 'EGYD', 'base.jpg', 0, 218, 0),
(577, 'RAF Barkston Heath', 'Barkston Heath', 'United Kingdom', '-0.5616250038150', '52.96220016480000', '\\N', 'EGYE', 'base.jpg', 0, 367, 0),
(578, 'RAF Marham', 'Marham', 'United Kingdom', '0.5506920000000', '52.64839500000000', 'KNF', 'EGYM', 'base.jpg', 0, 75, 0),
(579, 'Mount Pleasant Airport', 'Mount Pleasant', 'Falkland Islands', '-58.4472007751465', '-51.82279968261719', 'MPN', 'EGYP', 'base.jpg', 0, 244, 0),
(580, 'Amsterdam Airport Schiphol', 'Amsterdam', 'Netherlands', '4.7638897895800', '52.30860137940000', 'AMS', 'EHAM', 'base.jpg', 0, -11, 0),
(581, 'Budel Airport', 'Weert', 'Netherlands', '5.6013898849500', '51.25529861450000', '\\N', 'EHBD', 'base.jpg', 0, 114, 0),
(582, 'Maastricht Aachen Airport', 'Maastricht', 'Netherlands', '5.7701401710500', '50.91170120240000', 'MST', 'EHBK', 'base.jpg', 0, 375, 0),
(583, 'Deelen Air Base', 'Deelen', 'Netherlands', '5.8730600000000', '52.06060000000000', '\\N', 'EHDL', 'base.jpg', 0, 158, 0),
(584, 'Drachten Airport', 'Drachten', 'Netherlands', '6.1297202110300', '53.11920166020000', '\\N', 'EHDR', 'base.jpg', 0, 14, 0),
(585, 'Eindhoven Airport', 'Eindhoven', 'Netherlands', '5.3745298385600', '51.45009994510000', 'EIN', 'EHEH', 'base.jpg', 0, 74, 0),
(586, 'Eelde Airport', 'Groningen', 'Netherlands', '6.5794401168800', '53.11970138550000', 'GRQ', 'EHGG', 'base.jpg', 0, 17, 0),
(587, 'Gilze Rijen Air Base', 'Gilze-rijen', 'Netherlands', '4.9318299293518', '51.56740188598633', '\\N', 'EHGR', 'base.jpg', 0, 49, 0),
(588, 'De Kooy Airport', 'De Kooy', 'Netherlands', '4.7806200981140', '52.92340087890625', 'DHR', 'EHKD', 'base.jpg', 0, 3, 0),
(589, 'Lelystad Airport', 'Lelystad', 'Netherlands', '5.5272197723389', '52.46030044555664', 'LEY', 'EHLE', 'base.jpg', 0, -13, 0),
(590, 'Leeuwarden Air Base', 'Leeuwarden', 'Netherlands', '5.7605600357056', '53.22859954833984', 'LWR', 'EHLW', 'base.jpg', 0, 3, 0),
(591, 'Rotterdam The Hague Airport', 'Rotterdam', 'Netherlands', '4.4372200000000', '51.95690200000000', 'RTM', 'EHRD', 'base.jpg', 0, -15, 0),
(592, 'Soesterberg Air Base', 'Soesterberg', 'Netherlands', '5.2761898040800', '52.12730026250000', 'UTC', 'EHSB', 'base.jpg', 0, 66, 0),
(593, 'Twente Airfield', 'Enschede', 'Netherlands', '6.8891667000000', '52.27583330000000', 'ENS', 'EHTW', 'base.jpg', 0, 114, 0),
(594, 'Valkenburg Naval Air Base', 'Valkenburg', 'Netherlands', '4.4179401397700', '52.16609954830000', 'LID', 'EHVB', 'base.jpg', 0, 1, 0),
(595, 'Woensdrecht Air Base', 'Woensdrecht', 'Netherlands', '4.3420300000000', '51.44910000000000', 'WOE', 'EHWO', 'base.jpg', 0, 63, 0),
(596, 'Cork Airport', 'Cork', 'Ireland', '-8.4911098480225', '51.84130096435547', 'ORK', 'EICK', 'base.jpg', 0, 502, 0),
(597, 'Galway Airport', 'Galway', 'Ireland', '-8.9415903091431', '53.30020141601563', 'GWY', 'EICM', 'base.jpg', 0, 81, 0),
(599, 'Dublin Airport', 'Dublin', 'Ireland', '-6.2700700759888', '53.42129898071289', 'DUB', 'EIDW', 'base.jpg', 0, 242, 0),
(600, 'Ireland West Knock Airport', 'Connaught', 'Ireland', '-8.8184900283813', '53.91030120849609', 'NOC', 'EIKN', 'base.jpg', 0, 665, 0),
(601, 'Kerry Airport', 'Kerry', 'Ireland', '-9.5237798690796', '52.18090057373047', 'KIR', 'EIKY', 'base.jpg', 0, 112, 0),
(602, 'Casement Air Base', 'Casement', 'Ireland', '-6.4513301849400', '53.30170059200000', '\\N', 'EIME', 'base.jpg', 0, 319, 0),
(603, 'Shannon Airport', 'Shannon', 'Ireland', '-8.9248199462891', '52.70199966430700', 'SNN', 'EINN', 'base.jpg', 0, 46, 0),
(604, 'Sligo Airport', 'Sligo', 'Ireland', '-8.5992097854614', '54.28020095825200', 'SXL', 'EISG', 'base.jpg', 0, 11, 0),
(605, 'Waterford Airport', 'Waterford', 'Ireland', '-7.0869598388672', '52.18719863891602', 'WAT', 'EIWF', 'base.jpg', 0, 119, 0),
(607, 'Aarhus Airport', 'Aarhus', 'Denmark', '10.6190004349000', '56.29999923710000', 'AAR', 'EKAH', 'base.jpg', 0, 82, 0),
(608, 'Billund Airport', 'Billund', 'Denmark', '9.1517801284800', '55.74029922490000', 'BLL', 'EKBI', 'base.jpg', 0, 247, 0),
(609, 'Copenhagen Kastrup Airport', 'Copenhagen', 'Denmark', '12.6560001373290', '55.61790084838900', 'CPH', 'EKCH', 'base.jpg', 0, 17, 0),
(610, 'Esbjerg Airport', 'Esbjerg', 'Denmark', '8.5534000396729', '55.52590179443359', 'EBJ', 'EKEB', 'base.jpg', 0, 97, 0),
(611, 'Grønholt Hillerød Airport', 'Gronholt', 'Denmark', '12.3822002410889', '55.94139862060547', '\\N', 'EKGH', 'base.jpg', 0, 97, 0),
(612, 'Karup Airport', 'Karup', 'Denmark', '9.1246299743652', '56.29750061035156', 'KRP', 'EKKA', 'base.jpg', 0, 170, 0),
(613, 'Læsø Airport', 'Laeso', 'Denmark', '11.0001001358032', '57.27719879150391', '\\N', 'EKLS', 'base.jpg', 0, 25, 0),
(614, 'Lolland Falster Maribo Airport', 'Maribo', 'Denmark', '11.4401000000000', '54.69929900000000', '\\N', 'EKMB', 'base.jpg', 0, 16, 0),
(615, 'Odense Airport', 'Odense', 'Denmark', '10.3309001922607', '55.47669982910156', 'ODE', 'EKOD', 'base.jpg', 0, 56, 0),
(616, 'Kruså-Padborg Airport', 'Krusa-padborg', 'Denmark', '9.2790098190308', '54.87030029296875', '\\N', 'EKPB', 'base.jpg', 0, 88, 0),
(617, 'Copenhagen Roskilde Airport', 'Copenhagen', 'Denmark', '12.1314001083374', '55.58560180664063', 'RKE', 'EKRK', 'base.jpg', 0, 146, 0),
(618, 'Bornholm Airport', 'Ronne', 'Denmark', '14.7595996856689', '55.06330108642578', 'RNN', 'EKRN', 'base.jpg', 0, 52, 0),
(619, 'Sønderborg Airport', 'Soenderborg', 'Denmark', '9.7917299270630', '54.96440124511719', 'SGD', 'EKSB', 'base.jpg', 0, 24, 0),
(621, 'Skrydstrup Air Base', 'Skrydstrup', 'Denmark', '9.2670200000000', '55.22104800000000', 'SKS', 'EKSP', 'base.jpg', 0, 141, 0),
(622, 'Skive Airport', 'Skive', 'Denmark', '9.1729803085327', '56.55020141601563', '\\N', 'EKSV', 'base.jpg', 0, 74, 0),
(623, 'Thisted Airport', 'Thisted', 'Denmark', '8.7052202224731', '57.06880187988281', 'TED', 'EKTS', 'base.jpg', 0, 23, 0),
(624, 'Kolding Vamdrup Airport', 'Kolding', 'Denmark', '9.3309202194200', '55.43629837040000', '\\N', 'EKVD', 'base.jpg', 0, 143, 0),
(625, 'Vagar Airport', 'Vagar', 'Faroe Islands', '-7.2772197723389', '62.06359863281250', 'FAE', 'EKVG', 'base.jpg', 0, 280, 0),
(626, 'Vesthimmerlands Flyveplads', 'Vesthimmerland', 'Denmark', '9.4586100000000', '56.84690100000000', '\\N', 'EKVH', 'base.jpg', 0, 119, 0),
(627, 'Stauning Airport', 'Stauning', 'Denmark', '8.3539104461670', '55.99010086059570', 'STA', 'EKVJ', 'base.jpg', 0, 17, 0),
(628, 'Aalborg Airport', 'Aalborg', 'Denmark', '9.8492431640600', '57.09275891380000', 'AAL', 'EKYT', 'base.jpg', 0, 10, 0),
(629, 'Luxembourg-Findel International Airport', 'Luxemburg', 'Luxembourg', '6.2044444000000', '49.62333330000000', 'LUX', 'ELLX', 'base.jpg', 0, 1234, 0),
(630, 'Ålesund Airport', 'Alesund', 'Norway', '6.1196999549866', '62.56250000000000', 'AES', 'ENAL', 'base.jpg', 0, 69, 0),
(631, 'Andøya Airport', 'Andoya', 'Norway', '16.1441993713380', '69.29250335693400', 'ANX', 'ENAN', 'base.jpg', 0, 43, 0),
(632, 'Alta Airport', 'Alta', 'Norway', '23.3717002868650', '69.97609710693400', 'ALF', 'ENAT', 'base.jpg', 0, 9, 0),
(633, 'Bømoen Airport', 'Voss', 'Norway', '6.5015001296997', '60.63890075683594', '\\N', 'ENBM', 'base.jpg', 0, 300, 0),
(634, 'Brønnøysund Airport', 'Bronnoysund', 'Norway', '12.2174997329710', '65.46109771728500', 'BNN', 'ENBN', 'base.jpg', 0, 25, 0),
(635, 'Bodø Airport', 'Bodo', 'Norway', '14.3653001785278', '67.26920318603516', 'BOO', 'ENBO', 'base.jpg', 0, 42, 0),
(636, 'Bergen Airport Flesland', 'Bergen', 'Norway', '5.2181401250000', '60.29339981000000', 'BGO', 'ENBR', 'base.jpg', 0, 170, 0),
(637, 'Båtsfjord Airport', 'Batsfjord', 'Norway', '29.6914005279540', '70.60050201416000', 'BJF', 'ENBS', 'base.jpg', 0, 490, 0),
(638, 'Kristiansand Airport', 'Kristiansand', 'Norway', '8.0853700637817', '58.20420074462891', 'KRS', 'ENCN', 'base.jpg', 0, 57, 0),
(639, 'Geilo Airport Dagali', 'Geilo', 'Norway', '8.5183496475220', '60.41730117797852', '\\N', 'ENDI', 'base.jpg', 0, 2618, 0),
(640, 'Bardufoss Airport', 'Bardufoss', 'Norway', '18.5403995513920', '69.05580139160200', 'BDU', 'ENDU', 'base.jpg', 0, 252, 0),
(641, 'Harstad/Narvik Airport, Evenes', 'Harstad/Narvik', 'Norway', '16.6781005859380', '68.49130249023400', 'EVE', 'ENEV', 'base.jpg', 0, 84, 0),
(642, 'Leirin Airport', 'Fagernes', 'Norway', '9.2880601882935', '61.01559829711900', 'VDB', 'ENFG', 'base.jpg', 0, 2697, 0),
(643, 'Florø Airport', 'Floro', 'Norway', '5.0247201919556', '61.58359909057600', 'FRO', 'ENFL', 'base.jpg', 0, 37, 0),
(644, 'Oslo Gardermoen Airport', 'Oslo', 'Norway', '11.1003999710080', '60.19390106201200', 'OSL', 'ENGM', 'base.jpg', 0, 681, 0),
(645, 'Haugesund Airport', 'Haugesund', 'Norway', '5.2083601951599', '59.34529876709000', 'HAU', 'ENHD', 'base.jpg', 0, 86, 0),
(646, 'Hasvik Airport', 'Hasvik', 'Norway', '22.1396999359130', '70.48670196533200', 'HAA', 'ENHK', 'base.jpg', 0, 21, 0),
(647, 'Kristiansund Airport (Kvernberget)', 'Kristiansund', 'Norway', '7.8245201110840', '63.11180114746100', 'KSU', 'ENKB', 'base.jpg', 0, 204, 0),
(648, 'Kjeller Airport', 'Kjeller', 'Norway', '11.0361003876000', '59.96929931640000', '\\N', 'ENKJ', 'base.jpg', 0, 354, 0),
(649, 'Kirkenes Airport (Høybuktmoen)', 'Kirkenes', 'Norway', '29.8913002014160', '69.72579956054700', 'KKN', 'ENKR', 'base.jpg', 0, 283, 0),
(650, 'Lista Airport', 'Farsund', 'Norway', '6.6260499954224', '58.09949874877930', 'FAN', 'ENLI', 'base.jpg', 0, 29, 0),
(651, 'Molde Airport', 'Molde', 'Norway', '7.2624998092651', '62.74470138549800', 'MOL', 'ENML', 'base.jpg', 0, 10, 0),
(652, 'Mosjøen Airport (Kjærstad)', 'Mosjoen', 'Norway', '13.2149000167850', '65.78399658203100', 'MJF', 'ENMS', 'base.jpg', 0, 237, 0),
(653, 'Banak Airport', 'Lakselv', 'Norway', '24.9734992980960', '70.06880187988300', 'LKL', 'ENNA', 'base.jpg', 0, 25, 0),
(654, 'Notodden Airport', 'Notodden', 'Norway', '9.2122200000000', '59.56570100000000', 'NTB', 'ENNO', 'base.jpg', 0, 63, 0),
(655, 'Ørland Airport', 'Orland', 'Norway', '9.6040000915527', '63.69889831542969', 'OLA', 'ENOL', 'base.jpg', 0, 28, 0),
(656, 'Røros Airport', 'Roros', 'Norway', '11.3423004150390', '62.57839965820300', 'RRS', 'ENRO', 'base.jpg', 0, 2054, 0),
(657, 'Moss-Rygge Airport', 'Rygge', 'Norway', '10.7854390000000', '59.37881700000000', 'RYG', 'ENRY', 'base.jpg', 0, 174, 0),
(658, 'Svalbard Airport, Longyear', 'Svalbard', 'Norway', '15.4656000137330', '78.24610137939500', 'LYR', 'ENSB', 'base.jpg', 0, 88, 0),
(659, 'Skien Airport', 'Skien', 'Norway', '9.5669403076172', '59.18500137329102', 'SKE', 'ENSN', 'base.jpg', 0, 463, 0),
(660, 'Stord Airport', 'Stord', 'Norway', '5.3408498764038', '59.79190063476563', 'SRP', 'ENSO', 'base.jpg', 0, 160, 0),
(662, 'Sandnessjøen Airport (Stokka)', 'Sandnessjoen', 'Norway', '12.4688997268680', '65.95680236816400', 'SSJ', 'ENST', 'base.jpg', 0, 56, 0),
(663, 'Tromsø Airport', 'Tromso', 'Norway', '18.9188995361328', '69.68329620361328', 'TOS', 'ENTC', 'base.jpg', 0, 31, 0),
(664, 'Sandefjord Airport, Torp', 'Sandefjord', 'Norway', '10.2586002350000', '59.18669891360000', 'TRF', 'ENTO', 'base.jpg', 0, 286, 0),
(665, 'Trondheim Airport Værnes', 'Trondheim', 'Norway', '10.9239998000000', '63.45780180000000', 'TRD', 'ENVA', 'base.jpg', 0, 56, 0),
(666, 'Stavanger Airport Sola', 'Stavanger', 'Norway', '5.6377801895000', '58.87670135400000', 'SVG', 'ENZV', 'base.jpg', 0, 29, 0),
(667, 'Babice Airport', 'Warsaw', 'Poland', '20.9109992980957', '52.26850128173828', '\\N', 'EPBC', 'base.jpg', 0, 352, 0),
(668, 'Gdańsk Lech Wałęsa Airport', 'Gdansk', 'Poland', '18.4661998748779', '54.37760162353516', 'GDN', 'EPGD', 'base.jpg', 0, 489, 0),
(669, 'John Paul II International Airport Kraków-Balice Airport', 'Krakow', 'Poland', '19.7847995758057', '50.07770156860352', 'KRK', 'EPKK', 'base.jpg', 0, 791, 0),
(670, 'Muchowiec Airport', 'Katowice', 'Poland', '19.0342006683350', '50.23809814453125', '\\N', 'EPKM', 'base.jpg', 0, 909, 0),
(671, 'Katowice International Airport', 'Katowice', 'Poland', '19.0800000000000', '50.47430000000000', 'KTW', 'EPKT', 'base.jpg', 0, 995, 0),
(673, 'Mielec Airport', 'Mielec', 'Poland', '21.4620990753174', '50.32229995727539', '\\N', 'EPML', 'base.jpg', 0, 548, 0),
(674, 'Poznań-Ławica Airport', 'Poznan', 'Poland', '16.8262996674000', '52.42100143430000', 'POZ', 'EPPO', 'base.jpg', 0, 308, 0),
(675, 'Rzeszów-Jasionka Airport', 'Rzeszow', 'Poland', '22.0189990997000', '50.11000061040000', 'RZE', 'EPRZ', 'base.jpg', 0, 675, 0),
(676, 'Szczecin-Goleniów \\Solidarność\\ Airport', 'Szczecin', 'Poland', '14.9021997452000', '53.58470153810001', 'SZZ', 'EPSC', 'base.jpg', 0, 154, 0),
(677, 'Redzikowo Air Base', 'Slupsk', 'Poland', '17.1075000762939', '54.47890090942383', 'OSP', 'EPSK', 'base.jpg', 0, 217, 0),
(678, 'Swidwin Military Air Base', 'Shapaja', 'Poland', '15.8262996674000', '53.79059982300000', '\\N', 'EPSN', 'base.jpg', 0, 385, 0),
(679, 'Warsaw Chopin Airport', 'Warsaw', 'Poland', '20.9671001434000', '52.16569900510000', 'WAW', 'EPWA', 'base.jpg', 0, 362, 0),
(680, 'Copernicus Wrocław Airport', 'Wroclaw', 'Poland', '16.8857994080000', '51.10269927980000', 'WRO', 'EPWR', 'base.jpg', 0, 404, 0),
(681, 'Zielona Góra-Babimost Airport', 'Zielona Gora', 'Poland', '15.7986001968000', '52.13850021360000', 'IEG', 'EPZG', 'base.jpg', 0, 194, 0),
(682, 'Malmen Air Base', 'Linkoeping', 'Sweden', '15.5256996154785', '58.40230178833008', '\\N', 'ESCF', 'base.jpg', 0, 308, 0),
(683, 'Bråvalla Air Base', 'Norrkoeping', 'Sweden', '16.1035995483398', '58.61090087890625', '\\N', 'ESCK', 'base.jpg', 0, 90, 0),
(684, 'Uppsala Airport', 'Uppsala', 'Sweden', '17.5886001586914', '59.89730072021484', '\\N', 'ESCM', 'base.jpg', 0, 68, 0),
(685, 'Ronneby Airport', 'Ronneby', 'Sweden', '15.2650003433230', '56.26670074462900', 'RNB', 'ESDF', 'base.jpg', 0, 191, 0),
(686, 'Råda Air Base', 'Rada', 'Sweden', '13.0531997680664', '58.49810028076172', '\\N', 'ESFR', 'base.jpg', 0, 230, 0),
(687, 'Gothenburg-Landvetter Airport', 'Gothenborg', 'Sweden', '12.2798004150390', '57.66279983520500', 'GOT', 'ESGG', 'base.jpg', 0, 506, 0),
(688, 'Jönköping Airport', 'Joenkoeping', 'Sweden', '14.0686998367310', '57.75759887695313', 'JKG', 'ESGJ', 'base.jpg', 0, 741, 0),
(689, 'Falköping Airport', 'Falkoping', 'Sweden', '13.5878000259399', '58.16979980468750', '\\N', 'ESGK', 'base.jpg', 0, 785, 0),
(690, 'Lidköping-Hovby Airport', 'Lidkoping', 'Sweden', '13.1744003295900', '58.46549987793000', 'LDK', 'ESGL', 'base.jpg', 0, 200, 0),
(691, 'Gothenburg City Airport', 'Gothenborg', 'Sweden', '11.8704004287720', '57.77470016479492', 'GSE', 'ESGP', 'base.jpg', 0, 59, 0),
(692, 'Skövde Airport', 'Skovde', 'Sweden', '13.9727001190186', '58.45640182495117', 'KVB', 'ESGR', 'base.jpg', 0, 324, 0),
(693, 'Trollhättan-Vänersborg Airport', 'Trollhattan', 'Sweden', '12.3450002670288', '58.31809997558594', 'THN', 'ESGT', 'base.jpg', 0, 137, 0),
(694, 'Karlsborg Air Base', 'Karlsborg', 'Sweden', '14.5071001052856', '58.51380157470703', '\\N', 'ESIA', 'base.jpg', 0, 308, 0),
(695, 'Såtenäs Air Base', 'Satenas', 'Sweden', '12.7144002914429', '58.42639923095703', '\\N', 'ESIB', 'base.jpg', 0, 181, 0),
(696, 'Barkarby Airport', 'Stockholm', 'Sweden', '17.8821372986000', '59.41447436440000', '\\N', 'ESKB', 'base.jpg', 0, 50, 0),
(697, 'Karlskoga Airport', 'Karlskoga', 'Sweden', '14.4959001541138', '59.34590148925781', 'KSK', 'ESKK', 'base.jpg', 0, 400, 0),
(698, 'Mora Airport', 'Mora', 'Sweden', '14.5114002227783', '60.95790100097656', 'MXX', 'ESKM', 'base.jpg', 0, 634, 0),
(699, 'Stockholm Skavsta Airport', 'Stockholm', 'Sweden', '16.9122009277344', '58.78860092163086', 'NYO', 'ESKN', 'base.jpg', 0, 140, 0),
(700, 'Arvika Airport', 'Arvika', 'Sweden', '12.6393995285034', '59.67589950561523', '\\N', 'ESKV', 'base.jpg', 0, 237, 0),
(701, 'Emmaboda Airfield', 'Emmaboda', 'Sweden', '15.6048000000000', '56.61080200000000', '\\N', 'ESMA', 'base.jpg', 0, 442, 0),
(702, 'Feringe Airport', 'Ljungby', 'Sweden', '13.9216995239000', '56.95029830930000', '\\N', 'ESMG', 'base.jpg', 0, 538, 0),
(703, 'Kristianstad Airport', 'Kristianstad', 'Sweden', '14.0854997634888', '55.92169952392578', 'KID', 'ESMK', 'base.jpg', 0, 76, 0),
(704, 'Landskrona Airport', 'Landskrona', 'Sweden', '12.8699998855591', '55.94599914550781', 'JLD', 'ESML', 'base.jpg', 0, 194, 0),
(705, 'Oskarshamn Airport', 'Oskarshamn', 'Sweden', '16.4979991912840', '57.35049819946300', 'OSK', 'ESMO', 'base.jpg', 0, 96, 0),
(706, 'Anderstorp Airport', 'Anderstorp', 'Sweden', '13.5993995666504', '57.26419830322266', '\\N', 'ESMP', 'base.jpg', 0, 507, 0),
(707, 'Kalmar Airport', 'Kalkmar', 'Sweden', '16.2875995635986', '56.68550109863281', 'KLR', 'ESMQ', 'base.jpg', 0, 17, 0),
(708, 'Malmö Sturup Airport', 'Malmoe', 'Sweden', '13.3761978149000', '55.53630536400000', 'MMX', 'ESMS', 'base.jpg', 0, 236, 0),
(709, 'Halmstad Airport', 'Halmstad', 'Sweden', '12.8201999664307', '56.69110107421875', 'HAD', 'ESMT', 'base.jpg', 0, 101, 0),
(710, 'Hagshult Airport', 'Hagshult', 'Sweden', '14.1372003555000', '57.29219818120000', '\\N', 'ESMV', 'base.jpg', 0, 556, 0),
(711, 'Växjö Kronoberg Airport', 'Vaxjo', 'Sweden', '14.7279996871948', '56.92910003662109', 'VXO', 'ESMX', 'base.jpg', 0, 610, 0),
(712, 'Hallviken Airport', 'Hallviken', 'Sweden', '15.4582996368408', '63.73830032348633', '\\N', 'ESNA', 'base.jpg', 0, 1119, 0),
(713, 'Hedlanda Airport', 'Hede', 'Sweden', '13.7472000122000', '62.40890121459999', '\\N', 'ESNC', 'base.jpg', 0, 1460, 0),
(714, 'Sveg Airport', 'Sveg', 'Sweden', '14.4229001998901', '62.04779815673828', 'EVG', 'ESND', 'base.jpg', 0, 1178, 0),
(715, 'Gällivare Airport', 'Gallivare', 'Sweden', '20.8145999908447', '67.13240051269531', 'GEV', 'ESNG', 'base.jpg', 0, 1027, 0),
(716, 'Hudiksvall Airport', 'Hudiksvall', 'Sweden', '17.0806999207000', '61.76810073850000', 'HUV', 'ESNH', 'base.jpg', 0, 95, 0),
(717, 'Jokkmokk Airport', 'Jokkmokk', 'Sweden', '20.1471996307373', '66.49620056152344', '\\N', 'ESNJ', 'base.jpg', 0, 904, 0),
(718, 'Kramfors Sollefteå Airport', 'Kramfors', 'Sweden', '17.7688999176025', '63.04859924316406', 'KRF', 'ESNK', 'base.jpg', 0, 34, 0),
(719, 'Lycksele Airport', 'Lycksele', 'Sweden', '18.7161998748779', '64.54830169677734', 'LYC', 'ESNL', 'base.jpg', 0, 705, 0),
(720, 'Optand Airport', 'Optand', 'Sweden', '14.8028001785278', '63.12860107421875', '\\N', 'ESNM', 'base.jpg', 0, 1236, 0),
(721, 'Sundsvall-Härnösand Airport', 'Sundsvall', 'Sweden', '17.4438991546631', '62.52809906005859', 'SDL', 'ESNN', 'base.jpg', 0, 16, 0),
(722, 'Örnsköldsvik Airport', 'Ornskoldsvik', 'Sweden', '18.9899997711182', '63.40829849243164', 'OER', 'ESNO', 'base.jpg', 0, 354, 0),
(723, 'Piteå Airport', 'Pitea', 'Sweden', '21.2607994079590', '65.39830017089844', '\\N', 'ESNP', 'base.jpg', 0, 43, 0),
(724, 'Kiruna Airport', 'Kiruna', 'Sweden', '20.3367996215820', '67.82199859619100', 'KRN', 'ESNQ', 'base.jpg', 0, 1508, 0),
(725, 'Orsa Airport', 'Orsa', 'Sweden', '14.7125997543335', '61.18999862670898', '\\N', 'ESNR', 'base.jpg', 0, 683, 0),
(726, 'Skellefteå Airport', 'Skelleftea', 'Sweden', '21.0769004821777', '64.62480163574219', 'SFT', 'ESNS', 'base.jpg', 0, 157, 0),
(727, 'Sättna Airport', 'Sattna', 'Sweden', '17.0028990000000', '62.48140000000000', '\\N', 'ESNT', 'base.jpg', 0, 886, 0),
(728, 'Umeå Airport', 'Umea', 'Sweden', '20.2828006744380', '63.79180145263700', 'UME', 'ESNU', 'base.jpg', 0, 24, 0),
(729, 'Vilhelmina Airport', 'Vilhelmina', 'Sweden', '16.8335990905762', '64.57910156250000', 'VHM', 'ESNV', 'base.jpg', 0, 1140, 0),
(730, 'Arvidsjaur Airport', 'Arvidsjaur', 'Sweden', '19.2819004058838', '65.59030151367188', 'AJR', 'ESNX', 'base.jpg', 0, 1245, 0),
(731, 'Örebro Airport', 'Orebro', 'Sweden', '15.0380001068115', '59.22370147705078', 'ORB', 'ESOE', 'base.jpg', 0, 188, 0),
(733, 'Stockholm Västerås Airport', 'Vasteras', 'Sweden', '16.6336002349854', '59.58940124511719', 'VST', 'ESOW', 'base.jpg', 0, 21, 0),
(734, 'Luleå Airport', 'Lulea', 'Sweden', '22.1219997406010', '65.54380035400400', 'LLA', 'ESPA', 'base.jpg', 0, 65, 0),
(735, 'Vidsel Air Base', 'Vidsel', 'Sweden', '20.1499004364014', '65.87529754638672', '\\N', 'ESPE', 'base.jpg', 0, 597, 0),
(736, 'Arboga Airport', 'Arboga', 'Sweden', '15.9240999221802', '59.38660049438477', '\\N', 'ESQO', 'base.jpg', 0, 33, 0),
(737, 'Stockholm-Arlanda Airport', 'Stockholm', 'Sweden', '17.9186000823970', '59.65190124511700', 'ARN', 'ESSA', 'base.jpg', 0, 137, 0),
(738, 'Stockholm-Bromma Airport', 'Stockholm', 'Sweden', '17.9416999816895', '59.35440063476563', 'BMA', 'ESSB', 'base.jpg', 0, 47, 0),
(739, 'Borlange Airport', 'Borlange', 'Sweden', '15.5151996612549', '60.42200088500977', 'BLE', 'ESSD', 'base.jpg', 0, 503, 0),
(740, 'Hultsfred Airport', 'Hultsfred', 'Sweden', '15.8233003616330', '57.52579879760700', 'HLF', 'ESSF', 'base.jpg', 0, 366, 0),
(741, 'Gävle Sandviken Airport', 'Gavle', 'Sweden', '16.9514007568359', '60.59329986572266', 'GVX', 'ESSK', 'base.jpg', 0, 224, 0),
(742, 'Linköping City Airport', 'Linkoeping', 'Sweden', '15.6805000305000', '58.40620040890000', 'LPI', 'ESSL', 'base.jpg', 0, 172, 0),
(743, 'Norrköping Airport', 'Norrkoeping', 'Sweden', '16.2506008148193', '58.58629989624023', 'NRK', 'ESSP', 'base.jpg', 0, 32, 0),
(745, 'Eskilstuna Airport', 'Eskilstuna', 'Sweden', '16.7084007263184', '59.35110092163086', '\\N', 'ESSU', 'base.jpg', 0, 139, 0),
(746, 'Visby Airport', 'Visby', 'Sweden', '18.3462009429930', '57.66279983520500', 'VBY', 'ESSV', 'base.jpg', 0, 164, 0),
(748, 'Kalixfors Airport', 'Kalixfors', 'Sweden', '20.2572002410889', '67.76480102539062', '\\N', 'ESUK', 'base.jpg', 0, 1549, 0),
(750, 'Spangdahlem Air Base', 'Spangdahlem', 'Germany', '6.6925001144400', '49.97269821170000', 'SPM', 'ETAD', 'base.jpg', 0, 1197, 0),
(751, 'Ramstein Air Base', 'Ramstein', 'Germany', '7.6002798080444', '49.43690109252930', 'RMS', 'ETAR', 'base.jpg', 0, 776, 0),
(753, '[Duplicate] Giebelstadt Army Air Field', 'Giebelstadt', 'Germany', '9.9664897918700', '49.64810180660000', 'GHF', 'ETEU', 'base.jpg', 0, 980, 0),
(754, 'Bückeburg Air Base', 'Brueckeburg', 'Germany', '9.0821700000000', '52.27850000000000', '\\N', 'ETHB', 'base.jpg', 0, 230, 0),
(755, 'Celle Airport', 'Celle', 'Germany', '10.0221004486084', '52.59120178222656', 'ZCN', 'ETHC', 'base.jpg', 0, 129, 0),
(756, 'Rheine Bentlage Air Base', 'Rheine-brentlange', 'Germany', '7.3870000000000', '52.29119900000000', '\\N', 'ETHE', 'base.jpg', 0, 129, 0),
(757, 'Fritzlar Airport', 'Fritzlar', 'Germany', '9.2860000000000', '51.11460000000000', '\\N', 'ETHF', 'base.jpg', 0, 1345, 0),
(758, 'Laupheim Air Base', 'Laupheim', 'Germany', '9.9100200000000', '48.22029900000000', '\\N', 'ETHL', 'base.jpg', 0, 1766, 0),
(759, 'Mendig Airport', 'Mendig', 'Germany', '7.3153300285300', '50.36600112920000', '\\N', 'ETHM', 'base.jpg', 0, 597, 0),
(760, 'Niederstetten Army Air Base', 'Niederstetten', 'Germany', '9.9588890000000', '49.39194500000000', '\\N', 'ETHN', 'base.jpg', 0, 1339, 0),
(761, 'Roth Airport', 'Roth', 'Germany', '11.1001996994019', '49.21749877929688', '\\N', 'ETHR', 'base.jpg', 0, 1268, 0),
(762, 'Fassberg Air Base', 'Fassberg', 'Germany', '10.1858270000000', '52.91939900000000', '\\N', 'ETHS', 'base.jpg', 0, 245, 0),
(763, 'Grafenwohr Army Air Field', 'Grafenwoehr', 'Germany', '11.9401998519897', '49.69869995117188', '\\N', 'ETIC', 'base.jpg', 0, 1363, 0),
(764, 'Hanau Army Air Field', 'Hanau', 'Germany', '8.9615900000000', '50.16920100000000', 'ZNF', 'ETID', 'base.jpg', 0, 368, 0),
(765, 'Hohenfels Army Air Field', 'Hohenfels', 'Germany', '11.8360996246338', '49.21810150146484', '\\N', 'ETIH', 'base.jpg', 0, 1455, 0);
INSERT INTO `aeroport` (`idAeroport`, `nomAeroport`, `villeAeroport`, `paysAeroport`, `longitude`, `latitude`, `codeAITA`, `codeOACI`, `photoBaseAeroport`, `vue`, `altitude`, `noteGlobaleMoyenne`) VALUES
(766, 'Kitzingen Army Air Field', 'Kitzingen', 'Germany', '10.2005996704102', '49.74309921264648', '\\N', 'ETIN', 'base.jpg', 0, 689, 0),
(767, 'Nordholz Naval Airbase', 'Nordholz', 'Germany', '8.6584997177100', '53.76770019530000', '\\N', 'ETMN', 'base.jpg', 0, 74, 0),
(768, 'Diepholz Air Base', 'Diepholz', 'Germany', '8.3422220000000', '52.58555600000000', '\\N', 'ETND', 'base.jpg', 0, 128, 0),
(769, 'Geilenkirchen Air Base', 'Geilenkirchen', 'Germany', '6.0424200000000', '50.96080000000000', 'GKE', 'ETNG', 'base.jpg', 0, 296, 0),
(770, 'Hohn Airport', 'Hohn', 'Germany', '9.5381698608398', '54.31219863891602', '\\N', 'ETNH', 'base.jpg', 0, 39, 0),
(771, 'Jever Air Base', 'Jever', 'Germany', '7.8886700000000', '53.53350100000000', '\\N', 'ETNJ', 'base.jpg', 0, 24, 0),
(772, 'Rostock-Laage Airport', 'Laage', 'Germany', '12.2783002853000', '53.91820144650000', 'RLG', 'ETNL', 'base.jpg', 0, 138, 0),
(773, 'Nörvenich Air Base', 'Noervenich', 'Germany', '6.6581700000000', '50.83120000000000', '\\N', 'ETNN', 'base.jpg', 0, 386, 0),
(774, 'Schleswig Air Base', 'Schleswig', 'Germany', '9.5163300000000', '54.45930100000000', '\\N', 'ETNS', 'base.jpg', 0, 70, 0),
(775, 'Wittmundhafen Airport', 'Wittmundhafen', 'Germany', '7.6673297882080', '53.54779815673828', '\\N', 'ETNT', 'base.jpg', 0, 26, 0),
(777, 'Wunstorf Air Base', 'Wunstorf', 'Germany', '9.4271700000000', '52.45729800000000', '\\N', 'ETNW', 'base.jpg', 0, 187, 0),
(778, 'Vilseck Army Air Field', 'Vilseck', 'Germany', '11.7672004699707', '49.63359832763672', '\\N', 'ETOI', 'base.jpg', 0, 1353, 0),
(779, 'Coleman Army Air Field', 'Coleman', 'Germany', '8.4633903503418', '49.56359863281250', '\\N', 'ETOR', 'base.jpg', 0, 309, 0),
(780, 'Wiesbaden Army Airfield', 'Wiesbaden', 'Germany', '8.3254003524780', '50.04980087280273', '\\N', 'ETOU', 'base.jpg', 0, 461, 0),
(781, 'Landsberg Lech Air Base', 'Landsberg', 'Germany', '10.9060000000000', '48.07059900000000', '\\N', 'ETSA', 'base.jpg', 0, 2044, 0),
(782, 'Büchel Air Base', 'Buechel', 'Germany', '7.0633301734900', '50.17380142210000', '\\N', 'ETSB', 'base.jpg', 0, 1568, 0),
(783, 'Erding Airport', 'Erding', 'Germany', '11.9486999511719', '48.32229995727539', '\\N', 'ETSE', 'base.jpg', 0, 1515, 0),
(784, 'Fürstenfeldbruck Airport', 'Fuerstenfeldbruck', 'Germany', '11.2669439315796', '48.20555496215820', 'FEL', 'ETSF', 'base.jpg', 0, 1703, 0),
(785, 'Holzdorf Air Base', 'Holzdorf', 'Germany', '13.1677000000000', '51.76779900000000', '\\N', 'ETSH', 'base.jpg', 0, 265, 0),
(786, 'Ingolstadt Manching Airport', 'Ingolstadt', 'Germany', '11.5340003967285', '48.71569824218750', 'IGS', 'ETSI', 'base.jpg', 0, 1202, 0),
(787, 'Lechfeld Airport', 'Lechfeld', 'Germany', '10.8612003326416', '48.18550109863281', '\\N', 'ETSL', 'base.jpg', 0, 1822, 0),
(788, 'Neuburg AFB', 'Neuburg', 'Germany', '11.2115000000000', '48.71099900000000', '\\N', 'ETSN', 'base.jpg', 0, 1249, 0),
(789, 'Gütersloh Air Base', 'Guetersloh', 'Germany', '8.3063300000000', '51.92279800000000', 'GUT', 'ETUO', 'base.jpg', 0, 236, 0),
(790, 'Alexander Bay Airport', 'Alexander Bay', 'South Africa', '16.5333003998000', '-28.57500076290000', 'ALJ', 'FAAB', 'base.jpg', 0, 98, 0),
(791, 'Aggeneys Airport', 'Aggeneys', 'South Africa', '18.8138999938965', '-29.28179931640625', 'AGZ', 'FAAG', 'base.jpg', 0, 2648, 0),
(792, 'Brakpan Airport', 'Brakpan', 'South Africa', '28.3017997741699', '-26.23859977722168', '\\N', 'FABB', 'base.jpg', 0, 5300, 0),
(793, 'Bisho Airport', 'Bisho', 'South Africa', '27.2791004181000', '-32.89709854130000', 'BIY', 'FABE', 'base.jpg', 0, 1950, 0),
(794, 'Bram Fischer International Airport', 'Bloemfontein', 'South Africa', '26.3024005890000', '-29.09269905090000', 'BFN', 'FABL', 'base.jpg', 0, 4458, 0),
(795, 'Bethlehem Airport', 'Bethlehem', 'South Africa', '28.3360996246000', '-28.24839973450000', '\\N', 'FABM', 'base.jpg', 0, 5561, 0),
(796, 'Hendrik Potgieter Airport', 'Bothaville', 'South Africa', '26.6291999816895', '-27.36680030822754', '\\N', 'FABO', 'base.jpg', 0, 4236, 0),
(797, 'Cape Town International Airport', 'Cape Town', 'South Africa', '18.6016998291000', '-33.96480178830000', 'CPT', 'FACT', 'base.jpg', 0, 151, 0),
(798, 'Calvinia Airport', 'Calvinia', 'South Africa', '19.7259006500244', '-31.50029945373535', '\\N', 'FACV', 'base.jpg', 0, 3250, 0),
(799, 'King Shaka International Airport', 'Durban', 'South Africa', '31.1197222222000', '-29.61444444440000', 'DUR', 'FALE', 'base.jpg', 0, 295, 0),
(800, 'Ben Schoeman Airport', 'East London', 'South Africa', '27.8258991241000', '-33.03559875490000', 'ELS', 'FAEL', 'base.jpg', 0, 435, 0),
(801, 'Ermelo Airport', 'Ermelo', 'South Africa', '29.9797992706299', '-26.49559974670410', '\\N', 'FAEO', 'base.jpg', 0, 5700, 0),
(802, 'Ficksburg Sentraoes Airport', 'Ficksburg', 'South Africa', '27.9088993072510', '-28.82309913635254', '\\N', 'FAFB', 'base.jpg', 0, 5315, 0),
(803, 'Grand Central Airport', 'Johannesburg', 'South Africa', '28.1401004791000', '-25.98629951480000', 'GCJ', 'FAGC', 'base.jpg', 0, 5325, 0),
(804, 'George Airport', 'George', 'South Africa', '22.3789005280000', '-34.00559997560000', 'GRJ', 'FAGG', 'base.jpg', 0, 648, 0),
(806, 'Graaff Reinet Airport', 'Graaff Reinet', 'South Africa', '24.5414009094238', '-32.19359970092773', '\\N', 'FAGR', 'base.jpg', 0, 2604, 0),
(807, 'Grahamstown Airport', 'Grahamstown', 'South Africa', '26.4981002807617', '-33.28469848632813', '\\N', 'FAGT', 'base.jpg', 0, 2135, 0),
(808, 'Greytown Airport', 'Greytown', 'South Africa', '30.5867004395000', '-29.12199974060000', '\\N', 'FAGY', 'base.jpg', 0, 3531, 0),
(809, 'Harmony Airport', 'Harmony', 'South Africa', '26.8612003326416', '-28.07869911193848', '\\N', 'FAHA', 'base.jpg', 0, 4399, 0),
(810, 'Harrismith Airport', 'Harrismith', 'South Africa', '29.1061992645264', '-28.23509979248047', '\\N', 'FAHR', 'base.jpg', 0, 5585, 0),
(811, 'Hoedspruit Air Force Base Airport', 'Hoedspruit', 'South Africa', '31.0487003326000', '-24.36860084530000', 'HDS', 'FAHS', 'base.jpg', 0, 1743, 0),
(812, 'Gariep Dam Airport', 'Hendrik Verwoerddam', 'South Africa', '25.5282993316650', '-30.56220054626465', '\\N', 'FAHV', 'base.jpg', 0, 4176, 0),
(813, 'OR Tambo International Airport', 'Johannesburg', 'South Africa', '28.2460000000000', '-26.13920000000000', 'JNB', 'FAJS', 'base.jpg', 0, 5558, 0),
(814, 'P C Pelser Airport', 'Klerksdorp', 'South Africa', '26.7180004119873', '-26.87109947204590', '\\N', 'FAKD', 'base.jpg', 0, 4444, 0),
(815, 'Kimberley Airport', 'Kimberley', 'South Africa', '24.7651996613000', '-28.80279922490000', 'KIM', 'FAKM', 'base.jpg', 0, 3950, 0),
(816, 'Krugersdorp Airport', 'Krugersdorp', 'South Africa', '27.7259149551000', '-26.08082591990000', '\\N', 'FAKR', 'base.jpg', 0, 5499, 0),
(817, 'Kroonstad Airport', 'Kroonstad', 'South Africa', '27.3157997131348', '-27.66060066223145', '\\N', 'FAKS', 'base.jpg', 0, 4700, 0),
(818, 'Johan Pienaar Airport', 'Kuruman', 'South Africa', '23.4113998413086', '-27.45669937133789', 'KMH', 'FAKU', 'base.jpg', 0, 4382, 0),
(819, 'Kleinsee Airport', 'Kleinsee', 'South Africa', '17.0939998627000', '-29.68840026860000', 'KLZ', 'FAKZ', 'base.jpg', 0, 270, 0),
(820, 'Lanseria Airport', 'Johannesburg', 'South Africa', '27.9260997772000', '-25.93849945070000', 'HLA', 'FALA', 'base.jpg', 0, 4517, 0),
(821, 'Lichtenburg Airport', 'Lichtenburg', 'South Africa', '26.1846008300781', '-26.17569923400879', '\\N', 'FALI', 'base.jpg', 0, 4875, 0),
(822, 'Makhado Air Force Base Airport', 'Lambertsbaai', 'South Africa', '29.6965007781982', '-23.15990066528320', '\\N', 'FALM', 'base.jpg', 0, 3069, 0),
(823, 'Langebaanweg Airport', 'Langebaanweg', 'South Africa', '18.1602993011000', '-32.96889877320000', '\\N', 'FALW', 'base.jpg', 0, 108, 0),
(824, 'Ladysmith Airport', 'Ladysmith', 'South Africa', '29.7497005463000', '-28.58169937130000', 'LAY', 'FALY', 'base.jpg', 0, 3548, 0),
(825, 'Middelburg Airport', 'Middelburg', 'South Africa', '29.4402008056641', '-25.68479919433594', '\\N', 'FAMB', 'base.jpg', 0, 4886, 0),
(827, 'Margate Airport', 'Margate', 'South Africa', '30.3430004120000', '-30.85740089420000', 'MGH', 'FAMG', 'base.jpg', 0, 495, 0),
(828, 'Marble Hall Airport', 'Marble Hall', 'South Africa', '29.2831001281738', '-24.98909950256348', '\\N', 'FAMI', 'base.jpg', 0, 2980, 0),
(829, 'Majuba Power Station Airport', 'Majuba Power Station', 'South Africa', '29.7784996033000', '-27.07929992680000', '\\N', 'FAMJ', 'base.jpg', 0, 5600, 0),
(831, 'Riverside Airport', 'Malalane', 'South Africa', '31.5767002106000', '-25.43000030520000', '\\N', 'FAMN', 'base.jpg', 0, 1024, 0),
(832, 'Morningside Farm Airport', 'Musina', 'South Africa', '26.9090003967000', '-25.70450019840000', 'MEZ', 'FAMS', 'base.jpg', 0, 4251, 0),
(833, 'Mkuze Airport', 'Mkuze', 'South Africa', '32.0443000793457', '-27.62610054016113', '\\N', 'FAMU', 'base.jpg', 0, 400, 0),
(834, 'Newcastle Airport', 'Newcastle', 'South Africa', '29.9769001007000', '-27.77059936520000', 'NCS', 'FANC', 'base.jpg', 0, 4074, 0),
(835, 'Nylstroom Airfield', 'Nylstroom', 'South Africa', '28.4349002838135', '-24.68610000610352', '\\N', 'FANY', 'base.jpg', 0, 3900, 0),
(836, 'Overberg Airport', 'Overberg', 'South Africa', '20.2506999969000', '-34.55490112300000', '\\N', 'FAOB', 'base.jpg', 0, 52, 0),
(837, 'Oudtshoorn Airport', 'Oudtshoorn', 'South Africa', '22.1889991760000', '-33.60699844360000', 'DUH', 'FAOH', 'base.jpg', 0, 1063, 0),
(838, 'Port Elizabeth Airport', 'Port Elizabeth', 'South Africa', '25.6173000336000', '-33.98490142820000', 'PLZ', 'FAPE', 'base.jpg', 0, 226, 0),
(839, 'Plettenberg Bay Airport', 'Plettenberg Bay', 'South Africa', '23.3287234306000', '-34.08816016750000', '\\N', 'FAPG', 'base.jpg', 0, 465, 0),
(840, 'Hendrik Van Eck Airport', 'Phalaborwa', 'South Africa', '31.1553993225000', '-23.93720054630000', 'PHW', 'FAPH', 'base.jpg', 0, 1432, 0),
(841, 'Pietersburg Municipal Airport', 'Polokwane', 'South Africa', '29.4843997955000', '-23.92609977720000', '\\N', 'FAPI', 'base.jpg', 0, 4354, 0),
(842, 'Port St Johns Airport', 'Port Saint Johns', 'South Africa', '29.5198001861572', '-31.60589981079102', '\\N', 'FAPJ', 'base.jpg', 0, 1227, 0),
(843, 'Pietermaritzburg Airport', 'Pietermaritzburg', 'South Africa', '30.3987007141000', '-29.64900016780000', 'PZB', 'FAPM', 'base.jpg', 0, 2423, 0),
(844, 'Pilanesberg International Airport', 'Pilanesberg', 'South Africa', '27.1734008789000', '-25.33379936220000', 'NTY', 'FAPN', 'base.jpg', 0, 3412, 0),
(845, 'Polokwane International Airport', 'Potgietersrus', 'South Africa', '29.4586150000000', '-23.84526900000000', 'PTG', 'FAPP', 'base.jpg', 0, 4076, 0),
(846, 'Potchefstroom Airport', 'Potchefstroom', 'South Africa', '27.0818996429000', '-26.67099952700000', '\\N', 'FAPS', 'base.jpg', 0, 4520, 0),
(847, 'Parys Airport', 'Parys', 'South Africa', '27.5034008026123', '-26.88929939270020', '\\N', 'FAPY', 'base.jpg', 0, 4740, 0),
(848, 'Queenstown Airport', 'Queenstown', 'South Africa', '26.8822002410889', '-31.92020034790039', 'UTW', 'FAQT', 'base.jpg', 0, 3637, 0),
(849, 'Richards Bay Airport', 'Richard\'s Bay', 'South Africa', '32.0920982361000', '-28.74099922180000', 'RCB', 'FARB', 'base.jpg', 0, 109, 0),
(850, 'Rustenburg Airport', 'Rustenburg', 'South Africa', '27.2710990906000', '-25.64430046080000', '\\N', 'FARG', 'base.jpg', 0, 3700, 0),
(851, 'Robertson Airport', 'Robertson', 'South Africa', '19.9027996063232', '-33.81219863891602', 'ROD', 'FARS', 'base.jpg', 0, 640, 0),
(852, 'Springbok Airport', 'Springbok', 'South Africa', '17.9395999908447', '-29.68930053710938', 'SBU', 'FASB', 'base.jpg', 0, 2690, 0),
(853, 'Secunda Airport', 'Secunda', 'South Africa', '29.1700992584000', '-26.52409935000000', '\\N', 'FASC', 'base.jpg', 0, 5250, 0),
(854, 'Saldanha /Vredenburg Airport', 'Saldanha', 'South Africa', '17.9692993164000', '-32.96409988400000', '\\N', 'FASD', 'base.jpg', 0, 50, 0),
(855, 'Springs Airfield', 'Springs', 'South Africa', '28.3982715607000', '-26.24940047360000', '\\N', 'FASI', 'base.jpg', 0, 5340, 0),
(856, 'Swartkop Air Force Base', 'Swartkop', 'South Africa', '28.1646003723000', '-25.80970001220000', '\\N', 'FASK', 'base.jpg', 0, 4780, 0),
(857, 'Sishen Airport', 'Sishen', 'South Africa', '22.9993000031000', '-27.64859962460000', 'SIS', 'FASS', 'base.jpg', 0, 3848, 0),
(858, 'Hendrik Swellengrebel Airport', 'Swellendam', 'South Africa', '20.4745998382568', '-34.04819869995117', '\\N', 'FASX', 'base.jpg', 0, 407, 0),
(859, 'Skukuza Airport', 'Skukuza', 'South Africa', '31.5886993408000', '-24.96089935300000', 'SZK', 'FASZ', 'base.jpg', 0, 1020, 0),
(860, 'Tommys Field Airport', 'Tommy\'s Field', 'South Africa', '22.9932003021240', '-28.26000022888184', '\\N', 'FATF', 'base.jpg', 0, 4360, 0),
(861, 'New Tempe Airport', 'Bloemfontein', 'South Africa', '26.1576004028320', '-29.03289985656738', '\\N', 'FATP', 'base.jpg', 0, 4547, 0),
(862, 'Tutuka Power Station Airport', 'Tutuka', 'South Africa', '29.3388004303000', '-26.77659988400000', '\\N', 'FATT', 'base.jpg', 0, 5313, 0),
(863, 'Tzaneen Airport', 'Tzaneen', 'South Africa', '30.3292999268000', '-23.82439994810000', 'LTA', 'FATZ', 'base.jpg', 0, 1914, 0),
(864, 'Prince Mangosuthu Buthelezi Airport', 'Ulundi', 'South Africa', '31.4165000916000', '-28.32060050960000', 'ULD', 'FAUL', 'base.jpg', 0, 1720, 0),
(865, 'Pierre Van Ryneveld Airport', 'Upington', 'South Africa', '21.2602005005000', '-28.39909935000000', 'UTN', 'FAUP', 'base.jpg', 0, 2782, 0),
(866, 'K. D. Matanzima Airport', 'Umtata', 'South Africa', '28.6733551025000', '-31.54636318490000', 'UTT', 'FAUT', 'base.jpg', 0, 2400, 0),
(867, 'Vryburg Airport', 'Vryburg', 'South Africa', '24.7287998199000', '-26.98240089420000', 'VRU', 'FAVB', 'base.jpg', 0, 3920, 0),
(868, 'Virginia Airport', 'Durban', 'South Africa', '31.0583992004395', '-29.77059936523438', 'VIR', 'FAVG', 'base.jpg', 0, 20, 0),
(869, 'Vredendal Airport', 'Vredendal', 'South Africa', '18.5447998046875', '-31.64100074768066', '\\N', 'FAVR', 'base.jpg', 0, 330, 0),
(870, 'Vereeniging Airport', 'Vereeniging', 'South Africa', '27.9608001709000', '-26.56640052800000', '\\N', 'FAVV', 'base.jpg', 0, 4846, 0),
(871, 'Wonderboom Airport', 'Pretoria', 'South Africa', '28.2241990000000', '-25.65390000000000', 'PRY', 'FAWB', 'base.jpg', 0, 4095, 0),
(872, 'Witbank Airport', 'Witbank', 'South Africa', '29.1919994354000', '-25.83230018620000', '\\N', 'FAWI', 'base.jpg', 0, 5078, 0),
(873, 'Waterkloof Air Force Base', 'Waterkloof', 'South Africa', '28.2224998474000', '-25.82999992370000', '\\N', 'FAWK', 'base.jpg', 0, 4940, 0),
(874, 'Welkom Airport', 'Welkom', 'South Africa', '26.6633338928000', '-27.99682451110000', 'WEL', 'FAWM', 'base.jpg', 0, 4421, 0),
(875, 'Ysterplaat Air Force Base', 'Ysterplaat', 'South Africa', '18.4983005523682', '-33.90019989013672', '\\N', 'FAYP', 'base.jpg', 0, 52, 0),
(876, 'Zeerust Airport', 'Zeerust', 'South Africa', '26.0422992706299', '-25.59900093078613', '\\N', 'FAZR', 'base.jpg', 0, 4258, 0),
(877, 'Francistown Airport', 'Francistown', 'Botswana', '27.4745006561279', '-21.15959930419922', 'FRW', 'FBFT', 'base.jpg', 0, 3283, 0),
(878, 'Jwaneng Airport', 'Jwaneng', 'Botswana', '24.6909999847412', '-24.60230064392090', 'JWA', 'FBJW', 'base.jpg', 0, 3900, 0),
(879, 'Kasane Airport', 'Kasane', 'Botswana', '25.1623992919922', '-17.83289909362793', 'BBK', 'FBKE', 'base.jpg', 0, 3289, 0),
(880, 'Maun Airport', 'Maun', 'Botswana', '23.4311008453369', '-19.97260093688965', 'MUB', 'FBMN', 'base.jpg', 0, 3093, 0),
(881, 'Sir Seretse Khama International Airport', 'Gaberone', 'Botswana', '25.9181995391846', '-24.55520057678223', 'GBE', 'FBSK', 'base.jpg', 0, 3299, 0),
(882, 'Selebi Phikwe Airport', 'Selebi-phikwe', 'Botswana', '27.8288000000000', '-22.05830000000000', 'PKW', 'FBSP', 'base.jpg', 0, 2925, 0),
(883, 'Maya-Maya Airport', 'Brazzaville', 'Congo (Brazzaville)', '15.2530002593994', '-4.25169992446899', 'BZV', 'FCBB', 'base.jpg', 0, 1048, 0),
(884, 'Owando Airport', 'Owando', 'Congo (Kinshasa)', '15.9500999450684', '-0.53135001659393', 'FTX', 'FCOO', 'base.jpg', 0, 1214, 0),
(885, 'Ouesso Airport', 'Ouesso', 'Congo (Kinshasa)', '16.0379009247000', '1.61599004269000', 'OUE', 'FCOU', 'base.jpg', 0, 1158, 0),
(886, 'Pointe Noire Airport', 'Pointe-noire', 'Congo (Brazzaville)', '11.8865995407105', '-4.81603002548218', 'PNR', 'FCPP', 'base.jpg', 0, 55, 0),
(887, 'Matsapha Airport', 'Manzini', 'Swaziland', '31.3075008392334', '-26.52899932861328', 'MTS', 'FDMS', 'base.jpg', 0, 2075, 0),
(888, 'Bangui M\'Poko International Airport', 'Bangui', 'Central African Republic', '18.5188007354736', '4.39847993850708', 'BGF', 'FEFF', 'base.jpg', 0, 1208, 0),
(889, 'Berbérati Airport', 'Berberati', 'Central African Republic', '15.7863998413086', '4.22158002853394', 'BBT', 'FEFT', 'base.jpg', 0, 1929, 0),
(890, 'Bata Airport', 'Bata', 'Equatorial Guinea', '9.8056802749634', '1.90547001361847', 'BSG', 'FGBT', 'base.jpg', 0, 13, 0),
(891, 'Malabo Airport', 'Malabo', 'Equatorial Guinea', '8.7087202072144', '3.75527000427246', 'SSG', 'FGSL', 'base.jpg', 0, 76, 0),
(892, 'RAF Ascension Island', 'Wide Awake', 'Saint Helena', '-14.3936996459961', '-7.96960020065308', 'ASI', 'FHAW', 'base.jpg', 0, 278, 0),
(893, 'Sir Seewoosagur Ramgoolam International Airport', 'Plaisance', 'Mauritius', '57.6836013793945', '-20.43020057678223', 'MRU', 'FIMP', 'base.jpg', 0, 186, 0),
(894, 'Sir Charles Gaetan Duval Airport', 'Rodriguez Island', 'Mauritius', '63.3610000610352', '-19.75769996643066', 'RRG', 'FIMR', 'base.jpg', 0, 95, 0),
(895, 'Diego Garcia Naval Support Facility', 'Diego Garcia Island', 'British Indian Ocean Territory', '72.4111020000000', '-7.31327000000000', '\\N', 'FJDG', 'base.jpg', 0, 9, 0),
(896, 'Tiko Airport', 'Tiko', 'Cameroon', '9.3605298996000', '4.08919000626000', 'TKC', 'FKKC', 'base.jpg', 0, 151, 0),
(897, 'Douala International Airport', 'Douala', 'Cameroon', '9.7194795608500', '4.00608015060000', 'DLA', 'FKKD', 'base.jpg', 0, 33, 0),
(898, 'Salak Airport', 'Maroua', 'Cameroon', '14.2573995590210', '10.45139980316162', 'MVR', 'FKKL', 'base.jpg', 0, 1390, 0),
(899, 'Foumban Nkounja Airport', 'Foumban', 'Cameroon', '10.7508001327515', '5.63691997528076', 'FOM', 'FKKM', 'base.jpg', 0, 3963, 0),
(900, 'N\'Gaoundéré Airport', 'N\'gaoundere', 'Cameroon', '13.5592002868652', '7.35700988769531', 'NGE', 'FKKN', 'base.jpg', 0, 3655, 0),
(901, 'Garoua International Airport', 'Garoua', 'Cameroon', '13.3701000213623', '9.33588981628418', 'GOU', 'FKKR', 'base.jpg', 0, 794, 0),
(902, 'Bafoussam Airport', 'Bafoussam', 'Cameroon', '10.3545999527000', '5.53692007065000', 'BFX', 'FKKU', 'base.jpg', 0, 4347, 0),
(903, 'Bamenda Airport', 'Bamenda', 'Cameroon', '10.1225996017456', '6.03923988342285', 'BPC', 'FKKV', 'base.jpg', 0, 4065, 0),
(904, 'Yaoundé Airport', 'Yaounde', 'Cameroon', '11.5235004425049', '3.83604001998901', 'YAO', 'FKKY', 'base.jpg', 0, 2464, 0),
(905, 'Kasompe Airport', 'Kasompe', 'Zambia', '27.8938999176030', '-12.57279968261700', '\\N', 'FLKE', 'base.jpg', 0, 4636, 0),
(906, 'Livingstone Airport', 'Livingstone', 'Zambia', '25.8227005004883', '-17.82180023193359', 'LVI', 'FLLI', 'base.jpg', 0, 3302, 0),
(907, 'Kenneth Kaunda International Airport Lusaka', 'Lusaka', 'Zambia', '28.4526004791000', '-15.33080005650000', 'LUN', 'FLLS', 'base.jpg', 0, 3779, 0),
(908, 'Mfuwe Airport', 'Mfuwe', 'Zambia', '31.9365997314453', '-13.25889968872070', 'MFU', 'FLMF', 'base.jpg', 0, 1853, 0),
(909, 'Mongu Airport', 'Mongu', 'Zambia', '23.1623001098633', '-15.25450038909912', '\\N', 'FLMG', 'base.jpg', 0, 3488, 0),
(910, 'Simon Mwansa Kapwepwe International Airport', 'Ndola', 'Zambia', '28.6648998260500', '-12.99810028076200', 'NLA', 'FLND', 'base.jpg', 0, 4167, 0),
(911, 'Southdowns Airport', 'Southdowns', 'Zambia', '28.1499004364014', '-12.90050029754639', 'KIW', 'FLSO', 'base.jpg', 0, 4145, 0),
(912, 'Prince Said Ibrahim International Airport', 'Moroni', 'Comoros', '43.2719000000000', '-11.53370000000000', 'HAH', 'FMCH', 'base.jpg', 0, 93, 0),
(913, 'Mohéli Bandar Es Eslam Airport', 'Moheli', 'Comoros', '43.7663993835449', '-12.29810047149658', 'NWA', 'FMCI', 'base.jpg', 0, 46, 0),
(914, 'Ouani Airport', 'Anjouan', 'Comoros', '44.4303016662598', '-12.13169956207275', 'AJN', 'FMCV', 'base.jpg', 0, 62, 0),
(915, 'Dzaoudzi Pamandzi International Airport', 'Dzaoudzi', 'Mayotte', '45.2811012268066', '-12.80469989776611', 'DZA', 'FMCZ', 'base.jpg', 0, 23, 0),
(916, 'Roland Garros Airport', 'St.-denis', 'Reunion', '55.5102996826172', '-20.88710021972656', 'RUN', 'FMEE', 'base.jpg', 0, 66, 0),
(917, 'Pierrefonds Airport', 'St.-pierre', 'Reunion', '55.4249992370606', '-21.32089996337891', 'ZSE', 'FMEP', 'base.jpg', 0, 59, 0),
(918, 'Ivato Airport', 'Antananarivo', 'Madagascar', '47.4788017273000', '-18.79689979550000', 'TNR', 'FMMI', 'base.jpg', 0, 4198, 0),
(919, 'Miandrivazo Airport', 'Miandrivazo', 'Madagascar', '45.4508018493652', '-19.56279945373535', 'ZVA', 'FMMN', 'base.jpg', 0, 203, 0),
(920, 'Sainte Marie Airport', 'Sainte Marie', 'Madagascar', '49.8157997131348', '-17.09390068054199', 'SMS', 'FMMS', 'base.jpg', 0, 7, 0),
(921, 'Toamasina Airport', 'Toamasina', 'Madagascar', '49.3925018310547', '-18.10950088500977', 'TMM', 'FMMT', 'base.jpg', 0, 22, 0),
(922, 'Morondava Airport', 'Morondava', 'Madagascar', '44.3176002502441', '-20.28470039367676', 'MOQ', 'FMMV', 'base.jpg', 0, 30, 0),
(923, 'Arrachart Airport', 'Antsiranana', 'Madagascar', '49.2916984558106', '-12.34939956665039', 'DIE', 'FMNA', 'base.jpg', 0, 374, 0),
(924, 'Mananara Nord Airport', 'Mananara', 'Madagascar', '49.7737998962402', '-16.16390037536621', 'WMR', 'FMNC', 'base.jpg', 0, 9, 0),
(925, 'Andapa Airport', 'Andapa', 'Madagascar', '49.6206016540527', '-14.65170001983643', 'ZWA', 'FMND', 'base.jpg', 0, 1552, 0),
(926, 'Ambilobe Airport', 'Ambilobe', 'Madagascar', '48.9879989624023', '-13.18840026855469', 'AMB', 'FMNE', 'base.jpg', 0, 72, 0),
(927, 'Antsirabato Airport', 'Antalaha', 'Madagascar', '50.3202018737793', '-14.99940013885498', 'ANM', 'FMNH', 'base.jpg', 0, 20, 0),
(928, 'Analalava Airport', 'Analalava', 'Madagascar', '47.7638015747070', '-14.62969970703125', 'HVA', 'FMNL', 'base.jpg', 0, 345, 0),
(929, 'Amborovy Airport', 'Mahajanga', 'Madagascar', '46.3512325287000', '-15.66684174210000', 'MJN', 'FMNM', 'base.jpg', 0, 87, 0),
(930, 'Fascene Airport', 'Nosy-be', 'Madagascar', '48.3148002625000', '-13.31210041050000', 'NOS', 'FMNN', 'base.jpg', 0, 36, 0),
(931, 'Besalampy Airport', 'Besalampy', 'Madagascar', '44.4824838638000', '-16.74453029650000', 'BPY', 'FMNQ', 'base.jpg', 0, 125, 0),
(932, 'Maroantsetra Airport', 'Maroantsetra', 'Madagascar', '49.6883010864258', '-15.43669986724854', 'WMN', 'FMNR', 'base.jpg', 0, 13, 0),
(933, 'Sambava Airport', 'Sambava', 'Madagascar', '50.1747016906738', '-14.27859973907471', 'SVB', 'FMNS', 'base.jpg', 0, 20, 0),
(934, 'Vohimarina Airport', 'Vohemar', 'Madagascar', '50.0027999877930', '-13.37580013275147', 'VOH', 'FMNV', 'base.jpg', 0, 19, 0),
(935, 'Ambalabe Airport', 'Antsohihy', 'Madagascar', '47.9939002990723', '-14.89879989624023', 'WAI', 'FMNW', 'base.jpg', 0, 92, 0),
(936, 'Ampampamena Airport', 'Ampampamena', 'Madagascar', '48.6327020000000', '-13.48481600000000', 'IVA', 'FMNZ', 'base.jpg', 0, 49, 0),
(937, 'Tôlanaro Airport', 'Tolagnaro', 'Madagascar', '46.9561004638672', '-25.03809928894043', 'FTU', 'FMSD', 'base.jpg', 0, 29, 0),
(938, 'Fianarantsoa Airport', 'Fianarantsoa', 'Madagascar', '47.1116981506348', '-21.44160079956055', 'WFI', 'FMSF', 'base.jpg', 0, 3658, 0),
(939, 'Farafangana Airport', 'Farafangana', 'Madagascar', '47.8205986022949', '-22.80529975891113', 'RVA', 'FMSG', 'base.jpg', 0, 26, 0),
(940, 'Manakara Airport', 'Manakara', 'Madagascar', '48.0217018127441', '-22.11969947814941', 'WVK', 'FMSK', 'base.jpg', 0, 33, 0),
(941, 'Mananjary Airport', 'Mananjary', 'Madagascar', '48.3582992553711', '-21.20179939270020', 'MNJ', 'FMSM', 'base.jpg', 0, 20, 0),
(942, 'Morombe Airport', 'Morombe', 'Madagascar', '43.3754997253418', '-21.75390052795410', 'MXM', 'FMSR', 'base.jpg', 0, 16, 0),
(943, 'Toliara Airport', 'Toliara', 'Madagascar', '43.7285003662109', '-23.38339996337891', 'TLE', 'FMST', 'base.jpg', 0, 29, 0),
(944, 'Mbanza Congo Airport', 'M\'banza-congo', 'Angola', '14.2469997406006', '-6.26989984512329', 'SSY', 'FNBC', 'base.jpg', 0, 1860, 0),
(945, 'Benguela Airport', 'Benguela', 'Angola', '13.4036998749000', '-12.60900020600000', 'BUG', 'FNBG', 'base.jpg', 0, 118, 0),
(946, 'Cabinda Airport', 'Cabinda', 'Angola', '12.1884002685547', '-5.59699010848999', 'CAB', 'FNCA', 'base.jpg', 0, 66, 0),
(948, 'Nova Lisboa Airport', 'Huambo', 'Angola', '15.7604999542236', '-12.80889987945557', 'NOV', 'FNHU', 'base.jpg', 0, 5587, 0),
(949, 'Kuito Airport', 'Kuito', 'Angola', '16.9473991394040', '-12.40460014343300', 'SVP', 'FNKU', 'base.jpg', 0, 5618, 0),
(950, 'Lobito Airport', 'Lobito', 'Angola', '13.5366001129150', '-12.37119960784912', '\\N', 'FNLB', 'base.jpg', 0, 10, 0),
(951, 'Quatro de Fevereiro Airport', 'Luanda', 'Angola', '13.2312002182000', '-8.85836982727000', 'LAD', 'FNLU', 'base.jpg', 0, 243, 0),
(952, 'Malanje Airport', 'Malanje', 'Angola', '16.3124008178711', '-9.52509021759033', 'MEG', 'FNMA', 'base.jpg', 0, 3868, 0),
(953, 'Menongue Airport', 'Menongue', 'Angola', '17.7198009490967', '-14.65760040283203', 'SPP', 'FNME', 'base.jpg', 0, 4469, 0),
(955, 'Negage Airport', 'Negage', 'Angola', '15.2876996994019', '-7.75450992584229', 'GXG', 'FNNG', 'base.jpg', 0, 4105, 0),
(956, 'Porto Amboim Airport', 'Porto Amboim', 'Angola', '13.7655000686646', '-10.72200012207031', 'PBN', 'FNPA', 'base.jpg', 0, 16, 0),
(957, 'Saurimo Airport', 'Saurimo', 'Angola', '20.4319000244141', '-9.68906974792481', 'VHC', 'FNSA', 'base.jpg', 0, 3584, 0),
(958, 'Soyo Airport', 'Soyo', 'Angola', '12.3718004226685', '-6.14108991622925', 'SZA', 'FNSO', 'base.jpg', 0, 15, 0),
(959, 'Lubango Airport', 'Lubango', 'Angola', '13.5749998092651', '-14.92469978332520', 'SDD', 'FNUB', 'base.jpg', 0, 5778, 0),
(960, 'Luena Airport', 'Luena', 'Angola', '19.8976993560791', '-11.76809978485107', 'LUO', 'FNUE', 'base.jpg', 0, 4360, 0),
(961, 'Uige Airport', 'Uige', 'Angola', '15.0277996063232', '-7.60306978225708', 'UGO', 'FNUG', 'base.jpg', 0, 2720, 0),
(962, 'Xangongo Airport', 'Xangongo', 'Angola', '14.9652996063232', '-16.75539970397949', 'XGN', 'FNXA', 'base.jpg', 0, 3635, 0),
(963, 'Oyem Airport', 'Oyem', 'Gabon', '11.5813999176025', '1.54311001300812', 'OYE', 'FOGO', 'base.jpg', 0, 2158, 0),
(964, 'Okondja Airport', 'Okondja', 'Gabon', '13.6731004714966', '-0.66521400213242', 'OKN', 'FOGQ', 'base.jpg', 0, 1325, 0),
(965, 'Lambarene Airport', 'Lambarene', 'Gabon', '10.2456998825073', '-0.70438897609711', 'LBQ', 'FOGR', 'base.jpg', 0, 82, 0),
(966, 'Bitam Airport', 'Bitam', 'Gabon', '11.4932003021240', '2.07563996315002', 'BMM', 'FOOB', 'base.jpg', 0, 1969, 0),