AeroLogix

AeroLogix is a digital flight logbook built for pilots and flight simulator enthusiasts who want something better than a spreadsheet or a paper logbook. The app stores both planned and actual flight data, so you can compare what you filed versus what actually happened, including departure delays, real flight duration, and any remarks from the flight.

It also ships with a full airport reference database sourced from OurAirports, covering identifiers, locations, runway surfaces, and lengths for airports worldwide. This means you can look up any airport before planning a leg, rather than keeping a separate reference document open.

• Browse a worldwide airport directory with runway details pulled from the OurAirports public dataset
• Add and manage aircraft records by registration, model, and notes
• Add and manage crew members with their roles
• Plan flights with multiple airports, crew assignments, and scheduled times
• Log completed flights with actual departure and arrival times
• Search and filter your flight log by date, aircraft, airport, or crew member
• Summary reports: total flight time by month, by aircraft, and most visited airports
• Export your full flight log to CSV

The database is built on SQLite and organized around two types of data. Reference data, imported from the OurAirports public dataset, covers airports, runways, countries, and regions. Operational data is everything the user enters: aircraft, crew, flight plans, and completed flight records.

Two many-to-many relationships drive the core logic. A flight can involve multiple crew members across different roles, and a single flight can pass through multiple airports (departure, arrival, alternates) in a defined sequence. Junction tables handle both relationships cleanly, keeping the schema normalized and queries straightforward.

All queries are written in raw SQL, with no ORM layer hiding what is happening under the hood.