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.

N61CPFlying Df'S LLC · Dover, DEBuilt 2017 · S/N 4503N61CZWinfort Aviation LLC · Chino Hills, CABuilt 2015 · S/N 1106N61FABulldog Aviation LLC · Dover, DES/N 0739N61GEReal Estate Affiliates Of Telluride LLC · Telluride, COS/N 3229N61GTFogle Dennis · Pella, IAS/N 3824N61JSAltitude & Perspective LLC · Galivants Ferry, SCBuilt 2012 · S/N 3882N61KRUnderground Racing LLC · Helena, MTBuilt 2024 · S/N 10113N61LBBober Ronald J · La Porte, INBuilt 2003 · S/N 61N61SASierra Alpha Holdings LLC · Albany, NYS/N 0677N61TZDrakkon Aviation LLC · Las Vegas, NVBuilt 2025 · S/N 10878N61WEWesco Logistics LLC · Dover, DEBuilt 2023 · S/N 9261N61WPBv Aviation LLC · Milwaukee, WIBuilt 2025 · S/N 10615N61WWKingsboro David · Menifee, CABuilt 1973 · S/N 340-0203N61ZPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2009 · S/N 3411N6202BGamache Daniel S · Pleasanton, CABuilt 1978 · S/N 21062706N6209C8 Waters LLC · Goodyear, AZBuilt 1979 · S/N 21063830N6209PFly Fast Live Slow LLC · Chiefland, FLBuilt 1978 · S/N P21000151N620AAKinser Todd · Custer, SDBuilt 2020 · S/N 2118N620ABViridian Aviation LLC · Centennial, COBuilt 2026 · S/N 11484N620ATAdco Aviation LLC · North Hollywood, CABuilt 2025 · S/N 10687N620DFCirrus Consequences LLC · Jacksonville, FLBuilt 2004 · S/N 1117N620ECRed Fifes LLC · Coos Bay, ORBuilt 2010 · S/N 3620N620HAMerrion Aircorp Inc Trustee · Wilmington, DEBuilt 2021 · S/N 2351N620MVLegends Air Center LLC · Bentonville, ARBuilt 2014 · S/N 4154N620RJLim Flt Inc · San Francisco, CABuilt 2019 · S/N 2014N620TDAct Five LLC · Moultonborough, NHBuilt 2025 · S/N 10759N6211BFleming Patrick J Trustee · Palm Desert, CABuilt 1978 · S/N 21062708N6212CJensen Consulting Service LLC · Valparaiso, INS/N 0240N6218YLucky Star Auto Sales Inc · Grangeville, IDBuilt 1981 · S/N 21064299N6219CAbbott Todd Christopher · Houston, TXBuilt 1977 · S/N 340A0424N621AKelsey John · Casa Grande, AZBuilt 1980 · S/N 21064069N621ARLt Dream LLC · Boerne, TXBuilt 2025 · S/N 10679N621CFArkwell Kathy A · Peoria, ILBuilt 2010 · S/N 3621N621CMRhude Steven A · Niceville, FLBuilt 2015 · S/N 3RX166N621DEDesert Excavating Inc · Yuma, AZBuilt 2002 · S/N TH-2032N621DGQ Continuum LLC · Austin, TXBuilt 2019 · S/N 1897N621EREdair LLC · Fort Lauderdale, FLBuilt 2022 · S/N 8683N621FWFrancis Wayne Ltd · Springfield, OHBuilt 2007 · S/N 2594N621GBCirrus Design Corp · Knoxville, TNBuilt 2009 · S/N 2021N621GGDalsheim John S Trustee · New York, NYBuilt 2023 · S/N 9062N621JCEri Air LLC · Fresno, CABuilt 2026 · S/N 11451N621JPMaster Aviation LLC · Intl Falls, MNBuilt 2025 · S/N 10611N621KAcg Aviation LLC · Longview, TXBuilt 2021 · S/N 5063N621LWMwatts Holdings LLC · Readyville, TNBuilt 2025 · S/N 11002N621RHSchiffer Herbert · West Chester, PABuilt 1991 · S/N E-2654N621RJWheels Up LLC · Ada, OKBuilt 2002 · S/N 0333N621RTLegacy Specialties Inc · Minden, NVBuilt 2022 · S/N 8893N621SLFarm Boys Investments LLC · Los Altos, CABuilt 2005 · S/N 41510N621SMSierra Mike LLC · Crystal, MIBuilt 2025 · S/N 10490N621WYShowalter Richard L · Beckley, WVBuilt 2005 · S/N 1289
Back to AD 2012-10-13