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=8069 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 48 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
Italeri IT2803
1:48
McDonnell F-15E Strike Eagle NEW PARTS - SUPER DECALS SHEET FOR 6 VERSIONS - COLOR INSTRUCTION SHEET FIGURE NOT INCLUDED - CONTAINS 1 MODEL The McDonnell Douglas F-15 Eagle design was initiated in the 1970s to equip the United States Air Force fighter squadrons with an advanced and high-performance jet fighter. The effective and robust aerodynamically design lay-out led to production of the two-seat "all-weather" F-15E Stri...
Aircraft kits (injection)
Catalogue
£44.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

Italeri IT2797
1:48
LTV A-7E Corsair II ORIGINALS MOULDS FROM ESCI - SUPER DECALS SHEET FOR 4 VERSIONS The LTV A-7 Corsair II was designed and implemented in the first half of the 1960s to satisfy the specific United States Navy request to have a new carrier-capable light attack aircraft able to replace the Douglas A-4 Skyhawk and the piston-powered Douglas A-1 Skyraider. It was directly developed by the fighter Vought F-8 Crusade airframe. Th...
Aircraft kits (injection)
Catalogue
£35.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
Italeri IT2767
Macchi C.200 XXI Series FIGURE NOT INCLUDED - CONTAINS ONE MODEL Designed by the celebre engineer Mario Castoldi, the Macchi MC 200 has represented a significant production evolution of the Italian fighter aircrafts. Compared to the biplanes Fiat CR 32 and Fiat CR 42 that were the main Italian fighters squadrons structure at the beginning of the Second World War, the Macchi MC 200 distinguished itself, together with its co...
Aircraft kits (injection)
Catalogue
£34.99
£31.49
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

No Image
Italeri IT2828
Hawker Hurricane MK.IIC SUPER DECALS SHEET FOR 6 VERSIONS - COLOR INSTRUCTION SHEET - PHOTO-ETCHED PARTS The Hawker Hurricane was the most common and most widely used fighter of the British Royal Air Force at the start of the Second World War. It contributed significantly to the ultimate victory of the R.A.F. during the Battle of Britain, but over the course of the war it was progressively superseded in its front-line fight...
Aircraft kits (injection)
Catalogue
£34.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
Italeri IT2824
1:48
Boeing EA-18G Growler COLOR INSTRUCTION SHEET - SUPER DECALS SHEET FOR 3 VERSIONS FIGURE NOT INCLUDED The Boeing EA-18 G Growler was designed to fulfill a specific U.S. Navy requirement. The aim was to commission a specialized carrier-based electronic warfare aircraft to replace the outdated Grumman EA-6B Prowler. The Growler is directly derived from the tandem-seat fighter F/A-18 F Super Hornet and retains all of its ma...
Aircraft kits (injection)
Catalogue
£42.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
Italeri IT2826
Douglas A-4E/F/G Skyhawk SUPER DECALS SHEET FOR 6 VERSIONS - COLOR INSTRUCTION SHEET The Douglas A-4 Skyhawk was developed in the 1950s and was one of the most famous light attack aircraft in the aviation history. Its small and compact dimensions made it extremely maneuverable and ideal for use on the aircraft carriers. It was characterized by the low-mounted delta wing solution, the two small air intakes on the fuselage si...
Aircraft kits (injection)
Catalogue
£34.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
Italeri IT2825
Lockheed-Martin F-16C Fighting Falcon
Aircraft kits (injection)
Catalogue
£34.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
Italeri IT2819
Henschel Hs-123 UPER DECALS SHEET FOR 6 VERSIONS - COLORS INSTRUCTIONS SHEET FIGURE NOT INCLUDED During the 1930s Henschel were tasked to design and build a ground attack aircraft that could provide support to ground troops. This led to the creation of the robust Henschel Hs-123 biplane, which was supplied to flying Squadrons in 1935. The first operational deployment of the aircraft took place during the Spanish Civil W...
Aircraft kits (injection)
Catalogue
£29.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
Italeri IT2818
McDonnell RF-4E Phantom II
Aircraft kits (injection)
Catalogue
£39.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
Italeri IT2774
Piasecki H-21C Flying Banana Gunship NEW PARTS - SUPER DECALS SHEET FOR 5 VERSIONS - PHOTO ETCHED PARTS - COLOR INSTRUCTIONS SHEET FIGURE NOT INCLUDED The H-21 Shawnee helicopter is best known for its nickname "the flying banana", which derives from the peculiar upward angle of the aft fuselage. The fuselage, uniquely designed in this novel way, was developed to accommodate the two powerful tandem rotors and the oversi...
Aircraft kits (injection)
Catalogue
£49.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
Italeri IT2823
Boeing F/A-18F Hornet U.S. Navy Special Colors
Aircraft kits (injection)
Catalogue
£44.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

