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.

N2708SQuiroga Herman R · Phoenix, AZBuilt 1979 · S/N 335-0032N2708TCae Aviation LLC · Peshtigo, WIBuilt 1979 · S/N 335-0033N2708YWings Aircraft LLC · New Richmond, WIBuilt 1979 · S/N 335-0035N2709BA&R Investments Inc · Sylvania, OHBuilt 1979 · S/N 335-0037N2709RSchultz Daniel A · Tipp City, OHS/N 335-0039N270ADRay Dani · Fall River, MABuilt 2017 · S/N 1533N270ARDuffy Kevin · Manchester Center, VTBuilt 2024 · S/N 10138N270MRFurtado William J III DBA · Fremont, CABuilt 1976 · S/N 21061660N270MWM9 Aviation Ventures LLC · Philadelphia, PABuilt 2003 · S/N 0735N270RCEagle 1-N270rc LLC · San Juan, PRBuilt 1980 · S/N 402C0269N270WL270wl Aviation LLC · Owensboro, KYBuilt 2023 · S/N 9567N2710JPeople Incorporated Of Virginia · Abingdon, VABuilt 1979 · S/N 335-0043N2711NMountain Air Aviation LLC · Fruit Heights, UTBuilt 1980 · S/N 335-0050N2712FDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N 402C0121N2714CLipcon James P · Stow, MABuilt 2005 · S/N 1393N2715TDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 402C0214N2718YRichland Aviation Inc · Sidney, MTBuilt 1979 · S/N 402C0232N271CPCharlie Hotel Mike LLC · Lincoln, NEBuilt 2010 · S/N 0044N271EOuray Ventures LLC · San Diego, CABuilt 2015 · S/N 1157N271NPJust Plane Stuff Inc · Jackson, MSBuilt 2024 · S/N 10043N271PBClark Mayer Aviation LLC · Cross Roads, TXBuilt 1997 · S/N TH-1840N271SRGriffin James R · Pinedale, WYBuilt 2007 · S/N 2714N271WMFarm Dog Holdings LLC · Reedley, CABuilt 2024 · S/N 9931N2720ABaron N2720a LLC · Faulkton, SDBuilt 1978 · S/N TK-69N2727LAircraft Trustee Services Inc Trustee · Dover, DES/N 414A0602N2729LVip Wellness LLC · Victoria, TXBuilt 1979 · S/N 414A0431N272CDSegers Ernst E · Pensacola, FLBuilt 2010 · S/N 3541N272CSTres Vientos LLC · Santa Fe, NMBuilt 2011 · S/N ESP-217-16N272CTInncal Inc · Stockton, CABuilt 1993 · S/N E-2824N272DDelta Delta Aviation LLC · Pickerington, OHBuilt 2021 · S/N 5095N272EVSanderlin Aviation LLC · Seattle, WABuilt 2026 · S/N 11477N272HMBas Part Sales LLC · Greeley, COBuilt 2015 · S/N 1079N272RHLewis Coleman · Dallas, TXBuilt 2008 · S/N 3054N272TMRam Precision Industries Inc · Dayton, OHBuilt 2017 · S/N 1655N2730MSua LLC · Artesia, NMBuilt 1980 · S/N 414A0437N2730PRegistration Pending · Palm Harbor, FLRegistration pendingBuilt 2005 · S/N 41071N2732TJellor Realty Inc · Los Angeles, CABuilt 1979 · S/N 414A0449N2734BStella Air Inc · Wyoming, PABuilt 1979 · S/N 414A0454N2734GSplit Rock Aerospace LLC · Southport, CTBuilt 1979 · S/N 414A0456N2735JAlpha 414a LLC · New Smyrna Beach, FLBuilt 1980 · S/N 414A0466N273DTN273dt LLC · Abilene, TXBuilt 2013 · S/N 0652N273DVD&K LLC · Sioux Falls, SDBuilt 2013 · S/N 4024N273ESTailwinds Aviation LLC · Windham, NHBuilt 2005 · S/N 1609N273MMValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 11078N273NFTrk Management LLC · Punta Gorda, FLBuilt 2016 · S/N 4407N273RVMev Aviation LLC · Fort Lauderdale, FLBuilt 2021 · S/N 5001N2740TKraybill Paul D · Portola Valley, CABuilt 1979 · S/N 310R1843N2742HWilbert John W III · Plaquemine, LABuilt 1979 · S/N 340A0929N2743JColman Scott · Tampa, FLBuilt 1976 · S/N 21061690N2744PTouchdown LLC · Pls Vrds Est, CABuilt 1979 · S/N 340A0941
Back to AD 2012-10-13