AD 85-02-05 R1

Registered aircraft · 8,921

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.

N3283BGay Morgan C · Tunkhannock, PABuilt 1954 · S/N 20-1096N3284BGlover Gary J · Columbia, SCBuilt 1954 · S/N 22-2104N3285PLsop Rentals Premier Asset Management LLC · Gowanda, NYBuilt 1957 · S/N 23-1233N3292PCrosswindz Ranch LLC · Seminole, TXS/N 23-1242N3298PCross Albert B III · Salinas, CABuilt 1957 · S/N 23-1248N329SDAce Flight Center Inc · St Thomas, VIBuilt 1966 · S/N 27-3512N32DMHulme Thomas L · Fountain Hills, AZBuilt 1959 · S/N 23-1692N32JDDuflo Spray Chemical Inc · Bremen, NYS/N 27-372N32RWSkylens LLC · Hammond, LABuilt 1971 · S/N 27-4667N32VUVincennes University · Vincennes, INBuilt 2018 · S/N 4496430N3300BJohnson Rusty E · Enumclaw, WABuilt 1954 · S/N 22-2114N3300ZKoliastasis Pete · Reno, NVBuilt 1959 · S/N 22-7231N3301ASmith Randall P · Fort Worth, TXS/N 22-1583N3301BLux Jason M · King Salmon, AKBuilt 1954 · S/N 22-2116N3301PDramstad Flying Service LLC · Helena, MTBuilt 1958 · S/N 23-1251N3301ZWood Paul S · Lawton, OKBuilt 1959 · S/N 22-7232N3302BNehrkorn Ruediger · Slate Hill, NYBuilt 1954 · S/N 22-2117N3302ZMeginnes Mark A · Tucson, AZS/N 22-7234N3303ZZanis Paul M · Wolfeboro, NHBuilt 1959 · S/N 22-7233N3304BDoty Danial J · Talkeetna, AKBuilt 1956 · S/N 22-2119N3304PBucket List Aviation LLC · San Jose, CABuilt 1958 · S/N 23-1254N3305PAir Royal · Middletown, DEBuilt 1958 · S/N 23-1255N3307PAlbano James R · Oakham, MAFirst renewal noticeBuilt 1958 · S/N 23-1257N3308ARegistered aircraftBuilt 1953 · S/N 22-1580N3308ZWeber Daniel Troy · Port Charlotte, FLS/N 22-7239N3309ZRubbert Randy C · Reynolds, NDBuilt 1959 · S/N 22-7241N330ARegistered aircraftBuilt 1954 · S/N 22-1939N330CPCharlie Pop Flyers Inc · Jacksonville, FLBuilt 1969 · S/N 30-1884N330JGCultra LLC · Naples, FLS/N 24-3042N330KRCherry Hill Aviation Inc · Freetown, INBuilt 1956 · S/N 22-4152N3310AKonrad Robert M · Centennial, COS/N 22-1587N3310BHilgendorf Ross E · Welcome, MNBuilt 1954 · S/N 22-2125N3311ARitchie John A Jr · Gold Hill, NCBuilt 1953 · S/N 22-1586N3311BJackson Tal H · Spearman, TXBuilt 1954 · S/N 22-2126N3312ARegistration Pending · Myerstown, PARegistration pendingBuilt 1953 · S/N 22-1584N3312ZDemontigny Tyler R · Redding, CAS/N 227244N3313BOlling Stanley J Trustee · Wanatah, INBuilt 1954 · S/N 22-2128N3314AMichalek Construction Inc · Keosauqua, IABuilt 1953 · S/N 22-1589N3316AStanley Daniel P · Hindman, KYS/N 22-1593N3316PCrew Sourcing Inc · Wilmington, DEBuilt 1958 · S/N 23-1267N3318BDeane Daniel G · Park City, UTBuilt 1954 · S/N 22-2133N3319AThomas Brian D · Corning, IABuilt 1953 · S/N 22-1595N331GPDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 44-7995277N3320ZHolton Mark · Lebanon, MOBuilt 1960 · S/N 22-7255N3321BLee Donald R · Talkeetna, AKS/N 22-2136N3322AJohnson Ezra M · Rhinelander, WIS/N 22-1598N3322GLone Star Flight Museum · Houston, TXBuilt 1970 · S/N 39-10N3323BCenterville Air Techs LLC · Centerville, IABuilt 1954 · S/N 22-2138N3325AAustin James M · Ft Worth, TXBuilt 1953 · S/N 22-1609N3326PDean Marshall H · El Paso, TXBuilt 1958 · S/N 23-1277
Back to AD 85-02-05 R1