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=8252 AND ps.id = 956 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 30 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
Ventura VA72102
1:48
24" RAF and Commonwealth code letters, WHITE. (these are 16" in 1/48th scale)
Aircraft decals (military)
Catalogue
£5.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
Ventura VA72096
Pacific Curtiss P-40s "Wairarapa Wildcat", NZ3078 S/Ldr. Herrick, RAAF, USAAC - P-40M-5 NZ3072 "Wairarapa Wildcat" 1943 - P-40N 42-105202, Lt. Robert M DeHaven, 7th FS, 49th FG, New Guinea, January 1944 - P-40N A29-607, Sqn Ldr John Waddy, August 1944 - P-40M-5 NZ3078, Sqn Ldr M. J. Herrick DFC and bar. Squadron Leader Michael J Herrick served in the RAF as a night fighter pilot during the Battle of Britain ...
Aircraft decals (military)
Catalogue
£9.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

No Image
Ventura VA72099
RNZAF Vought FG-1D Corsairs & Douglas C-47A Dakota, No.14 Squadron. Post war in Japan 1946-48 - Douglas C-47A NZ3505, No.40 Sqn - FG-1D Corsair NZ5659, "Doris", 1947 - FG-1D Corsair NZ5660, "Gremlin", No.14 Squadron, 1946 - FG-1D Corsair NZ5639, "Kathleen", 1946
Aircraft decals (military)
Catalogue
£11.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
Ventura VA72100
RNZAF Douglas C-47 / DC-3 Dakotas - "Kiwi" roundels, three options. Recommended kit, Airfix - NZ3547, No.42 Squadron. Parachute training configuration, 1977 - NZ3551, No.42 Squadron. VIP configuration mid 1970's - NZ3553, No.42 Squadron. VIP configuration 1978. Colour schemes. Gloss white above the fuselage window line and on vertical tail surfaces as shown on the profile. Propeller blades are black with white-r...
Aircraft decals (military)
Catalogue
£11.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
Ventura VA72101
1:72
RNZAF Douglas DC-3 Dakota - "Fern leaf" roundels, one option Recommended kit, Airfix - NZ3553, No.42 Squadron, 1956. VIP configuration. NZ3553, a C-47B-45-DK, was converted to VIP configuration in 1949 (like a DC-3, but with more comfortable seats etc.) and served with No.41 Squadron, Whenuapai until being passed to No.42 Squadron in November 1953. After a long service career, all with No.42 Squadron, it was final...
Aircraft decals (military)
Catalogue
£11.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

Ventura VA7277
RNZAF Curtiss P-40N, Pacific Theatre (Later aircraft with large roundel bars) Three options. NZ3184 '75', NZ3259 'Leslie' and NZ3267 'V'.
Aircraft decals (military)
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

No Image
Ventura VA7295
RNZAF Vought F4U-1 Corsairs #3. The four "Donald Duck" nose art Corsairs ƒ¢aš-é"ƒ¢aš-é" - NZ5248, No.21 Squadron, May 1945 - NZ5255, No.4 SU, July 1944 ƒ¢aš-é" - NZ5262, No.30 SU, 1945 - NZ5277, No.21 Squadron, July 1945
Aircraft decals (military)
Catalogue
£9.99
£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
Ventura VA7297
RNZAF Douglas SBD Dauntless. Four options. ƒ¢aš-é" - SBD-3 NZ208, home based, September 1943 ƒ¢aš-é"- SBD-5 NZ5055, 'He'll Be Back Again'. Early version - SBD-5 NZ5061, "Boxing Kangaroo" ƒ¢aš-é"- SBD-5 NZ5064, 'He'll Be Back Again'. Late version ƒ¢aš-é" SBD-3 NZ208 colour scheme. Dauntless SBD-3 NZ208 was an ex US Marine Corps aircraft painted in US Blue Gray upper surfaces and US Light Gray lower surfaces. It w...
Aircraft decals (military)
Catalogue
£9.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

No Image
Ventura VA7298
RNZAF Grumman TBF-1C Avengers #2, Pacific Theatre and home based. Three options. - NZ2522 TBF-1C, No.30 and 31 Squadron. "winged kiwi" ƒ¢aš-é"- TBF-1C, No.30 Squadron. "Donald Duck" nose art. - NZ2503, post war target tug.ƒ¢aš-é"ƒ¢aš-é" No.30 and 31 Squadron. On 26 January 1944, the first nine Avengers left for Espiritu Santo and arrived on the 27th. By the 30th all No.30 Squadron's aircraft had arrived and commenced...
Aircraft decals (military)
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

No Image
Ventura VA7292
RNZAF Consolidated PBY Catalinas No.6 Sqn. RNZAF Consolidated PBY-5 Catalinas, Pacific Theatre 1943 - 1945. Four options. NZ4011, No.6 FB Sqn. Lauthala Bay Fiji, 1943. NZ4015, F/Lt Ian Scott, No.6 FB Sqn. Halavo Bay, Solomon Islands, March 1944. NZ4021, F/Lt Ian Scott, No.6 FB Sqn. Halavo Bay, March 1944. NZ4012, "The Naughty Nine" F/Lt Guy Rogers, No.6 FB Sqn. Halavo Bay 1945. All are in the U.S. Navy c...
Aircraft decals (military)
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
Ventura VA7293
24 and 30 inch RAF and Commonwealth code letters, MEDIUM SEA GREY. WW II.
Aircraft decals (military)
Catalogue
£5.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

No Image
Ventura VA7294
36 inch RAF and Commonwealth code letters, MEDIUM SEA GREY. WW II.
Aircraft decals (military)
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

