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=7916 AND ps.id = 957 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 55 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

Anigrand Craftswork ANIG4010
Nakajima G10N1 Fukagu. Also includes BONUS kits of the Mansyu Ki-98, Kawanishi Baika, Mizuno Shinryu. WAS é£87.99. NOW BEING CLEARED!! SAVE 1/3RD!!! In 1943, as the war situation worsened, Nakajima sought to develop a very long-range, super heavy bomber which could be able to carry 11000 lbs bomb load into U.S. air-field, where they could mount bombing raids against targets along America's western seaboard. The project in-hous...
Aircraft kits (resin)
Catalogue
£58.68
-
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

Anigrand Craftswork ANIG4101
Northrop YRB-49A (includes these BONUS kits Hughes XV-9A Hot cycle, MSU XV-11A Marvel and Ryan VZ-3RY) In June 1948, after the flight test of the YB-49 was proved, the U.S. Air Force ordered the type into full production as the RB-49A reconnaissance aircraft. It was powered by six jet engines, two of them externally mounted in under-wing pods, ruining the aircraft's sleek, aerodynamic lines, but extending its range by carrying...
Aircraft kits (resin)
Catalogue
£87.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

Anigrand Craftswork ANIG4002
Myasishchev M-50 Bounder. Also includes BONUS kits of the Sukhoi Su-15, Lavochkin La-250 and MiG Ye-152 In 1955, the USSR Council of Ministers was spurred by the thread from the U.S. XB-70 bomber which was designed for Mach-3, but this was considered an impossible objective for the Soviet Union at that time. As the Myasishchev OKB was striving to develop the huge 3M subsonic bomber, this design bureau was assigned the addition...
Aircraft kits (resin)
Catalogue
£87.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

Anigrand Craftswork ANIG4021
Douglas XB-19 / XB-19A Hemi-sphere Defender. Also includes BONUS kits of the Tucker XP-57, Bell XP-59A Airacomet and Curtiss XP-60C. In 1935, the USAAC launched a top secret project for a super long-range 'Project-D' bomber. The Army issued contracts for preliminary design to two aircraft companies, which were designated as Douglas XBLR-2 and Sikorsky XBLR-3. In 1936, the mockups of two designs were inspected. The Douglas prop...
Aircraft kits (resin)
Catalogue
£117.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

Anigrand Craftswork ANIG3007
Century Fighters Special set. Republic XF-103 Thunderwarrior / North-American YF-107A Ultra Sabre / North-American XF-108 Rapier / Bell XF-109 McDonnell / F-110A (McDonnell F-4C) Spectre
Aircraft kits (resin)
Catalogue
£77.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

Anigrand Craftswork ANIG4051
Convair XP5Y-1 Tradewind Includes bonus kits of the Convair XF2Y-1 Sea Dart, Douglas F3D-2 Skyknight, Douglas XA2D-1 Skyshark. In 1944, the U.S. Navy asked the industries to enter a design competition for a 105,000 pound patrol boat powered by four radials. At the end of the war, two Blohm-und-Voss Bv.222 flying boats were captured by U.S. forces. Convair acquired one for evaluation at Naval Air Station, the intensive studies ...
Aircraft kits (resin)
Catalogue
£87.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

Anigrand Craftswork ANIG3003
Sound Barrier Breakers set of 6 aircraft. Including Bell X-1, Bell X-2, Douglas X-3 Stiletto, Douglas D558-1 Skystreak, Douglas D558-2 Skyrocket, Douglas D558-3 Skyflash.
Aircraft kits (resin)
Catalogue
£67.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

Anigrand Craftswork ANIG3009
1:144
Japanese experimental defensive airplanes special set vol.2 - Imperial Japan Army. Includes Mitsubishi Ki-109 / Rikugun Ki-93 / Kawasaki Ki-103B Randy / Mitsubishi Ki-167 Mitsubishi Ki-109 - A heavy fighter that was to be used against the American B-29s at high altitude, but the Allied began making night raids at low altitude. The Ki-109 was no longer needed. Kawasaki Ki-102b - A ground-attack fighter that similar to prot...
Aircraft kits (resin)
Catalogue
£87.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

