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.

N610EPTug Hill Aviation LLC · Fort Worth, TXBuilt 2020 · S/N 50500582N611ECB&R Leasing LLC · Inver Grove Hgts, MNBuilt 2012 · S/N 50000265N613RJenkins Aviation Inc · North Charleston, SCBuilt 2014 · S/N 50500205N617AEmbraer Executive Aircraft Inc · Melbourne, FLS/N 50500988N620ASHgh Aviation LLC · Wilmington, DEBuilt 2009 · S/N 50000045N623DTRg Aviation LLC · Sinking Spring, PABuilt 2010 · S/N 50000148N627DBBailey Aviation Holdings LLC · Hayden, IDBuilt 2010 · S/N 50000118N628ALParker Acres LLC · Kalispell, MTBuilt 2011 · S/N 50000243N628DSDisam Air LLC · Daytona Beach, FLBuilt 2013 · S/N 50500151N629JJBenton Aviation LLC · Millersburg, OHBuilt 2010 · S/N 50000157N62SQGold Star Aviation Inc · Salisbury, NCBuilt 2024 · S/N 50000456N63007Woody In The Sky With Diamonds LLC · New York, NYBuilt 2010 · S/N 50000145N631ADWheels Up Partners LLC · New York, NYBuilt 2017 · S/N 50500423N631JSDrrt Mobility Services Inc · Fort Lauderdale, FLS/N 50500089N636DKCraig May LLC · Chico, CAS/N 50500636N636SDOld Bonita Air LLC · Marshall, TXBuilt 2009 · S/N 50000117N637AS637as Aviation LLC · Las Vegas, NVBuilt 2010 · S/N 50000133N640DPDodson International Parts Inc · Rantoul, KSS/N 50000165N640HCC & S Aviation LLC · Newport, ARBuilt 2025 · S/N 50500890N6422ZFgc Corrmed Aero Inc · Benton, KYBuilt 2023 · S/N 50000444N644RMWeldon Air LLC · Chaffee, MOBuilt 2009 · S/N 50000061N645BBunn Family Corp · Springfield, ILBuilt 2014 · S/N 50500238N647ASCavern Aviation LLC · Lenexa, KSBuilt 2009 · S/N 50000067N648DXQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 2010 · S/N 50000176N648MEMid-West Hose & Specialty Inc · Oklahoma City, OKBuilt 2017 · S/N 50500425N649DXAsa Parts LLC · Dallas, TXBuilt 2010 · S/N 50000194N650UPWoodland Drive Crossing LLC · Riverside, CTBuilt 2015 · S/N 50500300N651UPWheels Up Partners LLC · New York, NYBuilt 2015 · S/N 50500322N652UPInfinity & Beyond LLC · Fort Lauderdale, FLBuilt 2016 · S/N 50500348N653UPUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 50500564N654UPWheels Up Partners LLC · New York, NYBuilt 2013 · S/N 50500122N654WBSunridge Properties Inc · Mesa, AZBuilt 2024 · S/N 50500835N655UPUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 50500399N656UPWheels Up Partners LLC · New York, NYBuilt 2016 · S/N 50500358N657UPUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 50500572N658UPUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 50500581N659UPUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 50500355N65KZKinze Aircraft LLC · Williamsburg, IABuilt 2012 · S/N 50500103N661UPInfinity & Beyond LLC · Fort Lauderdale, FLBuilt 2017 · S/N 50500436N662JMJtl Investments LLC · Phoenix, AZBuilt 2022 · S/N 50500685N662UPWheels Up Partners LLC · New York, NYBuilt 2019 · S/N 50500530N664UPUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 50500375N665ABBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 50000368N665ASJssi Parts LLC · Chicago, ILBuilt 2009 · S/N 50000018N665UPInfinity & Beyond LLC · Fort Lauderdale, FLBuilt 2014 · S/N 50500185N667UPWheels Up Partners LLC · New York, NYBuilt 2021 · S/N 50500620N668UPUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 50500442N669AGFlying Time Machine LLC · Dover, DEBuilt 2010 · S/N 50000182N66JSan Sophia Aviation LLC · Carrollton, GABuilt 2020 · S/N 50500575N66MCj Leasing Services LLC · San Diego, CAS/N 50500412
Back to AD 2021-24-21