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.

N399MACavorite Aviaton LLC · West Jordan, UTBuilt 2004 · S/N 2843599N399MESound Sleep Clinic Pllc · Bainbridge Island, WABuilt 2000 · S/N 18280878N399RCSouthwestern Development & Leasing Inc · Costa Mesa, CABuilt 1965 · S/N 32-212N399RMEyles Edwin W Jr · Butler, PABuilt 1975 · S/N AA5A-0048N399RSRegistered aircraftBuilt 1999 · S/N 5477N399SBBuchanan Sam C · Athens, ALBuilt 1999 · S/N 25241N399TBg Flight Group LLC · Bowling Green, KYBuilt 2000 · S/N 18280817N399TCTexas State Technical College · Waco, TXBuilt 2024 · S/N 28020190N399ZFlyin Horse LLC · Columbus, GAS/N 25082CN39ACCoyle Whitney J · Edgewater, FLBuilt 2021 · S/N 24020N39AHCapital Aircraft LLC · Juneau, AKBuilt 2001 · S/N 2140N39ALMcentire David J · Bainbridge, INBuilt 2005 · S/N 01N39BBHammonds Willard H II · Corpus Christi, TXBuilt 2005 · S/N T18208360N39BCRoberts David C · Cedar Falls, IABuilt 1973 · S/N 28-7410013N39BPEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1999 · S/N 2906N39CPWhirl'D Helicopters Inc · Sevierville, TNBuilt 2003 · S/N 10069N39CTRotramel Paul D · Hardinsburg, KYBuilt 1968 · S/N 28R-30712N39CWWindham Charles R · Rogersville, TNBuilt 2012 · S/N 91447N39DBKwasinski Mark W · Kalamazoo, MIBuilt 1969 · S/N 153N39DCCruson Dale E · Ontario, ORBuilt 1993 · S/N 20374N39DRLehigh Valley Flying Club Inc · Lehigh Valley, PABuilt 1976 · S/N 28-7790221N39DUYokoo Kureha · Petaluma, CAS/N 22818N39ECSmith Adria A · Kingwood, TXBuilt 1968 · S/N 28-4985N39EJAndersen John · Kenosha, WIBuilt 2006 · S/N 39N39FZLongley Charles A · Nome, AKBuilt 1962 · S/N 18-7745N39GMonteleone Gene R · Mount Vernon, TXS/N 15N39GCWilliams Jeffrey D · Florence, ALBuilt 1980 · S/N AS123N39GDNovember Sierra Romeo LLC · Byron Center, MIS/N 10250N39GHApaka Lee K · Fairfield, CABuilt 1975 · S/N 65N39GMBacon Gregory A · Prairie Home, MOS/N 0001N39GPExtra 2 Inc · Newark, DEBuilt 2000 · S/N 116N39GTAshwill Gregory L Trustee · Overgaard, AZBuilt 2018 · S/N SC-100N39GWKotalite Consultant LLC · West Palm Beach, FLS/N 3096N39HASmc Ltd · Somerset, WIS/N 31-497N39HBBartle Henson P · Independence, ORBuilt 2012 · S/N 1N39HYReed Hollow Aviation LLC · Franktown, COBuilt 2001 · S/N 2137N39JMJads Aviation LLC · Rowlett, TXBuilt 1960 · S/N 23-1943N39KWFier William J · Austin, TXBuilt 2000 · S/N 3374N39KYYang Chi · Lafayette, COBuilt 1979 · S/N 447995304N39LDMau Thomas E · Kenmare, NDS/N 18-5757N39LTGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 924-2003N39MRGraupman Gerald · Chicago, ILBuilt 1969 · S/N EGA-1N39MVMedical Transport Inc · Dover, DES/N 61P07728063385N39NDTerwillegar Charles E · Renton, WABuilt 1967 · S/N R1720082N39NSMacair Inc · Corvallis, ORBuilt 1998 · S/N 2003N39PCN39pc LLC · Portsmouth, NHBuilt 1983 · S/N 18268313N39RFHughes Todd R · Euless, TXBuilt 1996 · S/N 532N39RLAdams Nathan M · Edgewater, FLBuilt 1972 · S/N 416-HN39SDMbm Leasing LLC · Jacksonville, NCBuilt 1966 · S/N 28-3565N39SJArrigo Johnathan T · Mill Spring, NCBuilt 1999 · S/N 3269
Back to AD 87-10-06 R1