Italeri IT2720
1:48
Westland Wessex HU.5 New Tooling in 2014 See Xtradecal X48110 for decal options.
Aircraft kits (injection)
Catalogue
£44.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
Italeri IT2810
Lockheed-Martin F-35B Lightning II (New Tooling)
Aircraft kits (injection)
Catalogue
£75.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
Italeri IT2822
Lockheed-Martin F-22A Raptor SUPER DECALS SHEET FOR 3 VERSIONS - COLOR INSTRUCTION SHEET FIGURE NOT INCLUDED The Lockheed Martin-Boeing F-22 is a 5th generation USAF stealth fighter aircraft. Extremely innovative in concept and design, the "Raptor" is equipped with two Pratt & Whitney F119 turbofan engines, with afterburners capable of generating vector thrust via its exhaust nozzles. The "stealth" capability is provided...
Aircraft kits (injection)
Catalogue
£29.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
Italeri IT2804
Supermarine Spitfire Mk.IX SUPER DECALS SHEET FOR 4 VERSIONS - COLOR INSTRUCTIONS SHEET FIGURE NOT INCLUDED - CONTAINS 1 MODEL The Supermarine Spitfire is considered to be one of the most famous fighter aircraft in aviation history and an "icon" of British aeronautical production. The well-armed low-wing single-engine aircraft along with the Hawker Hurricane, formed the backbone of the Royal Air Force fighter units engag...
Aircraft kits (injection)
Catalogue
£29.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
Italeri IT2815
Macchi MC-200 Designed by the celebre engineer Mario Castoldi, the Macchi MC 200 has represented a significant production evolution of the Italian fighter aircrafts. Compared to the biplanes Fiat CR 32 and Fiat CR 42 that were the main Italian fighters squadrons structure at the beginning of the Second World War, the Macchi MC 200 distinguished itself, together with its contemporary Fiat G50, for its monoplane configuration an...
Aircraft kits (injection)
Catalogue
£32.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
Italeri IT2813
1:48
BAe HAwk T Mk.1 The Hawk T Mk 1 was developed by Hawker Siddeley, today part of BAE Systems, to equip the Royal Air Force training units in the second half of the 1970's. The Royal Air Force specific requirement was to have a new updated jet trainer to replace the old Folland Gnat. The advanced-trainer Hawk was characterized by a great maneuverability and thanks to its Rolls-Royce Adour turbofan engine was able to reach the ma...
Aircraft kits (injection)
Catalogue
£34.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
Italeri IT2820
Bell OH-13 Sioux SUPER DECALS SHEET FOR 6 VERSIONS - COLORS INSTRUCTIONS SHEET FIGURES NOT INCLUDED The American Bell OH-13 is one of the most iconic helicopters in aviation history. Developed immediately after the Second World War, it was distributed to the U.S. Army in the late 1940s. The "Sioux" was characterized by its distinctive "soap bubble canopy" which made it unique and easily recognizable along with the tail t...
Aircraft kits (injection)
Catalogue
£24.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
Italeri IT2814
1:48
Aermacchi MB-326 SUPER DECALS SHEET FOR 4 VERSIONS - COLORS INSTRUCTIONS SHEET FIGURES NOT INCLUDED The Macchi MB-326 was developed during the 1950s to equip the training "Stormi" of the Italian Air Force. The initial units of the new Macchi two-seat low-wing trainer were delivered in 1961, and immediately proved to be a technically excellent aircraft with good flight and operational characteristics. Easily recognizable ...
Aircraft kits (injection)
Catalogue
£29.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

Italeri IT2623
Lockheed S-3A/B Viking. SUPER DECALS SHEET FOR 3 VERSIONS FIGURE NOT INCLUDED The S-3 Viking is the American Marines' standard anti-submarine aircraft for shipborn used since the mid-70s. This big twin-jet plane is equipped with cutting-edge electronics to control sea missions and surveillance in close contact with ships and helicopters entrusted to protect aircraft-carriers. Viking II has an ample range, thanks to in-fl...
Aircraft kits (injection)
Catalogue
£47.99
-
In Stock
7

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Italeri IT2691
German Aircraft Weapons WWII
Aircraft kits (injection)
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
Italeri IT2805
Messerschmitt Bf-109K-4 SUPER DECALS SHEET FOR 4 VERSIONS - COLOR INSTRUCTIONS SHEET FIGURE NOT INCLUDED - CONTAINS ONE MODEL The Messerschmitt Bf-109 is undoubtedly one of the best-known fighters of the Second World War and is considered an iconic aircraft of the German Luftwaffe. During the conflict the engines and armaments were regularly upgraded to be kept in line with the emerging, more modern enemy fighters. The B...
Aircraft kits (injection)
Catalogue
£29.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

No Image
Italeri IT2801
1:48
Fiat CR.42 "Falco" "Battle of Britain 80th Anniversary"
Aircraft kits (injection)
Catalogue
£29.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
Italeri IT2808
Opel Blitz Kfz.385 Tankwagen DECALS SHEET FOR 4 VERSIONS - COLOR INSTRUCTION SHEET FIGURES NOT INCLUDED - AIRCRAFTS NOT INCLUDED The Opel Blitz was the main truck used by German forces during the Second World War. It was deployed extensively on all fronts in huge numbers, and was consequently considered to be the "working mule" of the Wehrmacht. Thanks to the sturdy frame, the robust system of rigid axles with leaf sprin...
Military vehicle kits (injection)
Catalogue
£32.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
Italeri IT2807
1:48
Junkers Ju-87B 'Stuka' 80th Anniversary of the Battle of Britain. SUPER DECALS SHEET FOR 4 VERSIONS - PHOTO ETCHED FRET - COLOR INSTRUCTIONS SHEET FIGURE NOT INCLUDED - CONTAINS ONE MODEL The Junkers Ju-87 'Stuka' was a two-seat dive-bomber/ground-attack aircraft. The 'Stuka' first flew in 1935 and made its combat debut in 1936 as part of the Condor Legion during the Spanish Civil War . The aircraft was easily recognizab...
Aircraft kits (injection)
Catalogue
£34.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