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.

N8095YN8095y Inc · Oakdale, MNBuilt 1966 · S/N 30-1213N8096PTsacoyianis Jonathan J · Pascoag, RIBuilt 1962 · S/N 24-3345N8098PTaylor Edith E · Como, NCBuilt 1962 · S/N 24-3348N8098YPestair LLC · Wilmington, NCBuilt 1966 · S/N 30-1216N8099YMs Aero Inc · Lakeville, OHBuilt 1966 · S/N 30-1217N809AKeller Gene M · Bethlehem, PABuilt 1951 · S/N 22-114N80FFP A M Aviation LLC · Portsmouth, NHBuilt 1972 · S/N 27-7304958N80HSN80hs LLC · Wilmington, DES/N 31P-7300164N80NDMerrifield Robert Craig · Fitzgerald, GAS/N 24-4164N8100PBaluch Adam · Medina, OHBuilt 1963 · S/N 24-3349N8101DZambrano Holdings LLC · Port Orange, FLBuilt 1979 · S/N 44-8095003N8101PFosters Aviation · Idaho Falls, IDS/N 24-3350N8102PWilliams William G · Lowell, VTBuilt 1962 · S/N 24-3351N8104PPhillips Lester L · Pahrump, NVBuilt 1962 · S/N 24-3354N8105EPockrus Pat · Mineral Wells, TXBuilt 1951 · S/N 22-94N8105PFox Robert · Muskogee, OKBuilt 1963 · S/N 24-3355N8107QTimpanogos Aviation LLC · Saint George, UTBuilt 1960 · S/N 24-2142N8108DKanz Peter J · Wasilla, AKS/N 22-5599N810ATDot Aviation LLC · Wilmington, DEBuilt 2014 · S/N 4496367N8110PBlue Sky Technologies Inc · Laramie, WYBuilt 1963 · S/N 24-3360N8110YM2 Recreation LLC · Wilmington, NCBuilt 1966 · S/N 30-1219N8111YBeckner Bruce Allen · Red Wing, MNBuilt 1966 · S/N 30-1033N8112PButler Tracey D · Buckley, WABuilt 1955 · S/N 222567N8112YHaggerty Patrick E Jr · Dallas, TXBuilt 1966 · S/N 30-1220N8113CCzech Nathanial · Airway Heights, WAS/N 22-2259N8113DHedditch David R · Victor, MTBuilt 1957 · S/N 22-5603N8113PJohnston Consulting Inc · Virginia Beach, VABuilt 1962 · S/N 24-3363N8114DFarago John A · Grapevine, TXS/N 22-5605N8115CKrzywdzinski Douglas E · Beaumont, CAS/N 22-2261N8115DOsborne Richard Tyler · Anderson, SCBuilt 1957 · S/N 22-5606N8117PBluj Solutions LLC · Raleigh, NCBuilt 1963 · S/N 24-3370N8118CAnderson Todd · Dayton, OHBuilt 1954 · S/N 22-2264N8119DHam Keith W · Kasilof, AKS/N 22-5610N8119YStar H Aviation LLC · Plano, TXBuilt 1966 · S/N 30-1229N811ATDot Aviation LLC · Wilmington, DEBuilt 2014 · S/N 4496368N811BCMaki Stephen B · New Port Richey, FLS/N 39-117N811LESmith Colin B · San Diego, CABuilt 1966 · S/N 30-1224N8120PLysford Troy D · Dalhart, TXBuilt 1962 · S/N 24-3373N8120YDevries Dennis J · Owasso, OKBuilt 1966 · S/N 30-1230N8122CJordan Walter B · Chehalis, WABuilt 1954 · S/N 22-2268N8122DCarothers Edward L · Jersey Shore, PAS/N 22-5613N8122PDamico Anthony J · Riverview, FLBuilt 1963 · S/N 24-3375N8124YMatthews Grover C · Hardinsburg, KYBuilt 1966 · S/N 27-3237N8125LHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 44-8095010N8125PIrie Lot LLC · Westminster, COBuilt 1962 · S/N 24-3378N8126DHackleman Brian K · Rochester, NYS/N 22-5617N8126PCsm Holding LLC · Boscobel, WIBuilt 1963 · S/N 24-3379N8127DTrimmer Marvin E · Willow, AKBuilt 1957 · S/N 22-5618N8127YDragon Flight Training Academy LLC · Pembroke Pines, FLBuilt 1966 · S/N 30-1239N8128DBuckner John L · Ragland, ALBuilt 1957 · S/N 22-5619
Back to AD 85-02-05 R1