AD 2020-21-21

Registered aircraft · 308

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-21-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-21-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.

N58CMCrystal Motorsports LLC · Crystal River, FLS/N 14030N596LFHaynes Life Flight LLC · Wetumpka, ALBuilt 2013 · S/N 14810N59PDiesel Acquisitions LLC · Milpitas, CABuilt 2007 · S/N 22036N59ZXAs 355 LLC · Gay, GABuilt 2006 · S/N 11683N5UVPortlock Aviation LLC · Mansfield, TXS/N 11150N613HAHa 109e LLC · Flushing, NYBuilt 2006 · S/N 11674N618HRBoardwalk Air I LLC · Atlantic City, NJBuilt 2020 · S/N 22419N621SCSouth Bay Helicopter Service Inc · Hayward, CAS/N 22078N631HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2016 · S/N 22349N648SHAltus Aviation Management · Las Vegas, NVNon-citizen corporation, flight hours not reportedBuilt 2018 · S/N 14954N651MCMercy Flight Central Holding LLC · Canandaigua, NYBuilt 2023 · S/N 15021N656LFTroy Equipment Holdings LLC · Houston, TXBuilt 2014 · S/N 14826N65CJBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 11051N663SSLeonardo Helicopters US Corp · Philadelphia, PABuilt 2019 · S/N 14938N669SSLeonardo Helicopters US Corp · Philadelphia, PABuilt 2019 · S/N 14940N671MHMansfield Heliflight Inc · Milton, VTS/N 14507N68NMNorth Memorial Healthcare · Brooklyn Center, MNBuilt 2008 · S/N 22076N69KGBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2006 · S/N 22021N6JEEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 11095N6VZLeonardo Helicopters US Corp · Philadelphia, PABuilt 2000 · S/N 11099N703SHNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15833N705SHNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15834N706SHNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15835N709CGBristow LLC · Lake Charles, LAS/N 14052N712MCMercy Flight Central Holding LLC · Canandaigua, NYBuilt 2022 · S/N 15008N715RTBristow LLC · Lake Charles, LABuilt 2006 · S/N 14516N71NMNorth Memorial Health Care · Brooklyn Center, MNBuilt 2009 · S/N 22146N726LFBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 14836N72HRSeminole Tribe Of Florida DBA · Davie, FLBuilt 2019 · S/N 22396N72SLMhm Logistics LLC · Wilmington, DEBuilt 2005 · S/N 14501N731HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2025 · S/N 22474N73AZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 22004N749SDRocklyn Leasing LLC · Duluth, GABuilt 2002 · S/N 11155N756LFBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 14837N75GGA109s LLC · Pinecrest, FLBuilt 2009 · S/N 22141N770PATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 22022N776LFKeybank Na · Superior, COBuilt 2016 · S/N 14846N786LFKeybank Na · Superior, COBuilt 2016 · S/N 14847N786MKAviation Trust Co LLC Trustee · Oklahoma City, OKS/N 22394N789RTIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 22257N78LFMercy Health Life Flight Network LLC · Toledo, OHBuilt 2019 · S/N 14963N794DMRed River Aircraft Leasing LLC · Anchorage, AKBuilt 2006 · S/N 14512N7ADEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 11098N7UCRegistration Pending · Greenwood Village, CORegistration pendingBuilt 2000 · S/N 11088N802SMBristow LLC · Lake Charles, LAS/N 14711N808STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15861N80NYWgb Holdings LLC · Sparta, NJS/N 11214N80PJBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 14910N810MCMercy Flight Central Holding LLC · Canandaigua, NYBuilt 2023 · S/N 15022N810STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15836
Back to AD 2020-21-21