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=362108 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 878 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
Print Scale PSL14424
1:144
Avro Vulcan B.2 Part 2 1. Avro Vulcan B.2 XL 444 of No. 617 Sqn, RAF Scampton, mid-1970s. 2. Vulcan K2 XL 445 of No. 50 Sqn, RAF Waddington, 1983. 3. Avro Vulcan B.2 XM 602 of No. 1 Group, Giant Voice 1971, McCoy AFB, Florida, 1971. 4. Avro Vulcan B.2BS XM 610 of No. 44 Rhodesia Sqn, RAF Scampton, January 1969. 5. Avro Vulcan B.2 XL 391 of No 9 Sqn, RAF Waddington, 1976. 6. Avro Vulcan B.2 XJ 783 of No 35 Sqn...
Aircraft decals (military)
Catalogue
£11.80
-
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

Print Scale PSL48040
Panavia Tornado Part 1 1. Tabuk Tornado GR.1 Za447 /EA 'MiG Eater' the party the Gulf war in 1991 2. Tornado GR.1 ZA465 / Tabuk of the 'Foxy Killer 'FK the Gulf war in 1991 3.Tornado GR.1 Za739 'Armored Charmer' AC Tabuk detachment, the Gulf war in 1991 4. Tornado GR.1 ZA748 / Anola Kay AK Tabuk detachment the Gulf war in 1991 5. Tabuk Tornado GR.1 ZD746 / AB Alarm Belle detachment the Gulf war in 1991 6. Tor...
Aircraft decals (military)
Catalogue
£23.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

No Image
Print Scale PSL72392
1:72
LTV A-7 Corsair II. Part 3 1. A-7A BuNo 153206/AC 313 of VA-37/CVW-3, USS Saratoga, June 1972. 2. A-7E BuNo 156833/NG 400 of VA-147/CVW-9, USS Constellation, 1972. 3. A-7B BuNo 154430/NM 411 of VA-215/CVW-19, USS Oriskany, 1971. 4. A-7C BuNo 156794/AJ 302 of VA-82/CVW-8, USS America, 1972.
Aircraft decals (military)
Catalogue
£20.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

No Image
Print Scale PSL72400
Kaman Sea Sprite. 1/72. Part 1 1. UH-2B, 150186, UP38, HC-1, USS Enterprice, 1966. 2. UH-2A, 149030, VH3, HC-7, Atsugi, Japan, 1965. 3. UH-2A, 149024, HC-1, USS Enterprice, 1968. 4. UH-2A, 149742, UP19, HC-1, USS Kitty Hawk, 1966. 5. UH-2A, 149764, Clementine - 2, pilot C.E. Lassen, HC-7, Tonkin Gulf, 1968. 6. UH-2A, 149745, UP3, HU-1, USS Kitty Hawk, 1964. 7. UH-2A, 149756, 55, HC-4, USS Traverse County, 19...
Aircraft decals (military)
Catalogue
£17.30
-
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

No Image
Print Scale PSL72401
Blackburn Buccaneer Part-1 1. Blackburn Buccaneer S.2D. XV866/LM-653 of 736 Squadron. Gloss extra dark sea grey overall with all serial numbers and code in pale blue. Underwing pylons are white. 2. Blackburn Buccaneer S.2. XV344/LM-325 of 809 Squadron during 1969. Gloss finish of extra dark sea grey overall with pale blue serial numbers, codes and ' Royal Navy' titles. 3. Blackburn Buccaneer S.2 . XT287/H-230 of 801 Sq...
Aircraft decals (military)
Catalogue
£19.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

No Image
Print Scale PSL72402
Blackburn Buccaneer Part-2 1. Blackburn Buccaneer S.1. XK533/LM-682 of 700Z Squadron during 1962.Gloss extra dark sea grey and white finish with coding and underwing serial numbers in pale blue.'Royal Navy' title on fin is in black. White fuselage serial number with national insignia being pale red, white and pale blue. Ejection seat markings are pale red whilst nose radome is pale grey/green. 2.Blackburn Buccaneer S.1. XN...
Aircraft decals (military)
Catalogue
£19.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

