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.price_set = 1 
		 AND P.product_category_id = 105 
		AND pc.show_in_search = 1

	 AND (P.product_category_id = 103 OR P.price_set) GROUP BY P.id ORDER BY DATE_FORMAT(P.arrival_date,"%Y-%m-%d %H")   DESC  ,  P.code
New Arrivals | Hannants
Hannants News Feed Subscribe To This Search | Create Search Alert Create Search Notification

New Arrivals



Found 1,954 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

Scale

Product Type

Manufacturer

Added Within

Manufacturer & Catalogue No ASC DESC
Scale ASC DESC
Description ASC DESC
Type ASC DESC
Department ASC DESC
Delivered 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 PSL72510
Nieuport N.17- N.24 1. Nieuport 24 né° N 4663 du Sgt Andrƒ© Lƒ©vy - Dessin David Mƒ©chin. 2. Nieuport 21E1 No. 4227 Advanced Pilots School In Grudziadz, July 1921. 3. Nieuport 23 Russian, 2nd Lt.K. Krauzes, 8th Fighter Airborne Sqn, Summer 1917. 4. Nieuport 23 aircraft No. 2903 assigned to Escadrille N 562-SPA 561, piloted by Slt Marcel Robert, of the French forces in Venice, Italy during the Summer 1917. 5...
Aircraft decals (military)
New Arrivals
19/03/2024
£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

Xtradecal X48032
Re-printed! RAF National Insignia/Roundels A1 Type. Sizes 30 inches , 35 inches , 42 inches , 45.5 inches , 49 inches , 56 inches , 64 inches ,70 inches , 84 inches (RAF Roundels)
Aircraft decals (military)
New Arrivals
19/03/2024
£4.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

Xtradecal X48209
Re-printed! Lockheed F-104 Starfighter Collection Pt2 (7) RF-104G Starfighter '9054/FX90' of 10th Tactical Wing, Force aƒ©rienne belge, (Belgian Air Force) based at Kleine-Brogel, Belgium, 1980. CF-104 Starfighter, '104761', of the 4th Wing, Canadian Armed Forces, based at CFB Baden- Solellingen, West Germany, 1983. F-104G Starfighter, 'R-345' of Esk.723 FlyvevƒÆ'é¥bnet, (Royal Danish Air Force), based at Aalborg, Denmark, ...
Aircraft decals (military)
New Arrivals
19/03/2024
£8.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

Xtradecal X72126
Re-printed!! RAF WWII Red 8' serial letters and numbers, stencil and non-stencil styles and 48' x 30' x 6' code numbers to go with MD082. To replace Modeldecal MD083 which is now out of print.
Aircraft decals (military)
New Arrivals
19/03/2024
£4.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

Xtradecal X72204
Re-printed!! de Havilland DH.82A Tiger Moth Pt 2 in Colourful Civil schemes. (9) ZK-BFH Croydon Aircraft Works, Manderfield Airfield New Zealand 2006 Yellow/Silver; G-APMX K.B.Palmer, Popham, Hants 1980 Yellow/Silver; G-ANEZ Isle of Wight Gliding Club 1969 Red/Silver; G-ANEN Berkshire 2009 Red/Silver; G-ADVZ Scottish-Aviation 12ERFTS, Prestwick, 1935 Orange/Silver; G-ADOF Airwork/11ERFTS Perth, Scotland 1936 White/Silver; G-AE...
Aircraft decals (military)
New Arrivals
19/03/2024
£8.99
-
In Stock
17

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

Xtradecal X72212
Re-printed! RAF WWII Dull red letters and numbers 36' high x 6' and 4.5' strokes. Was MD084. 8' red serials to go with this sheet on Xtradecal X72126. (RAF codes/RAF code letters/RAF serial numbers) See also X72RAF2
Aircraft decals (military)
New Arrivals
19/03/2024
£4.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

