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.

N833LCTcb Capital Holdings LLC · Winter Park, FLBuilt 2018 · S/N 50500500N835TBTraylor Air LLC · Evansville, INBuilt 2017 · S/N 50500434N839NNicholas Services LLC · Oxford, MSBuilt 2019 · S/N 50500506N83RXRegistered aircraftBuilt 2010 · S/N 50500029N843SG843sg Holdings LLC · Hilton Head Island, SCBuilt 2011 · S/N 50000260N851LGLala Guidry Investments LLC · Madisonville, LABuilt 2021 · S/N 50500648N853GRMig Real Estate LLC · Newport Beach, CABuilt 2022 · S/N 50500681N855EEAllen D Swell LLC · Houston, TXBuilt 2024 · S/N 50500816N858EERbl Aviation LLC · Aspen, COBuilt 2016 · S/N 50500352N85SGWhite Sands Equipment Leasing LLC · Inlet Beach, FLBuilt 2010 · S/N 50000181N860CTSpairco LLC · Nacogdoches, TXBuilt 2020 · S/N 50500597N862LGMaxair LLC · Appleton, WIBuilt 2014 · S/N 50500163N86CUFisco Air LLC · Bayamon, PRS/N 50500783N86KMUmb Bank Na Owner Trustee · Salt Lake City, UTBuilt 2025 · S/N 50500867N86TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 50500826N871RVKt Construction LLC · Russellville, KYBuilt 2010 · S/N 50000218N876JCFlyakite Inc · Beverly Hills, CANon-citizen corporation, flight hours not reportedBuilt 2009 · S/N 50000075N87HGWinter Haven Aero Group Inc · Bradenton, FLBuilt 2011 · S/N 50000252N87PWSoaring Winds LLC · Glenns Ferry, IDBuilt 2019 · S/N 50000403N881RECead LLC · Fort Lauderdale, FLBuilt 2018 · S/N 50500463N886DBAircraft Holding And Leasing LLC · Sarasota, FLBuilt 2012 · S/N 50000283N886WOwlbear LLC · Oakland, CABuilt 2023 · S/N 50500729N88EJOscar Mike Ventures LLC · Dover, DES/N 50500193N88FWFw Tailwind LLC · Fort Worth, TXBuilt 2012 · S/N 50000277N88LVWya Air LLC · Sullivans Island, SCBuilt 2012 · S/N 50000299N88WEmbraer Executive Aircraft Inc · Melbourne, FLBuilt 2026 · S/N 50500973N894JHJack Henry & Associates Inc · Monett, MOBuilt 2013 · S/N 50500138N895JHJack Henry And Associates Inc · Monett, MOBuilt 2013 · S/N 50500174N896BLLeon Phenom LLC · Miami, FLBuilt 2011 · S/N 50500071N896JHWard Aviation LLC · Longmont, COBuilt 2014 · S/N 50500215N897JHN D Air LLC · Kansas City, MOBuilt 2015 · S/N 50500318N898MWN898mw Inc Trustee · Wilmington, DEBuilt 2011 · S/N 50500048N899DXQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 2010 · S/N 50000216N89JJAtlantis Aviation LLC · Frisco, TXBuilt 2010 · S/N 50000150N8BDEmpower Air II LLC · Richardson, TXBuilt 2024 · S/N 50500833N8KDBt Consulting LLC · Wilsonville, ORS/N 50000304N8PCTubing Rentals LLC · Robstown, TXBuilt 2011 · S/N 50500043N8PGPerihelion Aviation LLC · Sarasota, FLBuilt 2025 · S/N 50500924N900HTFarsight Technologies Inc · Big Bear Lake, CABuilt 2011 · S/N 50500061N904DHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 50500474N906KBAerospace Holding & Leasing LLC · Sarasota, FLBuilt 2012 · S/N 50000287N909EMEmbraer Executive Aircraft Inc · Melbourne, FLS/N 50500979N90PQ15 Holdings LLC · Zionsville, INBuilt 2019 · S/N 50500509N910XS910jk LLC · Wilmington, DEBuilt 2016 · S/N 50500359N911EJOakley In The Clouds LLC · Lake Wales, FLBuilt 2021 · S/N 50500610N911YA700pc LLC · Santa Barbara, CABuilt 2012 · S/N 50000300N914EGMs Aviation LLC · Los Angeles, CABuilt 2016 · S/N 50000355N914MLRapid Aviation LLC · Ocoee, FLBuilt 2023 · S/N 50000445N915WKRoofkan 2016 LLC · Naples, FLS/N 50500021N918STKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2023 · S/N 50500728
Back to AD 2021-24-21