AD 2012-21-05

Registered aircraft · 186

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-21-05')
    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-21-05')
  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.

N2971Dick Holdings LLC · Merritt Island, FLBuilt 2020 · S/N TH-2537N321WVHill Stephen D · Lincoln, NEBuilt 2012 · S/N TH-2343N324EAWaytack LLC · Bryant, ARBuilt 2015 · S/N TH-2452N325JWKlug Transport Inc · Farmington, MOBuilt 2012 · S/N TH-2340N341EEggleston William Joseph III · Leakey, TXS/N TH2141N34BPAviation Insurance Managers Inc · Uniontown, OHBuilt 2014 · S/N TH-2420N358RMMrm Phoenix Ltd · Cape Girardeau, MOBuilt 2015 · S/N TH-2434N36JGJones Aviation LLC · Danville, CABuilt 2007 · S/N TH-2196N3730YSilversky Exploration LLC · San Antonio, TXS/N TH-2130N384BCCrider Transportation LLC · Stillmore, GAFirst renewal noticeBuilt 2013 · S/N TH-2385N391BRWagers Wings LLC · Cleveland Heights, OHBuilt 2015 · S/N TH-2451N39KTEcojiva Air LLC · Bloomfield Hills, MIS/N TH2140N412GHHavemeier Gregory Wiliam · Marco Island, FLBuilt 2019 · S/N TH2518N429MAirmart Inc · Lexington, KYBuilt 2014 · S/N TH-2422N430GLFogle LLC · Bella Vista, ARS/N TH-2149N432ZBaronhawks LLC · Jacksonville, FLBuilt 2010 · S/N TH-2284N440BETextron Aviation Inc · Wichita, KSBuilt 2015 · S/N TH-2440N444KY444 Dd LLC · Chavies, KYBuilt 2018 · S/N TH-2497N453BBBass Equipment LLC · Texarkana, ARBuilt 2016 · S/N TH-2453N458GShasta Air LLC · Sacramento, CAS/N TH-2156N464EABaron Four LLC · Virginia Beach, VABuilt 2012 · S/N TH-2349N47PHReal Time Aviation LLC · Southlake, TXBuilt 2016 · S/N TH-2467N47WK57 Bw LLC · Reno, NVBuilt 2007 · S/N TH-2179N48MWFour Echo X-Ray LLC · Boston, MABuilt 2007 · S/N TH-2173N495AUCohen Aircraft Leasing & Sales LLC · Dunwoody, GABuilt 2010 · S/N TH-2287N500KBKilo Bravo LLC · Mount Airy, MDS/N TH-2388N5026AMartin Kent D · Pittsburg, TXBuilt 2014 · S/N TH-2426N5036UTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N TH-2362N504WEArchitectural Supplements Aviation LLC · Waterbury, CTBuilt 2016 · S/N TH-2454N5070JCrc Properties Inc · Coto Laurel, PRBuilt 2013 · S/N TH-2370N50LPParker-Long LLC · Lexington, NCBuilt 2026 · S/N TH-2551N513KXHart Aviation Enterprises LLC · Jonesboro, ARBuilt 2012 · S/N TH-2342N517MPMorey Organization Inc · Wildwood, NJBuilt 2014 · S/N TH-2419N517RBRbc Holdings LLC · San Juan, PRBuilt 2018 · S/N TH-2513N51HAJd Air Inc · Fairlawn, NJBuilt 2014 · S/N TH-2418N521JCRasmussen Group · Des Moines, IABuilt 2008 · S/N TH-2242N522RBWahoo Aviation Inc · Charlotte, NCBuilt 2013 · S/N TH-2372N523BOhh Cat Inc · Oklahoma City, OKBuilt 2007 · S/N TH-2184N525Alpine Aviation LLC · Oklahoma City, OKBuilt 2007 · S/N TH-2188N529LHRightway Drywall Inc · Macon, GABuilt 2019 · S/N TH-2517N533PMMccollom Perry C · Saint Louis, MOBuilt 2009 · S/N TH-2255N538BBTextron Aviation Inc · Wichita, KSBuilt 2023 · S/N TH-2538N53VEReam Aviation LLC · York, PAS/N TH-2530N549RSN549 Romeo Sierra LLC · Wilson, NCS/N TH-2157N553WETextron Aviation Inc · Wichita, KSS/N TH-2553N577HRBonanza Holdings LLC · Rapid City, SDBuilt 2020 · S/N TH-2526N580CXWicked Wings Aviation LLC · Dover, DEBuilt 2010 · S/N TH-2277N580SMMacair Leasing LLC · Cocoa, FLBuilt 2015 · S/N TH-2444N584DWAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2014 · S/N TH-2394N584PCHurry Back Air LLC · Knoxville, TNBuilt 2007 · S/N TH-2211
Back to AD 2012-21-05