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.

N1536ACoughlin Edmund Timothy · Manlius, NYBuilt 1951 · S/N 20-732N1538PWassmus Justin A · Riley, MIS/N 22-2415N1539AHall Mark R · New Smyrna Beach, FLBuilt 1951 · S/N 20-735N153LMSkylens LLC · Hammond, LABuilt 1976 · S/N 27-7754019N153WBOster Dale E · Trego, MTBuilt 1966 · S/N 27-3329N1540AMorrill John R · Fort Bragg, CABuilt 1951 · S/N 20-748N1541PFranklin Thomas J · Benton, KSBuilt 1954 · S/N 22-2405N1542PLewis David J · Burlington, IABuilt 1954 · S/N 22-2406N1544ABrunquist Karl · Wasilla, AKS/N 20-740N1545AStein Jay A · Glyndon, MNBuilt 1951 · S/N 20-741N1545PRegistration Pending · Missoula, MTRegistration pendingBuilt 1954 · S/N 22-2409N1549ADirk Chantz M · Rapid City, SDS/N 20-752N1550AGifford Steven K · Buskirk, NYS/N 20-745N155EPGogoplex LLC · Wilmington, DEBuilt 1969 · S/N 27-4430N1562AHansen Jens I · Arroyo Grande, CAS/N 20-768N156DCEaton Billy J · Bridgeport, TXBuilt 1961 · S/N 24-2751N156LMLoup Technologies Inc · Longmont, COBuilt 1966 · S/N 30-1017N156WMFixed Wing Holding Company Inc · Pembroke Pines, FLBuilt 2002 · S/N 4496156N1573AHanson Scott F · Grantsburg, WIBuilt 1951 · S/N 20-803N1576AHile Adam V · Apple Creek, OHBuilt 1951 · S/N 20-790N1577AYoung Carl J · Lubbock, TXBuilt 1951 · S/N 20-812N1577RGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1981 · S/N 278154026N1579ADelap Jay · Collinsville, OKBuilt 1951 · S/N 20-813N157WMYale Companies LLC DBA · Indianapolis, INBuilt 2002 · S/N 4496157N1580ADenton David W · Cedaredge, COS/N 20-814N1589AWilliams Richard P · Sheldon, WIS/N 20-824N158GEarle Norman R · Fairview, NCS/N 23-1521N158WUYale Companies LLC DBA · Indianapolis, INBuilt 2002 · S/N 4496158N1590AChapman Dan W · Soldotna, AKBuilt 1951 · S/N 20-826N1591AKlein Frank J · Riley, KSBuilt 1951 · S/N 20-827N1592ABurbank Kevin L · Boscawen, NHS/N 20-829N1596AMinelli Giovanni · Carmel, CABuilt 1951 · S/N 20-835N1598AEllis Hal R · Colorado Springs, COBuilt 1952 · S/N 20-836N1599APetro Harold J · Des Moines, IABuilt 1952 · S/N 20-841N159BOppold Robert S · Overland Park, KSBuilt 1977 · S/N 27-7754047N159DSynapse USA LLC · Mesa, AZBuilt 1974 · S/N 31P7530012N159RSTechnical Education Services Inc · Virginia Beach, VAS/N 27-2817N159WMFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 2002 · S/N 4496159N15FGShannon Jesse Lee · Boise City, OKBuilt 1975 · S/N 27-7554112N15JEPremier Flight Center LLC · Hartford, CTBuilt 1964 · S/N 27-2494N15JMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1981 · S/N 44-8107060N15KYMcdougle Sean · Oklahoma City, OKBuilt 1965 · S/N 27-2780N15QAQuiet Aero LLC · Fort Myers, FLBuilt 1960 · S/N 24-2388N15REGreat Alaskan Flooring Inc · Kodiak, AKBuilt 1968 · S/N 27-4068N15YPDepartamento De Educacion Prami · San Juan, PRBuilt 1968 · S/N 27-3966N1602PDavis Jacob J · Georgetown, TXBuilt 1954 · S/N 22-2417N160DBAguilar Theodore · Bozeman, MTBuilt 1959 · S/N 23-1670N160KPWorman Clinton L · Volborg, MTBuilt 1954 · S/N 22-2422N160LMMino Leonard G · Pueblo West, COBuilt 1958 · S/N 24-79N160MJFoley Robert A · Columbia, NJS/N 30-1410
Back to AD 85-02-05 R1