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=85838 AND ps.id = 955
		 AND P.product_category_id = 108 
		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
Limited Availability | Hannants
Hannants News Feed Subscribe To This Search | Create Search Alert Create Search Notification

Limited Availability



Found 51 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

No Image
Eduard Big-Ed EBIG49274
Sukhoi Su-27UB (designed to be used with Kitty Hawk Model kits) This BiG-Ed set includes all these Eduard sets..... ED481037 Sukhoi Su-27UB exterior ED491130 Sukhoi Su-27UB interior DEFE1131 Sukhoi Su-27UB seatbelts STEEL EDEX733 Sukhoi Su-27UB canopy and wheels paint mask
Aircraft detailing sets (etched)
Limited Availability
£38.30
-
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
Eduard Big-Ed EBIG49313
Boeing F/A-18E Hornet (designed to be used with Hobby Boss kits) This BiG-Ed set includes all these Eduard sets..... ED491227 F/A-18E 1/48 EDFE1228 F/A-18E seatbelts STEEL EDEX811 F/A-18E (Eduard sold out March 2024 part 1)
Aircraft detailing sets (etched)
Limited Availability
£23.60
-
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
Eduard Big-Ed EBIG49252
Hawker Hunter F.4 (designed to be used with Airfix kits) This BiG-Ed set includes all these Eduard sets..... ED491082 Hawker Hunter F.4 ED481014 Hawker Hunter F.4/F.5 landing flaps EDFE1084 Hawker Hunter F.4/F.5 seatbelts EDEX696 Hawker Hunter F.4/F.5 paint mask (Eduard sold out February 2024 part 1)
Aircraft detailing sets (etched)
Limited Availability
£30.60
-
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
Eduard Big-Ed EBIG49251
1:48
North-American P-51D-5 (designed to be used with Airfix kits) This BiG-Ed set includes all these Eduard sets..... EDEX689 P-51D-5 ED481013 P-51D-5 exterior ED491074 P-51D-5 interior EDFE1075 P-51D-5 seatbelts STEEL (Eduard sold out January 2024 part 1)
Aircraft detailing sets (etched)
Limited Availability
£25.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

No Image
Eduard Big-Ed EBIG49253
Hawker Hunter F.5 (designed to be used with Airfix kits) This BiG-Ed set includes all these Eduard sets..... ED491083 Hawker Hunter F.5 ED481014 Hawker Hunter F.4/F.5 landing flaps EDFE1084 Hawker Hunter F.4/F.5 seatbelts EDEX696 Hawker Hunter F.4/F.5 paint mask (Eduard sold out January 2024 part 1)
Aircraft detailing sets (etched)
Limited Availability
£30.60
-
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
Eduard Big-Ed EBIG49262
Messerschmiit Bf-110D 1/48 (designed to be used with Dragon kits) [Bf-110D-1/R1 Bf-110D-3] This BiG-Ed set includes all these Eduard sets..... EDEX710 Bf-10D TFace canopy frame paint mask (inside & outside) ED481022 Bf-110D exterior ED491106 Bf-110D interior EDFE1107 Bf-110D seatbelts STEEL (Eduard sold out January 2024 part 1)
Aircraft detailing sets (etched)
Limited Availability
£32.70
-
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
Eduard Big-Ed EBIG49318
Grumman F-14A Tomcat late (designed be used with Tamiya kits) This BiG-Ed set includes all these Eduard sets..... ED48910 F-14A engines ED481075 F-14A late exterior 1/48 ED49806 F-14A seatbelts STEEL ED491239 F-14A late interior 1/48 EDEX540 F-14A 1/48 (Eduard sold out January 2024 part 1)
Aircraft detailing sets (etched)
Limited Availability
£49.30
-
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
Eduard Big-Ed EBIG49333
Lockheed F-104A Starfighter (designed to be used with Kinetic Model kits) This BiG-Ed set includes all these Eduard sets..... ED49103 Remove Before Flight STEEL ED491266 F-104A 1/48 EDFE1270 F-104A/C seatbelts STEEL 1/48 EDEX850 F-104A/C
Aircraft detailing sets (etched)
Limited Availability
£25.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

