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.

N464QSRegistered aircraftBuilt 2023 · S/N 50500751N465WGtw Aviation LLC · San Jose, CABuilt 2010 · S/N 50000215N466JGTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 50500893N466QSRegistered aircraftS/N 50500757N467MSSuperior Capital Holdings LLC · Fayetteville, ARBuilt 2021 · S/N 50500614N467QSRegistered aircraftBuilt 2023 · S/N 50500760N468QSRegistered aircraftBuilt 2023 · S/N 50500766N468SFL And M Aviation LLC · Elk City, OKBuilt 2011 · S/N 50000237N469QSRegistered aircraftBuilt 2023 · S/N 50500767N4711Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 50500798N471PGPhenomenal Aviation LLC · Bradenton, FLBuilt 2026 · S/N 50000471N471QSRegistered aircraftBuilt 2023 · S/N 50500771N472EEBank Of Utah Trustee · Salt Lake City, UTBuilt 2026 · S/N 50000472N472QSRegistered aircraftBuilt 2023 · S/N 50500772N473BBBcb Aviation LLC · Jonesboro, ARBuilt 2018 · S/N 50500473N473QSRegistered aircraftBuilt 2023 · S/N 50500777N474QSRegistered aircraftBuilt 2024 · S/N 50500787N474VBWestern States Aviation LLC · Laguna Beach, CABuilt 2013 · S/N 50500176N475QSRegistered aircraftBuilt 2024 · S/N 50500790N475TRTorrence Enterprises LLC · Henderson, TXBuilt 2019 · S/N 50500541N476QSRegistered aircraftBuilt 2024 · S/N 50500795N477QSRegistered aircraftBuilt 2024 · S/N 50500799N478QSRegistered aircraftS/N 50500802N479MAMaxair LLC · Oshkosh, WIBuilt 2010 · S/N 50500042N479MMWestern Arkansas Properties LLC · Fort Smith, ARBuilt 2022 · S/N 50500686N479QSRegistered aircraftBuilt 2024 · S/N 50500805N480QSRegistered aircraftBuilt 2024 · S/N 50500809N481QSRegistered aircraftBuilt 2024 · S/N 50500811N482BBIcebox Express LLC · Intl Falls, MNBuilt 2010 · S/N 50500018N482QSRegistered aircraftBuilt 2024 · S/N 50500817N483QSRegistered aircraftBuilt 2024 · S/N 50500830N484JHRmh Aviation LLC · Wilmington, DEBuilt 2009 · S/N 50000016N484QSRegistered aircraftBuilt 2024 · S/N 50500837N484SJN484jh I LLC · La Jolla, CABuilt 2023 · S/N 50500717N485LDDodson International Parts Inc · Rantoul, KSBuilt 2014 · S/N 50500250N485QSRegistered aircraftBuilt 2024 · S/N 50500823N486QSRegistered aircraftBuilt 2024 · S/N 50500840N487QSRegistered aircraftBuilt 2024 · S/N 50500841N488QSRegistered aircraftBuilt 2025 · S/N 50500866N489QSRegistered aircraftBuilt 2025 · S/N 50500873N48CKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2023 · S/N 50500746N48KECnwp Management LLC · Greensboro, NCBuilt 2017 · S/N 50000376N48LTLaketwo Aviation LLC · Fargo, NDBuilt 2019 · S/N 50000409N48VCVermeer Manufacturing Co DBA · Pella, IABuilt 2012 · S/N 50000291N48VMVermeer Manufacturing Co · Pella, IABuilt 2015 · S/N 50500292N48WZOlen Air LLC · Dover, DEBuilt 2026 · S/N 50500936N48XCEmbraer Executive Aircraft Inc · Melbourne, FLS/N 50500996N490QSRegistered aircraftBuilt 2025 · S/N 50500877N491QSRegistered aircraftBuilt 2025 · S/N 50500880N492QSRegistered aircraftBuilt 2025 · S/N 50500887
Back to AD 2021-24-21