OpenAirDocs.org
AD 85-02-05 R1

Registered aircraft · 8,921

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.

N240LHWitt Aaron K · Hooker, OKBuilt 1966 · S/N 30-1240N240TFAir Fleet Holdings LLC · Missoula, MTBuilt 2023 · S/N 4496558N2412AWetzel Jay L · Xenia, OHBuilt 1952 · S/N 20-924N2412XMid Continent Aircraft Corp · Hayti, MOBuilt 1982 · S/N 36-8302001N24146Wright Jeffrey N · Copper Center, AKBuilt 1961 · S/N 22-8258N2416AKoenig Caleb A · Huntsville, TXBuilt 1952 · S/N 22-782N2417ASitta Donald C · Farmington, NMBuilt 1952 · S/N 22-781N2418ANation Linda S · Sanford, FLBuilt 1952 · S/N 22-784N2418VHart William Kirby · Springville, CABuilt 1960 · S/N 27-81N2419ABoehlke Kevin P · New Baltimore, NYBuilt 1952 · S/N 22-786N2419PRegistration Pending · Lavale, MDRegistration pendingBuilt 1955 · S/N 22-3091N241ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496039N241CFPalermo Michael S · Carter Lake, IABuilt 1957 · S/N 23-1160N241JPNate Nelsen LLC · Enterprise, ALBuilt 1963 · S/N 30-241N241KCChase Kenneth W · Anvik, AKS/N 22-4138N241PBTranstek International Inc · Deerfield, ILBuilt 1964 · S/N 27-2589N241TFAir Fleet Holdings LLC · Missoula, MTBuilt 2023 · S/N 4496559N241TNWilmoth Matthew L · Traverse City, MIBuilt 1979 · S/N 27-7954110N2421PBoyko Matthew · Gilbert, AZBuilt 1955 · S/N 22-2792N2425AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496252N2428PHill Tim E · Russellville, ARBuilt 1970 · S/N 39-64N2431ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 22-787N2432PUnruh Philip Trustee · Harper, KSBuilt 1955 · S/N 22-2803N2433ARyther John W · Austin, MNS/N 20-929N2435PGarst William P · Johnson City, TNBuilt 1955 · S/N 22-2806N2436ASandercock Mark L · Pewaukee, WIS/N 22-789N2437MRock Full Gospel Church · Parkersburg, WVBuilt 1979 · S/N 27-7954058N2438PDavey Kenneth E · Lake Crystal, MNBuilt 1955 · S/N 22-2809N2439PNeal Christopher C · Staples, MNBuilt 1955 · S/N 22-2810N243ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496042N243CGTampa Bay Soaring Society · Zephyrhills, FLBuilt 1972 · S/N 25-5450N243SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1961 · S/N 22-8376N243SDRegistration Pending · Brookings, SDRegistration pendingBuilt 2024 · S/N 4496576N2440DXing Kong Aviation Service LLC · Atwater, CAS/N 4496305N24410Storm Spraying Service Inc · Webster City, IABuilt 1982 · S/N 36-8302012N2441MBlackburn Alan Ryan II · Palm City, FLBuilt 1979 · S/N 27-7954059N2442VBarts Flying Service Inc · Storm Lake, IABuilt 1980 · S/N 36-8060017N2443AGauthier Evans J · Mckinney, TXBuilt 1953 · S/N 22-1096N2444PMcgowan Robert A · Burgaw, NCS/N 22-2815N2445PBolivar Flyers Inc · Brighton, MOBuilt 1955 · S/N 22-2816N2449PSchulze Thomas A · Bloomville, OHBuilt 1955 · S/N 22-2821N244ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496043N244CGEagle Sport Aviation Club Inc · De Leon Springs, FLBuilt 1968 · S/N 25-4734N244RWeiser Inc · Minburn, IABuilt 1973 · S/N 27-7305025N2450PMerit Aviation LLC · Fort Myers Beach, FLBuilt 1955 · S/N 22-2823N2451VHatfield Spraying Service Inc · Nunica, MIBuilt 1980 · S/N 36-8002028N2452PStichter Darin J · Wedderburn, ORFirst renewal noticeBuilt 1955 · S/N 22-2825N2454FOlson Donald C · Golovin, AKS/N 27-2666N2456ADempsey Timothy P · Pacific, MOBuilt 1952 · S/N 22-796N2456PMc Elheny Michael J · Canton, GABuilt 1962 · S/N 24-3153
Back to AD 85-02-05 R1