Airworthiness Directive Spreadsheet

[HopePilot]

Hi all,

My bird is going in for its first annual and I'm putting together a list of the ADs and when they were complied with.  Has anyone put together such a spreadsheet?

Thanks!

[Awful_Charlie]

I've got one, but it is far from perfect.  If someone has a better way of doing it, I'd be interested too

[DonMuncy]

To do it right, you have to have the information on all the equipment on your plane. This includes changed pumps etc. So anyone else's list will not give you everything you need. I admit someone else's might be close, but you really should dig in and do it the hard way. The good news is that once it is done, it is much easier to keep updated.

Don

[HopePilot]

Okay, thanks.  Well, I'm not looking for the actual info/equipment, but rather insight into how other people have arranged everything.  I'm planning on doing all the hard work, but I haven't even a clue as to how to organize it on a spreadsheet.

[Jeff_S]

I would save yourself the trouble, because this is exactly what the IA is supposed to do as part of his job and what you are paying him (or her) for.  They will have the list of the required ADs for your plane, and they will scour the logbooks and fill out a form to keep track of it. They also all use a common program for doing this, which prints out the record that they then sign and becomes part of your logs.

[kortopates]

Frankly its well worth it for any owner that wants to take an active role in their planes maintenance and you can save your IA some time and it will help you plan instead of being surprised. Its a big job though without the benefit of the commercial s/w that automates the search, but you should have a list from prior annuals to start with. Keep in mind though that finding ADs for the Mooney airframe and engine are the easy part, the hard part is finding is all the appliance AD's such as prop, governor, radios, AP etc, there is even an ignition switch AD. Its also suggested to include important SB's such as Mooney's infamous M20-282A no-clutch back spring for every 1000 hrs.

The preferred approach is two create two lists or two worksheets as I do in one spreadsheet with one for recurring ADs and the other for one time or non-recurring ADs. This way the only the recurring ADs sheet is being updated with new compliance dates yet both will get new ADs added to them as they come out.

The columns to use are in bolded are (with values in parens): Type ("Once", or the time interval (e.g. "100 hr"), or "NA"), AD No. (i put in the URL to it e.g., 85-23-07 ), Effective Date, Description, Applicability (what model or serial # a/c it applies too), either "One Time" or "Recurring" (values are NA or C/W date, or Every 500 hrs Last C/W date), and Action (description of required action and method of compliance). Many IA will sign ieach entry with the action, but that's not necessary since the IA's signature of compliance is already in the log book so just need to make sure its easy to find in the log book which contains the method and signature of compliance. I know there are some IAs here which can give some additional advice/help.

[MARZ]

My AD investigation was more of a narrowing of the type of airplane to buy than anything else - I wanted to see which make and model of airplane had the least amount of ADs and therefore (in my mind) a better quality / track record

This is the process that I took once I had short listed a Mooney - first stop was to Mooney.com to get a list of all the service bulletins HERE

At the bottom of the page is a link to download everything to an excel spreadsheet.  I narrowed the download to my model, and found which ones were applicable to my plane eliminating by serial number or equipment (for example manual to electric landing gear)   There is a correlation of service bulletins to ADs but not all service bulletins spawn ADs

My next stop was the FAA site to do several searches HERE

airframe (M20F)

engine (yours will vary)

Prop (yours will vary)

Other specific equipment particular to your application

As stated there are one time vs recurring ADs - I created  three columns - one for a one time and two  for recurring. When the recurring AD is complied with I put the date in one column and the hours in another. 

Finally - once I had narrowed my plane search to a specific one - scour of the logs to see which ADs have been complied with and the process of filling in the spreadsheet.  - I actually did this prior to the pre buy - if a vast number of ADs had not been documented in the logs it meant the purchase was going to be complex, something I was trying to avoid.

I found that this process will give the owner (Me) a better understanding of what needs to happen - but I never envisioned it to be a final say on compliance - I will leave that an IA for annuals and pre-buy.

[GXPD]

I have a spreadsheet in excel format .  If anyone has an FTP site that I can upload the file to I am willing to donate it to the group.

It is not totally complete (Needs input on SB/SI and out of phase history) but works reasonably well.  Fill in some general information  on the main page and on the AD page anything due at current airtime will be noted with red fill and recurring ADs will show up as red text with due airtime.  Used it on my last recent annual and gave it to the mechanic to confirm compliance.

No guarantees on accuracy or suitability.  If anyone does modify and upgrade, they can repost for anyones benefit.

 

[flight2000]

Quote: GXPD

I have a spreadsheet in excel format .  If anyone has an FTP site that I can upload the file to I am willing to donate it to the group.

No guarantees on accuracy or suitability.  If anyone does modify and upgrade, they can repost for anyones benefit.

[flight2000]

The file is now uploaded and ready for use as needed...

See the link above for access to it and other assorted things for the M20 series.

[danb35]

I also use AdLog, though I've replaced some of their preprinted forms (like the inspection status sheet) with spreadsheets that I print out and put in the binder.