Reports and Analytics
How many hours did N172SP fly last month? Which instructor billed the most? Reports answer these.
WingWrangler pulls data from every booking, invoice, and logbook entry across your operation. You get revenue breakdowns, fleet utilization, instructor productivity, and training pipeline visibility — all without exporting a single spreadsheet.
Report Categories
Section titled “Report Categories”Revenue Analysis
Section titled “Revenue Analysis”You need to know where the money’s coming from. Revenue reports break it down by aircraft, instructor, and time period so you can spot what’s working and what isn’t.
| Report | What you’ll see |
|---|---|
| Total revenue | Gross income for the period. January pulled $47,200 across the fleet. |
| By aircraft | N172SP generated $12,800 last month. N182RG? $3,100. Time to figure out why. |
| By instructor | Mike logged 62 dual hours. Sarah logged 41. See who’s carrying the load. |
| Trends | Bookings dip every December. Revenue peaks in June. Now you’ve got the data to prove it. |
Receivables Tracking
Section titled “Receivables Tracking”Outstanding balances add up fast. The aging report tells you who owes what, and how long it’s been sitting there.
| Age | What it means |
|---|---|
| Current | Not due yet. Normal. |
| 30 days | A little late. Send a reminder. |
| 60 days | Needs a phone call. $1,450 from a member who hasn’t flown in weeks is a red flag. |
| 90+ days | Collection priority. Consider grounding privileges until the balance is settled. |
Utilization Metrics
Section titled “Utilization Metrics”Your Archer sits on the ramp every Tuesday. Your 172 is double-booked every Saturday morning. Utilization reports show you the pattern so you can adjust pricing, availability, or fleet size.
| Metric | What it tells you |
|---|---|
| Aircraft utilization | N172SP flew 68 of 120 available hours (57%). N182RG flew 22 of 120 (18%). That’s a pricing or demand problem. |
| Day patterns | Saturdays run at 89% capacity. Tuesdays drop to 24%. Offer a weekday rate. |
| Time patterns | The 7-9 AM block is empty. The 3-6 PM block has a waitlist. Shift instructor schedules accordingly. |
Training Progress
Section titled “Training Progress”You’ve got 14 students in your Part 141 program. Three are stuck on stage checks. Two haven’t flown in three weeks. Training reports surface these problems before they become attrition.
| Report | Why it matters |
|---|---|
| Student progress | Jake is 72% through his PPL syllabus with 38.2 hours logged. On track for a checkride in 6 weeks. |
| Stage analysis | Four students failed the Stage 3 check on the same maneuver. That’s a curriculum gap, not a student problem. |
| Completion rates | 78% first-attempt pass rate on checkrides this year. Industry average is around 80%. You’re close. |
Natural Language Queries
Section titled “Natural Language Queries”Don’t want to click through filters? Just ask.
Type questions like:
- “How much revenue did we make last quarter?”
- “Which aircraft has the most Hobbs time this year?”
- “How many students passed their PPL checkride in January?”
- “Show me N5281F’s flight hours by month”
Report Configuration
Section titled “Report Configuration”Every report starts with three decisions: what time period, how to group the data, and what to filter out.
| Option | How you’ll use it |
|---|---|
| Date range | Last 30 days, this quarter, YTD, or a custom window. Pull January 1 - March 31 for your Q1 board meeting. |
| Grouping | Group revenue by aircraft to see per-tail-number income. Group by instructor to compare productivity. |
| Filtering | Only want C172 data? Filter to a single aircraft type. Only care about Part 141 students? Filter by program. |
Export Options
Section titled “Export Options”Reports are useful in the app. They’re more useful when you can share them or feed them into your accounting software.
| Format | When to use it |
|---|---|
| CSV | Dump into Excel or Google Sheets for custom analysis. Your accountant will thank you. |
| Clean, formatted report for your board meeting or insurance renewal. | |
| Scheduled | Set it and forget it. Monthly revenue summary hits your inbox on the 1st. Weekly utilization report every Monday at 7 AM. |
Quick Reference
Section titled “Quick Reference”| Task | Path |
|---|---|
| View reports | Reports → Select Type |
| Export data | Report → Export |
| Schedule report | Report → Schedule |
| Natural language | Reports → Ask |