This page summarizes the procurement record for award W31P4Q23C0036, with total obligated amount of 1.61 billion across 26 award actions. The average action value is 61.84 million over the analysis window.
Award Number
Award Number 9700 / W31P4Q23C0036 Federal Contract Action Summary (Last 5 Years)
Federal award page for award number W31P4Q23C0036 under agency ID 9700, covering activity in the last 5 years.
Amounts reflect the last 5 years of award activity and use the provided total obligated exact value of 1607872304.74.
Overview
Award W31P4Q23C0036 is associated with agency ID 9700 and shows 26 award actions in the last 5 years. Total obligated amount is 1,607,872,304.74, which is approximately 1.61 billion. The average action value across the period is 61,841,242.49.
How to use this page
Use this page to review the award-level obligation pattern for W31P4Q23C0036 over the analysis window. The figures support quick comparison of total obligated value, action count, and average action value for this award.
Top Agencies
SELECT
content__award__purchaserInformation__contractingOfficeAgencyID AS agency_id,
content__award__purchaserInformation__contractingOfficeAgencyID__name AS agency_name,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = 'W31P4Q23C0036'
AND content__award__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__award__purchaserInformation__contractingOfficeAgencyID != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
agency_id,
agency_name
ORDER BY total_obligated DESC
LIMIT 10
| Agency ID | Agency Name | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| 2100 | DEPT OF THE ARMY | 1,607,872,304.74 | 1.61 billion | 25 |
| 9763 | DEFENSE CONTRACT MANAGEMENT AGENCY (DCMA) | 0.00 | 0.00 | 1 |
Insight
Obligations for PIID W31P4Q23C0036 over the 5-year window are highly concentrated in the Department of the Army, which accounts for $1.61 billion across 25 awards. DCMA appears only once and carries no obligated value, indicating minimal financial distribution outside the Army. Overall, the award history is concentrated in a single funding source, with no material obligated activity recorded for the secondary agency listed.
Top Vendors
SELECT
vendor_name,
cage_code,
total_obligated,
award_count,
formatReadableQuantity(total_obligated) AS total_obligated_readable
FROM
(
SELECT
content__award__vendor__vendorHeader__vendorName AS vendor_name,
ifNull(content__award__vendor__vendorSiteDetails__entityIdentifiers__cageCode, '') AS cage_code,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = 'W31P4Q23C0036'
AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
AND content__award__vendor__vendorHeader__vendorName != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
vendor_name,
cage_code
)
ORDER BY total_obligated DESC
LIMIT 10
| Vendor | CAGE Code | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| RAYTHEON COMPANY | 05716 | 1,607,872,304.74 | 1.61 billion | 26 |
Insight
Over the 5-year window for PIID W31P4Q23C0036, obligations are fully concentrated with a single vendor, RAYTHEON COMPANY (CAGE 05716). The vendor received 26 awards totaling $1.61 billion, indicating a highly concentrated award distribution with no evidence in this section of diversification across additional vendors. This pattern suggests continued reliance on one contractor for the reported award activity under this PIID.
Top NAICS
SELECT
content__award__productOrServiceInformation__principalNAICSCode AS naics_code,
content__award__productOrServiceInformation__principalNAICSCode__description AS naics_name,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = 'W31P4Q23C0036'
AND content__award__productOrServiceInformation__principalNAICSCode IS NOT NULL
AND content__award__productOrServiceInformation__principalNAICSCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
naics_code,
naics_name
ORDER BY total_obligated DESC
LIMIT 10
| NAICS Code | Description | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| 336414 | GUIDED MISSILE AND SPACE VEHICLE MANUFACTURING | 1,607,872,304.74 | 1.61 billion | 26 |
Insight
Award obligations are fully concentrated in NAICS 336414, Guided Missile and Space Vehicle Manufacturing, with $1.61 billion across 26 awards over the 5-year window. This indicates a highly focused procurement profile tied to a single industrial base segment rather than a diversified mix of NAICS codes. The volume of awards alongside the concentrated dollar value suggests repeated activity within the same manufacturing category.
Top PSC Codes
SELECT
content__award__productOrServiceInformation__productOrServiceCode AS psc_code,
content__award__productOrServiceInformation__productOrServiceCode__description AS psc_name,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = 'W31P4Q23C0036'
AND content__award__productOrServiceInformation__productOrServiceCode IS NOT NULL
AND content__award__productOrServiceInformation__productOrServiceCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
psc_code,
psc_name
ORDER BY total_obligated DESC
LIMIT 10
| PSC Code | Description | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| 1420 | GUIDED MISSILE COMPONENTS | 1,607,872,304.74 | 1.61 billion | 26 |
Insight
Over the 5-year window, obligations for award W31P4Q23C0036 are highly concentrated in PSC 1420, Guided Missile Components, with $1.61 billion obligated across 26 awards. This indicates the award’s spend profile is dominated by a single product service code rather than being broadly distributed across multiple PSCs. The concentration suggests PSC 1420 is the primary driver of obligated value for this award.
Annual Trend
SELECT
toYear(parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate)) AS year,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable,
count() AS award_count
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = 'W31P4Q23C0036'
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC
| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2023 | 50,760,840.45 | 50.76 million | 3 |
| 2024 | 934,536,269.83 | 934.54 million | 6 |
| 2025 | 622,575,194.46 | 622.58 million | 17 |
Insight
Obligations for PIID W31P4Q23C0036 are highly concentrated in 2024 and 2025, which together account for most of the 5-year window observed here. Funding rose from 50.76 million across 3 awards in 2023 to 934.54 million across 6 awards in 2024, then remained elevated at 622.58 million across 17 awards in 2025. The increase in award count in 2025 alongside lower obligated dollars versus 2024 suggests a broader distribution of funding across more awards.
Use FPDS Query for deeper award and vehicle analysis
Explore federal procurement data with custom SQL, fast filtering, and deeper contract action analysis across agencies, vendors, NAICS, PSC, and annual trends.
Continue from this last 5 years view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.