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.

N66CMMadson Jerome R · Goodyear, AZBuilt 1992 · S/N 953N66CRRazer Chester R · Columbia, ILS/N 24197N66DLIzzard William S · Crescent City, FLBuilt 1956 · S/N 158/196N66DSPaulsen Rebecca D · Broken Arrow, OKBuilt 1987 · S/N 120N66EMichaud Michael A · Winslow, MEBuilt 2002 · S/N 25077CN66EBAj Aviation Services LLC · Midland, TXBuilt 2005 · S/N 001N66EGWashburn Tom · Terrell, TXBuilt 1984 · S/N AGD01N66FBJames W Woodward · Sagle, IDBuilt 2001 · S/N 81085N66FDExtra Air LLC · Port Orange, FLBuilt 1983 · S/N 724N66FTTill Robert B · Cody, WYBuilt 2010 · S/N 81682N66FUGreen Steven D · Underhill, VTBuilt 1959 · S/N 22-7167N66FWBracilano Robert A · Virginia Beach, VABuilt 1977 · S/N FDW66N66GCBecker Air LLC · Grand Rapids, MIBuilt 1979 · S/N 61P07067963339N66GJShamrock Aviation LLC · Seabrook, NHBuilt 1966 · S/N 18-8416N66GNMoye Brian C · Naples, FLBuilt 1969 · S/N 28-5717N66GVPearson Robert L IV · Spartanburg, SCBuilt 1974 · S/N 17263861N66GZGarabedian John H · Southborough, MABuilt 2017 · S/N 91385N66HERausch William Donald · Ontario, NYBuilt 2004 · S/N 18281482N66HUUzzle Harry L · San Antonio, TXBuilt 2021 · S/N 2158N66HYN66hy LLC · Naples, FLBuilt 2000 · S/N 2091N66JFNaylor Matthew · Canyon Lake, TXS/N 2903N66JHHefner James L · Oro Valley, AZBuilt 2017 · S/N 20701N66JJWilliams Nicholas Indrais · Pickerington, OHBuilt 1972 · S/N 28R-7235157N66JMRussman Nicholas S · Farmersville, TXBuilt 1981 · S/N 15285251N66JSSisson Jp · Litchfield, ILBuilt 1973 · S/N JS66N66KBNorris Victor H · Bremerton, WABuilt 1976 · S/N 22N66KPRegistration Pending · Batesville, TXRegistration pendingBuilt 1966 · S/N 18-8408N66KYKelcher Randi R · Saint Charles, MOS/N 01AN66LKeating Gregory D · Carpenter, SDBuilt 1966 · S/N 60N66LBHermeling Mark A · Vail, AZBuilt 1973 · S/N 28-7310110N66LGHarpenden Corp · Los Angeles, CABuilt 2011 · S/N 2843696N66LYRapid Fleet II LLC · Carmel, INBuilt 2005 · S/N 172S9789N66MACp Aviation · Santa Paula, CABuilt 1985 · S/N 17276376N66MGPeeler Dixie L · Sandy, UTFirst renewal noticeS/N 1029N66MMTake Flyt LLC · Eagle Lake, MNBuilt 1976 · S/N 17266632N66MNGoebel Michael M · Conroe, TXBuilt 1993 · S/N 2487N66MWWhidden Marion H · Okeechobee, FLBuilt 1994 · S/N 2766N66NDMiller Aircraft Services Inc · Crookston, MNBuilt 1989 · S/N 1809046N66PArchangel One LLC · Lewes, DEBuilt 1978 · S/N 17270824N66PKMorton Dennis D · La Harpe, ILBuilt 2021 · S/N 1103N66PMMajestic Air LLC · Lowell, MIBuilt 1979 · S/N 500-79N66PRPeterjohn Management II LLC · Pound Ridge, NYBuilt 1980 · S/N 17273879N66PSSaurenman Edward E · Southampton, NYBuilt 1974 · S/N 1-74N66PTRobin194 LLC · Prescott Valley, AZBuilt 1981 · S/N 194N66RDTiger Air 2 LLC · Atlanta, GAFirst renewal noticeBuilt 1978 · S/N AA5B1013N66RPHedges Aviation Inc · Ronkonkoma, NYS/N 183-18045N66SEDaubenberger Joseph R · Hood River, ORBuilt 1973 · S/N 368-73N66SWAviator 20 LLC · Saint Louis, MOBuilt 2013 · S/N 001N66TKCollins Raymond S · Loomis, CAS/N 005N66TPAmerican Aviation Aircraft Leasing Inc · El Cajon, CABuilt 1979 · S/N ME-164
Back to AD 81-18-04 R2