Sign In
Register

Or

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='249') 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

1 Homebuilt Aircraft Kits found

Just Aircraft, LLC
Just Aircraft

Categories:

Just Aircraft LLC is an American aircraft manufacturer based in Walhalla, South Carolina and founded by Troy Woodland in 2002. The company specializes in the design and manufacture of STOL light aircraft in the form of kits for amateur construction and complete ready-to-fly light-sport aircraft