[Feature] Import from Flighty

[eanmclaughlin]

I have searched the existing feature requests to make sure this is not a duplicate request.

• Yes

The feature

Support import from Flighty.

Flighty exports as a CSV:
FlightyExport-2025-03-16 copy.csv

The Seat Type, Class, and Reason values are these in UPPER_SNAKECASE:

Flighty tracks diversions which is interesting but not currently supported by AirTrail so I think import would just use scheduled destination.

[eanmclaughlin]

I'm down to work on this in some free time over the next week or two

[nikdoof]

I did make another post before properly searching, here is the layout of the CSV based on my data.

Fields

• Date - YYYY-MM-DD
• Airline - String ICAO
• Flight - Integer
• From - IATA 3 Letter
• To - IATA 3 Letter
• Dep Terminal - String / Null
• Dep Gate - String / Null
• Arr Terminal - String / Null
• Arr Gate - String / Null
• Canceled - Boolean
• Diverted To - String / Null
• Gate Departure (Scheduled) - ISO 8601
• Gate Departure (Actual) - ISO 8601 / Null
• Take off (Scheduled) - ISO 8601 / Null
• Take off (Actual) - ISO 8601 / Null
• Landing (Scheduled) - ISO 8601 / Null
• Landing (Actual) - ISO 8601 / Null
• Gate Arrival (Scheduled) - ISO 8601 / Null
• Aircraft Type Name - String
• Tail Number - String
• PNR - String / Null
• Seat - String / Null
• Seat Type - WINDOW/AISLE/MIDDLE/Null
• Cabin - ECONOMY/BUSINESS
• Flight Reason - LEISURE/BUSINESS
• Notes - String / Null
• Flight Flighty ID - UUID
• Airline Flighty ID - UUID
• Departure Airport Flighty ID - UUID
• Arrival Airport Flighty ID - UUID
• Diverted To Airport Flighty ID - UUID
• Aircraft Type Flighty ID - UUID

[nikdoof]

To scratch my own itch I made a dumb importer script: https://gist.github.com/nikdoof/9d2c64975bd980e9080969ae18180b14

This will cover me until official support

[conchyliculture]

Wish I stumbled on your code earlier

Here's my version, which converts a Flighty CSV to a AirTrail JSON:

https://github.com/conchyliculture/flight_stuff/blob/main/flighty2airtrail.rb

[johanohly]

This has been added in v3.0.0!

[eanmclaughlin]

Obviously I never got around to working on this but thrilled that you got it implemented and released! Thank you!