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=362108 AND ps.id = 955 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 272 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
Print Scale PSM48002
Dewoitine D.520 mask +decal+3D decal Dewoitine D.520, No.73/10 flown by Adj Andre Carrier of 2 Escadrille, GC I/3 Armeĩ de L'Air, Wez-Thuizy, May 1940. The pilot lost his life in this aircraft on 14 May 1940.
Aircraft decals and paint masks (military)
Catalogue
£17.40
£15.66
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
Print Scale PSM48003
1:48
Dewoitine D.520 mask +decal+3D decal / Dewoitine D.520 with 1AC. 1AC fought the Allies during the SyriaLebanon campaign.
Aircraft decals and paint masks (military)
Catalogue
£17.40
£15.66
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
Print Scale PSM48004
Dewoitine D.520 mask +decal+3D decal / Dewoitine D.520 with 2 Squadron GC III/6. Algiers, spring 1942 year.
Aircraft decals and paint masks (military)
Catalogue
£17.40
£15.66
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
Print Scale PSR48039
AWG-10 APG-59 Radar for McDonnell Phantom II F-4J/F-4S Aircraft equipped with this radar F-4J Phantom II F-4J(UK) Phantom II F-4S Phantom II McDonnell-DouglasFG.1/ FGR.2 Phantom
Aircraft detailing sets (resin)
Catalogue
£29.99
£26.99
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
Print Scale PSL48259
Hornet F/A-18A Part 1 1. McDonnell Douglas F/A-18A Hornet Bu No. 161957/NK413, VFA-25 aâé-~Fist of the Fleet, USS Constellation Finished in standard Dark Ghost Gray F.S.36320 over Light Ghost Gray F.S. 36375. 2. McDonnell-Douglas F/A-18A Hornet BuNo. 162451/AK202, VFA-132 aâé-~Privateers, Finished in standard Dark Ghost Gray F.S.36320 over Light Ghost Gray F.S. 36375
Aircraft decals (military)
Catalogue
£19.40
£17.46
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
Print Scale PSL48260
1:48
Lockheed P-38 Lightning in Bare Metal Part P-38L-5-LO 36th FS, 8th FG, 15th AF, USAAF - Le Shima, 1945.
Aircraft decals (military)
Catalogue
£19.40
£17.46
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
Print Scale PSL48261
Lockheed P-38 Lightning in Bare Metal Part 2 NEW
Aircraft decals (military)
Catalogue
£17.40
£15.66
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
Print Scale PSL48262
McDonnell-Douglas Hornet FA-18A Part 2 VFA-151 VFA-132
Aircraft decals (military)
Catalogue
£17.40
£15.66
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
Print Scale PSL48263
1:48
Republic P-47 C/D Razorback Robert S. Jonson Part 1 1. P-47D-5-RE aâé-l" Luckyaâé- (42-28461). February 1944. 2. P-47D -21-RE, aâé-l"Penrod and Samaâé- (42-25512) LM-Q Capt. Robert S Johnson, 62nd FS, 56th FG, Boxted, England May 1944. The aâé-l"Print Scaleaâé- Publishing Group team would like to thank Ed Shelnutt for his professional advice on the historical accuracy of this project, as well as Paul Moore for his idea and efforts ...
Aircraft decals (military)
Catalogue
£17.40
£15.66
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
Print Scale PSL48264
Republic P-47C/P-47D Razorback Robert S. Jonson Part 2 1. P-47C-2-RE aâé-l" Half Pint aâé- HV-P (41-6235). 2. P-47D-15-RE aâé-l" Double Lucky aâé- HV-P (42-76234). The aâé-l"Print Scaleaâé- Publishing Group team would like to thank Ed Shelnutt for his professional advice on the historical accuracy of this project, as well as Paul Moore for his idea and efforts to inspire our team during the work.
Aircraft decals (military)
Catalogue
£20.99
£18.89
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
Print Scale PSL48265
Lockheed P-38 Lightning hark Mouth Part 4 1. Lockeed P-38, F-4C-1-LO, S/No. 4267119 The Florida Gator, flown by Lt. Edward W. Durst, 22th PRS, 7th PG, 8th AF, Mount Farm, 1944. PRU Blue overall with yellow-orange and white sharksmouth motif on engine cowlings. Code 119 in white. Name on nose is white with a thin yellow-orange outline, mission markings in white. Crew names in white in a black bordered box. Wheel hubs are yel...
Aircraft decals (military)
Catalogue
£17.40
£15.66
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
Print Scale PSL48266
Messerschmitt Bf-109B/D Spanish War Part 1 1. Bf-109B-2 2.J88 Condor Legion 6x60 Herbert Schob La Cenia Spain late 1938. RLM 77, RLM 65. 2. Bf-109D-1 of 3/J 88, Spain, November 1938 Pilot, Hauptmann (Captain) Werner Molder. RLM 62, RLM 65. 3. Bf-109D-1 2.J/88, Legion Condor - Gotthard Handrick (5 victories). 18 June 1937 - 10 September 1938. RLM 62, RLM 65.
Aircraft decals (military)
Catalogue
£16.50
£14.85
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
Print Scale PSL48267
1:48
Messerschmitt Bf-109B/D Spanish War Part 2 1. Bf109D-1 "Legion Condor" Fighter Group Commander 88 Pilot: Hauptmann Walter Grabmann (final score 7), late 1938, Spain. RLM 62, RLM 65. 2. Me 109D 1/J 88, Spain, August 1938. Pilot, Oblt. (Lieutenant) Otto Bertram.This aircraft was shot down on October 4, 1938. RLM 63, RLM 65. 3. Bf-109V-3 Obit. Hannes Traufloft, J/88, Sivilla/ Tablada airfield, December 1936. One of the fi...
Aircraft decals (military)
Catalogue
£16.50
£14.85
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
Print Scale PSL48268
Bloch MB.151/152 1. MB.151 C1. Unit: Armeĩ de l'Air. Serial: 12 (N364). Chartres Training Center, 1940. 2. MB.152 C1. Unit: 2 Escadrille, GC I/8, Armeĩ de l'Air. Serial: 16 (N34). 3. MB 151 C1 Delta 173, 24 Mira, Royal Hellenic Air Force, based at Elefsina, Greece, October 1940. 4. MB-152 C1, No. 507/3, operated by the 3rd Escadrille, GC ll/1 (SPA 94 ), Armeĩ de IAir, based at Buc, Northern France, spring 1940...
Aircraft decals (military)
Catalogue
£18.20
£16.38
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
Print Scale PSL48269
Lockheed P-38 Lightning Shark Mouth Part 5 P-38 Lightning Part 5 / 48-269 / 1. Lockheed P-38F-5-LO, S/No. 42-12623/16, flown by Capt. Robert L. Faurot, 39th FS, 35th FG USAAF, Port Moresby (New Guinea), early 1943. 2. P-38H-1 42-66532 of Maj Tom Lynch, CO of the 39th FS/35th FG, Tsili Tsili, September 1943.
Aircraft decals (military)
Catalogue
£17.40
£15.66
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
Print Scale PSL48270
Lockheed F-80 Shooting Star Part 4 1. Lockheed F-80C-5-LO aâé-l"Shooting Staraâé- 47-545/FT-545, flown by Col. John W. Mitchell, commander of the 63rd Fighter Wing, photographed on 26 March 1950 during the USAF Gunnery Meet at Nellis AFB.
Aircraft decals (military)
Catalogue
£16.50
£14.85
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
Print Scale PSL48198
Gloster Javelin FAW.9/9R Part-2 1. Javelin F(AW) Mk 2, XA 774. 'J', No.89 Squadron, RAF Stradishall, 1958. Standard scheme and national markings. White code 'J' on fin above squadron colours of light and dark blue. 2. Javelin F (AW) Mk 1, XA 623, 'G', No. 46 Squadron (B Flight). Standard scheme and national markings. Unit flash in red and white under nose roundel, repeated on a white rectangle on fin. Yellow 'G' on fin....
Aircraft decals (military)
Catalogue
£23.40
-
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
Print Scale PSW48017
Grumman Avenger RESIN RIMS AND ELASTIC RUBBER WHEELS consists of rims printed with hard 3D resin and tires printed with flexible 3D polymer that fully mimics the properties of natural rubber. This product can be easily painted with all available modeling paints and tinted. Unlike other polymer resins and rubbers, our product does not deteriorate over a long period of time, does not leave stains on the model storage shelves, do...
Aircraft wheels (resin)
Catalogue
£17.40
-
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
Print Scale PSW48018
1:48
Grumman F-14A/F-14B Tomcat RESIN RIMS AND ELASTIC RUBBER WHEELS consists of rims printed with hard 3D resin and tires printed with flexible 3D polymer that fully mimics the properties of natural rubber. This product can be easily painted with all available modeling paints and tinted. Unlike other polymer resins and rubbers, our product does not deteriorate over a long period of time, does not leave stains on the model storage ...
Aircraft wheels (resin)
Catalogue
£17.40
-
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
Print Scale PSW48019
Locheed-Martin F-35A Lightning RESIN RIMS AND ELASTIC RUBBER WHEELS consists of rims printed with hard 3D resin and tires printed with flexible 3D polymer that fully mimics the properties of natural rubber. This product can be easily painted with all available modeling paints and tinted. Unlike other polymer resins and rubbers, our product does not deteriorate over a long period of time, does not leave stains on the model stor...
Aircraft wheels (resin)
Catalogue
£17.40
-
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
Print Scale PSW48020
Boeing B-17F/B-17G Flying Fortress (designed to be used with Hong Kong Models, Monogram and Revell kits) RESIN RIMS AND ELASTIC RUBBER WHEELS consists of rims printed with hard 3D resin and tires printed with flexible 3D polymer that fully mimics the properties of natural rubber. This product can be easily painted with all available modeling paints and tinted. Unlike other polymer resins and rubbers, our product does not deter...
Aircraft wheels (resin)
Catalogue
£17.40
-
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
Print Scale PSL48251
1:48
"Adam's head" on the wings of the Great War 1/48 Part 2 1. Albatros D.III (Oef) 153.52 Flik 41J, Torresella, zima 1917-1918, Hptm. Godwin Brumowski. 2. Albatros D.III (Oef) 153.45 Flik 41J, Torresella, prosinec 1917, Hptm. Godwin Brumowski. 3. Breguet XIV A2 10.21, 3th Squadron, Polish Air Force 1920. 4. PhĦnix D.I 328.26. [Phonix]
Aircraft decals (military)
Catalogue
£19.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
Print Scale PSL48256
Hawker Hurricane Aces in the Mediterranean & Africa. Part 4 1. Hurricane Mk. I (Trop), W9298/X, 33 Squadron RAF, flown by S/Ldr E. A. Howell, Maleme, Crete, May 1941. 2. Hurricane Mk. I, W9349/F "Pride of Ceylon", 213 Squadron RAF, flown by P/O J. Stowrey, Famagusta, Cyprus, October 1941. 3. Hurricane Mk. I, Z4223/V, 213 Squadron RAF, flown by F/OG.H.Westlake, Nicosia, Cyprus, October 1941. 4. Hurricane Mk. I, V7599/...
Aircraft decals (military)
Catalogue
£17.40
-
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
Print Scale PSL48206
Bristol Beaufighter TF.Mk.X Part-2 1. Beaufighter TF.Mk.X. Unit: 45 Sqn, RAF. Serial: OB-A (RB858).
Aircraft decals (military)
Catalogue
£17.30
-
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
Print Scale PSL48248
USAF Lockheed U2/TR-1 Part 2 1. Lockheed U-2A, NACA-320. This is actually the prototype, as it appeared in February, 1957. The purpose of the NACA, (later to become NASA),markings was purely a cover-up exercise. The aircraft is shown as it appeared in the first officially released photograph of the U-2. 2. Lockheed U-2A, NASA 55741. This aircraft is shown in the overall black scheme, that would later become famillar on lat...
Aircraft decals (military)
Catalogue
£17.70
-
In Stock
5+

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

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