Print Scale PSL72348
Royal Navy Hawker Hunter 1. Hawker hunter T. Mk.8 XL 580:719 VL of the Air Direction Training Unit, FAA., Yeovilton, September 1970. 2. Hawker hunter T.8 XF 289:738 VL , of Heron Station Flight, Yeovilton, September 1972. 3. Hawker hunter T. Mk 8 C XF 985:811 BY , of 759 Squadron FAA, Brawdy, in the late 1960s. 4. Hawker hunter T. Mk 8 XF 357:634 LM , of 738 Squadron FAA, Lossiemouth, September 1962. 5. Hawker...
Aircraft decals (military)
Catalogue
£15.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

Print Scale PSL48154
McDonnell-Douglas AV-8B Harrier II Part 2 VMA 311 "Tomcats" Marine Aircraft Group 13, 3rd marine Aircraft Wing, MCAS Yuma. VMA 311 "Tomcats" Marine Aircraft Group 13, 3rd marine Aircraft Wing, MCAS Yuma.
Aircraft decals (military)
Catalogue
£17.30
-
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

Print Scale PSL72385
Republic P-47D Thunderbolt 1. P-47C-2-RE "Uncle Den'/'Quack". Unit: 334th FS, 4th FG, 8th AF, USAAF. Serial: QP-L (41-6187) Pilot - Capt.Robert L.Priser 'Junior'. Joined 334th FS on 15th September 1942. Left 23rt November 1943 for Ninth Air Force. Was 'A' Flight CO from 13th September 1943. This was Priser's only aircraft. 2. P-47C-5-RE Sno 41-6538 QP-B 'Wela Kahoe ' of the 334th Fighter Squadron of the 4th Fighter Group,...
Aircraft decals (military)
Catalogue
£15.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

Print Scale PSL72387
1:72
Piasecki Retriever 1. HUP-3 Retriever, 116623, 247, HMCS Labrador, Canada 1955. 2. HUP-3 Retriever, 116622, 622, HMCS Assiniboine, Canada 1963. 3. HUP-2 Retriever, 130078 , 23.S-4, PA La Fayette 1956. 4. HUP-2 Retriever, 130013, 58.S-21, Haiphong, Indochine 1953. 5. HUP-2 Retriever, 128517, 517, NAS Willow Grove PA, USA 1961. 6. HUP-2 Retriever, 128515, 515, NAS Moffett Field, USA 1960. 7. HUP-2 Retriever, 128519, 56UR...
Aircraft decals (military)
Catalogue
£19.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

Print Scale PSL72389
1:72
Grumman S-2 Tracker Part 2 1. Grumman S-2A Tracker VS-22 (BuAer 133277) NAS Key West FL March 1956. 2. Grumman S2A, US Navy, VS-37, CVS-47 USS Philippine Sea, 1956. 3. Grumman S-2A Tracker, US Navy, VS-31, BuAer 133362, CVS-36 USS Antietam, 1957. 4. Grumman S-2A (S2F-1) Tracker (BuAer 136412) on the CVS-37 USS Princeton, 1956. 5. Grumman S-2C Tracker, BuAer 133385, VS-21 NAS Oakland CA, 1959.
Aircraft decals (military)
Catalogue
£15.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

Print Scale PSL72390
1:72
Grumman F-14A Tomcat Part 3 1. F-14A Tomcat BuNo.162592 NF 105 of VF-154 'Black Knights' of Lt Brandon Hammond 'Reggie' and Lt Kevin Sidenstricker 'Catfish'. 2. F-14D Tomcat BuNo.163904 NK 103 of VF-31 'Tomcatters' of LCdr Mark Burgess 'Crunchy' and LCdr Jason Geiger 'Alf'. 3. F-14B Tomcat BuNo.161873 AG 104 of VF-143 'Pukin' Dogs' of Lt Rob Mathewson 'Axle' and LCdr Dean Faller 'Dino'.
Aircraft decals (military)
Catalogue
£15.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

