SELECT /* MAIN SEARCH QUERY */
	
	pm.name AS manufacturer,
	pm.name AS manufacturer_name,
	P.id,
	P.id AS product_id,
	P.code,
    P.cost_price,
    P.vat_enabled,
	P.description,
	P.sold_retail,
	P.sold_trade,
	P.sold_wholesale,
    P.country_origin_code,
    P.commodity_code,
    P.price_set,
    P.width,
    P.height,
    P.length,
    P.product_scale_id,
    P.reorder_level,
    P.release_date,
    P.weight,
    P.restriction,
    P.restriction_bit,
    P.active,
    P.minimum_level,
    P.second_hand,
    P.limited_availability,
    P.can_reorder,
    P.warehouse_zone_id,
    P.wholesale_customers,
    P.new_price,
    P.big_postage,
    P.disable_min_order_amount,
    P.last_updated,
    P.notes,
    P.old_product_scale_txt,
    P.has_image_200,
    P.has_image_400,
    P.last_purchase_order_stock,
    P.last_purchase_order_date,
    P.first_delivered_date,
    P.last_moved,
    P.scale_string,
    P.keywords,
    P.finished_date,
    P.availability,
    P.sold,
    P.sold_total,
    P.sold_retail,
    P.sold_trade,
    P.sold_wholesale,
	P.base_price,
	P.base_export_price,
	P.retail_discount,
	P.eu_price,
	P.export_price,
	P.trade_price,
	P.trade_export,
	P.wholesale_price,
	P.wholesale_export,
	P.discount,
	P.backorder_retail_discount,
	P.backorder_discount,
	P.trade_discount,
	P.wholesale_discount,
	P.product_category_id,
    P.product_division_id,
	P.product_type_id,
	P.product_manufacturer_id,
	GROUP_CONCAT(DISTINCT ps.scale ORDER BY ps.scale ASC SEPARATOR ', ') AS scale,
	UNIX_TIMESTAMP(P.date_added) AS date_added,
	UNIX_TIMESTAMP(P.arrival_date) AS arrival_date ,
	DATE(P.arrival_date) AS real_arrival_date ,
	pt.name AS product_type,
	pt.name AS type_name,
	media.filename,
	IF (pp.id is null,0,1) as pending,
	
	if(
		coalesce( (coalesce(sl.count , 0) - coalesce(sc.product_quantity , 0 ) ) , 0 ) >= 0  ,
		if(
			coalesce( (coalesce(sl.count , 0) - coalesce(sc.product_quantity , 0 ) - coalesce(bv.backorders, 0 ) - coalesce(bv.free_backorders, 0 ) ) , 0 ) >= P.show_stock,
			P.show_stock ,
			coalesce( (coalesce(sl.count , 0) - coalesce(sc.product_quantity , 0 ) - coalesce(bv.backorders, 0 ) - coalesce(bv.free_backorders, 0 ) ) , 0 )
		)
	    , 0
	) as available,
    COALESCE(sl.count,0) as stock_level,
    COALESCE(sc.product_quantity,0) AS stock_committed,
    COALESCE(bv.backorders,0) AS backorders,
    COALESCE(bv.free_backorders,0) AS free_backorders,
	pc.id as department_id,
	pc.name as department,
	pc.name as department_name,
	P.show_stock,
	if(
		pc.name = 'Future Releases',
		true,
		false
	) AS future,
    unix_timestamp(media.date_uploaded) as unixtime



FROM product P
LEFT JOIN stock_level sl on P.id = sl.product_id
LEFT JOIN stock_committed sc on sc.product_id = P.id
LEFT JOIN backorder_values bv ON bv.product_id = P.id
LEFT JOIN product_category pc on P.product_category_id = pc.id
LEFT JOIN product_manufacturer pm ON P.product_manufacturer_id = pm.id
LEFT JOIN product_media media ON P.id = media.product_id AND `media`.`order` = 0

JOIN
product_scale_map AS psm ON (psm.product_id = P.id)

LEFT JOIN
product_scale ps ON (psm.scale_id = ps.id)

LEFT JOIN product_type pt ON P.product_type_id = pt.id
LEFT JOIN pending_product pp ON P.id = pp.id
WHERE 1  AND P.restriction_bit & 1 = 1 AND P.product_manufacturer_id=362387 AND P.price_set = 1 
		 AND P.product_category_id = 102 
		AND pc.show_in_search = 1

	 AND (P.product_category_id = 103 OR P.price_set) GROUP BY P.id ORDER BY DATE(P.arrival_date) desc, P.code
Catalogue | Hannants
Hannants News Feed Subscribe To This Search | Create Search Alert Create Search Notification

