AD and Service Bulletin Compliance Tracker Worksheet
Missing a repetitive airworthiness directive inspection is a serious compliance failure. This worksheet gives planners a simple remaining-hours view per item to catch the tight ones early.
| AD or SB ref. | Subject | Type | Recurrence | Interval (FH) | Done at (FH) | Current (FH) | Remaining (FH) | Calendar limit | |
|---|---|---|---|---|---|---|---|---|---|
150 | |||||||||
250 | |||||||||
450 | |||||||||
150 |
Sample entries use placeholder references, not real directives. Take every requirement and compliance time from the actual directive and your approved maintenance programme.
Due lists from ERP usage data
Optional review of feeding utilization and due dates from your ERP.
Optional. The tool and every export work without this. No spam.
How to use the tracker
Add each applicable AD or service bulletin on its own row with the reference, a short subject, whether it repeats, the interval, the flight hours when it was last done and the current total. Remaining hours calculate for each row. Keep a calendar limit column for items with a time basis, since many directives use hours, cycles or calendar time, whichever comes first. Export to Excel to filter by lowest remaining and review it at every planning meeting.
The remaining-time logic
For a repetitive item, remaining equals the interval minus the usage accumulated since the last compliance: interval - (current - last). A negative result means the limit has passed. For one-time items, treat the interval as the compliance limit and last as zero. The directive text always governs tolerances, grace periods and the units used.
- Keep hours, cycles and calendar limits in separate columns
- Sort ascending by remaining so tight items surface first
- Update the current figure at every utilization update
Common mistakes
A frequent error is mixing units, for example entering cycles against a flight hour counter. Another is tracking only the original directive and missing a later revision or superseding AD. Do not treat this sheet as the legal record of compliance; the signed maintenance record is. If a fleet is large, move the data into your maintenance information system and use the sheet for spot reviews or small operators.
Frequently Asked Questions
Does this give me the actual AD requirements?
No. It is only a tracker. Read the directive or bulletin itself for applicability, compliance time, method and any alternative means of compliance.
How do I handle cycles and calendar limits?
Add columns or duplicate the row per limit type. Compliance is generally due at whichever limit is reached first, as the directive states.
What if remaining goes negative?
That means the interval was exceeded. Stop and check the directive and your records, and escalate to your continuing airworthiness manager immediately.
Can I use this for service bulletins?
Yes, for tracking. Service bulletin compliance may be optional or recommended, so note the status and customer decision in your own records.
If compliance data sits in several spreadsheets, we can help consolidate it with your ERP or maintenance system data for one reliable due list.
Related Tools
Life-Limited Part (LLP) Tracking Worksheet
List serialized life-limited parts with their limit and cycles since new, then see percent used, cycles remaining and months left at your utilization.
Aerospace & DefenseMRO Technician Task Card Template
Build a printable task card with the maintenance reference, tooling, parts, steps and inspection sign-offs for a single job.
Aerospace & DefenseMRO Non-Routine Findings Log Worksheet
Log every non-routine finding during a check with estimated hours and parts, and see the running cost to share with the customer.
Aerospace & DefenseMRO Incoming Inspection and Receiving Report Template
Record what arrived, its paperwork, visible condition and disposition on one controlled receiving report for aircraft parts and components.