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 = 956
		 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 22 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 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 ANIG2031
Douglas XB-42 Mix-Master. In 1943, the Douglas began a company funded study to a high speed bomber design which was not liked the traditional wing mounting engines. It was an unusual idea to install the two engines within the fuselage driving a pair of propellers mounted at the tail. That can leaving the wing and fuselage clean and free of aerodynamics-reducing protrusions. Douglas submitted an unsolicited proposal to U.S.A.A....
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 ANIG2107
1:72
Ilyushin Il-102 Ground attacker competed with Su-25. In 1967, the Soviet Air Forces drew up a specification for a armoured ground attack aircraft. While Sukhoi designed an all-new single seat Su-25, Ilyushin proposed a modified version of their Il-40 of 1953 under the designation Il-42, which unlike the Sukhoi was a two seat aircraft with a remotely controlled rear gun turret. The design was rejected by the Soviet Air Forces, ...
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 ANIG2112
1:72
Fairchild XC-120 Packplane Modified C-119 with detachable cargo pod. In 1948, the USAF requested Fairchild to develop a new transport airplane based on the C-119 Flying Boxcar, as the cargo or troops carriers with a better and quicker way to deliver cargo, or an air-deliverable field hospital. Fairchild submitted a proposal for the conversion of the C-119B from the production line into a new designed machine. The aircraft reta...
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 ANIG2092
1:72
Ilyushin IL-22 In early 1946, the first Soviet designed jet engine, TR-1 was completed. The USSR Council of Ministers issued requirement for a new bomber that would use four of TR-1 jet engines. Ilyushin and Sokhoi were called to begin work on the jet bomber design that resulted in the Il-22 and Sukhoi Su-10. After the Myasishchev OKB was closed in 1945 several key design staff were transferred to Ilyushin and they became invo...
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 ANIG2121
1:72
Kawasaki OH-1 Ninja JGSDF OH-X programme. In late 1980s, the Japan Ground Self-Defence Force (JGSDF) launched the OH-X programme to acquire a new indigenous observation helicopter to replace its Kawasaki license-built OH-6Ds. Design proposals for the OH-X programme were presented by Kawasaki, Fuji and Mitsubishi. Kawasaki's design was selected. The first prototype XOH-1 completed its maiden flight in 1996. Kawasaki handed over...
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 ANIG2110
1:72
EWR VJ-101C German tilt-jet VTOL. In the late 1950's, the West Germany issued an 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. Heinkel submitted the configuration of the tiltjet fighter He.231, attracting interest of the German government. In 1959, He...
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 ANIG2058
1:72
McDonnell XF-88A Voodoo. In 1945, USAAF recognized all the early jet fighters lacked sufficient range to escort bombers to the target. So proposals for a penetration fighter were requested. In 1947, McDonnell submitted its larger-sized McDonnell F2H proposal, and was chosen for two prototypes, designated XF-88 Voodoo. The other designs entered the competition were the Lockheed XF-90 and the North-American YF-93A. In 1948, the ...
Aircraft kits (resin)
Limited Availability
£57.99
-
In Stock
2


Search Area Manufacturer Item Type Search

Part Number Scale Keywords Results per Page
Exact Match
Sort by:
Sort Direction:
Added Within last week
last 2 weeks
last month
last 6 months
last year