Xtradecal X72313
1:72
Re-printed! Mikoyan MiG-17F, PZL-Mielec Lim-5 & Shenyang J-5 Collection (12) aâé-¢ Mikoyan-Gurevich MiG-17F (Fresco C), 'Red 15', of Voennovezdusni sili (Bulgarian Air Force), Bulgaria, 1960s. aâé-¢ Mikoyan-Gurevich MiG-17F (Fresco C), '1411', of Ye Ithopya Ayer Hayl, (Ethiopian Air Force), flown by Cuban Air Force pilots during the Ogaden War, Eithiopia, 1977-78. aâé-¢ Mikoyan-Gurevich MiG-17F (Fresco C), 'Red 630', of Jagdflie...
Aircraft decals (military)
New Arrivals
19/03/2024
£8.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
Xtradecal X72327
Re-printed!! BAe Jetstream Collection (6) British Aerospace Jetstream T.2, XX478/CU64/564 of 750 NAS, Royal Navy, based at RAF Culdrose UK, 2009. Scottish Aviation Jetstream T.2, XX490/CU70/570, of 750 NAS, Royal Navy, based at RAF Culdrose UK, 30 July, 1985. Scottish Aviation Jetstream T.2, XX475 of Defense Evaluation & Research Agency, based at RAF Cottesmore UK, 2000. British Aerospace Jetstream 32EP, HS-DCA, of Thailan...
Aircraft decals (military)
New Arrivals
19/03/2024
£8.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
Xtradecal X72341
Re-printed!! Westland Whirlwind Collection (11) Sikorsky Whirlwind HAS.7 XN387/'626' of Royal Navy,seen at RNAS Abbotsinch July, 1961 Westland Whirlwind HAS.7 XN384/'H' of 846 Naval air Squadron, Royal Navy, based aboard H.M.S. Albion, 1962. Sikorsky Whirlwind HAR.3 XG588/'995' of H.M.S. Warrior Ships Flight, Royal Navy, During 'Operation Grapple' Atomic Weapons Tests, 1957. Westland Whirlwind HAR.9 XL899'8' of H.M.S. Endu...
Aircraft decals (military)
New Arrivals
19/03/2024
£8.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
Yellow Wings YW32043
U.S. Navy Pre-WWII Douglas TBD-1 Devastator, VT-2 USS Lexington, VT-3 USS Saratoga Designed to fit the NEW (2023) Trumpeter 1/32 scale TBD-1 "Devastator" Contains decals for two complete Pre-War aircraft. One from VT-2 USS Lexington CV-2 for the 1st section leaders aircraft 2-T-1 Plus one from VT-3 USS Saratoga CV-3 for the 3rd section leaders aircraft 3-T-7 There are also decals for Neutrality Patrol Aircraft.
Aircraft decals (military)
New Arrivals
19/03/2024
£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
Yellow Wings YW32044
1:32
U.S. Navy Pre-WWII Douglas TBD-1 Devastator, VS-42 USS Ranger, VT-5 USS Yorktown Designed to fit the NEW (2023) Trumpeter 1/32 scale Douglas TBD-1 "Devastator" Contains decals for two complete Pre-War aircraft. One from VS-42 USS Ranger CV-4 for the 6th section leaders aircraft 42-S-16 Plus one from VT-5 USS Yorktown CV-5 for the 5th section leaders aircraft 5-T-13 There are also decals for Neutrality Patrol Aircraft.
Aircraft decals (military)
New Arrivals
19/03/2024
£16.99
£15.29
Out of Stock
0

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Yellow Wings YW32045
U.S. Navy Pre-WWII Douglas TBD-1 Devastator, VT-6 USS Enterprise, VS-71 USS Wasp Designed to fit the NEW (2023) Trumpeter 1/32 scale TBD-1 "Devastator" Contains decals for two complete Pre-War aircraft One from VT-6 USS Enterprise CV-6 for the 4th section leaders aircraft 6-T-10 Plus one from VS-71 USS Wasp CV-7 for the 6th section leaders aircraft 71-S-16 There are also decals for Neutrality Patrol Aircraft.
Aircraft decals (military)
New Arrivals
19/03/2024
£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
Yellow Wings YW32046
Early WWII U.S. Navy Douglas TBD-1 Devastator, VT-4 USS Ranger, VT-7 USS Wasp Designed to fit the NEW (2023) Trumpeter 1/32 scale TBD-1 "Devastator" Contains decals for two complete early WWII aircraft. One from VT-4 USS Ranger CV-4 for the 3rd torpedo section 4-T-8 Plus one from VT-7 USS Wasp CV-7 for the 3RD torpedo section 7-T-8
Aircraft decals (military)
New Arrivals
19/03/2024
£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
Yellow Wings YW32047
Early WWII U.S. Navy Douglas TBD-1 Devastator, VT-2 USS Lexington, VT-8 USS Hornet Designed to fit the NEW (2023) Trumpeter 1/32 scale TBD-1 "Devastator" Contains decals for two complete early WWII aircraft. One from VT-2 USS Lexington CV-2 (Pre Coral Sea) for the 4th section leaders aircraft 2-T-10 Plus one from VT-8 USS Hornet CV-8 (Pre Coral Sea, Pre Midway) for the 5th torpedo section 8-T-14
Aircraft decals (military)
New Arrivals
19/03/2024
£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

