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.

N471QSRegistered aircraftBuilt 2023 · S/N 50500771N472QSRegistered aircraftBuilt 2023 · S/N 50500772N473BBBcb Aviation LLC · Jonesboro, ARBuilt 2018 · S/N 50500473N473QSRegistered aircraftBuilt 2023 · S/N 50500777N474QSRegistered aircraftBuilt 2024 · S/N 50500787N474VBWestern States Aviation LLC · Laguna Beach, CABuilt 2013 · S/N 50500176N475QSRegistered aircraftBuilt 2024 · S/N 50500790N475TRTorrence Enterprises LLC · Henderson, TXBuilt 2019 · S/N 50500541N476QSRegistered aircraftBuilt 2024 · S/N 50500795N477QSRegistered aircraftBuilt 2024 · S/N 50500799N478QSRegistered aircraftS/N 50500802N479MAMaxair LLC · Oshkosh, WIBuilt 2010 · S/N 50500042N479MMWestern Arkansas Properties LLC · Fort Smith, ARBuilt 2022 · S/N 50500686N479QSRegistered aircraftBuilt 2024 · S/N 50500805N480QSRegistered aircraftBuilt 2024 · S/N 50500809N481QSRegistered aircraftBuilt 2024 · S/N 50500811N482BBIcebox Express LLC · Intl Falls, MNBuilt 2010 · S/N 50500018N482QSRegistered aircraftBuilt 2024 · S/N 50500817N483QSRegistered aircraftBuilt 2024 · S/N 50500830N484QSRegistered aircraftBuilt 2024 · S/N 50500837N484SJN484jh I LLC · La Jolla, CABuilt 2023 · S/N 50500717N485LDDodson International Parts Inc · Rantoul, KSBuilt 2014 · S/N 50500250N485QSRegistered aircraftBuilt 2024 · S/N 50500823N486QSRegistered aircraftBuilt 2024 · S/N 50500840N487QSRegistered aircraftBuilt 2024 · S/N 50500841N488QSRegistered aircraftBuilt 2025 · S/N 50500866N489QSRegistered aircraftBuilt 2025 · S/N 50500873N48CKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2023 · S/N 50500746N48VMVermeer Manufacturing Co · Pella, IABuilt 2015 · S/N 50500292N48WZOlen Air LLC · Dover, DEBuilt 2026 · S/N 50500936N48XCEmbraer Executive Aircraft Inc · Melbourne, FLS/N 50500996N490QSRegistered aircraftBuilt 2025 · S/N 50500877N491QSRegistered aircraftBuilt 2025 · S/N 50500880N492QSRegistered aircraftBuilt 2025 · S/N 50500887N493QSRegistered 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 50500596
Back to AD 2011-20-01