SELECT /* MAIN SEARCH QUERY */
	
	pm.name AS manufacturer,
	pm.name AS manufacturer_name,
	P.id,
	P.id AS product_id,
	P.code,
    P.cost_price,
    P.vat_enabled,
	P.description,
	P.sold_retail,
	P.sold_trade,
	P.sold_wholesale,
    P.country_origin_code,
    P.commodity_code,
    P.price_set,
    P.width,
    P.height,
    P.length,
    P.product_scale_id,
    P.reorder_level,
    P.release_date,
    P.weight,
    P.restriction,
    P.restriction_bit,
    P.active,
    P.minimum_level,
    P.second_hand,
    P.limited_availability,
    P.can_reorder,
    P.warehouse_zone_id,
    P.wholesale_customers,
    P.new_price,
    P.big_postage,
    P.disable_min_order_amount,
    P.last_updated,
    P.notes,
    P.old_product_scale_txt,
    P.has_image_200,
    P.has_image_400,
    P.last_purchase_order_stock,
    P.last_purchase_order_date,
    P.first_delivered_date,
    P.last_moved,
    P.scale_string,
    P.keywords,
    P.finished_date,
    P.availability,
    P.sold,
    P.sold_total,
    P.sold_retail,
    P.sold_trade,
    P.sold_wholesale,
	P.base_price,
	P.base_export_price,
	P.retail_discount,
	P.eu_price,
	P.export_price,
	P.trade_price,
	P.trade_export,
	P.wholesale_price,
	P.wholesale_export,
	P.discount,
	P.backorder_retail_discount,
	P.backorder_discount,
	P.trade_discount,
	P.wholesale_discount,
	P.product_category_id,
    P.product_division_id,
	P.product_type_id,
	P.product_manufacturer_id,
	GROUP_CONCAT(DISTINCT ps.scale ORDER BY ps.scale ASC SEPARATOR ', ') AS scale,
	UNIX_TIMESTAMP(P.date_added) AS date_added,
	UNIX_TIMESTAMP(P.arrival_date) AS arrival_date ,
	DATE(P.arrival_date) AS real_arrival_date ,
	pt.name AS product_type,
	pt.name AS type_name,
	media.filename,
	IF (pp.id is null,0,1) as pending,
	
	if(
		coalesce( (coalesce(sl.count , 0) - coalesce(sc.product_quantity , 0 ) ) , 0 ) >= 0  ,
		if(
			coalesce( (coalesce(sl.count , 0) - coalesce(sc.product_quantity , 0 ) - coalesce(bv.backorders, 0 ) - coalesce(bv.free_backorders, 0 ) ) , 0 ) >= P.show_stock,
			P.show_stock ,
			coalesce( (coalesce(sl.count , 0) - coalesce(sc.product_quantity , 0 ) - coalesce(bv.backorders, 0 ) - coalesce(bv.free_backorders, 0 ) ) , 0 )
		)
	    , 0
	) as available,
    COALESCE(sl.count,0) as stock_level,
    COALESCE(sc.product_quantity,0) AS stock_committed,
    COALESCE(bv.backorders,0) AS backorders,
    COALESCE(bv.free_backorders,0) AS free_backorders,
	pc.id as department_id,
	pc.name as department,
	pc.name as department_name,
	P.show_stock,
	if(
		pc.name = 'Future Releases',
		true,
		false
	) AS future,
    unix_timestamp(media.date_uploaded) as unixtime



FROM product P
LEFT JOIN stock_level sl on P.id = sl.product_id
LEFT JOIN stock_committed sc on sc.product_id = P.id
LEFT JOIN backorder_values bv ON bv.product_id = P.id
LEFT JOIN product_category pc on P.product_category_id = pc.id
LEFT JOIN product_manufacturer pm ON P.product_manufacturer_id = pm.id
LEFT JOIN product_media media ON P.id = media.product_id AND `media`.`order` = 0

JOIN
product_scale_map AS psm ON (psm.product_id = P.id)

LEFT JOIN
product_scale ps ON (psm.scale_id = ps.id)

