AD 2012-13-12

Registered aircraft · 1,192

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-13-12')
    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-13-12')
  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.

N224BHBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4241N225DCAvion LLC · Birmingham, ALBuilt 1994 · S/N 1253N225ELThesun LLC · Miami, FLBuilt 1999 · S/N 587N226MPExecutive Jet Group LLC · Opa Locka, FLBuilt 1996 · S/N 1300N226RS226rs LLC · Cypress, TXBuilt 2002 · S/N 1479N226SLSpencer Talia Aviation LLC · Los Angeles, CABuilt 2001 · S/N 628N227SVHeritage Double Eagle LLC · Queensbury, NYS/N 4210N228RECape Clear LLC · Westborough, MABuilt 2001 · S/N 1438N2291RIngersoll Rand Inc · Davidson, NCBuilt 2017 · S/N 5565N229KMMike Post Productions Inc · Burbank, CABuilt 1996 · S/N 504N230BDGlobal Pursuits LLC · New York, NYBuilt 2006 · S/N 5115N231CETvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 5232N232FN232k LLC · Midland, TXBuilt 1993 · S/N 1232N236CACypress Cove Air LLC · Phoenix, AZBuilt 1992 · S/N 1202N236KRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 4209N236LPCrest Aviation II LLC · Newport Beach, CABuilt 2010 · S/N 4206N237GAOrange County/Sunbird Aviation LLC · Costa Mesa, CABuilt 2015 · S/N 5523N237GRRed Flag Two Ltd · Miamisburg, OHBuilt 2006 · S/N 4055N239GACentury Aviation International Inc · Wilmington, DEBuilt 1997 · S/N 517N239MJG4sp Holdings LLC · West Palm Beach, FLBuilt 2005 · S/N 5095N23DQJfb3 LLC · Atlanta, GABuilt 2007 · S/N 5148N241CHTtx 2 LLC · Las Vegas, NVBuilt 2011 · S/N 4217N242GMTrans-Exec Air Service Inc · Van Nuys, CABuilt 2007 · S/N 5123N245BDBs Farms Aviation LLC · Menlo Park, CABuilt 2007 · S/N 5165N245TTWotan America Inc · Fort Lauderdale, FLBuilt 2003 · S/N 5003N2461HTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 4088N247B247 Equipment LLC · Hillsboro Beach, FLBuilt 2004 · S/N 4006N247EMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 5265N247LMLive Mas Enterprises LLC · Greenwood Village, COBuilt 1994 · S/N 1258N247PDDelphi Consulting LLC · Knoxville, TNBuilt 2007 · S/N 4107N24JRWinbrook LLC · Los Angeles, CABuilt 2008 · S/N 4122N250KCFlight 444 LLC · Atlanta, GABuilt 1987 · S/N 1025N250RGAviation Co Inc · Cheyenne, WYBuilt 1986 · S/N 1003N250RJDixon John W · Aurora, ORBuilt 2014 · S/N 4308N251HRJohnson Breeders Inc · Rose Hill, NCBuilt 2005 · S/N 4027N252DVG550 Aviation LLC · Grand Rapids, MIBuilt 2014 · S/N 5463N254CAMmap LLC · Houston, TXBuilt 1987 · S/N 1054N256CWSrit LLC · Irvine, CABuilt 1998 · S/N 547N257ATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5571N25CPWilmington Trust Co Trustee · Wilmington, DEBuilt 1997 · S/N 527N25GMLap Acquisition Air LLC · Woodbury, NYBuilt 2008 · S/N 4145N25GVEast Coast Brokerage Services LLC · West Palm Beach, FLBuilt 1999 · S/N 591N25HLWilmington Trust Company Trustee · Wilmington, DEBuilt 2005 · S/N 5066N25RARadz Airways LLC · Solana Beach, CABuilt 1997 · S/N 1310N25UTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5359N261JDMaizenblue Express LLC · Jupiter, FLBuilt 2000 · S/N 1409N261PWPerryair LLC · New York, NYBuilt 2010 · S/N 5268N265SHSea Hunt Boat Mfg Co Inc · Sumter, SCBuilt 2013 · S/N 4290N267WAGlobal Aircraft LLC · Eden Prairie, MNBuilt 2000 · S/N 622N268VTAvire LLC · West Hollywood, CABuilt 1993 · S/N 1220
Back to AD 2012-13-12