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_category_id = 108 
		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
Limited Availability | Hannants
Hannants News Feed Subscribe To This Search | Create Search Alert Create Search Notification

Limited Availability



Found 6,710 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

Scale

Product Type

Manufacturer

Added Within

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 ANIG2093
1:72
Lockheed C-140A Jetstar Rapid jet transport
Aircraft kits (resin)
Limited Availability
£67.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 ANIG2099
1:72
North-American T-39A Sabreliner. In mid-1950s, the USAF launched a Utility Trainer Experimental (UTX) programme for a small, multi-engine jet that would function primarily as a crew trainer. The North-American offered its in house project, model NA-265 to the USAF. Its leading edge slats, swept-back wing and tail gave it a strong resemblance to the F-86 Sabre Jet and the F-100 Super Sabre. The design received the name Sabrelin...
Aircraft kits (resin)
Limited Availability
£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 ANIG2101
1:72
Mitsubishi ATD-X Shinshin Japan stealth fighter demonstrator.At the beginning of the 21st century, JASDF seeking to replace its aging fleet of fighter aircraft, began making overtures to the United States on the topic of purchasing several F-22 Raptors for their own forces. However the U.S. Congress had banned the exporting of the aircraft in order to safeguard secrets of the aircraft's technology such as its extensive use of ...
Aircraft kits (resin)
Limited Availability
£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 ANIG2126
1:72
McDonnell YC-15 STOL prototype to form the C-17 Globemaster. In 1972, the U.S. Air Force issued the Advanced 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. McDonnell Douglas's design incorporated a supercritical wing, the result of NASA researc...
Aircraft kits (resin)
Limited Availability
£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 ANIG2129
1:72
Dornier Do-29 Tilt-rotor experiment. In 1941, the Reich Air Ministry issued design study order to Focke-Achgelis for a fighter which would combine the VTOL capabilities of a helicopter. The Fa 269 full-scale mock-up was built to demonstrate the concept, but was destroyed by Allied bombing raids and all work was shelved in 1944. In the 1950s, a renewed interest in VTOL aircraft led to a re-evaluation of Fa 269 concept, and Dorn...
Aircraft kits (resin)
Limited Availability
£57.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 ANIG2136
1:72
Curtiss YC-76 Caravan Experimental all-wood transport. 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. The Curtiss proposal, submitted as the Model CW-27, utilizing wood con...
Aircraft kits (resin)
Limited Availability
£147.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 ANIG4003
1:144
Convair YB-60. ALSO includes 1 kit each of the XF-90, XF-88A Voodoo and YF-93 Sabre. In 1941, the USAAF begun the Convair B-36 program since it might need to conduct strategic bombing of Europe from USA. However, the XB-36 maiden flight did not occur until 1946. Still the USAAF wanted a much faster jet bomber, a specification for a new bomber to replace the B-36 was issued. Boeing responded with the Model 462, and was received...
Aircraft kits (resin)
Limited Availability
£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 ANIG4009
Northrop YB-49 flying wing. Also includes BONUS kits of the McDonnell FH-1, Douglas XB-43 and Bell XP-83. In 1941, as Britain fall to German invasion was seemed imminent, the USAAC opened up a competition for a very long-range bomber that would have to reach Europe directly from North America. Northrop and Consolidated were selected for the development of two prototypes that designated the XB-35 and XB-36. Numerous technical p...
Aircraft kits (resin)
Limited Availability
£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 ANIG4011
1:144
Dornier-Stratospharen Haunebu II. Also includes BONUS kits of the BMW Flugelrad I, BMW Flugelrad II, Sack As-6, Vril RFZ-5 Haunebu I. In 1935, a mysterious group, Vril was found in Northwest Germany that was to develop a series of flying disc. The disc crafts were to be installed by a revolutionary electro-magnetic-gravitic engine that powered the rotating disc wing or internal disc blade. In 1939, A several of prototypes were...
Aircraft kits (resin)
Limited Availability
£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 ANIG4012
1:144
Republic XF-12 Rainbow.ALSO includes 1 kit each of the Beech F-2A, Hughes XF-11 and Northrop XF-15 Reporter. In 1943, the USAAF had an urgent need to fly photo-reconnaissance missions over the Pacific Theater to identify Japanese positions and movements. However, the airfields were far too distant for the medium-range planes to make the round trip. The request for a new long-range, high altitude reconn. plane capable of the lo...
Aircraft kits (resin)
Limited Availability
£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 ANIG4016
1:144
Martin XB-16 Winged whale, dream design of 1930s. Also includes BONUS kits of the Grumman J2F-5 Duck, Lockheed XP-49, Grumman XP-50. In 1933, the US Material Division at Wright field began a study for a modern bomber that would able to carry 2500-lb bomb load form 5000 miles and 200mph. This specification was then submitted to the War Department as 'Project-A' and received tentative approval. In 1934, the USAAC began contract ...
Aircraft kits (resin)
Limited Availability
£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 ANIG4018
1:144
Horton Ho-XVIII Also includes BONUS kits of the Junkers EF 130, Blohm-und-Voss Bv-P.217, Lippisch Li P.04-106 and Messerschmitt Me P.334. In early 1930s, Horten brothers had interested in the flying-wing design as a method of improving the performance of airplane. Several Horten flying-wing gliders were built and tested. In 1943, Reichsmarschall Goring issued a request for the design proposals to produce a fighter/bomber that ...
Aircraft kits (resin)
Limited Availability
£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 ANIG4022
1:144
Yakovlev Yak-17 Feather, Cheranovski Ch-26 and Lavochkin La-15 Fantail Also includes BONUS kits of the Antonov An-22 Antei . In late 1950s, the Soviet leadership need a new cargo-lifter aircraft to carry cargoes to the underdeveloped areas of the northern USSR, Siberia and the Far East. Based on the experience acquired building the An-10 and the An-12 which were used as airliners and military transport, the Antonov design bure...
Aircraft kits (resin)
Limited Availability
£127.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 ANIG4031
Douglas XB-31 Raidmaster. Also includes BONUS kits of the Vultee XP-54 Swoose Goose, Curtiss-Wright XP-55 Ascender and Northrop XP-56 Black Bullet. 4 (YES FOUR) superb resin kits!!! In 1939, the USAAC issued a requirement for a new medium bomber which could operate at high-altitude to avoid attack from ground fire. Preliminary designs were submitted by Martin and North-American. The Martin XB-33 was redesigned from the B-26 ...
Aircraft kits (resin)
Limited Availability
£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 ANIG4033
1:144
Martin XB-33A Super Marauder. Also includes BONUS kits of the Lockheed PV-1 Ventura, Douglas A-20B Havoc and Curtiss XP-71. In 1939, the USAAC issued a requirement for a new medium bomber which could operate at high-altitude to avoid attack from ground fire. Preliminary designs were submitted by Martin and North-American. The Martin XB-33 was redesigned from the B-26 Marauder, and North-American XB-28 was based from the North-...
Aircraft kits (resin)
Limited Availability
£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 ANIG4042
1:144
Myasishchev 3MD Bison-B/C. Also includes BONUS kits of the Yakovlev Yak-27K Flashlight, Yakovlev Yak-28-64 and Tysbin LL-3. Aircraft History and Specification. In 1946, the USAF launched a program of the Boeing B-52 Stratofortress long-range bomber capable of carrying out the strategic mission. The USSR prompted to maintain the strategic balance. A requirement for the development of an intercontinental bomber with a strike cap...
Aircraft kits (resin)
Limited Availability
£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 ANIG4048
1:144
Convair XB-48. Includes BONUS kits of the Martin XB-51, Curtiss XP-87 Blackhawk, Lockheed F-94C Starfire. In 1944, with the success of the German jet bomber Ar.234, USAAF was aware of enemy aviation advances. The war department issued requirement for a new design of the jet bomber which powered either by J35 or J47 engines. The Martin company submitted the Model 223. It was awarded contract for two prototypes which designated ...
Aircraft kits (resin)
Limited Availability
£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 ANIG4049
1:144
Martin P4M-1/-2 Mercator. Includes BONUS kits of Grumman XTB2F-1, Douglas XSB2D-1 Destroyer, Brewster SB2S-4 Buccaneer In 1944, the U.S. Navy experienced that faster land-planes like the Lockheed PV-1 Ventura and Consolidated PB4Y Privateer had been useful as well in the war, this need not be limited to flying boats only. The requirement for a much more formidable ocean patrol land-plane, with longer range, better sensors, and...
Aircraft kits (resin)
Limited Availability
£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 ANIG4055
Boeing XB-55 B-47 Stratojet propeller-driven version. Includes BONUS kits of the Bell XV-3, Grumman XF12F Lion and Douglas XF5D Skylancer. In October 1947, the USAF announced the medium swept-wing bomber program with plans essentially using the new Allison T40-A2 turbprop engines design. It was estimated to give the new bomber a top speed of 490 mph. Boeing submitted the Model-474 design that was started as a replacement for t...
Aircraft kits (resin)
Limited Availability
£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 ANIG4056
1:144
Tupolev Tu-22K Blinder-B. Includes bonus kits of the Mikoyan MiG-9 Fargo, Tupolev Tu-128 Fiddler and Mil Mi-1 Hare. In 1954, the Soviet Council of Ministers issued an ordering the development of a long range supersonic bomber. The Tupolev OKB was put in charge of the development, the Tu-105 configuration was selected. The first Tu-105 prototype made it first flight in 1958. It was proven as an impressive machine. The aircraft ...
Aircraft kits (resin)
Limited Availability
£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 ANIG4058
1:144
Lockheed C-5M Super Galaxy. Includes BONUS kits of the Fairchild T-46 Eaglet, Cessna O-2A Skymaster and Boeing YUH-61. In 1963, the USAF began to study very large logistic jet-powered transports. After reviewing several airframe designs, they eventually choose one similar to that of the C-141A Starlifter featuring a high-set wing, four underwing jet engines and a T-tail. The design competition was between Boeing Model 747, Dou...
Aircraft kits (resin)
Limited Availability
£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 ANIG4060
1:144
Lockheed XR6V-1 / R6O-1. Includes BONUS aircraft of the McDonnell-Douglas A-12 Avenger II, Northrop-Grumman MQ-8 Fire Scout, and Boeing Diamond wing. In 1942, the U.S. Navy called for a large transport aircraft to improve upon the navy's fleet of flying boats. In the meantime, Lockheed and PanAm began a Model 189 airliner study as a greater / double-decker version of the 049 Constellation. A year later in 1943, the Navy involv...
Aircraft kits (resin)
Limited Availability
£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 ANIG4075
1:144
Boeing C-75 Stratoliner. Includes bonus kits of the Northrop A-17 Nomad / Kellett YO-60 / Ryan XF2R-1 Darkshark. In 1937, Boeing designed a four-engined Model 307 airliner based on its B-17C heavy bomber to operate at altitudes of 20,000 ft. Boeing built ten Stratoliners but production stopped at the onset of war in 1940. At the time the U.S. entered World War II, the U.S. Military required for the long-range transport aircraf...
Aircraft kits (resin)
Limited Availability
£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 ANIG4079
1:144
Boeing YAL-1A The Airborne Laser Test Bed. Includes bonus kits of the Bede BD-5 / Pilatus UV-20A Chiricahua / Northrop Tacit Blue. In 1996, the U.S. Air Force launched the Airborne Laser program for the destruction of tactical theatre ballistic missiles. The Department of Defense awarded Boeing for the program management, systems integration, battle management system and modification of the 747-400F aircraft. Northrop Grumman ...
Aircraft kits (resin)
Limited Availability
£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 ANIG5005
1:144
Salyut Polyus- Orbital Weapons Platform. In 1983, U.S. President Reagan launched a 'Star Wars' program, a shield intended to defend the U.S. against nuclear attack from any place on earth. The Soviet Union immediately accused the United States of seeking to militarily dominate over the others. The USS R. chairman Andropov sought to bring about a treaty banning military weapons from space, and authorized the design of counter-m...
Space kits (resin)
Limited Availability
£47.99
-
In Stock
1

[1]   «      58   |   59   |   60   |   61   |   62      »      [269]
-50 -20 -10 | +10 +20 +50 +100

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