OpenAirDocs.org
AD 87-21-02 R1

Registered aircraft · 3,961

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-21-02-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-21-02-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.

N6742TMorris Thomas B · Imlay City, MIBuilt 1960 · S/N 39042N6748TWhalen John J · West Ossipee, NHBuilt 1960 · S/N 39048N6749XSchindele Micheal D · Tolna, NDBuilt 1961 · S/N 310-0049N674CCTrn Aviation LLC · Mcallen, TXS/N 414-0453N674PCLegal Wings I LLC · Overland Park, KSBuilt 1978 · S/N 340A0544N6750TArsic Ranko · Hallendale, FLBuilt 1960 · S/N 39050N6756TStanley M C DBA · Caldwell, IDBuilt 1960 · S/N 39056N6758TGill James L Jr · Hernando, MSBuilt 1960 · S/N 39058N675RVb Flying LLC · Cornelius, NCBuilt 1981 · S/N 414A0634N6760TTregre Gary M · Fort Worth, TXFirst renewal noticeBuilt 1959 · S/N 39060N6765THyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0629N67664Hukill Ryan R · Eagle Point, ORS/N 340A1534N6766TAero Research & Development Corp · Bronx, NYS/N 39066N6767TAviation Career Enrichment Inc · Atlanta, GABuilt 1960 · S/N 39067N676MFCoastal Resource Associates Inc · Christiansted, VIBuilt 1971 · S/N 402B0106N6772XKallhoff Mark R DBA · Canby, MNBuilt 1961 · S/N 310-0072N6777MPineiro Enrique · Miami, FLBuilt 1961 · S/N 310-0073N6779TDoyle Mary · Hampton, IABuilt 1960 · S/N 39079N6779XSmith Peter I Trustee · Ocala, FLBuilt 1961 · S/N 310-0079N677CAHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0631N677HCWashburn Wall Systems LLC · Cedar Rapids, IAS/N 421B0387N677MFCoastal Resource · Christiansted, VIS/N 404-0421N6780XN6780x LLC · Duluth, MNBuilt 1961 · S/N 310-0080N6784XSjc Vii LLC · Lawrence, KSBuilt 1961 · S/N 310-0084N6787XTennis Gayland L · Bath, MIBuilt 1961 · S/N 310-0087N67886Hyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0435N678DBGolden Eagle Flight LLC · Farmington, UTBuilt 1975 · S/N 421B0876N678HDawson Aircraft Inc · Clinton, ARBuilt 1981 · S/N 414A0678N678JGHyannis Air Service Inc DBA · Hyannis, MAS/N 402C0266N678JSGolden Pegasus LLC · Hughson, CABuilt 1978 · S/N 414A0090N67909Hyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0449N6791XEve Scott G · Odessa, TXBuilt 1961 · S/N 310-0091N6792T2a Emergency Site Services LLC · Swainsboro, GABuilt 1960 · S/N 39092N6796VBar Wr Air Services LLC · Dallas, TXS/N 421C1045N6797XJ & W Air LLC · Wilmington, DEBuilt 1961 · S/N 310-0097N6798VGaylord Hangars LLC · Gaylord, MIBuilt 1982 · S/N 421C1254N6798XSale Reported · WurzburgSale reported, pending cancellationS/N 421C1061N679JJClement James H Jr · Dallas, TXS/N 421C0637N67CMSmith Kenneth L · Pomona, CABuilt 1973 · S/N 310Q0977N67JVNext Gen Aviation LLC · Jenks, OKBuilt 1978 · S/N 421C0429N67MLBgdr LLC · Wilmington, DEBuilt 1975 · S/N 340-0519N67RKRiley Matthew · Xenia, OHS/N 310Q1107N67RZModular Aviation LLC · Saratoga Springs, UTBuilt 1981 · S/N 414A0817N6813JHyannis Air Service Inc DBA · Hyannis, MAS/N 402C0641N6814RBbc414a LLC · Alton Bay, NHBuilt 1981 · S/N 414A0638N6815TL A Flyers LLC · Monticello, ARBuilt 1981 · S/N 414A0645N6817DGlasscock Charles W Jr · Elm Grove, LABuilt 1981 · S/N 414A0656N6817TErickson Paul M · Okahumpka, FLS/N 39117N6818XBlue Skys Aero LLC · Vermilion, OHBuilt 1981 · S/N 414A0663N681RCObsidian Air LLC · Pompano Beach, FLS/N 402C0002
Back to AD 87-21-02 R1