Anigrand Craftswork ANIG4019
1:144
Kawasaki Ki-9 1 Also includes BONUS kits of the Kayaba Katsuodori, Nakajima Ki-201 and Kawasaki Ki-108. In early 1943, as the war situation worsened, Nakajima had to develop a very long-range Fugaku bomber which could be able to mount bombing raids against targets along America's western seaboard. The Fugaku project impressed the Japanese Army and Navy. However, it was deemed too complex, and would not be available in service....
Aircraft kits (resin)
Catalogue
£87.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

Anigrand Craftswork ANIG3008
1:144
Experimental defensive airplanes special set vol.1 - Imperial Japan Navy. Includes Mitsubishi Q2M1 Taiyo / Aichi S1A1 Denko / Nakajima J5N1 Tenrai / Kawanishi J6K1 Jinpu. Aichi S1A-1 Denko - A night-fighter was requested by Navy that intended to replace the Nakajima J1N Gekko, filling the role of a radar-eqquipped airplane to combat the American B-29 raids. Two prototypes were constructed in 1945, but were destroyed durin...
Aircraft kits (resin)
Catalogue
£87.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

Anigrand Craftswork ANIG4096
1:144
Sikorsky JR2S-1 / VS-44A flying boat. Bonus kits included are Beechcraft XA-38 Grizzly, Platt-LePage XR-1 and Cornelius
Aircraft kits (resin)
Catalogue
£87.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

Anigrand Craftswork ANIG4046
1:144
Convair XB-46. Includes BONUS kits of the North-American B-45A Panavia Tornado, Northrop F-89B Scorpion and Ryan XV-5A Vertifan. In 1944, with the success of the German jet bomber Arado Ar-234, U.S. war department was aware of aviation advance in the enemy. So a requirement for a new design of the jet bomber which tactical radius could cover 1000-miles was issued. Convair (Consolidated Vultee Aircraft) submitted the Model 109 ...
Aircraft kits (resin)
Catalogue
£77.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

Anigrand Craftswork ANIG4045
1:144
Junkers EF-132 . Final jet bomber captured by Russian. Includes BONUS kits of the Lippisch Li.P12 Entwurf III, Focke-Wulf P.0310251-1006 Victoria tail, Messerschmitt Me.P1106 and Heinkel WESPE. In the autumn of 1944 Reichsmarschall Goring instructed the Junkers and Messerschmitt works to design and produce the very long-range bombers which would be capable of delivering 4000kg bomb load, at high speeds and over extreme distanc...
Aircraft kits (resin)
Catalogue
£87.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

Anigrand Craftswork ANIG4062
1:144
Boeing XCH-62 HLH Heavy lift helicopter program. Includes BONUS aircraft of the Sikorsky CH-54A Skycrane, Fairchild VZ-5 Fledgling and Cessna YH-41 Seneca. In 1967, the Soviet Mil V-12 helicopter made its first lift-off successfully. The U.S. military had an urge to match or top this heavy-lift helicopter. In early 1970, a joint Army and Navy working committee was formed to study the development of a heavy lift helicopter. The...
Aircraft kits (resin)
Catalogue
£87.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

Anigrand Craftswork ANIG4105
1:144
McDonnell YC-15 Includes these BONUS kits North-American T-30 Sabreliner, Northrop YC-125 Raider and Rockwell XFV-12A)
Aircraft kits (resin)
Catalogue
£87.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

Anigrand Craftswork ANIG4059
1:144
Boeing XB-59 Alternation of the Convair B-58 Hustler. Includes bonus kits of North-American X-15, XF-91 Thunderceptor & T-28 Trojan. In May 1947, the U.S. War Department issued a requirement to the industries for a new jet-powered supersonic bomber that would be ready for service by the late 1950s. A number of contractors submitted bids. The USAF chose Convair XB-58 and Boeing XB-59 to proceed with a Phase-I study. The basic X...
Aircraft kits (resin)
Catalogue
£87.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

Anigrand Craftswork ANIG4104
1:144
Boeing YC-14 STOL prototype to replace the C-130 Hercules. (includes these BONUS kits Bell X-16, McCulloch YH-30 and Lockheed YO-3A) In 1972, the U.S. Air Force issued the Advanced transport STOL transport program for a new medium airlifter that capable of operations into battle zones with short, temporary airfields. Two proposals were accepted for construction as the Boeing YC-14 and McDonnell-Douglas YC-15 prototypes. The Bo...
Aircraft kits (resin)
Catalogue
£87.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

