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 ps.id = 957 AND P.price_set = 1 
		 AND P.product_category_id = 102 
		AND pc.show_in_search = 1

	 AND (P.product_category_id = 103 OR P.price_set) GROUP BY P.id ORDER BY DATE(P.arrival_date) desc, P.code
Catalogue | Hannants
Hannants News Feed Subscribe To This Search | Create Search Alert Create Search Notification

Catalogue



Found 2,472 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

No Image
1:144
Sterling Boeing 757 for Zvezda
Aircraft decals (civil)
Catalogue
£10.99
-
In Stock
5+

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

No Image
1:144
Lun Class Ekranoplan Soviet GEV Soviet 'Ground Effect Vehicle' developed during the Cold War. 8-engined hybrid seaplane capable of skimming the water's surface at 16-32 feet unseen by radar. Armed with six anti-ship missiles mounted on the spine. Full cockpit, detailed rear gunner's emplacement, six Moskit missile launch tubes. Choice of 3 markings
Aircraft kits (injection)
Catalogue
£59.99
-
In Stock
5+

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

No Image
'Marston Mat' Pierced Steel Plank (PSP). 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) 'Marston Mat', was a very common covering used for makeshift runways, parking areas and other military uses where rough ground was prevalent. Each panel measured 1 ft 7.5 in by 11 ft 9.75 in, and interlocked with its neighbour by a series of flat 'T' hooks and slots along each of the longest sides, which allowed a degree of flexibility of m...
Vinyl Bases
Catalogue
£7.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

No Image
RAF Coningsby, Lincolnshire, United Kingdom, 2005-2021. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) RAF Coningsby was built in the late 1930's and after officially opening in November 1940, became operational in February 1941. No. 106 Squadron was the first unit to begin offensive operations from the base flying Handley Page Hampden's. A second unit, No. 97 Squadron, arrived in April equipped with Avro Manchester's, and in ...
Vinyl Bases
Catalogue
£7.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

No Image
Wood Planked Revetment, Great War and Second World War 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Wooden planked revetments were used by all sides during the Great War and Second World War, but were most notably common in Luftwaffe use. Quickly laid down, they did not follow a standardised pattern, size, shape or design. Sometimes, they consisted of simple planked hard standings as in this set, or more elaborate affairs wi...
Vinyl Bases
Catalogue
£7.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

No Image
Fliegerhorst Grove, Denmark- 1.(F)/33 (possibly transited through the base), Danish units post-war. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Located near the Danish town of Karup, the construction of Grove was commenced shortly after the German occupation of Denmark in 1940, with the base becoming operational later that year. By 1945, the base had grown with the addition of command bunkers, aircraft revetments, anti-airc...
Vinyl Bases
Catalogue
£7.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

No Image
RAF Lakenheath- 1990 to 2021. (Main) USAF Units- 48th Fighter Wing (492nd, 493rd, 494th Fighter Squadrons, 495th Fighter Squadron- (due to reactivate in 2021)). 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Located near the town of Lakenheath in Suffolk, United Kingdom, the base can date its roots back to the Great War when it was named Lakenheath Warren and used as a bombing range. It fell into disrepair after 1918, but was ...
Vinyl Bases
Catalogue
£7.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

No Image
Tyndall Air Force Base, Florida- 2021. (Main) USAF Units- 325th Fighter Wing/325th Operations Group (2nd Flying Training Squadron, 43rd and 95th Fighter Squadrons). 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Tyndall Field as it was previously known was activated as a USAAC gunnery range in 1941. It was deactivated at the end of World War 2 and became a training airfield under Air Training Command. In 1948, the base was ren...
Vinyl Bases
Catalogue
£7.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

No Image
Royal Naval Air Station Yeovilton (H.M.S. Heron), 1990's onwards. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) RNAS Yeovilton was built in 1939, with 750 NAS commencing operations from the base in the same year, and followed by 751 and 752 NAS shortly afterwards. 794 NAS was formed in 1940 and 827 NAS started operations from the base in 1943. This unit was the first to receive the Fairy Barracuda torpedo bomber. Yeovilton un...
Vinyl Bases
Catalogue
£7.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

No Image
Four single parking areas. Suitable for Great War onwards. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) The four bases in this set are suitable for both 1/48th and 1/72nd aircraft, and are ideal for types operating from rough terrain from the Great War onwards. Usable for any type of aircraft of relevant type, size and scale.
Vinyl Bases
Catalogue
£7.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

No Image
USS Nimitz (CVN-68), No. 2 Elevator, 2020 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Named after Chester W. Nimitz, the ship was launched in May 1972 and commissioned in May 1975, originally as CVAN-68 and thereafter CVN-68. Her first deployment was to the Mediterranean in July 1976 and she returned to the United States in February the following year. This was followed by further deployments to the Mediterranean, firstly i...
Vinyl Bases
Catalogue
£7.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

No Image
Plain Grass (Solid). 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) A base of solid grass that can serve a number of functions. Applications could include military and civilian airfields and aerodromes from the dawn of flight to the present day and even bases for vehicle displays. The base can also be used for 1/72nd displays, is large enough to be cut into smaller sections to create a number of separate bases and as it's seam...
Vinyl Bases
Catalogue
£7.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

No Image
RAF Wildenrath, West Germany, 1967. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Construction of RAF Wildenrath began in 1950, with the station coming onto 'active' status in 1952. It was the first of four 'clutch' bases operated by the RAF in West Germany; the others being Geilenkirchen, Brƒ¼ggen and Laarbruch. From 1953, the first units to operate from Wildenrath were Nos. 67 and 71 Squadrons flying North-American F-86E...
Vinyl Bases
Catalogue
£7.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

