Flighty To HTML

This script will convert a Flighty csv flight log, into a nice HTML table. Airport codes will also link to FlightRadar24 for info on that airport.

Date	Airline	Flight	Route	Aircraft Type Name	Tail Number
2025-05-13	Delta	2780	DAL ✈ ATL	Boeing 717-200	N955AT
2025-05-10	Delta	2711	BWI ✈ ATL	Boeing 757-200	N6704Z
2025-03-25	Southwest	3548	IAD ✈ DEN	Boeing 737-700	N213WN
2025-01-12	Southwest	1893	DEN ✈ BWI	Boeing 737-700	N954WN
2022-09-24	Spirit	1435	ATL ✈ BWI	Airbus A321	N671NK

It will also output a simple stats tables

Flights	Airports	Airlines	Aircraft
26	12	2	4

Usage

1. Export your Flighty flight log, and save it to your computer.

2. Run ./flights.sh <PATH TO FLIGHT LOG>

3. Use the HTML tables however you want.

Exporting Flighty Log

1. Click on your profile picture.

2. Click Setting.

3. Scroll down and click Account Data.

4. Click Export Your Flights.

5. Enter your email.

6. Save the log from the email from Flighty.

Adding Airlines

To add extra airline names, add both the ICAO code (its in the flights log), and the Airline name to the awk section of the script. For example, to add Air Koryo, do the following.

1. Look for the folowing section in the script.

airline["SWA"] = "Southwest";
airline["DAL"] = "Delta";
airline["NKS"] = "Spirit";

2. Add the wanted airline.

airline["SWA"] = "Southwest";
airline["DAL"] = "Delta";
airline["NKS"] = "Spirit";
airline["KOR"] = "Air Koryo";

3. (optinal) Question why you flew on Air Koryo.

Fun Extra

You can add little airline logos to the airline names if you want. Here is an example.

airline["SWA"] = "Southwest <img src='/assets/ali/swa.png' width='16'/>";
airline["DAL"] = "Delta <img src='/assets/ali/dal.png' width='16'/>";
airline["NKS"] = "Spirit <img src='/assets/ali/nks.png' width='16'/>";