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.

N504CSBeach Cruiser Express LLC · Hummelstown, PABuilt 2014 · S/N 4131N504FPBaumgarten Jeffrey A · New Orleans, LABuilt 2004 · S/N 1192N504GLBravo Whiskey Solutions LLC · Brenham, TXBuilt 1975 · S/N TJ-26N504HXTes Aircraft Leasing LLC · Fort Myers, FLBuilt 2020 · S/N 2191N504JLJade Management Inc · Hailey, IDBuilt 2004 · S/N 41020N504JWPalmer Gary H · San Juan, TXBuilt 1981 · S/N 21064232N504LAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2022 · S/N 8682N504LMLucky H Farms Inc · Mesa, WABuilt 2008 · S/N 2912N504PGHlm Partners LLC · Grosse Pt Shr, MIBuilt 2008 · S/N 3014N504TBAutomotive Air III LLC · Belcamp, MDBuilt 1997 · S/N TH-1810N504TKN504tk LLC · Fairhope, ALBuilt 2022 · S/N 8842N5050GHats Off Aviation LLC · Newnan, GABuilt 2004 · S/N 0833N5050MMarijune Aviation LLC · Lakeland, FLBuilt 2016 · S/N 4326N5056XN5056x LLC · Troy, OHS/N E-3456N505ACPark Creek Holdings LLC · Quanah, TXBuilt 2023 · S/N 9580N505ARDoss Justin · Beaumont, TXBuilt 2007 · S/N 2798N505CDValiair Limited Company Owner Trustee · Casper, WYBuilt 2002 · S/N 0323N505CNLes Amis Air LLC · Dorado, PRBuilt 1978 · S/N 414A0201N505FRAf Holdings LLC · Argyle, TXBuilt 2023 · S/N 9317N505JTSheffels Eric B · Wayland, MABuilt 2007 · S/N ES-134-FBN505MAMonmouth Aviation LLC · Sea Girt, NJBuilt 2026 · S/N 11201N505MBAr South Aviation LLC · Lafayette, LABuilt 2019 · S/N 33-0011N505PCRegistered aircraftBuilt 2022 · S/N 8666N505PGNorthern Minnesota Group LLC · Baxter, MNS/N 3016N505PTBeckett Consulting Services Inc · Fort Collins, COS/N 1352N505SFLux William E · Newman Lake, WABuilt 1977 · S/N 340A0261N505TSOms Aviation LLC · Boise, IDBuilt 2014 · S/N 0788N505WMAndrew Aircraft Sales LLC · Selmer, TNS/N 29-0151N5060VMacair Aviation LLC · Xenia, OHBuilt 2004 · S/N 0829N5061QLepper Michael J · Ward, COBuilt 1971 · S/N 340-0017N5062HCoati Aviation LLC · San Diego, CABuilt 1967 · S/N D-8379N5065RZ J Express LLC · Lewes, DEBuilt 2002 · S/N TH-2040N506CPHunter Mechanical & Controls Inc · Oklahoma City, OKBuilt 2008 · S/N 3317N506LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 10048N506LR5m Aviation Holdings LLC · Monticello, FLBuilt 2025 · S/N 10458N506PGPegasus Air LLC · Westerville, OHBuilt 2008 · S/N 3005N5072CThomas Robert Allan Jr · Phoenix, AZBuilt 1978 · S/N 310R1414N5073CInternational Air Services Inc Trustee · Carson City, NVS/N EA-667N5075YAlkota Of Kansas LLC · Wichita, KSBuilt 2001 · S/N EA-675N507CPFrom The Ground Up Air LLC · Lake Havasu City, AZBuilt 2008 · S/N 3319N507HHGrossetete Nugget S · Edgewood, NMBuilt 1980 · S/N P21000481N507KBTj Air Holdings Inc Trustee · Wilmington, DEBuilt 2010 · S/N 3631N507MCBowden Wayne · Draper, UTS/N 3389N507NANasa Langley Research Center · Hampton, VABuilt 2000 · S/N 40008N507RWSmith Air LLC · Bentonville, ARBuilt 2013 · S/N 0664N5080RRodriguez Roberto F · Tampa, FLBuilt 2001 · S/N E-3386N5081EGolden Alan · Wilmette, ILBuilt 2001 · S/N E-3401N5083JKrs Aerial Inc · Galloway, OHS/N 310R0203N5083TClaar Brian · Spring, TXBuilt 1982 · S/N EA-287N5083WJtc Investments LLC · Tyrone, GABuilt 1980 · S/N P21000635
Back to AD 2012-10-13