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=339360 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 1,162 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

1:48
Black Cat '30' VP-11, Riviere Sepik, Papua New Guinea 1943. Consolidated PBY-5 Catalina 'Pistol Packin' Mama' VP-11 Black Cats.
Aircraft decals (military)
Catalogue
£10.20
-
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

1:48
Black Cat 'Frisco Gal' VP-11Riviere Sepik Papua New Guinea 1943. Consolidated PBY-5 Catalina 'Jumpie' Lt William Price VP-72 Funfuti July 1944.
Aircraft decals (military)
Catalogue
£10.20
-
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

Consolidated OA-10A Catalina Miss Pick Up Originally 5th Emergency Rescue Sqn Halesworth Suffolk April 1945 (Also includes restored version currently flying). Consolidate PBY-5 Catalina Wanderin Witch Flt Lt Scholes 6 Sqn RNZF Halavo Bay Soloman Islands 1945
Aircraft decals (military)
Catalogue
£10.20
-
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

1:72
Black Cat '30' VP-11, Riviere Sepik, Papua New Guinea 1943. ConsolidatedPBY-5 Catalina 'Pistol Packin' Mama' VP-11 Black Cats.
Aircraft decals (military)
Catalogue
£10.20
-
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

1:72
Black Cat 'Frisco Gal' VP-11 Riviere Sepik Papua New Guinea 1943. - Consolidated PBY-5 Catalina 'Jumpie' Lt William Price VP-72 Funfuti July 1944.
Aircraft decals (military)
Catalogue
£10.20
-
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

1:72
Consolidated OA-10A Catalina Miss Pick Up Originally 5th Emergency Rescue Sqn Halesworth Suffolk April 1945 (Also includes restored version currently flying). Consolidated PBY-5 Catalina Wanderin Witch Flt Lt Scholes 6 Sqn RNZF Halavo Bay Soloman Islands 1945.
Aircraft decals (military)
Catalogue
£10.20
-
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

Blackburn/Hawker-Siddeley Buccaneer. Buccaneer S. Mk.2- XN974, Royal Navy Test Squadron, based at A&AEE Boscombe Down, 1971.Buccaneer NA.39- XK527/527, Royal Navy Test Squadron, RAF Holme-on-Spalding Moor, 1975.Buccaneer S. Mk 2- XN975, Royal Radar Establishment, RAF Pershore, 1976. (Alternative Scheme). Buccaneer S. Mk 2- XN975, Royal Radar Establishment, RAF Pershore, 1976. Buccaneer S. Mk 2B- XW529, A&AEE/British Aerospac...
Aircraft decals (military)
Catalogue
£10.20
-
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

1:72
North-American/Rockwell OV-10 Bronco. OV-10F Bronco, operated by Skadron Udara 21, Indonesian Air Force. OV-10A Bronco, operated by the Naval Weapons Evaluation Facility, based at NWEF Albuquerque, New Mexico, early 1980's. OV-10C Bronco, operated by the 16th Strike Squadron, 15th Strike Wing, Philippines Air Force, based at Danielo Atienza AB, 2005. OV-10E Bronco, operated by Escuadron 40, Venezuelan Air Force, mid-19...
Aircraft decals (military)
Catalogue
£10.20
-
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

1:72
North-American F-86 SABRE. F-86F-30, 251-02/C-102, Grupo 1 de Caza Bombardero IV , Brigada Aerea, Fuerza Aerea Argentina, based at Aerea Militar El Plumerillo (Mendoza), 1960 s. Sabre Mk.2 (F-86E(M)), 19241/241, 141 Filo, Turk Hava Kuvvetleri, 1960 s. F-86F-25, 265 , 1st Fighter Bomber Squadron, Imperial Ethiopian Air Force, Debre Zebit Air Base, 1960 s. F-86F, 132 , Escuadron de Caza 12, Fuerza Aerea Peruana, late 1950 s. ...
Aircraft decals (military)
Catalogue
£10.20
-
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

