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.

N422SNFalcon Flight LLC · Las Vegas, NVS/N 3508N422SRReno Flight Club LLC · Reno, NVBuilt 2006 · S/N 1976N422SSInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 29-0339N422SWLarson Daniel · Mora, MNBuilt 1977 · S/N 21062164N422SXCsongor Robert A Trustee · Pleasanton, CABuilt 2019 · S/N 1867N422TBMark 2 Aviation LLC · Sand Springs, OKBuilt 2006 · S/N 1888N422WAWestwind Aviation Of Silicon Valley Inc · Los Gatos, CABuilt 2019 · S/N 1929N422WTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2013 · S/N 0641N4235CColville LLC · Signal Mountain, TNBuilt 1974 · S/N 414-0534N4237CBreakaway Group Aviation LLC · Franklin, TNBuilt 1974 · S/N 414-0535N423BDConcorde Transportation LLC · Freehold, NJBuilt 2020 · S/N 4893N423BEPs Capital Equipment LLC · Delray Beach, FLBuilt 2020 · S/N 2106N423BWFehring William · Sunnyvale, CABuilt 2000 · S/N EA-658N423CDGrzebik Ellerine P · Petaluma, CAS/N 1109N423CPAltus Aviation LLC · Pike Road, ALBuilt 2013 · S/N 3944N423LGNew Cirrus 2018 LLC · Ponte Vedra Beach, FLBuilt 2026 · S/N 11266N423PPrestige Worldwyde! LLC · Concord Township, OHBuilt 2002 · S/N E 3439N423RBAdams Aviation Services Inc Owner Trustee · Wilmington, DEBuilt 1981 · S/N 340A1270N423RGSchue Gary C · Fredericksburg, VABuilt 2005 · S/N SES-181MB2N423SRHaloroc Muppets II LLC · Nashville, TNBuilt 2007 · S/N 2459N423WBMass Air LLC · Chattanooga, TNBuilt 2025 · S/N 10464N424ATInspiring Strength Inc · Redding, CABuilt 2011 · S/N 3817N424AXPolyloom Corporation Of America Inc · Florence, ALBuilt 2016 · S/N 4308N424BBYoung Robert N · Stratham, NHBuilt 2015 · S/N 4195N424BDBadass Aviation LLC · Fernandina, FLBuilt 2005 · S/N 1723N424CHFlying Betty LLC · Prescott, AZBuilt 2000 · S/N 40004N424CKCca Aviation LLC · Great Bend, KSS/N 3495N424EGS&R Flying LLC · Franklin, TNBuilt 2004 · S/N 0887N424GLasalle Corrections Transport LLC · Dripping Springs, TXS/N 0537N424GBAvenge Holdings LLC · Ashburn, VABuilt 2026 · S/N 11507N424JN424 Juliet LLC · Mesa, AZBuilt 1984 · S/N 46-8408019N424LLLarkin Michael Paul · Port Orange, FLBuilt 2006 · S/N L2K-268N424MEKfl LLC · Canyon Country, CABuilt 1976 · S/N 340A0051N424PBDavis John W · Sugar Land, TXBuilt 2015 · S/N 4277N424PCMontana Livestock Ag Credit Inc · Helena, MTS/N 340A1266N424QLj Sutter Aviation LLC · Shavertown, PABuilt 1990 · S/N TH-1582N424RSRomeo Sierra LLC · Acworth, GABuilt 2025 · S/N 10604N424SRMartin Gary D · Plano, TXBuilt 2007 · S/N 2464N424SWPrestige Worldwide Sr22 LLC · Caldwell, IDBuilt 2009 · S/N 3380N424XBespinx LLC · Austin, TXBuilt 2014 · S/N 4153N4255STeton River Flying Service Inc · Rexburg, IDBuilt 1976 · S/N TK-35N425BVBvi Air LLC · Grand Forks, NDBuilt 2014 · S/N 4158N425CDDtn Aviation LLC · Winona, MNBuilt 2004 · S/N 0892N425CGSchmiesing Brothers Aviation Ltd · Minster, OHBuilt 2007 · S/N 2814N425ESKatz Stanley · Riverhead, NYBuilt 2026 · S/N 11332N425JAWhiskey Tango Fox LLC · Portland, ORBuilt 2007 · S/N 2452N425MHN425mh LLC · Geismar, LABuilt 2017 · S/N 4517N425MSMcdonald Shane · Belmont, MSBuilt 2005 · S/N 1256N425MTRkg Enterprises · Hibbing, MNBuilt 2015 · S/N 4201N425PQuimus Aviation LLC · Townsend, WIBuilt 1998 · S/N E-3175
Back to AD 2012-10-13