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=8008 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 25 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
Falcon FNCV5648
Clear-Vax Set No.56 Luftwaffe Part 6 Includes canopies for he Dornier Do-17Z-2/Do-17Z-7/Do-17Z-10/Do-215B-4/Do-215B-5 (designed to be used with ICM kits) Messerschmitt Me-262A (designed to be used with Dragon, Italeri, Hobby Boss and Trimaster kits) Bf-109E-1/Bf-109E-3 early style hood (designed to be used with Airfix and Eduard kits) Bf-110G-4 (designed to be used with Eduard kits and Revell kits) and Bf-109G Erla hood (desig...
Aircraft canopies (vacform)
Catalogue
£14.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

Falcon FNCV1648
1:48
Luftwaffe part 2. Messerschmitt Bf-109E 'Erlaaube' (designed to be used with Monogram and Revell kits) Messerschmitt Bf-109E-4 (designed to be used with Hobbycraft kits) Messerschmitt Bf-109B/Bf-109E (designed to be used with Hobbycraft kits) Horton Ho-229A-1 (designed to be used with Dragon kits) Arado Ar-234C 'Blitz' (designed to be used with Hobbycraft kits) Dornier Do-335A 'Zerstorer' and Dornier Do-335A 'Aufklarer' reconn...
Aircraft canopies (vacform)
Catalogue
£12.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

Falcon FN412
Supermarine Swift FR.5 / F.7 With metal parts and decals..
Aircraft kits (vacform)
Catalogue
£32.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

Falcon FNCV5148
1:48
Supermarine Spitfire Special. Supermarine Spitfire and Seafires. Spifire protoype/early Mk.I (designed to be used with Tamiya kits) Supermarine Spitfire Mk.I flat screen/bulged top (designed to be used with Tamiya kits) Supermarine Spitfire Mk.I armour glass screen/bulged top (designed to be used with Tamiya kits) High Speed (designed to be used with Tamiya kits) Supermarine Spitfire PR (designed to be used with Tamiya kits) P...
Aircraft canopies (vacform)
Catalogue
£12.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

No Image
Falcon FN404
Martin-Baker MB.5 with decals
Aircraft kits (vacform)
Catalogue
£19.60
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

Falcon FNC006
1:48
Convair F-106B Delta Dart; Republic F-105B and McDonnell F4H-1 (vacform) (designed to be used with Hasegawa F-4B/N Phantom and Monogram F-105D and F-106A kits) no decals are included
Aircraft conversions (vacform)
Catalogue
£16.99
-
In Stock
2

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

Falcon FNCV3748
1:48
Italian and Russian WWII Fighters part 2. Fiat G.50 enclosed AND standard (designed to be used with Hasegawa and Sector kits) Fiat G.55 (designed to be used with Classic Airframe kits) IAR IAR-80 LTD Lavochkin LaGG-3 series 1-35 and series 66 LTD Lavochkin La-5/La-7 (designed to be used with Hobbycraft kits) Polikarpov I-16 type 5/6 and type 10 'Super Mosca' and standard (designed to be used with Hobbycraft kits) Yakovlev Yak-...
Aircraft canopies (vacform)
Catalogue
£12.99
-
In Stock
2

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

Falcon FNCV5048
1:48
Messerschmitt Bf-109 special set. Messerschmitt Bf-109V-3 (designed to be used with Hobbycraft kits), Messerschmitt Bf-109V-13 record breaker (designed to be used with Tamiya kits) Messerschmitt Bf-109 prototype and early production Messerschmitt Bf-109B (designed to be used with Hobbycraft kits) Messerschmitt Bf-10B/Bf-109C/Bf-109D (designed to be used with Hobbycraft kits) Messerschmitt Bf-109E-1/Bf-109E-3 (designed to be us...
Aircraft canopies (vacform)
Catalogue
£12.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

Falcon FNCV5448
1:48
North-American P-51 Mustang Roundup. NA-73X prototype (designed to be used with Accurate Miniatures and Italeri kits) North-American P-51A/North-American A-36A (designed to be used with Accurate Miniatures and Italeri kits) North-American P-51B/P-51C 'Malcolm' Hood (designed to be used with Accurate Miniatures and Tamiya kits) North-American P-51D-5 low profile (designed to be used with Tamiya kits) North-American P-51D Mustan...
Aircraft canopies (vacform)
Catalogue
£12.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

Falcon FNCV0348
1:48
WWII Fighters. Republic P-47D Thunderbolt 'Malcom' hood (designed to be used with Monogram kits) Messerschmitt Bf-109F (designed to be used with Airfix kits) Messerschmitt Bf-109G 'Erla Haube' (designed to be used with Arii and Otaki kits) Republic P-47D Thunderbolt 'Razorback (designed to be used with Monogram kits) Supermarine Spitfire PR Mk.IV (designed to be used with Airfix kits) Focke-Wulf Fw-190 'Blown' (designed to be ...
Aircraft canopies (vacform)
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

Falcon FNCV0748
1:48
USN Post WWII part 1. Grumman F4F Wildcat (designed to be used with Monogram kits) Grumman F6F-5 Hellcat (designed to be used with Airfix, Arii and Revell kits) Grumman F6F-3 Hellcat (designed to be used with Airfix, Arii and Revell kits) Douglas SBD Dauntless (designed to be used with Monogram kits) Grumman TBF Avenger (designed to be used with Monogram kits) Vought OS2U Kingfisher (designed to be used with Monogram kits) Cur...
Aircraft canopies (vacform)
Catalogue
£12.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

Falcon FNCV1248
1:48
USN WWII Part 2. Vought F4U-1 'Birdcage' Corsair (designed to be used with Arii and Otaki kits) Grumman F8F Bearcat (designed to be used with Italeri and Testors kits) Vought F4U-4 Corsair (designed to be used with Academy, Hasegawa and Minicraft kits) Douglas AD-6 Skyraider (designed to be used with Monogram kits) Grumman J2F Duck GL Brewster F2A Buffalo (designed to be used with Tamiya kits) North-American SNJ Texan (designe...
Aircraft canopies (vacform)
Catalogue
£12.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

Falcon FNCV1448
1:48
Luftwaffe WWII. Junkers Ju-88A-4 (designed to be used with Hobbycraft kits) Henschel Hs-129 (designed to be used with Esci and Italeri kits) Dornier Do-17Z (designed to be used with Hobbycraft kits) Arado Ar-234 'Blitz' (designed to be used with Hobbycraft kits) Dornier Do-335A (designed to be used with Monogram kits) Messerschmitt Bf-110C/Bf-110D (designed to be used with Fujimi kits)
Aircraft canopies (vacform)
Catalogue
£12.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

Falcon FNCV3148
1:48
RAF Fighters WWII. Hawker Sea Fury FB.11 (designed to be used with Hobbycraft kits) (we do not know how well this fits to the new Airfix kit yet sorry) Hawker Typhoon Mk.IB (designed to be used with Monogram kits) Hawker Hurricane Mk.I/Mk.II (designed to be used with Airfix and Hobbycraft kits) Supermarine Spitfire Mk.V (designed to be used with Tamiya kits) Gloster Gladiator (early) (designed to be used with Inpact, Lindberg ...
Aircraft canopies (vacform)
Catalogue
£12.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

Falcon FNCV3248
USAAF Fighters WWII. Seversky P-35 (designed to be used with Academy and Hobbycraft kits) Republic P-47D Thunderbolt 'Bubble' (designed to be used with Monogram kits) Republic P-47D Thunderbolt 'Razorback' (designed to be used with Arii and Otaki kits) North-American P-51/North-American A-36 Mustang (designed to be used with Accurate Miniatures and Italeri kits) Curtiss P-36 Hawk/Hawk 75 (designed to be used with Hobbycraft ki...
Aircraft canopies (vacform)
Catalogue
£12.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

Falcon FNCV3348
1:48
Imperial Japanese Naval Air Force/ IJN WWII. Mitsubishi A6M Zero (open position) (designed to be used with Hasegawa kits) Yokosuka K5Y 'Willow' (designed to be used with Arii and Otaki kits) Kyushu J7W1 Shinden (designed to be used with Hasegawa kits) Kawanishi N1K2-J Shiden-Kai 'George' (designed to be used with Hasegawa kits) Mitsubishi A5M2 'Claude' (designed to be used with Fine Molds kits) Mitsubishi F1M2 'Pete' (designed...
Aircraft canopies (vacform)
Catalogue
£12.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

Falcon FNCV3548
1:48
Luftwaffe part 3. Messerschmitt Bf-110G-2/Bf-110G-4 (designed to be used with Monogram and Revell kits) Heinkel He-178 (designed to be used with Condor kits) Junkers Ju-88G (designed to be used with Dragon kits) Junkers Ju-88A-1/A-5 (designed to be used with Monogram and Revell kits) Dornier Do-17E/Do-17F (designed to be used with Hobbycraft kits) Messerschmitt Bf-109E-3 (open position) (designed to be used with Hasegawa kits)...
Aircraft canopies (vacform)
Catalogue
£12.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

Falcon FNCV3648
USAAF WWII part 2. Lockheed P-38J/P-38M (designed to be used with Academy and MRC kits), North-American P-51D Mustang (designed to be used with Tamiya kits) North-American P-51D Mustang Dallas canopy (designed to be used with Tamiya kits) Curtiss P-40M/P-40N/Kittyhawk III (designed to be used with Mauve kits) Consolidated B-24J Liberator (Excludes Front turret) (designed to be used with Monogram kits) North-American P-51B Must...
Aircraft canopies (vacform)
Catalogue
£12.99
-
In Stock
2

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

Falcon FNCV3448
1:48
Imperial Japanese Army Air Force/IJAAF WWII. Tachikawa Ki-9 'Spruce' NI Nakajima Ki-27 'Nate' early and Nakajima Ki-27 'Nate' late (designed to be used with Hasegawa kits) Nakajima Ki-43-I 'Oscar' NI Nakajima Ki-43-II 'Oscar' (designed to be used with Fine Molds kits) Kawasaki Ki-45 'Nick' NI Mitsubishi Ki-46-III-KAI 'Dinah' (designed to be used with Tamiya kits) Mitsubishi Ki-51 'Sonia' NI Kawasaki Ki-61 Hien 'Tony' (designed...
Aircraft canopies (vacform)
Catalogue
£12.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

Falcon FNCV3848
Luftwaffe WWII part 4. Focke-Wulf Fw-190-8 Rammjager (designed to be used with Dragon, Tamiya and Trimaster kits) Messerschmitt Bf-109B-1 (designed to be used with Hobbycraft kits) Junkers Ju-88 S/T (designed to be used with Revell kits) Messerschmitt Me-163B (designed to be used with Dragon and Trimaster kits) Heinkel He-111 x 8 variants 1a early style gondola fron tranparency 1b later style gondola front transparency 1c seco...
Aircraft canopies (vacform)
Catalogue
£12.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

Falcon FNCV3948
U.S. Navy part 3. Douglas A-1E Skyraider PK Vought F7U Cutlass (designed to be used with Academy kits) Vought SB2U Vindicator (designed to be used with HIPM kits) Stearman PT-17 Kaydet (designed to be used with Lindberg kits but may fit the Revell) Vought F4U-4 Corsair (designed to be used with Academy and Hasegawa kits) Vought F4U-5N Corsair (designed to be used with Minicraft kits) Curtiss F11C Goshawk (designed to be used w...
Aircraft canopies (vacform)
Catalogue
£12.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

Falcon FNCV4048
1:48
RAF part 2. Gloster Meteor F.3 (designed to be used with Tamiya kits) Hawker Hurricane Mk.I [unarmoured windscreen, early external armour glass windscreen, standard windscreen] (in open position) (designed to be used with Hasegawa kits) de Havilland Mosquito Mk.VI (bulged type) (designed to be used with Tamiya kits) Bulldog LI/SR Hawker Fury (designed to be used with Inpact and Lindberg kits) Hawker Hunter (in open position) (...
Aircraft canopies (vacform)
Catalogue
£12.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

Falcon FNCV5248
1:48
USAF Post 1950. Convair F-106A Delta Dart (blown canopy) (designed to be used with Monogram kits) Lockheed F-80 (designed to be used with Monogram kits) Lockheed T-33 (designed to be used with Academy and Hobbycraft kits) Lockheed U-2 (designed to be used with Italeri and Testors kits) McDonnell F-15A/F-15C (designed to be used with Hasegawa kits) Northrop F-5A (designed to be used with Italeri and Testors kits) Northrop F-5E ...
Aircraft canopies (vacform)
Catalogue
£12.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

Falcon FNCV5348
1:48
U.S. Navy part IV. Douglas A-4B/A-4E Skyhawk (designed to be used with Hobbycraft kits) Douglas A-4C/A-4K Skyhawk (designed to be used with Hasegawa kits) Douglas A-4M Skyhawk (designed to be used with Hobbycraft kits) Vought F-8E Crusader (designed to be used with Monogram kits) McDonnell-Douglas F-4 Phantom (designed to be used with Hasegawa kits) Grumman F-14A/F-14B Tomcat (designed to be used with Hasegawa kits) McDonnell-...
Aircraft canopies (vacform)
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

Falcon FNCV5548
Luftwaffe Part V. Junkers Ju-88 selection. Junkers Ju-88A-5 (designed to be used with Monogram and Revell kits) Junkers Ju-88A-4 (designed to be used with Monogram and Revell kits) Junkers Ju-88C twin guns (designed to be used with Dragon, Monogram and Revell kits) Junkers Ju-88C single rear machine gun (designed to be used with Monogram and Revell kits) Junkers Ju-188A/D (designed to be used with Dragon kits)
Aircraft canopies (vacform)
Catalogue
£12.99
Out of Stock
0


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