AD 2020-03-21

Registered aircraft · 523

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

N616DCDjw Aviation III LLC · Monterey, CABuilt 2008 · S/N 9296N618WFJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 9005N6192BGlacier Aviation LLC · Westlake, TXBuilt 2015 · S/N 9708N620SYGreeneagles LLC · Salt Lake City, UTBuilt 2016 · S/N 9759N622CKN622ck LLC · Sterling, VABuilt 2018 · S/N 9819N6235DBombardier Aerospace Corp · Dallas, TXS/N 60235N6237DBombardier Aerospace Corp · Dallas, TXS/N 60237N624BPWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 9830N624BRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 9236N625SCStryker Corp · Portage, MIBuilt 2014 · S/N 9647N626JJBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 9617N626JSJwc Winter LLC · West Palm Beach, FLBuilt 2023 · S/N 60104N628MWN628mw LLC · Salt Lake City, UTBuilt 2023 · S/N 60110N62AFAmerican Fidelity Corp · Oklahoma City, OKBuilt 2012 · S/N 9505N633ABWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 9368N636JSJrs Global LLC · Opa Locka, FLBuilt 2009 · S/N 9325N646JCJrs Airco LLC · Miami, FLBuilt 2021 · S/N 60046N646TBBoeing Co · Berkeley, MOBuilt 2012 · S/N 9523N64MTWindtop Inc · Dallas, TXBuilt 2010 · S/N 9391N6508Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 9429N6509Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9669N650CVVerde Capital Corp · Tempe, AZBuilt 2020 · S/N 60010N650RVTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 9861N650RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 60083N650SNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 60089N650WCRegistered aircraftN-number assigned (import), not yet registeredS/N 60222N65TPAltex LLC · Lincolnwood, ILBuilt 2014 · S/N 9616N65WLWillis Lease Finance Corp · Coconut Creek, FLBuilt 2001 · S/N 9089N661HNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 60061N667BBCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 9618N667JDWch Aa Inc · White Plains, NYBuilt 2018 · S/N 9820N668BBCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 9842N669TTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 9831N672EVBombardier Aerospace Corp · Dallas, TXBuilt 2015 · S/N 9704N68005Mmap LLC · Houston, TXBuilt 1999 · S/N 9010N683SLSl Global LLC · Basking Ridge, NJBuilt 2022 · S/N 60051N684ARB U A Delaware Inc · Wilmington, DEBuilt 2022 · S/N 60071N68889Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 9568N689WMN2fd LLC · Miami Beach, FLBuilt 2007 · S/N 9265N68KPWilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 60044N690BDBank Of Utah Trustee · Salt Lake City, UTS/N 9107N691BDBank Of Utah Trustee · Salt Lake City, UTS/N 9123N691GLLakeline Aviation LLC · New York, NYBuilt 2025 · S/N 60191N692BDBank Of Utah Trustee · Salt Lake City, UTS/N 9131N692LN900e LLC · Jensen Beach, FLBuilt 2009 · S/N 9340N693BDBank Of Utah Trustee · Salt Lake City, UTS/N 9132N694BDBank Of Utah Trustee · Salt Lake City, UTS/N 9135N695BDBombardier Aerospace Corp · Dallas, TXS/N 60223N696BDRegistered aircraftAssigned (import), pending cancellationS/N 60228N698BDL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2025 · S/N 60198
Back to AD 2020-03-21