This award record shows 75 actions on PIID W31P4Q18C0049 during the last 5 years. Total obligated amount is 3.53 million, with an average action value of 47,124.67.
Award Number
Award Number 9700 / W31P4Q18C0049 Federal Contract Action Summary (Last 5 Years)
Federal procurement summary for award W31P4Q18C0049 under agency 9700, covering obligations and action history over the last 5 years.
Figures are based on the provided 5-year analysis window and the exact obligated total of 3,534,350.59.
Agency ID
9700
PIID
W31P4Q18C0049
Type
Award
Total Obligated
3.53 million
3,534,350.59
Actions
75
Average Action Value
47,124.67
Overview
This page summarizes award number W31P4Q18C0049 for agency 9700 over the last 5 years. The record includes 75 award actions and a total obligated amount of 3,534,350.59, with an average action value of 47,124.67.
How to use this page
Use this page to review the award-level obligation pattern and action count for W31P4Q18C0049. The figures support basic procurement analysis, including scale, frequency of activity, and average action size within the selected window.
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 = 'W31P4Q18C0049'
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 | 3,534,350.59 | 3.53 million | 75 |
Insight
Over the 5-year window for award W31P4Q18C0049, obligations are concentrated entirely within the DEPT OF THE ARMY. The Army accounts for $3.53 million across 75 awards, indicating a fully concentrated agency distribution with no other agencies represented in the provided rows. This pattern suggests all visible obligation activity for this PIID is tied to a single agency relationship.
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 = 'W31P4Q18C0049'
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 |
|---|---|---|---|---|
| LOCKHEED MARTIN CORPORATION | 64059 | 3,534,350.59 | 3.53 million | 75 |
Insight
Over the 5-year window for award W31P4Q18C0049, obligations are fully concentrated with a single vendor: LOCKHEED MARTIN CORPORATION (CAGE 64059). The vendor received 75 awards totaling $3.53 million, indicating a consistently recurring procurement relationship rather than a distributed vendor base.
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 = 'W31P4Q18C0049'
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 | 3,534,350.59 | 3.53 million | 75 |
Insight
Over the last 5 years, obligations for award W31P4Q18C0049 are concentrated entirely in NAICS 336414, Guided Missile and Space Vehicle Manufacturing. This NAICS accounts for $3.53 million across 75 awards, indicating a highly focused procurement pattern within a single industrial category. The distribution suggests repeated activity in the same sector rather than a diversified obligation profile.
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 = 'W31P4Q18C0049'
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 |
|---|---|---|---|---|
| 1410 | GUIDED MISSILES | 3,534,350.59 | 3.53 million | 75 |
Insight
Over the 5-year window for award W31P4Q18C0049, obligations are fully concentrated in PSC 1410, Guided Missiles, with $3.53 million across 75 awards. This indicates a narrow procurement mix and sustained use of the same product category rather than a diversified PSC distribution. The award volume suggests repeated transactional activity within a single PSC, but no variation across other PSCs is evident in the provided data.
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 = 'W31P4Q18C0049'
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 |
|---|---|---|---|
| 2021 | 5,097,933.66 | 5.10 million | 26 |
| 2022 | 3,617.00 | 3.62 thousand | 24 |
| 2023 | 741,287.14 | 741.29 thousand | 18 |
| 2024 | -682,058.80 | -682.06 thousand | 6 |
| 2025 | -1,626,428.41 | -1.63 million | 1 |
Insight
Obligations for PIID W31P4Q18C0049 under Agency 9700 were highly concentrated in 2021, when 26 awards accounted for $5.10 million, far exceeding subsequent years. Activity then declined sharply by obligation value and award count: 2022 and 2023 remained relatively low, with 24 and 18 awards, respectively, but only modest funding. The series turns negative in 2024 and 2025, indicating deobligations in those years, with the largest negative amount in 2025 despite only one award.
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.