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.

N2305PNewell Timothy A · Beach City, OHBuilt 1955 · S/N 22-2716N2306PRicks Electric Plus LLC · Middleton, IDBuilt 1955 · S/N 22-2717N2307AFerry Donald A · Shakopee, MNBuilt 1952 · S/N 22-696N2307PMellish Everett C · La Center, WAS/N 22-2718N2308PRubbert Randy C · Reynolds, NDBuilt 1955 · S/N 22-2719N2309APlitt Benjamin T · Hortonville, WIS/N 22-698N2309PWielinga Pieter F · Hayes, VABuilt 1955 · S/N 22-2720N230JCN230jc Inc Trustee · Wilmington, DEBuilt 1977 · S/N 27-7854011N230MJVne LLC · Sheridan, WYS/N 30-1302N230SUBoelte Aviation LLC · Wilmington, DEBuilt 2026 · S/N 4496639N230SWMartin Co · Tyrone, GABuilt 1971 · S/N 39-37N230UBoard Of Regents · Norman, OKBuilt 2024 · S/N 4496587N2311PCuller Stephen R · Winston Salem, NCBuilt 1955 · S/N 22-2722N2312PMoran Thomas D · Orchard Park, NYBuilt 1955 · S/N 22-2723N2313PWright Michael · Hurricane, UTS/N 22-2724N2313ZT R Gemelli Holding Co LLC · Wilmington, DEBuilt 1979 · S/N 27-8054013N2314ADodson John N · Hernando, MSS/N 22-703N2315PFlood Joseph W · Franklinville, NJBuilt 1955 · S/N 22-2726N2315YMid Continent Aircraft Corp · Hayti, MOBuilt 1980 · S/N 36-8002040N2317AHansen Craig Dan · Idaho Falls, IDBuilt 1952 · S/N 22-717N2319PMood Kathleen T · Carlsbad, CABuilt 1955 · S/N 22-2730N231WURegistered aircraftBuilt 2006 · S/N 4496231N2320MAkl Properties · Westlake, OHBuilt 1979 · S/N 27-7954038N2321PClinton Flying Service Inc · Clinton, NCBuilt 1956 · S/N 22-2732N2322PWilliams John P · Lisbon, OHS/N 22-2733N2323MPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954039N2323PMertens Michael R · Denton, NEBuilt 1955 · S/N 22-2734N2325PCarnahan Thomas L · Wasilla, AKS/N 22-2736N2327PRoa Rembrandt Aguspina · Anchorage, AKBuilt 1955 · S/N 22-2738N2329YHeppe Andrew S DBA · Turner, MTBuilt 1981 · S/N 36-8160002N232YPGill Joshua Daniel · Tucson, AZS/N 24-3401N2330AAllen Christopher S · Aberdeen, SDS/N 22-708N2332AStauffer Michael S · Wichita Falls, TXBuilt 1952 · S/N 22-709N2335PGrosse Martin · Viola, WIBuilt 1955 · S/N 22-2746N2337AHrutkay Charles S · Scenery Hill, PAS/N 20-917N2338XHangar 8 Spray Service LLC · Clark, SDS/N 36-8202007N2339PMulvania Rodney A · Linn, MOBuilt 1955 · S/N 22-2750N2341YFlying G Aviation Inc · Drayton, NDBuilt 1981 · S/N 36-8160010N2342AThomas Todd · Sandy Hook, MSBuilt 1952 · S/N 22-732N2343PStalder Fredrick Bleu · Magnolia, TXBuilt 1955 · S/N 22-2754N2344AYoung Carl J · Lubbock, TXS/N 22-718N2344PVieaux James M · Park Forest, ILBuilt 1955 · S/N 22-2755N2345RBlue Wave Air LLC · Huntsville, ALBuilt 1981 · S/N 27-8154019N234BGLangeland Thomas Arthur · San Antonio, TXBuilt 1965 · S/N 30-909N234PLCole Steven David · Saint Petersburg, FLS/N 31P-7300147N2350ABarlow Kirk A · Eads, COBuilt 1952 · S/N 22-725N2352XFlying G Aviation Inc · Drayton, NDBuilt 1982 · S/N 36-8202012N2352ZPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-8054022N2354ANelson David R · New Richmond, WIS/N 22-724N2358ABedell Samuel G · Fairbanks, AKBuilt 1952 · S/N 20-921
Back to AD 85-02-05 R1