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=8213 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 295 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

No Image
Potez 25 B2 Polish Jupiter 'Against the Tide'. The Potez 25, produced in a wide variety of versions, fitted with several types of power plants, was one of the most widely used aeroplanes of the 1920s. The type was both exported abroad and built under licence. It could be seen flying almost world-wide, over Europe, Asia, to Africa or South America. The Potez 25 took part in many conflicts including the Second World War. One of ...
Aircraft kits (injection)
Catalogue
£19.99
-
In Stock
10+

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
de Havilland DH.100 Vampire Mk.3 'European and American Users' , GB, Norway, Canada, Mexico. The DH.100 Vampire was a British first generation fighter jet aeroplane and was produced in several versions both for the RAF and for export. The Vampire Mk.3 version saw service not just with the domestic force, it was also operated by military in Canada, Norway and Mexico. And these four operators is what you will find offered on the...
Aircraft kits (injection)
Catalogue
£15.30
-
In Stock
10+

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
Heinkel He-59B This re-release of the Heinkel He 59B is suitable for more experienced modellers. It contains four grey styrene sprues, resin cast parts and a fret of etches. The resin parts have been designed anew now as well as the clear plastic ones which replace the original vacuum-formed items. The decal sheet brings markings for a Legion Condor machine flying over Spain during the civil war and a machine in the colours of...
Aircraft kits (injection)
Catalogue
£53.99
£48.59
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
Aero A-11HS aâé-~Finnish Export Version 1/72 In 1925, Finland bought a dozen of Aero A.11 observation and light bomber biplanes. This meant one of the first export success of the Czechoslovak aviation industry. The Finnish version differed from Czech Aero A.11s by having the more powerful Hispano Suiza engine fitted. The kit comes on three styrene sprues, two clear ones and a few 3D-Printed parts for the HS power unit. Th...
Aircraft kits (injection)
Catalogue
£19.80
£17.82
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
Gloster Meteor TT Mk.20. As the RAF Gloster Meteor Mk.11 jets began to leave the first line duty, it was necessary to find a new job for them. A few of the Mk.11 airframes were converted to a target tug to requirements issued by both the Royal Navy and RAF. These were designated TT Mk.20 and in a similar fashion were also rebuilt Meteor Mk.11s of the Danish Air Force and a Swedish civil operator. Our Meteor TT Mk.20 comes on f...
Aircraft kits (injection)
Catalogue
£22.50
£20.25
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
CASA C-212-300/400 'Long Nosed Casas' 1/72 At the end of the 1960s, the Spanish air force begun to look for a type to replace the then widely used transport aircraft, of which the longest-serving were the Ju-52s built in the 1930s. The military issued requirements calling for a new transport and multi-purpose type and to fit these requirements, the CASA company brought forward their concept of a twin-engined, turbo-prop powe...
Aircraft kits (injection)
Catalogue
£26.99
£24.29
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
Siebel Si-204E 'German Night Bomber & Trainer' The Siebel Si 204A and Si 204D were the transport and trainer versions of the twin engined aeroplane originally built to be operated by the Lufthansa as well as (and mainly) by the Luftwaffe. In the war years, a trainer bomber version was built and later used in the night bombing role. This type was designated the Si 204E and a pair of prototypes and a small batch of Si 204E-0 pro...
Aircraft kits (injection)
Catalogue
£49.50
-
In Stock
10+

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

1:72
Blohm-und-Voss Bv-155V-1 The Blohm Voss BV 155B was supposed to become just that weapon to stop the new American B-29 high altitude bombers. However, these magnificent machines were sent to the Pacific area and the development of the BV 155B was not brought to a successful finish. The development had really been rather complicated, originally taking place at Messerschmitt facility as the Me 155, originally designed as a naval ...
Aircraft kits (injection)
Catalogue
£16.99
£15.29
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

1:72
Re-released! Dassault-Mirage F.1CR The Mirage F.1C came to being as a private venture of the French Dassault company. The French Air Force, or the Armƒ¯é¿é½e de l'Air, had ordered two prototype aircraft named Mirage F.2 and Mirage F.3 which were to be equipped with a JTF10 engine. However, Dassault built at their own expense an additional prototype, smaller than the two previous and fitted with an Atar 9K power plant. This mac...
Aircraft kits (injection)
Catalogue
£17.30
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

Re-released! Curtiss P-40K-1/5 Warhawk A model of the P-40K-1/5 Warhawk US WW2 fighter aircraft which featured a short fuselage and an enlarged tail fin. The kit contains: three sprues with grey styrene parts, one sprue with clear parts, decal sheet and full-colour instructions. The decal sheet offers markings for four machines: P-40K-1 (42-46040), white 13, pilot 1Lt. Robert J. "Crash" Overcash, 64FS, 57FG, Africa, May 194...
Aircraft kits (injection)
Catalogue
£16.99
£15.29
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
Re-released! SIAI Marchetti SF-260 The Italian SF-260 trainer, aerobatic and light sports aircraft is used world wide. In Europe, it has been operated by the Italian and Belgian air forces as well as by the Irish Air Corps. The model is laid out to five styrene sprues including a clear one with the early, no so bulged canopy hood. Colour schemes and decals for Italian, Belgian and Irish M, AM and W version machines are prov...
Aircraft kits (injection)
Catalogue
£12.40
£11.16
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
Avro Anson MASK 1/48 Pre-cut spray masks for the clear parts and undercarriage wheels (designed to be used with Special Hobby kits)
Aircraft paint masks (self adhesive)
Catalogue
£4.30
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
Messerschmitt Bf-109E-3 In 1939-40, the Messerschmitt Bf-109E was the best fighter aircraft in production. Superbly trained pilots, utilizing the tactics devised during the war in Spain, simply swept from the skies everything that opposed them, first over Poland, then over Scandinavian countries and the skies of western Europe as well. It was not until they had reached proud Albion that their dominance was finally eliminated b...
Aircraft kits (injection)
Catalogue
£13.99
-
In Stock
10+

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
Westland Whirlwind FB Mk.I 'Fighter-Bomber' Hi-Tech version. Not long before the outbreak of WW2, the British Air Ministry issued a requirement calling for two types of fighter aircraft, one light weight with machine gun armament and the other one with heavy cannon armament. To these requirements, the machine gun armed Hurricanes and Spitfires were designed, while to fit the second category, the Westland offered their Whirlwi...
Aircraft kits (injection)
Catalogue
£89.99
-
In Stock
10+

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

