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.

N40HYHendrickson Dale W · Denton, TXBuilt 2002 · S/N 2205N40JTav8rs LLC · Tea, SDS/N 001N40JAJersey Aero Club Inc · Lakewood, NJBuilt 1985 · S/N 28-8616036N40JEReddy Subash C · Huntingdon Valley, PABuilt 1993 · S/N 27-0161N40JGSimms Charles Jr · Lexington, KYBuilt 1968 · S/N 28R-30953N40JKMann Nathan · Poulsbo, WABuilt 2022 · S/N 11480N40JMAll Breeds Combined LLC · Kalispell, MTS/N 540-2011N40JSAir Flight Enterprises Inc · South Daytona, FLS/N 24-3269N40JVWhiting Andrew W · Mentor, OHBuilt 1977 · S/N 80N40KHMccormick Robert E · Selah, WABuilt 1979 · S/N 13082N40KLConstantine Lucas L · Inglewood, CAS/N 40.316N40KMFlight Tech LLC · Prosser, WABuilt 2000 · S/N 23063CN40KPZoie Air LLC · Fort Lauderdale, FLBuilt 2003 · S/N 30030CN40LHSale Reported · Prineville, ORSale reported, pending cancellationBuilt 1994 · S/N 27-0178N40LWMorgan Aviation LLC · Oak Harbor, WABuilt 1975 · S/N 27-7554146N40LYAsh Gary W · Houston, TXBuilt 1978 · S/N 17270900N40MBAndersen Thomas · Yoder, COS/N 708N40MGFly Arkansas LLC · Harrison, ARBuilt 1959 · S/N TD-293N40MRWennberg Timothy J · Mariposa, CABuilt 1979 · S/N 001N40MUOracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264170N40NCJones Edward B · Valdese, NCBuilt 1980 · S/N 32-8006014N40NZGround Effect LLC · Atascadero, CABuilt 1974 · S/N 32-7440171N40PXHealey David A · Hammondsport, NYBuilt 2003 · S/N 14110CN40PZHaagenson Trevor · Portland, ORBuilt 2006 · S/N 155N40RGDovy Aviation LLC · Houston, TXBuilt 1974 · S/N 17263241N40RSSaul Gregory D Jr · Glenrock, WYBuilt 1960 · S/N 24-2031N40RZTwin Trails LLC · Draper, UTBuilt 1995 · S/N 4636009N40SASemper Fi Aviation LLC · Brooksville, FLS/N 32-111N40SFSterling Flight Training LLC · Jacksonville, FLBuilt 2020 · S/N 2881377N40SPSmith Terry G · Liberty Twp, OHBuilt 1980 · S/N 17274099N40STAvera Stewart · Pensacola, FLBuilt 1997 · S/N T106AN40SYTouchandgo LLC · Hilton Head Island, SCBuilt 1976 · S/N 32R-7680271N40TBTowe Wyley · Rogersville, MOBuilt 1997 · S/N 27-0232N40TDWinick Evan K · Allentown, PABuilt 2006 · S/N 1N40TMN40tm LLC · Wilmington, DEBuilt 1966 · S/N 1063N40TPDraco Flight School DBA · Chino, CABuilt 1981 · S/N 17274723N40TUParrot Cay LLC · Missoula, MTBuilt 1978 · S/N 18-7809143N40VKSimply Living LLC · Fort Myers, FLBuilt 1966 · S/N 24-4473N40VVFaulkner Winthrop S · Anchorage, AKS/N 005N40VXHarder Steven R Trustee · The Sea Ranch, CABuilt 1998 · S/N 5040N40VZJump Jet LLC · Fort Worth, TXBuilt 2021 · S/N 40N40WFGrennell Brian M · Euless, TXS/N 30-971N40WNRider Rebecca L · Hyde Park, NYBuilt 1968 · S/N 17700829N40XEFly Diamond Da40 N40xe LLC · Kalispell, MTBuilt 2002 · S/N 40.208N40XPRegistration Pending · Dallas, TXRegistration pendingBuilt 1976 · S/N K-040N40YLMeggers Roger D · Baker, MTBuilt 1996 · S/N 1327N40ZMArmour Anthony E · Ringgold, GABuilt 1993 · S/N 27-0169N4100FGoldberg Mark · Massapequa Park, NYBuilt 1976 · S/N 28-7715006N4100PValley Flying LLC · Stuarts Draft, VABuilt 1959 · S/N 23-1580N4100YLofton Charles T · Georgetown, MNBuilt 1976 · S/N 944-76
Back to AD 87-10-06 R1