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=362427 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 89 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
Caracal Models CD48232
USAF Lockheed-Martin F-16D Viper Six marking options for USAF Lockheed-Martin F-16D two-seat Vipers, designed for the Kinetic kit. The six options on this decal sheet are: F-16D Block 42 90-0778 MiG-25 killer - 30th anniversary special scheme F-16D Block 40 89-2178 510 FS, Aviano AB F-16D Block 52 92-3924 157 FS, South Carolina ANG F-16D Block 52 92-3925 157 FS, South Carolina ANG F-16D Block 30 87-0365 182 FS, Texas AN...
Aircraft decals (military)
Catalogue
£15.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

Caracal Models CD48046
1:48
Re-printed! Next release! USAF/VNAF Douglas A-1E Skyraider: Designed for the recent Revell re-release of the 1/48 Matchbox A-1E kit, our first "fat face" Skyraider sheet features markings for seven USAF and two VNAF aircraft; all from the Vietnam War era. The options on this decal sheet are: A-1E 132649, (aircraft flown by Maj. Bernie Fisher during the mission that won him the Medal of Honor) A-1E 132619, "Carolyn's Folly"...
Aircraft decals (military)
Catalogue
£15.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

Caracal Models CD48050
Re-printed! Next release! Douglas AD-5 / A-1E Skyraider: U.S. Navy / USMC. Designed for the recent Revell re-release of the 1/48 A-1E kit (originally from Matchbox), our second A-1E Skyraider sheet features various U.S. Navy and USMC schemes. The options on this decal sheet are: AD-5 Skyraider BuNo 133878, VU-1 AD-5 Skyraider BuNo 133893, NAS Los Alamitos AD-5 Skyraider BuNo 133876, NAS Seattle AD-5 Skyraider BuNo 132466,...
Aircraft decals (military)
Catalogue
£15.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
Caracal Models CD48202
USAF F-104 Starfighter Colorful marking options for natural metal early USAF F-104A/B/C Starfighters. USAF F-104A/C Starfighter The F-104 Starfighter served in the United States Air Force (USAF) from the late 1950s to the early 1970s. Known for its sleek design and impressive speed capabilities, the F-104 was used primarily for air defense missions and played a crucial role in the Cold War-era arms race; and later became the...
Aircraft decals (military)
Catalogue
£15.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
Caracal Models CD48218
US Navy Douglas A-4E/F Skyhawk A workhorse of the US Navy and Marines during the Vietnam War, the A-4 Skyhawk is an iconic and beloved aircraft among aviation enthusiasts who appreciate its unique blend of simplicity, speed, and versatility. This set for the A-4E/F variants of the Skyhawk features markings for several Navy and Marines units, including a camouflaged example that was briefly operated as an adversary aircraft fo...
Aircraft decals (military)
Catalogue
£15.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
Caracal Models CD48229
NASA McDonnell-Douglas F-18 Hornet NASA has operated a fleet of F/A-18 "legacy" Hornets for various flight research activities for years. These aircraft play a very important role for exploring new technologies and concepts in aviation - not to mention that they look great in the NASA color scheme! In this sheet, we provide markings for six NASA Hornets - both single and twin seaters, some with special markings for specific r...
Aircraft decals (military)
Catalogue
£14.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
Caracal Models CD48184
Sikorsky CH-53 Multiple marking options for US Navy & US Marine Corps twin-engine CH-53 variants. Includes USAF Super Jolly Green Giants, MH-53J Pave Low, Navy RH-53s and various USMC units. US Navy & Marines CH-53 The first sheet in our CH-53 series covers US Navy & Marines markings for the twin-engine variants of the venerable Sea Stallion. This sheet is designed for the Revell CH-53 kit.. The options on this decal she...
Aircraft decals (military)
Catalogue
£14.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

