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.

N294TXTransmedics Inc · Belgrade, MTBuilt 2023 · S/N 50500745N295TXTransmedics Inc · Belgrade, MTBuilt 2023 · S/N 50500784N297TXTransmedics Inc · Belgrade, MTBuilt 2022 · S/N 50500692N298TXTransmedics Inc · Belgrade, MTBuilt 2023 · S/N 50500722N299PPCastle Aviation II LLC · Meridian, MSBuilt 2015 · S/N 50500298N29GSAir Cashmere LLC · Granger, INBuilt 2014 · S/N 50500240N300DPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 50500573N300EEPhenom Flight Operations LLC · Marion, INBuilt 2020 · S/N 50500537N300EZAvex Xi LLC · Fort Lauderdale, FLS/N 50500794N300FJRichbuilt Construction LLC · Fort Pierce, FLBuilt 2011 · S/N 50500046N300FLValiair Lc Trustee · Casper, WYBuilt 2010 · S/N 50500027N300FMTailwinds 300 LLC · Friendswood, TXBuilt 2024 · S/N 50500845N300FPCapital Holdings 232 LLC · La Porte, INS/N 50500277N300GMRosedale Aircraft LLC · Cedar Rapids, IABuilt 2012 · S/N 50500093N300GVWheels Up Partners LLC · New York, NYBuilt 2012 · S/N 50500104N300HJ300e LLC · Miami, FLBuilt 2024 · S/N 50500827N300HYLgp Holding LLC · Chicago, ILBuilt 2014 · S/N 50500204N300JKCerulean Advisory LLC · Houston, TXBuilt 2011 · S/N 50500073N300MGEon Management LLC · Miami, FLBuilt 2012 · S/N 50500120N300MWSolidfire Racing LLC · Kalispell, MTBuilt 2012 · S/N 50500101N300QSRegistered aircraftBuilt 2016 · S/N 50500379N300RXNorthside Hay Company Inc · Tempe, AZBuilt 2017 · S/N 50500420N300ZZExecutive Airshare LLC · Overland Park, KSBuilt 2022 · S/N 50500663N301AZPhenom 300 LLC · Fort Lauderdale, FLBuilt 2016 · S/N 50500377N301BERegistered aircraftBuilt 2018 · S/N 50500464N301FXPoirrier Sharon · Cleveland, OHBuilt 2024 · S/N 50500838N301XTTub Time Aviation LLC · Portland, ORBuilt 2012 · S/N 50500096N302AZPhenom 300 LLC · Fort Lauderdale, FLBuilt 2012 · S/N 50500130N302FXRpc Strategies LLC · Cleveland, OHBuilt 2024 · S/N 50500839N302QSRegistered aircraftBuilt 2013 · S/N 50500123N302TGCrg Investments LLC · Carmel, INBuilt 2015 · S/N 50500310N303FXRpc Strategies LLC · Cleveland, OHBuilt 2024 · S/N 50500843N303QSRegistered aircraftBuilt 2013 · S/N 50500141N303TGTvpx Ars Inc Trustee · North Salt Lake, UTS/N 50500559N304FXFlexjet LLC · Cleveland, OHBuilt 2025 · S/N 50500875N304QSRegistered aircraftBuilt 2013 · S/N 50500143N305FXFlexjet LLC · Cleveland, OHBuilt 2025 · S/N 50500881N306FLRains Ronald D · Odessa, TXBuilt 2010 · S/N 50500030N306FXFlexjet LLC · Cleveland, OHBuilt 2025 · S/N 50500895N306QSNetjets Sales Inc · Columbus, OHS/N 50500976N307FXKaribu Lepidoptera LLC · Cleveland, OHBuilt 2025 · S/N 50500901N308FXFlexjet LLC · Cleveland, OHBuilt 2025 · S/N 50500910N309FXFlexjet LLC · Cleveland, OHBuilt 2025 · S/N 50500913N309QSRegistered aircraftBuilt 2013 · S/N 50500152N310FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 50500366N310QSRegistered aircraftBuilt 2013 · S/N 50500147N311FXFlexjet LLC · Cleveland, OHBuilt 2026 · S/N 50500955N311QSEmbraer Executive Aircraft Inc · Melbourne, FLS/N 50500982N312FLBam Acquisitions LLC · Carmel, INBuilt 2011 · S/N 50500037N312FXFlexjet LLC · Cleveland, OHBuilt 2026 · S/N 50500963
Back to AD 2011-20-01