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=8045 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 46 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
Hi Decal HD72063
1:72
Back in stock! McDonnell F-4E Phantom II 'Pharaoh's Ghosts' (4) 222nd Tactical Fighter Brigade, Egyptian Air Force: * 66-0366 / 7813 in disruptive 'Compass Ghost Grey' camouflage, 1980, * 67-0289 / 7827 in 'South East Asia' camouflage with orange & black quick ID panels, 1983, * 67-0341 / 7818 in 'Hill One' scheme, seen in 1988, * 67-0239 / 7817 in 'Hill Two' scheme with orange & black quick ID panels, 1990. Before bei...
Aircraft decals (military)
Catalogue
£7.20
-
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

Hi Decal HD72024
Sukhoi Su-27 Flanker (4) All 1992 schemes. Blue 24 582 Fighter Regt CIS Air Force 1992; Red 10 Soviet Air Force Training Center; Blue 06 either Soviet or Ukranian Air Force; Blue 24 Chinese Air Force
Aircraft decals (military)
Catalogue
£6.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

Hi Decal HD72052
Re-printed! Northrop F-5E Tiger II Islamic Iranian Air Force (4) 3-7059, 21 TFS, TFB.2 Tabriz, 1985 - credited with at least 3 kills during the Iran-Iraq war; Northrop F-5E Tiger II 3-7301, 21 TFS, TFB.2 Tabriz, 2010 - with eagle head and diving eagle on fin; Northrop F-5F Tiger II 3-7155, 43 TFS, TFB.4 Vahdati, 2010 - with Tigerhead and diving eagle on fin; All with dk. green/ brown/sand Asia Minor camouflage; Northrop F-5E A...
Aircraft decals (military)
Catalogue
£6.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

Hi Decal HD72026
1:72
Mil Mi-4A Hound A (9) Yellow 03 Soviet Air Force 1965; White 611 Ploish Air Force 1975; White 746 E. Geramn Air Force 1968; Black 569 E. German Air Force; White 28 Hungarian Uprising 1956; Yellow 7385 Chinese Air Force 1974; White 4417 N. Vietnamese Air Force 1969; Z1017 Indian Air Force 1965; H-302 Indonesian Air Force 1963; Variety of schemes.
Aircraft decals (military)
Catalogue
£6.99
-
In Stock
3

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

Hi Decal HD72015
Re-printed! Mikoyan MiG-23 Flogger B/E/G (5) Soviet Red 01 with Dolphin on rudder; Israeli 1990 (ex Syrian Air Force); Poland Red 007 1991; Iraqi 1990- 91; German (ex East German) 20+05
Aircraft decals (military)
Catalogue
£6.99
-
In Stock
4

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Hi Decal HD72062
1:72
Lockheed T-33A Shooting Star (5) - T-33A "2-161", Imperial Iranian Air Force (IIAF), Training Detachment at TFB.1 Mehrabad, 1963 - target tug scheme wth orange uppersurfaces and NMF underside; - T-33A "2-8002", Islamic Republic of Iran Air Force (IRIAF),85th AWTS, TFB.8 Baba'ie, 1987 - pale grey uppersurfaces and light grey underside; - T-33A "2-8005", Islamic Republic of Iran Air Force (IRIAF),85th AWTS, TFB.8 Baba'ie, 1...
Aircraft decals (military)
Catalogue
£7.20
-
In Stock
4

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Hi Decal HD72037
1:72
Mikoyan MiG-21bis Fishbed L/N/(6) 01 Soviet Air Force 1989; 01 Ukranian Air Force 1992 (same aircraft as first); 0809 Polish Navy; Yugoslav Republic Air Force 1993; Croatian Air Force 'Avenger of Dubrovnik' 1993; No 887 East German Air Force 1978;
Aircraft decals (military)
Catalogue
£6.99
-
In Stock
4

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Hi Decal HD72044
1:72
Mikoyan MiG-29A/BG 'Fulcrum' A (7) Poland (2) Red 66 1st Fighter Regt 1999; Red 89 Eagles Talon '97; Yugoslavia 127 Sqn 1997; Cuba 231 Fighter Sqn 1997; India KBoeing 720 28Sqn; Iran 3-6115 1998;Luftwaffe 29+06 1st Sqn 1997
Aircraft decals (military)
Catalogue
£6.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

