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 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 156 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 113
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 DKD48063
Hawker Sea Hurricane 1. Sea Hurricane Mk.IA, BW866, Dartmouth Maintenance Pool, RCAF, 1942 2. Sea Hurricane Mk.IA, V6803, P/O A. Lumsden, CAM ship Daghestan, 1942 3. Sea Hurricane Mk.IB, P2731, No.804 NAS, HMS Eagle, 1941 4. Sea Hurricane Mk.IB, Z4550, No.880 NAS, HMS Indomitable 1942 5. Sea Hurricane Mk.IIB, BD771, No.880 NAS, HMS Indomitable, 1942 6. Sea Hurricane Mk.XII JS327, No.800 NAS, HMS Bitter, 1942 7. Se...
Aircraft decals (military)
Catalogue
£20.50
£18.45
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 DKD72124
Hawker Hurricanes of Czechoslovak pilots (Nos.1, 17, 32, 310 & 312 Sq.) 1. Hurricane Mk.I, P2715, Sgt. J. ...Ël"ehka, No.310 Sq. RAF 2. Hurricane Mk.IIA, Z2505, F/O E. Foit, No.310 Sq. RAF 3. Hurricane Mk.IIA, Z2836, F/Sgt. V. SmoLk, No.312 Sq. RAF 4. Hurricane Mk.I, P3773, P/O V. JÆ'écha, No.17 Sq. RAF 5. Hurricane Mk.IIC, BE150, P/O K. Kuttelwascher, No.1 Sq. RAF 6. Hurricane Mk.IIC, BD946, P/O O. Pavl...é, No.1 ...
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 DKD72125
Hawker Sea Hurricane 1. Sea Hurricane Mk.IA, BW866, Dartmouth Maintenance Pool, RCAF, 1942 2. Sea Hurricane Mk.IA, V6803, P/O A. Lumsden, CAM ship Daghestan, 1942 3. Sea Hurricane Mk.IB, P2731, No.804 NAS, HMS Eagle, 1941 4. Sea Hurricane Mk.IB, Z4550, No.880 NAS, HMS Indomitable 1942 5. Sea Hurricane Mk.IIB, BD771, No.880 NAS, HMS Indomitable, 1942 6. Sea Hurricane Mk.XII JS327, No.800 NAS, HMS Bitter, 1942 7. Se...
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 DKD48059
No.312 Sq. RAF - Hawker Hurricanes of Czechoslovak pilots 1. Hurricane Mk.I, L1807 Sgt. J. StehLk, September 1940 2. Hurricane Mk.I, P3268 P/O J. La...éika, October 1940 3. Hurricane Mk.I, V6885 F/O J. Barto...éi, winter 1941 4. Hurricane Mk.I, P3612 Sgt. F. Kru...éa, winter 1941 5. Hurricane Mk.I, P3209 Sgt. F. Kru...éa, spring 1941 6. Hurricane Mk.I, V6678 F/O A. VrÆ'éina, winter 1941 7. Hurricane Mk.IIB, Z3437...
Aircraft decals (military)
Catalogue
£20.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 DKD48060
Hawker Hurricane of Czechoslovak pilots (Nos.1, 17 & 32 Sq. RAF) 1. Hurricane Mk.I, V6997, Sgt. J. DygrÆ'é½n, No.1 Sq. 2. Hurricane Mk.IIA, Z2482, Sgt. B. KrÆ'éitkorukÆ'é½, No.1 Sq. 3. Hurricane Mk.IIC, Z3899, Sgt. J. NovÆ'éik, No.1 Sq. 4. Hurricane Mk.IIC, BE581, P/O K. Kuttelwascher, No.1 Sq. 5. Hurricane Mk.IIC, BE581, P/O K. Kuttelwascher, No.1 Sq. 6. Hurricane Mk.I, P3773, P/O V. JÆ'écha, No.17 Sq. 7. Hurrican...
Aircraft decals (military)
Catalogue
£20.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 DKD48061
Hawker Hurricane Mk.IIB in the Far East, Pt.1 1. Hurricane Mk.IIB, AP894, No.135 Sq., F/L J. Storey, India 1943 2. Hurricane Mk.IIB, BE171, No.17 Sq., Sgt J.F. Barrick, Burma 1942 3. Hurricane Mk.IIB, BG827, No.30 Sq., P/O J. Whalen, Ceylon 1942 4. Hurricane Mk.IIB, BM935, No.135 Sq., P/O B. Sykes, Burma 1942 5. Hurricane Mk.IIB, BM913, No.136 Sq., F/L E. Brown, India 1943 6. Hurricane Mk.IIB, BE198, No.136 Sq., P...
Aircraft decals (military)
Catalogue
£20.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 DKD48062
Hawker Hurricane Mk.IIB in the Far East, Pt.2 1. Hurricane Mk.IIB, BM936, No.136 Sq., P/O I. Adamson, Burma 1943 2. Hurricane Mk.IIB, Z5659, No.135 Sq., P/O Storey, Burma 1942 3. Hurricane Mk.IIB, BE208, No.232 Sq., S/L R. Brooker, Singapore 1942 4. Hurricane Mk.IIB, BG882, No.261 Sq., S/L R. Cleaver, Ceylon 1942 5. Hurricane Mk.IIB, BG827, No.274 Sq., Ceylon 1943 6. Hurricane Mk.IIB, BG859, No.136 Sq., India 1942...
Aircraft decals (military)
Catalogue
£20.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 DKD48P04
Richard Cresswell and his aircraft 1. Curtiss P-40E Kittyhawk, A29-113, No.77 Sq. RAAF, Darwin 1942 2. Curtiss P-40K Kittyhawk, A29-166, No.77 Sq. RAAF, New Guinea 1943 3. North-American P-51D-25 Mustang, A68-803, No.77 Sq. RAAF, Korea 1950
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

