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=8264 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 149 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

No Image
Warpaint Series WPS141
Vickers Viking, Valetta & Varsity In Military Service. By Adrian M. Balch é£19.00 56 pages The Vickers VC.1 Viking was a British twin-engine short-range airliner derived from the Vickers Wellington bomber and built by Vickers-Armstrongs Limited at Brooklands near Weybridge in Surrey. After the Second World War, the Viking was an important airliner with British airlines, pending the development of turboprop aircraft like the...
Aircraft books
Catalogue
£19.00
£17.10
Out of Stock
0

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Warpaint Series WPS140
North-American OV-10 Bronco written by Mike Verier The full story of the first true Multi-Role Combat Aircraft, the OV-10 Bronco, still flying operationally after nearly six decades of service, is told here for the first time in a bumper 104-page Warpaint. Detailed first-hand information gathered over many years has enabled the author to bring together the many facets of this remarkably versatile aircraft including pre-curs...
Aircraft books
Catalogue
£28.00
£25.20
Out of Stock
0

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Warpaint Series WPS58
Supermarine Swift FR.5 and type 535
Aircraft books
Catalogue
£14.00
-
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
Warpaint Series WPS139
de Havilland (Canada) DHC-2 Beaver By Adrian M. Balch. The de Havilland Canada DHC-2 Beaver is a single-engine high-wing propeller-driven short take off and landing (STOL) aircraft developed and manufactured by de Havilland Canada. It has been mainly operated as a bush plane and has been used for a wide variety of utility roles, such as cargo and passenger hauling, aerial application (crop dusting and aerial topdressing), and ...
Aircraft books
Catalogue
£18.00
-
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
Warpaint Series WPS138
Lockheed F-117 Nighthawk By Andy Evans Now you see it now you don't! The F-117's retirement may have seemed premature, but has it really gone? The informative text traces the story of this remarkable aircraft from its Have Blue origins to its withdrawal from active front line service, and takes a look at some of the recent sightings of the aircraft that suggest there may be a role of some sort for it yet. This latest Warpa...
Aircraft books
Catalogue
£18.00
-
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
Warpaint Series WPSSP06
Dambusters and the Avro Lancaster 64 pages By Desmond Brennan Few military exploits have captured the public's imagination as much as the famous 'Dambusters' raid on the night of 16 " 17 May 1943. To mark the 80th anniversary of the escapade Guideline present Dambusters and the Lancaster, a comprehensive study of the raid itself, the background and planning that led up to it, and the men and machinery that took part, as wel...
Aircraft books
Catalogue
£20.00
-
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

Warpaint Series WPT116
Back in stock! Cessna Bird Dog Warpaint Special No 4 Author: Des Brennan. Cessna's Bird Dog was designed and built to serve in what some might regard as the unglamorous field of Army co-operation at a time when attention was more often focused on a growing array of gleaming silver, nuclear-capable jet fighters and bombers deemed essential for a seemingly inevitable Third World War. Nonetheless the Bird Dog was flown sometimes ...
Aircraft books
Catalogue
£11.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
Warpaint Series WPS137
Douglas SBD Dauntless By Kev Darling The Douglas SBD Dauntless earned itself a reputation as a great dive bomber even though its antecedents were very much of pre-war origin. Many nicknames were given to the SBD during its time in frontline service, my own personal favourite is 'slow but deadly'. The original concept was developed by Jack Northrop with some help from Ed Heinemann. The resultant aircraft, the BT-1, had quite...
Aircraft books
Catalogue
£28.00
-
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
Warpaint Series WPS136
Airspeed Oxford and Consul By William Harrison 52 pages With more than 8,750 built the Oxford was a well thought-out design that was based on their Airspeed Envoy, a similar shaped twin-engine executive aircraft that was used in the early 1930s but the more advanced design of the Oxford suited the military requirement for a three-seat training aircraft. The Oxford was a low-wing cantilever monoplane of advanced design and ...
Aircraft books
Catalogue
£18.00
-
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
Warpaint Series WPS135
de Havilland DH.89 Dragon Rapide & Dominie By Adrian M Balch
Aircraft books
Catalogue
£17.00
-
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
Warpaint Series WPS134
No Scale
Aero L-29 Delfin 72 pages
Aircraft books
Catalogue
£21.00
-
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
Warpaint Series WPS133
No Scale
Douglas C-47 Skytrain/Dakota By Adrian M. Balch When the prototype Douglas DC-3 " actually a DST Douglas Sleeper Transport first flew from Clover Field, Santa Monica, California on Sunday 17 December 1935, Donald Wills Douglas never imagined that the production run would total more than 10,000, with more licence built in Russia and Japan, let alone many would be still be flying 86 years later, the C-47 being perpetuated by ...
Aircraft books
Catalogue
£25.00
-
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

Warpaint Series WPS122
No Scale
Albatros D.I - D.III By Dave Hooper The Albatros D.III was flown by many top German aces during World War One, including Wilhelm Frankl, Erich Lƒ¶wenhardt, Manfred von Richthofen, Karl Emil Schƒ¤fer, Ernst Udet, and Kurt Wolff and was the preeminent fighter during the period of German aerial dominance known as 'Bloody April' 1917. The D.III entered squadron service in December 1916, and was immediately acclaimed by German airc...
Aircraft books
Catalogue
£15.00
-
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

