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 ps.id = 955 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 115 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 115
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

No Image
Barracuda Studios BCR48499
North-American P-51B/P-51D Mustang Diamond Tread Mainwheels This set contains a pair of accurate 3D-Printed mainwheels with diamond tread tires, complete with period accurate logo and tire data. The hubs are printed separately to preserve the see-through effect of the real wheel hub. Two rear hub styles are supplied, allowing these wheels to be fitted to P-51 kits from different manufacturers. Applicable for all P-51 variants....
Aircraft wheels (resin)
Catalogue
£8.99
Out of Stock
0

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

No Image
Barracuda Studios BCR48500
North-American P-51D Mustang Block Tread Mainwheels This set contains a pair of accurate 3D-Printed mainwheels with block tread tires, complete with period accurate logo and tire data. The hubs are printed separately to preserve the see-through effect of the real wheel hub. Two rear hub styles are supplied, allowing these wheels to be fitted to P-51 kits from different manufacturers. Applicable for all P-51 variants. (Prototyp...
Aircraft wheels (resin)
Catalogue
£8.99
Out of Stock
0

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

No Image
Barracuda Studios BCR48509
RAF Small Bomb Containers - Incendiary Sticks. This set contains eight highly detailed and accurate 3D-Printed 250 pound small bomb containers. They are loaded with 4 lb. incendiary stick bombs, as fitted to many RAF bombers in WWII. These containers were delivered to the aircraft preloaded to speed the process of bombing up. A full load for a Lancaster would consist of a cookie and 14 SBCs. For all 1/48 kits. A big detail upg...
Aircraft detailing sets (resin)
Catalogue
£12.99
Out of Stock
0

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

No Image
Barracuda Studios BCR48510
1:48
RAF Small Bomb Containers - 30 Pound Bombs This set contains eight highly detailed and accurate 3D-Printed 250 pound small bomb containers. Each container is loaded with eight 30 pound bombs, as fitted to many RAF bombers in WWII. These containers were delivered to the aircraft preloaded, to speed the process of bombing up. A full load for a Lancaster would consist of a cookie and 14 SBCs. For all 1/48 kits. A big detail upgra...
Aircraft detailing sets (resin)
Catalogue
£12.99
Out of Stock
0

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

No Image
Barracuda Studios BCR48517
Hawker Sea Fury Landing Gear Super detailed 3D-Printed main landing gear struts and retracts, tailwheel leg and tailwheel designed specifically for the Airfix Sea Fury kit. Parts are 3D-Printed in a tough, ABS like resin. Stronger than the kit parts, but not bulletproof like brass parts. The advantage is the superior detail and smooth, texture and seam free surfaces that brass parts frequently have. May be adapted for the Trum...
Aircraft detailing sets (resin)
Catalogue
£12.99
Out of Stock
0

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

No Image
Barracuda Studios BCR48114
1:48
Vought F4U Corsair Smooth Tread Mainwheels This set consists of a pair of smooth tread mainwheels, as fitted to most Birdcage Corsairs, as well as many wartime Vought F4U-1 and 1a aircraft. Accurate resin cast mainwheels with logos and tire data are finished off with well fitting, super detailed, 3D-Printed wheel hub covers. Designed for the Tamiya family of Corsairs, but can be used with any 1/48 Vought F4U Corsair kit. A si...
Aircraft wheels (resin)
Catalogue
£8.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

No Image
Barracuda Studios BCR48115
Vought F4U Corsair Diamond Tread Mainwheels This set consists of a pair of classic diamond tread mainwheels as fitted to many wartime Vought F4U-1 and 1a aircraft, as well as being a common fit on later model postwar Corsairs. Accurate resin cast mainwheels with logos and tire data are finished off with well fitting, super detailed, 3D-Printed wheel hub covers. Designed for the Tamiya family of Corsairs, but can be used with ...
Aircraft wheels (resin)
Catalogue
£8.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

No Image
Barracuda Studios BCR48116
Vought F4U Corsair Postwar Tread Mainwheels This set consists of a pair of postwar tread (circumferential ribs with side diamonds) mainwheels as fitted to many postwar Vought F4U-4, -5, and AU-1 aircraft, as well as being a common fit on -1 and -1A model postwar Corsairs. Accurate resin cast mainwheels with logos and tire data are finished off with well fitting, super detailed, 3D-Printed wheel hub covers. Designed for the Ta...
Aircraft wheels (resin)
Catalogue
£8.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

No Image
Barracuda Studios BCR48117
Vought F4U Corsair Stamped Hub Mainwheels This set consists of a pair of postwar circumferential tread mainwheels with one piece stamped metal wheel hubs as often fitted to later postwar Vought F4U-4, -5, and AU-1 aircraft, as well as some postwar -1 and -1a Corsairs as well. Most Vought F4U and F6F warbirds and air racers are fitted these wheels, as I suspect they stood up to time better than the cast variety. These are high...
Aircraft wheels (resin)
Catalogue
£8.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

No Image
Barracuda Studios BCR48505
Supermarine Spitfire Early Style Control Column This is for Supermarine Spitfire Mk Is and Vs fitted with machine guns only. If it has an eight gun A wing, this is the set for you. The spade grip features the round housing for the trigger, as well as an attached brake lever. This control column is offered in 3 versions. With and without gun camera button and a third version with the ailerons deflected. Perfect for your recent...
Aircraft detailing sets (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

No Image
Barracuda Studios BCR48506
1:48
Supermarine Spitfire Late Style Control Column This stick is suitable for every Supermarine Spitfire from The Mk Vb on through the Seafire FR 47. The spade grip features the rectangular housing for the 3 position trigger switch, and a molded on brake lever. This control column is offered in 3 versions. With and without gun camera button and a third version with the ailerons deflected. A quick and easy upgrade that will be...
Aircraft detailing sets (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

No Image
Barracuda Studios BCR48486
Messerschmitt Bf-109F/Bf-109G and Bf-109K Aileron Mass Balances. Contains 4 pairs of accurate and detailed 3D-Printed aileron mass balances. Balances are cast in a strong resin to reduce the chances of breakage. They require much less cleanup and have detail that no kit parts have. Also useful to replace lost or broken kit parts on finished models. Can be fitted to any 1/48 kit of the Bf-109F, G or K.
Aircraft detailing sets (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 BCR48388
Messerschmitt Bf-109G-5 the to Bf-109G-14 smooth main tyres and separate ribbed hubs. (designed to be used with Academy, Arii, Eduard kits, Fujimi, Hasegawa, Hobby Boss, Hobbycraft, ICM, Italeri, Monogram, Otaki, Matchbox, Revell, Tamiya and Unimodel kits) [Bf-109G-6 Bf-109G-7 Bf-109G-8 Bf-109G-9 Bf-109G-10 Bf-109G-11 Bf-109G-12 Bf-109G-13 Bf-109G-6/G-2]
Aircraft wheels (resin)
Catalogue
£8.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

No Image
Barracuda Studios BCR48445
Supermarine Spitfire Mk.I - IX Five Slot Mainwheels This set contains a pair of accurate resin wheels featuring super detailed hubs and tires with logo and data. Most kit 5 slot wheels are not very well done. A very noticeable upgrade for Eduard kits, Airfix, Tamiya, and other Supermarine Spitfire Mk I, II V, VI and early IX kits, as well as Merlin engined Seafires. Master pattern by Gerry Mos.
Aircraft wheels (resin)
Catalogue
£8.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

No Image
Barracuda Studios BCR48446
Supermarine Spitfire Five Slot Z-Block Mainwheels This set consists of a pair of accurate resin wheels featuring super detailed hubs and treaded Z-Block tires with logo and data. These wheels were often fitted to Australian Supermarine Spitfire s, but were also used in Africa and the CBI theatre. Most kit 5 slot wheels are not very well done. A very noticeable upgrade for Eduard kits, Airfix, Tamiya, and other Supermarine Sp...
Aircraft wheels (resin)
Catalogue
£8.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

No Image
Barracuda Studios BCR48447
1:48
Supermarine Spitfire Mk.I - mk.IX Five Slot Covered Mainwheels This set contains a pair of accurate resin wheels featuring super detailed covered hubs and tires with logo and data. Most kits don't give you the covered option, yet they were seen quite a bit on Mk Vs and Seafires. A very noticeable upgrade for Eduard kits, Airfix, Tamiya, and other Supermarine Spitfire Mk.V, Mk.VI, Mk.VII and early Mk.IX kits. Master pattern by ...
Aircraft wheels (resin)
Catalogue
£8.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

No Image
Barracuda Studios BCR48476
Supermarine Spitfire Mk.V Cockpit Snapshot Upgrade. This set contains highly accurate and detailed replacement resin parts for the cockpit door, gunsight, stick, throttle and retract quadrants, seat with molded-in belts, and other detail parts. Also included is a sheet of cockpit stencil decals. It is designed to install quickly and easily in the Eduard Supermarine Spitfire Mk V series, but can be adapted to any other 48th sca...
Aircraft detailing sets (resin)
Catalogue
£14.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 BCR48389
Messerschmitt Bf-109G-5 the to Bf-109G-14 ribbed main tyres and separate plain hubs. W (designed to be used with Academy, Arii, Eduard kits, Fujimi, Hasegawa, Hobby Boss, Hobbycraft, ICM, Italeri, Monogram, Otaki, Matchbox, Revell, Tamiya and Unimodel kits) [Bf-109G-6 Bf-109G-7 Bf-109G-8 Bf-109G-9 Bf-109G-10 Bf-109G-11 Bf-109G-12 Bf-109G-13 Bf-109G-6/G-2]
Aircraft wheels (resin)
Catalogue
£8.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

No Image
Barracuda Studios BCR48458
Focke-Wulf Fw-190A, Fw-190D Fw-190F (early war) Standard Sliding Hood (designed to be used with Eduard kits) This set contains one accurately shaped, crystal clear, distortion free, vacform sliding standard hood to replace the kit part in all Eduard Fw-190 kits. Will fit most other kits, too. Why do you need them? Eduard's first generation 1/48 Fw-190s had both sliding hoods molded without enough bulge over the pilot's head. T...
Aircraft canopies (vacform)
Catalogue
£4.25
-
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

No Image
Barracuda Studios BCR48459
Focke-Wulf Fw-190A, Fw-190D Fw-190F (late war) Standard Sliding Hood (designed to be used with Eduard kits) This set contains one accurately shaped, crystal clear, vacform sliding blown hood to replace the kit part in all Eduard Fw-190 kits. Will fit most other kits, too. Why do you need them? Eduard's first generation 1/48 Fw-190s had both sliding hoods molded without enough bulge over the pilot's head. The second generation ...
Aircraft canopies (vacform)
Catalogue
£4.25
-
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

No Image
Barracuda Studios BCR48368
1:48
Messerschmitt Bf-109G-6 Horizontal Tailplanes with Separate Elevators (designed to be used with Tamiya kits) This set contains a new resin horizontal stabiliser with separate elevators. Most 109Gs have elevators hanging in the down position when parked, unless control locks were fitted. Directly replaces the kit tailplanes for the Tamiya Bf-109G-6. A simple upgrade to add life to your Gustav. (designed to be used with Tamiya k...
Aircraft detailing sets (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

No Image
Barracuda Studios BCR48369
Messerschmitt Bf-109G-6 and Bf-109G-14 Variants Conversion (designed to be used with Tamiya kits) The beautiful Tamiya G-6 has one main problem: it's seriously limited in the number of schemes it can be built with due to a lack of alternate parts. This set supplies you with a tall fin and two different rudders, as well as the compressor bulge fitted to the starboard buele of Erla built G-5s and some G-6s. A battery box cover f...
Aircraft conversions (resin)
Catalogue
£8.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

No Image
Barracuda Studios BCR48370
Messerschmitt Bf-109G-6 and Bf-109G-14 Seat with Molded In Belts (designed to be used with Tamiya kits) Contains a new cockpit rear bulkhead, featuring a super detailed seat with accurate and naturally draped molded-in seat belts. If you struggle with bending and gluing down etched seatbelts, trying to make them look natural, only to have them look a bit two-dimensional, this is a simple and easy to install fix. Minor cutting ...
Aircraft seats (resin)
Catalogue
£7.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

No Image
Barracuda Studios BCR48372
Messerschmitt Bf-109G-2 Though Bf-109G-10 Seat with Molded In Belts (designed to be used with Eduard kits)Contains a new cockpit floor and rear bulkhead, featuring a super detailed seat with accurate and naturally draped molded-in seat belts. If you struggle with bending and gluing down etched seatbelts, trying to make them look natural, only to have them look a bit two-dimensional, this is a simple and easy to install fix. Di...
Aircraft seats (resin)
Catalogue
£8.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

No Image
Barracuda Studios BCR48392
Messerschmitt Bf-109GK Tall Tailwheel Set. This set contains one accurate and very strong lost wax cast brass tall tail strut and two styles of detailed tailwheels in resin, both smooth and radial tread tire versions. This brass strut will not bend over time like white metal can. Can be fit to all late model Bf-109G/K kits in 1:48 scale. A quick and easy upgrade that will assure no more broken tailwheels. Designed by Gunnar Ja...
Aircraft wheels (resin)
Catalogue
£7.25
-
In Stock
5

   1   |   2   |   3   |   4   |   5      »      [5]

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