Italeri IT3645
Back in stock! Mercedes Benz 300SL Gullwing The Mercedes-Benz 300 SL was produced in 1954 by the German car manufacturer and it's a masterpiece on four-wheels for design, elegance and luxury. The 300 SL, where the acronym stands for Sport Leicht, (Sport Light), adopted innovative solutions for the time. The Mercedes 2 door coupe had a tubular frame, a front 2.996 cc longitudinal engine connected to a 4-speed transmission and t...
Car kits (injection)
New Arrivals
18/03/2024
£34.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
Kora KORPK72180
1:72
Saiman 202M Italian Service
Aircraft kits (injection)
New Arrivals
17/03/2024
£24.50
£22.05
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
Magic Factory MF5001
Vought F4U-1A/2 Corsair Dual Combo 2 kits in the box
Aircraft kits (injection)
New Arrivals
16/03/2024
£64.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
First To Fight Kits FTF108
French reconnaissance tank AMR35 ZT 1b Attention!!! The booklet is in Polish and English.
Military vehicle kits (injection)
New Arrivals
15/03/2024
£9.50
£8.55
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
Revell RV3356
Spahwagen Fennek
Military vehicle kits (injection)
New Arrivals
15/03/2024
£16.99
£15.29
Out of Stock
0

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
Revell RV5655
Gift Set "Conflict of Nations" - Exclusive Edition
Military vehicle kits (injection)
New Arrivals
15/03/2024
£99.99
£89.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

Caracal Models CD144001
RE-PRINTED!!! USAF Boeing KC-135R Stratotanker. The workhorse of the USAF tanker fleet since the 1960s, the KC-135 Stratotanker will be serving the USAF (and its allies) well into the 2010s. Our latest decal sheet is a very comprehensive tribute to the current version of the Stratotanker : the KC-135R. Our first 1/144 scale sheet is a scaled-down version of our best-selling 1/72 KC-135R sheet. This extensive set features mark...
Aircraft decals (military)
New Arrivals
15/03/2024
£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 CD32025
USAF Lockheed-Martin F-16D Fighting Falcon "Mig Killer" Anniversary desert camouflage markings for F-16D Mig Killer 90-0778 - limited edition of 250 sheets only. Accurate stencilling and national insignia for this specific jet are included. This decal sheet was professionally screen printed by Microscale in the US.
Aircraft decals (military)
New Arrivals
15/03/2024
£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 CD48028
RE-PRINTED!!! Air National Guard Fairchild A-10C Warthogs. Current ANG Fairchild A-10C markings for Arkansas ANG (184FS), Idaho ANG(190FS), Indiana ANG(163FS) and Michigan ANG(107FS). Our first decal sheet for the A-10 features four options for the recently upgraded Fairchild A-10C version of the venerable Warthog. The options on this sheet are: Fairchild A-10C 82-0661, 163 FS, Indiana ANG (commander's aircraft) Fairchild A...
Aircraft decals (military)
New Arrivals
15/03/2024
£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 CD48034
RE-PRINTED!!! Air National Guard Fairchild A-10C Part 2: The options on this sheet are: Fairchild A-10C 80-0188, 188 FW, Arkansas ANG (commander's aircraft) Fairchild A-10C 78-0614, 188 FW, Arkansas ANG Fairchild A-10C 79-0193, 127 FW, Michigan ANG Fairchild A-10C 80-0255, 127 FW, Michigan ANG
Aircraft decals (military)
New Arrivals
15/03/2024
£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 CD48186
Republic F-105B/F-105D Thunderchief Multiple marking options for USAF single-seat Thuds. The F-105 Thunderchief, affectionately known as the "Thud," held a prominent position in the USAF fleet from the late 1950s through the 1980s. With its robust design and remarkable strike capabilities, the F-105 played a vital role in various combat scenarios and strategic missions, leaving an indelible mark on aviation history. Renowned ...
Aircraft decals (military)
New Arrivals
15/03/2024
£15.99
£14.39
Out of Stock
0

[1]   «      44   |   45   |   46   |   47   |   48      »      [79]
-20 -10 | +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