AD 2017-20-06

Registered aircraft · 364

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-06')
    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-06')
  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.

N379TFSaturdays Child LLC · Palm Beach Gardens, FLBuilt 2011 · S/N 20340N37FEFederal Express Leasing Corp · Memphis, TNBuilt 2013 · S/N 20411N383LAGh Development Holdings LLC · Salem, ORBuilt 2006 · S/N 20098N385DBCitation X Parts LLC · Liberty, NCBuilt 2005 · S/N 20041N393JSG5 Aviation LLC · Miami, FLBuilt 2009 · S/N 20282N394BWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 20394N396BCAircat LLC · North Hollywood, CABuilt 2006 · S/N 20108N396JSPh300 Holdings LLC · Wilmington, DEBuilt 2014 · S/N 20445N3975APcsa 1 LLC · Aspen, COBuilt 2007 · S/N 20170N39FEFedex Freight Inc · Memphis, TNBuilt 2013 · S/N 20412N402DBCitation X Parts LLC · Liberty, NCBuilt 2006 · S/N 20118N402HPGottsch Brothers Of Elkhorn LLC · Elkhorn, NEBuilt 2012 · S/N 20349N405HMSky Air LLC · Norman, OKBuilt 2005 · S/N 20060N406BJWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 20343N409MRRegistered aircraftBuilt 2006 · S/N 20105N415NGDt Re LLC · Silver Lake, KSBuilt 2005 · S/N 20061N416FCitation X Leasing LLC · Liberty, NCBuilt 2009 · S/N 20262N417HC417hc Holdings LLC · Johnstown, PABuilt 2001 · S/N 20003N41DP20010 Ventures LLC · Denver, COBuilt 2004 · S/N 20010N420MPChallenger 20420 LLC · Nashville, TNBuilt 2013 · S/N 20420N422MPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 20422N423JGOwen Aviation LLC · San Diego, CABuilt 2009 · S/N 20266N42GJJlj Equipment Leasing Corp · Hobe Sound, FLBuilt 2006 · S/N 20085N430WCElevation Aviation Services LLC · Aurora, ORBuilt 2010 · S/N 20288N432MCMcm Air LLC · Midland, TXBuilt 2008 · S/N 20198N43FEFederal Express Leasing Corp · Memphis, TNBuilt 2014 · S/N 20456N447AKFriends Of Challenger LLC · Dover, DEBuilt 2012 · S/N 20360N44CPAlrick Holdings LLC · Wilmington, DEBuilt 2005 · S/N 20040N451HMQuincy St LLC · Falls Church, VABuilt 2014 · S/N 20444N453FDShp-Air Leasing LLC · Wilmington, NCBuilt 2014 · S/N 20453N465VCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 20430N46VENoble Plane LLC · Fishers, INBuilt 2013 · S/N 20396N46WYJjc Holdings 2020 LLC · Richardson, TXBuilt 2013 · S/N 20425N479PFGenmark Ventures LLC · Boca Raton, FLBuilt 2009 · S/N 20255N487JAJ & Ak Aviation LLC · Kansas City, MOBuilt 2014 · S/N 20439N495ECEdwards Challenger 300 LLC · Columbus, OHBuilt 2006 · S/N 20131N4MXB&G Air Inc · Morgan City, LABuilt 2008 · S/N 20223N503KJCrawford Leasing Company LLC · Wichita, KSBuilt 2007 · S/N 20188N508XJBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 20008N511FCMaryland Group LLC · Saint Louis, MOBuilt 2006 · S/N 20141N516WP516wp LLC · Boca Raton, FLBuilt 2007 · S/N 20178N517FXFlexjet LLC · Cleveland, OHBuilt 2005 · S/N 20038N518FXFlexjet LLC · Cleveland, OHBuilt 2005 · S/N 20046N520RPEcho Acquisitions LLC · Dover, DEBuilt 2004 · S/N 20032N524FXFlexjet LLC · Cleveland, OHBuilt 2006 · S/N 20095N525FXFlexjet LLC · Cleveland, OHBuilt 2006 · S/N 20112N5262State Street Corp · Shelton, CTBuilt 2006 · S/N 20122N527FXFlexjet LLC · Cleveland, OHBuilt 2007 · S/N 20124N530FXCitation X Parts LLC · Liberty, NCBuilt 2007 · S/N 20148N533XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20045
Back to AD 2017-20-06