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.

N5468PThompson Kevin A · San Rafael, CABuilt 1958 · S/N 24-525N5468ZJensen Larry F · Millington, MIS/N 22-9247N546KABaer Monte Wayne · Ronan, MTS/N 24-2158N5470YWeber Mark J · Dalton, MABuilt 1964 · S/N 27-2560N5470ZGordon Robert F · Collins, MOBuilt 1962 · S/N 22-9250N5471PN5471p LLC · Roswell, GABuilt 1958 · S/N 24-528N5472ZBanks Steven R · Blue Springs, MOBuilt 1962 · S/N 229252N5473PBloyer Kelly G · Townsend, GABuilt 1959 · S/N 24-530N5474PKrnp Air Services LLC · Zeeland, MIBuilt 1958 · S/N 24-531N54757Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554068N5475ZRaptor Flight LLC · Fort Worth, TXS/N 22-9256N5476ZGroom Aircraft Service LLC · Brownwood, TXBuilt 1962 · S/N 22-9261N54772Watts John J · Murchison, TXBuilt 1975 · S/N 27-7554080N54775Hankins Shannon G · Tulsa, OKBuilt 1975 · S/N 27-7554082N5478PKoch Kenneth J · Middleport, NYBuilt 1958 · S/N 24-537N5478ZKeel Ronald L · Auburn, ALBuilt 1962 · S/N 22-9260N54796Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554097N5479ZFoster Shane Edward · Summerville, SCBuilt 1961 · S/N 22-9257N54808Wsk Inc · Wolfeboro, NHBuilt 1975 · S/N 277554106N54809Mgc LLC · Brandon, FLBuilt 1975 · S/N 27-7554108N5480ZLauritzen Ethan J · Wild Rose, WIS/N 22-9262N54810Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554109N54811Simms Linda Ann Murray Trustee · Westminster, MDBuilt 1975 · S/N 27-7554110N5481PJohnson Ronald I · Fredonia, AZBuilt 1958 · S/N 24-540N5481ZDicenzo Eugene N · Cumberland, RIFirst renewal noticeBuilt 1961 · S/N 22-9263N5484PRussi Kenton S · Caldwell, IDBuilt 1965 · S/N 24-544N54854Registration Pending · Saint Augustine, FLRegistration pendingBuilt 1975 · S/N 27-7554154N54857Mach Tuck LLC · Daytona Beach, FLBuilt 1975 · S/N 27-7554157N54858Advanced Aviation Group LLC · Frederick, MDBuilt 1975 · S/N 27-7554158N5485PGoodlin Scott · Tulare, CAFirst renewal noticeS/N 24-546N54861Fly Car Aviation LLC · North Fort Myers, FLBuilt 1975 · S/N 27-7554159N54862J&P Master Flooring Corp · Lauderdale Lakes, FLBuilt 1975 · S/N 27-7554161N5486PHorton James D · Las Vegas, NVBuilt 1958 · S/N 24-547N54870Senter Carl V · Coeymans, NYBuilt 1975 · S/N 27-7554165N54879Shaw Brian · Granada, COS/N 25-7656025N5487PDotterer Kurt Samuel · Bloomfield, IABuilt 1958 · S/N 24-548N54881Huntsville Soaring Club · Brownsboro, ALBuilt 1976 · S/N 25-7656027N5488PScheuermann Hugo T · Cape Coral, FLBuilt 1958 · S/N 24-549N5488ZLand Cecil J · Goshen, KYBuilt 1962 · S/N 22-9271N54898Central Indiana Soaring Society · Yorktown, INBuilt 1976 · S/N 25-7656032N5489PClarke Adam M · Lompoc, CABuilt 1958 · S/N 24-550N54904Quality Aviation Inc · Marana, AZS/N 25-7656033N54909Soaring Society Of Dayton Inc · Waynesville, OHBuilt 1976 · S/N 25-7656049N54914Csa Foundation Inc · Wellington, COBuilt 1976 · S/N 25-7656055N54915Mohawk Soaring Club Inc · Hoosick Falls, NYBuilt 1976 · S/N 25-7656056N5492PArbuckle Ian A · Montgomery, TXBuilt 1958 · S/N 24-553N5493PGear Up Aviation LLC · Santa Clara, CAS/N 24-554N5493ZMcnabb James A Trustee · Grove, OKBuilt 1962 · S/N 22-9278N5494YSchildberg Gregory M · Casey, IABuilt 1964 · S/N 27-2587N5494ZLanham William B · Mineral Wells, TXBuilt 1962 · S/N 22-9279
Back to AD 85-02-05 R1