No Image
RAF Marham, Norfolk, United Kingdom, 2018-. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) RAF Marham can trace its history back to 1916 when it started service as a night landing ground near RNAS Narborough, and also as an airfield to launch defensive operations against German Zeppelin attacks against Norfolk. The first unit stationed here was No. 51 Squadron, Royal Flying Corps flying Royal Aircraft Factory B.E.2 and B.E.12'...
Vinyl Bases
Catalogue
£7.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

No Image
Da Nang Air Base, 1970-71. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) Armĩe de l'Air: The history of the air base at Da Nang goes back to the days of French Indochina. Tourane Airfield as it was then called, was constructed during the 1930's. In 1940, the French Vichy Government agreed to let Imperial Japan use the base as a stationing post for Japanese troops along with several other bases in the area including Cam Ra...
Vinyl Bases
Catalogue
£7.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

No Image
RAF Dispersal 150ft 'Frying Pan' type. 337mm(W) x 225mm(H) 13 inches x 9 inches(H) There were a number of aircraft dispersals employed during, and indeed after the Second World War. The subject of this base is the 'Frying Pan' (FP) type. So named for obvious reasons, they came in two sizes, 125ft diameter and 150ft diameter and could be used by the largest RAF bombers in service. They were circular in shape and with eith...
Vinyl Bases
Catalogue
£9.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

No Image
USS Enterprise (CV-6), 250N Blue Flight Deck Stain, November 1943. 337mm(W) x 225mm(H) 13 inches x 9 inches(H) The Enterprise was one of three Yorktown-class carriers, the others being the Yorktown (CV-5) and Hornet (CV-8). She was laid down on July 16th 1934, and launched on October 3rd, 1936, and was the seventh ship to that date to be named Enterprise. Nicknamed The Big E, the Enterprise was commissioned in May 1938 a...
Vinyl Bases
Catalogue
£7.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

No Image
RAF Coltishall, Norfolk, United Kingdom, 1950's-1970's. 438mm(W) x 225mm(H) 17 inches x 9 inches(H) Scottow Aerodrome was built in 1939. Renamed Coltishall, it was activated in May 1940 and one of the first units to operate from the station was No. 242 Squadron flying the Hawker Hurricane and led by Douglas Bader. 242 Squadron left for RAF Duxford shortly afterwards. The station became a night fighter base for most of the r...
Vinyl Bases
Catalogue
£7.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

No Image
Wood planked revetments, Finland/Russia: Winter War/Eastern Front/Continuation War, 1940-1944. 337mm(W) x 225mm(H) 13 inches x 9 inches(H) Life during the war on the Eastern Front was primitive to say the least. Many roads were little more than dirt tracks, which, although fine for travel during the hot summer months, became nigh impassable during the spring and autumn periods known as the Rasputitsa, or more commonly to th...
Vinyl Bases
Catalogue
£7.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

No Image
Desert- Blurred. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) This base can be used for a number of applications and theatres involving civil and military aviation from the Great War (Egypt, Mesopotamia, Palestine etc), through to the Second World War (Middle East, Persia), the Cold War (Middle East and Iran/Iraq conflicts, Indo-Pakistan conflicts etc), to the present day (Gulf Wars, Middle East wars, United States adversary...
Vinyl Bases
Catalogue
£7.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

No Image
RAF Scampton, Lincolnshire, United Kingdom, 2000-2021. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) RAF Scampton's location can trace its ancestry back to the Great War when, named Home Defence Flight Station Brattleby, it served as a landing field for the Royal Flying Corps. From here operated No. 3 Squadron 'A' Flight equipped with the Royal Aircraft Factory F.E.2b albeit briefly in the anti-Zeppelin role. This unit was fo...
Vinyl Bases
Catalogue
£7.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

No Image
RAF Scampton, Lincolnshire, United Kingdom, 2000-2021- Main runway- blurred. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) RAF Scampton's location can trace its ancestry back to the Great War when, named Home Defence Flight Station Brattleby, it served as a landing field for the Royal Flying Corps. From here operated No. 3 Squadron 'A' Flight equipped with the Royal Aircraft Factory F.E.2b albeit briefly in the anti-Zeppelin ...
Vinyl Bases
Catalogue
£7.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

No Image
RAF Waddington, Lincolnshire, United Kingdom, 1960s. 225mm(W) x 225mm(H) 9inches(W) x 9inches(H) RAF Waddington began as a training base for the Royal Flying Corps in 1916. Between this time and 1919, the station was home to a number of squadrons both under RFC, and later, RAF control. Nos. 82, 97, 105, 117 and 123 Squadrons RFC between 1917 and 1918, and Nos. 23, 203 and 204 Squadrons RAF throughout 1919 were based at Wad...
Vinyl Bases
Catalogue
£7.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

No Image
Douglas C-133A with PGM-17 Thor IRBM Mobile strategic aircraft complex consisting of C-133 aircraft and PGM-17 Thor missile. The main objective was to quickly deliver intermediate-range ballistic missiles (IRBM) by transport aircraft to remote points in other continents, placing missiles as close as possible to the borders of potential adversaries. From 1959 to 1963 missiles of this type were transported to Great Britain on C...
Aircraft kits (injection)
Catalogue
£29.99
-
In Stock
4

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

Tupolev Tu-154M Samara Airlines
Aircraft decals (military)
Catalogue
£7.20
-
In Stock
2