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.

N9338PDream Home Aviation Inc · New Smyrna Beach, FLS/N 24-4836N9338RMeshinsky Jeffrey · Alpine, CABuilt 1978 · S/N R18200693N9338SGentilin Glen R · Camino, CABuilt 1975 · S/N M-1643N9338VDheedene Nicholas · San Mateo, CABuilt 1969 · S/N 700004N9339JTruesdell Michael L · Tonopah, NVS/N 28-3436N9339NKadee Transportation LLC · Bucyrus, KSBuilt 2006 · S/N 90761N9339PBreznik John D · Bradford, PABuilt 1969 · S/N 24-4837N9339VTechnical Education Services Inc · Virginia Beach, VABuilt 1969 · S/N 700005N933BKKreul Robert W · Waconia, MNBuilt 1971 · S/N 28-7225113N933CC27 Latitude LLC DBA · West Palm Beach, FLBuilt 1979 · S/N 28-7990503N933DSDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2003 · S/N 40.327N933GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881224N933GYDemaria Steven M · Dacula, GAS/N 839N933LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496421N933SCAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881873N933STSaratina Inc · Calhoun, GABuilt 1994 · S/N 5299N933TEBcaz Holdings LLC · Wilmington, DEBuilt 2002 · S/N 10212N933XAndrews Richard S III · Guilford, CTBuilt 2005 · S/N 60515N9340JLovelace Mario · Coral Springs, FLBuilt 1966 · S/N 28-3438N9340MWeidner Mark · Cincinnati, OHBuilt 1966 · S/N 1272N9340N9340n LLC · Broken Arrow, OKBuilt 1969 · S/N 28R-35041N9340SGarbade Richard L · Martinez, GAS/N MC-349N9341CMerlin Aviation LLC · South Saint Paul, MNBuilt 1978 · S/N 28-7890399N9341HAndreas Neil A · Yakima, WABuilt 1975 · S/N 17266099N9341MGabel Mark E · Oxnard, CABuilt 1966 · S/N 1273N9341SSantos Eric G · West Oneonta, NYBuilt 1975 · S/N M-1644N9341VAvalle Oscar A · Chicago, ILBuilt 1969 · S/N 700006N9341WSleigh Jonathan B · Upland, CAS/N 28-11027N9342FChurchill David J · Bear, DEBuilt 1998 · S/N 18280105N9342HGutierrez Ricardo · Downey, CABuilt 1975 · S/N 17266100N9342JDeschepper Sandra K · Independence, MOBuilt 1966 · S/N 28-3440N9342PTaulbee Gregory · Sarasota, FLBuilt 1969 · S/N 24-4840N9342RCampbell Gene H · Baytown, TXBuilt 1978 · S/N 17702752N9342VClute Charles J · New Smyrna Beach, FLBuilt 1969 · S/N 700005N9342WSmith Bradley W · St George, UTBuilt 1968 · S/N 28-11028N9343DAva Aviation LLC · Tappan, NYBuilt 1982 · S/N 172RG1128N9343MStateline Trucking Inc · Fruita, COBuilt 1966 · S/N 1275N9343VFundora Joel A · Altamonte Springs, FLBuilt 1969 · S/N 700007N9344HBarnstormers Flying Club Inc · Pulaski, TNBuilt 1975 · S/N 17266102N9344JBiamonte Thomas John · Ventura, CABuilt 1966 · S/N 28-3442N9344LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276543N9344PWheeler R Tyson · Frederick, MDBuilt 1969 · S/N 24-4843N9344SScram Branden L · Fairbanks, AKBuilt 1975 · S/N MB-778N9344VOchoa Hougan Michael H · Chino Hills, CABuilt 1970 · S/N 700052N9344WEmery Nelson J · Emporia, KSBuilt 1967 · S/N 28-11031N9345AAdamson Donald R · Lonoke, ARS/N WS1N9345JGrady John O · West Chester, OHBuilt 1966 · S/N 28-3443N9345LHaynie Aviation LLC · Alexander City, ALBuilt 1986 · S/N 17276544N9345MMichael Matthew C · Ames, IABuilt 1966 · S/N 1277N9345PRegistration Pending · Gilbert, AZRegistration pendingBuilt 1969 · S/N 24-4844
Back to AD 87-10-06 R1