AD 2012-04-10

Registered aircraft · 175

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:2012-04-10')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-04-10')
  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.

N1452HWilliams Saul C · Fairbanks, AKBuilt 1950 · S/N 15AC-521N1455HKephart Walter F · Anchorage, AKBuilt 1949 · S/N 15AC-525N1456HLafrance Edward J · Ellensburg, WAS/N 15AC-524N1459HLuke Daniel J · Burlington, WIS/N 15AC-528N1460HNeeves Aviation And Flying LLC · Sioux Falls, SDBuilt 1950 · S/N 15AC-530N1462HParrott David C · Harrison, MEBuilt 1950 · S/N 15AC-532N1464HKnight Aaron P · Marion, INBuilt 1950 · S/N 15AC-534N1471HWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1951 · S/N 15AC-541N1473HMyburgh Hendrik T · Sunnyvale, CABuilt 1951 · S/N 15AC-543N1475HHebbard Gary D · Bethel, OHS/N 15AC-546N1491HMacveigh Craig A · New Carlisle, OHS/N 15AC-561N150BSSpry Brad T · Walker, MNBuilt 1948 · S/N 15AC-348N159Nelson Chester C · Little Falls, MNS/N 15AC-43N15ACSafran Brian J · Valley City, OHBuilt 1949 · S/N 15AC-341N211HRRopp Harry F · Poplar Grove, ILBuilt 1955 · S/N 15AC-255N2644HWalters Larry C · Wasilla, AKS/N 15AC-256N274HJd Aero LLC · Chester, SDBuilt 1948 · S/N 15AC-289N390LBBesse Bruce B · Soldotna, AKBuilt 1949 · S/N 15AC-473N494AKIngram Allen · Eagle River, AKBuilt 1948 · S/N 15AC-75N5114YHoag Michael R · Three Rivers, MIBuilt 1950 · S/N 15AC-326N538JBNelson Adam · Buckley, WABuilt 1948 · S/N 15AC50N6665KShe-Rat Aviation Inc · Wilmington, DEBuilt 1950 · S/N 15AC-533N699TKStockton Clifford A · Anchorage, AKBuilt 1950 · S/N 15AC-527N823SNNelson Chester C · Little Falls, MNS/N 15AC 464N944EWWells James E · Lansing, NYBuilt 1948 · S/N 15AC-126
Back to AD 2012-04-10