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=8274 AND ps.id = 953 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 40 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
1:32
Gloster Meteor F.3 Collection (6) Gloster Meteor F.3 EE239, 'YQ.Q' of 616 Squadron, 2 TAF, Royal Air Force based at Lubeck, Germany, 1946. Gloster Meteor F.3 EE278, 'ZD.A' of 222 Squadron, Royal Air Force based at RAF Tangmere, UK, 1947. Gloster Meteor F.3 EE337, 'FD/051' of 778 Naval Air Squadron, Royal Air Force based at RAF Tangmere, UK, 1947. Gloster Meteor F.3 EE416, which was the first trials aircraft to be used by M...
Aircraft decals (military)
Catalogue
£11.99
-
In Stock
50++

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
Douglas A-20G Havoc Collection (4) Douglas A-20G Havoc, 43-10213, 6Q/R, 'Skonk Works' of 410th Bomber Group, 9th Air Force, United States Air Force, 1944. Douglas A-20G Havoc, 43-22148, A28-78, DU.R, 'Topsy' of 22 Squadron, Royal Australian Air Force, based at Morotai, December, 1944. Douglas A-20G Havoc, 42-54258, 'White 3' of 27th Bomber Aviation Regiment, Soviet Air Force, based at Lvov, Ukraine area, Autumn, 1944. Doug...
Aircraft decals (military)
Catalogue
£10.99
-
In Stock
50++

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
Hawker Hurricane Mk.IIb (4) Hawker Hurricane Mk.IIb, Z3768, 'FK.49' of 81 Sqn, 151 Wing, RAF, South African Air Force based at Vaenga, Russia, September, 1941. Hawker Hurricane Mk.IIb, Z3658, 'YO.N' of 401 (Ram) Squadron, RCAF, based at RAF Digby, 24 July, 1941. Hawker Hurricane Mk.IIb, AP894, 'C' flown by Flight Lieutenant Jack Storey of 135 Squadron, Royal Air Force, based at 'George' and 'Hove' Landing Grounds, East Beng...
Aircraft decals (military)
Catalogue
£8.99
-
In Stock
50++

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

REPRINTED!! Messerschmitt Bf-109s with Stab markings Pt 2 (8) Bf-109E-4 III/JG 77 Greece 1941 Yellow nose/rudder; Bf-109E-4 I/JG 3 CO Hptm Hans Von Hahn Late 1940, St Omer France, Yellow nose/rudder; Bf-109F-2 I/JG 3 Tech Offizer Hptm Detlev Rohwer Ukraine 1941 Yellow nose/fuselage band, includes correction for spinner stripes; Bf-109F-2 II/JG 53 Gruppenkommandeur Hptm Heinz Bretnutz, St Omer 1941. Yellow nose/rudder; Bf-...
Aircraft decals (military)
Catalogue
£8.99
-
In Stock
50++

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

1:24
Luftwaffe/German Swastikas. Various styles including solid and outline. Sizes 300mm, 430mm, 540mm, 650mm, Also includes 1:24 Swastikas 300mm and 540mm
Aircraft decals (military)
Catalogue
£6.99
-
In Stock
50++

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

1:32
North-American P-51D Mustang Mk.IV (6) KH655 QV-P 19 Sqn RAF Peterhead; KM680 Y2-B 442 (RCAF) Sqn PO A.J.Mallandine 'Edmonton Special'RAF Hunsdon May; KH755 CV-W 3(RAAF) Sqn 'Anita' Italy; All OD/Dk Grey/Med Grey. KH765 HG-R 154 Sqn Alex Forsyth RAF Hunsdon; KM138 AK-Y 213 Sqn Italy; KM232 JAS Wg.Cdr J.A.Storrer Wing Ldr RAF Hunsdon. All Bare Metal 1945.
Aircraft decals (military)
Catalogue
£9.99
-
In Stock
50++

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

Re-printed!! Supermarine Spitfire Mk.Vb late (6) EP166 JU-N 111 Sqn S/Ldr P.R.W.Wickham 'O Bandeirante' 1942; W3843 YO-Q 401(RCAF) P/O Ibby Ibbotson RAF Redhill; AE-A 402(RCAF) Sqn S/L Godfrey Northcott RAF Merston 1943; BL370 SH-J 64 Sqn F/Lt Tony Cooper on D-Day RAF Harrowbeer. All Dk Green/Ocean Grey/Med Sea Grey. AB502 IR-G 246 Wing Wg.Cdr Ian Gleed Tunisia 1943 Dk Earth /Tan/Azure Blue; EP829 T-N 249 Sqn S/L Jos...
Aircraft decals (military)
Catalogue
£8.99
-
In Stock
50++

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

