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.

N430QSNetjets Sales Inc · Columbus, OHBuilt 2026 · S/N 50500958N430TBBernstein Air LLC · Hudson Oaks, TXBuilt 2009 · S/N 50000052N431QSRegistered aircraftBuilt 2019 · S/N 50500507N432AK2150b LLC · Westport, CTBuilt 2019 · S/N 50500549N432ATCity Gate Capital LLC · Oklahoma City, OKBuilt 2019 · S/N 50000402N432NNicholas Services LLC · Oxford, MSS/N 50500569N432QSRegistered aircraftBuilt 2019 · S/N 50500508N433NNicholas Services LLC · Oxford, MSBuilt 2019 · S/N 50500534N433QSRegistered aircraftBuilt 2019 · S/N 50500515N434QSRegistered aircraftBuilt 2019 · S/N 50500518N435NNicholas Services LLC · Oxford, MSBuilt 2022 · S/N 50500655N435TMKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2017 · S/N 50500435N436QSRegistered aircraftBuilt 2019 · S/N 50500525N437QSRegistered aircraftBuilt 2019 · S/N 50500527N438QSRegistered aircraftBuilt 2019 · S/N 50500531N439EEMango Tree Logistics LLC · Camden, DEBuilt 2024 · S/N 50000439N439PFFamous Software LLC · Fresno, CABuilt 2017 · S/N 50500439N439QSRegistered aircraftBuilt 2019 · S/N 50500542N43AGValiair Ltd Co Trustee · Casper, WYBuilt 2010 · S/N 50000128N43DJAvpro Inc · Annapolis, MDS/N 50500557N43EPDp1963 LLC · Largo, FLBuilt 2010 · S/N 50000129N43RJR&J Aviation LLC · Nash, TXBuilt 2026 · S/N 50500935N440XXAeroplane LLC · Louisville, KYBuilt 2022 · S/N 50500713N441QSNetjets Sales Inc · Columbus, OHBuilt 2026 · S/N 50500961N441WMWhite Mountains Capital LLC · Hanover, NHBuilt 2018 · S/N 50500472N442QSRegistered aircraftBuilt 2020 · S/N 50500565N443BBRdi 1 Air Phenom LLC · Cincinnati, OHBuilt 2012 · S/N 50500106N443QSRegistered aircraftBuilt 2021 · S/N 50500616N444KZWarrior Notes · Destrehan, LABuilt 2010 · S/N 50500004N444MNMctr LLC · Hurricane, UTS/N 50500351N444QSRegistered aircraftS/N 50500621N446QSRegistered aircraftS/N 50500622N447QSRegistered aircraftS/N 50500635N449QSRegistered aircraftBuilt 2022 · S/N 50500659N450JFWasatch Aviation Group 450 LLC · Sandy, UTBuilt 2010 · S/N 50000184N451QSRegistered aircraftBuilt 2022 · S/N 50500665N452QSRegistered aircraftBuilt 2022 · S/N 50500671N453QSRegistered aircraftBuilt 2022 · S/N 50500683N454CCAuto Advisors Group LLC · Phoenix, AZBuilt 2020 · S/N 50500580N454DRSpegs Aviation LLC · Scottsdale, AZBuilt 2009 · S/N 50500005N454QSRegistered aircraftBuilt 2022 · S/N 50500690N456QSRegistered aircraftBuilt 2022 · S/N 50500698N456RFCape Aerospace LLC · Naples, FLBuilt 2011 · S/N 50000223N457QSRegistered aircraftBuilt 2022 · S/N 50500704N458QSRegistered aircraftBuilt 2022 · S/N 50500708N459QSRegistered aircraftBuilt 2023 · S/N 50500721N460QSRegistered aircraftBuilt 2023 · S/N 50500730N462BMCaliber Aviation LLC · Peoria, AZS/N 50000149N462QSRegistered aircraftBuilt 2023 · S/N 50500719N463QSRegistered aircraftBuilt 2023 · S/N 50500748
Back to AD 2021-24-21