LEFT JOIN product_type pt ON P.product_type_id = pt.id
LEFT JOIN pending_product pp ON P.id = pp.id
WHERE 1  AND P.restriction_bit & 1 = 1 AND P.product_manufacturer_id=8274 AND ps.id = 955 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 174 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
Fairey Gannet COD.4/AS.4/T.2/T.5 Collection (9) Fairey Gannet COD.4 XA430, '074'/'E' Royal Navy, aboard HMS Eagle, 1960s. Fairey Gannet COD.4 XG786, 'FOAC'/'2' assigned to Flag Officer Carriers, Ship's Flight, Royal Navy, aboard HMS Ark Royal, 1963. Fairey Gannet AS.4 XA321, '293'/'O' of 815 NAS, Royal Navy, aboard HMS Ark Royal, 1956. Fairey Gannet AS.4 XA471, '280'/'E' of 814 NAS, Royal Navy, aboard HMS Eagle, 1960s. Fa...
Aircraft decals (military)
Catalogue
£10.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
1:48
McDonnell F-4G Phantom 'Wild Weasel' Collection Pt1 (6) McDonnell F-4G Phantom II, 69-7251 of 562nd Tactical Fighter Squadron, 35th Tactical Fighter Wing, based at George Air Force Base, California, May, 1981. McDonnell F-4G Phantom II, 69-7580 of 90th Tactical Fighter Squadron, 3rd Tactical Fighter Wing, based at Clark Air Base, Philippines, September, 1988. McDonnell F-4G Phantom II, 69-0263 of 4404th Composite Wing, 81st...
Aircraft decals (military)
Catalogue
£8.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
Westland Sea King Collection Pt1 (7) Westland Sea King AEW.2 XV714, '187'/'87' of 849 Naval Air Squadron, Royal Navy, based at RNAS Culdrose, 1989. Westland Sea King HAS.6 ZG813, '274'/'74' of 820 Naval Air Squadron, Royal Navy, aboard HMS Illustrious, 2001. The 820 NAS display Sea King for the 2001 season as seen at The International Festival of the Sea that year. Westland Sea King HAR.3 XZ589, of 'D Flight', 202 Squadron,...
Aircraft decals (military)
Catalogue
£8.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
Westland Sea King Collection Pt2 (7) Westland Sea King HAR.3 XZ295, of 302 Squadron, Royal Air Force, based at RAF Lossiemouth, 1990s. Westland Sea King HAR.3 XZ591 of 202 Squadron, Royal Air Force, based at RAF Brawdy, 1983. Westland Commando HC.4 ZD480, of 845 Naval Air Squadron, used in United Nations duties, seen at RNAS Yeovilton, 14 July, 1995. Westland Sea King HAS.1 XV653, '94' of 706 Naval Air Squadron, Royal Navy...
Aircraft decals (military)
Catalogue
£8.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
Westland Sea King Collection Pt3 (6) Westland Sea King HU.5 XV705, '821'/'21'/'CU' of 771 Naval Air Squadron, Royal Navy, based at RNAS Culdrose, Westland Commando HC.4 ZE427, 'K' of 848 Naval Air Squadron, Royal Navy, based at RNAS Yeovilton, January, 2016. Westland Sea King HAS.6 ZG818, '71'/'N' of 814 Naval Air Squadron, Royal Navy, based at RAF Culdrose, 1991 Westland Commando HC.4 ZG822, 'WF', of 848 Naval Air Squadro...
Aircraft decals (military)
Catalogue
£8.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
Westland Sea King Collection Pt4 (6) Westland Sea King HU-5S XZ918, '020'/'20'/'N' of 771 Naval Air Squadron, Royal Navy, Mid-1980s. Westland Commando HC.4 ZB507, 'B' Royal Aircraft Establishment, Farnborough, 1980s. Westland Sea King HAR.3 XZ592, 'S', of 203 Squadron which was part of the Royal Air Force, Sea King Training Unit, Royal Air Force, based at RAF Culdrose, 1990s. Westland Commando HC.4 ZG820, 'F', of 845 Naval...
Aircraft decals (military)
Catalogue
£8.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
Westland Sea King Collection Pt5 (6) Westland Sea King Mk.50 N16-125, '10' of 817 Naval Air Squadron, Royal Australian Navy, 1977. Westland Sea King Mk.48 'RS01' of 40 Squadron, Belgian Air Force, 2007. Westland Sea King Mk.42C 'IN559' of 40 Squadron, Indian Navy, 2007. Westland Sea King Mk.45 '4514' Pakistan Navy, 1976. Westland Commando Mk.3 'QA30' of No.8 Anti-Surface Vessel Squadron, Qatari Emiri Air Force, 2011. Wes...
Aircraft decals (military)
Catalogue
£8.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
1:48
Westland Sea King Collection Pt6 (5) Westland Sea King Mk.43B, '073', of 330 Squadron, Royal Norwegian Air Force, Based at Bod Main Air Station, Norway, 2014. Westland Sea King Mk.45 '11' Pakistan Navy, 2005. Westland Sea King Mk.50A 'N16-118'/'07' of 817 Squadron, Royal Australian Navy, 2005. Westland Sea King Mk.41, '89+51', of Marinefliegergeschwader 5, West German Navy, Based at Kiel-Holtenau, West Germany, 1992.
Aircraft decals (military)
Catalogue
£8.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
Mitsubishi KI-21 (8) Mitsubishi Ki-21-II-Ko(a), of Hamamatsu Army Flying School, Japanese Army Air Force, based at Hamamatsu Air Base, Shizuoka Prefecture, Japan, 1939. Mitsubishi Ki-21-Ib, of 2nd Chutai, 7th K...ék...é«tai, Japanese Army Air Force, based in Malaysia, 1942. Mitsubishi Ki-21-II-Ko(a), of 2nd Chutai, Hamamatsu Army Flying School, Japanese Army Air Force, based at Hamamatsu Air Base, Shizuoka Prefecture, Japan,...
Aircraft decals (military)
Catalogue
£10.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
Hawker Hurricane Mk.IIc Collection (8) Hawker Hurricane Mk.IIc, BD929, 'ZY.S' of 247 (China-British) Squadron, Royal Air Force, based at RAF Exeter, UK, 1942. Hawker Hurricane Mk.IIc, serial possibly Z3574, 'OK.2' personal aircraft of Air Vice Marshal Keith R. Park, AOC Malta, Royal Air Force, based at RAF Luqa, Malta, October/November, 1942. Hawker Hurricane Mk.IIc, LF534, '6H.C' of 1688 Bomber Defence Training Flight,...
Aircraft decals (military)
Catalogue
£8.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
1:48
Hawker Hurricane Mk.IIc Trop Collection (7) Hawker Hurricane Mk.IIc Trop, LB680, 'MW.J' of 7 (Battleaxes) Squadron, Indian Air Force, based at Peshawar, Pakistan, December, 1944. Hawker Hurricane Mk.IIc, BE643, 'EG.N' of 34 Squadron, Royal Air Force, based at Palel, India 1944. Hawker Hurricane Mk.IIc 5285, 'AX.E' of 'A Flight' 11 OTU, South African Air Force based at Waterkloof, Air Base, South Africa, 1945. Hawker Hurric...
Aircraft decals (military)
Catalogue
£8.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
1:48
Hawker Sea Hurricane Mk.IIc Collection (8) Hawker Sea Hurricane Mk.IIc, NF698 '7.D' of 835 Naval Air Squadron, Fleet Air Arm, based aboard HMS Nairana, 1944. Hawker Sea Hurricane Mk.IIc NF728, 'K1.F' of 760 Naval Air Squadron, Fleet Air Arm, based aboard HMS Ravager, October 4, 1944. Hawker Sea Hurricane Mk.IIc NF694, 'U'/'Sheila' of 824 Naval Air Squadron, Fleet Air Arm, based aboard HMS Striker, 1944. Hawker Sea Hurrican...
Aircraft decals (military)
Catalogue
£8.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

