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.

N8540YCli Aerospace LLC · Appleton, WIS/N 30-1568N8542PPro Aviation LLC · Allen, TXS/N 26-123N8542YAviation Training Solutions LLC · Hilo, HIBuilt 1967 · S/N 30-1598N8543DHuntwork Dayna · Boise, IDBuilt 1957 · S/N 22-5774N8544CNixon H M · Wayne, NJBuilt 1953 · S/N 22-1256N8544DThames James W · Florence, ALBuilt 1957 · S/N 22-5775N8544LMid Continent Aircraft Corp · Hayti, MOBuilt 1971 · S/N 25-5420N8544PSetzler Frank · Gilbert, AZBuilt 1964 · S/N 24-4001N8545DFour-Five-Delta LLC · Mountainville, NYBuilt 1957 · S/N 22-5776N8547PStewart James David · Mesa, AZBuilt 1964 · S/N 24-4004N8548CMapes Peter B · Oscoda, MIBuilt 1953 · S/N 22-1251N8548LNiagara Soaring Club Inc · Williamsville, NYBuilt 1969 · S/N 25-4968N8549PWest Texas Weather Modification Association · San Angelo, TXBuilt 1964 · S/N 24-4006N854NDAero Equities LLC · Ventura, CABuilt 1989 · S/N 4495008N8550DRiester Gary R · Navarre, FLS/N 22-5782N8550LHigh Desert Soaring Clubinc · Bend, ORBuilt 1969 · S/N 25-4970N8550PNick Smith And Associates Inc · Mcallen, TXBuilt 1964 · S/N 24-4007N8551LQuality Avition Inc · Marana, AZS/N 25-4971N8551PBratcher Troy L · Williston, NDS/N 24-4008N8552DSvec Adolph Ralph · Marengo, ILBuilt 1957 · S/N 22-5784N8552LWhittington John H Jr · Dillon, SCBuilt 1971 · S/N 25-5423N8554DParks Alan J · Homer, AKBuilt 1957 · S/N 22-5786N8555Bank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 44-8207002N8555LNorth Shore Aircraft Leasing Co LLC · Waialua, HIBuilt 1969 · S/N 25-4976N8555YScharf Mark T · Rosamond, CAFirst renewal noticeBuilt 1968 · S/N 30-1702N8556PLandis Ehrin · Redding, CABuilt 1964 · S/N 24-4013N8557DWells Michael D · Wilton, MEBuilt 1957 · S/N 22-5789N8557PQuaal Ranch Inc · Sundance, WYS/N 24-4014N8558LStar Ads Inc · Torrance, CABuilt 1971 · S/N 25-5418N8558PBaughman Kevin R · Avinger, TXBuilt 1964 · S/N 24-4015N8558YFritsch Nathaniel · Ettrick, WIBuilt 1968 · S/N 30-1705N8559PMcclean Adam D · Lakeport, CABuilt 1964 · S/N 24-4016N855AVD & J Training Planes LLC · Logan, UTBuilt 1978 · S/N 44-7995174N8560DMachovsky Andrew J · Mesa, AZS/N 22-5794N8560LKnutson Wayne R · Thompson, NDS/N 25-4981N8560YSullian John J · Alexandria, VAS/N 30-1707N8562PRegistration Pending · Waukee, IARegistration pendingBuilt 1965 · S/N 24-4019N8564YGingers Holdings Inc · Jacksonville, FLBuilt 1968 · S/N 30-1711N8565PLynn Owen P · Vinemont, ALS/N 24-4021N8566PRicciardi Brian · Dennis, MABuilt 1964 · S/N 24-4022N8566YClarke George W III · Sierra Vista, AZBuilt 1968 · S/N 30-1714N8567PJeewek Rita M Trustee · Parma, OHBuilt 1964 · S/N 24-4023N8567YJohnson Randy D · Becket, MAS/N 30-1715N8569PPurpose Flight Inc · Wilmington, DES/N 24-4026N856NDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1989 · S/N 4495001N8571PBrackett William E · Capitan, NMBuilt 1964 · S/N 24-4028N8572LSky Soaring Inc · Hampshire, ILBuilt 1969 · S/N 25-4996N8572PService Drug DBA · Chadron, NEBuilt 1964 · S/N 24-4029N8573PMounicou Sonny M · Olive Branch, MSBuilt 1964 · S/N 24-4030N8577PPrice Isaac H · Flat Rock, ALBuilt 1964 · S/N 24-4034
Back to AD 85-02-05 R1