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.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 64 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 ANIG2048
1:72
Douglas XA2D-1 Skyshark. In June 1945, with the success of the high performance AD Skyraider, Navy asked Douglas to design a new version of the AD with turboprop power, and selected Allison to design the power-plant. Allison proposed to install a pair of nose mounted engines to drive a pair of contra-rotating propellers. In cruise flight, one of the engine and prop could be shut down to increase its flight range. In 1947, two ...
Aircraft kits (resin)
Limited Availability
£47.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 ANIG2063
1:72
Bell YAH-63 attack helicopter. In 1972, the U.S. Army requested proposals for a new Advanced Attack Helicopter (AAH) intended for the all-weather anti-armor role. Preliminary designs were submitted by Boeing, Bell, Hughes, Lockheed and Sikorsky, and in 1973 both Bell and Hughes were awarded contacts for two prototypes. Bell's Model 409 was designated YAH-63, and Hughes' Model 77 became the YAH-64. The YAH-63 was based largely ...
Aircraft kits (resin)
Limited Availability
£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 ANIG2065
1:72
Convair Atlas-A/-B/-D/X-11/X-12/XB-65/SM-65B/CGM-16D 1st ICBM. In October 1945, U.S. Army issued supersonic missile requirement to the industries which received many military missiles technical papers from Nazi Germany. In 1946, Convair submitted several proposals and was received funding for the MX-774 rocket study. In 1949, Soviet detonated its first nuclear weapon, U.S.A.F. gave highest priority to Convair to develop a more...
Space 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 ANIG2068
1:72
North-American XB-28. In 1939, the USAAF issued requirement for a new medium bomber which could operate at high-altitude to avoid attack from ground fire. Martin and North-American responded with the requirement, Martin submitted the Model 182 which was redesigned from the Martin B-26 Marauder, and North-American proposed NA-63 which was based from the North-American B-25 Mitchell. In 1940, North-American's design was chosen t...
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 ANIG2073
1:72
Myasishchev M-17 Stratosfera. In May 1960, when the Lockheed U-2 spy-plane was shot down over Ukraine, American started to use alternative unmanned balloon that prevailing winds would carry it across Soviet territory. The Soviet PVO (air defense forces) found this tread difficult to counter, and ordered Myasishchev to be head of a secret tasked with a high-altitude balloon destroyer aircraft. The result was the M-17 Mystic-A. ...
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 ANIG2077
1:72
Boeing X-20 Dyna Soar. 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 the study on space-craft, and named BoMi. In 1956, the Air Force channeled Bell's development to a reconnaissance, bombardment vehicle. A competition for a glider prototype was opened. In 1959, Boeing won the competition, and was contra...
Aircraft kits (resin)
Limited Availability
£47.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 ANIG2085
1:72
Lockheed AH-56A Cheyenne Attack helicopter to replace AH-1. In 1965, with the growing involvement in Vietnam, the U.S. Army requested proposals for an Advanced Aerial Fire Support System (AAFSS) program intended to establish a technologically advanced attack helicopter. Preliminary designs were submitted by Lockheed and Sikorsky. In 1966, Lockheed's design, AH-56 Cheyenne was selected as the winner. An engineering development ...
Aircraft kits (resin)
Limited Availability
£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 ANIG2086
1:72
Boeing YUH-61. In 1965, the U.S. Army launched the Utility Tactical Transport Aircraft System (UTTAS) program. The initial specification called for an aircraft able to carry a crew of three and eleven troops with the main goal of replacing the Bell UH-1 Huey. Requests for proposals were issued to the industries in 1972. All the designs proposed in response to the specification were required to use two G.E. turboshaft engines a...
Aircraft kits (resin)
Limited Availability
£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 ANIG2090
1:72
North-American XA2J-1 Super Savage. Most powerful savage bomber. In 1945, after the first atomic bomb was dropped successfully, the U.S. Navy launched a program for a carrier-based attack aircraft that would be capable of delivering a atomic bomb. The North-American AJ Savage won a Phase 1 competition, a turbo-prop powered aircraft being phase 2, and the phase 3 was a larger jet-powered attack aircraft. In 1947, the Navy reque...
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 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

   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