No Image
Warpaint Series WPS132
Boeing B-52A-F Stratofortress. The Boeing B-52 Stratofortress has become an icon although it was the result of a difficult birth courtesy of various officials whose understanding of realistic goals was overridden by the desire to chase an impossible dream. Eventually a great eight engined high winged bomber would appear on the Seattle flight line. The first model would be a development batch with the B Model being the first op...
Aircraft books
Catalogue
£25.00
-
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
Warpaint Series WPS131
The Auster, In British Military & Foreign Air Arm Service. Author Adrian M Balch 64 pages, 15 pages of Colour Profiles Over 150 many never seen before images Stemming from the original American Taylorcraft design, the British Auster is arguably as well known and famous as the Tiger Moth, being built at the right time to provide a vital role during WW2 in the Air Observation Post role, spotting and reporting artillery posit...
Aircraft books
Catalogue
£17.00
-
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
Warpaint Series WPS130
IIyushin II-28 Author Nikolay Jakubovich 68 pages PLUS 8 pages of A2 page plans 8 pages of Colour Profiles Never seen before Images Nikolay Yakubovich documents fully this milestone in Soviet aviation history. The Ilyushin Il-28 (NATO reporting name 'Beagle') was the Soviet Union's first jet bomber to enter large-scale production. Licence-built in China as the Harbin H-5, as well as in the Czech Republic, total pr...
Aircraft books
Catalogue
£17.00
-
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

Warpaint Series WPSSP02
None
Re-released! Messerschmitt Bf-109. When it comes to famous aircraft of the 20th Century, one that is sure to come to the top of the list is the Messerschmitt Bf-109. With a career spanning nearly 20 years and over 30.000 examples of being built the Messerschmitt Bf-109 is probably the most recognised of all the World War 2 fighters. Ironically this German fighter started and ended its life being powered by British engines.
Aircraft books
Catalogue
£25.00
-
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

Warpaint Series WPSSP03
de Havilland Mosquito Mks I to TT.39 Written and Illustrated by Richard J Caruana 84 pages Born during the dark days of World War 2, the Mosquito was the result of revolutionary thinking that started way back in 1936. Although originally designed and built as a bomber, it was even- tually adapted to any role imaginable where speed was of an essence. In fact its only defence was its capability of outpacing enemy intercept...
Aircraft books
Catalogue
£25.00
-
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
Warpaint Series WPSSP05
Warpaint Special no 5 North-American P-51 Mustang - Warpaint Special no 5 aâé-¢ A massive 108 pages aâé-¢ Author superb and respected Kev Darling aâé-¢ Artwork by John Fox aâé-¢ Over 200 images some never seen before aâé-¢ 16 pages of Colour Profiles aâé-¢ 2 page scale Plans aâé-¢ 4 pages of detailed Aircraft used by various units
Aircraft books
Catalogue
£22.00
-
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
Warpaint Series WPS129
Mikoyan-Gurevich MiG-3 By Nikolay Yakubovich By the time Operation Barbarossa unfolded on 22 June 1941 some 981 MiG-3s were in service with the Soviet Air Forces (VVS), the Soviet Air Defence Forces (PVO) and Soviet Naval Aviation, but the aircraft had undergone a difficult development and was an unforgiving machine to fly in combat. It had been designed for high-altitude but combat over the Eastern Front was generally at l...
Aircraft books
Catalogue
£17.00
-
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
Warpaint Series WPS128
Bristol Scout
Aircraft books
Catalogue
£14.00
-
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
Warpaint Series WPS127
Cessna T-37 A/B/C 'Tweet' and the A-37A/B 'Dragonfly' By Kev Darling When USAF went searching for a new jet trainer in the early 1950's to replace the Lockheed T-33, it came as a great surprise to all when Cessna, best known for producing light aircraft, actually won the competition. Little did anyone realise that the T-37, the new training aircraft's designation, would stay in service for fifty years. Along the way the fle...
Aircraft books
Catalogue
£20.00
-
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
Warpaint Series WPS126
Grumman F-14 Tomcat By Charles Stafrace. The US Navy embarked on the VFX fighter programme when it became obvious that the weight, engine and manoeuvrability issues plaguing F-111B, the naval variant of the Tactical Fighter Experimental (TFX), would not be resolved to the Navy's satisfaction. The Navy requirement was for a fleet air defence fighter whose primary role was intercepting Soviet bombers before they could launch mis...
Aircraft books
Catalogue
£25.00
-
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
Warpaint Series WPS125
Bristol Britannia including the Canadair CP-107 Argus and CC-106 Yukon by Charles Starface. The Britannia and its Canadian derivatives were not built in huge numbers - 39 Yukons and CL-44s, and 33 Argus were built in Canada. These and the 85 Britannias carried out useful work faithfully and reliably, and all over the world, the last civilian Britannia being retired in 1997. All versions of this interesting aircraft are desc...
Aircraft books
Catalogue
£16.00
-
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

Warpaint Series WPS31
RAF/RN McDonnell F-4K/F-4M Phantoms (Hall Park Books Limited) Designed with both the aircraft enthusiast and the modeller in mind, this series offers a comprehensive and accurate account of a single aircraft type within each issue. Drawings provided in both colour side and plan view with 1:72 scale plans, kit decal and accessory lists, squadrons, units and individual aircraft serials in codes, etc.
Aircraft books
Catalogue
£15.50
-
In Stock
5+

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

Search Area Manufacturer Item Type Search

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