AD 2021-24-21

Registered aircraft · 898

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:2021-24-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:2021-24-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.

N75WEWave Equity Partners LLC · Newport Beach, CABuilt 2020 · S/N 50500587N76EMU Can Fly LLC · Naples, FLBuilt 2009 · S/N 50000013N770BRTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 50000077N771DFPl400 LLC · Beaumont, CABuilt 2022 · S/N 50500702N771SSSlingshot 100 LLC · Wooster, OHBuilt 2011 · S/N 50000228N774RC774rc LLC · Hillsboro Beach, FLBuilt 2022 · S/N 50500672N777JQParadise Air LLC · Anaheim, CABuilt 2009 · S/N 50000072N777LBUnion Airspeed LLC · Cincinnati, OHBuilt 2020 · S/N 50500578N77RFGoldleaf Leasing LLC · Madison, WIBuilt 2025 · S/N 50500864N77T8c LLC · Bellevue, WABuilt 2021 · S/N 50500612N784JPPhenomenal Sales And Marketing LLC · Butler, NJBuilt 2009 · S/N 50000074N786QAArfeen Properties Lp · Beaumont, TXBuilt 2024 · S/N 50000449N787ADBurris D Rob Co-Trustee · Tucson, AZBuilt 2021 · S/N 50500651N787PJGo Marketing Services Inc · Raleigh, NCBuilt 2011 · S/N 50000258N789GGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 50500812N7917Owl Aviation Services LLC · Oldsmar, FLBuilt 2014 · S/N 50500226N795WWyoming Machinery Co · Casper, WYBuilt 2015 · S/N 50500296N798TWN354rx LLC · Nashville, TNBuilt 2016 · S/N 50000372N79KLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 50500478N79RZTop Flite Holdings Nc Inc · Naples, FLBuilt 2010 · S/N 50000142N7CHCmh Services Aviation Inc · Maryville, TNBuilt 2026 · S/N 50500925N7DCBlue Rock Flyers LLC · Missoula, MTBuilt 2010 · S/N 50000179N7DRRandolph Aviation LLC · Naples, FLBuilt 2015 · S/N 50500323N7FWCc Coast To Coast LLC · Corpus Christi, TXBuilt 2020 · S/N 50500551N7HMShoeson LLC · Wilmington, DEBuilt 2014 · S/N 50000349N7JWNetwork Sales And Leasing Inc · Newtown, PABuilt 2013 · S/N 50500172N7LGGarrett Luke R · Joaquin, TXBuilt 2015 · S/N 50000360N800CSCat Scale Co · Walcott, IABuilt 2020 · S/N 50500594N800ETUncharted LLC · Whitefish, MTBuilt 2023 · S/N 50500744N801MEmbraer Executive Aircraft Inc · Melbourne, FLBuilt 2026 · S/N 50500974N801SHBank Of Utah Trustee · Salt Lake City, UTBuilt 2026 · S/N 50500927N801WZ400 Club LLC · Marco Island, FLBuilt 2013 · S/N 50500144N804SWRegistered aircraftBuilt 2016 · S/N 50500346N805PGValti LLC · Dover, DEBuilt 2015 · S/N 50500287N807NNicholas Services LLC · Oxford, MSBuilt 2019 · S/N 50500504N808MLb Rat Condo LLC · Tampa, FLBuilt 2010 · S/N 50500031N80FEJava Wave LLC · Valparaiso, INBuilt 2017 · S/N 50500416N810NNicholas Services LLC · Oxford, MSBuilt 2021 · S/N 50500602N811HGTwo Guys And A Plane Ltd · Toledo, OHBuilt 2021 · S/N 50500646N812LPFrontline Aviation LLC · Lake Mary, FLBuilt 2023 · S/N 50500747N813EEBank Of Utah Trustee · Salt Lake City, UTS/N 50500813N814NNicholas Services LLC · Oxford, MSBuilt 2018 · S/N 50500455N816WFBlue Parrot Capital LLC · Cabot, ARBuilt 2020 · S/N 50500584N8188EPilotinside.Com LLC · Reno, NVBuilt 2023 · S/N 50500724N818CMWheels Up Partners LLC · Ny, NYBuilt 2017 · S/N 50500410N818RPEdison Air LLC · Cleveland, OHBuilt 2019 · S/N 50500520N82161Noble Leasing LLC · Atlanta, GABuilt 2011 · S/N 50500054N828TRPenney And Associates · Roseville, CAS/N 50500627N82DUR & M Okieone LLC · Oklahoma City, OKBuilt 2008 · S/N 50000008N833CLLuck Stone Corp · Manakin Sabot, VABuilt 2024 · S/N 50500846
Back to AD 2021-24-21