OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,010

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:87-10-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
  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.

N5891U2dwh LLC · Katy, TXBuilt 1970 · S/N 28-26727N5891WMarino Mario Mennona · King Of Prussia, PABuilt 1965 · S/N 28-2633N58923Singh Jaspal · Sacramento, CABuilt 1973 · S/N 18262394N5892UFeighl Engineering Group Inc · Hot Springs, ARS/N 28-26735N5893LHegwood Jonathan E · Petal, MSBuilt 1972 · S/N AA5-0093N5893NKoehn Juergen A · Lago Vista, TXBuilt 1979 · S/N 14506N5893UCasper Gary · Spring Creek, NVBuilt 1970 · S/N 28-26706N5893WFinch Howell M Jr · Victoria, TXBuilt 1965 · S/N 28-2645N5894LTrueblood Terry L · Effingham, ILBuilt 1972 · S/N AA5-0094N5894QBlech Fritz · Grants Pass, ORBuilt 1965 · S/N 3155N5895LWatkins Marion D · Mcdonough, GABuilt 1972 · S/N AA5-0095N5895NCommander Club LLC · Hudson, WIBuilt 1979 · S/N 14508N5896PBurwell Brent C · New Ulm, TXBuilt 1959 · S/N 24-983N5896UGift Academy Inc · Vernon, TXS/N 28-26792N5896YPatentcentral LLC · Hollywood, FLBuilt 1965 · S/N 27-3051N5897LCulver Christopher J · Rockmart, GABuilt 1972 · S/N AA5-0097N5897QBarsi Jeffrey D · Bonham, TXBuilt 1965 · S/N 813N5898LLamer Benjamin W · Ada, MIBuilt 1972 · S/N AA5-0098N5898QO'Neal Timothy L · Damascus, ORBuilt 1965 · S/N 3157N5898VMaxair Inc · Coxs Creek, KYBuilt 1977 · S/N 28-7716213N5898WFrazier Justyn K · Mesa, AZS/N 28-2708N589APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843765N589CBBryan Curtis · Enumclaw, WAS/N 589N589LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2023 · S/N 28020107N589RAMcgowin James E · Ball Ground, GABuilt 2007 · S/N 60589N589RPEdmundson George · Hood River, ORS/N 5589N589RTPoling George T · Clayton, NMBuilt 2005 · S/N T20608572N589SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881407N589SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2000 · S/N 172S8519N589TFam Vans Inc · Fountain Valley, CAS/N 40.503N589TRRussell Tony B Jr · Severance, COBuilt 1975 · S/N 589N589VWPierce Thurlow L · Attica, MIBuilt 1967 · S/N 32-908N58AEKraujales Adam M · East Moriches, NYS/N 28-5075N58ALHsing Mitchell · Redwood City, CABuilt 1993 · S/N 3058N58BWarnick Ronald S · Cascade, MTBuilt 1968 · S/N 15068409N58BFH Jack Flash Inc · Fort Worth, TXS/N 12013N58BGStassi Jean-Paul A Jr · Henagar, ALS/N 312N58BHPierson Ted · Gooding, IDBuilt 2015 · S/N 568-2015N58BVVarney Aviation LLC · Bangor, MEBuilt 1999 · S/N T20608036N58CCPittsburgh Marine Technologies · Eighty Four, PABuilt 1981 · S/N R18201729N58CFComputerized Flight Systems Inc · Nokomis, FLBuilt 1977 · S/N 61P-0459-179N58CR7192 Locke Road LLC · Millington, TNBuilt 2005 · S/N 18281544N58CTS 1t LLC · Parkland, FLS/N 1058N58DERichmond P Curt · Anna, TXBuilt 1996 · S/N 5333N58DSBalliet Edgar J III · Northampton, PABuilt 1979 · S/N 17272305N58EBConservation Flight LLC · Bronx, NYBuilt 2003 · S/N T20608404N58FSClark Mitchell P R · Drewsey, ORS/N 2108N58GMWanless Dax D · Granite Falls, MNS/N 153N58GSCranford John · Douglassville, TXBuilt 1979 · S/N R18201412N58JPThompson Frank L · Weiser, IDBuilt 1977 · S/N 002
Back to AD 87-10-06 R1