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='219') 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
Founded in 1957, the Aircraft Electronics Association represents nearly 1,300 member companies in 43 countries, including government-certified international repair stations specializing in maintenance, repair and installation of avionics and electronic systems in general aviation aircraft. The AEA membership also includes manufacturers of avionics equipment, instrument repair facilities, instrument manufacturers, airframe manufacturers, test equipment manufacturers, major distributors, engineers and educational institutions.
If you are a pilot- aircraft dealer- appraiser- lender- CEO- flight department manager or anyone involved with airplanes- Vref* should be on your desktop and in your flight bag. Vref is the industry’s modern price guide designed especially for professionals operating in today’s challenging marketplace.