Hi Decal HD72051
1:72
Re-printed! Grumman F-14A Tomcats (6) 160365 / 3-6067 73rd TFS Imperial Iranian Air Force 1978; 160318 / 3-6020 Islamic Republic of Iran Air Force both in desert camouflage schemes FS30400/30140/34079; 160320 / 3-6022 IRIAF 1995 FS35450/33578; 160339 3-6041 IRIAF 2003 FS3622/33578; 159855/10 NSAWC blue/grey Aggressor scheme 1998; 160913/13 NSAWC tan/green Aggresor scheme. Both NAS Fallon
Aircraft decals (military)
Catalogue
£6.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

Hi Decal HD72053
1:72
Re-printed! McDonnell RF-4C Phantom/RF-4E Phantoms (7) McDonnell RF-4C Phantom (4) 65-0835 165 TRS/123 TRW Kentucky ANG RAM 1986; then with Spanish Air Force as 12-58 123 Escuadron 1989 still in Europe 1 camouflage schemes and then in light grey camouflage schemes 1993 as it flew last Spanish F-4 flight in 2003; 65-0823 12-64 123 Escuadron Torrejon retirement scheme Titanes Phorever 1978-2002. McDonnell RF-4E (3) Iran Air Forc...
Aircraft decals (military)
Catalogue
£6.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

Hi Decal HD72055
1:72
Re-printed! McDonnell F-4D Phantom (7) Korea Air Force 66-8798 151 TFS 1990; Iranian Air Force 87-14884/3-616 308 TFS 1973 or 1980; USAF 66-8802/TX 704th TFS USAFRes Bergstrom Air Force Base; 65-0801 111st FIS Texas ANG Ellington 1988; 660271 127th TFS Kansas ANG McConnel Air Force Base 1986; 66-7751/FM 93rd TFS USAFRes Homestead Air Force Base 1984
Aircraft decals (military)
Catalogue
£6.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

Hi Decal HD72050B
1:72
Re-printed and updated version of HD72050 Sukhoi Su-27S/SK/UB Flanker B/C (6) Su-27S Flanker B: - "1953" 1st Fighter Sqn, Ethiopian Air Force with kill marking 2010; - "608" 6th Fighter Squadron Eritrean Air Force 2005; - "C110" 13th Fighter Squadron Angolan Air Force 2006; Su-27 SK Flanker B: - "TS-2701" 11th Fighter Squadron, Indonesian Air Force 2003; Su-27UB Flanker C: - "I 100" 13th Fighter Squadron Angol...
Aircraft decals (military)
Catalogue
£6.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

Hi Decal HD72064
1:72
North-American F-86F-25/F-30 (F-40 wing) Sabre (4) - - 'Camouflaged Desert Swords' (designed to be used with Fujimi, Hasegawa and Hobby Boss kits) * F-86F-25 51-13244 / 3-133 - 103rd TFS, Imperial Iranian Air Force, in Natural Metal Finish, deployed to Kamina AB,Congo, in 1963 as part of the UN Fighter Wing during the Katanga crisis. * F-86F-25 51-13224 / 3-140 - 41st TFS, Imperial Iranian Air Force, in Asia Minor camouf...
Aircraft decals (military)
Catalogue
£6.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

Hi Decal HD72058
McDonnell F-4E/F-4ETM /RF-4ETM Phantom II 'Turkish Air Force' (4) 68-0346 F-4E Phantom II - 111 Filo 'Panter', ex NJ ANG, with big 'Tiger head' on the front fuselage,1993. 68-0403 F-4ETM Simsek - 112 Filo 'Seytan', with big Sharkteeth and 'Devil head' artwork on the tail , 2011. 67-0227 F-4E Phantom II - 172 Filo 'Sahin', with Sharkteeth and big 'Falcon head' artwork on the tail , 2010. These Phantoms all wear the Hi...
Aircraft decals (military)
Catalogue
£6.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

Hi Decal HD72025
McDonnell F-4E/RF-4E/F-4E(S), Kurnass 2000 Phantom Israeli (8) F-4E from Scorpion, Bat Orange Tail and 'Ahat' Squadrons; F-4E(S) 'Atalev' Sqn; McDonnell RF-4E black/yellow check rudder; etc.
Aircraft decals (military)
Catalogue
£6.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

