OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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.

N217BWAuer William E · East Liverpool, OHBuilt 2005 · S/N 81217N217DKHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2018 · S/N 2556N217DLValiair Lc Trustee · Casper, WYS/N T20608224N217HCSwartzendruber Brett E · Hesston, KSBuilt 1963 · S/N 30-166N217JAFlying Colors Airparts Inc · Leesburg, FLS/N 17275623N217JBMccoy Robert G Jr · Marshville, NCBuilt 2002 · S/N 5122N217LFSnyder Aero LLC · Joshua, TXBuilt 1969 · S/N 32-1157N217LMCanada Christopher W · Freeport, FLBuilt 1966 · S/N 28-21972N217PFBixenman Kenneth J · Colby, KSBuilt 1997 · S/N 784-97N217SLegacy Leasing Group Inc · Wilmington, DEBuilt 2003 · S/N 05N217TSLaukatel Air Inc Trustee · Wilmington, DEBuilt 1998 · S/N 4636144N217TXLong Jeffrey E · Dothan, ALBuilt 1997 · S/N 3246070N21802Owen Michael C · Seaside, CABuilt 1978 · S/N 28-7990059N21803Morgan Edward · Gaithersburg, MDBuilt 1978 · S/N 28-7990060N21804Sharpe Alexander F · Camarillo, CABuilt 1974 · S/N 17264026N21809Eckerson Dean H · Benicia, CABuilt 1974 · S/N 17264028N2180EInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 28-7916165N2180FGentle Breezes LLC · Johnson City, TNBuilt 1978 · S/N 32-7940012N2180KRoad Runner Flying Club Inc · Radcliffe, IABuilt 1978 · S/N 28-7911082N2180RRoan Paul J · Clive, IABuilt 1969 · S/N 28-5479N2180TDe Bella Richard M Sr · Blackwood, NJBuilt 1971 · S/N 28-7205027N2180WGerges Amir · Arlington, TXS/N M-1563N2180YAstro Aviation LLC · Cross Plains, TNBuilt 1979 · S/N 28-7990383N2180ZM&M Aero LLC · Wilmington, DEBuilt 1979 · S/N 32-7940102N21819Middlesex Aviation Partners LLC · Bellingham, MABuilt 1974 · S/N 17264029N2181AL&C Ventures LLC · Clovis, NMBuilt 2005 · S/N T18208467N2181BJao Robert V · Kailua, HIBuilt 1978 · S/N 28-7916114N2181NState Of Oregon · Salem, ORBuilt 2004 · S/N 18281339N2181TAdk Flying Club Inc · Ballston Spa, NYBuilt 1971 · S/N 28-7205036N21825Shepherd David K J · Bakersfield, CABuilt 1978 · S/N 32-7840189N2182BFlying 20 Club Inc · Springfield, ILBuilt 1978 · S/N 28-7990124N2182CSkyhunter LLC · Yonkers, NYS/N 17702749N2182FKleen Sheen IV LLC · Bowling Green, KYBuilt 2004 · S/N 18281340N2182KDura Built LLC · Greensburg, KYBuilt 2005 · S/N T18208469N2182QCassett Terry D · Mankato, MNBuilt 1979 · S/N 28-7990297N2182SCimprich Michael J · Kirkland, WABuilt 1979 · S/N R18201311N2182VJavorsek Daniel II · Harriman, TNS/N 32R-7987117N21836C & S Development Services LLC · Weatherford, TXBuilt 1978 · S/N 32R-7885263N2183CVaughn Michael A Jr · Oxford, MIBuilt 1978 · S/N 17702750N2183DLyons Terry L · Springfield, ILBuilt 1978 · S/N 28-7990163N2183KMaven Aviation LLC · Dillon, MTBuilt 1978 · S/N 32-7940022N2183MHayes William F · Philomath, ORBuilt 1979 · S/N 28-7911088N2183PBarney Northcote Inc · Riverside, CABuilt 2005 · S/N T18208470N2183TSkies Unlimited LLC · Clinton Township, MIBuilt 1971 · S/N 28-7205026N2183VMile High Maintanance Inc · Lakewood, COBuilt 1979 · S/N 32R-7987118N2183ZCondor Enterprises Inc · Elkins Park, PABuilt 1979 · S/N 32-7940105N21840Erickson Arnold F · Devils Tower, WYBuilt 1974 · S/N 17264031N21841Erlinger Ronald W · Wickenburg, AZBuilt 1974 · S/N 17264032N2184BPlane Nonsense Inc · Middletown, DEBuilt 1978 · S/N 28-7990125N2184DMeyer David J · Granbury, TXBuilt 1978 · S/N 32R-7985032
Back to AD 87-10-06 R1