AD 2017-20-01

Registered aircraft · 341

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:2017-20-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-20-01')
  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.

N222NEHigher Cause LLC · Grand Rapids, MIBuilt 2000 · S/N 110N224JL205 Flintstones LLC · Flint, MIBuilt 1995 · S/N 258279N229LJN229lj LLC · Bentonville, ARBuilt 2001 · S/N 229N22CPRegistered aircraftBuilt 2003 · S/N 258624N241LJDouble Whiskey Aviation LLC · Midland, TXS/N 241N244CKKalitta Air LLC · Ypsilanti, MIBuilt 1977 · S/N 369N248BPNorth Valley Air Ltd · St Thomas, VIBuilt 1998 · S/N 283N24NNWorld Jet Of Delaware Inc · Fort Lauderdale, FLS/N 35-037N250EXAb Aspen LLC · Opa Locka, FLBuilt 2001 · S/N 139N253SCPowderhorn 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 258616N258UTBurnt 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 231N263SNBlue Skies Hawker LLC · Whitefish, MTBuilt 2002 · S/N 258580N264RVHfa Specialty Acquisitions LLC · Boca Raton, FLBuilt 2002 · S/N 327N265HTmfb 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 239N268TSExpeditus Holdings LLC · Jacksonville, FLS/N 268N271ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 189N275ERContinuum Aviation LLC · Oklahoma City, OKBuilt 2005 · S/N 275N277RSMaize & White Aviation LLC · Youngstown, OHBuilt 2004 · S/N 258693N280BDLcg Enterprises LLC · Greenwich, CTBuilt 2003 · S/N 332N290GSBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 2038N291BBattelle Memorial Institute · Columbus, OHBuilt 2001 · S/N 317N291FJNhs Management LLC · Tuscaloosa, ALS/N 291N299PRMeregrass Inc · Dublin, TXBuilt 2000 · S/N 299N29BBattelle Memorial Institute · Columbus, OHBuilt 2005 · S/N 343N3007Empire Airlines Inc · Lebanon, MOBuilt 2000 · S/N 258487N303XX303 Aviation LLC · North Plains, ORS/N 196N305BBBsc Landing LLC · Saint Louis, MOBuilt 1999 · S/N 105N307DLNova Jets USA Corp · Orlando, FLS/N 2002N308DD225sbi LLC · Stuart, FLBuilt 2004 · S/N 258665N30AXN27ax LLC · Tulsa, OKBuilt 2001 · S/N 141N310LJTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 031N311BPWls Enterprise LLC · Portland, ORBuilt 2001 · S/N 314N311KBJet Plaid LLC · Nashville, TNBuilt 2004 · S/N 135N311RSKen Sale Resources Inc · Southlake, TXBuilt 1977 · S/N 5222N312FUKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2001 · S/N 258545N314SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 133N315EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 315N315RCRocklyn National LLC · Syracuse, NYBuilt 2000 · S/N 258480N316CLCalco 316 LLC · Frisco, TXBuilt 1993 · S/N 6507032N317CQPrivate Fliers LLC · Wheaton, ILBuilt 2001 · S/N 258532N31KHAery Aviation LLC · Wilmington, DEBuilt 1999 · S/N 173N31YAInternational Trading Energy Fuels LLC · Houston, TXBuilt 1990 · S/N 021
Back to AD 2017-20-01