AD 2012-11-08

Registered aircraft · 177

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-11-08')
    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-11-08')
  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.

N80JVBaker Aviation Consulting LLC · Summerland Key, FLBuilt 2015 · S/N 1207N821KSdl Enterprises LLC · Akron, IABuilt 1931 · S/N 82N827GLEtchart Joseph O · Glasgow, MTBuilt 1978 · S/N 0827N828KLumley William B · Delray Beach, FLBuilt 1932 · S/N 89N833KAshley James M · Greenwood, SCBuilt 1930 · S/N 94N834KHoover Michael B · Ridgeland, WIS/N 95N837KRouth Gary Lee · Lebanon, TNS/N 98N839KMorozowsky Anthony M · Zanesville, OHS/N 103N841HSaure Cameron G · Reynolds, NDBuilt 1929 · S/N 20N849DDBishop David · Butlerville, INS/N 113N856LSlack Troy Trustee · New Concord, OHBuilt 1930 · S/N 117N85GLAviation Insurance Managers Inc · Uniontown, OHS/N 1223N863KCronin Robert B Jr · Candia, NHBuilt 1932 · S/N 124N864KRouth Gary L · Lebanon, TNS/N 125N866KSdl Enterprises LLC · Akron, IABuilt 1930 · S/N 127N86WSPlane Fun Inc Tr Trustee · Snellville, GABuilt 2022 · S/N 1216N874KGreat Lakes Aircraft LLC · Palmer Lake, COBuilt 1929 · S/N 135N87GBertacchi Lawrence · Vineland, NJBuilt 1985 · S/N 1010N87GLPendleton Terry S · Salisbury, NCBuilt 1978 · S/N 0826N882BKRegistered aircraftBuilt 2022 · S/N 1220N909NPreston Robert J · Pittstown, NJBuilt 1930 · S/N 139N915NMadden William L · Las Cruces, NMBuilt 1929 · S/N 145N95HCCrosswell Joe · Springtown, TXBuilt 2016 · S/N 1210N97GLHarrison Christopher J · Danville, CAS/N 0709N997WTRxy LLC · Gilbert, AZBuilt 2023 · S/N 1222N99GLCristy Daron James · La Jolla, CABuilt 1981 · S/N 1005N9GLCampbell Joseph P · Vail, AZBuilt 1974 · S/N 0703
Back to AD 2012-11-08