OpenAirDocs.org
AD 85-02-05 R1

Registered aircraft · 8,920

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.

N39669Lane Community College · Eugene, ORBuilt 1978 · S/N 44-7995021N39704Sunrise Aviation · Ormond Beach, FLBuilt 1978 · S/N 44-7995026N397PCPapadopoulos Gustave · Summerland Key, FLBuilt 1962 · S/N 24-3189N3980EOse Airspray LLC · Thief River Falls, MNS/N 36-8302022N3982EFresno Westside Mosquito Abatement District · Firebaugh, CABuilt 1979 · S/N 36-7902027N3993EStorm Spraying Serv Inc · Webster City, IABuilt 1978 · S/N 36-7802052N39CRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1970 · S/N 39-4N39JMJads Aviation LLC · Rowlett, TXBuilt 1960 · S/N 23-1943N39KYYang Chi · Lafayette, COBuilt 1979 · S/N 447995304N3HMTalley John T · Clifton, TXBuilt 1965 · S/N 24-4277N3HRDow Glendal R Trustee · Bedford, TXBuilt 1962 · S/N 24-3126N3KEBlevins Myrl Dean · Wytheville, VABuilt 1962 · S/N 22-9244N3MSCarter Zac · Atlanta, GABuilt 1960 · S/N 24-1747N3SDDanish John S · Hooksett, NHBuilt 1958 · S/N 24-380N3SGN3sg Enterprises Inc · Wilmington, DEBuilt 1960 · S/N 24-2036N3UGHoffman William C · Mount Pleasant, PABuilt 1977 · S/N 27-7854050N3XEServ Aero Engineering Inc · Salinas, CABuilt 1963 · S/N 30-92N4008PViento LLC · Nashville, TNS/N 23-1483N4009PApplegate Ronald E · Rosamond, CABuilt 1958 · S/N 23-1484N400CJDeepe Mark D · York, NEBuilt 1964 · S/N 26-5N400EDavis Richard · Reno, NVBuilt 1964 · S/N 26-15N400FKFinazzo Joseph · Fort Mohave, AZS/N 26-47N400FW400fw LLC · Largo, FLBuilt 1964 · S/N 26-51N400GCNorthern Sky Aviation LLC · Harbor Springs, MIBuilt 1965 · S/N 26-80N400GUTriple S Aviation LLC · Wilmington, DEBuilt 1964 · S/N 26-32N400HLSale Reported · Lamesa, TXSale reportedBuilt 1964 · S/N 26-86N400HPMorgan David W · Canton, MIBuilt 1964 · S/N 26-16N400HRDavis Gary L · Burleson, TXS/N 26-118N400KKDennehey Patrick N · Cameron Park, CABuilt 1965 · S/N 26-103N400LBAutumn Crocus LLC · Cincinnati, OHS/N 30-1059N400MJHaney Michael W · Tehachapi, CAS/N 23-1627N400NQN400nq LLC · Gleeley, COS/N 26-29N400PAN6105s LLC · Norwood, NCBuilt 1964 · S/N 26-54N400PPMig Aviation LLC · Sandy, UTS/N 26-28N400SWDay Stephen F · Queen Creek, AZS/N 26-112N400TDHardy Mikel · Twin Falls, IDBuilt 1968 · S/N 30-1708N400VVCarver Aero LLC · Muscatine, IABuilt 2001 · S/N 4496105N400WGRegistered aircraftBuilt 1965 · S/N 26-104N400WLHammer Construction Corp · Miami, FLBuilt 1965 · S/N 26-148N400YKarschney Rich · Seattle, WABuilt 1965 · S/N 26-101N4011PWelke Paul R · Beaver Island, MIBuilt 1958 · S/N 23-1486N4014PGriffing Flying Service Inc · Port Clinton, OHBuilt 1958 · S/N 23-1489N4017P17p LLC · Caddo Mills, TXS/N 23-1492N40193Rearden Logic Inc · Denver, COBuilt 1959 · S/N 24-1239N401MBFly Aztecs LLC · Waterloo, NEBuilt 1977 · S/N 27-7854013N401PJSkylens LLC · Hammond, LABuilt 1968 · S/N 27-4112N40200Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 1973 · S/N 27-7304997N40254Jezior Michael · Midland, MIBuilt 1973 · S/N 27-7305061N40267Island Birds Inc · St Thomas, VIBuilt 1973 · S/N 27-7305080N40279Hhozapnv LLC · Las Vegas, NVBuilt 1973 · S/N 27-7305093
Back to AD 85-02-05 R1