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='237') 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
ACES Systems vibrant aviation diagnostic instruments are recognized worldwide by users and manufacturers as easy-to-use- versatile- and affordable. Aviation maintenance tasks such as propeller balancing- rotor track and balance- fan trim balancing- engine performance monitoring- vibration analysis- and acoustic analysis become virtually effortless with ACES Systems.
CNR was established in 1989 by our Managing Director- Chris Reckless- to provide contract engineering design services to industrial and transport markets. Since we began- the company has expanded- supplying an increasing diversity of market sectors with a range of engineering services- with specific expertise in helicopter transmissions and laser alignment systems.
Laversab Aviation Systems is a leading supplier of Air Data Test Sets and Pitot Static Testers to the Aviation Industry. For more than 30 years, Laversab has been dedicated to providing reliable and innovative products to the aviation industry. Our line of Pitot Static Test equipment and RVSM Air Data Testers are used by hundreds of customers in the Military, Commercial, Business and General aviation sectors worldwide for both fixed-wing and rotor-wing aircraft. Our products are designed and manufactured at our new state-of-the-art facility to exacting quality standards.