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.

N4558PAviation Services Of Tn Inc · Dover, DEBuilt 1960 · S/N 27-64N455MKNorth Star Aviation · Mankato, MNBuilt 2024 · S/N 4496580N4560PAmerican Trans Air Training Corp · Virginia Beach, VABuilt 1960 · S/N 27-66N4562YEd Air Inc · Oaktown, INBuilt 1967 · S/N 25-4186N4563VMercer Alexander David · San Diego, CABuilt 1958 · S/N 24-129N4563ZKnutson Wayne R · Thompson, NDS/N 22-8070N4564ZJones Brad · Oak Hill, FLBuilt 1961 · S/N 22-8071N4565AGriswold Joshua M · Wasilla, AKBuilt 1956 · S/N 22-3876N4566ZPackett Roger L · Yachats, ORBuilt 1961 · S/N 22-8074N4567ADonovan Timothy P · Wichita Falls, TXBuilt 1956 · S/N 22-3878N4568ABartlett Michael W · Barron, WIBuilt 1956 · S/N 22-3879N4569YDebilt Bruce A · Berthold, NDBuilt 1967 · S/N 25-4232N456MKPiper Aircraft Inc · Vero Beach, FLS/N 4496657N456PBooth Donald V · Denison, TXS/N 24-3276N4571YDavis James J · Beaver Dam, WIBuilt 1967 · S/N 25-4235N4573ZMatty Elizabeth · Tucson, AZS/N 22-8082N4575PWings Management Co LLC · Rio Rancho, NMBuilt 1960 · S/N 27-84N4576ZBauman Solomon A · Lyle, WAS/N 22-8085N4582ZWriedt Dirk · South Beloit, ILBuilt 1961 · S/N 22-8091N4584ZCompton Michael · Crabtree, ORBuilt 1961 · S/N 22-8093N4586YRiggin Flight Service Inc · Madison, SDBuilt 1967 · S/N 25-4264N45888D-Five Holdings Group LLC · Vidor, TXBuilt 1963 · S/N 24-3453N4588ZEta Of Missouri Inc · Lone Jack, MOBuilt 1961 · S/N 22-8097N458SCAb Prop Plane I LLC · Metairie, LABuilt 2019 · S/N 4496490N4590ZSpeck Daniel N · Waverly, NYBuilt 1961 · S/N 22-8099N4591ZColt Flying Club LLC · Lebanon, PAS/N 22-8100N4593YSoaring Society Of Boulder · Boulder, COBuilt 1967 · S/N 25-4278N4594ZRichard Waldren LLC · Newberg, ORBuilt 1961 · S/N 22-8104N4596ZEscue Dean · Milford, NJBuilt 1961 · S/N 22-8106N4597PGv Air Inc · Medford, ORBuilt 1960 · S/N 27-107N4597ZEgan Richard G · Tallahassee, FLBuilt 1961 · S/N 22-8109N459SCAb Prop Plane I LLC · Metairie, LABuilt 2019 · S/N 4496492N45JLBows Investments LLC · Bend, ORS/N 39-148N45MBWright Kelly A · Spokane, WABuilt 1959 · S/N 24-1445N45PCEllis Kirk W · Gakona, AKBuilt 1955 · S/N 22-3145N4602ZMoorefield Oscar W · Monroe, GABuilt 1961 · S/N 22-8116N4603ZN4603z Colt Flyers LLC · Kenmore, WAS/N 22-8117N4606YAdirondack Soaring Association Inc · Ballston Spa, NYBuilt 1967 · S/N 25-4303N460SCFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 4496551N4610ZGrantham Farley · Bush, LAS/N 22-8124N4611ZRichard Waldren LLC · Newberg, ORFirst renewal noticeBuilt 1961 · S/N 22-8125N4614PHull John W Jr · Palmdale, CABuilt 1960 · S/N 27-126N4616ZBest David Eugene · Newalla, OKBuilt 1961 · S/N 22-8130N4618YEagleville Soaring Club · Eagleville, TNBuilt 1967 · S/N 25-4324N4618ZFilhart Robert · Rosebush, MIBuilt 1961 · S/N 22-8132N4621ZGodbold Donald W · Camden, ALBuilt 1961 · S/N 22-8136N4623ZCordell Ricky L · Fairfield, PAS/N 22-8138N4624YBowers James E DBA · Galloway, OHBuilt 1967 · S/N 25-4337N4625YAir Sailing Inc · Reno, NVBuilt 1967 · S/N 25-4339N4625ZAgnew Alfred Paul · Palm Beach Gardens, FLS/N 22-8140
Back to AD 85-02-05 R1