AD 81-18-04 R2

Registered aircraft · 81,733

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N96TJJohnson Thomas R · Costa Mesa, CABuilt 2003 · S/N 23657N96UEkstrand Marshall C · Lake Stevens, WABuilt 1974 · S/N S1AN96VAJak Real Estate LLC · Gorham, MEBuilt 1973 · S/N 28-7415052N96VETrost Peter K · San Diego, CABuilt 1996 · S/N 003-1095N96WGMartin David · Albertville, ALBuilt 2003 · S/N 24952N96WHHood William E · Dover, NCBuilt 1996 · S/N 1N96WJBas Part Sales LLC · Greeley, COBuilt 2022 · S/N 3397N96WLDrake Dallas H · Auburn, CABuilt 1997 · S/N 14N96WPVanneman William M · Ludlow, VTBuilt 1978 · S/N R182-00216N96WWDragging Tails LLC · Madison, MSBuilt 2001 · S/N 888-2001N96WYHamilton Triple C Farms LLC · Ririe, IDBuilt 2014 · S/N 3206N96YRLove James E · Galva, ILBuilt 2009 · S/N 90742N9700CCaldwell Stephanie Trustee · New Middletown, OHS/N 25N9700HBrutko Barry J · Lebanon, PABuilt 1975 · S/N 17266323N9700LJet Aviation LLC · Commerce Township, MIBuilt 1971 · S/N MB-506N9700VStencel Lawrence E · Palm Coast, FLBuilt 1974 · S/N 17264479N97019Mccreery Aviation Co Inc · Mcallen, TXBuilt 1984 · S/N 17276146N9701DCharles Benjamin L · Willow, AKBuilt 1959 · S/N 22-6612N9701KEmory Christopher W · Lexington Park, MDBuilt 1976 · S/N 28R-7635257N9701MInternational Air Services Inc Trustee · Carson City, NVS/N 670261N9701PTucson Soaring Club Inc · Sahuarita, AZBuilt 1975 · S/N 25-7556012N9701UStearns Edwin B Jr · Eloy, AZS/N AA5A-0101N9701WGlougie Robert M · Fresno, CABuilt 1967 · S/N 28-23175N9702CToledo Flying Club Inc · Toledo, WABuilt 1978 · S/N 28-7816519N9702DAdams Carl B · Albuquerque, NMBuilt 1959 · S/N 22-6613N9702LFlying Dreams One LLC · Louisville, KYBuilt 1986 · S/N 17276600N9702MPippin Alan D · Prattville, ALBuilt 1967 · S/N 670262N9702PHall Charles R · Ennis, MTBuilt 1975 · S/N 18-7509134N9702ULyons William S IV · Castle Rock, COBuilt 1976 · S/N AA5A-0102N9703MBertucci David · Sunnyvale, CABuilt 1967 · S/N 670263N97045Smith Brandon J · Casselton, NDBuilt 1984 · S/N 17276148N9704CAlon Guy · El Paso, TXBuilt 1978 · S/N 28-7890439N9704DTrimmer Marvin E · Willow, AKBuilt 1959 · S/N 22-6615N97055Skaya Aircraft LLC · Kalispell, MTBuilt 1984 · S/N 17276149N9705DHensley Roger A · Rosamond, CABuilt 1959 · S/N 22-6616N9705JFjb Aviation LLC · Palestine, TXS/N 28-3895N9705LDavis James A · Rockledge, FLS/N M-1324N9705QSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1970 · S/N MC-61N9705SVandivier Calvin Leo · Navarre, FLBuilt 1997 · S/N 18280016N9706LMoore Matthew W · Wichita, KSBuilt 1971 · S/N MC-95N9706MDance David C · Idaho Falls, IDBuilt 1967 · S/N 670116N9706QTzafrir Sheffer · Seattle, WABuilt 1975 · S/N 17265784N9706VDagnon Paul A · Apple Valley, MNBuilt 1974 · S/N 17264482N97075Sopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1984 · S/N 17276152N9707DPapke Brian D · Beulah, MIS/N 22-6619N9707LGriffith Jonathan E · Newark, NJBuilt 1971 · S/N MC-96N9707MCombs Charles D · Buffalo, MOBuilt 1967 · S/N 670267N9707PN B Tweet & Sons · Nome, AKBuilt 1975 · S/N 18-7509135N9707WBulger Edward P · Amesbury, MABuilt 1967 · S/N 28-23182N9708JGautsch Michael J · Onalaska, WIBuilt 1967 · S/N 28-3899
Back to AD 81-18-04 R2