AD 2011-20-01

Registered aircraft · 677

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:2011-20-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-20-01')
  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.

N340QSRegistered aircraftBuilt 2014 · S/N 50500189N341FXFlexjet LLC · Cleveland, OHBuilt 2011 · S/N 50500047N343QSRegistered 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 50500094N347PPCastle Aviation 300 LLC · Meridian, MSBuilt 2012 · S/N 50500112N347QSRegistered aircraftBuilt 2014 · S/N 50500257N348FXFlexjet LLC · Cleveland, OHBuilt 2012 · S/N 50500097N348QSRegistered aircraftBuilt 2014 · S/N 50500259N349FXFlexjet LLC · Cleveland, OHBuilt 2012 · S/N 50500100N351FXFlexjet LLC · Cleveland, OHBuilt 2012 · S/N 50500105N351QSRegistered aircraftBuilt 2014 · S/N 50500237N352DZDel Zotto International LLC · Ocala, FLBuilt 2017 · S/N 50500396N352FXFlexjet LLC · Cleveland, OHBuilt 2012 · S/N 50500109N352QSRegistered aircraftBuilt 2014 · S/N 50500244N353FXFlexjet LLC · Cleveland, OHBuilt 2012 · S/N 50500115N353QSRegistered aircraftBuilt 2014 · S/N 50500263N354FXFlexjet LLC · Cleveland, OHBuilt 2013 · S/N 50500135N354PSTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2026 · S/N 50500967N354QSRegistered aircraftBuilt 2014 · S/N 50500265N355FXFlexjet LLC · Cleveland, OHBuilt 2013 · S/N 50500139N356BHHoffman Leasing LLC · Andrews, TXBuilt 2016 · S/N 50500333N356FXFlexjet LLC · Cleveland, OHBuilt 2013 · S/N 50500155N356GRsg Aviation LLC · Park City, UTBuilt 2022 · S/N 50500676N357FXFlexjet LLC · Cleveland, OHBuilt 2014 · S/N 50500156N358EEAerodyne Flight Services LLC · Merritt Island, FLBuilt 2022 · S/N 50500658N358FXFlexjet LLC · Cleveland, OHBuilt 2014 · S/N 50500171N359AKEmbraer Executive Aircraft Inc · Melbourne, FLS/N 50500981N359ASExecutive Airshare LLC · Overland Park, KSS/N 50500354N359FXFlexjet LLC · Cleveland, OHBuilt 2014 · S/N 50500208N35EABank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2018 · S/N 50500495N360FXFlexjet LLC · Cleveland, OHBuilt 2014 · S/N 50500233N360QSRegistered aircraftBuilt 2015 · S/N 50500254N361ASExecutive Airshare LLC · Overland Park, KSS/N 50500313N361FXFlexjet LLC · Cleveland, OHBuilt 2014 · S/N 50500234N362ASExecutive Airshare LLC · Overland Park, KSBuilt 2016 · S/N 50500368N363FWRegistered aircraftBuilt 2014 · S/N 50500242N363FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 50500390N363QSRegistered aircraftBuilt 2015 · S/N 50500256N364FXFlexjet LLC · Cleveland, OHBuilt 2012 · S/N 50500133N365FXFlexjet LLC · Cleveland, OHBuilt 2015 · S/N 50500269N366FXFlexjet LLC · Cleveland, OHS/N 50500326N366QSRegistered aircraftBuilt 2015 · S/N 50500268N367FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 50500378N367QSRegistered aircraftBuilt 2015 · S/N 50500273
Back to AD 2011-20-01