AD 2012-17-05

Registered aircraft · 1,197

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-17-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-17-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.

N2411APuerto Rico Air Management Services Inc · Coral Gables, FLS/N 650-0103N241CTAvalair Aircraft Management LLC · Brookshire, TXBuilt 1981 · S/N 355N241LJDouble Whiskey Aviation LLC · Midland, TXS/N 241N243JRDodson International Parts Inc · Rantoul, KSFirst renewal noticeS/N 565N244CKKalitta Air LLC · Ypsilanti, MIBuilt 1977 · S/N 369N244FLAviation Leasing Group Inc · Wilmington, DES/N 258066N244LJN244lj Aviation Inc · Middletown, DEBuilt 1979 · S/N 244N244RG369ba LLC · West Columbia, SCBuilt 1977 · S/N 154N247FRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 184N248BPNorth Valley Air Ltd · St Thomas, VIBuilt 1998 · S/N 283N248ECEc Aviation LLC · Lake Oswego, ORBuilt 1998 · S/N 258368N24KTFalcon Type Air LLC · Nashville, TNBuilt 1995 · S/N 650-7052N24NNWorld Jet Of Delaware Inc · Fort Lauderdale, FLS/N 35-037N24SMExecutive Air Solutions Corp · Fort Lauderdale, FLBuilt 2002 · S/N 258567N24ZDNext Wave Aviation LLC · Henderson, NVBuilt 1994 · S/N 073N250EXAb Aspen LLC · Opa Locka, FLBuilt 2001 · S/N 139N250MBNo Layover LLC · Hays, KSBuilt 1993 · S/N 258237N253SCPowderhorn 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 258616N256AUnlimited Boat Sales Inc · Page, AZS/N 172N258UTBurnt Orange Five LLC · Seabrook, TXBuilt 1992 · S/N 114N259RHAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258529N25EGGarcia Airways LLC · Virginia Beach, VABuilt 1989 · S/N 650-0167N25STLewis Garry L · Livingston, LABuilt 1982 · S/N 198N25XPRd Airways LLC · Channelview, TXS/N 258572N260LFEthos Aviation LLC · Cleveland, OHBuilt 2001 · S/N 231N260RCValiair Limited Company Trustee · Casper, WYBuilt 1993 · S/N 080N260RFHampton Holdings LLC · Atlanta, GAFirst renewal noticeBuilt 1996 · S/N 160N263SNBlue Skies Hawker LLC · Whitefish, MTBuilt 2002 · S/N 258580N264RVHfa Specialty Acquisitions LLC · Boca Raton, FLBuilt 2002 · S/N 327N265GCnl Group Services III LLC · Orlando, FLS/N 214N265HTmfb Transporation LLC · Orlando, FLBuilt 2004 · S/N 139N265JGShell Mountain Ranch LLC · Cranfills Gap, TXBuilt 2004 · S/N 258699N265WSPortside Aero LLC · Edgewater, NJBuilt 1981 · S/N 465-62N266AJMoore Investment Fund LLC · Belmont, OHBuilt 2004 · S/N 239N268TSExpeditus Holdings LLC · Jacksonville, FLS/N 268N269TAMadison Ql Partners LLC · Dallas, TXBuilt 2000 · S/N 650-7112N26BDArkansas Bolt Co · Little Rock, ARBuilt 1992 · S/N 062N26FNDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 011N26MEJ Jets Inc · Los Angeles, CABuilt 1982 · S/N NA 0315N26TCAcme Nite LLC · Nashville, TNBuilt 2001 · S/N 258521N26TNAj Air LLC · Blackwell, OKS/N 418N26TVDujuan And Only Media LLC · The Woodlands, TXBuilt 2006 · S/N 258766N271ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 189N275ERContinuum Aviation LLC · Oklahoma City, OKBuilt 2005 · S/N 275N2766KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 258744N277ALAti Jet Inc · El Paso, TXBuilt 1984 · S/N 104N277RSMaize & White Aviation LLC · Youngstown, OHBuilt 2004 · S/N 258693
Back to AD 2012-17-05