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.

N455KGMiguel Paul A · Canyon, TXBuilt 2014 · S/N 0890N455MVGrand Sierra Investments LLC · Kingfisher, OKBuilt 2016 · S/N 4307N455PN455p LLC · Fulshear, TXBuilt 1999 · S/N E3276N455PCPch Inc · Roseville, CABuilt 2006 · S/N 1961N455RMRomeoav8 LLC · Houston, TXBuilt 2021 · S/N 2243N455SDJ&L Aviation LLC · Malta, NYS/N TJ-405N455SPSrb Aviation LLC · Pewaukee, WIBuilt 2007 · S/N 2406N455SRScottie Dog Air LLC · Wilmington, DEBuilt 2006 · S/N 2229N455TBSmith Loren D · Great Falls, MTS/N 310R1860N455TCTompkins Landing Lc · Wayne, NEBuilt 2007 · S/N 2491N4560KRegistered aircraftBuilt 1948 · S/N NAV-4-1560N4566MPalacios Luis A · El Paso, TXBuilt 1978 · S/N TJ-182N4567ZMae Enterprises LLC · La Porte, INBuilt 2025 · S/N 10467N4568NBergren Scott W Trustee · Walnut Creek, CABuilt 1978 · S/N 340A0549N456ACHotel Quebec I LLC · Mount Pleasant, SCBuilt 2015 · S/N 4249N456ADStafford Arthur · Oak Bluffs, MABuilt 1996 · S/N E-3026N456ATBonanza Aircraft Lc · Steamboat Springs, COS/N EA-252N456BRPressurized LLC · Sequim, WAFirst renewal noticeBuilt 1981 · S/N P21000717N456BWCustom Wholesale Supply Co Inc · Odessa, TXBuilt 1975 · S/N 20700298N456DCCatalpa Holdings LLC · Las Vegas, NVBuilt 2005 · S/N 1525N456DRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2016 · S/N 1247N456GGCoward Lawrence Jayson · Paris, TXBuilt 2004 · S/N 0896N456HWestwind Inc · Marina, CABuilt 1951 · S/N NAV-4-2228-BN456HTDumbo II LLC · Omaha, NEBuilt 2016 · S/N 1371N456JMLandmark Aviation Services LLC · Sarasota, FLBuilt 1974 · S/N 340-0535N456KGDesk Aviation Inc · Las Vegas, NVBuilt 2022 · S/N 8979N456KMKilo Mike Aviation LLC · Chandler, AZBuilt 2006 · S/N 1977N456LEAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2006 · S/N 1868N456LL2fly-Safety LLC Trustee · Azle, TXBuilt 2008 · S/N 3009N456MGJones Daniel S Trustee · Hendersonville, NCBuilt 2008 · S/N 3330N456MPAhgl LLC · San Diego, CABuilt 2004 · S/N 287N456PSGaston Trevino Jr · Brownsville, TXBuilt 2004 · S/N 29-0335N456PWMilnar Greg · New Richmond, WIBuilt 2003 · S/N 1IV-446N456RTMassive Solutions LLC Trustee · Denton, TXBuilt 2002 · S/N 0314N456STMcbride Ken · San Martin, CABuilt 1975 · S/N 414-0810N456WPMatagorda Production Co · Westhoff, TXBuilt 1979 · S/N 340A0766N4570KHead East Aviation LLC · Geneseo, ILBuilt 1979 · S/N P21000220N4576KPope James Dean · Lewiston, IDBuilt 1979 · S/N P21000222N4577LLucas John · Norco, CABuilt 1972 · S/N 340-0115N4578NAviation International LLC · El Paso, TXBuilt 1978 · S/N 340A0553N4579NSeven Eight Juliet LLC · Edmond, OKBuilt 1978 · S/N 340A0479N457BBRlm Investment Holdings LLC · Wilmington, NCBuilt 1994 · S/N TH-1712N457CBPreferred Aviation Technologies LLC · Mooresville, NCBuilt 2008 · S/N 3058N457DKMiller Gordon J Jr · Monaca, PABuilt 2003 · S/N 29-0313N457DMMajor Development LLC · Cedaredge, COBuilt 1978 · S/N 340A0554N457DTMathew Reggie T · Satellite Beach, FLBuilt 1997 · S/N E-3095N457FDCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10457N4580KHarrah Daniel R · Juneau, AKBuilt 1979 · S/N P21000223N4589NGeneric Implant Solutions LLC · Pratt, KSBuilt 1978 · S/N 340A0556N458BBLeonard Aviation LLC · Ponte Vedra Beach, FLBuilt 2018 · S/N 4716
Back to AD 2012-10-13