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.

N615CMA Cirrus Life LLC · Santa Barbara, CABuilt 2006 · S/N 2010N615DWMantis Aviation LLC · Arrington, TNBuilt 2022 · S/N 8899N615EMGinther Associates LLC · Hillsdale, NYBuilt 2010 · S/N 3682N615HBButterbean Aviation LLC · Brentwood, TNBuilt 2025 · S/N 10842N615JPBeyer Munch Enterprises LLC · San Antonio, TXBuilt 2007 · S/N 2401N615KN981k LLC · Nashville, TNBuilt 2026 · S/N 11256N615LMPerrett Construction Ltd · Valentine, NEBuilt 2002 · S/N 0412N615LTAlmo Air LLC · Albuquerque, NMBuilt 2021 · S/N 2459N615MBTango Sierra LLC · Kalispell, MTBuilt 2013 · S/N 4029N615MPMorning Star Transportation Inc · Dardanelle, ARBuilt 2001 · S/N 40017N615PCBurning Blue LLC · Greenwood, MSBuilt 1978 · S/N 340A0615N615PJEngelstad Dana P · Midland, TXFirst renewal noticeBuilt 1977 · S/N 340A-0260N615PWCardiac LLC · Amarillo, TXBuilt 2004 · S/N 1157N615PXKempton Robert · Tampa, FLBuilt 2006 · S/N 29-0418N615SALordemann Holdings LLC · Kalispell, MTBuilt 1978 · S/N 340A0427N615SMWjjw Interests LLC · Chappell Hill, TXBuilt 2018 · S/N 1711N615TMMlp Aviation LLC · Phoenix, AZBuilt 2021 · S/N 2435N615TNNagy Timothy E · Franklin, TNBuilt 2024 · S/N 10202N61609Eriksen Bjorn A · Polson, MTBuilt 1981 · S/N 18504235N6161NOn Eagles Wings LLC · Los Gatos, CABuilt 1978 · S/N 21062932N6161ZSkybound Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0019N6162CHeller Casey · Williston, NDBuilt 2003 · S/N 0619N6162XCapital Holdings 149 LLC · Kearney, NEBuilt 2005 · S/N 1371N6167CSnyder Larry G · Holland, NYBuilt 1979 · S/N 21063818N6168NRegistered aircraftBuilt 1978 · S/N 21062939N616ASBrozzo Ralph A · Midland, MIBuilt 2005 · S/N 1428N616ATMartin Ingram Enterprises Inc · Dallas, TXBuilt 2025 · S/N 11008N616BPAesthetic Surgeons Leasing LLC · Birmingham, ALBuilt 2017 · S/N 1602N616CWDixie Air LLC · Russell Springs, KYBuilt 2005 · S/N 1620N616GROld Goat Aviation LLC · Chattanooga, TNS/N TJ-184N616JNBatten Aviation LLC · Lancaster, OHBuilt 2011 · S/N 3770N616MB6mb Partners LLC · Burleson, TXBuilt 2009 · S/N 3493N616MSBledsoe Bobby H · Hot Springs, ARS/N 40047N616RMMnemonics Inc · Melbourne, FLBuilt 1973 · S/N 414-0375N616SGDei Flight Inc · Stoughton, WIBuilt 2014 · S/N 0746N616SJRegistered aircraftBuilt 2025 · S/N 11099N616SPAdmiral Aviation Holdings Lp · Summerville, SCBuilt 2023 · S/N 9753N616ZW16 Paws LLC · Navarre, FLBuilt 2022 · S/N 5141N6170NGarmin210 LLC · Willard, MOBuilt 1978 · S/N 21062941N6171ZTennessee Valley Aviation LLC · Fayetteville, TNBuilt 2003 · S/N 0635N6173RBeyer Livestock Auction LLC · Clovis, NMBuilt 1965 · S/N T210-0073N6174BN6174b LLC · Nokomis, FLBuilt 1978 · S/N 21062698N6177XMayhew William D · Round Lake, ILBuilt 1978 · S/N 310R1316N6178WBlu Sky Key West LLC · Key West, FLBuilt 1981 · S/N P21000724N617CPDaccarett Miguel S · Chicago, ILS/N 3363N617DTCacoum LLC · Boca Raton, FLBuilt 2015 · S/N 4193N617JJAviazione Leoni LLC · Miami, FLBuilt 2009 · S/N 3482N617KHPiscosos Inc Trustee · Wilmington, DEBuilt 2022 · S/N 8837N617PCBurns Keith D Trustee · Tower, MNBuilt 2011 · S/N 0158N617THCain Daniel · Topsail Beach, NCBuilt 2020 · S/N 4876
Back to AD 2012-10-13