To assist you in understanding each field within the ForeFlight Logbook Template, here are formatting notes for the fields:
IMPORTANT: To ensure importation without errors, don't remove columns and fields in the ForeFlight Logbook Template. For instructions on how to add custom fields, refer to the following article: How do I create custom logbook fields in my logbook spreadsheet template?
AIRCRAFT TABLE FORMATTING
FIELD | FORMATTING NOTES |
AircraftID | The aircraft’s registration, or “tail number.” Example: N201TH |
EquipmentType | The type of equipment (aircraft or simulator) used for flight. Use one of the following: aircraft, ffs, ftd, aatd, batd. If this field is left blank, ‘aircraft’ will be used. |
TypeCode | This is the aircraft's ATC flight plan code. Usually, four characters. Example: Piper Archer = P28A. Find your aircraft's code here. |
Year | YYYY format. Example: 1997 |
Make | The manufacturer of the aircraft. Example: Cessna |
Model | The aircraft’s model name. Example: 172 |
Category | Use one of the following: Airplane, Rotorcraft, Glider, Lighter Than Air, Powered Lift, Powered Parachute, Weight-Shift-Control, Simulator. The aircraft’s “Class” field must correlate to this field. |
Class | Use one of the following codes: ASEL (Airplane Single Engine Land), AMEL (Airplane Multi Engine Land), ASES (Airplane Single Engine Sea), AMES (Airplane Multi-Engine Sea), RH (Rotorcraft Helicopter), RG (Rotorcraft Gyroplane), Glider, LA (Lighter Than Air Airship), LB (Lighter Than Air Balloon), Powered Lift, PL (Powered Parachute Land), PS (Powered Parachute Sea), WL (Weight Shift Control Land), WS (Weight Shift Control Sea), FFS (Full Flight Simulator), FTD (Flight Training Device), ATD (Aviation Training Device) |
GearType | Use one of the following codes: AM (Amphibian), FC (Fixed Tailwheel), FT (Fixed Tricycle), RC (Retractable Tailwheel), RT (Retractable Tricycle), Floats, Skids. |
EngineType | Choose from: Diesel, Electric, Non-Powered, Piston, Radial, Turbofan, Turbojet, Turboprop, Turboshaft |
Complex | This is a true or false field. We suggest a simple ‘x’ if the airplane is complex. |
HighPerformance | This is a true or false field. We suggest a simple ‘x’ if the airplane is high-performance. |
Pressurized | This is a true or false field. We suggest a simple ‘x’ if the airplane is pressurized. |
TAA | This is a true or false (Boolean) field. We suggest a simple 'x' if the aircraft is a technically advanced aircraft. |
FLIGHT TABLE FORMATTING
FIELD | FORMATTING NOTES |
---|---|
Date | The date of the flight in YYYY-MM-DD format. Example: 2002-01-02 |
AircraftID | The aircraft’s registration or “tail number.” Example: N201TH |
From | The code for the departure airport. Example: KBVU |
To | The code for the destination airport. Example: KVGT |
Route | The points between departure and destination separated by a space. Example: KCDC 67L |
TimeOut | Hours and minutes in 24-hour format. Example: 1823 |
TimeOff | Hours and minutes in 24-hour format. Example: 1823 |
TimeOn | Hours and minutes in 24-hour format. Example: 2137 |
TimeIn | Hours and minutes in 24-hour format. Example: 2137 |
OnDuty | Hours and minutes in 24-hour format. Example: 1700 |
OffDuty | Hours and minutes in 24-hour format. Example: 2200 |
TotalTime | Duration of flight in decimal format. Example: 3.6 |
PIC | Duration in decimal format or in hours and minutes (HH:MM) format. Example: 3.6 (Decimal format) or 03:36 (HH:MM format) |
SIC | Duration in decimal format or in hours and minutes (HH:MM) format. Example: 0.0 (Decimal format) or 00:00 (HH:MM format) |
Night | Duration in decimal format or in hours and minutes (HH:MM) format. Example: 1.2 (Decimal format) or 01:12 (HH:MM format) |
Solo | Duration in decimal format or in hours and minutes (HH:MM) format. Example: 3.6 (Decimal format) or 03:36 (HH:MM format) |
CrossCountry | Duration in decimal format or in hours and minutes (HH:MM) format. Example: 5.4 (Decimal format) or 05:24 (HH:MM format) |
NVG | Duration in decimal format. Example: 1.1 |
NVGOps | A whole number. Example: 3 |
Distance | Nautical miles in decimal format: Example: 135.0. You have the option to use this field to track a total route distance or the distance to the furthest landing for training purposes. Whichever you choose, be consistent on all entries. |
DayTakeoffs | A whole number. Example: 2 |
DayLandingsFullStop | A whole number. Example: 2 |
NightTakeoffs | A whole number. Example: 1 |
NightLandingsFullStop | A whole number. Example: 1 |
AllLandings | The total number of landings. Example: 3 |
ActualInstrument | Duration in actual IMC in decimal format or in hours and minutes (HH:MM) format. Example: 3.6 (Decimal format) or 03:36 (HH:MM format) |
SimulatedInstrument | Duration with a view limiting device, or "hood" in decimal format or in hours and minutes (HH:MM) format. Example: 3.6 (Decimal format) or 03:36 (HH:MM format) |
HobbsStart | Aircraft Hobbs reading at the beginning of flight: Example: 250.4 |
HobbsEnd | Aircraft Hobbs reading at end of flight: Example: 255.2 |
TachStart | Aircraft tachometer reading at the beginning of flight: Example: 200.15 |
TachEnd | Aircraft tachometer reading at end of flight: Example: 204.42 |
Holds | A whole number. Example: 1 |
Approach1,2,... | The approach(es) you flew, with details separated by semicolons. The format expected is #;type;runway;airport;comments Choose from the following approach types: ASR/SRA, Circle, GCA, GLS, ILS, ILS CAT II, ILS CAT III, LDA, LOC, LOC BC, MLS, NDB, PAR, RNAV (GPS), RNAV (RNP), SDF, TACAN, VOR. Example: 1;ILS;12L;KVGT;Broke out at 350 AGL. Example: 2;ILS OR LOC RWY 18L;18L;KAUS; testing circle to land;CIRCLE. Example without comment: 2;ILS OR LOC RWY 18L;18L;KAUS;;CIRCLE. |
DualGiven | Flight instruction you provide in decimal format or in hours and minutes (HH:MM) format. Example: 3.6 (Decimal format) or 03:36 (HH:MM format) |
DualReceived | Flight instructions provided to you in decimal format or in hours and minutes (HH:MM) format. Example: 3.6 (Decimal format) or 03:36 (HH:MM format) |
SimulatedFlight | Simulator time in decimal format or in hours and minutes (HH:MM) format. Example: 3.3 (Decimal format) or 03:18 (HH:MM format) |
GroundTraining | Ground training you received in decimal format or in hours and minutes (HH:MM) format. Example: 0.8 (Decimal format) or 00:48 (HH:MM format) |
InstructorName | First and last name. Example: Mark Wallace |
InstructorComments | Your instructor’s notes on the event: Example: “BAI, Unusual Attitudes, IFR lost comm procedures.” These may also be placed in the “PilotComments” field if you choose. |
Person1,2,... | Other people on board the aircraft with their role for that flight. The expected format is Name;Role;Email. Choose from the following roles: Instructor, Student, Passenger, PIC, SIC, Safety Pilot, Flight Attendant, Flight Engineer, First Officer, Second Officer, Examiner. Example: Robert Hale;Student;Bob@example.com |
FlightReview | This is a true or false field. We suggest a simple ‘x’ if a flight review was conducted. |
CheckRide | This is a true or false field. We suggest a simple ‘x’ if a successful checkride occurred. |
IPC | This is a true or false field. We suggest a simple ‘x’ if an instrument proficiency check was conducted. |
NVGProficiency |
This is a true or false (Boolean) field. We suggest a simple 'x' if an NVG Proficiency check was conducted. |
FAA6158 | This is a true or false (Boolean) field. We suggest a simple 'x' if the flight qualifies under FAA 61.58 |
CustomFields | Custom Fields: If you need to carry over any custom fields, change the name and type of that field as appropriate. Choose from the following field types: Text, Numeric, Hours, Counter, Date, DateTime, or Toggle. Format: [FieldType]CustomFieldName. Example: [Hours]JumpPilot. |
PilotComments | This is a standard text field where you can place the contents of “Comments,” “Remarks,” or other similar fields from your logbook. Example “Instrument checkride - PASSED!” |
Last Updated:
Was this article helpful?