# AD and Service Bulletin Compliance Tracker Worksheet

> Source: https://netray.co/tools/mro-ad-sb-compliance-tracker-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Track recurring AD and SB items by interval, last done and current flight hours, with remaining hours calculated for each line.

## Category

aerospace-defense

## Industry

Aerospace MRO

## Audience

- Continuing airworthiness manager
- Maintenance planner
- Records clerk

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### AD or SB ref.

**Key:** ref

**Type:** text

#### Subject

**Key:** subject

**Type:** text

#### Type

**Key:** type

**Type:** select

**Options:**

- AD
- SB
- Alert SB
- Manufacturer letter

#### Recurrence

**Key:** recur

**Type:** select

**Options:**

- One-time
- Repetitive

#### Interval

**Key:** interval

**Type:** number

**Unit:** FH

#### Done at

**Key:** last

**Type:** number

**Unit:** FH

#### Current

**Key:** current

**Type:** number

**Unit:** FH

#### Remaining

**Key:** remaining

**Type:** number

**Expr:** interval - (current - last)

**Unit:** FH

**Format:** number

#### Calendar limit

**Key:** next_date

**Type:** date

**Rows:**

**Ref:** AD-EXAMPLE-01

**Subject:** Elevator hinge inspection

**Type:** AD

**Recur:** Repetitive

**Interval:** 600

**Last:** 4100

**Current:** 4550

**Next date:** 2027-03-15

**Ref:** AD-EXAMPLE-02

**Subject:** Fuel pump connector check

**Type:** AD

**Recur:** Repetitive

**Interval:** 1000

**Last:** 3800

**Current:** 4550

**Next date:** 2027-08-01

**Ref:** SB-EXAMPLE-03

**Subject:** Cabin pressure valve modification

**Type:** SB

**Recur:** One-time

**Interval:** 5000

**Last:** 0

**Current:** 4550

**Next date:** 2028-01-10

**Ref:** AD-EXAMPLE-04

**Subject:** Wing spar fitting eddy current

**Type:** AD

**Recur:** Repetitive

**Interval:** 400

**Last:** 4300

**Current:** 4550

**Next date:** 2026-12-20

**Totals:**

#### Lowest remaining FH

**Key:** remaining

**Agg:** min

**Format:** number

#### Items tracked

**Key:** ref

**Agg:** count

**Format:** integer

**Summary:**

#### Tightest item (FH remaining)

**Key:** tightest

**Expr:** min_remaining

**Format:** number

**Primary:** true

**Notes:** Sample entries use placeholder references, not real directives. Take every requirement and compliance time from the actual directive and your approved maintenance programme.

## Content

**Intro:** 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.

**Sections:**

#### How to use the tracker

**Body:** 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

**Body:** 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.

**Bullets:**

- 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

**Body:** 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.

**Cta:** If compliance data sits in several spreadsheets, we can help consolidate it with your ERP or maintenance system data for one reliable due list.

**Faq:**

#### Does this give me the actual AD requirements?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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?

**Answer:** Yes, for tracking. Service bulletin compliance may be optional or recommended, so note the status and customer decision in your own records.

## Search terms

airworthiness directive tracking spreadsheet, ad compliance tracker excel, service bulletin tracking template, ad sb compliance log, aircraft ad status template, recurring ad inspection tracker, airworthiness directive compliance record, aircraft maintenance due list excel

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json