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.

N923EZE Z Air LLC · Wilmington, NCBuilt 1966 · S/N 3458N923HJWayner Ronald P · Sutton, AKS/N HUMPHREY 002N923JFJf Aerosports LLC · Vineland, NJBuilt 1998 · S/N 6002N923JSSankey Aviation LLC · Warminster, PABuilt 2005 · S/N T18208390N923KMWilliams Zackery · Lake Tapps, WABuilt 1993 · S/N 20008N923MGGoss Mark William · Lake Stevens, WABuilt 2023 · S/N 11328BN923PSWaterman Marc K · Cedaredge, COBuilt 2010 · S/N 923N923SDFresno County Sheriffs Department · Fresno, CABuilt 2001 · S/N T20608342N923SMN923sm LLC · Rehoboth Beach, DEBuilt 1991 · S/N 1923MN923SQSprecher Susan E · Locust Grove, GAS/N 86-73N923TEDiscover Resources LLC · Norman, OKBuilt 2001 · S/N 10202N923VDog House Aviation LLC · Mount Pleasant, SCBuilt 1974 · S/N M-1591N9240HPropability One LLC · Daytona Beach, FLBuilt 1975 · S/N 17266038N9240JThorson Jason J · East Grand Forks, MNBuilt 1966 · S/N 28-3314N9240KHolland Wyatt Eugene · Garner, IAS/N 28-7690234N9240MMathews Justin R · Omaha, NEBuilt 1966 · S/N 1193N9241MBellinger John · Wexford, PABuilt 1966 · S/N 3447N9241PGaskill Jeffrey V · Weston, MOS/N 24-4740N9241SCosby Asa · Weldon, CAS/N M-1734N9241WAnderson Fred M · Cocoa, FLBuilt 1967 · S/N 28-10911N92424Christiansen Cortland · Bakersfield, CAS/N 17261573N9242DWeishaar Wallace · Livingston, TXBuilt 1958 · S/N 22-6302N9242HRoland Aviation LLC · Gualala, CABuilt 1975 · S/N 17266040N9242JCoyote Flight Centers LLC · Amarillo, TXBuilt 1966 · S/N 28-3316N9242PDekervor Marc Phillippe II · La Mesa, CAS/N 24-4741N9242VHurley Gregory · Capon Bridge, WVBuilt 1969 · S/N 690061N9242WAllison Richard H Jr · Livingston, TXBuilt 1967 · S/N 28-10912N9242ZProfit Solving Group LLC · Bigfork, MTBuilt 1975 · S/N AA5B-0183N9243DPiper Aviation Museum Foundation · Lock Haven, PABuilt 1958 · S/N 22-6303N9243HSeward Air Taxi LLC · Seward, AKBuilt 1975 · S/N 17266041N9243JRoney Edward A · Weirton, WVBuilt 1966 · S/N 28-3318N9243MHill James C · Grand Saline, TXBuilt 1966 · S/N 1194N9243PKanne Michael J · Des Moines, IABuilt 1967 · S/N 24-4742N9244Wahner Rudolf M Jr Trustee · Aston, PABuilt 1974 · S/N 202N92445Pureflight Aviation Training LLC · Newberg, ORBuilt 1973 · S/N 17261575N92447American Patrols Inc · Midland, TXBuilt 1973 · S/N 17261576N92448Eckholt John · Forest Grove, ORBuilt 1973 · S/N 17261577N9244DShrode Rafe C · Jewett, TXS/N 22-6304N9244HCoachron Investments LLC · Grosse Ile, MIBuilt 1975 · S/N 17266042N9244JRichardson David M · Dwight, ILS/N 28-3319N9244MAntos Corey · Leland, NCBuilt 1966 · S/N 1195N9244SKonefal Arthur Joseph · Fairbanks, AKBuilt 1975 · S/N M-1740N9244VGibbs Richard L · Palm Coast, FLBuilt 1969 · S/N 690062N9244WCogan Michael Benjamin · San Jose, CABuilt 1967 · S/N 28-10914N9244YParker Aircraft Sales Inc · Wilmington, DEBuilt 1983 · S/N 31P-8414014N9245MIneson Thomas · Edgewood, NMBuilt 1966 · S/N 1196N9245SMowery Joseph · Orlando, FLBuilt 1975 · S/N M-1741N9245WN9245w Partnership · Lumberton, MSS/N 28-10915N9245YMiles Aviation LLC · Sheridan, WYBuilt 1983 · S/N 31P-8414025N9246FFischer Alfred M · Genoa City, WIBuilt 1989 · S/N 2841254
Back to AD 87-10-06 R1