Print Scale PSL72391
1:72
Bristol Beaufighter. Part 2 1. Beaufighter Mk.IF. Unit: 604 Squadron RAuxAF Detachment. Serial: NG-R (T4625). 2. Beaufighter Mk.IIF. Unit: 307 (Polish) Sqn, RAF. Serial: EW-U (T3048). RAF Exeter, UK, circa Autumn 1942. 3. Beaufighter Mk.V. Unit: 29 Sqn, RAF. Serial: RO-O (R2306). RAF West Malling, June/July 1941. 4. Beaufighter Mk.VIF. Unit: 600 Sqn, RAF. Serial: BQ-K (X7887). Predannack, Cornwall, UK, August 1942. 5. Bea...
Aircraft decals (military)
Catalogue
£15.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

Print Scale PSL72393
1:72
Focke-Wulf Fw-190 in Foreign Service 1. FW-190A-3 W.Nr 142310, in which Uffz Helmut Brandt of 2./JG 54 performed a belly-landing in the south-east part of frozen Lake Ladoga on 13 January 1943. 2. FW-190A-8/R6 W.Nr 580967, Which was captured due to Gustav Heuler's desertion to the Soviets in September 1944. 3. NC900A-8 No 28, the next one plane of 'Normandie-Niemen'. 4.FW-190F-8 W.521 'White 21" of 102/2 Vadaszbom-...
Aircraft decals (military)
Catalogue
£15.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

Print Scale PSL72394
1:72
Kamov Ka-25 "Hormone" 1. Ka-25PL (ASW), black 573, Indian Navy 1985. 2. Ka-25PL (ASW), red 36, Ukrainian Navy 1996. 3. Ka-25PL (ASW), red 28, USSR Navy 1968. 4. Ka-25PS (SAR), white 59, USSR Navy 1970. 5. Ka-25C (targeting), red 15, USSR Navy 1972. 6. Ka-25PL (ASW), yellow 55, USSR Navy 1975. 7. Ka-25C (targeting), yellow 54, USSR Navy 1974. 8. Ka-25PL (ASW), red 7511, Vietnam 1971. 9. Ka-25PL (ASW), white 305, Yugosl...
Aircraft decals (military)
Catalogue
£11.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

Print Scale PSL72073
Grumman EA-6B Prowler 1. EA-6B Prowler BuNo. 159584 AB 621 of VAQ-137 'Rooks' 2. EA-6B Prowler BuNo. 160709 AB 500 of VAQ-137 'Rooks' assigned to Capt M. 'Waldo' Wralstad DCAG & Lt J.D. 'Stucky' Tutwiler 3. EA-6B Prowler BuNo. 161779 AB 500 'Rookie' of VAQ-137 'Rooks' assigned to Capt Kenneth Whitesell CAG and LCdr Martin Fuerst 'Duty' 4. EA-6B Prowler BuNo. 163047 AB 501 'Ready on Arrival' of VAQ-137 'Rooks' assi...
Aircraft decals (military)
Catalogue
£15.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

Print Scale PSL48037
Re-printed! Lockheed P-38 Lightning Part 2. 1. P-38j 42-67685 CG-O Journey s End flown by Maj. Joseph Myers Jr. of the 38th FS, 55th FG 2. P-38H-5-LO 42-67060 Skylark lV flown by capt Mark K. 2/Lt Herbert T. of the 8th AF, 5th FG 38th FS 3. P-38H 42-66683 'Pluto' '208' of 12th FS, 18th FG, 13th AF, New Guinea,1943 4. P-38J 42-67928 MC-L Hells Belle flown by 1/Lt. Willard H. Lewis of the 79th FS, 20th FG
Aircraft decals (military)
Catalogue
£17.30
-
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

Print Scale PSL48175
1:48
Savoia-Marchetti SM-79 Sparviero in the Spanish Civil War. The complete set 2 sheets 1. Savoia-Marchetti SM.79 Sparviero (28-11). 2. SM 79 of 10th Squadron, XXVIIth. BV Group. 8th Stormo BV, Palma de Mallorca, Baleares, Spain. December 1937. 3. SM.79. Unit: ? Squadriglia, 25 Gruppo, 21 Stormo 'Pipistrelli', Aviazione Legionaria. Serial: 28-6. 4. SM.79-I. Unit: 52 Esquadrilla, 27 Grupo 'Falchi Delle Baleari'. Serial:...
Aircraft decals (military)
Catalogue
£21.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