Recently found! McDonnell-Douglas FG.1 Phantom (2) 43 Sqn XV571/A with Black and White check fin; 111 Sqn XV574/Z with Black and Yellow Fin.
Aircraft decals (military)
Catalogue
£4.99
-
In Stock
50++

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

REPRINTED!! RAF National Insignia/Roundels A type. Sizes 25 inches , 30 inches , 32.5 inches , 35 inches , 40 inches , 42 inches , 45 inches , 50 inches , 60 inches , 65 inches , 84 inches , 100 inches (RAF Roundels)
Aircraft decals (military)
Catalogue
£6.99
-
In Stock
50++

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

1:48
REPRINTED!! Hawker Hunter F.6 (7 Sqns, 4 a/c) XF383 12 Sqn wrap round camouflage; XF526/C 56 Sqn, C/63 Sqn, 78/4 FTS RAF Valley red/white/grey scheme all red/white/ blue roundels; XE599 D/74 Sqn, C/208 Sqn; XF506/X 111 Sqn Black Arrows S/L Latham's lead a/c
Aircraft decals (military)
Catalogue
£7.99
-
In Stock
50++

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

REPRINTED!! RAF White Letters, Numerals 4 inches ,8 inches and 12 inches and Titles for Royal Air Force, Royal Navy, Army, Air Support Command etc double sheet. (RAF codes/RAF code letters/RAF serial numbers)
Aircraft decals (military)
Catalogue
£6.99
-
In Stock
50++

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

