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.

N313NRDawn Patrol LLC · Portsmouth, NHBuilt 2024 · S/N 10209N313RWSarp Rentals LLC · Loudon, TNBuilt 1969 · S/N 414-0010N313SCCirrus N7580 LLC · Valparaiso, INBuilt 2024 · S/N 10122N313SRTrust Your Fronts LLC · Miami, OKBuilt 2006 · S/N 1978N313TF313tf Aviation LLC · Superior, WIBuilt 2004 · S/N 1237N313TLSmallwood Aviation LLC · Nokesville, VABuilt 2024 · S/N 9965N313VBVernor Air LLC · Harbor Springs, MIBuilt 2016 · S/N 4361N313VFRegistered aircraftBuilt 2025 · S/N 10405N313WTCinotto Robert L · Rhome, TXBuilt 1979 · S/N P21000350N31416Pterosaur Holdings LLC · Scarsdale, NYBuilt 2018 · S/N 4665N3144YSierra Bravo Zulu LLC · Middletown, DES/N E-2437N3147LBrowning Charles H III · Woodbine, MDBuilt 1994 · S/N E-2882N3148PSky Hi Aviation LLC · Wilmington, DEBuilt 1977 · S/N 210-61945N314AAlien Air LLC · Missoula, MTBuilt 2006 · S/N 2061N314CPWilbury LLC · Las Vegas, NVBuilt 2008 · S/N 3234N314DGLaminar Holdings LLC · Sheridan, WYBuilt 2007 · S/N 260N314DSFlyers Unlimited LLC · Tucson, AZBuilt 2005 · S/N 1705N314HBMarc Inc · Bolton, MSBuilt 1979 · S/N 310R1586N314KD314 Aviation LLC · Carlisle, PABuilt 2024 · S/N 10165N314KFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 2456N314PKKelsey Excavating Inc · Davis, ILBuilt 2006 · S/N 1779N3151JStava Robert D · Brainard, NEBuilt 1980 · S/N T18803609TN31526Trostel Manfred E · Longboat Key, FLBuilt 1989 · S/N E-2487N3152ERegional Medical Consulting Pllc · Mebane, NCBuilt 1994 · S/N E-2880N3153BSeverson James A Jr · Tualatin, ORBuilt 1983 · S/N P21000834N3153PWhiskey Mike Aviation LLC · Merrimac, WIBuilt 1994 · S/N E-2884N3154FMetcalf Management Inc · St George, UTBuilt 1994 · S/N EA-564N3156XBack Country Aviation LLC · Jupiter, FLS/N 20700376N315AHHorizon Aviation Holdings LLC · Fort Lauderdale, FLBuilt 2019 · S/N 4789N315CACirrus Middle East Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11466N315CDFranklin Clinton · Edmond, OKBuilt 2004 · S/N 0947N315CEAddonizio Victor Paul III · Long Island City, NYBuilt 2011 · S/N 0111N315CKMarket-Partners Inc · Santa Rosa, CABuilt 2009 · S/N 3413N315DBBooker Daniel R · Newaygo, MIBuilt 2005 · S/N 1596N315GTN315gt LLC · Naperville, ILBuilt 2014 · S/N 0922N315JRStarkweather James · Southwest Ranches, FLBuilt 2005 · S/N 1604N315JSAmore Industries LLC · Greer, SCBuilt 2015 · S/N 4200N315MCDeeds Brian A · Meridian, IDBuilt 2017 · S/N 1651N315NLBestrand Aviation LLC · Cincinnati, OHBuilt 2017 · S/N 4586N315PZPizzo Philip · West Sacramento, CABuilt 2024 · S/N 10340N315RTTidwell Consulting LLC · Phil Campbell, ALBuilt 2016 · S/N 4387N315SRMarciniak Paul D · Lebanon, TNBuilt 2007 · S/N 2315N315TARegistered aircraftBuilt 2018 · S/N 1726N315VGValiair Limited Co · Casper, WYBuilt 2023 · S/N 9530N315XRegistered aircraftBuilt 2025 · S/N 10900N3160LKo Hee Sun · Norwood, NJBuilt 1975 · S/N U20602815N31644Aquarius Aviation Inc · Miami, FLBuilt 1988 · S/N E-2442N316ABRegistered aircraftBuilt 2006 · S/N 2079N316BCBc Air LLC · Great Falls, VABuilt 2024 · S/N 10358N316BW345ds Capital Holdings LLC · Scottsdale, AZBuilt 2025 · S/N 11104
Back to AD 2012-10-13