OpenAirDocs.org
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.

N326QSRegistered aircraftBuilt 2016 · S/N 50500385N327HFSig Aero LLC · Lewes, DEBuilt 2010 · S/N 50000146N327MCMrk LLC · Belgrade, MTBuilt 2020 · S/N 50500571N327QSRegistered aircraftBuilt 2013 · S/N 50500170N327SCEhc Holdings V LLC · Birmingham, MIBuilt 2023 · S/N 50500737N328QSRegistered aircraftBuilt 2013 · S/N 50500175N329MCAced Aviation LLC · Saint Petersburg, FLBuilt 2011 · S/N 50500068N32JANorsan Aviation LLC · Duluth, GABuilt 2025 · S/N 50000469N32KCF & S LLC · Jefferson City, MOBuilt 2016 · S/N 50500339N32KETaildragger LLC · Pocatello, IDS/N 50000063N32MKh Partnership LLC · Whitefish, MTBuilt 2024 · S/N 50500792N32ZWRodforce 1 LLC · Omaha, NES/N 50500975N330QMaxair LLC · Appleton, WIBuilt 2012 · S/N 50500076N330QSRegistered aircraftBuilt 2013 · S/N 50500180N331ASExecutive Airshare LLC · Lenexa, KSBuilt 2015 · S/N 50500285N331FXFlexjet LLC · Cleveland, OHBuilt 2011 · S/N 50500032N331GVWheels Up Partners LLC · New York, NYBuilt 2012 · S/N 50500091N331QSRegistered aircraftBuilt 2013 · S/N 50500183N332EEBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 50500732N332QSRegistered aircraftBuilt 2013 · S/N 50500184N333FXFlexjet LLC · Cleveland, OHBuilt 2011 · S/N 50500034N333KZWarrior Notes · Destrehan, LABuilt 2012 · S/N 50500126N333QSRegistered aircraftBuilt 2013 · S/N 50500186N335ASExecutive Airshare LLC · Lenexa, KSS/N 50500079N335QSRegistered aircraftBuilt 2014 · S/N 50500200N336QSRegistered aircraftBuilt 2014 · S/N 50500201N337ASExecutive Airshare LLC · Lenexa, KSBuilt 2014 · S/N 50500267N337HCElektra Air LLC · New York, NYBuilt 2010 · S/N 50000183N337QSRegistered aircraftBuilt 2014 · S/N 50500202N337VBDmb LLC · Wilmington, DEBuilt 2013 · S/N 50000323N340ASExecutive Airshare LLC · Lenexa, KSBuilt 2013 · S/N 50500148N340GVLe Air II LLC · Lafayette, LABuilt 2022 · S/N 50500667N340QSRegistered aircraftBuilt 2014 · S/N 50500189N341FXFlexjet LLC · Cleveland, OHBuilt 2011 · S/N 50500047N342NXValiair Lc Trustee · Casper, WYS/N 50000342N343QSRegistered aircraftBuilt 2014 · S/N 50500194N344FXFlexjet LLC · Cleveland, OHBuilt 2011 · S/N 50500050N344QSRegistered aircraftBuilt 2014 · S/N 50500219N345BLEmbraer Executive Aircraft Inc · Melbourne, FLS/N 50500970N345QSRegistered aircraftBuilt 2014 · S/N 50500230N346ASExecutive Airshare LLC · Overland Park, KSBuilt 2016 · S/N 50500386N346FXFlexjet LLC · Cleveland, OHBuilt 2012 · S/N 50500090N347FXFlexjet LLC · Cleveland, OHBuilt 2012 · S/N 50500094N347HMSilverwings LLC · Birmingham, ALBuilt 2022 · S/N 50000434N347PGLand Air Sea Systems Inc · Kenosha, WIBuilt 2014 · S/N 50000347N347PPCastle Aviation 300 LLC · Meridian, MSBuilt 2012 · S/N 50500112N347QSRegistered aircraftBuilt 2014 · S/N 50500257N348FXFlexjet LLC · Cleveland, OHBuilt 2012 · S/N 50500097N348NVivid Aviation LLC · La Jolla, CABuilt 2015 · S/N 50000352N348QSRegistered aircraftBuilt 2014 · S/N 50500259
Back to AD 2021-24-21