RAF National Insignia/Roundels B Type. Sizes 15 inches , 25 inches , 30 inches , 32 inches , 35 inches , 40 inches , 44 inches , 48 inches , 49 inches , 50 inches , 56 inches , 59 inches , 63 inches , 66.5 inches , 75 inches , 100 inches Double sheet.(RAF Roundels)
Aircraft decals (military)
Catalogue
£6.99
-
In Stock
50++

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Re-printed!! RAF Post War D Type roundels, 84 inches , 66 inches , 54 inches , 48 inches , 36 inches , 30 inches , 24 inches , 18 inches and rudder stripes plus Low Viz pink and pale blue National Insignia/Roundels 45 inches , 36 inches , 12 inches and white outline discs. Double sheet
Aircraft decals (military)
Catalogue
£6.99
-
In Stock
50++

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Battle of Britain Luftwaffe (8) Messerschmitt Bf-109E-3/Bf-109E-4 Yellow 11 9./JG 26 Fw Artur Beese Aug 1940; Yellow 1 6./JG 51 Oblt Josef (Pips) Priller Staffelkapitan Oct 1940; Yellow M 6(Schlact)/LG 2 Fw Erhardt Pankratz Oct 1940; All yellow nose/rudder; Yellow 15 3./JG 52 Uffz Karl Wolff Aug 1940 White nose/rudder; Junkers Ju-87B-1 'Stuka' 6G+AT 6./St.G 1 Summer 1940; Messerschmitt Bf-110C 3U+AA ZG 76 Oberslt Huth, Kommodo...
Aircraft decals (military)
Catalogue
£12.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

No Image
NEW!!! Avro Anson Mk.I Part 4 (6) Avro Anson T.I, EG317/'603'/'C', of Air Service Training Ltd, in service under Royal Navy Admiralty contract, based at RAF Hamble,UK, 1952. Avro Anson Mk.I, DJ513, of Royal Norwegian Air Force, based in Norway, 1946 - 1947. Avro Anson Mk.I, '214' of Portuguese Air Force, based in Portugal, 1947. Avro Anson 10 '02' of Israeli Air Force, based in Israel, early 1950's. Avro Anson Mk.I, R3530...
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
NEW!!! Battle Of France Fighters Collection (4) Morane-Saulnier MS.406C1, No.795/L824/'5', flown by Jean Bertrand of 6 escadrille, Groupe de Chasse III/7, Arme de l'air, based in France, 14 May, 1940. Marcel Bloch MB.152, No.622/'15' of flown by C. C. Szaposznikow of 3 escadrille, Groupe de Chasse II/6, Arme de l'air, based in France, June, 1940. Hawker Hurricane Mk.I, L2047, 'LK.H' of 87(F) Sqn, 60 Wing, Air Component ...
Aircraft decals (military)
Catalogue
£8.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
NEW!!! Desert Air War Collection Part 1 Supermarine Spitfire Mk.Vb Trop, ES276, 'WD*D', flown by Lt. Sylvan Feld of 4th Fighter Squadron, 52nd Fighter Group, USAAC, based at La Sebala, Tunisia, June, 1943. Curtiss Tomahawk Mk.IIb, AM406, 'DX.O' of 4 Squadron, South African Air Force, based at Lille-Seclin, North Africa, May, 1942 Supermarine Spitfire Mk.Vb Trop, ER758, 'S', 'Hero', of 336 (Greek) Squadron, based at Benghazi...
Aircraft decals (military)
Catalogue
£8.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

Panavia Tornado Gr.1 Stencil Data. Complete stencil data for 2 UK and RAF Germany (RAFG) (1 each) based aircraft including underwing stores and uppersurface walkways. 2 full size decal sheets.
Aircraft decals (military)
Catalogue
£9.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

No Image
Avro Anson Mk.I Part 1 (6) Avro Anson Mk.I, W2531, of No.8 Service Flying Training School, Royal Canadian Air Force, based at Moncton, New Brunswick, Canada, September, 1941. Avro Anson Mk.I, W2531, 'J3', of No.31 Air Navigation School, Royal Canadian Air Force, based at Port Albert, Ontario, Canada, 1941. Avro Anson Mk.I, N9561, of No.9 Flying Training School, Royal Air Force, based at RAF Hullavington, UK, during 1939 - 1...
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
Avro Anson Mk.I Part 2 (6) Avro Anson Mk.I (Early), K6163, of Central Flying School, Royal Air Force, based at RAF Uphaven, UK, 1937. Avro Anson Mk.I (Early), A4-21, of 22 Squadron, Royal Australian Air Force, based at RAAF Richmond, New South Wales, Australia, 1938 - 1939. Avro Anson Mk.I (Early), A4-27, of No. 4 Service Flying Training School, Royal Australian Air Force, based at RAAF Geraldton, Western Australia, Austral...
Aircraft decals (military)
Catalogue
£9.99
-
In Stock
5+