select GROUP_CONCAT(psa.advertiser_id) from wp_pods_advertiser advertiser inner join wp_podsrel_advertiser_product_service_advertiser psa ON (psa.advertiser_id = advertiser.id) inner join wp_podsrel_advertiser_product_service_service_type cat_type ON (cat_type.advertiser_product_service_id = psa.advertiser_product_service_id and cat_type.service_type_id='212') inner join wp_pods_product_service_type cat ON (cat.id = cat_type.service_type_id) where advertiser.active=1 AND advertiser.product_services_supplier=1
“The Door Steward™ is a product improvement installation that greatly improves the operation of the aircraft doors. The installation consists of a gas spring attached to brackets mounted on the door and the airframe. When the door is unlatched the gas spring gently but firmly opens the door to the full open position. The gas spring while in the open position protects the aircraft and occupants from unexpected openings and closings by providing resistance to considerably higher wind gusts and prop wash than the original stops.