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 = 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 73 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 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. SmoLƒk, 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

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 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. StehLƒk 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

DK Decals DKD72072
Re-print! AVG/23rd FG (Curtiss Hawk 81A and P-40 Warhawk era 1941-44) 1. Hawk 81A P8115, Rangoon, September 1941 2. Hawk 81A P8173, 3rd PS AVG, R.T. Smith, Kunming, January 1942 3. Hawk 81A P8102, 1st PS AVG, J.D. Cross, Rangoon, January 1942 4. Hawk 81A P8133, 3rd PS AVG, T. Haywood, Kunming, June 1942 5. Hawk 81A P8146, 74th FS, Kunming, July 1942 6. Hawk 81A P8146, 74th FS, Kunming, Autumn 1942 7. P-40E Warhawk, ...
Aircraft decals (military)
Catalogue
£20.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 DKD72108
No.77 Sq. RAAF (P-40E/K/N, P-51, Meteor Mk.8, C-47B) 1. P-40E, A29-113, S/L R. Creswell, Darwin 1942 2. P-40K, A29-166, S/L R. Creswell, New Guinea 1943 3. P-40K, A29-164, F/O A. Wallace, New Guinea 1943 4. P-40K, A29-184, F/O J.A. Hodgkinson, New Guinea 1943 5. P-40N, A29-819, P/O D.H.Helsham, Labuan 1945 6. P-40N, A29-920, W/O A.D. Monsbourgh, Labuan 1945 7. P-51D, A68-700, F/O M. McKay, Labuan 1945 8. P-51D, A68-74...
Aircraft decals (military)
Catalogue
£22.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 DKD72109
RAAF Meteor Mk.8s RAAF Meteor Mk.8s 1. Meteor F.8, A77-17, W/O A.R. Turner, Korea 1953 2. Meteor F.8, A77-207, Sgt G. Collins, Korea 1953 3. Meteor F.8, A77-316, Sgt J.C. Kitchenside RAF, Korea 1952 4. Meteor F.8, A77-853, F/L J.B. Ball RAF, Korea 1953 5. Meteor F.8, A77-865, Korea 1953 6. Meteor F.8, A77-157, F/L M. Whitworth-Jones RAF, Korea 1953 7. Meteor F.8, A77-415, D.A. Arnott RAF, Korea 1952 8. Meteor F.8, A7...
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 DKD72118
Hawker Hurricane Mk.IIB in the Far East, Pt.1 1. Hurricane Mk.IIB, AP894, No.135 Sq. RAF, F/L J. Storey, India 1943 2. Hurricane Mk.IIB, BE171, No.17 Sq. RAF, Sgt J.F. Barrick, Burma 1942 3. Hurricane Mk.IIB, BG827, No.30 Sq. RAF, P/O J. Whalen, Ceylon 1942 4. Hurricane Mk.IIB, BM935, No.135 Sq. RAF, P/O B. Sykes, Burma 1942 5. Hurricane Mk.IIB, BM913, No.136 Sq. RAF, F/L E. Brown, India 1943 6. Hurricane Mk.IIB, BE198...
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 DKD72119
1:72
Hawker Hurricane Mk.IIB in the Far East, Pt.2 1. Hurricane Mk.IIB, BM936, No.136 Sq. RAF, P/O I. Adamson, Burma 1943 2. Hurricane Mk.IIB, Z5659, No.135 Sq. RAF, P/O Storey, Burma 1942 3. Hurricane Mk.IIB, BE208, No.232 Sq. RAF, S/L R. Brooker, Singapore 1942 4. Hurricane Mk.IIB, BG882, No.261 Sq. RAF, S/L R. Cleaver, Ceylon 1942 5. Hurricane Mk.IIB, BG827, No.274 Sq. RAF, Ceylon 1943 6. Hurricane Mk.IIB, BG859, No.136 Sq...
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 DKD72103
3rd Attack Group "The Grim Reapers" 1942 1. A-24, 41-12752, 8 th BS, Australia 1942 2. A-24, 41-15749, 8 th BS, New Guinea 1942 3. A-24, 41-15819, 8th BS, New Guinea 1942 4. A-20A Havoc, 40-3151, 89th BS, New Guinea 1942 5. A-20A Havoc, 40-139, 89th BS, New Guinea 1942 6. A-20A Havoc, 40-3160, 89th BS, New Guinea 1942 7. B-25C Mitchell, 41-29731, 90th BS, Australia 1942 8. B-25C Mitchell, 41-12962, 13th BS, Austr...
Aircraft decals (military)
Catalogue
£19.60
-
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 DKD72104
North-American B-25C/D Mitchell 3rd AG "The Grim Reapers" 1. B-25C Mitchell, 41-12499 (ex-Dutch N5-149), 13th BS, Australia 1942 2. B-25C Mitchell, 41-12438, 13th BS, Australia 1942 3. B-25D Mitchell, 41-29737, 13th BS, Australia 1942 4. B-25C Mitchell, 41-12464 (ex-Dutch N5-125), 13th BS, Australia 1942 5. B-25C Mitchell, 41-12906, 13th BS, New Guinea 1943 6. B-25D Mitchell, 41-30766, 13th BS, New Guinea 1943 7. B...
Aircraft decals (military)
Catalogue
£19.60
-
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 DKD72110
Bell Airacobra Mk.I (P-39) in RAF and RAAF service 1. Airacobra Mk.I, AH577, No.601 Sq., F/Lt. J. Himr, Duxford, autumn 1941 2. Airacobra Mk.I, AH576, No.601 Sq., Sgt. F. Mares, Duxford, autumn 1941 3. Airacobra Mk.I, AH601, No.601 Sq., S/L E.J. Gracie, Duxford, autumn 1941 4. Airacobra Mk.I, AH583, No.601 Sq., F/Lt. J. Himr, Manston, autumn 1941 5. Airacobra Mk.I, AH589, No.601 Sq., Sgt. J. Kohout, Acaster Malbis, au...
Aircraft decals (military)
Catalogue
£19.60
-
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 DKD72111
Bell P-39/P-400 Airacobra over Solomons Islands 1. P-400 Airacobra, BW146 67th FS, 347th FG, Guadalcanal 1942 2. P-400 Airacobra, 67th FS, 347th FG, Guadalcanal 1942 3. P-400 Airacobra, BW156 67th FS, Guadalcanal 1942 4. P-400 Airacobra, 67th FS, 347th FG, Guadalcanal 1942 5. P-39K Airacobra, 42-4275 70th FS (originally 12th FS), Guadalcanal 1942/1943 6. P-39D Airacobra, 41-38379 68th FS (originally 67th FS), Guadal...
Aircraft decals (military)
Catalogue
£19.60
-
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 DKD72116
Bell P-39/P-400 Airacobra over Africa and Italy 1. P-400, Capt. J.R. Hillin, 91st FS, 81st FG, Tunisia 1943 2. P-39N Airacobra, 42-18306, Lt. I. Behel, 346th FS, 350th FG, Tunis 1943 3. P-39N Airacobra, 42-18363, Lt. G. Viczarra, 345th FS, 350th FG, Sardinia 1943 4. P-39N Airacobra, 42-18309 347th FS, 350th FG, Sardinia 1943 5. P-39N Airacobra, 42-18393, Lt. S.M. Allexander Jr., 346th FS, 350th FG, Sardinia 1944 6. P...
Aircraft decals (military)
Catalogue
£19.60
-
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 DKD72100
Early Strafers (Douglas A-20A, North-American B-25C/D Mitchell) 1. A-20A Havoc, 40-170, 89th BS, 3rd BG, New Guinea, 1942 2. A-20A Havoc, 40-162, 89th BS, 3rd BG, New Guinea, 1942 3. B-25C Mitchell, 41-12946, 90th BS, 3rd BG, Australia, 1942 4. B-25C Mitchell, 41-12437, 90th BS, 3rd BG, New Guinea, 1943 5. B-25C Mitchell, 41-12998, 8th BS, 3rd BG, New Guinea, 1943 6. B-25D Mitchell, 41-30118, 405th BS, 38th BG, New G...
Aircraft decals (military)
Catalogue
£19.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 DKD72101
North-American B-25C "Mortimer" as time went on... 1. B-25C 41-12443, Capt. T. Gerrity, 13th BS, 3rd BG, New Guinea, July 1942 2. B-25C 41-12443, 1/Lt. R.A. Price, 13th BS, 3rd BG, New Guinea, September 1942 3. B-25C 41-12443, 1/Lt. E.T. Solomon, 90th BS, 3rd BG, New Guinea, February 1943 4. B-25C 41-12443, 1/Lt. J.W. Pryor, 90th BS, 3rd BG, New Guinea, April 1943 5. B-25C 41-12443, 90th BS, 3rd BG, New Guinea, Octobe...
Aircraft decals (military)
Catalogue
£17.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 DKD72102
North-American B-25C Mitchell "Fat Cat" as time went on... 1. & 2. B-25C, 41-12449, Capt. W.R. Johnson, 90th BS, 3rd BG, New Guinea, autumn/winter 1942 3. B-25C, 41-12449, 90th BS, 3rd BG, New Guinea, after strafer modification, January 1943 4., 5. & 6. B-25C, 41-12449, 3rd BG, New Guinea, transport modification, autumn 1943 7. B-25D, 41-30772, 3rd BG, the Philippines,1944, another transport B-25 named "Fat Cat"
Aircraft decals (military)
Catalogue
£17.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 DKD72112
Bell P-39/P-400 Airacobra over New Guinea, Pt.1 1. P-400 Airacobra, Lt. R. Faurot, 39th FS, 35th FG, New Guinea, 1942 2. P-400 Airacobra, AH736, Lt. N.C. Ruff, 80th FS, 8th FG, New Guinea, 1942 3. P-400 Airacobra, 41st FS, 35th FG, New Guinea, 1943 4. P-39D, 41-38345, Lt. G. Welch, 36th FS, 8th FG, New Guinea, 1942 5. P-39D, 41-38373, Lt. J.W. Egan, 35th FG, 8th FG, New Guinea, 1942/1943 6. P-39K, 42-4358, Lt. W. McD...
Aircraft decals (military)
Catalogue
£19.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 DKD72113
Bell P-39/P-400 Airacobra over New Guinea, Pt.2 1. P-400 Airacobra, AP375, 41st FS, 35th FG, New Guinea, 1942 2. P-400 Airacobra, BW150, 41st FS, 35th FG, New Guinea, 1942 3. P-400 Airacobra, 80th FS, 8th FG, New Guinea, 1942 4. P-39D, 41-38369, Lt. McLelland, 35th FS, 8th FG, New Guinea, 1942/1943 5. P-39D, 41-38350, 35th FS, 8th FG, New Guinea, 1942/1943 6. P-39D, 41-38401, Maj. N.G. Morris, New Guinea, 1942/1943 ...
Aircraft decals (military)
Catalogue
£19.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 DKD72114
Bell P-39/P-400 Airacobra over New Guinea, Pt.3 1. P-400 Airacobra, AH736, 39th FS, 35th FG, New Guinea, 1942 2. P-400 Airacobra, Capt. E. Widman, 41st FS, 35th FG, New Guinea, 1942 3. P-400 Airacobra, Lt. C. King, 80th FS, 8th FG, New Guinea, 1942/1943 4. P-39K, 42-4349, Capt. T.H. Winburm, 40th FS, 35th FG, New Guinea, 1943 5. P-39F Airacobra, 39th FS, 35th FG, New Guinea, 1942 6. P-400 Airacobra, AP356, Lt. J. Ku...
Aircraft decals (military)
Catalogue
£19.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 DKD72115
Bell P-39 Airacobra over the central Pacific 1. P-39D Airacobra, 12th FS, Christmas Island 1942 2. P-39Q, 42-19474, Maj. C. Taylor, 72nd FS, 318th FG, Makin Atoll, 1943/1944 3. P-39Q, 42-20385, Maj. P. Crawley, 72nd FS, 318th FG, Gilbert Islands, 1944 4. P-39Q, 42-19499, Lt. F. Erbele, 72nd FS, 318th FG, Makin Atoll, 1943/1944 5. P-39Q, 42-19549, Maj. J.H. Powell, 72nd FS, 21th FG, the Mariana Islands, 1944 6. P-39Q, ...
Aircraft decals (military)
Catalogue
£19.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 DKD72045U
Re-printed! Supermarine Spitfire 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.IIB, P8518, Northolt Wing, W/Cdr J.A. Kent 4. Spitfire Mk.IB, R6882, No.92 Sq. RAF, Sgt D.E. Kingaby 5. Spitfire Mk.IB, R6923, No.92 Sq. RAF, F/O A. Wright 6. Spitfire Mk.IA, N3093, No.616 Sq. RAF, F/Lt D.E. Gillam 7. Spitfire Mk.IA, X4036, No.234 Sq. RAF, P...
Aircraft decals (military)
Catalogue
£14.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

DK Decals DKD72010U
Hawker Hurricane Mk.I/II in RAF (Czechoslovak) Squadrons 1. Hurricane Mk.I, L2099, Sgt Josef Frantiƒ...éiek, DFM, No. 303 Sq., September 1940 2. Hurricane Mk.I, P3975, Sgt Josef Frantiƒ...éiek, DFM, No. 303 Sq., September 1940 3. Hurricane Mk.I, R4175, Sgt Josef Frantiƒ...éiek, DFM, No. 303 Sq., October 1940 4. Hurricane Mk.I, P3889, P/O Emil Fechtner, No. 310 Sq., October 1940 5. Hurricane Mk.IIA, Z2768, F/O Frantiƒ...éiek...
Aircraft decals (military)
Catalogue
£17.40
-
In Stock
5+

   1   |   2   |   3      »      [3]

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