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=7992 AND ps.id = 953 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 117 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

Re-printed! Vought F4U-1 Corsairs White 29 BuNo 17684 VF-17 Jan 31 1944 Pilot: Lt.(jg) Ira "Ike" Kepford. This is the second aircraft flown by the 16 victory ace, but the first to be numbered "29". White 3 BuNo Unknown VF-17 Feb 1944 Pilot: Lt.(jg) James "Big Jim" Streig. He flew two tours with VF-17 and is credited with 5.5 confirmed victories. L.A. City Limits BuNo Unknown VF-17 Mar 1944 Pilot: Lt.(jg) Doris C. "Chico" ...
Aircraft decals (military)
Catalogue
£21.50
£19.35
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
North-American P-51D Mustangs aâé-l"Sandyaâé- P-51D-5-NA LC-X S/N 44-13692 20th FG Pilot: Unknown, after October 194 Capt. Cartheledge Huey, Jr. aâé-l"Scat #5aâé- P-51D-10-NA 12-W S/N 44-14426 479th FG Pilot: Lt. Robin Olds aâé-l"Trigger IIIaâé- P-51D-10-NA YF-T S/N 44-14230 355th FG Pilot: Capt. Walter Cresham Jr. aâé-l"Man O Waraâé- P-51D-25-NA WR-A S/N 44-73144 355th FG Pilot: Col. Claiborne Kinnard Jr.
Aircraft decals (military)
Catalogue
£24.99
£22.49
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
1:32
de Havilland Mosquito Mk.VI TH-J HX819 418 "City of Edmonton" Sqn. Flown by several squadron pilots; however, F/O sid Seid and Dave McIntosh DFC are mainly associated with this aircraft. TH-G NS830 418 "City of Edmonton" Sqn. Crew: F/O Bert Ford and F/O John Clark YP-E PZ181 23 Sqn. Crew: George Steward DFC and F/O Paul Beaudet SM-M NT227 305 Sqn. Known Crew: F/Sgt. Antoni Mierzwa and F/O Eduard Panek. S/L P.H.C. Han...
Aircraft decals (military)
Catalogue
£24.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
Lockheed P-38 Lightnings in Europe Pilot Lt. Robin Olds aâé-l"Scat IIaâé- P-38J-15-LO aâé-l"Waâé- S/N 43-28707 479th FG Pilot Lt. Walter Zurney aâé-l"Taffyaâé- P-38L aâé-l"Saâé- S/N unknown 82nd FG Pilot Lt. Roy Scrutchfield aâé-l"Jeanneaâé- P-38J-10-LO aâé-l"KI-Raâé- S/N 42-67505 55th FG Pilot Lt. Arnold G. Helding aâé-l"Lucky Ladyaâé- P-38J-15-LO aâé-l"Laâé- S/n 43-28714 479th FG Includes scrap view details of nose art.
Aircraft decals (military)
Catalogue
£24.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

1:32
Re-printed! de Havilland Mosquito Mk.IV was the early bomber version of de Havilland's wooden wonder. Capable of high speed, it was also used in the photo-reconnaissance role. Markings for B.Mk.IV / PR.Mk.IV LY-G DK310 No 1 PRU August 1942 Grim Reaper HS-F DK333 109 Sqn 1944 AZ-B KB195 627 Sqn June 1944 Uncle Sam GB-N DK337 105 Sqn May 1943 Pilot: American, F/O "Bud" Fisher DFC AZ-Q DZ415 627 Sqn Early 1945
Aircraft decals (military)
Catalogue
£24.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
Focke-Wulf Fw-190A-5 Black 21" W.Nr. 7336 Pilot: Unknown Stabsstaffel JG 51 Date/Location Unknown Fw-190A-5 "Yellow 5" W.Nr. Unknown Pilot: Oblt. Rolf Hermichen 3./JG 26 Spring 1943, Russia Fw-190A-5 "Yellow 6" W.Nr. Unknown Pilot: Unknown 3./JG 26 Winter 1943 Rielbitzi, Russia Fw-190A-5 "White 7" W.Nr. Unknown Pilot:ƒ¢aš-Ë Unknown 1./JG 26 Winter 1943 Rielbitzi, Russia
Aircraft decals (military)
Catalogue
£25.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
Messerschmitt Bf-109G-2s "Black 13" Oblt. Gunther Rall Staffelkapitƒ¤n 8./JG 52 September 1942 "Mickey Mouse" Bf-109G-2/R6 Hptm. H. Carganico Kommandeur II./JG 5 Salmijƒ¤rvi, Finland May 1943 "Blue 5" 7./JG 54 probably Isotscha airfield Smolensk area, Russia, winter of 1942-43
Aircraft decals (military)
Catalogue
£24.99
-
In Stock
3

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Messerschmitt Bf-109G-2s "Double Chevron" Bf-109 G-2 Major Trautloft Kommodore JG 54, possibly Siwerskaja, Russia Aug. 1942 "Blue 1" Staffelkapitƒ¤n Lt. Georg-Peter Eder 12./JG 2 Beaumone-Le-Roger, France March 1943 "Black 8" Ofw. Jakob Norz 8./JG 5 Petsamo, Finland (Russia), winter 1943-44
Aircraft decals (military)
Catalogue
£24.99
-
In Stock
4

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Re-printed! North-American P-51D Mustang 357th FG Pt 1 (3) B6-S Col Bud Anderson `Old Crow' 363rd FS; G4-C Maj England `Missouri Armada'; G4-E Maj Kit Carson `Nooky Booky', both 362ndFS
Aircraft decals (military)
Catalogue
£17.50
£15.75
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

