airport.id,airport.ts,airport.name,airport.icao,airport.iata,airport.location,airport.country,airport.airport_type,airport.longitude_or_latitude,airport.elevation,airport.magnetic_variation,airport.time_zone,airport.country_x_airport_id,airport.airport_x_airport_communication_id,airport.airport_x_remark_id,airport.airport_x_runway_information_id 21,"2017-10-23 05:46:15","Taloqan Airport",OATQ,TQN,Taloqan,Afghanistan,,,,,,"{ ""21"": { ""country_x_airport.id"": 21, ""country.id"": 1, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Afghanistan"" } }",{},{},{} 22,"2017-10-23 05:46:15","Tereen Airport",OATN,TII,Tereen,Afghanistan,,,,,,"{ ""22"": { ""country_x_airport.id"": 22, ""country.id"": 1, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Afghanistan"" } }",{},{},{} 23,"2017-10-23 05:46:15","Zaranj Airport",OAZJ,ZAJ,Zaranj,Afghanistan,,,,,,"{ ""23"": { ""country_x_airport.id"": 23, ""country.id"": 1, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Afghanistan"" } }",{},{},{} 24,"2017-10-23 21:33:41","Gjader Airport",LAGJ,"Gjader Airport",Gjader,Albania,,"E 019° 35' 55.24""/N 41° 53' 42.80""19.598678/41.895222","23 ft / 7.01 m","E 3°13.4' (2008-04)",UTC+1(+2DT),"{ ""24"": { ""country_x_airport.id"": 24, ""country.id"": 2, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Albania"" } }","{ ""26"": { ""airport_x_airport_communication.id"": 26, ""airport_communication.id"": 26, ""airport_communication.ts"": ""2017-10-23 21:33:41"", ""airport_communication.type"": ""Tower"", ""airport_communication.name"": ""TWR"", ""airport_communication.freq_1"": ""129.5 M"", ""airport_communication.freq_2"": """", ""airport_communication.freq_3"": """", ""airport_communication.freq_4"": """", ""airport_communication.freq_5"": """" } }","{ ""57"": { ""airport_x_remark.id"": 57, ""remark.id"": 57, ""remark.ts"": ""2017-10-23 21:33:41"", ""remark.value"": ""Fuel - (NC-A1)"" }, ""58"": { ""airport_x_remark.id"": 58, ""remark.id"": 58, ""remark.ts"": ""2017-10-23 21:33:41"", ""remark.value"": ""Restricted - PPR."" } }","{ ""9"": { ""airport_x_runway_information.id"": 9, ""runway_information.id"": 9, ""runway_information.ts"": ""2017-10-24 03:51:48"", ""runway_information.dimension"": ""9186 x 197 ft / 2799.9 x 60.0 m"", ""runway_information.surface"": ""Asphalt, asphaltic concrete, tar macadam, or bitumen bound macadam."", ""runway_information.runway"": ""Runway 16"", ""runway_information.runway_1"": ""Runway 34"", ""runway_information.longitude"": ""130.443186 / E 130° 26' 35.47\""", ""runway_information.longitude_1"": ""130.458186 / E 130° 27' 29.47\""", ""runway_information.latitude"": ""33.596919 / N 33° 35' 48.91\""", ""runway_information.latitude_1"": ""33.574967 / N 33° 34' 29.88\""", ""runway_information.end_elevation"": ""15.0 ft"", ""runway_information.end_elevation_1"": ""32.0 ft"", ""runway_information.alignment"": ""157.0"", ""runway_information.alignment_1"": ""337.0"", ""runway_information.slope"": ""0.2"", ""runway_information.slope_1"": ""-0.2"", ""runway_information.touchdown_zone_elev"": ""18.0"", ""runway_information.touchdown_zone_elev_1"": ""32.0"", ""runway_information.displaced_threshold"": """", ""runway_information.displaced_threshold_1"": """", ""runway_information.lighting_system_1"": ""Sequenced Flashing Lights"", ""runway_information.lighting_system_1_1"": ""Sequenced Flashing Lights"", ""runway_information.lighting_system_2"": ""Touchdown Zone Lighting"", ""runway_information.lighting_system_2_2"": ""Touchdown Zone Lighting"", ""runway_information.lighting_system_3"": ""Centerline Lighting System"", ""runway_information.lighting_system_3_3"": ""Centerline Lighting System"", ""runway_information.lighting_system_4"": ""High Intensity Runway Lights"", ""runway_information.lighting_system_4_4"": ""High Intensity Runway Lights"", ""runway_information.lighting_system_5"": ""ALSF-1"", ""runway_information.lighting_system_5_5"": ""ALSF-1"" } }" 25,"2017-10-23 05:46:34","Korçë Northwest Airport",LAKO,"Korçë Northwest Airport",Korçë,Albania,,,,,,"{ ""25"": { ""country_x_airport.id"": 25, ""country.id"": 2, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Albania"" } }",{},{},{} 26,"2017-10-23 21:33:52","Kuçovë Airport",LAKV,"Kuçovë Airport",Kuçovë,Albania,,"E 019° 54' 06.80""/N 40° 46' 18.80""19.901890/40.771889","135 ft / 41.15 m","E 3°10.9' (2008-04)",UTC+1(+2DT),"{ ""26"": { ""country_x_airport.id"": 26, ""country.id"": 2, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Albania"" } }","{ ""27"": { ""airport_x_airport_communication.id"": 27, ""airport_communication.id"": 27, ""airport_communication.ts"": ""2017-10-23 21:33:52"", ""airport_communication.type"": ""Tower"", ""airport_communication.name"": ""TWR"", ""airport_communication.freq_1"": ""124.5 M"", ""airport_communication.freq_2"": """", ""airport_communication.freq_3"": """", ""airport_communication.freq_4"": """", ""airport_communication.freq_5"": """" } }","{ ""60"": { ""airport_x_remark.id"": 60, ""remark.id"": 58, ""remark.ts"": ""2017-10-23 21:33:41"", ""remark.value"": ""Restricted - PPR."" }, ""59"": { ""airport_x_remark.id"": 59, ""remark.id"": 59, ""remark.ts"": ""2017-10-23 21:33:52"", ""remark.value"": ""Fuel - (NC-J4)"" } }","{ ""10"": { ""airport_x_runway_information.id"": 10, ""runway_information.id"": 10, ""runway_information.ts"": ""2017-10-23 21:33:52"", ""runway_information.dimension"": ""9318 x 220 ft / 2840.1 x 67.1 m"", ""runway_information.surface"": ""Concrete."", ""runway_information.runway"": ""Runway 14"", ""runway_information.runway_1"": ""Runway 32"", ""runway_information.longitude"": ""19.890628 / E 019° 53' 26.26\""", ""runway_information.longitude_1"": ""19.913147 / E 019° 54' 47.33\""", ""runway_information.latitude"": ""40.781394 / N 40° 46' 53.02\""", ""runway_information.latitude_1"": ""40.762378 / N 40° 45' 44.56\""", ""runway_information.end_elevation"": """", ""runway_information.end_elevation_1"": """", ""runway_information.alignment"": ""134.0"", ""runway_information.alignment_1"": ""314.0"", ""runway_information.slope"": ""Unknown"", ""runway_information.slope_1"": ""Unknown"", ""runway_information.touchdown_zone_elev"": ""Unknown"", ""runway_information.touchdown_zone_elev_1"": ""Unknown"", ""runway_information.displaced_threshold"": ""200 ft"", ""runway_information.displaced_threshold_1"": ""0 ft"", ""runway_information.lighting_system_1"": ""Portable"", ""runway_information.lighting_system_1_1"": ""Portable"", ""runway_information.lighting_system_2"": """", ""runway_information.lighting_system_2_2"": """", ""runway_information.lighting_system_3"": """", ""runway_information.lighting_system_3_3"": """", ""runway_information.lighting_system_4"": """", ""runway_information.lighting_system_4_4"": """", ""runway_information.lighting_system_5"": """", ""runway_information.lighting_system_5_5"": """" } }" 27,"2017-10-23 05:46:34","Kukes Airport",LAKU,"Kukes Airport",Kukës,Albania,,,,,,"{ ""27"": { ""country_x_airport.id"": 27, ""country.id"": 2, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Albania"" } }",{},{},{} 28,"2017-10-23 21:34:05","Rinas Mother Teresa Airport",LATI,TIA,Tirana,Albania,,"E 019° 43' 14.02""/N 41° 24' 53.07""19.720561/41.414742","126 ft / 38.40 m","E 3°12.3' (2008-04)",UTC+1(+2DT),"{ ""28"": { ""country_x_airport.id"": 28, ""country.id"": 2, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Albania"" } }","{ ""28"": { ""airport_x_airport_communication.id"": 28, ""airport_communication.id"": 28, ""airport_communication.ts"": ""2017-10-23 21:34:05"", ""airport_communication.type"": ""Area Control Center"", ""airport_communication.name"": ""ACC"", ""airport_communication.freq_1"": ""127.5 M"", ""airport_communication.freq_2"": ""124.025 M"", ""airport_communication.freq_3"": """", ""airport_communication.freq_4"": """", ""airport_communication.freq_5"": """" }, ""29"": { ""airport_x_airport_communication.id"": 29, ""airport_communication.id"": 29, ""airport_communication.ts"": ""2017-10-23 21:34:05"", ""airport_communication.type"": ""Approach Control"", ""airport_communication.name"": ""APP"", ""airport_communication.freq_1"": ""133.15 M"", ""airport_communication.freq_2"": ""124.025 M"", ""airport_communication.freq_3"": """", ""airport_communication.freq_4"": """", ""airport_communication.freq_5"": """" }, ""30"": { ""airport_x_airport_communication.id"": 30, ""airport_communication.id"": 30, ""airport_communication.ts"": ""2017-10-23 21:34:05"", ""airport_communication.type"": ""Tower"", ""airport_communication.name"": ""TWR"", ""airport_communication.freq_1"": ""122.5 M"", ""airport_communication.freq_2"": ""123.5 M"", ""airport_communication.freq_3"": """", ""airport_communication.freq_4"": """", ""airport_communication.freq_5"": """" } }","{ ""61"": { ""airport_x_remark.id"": 61, ""remark.id"": 61, ""remark.ts"": ""2017-10-23 21:34:05"", ""remark.value"": ""Caution - Animal haz."" }, ""62"": { ""airport_x_remark.id"": 62, ""remark.id"": 62, ""remark.ts"": ""2017-10-23 21:34:05"", ""remark.value"": ""Fuel - Avbl 0500-2100Z++. OT O/R fone C44-1-202-590-558. A1 (Air BP)"" } }","{ ""11"": { ""airport_x_runway_information.id"": 11, ""runway_information.id"": 11, ""runway_information.ts"": ""2017-10-23 21:34:05"", ""runway_information.dimension"": ""8971 x 148 ft / 2734.4 x 45.1 m"", ""runway_information.surface"": ""Asphalt, asphaltic concrete, tar macadam, or bitumen bound macadam."", ""runway_information.runway"": ""Runway 18"", ""runway_information.runway_1"": ""Runway 36"", ""runway_information.longitude"": ""19.718942 / E 019° 43' 08.19\""", ""runway_information.longitude_1"": ""19.722197 / E 019° 43' 19.91\""", ""runway_information.latitude"": ""41.426981 / N 41° 25' 37.13\""", ""runway_information.latitude_1"": ""41.402483 / N 41° 24' 08.94\""", ""runway_information.end_elevation"": ""109.0 ft"", ""runway_information.end_elevation_1"": ""126.0 ft"", ""runway_information.alignment"": ""172.0"", ""runway_information.alignment_1"": ""352.0"", ""runway_information.slope"": ""0.2"", ""runway_information.slope_1"": ""-0.2"", ""runway_information.touchdown_zone_elev"": ""Unknown"", ""runway_information.touchdown_zone_elev_1"": ""Unknown"", ""runway_information.displaced_threshold"": """", ""runway_information.displaced_threshold_1"": """", ""runway_information.lighting_system_1"": ""Touchdown Zone Lighting"", ""runway_information.lighting_system_1_1"": ""Touchdown Zone Lighting"", ""runway_information.lighting_system_2"": ""High Intensity Runway Lights"", ""runway_information.lighting_system_2_2"": ""High Intensity Runway Lights"", ""runway_information.lighting_system_3"": ""Runway End Identifier Lights"", ""runway_information.lighting_system_3_3"": ""Runway End Identifier Lights"", ""runway_information.lighting_system_4"": ""SALS or SALSF"", ""runway_information.lighting_system_4_4"": ""MALS and MALSF or SSALS and SSALF"", ""runway_information.lighting_system_5"": ""PAPI - Precision Approach Path Indicator"", ""runway_information.lighting_system_5_5"": ""PAPI - Precision Approach Path Indicator"" } }" 29,"2017-10-23 05:46:34","Sarandë Airport",LASR,"Sarandë Airport","Sarandë (Saranda)",Albania,,,,,,"{ ""29"": { ""country_x_airport.id"": 29, ""country.id"": 2, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Albania"" } }",{},{},{} 30,"2017-10-23 05:46:34","Shkodër Airport",LASK,"Shkodër Airport","Shkodër (Shkodra)",Albania,,,,,,"{ ""30"": { ""country_x_airport.id"": 30, ""country.id"": 2, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Albania"" } }",{},{},{} 31,"2017-10-23 05:46:34","Tirana Mil Hel Airport",LAFK,"Tirana Mil Hel Airport",Tirana,Albania,,,,,,"{ ""31"": { ""country_x_airport.id"": 31, ""country.id"": 2, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Albania"" } }",{},{},{} 32,"2017-10-23 05:46:34","Vlorë Airport",LAVL,"Vlorë Airport","Vlorë (Vlora)",Albania,,,,,,"{ ""32"": { ""country_x_airport.id"": 32, ""country.id"": 2, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Albania"" } }",{},{},{} 33,"2017-10-23 21:34:33","Ain Arnat Airport",DAAS,QSF,Setif,Algeria,,"E 005° 19' 37.63""/N 36° 10' 42.08""5.327119/36.178356","3330 ft / 1014.98 m","E 0°26.3' (2008-04)",UTC+1,"{ ""33"": { ""country_x_airport.id"": 33, ""country.id"": 3, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Algeria"" } }","{ ""31"": { ""airport_x_airport_communication.id"": 31, ""airport_communication.id"": 31, ""airport_communication.ts"": ""2017-10-23 21:34:33"", ""airport_communication.type"": ""Tower"", ""airport_communication.name"": ""TWR"", ""airport_communication.freq_1"": ""119.7 M"", ""airport_communication.freq_2"": ""119.9 M"", ""airport_communication.freq_3"": """", ""airport_communication.freq_4"": """", ""airport_communication.freq_5"": """" } }","{ ""63"": { ""airport_x_remark.id"": 63, ""remark.id"": 63, ""remark.ts"": ""2017-10-23 21:34:33"", ""remark.value"": ""Operating Hours - Opr 0700-1500Z."" } }","{ ""12"": { ""airport_x_runway_information.id"": 12, ""runway_information.id"": 12, ""runway_information.ts"": ""2017-10-23 21:34:33"", ""runway_information.dimension"": ""7874 x 148 ft / 2400.0 x 45.1 m"", ""runway_information.surface"": ""Asphalt, asphaltic concrete, tar macadam, or bitumen bound macadam."", ""runway_information.runway"": ""Runway 09"", ""runway_information.runway_1"": ""Runway 27"", ""runway_information.longitude"": ""5.314167 / E 005° 18' 51.00\""", ""runway_information.longitude_1"": ""5.340833 / E 005° 20' 27.00\""", ""runway_information.latitude"": ""36.177500 / N 36° 10' 39.00\""", ""runway_information.latitude_1"": ""36.178889 / N 36° 10' 44.00\""", ""runway_information.end_elevation"": ""3330.0 ft"", ""runway_information.end_elevation_1"": ""3307.0 ft"", ""runway_information.alignment"": ""087.0"", ""runway_information.alignment_1"": ""267.0"", ""runway_information.slope"": ""-0.3"", ""runway_information.slope_1"": ""0.3"", ""runway_information.touchdown_zone_elev"": ""Unknown"", ""runway_information.touchdown_zone_elev_1"": ""Unknown"", ""runway_information.displaced_threshold"": """", ""runway_information.displaced_threshold_1"": """", ""runway_information.lighting_system_1"": ""Low Intensity Runway Lighting System"", ""runway_information.lighting_system_1_1"": ""Low Intensity Runway Lighting System"", ""runway_information.lighting_system_2"": ""PAPI - Precision Approach Path Indicator"", ""runway_information.lighting_system_2_2"": """", ""runway_information.lighting_system_3"": """", ""runway_information.lighting_system_3_3"": """", ""runway_information.lighting_system_4"": """", ""runway_information.lighting_system_4_4"": """", ""runway_information.lighting_system_5"": """", ""runway_information.lighting_system_5_5"": """" } }" 34,"2017-10-23 21:34:40","Ain Eddis Airport",DAAD,BUJ,"Bou Saada, M'Sila",Algeria,,"E 004° 12' 23.00""/N 35° 19' 57.00""4.206389/35.332500","1506 ft / 459.03 m","E 0°11.1' (2008-04)",UTC+1,"{ ""34"": { ""country_x_airport.id"": 34, ""country.id"": 3, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Algeria"" } }","{ ""32"": { ""airport_x_airport_communication.id"": 32, ""airport_communication.id"": 32, ""airport_communication.ts"": ""2017-10-23 21:34:40"", ""airport_communication.type"": ""Tower"", ""airport_communication.name"": ""TWR"", ""airport_communication.freq_1"": ""118.1 M"", ""airport_communication.freq_2"": """", ""airport_communication.freq_3"": """", ""airport_communication.freq_4"": """", ""airport_communication.freq_5"": """" } }","{ ""64"": { ""airport_x_remark.id"": 64, ""remark.id"": 64, ""remark.ts"": ""2017-10-23 21:34:40"", ""remark.value"": ""Operating Hours - Opr 0700-1600Z Sat-Thu, OT PN before 1400Z to DAADYDYD."" }, ""65"": { ""airport_x_remark.id"": 65, ""remark.id"": 65, ""remark.ts"": ""2017-10-23 21:34:40"", ""remark.value"": ""Restricted - Arpt clsd to public air tfc UFN."" } }","{ ""13"": { ""airport_x_runway_information.id"": 13, ""runway_information.id"": 13, ""runway_information.ts"": ""2017-10-23 21:34:40"", ""runway_information.dimension"": ""7218 x 98 ft / 2200.0 x 29.9 m"", ""runway_information.surface"": ""Asphalt, asphaltic concrete, tar macadam, or bitumen bound macadam."", ""runway_information.runway"": ""Runway 04"", ""runway_information.runway_1"": ""Runway 22"", ""runway_information.longitude"": ""4.198431 / E 004° 11' 54.35\""", ""runway_information.longitude_1"": ""4.214617 / E 004° 12' 52.62\""", ""runway_information.latitude"": ""35.325081 / N 35° 19' 30.29\""", ""runway_information.latitude_1"": ""35.339942 / N 35° 20' 23.79\""", ""runway_information.end_elevation"": ""1506.0 ft"", ""runway_information.end_elevation_1"": ""U ft"", ""runway_information.alignment"": ""043.0"", ""runway_information.alignment_1"": ""223.0"", ""runway_information.slope"": ""Unknown"", ""runway_information.slope_1"": ""Unknown"", ""runway_information.touchdown_zone_elev"": ""Unknown"", ""runway_information.touchdown_zone_elev_1"": ""Unknown"", ""runway_information.displaced_threshold"": """", ""runway_information.displaced_threshold_1"": """", ""runway_information.lighting_system_1"": """", ""runway_information.lighting_system_1_1"": """", ""runway_information.lighting_system_2"": """", ""runway_information.lighting_system_2_2"": """", ""runway_information.lighting_system_3"": """", ""runway_information.lighting_system_3_3"": """", ""runway_information.lighting_system_4"": """", ""runway_information.lighting_system_4_4"": """", ""runway_information.lighting_system_5"": """", ""runway_information.lighting_system_5_5"": """" } }" 35,"2017-10-23 21:34:47","Ain El Beida Airport",DAUU,OGX,Ouargla,Algeria,,"E 005° 24' 46.00""/N 31° 55' 02.00""5.412778/31.917223","492 ft / 149.96 m","E 0°19.7' (2008-04)",UTC+1,"{ ""35"": { ""country_x_airport.id"": 35, ""country.id"": 3, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Algeria"" } }","{ ""33"": { ""airport_x_airport_communication.id"": 33, ""airport_communication.id"": 33, ""airport_communication.ts"": ""2017-10-23 21:34:47"", ""airport_communication.type"": ""Tower"", ""airport_communication.name"": ""OUARGLA TWR"", ""airport_communication.freq_1"": ""118.7 M"", ""airport_communication.freq_2"": ""119.7 M"", ""airport_communication.freq_3"": """", ""airport_communication.freq_4"": """", ""airport_communication.freq_5"": """" } }","{ ""66"": { ""airport_x_remark.id"": 66, ""remark.id"": 57, ""remark.ts"": ""2017-10-23 21:33:41"", ""remark.value"": ""Fuel - (NC-A1)"" } }","{ ""14"": { ""airport_x_runway_information.id"": 14, ""runway_information.id"": 14, ""runway_information.ts"": ""2017-10-23 21:34:47"", ""runway_information.dimension"": ""10062 x 148 ft / 3066.9 x 45.1 m"", ""runway_information.surface"": ""Asphalt, asphaltic concrete, tar macadam, or bitumen bound macadam."", ""runway_information.runway"": ""Runway 02"", ""runway_information.runway_1"": ""Runway 20"", ""runway_information.longitude"": ""5.404722 / E 005° 24' 17.00\""", ""runway_information.longitude_1"": ""5.413333 / E 005° 24' 48.00\""", ""runway_information.latitude"": ""31.905556 / N 31° 54' 20.00\""", ""runway_information.latitude_1"": ""31.932222 / N 31° 55' 56.00\""", ""runway_information.end_elevation"": ""495.0 ft"", ""runway_information.end_elevation_1"": ""463.0 ft"", ""runway_information.alignment"": ""017.0"", ""runway_information.alignment_1"": ""197.0"", ""runway_information.slope"": ""-0.3"", ""runway_information.slope_1"": ""0.3"", ""runway_information.touchdown_zone_elev"": ""Unknown"", ""runway_information.touchdown_zone_elev_1"": ""Unknown"", ""runway_information.displaced_threshold"": """", ""runway_information.displaced_threshold_1"": """", ""runway_information.lighting_system_1"": """", ""runway_information.lighting_system_1_1"": """", ""runway_information.lighting_system_2"": """", ""runway_information.lighting_system_2_2"": """", ""runway_information.lighting_system_3"": """", ""runway_information.lighting_system_3_3"": """", ""runway_information.lighting_system_4"": """", ""runway_information.lighting_system_4_4"": """", ""runway_information.lighting_system_5"": """", ""runway_information.lighting_system_5_5"": """" } }" 36,"2017-10-23 21:34:55","Batna Airport",DABT,BLJ,Batna,Algeria,"A - Civil","E 006° 18' 30.92""/N 35° 45' 07.58""6.308589/35.752106","2697 ft / 822.05 m","E 0°37.9' (2008-04)",UTC+1,"{ ""36"": { ""country_x_airport.id"": 36, ""country.id"": 3, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Algeria"" } }","{ ""34"": { ""airport_x_airport_communication.id"": 34, ""airport_communication.id"": 34, ""airport_communication.ts"": ""2017-10-24 07:18:33"", ""airport_communication.type"": ""Tower"", ""airport_communication.name"": ""TWR"", ""airport_communication.freq_1"": ""118.1 M"", ""airport_communication.freq_2"": ""119.7 M"", ""airport_communication.freq_3"": ""120.225 M"", ""airport_communication.freq_4"": """", ""airport_communication.freq_5"": """" } }","{ ""67"": { ""airport_x_remark.id"": 67, ""remark.id"": 63, ""remark.ts"": ""2017-10-23 21:34:33"", ""remark.value"": ""Operating Hours - Opr 0700-1500Z."" } }","{ ""15"": { ""airport_x_runway_information.id"": 15, ""runway_information.id"": 15, ""runway_information.ts"": ""2017-10-23 21:34:55"", ""runway_information.dimension"": ""9837 x 148 ft / 2998.3 x 45.1 m"", ""runway_information.surface"": ""Asphalt, asphaltic concrete, tar macadam, or bitumen bound macadam."", ""runway_information.runway"": ""Runway 05"", ""runway_information.runway_1"": ""Runway 23"", ""runway_information.longitude"": ""6.295789 / E 006° 17' 44.84\""", ""runway_information.longitude_1"": ""6.322878 / E 006° 19' 22.36\""", ""runway_information.latitude"": ""35.744050 / N 35° 44' 38.58\""", ""runway_information.latitude_1"": ""35.759625 / N 35° 45' 34.65\""", ""runway_information.end_elevation"": """", ""runway_information.end_elevation_1"": """", ""runway_information.alignment"": ""053.0"", ""runway_information.alignment_1"": ""233.0"", ""runway_information.slope"": ""Unknown"", ""runway_information.slope_1"": ""Unknown"", ""runway_information.touchdown_zone_elev"": ""Unknown"", ""runway_information.touchdown_zone_elev_1"": ""Unknown"", ""runway_information.displaced_threshold"": """", ""runway_information.displaced_threshold_1"": """", ""runway_information.lighting_system_1"": ""Touchdown Zone Lighting"", ""runway_information.lighting_system_1_1"": ""Touchdown Zone Lighting"", ""runway_information.lighting_system_2"": ""Centerline Lighting System"", ""runway_information.lighting_system_2_2"": ""Centerline Lighting System"", ""runway_information.lighting_system_3"": ""Lights"", ""runway_information.lighting_system_3_3"": ""Lights"", ""runway_information.lighting_system_4"": """", ""runway_information.lighting_system_4_4"": """", ""runway_information.lighting_system_5"": """", ""runway_information.lighting_system_5_5"": """" } }" 37,"2017-10-23 21:35:06","Béchar Ouakda Airport",DAOR,CBH,Béchar,Algeria,,"W 002° 16' 11.50""/N 31° 38' 44.68""-2.269861/31.645744","2661 ft / 811.07 m","W 1°27.4' (2008-04)",UTC+1,"{ ""37"": { ""country_x_airport.id"": 37, ""country.id"": 3, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Algeria"" } }","{ ""35"": { ""airport_x_airport_communication.id"": 35, ""airport_communication.id"": 35, ""airport_communication.ts"": ""2017-10-23 21:35:06"", ""airport_communication.type"": ""Tower"", ""airport_communication.name"": ""TWR"", ""airport_communication.freq_1"": ""118.7 M"", ""airport_communication.freq_2"": """", ""airport_communication.freq_3"": """", ""airport_communication.freq_4"": """", ""airport_communication.freq_5"": """" } }","{ ""68"": { ""airport_x_remark.id"": 68, ""remark.id"": 57, ""remark.ts"": ""2017-10-23 21:33:41"", ""remark.value"": ""Fuel - (NC-A1)"" }, ""69"": { ""airport_x_remark.id"": 69, ""remark.id"": 63, ""remark.ts"": ""2017-10-23 21:34:33"", ""remark.value"": ""Operating Hours - Opr 0700-1500Z."" } }","{ ""16"": { ""airport_x_runway_information.id"": 16, ""runway_information.id"": 16, ""runway_information.ts"": ""2017-10-23 21:35:06"", ""runway_information.dimension"": ""9733 x 148 ft / 2966.6 x 45.1 m"", ""runway_information.surface"": ""Asphalt, asphaltic concrete, tar macadam, or bitumen bound macadam."", ""runway_information.runway"": ""Runway 06"", ""runway_information.runway_1"": ""Runway 24"", ""runway_information.longitude"": ""-2.295339 / W 002° 17' 43.22\""", ""runway_information.longitude_1"": ""-2.268275 / W 002° 16' 05.79\""", ""runway_information.latitude"": ""31.637881 / N 31° 38' 16.37\""", ""runway_information.latitude_1"": ""31.651292 / N 31° 39' 04.65\""", ""runway_information.end_elevation"": ""2648.0 ft"", ""runway_information.end_elevation_1"": ""2657.0 ft"", ""runway_information.alignment"": ""062.0"", ""runway_information.alignment_1"": ""242.0"", ""runway_information.slope"": ""0.1"", ""runway_information.slope_1"": ""-0.1"", ""runway_information.touchdown_zone_elev"": ""Unknown"", ""runway_information.touchdown_zone_elev_1"": ""Unknown"", ""runway_information.displaced_threshold"": ""0 ft"", ""runway_information.displaced_threshold_1"": ""985 ft"", ""runway_information.lighting_system_1"": """", ""runway_information.lighting_system_1_1"": """", ""runway_information.lighting_system_2"": """", ""runway_information.lighting_system_2_2"": """", ""runway_information.lighting_system_3"": """", ""runway_information.lighting_system_3_3"": """", ""runway_information.lighting_system_4"": """", ""runway_information.lighting_system_4_4"": """", ""runway_information.lighting_system_5"": """", ""runway_information.lighting_system_5_5"": """" } }" 38,"2017-10-23 21:35:17","Biskra Airport",DAUB,BSK,Biskra,Algeria,"A - Civil","E 005° 44' 17.63""/N 34° 47' 35.84""5.738231/34.793289","289 ft / 88.09 m","E 0°29.7' (2008-04)",UTC+1,"{ ""38"": { ""country_x_airport.id"": 38, ""country.id"": 3, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Algeria"" } }","{ ""36"": { ""airport_x_airport_communication.id"": 36, ""airport_communication.id"": 36, ""airport_communication.ts"": ""2017-10-23 21:35:17"", ""airport_communication.type"": ""Tower"", ""airport_communication.name"": ""TWR"", ""airport_communication.freq_1"": ""119.7 M"", ""airport_communication.freq_2"": """", ""airport_communication.freq_3"": """", ""airport_communication.freq_4"": """", ""airport_communication.freq_5"": """" } }","{ ""70"": { ""airport_x_remark.id"": 70, ""remark.id"": 57, ""remark.ts"": ""2017-10-23 21:33:41"", ""remark.value"": ""Fuel - (NC-A1)"" }, ""71"": { ""airport_x_remark.id"": 71, ""remark.id"": 63, ""remark.ts"": ""2017-10-23 21:34:33"", ""remark.value"": ""Operating Hours - Opr 0700-1500Z."" } }","{ ""17"": { ""airport_x_runway_information.id"": 17, ""runway_information.id"": 17, ""runway_information.ts"": ""2017-10-23 21:35:17"", ""runway_information.dimension"": ""9458 x 148 ft / 2882.8 x 45.1 m"", ""runway_information.surface"": ""Asphalt, asphaltic concrete, tar macadam, or bitumen bound macadam."", ""runway_information.runway"": ""Runway 13"", ""runway_information.runway_1"": ""Runway 31"", ""runway_information.longitude"": ""5.726389 / E 005° 43' 35.00\""", ""runway_information.longitude_1"": ""5.750556 / E 005° 45' 02.00\""", ""runway_information.latitude"": ""34.801667 / N 34° 48' 06.00\""", ""runway_information.latitude_1"": ""34.785000 / N 34° 47' 06.00\""", ""runway_information.end_elevation"": ""289.0 ft"", ""runway_information.end_elevation_1"": ""246.0 ft"", ""runway_information.alignment"": ""130.0"", ""runway_information.alignment_1"": ""310.0"", ""runway_information.slope"": ""-0.5"", ""runway_information.slope_1"": ""0.5"", ""runway_information.touchdown_zone_elev"": ""Unknown"", ""runway_information.touchdown_zone_elev_1"": ""Unknown"", ""runway_information.displaced_threshold"": """", ""runway_information.displaced_threshold_1"": """", ""runway_information.lighting_system_1"": ""PAPI - Precision Approach Path Indicator"", ""runway_information.lighting_system_1_1"": ""PAPI - Precision Approach Path Indicator"", ""runway_information.lighting_system_2"": """", ""runway_information.lighting_system_2_2"": """", ""runway_information.lighting_system_3"": """", ""runway_information.lighting_system_3_3"": """", ""runway_information.lighting_system_4"": """", ""runway_information.lighting_system_4_4"": """", ""runway_information.lighting_system_5"": """", ""runway_information.lighting_system_5_5"": """" } }" 39,"2017-10-23 21:35:17","Blida Airport",DAAB,QLD,Blida,Algeria,,"E 002° 48' 51.00""/N 36° 30' 13.01""2.814167/36.503613","535 ft / 163.07 m","W 0°06.9' (2008-04)",,"{ ""39"": { ""country_x_airport.id"": 39, ""country.id"": 3, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Algeria"" } }",{},{},"{ ""18"": { ""airport_x_runway_information.id"": 18, ""runway_information.id"": 18, ""runway_information.ts"": ""2017-10-23 21:35:17"", ""runway_information.dimension"": ""5833 x 150 ft / 1777.9 x 45.7 m"", ""runway_information.surface"": ""Asphalt, asphaltic concrete, tar macadam, or bitumen bound macadam."", ""runway_information.runway"": ""Runway 07"", ""runway_information.runway_1"": ""Runway 25"", ""runway_information.longitude"": ""2.803306 / E 002° 48' 11.90\""", ""runway_information.longitude_1"": ""2.821917 / E 002° 49' 18.90\""", ""runway_information.latitude"": ""36.501389 / N 36° 30' 05.00\""", ""runway_information.latitude_1"": ""36.508025 / N 36° 30' 28.89\""", ""runway_information.end_elevation"": """", ""runway_information.end_elevation_1"": """", ""runway_information.alignment"": ""068.0"", ""runway_information.alignment_1"": ""248.0"", ""runway_information.slope"": ""Unknown"", ""runway_information.slope_1"": ""Unknown"", ""runway_information.touchdown_zone_elev"": ""Unknown"", ""runway_information.touchdown_zone_elev_1"": ""Unknown"", ""runway_information.displaced_threshold"": ""350 ft"", ""runway_information.displaced_threshold_1"": ""0 ft"", ""runway_information.lighting_system_1"": """", ""runway_information.lighting_system_1_1"": """", ""runway_information.lighting_system_2"": """", ""runway_information.lighting_system_2_2"": """", ""runway_information.lighting_system_3"": """", ""runway_information.lighting_system_3_3"": """", ""runway_information.lighting_system_4"": """", ""runway_information.lighting_system_4_4"": """", ""runway_information.lighting_system_5"": """", ""runway_information.lighting_system_5_5"": """" } }" 40,"2017-10-23 21:35:19","Bordj Mokhtar Airport",DATM,BMW,"Bordj Mokhtar",Algeria,"A - Civil","E 000° 55' 33.53""/N 21° 22' 39.63""0.925981/21.377675","1302 ft / 396.85 m","W 1°20.8' (2008-04)",UTC+1,"{ ""40"": { ""country_x_airport.id"": 40, ""country.id"": 3, ""country.ts"": ""2017-10-23 05:02:00"", ""country.title"": ""Algeria"" } }","{ ""37"": { ""airport_x_airport_communication.id"": 37, ""airport_communication.id"": 37, ""airport_communication.ts"": ""2017-10-23 21:35:19"", ""airport_communication.type"": ""Radio"", ""airport_communication.name"": ""RDO"", ""airport_communication.freq_1"": ""8894 K"", ""airport_communication.freq_2"": """", ""airport_communication.freq_3"": """", ""airport_communication.freq_4"": """", ""airport_communication.freq_5"": """" }, ""38"": { ""airport_x_airport_communication.id"": 38, ""airport_communication.id"": 38, ""airport_communication.ts"": ""2017-10-23 21:35:19"", ""airport_communication.type"": ""Tower"", ""airport_communication.name"": ""TWR"", ""airport_communication.freq_1"": ""119.7 M"", ""airport_communication.freq_2"": ""118.3 M"", ""airport_communication.freq_3"": """", ""airport_communication.freq_4"": """", ""airport_communication.freq_5"": """" } }","{ ""72"": { ""airport_x_remark.id"": 72, ""remark.id"": 72, ""remark.ts"": ""2017-10-23 21:35:19"", ""remark.value"": ""Fuel - (NC-A1)."" }, ""73"": { ""airport_x_remark.id"": 73, ""remark.id"": 73, ""remark.ts"": ""2017-10-23 21:35:19"", ""remark.value"": ""Operating Hours - Opr 0600-1800Z."" } }","{ ""19"": { ""airport_x_runway_information.id"": 19, ""runway_information.id"": 19, ""runway_information.ts"": ""2017-10-24 01:02:21"", ""runway_information.dimension"": ""9842 x 148 ft / 2999.8 x 45.1 m"", ""runway_information.surface"": ""Asphalt, asphaltic concrete, tar macadam, or bitumen bound macadam."", ""runway_information.runway"": ""Runway 08"", ""runway_information.runway_1"": ""Runway 26"", ""runway_information.longitude"": ""-77.100353 / W 077° 06' 01.27\""", ""runway_information.longitude_1"": ""-77.072714 / W 077° 04' 21.77\""", ""runway_information.latitude"": ""20.285217 / N 20° 17' 06.78\""", ""runway_information.latitude_1"": ""20.292603 / N 20° 17' 33.37\""", ""runway_information.end_elevation"": ""112.0 ft"", ""runway_information.end_elevation_1"": ""85.0 ft"", ""runway_information.alignment"": ""080.0"", ""runway_information.alignment_1"": ""260.0"", ""runway_information.slope"": ""Unknown"", ""runway_information.slope_1"": ""Unknown"", ""runway_information.touchdown_zone_elev"": ""Unknown"", ""runway_information.touchdown_zone_elev_1"": ""Unknown"", ""runway_information.displaced_threshold"": """", ""runway_information.displaced_threshold_1"": """", ""runway_information.lighting_system_1"": ""Medium Intensity Runway Lighting System"", ""runway_information.lighting_system_1_1"": ""Medium Intensity Runway Lighting System"", ""runway_information.lighting_system_2"": ""SALS or SALSF"", ""runway_information.lighting_system_2_2"": ""Lighting System 3:"", ""runway_information.lighting_system_3"": ""PAPI - Precision Approach Path Indicator"", ""runway_information.lighting_system_3_3"": """", ""runway_information.lighting_system_4"": """", ""runway_information.lighting_system_4_4"": """", ""runway_information.lighting_system_5"": """", ""runway_information.lighting_system_5_5"": """" } }"