No Image
Ventura VA7291
RNZAF North-American P-51D Mustangs, Wellington Canterbury and Otago Squadrons and civilian 'Mobil' Mustang. Six options. P-51D Mustang ZK-CCG was ex RNZAF Mustang NZ2417. It was sponsored by Mobil Oil from late 1964 until 1968. Initially the aircraft's all white colour scheme included Mobil's "winged horse" based logo and later the more modern plain "Mobil" signage. NZ2423, No.2 (Wellington) Squadron, 1955. This aircraft...
Aircraft decals (military)
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

Ventura VA7290
8 inch serial numbers - Black for US built aircraft. This sheet includes seven styles of black 8 inch numbers including stencil and non-stencil styles as used on P-40, P-47 and North-American P-51 Mustangs etc.
Aircraft decals (military)
Catalogue
£3.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

Ventura VA7288
1:72
24 inch letters for RAF, RN, RAAF, RCAF and RNZAF etc. This sheet includes a variety of black 24 inch letters in "rounded" and "squared" styles, as used by British, Australian, Canadian, New Zealand and other air forces in World War II and later.
Aircraft decals (military)
Catalogue
£5.20
-
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

Ventura VA7289
1:72
24 inch numbers for RAF, RN, RAAF, RCAF and RNZAF etc This sheet includes a variety of black 24 inch numbers in "rounded" and "squared" styles, as used by British, Australian, Canadian, New Zealand and other allied air forces in World War II and later.
Aircraft decals (military)
Catalogue
£5.20
-
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

Ventura VA7287
1:72
RAF and Commonwealth 1919-1939 serials. 8" black and black with white outline. Between-the-wars period 1/72nd scale serials, black and black with white outline. Often an aircraft used black serials on the fuselage and similar ones with white outlines on the rudder. A variety of styles are included covering different manufacturers. Some of the white outline styles were 8" plus the outline while others were 8" including t...
Aircraft decals (military)
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

Ventura VA7285
1:72
RNZAF F4U-1D & FG-1D Corsairs, three options - F4U-1D NZ5485 "Kohimarama IX" - F4U-1D NZ5566, Fighter Leaders School - FG-1D Corsair NZ5617 with No.14 Squadron, RNZAF, Japan,
Aircraft decals (military)
Catalogue
£5.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

Ventura VA7286
1:72
Curtiss P-40Ns, RNZAF "Gloria Lyons" and American Volunteer Group, three options - NZ3220 "Gloria Lyons", late 1944. Both variations of "Gloria Lyons" artwork worn by NZ3220 are provided - P-40N "Boss's Hoss", flown by Lt. Colonel William N Reed of the Chinese-American Composite Wing, August 1944.
Aircraft decals (military)
Catalogue
£5.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

Ventura VA7209
1:72
Hawker Sea Fury T.20 VX280/85; Supermarine Seafire 15 PR479/L 803 Sqn RCN 1947; Supermarine Seafire Mk.XV PR502 13-2/N 801 Sqn H.M.S. Implacable Pacific 1945; Harvard Mk.II NZ941/99 2 SFTS New Zealand 1942
Aircraft decals (military)
Catalogue
£5.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

Ventura VA3279
1:32, 1:48, 1:72
RAF and RAAF 8' serial letters and numbers. WHITE in 1/32nd scale. Also used as as 12 inch in 1/48th and 18 inch in 1/72nd scale. Each package includes three 125mm x 200mm sheets.
Aircraft decals (military)
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

Ventura VA7207
1:72
Revised and Re-printed! Curtiss P-40 Kittyhawk, Supermarine Seafire Mk.XV, Hawker Sea Fury FB.11 (5) Curtiss P-40 NZ3136 OD-28 4 OTU NZ 1945; Supermarine Seafire Mk.XV PR434 AA-C 833 Sqn R Canadian Navy; Sea Furies RAN WH589 No 115 Australian Display Team overall Oxford blue; WH676 138/K; VX730 109/K. Both 805 Sqn HMAS Sydney Korea
Aircraft decals (military)
Catalogue
£5.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

Ventura VA7253
1:72
RAF and Australian 8 and 4 inch GREY serial numbers and letters. WWII to present (RAF codes/RAF code letters/RAF serial numbers)
Aircraft decals (military)
Catalogue
£5.20
-
In Stock
15

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

Ventura VA7275
1:72
RNZAF Lockheed PV-1 Venturas, Pacific Theatre, No.1 (BR) Squadron and No.11 Servicing Unit - three options NZ4509, based in New Zealand, late June 1943 (U.S. Navy Blue Gray and Light Gray scheme with RAF-style roundels), NZ4511 'Slippery Sam' based at, Henderson Field, November 1943 (U.S. Navy Mid-War `Three Tone Scheme') and NZ4624 of No.11 SU, 1944 (very faded (NZ) Blue Sea Grey and (NZ) Sky Grey scheme).
Aircraft decals (military)
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

Ventura VA7220
1:72
Supermarine Spitfire - RAAF and RNZAF (6) Mk.Vc Tropical version MA292 KW-D F/O Weggery 'Verna June II'; BS186 L Fl/Lt Edward Hall 452 Sqn; Mk.IXc MH454 FU-N F/O Boulton; EN522 FU-F or JR 'Shangri La' W/Co John Ratten C/O 453 Sqn; MA408 CG W/Co Colin Gray; From 'Supermarine Spitfire the Anzacs'
Aircraft decals (military)
Catalogue
£3.99
-
In Stock
3

   1   |   2      »      [2]

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