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.

N819DCLegacy Air LLC · Missoula, MTBuilt 2017 · S/N L2K-302N819DKBankston David P · Horseshoe Bay, TXBuilt 1983 · S/N EA-387N819GPTrustees Of Purdue University · West Lafayette, INBuilt 2011 · S/N 0253N819LAMukherjee Jason S Trustee · Simi Valley, CABuilt 1994 · S/N E-2869N819XInternational Air Services Inc Trustee · Carson City, NVBuilt 2012 · S/N 0433N81AEZoomair LLC · North Muskegon, MIBuilt 2023 · S/N 9304N81AJAircraft Propulsion Leasing LLC · Holland, OHBuilt 1976 · S/N TK-12N81BGAtlanta Aviation Systems LLC · Dallas, GABuilt 2025 · S/N 11046N81DTKbk Aviation LLC · Youngsville, LAS/N 21064519N81DXMackay Aviation LLC · Billings, MTBuilt 2021 · S/N 2319N81FDCastaway Cloudhoppers LLC · Alleyton, TXBuilt 2025 · S/N 11071N81FGBrandis Robert DBA · Taylorville, ILS/N E-2424N81FKPtair LLC · Carrollton, GABuilt 2020 · S/N 4878N81FMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1999 · S/N 29-0180N81HCSmith Ronald Shane · Peachtree City, GABuilt 1990 · S/N TH-1600N81HTBaby Raptor LLC · Castle Pines, COBuilt 2019 · S/N 1925N81KCCraigo Keith A · Addison, TXBuilt 1981 · S/N 21064386N81KRMac Properties Aviation LLC · Niceville, FLBuilt 2023 · S/N 9481N81MTBennett Thomas Richard · Brooklyn Park, MNBuilt 1981 · S/N P21000794N81NXEagle Aero Aviation LLC · Lewes, DEBuilt 2007 · S/N 2660N81PVBrighton Vista LLC · Rockaway Beach, ORBuilt 2016 · S/N 4433N81RLNew Aker LLC · Wellington, FLBuilt 2025 · S/N 10503N81RYRedding Dermatology Medical Group Inc · Redding, CABuilt 1981 · S/N 340A1238N81TBMalachi Leasing Co · Wilmington, DEBuilt 1978 · S/N TJ-147N81VPWoodruff Harold S · Rancho Cucamonga, CABuilt 2003 · S/N LIV-450N81VRRaviele Vincent · Richmond, TXBuilt 1986 · S/N P21000868N81WFWolf Capital LLC · Forest, VABuilt 2006 · S/N 1772N820Ames Air LLC · Mechanicsville, VABuilt 2008 · S/N 3305N8201ETigre Air LLC · Missoula, MTBuilt 1993 · S/N E-2777N8207AStadium Air LLC · Jonesboro, ARBuilt 2023 · S/N 9569N8209ARocky Top Real Estate Investments LLC · Paola, KSBuilt 1993 · S/N E-2781N820AHBuffaloe Thomas N · Mancos, COBuilt 1981 · S/N U20606123N820BKKamberi Aviation LLC · Hyannis, MABuilt 2025 · S/N 10866N820BRSkywood Aviation LLC · Wayne, NJBuilt 1996 · S/N E-3011N820CSAmcs LLC · Pembroke Pines, FLS/N 1985N820FWN820fw LLC · Grand Rapids, MIBuilt 2011 · S/N 3798N820GHMcdavitt Edward T · Sugar Land, TXBuilt 1994 · S/N E-2870N820LWLance R Ward Enterprises Inc · Geneva, NYBuilt 2005 · S/N 1660N820SRCannoles Ronald I · Las Vegas, NVBuilt 2007 · S/N 2463N820TSSr820 LLC · Nashville, TNBuilt 2018 · S/N 4607N820VNovember 820v LLC · Fitchburg, WIBuilt 1995 · S/N E-2947N8212DN8212d LLC · Elkins Park, PABuilt 2025 · S/N 10717N8215MJnk Equipment LLC · Deer Harbor, WABuilt 1993 · S/N EA-548N821CVSea Duck LLC · Miami, FLFirst renewal noticeBuilt 2016 · S/N 4374N821DLanco Travel LLC · Tacoma, WABuilt 2023 · S/N 9307N821GCascade Virga LLC · Wilmington, DEBuilt 2005 · S/N 1471N821GHN821gh LLC · Hudson Oaks, TXBuilt 1994 · S/N E-2871N821GTChatelain Ray · Lago Vista, TXBuilt 2013 · S/N 3932N821LLRiddley Retail Fixtures Inc · Kings Mountain, NCBuilt 2025 · S/N 10570N821MSAci Enterprises LLC · Costa Mesa, CABuilt 2014 · S/N 4052
Back to AD 2012-10-13