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.

N670UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N 50500231N673DCPhenom Aviation LLC · Monterey, CABuilt 2009 · S/N 50000010N679KJN679kj LLC · Torrance, CABuilt 2024 · S/N 50500804N680JHHodge Aviation LLC · Muskogee, OKBuilt 2022 · S/N 50500680N685ASEz Jet LLC · Plantation, FLBuilt 2009 · S/N 50000041N685UPWheels Up Partners LLC · New York, NYBuilt 2018 · S/N 50500476N6874SNaples Jet Center Holdings LLC · Naples, FLS/N 50000210N688UPWheels Up Partners LLC · New York, NYBuilt 2015 · S/N 50500314N689MCLos Corales 601 Corp · South Padre Island, TXBuilt 2020 · S/N 50000422N68ERStarwood Air LLC · Missoula, MTBuilt 2009 · S/N 50000011N68NHAljobe Bajeky LLC · Levittown, NYBuilt 2014 · S/N 50000331N68TJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 50500246N690UPWheels Up Partners LLC · New York, NYBuilt 2015 · S/N 50500286N691UPWheels Up Partners LLC · New York, NYBuilt 2019 · S/N 50500511N692UPWheels Up Partners LLC · New York, NYS/N 50500561N693UPWheels Up Partners LLC · New York, NYBuilt 2017 · S/N 50500409N696UPWheels Up Partners LLC · New York, NYS/N 50500544N697ASExecutive Airshare LLC · Overland Park, KSBuilt 2011 · S/N 50500056N69FXPhenom489 LLC · New York, NYBuilt 2019 · S/N 50500489N69VKRegistered aircraftBuilt 2011 · S/N 50500069N6ARandolph Aviation LLC · Naples, FLFirst renewal noticeS/N 50500403N6DKDeka Research & Development Corp · Manchester, NHBuilt 2022 · S/N 50500711N6DYN6dy LLC · Los Altos, CABuilt 2024 · S/N 50500791N700AJIndigo Air LLC · Gulf Breeze, FLBuilt 2025 · S/N 50000458N701CMChronos Aviation LLC · El Paso, TXBuilt 2026 · S/N 50500944N701TWMeridian Asset Leasing LLC · Saint Louis, MOBuilt 2009 · S/N 50000088N70CHCmh Homes Inc · Maryville, TNBuilt 2016 · S/N 50500353N710AXInnovative Aviation LLC · Naples, FLS/N 50500563N710SCValiair Lc Trustee · Casper, WYBuilt 2011 · S/N 50000229N7117NTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2026 · S/N 50500969N711JTGuardian Air LLC · Hobart, WIBuilt 2022 · S/N 50500705N713GCGc Jets LLC · Big Sky, MTBuilt 2025 · S/N 50500883N713LVCarolina Air Transfer III LLC · Alpharetta, GABuilt 2019 · S/N 50500512N713WDWinds Away 07 LLC · Houston, TXBuilt 2023 · S/N 50500743N715DEJt Air LLC · Nashville, TNBuilt 2014 · S/N 50500191N715JKJdv Solutions LLC · Coralville, IABuilt 2009 · S/N 50000030N716LLLindemann Logistics LLC · Oshkosh, WIBuilt 2012 · S/N 50500099N717RSCcg Ventures LLC · Dallas, TXBuilt 2010 · S/N 50000213N720TWBravo Mike Corp · Burlington, MABuilt 2013 · S/N 50000290N723GBBank Of Utah Trustee · Salt Lake City, UTS/N 50000111N723NDHvmd Air LLC · Treasure Island, FLBuilt 2014 · S/N 50500255N725BSFlex Phenom LLC · Wapakoneta, OHBuilt 2015 · S/N 50500307N725TWBlenn Haven Logistics LLC · Parkersburg, WVBuilt 2017 · S/N 50500426N732ACRjc Leasing LLC · Appleton, WIBuilt 2011 · S/N 50500070N73DBPhenom Aviation LLC · Fayetteville, ARBuilt 2009 · S/N 50000020N750SCEnerquest Aviation Partners LLC · Midland, TXS/N 50500299N752KKPremier Air Holdings LLC · Stuart, FLBuilt 2023 · S/N 50500752N755PJPem Acquisitions LLC · Phoenix, AZBuilt 2020 · S/N 50500567N75LHTkl Capital Holdings LLC · Newark, DEBuilt 2017 · S/N 50500429N75RZFlying Phenom LLC · Sheridan, WYBuilt 2010 · S/N 50000151
Back to AD 2021-24-21