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 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 487 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

Xtradecal X48193
1:48
Messerschmitt Me-262B-1a (9) W.Nr 111643 B3+ZM 4/KG(J)54 Found at Vlatov Czechoslovakia; White S 111/EJG2 Lechfield 1944; White 17 111/EJG2 Lechfield Oberst Hans Trautloft 1944; 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; Avia CS-92.3 V-31 of the VLĮ'...i Scientific Aviation Institute, September 1947
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

Xtradecal X48194
1:48
Panavia Tornado F.3 Part 1 (9) ZE734/JU 111 Sqn RAF Leuchars 2011; ZE785 F.3 OEU RAF Waddington 2003; ZE763/DG 11 Sqn RAF Leuchars 2006; ZE962/XC Dennis the Menace/Deere 29 and ZE731/YP Desperate Dan/Bishop 72 Both Leuchars Fighter Wing, Operation Telic, Saudia Arabia 2003; ZG757 43 Sqn RAF Leuchars 2006 overall black; ZG780 25 Sqn RAF Leeming 2006 black fin; ZH554 41 Sqn RAF Coningsby 2006; 3457 29 Sqn R. Saudi Air...
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

Xtradecal X72178
Supermarine Spitfire Mk.XIV (14) High Back. RB159 DW-D 610 Sqn RAuxAF RAF Culmhead; RB169 MN-F 350(Belgian) Sqn RAF Lympe; NH703 AE-B 'Emily' 402(RCAF)Sqn Germany 1945; RM972 YB-D 17 Sqn RAF Seletar 1945; RN135 Sqn.Ldr 'Ginger' Lacey CO 17 Sqn Japan 1946; Low Back. NH895 NI-K 451 Sqn RAAF Fassberg 1945; NH927/R 6 Sqn R.Indian AF; SM888/B 28 Sqn RAF Kuala Lumpur 1946; NH926/P 28 Sqn RAF Tengah 1947; TZ112 OI-G 2 Sqn RAF Buckebu...
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

Xtradecal X72304
1:72
Messerschmitt Me-262B-1a (9) W.Nr 111643 B3+ZM 4/KG(J)54 Found ay Vlatov Czechoslovakia; Captured at Zatec, Czechoslovakia; White S 111/EJG2 Lechfield 1944; White 17 111/EJG2 Lechfield Oberst Hans Trautloft 1944; 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; Avia CS-92.3 V-31 of the VLĮ'...i Scientific...
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

Xtradecal X72305
1:72
RAF XV Squadron History (6) Bristol Scout C 5313 RFC France 1916; Bristol Blenheim Mk.IV L8852 LS-Q RAF Wyton 1940; Short Stirling Mk.I N6086 LS-F McRoberts Reply RAF Wyton 1942; Avro Lancaster B.III (Special) PD131 LS-V RAF Bovington 1946; Tornado GR.1 ZA446/F McRoberts Reply RAFG Laarbruch 1990; Tornado GR.4 ZA602/F W/C J.P.Nixon/Sl.Ldr P. Abbott, RAF Lossiemouth 2015;
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

Xtradecal X72302
1:72
Vickers Wellington Mk.I (8) L4272 LY-G 149(East India) Sqn RAF Mildenhall 1939; L7842 KX-T 311(Czechoslovak) Sqn RAF Honnington 1940; X9684/Y 37 Sqn, Shallvea, Egypt 1942; X9827 KX-F 311(Czechoslovak) Sqn RAF Bircham Newton 1942; X9889 BL-D 40 Sqn RAF Wyton 1941; N2887/5 Central Gunnery School, RAF Sutton Bridge 1943; Coastal Command W5674 DF-O 221 Sqn Iceland 1942; Z1111 KX-N 311(Czechoslovak) Sqn RAF Aldergrove 1942...
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

Xtradecal X48189
1:48
Hawker Hunter F Mk.6 (8) XF438/H 208 Sqn RAF Tangmere 1959; XF440/D 247 Sqn RAF Odiham 1957; XG172/36 229 OCU (54 Sqn) RAF Chivenor 1969; XF382/15 234 TWU at RIAT Greenham Common 1976; XG204/D CFE detached to Sharjah 1963; XK149/44 79 Sqn RAF Brawdy 1970; XF383/14 220OCU (145 Sqn) RAF Duxford 1960; XF447/H 65 Sqn RAF Duxford 1960; XF383 12 Sqn RAF Honnington 1984;
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

Xtradecal X72287
McDonnell-Douglas FG.1 Phantom Royal Navy stencil data Part 1. Note that small white serials are between the roundels and the black serials but are hard to see. [FG.1/FGR.2]
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

Xtradecal X72300
Martin B-26 Marauder (7) 41-34946 YA-L 386BG 555BS 'The Yankee Guerrilla' RAF Boxted 1944; FB441/G 21 Sqn South Africa Air Force Italy 1944; 42-107652/03 Gp de Bomb Moyen 1/19 Gasacoigne Armeĩ e de l'Air Francaise, Sardinia 1944; FK 375/D RAF 14 Sqn Dominion Revenge, Egypt 1942; 42-95987 71-S 497BS 344BG 'Yo-Yo Champ' Lt A.J.Wood Dijon 1945; 42-96131 YA-P 555BS 386BG Maj R.L.Perkins 'Perkatory II' RAF Gt. Dunmow 1944; ...
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

