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.

N900SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 9277N901GXUnited States Air Force · Bedford, MAS/N 9001N9045United States Air Force · Bedford, MAS/N 60045N9046United States Government · Bedford, MABuilt 2021 · S/N 60056N9047United States Government · Bedford, MABuilt 2022 · S/N 60087N9048GUnited States Air Force · Bedford, MABuilt 2023 · S/N 60115N905JGLion Sky Aviation LLC · Studio City, CABuilt 2012 · S/N 9497N907GXLearjet Inc · Wichita, KSNon-citizen corporation, flight hours not reportedS/N 9007N907PHShore Capital Aviation LLC · Chicago, ILBuilt 2006 · S/N 9210N907WSN907ws Aviation LLC · Honolulu, HIBuilt 2005 · S/N 9176N909ZMMoelis & Company Manager LLC · Los Angeles, CABuilt 2025 · S/N 60162N90FXCitation X Parts LLC · Liberty, NCBuilt 1999 · S/N 9017N90LEEstein Aviation LLC · Orlando, FLBuilt 2025 · S/N 60188N9103JSn 9103 LLC · Dover, DEBuilt 2002 · S/N 9103N9125XDodson International Parts Inc · Rantoul, KSS/N 9122N912MTUS Bank Na · Marshall, MNBuilt 2015 · S/N 9699N9130Alliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedS/N 9130N915JGBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 9115N916MXWilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 60097N917RPadaca Global LLC · Hollywood, FLBuilt 1998 · S/N 9008N918DBHdb Holdings LLC · Dallas, TXS/N 60208N918TBScout Aviation IV LLC · New York, NYBuilt 2014 · S/N 9613N919EMTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2011 · S/N 9451N925GTenax Aerospace LLC · Ridgeland, MSBuilt 2001 · S/N 9025N926PNSn 9003 LLC · Van Nuys, CABuilt 1997 · S/N 9003N92FXFlexjet LLC · Cleveland, OHBuilt 2004 · S/N 9147N930ENE Management LLC · New York, NYBuilt 1999 · S/N 9040N930FTSierra Nevada Company LLC · Sparks, NVBuilt 2025 · S/N 60209N933EYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 9731N933MLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 9504N934JMMch Air LLC · New York, NYBuilt 2015 · S/N 9748N939APRegistered aircraftS/N 9180N939GSRegistered aircraftBuilt 2014 · S/N 9663N939MLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 60058N944GL9443 LLC · Fort Lee, NJBuilt 2011 · S/N 9443N944MMTc Flight LLC · San Francisco, CABuilt 2000 · S/N 9024N9506GUnited States Government · Hanscom Afb, MABuilt 2012 · S/N 9506N950MPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 9770N954JJSn 9103 LLC · Dover, DEBuilt 2001 · S/N 9055N954LRegistered aircraftBuilt 2016 · S/N 9776N954SPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 9113N956WSWilliams-Sonoma Stores Inc · San Francisco, CABuilt 2025 · S/N 60173N958JGDiamond Aviation LLC · Dublin, GABuilt 2002 · S/N 9116N959KFKw Flight LLC · Bozeman, MTBuilt 2024 · S/N 60120N963JPLeila Management Inc · San Francisco, CABuilt 2009 · S/N 9329N968BXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 9694N969EPTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 60193N969FBUmb Bank Na · Salt Lake City, UTBuilt 2025 · S/N 60174N96APTwo Creeks Partners LLC · Farmingdale, NYBuilt 2016 · S/N 9764N96FXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 9002
Back to AD 2020-03-21