Contrails
0%
Objectives & Key Results
0 selected
Objectives
Key Results
Chat about all OKRs
Searching documents...
Speak Now
Tactical Board
LEGEND
Crewing:
✓ Crewed
→ In Transit
◉ Scheduled
✗ Uncrewed
(Note, coloring will remain green if exiting crew still onsite)
Maintenance:
✓ Online
✓/✓ Online (MX Today / Tomorrow)
■ SCH
◆ AOG
● Other MX
▲ Ferry
✚ Eval
✗ Non-MX Revenue Unavailable
Tail Number
Coloring indicates Active MEL or NEF (hover for detail)
Notes:
* "Whitespace" Definition
- Crew has have duty time
- Crew is with aircraft (not in movement)
- AC is projected MX available
- AC isn't OOS for non-MX reason
- AC isn't flying a 135 trip
- ...all for at least a 5 hour window
Other dashboard Notes
- DA Excludes GIVs
Event Type: SME
Enhance Your Prompt
Generating enhanced prompts...
Memories
Loading memories...
Help & Reference
What can Contrails do?
- Query flight & revenue data from the database
- Analyze uploaded documents (PDF, Word, Excel)
- Generate charts and visualizations
- Show flight routes on interactive maps
- Create Word and Excel reports
- Search SharePoint and OneDrive files
How to Ask
Specify Time Periods
"Revenue last month"
"Flights YTD"
"Q3 2024 data"
Request Visualizations
"...as a bar chart"
"...as a pie chart"
"Show on a map"
Name Entities
"Surf Air revenue"
"Flights for N123EX"
"Trips to KTEB"
Group Data
"...by customer"
"...by aircraft type"
"...by week"
Example Queries
"Show me top 10 customers by revenue this month as a bar chart"
"What flights went to KTEB last week?"
"Compare YTD revenue to last year by month"
Glossary
Time Periods
YTD - Year to Date (Jan 1 to today)
MTD - Month to Date (1st of month to today)
QTD - Quarter to Date
LY - Last Year / Prior Year
Aviation Terms
PAX - Passengers
FH - Flight Hours
FBO - Fixed Base Operator (airport service provider)
ETA - Estimated Time of Arrival
ETD - Estimated Time of Departure
ICAO - International Civil Aviation Organization (4-letter airport codes like KTEB)
Tail # - Aircraft registration number (e.g., N123EX)
Delay Codes
WX - Weather delay
MX - Mechanical / Maintenance delay
ATC - Air Traffic Control delay
CREW - Crew-related delay
LATE PAX - Late passengers delay
REPO - Repositioning flight (no passengers)
Flight Status
Completed - Flight that actually occurred (fuel burn > 0)
Verified - Flight confirmed as completed (status_id = 8)
Cancelled - Flight that was cancelled before departure
Scheduled - Planned future flight
Revenue Terms
Reconciled Revenue - Final confirmed revenue amount
Estimated Revenue - Projected revenue before reconciliation
Charter - On-demand flight booked by customer
Jet Card - Prepaid flight hours membership
No matching terms found
Keyboard Shortcuts
- Tab Accept autocomplete suggestion
- Shift + Enter New line in message
- Enter Send message
Settings
Custom Instructions
Tell Contrails about your preferences, how you'd like responses formatted, or context that helps with your queries.
0 / 2000
Flight Maps
Choose how flight routes are displayed when you ask about flights.
Developer Options
Display the SQL query and row count for database queries in chat responses.
Document
Loading document...