Latitude 35 Logbook & Ledger - Ultimate Step-by-Step User Manual
Welcome to Latitude 35 Logbook! This guide is written in plain, friendly English to help pilots, aircraft owners, and business accountants navigate and operate every feature in the app.
To get the most out of the system's "smart" automation (such as auto-filling your airports, tracking airworthiness inspections, and managing warnings), we highly recommend following this guide in the sequence below.
π The Golden Path: Your Setup Sequence
If you are a new user, you should set up your data in this specific order. Doing so ensures that when you go to log a flight, all your aircraft, passengers, and smart defaults are ready and waiting!
[1] Register / Log In β [2] Workspace Setup β [3] Passenger Registry β [4] Aircraft Fleet β [5] Log Flights β [6] Squawks & RTS β [7] Compliance & Renewals β [8] Spreadsheets & Reporting
Step 1: Create Your Account & Log In
Before you can record any flight data, you need a secure profile:
- Open the App on your mobile device, tablet, or web browser.
- App Icon: Look for the official Latitude 35 Logbook icon on your home screen or app launcher (featuring the navy-and-gold compass rose, globe latitude lines, and aircraft medallion).
- The landing screen displays Latitude 35 Sign In along with the current app version (e.g.
Ver. 1.0.0) and the subtitle Access your Latitude 35 Logbook Dashboard.
- Instant Login & Enter Key:
- If you have already logged into the app on this device, the system automatically recognizes your session and routes you directly to your Latitude 35 Dashboard without any splash delays.
- On the Web App, you can simply type your password and press the Enter key to sign in immediately.
- New Registration:
- On the landing page, tap Don't have an account? Set up your workspace at the bottom of the card.
- Full Name: (e.g.,
Captain John Doe) - Email Address: (e.g.,
john.doe@example.com) - Password: Must be at least 6 characters long.
- Proceed to Step 2 to configure your workspace.
Step 2: Set Up Your Workspace (Tenant ID)
To keep your logs completely secure and separate from other schools, owners, or charter businesses, our app uses isolated Workspaces (tenants):
- Option A: Create a New Workspace (Default)
- If you are a solo pilot, flight school admin, or corporate flight department setting up for the first time, choose Create New.
- Under New Workspace Name, enter a friendly name (e.g.,
Skyline AviationorMy Personal Logbook). - The app creates a dedicated workspace partition for your fleet and flights.
- Option B: Join an Existing Workspace (Automated Invitation Detection)
- Automated Invitation: If your workspace owner or administrator sent you an invitation, simply enter your invited email address on the registration form. The app automatically recognizes your pending invitation, switches your selection to Join Existing, locks and pre-populates your Workspace ID, and assigns your authorized role (PILOT, ADMIN, MAINTENANCE, or ACCOUNTS).
- Manual Entry: If you have been given a Workspace ID directly, choose Join Existing and paste the ID code into the Existing Workspace ID (Tenant ID) field.
Once you've filled out your details, tap Set Up & Register to enter your Dashboard!
Multi-Workspace Membership & Context Switching
Pilots flying for multiple flight schools or syndicates, mechanics servicing multiple hangars, and accountants auditing separate entities can belong to multiple workspaces under a single user account:
- Switching Workspaces: Tap the interactive Workspace Switcher on your Dashboard profile card. A modal displays all workspaces you belong to, your assigned role in each workspace, and a checkmark on your active workspace. Tap any workspace to instantly switch your fleet, flights, squawks, and passenger records.
- Accepting Invitations as an Existing User: If you already have an account and receive an invitation to another workspace, simply sign in normally. A prominent Workspace Invitation banner appears at the top of your dashboard showing the workspace name, inviting user, and assigned role. Tap Accept & Switch to immediately link the workspace to your account and switch into itβno secondary registration required!
- Creating Additional Workspaces: From the Workspace Switcher, tap + Create New to set up a new flight school or syndicate. You automatically become the OWNER of the new workspace.
- Joining by Workspace ID: From the Workspace Switcher, tap + Join by ID to enter a Tenant ID code and join directly.
π‘ Workspace Member Invitations & Role Authority: Workspace OWNERs and ADMINs can invite team members directly from the Latitude 35 Dashboard by tapping the Invite User button on the profile card. Enter the invitee's email address and assign their role from the dropdown: ADMIN: Full access to fleet management, invitations, airworthiness tracking, and workspace administration. PILOT: Full flight logging, route calculation, passenger manifest selection, and discrepancy reporting. MAINTENANCE: Fleet inspection management, Minimum Equipment List (MEL) items, Return to Service (RTS) sign-off, and FAA 14 CFR Β§ 43.9 release generation. ACCOUNTS: Read-only desktop compliance auditor grid and IRS/tax reporting. The system formats a comprehensive invitation email with workspace details and acceptance instructions, opening your email client with one tap.
Step 3: Populate Your Passenger Registry
Before you can add passengers to a flight manifest, register them in your directory:
- On the dashboard, tap the Passenger Registry card.
- Tap Add Your First Passenger (or tap the + floating action button).
- Fill out passenger profile details:
- Passenger Photo: Tap the camera/gallery icon to take a new photo with your device's camera or choose an existing photo from your gallery. A live square avatar preview will confirm your selection.
- Full Name: Enter their complete legal name (e.g.,
Jane Doe). - Passenger Role & Code: Select from the standardized dropdown:
B - Business(Default)BE - Business EntertainmentPE - Personal EntertainmentPNE - Personal Non EntertainmentT - TrainingM - Maintenance- Compensation Type: Select the applicable tax compensation classification from the dropdown:
TBD(Default)K-1W-21099NoneOther- Date of Birth: (Optional) Tap the calendar date selector to record their birthdate.
- Contact Info: Enter their phone number or email address.
- Weight (lbs): Enter their body weight (for Weight & Balance calculations).
- Tap Save.
- Each passenger appears on a clean card showing their photo avatar, full name, role code and name badge (e.g.,
B β’ Business), compensation classification badge, and weight.
Step 4: Add Your Aircraft Fleet & Inspection Tracking
Every flight must be linked to a specific aircraft in your fleet. Adding an aircraft sets up your airworthiness indicators and maintenance tracking.
4.1 Registering an Aircraft
- On the dashboard, tap the Aircraft Fleet card.
- Tap Add Your First Aircraft (or the + button).
- Aircraft Photo: Tap the photo icon to snap a picture using your device's camera or select one from your gallery.
- Aircraft Profile Details:
- Tail Number: (e.g.,
ZS-ABCorN172SP) β automatically converted to CAPITALS. - Manufacturer & Model: (e.g.,
CESSNA 172S) β Model is automatically capitalized. - Year & Serial Number: Aircraft year of manufacture and airframe serial number.
- Home Airport: Enter the 4-letter ICAO code (e.g.,
FACTorKCLT) β automatically capitalized. - Total Seats: Enter the total number of seats in the aircraft (including pilot seats).
- Tap Save.
4.2 Inspection Tracker (Spreadsheet & Mobile View)
Directly on each aircraft's card, you have access to a dedicated inspection tracking spreadsheet:
- Locate the Inspections button positioned directly underneath the color-coded Airworthiness badge.
- Tap Inspections to open the full-screen Inspection Tracker (
<TAIL> - Inspection Tracker). - Mobile Responsiveness & Horizontal Scrolling:
- On narrow and mobile screens, a dedicated, always-visible horizontal Scrollbar allows smooth scrolling across all columns.
- The header area wraps responsively to prevent overflow on smaller mobile devices.
- The table includes 13 standardized categories sequenced exactly as per FAA compliance standards and the
Insp.csvspecification:
- ARROW Documents: Airworthiness Certificate (
A), Registration Certificate (R), Radio License (R), Operating Limitations (O), Weight and Balance Data (W). - AV1ATES Checks & Routine Maintenance: Annual Inspection (
A), VOR Check (V), 100 Hour Inspection (1), Altimeter/Pitot Static System (A), Transponder (T), ELT (E), Static System (S), and 50-Hour Oil Change and Analysis (50). - Verbatim Column Headings:
Code(Inspection mnemonic)Item(Inspection name)Valid Period(Validity interval, e.g., 12 Months, 100 Hours)Last Inspection (Date or Hours)(Date or meter reading when last performed)Date (Or Hours) of Inspection Required(Date or meter reading when next inspection is due)Days (Or Hours) Left till inspection(Remaining days or hours)Comment(Pilot remarks, squawks, or mechanic sign-off references)Action(Edit row button)
- Interactive Comments:
- Comments are truncated with an ellipsis (
...) in the table to save space. - Desktop/Web: Hovering over a comment displays a tooltip with the complete comment.
- Mobile & Desktop: Tapping any comment cell opens an Inspection Comment dialog displaying the full comment text and an Edit Item button to update the record directly.
- You can update any row, record new inspection dates or tach hours, and tap + Add Item if your aircraft has custom STC or equipment inspections.
- Resetting to the Standard Template:
- If an aircraft was registered before the new inspection checklist was introduced, an alert banner will appear at the top: "This aircraft is still using an earlier checklist configuration. Tap Reset to update it..."
- Tap Reset to New Table (or tap the Reset to Default button next to Add Item, or the restore icon in the top AppBar).
- Confirm the prompt to immediately reset the checklist to the standard 13-row ARROW and AV1ATES template from
Insp.csvand sync changes to Firestore.
4.3 Minimum Equipment List (MEL) & Maintenance Squawks
Directly on each aircraft's card, you have instant access to the regulatory Minimum Equipment List:
- Accessing the MEL:
- Locate the MEL button positioned in the action row of the aircraft card (next to Inspections and View Flight Logs).
- If any equipment items are currently marked inoperative, the button displays a prominent warning badge:
MEL (X INOP)in amber. - Tap MEL to open the full-screen Minimum Equipment List screen (
<TAIL> - Minimum Equipment List).
- Regulatory Categories & Structure (matching
MEL.csv):
- The list is organized under 3 regulatory sub-headings:
- DAYTIME VFR (A TOMATO FLAMES β 13 items): Airspeed Indicator, Tachometer, Oil Pressure Gauge, Manifold Pressure Gauge, Altimeter, Temperature Gauge, Oil Temperature Gauge, Fuel Gauge, Landing Gear Position Light, Anti-Collision Lights (Beacon), Magnetic Compass, ELT, Safety Belts / Shoulder Harnesses.
- NIGHT VFR (FLAPS β 5 items): Fuses (or circuit breakers), Landing Light (if for hire), Anti-Collision Lights (Beacon), Position Lights (NAV Lights), Source of Electricity.
- IFR (GRABCARD β 8 items): Generator or Alternator, Radios (Two-way radio communications), Sensitive Altimeter, Ball (Slip-skid indicator), Clock with sweep-second pointer/digital, Attitude Indicator, Rate of Turn Indicator, Directional Gyro (Heading Indicator).
- Use the horizontal filter chips at the top to filter items by ALL, DAYTIME VFR, NIGHT VFR, IFR, or INOP Only.
- Reporting an Issue / Marking Item as INOP (Triggering a Squawk):
- Should an issue or defect be detected with any equipment item, tap Mark INOP on that item's card.
- A dialog will prompt you to enter the Squawk Description / Defect Details (e.g., "Airspeed pointer erratic, fluctuating 20 kts in cruise").
- Tap Confirm INOP & Trigger Squawk.
- The item's badge immediately updates to a red INOP badge, the squawk description and report date are displayed, and an active Maintenance Issue (Squawk) is registered against the aircraft.
- More than one MEL item may become INOP at the same time.
- Clearing INOP Status / Returning to Operational:
- Once maintenance has rectified the defect, tap Clear INOP on the inoperative item's card.
- Confirm the prompt to clear the squawk and mark the item as OPERATIONAL (green badge).
- Resetting to Default Template:
- Tap the Restore / Reset icon button in the top AppBar to reset the aircraft's MEL back to the standard 26-item checklist from
MEL.csv.
- Logging Squawks from the Flight Logbook:
- Pilots can log maintenance squawks directly while entering or reviewing flight logs without having to manually locate the aircraft in Fleet Management first. Tapping Log Squawk on any flight card or within the flight entry/edit screen immediately opens this MEL screen for that flight's aircraft (see Section 5.4).
4.4 Viewing Aircraft-Specific Flight Logs
- Below the Inspections button, tap View Flight Logs.
- This instantly opens the logbook filtered exclusively to that tail number, showing that aircraft's specific flight history and dedicated total flight hours!
- Directly below the "View Flight Logs" button, use the Edit and Delete icon buttons to update the aircraft profile or retire it from the fleet.
Step 5: Log a Flight (Smart Entry & Lifecycle)
Logging flights is streamlined with smart pre-population, validation, and a complete pre-flight draft to final closure workflow:
5.1 Route of Flight & Smart Airport Defaults
- From the dashboard, tap Flight Logbook β Record Your First Flight (or +).
- Select Aircraft: Choose your plane from the dropdown.
- π Smart Departure: The moment you select an aircraft, the Departure (From) airport automatically pre-populates with the destination of that aircraft's previous flight! (If it's the aircraft's very first flight, it defaults to its home airport).
- β οΈ Real-Time Squawk Status Indication: Immediately after selecting an aircraft, the form indicates whether there are any active squawks:
- Active Squawks Detected (Amber Warning Card): If any equipment items are currently marked inoperative, an amber alert box appears directly below the dropdown. It shows the number of INOP items (e.g.,
Active Squawks Detected (2 INOP)), an advisory prompt to check flight eligibility, an itemized list of each inoperative item (equipment name, regulatory category, defect squawk notes, and date reported), and a direct View MEL button. - No Active Squawks (Green Operational Banner): If all equipment items are functional, a green badge confirms
No Active Squawks β All 26 Minimum Equipment List (MEL) items are operational for <TAIL>.
- Searchable Destination Dropdown:
- Tap the Destination (To) field. It searches our nationwide airport directory in real time, pre-seeded with 5,935+ airports spanning all 50 US states, Washington D.C., US territories, published private and public airfields on US Sectional Aeronautical Charts (e.g.,
2NC0,PA88), and international hubs. - You can type any airport code (e.g.,
KDEN,KORD,KLAX,2NC0), airport name (e.g.,Denver,O'Hare,Mountain Air), city, or 2-letter state code (e.g.,TX,CA,FL,NC) with multi-tiered relevance scoring to instantly filter matching airports! - + Add New Airport: If your destination airfield is an unlisted private strip or rural airstrip, tap + Add New Airport at the top of the list to register its Code, Name, City, State/Province, and Country. Once saved, it becomes immediately available in your workspace and to all other pilots!
- Quick-Pick Suggestion Chips:
- Directly beneath the Destination field, the app displays quick-pick chips for the last 4 airports visited by your fleet (excluding the current departure airport). Tap any chip to instantly set your destination with a single touch!
- Regulatory Flight Purpose:
- Choose the precise flight purpose from the dropdown:
BusinessTrainingInvestmentMaintenanceIncidental StopPersonal (Entertainment)Personal (Non-Entertainment)CharityCommutingCommuting/EntertainmentTaxable Biz. Entertainment
- Flight Details for Tax & Audit Justification (DESIGN.md 2.5.1.2):
- Positioned directly below the Flight Purpose dropdown, enter comprehensive contextual explanations supporting business and tax deductions in the event of an audit by tax authorities (IRS) or insurers.
- Record specific details such as project discussions, client names, job site locations, or contractor appointments.
- This narrative appears on the flight cards, in the flight viewer, and is formatted into Column L of the 20-Column Aircraft Flight Record.
- Charter, 3rd Party Lease & Reposition Classifications (DESIGN.md 5.1.1):
- Charter / Third Party Lease / Neither: Select
'N'(Neither - default),'C'(Charter), or'L'(Third Party Lease). - Reposition Flight: Select
'N'(No - default) or'Y'(Yes) if the aircraft is being repositioned without paying passengers.
5.2 Meters Log (Hobbs, Tach, Distance & Fuel)
The compact Meters Log card places Hobbs and Tachometer side-by-side to minimize scrolling, with additional flight metrics directly below:
- Airframe (Hobbs):
- Start Hobbs: Automatically pre-populated from the aircraft's last recorded ending Hobbs reading!
- End Hobbs: Enter your reading at engine shutdown.
- Total Hobbs: Computed and displayed automatically in real-time as you type (
End - Start). - Engine (Tachometer):
- Start Tach: Automatically pre-populated from the aircraft's last recorded ending Tach reading!
- End Tach: Enter your reading at engine shutdown.
- Total Tach: Computed and displayed automatically in real-time as you type (
End - Start). - Additional Flight Metrics:
- Distance of Flight: Enter the total flight distance covered (e.g., in nautical miles).
- Fuel Consumed: Enter the total amount of fuel burned during the flight (e.g., in gallons).
- β οΈ Built-in Error Checking: The app ensures ending meters cannot be less than starting meters, preventing accidental transposition errors.
5.3 Passenger Manifest, Aircraft Seat Capacity & On-the-Fly Passenger Registration
- Selecting Registered Passengers: Select passengers from the Add Passenger to Manifest dropdown. Each entry displays full name, role badge, and compensation type badge.
- On-the-Fly Passenger Registration: If a passenger is not already in your directory when logging or editing a flight, you do not need to leave the screen or lose flight form progress:
- + Register New Passenger Button: Tap the blue
+ Register New Passengerbutton located directly above the dropdown. - Dropdown Shortcut: Alternatively, open the dropdown and tap
+ Register New Passenger...at the top of the list. - Empty Directory Shortcut: If your directory has no passengers yet, tap the
Register Passengeraction button inside the manifest card. - Registration Dialog: Enter the passenger's Full Name (required), Contact Info, Weight, Role, Compensation Type, Date of Birth, and photo (via device camera or photo library). Once saved, the passenger is immediately stored in your tenant database and automatically added to your current flight manifest (if seats are available)!
- Seat Capacity Enforcement: The app calculates passenger seat capacity as
Total Aircraft Seats - 1(reserving one seat for the Pilot in Command). A real-time seat counter (e.g.,Seats: 2 / 3) indicates utilization. If you reach maximum capacity (Seats: 3 / 3 (Full)), the dropdown is locked and the app prevents adding excess passengers. - Removing a Passenger: To remove a passenger from the flight manifest, simply tap the trash/remove icon next to their name.
5.4 Comments, Instructor Endorsement & Logging Maintenance Squawks
- Comments & Remarks: Enter any pilot remarks, route notes, or operational comments under the Comments & Squawks card.
- Logging a Squawk Before, During, or After Flight:
- A pilot will normally log a maintenance squawk before, during, or after a flight directly from the flight logging workflow.
- From the Flight Card (Ledger): On the Logbook Ledger, both Draft and Final flight cards provide a Squawks button. Tapping it navigates immediately to the aircraft's Squawks & Maintenance ledger (
AircraftSquawksScreen). - From the Flight Entry / Edit Screen:
- Inside the Comments card, tap the Squawks button in the card header (styled identically to the Aircraft Details card) to open
AircraftSquawksScreen. - Logging or Deferring a Discrepancy: Navigating to
AircraftSquawksScreenallows you to log a full maintenance squawk across 9 aircraft systems or review open discrepancies. Tapping MEL opens the aircraft's MEL screen to mark equipment INOP. - Returning to the flight log automatically refreshes the aircraft data.
- (Optional) If flying dual instruction, enter your flight instructor's name under Endorsement.
5.5 The Flight Lifecycle: Draft vs. Final
- Saving as Draft (Pre-Flight):
- Before takeoff, you can create the flight record with the aircraft, route, starting meters, and passenger manifest, and tap Log This Flight.
- The flight is saved with a yellow Draft status badge.
- Updating a Draft (Post-Flight):
- After engine shutdown, open your flight list, locate your draft flight card, and tap Edit Log.
- Enter your ending Hobbs and Tachometer meter readings and any landing comments, then tap Update Flight.
- Marking as Final (Closing the Record):
- On the flight card, tap Mark as Final.
- The app runs an automated completeness check (
validateForFinal) verifying that destination airport, ending meters, and valid durations are all present. - Once confirmed, the flight transitions to a green Final status badge.
- Viewing Finalized Flights (Read-Only Protection):
- Finalized flights cannot be accidentally edited or altered.
- Final flight cards feature a View Log button. Tapping it opens the flight record in a protected Read-Only Mode displaying a closure banner, allowing you to review all details without modifying historical compliance data.
- Reopening a Finalized Flight as Draft (Auditor Corrections):
- If an auditor, tax accountant, or flight lead identifies adjustments needed on a finalized flight, you can easily reopen it.
- From the Flight Card: Tap the Revert to Draft button (alongside View Log). Confirm the prompt to reopen the record; it immediately switches to a yellow Draft badge with Edit Log and Mark as Final buttons.
- From the Read-Only Viewer: Inside the viewer, tap Revert to Draft to Edit directly beneath the closure notice banner. Upon confirmation, the form immediately unlocks into active edit mode so you can make your adjustments on the spot without leaving the screen.
- Once your edits are finished, you can update the draft or re-finalize the log!
5.6 Flight Card Format
Each flight card on the ledger features a clean two-column layout:
- Left Column: Flight sequence number (
FLIGHT #), route (FROM β TO), aircraft tail number, purpose badge, Hobbs & Tachometer meter breakdowns, and passenger manifest chips. - Right Column: Flight date, status badge (
DraftorFinal), action buttons (Edit Log,Mark as Final, andSquawksfor drafts;Revert to Draft,View Log, andSquawksfor finalized logs), and the delete button positioned directly below.
Step 6: Managing Maintenance Squawks & Return to Service (RTS)
The app features a comprehensive, FAA-compliant Squawk Management, Deferral, and Return to Service (RTS) lifecycle. Discrepancies are not limited to Minimum Equipment List (MEL) itemsβthey cover all mechanical, powerplant, avionics, electrical, and airframe squawks.
6.1 Three-Tier Severity Classification
Every reported squawk is classified into one of three regulatory severity levels:
- π΄ AOG (Aircraft On Ground): Critical safety defect or open Airworthiness Directive that renders the aircraft unairworthy. Submitting an AOG squawk immediately grounds the aircraft fleet and activates an automated dispatch interlock that blocks pilots from finalizing flight logs.
- π‘ Deferrable (MEL / 14 CFR Β§ 91.213): Equipment permitted to be inoperative under 14 CFR Β§ 91.213(d) or an approved MEL. Requires verification that a physical INOP placard has been installed in the cockpit and allows recording operational flight restrictions.
- π’ Minor (Monitor): Non-grounding observational or cosmetic discrepancies (e.g., dome light flicker) tracked for rectification during the next scheduled 50-hour or 100-hour inspection.
6.2 Reporting a Maintenance Squawk
You can report a squawk from multiple places in the app:
- From the Aircraft Fleet Screen: Tap the Squawks button on any aircraft card, then tap Log Squawk (or the + icon in the top AppBar).
- From the Flight Logbook Ledger: Tap the Squawks button directly on any flight card.
- From Inside the Flight Entry / Edit Form: Tap Squawks inside the Comments header to open the squawks ledger.
- Fill out the Discrepancy Details:
- Affected Aircraft System: Select from 9 standardized systems: Engine & Powerplant, Propeller, Airframe & Structure, Avionics & Communications, Instruments & MEL, Electrical, Fuel System, Landing Gear & Brakes, or Flight Controls.
- MEL Item Picker: If the defect involves instruments or equipment, optionally link it directly to one of the 26 standard Minimum Equipment List items.
- Airworthiness Severity: Select AOG Grounded, Deferrable, or Minor.
- Cockpit Placard Confirmation: For deferrable items, check the box confirming: "Physical 'INOP' placard installed in cockpit per FAA 14 CFR Β§ 91.213(d)".
- Operational Restrictions: Record any flight limitations (e.g., "Day VFR only", "Unpressurized flight only").
- Defect Description: Describe the defect, erratic instrument behavior, or unusual engine readings in detail.
- Attach Photos: Tap Camera or Gallery to capture and attach photographic evidence.
- Tap Submit Squawk.
6.3 Aircraft Squawks Dashboard (AircraftSquawksScreen)
Tapping the Squawks button on any aircraft card opens its dedicated maintenance dashboard:
- Summary Banner: Instantly shows whether the aircraft is grounded, the count of active squawks, or confirms all components are fully operational.
- Filter Chips: Filter discrepancies by All, AOG, Open, Deferred, or Closed.
- Detailed Cards: Each card displays the reporting pilot's name, date reported, defect description, system category, regulatory placard badge (
PLACARDED INOP (14 CFR 91.213)), and any operational restrictions.
6.4 Mechanic Return to Service (RTS) Sign-Off (FAA AC 120-78A)
Once maintenance work or component replacement is completed, a certified mechanic must legally close the discrepancy:
- On the active squawk card, tap Return to Service (RTS).
- Corrective Action Taken: Describe the maintenance procedure performed, replacement part numbers, and functional test results.
- Mechanic Identification: Enter the mechanic's full legal name and FAA certificate number (e.g.,
A&P 3849201orIA 2940182). - Meter Readings: Record the aircraft Hobbs and Tachometer meter readings at the time of sign-off.
- Digital Signature Canvas: The mechanic signs their legal signature directly on the touchscreen or using a stylus, conforming to FAA Advisory Circular AC 120-78A standards for electronic maintenance signatures.
- FAA Regulatory Statement: The dialog enforces the required 14 CFR Β§ 43.9 declaration:
> "The aircraft and/or component identified above was repaired and inspected in accordance with current regulations of the Federal Aviation Administration and is approved for return to service."
- Tap Sign & Return to Service. The squawk is officially closed and logged into historical records.
- Offline Hangar Guarantee: If working inside a metal hangar without Wi-Fi or cellular service, the digital signature and RTS resolution are cached locally on device and automatically synchronized once network connectivity resumes!
6.5 Printing FAA Maintenance Release Certificates (PDF)
For physical aircraft binders and airworthiness compliance audits:
- On any closed squawk card, tap PDF Release.
- The app generates an official client-side 8.5x11 FAA Maintenance Release Document with your organization's letterhead, aircraft registration, complete discrepancy record, corrective maintenance description, meter readings, and the mechanic's digital signature.
- Print directly to any wireless AirPrint/Mopria printer or share via email and cloud storage.
6.6 Pre-Flight Grounding Interlock (Safety Assurance)
- If an aircraft has an open AOG squawk or is marked Grounded, selecting it in the Flight Entry / Edit Form displays a prominent red AOG Grounding Banner.
- Should a user attempt to tap Finalize Log on a flight associated with a grounded aircraft, the app displays a blocking alert:
> "Cannot finalize flight: <TAIL> is Grounded (AOG). Resolve critical squawks before Return to Service."
- This programmatic interlock ensures complete compliance with FAA dispatch limitations.
π’ Understanding Aircraft Airworthiness Status Lights
When browsing your Aircraft Fleet, each plane displays an instant color-coded airworthiness badge:
- π’ Green ("AIRWORTHY"): All maintenance inspections and tachometer limits are fully up to date.
- π‘ Yellow ("WARNING"): An inspection is approaching its due date or meter limit:
- Calendar checks (Annual, Pitot-Static): Within 30 days of expiration.
- 100-Hour check: Tachometer is within 10 hours of the due limit.
- Action: Schedule maintenance soon to prevent grounding.
- π΄ Red ("GROUNDED"): An inspection has expired or the tachometer has exceeded the threshold.
- Action: The aircraft is legally grounded until maintenance is performed and the inspection record is updated in the app.
Step 7: Fleet Compliance & Renewals Tracker (DESIGN.md Section 6)
Aviation operations involve dozens of recurring agreements, databases, licenses, applications, and memberships across both aircraft avionics and individual flight crew. The Compliance & Renewals module provides complete lifecycle tracking, proactive renewal countdowns, cost summaries, and audit reporting without triggering In-App Purchase flags.
7.1 Accessing the Renewals Module
- On the Latitude 35 Dashboard, locate the Renewals button positioned directly to the right of the Users Report button in the header card (available on both desktop and mobile layouts).
- Proactive Notification Badge: If any renewal or database update is overdue or due within 30 days, the button renders an amber badge displaying the count of items requiring immediate attention (e.g.
Renewals [ 1 ]).
7.2 Financial & Compliance Metrics Overview
At the top of the Compliance & Renewals screen, four dynamic metric cards provide an instant executive summary:
- Total Annual Cost: Automatically calculated sum of recurring annual costs across all renewals and agreements.
- Current / Up-to-Date: Count of all compliant, active items.
- Action Required: Real-time count of overdue or due-soon items needing immediate renewal or data loading.
- Fleet vs. Crew Breakdown: Split count between Aircraft avionics and Pilot applications/memberships.
7.3 Filter Tabs
Quickly filter your renewals list using the category tabs:
- All: Displays the complete registry sequenced chronologically.
- Aircraft: Filters strictly to aircraft-specific avionics databases, chart subscriptions, and airframe services.
- Pilot: Filters to pilot-specific electronic flight bags (ForeFlight), memberships (AOPA), and certifications.
- Action Required: Instantly isolates items that are overdue or due within 30 days.
7.4 Adding or Editing a Renewal Record (Comprehensive Tooltip Guidance)
Tap + Add Renewal in the AppBar to open the registration dialog. Every field provides both an interactive ? tooltip and inline helper text directing the user on what data is expected:
- Category (AC - Pilot):
- Tooltip & Helper: Select whether the renewal belongs to an Aircraft (e.g. NavData, Charts, SiriusXM) or an individual Pilot (e.g. ForeFlight, Memberships, Medical).
- Item Name / Title:
- Tooltip & Helper: Enter the specific title of the agreement, database, or membership (e.g.,
ForeFlight Performance Plus,Jeppesen NavData + Garmin Aeronautical Data,Garmin GI 275 Database Bundle).
- Assigned To (Tail # or Pilot Name):
- Tooltip & Helper: Tail number (e.g.,
N172SP) or pilot display name (e.g.,Captain Brian) provisioned for this item.
- Next Update Required Date (AIRAC & Renewal Cycles):
- Tooltip & Helper: The critical date when the next database cycle update (e.g. 28-day AIRAC cycle), renewal, or payment is required.
- Quick Cycle Increment Chips: Tap
+28d AIRAC Cycle,+1 Month, or+1 Yeardirectly beneath the date picker to rapidly advance cycle dates upon completion!
- Valid Period / Expiration:
- Tooltip & Helper: The overall contractual agreement validity interval or expiration date (e.g.,
12 Months,7/27/27,Annual Cycle).
- Cost ($):
- Tooltip & Helper: Recurring cost in USD (e.g.
390.00).
- Billing Cycle:
- Tooltip & Helper: Select renewal frequency:
Annual,Monthly,28-Day Cycle(Aviation AIRAC database cycle),Quarterly, orOne-time.
- Provider / Vendor:
- Tooltip & Helper: Vendor or organization providing the service (e.g.,
Jeppesen,Garmin,ForeFlight,SiriusXM,AOPA,FAA).
- Notes & Account Info:
- Tooltip & Helper: Record system IDs, account numbers, login portal links, and administrative remarks.
7.5 One-Tap Update Cycle & Maintenance
- Mark Updated (Next Cycle): Directly on each renewal card, tap Mark Updated (Next Cycle) to roll the update date forward by its defined interval (e.g., advancing 28 days for NavData or 1 year for annual agreements) with a single tap.
- Edit & Delete: Update cost, provider details, or remove retired records using the edit and trash actions.
- Clean Slate (Zero Preloaded Clutter): When opening a new workspace, the app presents a clean empty state with a "+ Add First Renewal" buttonβno mock or unwanted template records are injected.
7.6 Export to Google Sheet (.xlsx)
- Tap Export to Google Sheet (.xlsx) in the top AppBar to generate an ECMA-376 OpenXML spreadsheet matching
subs.csv. - Includes columns
#,AC - PILOT,ITEM,ASSIGNED TO,VALID PERIOD,UPDATE REQUIRED,STATUS, andCOST. - Features native Excel calculation formula
=SUM(H5:H{lastRow})for automatic cost aggregation.
Step 8: Desktop Auditing & 20-Column Aircraft Flight Record (DESIGN.md 5.1.1)
For business accountants, tax preparers, and chief pilots, the Web App provides a high-density, desktop-first auditing spreadsheet configured to the rigorous specifications of tax consultants and auditors:
- On your dashboard, tap Compliance Auditor.
- 20-Column Aircraft Flight Record (Columns A through T):
The active in-app grid view renders the official 20-column layout matching IRS tax and aviation auditor standards:
- ENTRY # (Col A, light blue): Serialized record sequence number starting at
1for the oldest flight and incrementing chronologically (1, 2, 3...). - DATE (MM/DD/YYYY) (Col B): Formatted flight date.
- DEPARTURE (IDENTIFIER) (Col C, light blue): Departure airfield ICAO code.
- FLIGHT OR HOBBS HOURS AT DEPARTURE (Col D, light blue): Starting Hobbs meter reading.
- ARRIVAL (IDENTIFIER) (Col E): Destination airfield ICAO code.
- FLIGHT OR HOBBS HOURS AT ARRIVAL (Col F): Ending Hobbs meter reading.
- TOTAL FLIGHT/HOBBS HOURS (Col G, light blue): Live duration calculation (
Hobbs End - Hobbs Start). - NAUTICAL MILES (Col H): Total flight distance.
- OPERATOR/LESEE (Col I): Workspace tenant name or pilot display name.
- CHARTER/THIRD PARTY LEASE/NEITHER (Col J): Classification dropdown (
'N','C','L'). - REPOSITION Y/N (NA IF YOU ARE THE PILOT) (Col K): Classification dropdown (
'N','Y'). - FLIGHT DETAILS (Col L): Detailed contextual justification narrative supporting tax and insurance deductions.
- PASSENGER NAMES (Col M): Complete occupant roster (Pilot with
- Pilot, Instructor with- Instructor, and all manifest passengers). - B, BE, PE, PNE, T, M (Cols N to S): Passenger counts categorized by IRS passenger role code:
Bβ BusinessBEβ Business EntertainmentPEβ Personal EntertainmentPNEβ Personal Non EntertainmentTβ TrainingMβ Maintenance- TOTAL (Col T, light blue): Sum total of manifest passengers on the flight.
- Two-Line Wrapped Headings & High-Contrast Styling:
- Column headers are wrapped across two lines so the complete header text remains fully visible without truncation.
- Key auditing columns (Entry #, Departure, Hobbs Departure, Total Hours, Total Passengers) are styled with light blue highlights.
- Crisp black typography on high-contrast white and light-gray rows provides effortless readability during long audits.
- Inline Editing & Instant Cloud Sync:
- Accountants can double-click directly into cells in Charter/Lease, Reposition, Flight Details, and Comments columns to make adjustments that immediately synchronize to Firestore.
- Passenger & Operator Name Resolution:
- Persistent caching ensures passenger and pilot full legal names are always resolved and displayed instead of raw document IDs, even across filtering, column sorting, and network drops.
- Alternative Insurer Compliance Code Preservation:
- The underlying 15-column legacy compliance audit grid is preserved in the codebase for operators requiring alternative insurer compliance auditing.
Step 9: Universal OpenXML Spreadsheet Exports (.xlsx for Google Sheets & Excel)
The application provides native ECMA-376 OpenXML (.xlsx) multi-sheet spreadsheet generation across all modules, styled with navy headers, high-contrast rows, and calculated spreadsheet formulas (SUM, AVERAGE, COUNTA):
- Single & Multi-Flight Logbook Sheets:
- Export individual flights directly from the flight card or flight edit screen.
- Export complete workspace flight logs with meter readings, durations, routes, passenger lists, and flight details.
- Aircraft Flight Record Sheet (DESIGN.md 5.1.1):
- Generates the complete 20-column tax consultant spreadsheet (Columns A through T) ready for immediate submission to tax authorities and business accountants.
- Inspection Tracker Sheet (ARROW & AV1ATES):
- Export the 13-row inspection schedule directly from the Inspection Tracker AppBar or table header.
- Minimum Equipment List (MEL) Sheet:
- Export all 26 regulatory items across Daytime VFR, Night VFR, and IFR with current operational/INOP status and defect descriptions.
- Squawks Summary & Detail Sheets:
- Export a fleet-wide maintenance discrepancy ledger with system categories, severity ratings, placarded flags, and mechanic Return to Service sign-offs.
- Passenger Directory & History Sheets:
- Export complete passenger registries with roles, compensation types, and contact details, plus individual passenger flight histories per aircraft.
- Users & Workspace Members Report:
- Export from the Dashboard profile card detailing all invited members, assigned roles, ownership status, and join timestamps.
- Compliance & Renewals Sheet:
- Export the complete renewals and compliance schedule matching
subs.csvwith automated=SUM(H5:H{N})annual cost calculations.
Step 10: Account Settings, Privacy & Account Deletion (Apple App Store Guideline 5.1.1)
Users have complete autonomy over their identity, workspace profile, and data privacy directly from the application:
- Accessing Account Settings:
- Tap the Settings (gear) icon located in the upper-right corner of the Dashboard AppBar.
- The Account & Privacy dialog opens, displaying your registered display name, email address, and active role.
- Privacy Policy & Terms of Service:
- Review data handling, device camera usage, and privacy commitments anytime at
https://fcflightlog.web.app/privacy.html. - Review platform terms at
https://fcflightlog.web.app/terms.html. - Both links are directly accessible without login on the initial Login & Registration screen, within the Dashboard footer, and inside the Account & Privacy settings modal.
- Permanent Account Deletion (Self-Service):
- In accordance with Apple App Store Guideline 5.1.1(v), users can permanently delete their account without contacting support.
- Tap the red Delete Account button.
- A confirmation dialog warns that this will permanently remove your user profile, credentials, and workspace access.
- If recent authentication is expired, a secure password confirmation dialog prompts for verification.
- Upon confirmation, your Firebase Auth record and user profile document in Firestore are permanently erased, and you are logged out.