OpenAirDocs.org
AD 2012-10-13

Registered aircraft · 13,307

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.

N122CVDonnellan William B · Chattanooga, TNBuilt 2003 · S/N 0450N122DRCirrus Sr22t 1824 Inc Trustee · Wilmington, DEBuilt 2018 · S/N 1824N122ECBronte LLC · Boise, IDBuilt 2024 · S/N 10267N122EPN122ep LLC · Coushatta, LABuilt 2014 · S/N 4138N122ESCooper Anthony · Bainbridge, GABuilt 2015 · S/N 4188N122GWhittier Roger A · Glendale, AZBuilt 2001 · S/N 0009N122GHThompson Jason · River Heights, UTBuilt 2002 · S/N 0175N122GWSew Belmont LLC · Laconia, NHBuilt 2015 · S/N 4225N122HBBych Robert Peter Trustee · Chandler, AZS/N 1762N122HDDadwal Aviation LLC · Seaside, CABuilt 2020 · S/N 4921N122JKBenhaven Aviation LLC · Red Lodge, MTBuilt 2013 · S/N 0473N122JRSisto Donato · Rye, NHBuilt 2023 · S/N 9060N122KMBruce Mellor Inc · Escalon, CABuilt 2001 · S/N 0036N122LGStewart John H · Burlington, COBuilt 1988 · S/N E-2413N122MBSuncrest Industries Inc · Lake Forest, CABuilt 2022 · S/N 8607N122MG122mg Inc Trustee · Wilmington, DEBuilt 2005 · S/N 1250N122MTKing Aviation Services LLC · Marietta, OHBuilt 2019 · S/N 1856N122PBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 2797N122RLuv2av8 · Fort Pierce, FLBuilt 1997 · S/N L IV-169-PN122RSN864sr LLC · Phoenix, AZBuilt 2008 · S/N 3241N122SMCirrus Aircraft LLC · Middletown, DEBuilt 2018 · S/N 1658N122SPPort Cyber Aviation Sr LLC · Austin, TXBuilt 2025 · S/N 11005N122SZValiair Lc Trustee · Casper, WYBuilt 2018 · S/N 1834N122VAVollman David B · Bunkie, LABuilt 2011 · S/N 0163N122VSOrwin LLC · Winter Park, FLBuilt 2014 · S/N 4155N122YWilsbach Kenneth · Fort Myer, VAS/N L2K-249N122ZM122 Zulu Mike LLC · Wheaton, ILBuilt 2018 · S/N 1760N122ZTJdw Aviation Inc Trustee · Wilmington, DEBuilt 2020 · S/N 4882N1230ZC & J Air Inc · Middleton, DEBuilt 1994 · S/N E-2875N1231BRise Companies Aviation LLC · Hawley, MNBuilt 2020 · S/N 2166N1232KCorporate Air LLC · West Mifflin, PABuilt 1984 · S/N 340A1815N1234MDelta Mike Aviation LLC · Darien, CTBuilt 1997 · S/N 29-0127N1234WCuellar Mauricio Dominguez · Tampa, FLBuilt 1970 · S/N 414-0043N1237MJ&C Walker Aviation LLC · Henderson, TXBuilt 1977 · S/N 21061927N1238RLtx Consulting LLC · Austin, TXBuilt 1977 · S/N 340A-0272N123AMC W Myers Holdings LLC · Anthony, NMBuilt 1973 · S/N 340-0245N123AZN123az LLC · Las Vegas, NVS/N EA-498N123BCBlue River Baron 58 LLC · Malcolm, NEBuilt 1977 · S/N TK-41N123BMMb700pv LLC · Greenwich, CTBuilt 2009 · S/N 3513N123CEBas Part Sales LLC · Greeley, COS/N 21061054N123DDCenturion 123 LLC · Glenwood Springs, COBuilt 1974 · S/N 21060627N123DHStrategic Initiative LLC · Onawa, IABuilt 2020 · S/N 2064N123DVInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 1313N123FUGm321go Aviation Group LLC · Prescott, AZBuilt 2012 · S/N 0385N123HBValiair Limited Co Trustee · Casper, WYBuilt 2003 · S/N 0510N123KEDesautels Jean · Laud By Sea, FLBuilt 2023 · S/N 9613N123MCNelson Isaac · Saint Croix Falls, WIS/N 21063578N123PCRegistered aircraftBuilt 2020 · S/N 2110N123PKNunley Lonnie · Show Low, AZBuilt 1998 · S/N LRK-017N123PRAerotransporters Inc · San Juan, PRBuilt 2006 · S/N ES-019
Back to AD 2012-10-13