Caracal Models CD48063
Re-printed! Stearman PT-17 Kaydet / N2S "Kaydet": This decal sheet provides accurate markings for the new Revell kit of the legendary Kaydet trainer. The options on this sheet are: US Army Air Corps PT-17 U.S. Navy N2S2, NAS Corpus Christi, 1943 U.S. Navy N2S3, 1942 Royal Canadian Air Force PT-27 Chinese Air Force pre-delivery markings
Aircraft decals (military)
Catalogue
£11.99
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Caracal Models CD48146
North-American F-82 Twin Mustang The F-82 "Twin Mustang" was too late for WWII and its service in USAF was short, but its unique looks and performance earned distinction over Korea. For this new sheet, we researched some of the most interesting markings carried by this type. Most of the options we provide on this sheet are for the F-82G variant, but we also include markings for one 27th FEG F-82E. This set was designed for...
Aircraft decals (military)
Catalogue
£15.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
Caracal Models CD48227
1:48
Lockheed-Martin F-16C "Dark Vipers" Part 4 Here is the latest installment in our series of "Dark Vipers" sheets which feature USAF F-16s in the "Have Glass V" scheme. In this set we provide four marking options for Vipers wearing the now-familiar overall dark gray scheme. The four options on this sheet are: F-16C Block 42 89-2112, 112nd FS, Ohio Air National Guard F-16C Block 30 86-0216, 301st FW, Texas Air National Guar...
Aircraft decals (military)
Catalogue
£14.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
Caracal Models CD48228
Aggressors Now - and Then" This multi-subject sheet features markings for five different types of aircraft flown in aggressor roles by USAF. Starting with the most modern USAF jet to fly in this role (F-35A), we provide markings for the striking "Wraith" F-16C in an overall black scheme, and three Soviet jets that were operated by the top-secret "Constant Peg" program. The markings for "Constant Peg" jets were designed using...
Aircraft decals (military)
Catalogue
£14.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

Caracal Models CD48138
1:48
Re-printed! Lockheed F-117A Nighthawk Stealth Fighter. Our first 1/48 sheet for the F-117A features a comprehensive selection of options covering the entire service history of this important aircraft. In addition to examples attached to every operating unit in Holloman during the 2000s, we provide markings for 6 aircraft that flew in Desert Storm; each with unique bomb bay artwork and accurate crew names. Markings for "Vega 31...
Aircraft decals (military)
Catalogue
£13.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
Caracal Models CD48166
Lockheed-Martin F-22 Raptor. Our first 1/48 scale decals for the F-22 Raptor provide a variety of accurate markings for different units that fly the most advanced fighter in the USAF inventory. We provide options for fourteen (14) USAF Raptors, some with unique nose art or unit flagship markings. The aircraft featured on this sheet are: F-22A 10-4193, 3WG, Elmendorf AFB F-22A 10-4195, 525FS, Elmendorf AFB F-22A 06-4115, 52...
Aircraft decals (military)
Catalogue
£14.99
£13.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
Caracal Models CD48200
Rockwell B-1B Lancer - Part 3 Multiple marking options for camouflaged USAF B-1B Lancers from the 1980s - early 1990s. Our third 1/48 scale set for the B-1B Lancer features markings for aircraft from the early Strategic Air Command years of the B-1B operations. We provide options for ten camouflaged Lancers, each with unique and colorful nose art. The aircraft featured on this sheet are: B-1B 86-0095 "Mystique", 28th BW, Ell...
Aircraft decals (military)
Catalogue
£15.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
Caracal Models CD48206
USAF Sikorsky CH-53 Multiple marking options for USAF CH-53 variants (HH-53/MH-53). USAF CH-53 / MH-53 The second sheet in our CH-53 series features markings for thirteen USAF CH-53/HH-53 and MH-53 helicopters. The options on this sheet cover the entirety of the type's service in the US, starting from the Vietnam War era all the way to the last MH-53 Pave Lows. This sheet is designed for the 1/48 scale Revell CH-53 kit - p...
Aircraft decals (military)
Catalogue
£14.99
£13.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
Caracal Models CD48216
US Navy LTV A-7A/B Corsair Multiple marking options for US Navy LTV A-7A/B Corsairs. featuring five colorful US Navy A-7A/B Corsairs, including VA-46 with its intricate tartan design on the tail. This sheet was designed to fit the Hobby Boss A-7A/B kit. The options on this decal sheet are: A-7B BuNo.154502, VA-46, USS John F Kennedy A-7B BuNo.154375, VA-72, USS John F Kennedy A-7A BuNo.153237, VA-93, USS Midway A-7B BuN...
Aircraft decals (military)
Catalogue
£14.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
Caracal Models CD48225
Lockheed-Martin F-35A International Thirteen new marking options for F-35A Lightning II fighters from USAF, Australia, Denmark, Israel, Japan and Norway. F-35A International This 1/48 scale sheet for the F-35A features 13 more marking options from USAF and allied forces - including the very colorful Royal Norwegian Air Force 75th anniversary scheme and the Israeli test jet of the MANAT unit. The options on this decal sheet ...
Aircraft decals (military)
Catalogue
£14.99
£13.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
Caracal Models CD48226
Lockheed-Martin F-22 Raptor - Part 2. Our second 1/48 scale decal sheet for the F-22 features markings for fifteen (15) USAF Raptors, some with unique nose art or unit flagship markings. The aircraft featured on this sheet are: F-22A 07-4147, 477FG, Elmendorf AFB F-22A 09-4190 anniversary markings, 90FS, Elmendorf AFB F-22A 07-4149, 90FS, Elmendorf AFB F-22A 91-4006 "4006" nose art, 412TW, Edwards AFB F-22A 91-4007 "007"...
Aircraft decals (military)
Catalogue
£14.99
£13.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