Print Scale PSL48176
Polikarpov U-2/Po-2 Part 1 1. Po-2. Unit: Airclub, GST. Serial: DM-WCR. Dresden, 1959. 2. Po-2. Serial: 9. Aircraft of one of the Northern Korean aeroclubs, 1949. 3. U-2. Unit: THK. THK (Turkish Air league) was founded in 1925. Its first name was TTC (Turk Tayyare Cemiyeti = Turkish Airplane Society). The first plane they bought was Polikarpov U-2. Two of them remained in service until 1945. 4. Po-2. Unit: VSJ. Seri...
Aircraft decals (military)
Catalogue
£17.30
-
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

Print Scale PSL48177
Polikarpov U-2/Po-2 Part 2 1. Po-2VS. Unit: 9th GbNBAD. Serial: 28. Mission of Polish rebels supply. September 1944. 2. U-2SP (PS-3). Unit: 62nd Guards air regiment of GVF. Serial: 9. Winter 1943-1944s. 3. U-2VS (LNB). Unit: 242nd NBAD. Serial: 5. Pilot - Hero of the Soviet Union Popova Nadezhda Vasilievna (852 combat missions). 4. U-2VS (LNB). Unit: 46th GvNBAD. Serial: 2 5. U-2. Unit: 2nd Numberless Regiment, 46...
Aircraft decals (military)
Catalogue
£17.30
-
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

Print Scale PSL72009
Mikoyan MiG-21 Fishbed (15) Blue 40; White outline 44; White outline 17; Red 06; White outline 17; Blue 45; Blue 04; Red 57, all Russia; Syria; C1111 India; Iraq; Egypt; Black 1856 first Chinese built; Red 4326; Red 5071, both North Vietnam;
Aircraft decals (military)
Catalogue
£14.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

Print Scale PSL72386
Supermarine Spitfire Aces of Northwest Europe 1944-45 Part 2 1. Spitfire XVI TB900/GE-D of Sqn Ldr R A Lallemant, No 349 (Belgian) Sqn, B106 Twente, Holland, and B113 Varrelbusch, Germany, April-May 1945. 2. Spitfire XVI TB752/KH-Z of Sqn Ldr H P M Zary, No 403 Sqn RCAF, B114 Diepholz, Germany, April-June 1945. 3. Spitfire XVI TD 246/ GRM of Gp Capt G R McGregor, No 126 Wing, B116 Wunstorf and B152 Fassburg, Germany, July-A...
Aircraft decals (military)
Catalogue
£15.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

Print Scale PSL72388
1:72
Savoia-Marchetti SM-79 in the Spanish Civil War 1. Savoia-Marchetti SM.79 Sparviero (28-11). 2. SM 79 of 10th Squadron, XXVIIth. BV Group. 8th Stormo BV, Palma de Mallorca, Baleares, Spain. December 1937. 3. SM.79. Unit: ? Squadriglia, 25 Gruppo, 21 Stormo 'Pipistrelli', Aviazione Legionaria. Serial: 28-6. 4. SM.79-I. Unit: 52 Esquadrilla, 27 Grupo 'Falchi Delle Baleari'. Serial: 5.
Aircraft decals (military)
Catalogue
£15.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

Print Scale PSL48150
Silver Republic F-105D Thunderchiefs in the Vietnam War Part-1 1. F-105D-25-RE, Serial 61-0217, of the 12th TFS/18th TFW, Korat RTAFB, Thailand, March 1968. 2. F-105D-25-RE, Serial 61-0143 of the 354th TFS/355th TFW Takhli RTAFB, Thailand, April 1965. 3. F-105D-20-RE, Serial 61-0116 of the 562nd TFS/23rd TFW (6235th TFW), Takhli RTAFB, Thailand, September 1965.
Aircraft decals (military)
Catalogue
£17.30
-
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

Print Scale PSL48041
1:48
Panavia Tornado Gr.4/Gr.4a Part 2
Aircraft decals (military)
Catalogue
£23.99
Out of Stock
0

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

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