1:72
Hawker Hurricane. Hawker Hurricane Mk. I/Trop, Z4434, operated by the Groupe Bretagne, Forces Aƒ¯é¿é½riennes Franƒ¯é¿é½aises Libres (FAFL), North Africa, 1942. Hawker Hurricane Mk. IIb/Trop, Z5664, operated by 2-VI-G IV,KNIL-LVA, Kalidjati, Java, Dutch East Indies, 1942. Hawker Hurricane Mk. IIc/Trop, 2-13, operated by the Imperial Iranian Air Force, Doshan Teppeh AB, 1947. Hawker Hurricane Mk. IIc/Trop, 2-32, operated by t...
Aircraft decals (military)
Catalogue
£10.20
-
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

1:72
Douglas A-20 Havocs. A-20G, Havoc 43-9224 F6-E - 5H-E Miss Laid of the 410th BG, France, July 1944 - A-20G-45, Havoc 43-22166 Ridin' High 388th BS.
Aircraft decals (military)
Catalogue
£10.20
-
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

1:48
Douglas A-20 Havocs. A-20G, Havoc 43-9224 F6-E - 5H-E 'Miss Laid' of the 410th BG, France, July 1944 - A-20G-45, Havoc 43-22166 'Ridin' High' 388th BS.
Aircraft decals (military)
Catalogue
£10.20
-
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

1:48
Douglas A-20 Havocs. A-20G, Havoc Little Chief 321st BS - A-20G-DL-40, Havoc Miss Possum My Texas Gal , 388BS, 312th Bomb Group, 5th Air Force, USAAF.
Aircraft decals (military)
Catalogue
£10.20
-
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

1:72
Douglas A-20 Havocs A-20G, Havoc Little Chief 321st BS - A-20G-DL-40, Havoc Miss Possum My Texas Gal , 388BS, 312th Bomb Group, 5th Air Force, USAAF.
Aircraft decals (military)
Catalogue
£10.20
-
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

1:48
REPUBLIC F-105D-RE-31 THUNDERCHIEF 62-4364 'PUSSY GALORE II' 354TH TFS, 355TH TFW. REPUBLIC F-105D-6-RE 59-1771 THUNDERCHIEF 59-1771 'DYNAMIC DUO II' VIRGINIA AIR NATIONAL GUARD. F-105D 59-1771 Dynamic Duo II featured the Rocky and Bullwinkle cartoon characters.
Aircraft decals (military)
Catalogue
£10.20
-
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

REPUBLIC F-105D THUNDERCHIEF 61-0069 CHERRY GIRL 357TH TFS, 355TH TFW Moe Seaver Wiggins Pilot: flew F-105D-25-RE Cherry Girl which spent a year in combat with the 357th TFS, 355th TFW. Takhli, Thailand. MiG-17 shot down by this aircraft on June 3rd 1967. REPUBLIC F105D THUNDERCHIEF 59-1739 QUEEN OF THE FLEET VIRGINIA AIR NATIONAL GUARDF-105D-6-RE, 59-1739, 'Queen of the Fleet' 149 TFS/ 192nd TFG, VA ANG, Richmond ANGB, VA....
Aircraft decals (military)
Catalogue
£10.20
-
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

1:48
REPUBLIC F105D THUNDERCHIEF 60-0504 'MEMPHIS BELLE II' 357TH TFS, 355TH TFW RTAB (Royal Thai Air Base) Takhli, Thailand, 1967. The nickname Memphis Belle II refers to the B-17F that carried the same artwork during WWII. The two red stars under the cockpit represent the two MiG kills it claimed during the Southeast Asia War. Pilot: MAJ Buddy Jones. REPUBLIC F105D THUNDERCHIEF 61-0165 'MY HONEYPOT' VIRGINIA AIR NATIONAL GUARD ...
Aircraft decals (military)
Catalogue
£10.20
-
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

1:72
REPUBLIC F-105D-RE-31 THUNDERCHIEF 62-4364 'PUSSY GALORE II' 354TH TFS, 355TH TFW. REPUBLIC F-105D-6-RE 59-1771 THUNDERCHIEF 59-1771 'DYNAMIC DUO II' VIRGINIA AIR NATIONAL GUARD. F-105D 59-1771 Dynamic Duo II featured the Rocky and Bullwinkle cartoon characters.
Aircraft decals (military)
Catalogue
£10.20
-
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

