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 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 139 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

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 ANIG2022
1:72
Sikorsky S-67 In 1964, U.S. Army lunched the AAFSS specification, that calling for an aircraft with a high-speed cruising and long-time hovering capability. Sikorsky submitted the S-66 pusher tail rotor project that competitor with Lockheed AH-56 Cheyenne. The AH-56 won the contest but failed to meet the expectations. For intended to replace the AH-56, Sikorsky self-venture developed a simplified AAFSS that used a number of ex...
Aircraft kits (resin)
Catalogue
£57.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 ANIG2039
1:72
North-American YF-93A. In 1946, USAF recognized all the early jet fighters were lacked sufficient range to escort bombers to the target. So the proposal for a penetration fighter were requested. In 1947, North-American responded with the proposal for a revised version of North-American F-86A, which the fuselage size was enlarged for bigger internal fuel tanks to increase its range. The extra fuel increased weight so the more p...
Aircraft kits (resin)
Catalogue
£47.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

Anigrand Craftswork ANIG2135
Kugisho MXY-6 Test-bed of the Kyushu J7W Shinden. In 1943, the IJN issued an 18-shi specification for a new interceptor. Kyushu submitted a design with canard foreplanes, the J7W Shinden. Despite some opposition to the design, the IJN was intrigued enough to accept the proposal. However, the design had to show promise and the canard configuration needed to be proven before the IJN would authorise further development. Therefore...
Aircraft kits (resin)
Catalogue
£67.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

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 ANIG5006
Martin-Boeing XMS-1. Original Dyna-Soar configuration. In 1945, millions of German military documents were confiscated by USAAF. One of the concept was the Sanger aerospace bomber. During post-war years, Bell was selected for further studies on rocket-bomber which named BoMi. In 1956, the USAF channeled Bell's development to a reconnaissance, bombardment vehicle. A competition for a prototype was opened. In 1959, Boeing won th...
Space 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 ANIG2119
1:72
VFW-Fokker VAK-191B German vector thrust VTOL. In 1962, the West German government launched an requirement for the new ground attack fighter to replace the Fiat G.91. In the meantime NATO had launched a program for VTOL combat aircrafts. The Germans decided to work on the second VTOL fighter. After consideration of various options, the effort focused on the Focke-Wulf Fw.1262 design. This was further developed in a partnership...
Aircraft kits (resin)
Catalogue
£73.80
-
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 ANIG2128
Budd C-93/RB-1 Conestoga. In 1941, the U.S. War Department required for a twin-engine transport comparable in performance to the Douglas C-47, to be constructed of "non-strategic materials". At the time, U.S. government feared that the thousands of new aircraft needed for the war effort might create shortages of aluminum alloys. Sprang from this requirement, the Curtiss C-76 and Fairchild C-82 were to be constructed of wood. A...
Aircraft kits (resin)
Catalogue
£98.69
-
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 ANIG2137
1:72
Sikorsky XPBS-1 flying boat Patrol bomber . In 1935, the US Navy initiated development of a new patrol bomber larger than the PBY Catalina that would have increased performance and weapon load capability. Consolidated and Sikorsky submitted proposals, and each received order for two prototypes as the XPB2Y-1 and XPBS-1. Both the prototypes first flew in 1937 but the Navy did not have funds at that time to procure the aircraft....
Aircraft kits (resin)
Catalogue
£167.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 ANIG2130
1:72
McDonnell Model 119 UCX prototype compete with C-140 Jetstar. In 1956, the USAF issued requirement for a utility transport that used to accomplish the combat flight inspection and navigation mission. Due to the budget cuts, the Air Force asked the industry-financed "off-the-shelf" prototypes. McDonnell submitted company's Model 119 for a small, 4-jets, multi-purpose, ulitity airplane. It will be capable of going anywhere in th...
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 ANIG2138
1:72
BAE Tempest II RAF fifth generation fighter project. In 2018, U.K. Ministry of Defense has unveiled the Tempest II model at the Farnborough show, new plans for a new stealth fighter jet. Tempest II is a proposed stealth fighter aircraft concept to be designed and manufactured in the United Kingdom for the Royal Air Force. It is being developed by a consortium known as "Team Tempest," consisting of the UK Ministry of Defence, B...
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 ANIG2134
1:72
Columbia XJL-1 flying boat. In June 1939, Grumman intended to update their J2F Duck biplane to an all-metal monoplane as a replacement for the United States Navy. The aircraft was assigned the G-42. However due to increased production pressures for other Grumman fighter aircraft, the project of prototype and test was turned over to the Columbia Aircraft Company which was already under a production contract for J2F-6 Ducks. Thr...
Aircraft kits (resin)
Catalogue
£77.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 ANIG2118
1:72
Fairchild C-82A Packet World's first twin-boom transport aircraft. During outbreak of War World II, the mainstay of cargo freight operations in USAAF was catered by the C-47 Dakota, C-46 Commando and the C-54 Skymaster but they were built as pre-war civil passenger aircraft, not as dedicated cargo aircraft. In 1941, USAAF issued requirement for a large capacity cargo transport aircraft. Fairchild responded with a submission by...
Aircraft kits (resin)
Catalogue
£147.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 ANIG2113
Martin M-130 China Clipper. U.S. Navy transport for the Manhattan Project. In early 1930s, Pan Am requested for a flying boat with capability that could fly across the ocean. Martin's bid of Model-130 was successful. In 1934, three M-130 were built as Martin Ocean Transports, but to the public thay were all referred as the China Clipper. On November 1935, the China Clipper flew the first trans-Pacific airmail route. Their rang...
Aircraft kits (resin)
Catalogue
£167.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

   1   |   2   |   3   |   4   |   5      »      [6]

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