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.

N9117PRenewable Fuels Consulting Inc · Clear Lake, IABuilt 1966 · S/N 24-4595N9119PChapman Charlie Jr · Lubbock, TXBuilt 1966 · S/N 24-4598N911RKBurnley Christopher · Henderson, NVS/N 30-1184N9127PMiscellaneous Metals LLC · Thaxton, MSBuilt 1966 · S/N 24-4607N9128PPeriman Nicholas James · Waxahachie, TXBuilt 1966 · S/N 24-4608N9129PStocker Glen A · Canyon, TXBuilt 1966 · S/N 24-4609N912JKLysiuk Lance · Andover, CTS/N 244980N912PAlf Ix LLC · Chicago, ILS/N 30-951N9130PFarmer Arnol Jr · Kiana, AKBuilt 1966 · S/N 24-4610N9132PEhrenfelt Linda Mae · Pierre, SDBuilt 1966 · S/N 24-4612N9132RCrow Dylan R H · Wilbur, WABuilt 1952 · S/N 20-823N9133PJ&J N2288 LLC · Houston, TXBuilt 1966 · S/N 24-4613N9134PGjdefigo LLC · Gambrills, MDBuilt 1966 · S/N 24-4614N9135PMatthias Michael V · Readlyn, IABuilt 1966 · S/N 24-4615N9137PJackson Thomas A Trustee · Maple Grove, MNBuilt 1966 · S/N 24-4618N9138PSiemering Thomas · Sarasota, FLBuilt 1966 · S/N 24-4619N913APeckenpaugh Dawson S · Worden, MTBuilt 1951 · S/N 22-219N9140PKing Stephen M · Medford, MABuilt 1966 · S/N 24-4621N9141PSilvabar Air LLC · Springfield, VTS/N 24-4622N9142PErickson Ralph E · Foristell, MOBuilt 1966 · S/N 24-4623N9143PSons Aviation LLC · Moody, ALS/N 24-4624N9144PKober Kelly W · West Chester, PABuilt 1966 · S/N 24-4625N9146PBlack Diamond Aviation LLC · Levelland, TXBuilt 1967 · S/N 24-4629N9147PDesouza Ian · Binghamton, NYBuilt 1966 · S/N 24-4631N9148PJohnson T J H · Franklin, MIBuilt 1966 · S/N 24-4632N914CCJ&W Racing And Aviation LLC · Port Saint Lucie, FLBuilt 1967 · S/N 27-3769N914DPGonzalez Ramiro · Lancaster, OHBuilt 1966 · S/N 24-4633N9152PLock Haven 24 LLC · Chandler, AZS/N 24-4637N9153PA&E Aviation LLC · Ruston, LABuilt 1966 · S/N 24-4639N9154PSloan James M Trustee · Grandbury, TXBuilt 1966 · S/N 24-4640N9155DTaylor Glenn Maurice · Fayetteville, GABuilt 1958 · S/N 22-6207N9155PRegistered aircraftBuilt 1966 · S/N 24-4641N9156DTalmadge Jeffery K · New Milford, CTBuilt 1958 · S/N 22-6208N9157PN9157p LLC · Mason, MIBuilt 1966 · S/N 24-4643N915AJb Efta Farms Inc · Argyle, MNFirst renewal noticeBuilt 1951 · S/N 22-218N915BCGentry Jeremiah S · Fort Smith, ARBuilt 1967 · S/N 244673N915HPAnderson Austin C · Washington, DCBuilt 1966 · S/N 24-4371N9160DMalsby Thomas H · Blairsville, GABuilt 1958 · S/N 22-6212N9160PHeath Allen W · Westlake, TXBuilt 1966 · S/N 24-4648N9161PAven Michael D · Georgetown, INBuilt 1966 · S/N 24-4649N9162PBrown Nathan B · Wallace, KSBuilt 1966 · S/N 24-4650N9163DRubbert Jan Dale · Upham, NDBuilt 1958 · S/N 22-6216N9163PMiller Richard Marc Trustee · Dana Point, CABuilt 1966 · S/N 24-4651N9165DNelson Vanessa Jump Trustee · Portland, ORBuilt 1958 · S/N 22-6218N9166PNewman Jeffrey M · Pauline, SCBuilt 1966 · S/N 24-4654N9167PPegasus Unlimited LLC · Arroyo Grande, CABuilt 1966 · S/N 24-4655N9169DLapaseotes George P II · Sidney, NEBuilt 1958 · S/N 22-6222N9169PPorter Christina · Cape Coral, FLS/N 24-4658N916DPGalliot Bond LLC · Atlanta, GAS/N 27-7654183N916RDUssery Donald R · Blytheville, ARS/N 23-1743
Back to AD 85-02-05 R1