Caracal Models CD48064
North-American F-100D Super Sabre "Hun" in Vietnam - Part 1: The first installment of a two-sheet series chronicling the service of F-100 in Vietnam; this sheet features nine camouflaged "Huns" from different units. Many of these interesting options have not been done in decal form before. The sheet includes enough stencilling and national insignia to build any two of the aircraft featured on the sheet. The F-100 Super Sabre w...
Aircraft decals (military)
Catalogue
£14.99
£13.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
Caracal Models CD48205
McDonnell F-15C Eagle In addition to being the backbone of the current USAF fighter lineup, the F-15 has also been operated by NASA for various research and flight test acitivities. This colorful decal sheet provides markings for several NASA Eagles, in addition to the colorful NASA ACTIVE and MTD technology demonstrator platforms. The ACTIVE and MTD markings on the sheet are intended for advanced modelers, and please note th...
Aircraft decals (military)
Catalogue
£13.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
Caracal Models CD48219
Douglas B-26K Counter Invader Multiple marking options for B-26K (A-26A) Counter Invaders from the Vietnam War and Congo conflict. Designed for the ICM kit. An updated and strengthened version of the legendary WWII A-26 Invader attack bomber, the B-26K Counter Invader served in the Congo conflict and in Vietnam between 1966 and 1969. This decal sheet is intended for the ICM kit and provides accurate and colorful markings for ...
Aircraft decals (military)
Catalogue
£13.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

Caracal Models CD48102
Re-printed! Lockheed F-104C in Vietnam Our first sheet for the F-104 is dedicated to the Vietnam War service of Lockheed's famous "missile with a man in it". This set features markings for two silver and eight camouflaged Starfighters, for a total of 10 options: F-104C 56-0919, 479 TFW - Da Nang AB, 1965 F-104C 56-0892, 479 TFW - Da Nang AB, 1965 F-104C 56-0891 "NancyJ / Snoopy Sniper", 479 TFW - Udorn AB, 1966 F-104C 56-0...
Aircraft decals (military)
Catalogue
£13.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

Caracal Models CD48126
Re-printed! Lockheed U-2R/S & ER-2. Our second sheet for the U-2 features 11 different markings options for the later, longer-fuselage derivatives. There is something on this sheet for every U-2 enthusiast: current U-2S from Beale and the Osan detachment, several Desert Storm-era jets with colorful tail art, NASA ER-2 with both Dryden and Armstrong Flight Research Center options (plus bonus markings to build the temporary ...
Aircraft decals (military)
Catalogue
£13.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
Caracal Models CD48203
USAF "S.E.A. Camo" Heritage Republic A-10C & F-16C: In this decal sheet, we provide markings for two "heritage jets" from two different USAF units that were painted in the South East Asia (SEA) camouflage scheme. The A-10C belongs to the USAF A-10 Demonstration Team and wears the heritage scheme to honor 355th TFW's contribution to the Vietnam War; and the F-16C is from the 149th FW. The options on this decal sheet are: A-1...
Aircraft decals (military)
Catalogue
£11.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
Caracal Models CD48207
Piasecki HUP Retriever Markings for US Navy / Royal Canadian Navy Piasecki HUP "Retriever" helicopters. One of the most important early helicopter types to enter US Navy service, the HUP Retriever served as a carrier-based rescue and utility helicopter during the 1950s and early 1960s. Our decal sheet for the Retriever is intended to be used on the AMP kit. The options on this decal sheet are: HUP-2 Retriever BuNo.147622, ...
Aircraft decals (military)
Catalogue
£13.99
-
In Stock
1

   1   |   2   |   3   |   4      »      [4]

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