Aero Precision M4E1 Almost Complete Upper 5.56MM, 16" Barrel, 15" Altlas S-One MLOK™

Item# APAR700305M7

0 Reviews

$499.99

query

RESULTSET

query
	ATTR1ID	ATTR2ID	CAPACITY	NON_INVT	OF8	OVERALLQOH	PICTURE_ID	REALNAME	SCALEID	SKU_ID	SKU_OF7	STYLE	STYLE_ID	USEPACKAGE	WEBSTYLE	WEBSTYLE_SORT

CACHED

false

EXECUTIONTIME

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 = 'APAR700305M7' 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

SQLPARAMETERS

array
1	OBS
2	RS
3	SM
4	DNR
5	DNRFD
6	CSN
7	SPDNR
8	DOA

This complete upper includes the new ATLAS S-ONE Handguard! The S-ONE line of handguards are designed with size and weight in mind, providing the perfect addition to your lightweight build. The proprietary ATLAS attachment system is a durable and dependable mounting platform, maintaining a slim profile while still providing the strength and stability customers have grown to love from Aero Precision handguards.

Includes:
M4E1 Threaded Assembled Upper Receiver
15" ATLAS S-ONE Handguard
16" 5.56 CMV Barrel
Low Profile Gas Block and Mid Length Gas Tube
This complete upper does not include BCG or Charging Handle.
M4E1 Threaded Upper Receiver Features:
New enhanced forging that gives the upper receiver a "billet look"
New picatinny profile that blends seamlessly with the Enhanced Series Handguards
M4 Feedramps
.250 takedown pin holes
Laser engraved T-marks
Includes port door and forward assist installed
ATLAS S-ONE Handguard Features:
Front and rear picatinny rail
Eliminated center of top rail for weight reduction
Indexing grooves in 12:00 position for positive grip control
Compatible with low profile gas blocks
1.3” Inside diameter
1.5” Outside diameter
Compatible with mil-spec AR15 upper receivers and barrels
16" 5.56 M4 CMV Mid-Legnth Barrel Features:
5.56 Nato 16" Barrel, 1/7 twist, 4150 CrMoV, QPQ, gas port drilled
.750 gas block journal
Mid length gas system
M4 Feed Ramp Extension
HP and MPI tested
Standard A2 flash hider

WARNING
Cancer and Reproductive Harm
www.P65Warnings.ca.gov

No reviews have been written for this product.
Be the first one! – Write a Review

We Also Recommend

aero precision Aero Precision M4E1 Complete Upper 5.56MM 14.5" Barrel w Pinned VG6 Gamma, 12" Atlas R-One MLOK™

$699.99

We use cookies to improve your browsing experience. By continuing to browse our website you agree to our use of cookies. To learn more about how we use cookies, please review our privacy policy click here.