Catalogue



Found 319 results
| View per page
Refine your search

Deprecated: Creation of dynamic property Hannants\SearchFilters::$searchDirection is deprecated in /mnt/vault/Sync/Dessol/Sites/hannants.co.uk/php_includes/classes/SearchFilters.php on line 113
Manufacturer & Catalogue No ASC DESC
Scale ASC DESC
Description ASC DESC
Type ASC DESC
Department ASC DESC
Price ASC DESC
Watch
Stock ASC DESC
Buy

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR32104
Supermarine Spitfire 3 Slot Wheels - Circumferential (for all kits) This set contains a pair of super detailed resin 3 slot wheels with ribbed tires/tyres as fitted to many postwar variants, including the Supermarine Spitfire Mk.XIV, Mk.XVI, Mk.XVIII, Mk.XIX, Mk.22/24, as well as some Seafire 45 and 46 and Spiteful/Seafangs. These wheels are fitted to many postwar foreign Spits as well as many warbirds of all marks. Made from ...
Aircraft wheels (resin)
Catalogue
£9.99
-
In Stock
5

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR32140
1:32
Hawker Typhoon Mk.Ib, Tempest Series 1 Main wheels. The first ever accurate Typhoon style mainwheels, created from careful measurements of surviving wheels and study of period photos. Super detailed, accurate resin 5-slot wheels fitted to most Hawker Typhoons and Series 1 Tempest Mk.Vs (designed to be used with MDC, Pacific Coast Models, Special Hobby and Revell kits)
Aircraft wheels (resin)
Catalogue
£9.99
-
In Stock
9

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR32141
1:32
Hawker Typhoon Mk.Ib /Hawker Tempest Mk.V Intake Ring (designed to be used with Pacific Coast Models kits) This set consists of an accurate one piece, seamless resin carburetor intake duct and shroud. It replaces the somewhat crude multi-part duct found in the otherwise very nice PCM Tempest V. Also fitted to many Typhoons and other Tempest Mk.V kits.
Aircraft detailing sets (resin)
Catalogue
£5.99
-
In Stock
9

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR48092
1:48
Supermarine Spitfire PR Mk.XIX Tubular Exhausts (designed to be used with Airfix kits)
Aircraft exhausts (resin)
Catalogue
£5.99
-
In Stock
8

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR48096
1:48
Supermarine Spitfire PR Mk.XIX Vacform Canopy (designed to be used with Airfix kits) This set contains one sparkling, crystal clear, vacformed pressurized canopy with separate hood and frameless PR type windscreen. Designed for the beautiful Airfix Spit XIX.
Aircraft canopies (vacform)
Catalogue
£4.50
-
In Stock
7

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR48097
1:48
Supermarine Spitfire Mk.XIX 3 slot wheels - Circumferential (For all kits) Supermarine Spitfire 3 Slot Wheels - Circumferential (for all kits) (designed to be used with Academy, Airfix, Arii, AZ Models, Eduard kits, Fujimi, Hasegawa, ICM, Italeri, MPM, Ocidental, Otaki, Revell, Special Hobby and Tamiya kits)
Aircraft wheels (resin)
Catalogue
£7.99
-
In Stock
5

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR48147
1:48
Westland Whirlwind fighter Main Wheels This set contains a pair of super detailed, accurately sized and proportioned resin 4-slot wheels with logos, tire/tyre data and beading. Both the Cooper Details and Classic Airframes wheels are inaccurate. I should know. I mastered them back in the late 1980s! Technology and better access to research has finally allowed me to recreate them accurately. (designed to be used with Classic Ai...
Aircraft wheels (resin)
Catalogue
£7.99
-
In Stock
6

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR72100
1:72
Vought Corsair, Grumman Hellcat Wheels - Plain Tread (For all Corsair and Hellcat kits) Super detailed resin mainwheels with accurately proportioned 8 slot cast hub. Internal hub detail is visible through the slots! Features untreaded tires/tyres as commonly seen fitted to some F6Fs and F4Us during WWII. A simple upgrade for all Corsair and Hellcat kits. (designed to be used with Academy, Airfix, Heller, Hasegawa, Revell kits)
Aircraft wheels (resin)
Catalogue
£5.99
-
In Stock
6

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR72101
1:72
Vought Corsair, Grumman Hellcat Wheels - Diamond Tread (For all Corsair and Hellcat kits) Super detailed resin mainwheels with accurately proportioned 8 slot cast hub. Internal hub detail is visible through the slots! Features diamond tread tires/tyres as fitted to many F6Fs and F4Us in WWII and after. A simple upgrade for all Corsair and Hellcat kits. (designed to be used with Academy, Airfix, Hasegawa, Heller, Revell kits)
Aircraft wheels (resin)
Catalogue
£5.99
-
In Stock
6

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR72102
1:72
Vought Corsair, Grumman Hellcat Wheels - Postwar Tread (For all Corsair and Hellcat kits) Super detailed resin mainwheels with accurately proportioned 8 slot cast hub. Internal hub detail is visible through the slots! Features the common postwar ribbed/diamond treaded tires/tyres as fitted to many F4U-4, F4U-5, F4U-7 and AU-1s. A simple upgrade for all Hellcat and late model Corsair kits. (designed to be used with Academy, Air...
Aircraft wheels (resin)
Catalogue
£5.99
-
In Stock
10

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR72103
1:72
Vought Corsair, Grumman Hellcat Wheels - Stamped Hub (For all Corsair and Hellcat kits) Super detailed resin wheels with the late production stamped wheel hub and ribbed tires/tyres as fitted to late model F6F, F4U, Warbirds, and Air Racers. A simple upgrade for all Corsair and Hellcat kits. (designed to be used with Academy, Airfix, Heller, Hasegawa, Revell kits)
Aircraft wheels (resin)
Catalogue
£5.99
-
In Stock
5

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR72107
1:72
Supermarine Spitfire 3 Slot Wheels - Circumferential (for all kits) (designed to be used with Academy, Admiral, Airfix, AZ Models, Chematic, Eastern Express, FROG, Fujimi, Hasegawa, Heller, High Planes, Hobby Boss, Intech, Italeri, Kopro (ex KP kits), Lotnia, Matchbox, MPM, Novo, Pegasus, PM Model, Revell, Smer, Special Hobby, Sword, Tamiya, Ventura and Xtrakit kits)
Aircraft wheels (resin)
Catalogue
£5.99
-
In Stock
8

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR72136
Hawker Typhoon, Tempest Series 1 Mainwheels (For all kits) The first ever accurate Typhoon style mainwheels, created from careful measurements of surviving wheels and study of period photos. Super detailed, accurate resin 5-slot wheels fitted to most Hawker Typhoons and Series 1 Tempest Mk.Vs (designed to be used with Academy, Airfix, Brengun, Eastern Express, FROG, Heller Hobby Boss, Intech, Kovozavody Prostejov, Pavla Models...
Aircraft wheels (resin)
Catalogue
£5.99
-
In Stock
5

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR72137
1:72
Fairey Firefly I, Barracuda Early Mainwheels (designed to be used with Frog, Novo and Special Hobby kits) The first ever accurate Firefly/Barra mainwheels, created from careful measurements of surviving wheels and study of period photos. Super detailed resin 5-slot wheels fitted to wartime Fairey Firefly Mk.Is and wartime Fairey Barracudas. Greatly improves the Frog and Special Hobby kits of both subjects.
Aircraft wheels (resin)
Catalogue
£5.99
-
In Stock
3

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR32118
Vought Corsair/Grumman Hellcat Wheels - Plain Tread. This set consists of a pair of super detailed resin wheels with 8 slot cast hub and untreaded tires/tyres as fitted to some F6Fs and F4Us during WWII. The front hubcap is molded separately to permit the inner hub detail to be properly represented. The rear hub is designed to fit the Tamiya Corsair kit, but inserts are included to allow fitting these to all Corsair and Grumma...
Aircraft wheels (resin)
Catalogue
£9.99
-
In Stock
8

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR32119
Vought Corsair Grumman Hellcat Wheels - Diamond Tread. Super detailed resin wheels with 8 slot cast hub and diamond treaded tires/tyres as fitted to F6Fs and F4Us in WWII and after. The front hubcap is molded separately to permit the inner hub detail to be properly represented. The rear hub is designed to fit the Tamiya Corsair kit, but inserts are included to allow fitting these to all Corsair and Grumman Hellcat kits. . (des...
Aircraft wheels (resin)
Catalogue
£9.99
-
In Stock
5

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR32124
1:32
Hawker Tempest 32' 4-Slot Mainwheels - Smooth Tread. This set consists of a pair of super detailed, accurate resin main wheels with smooth tires/tyres as fitted to Hawker Tempest V, series II and later variants, such as the Mk.II and Mk.VI when operating primarily from grass or unimproved airfields. (designed to be used with Pacific Coast Models, Revell and Special Hobby kits)
Aircraft wheels (resin)
Catalogue
£9.99
-
In Stock
10

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR32125
1:32
Hawker Tempest 32' 4-Slot Mainwheels - Staggered Block Tread. This set consists of a pair of super detailed, accurate resin main wheels with staggered block tire/tyre tread as fitted to postwar Tempests when operating primarily from concrete runways. This wheel was also fitted to all variants of Postwar Fireflies, all variants of the de Havilland Hornet and Sea Hornet, and the mighty, but unpopular, Blackburn Firebrand. These ...
Aircraft wheels (resin)
Catalogue
£9.99
-
In Stock
7

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR32126
1:32
Vought F4U-1 Corsair Early Engine Upgrade Set. This set consists of a pair of detailed early style distributors and duplex-style ignition harness ring for F4U-1, and early F4U-1A Corsairs. This high pressure ignition system was prone to failure in flight and was replaced on later models by the style found in the kit. Stubs have pilot holes for drilling out and fitting plug wires. (designed to be used with Tamiya kits) but can ...
Aircraft engines and propellers (resin)
Catalogue
£8.99
-
In Stock
4

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR32070
Messerschitt Bf-109G Wheels - Ribbed Hub, Ribbed Tire/tyre. This set consists of a pair of super detailed, accurate resin mainwheels as fitted to the Bf-109G-5 through G-14 series aircraft. These wheels represent the very common early fit of the ribbed tire/tyre fitted to the ribbed hub. Will upgrade any 1/32nd Bf-109G kit, such as Hasegawa, Revell, and Trumpeter kits (designed to be used with Hasegawa, Revell and Trumpeter ki...
Aircraft wheels (resin)
Catalogue
£9.99
-
In Stock
8

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR32071
Messerschmitt Bf-109G Wheels - Ribbed Hub, Smooth Tire/tyre. This set consists of a pair of super detailed, accurate resin mainwheels as fitted to the Bf-109G-5 through G-14 series aircraft. These wheels represent the fit of the smooth tire/tyre fitted to the ribbed hub. Finely rendered raised tire/tyre data is featured. Will upgrade any 1/32nd Bf-109G kit, such as Hasegawa, Revell, and Trumpeter kits. (designed to be used wit...
Aircraft wheels (resin)
Catalogue
£9.99
-
In Stock
5

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR32073
Messerschmitt Bf-109G Wheels - Plain Hub, Smooth Tire/tyre. This set consists of a pair of super detailed, accurate resin mainwheels as fitted to the Bf-109G-5 through G-14 series aircraft. These wheels represent the later fit of the plain tire/tyre fitted to the plain, ribless hub. Finely rendered raised tire/tyre data is featured. Will upgrade any 1/32nd Bf-109G kit, such as Hasegawa, Revell, and Trumpeter kits. (designed to...
Aircraft wheels (resin)
Catalogue
£9.99
-
In Stock
5

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR32074
1:32
Messerschmitt Bf-109G-10, Bf-109K-4 and Heinkel He-162A-2 Salamander Mainwheels. This set consists of a pair of super detailed, accurate resin mainwheels as fitted to some Bf-109G-10 and most K-4 series aircraft. These wheels represent the the wide, smooth tire/tyre fitted to the plain, ribless hub. Finely rendered raised tire/tyre data is featured. Will upgrade any 1/32nd Bf-109G-10 and K-4 kit, such as Hasegawa and Trumpeter...
Aircraft wheels (resin)
Catalogue
£9.99
-
In Stock
8

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR32063
1:32
Heinkel He-219A-7 Uhu Open Cowl Flaps Set (designed to be used with Revell kits) A pair of beautifully detailed open engine cowl flaps and two accurate one-piece radiator units, complete with plumbing and actuator mounting ring are contained in this set. A full set of cowl flap actuator rods with spares are also included. When installed, the open flaps reveal the detailed radiator beneath, along with the detailed inside surfac...
Aircraft detailing sets (resin)
Catalogue
£18.99
-
In Stock
7

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Barracuda Studios BCR32066
1:32
Messerschmitt Me-262 Main, Ribbed Hub Nosewheels. (designed to be used with Revell nd Trumpeter kits)This set consists of detailed, accurate resin cast mainwheels with exacting tread pattern and a choice of two styles of ribbed hub nose-wheel. The nosewheel tire patterns included are smooth and ribbed. The mainwheels are molded without the brake lines, which are added by the modeler from the included wire and pressure coupling...
Aircraft wheels (resin)
Catalogue
£14.99
-
In Stock
4

[1]   «      9   |   10   |   11   |   12   |   13      »      [13]
-10

Search Area Manufacturer Item Type Search

Part Number Scale Keywords Results per Page
Exact Match
Sort by:
Sort Direction:
Added Within last week
last 2 weeks
last month
last 6 months
last year