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.

N5537XKelly Douglas E · Lake Ozark, MOBuilt 1990 · S/N E-2531N5538YTeton View Aircraft Leasing LLC · Grass Valley, CABuilt 1981 · S/N 21064241N553CDMhz Management LLC · Wilmington, DEBuilt 2005 · S/N 1638N553LBLive Big Air LLC · Athens, GABuilt 2015 · S/N 4242N553LPMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1978 · S/N 414A0092N553MCBaggott Properties LLC · Gates Mills, OHBuilt 2013 · S/N 0598N553SPArchangel Investors LLC · Hayesville, NCBuilt 2019 · S/N 1878N553SWHeritage Air LLC · Grove, OKBuilt 1981 · S/N 414A0614N5545AWhelan Peter A · Kettering, OHBuilt 1985 · S/N P21000864N5546Forster Sebastian Alexander · Elberta, ALBuilt 1979 · S/N EA-53N5549AGeoterra Inc · Eugene, ORBuilt 1979 · S/N 21063491N554BCReis Above Aviation LLC · Bismarck, NDBuilt 2013 · S/N 0602N554MCWilliams Michael · Fort Wayne, INBuilt 2006 · S/N 2057N554TMLamar Aviation LLC · Paris, TXBuilt 1992 · S/N E-2688N554UTC172 LLC · Rogers, ARBuilt 2022 · S/N 9014N5550YSteiner Paul R · Boerne, TXBuilt 1981 · S/N 21064245N5551VRegistered aircraftBuilt 1991 · S/N E-2637N5552XJjs Aero LLC · Middletown, DES/N E-2521N5555GSinton Frank J · Durango, COBuilt 1975 · S/N 21061039N5555SSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N P21000417N555AEGibraltar LLC · Van Nuys, CABuilt 2026 · S/N 11404N555AVUpslope Aviation LLC · Boulder, COBuilt 2004 · S/N 0990N555CBEnyedi Alexander Joseph · Plattsburgh, NYBuilt 2011 · S/N 3729N555CPFirebird Air LLC · Fulshear, TXBuilt 1979 · S/N 340A0651N555CTN555ct LLC · Largo, FLBuilt 1981 · S/N 414A0822N555HSEmpty Nest Holdings LLC · Orange, CABuilt 2017 · S/N 1575N555JPMina Mach Partners LLC · Sioux Falls, SDBuilt 2004 · S/N 0970N555KPSkyline Aviation LLC · Sheridan, WYBuilt 2025 · S/N 11096N555LMGrey Sky LLC · Bossier City, LABuilt 1999 · S/N 30-0009N555MGHampshire Blue Skies LLC · Bedford, NHBuilt 1987 · S/N E-2391N555MNThomas David R · Apex, NCBuilt 2003 · S/N 0664N555PDSw Plains Aviation LLC · Ford, KSBuilt 1980 · S/N EA-61N555RCCaron Robert M · Fort Pierce, FLBuilt 1976 · S/N 21061303N555RYA-1 Windshield Inc · Rexburg, IDBuilt 1977 · S/N 21062146N555SBAvia Blue LLC · Emerald Hills, CABuilt 2019 · S/N 4765N555SKJld Resources Management LLC · Helena, MTBuilt 1982 · S/N 21064728N555TJRegistered aircraftBuilt 2000 · S/N 29-0217N555TLTta Holdings LLC · Dublin, GABuilt 2020 · S/N 4970N555TTLight Speed Air LLC · Los Angeles, CABuilt 2012 · S/N 0373N555TYKiefer Karl F · Spring, TXBuilt 1974 · S/N 340-0515N555VAEscape Velocity LLC · Driggs, IDBuilt 2004 · S/N 41033N555VGCordingley Robert · Lafayette, COBuilt 2010 · S/N 3701N555ZGJeminn LLC · Scottsdale, AZBuilt 2004 · S/N 1116N5565DDirect Flight Inc · Vineyard Haven, MABuilt 1989 · S/N TH-1552N55674Frog Air LLC · Amarillo, TXBuilt 1990 · S/N E-2542N5567JVision Aeronautics LLC · Dequincy, LABuilt 2016 · S/N 4424N5569NReverie Aviation LLC · Burbank, CABuilt 1990 · S/N E-2529N556CDSec Ventures LLC · St Charles, ILBuilt 2004 · S/N 1033N556CESt Patrick Reserves LLC · St Louis, MOBuilt 2010 · S/N 3653N556GGCapital Group Logistics LLC · Tallahassee, FLBuilt 2024 · S/N 10139
Back to AD 2012-10-13