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.

N6866PDeckard Kyle R · Harrisburg, ORBuilt 1960 · S/N 24-2001N6867BMarx Nathan L · Sauk City, WIFirst renewal noticeS/N 22-4167N6867PAviation Services LLC · Jacksonville, ORS/N 24-2002N6868AFlamingo Air Inc · Cincinnati, OHBuilt 1965 · S/N 27-3096N6868ZC-Fleet LLC · Missoula, MTBuilt 1963 · S/N 25-2574N686ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 2010 · S/N 4496289N6871PHogue Kalum Shane · Monroe, TNBuilt 1960 · S/N 24-2006N6874BSale Reported · Mentor, OHSale reportedS/N 22-4118N6875BCyr Kevin M · Brush, COS/N 22-4119N6875YDodge Stanley R · Pocatello, IDBuilt 1969 · S/N 27-4222N6879AScruggs Ken R · Plain City, OHS/N 27-7954104N6879PCory Ipc Corp · Indianapolis, INS/N 24-2015N687NDAscent Aviation Inc · Duluth, MNBuilt 2014 · S/N 4496373N6880YLavalley Richard G Jr Trustee · Sylvania, OHBuilt 1969 · S/N 27-4228N6880ZMayes Brett R · Williams, CAS/N 25-2605N6882PKrumel Bradley · Omaha, NEBuilt 1960 · S/N 24-2018N6882YFlamingo Air Inc · Cincinnati, OHS/N 27-4231N6886PBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 24-2022N6888PKempf Douglas A · La Center, WABuilt 1960 · S/N 24-2025N6888YFlying W Leasing Inc · Bartlett, ILBuilt 1969 · S/N 27-4240N688MBHill Frank G · Navarre, FLBuilt 1965 · S/N 24-4231N688NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2014 · S/N 4496374N6890PMarble Jere D · Dayton, NVBuilt 1960 · S/N 24-2027N6891PWoods Eric V · Fort Washington, MDBuilt 1960 · S/N 24-2028N6893ZAg Air Squadron Three LLC · Saint Joseph, ILBuilt 1964 · S/N 25-2620N6895KRiemer Emil F · Brush Prairie, WABuilt 1951 · S/N 20-670N6895PDavis Jack J · Rifle, COBuilt 1960 · S/N 24-2029N6896PHwang Andrew S · Emeryville, CABuilt 1960 · S/N 24-2030N6897YReabe Design LLC · De Pere, WIBuilt 1969 · S/N 27-4250N6898PWeigle Alan B · Seward, NEBuilt 1960 · S/N 24-2032N689AW Grotendiek LLC · Portland, ORBuilt 1951 · S/N 22-92N689NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2014 · S/N 4496375N68AH740 Assoc Inc · Wilmington, DEBuilt 1968 · S/N 30-1685N68FSistrunk Donald M · Ragley, LABuilt 1956 · S/N 22-4107N68GPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 301656N68JBOtto Pilot LLC · Everett, WABuilt 1963 · S/N 24-3531N68LRMs Aero Inc · Lakeville, OHBuilt 1966 · S/N 30-1000N68MWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1975 · S/N 27-7554126N68SCBridges Lee P · Smithville, TNBuilt 1964 · S/N 30-633N68SEGateway Flight Center LLC · Port Lavaca, TXS/N 27-3780N68VEK F Aviation Inc · San Juan, PRBuilt 1970 · S/N 27-4457N68WCAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1973 · S/N 31P-7400188N68XLsk Aviation Corp · Wilmington, DEBuilt 1963 · S/N 30-238N6900DMahoney Shane · Auburn, WABuilt 1957 · S/N 22-4827N6900PMyer Charles G · Forest Lake, MNBuilt 1960 · S/N 24-2034N6900ZIndependence Glider Club · Independence, ORBuilt 1964 · S/N 25-2634N6902DFerrell Alan B · Arlington, OHBuilt 1957 · S/N 22-4829N6902YJ L Darr & Son Inc · High Point, NCBuilt 1969 · S/N 27-4256N6903BJones Gary L · Kerrville, TXBuilt 1956 · S/N 22-4175N6903PStack Gregory R · Aurora, COBuilt 1960 · S/N 242037
Back to AD 85-02-05 R1