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.

N515MJFleet Two LLC · Beverly Hills, CABuilt 2025 · S/N 60177N517RPSl Global 2026 LLC · Basking Ridge, NJS/N 60202N518DDDcs Aviation LLC · Dallas, TXBuilt 2004 · S/N 9141N519CPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 9200N51SETps LLC · Medina, WABuilt 2004 · S/N 9138N528MPCr Holdings LLC · Crystal Lake, ILBuilt 2008 · S/N 9307N529DBHardwicke Properties LLC · Houston, TXBuilt 2025 · S/N 60186N530KCRegistered aircraftBuilt 2006 · S/N 9206N53GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 9053N543GLSkechers USA Inc · Manhattan Beach, CABuilt 2013 · S/N 9543N545BZAv Logistics LLC · Cheshire, CTBuilt 2024 · S/N 60130N54DPGps 1 LLC · Tampa, FLBuilt 2002 · S/N 9120N550RLNew Prime Inc · Springfield, MOBuilt 2025 · S/N 60179N551SWSn 9086 LLC · Wilmington, DEBuilt 2001 · S/N 9086N552YMWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 9511N554AGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 9492N555DTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 9559N555HDDkh Services LLC · Salt Lake City, UTS/N 9328N555PVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 9841N560UCsms Management LLC · Pearland, TXBuilt 2009 · S/N 9366N561RLAgile Equipment Leasing LLC · Wilmington, DEBuilt 2004 · S/N 9139N562THGlobal One Tjh LLC · San Antonio, TXBuilt 2001 · S/N 9085N564DXDsg Finance LLC · Coraopolis, PABuilt 2024 · S/N 60124N569DC56 Holdings LLC · Las Vegas, NVBuilt 2006 · S/N 9209N575BGWmb Global 2018 LLC · Opa Locka, FLBuilt 2017 · S/N 9803N5883Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 9118N588CV9354 Leasing LLC · West Palm Beach, FLBuilt 2009 · S/N 9354N590EAurora Aircraft LLC · Waterford, MIBuilt 2001 · S/N 9105N590MSMartin Sprocket & Gear Inc · Arlington, TXBuilt 2000 · S/N 9042N591SRIsr Platforms LLC · Mclean, VABuilt 2023 · S/N 60105N595ETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 9588N595MPEoc Consulting LLC · Salt Lake City, UTBuilt 2018 · S/N 9822N599CETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 9515N59DBConstellation Productions Inc · Jacksonville, FLBuilt 2000 · S/N 9073N600JVJsv Leasing III LLC · Orlando, FLBuilt 2014 · S/N 9664N600NBCisco Aero - N9781 LLC · Cisco, TXBuilt 2016 · S/N 9781N603SVSv Solutions LLC · Ketchum, IDBuilt 2024 · S/N 60143N604BDL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2025 · S/N 60204N606TDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 60021N609AKPeck Ventures LLC · Henderson, NVBuilt 2009 · S/N 9346N609JPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 60128N609RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9653N60BJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 9402N60CCRegistered aircraftBuilt 2016 · S/N 9762N610AWMs Hawker LLC · Farmington Hills, MIBuilt 2004 · S/N 9143N610CXGlobal 9066 LLC · Wilmington, DEBuilt 2000 · S/N 9066N610SWSteel Services Ltd · New York, NYBuilt 2016 · S/N 9733N611BFAmb Group LLC · Atlanta, GABuilt 2016 · S/N 9774N611GJBank Of Utah Trustee · Salt Lake City, UTS/N 9569N615TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9675
Back to AD 2020-03-21