Re-printed!! Supermarine Spitfire Mk.I/Mk.IIa Pt 2 (4) Mk.Ia N3093 QJ-W 616 (Sth Yorkshire) Sqn 'The Virgin' Fl/Lt Denys Gilliam RAF Leconfield; Mk.IIa P8088 EB-J 1st Canadian 41 Sqn RAF Catterick 1941, both Dk Green/Dk Earth. P7856 VZ-E 412 Sqn Flt/Sgt Macdonnell RAF Digby 1941; P7308 XR-D 719Eagle) Sqn P/O Bill Dunn RAF North Weald 1941, both Dk Green/Grey. For the 2014 released kit from Revell Germany Kit
Aircraft decals (military)
Catalogue
£8.99
-
In Stock
50++

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

BAe Eurofighter Typhoon FGR.4 (2) ZK342/ED Wg.Cdr. Mike Baulkwill 6 Sqn 2014 Display Aircraft with desert camouflage on fin and spine RAF Lossiemouth; ZK343/BX Flt.Lt. Noel Rees 29 Sqn Display aircraft with black fin RAF Coningsby.
Aircraft decals (military)
Catalogue
£8.99
-
In Stock
20+

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

Hawker Hurricane Mk.IIc Pt 1 (3) BE643, AK-U P/O A.U.Houle 213 Sqn, Edku, Egypt, April, 1942. BD929, ZY-S 247 (China-British) Sqn,RAF Exeter,1942. possibly Z3574 OK-2 personal aircraft of Air Vice Marshal Keith R. Park, AOC Malta, RAF Luqa, Malta 1942.
Aircraft decals (military)
Catalogue
£8.99
-
In Stock
20+

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

