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.

N228LWhite Plains Aviation LLC · Saratoga Springs, NYBuilt 2008 · S/N 20194N228YAnderson Equipment Co · Latrobe, PABuilt 2014 · S/N 20447N22XZSaetta LLC · Lehi, UTBuilt 2010 · S/N 20294N235EFEaf Air LLC · Detroit, MIBuilt 2013 · S/N 20434N245AEN318mm LLC · Topeka, KSBuilt 2008 · S/N 20245N247FSNcm Leasing LLC · Naples, FLBuilt 2005 · S/N 20068N248MLMglctt Inc · Raleigh, NCBuilt 2012 · S/N 20378N24FEFederal Express Leasing Corp · Memphis, TNBuilt 2012 · S/N 20355N2510DD Squared Ventures LLC · Scottsdale, AZBuilt 2012 · S/N 20346N251FTSc Aviation Partners LLC · Boston, MABuilt 2011 · S/N 20315N256GGChantilly Crushed Stone Inc · Chantilly, VABuilt 2008 · S/N 20204N256WBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20079N265KCorporate Jet Leasing Co LLC · Wichita, KSBuilt 2009 · S/N 20265N265SJN529tm LLC · Fairfax, VABuilt 2010 · S/N 20308N267620407 Holdings LLC · Atlanta, GABuilt 2013 · S/N 20407N26FAFreymiller Aviation LLC · Oklahoma City, OKBuilt 2004 · S/N 20026N26FEFederal Express Leasing Corp · Memphis, TNBuilt 2012 · S/N 20358N272JGRegistered aircraftBuilt 2007 · S/N 20172N283BRanger Air LLC · Kinston, NCBuilt 2008 · S/N 20252N286JRTf 286 LLC · Torrance, CABuilt 2004 · S/N 20014N286MHPowerhouse Equipment Leasing LLC · Camden, DEBuilt 2013 · S/N 20400N28FEFederal Express Leasing Corp · Memphis, TNBuilt 2012 · S/N 20361N290CHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20029N290CLJs Leasing LLC · Frisco, TXBuilt 2009 · S/N 20290N293HCHampton Cattle Co LLC · Orlando, FLBuilt 2011 · S/N 20330N299TSTsi Equipment Leasing LLC · Spokane, WABuilt 2011 · S/N 20316N300JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20115N300KCKroger Co · Cincinnati, OHBuilt 2012 · S/N 20385N300KEOneok Inc · Tulsa, OKBuilt 2011 · S/N 20336N300KHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20130N300LVCapital Challenge LLC · Reno, NVBuilt 2006 · S/N 20129N300NJFrazier Aviation LLC · Corpus Christi, TXBuilt 2004 · S/N 20013N300NZTvpx Ars Inc Trustee · Concord, MABuilt 2013 · S/N 20397N300RLBbl Aviation LLC · Scottsdale, AZBuilt 2006 · S/N 20090N300TUFlying Amici Aviation LLC · Owasso, OKBuilt 2009 · S/N 20264N301JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20162N301JLRegistered aircraftBuilt 2012 · S/N 20351N302JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 20321N302KCorporate Jet Leasing Co LLC · Wichita, KSBuilt 2009 · S/N 20267N302KCKroger Co · Cincinnati, OHBuilt 2013 · S/N 20389N302LTAsig Aviation Partners LLC · Dover, DEBuilt 2007 · S/N 20157N302PEBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 20144N303JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 20320N304KCKroger Co · Cincinnati, OHBuilt 2013 · S/N 20390N304RJHaystack Jmr LLC · Irvine, CABuilt 2008 · S/N 20243N305WMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 20379N306MFUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 20009N306WBJ & R Airways LLC · Lincoln, ALBuilt 2004 · S/N 20015N307JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20123N307JWFinch Lawrence G · Moraga, CABuilt 2006 · S/N 20093
Back to AD 2017-20-06