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.

N75MVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 274N75XPRedd Air LLC · Vancouver, WABuilt 2000 · S/N 118N763PPTop Air Texas LLC · Glendale, CABuilt 1999 · S/N 278N766RARoyal Air Freight Inc · Waterford, MIBuilt 1977 · S/N 360N76CKKalitta Charters LLC · Ypsilanti, MIBuilt 1976 · S/N 076N770CCTaughannock Aviation Corp · Ithaca, NYBuilt 2002 · S/N 258587N777QLMed Air LLC · Lawrenceville, GABuilt 2002 · S/N 216N791CPMaxus Capital Group LLC · Cleveland, OHBuilt 1982 · S/N 108N793RCLfg Aviation Holdings LLC · Kalispell, MTBuilt 2001 · S/N 258550N799RMBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 258708N799SN143bl LLC · Hixson, TNBuilt 2002 · S/N 258588N800ABCheck Clearing House Aviation LLC · Glenwood Springs, COBuilt 2001 · S/N 137N800LQAdc Aviation LLC · Birmingham, ALBuilt 2001 · S/N 258551N800NJGlobal Empire Trust LLC · Fort Lauderdale, FLBuilt 2000 · S/N 258483N800PEFour C Air Inc · Delano, CABuilt 2000 · S/N 258508N800THHoover Aviation LLC · Nashville, TNBuilt 2004 · S/N 258678N800UKJ W Construction Co Inc · Wise, VABuilt 2002 · S/N 258577N800WWPnw Transport LLC · Tucson, AZBuilt 2004 · S/N 258661N804BHMahaska Bottling Co · Oskaloosa, IABuilt 2002 · S/N 258596N804MC824 Holdco LLC · Salt Lake City, UTBuilt 2004 · S/N 258684N806GJPb Air LLC · Higley, AZBuilt 2002 · S/N 258602N806MNJm Soar LLC · Paradise Valley, AZBuilt 2003 · S/N 258605N808MCLrt Aero Partners LLC · Sheridan, WYBuilt 2003 · S/N 258614N812LLH800 Vi LLC · Stuart, FLBuilt 2003 · S/N 258620N812SDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 258683N816KYBcp Fa Ap LLC · Providence, RIBuilt 2004 · S/N 258680N817SDSea Aviation Holdings LLC · Wilmington, DEBuilt 2005 · S/N 258709N818LXN818lx LLC · Wilmington, DEBuilt 2001 · S/N 258534N819EXPreserve Air LLC · Honolulu, HIBuilt 2006 · S/N 347N822RLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 258643N823AMAirmed International LLC · Birmingham, ALBuilt 2004 · S/N 258687N823HLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 2037N825QTKjm Air LLC · Aurora, ILBuilt 2000 · S/N 258497N825WKMadunn El LLC · Wayzata, MNBuilt 1980 · S/N 025N826CALear Management LLC · Tulsa, OKBuilt 2002 · S/N 222N831LXM&N Equipment LLC · Englewood, COBuilt 2000 · S/N 258510N831PC505sj LLC · Jackson, TNBuilt 2001 · S/N 140N835MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1992 · S/N 673N849EAIq Worldwide Solutions LLC · Tampa, FLBuilt 1998 · S/N 264N84UPN84up LLC · Wilmington, DEBuilt 2000 · S/N 258484N850ENBcbg Capital LLC · Clearwater, FLBuilt 2002 · S/N 326N855MWMunguia Mario · Downey, CABuilt 1993 · S/N 258241N85PTWestwind Air LLC · Oklahoma City, OKBuilt 1980 · S/N 285N864BFPsx LLC · Sheridan, WYBuilt 2002 · S/N 258584N865CSReef Aviation LLC · Knoxville, TNBuilt 2004 · S/N 136N867TXAirplane 1 LLC · Richmond, TXBuilt 2002 · S/N 258576N870ZPotomac Corp · Wheeling, ILBuilt 2001 · S/N 193N876MRBudget Jet LLC · Greenville, DEBuilt 1994 · S/N 125N8778Ligon Air LLC · Birmingham, ALBuilt 2001 · S/N 258560N878MBMb Air LLC · New York, NYBuilt 2002 · S/N 258603
Back to AD 2017-20-01