Skip to content

CSV Import

Jump to bottom
Dave Walker edited this page Dec 10, 2023 · 11 revisions

Aircraft Sightings

  • The following illustrates the format in which sightings are exported
  • It is also the format required for import of sightings from CSV files:
Flight,Airline,Registration,Serial Number,Manufacturer,Type,Age,From,To,Height,Date,Location
"KL713","KLM","PH-BQG","32704","Boeing","777-206(ER)","18","AMS","PBM","34000","08/12/2023","Abingdon"
"KL758","KLM","PH-BKG","42508","Boeing","787-10 Dreamliner","3","PTY","AMS","39000","08/12/2023","Abingdon"
"AC870","Air Canada","C-FNNQ","43251","Boeing","777-333(ER)","9","YUL","CDG","37000","08/12/2023","Abingdon"
"AC872","Air Canada","C-FIUW","35249","Boeing","777-333(ER)","15","YYZ","CDG","35000","08/12/2023","Abingdon"
"NJE372D","NetJets Europe","CS-LAS","680A0015","Cessna","680A Citation Latitude","8","OXF","GVA","29650","08/12/2023","Abingdon"
"U2728","EasyJet","G-EZTH","3953","Airbus","A320-214","13","JER","MAN","30025","08/12/2023","Abingdon"
  • The following fields are optional and may be left blank:
    • Age
    • Serial number
    • Manufacturer
    • Type
  • All other fields are required
  • The "From" and "To" fields specify the IATA codes for the embarkation and destination airports
  • The height is specified in feet
  • The date is specified in DD/MM/YYYY format
  • The year of manufacturer is calculated from the age, that is specified in years
  • It is only stored if the manufacturer and model are also specified
Clone this wiki locally