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.

N330DPAdvanced Commercial Group LLC · Helena, MTBuilt 2005 · S/N 1417N330FFFarrington Aviation LLC · Houston, TXBuilt 2006 · S/N WCR-107N330HCTf Op LLC · Houston, TXBuilt 2023 · S/N 9223N330MRJett Aviation LLC · Clovis, NMBuilt 1979 · S/N 340A0721N330RMCastle Rock Services LLC · Helena, MTBuilt 1996 · S/N LIV-044N330STBon Air LLC · Chickasha, OKBuilt 2026 · S/N 11292N3313HTriple H Capital Holdings LLC · Newark, DEBuilt 2019 · S/N 2041N33167Twincat Aero LLC · San Diego, CABuilt 2021 · S/N 2311N33189Schrage Rodney L · Steamboat Springs, COBuilt 1975 · S/N U20602659N331APSugar Creek Partners LLC · Rogers, ARBuilt 2021 · S/N 5109N331CBN331cb LLC · Great Falls, MTBuilt 1979 · S/N 21063747N331EDDaniel Dunagan Inc · Rome, GABuilt 2017 · S/N 4544N331KKK&K Aviation LLC · Anthem, AZBuilt 2017 · S/N 1486N331SMApex Aviation LLC · Farmingdale, NYBuilt 2018 · S/N 4630N331STFoothill Fire Protection Inc · Loomis, CABuilt 2024 · S/N 9770N331TFCapital Holdings 244 LLC · Dover, DEBuilt 2024 · S/N 10133N331WGRegistration Pending · York, PARegistration pendingBuilt 2026 · S/N 11509N331WPFms Management System LLC · Dover, DES/N 1718N331WVDeaver John · Waco, TXBuilt 2019 · S/N 1893N3321MMaxray Aviation LLC · Ashland, OHBuilt 1978 · S/N 310R1343N3322XAllgood Michael K · Saint Augustine, FLBuilt 1974 · S/N 310Q1030N332CBFlying Pigs Aviation LLC · Los Altos, CABuilt 2000 · S/N E-3306N332CDDuggar Aviation LLC · Springdale, ARBuilt 2004 · S/N 0873N332DAHanford Equipment LLC · Eagle, IDS/N 3453N332EFalconeer LLC · Gainesville, FLBuilt 2010 · S/N L2K-326N332GTArminair LLC · Dover, DEBuilt 2008 · S/N 3332N332LMLumbra Ronnie E · Rye, NYBuilt 2005 · S/N 1332N332MBLee Aviation Services Co LLC · Pensacola, FLBuilt 2024 · S/N 10002N332MMRan Health Services Inc · Modesto, CABuilt 2025 · S/N 10749N332PKCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11684N332RMCbc Media LLC · Nantucket, MABuilt 2019 · S/N 1986N332TTAlta Vista Enterprises LLC · Sheridan, WYBuilt 2009 · S/N 3525N3332BAirkrapf LLC · Clearwater, FLBuilt 1997 · S/N E-3140N3333MFun Tickets LLC · Manchester, MEBuilt 1981 · S/N 340A1229N3337Chay James M · Kent, WABuilt 1978 · S/N P3370316N333AMLally Glen Joseph · Pleasanton, CABuilt 1975 · S/N 414-0651N333ANNahale Properties LLC · Littleton, COBuilt 2010 · S/N 0055N333AQAqe LLC · San Diego, CABuilt 2024 · S/N 10227N333ARLe Bon Air Inc Trustee · Wilmington, DEBuilt 2004 · S/N 0844N333BCMcfadden John L · Cresson, TXBuilt 1977 · S/N 21061848N333CFTimewarp Aviation LLC · Trout Valley, ILBuilt 2017 · S/N 1691N333DAFavor Michael D · Chico, CABuilt 1976 · S/N 21061289N333GKCenturion210 LLC · Amherst, NHBuilt 1976 · S/N 21061282N333HRWilson Alan E Trustee · Erie, COBuilt 1974 · S/N 21060412N333JRLeonard Reid J · Hilton Head Island, SCBuilt 2013 · S/N 0592N333JTHaidar Aviation LLC · Dallas, TXBuilt 2020 · S/N 2196N333KQQuarles Transportation LLC · Bolivar, MOBuilt 2023 · S/N 9597N333LB333lb LLC · Fort Worth, TXBuilt 1978 · S/N 21062890N333LLNutex Concepts Of North Carolina Corp · Lenoir, NCBuilt 2017 · S/N 4447N333LZSkylane Partners LLC · Memphis, TNBuilt 2011 · S/N 0243
Back to AD 2012-10-13