Build guide
Airline Pilots, Copilots, and Flight Engineers OS
Airline Pilots, Copilots, and Flight Engineers OS: recency & currency and roster & duty hours, connected to trips & logbook, vehicles & equipment and maintenance & defects - calculations, views and example rows already set up.
For: Pilots, drivers, captains, dispatchers, logistics coordinators, rail and marine crew
- Linked databases
- 7
- Connections
- 4
- Automatic calculations
- 10
- Ready-made views
- 15
What it saves you
- Landings, night landings and sim checks - 90-day currency is calculated so you never fly out of currency.
- Duty periods with report and off-duty times - duty hours and rolling 28-day totals stay inside flight-time limits.
- Hours, distance and trip count roll up per vehicle or aircraft
- Next service is calculated from the last service and interval
- Licences, ratings and medicals count down to expiry
- Reimbursable expenses total per trip and are listed until paid
How the parts work together
- After each trip: Log the trip with hours and distance → Record defects found → Add expenses with receipts
- Monthly: Check "Service due" and "Renew soon" → Submit everything in "To claim"
Databases inside
Trips & Logbook
Each flight, drive, voyage or delivery run with route, duration and distance - your logbook and activity record.
10 fields · linked to Vehicles & Equipment, Expenses, Roster & Duty Hours
Views: Logbook, Roster, Last 30 days
Vehicles & Equipment
Aircraft, trucks, vans or vessels with odometer or hours. Usage rolls up from trips and the next service date is calculated.
9 fields · 5 calculated automatically · linked to Trips & Logbook, Maintenance & Defects
Views: Fleet, Service due
Maintenance & Defects
Defects found and work done per vehicle, with cost and whether it is safe to operate.
6 fields · linked to Vehicles & Equipment
Views: Open defects, History
Licences & Medicals
Licences, ratings, medicals, passports and permits with expiry dates counting down.
6 fields · 2 calculated automatically
Views: Renew soon, All documents
Expenses
Meals, fuel, tolls and hotels per trip with receipts, tracked until reimbursed.
7 fields · linked to Trips & Logbook
Views: To claim, By category
Recency & Currency
Landings, night landings and sim checks - 90-day currency is calculated so you never fly out of currency.
6 fields · 2 calculated automatically
Views: Lapsing soon, All requirements
Roster & Duty Hours
Duty periods with report and off-duty times - duty hours and rolling 28-day totals stay inside flight-time limits.
7 fields · 1 calculated automatically · linked to Trips & Logbook
Views: Roster, Last 28 days
You get the finished workspace, not homework.
Buy it once for $19 or get it with your membership, then duplicate it into Notion with every field, link, formula, view and example row already set up.
See Airline Pilots, Copilots, and Flight Engineers OS →