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='186') 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
At Elliott Jets, we took the sales division of Elliott Aviation and expanded it to create a new enterprise. Leveraging eight decades of aircraft sales experience with new offices, additional experienced industry veterans and an aggressive approach to jet sales, purchases and trades. We use some of the best technical resources in the industry to guide you through your transaction. Our experienced team focuses on your specific needs throughout the entire process.
General Aviation Modifications- Inc. was founded in 1994 by aeronautical engineers George Braly and Tim Roehl in order to obtain a Supplementary Type Certificate (STC) to install balanced fuel injectors on TCM engines, and a Parts Manufacturing Approval (PMA) to make them. To aid in this certification process thousands of man hours went into designing a computerized data acquisition system used to this day in order to precisely measure injector flow. This dual flow bench is equipped with the most precise pressure and flow measurement equipment found anywhere in the aviation industry. http://www.gami.com/