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 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
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
Westland Sea King In Worldwide Service (9) 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.41, '89+63', of Marinefliegergeschwader 5, West German Navy, Based at Kiel-Holtenau, Germany, 2023 Westland Commando Mk.3 'QA30...
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 Scale
1 each XPS1 Black, XPS2 White, XPS3 Silver, XPS4 RAF Roundel Red, XPS5 Insignia Yellow, XPS6 Roundel Blue Stripes. 6 sheets for the price of 5. (9 different widths of each colour)
Decals (multi-purpose)
Catalogue
£11.25
-
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
1:32
Gloster Meteor F.3 Collection (6) Gloster Meteor F.3 EE239, 'YQ.Q' of 616 Squadron, 2 TAF, Royal Air Force based at Lubeck, Germany, 1946. Gloster Meteor F.3 EE278, 'ZD.A' of 222 Squadron, Royal Air Force based at RAF Tangmere, UK, 1947. Gloster Meteor F.3 EE337, 'FD/051' of 778 Naval Air Squadron, Royal Air Force based at RAF Tangmere, UK, 1947. Gloster Meteor F.3 EE416, which was the first trials aircraft to be used by M...
Aircraft decals (military)
Catalogue
£11.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

No Image
Post War Avro Lancaster Pt3 (5) Avro Lancaster B.Mk.I, '1808', Royal Egyptian Air Force, October, 1950. Avro Lancaster Mk.X, BK904, 'CJ.P', part of the Royal Canadian Air Force Search & Rescue Force based at Sea Island Station, British Columbia, Canada, 1949. Avro Lancaster B.Mk.VII (F.E), NX683, 'BL.G', of 40 Squadron, Royal Air Force, based at Abu Sueir, Egypt, 1946. Avro Lancaster GR.3, SW329, 'CJ.G', of 203 Squadron, R...
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
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
Bell P-39 Airacobra In Worldwide Service Collection. (10) Bell P-39D Airacobra, 6731P/'67'of 40th Pursuit Squadron, 31st Pursuit Group United States Army Air Corps, during the Carolina Manoeuvres, USA, October - November, 1941. Bell P-39N Airacobra, 4218769/'6'of GC 1/4 ' Navarre', Forces Ariennes FranÆ'éaises Libres, based at La Mediouna, Morocco, 1943. Bell Airacobra Mk.I, AH565/'UF.U'of 601 Squadron, Royal Air Force,...
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

No Image
Auster In Worldwide Service Collection (9) Auster AOP.6, VX123, 'E', of 663 Royal Auxillary Squadron, Royal Air Force, based at RAF Hooten Park, UK, 1949. Auster AOP.6, VT986, 'A-13', of Belgian Air Force, based at Brasschat, Belgium, 28 March, 1952. Auster AOP.10, WJ363, of 38 Group, Royal Air Force, based at RAF Odiham, UK, 1961. Auster T.7, 16687, 'OU.687, of 38 Group, Light Aircraft School, Royal Canadian Air Force, b...
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
Post War Avro Lancaster Pt2 (6) Avro Lancaster ASR.Mk.III, RF324, 'RL.K', of 279 Squadron, Royal Air Force, based at RAF Thornaby, UK, 1945. Avro Lancaster ASR.Mk.III, RE115, 'OZ.T', of 210 Squadron, Royal Air Force, based at RAF St Eval, UK, 1948. Avro Lancaster MR.1, W.U.41, '9.S3', of Escadrille 9S, French Aeronavale, based at Naval Base Nouma, New Caledonia, 1961. Avro Lancaster B.Mk.I (Special), PD131, 'LS.V', of 15...
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
Douglas A-20G Havoc Collection (4) Douglas A-20G Havoc, 43-10213, 6Q/R, 'Skonk Works' of 410th Bomber Group, 9th Air Force, United States Air Force, 1944. Douglas A-20G Havoc, 43-22148, A28-78, DU.R, 'Topsy' of 22 Squadron, Royal Australian Air Force, based at Morotai, December, 1944. Douglas A-20G Havoc, 42-54258, 'White 3' of 27th Bomber Aviation Regiment, Soviet Air Force, based at Lvov, Ukraine area, Autumn, 1944. Doug...
Aircraft decals (military)
Catalogue
£10.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

No Image
Hawker Hurricane Mk.IIb (4) Hawker Hurricane Mk.IIb, Z3768, 'FK.49' of 81 Sqn, 151 Wing, RAF, South African Air Force based at Vaenga, Russia, September, 1941. Hawker Hurricane Mk.IIb, Z3658, 'YO.N' of 401 (Ram) Squadron, RCAF, based at RAF Digby, 24 July, 1941. Hawker Hurricane Mk.IIb, AP894, 'C' flown by Flight Lieutenant Jack Storey of 135 Squadron, Royal Air Force, based at 'George' and 'Hove' Landing Grounds, East Beng...
Aircraft decals (military)
Catalogue
£8.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

No Image
Hawker Hurricane Mk.IId (8) Hawker Hurricane Mk.IId, BP554, 'JV.-' of 6 Squadron, Royal Air Force, based at Shandur, Egypt, April, 1942. Hawker Hurricane Mk.IId, KX121, 'G' of 5 Squadron, Royal Air Force, based at Khargpur, India, July, 1943. Hawker Hurricane Mk.IId, HV663, 'U' of 6 Squadron, Royal Air Force, based in Western Desert, North Africa, 1942. Hawker Hurricane Mk.IId, KX413, 'FJ.M' of 164 Squadron, Royal Air Forc...
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

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!! Messerschmitt Bf-109s with Stab markings Pt 2 (8) Bf-109E-4 III/JG 77 Greece 1941 Yellow nose/rudder; Bf-109E-4 I/JG 3 CO Hptm Hans Von Hahn Late 1940, St Omer France, Yellow nose/rudder; Bf-109F-2 I/JG 3 Tech Offizer Hptm Detlev Rohwer Ukraine 1941 Yellow nose/fuselage band, includes correction for spinner stripes; Bf-109F-2 II/JG 53 Gruppenkommandeur Hptm Heinz Bretnutz, St Omer 1941. Yellow nose/rudder; Bf-...
Aircraft decals (military)
Catalogue
£8.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++