You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
{ "sample": { "is_sample": "TRUE", "limit_total": 400 }, "api": { "title": "World Airport", "point": { "title": "Main", "desc": "Main access point of this API. " } }, "input": {}, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/world_airport/main/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/world_airport/main/list/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/world_airport/main/list/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/world_airport/main/list/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 20, "limit_total": 400, "time": 0.0028200000000000000240085729075190101866610348224639892578125 }, "stats": { "raw_rows": 20, "rows": 20, "rows_total": 7586, "pages_total": 380 }, "struct": { "stem": { "0": "airport" }, "leaf": "airport.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "21": { "airport.id": 21, "airport.ts": "2017-10-23 05:46:15", "airport.name": "Taloqan Airport", "airport.icao": "OATQ", "airport.iata": "TQN", "airport.location": "Taloqan", "airport.country": "Afghanistan", "airport.airport_type": "", "airport.longitude_or_latitude": "", "airport.elevation": "", "airport.magnetic_variation": "", "airport.time_zone": "", "airport.country_x_airport_id": { "21": { "country_x_airport.id": 21, "country.id": 1, "country.ts": "2017-10-23 05:02:00", "country.title": "Afghanistan" } }, "airport.airport_x_airport_communication_id": {}, "airport.airport_x_remark_id": {}, "airport.airport_x_runway_information_id": {} }, "22": { "airport.id": 22, "airport.ts": "2017-10-23 05:46:15", "airport.name": "Tereen Airport", "airport.icao": "OATN", "airport.iata": "TII", "airport.location": "Tereen", "airport.country": "Afghanistan", "airport.airport_type": "", "airport.longitude_or_latitude": "", "airport.elevation": "", "airport.magnetic_variation": "", "airport.time_zone": "", "airport.country_x_airport_id": { "22": { "country_x_airport.id": 22, "country.id": 1, "country.ts": "2017-10-23 05:02:00", "country.title": "Afghanistan" } }, "airport.airport_x_airport_communication_id": {}, "airport.airport_x_remark_id": {}, "airport.airport_x_runway_information_id": {} }, "23": { "airport.id": 23, "airport.ts": "2017-10-23 05:46:15", "airport.name": "Zaranj Airport", "airport.icao": "OAZJ", "airport.iata": "ZAJ", "airport.location": "Zaranj", "airport.country": "Afghanistan", "airport.airport_type": "", "airport.longitude_or_latitude": "", "airport.elevation": "", "airport.magnetic_variation": "", "airport.time_zone": "", "airport.country_x_airport_id": { "23": { "country_x_airport.id": 23, "country.id": 1, "country.ts": "2017-10-23 05:02:00", "country.title": "Afghanistan" } }, "airport.airport_x_airport_communication_id": {}, "airport.airport_x_remark_id": {}, "airport.airport_x_runway_information_id": {} }, "24": { "airport.id": 24, "airport.ts": "2017-10-23 21:33:41", "airport.name": "Gjader Airport", "airport.icao": "LAGJ", "airport.iata": "Gjader Airport", "airport.location": "Gjader", "airport.country": "Albania", "airport.airport_type": "", "airport.longitude_or_latitude": "E 019° 35' 55.24\"/N 41° 53' 42.80\"19.598678/41.895222", "airport.elevation": "23 ft / 7.01 m", "airport.magnetic_variation": "E 3°13.4' (2008-04)", "airport.time_zone": "UTC+1(+2DT)", "airport.country_x_airport_id": { "24": { "country_x_airport.id": 24, "country.id": 2, "country.ts": "2017-10-23 05:02:00", "country.title": "Albania" } }, "airport.airport_x_airport_communication_id": { "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": "" } }, "airport.airport_x_remark_id": { "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." } }, "airport.airport_x_runway_information_id": { "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, "runway_information.alignment_1": 337, "runway_information.slope": 0.200000000000000011102230246251565404236316680908203125, "runway_information.slope_1": -0.200000000000000011102230246251565404236316680908203125, "runway_information.touchdown_zone_elev": 18, "runway_information.touchdown_zone_elev_1": 32, "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": { "airport.id": 25, "airport.ts": "2017-10-23 05:46:34", "airport.name": "Korçë Northwest Airport", "airport.icao": "LAKO", "airport.iata": "Korçë Northwest Airport", "airport.location": "Korçë", "airport.country": "Albania", "airport.airport_type": "", "airport.longitude_or_latitude": "", "airport.elevation": "", "airport.magnetic_variation": "", "airport.time_zone": "", "airport.country_x_airport_id": { "25": { "country_x_airport.id": 25, "country.id": 2, "country.ts": "2017-10-23 05:02:00", "country.title": "Albania" } }, "airport.airport_x_airport_communication_id": {}, "airport.airport_x_remark_id": {}, "airport.airport_x_runway_information_id": {} }, "26": { "airport.id": 26, "airport.ts": "2017-10-23 21:33:52", "airport.name": "Kuçovë Airport", "airport.icao": "LAKV", "airport.iata": "Kuçovë Airport", "airport.location": "Kuçovë", "airport.country": "Albania", "airport.airport_type": "", "airport.longitude_or_latitude": "E 019° 54' 06.80\"/N 40° 46' 18.80\"19.901890/40.771889", "airport.elevation": "135 ft / 41.15 m", "airport.magnetic_variation": "E 3°10.9' (2008-04)", "airport.time_zone": "UTC+1(+2DT)", "airport.country_x_airport_id": { "26": { "country_x_airport.id": 26, "country.id": 2, "country.ts": "2017-10-23 05:02:00", "country.title": "Albania" } }, "airport.airport_x_airport_communication_id": { "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": "" } }, "airport.airport_x_remark_id": { "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)" } }, "airport.airport_x_runway_information_id": { "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, "runway_information.alignment_1": 314, "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": { "airport.id": 27, "airport.ts": "2017-10-23 05:46:34", "airport.name": "Kukes Airport", "airport.icao": "LAKU", "airport.iata": "Kukes Airport", "airport.location": "Kukës", "airport.country": "Albania", "airport.airport_type": "", "airport.longitude_or_latitude": "", "airport.elevation": "", "airport.magnetic_variation": "", "airport.time_zone": "", "airport.country_x_airport_id": { "27": { "country_x_airport.id": 27, "country.id": 2, "country.ts": "2017-10-23 05:02:00", "country.title": "Albania" } }, "airport.airport_x_airport_communication_id": {}, "airport.airport_x_remark_id": {}, "airport.airport_x_runway_information_id": {} }, "28": { "airport.id": 28, "airport.ts": "2017-10-23 21:34:05", "airport.name": "Rinas Mother Teresa Airport", "airport.icao": "LATI", "airport.iata": "TIA", "airport.location": "Tirana", "airport.country": "Albania", "airport.airport_type": "", "airport.longitude_or_latitude": "E 019° 43' 14.02\"/N 41° 24' 53.07\"19.720561/41.414742", "airport.elevation": "126 ft / 38.40 m", "airport.magnetic_variation": "E 3°12.3' (2008-04)", "airport.time_zone": "UTC+1(+2DT)", "airport.country_x_airport_id": { "28": { "country_x_airport.id": 28, "country.id": 2, "country.ts": "2017-10-23 05:02:00", "country.title": "Albania" } }, "airport.airport_x_airport_communication_id": { "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": "" } }, "airport.airport_x_remark_id": { "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)" } }, "airport.airport_x_runway_information_id": { "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, "runway_information.alignment_1": 352, "runway_information.slope": 0.200000000000000011102230246251565404236316680908203125, "runway_information.slope_1": -0.200000000000000011102230246251565404236316680908203125, "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": { "airport.id": 29, "airport.ts": "2017-10-23 05:46:34", "airport.name": "Sarandë Airport", "airport.icao": "LASR", "airport.iata": "Sarandë Airport", "airport.location": "Sarandë (Saranda)", "airport.country": "Albania", "airport.airport_type": "", "airport.longitude_or_latitude": "", "airport.elevation": "", "airport.magnetic_variation": "", "airport.time_zone": "", "airport.country_x_airport_id": { "29": { "country_x_airport.id": 29, "country.id": 2, "country.ts": "2017-10-23 05:02:00", "country.title": "Albania" } }, "airport.airport_x_airport_communication_id": {}, "airport.airport_x_remark_id": {}, "airport.airport_x_runway_information_id": {} }, "30": { "airport.id": 30, "airport.ts": "2017-10-23 05:46:34", "airport.name": "Shkodër Airport", "airport.icao": "LASK", "airport.iata": "Shkodër Airport", "airport.location": "Shkodër (Shkodra)", "airport.country": "Albania", "airport.airport_type": "", "airport.longitude_or_latitude": "", "airport.elevation": "", "airport.magnetic_variation": "", "airport.time_zone": "", "airport.country_x_airport_id": { "30": { "country_x_airport.id": 30, "country.id": 2, "country.ts": "2017-10-23 05:02:00", "country.title": "Albania" } }, "airport.airport_x_airport_communication_id": {}, "airport.airport_x_remark_id": {}, "airport.airport_x_runway_information_id": {} }, "31": { "airport.id": 31, "airport.ts": "2017-10-23 05:46:34", "airport.name": "Tirana Mil Hel Airport", "airport.icao": "LAFK", "airport.iata": "Tirana Mil Hel Airport", "airport.location": "Tirana", "airport.country": "Albania", "airport.airport_type": "", "airport.longitude_or_latitude": "", "airport.elevation": "", "airport.magnetic_variation": "", "airport.time_zone": "", "airport.country_x_airport_id": { "31": { "country_x_airport.id": 31, "country.id": 2, "country.ts": "2017-10-23 05:02:00", "country.title": "Albania" } }, "airport.airport_x_airport_communication_id": {}, "airport.airport_x_remark_id": {}, "airport.airport_x_runway_information_id": {} }, "32": { "airport.id": 32, "airport.ts": "2017-10-23 05:46:34", "airport.name": "Vlorë Airport", "airport.icao": "LAVL", "airport.iata": "Vlorë Airport", "airport.location": "Vlorë (Vlora)", "airport.country": "Albania", "airport.airport_type": "", "airport.longitude_or_latitude": "", "airport.elevation": "", "airport.magnetic_variation": "", "airport.time_zone": "", "airport.country_x_airport_id": { "32": { "country_x_airport.id": 32, "country.id": 2, "country.ts": "2017-10-23 05:02:00", "country.title": "Albania" } }, "airport.airport_x_airport_communication_id": {}, "airport.airport_x_remark_id": {}, "airport.airport_x_runway_information_id": {} }, "33": { "airport.id": 33, "airport.ts": "2017-10-23 21:34:33", "airport.name": "Ain Arnat Airport", "airport.icao": "DAAS", "airport.iata": "QSF", "airport.location": "Setif", "airport.country": "Algeria", "airport.airport_type": "", "airport.longitude_or_latitude": "E 005° 19' 37.63\"/N 36° 10' 42.08\"5.327119/36.178356", "airport.elevation": "3330 ft / 1014.98 m", "airport.magnetic_variation": "E 0°26.3' (2008-04)", "airport.time_zone": "UTC+1", "airport.country_x_airport_id": { "33": { "country_x_airport.id": 33, "country.id": 3, "country.ts": "2017-10-23 05:02:00", "country.title": "Algeria" } }, "airport.airport_x_airport_communication_id": { "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": "" } }, "airport.airport_x_remark_id": { "63": { "airport_x_remark.id": 63, "remark.id": 63, "remark.ts": "2017-10-23 21:34:33", "remark.value": "Operating Hours - Opr 0700-1500Z." } }, "airport.airport_x_runway_information_id": { "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, "runway_information.slope": -0.299999999999999988897769753748434595763683319091796875, "runway_information.slope_1": 0.299999999999999988897769753748434595763683319091796875, "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": { "airport.id": 34, "airport.ts": "2017-10-23 21:34:40", "airport.name": "Ain Eddis Airport", "airport.icao": "DAAD", "airport.iata": "BUJ", "airport.location": "Bou Saada, M'Sila", "airport.country": "Algeria", "airport.airport_type": "", "airport.longitude_or_latitude": "E 004° 12' 23.00\"/N 35° 19' 57.00\"4.206389/35.332500", "airport.elevation": "1506 ft / 459.03 m", "airport.magnetic_variation": "E 0°11.1' (2008-04)", "airport.time_zone": "UTC+1", "airport.country_x_airport_id": { "34": { "country_x_airport.id": 34, "country.id": 3, "country.ts": "2017-10-23 05:02:00", "country.title": "Algeria" } }, "airport.airport_x_airport_communication_id": { "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": "" } }, "airport.airport_x_remark_id": { "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." } }, "airport.airport_x_runway_information_id": { "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, "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": { "airport.id": 35, "airport.ts": "2017-10-23 21:34:47", "airport.name": "Ain El Beida Airport", "airport.icao": "DAUU", "airport.iata": "OGX", "airport.location": "Ouargla", "airport.country": "Algeria", "airport.airport_type": "", "airport.longitude_or_latitude": "E 005° 24' 46.00\"/N 31° 55' 02.00\"5.412778/31.917223", "airport.elevation": "492 ft / 149.96 m", "airport.magnetic_variation": "E 0°19.7' (2008-04)", "airport.time_zone": "UTC+1", "airport.country_x_airport_id": { "35": { "country_x_airport.id": 35, "country.id": 3, "country.ts": "2017-10-23 05:02:00", "country.title": "Algeria" } }, "airport.airport_x_airport_communication_id": { "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": "" } }, "airport.airport_x_remark_id": { "66": { "airport_x_remark.id": 66, "remark.id": 57, "remark.ts": "2017-10-23 21:33:41", "remark.value": "Fuel - (NC-A1)" } }, "airport.airport_x_runway_information_id": { "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, "runway_information.slope": -0.299999999999999988897769753748434595763683319091796875, "runway_information.slope_1": 0.299999999999999988897769753748434595763683319091796875, "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": { "airport.id": 36, "airport.ts": "2017-10-23 21:34:55", "airport.name": "Batna Airport", "airport.icao": "DABT", "airport.iata": "BLJ", "airport.location": "Batna", "airport.country": "Algeria", "airport.airport_type": "A - Civil", "airport.longitude_or_latitude": "E 006° 18' 30.92\"/N 35° 45' 07.58\"6.308589/35.752106", "airport.elevation": "2697 ft / 822.05 m", "airport.magnetic_variation": "E 0°37.9' (2008-04)", "airport.time_zone": "UTC+1", "airport.country_x_airport_id": { "36": { "country_x_airport.id": 36, "country.id": 3, "country.ts": "2017-10-23 05:02:00", "country.title": "Algeria" } }, "airport.airport_x_airport_communication_id": { "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": "" } }, "airport.airport_x_remark_id": { "67": { "airport_x_remark.id": 67, "remark.id": 63, "remark.ts": "2017-10-23 21:34:33", "remark.value": "Operating Hours - Opr 0700-1500Z." } }, "airport.airport_x_runway_information_id": { "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, "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": { "airport.id": 37, "airport.ts": "2017-10-23 21:35:06", "airport.name": "Béchar Ouakda Airport", "airport.icao": "DAOR", "airport.iata": "CBH", "airport.location": "Béchar", "airport.country": "Algeria", "airport.airport_type": "", "airport.longitude_or_latitude": "W 002° 16' 11.50\"/N 31° 38' 44.68\"-2.269861/31.645744", "airport.elevation": "2661 ft / 811.07 m", "airport.magnetic_variation": "W 1°27.4' (2008-04)", "airport.time_zone": "UTC+1", "airport.country_x_airport_id": { "37": { "country_x_airport.id": 37, "country.id": 3, "country.ts": "2017-10-23 05:02:00", "country.title": "Algeria" } }, "airport.airport_x_airport_communication_id": { "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": "" } }, "airport.airport_x_remark_id": { "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." } }, "airport.airport_x_runway_information_id": { "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, "runway_information.slope": 0.1000000000000000055511151231257827021181583404541015625, "runway_information.slope_1": -0.1000000000000000055511151231257827021181583404541015625, "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": { "airport.id": 38, "airport.ts": "2017-10-23 21:35:17", "airport.name": "Biskra Airport", "airport.icao": "DAUB", "airport.iata": "BSK", "airport.location": "Biskra", "airport.country": "Algeria", "airport.airport_type": "A - Civil", "airport.longitude_or_latitude": "E 005° 44' 17.63\"/N 34° 47' 35.84\"5.738231/34.793289", "airport.elevation": "289 ft / 88.09 m", "airport.magnetic_variation": "E 0°29.7' (2008-04)", "airport.time_zone": "UTC+1", "airport.country_x_airport_id": { "38": { "country_x_airport.id": 38, "country.id": 3, "country.ts": "2017-10-23 05:02:00", "country.title": "Algeria" } }, "airport.airport_x_airport_communication_id": { "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": "" } }, "airport.airport_x_remark_id": { "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." } }, "airport.airport_x_runway_information_id": { "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, "runway_information.alignment_1": 310, "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": { "airport.id": 39, "airport.ts": "2017-10-23 21:35:17", "airport.name": "Blida Airport", "airport.icao": "DAAB", "airport.iata": "QLD", "airport.location": "Blida", "airport.country": "Algeria", "airport.airport_type": "", "airport.longitude_or_latitude": "E 002° 48' 51.00\"/N 36° 30' 13.01\"2.814167/36.503613", "airport.elevation": "535 ft / 163.07 m", "airport.magnetic_variation": "W 0°06.9' (2008-04)", "airport.time_zone": "", "airport.country_x_airport_id": { "39": { "country_x_airport.id": 39, "country.id": 3, "country.ts": "2017-10-23 05:02:00", "country.title": "Algeria" } }, "airport.airport_x_airport_communication_id": {}, "airport.airport_x_remark_id": {}, "airport.airport_x_runway_information_id": { "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, "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": { "airport.id": 40, "airport.ts": "2017-10-23 21:35:19", "airport.name": "Bordj Mokhtar Airport", "airport.icao": "DATM", "airport.iata": "BMW", "airport.location": "Bordj Mokhtar", "airport.country": "Algeria", "airport.airport_type": "A - Civil", "airport.longitude_or_latitude": "E 000° 55' 33.53\"/N 21° 22' 39.63\"0.925981/21.377675", "airport.elevation": "1302 ft / 396.85 m", "airport.magnetic_variation": "W 1°20.8' (2008-04)", "airport.time_zone": "UTC+1", "airport.country_x_airport_id": { "40": { "country_x_airport.id": 40, "country.id": 3, "country.ts": "2017-10-23 05:02:00", "country.title": "Algeria" } }, "airport.airport_x_airport_communication_id": { "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": "" } }, "airport.airport_x_remark_id": { "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." } }, "airport.airport_x_runway_information_id": { "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, "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": "" } } } } } }