You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
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": ""
}
} |
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 |