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.

N6405PSundstrom Raymond C · Ottawa, KSBuilt 1959 · S/N 24-1515N6407PSmith Wesley K · Billings, MTBuilt 1959 · S/N 24-1517N640GCComanche 640gc LLC · Henderson, NVS/N 24-4890N6410PMac Duffie Phillip J · Port Orange, FLBuilt 1959 · S/N 24-1520N6412PHansen Joe C · Wasilla, AKBuilt 1959 · S/N 24-1522N6416YMcm Aviation LLC · Estero, FLBuilt 1967 · S/N 27-3708N6418YWalker Gilbert R · Brentwood, TNBuilt 1967 · S/N 27-3710N6419PHelisur USA LLC · Pembroke Pines, FLS/N 24-1529N641ABroers Daniel Gt · Libby, MTS/N 22-44N6423PPowell Darron L · El Paso, TXBuilt 1959 · S/N 24-1533N6424PChristian Flying Club Inc · Stilwell, KSBuilt 1959 · S/N 24-1534N6426PCloud Bryan S · Phoenix, AZS/N 24-1536N642SWEdgar Thomas L · Flagstaff, AZBuilt 1960 · S/N 24-2316N6430PMitchell Joseph Thomas · Powell Butte, ORBuilt 1959 · S/N 24-1540N6430YFord William E · Minnetonka, MNBuilt 1967 · S/N 27-3728N6432PAlvarez Frank · Hartford, WIBuilt 1959 · S/N 24-1542N6432ZHamlin Timothy S · Bunker Hill, KSBuilt 1961 · S/N 25-585N6435PTriggs Andrew · Las Vegas, NVBuilt 1960 · S/N 24-1546N6439PWalter Sean E · Vancouver, WABuilt 1959 · S/N 24-1551N643SCRegistered aircraftBuilt 1970 · S/N 31P-7N64400Mascari M Richard · Iowa City, IABuilt 1964 · S/N 26-36N6440PMcdonald Patricia Lynn · Westcliffe, COBuilt 1959 · S/N 24-1553N6442PV & E Aviation LLC · Wisconsin Rapids, WIBuilt 1959 · S/N 24-1555N6443PCox William Matthew · Las Vegas, NVBuilt 1959 · S/N 24-1556N6444PSanderson Grain Inc · Springlake, TXBuilt 1959 · S/N 24-1558N6447PTuttle Glenn L · Lynnwood, WABuilt 1959 · S/N 24-1562N6447ZH&H Ag Aviation Inc · New Underwood, SDBuilt 1961 · S/N 25-607N6448PPlowman James C · Upland, CABuilt 1959 · S/N 24-1563N644KSKent State University · Stow, OHBuilt 2006 · S/N 4496220N6451PRoush Benjamin F · Letart, WVBuilt 1959 · S/N 24-1566N6453PHagel Kelton Roy · Carrington, NDBuilt 1959 · S/N 24-1568N6454ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1961 · S/N 25-638N6455PHussey Wilfred Lee II · Martinsville, VABuilt 1959 · S/N 24-1570N6456ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1961 · S/N 25-639N6458PHutchison Joseph C · Mebane, NCBuilt 1959 · S/N 24-1573N6459PJaeger Timothy S · Mukwonago, WIS/N 241574N645RD&S Development LLC · Spring, TXBuilt 1964 · S/N 30-240N645SCDeaton Dennis · Glen Allen, VAS/N 31P-22N645SDDacy Julia A · Harvard, ILBuilt 1964 · S/N 30-524N6460PAlpha Romeo Kilo Holdings Inc · Wilmington, DEBuilt 1959 · S/N 24-1575N6460YRogers Anthony J · Boynton Beach, FLBuilt 1967 · S/N 27-3754N6461PSullenger Charles H · Statesboro, GAS/N 24-1576N6462ZMinden Soaring Club Inc · Minden, NVBuilt 1962 · S/N 25-661N6465PKesser Gilbert M · Culpeper, VABuilt 1959 · S/N 24-1580N6468PTevis Aviation Enterprises LLC · Newcastle, OKS/N 24-1583N646SCRegistered aircraftBuilt 1970 · S/N 31P-33N6470ZNorthern California Soaring Association · Byron, CABuilt 1962 · S/N 25-672N6471PWare Patrick D · Farwell, TXBuilt 1959 · S/N 24-1586N6472YNorman Robert Alan · Zanesville, OHBuilt 1967 · S/N 27-3767N6474ZKoenig Donald J · Las Animas, COBuilt 1962 · S/N 25-678
Back to AD 85-02-05 R1