AD 2012-10-13

Registered aircraft · 13,306

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-10-13')
    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-10-13')
  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.

N92PKRun Through Aviation LLC · Roanoke, VABuilt 2011 · S/N 0238N92PRDtc Cirrus LLC · Kalispell, MTBuilt 2016 · S/N 1287N92SXApplied Process Logic Inc · San Luis Obispo, CABuilt 2006 · S/N L2K-254N92WFNpp Aviation I LLC · Teton Village, WYS/N 3763N92WH322ee Aviation LLC · Union, KYBuilt 1977 · S/N 340A0271N92WTCanyon Capital Assets LLC · Newark, DEBuilt 2024 · S/N 10104N9307YRader Drew · Avon, COBuilt 1981 · S/N 21064467N9309YYecny Alan K · San Luis Obispo, CABuilt 1981 · S/N 21064469N930DBKropp Christian Trustee · Azle, TXBuilt 1980 · S/N EA-184N930DGBieker James M · Eatonville, WABuilt 2020 · S/N 4935N930KHDirt Aviation LLC · Rome, GABuilt 2002 · S/N 0317N930MRJbk Aviation LLC · Bradfordwoods, PABuilt 1994 · S/N 29-0003N930SEStevens Neil Larry · Bingham Lake, MNBuilt 2006 · S/N 2254N930SMMask Holdings LLC · Holland, MIBuilt 2026 · S/N 11351N93128High Plains Aero Consulting Inc · Pampa, TXBuilt 1974 · S/N 21060273N93129Klca Inc · Warsaw, INS/N 21060274N93186Bates Byron B · Ethel, WABuilt 1974 · S/N 21060299N931CTCub Aviation LLC · Wilmington, DEBuilt 2008 · S/N 2931N931DRTls Aviation LLC · Kalispell, MTBuilt 2010 · S/N 0047N931PCJac Tay LLC · Saint Louis, MOBuilt 2002 · S/N E-3446N9322TG&G Airplane LLC · Mobile, ALBuilt 2019 · S/N 2031N93262Land Office LLC · Burlington, COBuilt 1974 · S/N 21060324N93274Wltf LLC · Caldwell, IDBuilt 1974 · S/N 21060335N93285Corrie Brent · Vero Beach, FLBuilt 1974 · S/N 21060341N93295Gates Steven · Midlothian, TXBuilt 1974 · S/N 21060347N932TARadioactive LLC · Ft Wright, KYS/N 1537N9330TCrusader 303 LLC · Eugene, ORBuilt 1981 · S/N T30300002N93344Cardinal Headings Ltd · Wilmington, DES/N 21060371N93350Rowe M D Trustee · Bozeman, MTBuilt 1974 · S/N 21060372N93354Utah County Sheriff · Spanish Fork, UTBuilt 1974 · S/N 21060374N93362Bouvier Ellis C · Prineville, ORBuilt 1974 · S/N 21060377N93380Stahla Robert E Trustee · Grand Island, NEBuilt 1974 · S/N 21060384N9338ZBarr Air Patrol LLC · Mesquite, TXBuilt 1981 · S/N U20606404N933CDCook Larry · Midland, TXBuilt 2004 · S/N 1233N933DHBonanza Associates Llp · Colorado Springs, COBuilt 2003 · S/N 0772N933WPMed Shuttle LLC · Jackson, TNBuilt 2016 · S/N 4370N934CRReygar Investments LLC · Brownsville, TXBuilt 1982 · S/N 414A0856N934DRCtrg Aviation Holdings 2 LLC · Lakeway, TXBuilt 2018 · S/N 1822N934PCBennell Ltd LLC · Naples, FLBuilt 2002 · S/N E-3448N934SYAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2024 · S/N 9934N934VFinke Wailes · Charleston, MSBuilt 1975 · S/N D-9739N9353YKovax Aviation LLC · Youngstown, OHBuilt 1981 · S/N 21064482N9356YParsons Bruce W Trustee · Costa Mesa, CABuilt 1981 · S/N 21064483N935CDRussell Ronald W · Auburn, ALBuilt 2003 · S/N 0454N935DRDd LLC · Wilmington, DEBuilt 2021 · S/N 2347N935SRSmaistrla Jeffrey L · Montgomery, TXBuilt 2007 · S/N 2482N935TSLvta Holdings LLC · Dundee, OHBuilt 2009 · S/N 3446N9369YBk Aviation Services LLC · Yorba Linda, CABuilt 1981 · S/N 21064488N936BCChase Brandon M · Granbury, TXBuilt 2023 · S/N 9513N936CMContinental Aerospace Technologies Inc · Mobile, ALBuilt 2007 · S/N 2447
Back to AD 2012-10-13