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.

N949RD5050 Group LLC · Valley, NEBuilt 2020 · S/N 2181N949WBBirdwin LLC · Buras, LABuilt 2003 · S/N 0447N94EBFlyboyz LLC · Helena, MTBuilt 2021 · S/N 5094N94JKWestwind Aviation Inc · Plantation, FLS/N E-2149N94JVSlikker Benn W · Marana, AZBuilt 1991 · S/N E-2625N94KMBurton Aviation LLC · Burlington, NCBuilt 1997 · S/N TH-1816N94MACox Dennis J · Beach City, TXBuilt 1986 · S/N 46-8608056N94MRMooney Group LLC · Washington, DCBuilt 1994 · S/N 29-0002N94PBBaron 94pb LLC · Tuscaloosa, ALBuilt 1979 · S/N TJ-245N94PSBrierley Michael G Trustee · Sparks, NVBuilt 1980 · S/N P21000469N94PTSmith Edward I · Suffolk, VABuilt 2006 · S/N LIV-494N94RWWithers Dana Ruth Executor · Mount Vernon, ILBuilt 1981 · S/N 414A0662N94TJHuber Robert T · West Chester, PABuilt 2002 · S/N TH2029N94WMGrowth Caddie LLC · Vero Beach, FLBuilt 1988 · S/N 4608114N94YEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1995 · S/N 0044N9502YBci Aviation LLC · Arroyo Grande, CABuilt 1981 · S/N 21064525N950DCParmelee Charles G Trustee · Reno, NVBuilt 1982 · S/N EA280N950PSPlane Services LLC · Twin Falls, IDS/N EA-337N950SRAcme Aero LLC · Kingman, KSBuilt 1979 · S/N 21063698N951CDSea To Sky LLC · Diberville, MSBuilt 2006 · S/N 1833N951POncourse LLC · Miami, FLBuilt 2001 · S/N TH-2015N951PBHare Aviation LLC · Haddam, CTBuilt 2005 · S/N 1449N951PCLeadair LLC · Brattleboro, VTBuilt 2005 · S/N 29-0374N951PRPrp Aviation LLC · Ocala, FLBuilt 2025 · S/N 10971N9527Xie Zhuopeng · Irvine, CABuilt 2006 · S/N 2117N9528YHunt William R · Tucson, AZBuilt 1981 · S/N 21064538N9529CSilver Lining Carpet Care & Restoration LLC · Tallahassee, FLS/N T30300185N952CF A Phoenix LLC · Eldorado, WIBuilt 2002 · S/N 0422N952RTOmega Management Services Inc · North Port, FLBuilt 2006 · S/N 1875N952SVAquitaine Enterprises LLC · Saint Louis, MOBuilt 2022 · S/N 8728N9531BLash Trucking LLC · Goleta, CABuilt 1979 · S/N 21063175N9533YN9533y Corp Trustee · Wilmington, DEBuilt 1981 · S/N 21064539N9535YSpectra Q LLC · Las Vegas, NVBuilt 1981 · S/N 21064540N9536MDsn Holdings LLC · La Crosse, WIBuilt 2014 · S/N 4143N953ABColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2011 · S/N 3815N953DCPhoenix Dkmc LLC · Jackson, MSBuilt 2025 · S/N 10921N953DMMainline Services Co · Wilmington, DEBuilt 1976 · S/N 340A0205N953EGCrc Aviation LLC · Laconia, NHBuilt 2007 · S/N 2417N953MBRegistered aircraftBuilt 2006 · S/N 2149N953MHFlywest LLC · Portland, ORBuilt 2021 · S/N 2349N9549GMacica Stephen J DBA · Truckee, CABuilt 1972 · S/N U20601749N954DTDatesman Miles E · Pittsburgh, PABuilt 2005 · S/N 29-0387N954PGPrime Gencore LLC · Hollywood, FLBuilt 2015 · S/N 4256N954PWWeckbacher Paul J Jr · Inverness, FLBuilt 1981 · S/N U20606288N954TBBlue Sqy LLC · Fort Lauderdale, FLBuilt 2022 · S/N 8617N9556ZIsland Aircraft LLC · Anchorage, AKBuilt 1918 · S/N U20606543N955CBBretthauer Erich W II · Las Vegas, NVBuilt 2008 · S/N 3124N955GBBioventures Leasing Corporation LLC · Brookhaven, GABuilt 1999 · S/N E-3286N955JLFlying4fun LLC · Largo, FLBuilt 2006 · S/N 2099N955JWMike Alpha LLC · Brookfield, CTBuilt 2017 · S/N 4455
Back to AD 2012-10-13