No Image
Eduard Big-Ed EBIG49334
Ilyushin Il-2 Stormovik mod. 1943 (designed to be used with Zvezda kits) This BiG-Ed set includes all these Eduard sets..... EDE481085 Il-2 mod. 1943 landing flaps ED491271 Il-2 mod. 1943 1/48 EDFE1272 Il-2 mod. 1943 seatbelts STEEL EDEX856 Il-2 mod. 1943
Aircraft detailing sets (etched)
Limited Availability
£49.30
-
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
Eduard Big-Ed EBIG49291
Mikoyan MiG-15bis (designed to be used with Bronco Models and Hobby 2000 kits) This BiG-Ed set includes all these Eduard sets..... ED481046 MiG-15bis landing flaps 1/48 ED491178 MiG-15bis 1/48 EDFE1179 MiG-15bis seatbelts STEEL 1/48 EDEX775 MiG-15bis 1/48 (Eduard sold out September 2023 part 1)
Aircraft detailing sets (etched)
Limited Availability
£32.70
-
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

Eduard Big-Ed EBIG49184
Sukhoi Su-35 Flanker-E (designed to be used with Kitty Hawk Model kits) This BiG-Ed set includes all these Eduard sets.... EDEX562 Su-35 Flanker E ED48934 Su-35 Flanker E exterior ED49858 Su-35 Flanker E interior EDFE859 Su-35 Flanker E seatbelts STEEL (Eduard sold out August 2023 part 1)
Aircraft detailing sets (etched)
Limited Availability
£32.70
-
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
Eduard Big-Ed EBIG49285
Sukhoi Su-30SM (designed to be used with Kitty Hawk Model kits) This BiG-Ed set includes all these Eduard sets..... ED491150 Su-30SM 1/48 EDFE1151 Su-30SM seatbelts STEEL 1/48 EDEX743 Su-30SM 1/48 (Eduard sold out August 2023 part 1)
Aircraft detailing sets (etched)
Limited Availability
£29.70
-
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
Eduard Big-Ed EBIG49315
Grumman TBF-1C Avenger (designed to be used with Academy kits) This BiG-Ed set includes all these Eduard sets..... ED481071 TBF-1C exterior ED481072 TBF-1C landing flaps ED491232 TBF-1C interior 1/48 EDEX819 TBF-1C 1/48 EDFE1233 TBF-1C seatbelts STEEL
Aircraft detailing sets (etched)
Limited Availability
£59.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

Eduard Big-Ed EBIG49158
Sukhoi Su-33 Sea Flanker D (designed to be used with Kinetic Model kits) This Big-Ed set includes these Eduard sets.... EDEX521 Su-33 ED48891 Su-33 exterior ED49778 Su-33 interior (Eduard sold out July 2023 part 1)
Aircraft detailing sets (etched)
Limited Availability
£29.70
-
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
Eduard Big-Ed EBIG49343
Seatbelts WWII Axis AF STEEL This BiG-Ed set includes all these Eduard sets..... ED49095 Seatbelts Luftwaffe WWII fighters STEEL ED49099 Seatbelts IJN fighters STEEL ED49105 Seatbelts Italy WWII fighters STEEL ED49109 Seatbelts IJAAF WWII STEEL (Eduard sold out July 2023 part 1)
Aircraft detailing sets (etched)
Limited Availability
£34.70
-
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

Eduard Big-Ed EBIG4891
Mikoyan MiG-3 (designed to be used Trumpeter kits) This BiG-Ed set includes all these Eduard sets..... ED48574 Mikoyan MiG-3 landiing flaps ED49388 Mikoyan MiG-3 EDEX229 Mikoyan MiG-3
Aircraft detailing sets (etched)
Limited Availability
£20.40
-
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

