Context

The dataset contains flights of various Philippine carrier flights from Jan 01, 2018 onwards extracted from https://openskynetwork.github.io/opensky-api/rest.html

PH Airlines ICAO codes

• CEB- Cebu Pacific
• PAL- Phiippine Airlines
• APG- Philippine AirAsia
• ATX- Air Swift
• BIC- Alphaland Aviation
• SRQ- CebGo
• GAP- PAL Express
• RYL- Royal Air Philippines
• MSJ- SkyJet
• WCC- Sky Pasada
• SEA- Sunlight Air
• SOY- Island Aviation Inc.
• PFR- Pacific Air
• SGD- SEAir International
• AMM- MET Express Air Corp.
• BOI- 2GO
• PHP- PSI Air 2007

The list of Philippine carriers can be seen here

Field meaning

• icao24: str - Unique ICAO 24-bit address of the transponder in hex string representation. All letters are lower case.
• firstSeen: int - Estimated time of departure for the flight as Unix time (seconds since epoch).
• estDepartureAirport: str - ICAO code of the estimated departure airport. Can be null if the airport could not be identified.
• lastSeen: int - Estimated time of arrival for the flight as Unix time (seconds since epoch).
• estArrivalAirport: str - ICAO code of the estimated arrival airport. Can be null if the airport could not be identified.
• callsign: str - Callsign of the vehicle (8 chars). Can be null if no callsign has been received. If the vehicle transmits multiple callsigns during the flight, we take the one seen most frequently.
• estDepartureAirportHorizDistance: int - Horizontal distance of the last received airborne position to the estimated departure airport in meters.
• estDepartureAirportVertDistance: int - Vertical distance of the last received airborne position to the estimated departure airport in meters.
• estArrivalAirportHorizDistance: int - Horizontal distance of the last received airborne position to the estimated arrival airport in meters.
• estArrivalAirportVertDistance: int - Vertical distance of the last received airborne position to the estimated arrival airport in meters.
• departureAirportCandidatesCount: int - Number of other possible departure airports. These are airports in short distance to estDepartureAirport.
• arrivalAirportCandidatesCount: int - Number of other possible departure airports.

Data Source

The OpenSky Network, https://opensky-network.org