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.

N3708PAeromarine Consulting Inc · Brandon, FLBuilt 1955 · S/N 22-3424N3708ZReisman Richard H · Montrose, COBuilt 1960 · S/N 22-7577N3709AGeorge Daniel F · Seldovia, AKBuilt 1954 · S/N 22-1949N370MDAlmost There Air LLC · Daytona Beach, FLBuilt 1972 · S/N 27-4814N370SASharp Spears LLC · Vero Beach, FLBuilt 1979 · S/N 278054005N370TBellas Business LLC · Kalispell, MTBuilt 1958 · S/N 23-1506N3712PPtl Endeavors LLC · Deland, FLBuilt 1955 · S/N 22-3430N3713ZVysoky Jessica L · Edwardsville, ILS/N 22-7584N3715PSeeley Edward J · Las Cruces, NMBuilt 1955 · S/N 22-3433N3715ZThomas Michael D · Dallas Center, IABuilt 1960 · S/N 22-7586N3716AHigh Point Construction Lbk LLC · Lubbock, TXS/N 22-1956N3716POsburn Christie R · Kotzebue, AKBuilt 1955 · S/N 22-3434N3718PNation Richard Vernon Jr · Wellsville, MOBuilt 1955 · S/N 22-3436N3718ZMckinnis James A · West Sunbury, PAS/N 22-7591N3719AWagner James E Jr · Peotone, ILBuilt 1954 · S/N 22-1959N371AMPreuss Andrew J · North Charleston, SCBuilt 1968 · S/N 27-4005N371DSCl Finney Aviation LLC · Benton, KSBuilt 1955 · S/N 23-153N3722AZawada Matthew J · Roberts, MTBuilt 1953 · S/N 22-1963N3724AHoeksel Michael J Sr · Poplar Grove, ILS/N 22-1965N3725ASwan Glenn E · Eagle River, AKFirst renewal noticeBuilt 1954 · S/N 22-1966N3725EWells Flying Services LLC · Holdrege, NEBuilt 1979 · S/N 36-7960055N3725PEnck Ronald L · Corvallis, ORBuilt 1955 · S/N 22-3443N3726PPrimm Jim R · Roswell, NMBuilt 1955 · S/N 22-3444N3727AHackett Joel W · Georgetown, DEBuilt 1954 · S/N 22-1968N3728PChambers Clark B · Wichita, KSBuilt 1955 · S/N 22-3446N3729AAgnew Michael D · Pardeeville, WIBuilt 1954 · S/N 20-1094N372FPMcpeek Isaac S · Barnesville, OHS/N 22-3439N373Clayland Walter · San Rafael, CABuilt 1966 · S/N 30-1374N3732AWil-Mar Corp · Hazen, ARBuilt 1953 · S/N 22-1975N3732PHusain Arif · Pipersville, PABuilt 1955 · S/N 22-3451N3733PCottrell Mark C · Leitchfield, KYS/N 22-3453N3734ASteel Alan P · Odessa, TXBuilt 1953 · S/N 22-1977N3734PHamilton Richard L · Monticello, FLBuilt 1955 · S/N 22-3454N3735ATurner John C · Corinth, MSBuilt 1953 · S/N 22-1978N3736APlitt Benjamin T · Hortonville, WIFirst renewal noticeS/N 22-1979N3736PKelly Larry M · Alexander City, ALBuilt 1955 · S/N 22-3456N3739EPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 36-7960076N3741APrice John C · Bennington, KSBuilt 1953 · S/N 22-1984N3743PBulldog Aviation LLC · Ely, MNBuilt 1955 · S/N 22-3463N3744APhillips Mark W · New Underwood, SDBuilt 1954 · S/N 22-1987N3744PCaplinger Jimmy C · Justin, TXBuilt 1955 · S/N 22-3464N3746ASpivey Harold E · Thomaston, GAS/N 22-1989N3747PRegistration Pending · Sterling, AKRegistration pendingBuilt 1955 · S/N 22-3467N3748PStade Joel T · Iowa Park, TXS/N 22-3468N374PDavhen Aero LLC · Anderson, SCBuilt 1974 · S/N 27-7405410N3750PMartyn Vincent J · Crossville, TNBuilt 1955 · S/N 22-3470N3751AAlpine Aviation LLC · Oasis, IDBuilt 1953 · S/N 22-1994N3751PVilven Jon A · Sweet Springs, MOBuilt 1955 · S/N 22-3471N3753PKarcic Tony M · Prescott, AZBuilt 1955 · S/N 22-3474N3756ACaswell Insurance Services Inc · Yanceyville, NCBuilt 1954 · S/N 22-1998
Back to AD 85-02-05 R1