DK Decals DKD72012
1:72
Re-printed! de Havilland 98 Mosquito of Australian pilots in RAAF and RAF (15 camouflage schemes) 1. Mosquito FB.VI, A52-533, No.1 Sq. RAAF, Borneo, 1945 2. Mosquito FB.VI, A52-513, No.1 Sq. RAAF, Borneo, 1945 3. Mosquito FB.VI, A52-531, No.1 Sq. RAAF, Borneo, 1945 4. Mosquito FB.VI, A52-505, No.1 Sq. RAAF, the Philippines, 1945 5. Mosquito FB.40, A52-50, No.5 O.T.U., RAAF, Australia, 1944 6. Mosquito PR.40, A52-6, ...
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 DKD144003
Hawker Hurricanes of Czechoslovak pilots (Nos.1, 17, 32, 310 & 312 Sq. RAF) 1. Hurricane Mk.I, P3143, No.310 Sq., F/L G.L. Sinclair/Sgt. B. F¼rst, September 1940 2. Hurricane Mk.I, V6579, No.310 Sq., S/L G.D.M. Blackwood, winter 1940/1941 3. Hurricane Mk.IIA, Z2579, No.310 Sq., Sgt. L. ...é rom, autumn 1941 4. Hurricane Mk.I, V6678, No.312 Sq., F/O A. VrÆ'éina, winter 1941 5. Hurricane Mk.IIB, Z3660, No.312 Sq., S/L...
Aircraft decals (military)
Catalogue
£11.70
-
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 DKD24003
1:24
Hawker Hurricane Mk.I 1. Hurricane Mk.I, V6579, S/L G.D.M. Blackwood No.310 Sq., winter 1940/1941 2. Hurricane Mk.I, P3143, F/L G.L. Sinclair, Sgt. B. F¼rst No.310 Sq., September 1940 3. Hurricane Mk.I, V6678, F/O A. VrÆ'éina No.312 Sq., winter 1941 4. Hurricane Mk.I, P3395, P/O A.V. Cloves, P/O E. "...'Æ'é...é¾ek, P/O F. B?hal, P/O A. VelebnovskÆ'é½, Sgt. J. DygrÆ'é½n, Sgt. A. Zavoral, No.1 Sq., summer 1940
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 DKD24004
1:24
Hawker Hurricane Mk.IIC Night Intruder 1. Hurricane Mk.IIC, BE581, P/O K. Kuttelwascher No.1 Sq., 1942 2. Hurricane Mk.IIC, BD936, Sous Lt. C. Helies No.247 Sq., 1942
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

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

DK Decals DKD48005
1:48
Re-printed! de Havilland 98 Mosquito of Australian pilots in RAAF and RAF (8 camouflage schemes) 1/ Mosquito F.B. Mk.VI A52-533, No.1 Sq. RAAF, Borneo 1945 2/ Mosquito F.B. Mk.VI A52-513, No.1 Sq. RAAF, Borneo 1945 3/ Mosquito F.B. Mk.VI A52-531, No.1 Sq. RAAF, Borneo 1945 4/ Mosquito P.R. Mk. 40 A52-6, No.87 Sq. RAAF, Coomalee Creek 1944 5/ Mosquito PR Mk.XVI A52-619, No.87 Sq. RAAF, Australia 1945 6/ Mosquito F.B. Mk.V...
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 DKD72121
1:72
No.310 Sq. RAF - Hawker Hurricanes of Czechoslovak pilots 1. Hurricane Mk.I, P3143, F/L G.L. Sinclair/Sgt. B. F¼rst, September 1940 2. Hurricane Mk.I, R4089, F/L J. Jefferies, September 1940 3. Hurricane Mk.I, V6556, Sgt. E. Prchal, November 1940 4. Hurricane Mk.I, V6579, S/L G.D.M. Blackwood, winter 1940/1941 5. Hurricane Mk.I, P3889, P/O E. Fechtner, October 1940 6. Hurricane Mk.IIA, Z2493, F/O V. Bergman, spri...
Aircraft decals (military)
Catalogue
£18.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 DKD72122
No.312 Sq. RAF - Hawker Hurricanes of Czechoslovak pilots 1. Hurricane Mk.I, L1740, P/O A. Hlobil, September 1940 2. Hurricane Mk.I, P3268, P/O J. La...éika, October 1940 3. Hurricane Mk.I, V6885, F/O J. Barto...éi, winter 1941 4. Hurricane Mk.I, P3612, Sgt. F. Kru...éa, winter 1941 5. Hurricane Mk.I, P3209, Sgt. F. Kru...éa, spring 1941 6. Hurricane Mk.I, V6678, F/O A. VrÆ'éina, winter 1941 7. Hurricane Mk.IIB, Z...
Aircraft decals (military)
Catalogue
£18.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 DKD72123
1:72
First shot of No.312 Sq. RAF 1. Hurricane Mk.I, P2575, F/Lt. D.E. Gillam 2. Hurricane Mk.I, L1807, Sgt. J. StehLk 3. Hurricane Mk.I, L1926, P/O A. Va...éiÆ'éitko 4. Ju 88A-1, W.Nr.4068, 2./KGr. 806, Caen-Carpiquet
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 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+

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

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