Aero Precision M4E1 Assembled Threaded Upper Receiver - Thunder Ranch Special Edition
|SQL||SELECT DISTINCT a.style_id, max(CASE WHEN m.description IS NULL OR RTRIM(LTRIM(m.description)) = '' THEN a.web_desc ELSE m.description END) as realname, sum(c.qoh+c.qc) as overallqoh, max(a.picture_id) as picture_id, max(a.of8) as of8, max(b.sku_id) as sku_id, max(b.sku_of7) as sku_of7, max(b.scale_entry_id) as scaleid, max(b.attr2_entry_id) as attr2id, max(b.attr1_entry_id) as attr1id, max(a.style) as style, max(r.package_id) as usepackage, max(a.web_style) as webStyle, max(m.capacity) as capacity, max(m.webstyle_sort) as webstyle_sort, max(a.NON_INVT) as NON_INVT FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id AND NOT (c.qoh < 1 AND a.of8 in (?,?,?,?,?,?,?,?)) AND NOT (c.qoh < 1 AND a.of8='INACTIVE') AND c.store_id in(49,90,4) ) LEFT JOIN web_product_information m WITH (NOLOCK) ON (a.style_id = m.style_id) LEFT JOIN dbo.tb_inet_names f WITH (NOLOCK) on (f.orig_text = a.brand and f.field_name='BRAND') LEFT JOIN tb_package r WITH (NOLOCK) on (r.sku_id=b.sku_id) INNER JOIN web_all_products wb WITH (NOLOCK) ON (wb.style_id = a.style_id) WHERE a.web_style = 'APAR700218AC' AND (upper(f.web_text) = 'AERO PRECISION' or upper(f.orig_text) = 'AERO PRECISION' or upper(a.brand) = 'AERO PRECISION') GROUP BY a.style_id,a.of8 HAVING (sum(c.qoh+c.qc) > 0 OR a.of8='STK') ORDER BY max(m.webstyle_sort), a.style_id|
The Thunder Ranch product line is a joint venture between Aero Precision and Thunder Ranch. Aimed to achieve Clint Smith's ideal purpose built "Ultimate Carbine", these products include key features requested from Clint Smith himself but with an Aero Precision flare. Like everything surrounding the Thunder Ranch name, you get exactly what you need - nothing more and nothing less.
The M4E1 Threaded Upper Receiver features an angular machined design that helps it stand apart from standard mil-spec upper receivers. This upper receiver features the same enhanced body profile as our M4E1 Enhanced Upper Receiver but is threaded to accept a standard AR15 barrel nut. It is forged from 7075-T6 Aluminum, precision machined to work with all mil-spec AR15 parts and includes the port door pre-installed.
- No Forward Assist - A first for our M4E1 Threaded Upper Receivers
- New enhanced forging that gives the upper receiver a "billet look"
- New picatinny profile that blends seamlessly with our Enhanced and ATLAS Series Handguards
- M4 Feedramps
- .250 takedown pin holes
- Laser engraved T-marks
- Includes port door
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$19.99 to $21.99