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=362475 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 78 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
Furball Aero-Design FBD48085
Lockheed-Martin F-35A Anthology Part FOUR Our first set "F-35 Anthology Part IV" (48-085) features options for 26! F-35As from 6 countries. Here's the list of aircraft included in this mega set: -F-35A 18-5354, 354TH FW FLAGSHIP, EIELSON AFB, 2020 -F-35A 18-5376, 356TH FS, EIELSON AFB, 2020 -F-35A 19-5481, 355TH FS, EIELSON AFB, 2021 -F-35A 18-5355, 355TH FS FLAGSHIP, EIELSON AFB, 2021 -F-35A 15-5200, 421ST FS ...
Aircraft decals (military)
Catalogue
£21.99
£19.79
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
Furball Aero-Design FMS027
Lockheed-Martin F-35A Lightning II Kit. This set has mask elements for the canopy, sensor windows, and wheel hubs. (designed to be used with Tamiya kits)
Aircraft paint masks (self adhesive)
Catalogue
£6.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
Furball Aero-Design FBD48089
1:48
USMC Rhinos part 3 with options for 8 McDonnell F-4Ns and 2 F-4J Phantoms. -VMFA-321 F-4N 153207, NAF Andrews, 1978 aâé-l"MG-00aâé- -VMFA-314 F-4N 152237, MCAS El Toro, 1973 aâé-l"VW-6aâé- -VMFA-314 F-4N 150640, MCAS El Toro, 1978 aâé-l"VW-00aâé- -VMFA-531 F-4N 152223, MCAS Cherry Point, 1978 aâé-l"EC-01aâé- -VMFAT-101 F-4N 150630, MCAS Yuma, 1977 aâé-l"SH-32aâé- -VMFA-531 F-4N 153050, USS Coral Sea, 1979 aâé-l"NK-210/ Catwalkeraâé-...
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
Furball Aero-Design FBD48090
1:48
Republic P-47D Thunderbolt Stencils and Data This set offers two complete sets of stencils and data decals for your P-47 model. D-Day invasion stripes, underwing IFF lights, as well as propeller markings are also included. [P-47D-30RE P-47D-25RE P-47D-30RA]
Aircraft decals (military)
Catalogue
£10.99
£9.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
Furball Aero-Design FBD48091
Lockheed-Martin F-35B Anthology Part V The latest edition in our F-35 Anthology series features 12 options for the new Tamiya F-35B kit. Two complete models can be built with the stencils provided. The jets covered include: -VMFA-542 F-35B 170064, (WH-01) MCAS Cherry Point, 2023 (black and yellow tailed CO jet) -VMFA-542 F-35B 170069, (WH-06) MCAS Cherry Point, 2023 (standard gray line jet) -VMFA-225 F-35B 169920, ...
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
Furball Aero-Design FBDS4826
Re-printed! "Colors and Markings of Republic F-105s Thunderchief Part I" (F/D&S-4826) has 15 options for F-105D/F/G's in 1/48 scale. All of these jets have the nose art and markings that they carried while serving in the Vietnam War. Here's a rundown of the aircraft that are covered in this set: F-105D 60-5375, 33rd TFS, "OLD CROW", TAKLHI RTAB, 1970 F-105D 59-1743, 34TH TFS, "ARKANSAS TRAVELER, KORAT RTAB, 1968 F-105...
Aircraft decals (military)
Catalogue
£19.99
£17.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
Furball Aero-Design FBDS4828
1:48
aâé-l"Colors and markings of Grumman A-6 Intrudersaâé- has options for ten A-6E Intruders and continues our collaboration with our friends from Detail & Scale. -VA-304 A-6E 155620, NAS Alameda, 1994 aâé-l"ND-06aâé- -VA-115 A-6E 155707, USS Independence, 1994, aâé-l"NF-500aâé- -VA-196 A-6E 154156, USS Carl Vinson, 1995, aâé-l"NK-503aâé- -VA-185 A-6E 155685, USS Midway, 1989, aâé-l"NF-400aâé- -VA-155 A-6E 152916, USS Ranger, 1991 aâé-l"...
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
Furball Aero-Design FBDS4829
Colors and Markings of Republic P-47D and P-47Ms Thunderbolts Part 1 -P-47D-16-RE 42-76005, Lt Jim Eubanks, 65TH FS, 57th FG, 1944 aâé-l"Doggieaâé- Nose Art -P-47D-15-RE 42-75820, Lt Stan Morrow, 65TH FS, 57th FG, 1944 aâé-l"The Wogaâé- Nose Art -P-47D-25-RE 42-26421, 66TH FS, 57th FG, 1944 aâé-l"War Bond Planeaâé- Nose Art -P-47D-30-RE 44-21043, Capt. A.M. Wolbes, 65TH FS, 57th FG, 1945 aâé-l"Miss Milovin IIaâé- Nose Art -P-47D-...
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

