This page summarizes award number W58RGZ22C0010 for agency ID 9700 over the last full year. It shows 20 award actions with total obligated value of 441,098,598.62, or 441.10 million readable.
Award Number
Award Number 9700 / W58RGZ22C0010 Federal Contract Action Summary (Last Year)
Federal procurement summary for award number W58RGZ22C0010 under agency ID 9700, showing last full year obligated totals and action activity.
Values are based on the provided analysis window and exact obligated amount of 441098598.62 across 20 actions.
Overview
For the last full year, award number W58RGZ22C0010 shows 20 recorded actions and total obligations of 441,098,598.62. The average action value is 22,054,929.93, which provides a simple measure of activity across the period.
How to use this page
Use this page to review the overall obligation level and action frequency associated with award W58RGZ22C0010. It is suitable for quick identification, comparison, and follow-up analysis within 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 = 'W58RGZ22C0010'
AND content__award__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__award__purchaserInformation__contractingOfficeAgencyID != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 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 | 441,098,598.62 | 441.10 million | 20 |
Insight
Obligations under PIID W58RGZ22C0010 in the past year are concentrated entirely with DEPT OF THE ARMY, which accounts for $441.10 million across 20 awards. This indicates a fully concentrated funding pattern with no observable distribution across other agencies in the provided results.
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 = 'W58RGZ22C0010'
AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
AND content__award__vendor__vendorHeader__vendorName != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 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 |
|---|---|---|---|---|
| SIKORSKY AIRCRAFT CORP | 78286 | 441,098,598.62 | 441.10 million | 20 |
Insight
Over the past 1 year, obligations for award W58RGZ22C0010 are fully concentrated with a single vendor, SIKORSKY AIRCRAFT CORP (CAGE 78286), which accounts for $441.10 million across 20 awards. This indicates all observed obligation activity in the period is directed to one supplier, with no diversification across other vendors in the provided data. The award pattern suggests sustained concentration rather than a dispersed 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 = 'W58RGZ22C0010'
AND content__award__productOrServiceInformation__principalNAICSCode IS NOT NULL
AND content__award__productOrServiceInformation__principalNAICSCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 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 | 441,098,598.62 | 441.10 million | 20 |
Insight
For PIID W58RGZ22C0010 over the past year, obligations are fully concentrated in NAICS 336411, Aircraft Manufacturing. This category accounts for $441.10 million across 20 awards, indicating a highly focused procurement profile with no diversification across other NAICS codes in the provided data. The distribution suggests the award activity is centered on aircraft manufacturing requirements within the selected window.
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 = 'W58RGZ22C0010'
AND content__award__productOrServiceInformation__productOrServiceCode IS NOT NULL
AND content__award__productOrServiceInformation__productOrServiceCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 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 |
|---|---|---|---|---|
| 1520 | AIRCRAFT, ROTARY WING | 441,098,598.62 | 441.10 million | 20 |
Insight
Obligations for PIID W58RGZ22C0010 over the 1-year window are fully concentrated in PSC 1520, Aircraft, Rotary Wing, with $441.10 million across 20 awards. This indicates a highly focused procurement profile with no observable distribution across other PSCs in the provided data. The average obligated amount is approximately $22.1 million per award, suggesting relatively large individual actions within a single product category.
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 = 'W58RGZ22C0010'
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC
| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2025 | 441,098,598.62 | 441.10 million | 20 |
Insight
For PIID W58RGZ22C0010 within Agency 9700, the 1-year annual trend shows obligations concentrated entirely in FY 2025, with $441.10 million obligated across 20 awards. This indicates a high level of activity within the observed window, but no year-over-year comparison is available from the provided rows. The distribution is therefore entirely single-year and cannot be used to assess directional change beyond FY 2025.
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 full year view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.