AD 2012-16-14

Registered aircraft · 779

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-16-14')
    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-16-14')
  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.

N2511BDealer Equipment Leasing LLC · Miami, FLBuilt 2020 · S/N 323N251SPSonoco Products Co · Hartsville, SCBuilt 2012 · S/N HA-0203N253ALCorsair Two LLC · Hillsboro, ORBuilt 2008 · S/N 361N253RM452053 LLC · Fort Lauderdale, FLBuilt 2006 · S/N 2053N253SCPowderhorn Aviation LLC · Bethany, OKBuilt 2004 · S/N 252N254ALCorsair Two LLC · Hillsboro, ORBuilt 2005 · S/N 283N254FSS&S Aviation Management LLC · Waco, TXBuilt 1999 · S/N 058N254SBHawker 800xp LLC · Fort Lauderdale, FLBuilt 2003 · S/N 258616N254TLHdsmjj LLC · Waco, TXBuilt 2009 · S/N 401N256AHApple Six Hospitality Air LLC · Richmond, VABuilt 2011 · S/N 2123N258UTBurnt Orange Five LLC · Seabrook, TXBuilt 1992 · S/N 114N259RHAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258529N25XPRd Airways LLC · Channelview, TXS/N 258572N260LFEthos Aviation LLC · Cleveland, OHBuilt 2001 · S/N 231N261CHSeecon Builders Inc · Concord, CABuilt 2011 · S/N 261N263SNBlue Skies Hawker LLC · Whitefish, MTBuilt 2002 · S/N 258580N264CDf 254 Holdings LLC · Wilmington, DEBuilt 2010 · S/N 254N264RVHfa Specialty Acquisitions LLC · Boca Raton, FLBuilt 2002 · S/N 327N265CWOde Family Logistics LLC · Strongsville, OHBuilt 2005 · S/N 2042N265HTmfb Transporation LLC · Orlando, FLBuilt 2004 · S/N 139N265JGShell Mountain Ranch LLC · Cranfills Gap, TXBuilt 2004 · S/N 258699N266AJMoore Investment Fund LLC · Belmont, OHBuilt 2004 · S/N 239N268TMTmrg LLC · Nashville, TNBuilt 2008 · S/N HA-0050N268TSExpeditus Holdings LLC · Jacksonville, FLS/N 268N26XPBanyan 2025 LLC · Fort Myers, FLBuilt 2009 · S/N HA-0152N271ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 189N275ERContinuum Aviation LLC · Oklahoma City, OKBuilt 2005 · S/N 275N276LJExpedite Aviation LLC · Westerville, OHBuilt 2001 · S/N 156N277RSMaize & White Aviation LLC · Youngstown, OHBuilt 2004 · S/N 258693N27KB3kb Investments LLC · Wilmington, DEBuilt 2010 · S/N 291N280BDLcg Enterprises LLC · Greenwich, CTBuilt 2003 · S/N 332N286JJHoran John J Jr · Dallas, TXBuilt 2012 · S/N 303N28NPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 118N28VMVan Metre Air LLC · Fairfax, VAS/N HA-0204N290GSBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 2038N291BBattelle Memorial Institute · Columbus, OHBuilt 2001 · S/N 317N291FJNhs Management LLC · Tuscaloosa, ALS/N 291N298RDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 024N299PRMeregrass Inc · Dublin, TXBuilt 2000 · S/N 299N29BBattelle Memorial Institute · Columbus, OHBuilt 2005 · S/N 343N29JWSchussboomer Systems Inc · Anacortes, WABuilt 2006 · S/N 205N29REHome State Insurance Group Inc · Waco, TXBuilt 2007 · S/N 2069N2HZHerzog Contracting Corp · Saint Joseph, MOBuilt 2006 · S/N 216N3007Empire Airlines Inc · Lebanon, MOBuilt 2000 · S/N 258487N301MLAirtime Aviation LLC · Bethesda, MDBuilt 2008 · S/N HA-0094N301RJ301rj LLC · Fayetteville, ARBuilt 2007 · S/N 2071N302RVAero Jet Aviation I Inc · Fort Lauderdale, FLBuilt 2008 · S/N 357N303XX303 Aviation LLC · North Plains, ORS/N 196N305BBBsc Landing LLC · Saint Louis, MOBuilt 1999 · S/N 105N305FCN305fc LLC · Opa Locka, FLBuilt 2006 · S/N 2063
Back to AD 2012-16-14