Furball Aero-Design FBD48053
Re-printed! Bombcat Weapons Set. contains all the markings you need to dress up the ordnance for your late model Grumman F-14A/F-14B Tomcat bomb droppers. Here are the specific makings included: -(6)GBU-12 -(6)BLU-111A/B -(4)GBU-31(V)1/B with BLU-117 warhead -(4)GBU-31(V)1/B with Mk-84 warhead -(4) Mk-83 -(4) GBU-16 -(4) BLU-117A/B -(4) GBU-24A/B -(4) MK 20 -(4)GBU-10 -(4) Mk-84 -(4) BLU-110...
Aircraft decals (military)
Catalogue
£19.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
Furball Aero-Design FBD48074
Reprinted! ' USN Fighter Squadron Aircrew Patches' . This set features over 150 tiny Fighter Squadron patches to dress up your 1/48 scale figures. Patches are included for all US Navy fighter squadrons from the Vietnam era thru the 2000s. These little gems are reproduced in exquisite detail as only Cartograf can achieve.
Figure decals
Catalogue
£7.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

Furball Aero-Design FBD48047
1:48
Re-prinred! McDonnell F-4B/N, F-4J/S Phantom Cockpit Detailing Set Alleviates the tedious task of cockpit painting. This set includes instrument panel decals that are designed to exactly fit the Academy cockpit parts. Decals are also included for enhancing the kit's ejection seats including seatbelts and ejection ring handles. One set of decals is included for F-4B/N cockpits, and one set is included for F-4J/S cockpits. [F-4 ...
Aircraft decals (military)
Catalogue
£7.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
Furball Aero-Design FBD48075
Re-printed! 'Lockheed-Martin F/A-18E, F/A-18F, F/A-18G Hornet Cockpit Detail Set' . This set is sized to work with specifically with the 1/48 Hasegawa series of kits. This set has decals to enhance the cockpit parts and alleviate the tedious task of detail painting. Decals for the instrument panels, display screens (in various configurations), and ejection seats are included. Enough decals are contained to build 2 complete coc...
Figure decals
Catalogue
£7.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
Furball Aero-Design FBD48086
1:48
"Growler Anthology Part III" (48-086) featuring options for seven colorful Grumman EA-18Gs. Here's a roundup of the aircraft covered: -EA-18G 168937, VAQ-131, "NL 550", NAS Whidbey Island, 2022 "Full color CO jet with Roman Warrior markings on the inner and outer tails -EA-18G 166858, VAQ-132, "NL 540", NAS Whidbey Island, 2022 "Black tailed CO jet with large red stinger squadron emblem painted on the tail as well as red...
Aircraft decals (military)
Catalogue
£21.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
Furball Aero-Design FBD48087
"Growler Anthology Part IV", (48-087) which also features options for seven colorful Grumman EA-18Gs. Here are the aircraft covered: -EA-18G 166893, VAQ-130, "AC 504", USS Eisenhower, 2022 "Lo-viz line jet with large black dragons painted on the tails -EA-18G 166858, VAQ-132, "NL 540", NAS Whidbey Island, 2022 "Colorful Scorpions CO jet with special rising sun tail markings commemorating the squadron's deployment to Japa...
Aircraft decals (military)
Catalogue
£21.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

Furball Aero-Design FBD48002
Re-printed! Douglas F4D-1 Skyray 'Fast Fords' (11) -F4D-1 130747, Naval Air Test Center, NAS Patuxent River, 1955 -F4D-1 130743, Naval Air Test Center, NAS Patuxent River, 1960 -F-6A 134806, US Navy Test Pilot School, NAS Patuxent River, 1966 -F4D-1 134809, VF-141 "NK-213", USS Ranger, 1958 -F4D-1 134843, VF-13 "AK-102", USS Shangri La, 1962 -F4D-1 134870, VF-102 "AJ-00", USS Forrestal, 1961 -F4D-1 134497, VF...
Aircraft decals (military)
Catalogue
£19.99
£17.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
Furball Aero-Design FBD48027
"Electric Intruders" This set has marking options for 11 different EA-6As. Enough stencil and data markings are included to build two complete models. Here's a rundown of the aircraft covered: -VMCJ-1, EA-6A 156986, "RM-6", Da Nang AB, Vietnam, 1971 -VMCJ-1, EA-6A 156984, "RM-624", USS Midway, 1975 -VMCJ-2, EA-6A 156992, "AA-612", USS Forrestal, 1971 -VMCJ-2, EA-6A 156991, "AC-610", USS Saratoga, 1972 -VMCJ-2, E...
Aircraft decals (military)
Catalogue
£19.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
Furball Aero-Design FBDS4827
1:48
"Colors & Markings of U.S. SBD's" continues our collaboration with out friends from Detail & Scale publications. This set has marking options for 18 SBD-3/4/5/6/A-24Bs. Enough stencils are included to build 2 complete models. Here are the aircraft covered in this set: VS-5 SBD-3, "White 5-S-14", USS YORKTOWN, 1941 (Gull Gray Scheme) VS-2 SBD-3, "White S-12", USS LEXINGTON, 1942 (Blue/Gray Scheme) VS-2 SBD-3, "White 2-...
Aircraft decals (military)
Catalogue
£19.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