1:72
REPUBLIC F105D THUNDERCHIEF 61-0069 CHERRY GIRL 357TH TFS, 355TH TFW Moe Seaver Wiggins Pilot: flew F-105D-25-RE Cherry Girl which spent a year in combat with the 357th TFS, 355th TFW. Takhli, Thailand. MiG-17 shot down by this aircraft on June 3rd 1967. REPUBLIC F105D THUNDERCHIEF 59-1739 QUEEN OF THE FLEET VIRGINIA AIR NATIONAL GUARDF-105D-6-RE, 59-1739, 'Queen of the Fleet' 149 TFS/ 192nd TFG, VA ANG, Richmond ANGB, VA. ...
Aircraft decals (military)
Catalogue
£10.20
-
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

1:72
REPUBLIC F105D THUNDERCHIEF 60-0504 MEMPHIS BELLE II 357TH TFS, 355TH TFW RTAB (Royal Thai Air Base) Takhli, Thailand, 1967. The nickname Memphis Belle II refers to the B-17F that carried the same artwork during WWII. The two red stars under the cockpit represent the two MiG kills it claimed during the Southeast Asia War. Pilot: MAJ Buddy Jones. REPUBLIC F105D THUNDERCHIEF 61-0165 MY HONEYPOT VIRGINIA AIR NATIONAL GUARD F10...
Aircraft decals (military)
Catalogue
£10.20
-
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

1:72
RAF lettering codes 28 inches high. Stores Ref. 33B/157 was developed in 1936 specifically for identification markings. . At this time it was known as Sea Grey, used between April 1939 - December 1940. 8 inch high black letters and numbers also included.
Aircraft decals (military)
Catalogue
£7.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

1:72
RAF lettering codes 24 inches high. Stores Ref. 33B/157 was developed in 1936 specifically for identification markings. At this time it was known as Sea Grey, used between April 1939 - December 1940. 8 inch high black letters and numbers also included.
Aircraft decals (military)
Catalogue
£7.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

1:32
Supermarine Spitfire Mk.IIa BBMF Part One Supermarine Spitfire Mk.IIa, P7350/UOƒ¯é¿é½T, No. 266 Squadron: 1972-1977. Supermarine Spitfire Mk.IIa, P7350/QVƒ¯é¿é½B, No. 19 Squadron: 1978-1981. Supermarine Spitfire Mk.IIa, P7350/SHƒ¯é¿é½D, No. 64 Squadron: 1982-1984. Supermarine Spitfire Mk.IIa, P7350/EBƒ¯é¿é½Z, No. 41 Squadron: 1985-1988. Spitfire Mk.IIa P7350 is the oldest airworthy Spitfire in the world and the only Spit...
Aircraft decals (military)
Catalogue
£10.20
-
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

1:32
Supermarine Spitfire Mk.IIa BBMF Part Two Supermarine Spitfire Mk.IIa, P7350/YTƒ¯é¿é½F, No. 65 Squadron: 1991-1993. Supermarine Spitfire Mk.IIa, P7350/RN's, No. 72 Squadron: mid-1990. Supermarine Spitfire Mk.IIa, P7350/BAƒ¯é¿é½Y, No. 277 (Air Sea Rescue) Squadron: 1997-2000. Spitfire Mk.IIa P7350 is the oldest airworthy Spitfire in the world and the only Spitfire still flying today to have actually fought in the Battle of ...
Aircraft decals (military)
Catalogue
£10.20
-
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

Supermarine Spitfire Mk.IIa BBMF Supermarine Spitfire Mk.IIa, P7350/XTƒ¯é¿é½D, No.603 (City of Edinburgh) Squadron: 2001-2006. Supermarine Spitfire Mk.IIa, P7350/XTƒ¯é¿é½W, No.603 (City of Edinburgh) Squadron: 2006-2007. Supermarine Spitfire Mk.IIa, P7350/XTƒ¯é¿é½L, No.603 (City of Edinburgh) Squadron: 2007-2008. Supermarine Spitfire Mk.IIa, P7350/QJƒ¯é¿é½K, No.92 Squadron: 2009. Supermarine Spitfire Mk.IIa, P7350/EBƒ¯é¿é...
Aircraft decals (military)
Catalogue
£10.20
-
In Stock
5+