This page summarizes obligation and action activity for award number W58RGZ23C0001 in agency ID 9700 over the last 10 years. The award shows 75 recorded actions and total obligated funding of 3.50 billion.
Award Number
Award Number 9700 / W58RGZ23C0001 Federal Contract Action Summary (Last 10 Years)
Federal procurement summary for award number W58RGZ23C0001 under agency ID 9700, covering the last 10 years.
Total obligated equals 3,497,288,935 and average action value is 46,630,519.13 across the analysis window.
Agency ID
9700
PIID
W58RGZ23C0001
Type
Award
Total Obligated
3.50 billion
3,497,288,935.00
Actions
75
Average Action Value
46,630,519.13
Overview
Award number W58RGZ23C0001 is associated with agency ID 9700 in the last 10 years of FPDS activity. The record reflects 75 actions and 3,497,288,935 in total obligated value. The average action value across those actions is 46,630,519.13.
How to use this page
Use this page to review the award-level obligation pattern for W58RGZ23C0001 and compare action volume against total dollars obligated. The figures support basic analysis of funding concentration and the scale of activity recorded for agency ID 9700.
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 = 'W58RGZ23C0001'
AND content__award__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__award__purchaserInformation__contractingOfficeAgencyID != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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,497,288,935.00 | 3.50 billion | 75 |
Insight
Obligations for PIID W58RGZ23C0001 are fully concentrated in a single agency: the Department of the Army (Agency ID 2100), which accounts for $3.50 billion across 75 awards over the 10-year window. This indicates the award activity is highly concentrated within one procuring agency, with no evidence in the provided rows of distribution across other agencies. The award count suggests repeated contracting activity within the same agency relationship rather than a broad interagency footprint.
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 = 'W58RGZ23C0001'
AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
AND content__award__vendor__vendorHeader__vendorName != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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 |
|---|---|---|---|---|
| BELL TEXTRON INC. | 97499 | 3,497,288,935.00 | 3.50 billion | 75 |
Insight
Over the 10-year window, obligations for PIID W58RGZ23C0001 are fully concentrated with a single vendor, BELL TEXTRON INC. (CAGE 97499). The vendor received 75 awards totaling $3.50 billion, indicating an exceptionally concentrated award distribution with no visible diversification among top vendors in the provided data. This level of concentration suggests sustained reliance on one contractor for the award activity captured here.
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 = 'W58RGZ23C0001'
AND content__award__productOrServiceInformation__principalNAICSCode IS NOT NULL
AND content__award__productOrServiceInformation__principalNAICSCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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 |
|---|---|---|---|---|
| 336411 | AIRCRAFT MANUFACTURING | 3,497,288,935.00 | 3.50 billion | 75 |
Insight
Obligations for PIID W58RGZ23C0001 over the 10-year window are fully concentrated in NAICS 336411, Aircraft Manufacturing. The award reflects $3.50 billion across 75 awards, indicating a clear specialization and no observable diversification across additional NAICS codes in the provided data. This concentration suggests the procurement activity is narrowly aligned to aircraft manufacturing requirements.
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 = 'W58RGZ23C0001'
AND content__award__productOrServiceInformation__productOrServiceCode IS NOT NULL
AND content__award__productOrServiceInformation__productOrServiceCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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 |
|---|---|---|---|---|
| AC33 | NATIONAL DEFENSE R&D SERVICES; DEFENSE-RELATED ACTIVITIES; EXPERIMENTAL DEVELOPMENT | 3,497,288,935.00 | 3.50 billion | 75 |
Insight
Obligations for PIID W58RGZ23C0001 are fully concentrated in PSC AC33, which accounts for the entire 10-year obligation total of $3.50 billion across 75 awards. This indicates a highly focused procurement profile centered on national defense R&D experimental development services, with no evidence here of PSC diversification within 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 = 'W58RGZ23C0001'
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2022 | 232,208,330.00 | 232.21 million | 2 |
| 2023 | 527,107,545.00 | 527.11 million | 17 |
| 2024 | 1,009,219,928.00 | 1.01 billion | 24 |
| 2025 | 1,728,753,132.00 | 1.73 billion | 32 |
Insight
Obligations on PIID W58RGZ23C0001 increased sharply over the period, rising from 232.21 million across 2 awards in 2022 to 1.73 billion across 32 awards in 2025. The pattern indicates both a higher volume of awards and a substantial increase in obligated dollars year over year, with the largest step-up occurring from 2024 to 2025. This concentration in the most recent years suggests the instrument became materially more active over time rather than remaining evenly distributed across the 10-year window.
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 10 years view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.