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.

N797KBBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 9290N799GSSms 111 LLC · New York, NYBuilt 2006 · S/N 9192N799JRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 60032N79AYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 9058N7CGCoulson Aviation (USA) Inc · Portland, ORBuilt 2000 · S/N 9075N7CSN7cs LLC · Fort Wayne, INS/N 60050N800HCSouthern Valhalla Air LLC · The Colony, TXBuilt 2011 · S/N 9460N800WGWilmington Trust Co Trustee · Wilmington, DEBuilt 2026 · S/N 60219N801PNSabrina Aviation Corp · Boston, MABuilt 2000 · S/N 9062N802BCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9644N806HKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 9796N807DCFj 900 Inc · Dulles, VABuilt 2023 · S/N 60096N809DCFj 900 Inc · Dulles, VABuilt 2023 · S/N 60086N80TEBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 60006N810CKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 60133N81118Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 9825N814RGWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 9736N816TJBombardier Aerospace Corp · Dallas, TXBuilt 2026 · S/N 60212N817KLKak Transportation 5500 LLC · Carlsbad, CABuilt 2023 · S/N 60082N818AATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 9347N821AMJoust Capital II LLC · Potomac, MDBuilt 2023 · S/N 60093N822VPVp LLC · Camden, DEBuilt 1999 · S/N 9016N825FSGlobalgriffin LLC · Belgrade, MTBuilt 2023 · S/N 60091N827TFAvandra LLC · Salt Lake City, UTBuilt 2011 · S/N 9439N82EMJdi Holdings LLC · Allentown, PABuilt 2007 · S/N 9239N82HPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 60028N832PJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 9837N838SWAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1999 · S/N 9035N83WGCooper Burger LLC · Coral Gables, FLBuilt 1999 · S/N 9030N843FFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 9574N843GXAlesant Air LLC · Miami, FLBuilt 1999 · S/N 9026N84YUTxpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 9300N858DLPnc Financial Services Group Inc · Pittsburgh, PABuilt 2026 · S/N 60218N85DRegistered aircraftBuilt 2001 · S/N 9078N863CMWeh 601 LLC · Wilmington, DEBuilt 2021 · S/N 9488N864JGBowtie Aircraft Xrs LLC · Aventura, FLBuilt 2019 · S/N 9864N8762MWilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 60088N878SCTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9614N880JVBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 60147N880XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 9806N886BPSun Air Three LLC · Scottsdale, AZBuilt 2011 · S/N 9453N888VSBank Of Utah Trustee · Salt Lake City, UTBuilt 2026 · S/N 60215N889PGPrima Air Inc · Pasadena, CABuilt 2006 · S/N 9226N889STBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 60125N88STTvpx Aircraft Solutions Trustee · North Salt Lake, UTBuilt 2014 · S/N 9610N898MDepartment Of The Air Force · Bedford, MABuilt 2024 · S/N 60156N898WSWilmington Trust Co Trustee · Wilmington, DES/N 9271N89CVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 60041N8VBCbs Mass Media Corp · Van Nuys, CABuilt 2012 · S/N 9490N900GXHrznar LLC · Dallas, TXS/N 9298
Back to AD 2020-03-21