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.

N279TXHester Air LLC · Visalia, CAS/N 0877N27BGGuzman Steven Manuel · Port Saint Lucie, FLS/N 340A0656N27DJLiberty Air LLC · Sarasota, FLBuilt 2019 · S/N 1959N27EBWalker Co · Cody, WYBuilt 2008 · S/N L2K 138N27EMStair Colin · Brookfield, WIBuilt 2006 · S/N 1798N27GPFlying Colors Airparts Inc · Leesburg, FLBuilt 1977 · S/N U20604105N27GRGolf Romeo Aviation LLC · Raleigh, NCBuilt 2021 · S/N 2367N27HALmn Aircraft Leasing LLC · Sellersburg, INBuilt 1982 · S/N T30300064N27LEQuality Feed Grains · Harrison, ARBuilt 2000 · S/N 00-301030N27LGStilda One LLC · Fort Loramie, OHBuilt 2008 · S/N 3052N27MLHam Aviation LLC · Marydel, DEBuilt 2016 · S/N 1269N27MXStewart Aviation LLC · Atlanta, GABuilt 2023 · S/N 9168N27MYBloomaker Holding Aero Service Inc · Waynesboro, VABuilt 2018 · S/N 1787N27PBMountain Lake Aviation LLC · Newark, DEBuilt 2024 · S/N 10018N27PFNorthstar Global Flight LLC · Bronxville, NYBuilt 2024 · S/N 9982N27PKOgary Aviation LLC · North Little Rock, ARBuilt 1993 · S/N TH-1687N27PY27py LLC · San Juan, PRBuilt 2026 · S/N 11456N27RGReya Sunshine LLC · Coral Gables, FLBuilt 2023 · S/N 9245N27SC5c Aviation LLC · Scottsdale, AZBuilt 1978 · S/N P21000181N27TSSalerni Anthony A · Bedford, NHBuilt 2016 · S/N LIV-244N27VPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1985 · S/N 18268451N27WVN27wv LLC · Shortsville, NYBuilt 2004 · S/N 1031N2801LAv8sgf LLC · Rogersville, MOBuilt 2017 · S/N 4475N2802JCentral States Aerial LLC · Polo, ILBuilt 1979 · S/N T18803515TN2803MBonanza N2803m LLC · Conway, ARBuilt 2002 · S/N E-3463N280CDWelling Lynn E · El Cajon, CABuilt 2005 · S/N 1411N280CPAi Aviators LLC · Vancouver, WABuilt 2008 · S/N 3222N280LVagiunic David · Ridgewood, NYBuilt 2002 · S/N 0154N280LCEstes Aviation LLC · Carson City, NVBuilt 2023 · S/N 9244N280SREdge Forward LLC · Thermopolis, WYBuilt 2007 · S/N 2800N2814QGill Robert L · Dixon, CABuilt 1975 · S/N U20602998N281BKCz Enterprise LLC · Loveland, OHBuilt 2018 · S/N 1759N281CPJust Plane Insane LLC · Missouri City, TXBuilt 2008 · S/N 3181N281DSBoughton Kyle · Mckinleyville, CABuilt 2007 · S/N 2534N281MFFisher Robert · Durham, NCBuilt 2025 · S/N 10441N281MGCirrus Design Corp · Duluth, MNBuilt 2024 · S/N 9771N281SRLawyers Real Estate Services LLC · Hondo, NMBuilt 2007 · S/N 2810N281SVOlson Fred · Harrison, ARBuilt 2000 · S/N 00-301029N281UDStanley David Wayne · Burleson, TXBuilt 1981 · S/N P21000690N281VBarry Larry M · Woodbine, IAS/N D-8195N282Sh1p Holdings LLC · Wichita, KSBuilt 2023 · S/N 9446N2824MDodson International Parts Inc · Rantoul, KSBuilt 2004 · S/N 1144N2824WBrown Logistics LLC · Auburn, WABuilt 2019 · S/N 1980N282ATMoonraker Iixl LLC · Wilmington, DEBuilt 2019 · S/N 2025N282CBWhisky Tango LLC · Hendersonville, TNBuilt 2011 · S/N 3782N282CDAurora Partners LLC · Oregon City, ORBuilt 2004 · S/N 1136N282DJViva LLC · Dover, DEBuilt 2021 · S/N 5066N282DMSkyshoe II LLC · Beverly, MABuilt 2021 · S/N 5035N282EEFogprop N282ee LLC · Bolinas, CABuilt 2005 · S/N 1619N282THAero Sky Inc · Terrace Park, OHBuilt 2019 · S/N 4748
Back to AD 2012-10-13