OpenAirDocs.org
AD 85-02-05 R1

Registered aircraft · 8,921

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:85-02-05-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:85-02-05-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.

N218SAInternational Air Services Inc Trustee · Carson City, NVS/N 24-1877N2190PN2190p LLC · Titusville, FLS/N 23-799N2192WRegistered aircraftS/N 22-2605N2193VApm Leasing LLC · Casper, WYBuilt 1979 · S/N 44-7995266N2194KAviation Training LLC · Wilmington, DEBuilt 1978 · S/N 44-7995203N2195PZahlmann Daniel R · Queen Creek, AZS/N 23-803N2196VFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1979 · S/N 44-7995267N2198ACrowl Jack A · Ashton, IABuilt 1952 · S/N 22-615N2198PAerotrack Inc · Hemet, CABuilt 1956 · S/N 23-808N2199PPowers Edward · Stormville, NYS/N 23-809N219EPEpic Aviation Inc · New Smyrna, FLBuilt 2019 · S/N 4496458N21AQCapiga Daniel P · North Fort Myers, FLBuilt 1973 · S/N 27-7305035N21DPPacific Fleet Aviation LLC · Rochester, NYBuilt 1978 · S/N 27-7854097N21NCBearing Tree Land Surveying LLC · Oklahoma City, OKBuilt 1976 · S/N 27-7654012N21NKSchellhaas Micha R · Joshua Tree, CABuilt 1953 · S/N 22-1186N21PZimmer Katie Lynn · San Antonio, TXBuilt 1958 · S/N 22-6017N21PAHensley Aviation LLC · Telford, TNS/N 30-1255N2202PMacair Aviation LLC · Xenia, OHBuilt 1956 · S/N 23-812N2204XAirgo Inc · Centralia, ILBuilt 1979 · S/N 44-7995281N2209PRuppel Robert E Jr · New Orleans, LABuilt 1967 · S/N 27-3788N220AURunamuck LLC · New Orleans, LABuilt 2025 · S/N 4496617N220FLChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 4496479N2212PHollingshead Terry L · Flint, MIS/N 23-821N2213AShort Colton R · Force, PABuilt 1952 · S/N 20-897N2214ADeuel Arthur B Jr · Williamsport, PABuilt 1952 · S/N 22-621N2214PMaslen Holbrook · Caldwell, IDS/N 23-823N2215ABailey Seth E · Coos Bay, ORBuilt 1952 · S/N 22-630N2216AHolliday Thomas E · Lake City, MIBuilt 1952 · S/N 22-619N2216YPacific Union College · Angwin, CABuilt 1979 · S/N 44-7995290N2217DDaytona Jets LLC · Daytona Beach, FLBuilt 1978 · S/N 44-7995137N221DFMoeckel Herbert R · Tunas, MOBuilt 1958 · S/N 24-242N221ECCorban James E · Starkville, MSBuilt 1953 · S/N 20-979N221FLFox Leasing Group LLC · Hollywood, FLBuilt 2021 · S/N 4496524N2220ANelson David R Trustee · New Richmond, WIBuilt 1952 · S/N 22-638N2220KLach Richard · Weldon, CABuilt 1957 · S/N 22-5761N2220PBryant Stephen C · Anchorage, AKBuilt 1955 · S/N 22-3302N2220XLach Richard · Weldon, CABuilt 1953 · S/N 22-1845N2221PHardin John M · Terrell, TXS/N 23-830N2222AUnruh Isaac J · Blossom, TXFirst renewal noticeBuilt 1952 · S/N 20-914N2222ZParsons John C · Wichita, KSBuilt 1963 · S/N 24-3388N2226ABrandt Benjamin R · Avon, SDBuilt 1952 · S/N 22-624N2227HHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 44-7995173N2229UCalifornia In Nice Inc DBA · San Jose, CABuilt 1979 · S/N 44-7995253N222DUCg 340 LLC · Fountain Hills, AZBuilt 1973 · S/N 27-7305046N222EWGuzman Steven M · Port Saint Lucie, FLS/N 23-1539N222HLDouble K Flying LLC · Scottsboro, ALBuilt 1961 · S/N 24-2670N222KHPavco Inc · Gig Harbor, WABuilt 1973 · S/N 27-7305097N222UClukey David Alan · Bryant Pond, MEFirst renewal noticeBuilt 1957 · S/N 23-912N222WBPower Robert R · Brenham, TXBuilt 1968 · S/N 27-3992N2233PAeroplanes Over Idaho · Caldwell, IDS/N 23-842
Back to AD 85-02-05 R1