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.
More Aerospace & Defense tools
See allKeep exploring
Free tools
- Engine Shop Visit Reserve per Flight Hour CalculatorTurn a shop visit estimate (labor, parts, life-limited parts, other) into a reserve per engine flight hour, per cycle and per month, with a sweep over the interval between visits.
- MRO Turn Time CalculatorAdd up the stages of a repair, see total turn time against target, the value-adding share and the work in process your shop will carry.
- Calibration Due Date Tracker WorksheetTrack each instrument's interval and days since calibration to see days remaining, percent of interval used and overdue count.
ERP fixes and how-tos
- Infor M3 Ad Hoc Report: Your Options, Step by Step, and Their LimitsHow to build ad hoc reports in Infor M3: list export, Excel, M3 API queries, data lake and BI options, with the limits of each and when to use which.
- SAP SE16N vs SQVI: Table Browser vs Ad Hoc QuerySE16N shows one table with filters and exports; SQVI joins multiple tables into a reusable ad hoc query. Here is when to use each, with setup steps for a first SQVI query.
- How the adop Patching Cycle Works in Oracle EBS 12.2How the adop online patching cycle works in Oracle EBS 12.2: prepare, apply, finalize, cutover and cleanup phases across the dual fs1/fs2 file system.
Guides
- AI-Powered Aerospace ERP SolutionsAerospace-specific ERP solutions with AI. AS9100 compliance, ITAR management, MRO optimization, and traceability for aviation and space manufacturers.
- Service Contract Management with ERP Billing IntegrationManage service contracts, entitlements, and recurring billing through integrated field service and ERP systems for accurate revenue recognition and SLA tracking.
- AI in MRO: Aerospace Use Cases That Work and Realistic ROIAI in MRO and AI for MRO: predictive maintenance, tech-log classification, 8130-3 drafting and repair quoting. What works today, data needed, realistic payback.
AI on your ERP
- AI for aviation MRO maintenance records and technical documentationOn-prem AI reads AD and SB packets, cross-checks logbooks and work orders against your MRO ERP, and drafts compliance narratives, without technical records leaving your network.
- AI for IFS Maintenix in aviation MROAI over IFS Maintenix maintenance records, AD/SB compliance, and task cards for MRO, deployed on-prem so tech records never leave your network.