Supermarine Spitfire Mk.IXc (4) Mk.IX.c MK805 SH-B 64 Sqn Flt.Lt Tony Cooper `Peter John 3' RAF Harrowbeer July 1944; MH737 FF-Y 132 Sqn Flt.Lt V.J.Sumpter RAF Detling 1943; MH552/R 73 Sqn RAF Brindisi 1945; IXe PV144/4D-A 74 Sqn Sqn.Ldr J.C.F.Hayter Belgium 1944.
Aircraft decals (military)
Catalogue
£8.99
-
In Stock
20+

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

Re-printed!! Eurofighter Typhoon FGR.4 29(F) Squadron 2015 Anniversary/Display (2) ZK349 GN-A 29(F) Squadron Flt Lt B. Westoby Brooks B of B 75th Anniversary. ZK353/BQ 29(F) Squadron 100th Anniversary Flt Lt Jonny Dowen
Aircraft decals (military)
Catalogue
£11.99
-
In Stock
20+

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

1:32
de Havilland Mosquito FB.Mk.VI (4) RF838 EO-A 404 Sqn Dk.Green/Med.Sea Grey; RS623 VV-A 235 Sqn Ex.Dk.Sea Grey/Sky Both Banff Wing 1945; HR399 OB-R 45 Sqn Joari, India 1945 Dk.Green/Dk.Earth/Azure Blue; RF751/B 211 Sqn St,Thomas Mount,India 1945 Overall Silver. For the NEW Tamiya Mosquito FB.Mk.VI
Aircraft decals (military)
Catalogue
£7.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
Gloster Gladiator (4 options) Gloster Gladiator Mk.I 'GK.Z' of 80 Squadron, Royal Air Force, based at Sidi Barrani, Egypt, August 1940. Gloster Sea Gladiator Mk.I N5520,'S' of Hal Far Fighter Flight, based at Hal Far, Malta, June, 1940. Gloster Gladiator Mk.I K7974,'RT.O' flown by Pilot Officer Percy Oliver Valentine Green of 112 Squadron, Royal Air Force based at Summit, Sudan, June, 1940. Gloster Gladiator Mk.II L9033, ...
Aircraft decals (military)
Catalogue
£7.99
-
In Stock
50++

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
RAF Panavia Tornado GR.4 (3) Panavia Tornado GR.4,ZD716, 'DH' crewed by Flt. Lt. N. Shawyer and Wg. Cdr. M. J. Bressani of 31 Squadron, Royal Air Force, RAF Marham, March, 2019. Panavia Tornado GR.4, ZG752, crewed by Sqn. Ldr. I. Dornan and Sqn. Ldr. S. Beardmore of IX(B) & 31 Squadron, Royal Air Force, RAF Marham, March, 2019. Panavia Tornado GR.4, ZG750, of XV(R) Squadron, Royal Air Force, RAF Lossiemouth, 2016.
Aircraft decals (military)
Catalogue
£9.99
-
In Stock
50++

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

Supermarine Spitfire Mk.I/Mk.IIa Pt 1 (3) Mk.Ia N3290 GR-U 92 Sqn RAF Hornchurch 1940; Mk.IIa P8088 NK-K 118 Sqn 'The Borough of Lambeth/Bette' P/O A.S.C.Lumsden RAF Ibsley 1941, both Dk Green/Dk Earth; TO-S 61 Operational Training Unit Pierre Closterman RAF Rednal 1942, Dk Green/Ocean Grey. For the 2014 released kit from Revell Germany Kit
Aircraft decals (military)
Catalogue
£7.99
-
In Stock
20+

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

1:32
RAF Code Letters and Numbers 30' Sky Double sheet
Aircraft decals (military)
Catalogue
£7.99
-
In Stock
20+

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

Supermarine Spitfire Mk.IXe/Mk.XVIe (3) RK855 FT-C 43 Sqn Zeltweg Austria Sept 1945; TB890 ZF-M 308(Polish) Sqn Germany 1945, Both with clipped wing tips; PV303 ON-B 124 Sqn RAF Hutton Cranwick 20 June 1945, all with pointed rudders
Aircraft decals (military)
Catalogue
£7.99
-
In Stock
50++

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

RAF Serial Letters, Numbers and Royal Navy 8' and 4' White
Aircraft decals (military)
Catalogue
£4.99
-
In Stock
13

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

Messerschmitt Me-262B-1a (5) W.Nr 111643 B3+ZM 4/KG(J)54 Found at Vlatov Czechoslovakia; WNr 111639 possibly NAGr6 now at NSA Willow Grove USA; WWNr 110635 Red 10 IV/NGJ11 Schleswig in Luftwaffe or RAF Markings; WNr 110306 Red 9 IV/NGJ11 in USAF markings;
Aircraft decals (military)
Catalogue
£7.99
-
In Stock
31

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

1:32
BAe Hawk T.1A All Camouflage (Barley) Grey/m/s/grey Camouflage (16) XX318 234 Sqn 1 TWU Brawdy 75th Anniversary Dragon on black fin 1992; XX193/193 234 Sqn, I TWU Brawdy 1989; XX219/219 or XX289/289 19 Sqn 7 FTS Chivenor 1992 with light blue fin; XX289/289 63 Sqn 2 TWU/7 FTS Chivenor 1991-2 with Arm and Axe on yellow disc on black fin, 2 designs; XX289/289 63 Sqn 2 TWU/7 FTS Chivenor 1991-2 with Arm and Axe on black fi...
Aircraft decals (military)
Catalogue
£7.99
-
In Stock
50++

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

1:32
RAF Code Letters and Numbers 30' m/s/grey Double sheet
Aircraft decals (military)
Catalogue
£7.99
-
In Stock
50++

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

RAF Code Letters and Numbers 24' m/s/grey Double sheet
Aircraft decals (military)
Catalogue
£5.99
-
In Stock
50++

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

1:32
Supermarine Spitfire Mk.Vb early (5) BM124 LO-W 602 Sqn 'Queen Salote' S/L B.E.F.Finucane RAF Kenley; BL351 BP-H 457(RAAF) Sqn S/L Johnny Gibson RAF Jurby; AA926 YO-E 401 (RCAF)Sqn 'Jersey'/ Marguerite, P/O I.C.Ormanston RAF Biggin Hill All Dk Green/Ocean Grey/Med Sea Grey; W3380 RN-J 72 Sqn 'Basuto' S/L D.F.B.Sheen DFC RAF Acklington Dk Green/Dk Earth/Sky; AB262 GN-B 249 Sqn Malta 1942 F/O Robert McNair Dk Earth/Tan/Med Blue;
Aircraft decals (military)
Catalogue
£7.99
-
In Stock
45

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

1:32
RAF Serial Black Letters and Numbers and Royal Navy and Army. 8' and 4'
Aircraft decals (military)
Catalogue
£4.99
Out of Stock
0