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 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 878 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 PSR32012
1:32
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 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 PSR72024
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
£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 PSL32035
Messerschmitt Bf-109G-6 Part 2 1. Me 109G-6 of 2/JG 300. Red 6 Germany summer 1944. 2. Me 109G-6 of 5./JG 53 aâé-l"Pikasaâé- Vienna (Austria), January 1944. Pilot: Oberfeldwebel Herbert Rollwage. 3. Me 109G-6 of I/JG 300. Helsinki-Malmi (Finland), March 1944. 4. Messerschmitt Bf-109G-6 of 2/JG 301 Germany, winter 1944. 5. Me 109G-6 of Stab I./ JG 27. Fels-am-Wagram (Austria), May 1944. Pilot: Hauptmann (captain) Ludwi...
Aircraft decals (military)
Catalogue
£22.80
£20.52
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 PSL32037
1:32
Luftwaffe Insignia. Winkel
Aircraft decals (military)
Catalogue
£25.99
£23.39
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 PSL72501
French Sopwith 1é½ Strutter 1. Sopwith B1, number 185 of Escadrille Sop 107, which operated as part of Groupe d'Bombardmet 3 (Gb3) from June 1917 until re-equipping with Breguet 14s in late 1917. At a time and in circumstances unknown to the artist, this aircraft was captured dy the Germans. The unit lnsignia was based on the Egyptian goddess Buto. 2. Sopwith A2, 4189 of Escadrille Sop 5, which flew this type from Septembe...
Aircraft decals (military)
Catalogue
£15.99
£14.39
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 PSL72502
1:72
Civil Consolidated PBY Catalina 1. PBY-5A, C-FNJB, c/n CV-249. The now defunct Canadian airline Norcanair operated this modified Catalina in a fire-fighting role from its Saskatoon base. The aircraft is basically natural metal with large areas for better visibility during missions. Tail and elevators are white, all titles in black. Note the Canadian flag on lower tail. 2. PBY-5A, N31235/98, c/n 48426. Slafco lnc. from M...
Aircraft decals (military)
Catalogue
£15.99
£14.39
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 PSL72503
AEG C.IV 1. AEG C.IV v.R C.7123/17. ? CWL 5.3 9th Reconnaissance Squadron, Krakow-Rakowice Airport. 2. AEG C.1042/16 may have been the AEG C.IV n/N.I prototype. It was sprayed in a two-color camouflage, probably in the typical green and mauve shown here. 3. AEG C.IV, 6623/16, nevertheless was the ancestor of the AEG N.I and the AEG J.I and J.II. This one is in standard factory sprayed camouflage finish with the black u...
Aircraft decals (military)
Catalogue
£15.99
£14.39
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 PSL72504
Fokker Dr.I Triplane 1. Fokker Dr.l 204/17 of Vzfw. Paul Baumer Jasta Boelcke, Halluin-Ost, May 1918. 2. Fokker Dr.l 413/17 of Oblt. Karl Bolle Jasta Boelcke, Halluin-Ost, May 1918. 3. Fokker Dr.l 209/17 of Vzfw. Paul Baumer, Jasta Boelcke, Marcke, March 1918. 4. Fokker Dr.1 403/17 by Lt. John Janzen, Jasta 6, Lien St Amand, February 1918. 5. Fokker Dr.l 556/17 from Lt. Ludwig "Lutz" Beckmann, Jasta 6, Lechelle, M...
Aircraft decals (military)
Catalogue
£15.99
£14.39
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 PSL72505
Republic P-47C/P-47D Thunderbolt Razorback Robert S. Jonson 1. P-47D-5-RE aâé-l" Luckyaâé- (42-28461). February 1944. 2. P-47C-2-RE aâé-l" Half Pint aâé- HV-P (41-6235). 3. P-47D-15-RE aâé-l" Double Lucky aâé- HV-P (42-76234). 4. 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.
Aircraft decals (military)
Catalogue
£16.50
£14.85
Out of Stock
0

   1   |   2   |   3   |   4   |   5      »      [36]
| +10 +20

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