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.

N7649KHaldeman Enterprises LLC · Vancouver, WABuilt 1950 · S/N 20-470N7650KAltherr James H · Fairbanks, AKBuilt 1950 · S/N 20-471N7651DLehrman Ronald L · Brownsburg, INBuilt 1957 · S/N 22-5360N7652POso Air LLC · Missoula, MTBuilt 1961 · S/N 24-2734N7652YMetro West Ambulance · Hillsboro, ORBuilt 1965 · S/N 30-730N7653PThomason Tony L · Williamson, GABuilt 1961 · S/N 24-2703N7654DDouglas Michael G · Holt, MOBuilt 1957 · S/N 22-5364N7656DBlackford Robert G · Summit Point, WVBuilt 1957 · S/N 22-5366N7656KFrankle Joseph Wilder · Arlington, WABuilt 1950 · S/N 20-477N7656PAnkney Gary L · Rector, PABuilt 1961 · S/N 24-2869N7658KJensen Gregory · Johnston, IAS/N 20-479N7659DJones Emmett F III · Minden, LAS/N 22-5369N7660KGbq LLC · New Prague, MNBuilt 1950 · S/N 20-481N7660PRegistered aircraftBuilt 1961 · S/N 24-2873N7661KJenkins James L · Lake Stevens, WABuilt 1950 · S/N 20-482N7662PRemund Richard W · Slate Hill, NYBuilt 1961 · S/N 24-2875N7663ZGieseke Joe · Tuttle, OKBuilt 1965 · S/N 25-3807N7664KHolzaepfel Carl E · Baytown, TXBuilt 1950 · S/N 20-485N7664PSandpiper Aviation LLC · Carson City, NVBuilt 1961 · S/N 24-2877N7664YSummit Flight Academy LLC · Peculiar, MOBuilt 1965 · S/N 30-742N7665KHicks Robert W · Petersburg, MIS/N 20-486N7669POkst George S · Slate Hill, NYBuilt 1961 · S/N 24-2882N766AAtp Aircraft 6 LLC · Wilmington, DEBuilt 2007 · S/N 4496245N766WTrafford John-Tristan G · Brighton, MIBuilt 1960 · S/N 22-7295N7670KRoss Mark Eric · Polson, MTBuilt 1950 · S/N 20-491N7670PSale Reported · Edenton, NCSale reportedS/N 24-2883N7671YBailey Wryan T · Nashville, TNBuilt 1965 · S/N 30-749N7672KWare Jake · Bovina, TXBuilt 1950 · S/N 20-493N7672PSantore William F · Laguna Niguel, CABuilt 1961 · S/N 24-2885N7672YBertrand Jason · Seattle, WABuilt 1965 · S/N 30-750N7674PChurches Michael D · Smyrna, TNS/N 24-2887N7674YBooth James R · Nevada City, CABuilt 1965 · S/N 30-752N7675PEhrhart Jerry L · Mount Joy, PABuilt 1961 · S/N 24-2844N7676PHanneman Robert D · Denver City, TXBuilt 1961 · S/N 24-2845N7676YCoffman Robert P · Bigfork, MTBuilt 1964 · S/N 30-755N7677KDailing Todd A · Fort Atkinson, WIBuilt 1950 · S/N 20-498N7677PHenderson William C · Grafton, WVBuilt 1961 · S/N 24-2888N7677ZSpurlock Ricky DBA · Jensen, UTFirst renewal noticeBuilt 1966 · S/N 25-3826N7678PMunday Jeff R · Waverly, GAS/N 24-2889N767AUAuburn University · Auburn, ALBuilt 2019 · S/N 4496456N767KPPhill-Air Inc · Dover, DEBuilt 1966 · S/N 30-1193N767PAPurdue Aviation LLC · West Lafayette, INBuilt 2002 · S/N 4496114N767RJS&S Aircraft Inc · Bennington, VTBuilt 1964 · S/N 27-2651N767SCClegg Stephen A · Port Orange, FLBuilt 1977 · S/N 27-7754060N7681YTaft Aviation LLC · Brookhaven, NYBuilt 1965 · S/N 30-759N7683KArne Blair · Carpenter, SDBuilt 1950 · S/N 20-505N7683PCavel Lonnie R · Vidor, TXBuilt 1961 · S/N 24-2892N7684PPache Keith M · Montgomery, TXBuilt 1961 · S/N 24-2893N7685PPinkel Lawrence W · Albuquerque, NMBuilt 1961 · S/N 24-2894N7685YNehrbass Douglas J · Clarksville, TNBuilt 1965 · S/N 30-765
Back to AD 85-02-05 R1