Hi Decal HD72029
1:72
Grumman A-6E Intruder (3)161667 AJ/633 VA-36 USS Theodore Roosevelt Desert Storm, tan and sand scheme; 157010 AB/500 VA-85 USS America Operation 'Deny Flight' 1993; 161681 EA/500 VNA(AW)-332 MCAS Cherry Point 1993
Aircraft decals (military)
Catalogue
£6.99
-
In Stock
4

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Hi Decal HD72017
1:72
Mikoyan MiG-23/MiG-27B/N Flogger B/N (5) Soviet Yellow 44 1991; Indian Air Force 9 Sqn TS531; Iraqi Air Force 1990; East German Red 7120 1989; Czech/Slovak 28 Fighter Bomber Regt 1992
Aircraft decals (military)
Catalogue
£6.99
-
In Stock
1

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

Hi Decal HD72022
1:72
Mikoyan MiG-15 Fagot B (5) Red 40 Soviet Ace Nikolay Shkodin 1953; Black 12 Soviet Aerobatic Team 1954; Red 1012 Polish Air Force 1959; Red 3 E. German Air Force 1957; Egyptian Air Force 1956
Aircraft decals (military)
Catalogue
£6.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

Hi Decal HD72045
1:72
Mikoyan MiG-29UB (7) Red 28 1st Fighter Regt Polish Air Force 1997; Blue 61 3rd Fighter SQn, Ukraine Air Force 1995; White 61 Moldavian Air Force 1997; White 77 120th Fighter Regt Soviet Air Force 1996; Red 15 57th Air Group Romanian Air Force 1998; Black 179 3rd Fighter Wing E. German Air Force 1989; 046 6th Air Group Peruvian Air Force 1997
Aircraft decals (military)
Catalogue
£6.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

Hi Decal HD72001
1:72
Panavia Tornado GR.1 (4) Desert Storm RAF ZA447/EA MiG Eater: ZD739/AC Armoured Charmer; Italian Air Force; Royal Saudi Air Force
Aircraft decals (military)
Catalogue
£6.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

Hi Decal HD72012
1:72
Boeing Chinook (5) #1 is a Chinook HC.1 ;240 OCU, RAF, Operating in Saudi Arabia during Desert Storm in February 1991. The paint scheme is Desert Pink FS 30279 with a Yellow Camel nose art on both sides. #2 is a Chinook HC.1;7th Sqn RAF, Operating in Saudi Arabiawith toned down camouflage for night operations during Desert Storm in February 1991. The paint scheme is Desert Pink FS 30279 with a Black FS 37038 "spots" and ...
Aircraft decals (military)
Catalogue
£6.99
-
In Stock
4

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Hi Decal HD72057
1:72
McDonnell RF-4C/F-4E Phantoms (7) McDonnell RF-4C 67-0436 131st TRS 39th TRG South Korean Air Force grey camouflage; F-4E 67-0392 457th TFS 301st TFW `War Lord' double MiG killer USAFR Texas 1989 Grey camouflage; 3-6658 11th TFS I Mehrabad 1978; 3-6645 61st TFW Bushehr 1980; 3-6642 32nd TFW Nojeh 1985, all Iran Air Force Dk Green,Brown/Sand camouflage; 76-0499 152nd TFW 17th TFW Daegu 1980 SEA camouflage; 68-0421 156th TFS 10t...
Aircraft decals (military)
Catalogue
£6.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

Hi Decal HD72036
North-American F-86D Sabre International (4) 16171 337Sqn 1965 Camouflage green/tan/grey; 18305 FU-305 343 SQn 1963 natural metal. Both Royal Hellenic Air Force. 18406 FU-406 8FS 5FW Phillippine Air Force 1965; 30848 No 1222 12 Sqn Royal Thai Air Force 1069
Aircraft decals (military)
Catalogue
£6.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

Hi Decal HD72043
1:72
Ilyushin IL-28/RT/U Beagle/Mascot (designed to be used with Bilek and Italeri kits)
Aircraft decals (military)
Catalogue
£6.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

Hi Decal HD72030
1:72
Mikoyan MiG-17F Fresco A (6) USSR, Blue 88 Czech invasion 1968; Blue 02 Aerobatic Team 1956; GDR, Red 589 1960; Iraq 1961; Mongolia, Red 003 1966; Royal Afghan Air Force Black 106 1962
Aircraft decals (military)
Catalogue
£6.99
-
In Stock
5

   1   |   2      »      [2]

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