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.

N8266YWerner Thomas E · Newark, DEBuilt 1966 · S/N 30-1394N8267CMichie Robert B · Austin, TXBuilt 1954 · S/N 22-2342N8267YMh Aviation Inc · Lancaster, CABuilt 1966 · S/N 30-1395N82688Wells Flying Services LLC · Holdrege, NEBuilt 1977 · S/N 36-7960043N8268YBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 30-1397N82692Piper Aircraft Inc · Vero Beach, FLBuilt 1977 · S/N 36-7960044N8269PEarley Douglas J · Covina, CABuilt 1963 · S/N 24-3522N8269TUniversal Aviators Academy Inc · El Monte, CABuilt 1980 · S/N 44-8107022N826ARobbins Julie A · Burson, CABuilt 1951 · S/N 22-128N826ATAviation Training LLC · Wilmington, DEBuilt 2002 · S/N 4496148N8270CBriscoe Travis L · Archie, MOBuilt 1954 · S/N 22-2345N8270PKraemer And Co Mfg Inc · Orland, CABuilt 1963 · S/N 24-3523N8271YWhitley Miles G · Olathe, KSBuilt 1966 · S/N 30-1400N8273YSkyway Air Service Inc · Wichita, KSBuilt 1966 · S/N 30-1402N8274PVenticinque Raymond A · Cranston, RIBuilt 1963 · S/N 24-3527N8274YTwinkie Transport LLC · Palm City, FLBuilt 1966 · S/N 30-1403N8275CLewis Payton S · Eupora, MSBuilt 1954 · S/N 22-2350N8276ASt Cloud Technical & Community College · Saint Cloud, MNBuilt 1980 · S/N 44-8107023N8278PDewalt Rodney P · Fort Worth, TXBuilt 1963 · S/N 24-3530N827ATAviation Training LLC · Wilmington, DEBuilt 2002 · S/N 4496149N827ECPacific Fleet Aviation LLC · Rochester, NYBuilt 1980 · S/N 27-8154005N8281PDubois Jean-Claude · Midlothian, TXS/N 24-3533N8283PPolzin Thomas H · Chippewa Falls, WIBuilt 1963 · S/N 24-3535N8284PTonry Richard Martin · Georgetown, TXBuilt 1963 · S/N 24-3536N8285PPhillips Dale J · Michigan City, INBuilt 1963 · S/N 24-3537N8286PStage Crew LLC · Clermont, FLBuilt 1963 · S/N 24-3538N8286YCoub Industries Inc · Fairfield, CABuilt 1967 · S/N 30-1422N8287PDeviny William M Jr · Arroyo Grande, CABuilt 1963 · S/N 24-3539N8288PStelter John · Clancy, MTBuilt 1963 · S/N 24-3540N828AYoder Stephen · Melba, IDBuilt 1951 · S/N 22-130N828ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496550N828LUMuldrow Erik · Newport, KYBuilt 1958 · S/N 23-1373N8290CMckinney Steve R · Hamersville, OHBuilt 1954 · S/N 20-1119N8290PEmge Douglas W · Albertville, ALBuilt 1963 · S/N 24-3543N8291CStober John · Goodrich, NDBuilt 1954 · S/N 22-2356N8291PWilcher Trevor C · Macungie, PABuilt 1963 · S/N 24-3544N8292PCharles City Aeronautics Inc · Charles City, IABuilt 1963 · S/N 24-3545N8294CZink Jason A · Belfair, WABuilt 1954 · S/N 22-2359N8294YNenno Richard W II · Bothell, WABuilt 1967 · S/N 30-1432N8296YBl Aviation Services LLC · Camden, DEBuilt 1967 · S/N 30-1435N8297CSullivan Timothy K · Portage, MIBuilt 1954 · S/N 22-2362N8298PBaumann Christopher · Plant City, FLBuilt 1963 · S/N 24-3234N8298YEstes Bernard R · Bumpass, VABuilt 1967 · S/N 30-1437N8299PFischer Dale R · Laporte, INBuilt 1963 · S/N 24-3277N829AHochstatter Patrick J · Moses Lake, WABuilt 1951 · S/N 22-131N82BLSkylens LLC · Hammond, LAS/N 27-7754049N82RJLynch James D Jr · Ocala, FLBuilt 1966 · S/N 30-1049N83003Bravo One LLC · Lewes, DEBuilt 1980 · S/N 44-8107018N8302YArnold Roger R · Jonesville, LAS/N 30-1441N8303PKh And G LLC · Spring, TXBuilt 1980 · S/N 44-8107031
Back to AD 85-02-05 R1