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.

N69JPPaul Air LLC · San Juan, PRBuilt 1999 · S/N 9029N6FEFederal Express Leasing Corp · Memphis, TNBuilt 2022 · S/N 60060N700HMHarbert Global Aviation LLC · Birmingham, ALBuilt 2009 · S/N 9330N700YBYb Global LLC · Mequon, WIBuilt 2010 · S/N 9377N702ERRegistered aircraftBuilt 2012 · S/N 9432N702LKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 9474N704MFMc Group · Santa Monica, CABuilt 1999 · S/N 9065N708TTWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 9607N70MJTornante Co LLC · Beverly Hills, CABuilt 2024 · S/N 60136N70PSRi Mercury LLC · Beverly, MABuilt 1999 · S/N 9012N711MCN&Md Investment Corp · Missoula, MTFirst renewal noticeBuilt 2002 · S/N 9121N711WKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 9785N711WMGaughan Flying LLC · Las Vegas, NVBuilt 2024 · S/N 60140N715TSTvpx Trust Co LLC · North Salt Lake, UTBuilt 2018 · S/N 9836N716TVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 9784N717DXDsg Finance LLC · Coraopolis, PABuilt 2023 · S/N 60084N717KDSky Range Aviation LLC · Sioux Falls, SDBuilt 2008 · S/N 9289N717NTMarila Leasing LLC · Chamblee, GABuilt 2022 · S/N 60054N718DDFlt 2 LLC · Dallas, TXBuilt 2004 · S/N 9140N718DTTse Leasing LLC · Short Hills, NJBuilt 2025 · S/N 60187N720WLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 9812N721MSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 9695N723HAHagan Properties Inc · Louisville, KYBuilt 2005 · S/N 9165N723HHAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2011 · S/N 9427N724JJKoga Air LLC · San Luis Obispo, CABuilt 2009 · S/N 9357N724MFMbf Leasing Of Florida LLC · Coral Gables, FLBuilt 2011 · S/N 9457N724MTGtbk LLC · Buffalo, NYBuilt 2024 · S/N 60150N725CSC&S Wholesale Grocers Inc · Keene, NHBuilt 2022 · S/N 60059N726AFBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 9352N726BFWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 9268N730DDDpm Aviation LLC · Dover, DEBuilt 2008 · S/N 9287N731SR83/80 LLC · New York, NYBuilt 2013 · S/N 9597N7413BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 9530N74DHHalbert & Associates LLC · Irving, TXBuilt 2006 · S/N 9217N75JJJtjd Aviation LLC · Belleair, FLBuilt 2025 · S/N 60161N75VBParamount Pictures Corp · Van Nuys, CABuilt 2007 · S/N 9247N770AGUnited States Air Force · Hanscom Afb, MABuilt 2009 · S/N 9355N770KFKw770 LLC · Bozeman, MTBuilt 2016 · S/N 9749N771BKKaiser Aviation LLC · Waterford, MIBuilt 2010 · S/N 9382N7777UTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9591N778CHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 60067N77NZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 9144N77SCBls Phenom LLC · Lawrenceville, GABuilt 2021 · S/N 60047N787KJTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2015 · S/N 9741N787NBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 9527N788MMBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 9599N78SDLiquid Aviation Inc · Del Mar, CABuilt 2017 · S/N 9765N793APCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 9454N793XInvolo LLC · New York, NYBuilt 2014 · S/N 9605N797CTCaterpillar Inc · Fort Worth, TXBuilt 2012 · S/N 9435
Back to AD 2020-03-21