Vought F4U-1 Corsairs Big Hog BuNo Unknown VF-17 Feb/Mar 1944 Brat III BuNo Unknown VMF-225 Aug 1944 Lucybelle BuNo 18086 VMF-214 Nov 1943 Luscious Lil Nan BuNo Unknown VMF-321 Aug 1944
Aircraft decals (military)
Catalogue
£19.50
-
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

1:32
Re-printed! de Havilland Mosquito FB Mk.VI EG-T MM417 487 Sqn Feb 1944 Lady Luck TH-H NT137 418 Sqn Oct 1944 SB-S HR352 464 Sqn Mar 1945 Wag's "War-Wagon" UP-J NS838 605 Sqn Mar 1944
Aircraft decals (military)
Catalogue
£21.50
-
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
Focke-Wulf Fw-190A-5 "Yellow 11" W.Nr. Unknown Pilot:ƒ¢aš-Ë Unknown 3./JG 26 Spring 1943, Russia Fw-190A-4 "Black 11" W.Nr. Unknown Pilot: Gerhard Thyben 5./JG 54 May 1944, Russia Location Petseri, Northern Russian Front Fw-190A-4 "White 4" W.Nr. Unknown Pilot: Lt. Georg-Peter Eder 7./JG 2 Jan 1943 Vannes, France Fw-190A-4/U7 "White Chevron Triangle" W.Nr. 2472 III./JG 2 After Nov 1942 Vannes, France Pilot: Gruppenk...
Aircraft decals (military)
Catalogue
£25.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
Curtiss P-40s of the A.V.G 3rd Pursuit Squadron #47 Serial Number: P-8127, Pilot: R.T. Smith 3rd Pursuit Sqn. Note scalloped design applied to main wheel hubs. #49 Serial Number: P-8133 Pilot: Tommy Haywood, 3rd Pursuit Sqn. #68 Serial Number: P-8109, Pilot: Charles "Chuck" Older, 3rd Pursuit Sqn. Note scalloped design applied to main wheel hubs. "FIRST AID INSIDE DOOR" stencil on rear fuselage is non-standard Red...
Aircraft decals (military)
Catalogue
£24.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
Curtiss P-40 Tomahawk IIB
Aircraft decals (military)
Catalogue
£24.99
-
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
Curtiss P-40s of the A.V.G. 1st and 2nd Pursuit Squadron Four interesting and colorful Hawk 81-A2 aircraft (the export version of the P-40B/C) appear on this sheet. #3 Serial Number: P-8103 Pilot: Dick Rossi 1st Pursuit Sqn. #21 Serial Number: P-8182 Pilot: Greg "Pappy" Boyington 1st Pursuit Sqn. Note non-standard camouflage pattern on mid-port fuselage forward of cockpit. Fuselage numbers have faded to a Grey col...
Aircraft decals (military)
Catalogue
£24.99
-
In Stock
3

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

