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=8135 AND ps.id = 956
		 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 30 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

RAF WWII Dull red letters and numerals 36' high x 6' stroke. Squadron codes on medium and some large aircraft (RAF codes/RAF code letters/RAF serial numbers)
Aircraft decals (military)
Limited Availability
£3.99
-
In Stock
20+

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

The Hawker Set (28) Hawker Harts (11) 6 Sqn; 11 Sqn; 12 Sqn; 33 Sqn; 39 Sqn; 57 Sqn; 600 (City of London) Sqn; 601 County of London) Sqn; 603 (City of Edinburgh) Sqn; No 4 FTS; Hawker Hinds (6) 15 Sqn; 18 Sqn; 57 Sqn; 103 Sqn; 107 Sqn; 139 (Jamaica) Sqn. Hawker Audax (4) 502 (Ulster) Sq; 4, 20 ans 28 (Army Co-Op) Sqns. Hawker Hardy (2) 4 FTS; 6 Sqn; Hawker Demon (3) 64 Sqn; 600 Sq RAuxAF; 601 RAuXAF; Hawker Osprey (...
Aircraft decals (military)
Limited Availability
£3.99
-
In Stock
30+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

1:72
RAF pre-war black serial letters and numerals 30 inches in both standard and narrow width styles (RAF codes/RAF code letters/RAF serial numbers) does not include instructions
Aircraft decals (military)
Limited Availability
£3.99
-
In Stock
30+

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

RAF McDonnell-Douglas FGR.2 Phantom XV470/H or W 2 Sqn Laarbruch 1971-73 or XV470/C 56 Sqn Coningsby 1976; Canadair Sabre F.1 XB900/A 20 Sqn 2nd TAF Oldenburg 1955-56; USAFE General-Dynamics F-111E 68-028 20 TFW 1976 Bi-Centennial at Greenham Common Air Tattoo; Armeĩ de l'Air Dassault-Mirage IIIE No 617 4-BE or 621 4-BG EC 2/4 Lafayette 1976; Fouga CM.170R Magister 30-OD 30th EEVSV 1973; 11-OF 11th EEVSV 1072; 10-KG 1...
Aircraft decals (military)
Limited Availability
£4.99
-
In Stock
30+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

1:72
Armeĩ de L'Air. North-American F-100D Super Sabre/North-American F-100F Super Sabre 3rd/11th Escadres 1960-78; Dassault-Mirage F.1B/C 5,10,12, 30 Escadres 1976-82; Aeronavale Vought F-8E(FN) Crusader 12th/14th Flotille 1964-83
Aircraft decals (military)
Limited Availability
£3.99
-
In Stock
20+

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

RAF Post War Letters and Numerals, White 48 inches (RAF codes/RAF code letters/RAF serial numbers)
Aircraft decals (military)
Limited Availability
£2.99
-
In Stock
30+

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

RAF WWII Roundels. Large Type A 65 inches , 84 inches and 100 inches ; Type A1 63 inches , 64 inches , 66 inches 77 inches , 84 inches , 100 inches (RAF Roundels)
Aircraft decals (military)
Limited Availability
£3.99
-
In Stock
30+

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

McDonnell F-4 Phantoms, late 1960s; F-4B VMFA-531 USMC; F-4C 497 TFS US Air Force; McDonnell-Douglas F-4K 767 Sqn RN
Aircraft decals (military)
Limited Availability
£4.99
-
In Stock
19

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

BAC/EE Lightning F.3 56 Sqn; Royal Navy/RN Westland Lynx HAS 2 702 Sqn; Supermarine Attacker FB.2 718 Sqn, 1831 Sqn; France Lockheed T-33A Shooting Star 1976
Aircraft decals (military)
Limited Availability
£4.99
-
In Stock
30+

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

RAF Panavia Tornado F.3. 11 Sqn inc ZE764/DH with black spine; 23 Sqn; Toeu; F2 ETPS all 1988; Sepecat Jaguar GR.1A 2 Sqn 1988 76th Anniversary black fin and large squadron badge; Dutch Air Force General-Dynamics F-16A 312 Sqn Klu 75th Anniversary 1988
Aircraft decals (military)
Limited Availability
£4.99
-
In Stock
30+

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

BAC/EE Canberra E.15 WJ756/C-L 100 Sqn; Canberra T.4 WJ879/BH 231 OCU; Canberra T.17 WK111/EA 360 Sqn; Canberra PR.9 XH165 1 PRU, all RAF Wyton 1983-85 Green/Grey camouflage; Italian Air Force Lockheed F-104G Starfighters MM6561 3-07 132 Gruppo; MM6647 3-29 28 Gruppo; MM6735 9-31 10 Gruppo; MM6814 5-42 23 Gruppo; MM6936 53-06 21 Gruppo.
Aircraft decals (military)
Limited Availability
£3.99
-
In Stock
30+

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

RAF McDonnell-Douglas FGR.2 Phantom XV428/CC 228 OCU Leuchars 1988 Display scheme; Westland Wessex HC.2 XR515/B or WR517/G or XV722/BH or XV728/BR all 18 Sqn; XR588/D 28 Sqn Kai Tak '72; XR524/F 72 Sqn Odiham; XR523/AM 72 Sqn Odiham 1976; Westland Wessex HAR.2 XT604 or XR518 both 22 Sqn; XR518 72 Sqn Manston; XT608 Diamond, XV721 Heart, XR522 Club, XV719 Joker all 84 Sqn Akrotiri 1982 overall Rescue yellow; Westland Wess...
Aircraft decals (military)
Limited Availability
£4.99
-
In Stock
30+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

1:72
Republic F-84G Thunderjet 71FBS Wethersfield 1953; 307 FES USA 1962; Douglas A-4G 805 Sqn HMAS Melbourne 1977; Sud-Aviation/Aerospatiale SA-330B Puma Armeĩ de L'Air 1977; BAe Hawk T.1234 Sqn TWU 1978; Sepecat Jaguar GR.1 31 Sqn Bruggen 1977
Aircraft decals (military)
Limited Availability
£3.99
-
In Stock
28

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

Modern Armeĩ de l'Air (French Air Force) black code letters and numbers 4 sizes 240mm inches 530mm (actual 3.3mm, 4.2mm, 6.2mm, 7.2mm)
Aircraft decals (military)
Limited Availability
£3.99
-
In Stock
30+

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

McDonnell-Douglas FG.1 Phantom 43 Sqn; McDonnell-Douglas FGR.2 Phantom 19, 23 and 56 Sqns 3 tone grey; McDonnell-Douglas FGR.2 Phantom 92 Sqn grey/green camouflage; BAe Hawk T.1 151 Sqn grey/green; Panavia Tornado GR.1 Tri-National Training Establishment, Cottesmore 1981 [FG.1/FGR.2]
Aircraft decals (military)
Limited Availability
£4.99
-
In Stock
30+

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

RAF Panavia Tornado GR.1 ZA542/05 27 Sqn Marham 1983;ZA392 TOEU Boscombe Down 1983; McDonnell-Douglas FGR.2 Phantom XV501/B Greenham Common 1983 or KV464/B Falklands 1983 both 23 Sqn; V406/D 29 Sqn Conningsby;XT901/Y 56 Sqn Wattisham; all 3 tone grey;
Aircraft decals (military)
Limited Availability
£4.99
-
In Stock
30+

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

RAF Panavia Tornado GR.1 ZA475/FC 16 Sqn; ZA450/EC; ZA446/F 'MacRoberts Reply' both XV Sqn Laarbruch 1984; ZA562 TWCU/45 Sqn Honnington 1984; Sepecat Jaguar GR.1 XZ116 41 Sqn Coltishall 1983; RN/FAA BAe Sea Harrier FRS.1 809 NAS names to update MD071; BAe Harrier T.4N ZB604/717 or ZB805/718 899 NAS Yeovilton 1984.
Aircraft decals (military)
Limited Availability
£3.99
-
In Stock
30+

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

RAF Hawker Hunter F.4 XF313/G 71 Sqn Bruggen 1956; Hunter F.6 XE616/E 1 Sqn Stradishall 1959; XF416/J 26 Sqn 121 Wing Gutersloh 1958; Hunter FR.10 X714/B 4 Sqn Gutersloh 1964; BAe Hawk T.1 XX172/172 4 FTS Valley 1981 Red/white/grey. Armeĩ de L'Air Dassault-Mirage IIIE No.436 2-LR E.C.3/2 Alsace 1965-1985 Anniversary; No.526 3-JV E.C.2/3 Champagne; No.501 3-IB E.C. 1/3 Navarre.
Aircraft decals (military)
Limited Availability
£3.99
-
In Stock
30+

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

West German Air Force and Navy Panavia Tornado ADS 43+47 MFG.1 Bundesmarine 1985; 43+04 TTTE RAF Cottesmore 1981; 98+03 Erprobungstelle 61 Manching 1980; 43+35 WaKo Erding 1962; 43+33 JBG.38 Jever 1983; Belgian Air Force Mirage 5BA BA-63 8 Sqn 1st Wing Bierset 1984 15th Anniversary.
Aircraft decals (military)
Limited Availability
£3.99
-
In Stock
30+

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

RAF McDonnell-Douglas FG.1 XV571/A 43 Sqn in 70th Anniversary schemes 1986; McDonnell-Douglas FGR.2 Phantom XT900/CO or XV393/CA 228 Sqn/64 OCU 1987; Boeing Chinook HC1. 18Sqn 1981; 240OCU 1982/5; 1310 Flt 1984; 78 Sqn 1986/7; Aerospatiale AS-330 Puma HC1 1563 Flt 1986/7; [FG.1/FGR.2] Sikorsky Sea King HAR3 78 Sqn 1987 to update MD067/071; Belgian Air Force General-Dynamics F-16A Fighting Falcon 350 Sqn 45 Anniversary ...
Aircraft decals (military)
Limited Availability
£4.99
-
In Stock
20+

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

RAF McDonnell-Douglas FG.1 Phantom XV574/Z 111 Sqn 1985/87 with black spine and fin, two versions. Panavia Tornado F.3. ZE203/BA or ZE208/BT 29 Sqn; ZE156/AM or ZE158/AK 229OCU/65 Sqn all 1987; [FG.1/FGR.2]
Aircraft decals (military)
Limited Availability
£4.99
-
In Stock
30+

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

RAF Gloster Meteor night fighters. NF.11 5 Sqn 1959; 11 Sqn 1959; 29 Sqn 1955; NF.12 25 Sqn 1958; 72 Sqn 1958; NF.13 39 Sqn 1955; NF.14 (Mk.14) 25 Sqn 1955; 72 Sqn 1956; Belgian Air Force Dassault-Mirage 5BA 1 Sqn 70th Anniversary Blackbird Special BA33
Aircraft decals (military)
Limited Availability
£3.99
-
In Stock
30+

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

RAF Gloster Meteor night fighters. NF.11 87 Sqn 1956; 96 Sqn 1956; 125 Sqn 1955; 141 Sqn 1952; 151 Sqn 1954; 256 Sqn 1958; 264 Sqn 1954; NF.12 152 Sqn 1958; 264 Sqn 1957; NF.14 (Mk.14) 33 Sqn 1958; 264 Sqn 1955; BAe Hawk T.1 XX172/XX238 1987 CFS display scheme Union Jack Tails
Aircraft decals (military)
Limited Availability
£3.99
-
In Stock
30+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

1:72
RAF McDonnell-Douglas FGR.2 Phantom XV492/Q 9 Sqn Conningsby 1974; XV432/N 6 Sqn Conningsby 1969; XV432/H 14 Sqn RAF Bruggen 1974; XV462/462 17 Sqn RAF Bruggen 1974; XV422 and XV431 31 Sqn RAF Bruggen 1974; All Dk Gn/Dk Sea Grey/Lt AC Grey; BAC/EE Lightning F.2A XN781/B or XN724/F 19 Sqn; XN727/W 92Sqn; BAe Harrier GR.3 XV738/B 4 Sqn RAF Gutersloh 1987 75th Anniversary fin; Panavia Tornado F.3 ZE292/CA Conningsby 1988
Aircraft decals (military)
Limited Availability
£4.99
-
In Stock
30+

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

Royal Navy/RN Westland Wessex HU.5 5 1964-81. 707, 771, 772, 829, 845, 846, 847, 848 Sqns and H.M.S. London, Bulwark and RFAs Olna, Tidepool, Regent and Resource. Belgian Air Force Dassault-Mirage 5BA 2 Sqn in 70th Anniversary 'Milky Way' scheme
Aircraft decals (military)
Limited Availability
£3.99
-
In Stock
30+