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=362639 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 34 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
DK Decals DKD32041
Duoermarine Spitfire & Messerschmitt Red Noses 1. Spitfire LF Mk.IXE, TE556, LH SNB Police Air Patrol Unit, Czechoslovak Police Air Force, Brno-Slatina, Czechoslovakia, 1948 2. Avia C-10.8, LH SNB Police Air Patrol Unit, Czechoslovak Police Air Force, Brno-Slatina, Czechoslovakia, 1947 3. Avia C-10, SVS Fighter Training Centre, PlanÆ'éi ("...'esk Bud?jovice), Czechoslovakia, 1947
Aircraft decals (military)
Catalogue
£18.50
£16.65
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
DK Decals DKD32035
1:32
Hawker Hurricane Mk.IIA/Mk.IIB of Czechoslovak pilots (Nos.1, 32, 310 & 312 Sq. RAF) 1. Huricane Mk.IIA, Z2770, P/O B. Kimli"éka, No.310 Sq. 2. Hurricane Mk.IIA, Z2579, Sgt. L. ...é rom, No.310 Sq. 3. Hurricane Mk.IIB, Z3660, S/L A. Va...éiÆ'éitko, No.312 Sq. 4. Hurricane Mk.IIB, AP518, F/O T. VybÆ'éral, No.312 Sq. 5. Hurricane Mk.IIA, Z2482, Sgt. B. KrÆ'éitkorukÆ'é½, No.1 Sq. 6. Hurricane Mk.IIA, Z2802, Sgt. J. ...
Aircraft decals (military)
Catalogue
£21.50
-
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
DK Decals DKD32031
1:32
Supermarine Spitfire LF Mk.IXE (S-89) in Post-War CzAF, No.310 Sq./1st Aviation Division 1. Supermarine Spitfire LF Mk.IXE, TE551, No.310 Sq., pilot ...éikpt. J. Hartmann, Ruzyn? airport, 1945 2. Supermarine Spitfire LF Mk.IXE, TE513, No.310 Sq., pilot rt. J. ChmeLk, Ruzyn? airport, 1945 3. Supermarine Spitfire LF Mk.IXE, SL628, No.310 Sq., pilot pplk. J. Hla"éo, Ruzyn? airport, 1945 4. Supermarine Spitfire LF Mk.IXE...
Aircraft decals (military)
Catalogue
£17.40
-
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
DK Decals DKD32032
Supermarine Spitfire LF Mk.IXE (S-89) in Post-War CzAF, No.312 Sq./2nd Aviation Division 1. Supermarine Spitfire LF Mk.IXE, TE527, No.312 Sq., pilot ...éikpt. H. HrbÆ'éi"éek, Ruzyn? airport, 1945 2. Supermarine Spitfire LF Mk.IXE, TE527, HQ Flt., pilot pplk. J. Hla"éo, LZ 2 PlanÆ'éi airfield,1945 3. Supermarine Spitfire LF Mk.IXE, TE566, No.312 Sq., pilot ...éikpt. J. Ma...Ë Æ'éik, Ruzyn? airport, 1945 4. Supermarine S...
Aircraft decals (military)
Catalogue
£17.40
-
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
DK Decals DKD32033
Supermarine Spitfire LF Mk.IXE (S-89) in Post-War CzAF, No.313 Sq./3nd Aviation Division 1. Supermarine Spitfire LF Mk.IXE, TE517, No.313 Sq., pilot kpt. O. Ku"éera, Ruzyn? airport,1945 2. Supermarine Spitfire LF Mk.IXE, TE557, No.313 Sq., pilot por. F. Vav...a"Æ'ének, Ruzyn? airport, 1945 3. Supermarine Spitfire LF Mk.IXE, SL652, HQ Flt., pilot plk. K. MrÆ'éizek, LZ 3 Brno-Slatina 1946 4. Supermarine Spitfire LF Mk.I...
Aircraft decals (military)
Catalogue
£17.40
-
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
DK Decals DKD32034
1:32
Douglas A-20G in RAAF service 1. A-20G Havoc, A28-60, No.22 Sq. RAAF, New Guinea 1944 2. A-20G Havoc, A28-78, No.22 Sq. RAAF, New Guinea 1944
Aircraft decals (military)
Catalogue
£15.30
-
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
DK Decals DKD32036
Westland Lysander Mk.III No.161(SD) Sq. RAF 1. Lysander Mk.III, V9673, S/L H. Verity 2. Lysander Mk.III, V9822, P/O J.A.McCairns 3. Lysander Mk.III, T1446, F/O 'Luck' Newhouse 4. Lysander Mk.III, R9125
Aircraft decals (military)
Catalogue
£15.30
-
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
DK Decals DKD32037
Hawker Hurricane Mk.IIB in the Far East, Pt.1 1. Hawker Hurricane Mk.IIB, BE171, No.17 Sq. RAF, Sgt J.F. Barrick, Burma 1942 2. Hawker Hurricane Mk.IIB, BG827, No.30 Sq. RAF, P/O J. Whalen, Ceylon 1942 3. Hawker Hurricane Mk.IIB, AP894, No.135 Sq. RAF, F/L J. Storey, India 1943 4. Hawker Hurricane Mk.IIB, BM935, No.135 Sq. RAF, P/O B. Sykes, Burma 1942 5. Hawker Hurricane Mk.IIB, BM913, No.136 Sq. RAF, F/L E. Brown, India...
Aircraft decals (military)
Catalogue
£19.40
-
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
DK Decals DKD32038
Hurricane Mk.IIB in the Far East, Pt.2 1. Hurricane Mk.IIB, Z5659, No.135 Sq. RAF, P/O Storey, Burma 1942 2. Hurricane Mk.IIB, BE208, No.232 Sq. RAF, S/L R. Brooker, Singapore 1942 3. Hurricane Mk.IIB, BM936, No.136 Sq. RAF, P/O I. Adamson, Burma 1943 4. Hurricane Mk.IIB, BG827, No.274 Sq. RAF, Ceylon 1943 5. Hurricane Mk.IIB, BG882, No.261 Sq. RAF, S/L R. Cleaver, Ceylon 1942 6. Hurricane Mk.IIB, BE198, No.136 Sq. RAF, ...
Aircraft decals (military)
Catalogue
£21.40
-
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
DK Decals DKD32039
Sea Hurricane Mk.IA/IIB/XII/IIC 1. Sea Hurricane Mk.IA, BW864, No.118(F) Sq. RCAF, Canada 1942 2. Sea Hurricane Mk.IA, V7421, No.760 NAS, 1942 3. Sea Hurricane Mk.IIB, BD771, No.880 NAS, HMS Indomitable, 1942 4. Sea Hurricane Mk.XII JS327, No.800 NAS, HMS Bitter, 1942 5. Sea Hurricane Mk.IIC, JS310, No. 825 NAS, 1944 6. Sea Hurricane Mk.IIC, JS 353, No. 804 NAS, 1943
Aircraft decals (military)
Catalogue
£22.40
-
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
DK Decals DKD32040
Hawker Hurricane Mk.IIB (Recce) in the Far East 1. Hawker Hurricane Mk.IIB, BM969, No.3 PRU, F/O D. Pearson, India 1942 2. Hawker Hurricane Mk.IIB, BH125, No.3 PRU/No.681 Sgn RAF, India 1942 3. Hawker Hurricane Mk.IIB, BM952, No.3 PRU/No.20 Sq. RAF, India 1942
Aircraft decals (military)
Catalogue
£13.30
-
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
DK Decals DKD32020
North-American Mitchell Mk.III in RAF service 1. Mitchell Mk.III, HD392, No.320 (Dutch) Sq. RAF 2. Mitchell Mk.III, KJ684, No.180 Sq. RAF
Aircraft decals (military)
Catalogue
£15.80
-
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