Eduard Big-Ed EBIG49185
Bell UH-1D 'Huey' (designed to be used with Kitty Hawk Model kits) This BiG-Ed set includes all these Eduard sets.... EDEX564 UH-1D ED48935 UH-1D cargo interior ED49861 UH-1D EDFE862 UH-1D seatbelts STEEL (Eduard sold out May 2023 part 2)
Aircraft detailing sets (etched)
Limited Availability
£32.70
-
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

Eduard Big-Ed EBIG49209
Grumman F-14D Tomcat (designed to be used with Tamiya kits) This BiG-Ed set includes all these Eduard sets.... EDEX624 F-14D ED48969 F-14D engines STEEL ED48970 F-14D exterior ED49933 F-14D 1 EDFE934 F-14D seatbelts STEEL (Eduard sold out May 2023 part 2)
Aircraft detailing sets (etched)
Limited Availability
£49.30
-
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

Eduard Big-Ed EBIG49213
McDonnell F-101B Voodoo (designed to be used with Kitty Hawk Model kits) This BiG-Ed set includes all these Eduard sets.... EDEX632 F-101B TFace canopy frame paint mask (inside & outside) ED48979 F-101B exterior ED49941 F-101B interior EDFE942 F-101B seatbelts STEEL (Eduard sold out May 2023 part 2)
Aircraft detailing sets (etched)
Limited Availability
£42.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

Eduard Big-Ed EBIG49218
1:48
Heinkel He-111H-16 (designed to be used with ICM kits) This BiG-Ed set includes all these Eduard sets.... EDEX640 He 111H-16 ED48985 He 111H-16 exterior ED49962 He 111H-16 nose interior ED49963 He 111H-16 radio compartment EDFE963 He 111H-16 seatbelts STEEL (Eduard sold out May 2023 part 2)
Aircraft detailing sets (etched)
Limited Availability
£55.80
-
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

Eduard Big-Ed EBIG49225
Yakovlev Yak-130 (designed to be used with Zvedza kits) This BiG-Ed set includes all these Eduard sets.... EDEX649 Yak-130 ED49978 Yak-130 EDFE979 Yak-130 seatbelts STEEL (Eduard sold out May 2023 part 2)
Aircraft detailing sets (etched)
Limited Availability
£20.40
-
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

Eduard Big-Ed EBIG49247
Douglas A-26B Invader (designed to be used with ICM kits) This BiG-Ed set includes all these Eduard sets..... EDEX685 A-26B ED481008 A-26B Invader undercarriage & exterior ED481009 A-26B Invader bomb bay ED491068 A-26B Invader EDFE1069A-26B Invader seatbelts STEEL (Eduard sold out May 2023 part 2)
Aircraft detailing sets (etched)
Limited Availability
£63.70
-
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
Eduard Big-Ed EBIG49259
Heinkel He-111Z (designed to be used with ICM kits) ED481016 Heinkel He-111Z 'Zwilling' exterior ED491090 Heinkel He-111Z 'Zwilling' nose interior ED491091 Heinkel He-111Z 'Zwilling' radio compartment EDFE1091 Heinkel He-111Z 'Zwilling' seatbelts STEEL EDFE698 Heinkel He-111Z 'Zwilling' paint masks
Aircraft detailing sets (etched)
Limited Availability
£71.80
-
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
Eduard Big-Ed EBIG49278
Lockheed TF-104G Starfighter (designed to be used with Kinetic Model kits) This BiG-Ed set includes all these Eduard sets..... EDEX738 TF-104G ED491139 TF-104G late EDFE1140 TF-104G seatbelts late STEEL (Eduard sold out May 2023 part 2)
Aircraft detailing sets (etched)
Limited Availability
£27.70
-
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
Eduard Big-Ed EBIG49294
Sukhoi Su-33 (designed to be used with Minibase kits) This BiG-Ed set includes all these Eduard sets..... EDSEX781 Su-33 ED491185 Su-33 EDFE1186 Su-33 seatbelts STEEL (Eduard sold out May 2023 part 2)
Aircraft detailing sets (etched)
Limited Availability
£23.60
-
In Stock
1

   1   |   2   |   3      »      [3]

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