1:48
Re-released! Supermarine Seafire Mk.III 'Aeronavale & Irish Air Corps'
Aircraft kits (injection)
Catalogue
£23.60
-
In Stock
10+

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
Messerschmitt Bf-109E-4 with schemes of two German fighter aces, G.Schopfel and H.Wick who, flying from bases in Western Europe, took part in the Battle of Britain. The kit also contains two more options, these being Emils as operated over the Balkans a year later. Decals of Wické's machine containing the fuselage camouflage mottles consisting of a myriad of tiny brush-made blotches are available separately SHK72031. The kit p...
Aircraft kits (injection)
Catalogue
£16.99
-
In Stock
10+

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
Curtiss P-40M Warhawk 'Involuntarily from Russia to Finland' 1/72 During the Second World War, the P-40M Warhawk fighter aircraft was used both by the USAAF and the air forces of the Allies. Over two hundres were also delivered to the Soviet Union. P-40M s/n 43-5925 White 23 saw only very brief service with the VVS (Soviet Air Force). When the new machine was being flown over to the unit, its pilot 2nd Lt. V.A.Revin got lost...
Aircraft kits (injection)
Catalogue
£15.75
-
In Stock
10+

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
Republic F-84F Thunderstreak 'The Suez Crisis' 1/72. The F-84F Thunderstreak swept-wing jet fighter was a development of the Republic F-84G straight wing aircraft. Using a wing with the sweep along with a more powerful jet engine improved the performance to that of the F-86 Sabre. At first, the F-84F experienced several trouble with their power units, manoeuvrability as well as with corrosion. Later, after the outbreak of the ...
Aircraft kits (injection)
Catalogue
£18.99
-
In Stock
10+

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
Westland Whirlwind Mk.I In the days leading to the outbreak of the Second World War, the British Air Ministry issued requirements calling for two types of a new fighter aircraft, a lighter one armed just with machine guns and the other one with heavier cannon armament. To this specifications, the Spitfire and Hurricane machine gun fighters were developed. The requirement for the heavier type led to the creation of the twin-eng...
Aircraft kits (injection)
Catalogue
£65.99
-
In Stock
7

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
Avro Anson Mk.I 'Anti-Submarine Annies' as the Avro Ansons were familiarly known then, flew during WW2 not just over their home skies in the UK, they were widely used also in Africa, Canada or Australia. And at the controls could be seen pilots of many various nationalities. And our SH48211 model kit and its colour schemes reminds us of such airmen who left their often occupied homes to fly and fight against the enemy. The fir...
Aircraft kits (injection)
Catalogue
£46.99
-
In Stock
10+

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:48
North-American T-2 Buckeye Buckeye 'Anniversary Markings' 1/48 The 1/48 T-2 Buckeye model is back now as is also its larger 1/32 cousin. And both releases share the same colour schemes depicting so called anniversary markings, one scheme is for a US Navy option while the other is more exotic indeed, reminding us that the Buckeyes also flew with the Hellenic Air Force. And both these schemes are quite eye-catching. Unlike the...
Aircraft kits (injection)
Catalogue
£39.99
-
In Stock
10+

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:72
Republic F-84F Thunderstreak The swept-wing jet fighter was a development of the Republic F-84G straight wing aircraft. Using a wing with the sweep along with a more powerful jet engine improved the performance to that of the F-86 Sabre. At first, the F-84F experienced several trouble with their power units, manoeuvrability as well as with corrosion. Later, after the outbreak of the Berlin Crisis and subsequent need to make th...
Aircraft kits (injection)
Catalogue
£18.99
-
In Stock
10+

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:72
Aero A-12 'the First of the Family' The Aero A-12 was developed by Ing.HusnƒÆ'ék, the chief designer at the Aero factory in 1923 and was introduced to the Czechoslovak Air Force a year later. And it was just the same year that the A-12 did very well during the 2nd Speed Race for the President of the Republic Trophy. Three of the A-12s set world records in the race, the first ones to be achieved by Czechoslovac crew. The reco...
Aircraft kits (injection)
Catalogue
£19.80
-
In Stock
10+

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
North-American T-2 Buckeye wheels and canopy frame paint masks Inside/Outside MASK (designed to be used with Special Hobby kits)
Aircraft paint masks (self adhesive)
Catalogue
£7.20
-
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

No Image
Republic F-84F Thunderstreak Pre-cut spray masks for the clear canopy parts and u/c wheels of the very new F-84F Thunderstreak model kits (designed to be used with Special Hobby kits)
Aircraft paint masks (self adhesive)
Catalogue
£4.30
-
In Stock
10+