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.

N4266QMaxwell James B · Lewiston, IDBuilt 1971 · S/N 17260166N4266RBig Guy Enterprise Transportation LLC · Portland, ORBuilt 1969 · S/N 32-40639N4266ZVan Ryzin Chris K · Sterling, AKBuilt 1967 · S/N 18-8512N42671P&N Corp · Marion, IABuilt 1974 · S/N 28-7415398N42675908 Flying Club Inc · Fort Pierce, FLBuilt 1974 · S/N 28-7405165N42677Swank And Son Inc · Poplar, MTBuilt 1975 · S/N AA5B-0074N4267HGmt Enterprises LLC · Stephenville, TXFirst renewal noticeBuilt 1978 · S/N 24-0690N4267QDhf LLC · Valentine, NEBuilt 1971 · S/N 17260167N4267THooley Charles M · North Oaks, MNBuilt 1971 · S/N 28-7225110N4268FWindt Edward A Jr · Chester, NJS/N 28-7790008N4268JLuxair LLC · Van Nuys, CAS/N 28-22626N4268PAhlem Mark · Hilmar, CABuilt 1959 · S/N 23-1767N4269BNortheast Aviation LLC · Bynum, TXBuilt 2000 · S/N 25047CN4269HSiniakin Michael K · East Brunswick, NJBuilt 1978 · S/N 24-0692N4269JMasino John B Jr · Berlin, MDBuilt 1967 · S/N 28-22628N4269TRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1972 · S/N 28-7205126N4269UAero380 Corp · Wilmington, DEBuilt 2017 · S/N 30021N426CPCivil Air Patrol · Montgomery, ALBuilt 2001 · S/N 172S8688N426CTAir Kraft Aviation LLC · Timber Lake, SDS/N 11174N426CUMiller Justin S · Cedar Rapids, IABuilt 2021 · S/N 4261986N426DLHawk30 Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172RG0827N426ESWeaver Corey E · Saline, MIBuilt 1997 · S/N 17280263N426HHickerson Timothy William · Springfield, OHBuilt 2003 · S/N 81246N426HLGiurtino Joel F · Spring Hill, FLBuilt 1977 · S/N 17269050N426JMThompson Daniel · Catawba, NCBuilt 1999 · S/N 60191N426JTReilly Michael R · Vestal, NYBuilt 1998 · S/N 750N426KFFaris Kevin D · Plattsmouth, NEBuilt 2007 · S/N 70710N426LPAir Mates Flying Club Inc · Northfield, NJBuilt 1999 · S/N 172S8199N426MCMagic Carpet LLC · Wilmington, DEBuilt 1971 · S/N 17260022N426NCHargrave Bobby P · Cantonment, FLBuilt 2000 · S/N 80706N426PAN426pa LLC · New Orleans, LABuilt 2001 · S/N 2843475N426PKMiddendorf Brian Jay · Alamogordo, NMBuilt 2009 · S/N 91404N426PRRyka Aviation LLC · Sunrise Beach, MOBuilt 1999 · S/N 3257108N426RCDahl Christopher E · Sutter Creek, CABuilt 1987 · S/N 26N426RMRocky Mountain College · Billings, MTBuilt 2002 · S/N 2843529N426RVN152tg LLC · Fort Collins, COBuilt 2000 · S/N 24344N426SSale Reported · Kotzebue, AKSale reportedS/N 31-8152190N426SEAthena Aviation LLC · Golden, MSS/N 3255042N426SKBergstrom Aircraft Inc · Pasco, WABuilt 1979 · S/N 17273720N426SLJorgensen Lynn L · Panora, IABuilt 2013 · S/N 001N426TC3di LLC · Elizabeth, WVBuilt 1987 · S/N 4622001N4270Campbell Edwin W · Hookstown, PABuilt 1959 · S/N E3B-427N4270CEverything Pitts LLC · Queen Creek, AZBuilt 1981 · S/N 1014N4270GBerg Keith A · Hatton, NDBuilt 2005 · S/N 1N4270JPiegza Mark J · Hilton Head Island, SCS/N 28-22629N4270QReeves James C · Locust Grove, GABuilt 1971 · S/N 17260170N4270RKreiser Foster E Jr · Middletown, PABuilt 1969 · S/N 32-40645N4270TAllen Aero LLC · Saint Cloud, FLBuilt 1971 · S/N 32-7240048N42710N42710 LLC · Itta Bena, MSBuilt 2005 · S/N 21088CN4271JDouble P Creative LLC · Pleasanton, TXS/N 28-22630
Back to AD 87-10-06 R1