No Image
DK Decals DKD32022
North-American P-51D/K Mustang over the Pacific and Australia 1. P-51D Mustang, 44-63272, Lt. L.E. Curdes, 4th FS, 3rd ACG, the Philippines 1945 2. P-51D Mustang, 44-64038, Lt. T. Sheets, 460th FS, 348th FG, Ie Shima 1945 3. P-51D Mustang, 44-64124, Capt. L.V. Grosshuesch, 39th FS, 35th FG, Okinawa 1945 4. P-51D Mustang, 44-72602, Capt. G. Marcott, 458th FS, 506th FG, Iwo Jima 1945 5. P-51D Mustang, 44-72505, Maj. W. ...
Aircraft decals (military)
Catalogue
£20.25
-
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

No Image
DK Decals DKD32023
Curtiss P-40E Warhawk/Kittyhawk Mk.I P.II 1. P-40E Warhawk, ET812, Capt. J.J. Kruzel, 9th FS, 49th FG, Australia 1942 2. P-40E Warhawk, ET799, Capt. Lt. C. Tice, 9th FS, 49th FG, Australia 1942 3. P-40E Kittyhawk, A29-142, F/L K.W. Truscott, No.76 Sq. RAAF, New Guinea 1942 4. Kittyhawk Mk.I, AK606, Sgt. I.A. Nursey, No.450 Sq. RAAF, Egypt 1942 5. Kittyhawk Mk.I, AK578, F/O N. Duke, No.112 Sq. RAF, Egypt 1942 6. Kittyhawk...
Aircraft decals (military)
Catalogue
£20.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
DK Decals DKD32028
Consolidated B-24D Liberator 90th BG "The Jolly Rogers" 1. B-24D Liberator, 41-24047, Maj P. Gottke, 320th BS, 90th BG, New Guinea 1943 2. B-24D Liberator, 41-24073, Capt Halverson, 319th BS, 90th BG, New Guinea 1943 3. B-24D Liberator, 41-23836, Capt E.A. Wood, 321th BS, 90th BG, New Guinea 1943 4. B-24D Liberator, 41-24074, Lt. J.R. Wilson, 319th BS, 90th BG, New Guinea 1943 5. B-24D Liberator, 41-23828, Lt H.L. Chovane...
Aircraft decals (military)
Catalogue
£21.25
-
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
DK Decals DKD32029
1:32
Boeing Fortress Mk.II/III of No.100 Group RAF 1. Fortress Mk.II, SR376, No.214 Sq. RAF, No.100 Group, 1944 2. Fortress Mk.II, SR386, No.214 Sq. RAF, No.100 Group, 1944 3. Fortress Mk.III, KJ121, No.223 Sq. RAF, No.100 Group, 1944 4. Fortress Mk.III, KJ117, No.214 Sq. RAF, No.100 Group, 1944
Aircraft decals (military)
Catalogue
£18.40
-
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
DK Decals DKD32030
North-American P-51D/K Mustang 23rd FG China 1944/1945 1. P-51D Mustang, 44-11283, 74th FS, Capt. J.C. Conn, Tushan, June 1945 2. P-51K Mustang, 44-11779, 75th FS, Maj. C.B. Slocumb, Luliang, August 1945 3. P-51D Mustang, 76th FS, Lt.Col. L.V. Teeter 4. P-51D Mustang, 44-11276, 23rd FG HQ, Lt.Col. Ch. Older, Luliang, spring 1945 5. P-51D Mustang, 44-11280, 118th TRS, Lt.Col. E.O. McComas, Luliang, 1945
Aircraft decals (military)
Catalogue
£18.60
-
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
DK Decals DKD32024
Curtiss P-40N Warhawk in RAAF service 1. P-40N Kittyhawk, A29-1138, S/L J. Waddy, No.80 Sq. RAAF, 1945 2. P-40N Kittyhawk, A29-806, No.77 Sq. RAAF, 1944 3. P-40N Kittyhawk, A29-1062, No.75 Sq. RAAF, 1945 4. P-40N Kittyhawk, A29-521, No.75 Sq. RAAF, 1944 5. P-40N Kittyhawk, A29-1140, No.76 Sq. RAAF, 1945 6. P-40N Kittyhawk, A29-558, No.78 Sq. RAAF, 1944 7. P-40N Kittyhawk, A29-512, F/L J.C. Griffith, No.78 Sq. RAA...
Aircraft decals (military)
Catalogue
£18.40
-
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
DK Decals DKD32025
Supermarine Spitfire Mk.I/II Aces 1. Spitfire Mk.IIA, P8084, No.64 Sq. RAF, F/Lt J.J. Oé'Meara 2. Spitfire Mk.IA, N3180, No.54 Sq. RAF, P/O A.C. Deere 3. Spitfire Mk.IIA, P7966, Tangmere Wing, W/Cdr D.R.S. Bader 4. Spitfire Mk.IA, X4382, No.602 Sq. RAF, P/O O.V. Hanbury 5. Spitfire Mk.IA, N3192, No.92 Sq. RAF, F/L R.R.S. Tuck 6. Spitfire Mk.IA, K9953, No.74 Sq. RAF, F/L A.G. Sailor Malan 7. Spitfire Mk.IA, X4338...
Aircraft decals (military)
Catalogue
£18.40
-
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
DK Decals DKD32026
Supermarine Spitfire Mk.V Aces 1. Spitfire Mk.VB, W3312, No.92 Sq. RAF, S/L J. Rankin 2. Spitfire Mk.VB, W3774, No.485 Sq. (RNZAF), Sgt W.V. Crawford-Compton 3. Spitfire Mk.VB, W3320, No.92 Sq. RAF, P/O D.E. Kingaby 4. Spitfire Mk.VB, W3257, No.611 Sq. RAF, F/L E.S. Lock 5. Spitfire Mk.VB, BL734, No.64 Sq. RAF, F/L J. Plagis 6. Spitfire Mk.VB, AB842, No.452 Sq. (RAAF), F/L K. Truscott 7. Spitfire Mk.VB, EP120, N...
Aircraft decals (military)
Catalogue
£19.40
-
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
DK Decals DKD32027
Supermarine Spitfire Mk.V - RAAF Squadrons 1. Spitfire Mk.VB, AB972, No.452 Sq. RAAF, F/L B.E.F. Finucane, U.K. 1941 2. Spitfire Mk.VB, EN824, No.453 Sq. RAAF, F/L J.W. Yarra, U.K. 1942 3. Spitfire Mk.VB, BL384, No.457 Sq. RAAF, F/L J. Gibson, U.K. 1942 4. Spitfire Mk.VC, JL394, No.1 Wing RAAF, W/C C. Caldwell, Australia 1943 5. Spitfire Mk.VC, A58-236, No.452 Sq. RAAF, P/O Beaton, Australia 1943 6. Spitfire Mk.VC...
Aircraft decals (military)
Catalogue
£18.40
-
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
DK Decals DKD32016
Supermarine Spitfire Mk.IX 2nd TAF 1944 1. Spitfire Mk.IXC, ML422, No.126 Wing, September 1944, pilot W/Cdr B.D. Russel 2. Spitfire Mk.IXC, ML365, No.135 Wing, November 1944, pilot G/Cpt P.R. Walker 3. Spitfire Mk.IXC, MJ671, No.641 Sq., July 1944, pilot Cpt M. Boudier 4. Spitfire Mk.IXC, PL288, No.350 Sq., July 1944, pilot S/L M.L. Donnet 5. Spitfire Mk.IXE, NH583, No.127 Sq., 1944, pilot S/L C.F. Bradley 6. Spitfire LF...
Aircraft decals (military)
Catalogue
£18.40
-
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
DK Decals DKD32019
North-American B-25J Mitchell in RAAF service 1. B-25J Mitchell, A47-27, No.2 Sq. RAAF, Australia 1944 2. B-25J Mitchell, A47-29, No.2 Sq. RAAF, Australia 1944
Aircraft decals (military)
Catalogue
£15.80
-
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
DK Decals DKD32021
Curtiss Kittyhawk Mk.IV - RAF, RAAF and SAAF squadrons over Italy 1944-45 1. Kittyhawk Mk.IV, FX760, No.112 Sq. RAF, Italy 1944 2. Kittyhawk Mk.IV, FX609, No.3 Sq. RAAF, pilot S/L M. Nash, Italy 1944 3. Kittyhawk Mk.IV, FX667, No.3 Sq. RAAF, pilot F/L K. Richards, Italy 1944 4. Kittyhawk Mk.IV, FX835, No.450 Sq. RAAF, pilot G.H. Brian, Italy 1944 5. Kittyhawk Mk.IV, FX835, No.450 Sq. RAAF, pilot G.H. Brian, Italy 1945 6....
Aircraft decals (military)
Catalogue
£17.50
-
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
DK Decals DKD32012
1:32
Bell Airacobra Mk.I of No.601 Sq. 1. Airacobra Mk.I, AH576, No.601 Sq., Sgt F. Mare...éi, Duxford airfield, autumn 1941 2. Airacobra Mk.I, AH583, No.601 Sq., F/Lt J. Himr, Manston airfield, autumn 1941 3. Airacobra Mk.I, AH595, No.601 Sq., F/O J. Ma...Ë ak, Manston airfield, autumn 1941 4. Airacobra Mk.I, AH589, No.601 Sq., Sgt J. Kohout, Acaster Malbis airfield, autumn 1941 5. Airacobra Mk.I, AH602, No.601 Sq., F/Lt J. Hi...
Aircraft decals (military)
Catalogue
£15.80
-
In Stock
4

   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