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.

N575LPWildkat Aviation LLC · Hudson, OHBuilt 2023 · S/N 9616N575MCStuteville Consulting LLC · Durant, OKBuilt 2007 · S/N 2764N575PWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 2442N575SABarnts Sales Company LLC · Diller, NEBuilt 2006 · S/N 2003N575SWHester Thomas F · Santa Barbara, CABuilt 1979 · S/N 414A0268N575TVIssue V Inc · Huntington Beach, CABuilt 2014 · S/N 0807N575TXHu Jianing · Santa Clara, CABuilt 2010 · S/N 3520N575WTDanemann Mark · Taos, NMBuilt 2005 · S/N 1533N575XSnowy Owl Investments LLC · Scottsdale, AZBuilt 2021 · S/N 2403N5762JJonesco Acquisitions LLC · Bixby, OKBuilt 1971 · S/N 21059462N5763MStan Hill Aviation LLC · Waterford, MIBuilt 1969 · S/N 310P0063N5765MBush Abe A · Eatonton, GABuilt 1968 · S/N 310P0065N5768S3c LLC · Waukee, IABuilt 1972 · S/N 3400037N576BSC&J Aerobiz LLC · Madison, ALBuilt 2005 · S/N 41059N576CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 1665N576CPQualitair LLC Trustee · MichelstadtBuilt 2008 · S/N 3342N576DGEdge David Lee · Lumberton, NCBuilt 2005 · S/N 1617N576NMKlas-Kcoe LLC · Las Vegas, NVBuilt 2015 · S/N 1147N576TMCadence Truck And Trailer Leasing LLC · Chicago, ILBuilt 2025 · S/N 10483N577DGW&E Aviation LLC · Peoria, AZBuilt 2020 · S/N 4887N577DHHawkeye Aviation LLC · Mason, OHBuilt 2016 · S/N 4339N577HSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2014 · S/N 0738N577KBDavid A Bush Inc · Hanford, CABuilt 2001 · S/N EA-668N577SRSteubesand Karl · Rhinebeck, NYBuilt 2007 · S/N 2845N5785CNoonan Leasing LLC · Johnstown, NYBuilt 2022 · S/N 8888N578AGAlpha Gulf Holdings LLC · Wesley Chapel, FLBuilt 2007 · S/N 2822N578CDCarothers Donald Luis · Bakersfield, CABuilt 2005 · S/N 1643N578CPOsman Keenan · Seffner, FLBuilt 2008 · S/N 3350N578DJDrj Management LLC · Edmond, OKBuilt 2025 · S/N 10826N578PSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 0966N578SBPremier Aviation LLC · Klein, TXBuilt 2018 · S/N 1682N5793MCoxbill Farms Inc · Torrington, WYBuilt 1969 · S/N 310P0093N57977Denney Dennis · New Port Richey, FLBuilt 1976 · S/N 21061475N579AGAccum Claude Alan · Dover, MABuilt 2012 · S/N 0315N579MWCqf Holdings LLC · Fairhope, ALBuilt 2019 · S/N 4785N579SRShepherd Kris R · Blue Ash, OHBuilt 2007 · S/N 2376N579TWGuerra Gerald · Sandusky, OHBuilt 2022 · S/N 8976N57AMclallen Holdings LLC · Saint Charles, ILBuilt 1980 · S/N P21000564N57AECirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11422N57CJCj Aero LLC · Eustis, FLBuilt 2012 · S/N 0388N57CXDmdt Ventures LLC · Victor, NYBuilt 1986 · S/N 46-8608013N57DB57db Aviation LLC · Fort Myers, FLBuilt 2021 · S/N 5108N57DCPorton Qozb LLC · Mesa, AZBuilt 2023 · S/N 9202N57DECape Aviation LLC · Lewes, DEBuilt 2024 · S/N 10129N57DGValiair Ltd Co Trustee · Casper, WYBuilt 2020 · S/N 2190N57DMPrecision Aviation Inc · Tulsa, OKBuilt 1999 · S/N 30-0014N57FECavu Air LLC · Lees Summit, MOBuilt 2005 · S/N 1521N57FMCohen Aaron H · Chattanooga, TNBuilt 1999 · S/N 30-0034N57GXJfp Aviation Inc · North Fort Myers, FLBuilt 2005 · S/N 29-0357N57KZKaz Mobility LLC · Kiawah Island, SCBuilt 2025 · S/N 10827
Back to AD 2012-10-13