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.

N6508FDi Ioia Mickey · Glen Mills, PABuilt 2004 · S/N 42061N65093Seaman Michael V · Kalispell, MTFirst renewal noticeBuilt 1977 · S/N 21061844N65099Aguirre-Y-Luker Grant C · Santa Fe, NMBuilt 2003 · S/N 40075N6509YColumbia 400 LLC · Reno, NVBuilt 2004 · S/N 41009N6509ZQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 42020N650BDV1vr LLC · Saint Louis, MOBuilt 1979 · S/N 414A0404N650DBValiair Limited Company Trustee · Casper, WYBuilt 1982 · S/N 414A0853N650DSFlight Crew Professionals LLC · Houston, TXBuilt 2001 · S/N 29-0276N650RMAcci Aviation LLC · Conway, ARBuilt 1978 · S/N 414A0031N650SCCrawford Setrige · Alameda, CABuilt 2005 · S/N L2K-216N650SREndpoints & Evidence LLC · Surf City, NCBuilt 2006 · S/N 2221N650XXUbiquitair LLC · San Antonio, TXBuilt 2026 · S/N 11335N65105Hall Herb · Leawood, KSBuilt 2004 · S/N 42059N6510V1903 Aviation LLC · Saint Augustine, FLS/N 42029N6510YSaginaw LLC · Missoula, MTBuilt 2004 · S/N 42057N65118Stormy Pilots LLC · Saint Thomas, VIBuilt 1982 · S/N TJ-437N6511YToys LLC · Cumberland, RIBuilt 2003 · S/N 40073N65123Martin Michael · Galesburg, ILS/N 40077N6512FFunk Norman J · Norfolk, NEBuilt 2003 · S/N 40078N6512RCeresa Glen · Watsonville, CABuilt 2003 · S/N 42014N6512ZNuvo Concepts Corp · El Paso, TXBuilt 2003 · S/N 42017N65131Bas Part Sales LLC · Greeley, COBuilt 2003 · S/N 42027N6513GMarno Aviation LLC · El Paso, TXBuilt 2003 · S/N 42025N6514BN2828 LLC · Highland, WIBuilt 2001 · S/N 40026N6517APeterson Holding Co · San Leandro, CABuilt 1979 · S/N 21063541N6519ABreen Jerry P III · Center Point, TXBuilt 1979 · S/N 21063542N6519NWinged Chariot LLC · Cincinnati, OHBuilt 1982 · S/N EA-319N651AGPoint Zero Ventures LLC · Scottsdale, AZBuilt 2018 · S/N 1665N651BZConsolidated Leasing And Management LLC · Newark, DEBuilt 2025 · S/N 10624N651CPN651cp LLC · Sylacauga, ALBuilt 2010 · S/N 3670N651DBJgm Icarus LLC · Centennial, COBuilt 1976 · S/N 340A0089N651JStuffings Jeffrey F · Longmont, COBuilt 2009 · S/N 311N651JRSumar Electrical Systems Inc · Warren, OHS/N 3491N651XCWoodland Air LLC · Grand Rapids, MIBuilt 2003 · S/N 0475N6526MDapp Eric M · Corvallis, ORBuilt 1977 · S/N 21061973N6527PKaci Property Management Inc · Boise, IDBuilt 1978 · S/N P21000186N6529RN6529r LLC · Merritt Island, FLBuilt 1982 · S/N EA-322N6529YBbd Lynch Family Lp · Houston, TXS/N 21064421N652CDCameronair LLC · Ann Arbor, MIBuilt 2006 · S/N 1794N652JMRed Raider Asset Holdings LLC · Austin, TXBuilt 2019 · S/N 4806N652MHCirrus Aviation Services LLC · Colorado Springs, COBuilt 2007 · S/N 2891N652PTCheddar Air LLC · Missoula, MTBuilt 2014 · S/N 0948N6530YDelgado Gonzalez Hector · San Diego, CABuilt 1981 · S/N 21064422N6531WInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N P21000791N6532NN6532n LLC · Sioux Falls, SDBuilt 1978 · S/N 21063088N65376Sardella Craig J · Gold River, CABuilt 1983 · S/N EA-366N6538NHaynie Ray G · Auburn, WABuilt 1978 · S/N 21063094N653CAAviation Insurance Managers Inc · Uniontown, OHBuilt 2026 · S/N 11226N653DENippert Dwight A · Lancaster, OHBuilt 2020 · S/N 4989N653DGWatson Dallas C · Guthrie, OKBuilt 2003 · S/N 0522
Back to AD 2012-10-13