Furball Aero-Design FBD48054
Re-printed! "Growler Anthology Part II" is a follow on to our very popular first release for the EA-18G. For this release we have marking options for 16 different EA-18Gs. Enough stencil and data markings are included to build two complete models. Here's a rundown of the aircraft covered: -VAQ-129, EA-18G 166859, NAS Whidbey Island, 2016 (NJ 550) - VAQ-129, EA-18G 168901, NAS Whidbey Island, 2016 (NJ 514) - VAQ-129, E...
Aircraft decals (military)
Catalogue
£21.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

Furball Aero-Design FBDS4813
Re-printed! ' Colors and Markings of U.S. Navy Tomcats' series. This time (FBDS4813) covers (6) Grumman F-14A Tomcats, (2) F-14Bs, and (1) F-14D. This set was designed using the excellent references provided in Detail and Scale's 'Colors and Markings of U.S. Navy F-14 Tomcats Part 1 and Part 2' . This set includes an 8.5' x 12' main decal page, an 8.5' x 4' insert decal page, as well as our 5' x 8' 48-059 stencil set. Two comp...
Aircraft decals (military)
Catalogue
£27.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

Furball Aero-Design FBD48020
Re-printed! IAI F-21A Lion Cubs featuring markings for six colorfully camouflaged USN/USMC F-21A Kfirs. Enough stencil and data decals are included to make two complete models. They are sized to fit the Kinetic kit, and include options for the following aircraft: F-21A 999709, VF-43, NAS Oceana, 1987, Ghost Scheme F-21A 999703, VF-43, NAS Oceana, 1987, Ghost Scheme F-21A 999731, VMFT-401, MCAS Yuma, 1989, Israeli De...
Aircraft decals (military)
Catalogue
£18.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

Furball Aero-Design FBD48022
Re-printed! Douglas A-3D-2 Skywarrior. Features options for 10 aircraft. Sized to fit the Trumpeter kit, the aircraft included are: A3D-1 135415, VAH-1, USS Shangri-La, 1956 A3D-1 135436, VAH-2, 1956 A-3B 147655, VAH-2, USS Coral Sea, 1956 A3D-2 138964, VAH-9, USS Saratoga, 1958 A-3B 142664, VAH-11, USS Roosevelt, 1964 RA-3B 144847, VAP-61, 1966 (Overall Black Night-Recon Scheme) A3D-2 135432, VAH-3, 1963 A3D-2 142661,...
Aircraft decals (military)
Catalogue
£20.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

Furball Aero-Design FBD48071
Re-printed! McDonnell F-15C/F-15E Heritage Eagles' covers 4 USAF F-15s in colorful commemorative schemes: -F-15E 91-0603, 494th FS, RAF Lakenheath, 2019 (D-Day 75th Anniversary scheme with invasion stripes and nose art) -F-15E 97-0219, 492nd FS, RAF Lakenheath, 2019 (D-Day 75th Anniversary scheme with invasion stripes and nose art) -F-15C 84-0010, 493rd FS, RAF Lakenheath, 2019 (D-Day 75th Anniversary scheme with inva...
Aircraft decals (military)
Catalogue
£20.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

Furball Aero-Design FBD48072
1:48
Re-printed! ' USAFE MOD Eagles' has options for fifteen European basedMcDonnell F-15A/C/F-15Ds in the subdued Mod-Eagle paint scheme. The Eagles covered include: -F-15C 84-0001, 493rd FS, Forward deployed at a Southwest Asia Air Base, 2019 (Decepticon logo on the nose along with 'Starscream' in the crew name block -F-15C 86-0164, 493rd FS, Forward deployed at a Southwest Asia Air Base, 2019 'Deadpool' in the crew name bl...
Aircraft decals (military)
Catalogue
£20.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
Furball Aero-Design FBD48083
Lockheed-Martin F-16 Stencils (LATE)
Aircraft decals (military)
Catalogue
£9.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
Furball Aero-Design FVD002
"F-16 Reinforcement Plates" (FVD-002) replicates the airframe structural reinforcement plates found on many variants of the Viper.
Aircraft detailing sets (vinyl)
Catalogue
£7.99
-
In Stock
5+

   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