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.

N493QSRegistered aircraftBuilt 2025 · S/N 50500894N494BAM G Air Transport LLC · Newport, NCS/N 50500085N494QSRegistered aircraftBuilt 2025 · S/N 50500900N495JHPhenom Holdings 495 LLC · Wilmington, DEBuilt 2011 · S/N 50500066N495QSRegistered aircraftBuilt 2025 · S/N 50500908N496QSBj'S Wholesale Club Inc · Oklahoma City, OKBuilt 2025 · S/N 50500912N497QSRegistered aircraftBuilt 2026 · S/N 50500914N498QSRegistered aircraftBuilt 2026 · S/N 50500917N499DTJedco Properties LLC · Nantucket, MABuilt 2024 · S/N 50500844N499QS3ten Construction LLC · Oklahoma City, OKBuilt 2026 · S/N 50500918N4BRandolph Aviation LLC · Naples, FLBuilt 2016 · S/N 50500347N4CDEmbraer Executive Aircraft Inc · Melbourne, FLBuilt 2026 · S/N 50500977N4LMLm Aviation Advisors LLC · Missoula, MTBuilt 2021 · S/N 50500608N4MT4mt LLC · Naples, FLS/N 50500009N4RSRcs Leasing LLC · Wentzville, MOBuilt 2014 · S/N 50500221N500CJIsla Lab Caribbean LLC · Guaynabo, PRBuilt 2020 · S/N 50500596N500DAWtj Capital Holdings II LLC · Vero Beach, FLBuilt 2020 · S/N 50500591N500ECN500ec LLC · Columbus, MTBuilt 2014 · S/N 50500251N500RBOkvs LLC · Lake Sherwood, CABuilt 2014 · S/N 50000334N500TPEmbraer Executive Aircraft Inc · Melbourne, FLS/N 50500985N502DVBedrock Base LLC · Brecksville, OHBuilt 2025 · S/N 50500862N502TXState Of Texas · Austin, TXBuilt 2019 · S/N 50000413N503ERTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 50500039N503TXState Of Texas · Austin, TXBuilt 2019 · S/N 50000412N504TXState Of Texas · Austin, TXBuilt 2019 · S/N 50000415N504WPWjp Logistics LLC · Newark, DEBuilt 2012 · S/N 50000294N505FFJones Co · Waycross, GABuilt 2024 · S/N 50500847N505GPPat Enterprises LLC · Santa Rosa Beach, FLBuilt 2014 · S/N 50500188N505LFRegistered aircraftBuilt 2019 · S/N 50500545N506BCrescent Solutions Group LLC · Park City, UTBuilt 2013 · S/N 50000313N506PTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 50500098N509DDAir Services II LLC · Spokane, WABuilt 2018 · S/N 50500479N511BCBc010101 LLC · Sioux Falls, SDBuilt 2021 · S/N 50500633N511KSEcho Matrix LLC · Bentonville, ARBuilt 2020 · S/N 50500586N511WKRegistered aircraftBuilt 2009 · S/N 50000103N514AFOtu Aerospace LLC · Horseshoe Bay, TXBuilt 2009 · S/N 50000039N515ESEmbraer Executive Aircraft Inc · Melbourne, FLBuilt 2026 · S/N 50500966N516NNicholas Services LLC · Oxford, MSBuilt 2017 · S/N 50500397N517TXTransmedics Inc · Belgrade, MTBuilt 2023 · S/N 50500715N521NTaylor Air LLC · Oxford, MSBuilt 2022 · S/N 50500700N521PEProaviation LLC · Sedalia, MOBuilt 2025 · S/N 50500922N522EPRegistered aircraftBuilt 2009 · S/N 50000022N5237RGlasstrans LLC · East Moline, ILBuilt 2013 · S/N 50000314N523DMD Fla Aviation LLC · Bowling Green, KYBuilt 2010 · S/N 50500036N524NCActono LLC · Las Vegas, NVBuilt 2009 · S/N 50000085N525MNPierpont King LLC · Tulsa, OKBuilt 2011 · S/N 50000235N528TMB O E Bancshares Inc · Lawton, OKBuilt 2012 · S/N 50500128N529NNicholas Services LLC · Oxford, MSBuilt 2023 · S/N 50500761N535BCWac Charter Inc · Aurora, ORBuilt 2018 · S/N 50500449N535GBBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 50500599
Back to AD 2021-24-21