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='234') 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
With the merger in 2009 between the Aero Vip Pilot Shop Pilot and Mr-Pilot born Pilot Wings Aviation Store Ltd as a private company integrated in the Grupo 7 Air with the headquartered in Cascais Municipal Aerodrome in Tires- Portugal. Pilot Wings is dedicated to the marketing and distribution of products for pilots - aviation companies - training schools - Pilot -Shops and aviation enthusiasts.
PilotMall.com Aviation Superstore is a specialized full-service aviation retailer offering over 5-000 aviation products. PilotMall.com was started by Neil Glazer in June of 1999. Over the years PilotMall.com has become one of the largest pilot supply retailers in the US. Our growth is thanks to our core business principles. Our goal is to offer our customers cutting edge aviation products- everyday low prices and world class service.
Our aim is to give our customers the best possible service and because we fly ourselves we can give you an informed and considered opinion on our products. If a particular article is not in stock it is usually only a question of a couple of days delivery time- thanks to our close contacts with major manufacturers.