Award Number

Award Number 9700 / N4008521C0077 Federal Contract Action Summary (Last 5 Years)

Award record for PIID N4008521C0077 under agency ID 9700, showing activity over the last 5 years.

This award page summarizes obligated funding and action activity for PIID N4008521C0077. Over the last 5 years, the award shows 72 actions and total obligated dollars of 1.77 billion.

Generated at 03/20/2026

Analysis period: Last 5 years

Dollar figures are based on the provided analysis window and may differ from rounded values because exact totals are used in reporting.

Agency ID
9700
PIID
N4008521C0077
Type
Award
Total Obligated
1.77 billion
1,774,598,061.87
Actions
72
Average Action Value
24,647,195.30

Overview

This award record is tied to agency ID 9700 and PIID N4008521C0077. In the last 5 years, it reflects 72 award actions with total obligated funding of 1,774,598,061.87 and an average action value of 24,647,195.3.

How to use this page

Use this page to review the award-level funding profile and action count for the selected period. The exact obligation total and average action value support basic trend review and cross-checking against related procurement records.

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 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
1700 DEPT OF THE NAVY 1,774,598,061.87 1.77 billion 72

Insight

Obligations for PIID N4008521C0077 over the 5-year window are concentrated entirely within the DEPT OF THE NAVY, which accounts for $1.77 billion across 72 awards. This indicates a highly concentrated funding pattern with no other agencies represented in the provided rows. The distribution suggests the award activity is wholly Navy-driven within this query context.

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 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
381 CONSTRUCTORS 8QYU2 1,774,598,061.87 1.77 billion 72

Insight

Obligations for PIID N4008521C0077 are concentrated entirely with 381 CONSTRUCTORS (CAGE 8QYU2), which accounts for the full reported 1.77 billion across 72 awards over the 5-year window. This indicates a highly concentrated vendor profile with no other vendors represented in the provided data. The volume of awards suggests sustained reliance on a single contractor rather than a broadly 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 = 'N4008521C0077'
    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
237990 OTHER HEAVY AND CIVIL ENGINEERING CONSTRUCTION 1,774,598,061.87 1.77 billion 72

Insight

The award is fully concentrated in NAICS 237990, Other Heavy and Civil Engineering Construction, with $1.77 billion obligated across 72 awards in the 5-year window. This indicates a consistently concentrated procurement profile within a single heavy civil engineering category rather than a diversified NAICS mix. The volume of awards suggests repeated obligation activity under the same NAICS 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 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
Y1ED CONSTRUCTION OF SHIP CONSTRUCTION AND REPAIR FACILITIES 1,774,598,061.87 1.77 billion 72

Insight

Obligations under PIID N4008521C0077 are fully concentrated in PSC Y1ED, Construction of Ship Construction and Repair Facilities, with 72 awards totaling $1.77 billion over the 5-year window. This indicates the award is focused on a single construction category rather than a diversified PSC mix. The volume and dollar concentration suggest sustained investment in ship construction and repair facility work within 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 = 'N4008521C0077'
    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 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 increased sharply from $70.00 million in 2021 to $421.82 million in 2022, then remained at a high level through 2024, ranging from $442.92 million to $444.97 million. Award activity also expanded over the period, rising from 1 award in 2021 to 13 awards in 2022 and 2023, then 19 in 2024 and 26 in 2025. In 2025, obligated dollars declined to $394.88 million while award count reached its highest level, indicating a broader distribution of obligation 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.