Anigrand Craftswork ANIG4089
1:144
Short Shetland flying boat(bonus kits: G.A.L. Twin Hotspur, Miles Magister with Articulated trailer wing & Martin-Baker MB.5). In 1941, the Bristish Air Ministry issued an requirement for a heavy defensive armament, long range flying boat that intended to replace the Short Sunderland. Saunders-Roe propsed S.41 to the Air Ministry, and was asked to combine the project with Short's proposal. The detailed design was performed by ...
Aircraft kits (resin)
Catalogue
£97.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

Anigrand Craftswork ANIG4083
Handley-Page Halifax B Mk.I. Includes BONUS kits of the GAL.56/04, Miles M.30 X-Minor and Avro Rota. Main RAF heavy bomber other than Lancaster. In 1936, when the British Air Ministry issued Specification B.12/36 which called for a conventional design which could operate from existing airfields but have a range of not less than 3,000 miles and carry a bomb load in excess of 8,000 lbs. In all 19 aircraft manufacturers were advi...
Aircraft kits (resin)
Catalogue
£87.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

Anigrand Craftswork ANIG4097
1:144
Xian Y-20 Kunpeng. Three bonus kits included are: Chngdou J-10B fighter, Shenyang J-31 Gyrfalcon stealth fighter and Guizhou Soar Dragon UAV. In 2006, China government launched a Y-XX program for the development of large transport aircraft to meet its military modernization drive by 2015. Two major Chinese aviation companies Shaanxi Aircraft Corporation and Xi'an Aircraft Corporation expressed interest to develop the Y-XX airc...
Aircraft kits (resin)
Catalogue
£97.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

Anigrand Craftswork ANIG3010
1:144
German experimental VTOL aircrafts special set Dornier Do-29 / VAK.191B / VJ.101C / Do-31. In late 1950's, the West Germany issued a requirement for the VTOL fighter, attack and transport aircrafts programme. The idea being that in case of Soviet attack, the VTOL would support dispersal of combat aircraft assets to small and easy concealed operation base. A renewed interest in STOL and VTOL aircraft led to a re-evaluation of F...
Aircraft kits (resin)
Catalogue
£87.99
£79.19
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

Anigrand Craftswork ANIG4095
1:144
Lockheed SR-95 Penetrator plus bonus kits: Lockheed Have Blue, Lockheed Hopeless Diamond and Northrop XST. Beginning in the mid-1980s, the U.S. Air Force and NASA have supported a number of studies of aircraft that are consistent with accounts of the Aurora reconnaissance aircraft project, the proposed successor to the SR-71 Blackbird which would retired in 1999. While various sources disclosed that Lockheed's secret Skunk Wor...
Aircraft kits (resin)
Catalogue
£87.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

Anigrand Craftswork ANIG4077
Messerschmitt Me-321 Gigant. Heavy glider for invasion of Britain & Russia. Includes bonus kits of the Gotha Go.50 / Lippisch Glider-bomber / He.111Z Zwilling / DFS DFS-230. In 1940, due to the preparations for the invasion of Britain and Russia, the Luftwaffe's Transport Command realized a need for a larger capacity cargo and troop carrying aircraft. It was decided that the most cost-effective solution was to use giant glider...
Aircraft kits (resin)
Catalogue
£97.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

Anigrand Craftswork ANIG4086
1:144
BMW Schnellbomber P.II. Includes BONUS kits of the Messerschmitt Me.1111, Arado Ar.E.530, Blohm and Voss Bv.P.192 and Messerschmitt Me.1019-16. Long range Forward-swept wing bomber. In 1944, Reichsmarschall Goring instructed the Messerschmitt and Junkers to design and produce very long-range bombers which would be capable of carrying a 4,000 kg bomb load, at high speeds and over extreme distances, to mount strategic air stri...
Aircraft kits (resin)
Catalogue
£77.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

Anigrand Craftswork ANIG4085
1:144
Vickers Windsor Includes these bonus kits Handley-Page HP.75 Manx, Baynes Bat, Vickers Type-432. In 1941, the Bristish Air Ministry issued an requirement for a high-altitude bomber with a pressurised crew compartment. By the time Vickers was already working on a experimental Wellingtion with pressure cabin nose. They submitted Type 447 proposal to Air Ministry, and was received contract for three Windsor prototypes plus two B....
Aircraft kits (resin)
Catalogue
£87.99
-
In Stock
2

   1   |   2   |   3      »      [3]

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