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.

N5833PCochran Keith W · Long Beach, CAS/N 24-914N5833YMyob Group LLC · Ocala, FLS/N 27-2982N5833ZGrossman Larry R · White Pigeon, MIBuilt 1963 · S/N 22-9664N5835PLoya Francisco · Crestline, CAS/N 24-916N5835ZNiemela Blair K · Wasilla, AKBuilt 1963 · S/N 22-9688N5836PShort Final LLC · Murfreesboro, TNBuilt 1959 · S/N 24-917N5836ZGaines Jesse B · Bryan, OHBuilt 1963 · S/N 22-9689N5837PGoodman Wayne A · Conway, SCBuilt 1959 · S/N 24-918N5838PHoughtling Marvin · Pasadena, TXBuilt 1959 · S/N 24-919N5839ZPhillips Michael K · Issaquah, WABuilt 1963 · S/N 22-9692N583NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496253N5841DLeopold Gary L · Winterset, IABuilt 1956 · S/N 22-4520N5842PFlyair Flight Academy LLC · Flint, TXBuilt 1959 · S/N 24-923N5843ZIkenberg H L · Butler, PABuilt 1963 · S/N 22-9697N5844PKoniar Steven L · Newcastle, OKS/N 24-925N5844ZJohnk Willi C II · Donalds, SCBuilt 1963 · S/N 22-9698N5845PGriffel Brandon T · Frederick, MDBuilt 1959 · S/N 24-926N5847YC&C Aviation LLC · Amarillo, TXBuilt 1965 · S/N 27-2998N5849PJinnis Flight Enterprises LLC · Montgomery, TXBuilt 1959 · S/N 24-930N5850PInto The Forest Equipment LLC · Placerville, CABuilt 1959 · S/N 24-932N5850ZMiller Helen J · Springfield, OHBuilt 1963 · S/N 22-9705N5851DRubbert Lorin E · Reynolds, NDBuilt 1956 · S/N 22-4530N5851ZBurklund Joel H · Minneapolis, MNBuilt 1963 · S/N 22-9706N5852DPierce Stephan L · Graham, TXS/N 22-4531N5852ZTuttle James R · Cherryvale, KSS/N 22-9708N5853DHapka Leon J · Halma, MNBuilt 1956 · S/N 22-4532N5853PLewellen Walter G · Moreno Valley, CABuilt 1959 · S/N 24-935N5854DPro West Air LLC · West Point, UTS/N 22-4533N5855DMiller Justin · Boaz, ALBuilt 1956 · S/N 22-4534N5856DStephen George · Land O Lakes, WIBuilt 1956 · S/N 22-4535N5856PDemontalvo Aaron M · Mansfield, TXBuilt 1959 · S/N 24-938N5856YGalett Steven J · Canton, CTS/N 27-2942N5856ZHankins Jon A · Fort Mohave, AZBuilt 1963 · S/N 22-9712N5859PSnider Scott E · Turner, MTBuilt 1959 · S/N 24-941N5859ZInternational Air Services Inc Trustee · Carson City, NVBuilt 1963 · S/N 22-9716N585BN585b LLC · Snohomish, WAS/N 27-4819N585NYPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954012N5860DMunnerlyn Richard L · Sherwood, ARBuilt 1956 · S/N 22-4539N5861DCash David L · Owasso, OKBuilt 1956 · S/N 22-4540N5862ZBitton Robert L · Corbett, ORBuilt 1963 · S/N 22-9719N5863PB E L Flight LLC · Punta Gorda, FLFirst renewal noticeS/N 24-946N5863ZGarner James H III · Sun Lakes, AZBuilt 1963 · S/N 22-9720N5864ZPeterson Josh · Paso Robles, CAS/N 22-9722N5865DWalter John Edward · Wewoka, OKS/N 22-4544N5865PLl Aviation LLC · Saint Joseph, MOBuilt 1959 · S/N 24-948N5866DCheuvront Jevon · Seminole, TXBuilt 1956 · S/N 22-4545N5866PBas Part Sales LLC · Greeley, COBuilt 1959 · S/N 24-949N5867PWickenheiser Kevin John · Detroit, MIBuilt 1959 · S/N 24-950N5867ZDraughon Charles V · Easley, SCBuilt 1963 · S/N 22-9730N5868DObritsch Monte R · Malcolm, NEBuilt 1956 · S/N 22-4547
Back to AD 85-02-05 R1