Xtradecal X72299
Handley-Page Victor K.2 (17) Green/Grey camouflage (5) XL189 57 Sqn RAF Marham 1984; XM715 57 Sqn RAF Marham 1983; XL164 57 Sqn RAF Marham 1983; XL231 232 OCU RAF Marham 1983; XL512 57 Sqn Fl Lt R.M.Skelton detached to Wideawake AB Ascesion Island, Op Corporate May 1982; Hemp camo.(12) XH671 55 Sqn 'Sweet Sue' Muharraq, Bahrain 1991; XH672 55 Sqn 'Maid Marion, Bahrain; XL161 55 Sqn Bahrain; XL231 55 Sqn 'Lusty Lady'...
Aircraft decals (military)
Catalogue
£8.99
Out of Stock
0

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Xtradecal X72301
1:72
BAC/EE Canberra B.2 (6) WD999 9Sqn RAF Binbrook took part in Queen's Coronation Flypast July 1953; WD980 617 Sqn RAF Binbrook 1954; WH640 109 Sqn RAF Hemswell 1953; WH655 249 Sqn RAF Akrotiri Cyprus 1958; WJ608 Swifter Flight, El Adam, Libya 1959; WK116/Q100 Sqn RAF Raynham 1973.
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

Xtradecal X72298
1:72
Bristol Blenheim Mk.I/Mk.If (11) Mk.1 K7078 38 Sqn RAF Wyton 1937 K7133 44-L 44 Sqn RAF Waddington 1938; YN-B 601 Sqn RAF Hendon 1939 L1257 ZK-I 25 Sqn RAF North Weald 1941; K7040 114-V 114 Sqn RAF Wyton 1937; K7107 VT-B 30 Sqn Ismalia Egypt 1940; L1381 VA-G 113 Sqn Greece 1941; Mk.If L1426 RX-M 25 Sqn RAF Northolt 1939; K7177 VT-N 30 Sqn Meleme Crete 1941; WQ-P 604 Sqn RAF Hendon 1940; L6782 ZD-Z 222 Sqn RAF Duxfor...
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

Xtradecal X48187
1:48
Bristol Blenheim Mk.I/Mk.IF (4) K7078 139 Sqn RAF Wyton 1937; K7133 44-L 44 Sqn RAF Waddington 1938; L1426 RX-M 25 Sqn RAF Northolt 1939; L8612 OB-W 45 Sqn Helway, Egypt 1940.
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

Xtradecal X72292
McDonnell-Douglas FGR.2 Phantom Pt.3 (5) XV413/Z 92 Sqn RAFG Wildenrath 1977; XV434/J 23 Sqn RAF Wattisham 1976; XV439/A 19 Sqn RAFG Wildenrath 1977; XV470/C 56 Sqn RAF Coningsby 1976; XV498/498 17 Sqn RAFG Bruggen 1974;
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

Xtradecal X72297
1:72
McDonnell-Douglas FGR.2 Phantom Pt 8 in special markings to Commemorate the 60th Anniversary of the first Atlantic Crossing by Alcock and Brown. Includes XV424 as displayed at IAT Greenham Common 1979 and XV486 the back up aircraft. XV424 is currently displayed at the RAF Museum at Hendon in 56 Sqn markings and these are also included.
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

Xtradecal X48188
1:48
Bristol Beaufighter TF. Mk.X (4) RD427 EO_O 406(RCAF) RAF Dallachy 1945; RD816 OB-O 45 Sqn RAF Tengah, Singapore, Operation Firedog; LZ293 MB-T 236 Sqn Coastal Command RAF North Coates 1944; BD515/Q 22 Sqn Burma 1944.
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

Xtradecal X72296
1:72
McDonnell-Douglas FG.1 Phantom Pt 7 (1) XT597 A & AEE Boscombe Down Raspberry Ripple scheme 25th Phantom Anniversary at IAT Greenham Common 1983. This aircraft needs FDR72120 nose cone. [FG.1/FGR.2]
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

