Automated Aircraft Utilization Report
Every evening, WebRun opens Flight Schedule Pro, reads each aircraft's Hobbs time for the day, calculates how many hours each aircraft flew, updates the utilization log in Google Sheets, and posts a brief digest to Slack so the chief flight instructor can see which aircraft are carrying the load and which are sitting idle.
How do I automatically track daily aircraft utilization and Hobbs time at my flight school?
Every evening, WebRun pulls Hobbs times for each aircraft from Flight Schedule Pro, calculates daily hours flown and a 7-day rolling average, appends the data to your Google Sheets utilization log, and posts a Slack digest so the chief flight instructor can spot underutilized aircraft and scheduling patterns at a glance.
- Daily Hobbs totals per aircraft are logged every night without manual entry
- The chief flight instructor sees utilization trends in Slack each morning
- Underutilized aircraft are flagged automatically so scheduling adjustments can be made
Built for flight school owners · chief flight instructors · flight school operations managers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.flightschedulepro.comin a real browser with your saved login - no setup, no API keys. -
1
Flight Schedule Pro - read daily Hobbs totals
flightschedulepro.com
WebRun opens Flight Schedule Pro to read daily Hobbs totals. - Open Flight Schedule Pro and navigate to the aircraft reservation and Hobbs log
- Read the Hobbs start and end times for each aircraft's completed flights today
- Calculate total hours flown per aircraft for the day and compare to the prior 7-day rolling average
Done when Daily Hobbs totals and 7-day rolling utilization are calculated for every aircraft.
-
2
Google Sheets - log utilization data
google.com
WebRun opens Google Sheets to log utilization data. - Open the aircraft utilization log sheet
- Append a row for today with each aircraft's tail number, daily hours, and 7-day average
- Flag any aircraft with utilization below the configured threshold for the week
Done when Today's utilization row is logged in the sheet with flags for underutilized aircraft.
-
3
Slack - post daily utilization digest
slack.com
WebRun opens Slack to post daily utilization digest. - Post a Slack digest to the operations channel listing each aircraft's hours flown today and 7-day average
- Highlight any aircraft that flew significantly above or below the weekly average
- Include a link to the full utilization log in Google Sheets
Done when The operations team has a daily Slack digest of aircraft utilization with standout performers and underutilized planes flagged.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
How does WebRun calculate the Hobbs hours for each aircraft?
WebRun reads the Hobbs start and end times from each completed reservation in Flight Schedule Pro for the day and sums them per aircraft. The figures come directly from the scheduling system, not from estimates.
Can it track revenue per aircraft alongside the hours?
If your Flight Schedule Pro account records the billed rate per reservation, WebRun can calculate estimated daily revenue per aircraft and include it in the Google Sheets log. This is configurable during setup.
What counts as an underutilized aircraft?
The threshold is configurable. By default, WebRun flags any aircraft that flew fewer than two hours on a full operating day. Adjust the threshold during setup to match your fleet size and expected daily demand.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.