This page summarizes the award identified by PIID N4008521C0077 for agency 9700. Over the last 10 years, the award totals 1.77 billion in obligated value across 72 actions.
Award Number
Award Number 9700 / N4008521C0077 Federal Contract Action Summary (Last 10 Years)
Federal award record for agency 9700 under PIID N4008521C0077, showing obligations and actions over the last 10 years.
Totals reflect the analysis window of the last 10 years; average action value is 24,647,195.3 and exact obligated value is 1774598061.87.
Overview
The award record for PIID N4008521C0077 shows 1,774,598,061.87 in obligated value across 72 award actions during the last 10 years. The average action value is 24,647,195.3, which indicates repeated activity within the same award record. This page is organized for review of the award’s obligation history and action volume.
How to use this page
Use this page to review the award’s total obligated amount, action count, and average action value within the stated analysis window. It supports basic award-level analysis for agency 9700 and can be used as a starting point for deeper examination of action history. The figures shown here are limited to the last 10 years.
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 = 'N4008521C0077'
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 |
|---|---|---|---|---|
| 1700 | DEPT OF THE NAVY | 1,774,598,061.87 | 1.77 billion | 72 |
Insight
Obligations for PIID N4008521C0077 are fully concentrated in a single agency, the DEPT OF THE NAVY, which accounts for $1.77 billion across 72 awards in the 10-year window. This indicates no cross-agency distribution in the provided data and suggests the award activity is centered entirely within one department.
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 = 'N4008521C0077'
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 |
|---|---|---|---|---|
| 381 CONSTRUCTORS | 8QYU2 | 1,774,598,061.87 | 1.77 billion | 72 |
Insight
381 CONSTRUCTORS is the only listed top vendor for award N4008521C0077 over the 10-year window, indicating complete vendor concentration in the provided data. The vendor accounts for $1.77 billion across 72 awards, suggesting a sustained, high-volume obligation pattern rather than a one-time transaction. Because no other vendors are listed, the available data does not support any broader distribution analysis within this section.
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 = 'N4008521C0077'
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 |
|---|---|---|---|---|
| 237990 | OTHER HEAVY AND CIVIL ENGINEERING CONSTRUCTION | 1,774,598,061.87 | 1.77 billion | 72 |
Insight
Over the 10-year window, award PIID N4008521C0077 is fully concentrated in NAICS 237990, Other Heavy and Civil Engineering Construction. This NAICS accounts for 72 awards and $1.77 billion in total obligated value, indicating a highly concentrated procurement profile within a single industry classification.
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 = 'N4008521C0077'
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 |
|---|---|---|---|---|
| Y1ED | CONSTRUCTION OF SHIP CONSTRUCTION AND REPAIR FACILITIES | 1,774,598,061.87 | 1.77 billion | 72 |
Insight
Obligations for this award are fully concentrated in PSC Y1ED, Construction of Ship Construction and Repair Facilities, with $1.77 billion obligated across 72 awards over the 10-year window. This indicates a highly focused procurement pattern with no diversification across other PSCs in the provided data. The volume of awards alongside the very large obligated value suggests repeated procurement activity in the same construction 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 = 'N4008521C0077'
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 |
|---|---|---|---|
| 2021 | 70,000,000.00 | 70.00 million | 1 |
| 2022 | 421,823,263.86 | 421.82 million | 13 |
| 2023 | 442,922,850.96 | 442.92 million | 13 |
| 2024 | 444,972,362.05 | 444.97 million | 19 |
| 2025 | 394,879,585.00 | 394.88 million | 26 |
Insight
Obligations for PIID N4008521C0077 are concentrated in the 2022–2025 period, rising sharply from $70.00 million in 2021 to a sustained annual level above $394.88 million thereafter. Funding was most pronounced in 2023 and 2024, when obligations peaked at $442.92 million and $444.97 million, respectively, with award counts increasing from 13 to 19. In 2025, obligated dollars declined to $394.88 million while award count increased to 26, indicating broader distribution across more actions despite lower annual dollar volume.
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.