Xtradecal X72167
BAe Hawks in Black (10) Hawk T.1A and Hawk T.2. XX194/CO 100 Sqn RAF Leeming 2000; XX312 19(R) Sqn 95th Anniversary with blue/white checks on fin top, RAF Valley 2010; XX170 Naval Flying Standards Flight (Fixed Wing) RNAS Yeovilton 2003; XX307/307 208(R) Sqn 4FTS RAF Valley 2010; XX167/PU 19(R) Sqn 4 FTS RAF Valley 1998; XX316/316 74(R) Sqn 4FTS RAF Valley 2000; XX184/184 208(R) Sqn 4FTS RAF Valley 1999; XX281 151(R) Sqn 7FTS ...
Aircraft decals (military)
Catalogue
£7.99
-
In Stock
10+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Xtradecal X72291
BAC Jet Provost T.3/T.3a/T4/ T51/T52 (10) T.3 XN577/45 RAF College Cranwell 1960's Overall Silver with Fluorescent orange panels; XP629 Manby College of Air Warfare, 'The Macaws' Overall Lt Aircraft Grey RAF Manby 1968; XN554/60 CFS RAF Little Rissington 1968; XN605/9 6 FTS RAF Acklington 1967; T.4 XR679 79(R) Sqn TWU RAF Brawdy 1984 Green/Grey Camo; XR679 79(R) Sqn TWU RAF Brawdy 1989 Barley Grey; T.51 CJ711 6 Sqn R.Ce...
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

Xtradecal X72295
McDonnell-Douglas FG.1/FGR.2 Phantom Pt.6 (9) FG.1 XT865/U 111 Sqn zapped with Thor's Hammer by Danish Air Force NATO 1980; FGR.2 XV474/F RAF Aldergrove 1978; XV498/U 92 Sqn blue fin RAF Akrotiri; XT891/Z 56 Sqn RAF Wattisham 1978 corrected not 43 Sqn.; XV403/403 6 Sqn RAF Luqa, Malta 1969; XV422/J Jaguar Killer 19 Sqn on detachment RAF Decimomannu 1980; XV464/464 54 Sqn RAF Coningsby 1974; XV401/B 228OCU/64 Sqn RAF Wa...
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

Xtradecal X72085
1:72
BAe Hawk T.1 2008 and Supermarine Spitfire Mk.I/Mk.1 1938 (4) XX325 4FTS/208 Sqn RAF 90th Anniversary Roundel Hawk; XX184 19 Sqn 70th Anniversary Supermarine Spitfire scheme; Red Arrows 2008 scheme; Supermarine Spitfire Mk.I/Mk.1 19 Sqn 1938 the basis for the BAe Hawk scheme The BAe Hawk and Supermarine Spitfire photo is Crown Copyright and re-produced with their permission, the Red Arrows were flying over Hannants warehouse a...
Aircraft decals (military)
Catalogue
£7.99
-
In Stock
2

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Xtradecal X72294
McDonnell-Douglas FG.1/FGR.2 Phantom Pt 5 (9) FG.1 XV579/R 43 Sqn check rudder RAF Coningsby 1979 FGR.2 XT903/X 56 Sqn RAF Wattisham; XV399/P 29 Sqn RAF Coningsby 1980; XV401/B 228OCU/64 Sqn RAF Wattisham 1987; XV406/CK 228 OCU RAF Wattisham 1987; XV418/S 92 Sqn RAFG Wildenrath 1979; XV485/P 23 Sqn RAF Wattisham 1981; XV491/491 31 Sqn RAFG Laarbruch 1971;
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

Xtradecal X72219
1:72
Short Stirling Mk.III and Mk.IV (8) Mk.III EF411 OJ-K 149 Sqn RAF Mildenhall; LK516 WB-J 90 Sqn RAF Tuddenham 1944; LJ516 EX-B RAF Lakenheath 1944; Mk.IV LJ875 QS-B 620 Sqn Cheers for the Beer at the Getsumin, RAF Fairford 1944 D-Day stripes; LJ850 QS-Y 620 Sqn Yorkshire Rose, RAF Fairford with chalked guidelines for D-Day stripes May 1944; LJ566 D4-N 620 Sqn Yorkshire Rose II, RAF Westcott 1945; LK171 WE-S Gp Capt W.E Surplic...
Aircraft decals (military)
Catalogue
£7.99
-
In Stock
7

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

Xtradecal X48184
1:48
U.S. Navy Reserve Air Wing 91 (4) TBM-3E Avenger BuNo 53638/Z NAS Squantum 1950 overall gloss sea blue with orange fuselage band F4U-4B Corsair BuNo 97506/Z NAS South Weymouth 1954 overall gloss sea blue F9F-6 Cougar 130911/7Z-9 NAS South Weymouth 1960's overall white with orange trim; T-33B Shooting Star 138088/7Z-088 1960's overall white with orange trim
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

Xtradecal X72284
1:72
USN Reserve Air Wing 91(10) North-American SNJ-6 Texan BuNo 111960/Z-960 Overall Natural Metal, NAS South Weymouth 1950; Grumman F6F-5 Hellcat BuNo 94268/Z-15 Overall Gloss Sea Blue, NAS Squantum 1952; Vought F4U-4B Corsair BuNo 97506/Z-55 Overall Gloss Sea Blue, NAS South Weymouth 1954; Grumman TBM-3E Avenger BuNo 536638/Z-141 Overall Gloss Sea Blue; Grumman F9F-6 Cougar BuNo 127281/Z-128 Overall Gloss Sea Blue, NAS Sout...
Aircraft decals (military)
Catalogue
£7.99
-
In Stock
20+

[1]   «      9   |   10   |   11   |   12   |   13      »      [20]
-10

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