1:32
Re-printed! Messerschmitt Bf-109G-6 (4) Erich Hartmann's Yellow 1 9./JG 52; Yellow 1 9/JG 52 alternative; White 1 7.JG 52; << L/JG 53. last two have black 'tulips' on nose
Aircraft decals (military)
Catalogue
£24.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

1:32
Re-printed! North-American P-51D Mustang Part 4 (3) 44-72218 WZ-I 78th FG Col. John Landers 'Big Beautiful Doll' RAF Duxford; 44-13954 CL-P 55th FG LT Col John L. McGinn 'Da Quake'; 44-14151 HO-M 352nd FG Lt Col John Myer 'Petie 2nd' RAF Bodney
Aircraft decals (military)
Catalogue
£24.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
Supermarine Spitfire Mk.Ia KL*B (N3180), No. 54 Sq. Kiwi 1, pilot P/O Al Deere. QV*I (X4474), No. 19 Sqn., pilot Sgt. Bernard Jennings. LZ8N (R6800), No. 55 Sqn., pilot S/L Rupert 'Lucky' Leigh
Aircraft decals (military)
Catalogue
£24.99
-
In Stock
3

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Focke-Wulf Fw-190A-8/R2s ' Black 8' 11.Sturm/JG 3 Uffz. Willi Maximowitz June 1944, Dreux France ' Yellow 2' W.Nr. 682181 6./JG 300 Fw. Hubert Engst Dec 1944 LĦbnitz, Germany ' Black 4' 8/JG 300 Lt. Victor Heimann Feb 1945 LĦbnitz, Germany ' Yellow 12' Muschi 6/JG 300 Uffz. Paul Lixfeld Nov 1944 LĦbnitz, Germany
Aircraft decals (military)
Catalogue
£24.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

1:32
Messerschmitt Bf-109G-6 "Yellow 6" 12./JG 51, 1944 Eastern Front, pilot unknown "Red (or Black) 11", 2./JG 302 Jƒ¯é¿é½terbog Feb 1944 "Blue 14" Bf-109 G-6/R6 12./JG 2 Beaumont le Roger, France 1943 "Black 1" Bf-109 G-6/R6 8./JG 54 Spring 1944 Lƒ¼neburg, Germany
Aircraft decals (military)
Catalogue
£24.50
-
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

1:32
Messerschmitt Bf-109G-6 Tropical version (4) Yellow 1 12./JG 27 Greece 1943; White 3 7./JG 27 Franz Stadler Crete 1944; White 8 7./JG 27 Crete 1943; Yellow 13 II./51 Tuniasia 1943. All RLM 74/75/76 camouflage schemes with white fuselage bands and yellow undernose
Aircraft decals (military)
Catalogue
£17.50
-
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

Messerschmitt Bf-109G-6 "Red (or Black) 7" 2./JG 302 Jƒ¯é¿é½terbog February 1944 Pilot: Xaver Neumeier W. nr. Unknown "Blue 17" 12./JG 2 Beaumont le Roger, France 1943 "White 3" 1./JG 300 Wildesau Spring 1944 "White 11" Bf-109 G-6/R6 7./JG 54 Spring 1944
Aircraft decals (military)
Catalogue
£24.50
-
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

Messerschmitt Me-262B-1A/U1 Nightfighters of NJG 11 The study of late war camouflage schemes of the Me-262 B nightfighter mirrors the confusion of the late war. Available references provide all kinds of variations in schemes for the same aircraft. More than ever, modelers should consult their own references to draw conclusions. Notes created by Ronald Belling of "Red 8", W.Nr, 110305, before its re-paint, remain the best sour...
Aircraft decals (military)
Catalogue
£22.50
-
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

de Havilland Mosquito FB Mk.VI
Aircraft decals (military)
Catalogue
£21.50
-
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

1:32
Focke-Wulf Fw-190F "White 2" Fw-190A-9. Pilot: Unknown. W.Nr. 206000 III./KG(J) 27 Wels, Austria "Black 11" Fw-190F-8. Pilot: Unknown. Werknummer Unknown Luftflotte 4 "Yellow 13" Fw-190F-8. Pilot: Unknown. W.Nr. 582304 II./SG 10 Neubiberg, Germany "Black 3" Fw-190F-8 Pilot: Fw. Eugen LĦrcher Werknummer Unknown 5./SG 2 8 May 1945 Aufhausen, Germany
Aircraft decals (military)
Catalogue
£21.50
-
In Stock
5+