Award Number

Award Number 9700 / N0002418C2406 Federal Contract Action Summary (Last Year)

Analyst summary for award N0002418C2406 under agency ID 9700, showing last full year obligation and action activity.

This page summarizes federal award activity for PIID N0002418C2406 during the last full year. Total obligated amounts to 85.95 million across 41 award actions, for an average action value of 2,096,295.13.

Last full year Last 5 years Last 10 years

Generated at 03/20/2026

Analysis period: Last full year

Figures reflect the provided analysis window and the award-level obligation total, action count, and average action value.

Agency ID

9700

PIID

N0002418C2406

Type

Award

Total Obligated

85.95 million

85,948,100.50

Actions

Average Action Value

2,096,295.13

Overview

In the last full year, award N0002418C2406 recorded 41 award actions and 85,948,100.5 in total obligated dollars. The average action value was 2,096,295.13, indicating the scale of activity captured in this award record. Agency ID 9700 is the only agency identifier provided for this page.

How to use this page

Use this page to review award-level obligation totals and action frequency for N0002418C2406 over the stated analysis window. The figures support quick comparison of total obligated value against the number of actions and the average value per action.

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 = 'N0002418C2406'
    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
1700	DEPT OF THE NAVY	85,948,100.50	85.95 million	41

Insight

Within the 1-year window for PIID N0002418C2406, obligations are concentrated in a single top agency: DEPT OF THE NAVY. This agency accounts for 85.95 million across 41 awards, indicating that current award activity is heavily concentrated rather than broadly distributed across agencies.

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 = 'N0002418C2406'
        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
HUNTINGTON INGALLS INCORPORATED	34293	85,948,100.50	85.95 million	41

Insight

HUNTINGTON INGALLS INCORPORATED (CAGE 34293) accounts for all reported obligation in this 1-year window, with $85.95 million obligated across 41 awards under PIID N0002418C2406. This indicates full vendor concentration in the reported award activity, with no other vendors represented in the provided data. The award pattern suggests repeated obligation to a single contractor 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 = 'N0002418C2406'
    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
336611	SHIP BUILDING AND REPAIRING	85,948,100.50	85.95 million	41

Insight

Obligations for PIID N0002418C2406 are fully concentrated in NAICS 336611, Ship Building and Repairing, with $85.95 million obligated across 41 awards in the 1-year window. This pattern indicates a highly focused procurement profile with no observable diversification across NAICS codes in the provided data. The award count suggests repeated activity within a single industrial classification rather than a broad mix of procurement categories.

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 = 'N0002418C2406'
    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
1905	COMBAT SHIPS AND LANDING VESSELS	85,948,100.50	85.95 million	41

Insight

Over the past 1 year, obligations under PIID N0002418C2406 are fully concentrated in PSC 1905, Combat Ships and Landing Vessels, totaling $85.95 million across 41 awards. This indicates a narrow product-service mix with spending entirely tied to a single PSC category. The award count suggests repeated obligations within the same ship-related classification rather than a diversified PSC distribution.

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 = 'N0002418C2406'
    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	85,948,100.50	85.95 million	41

Insight

For PIID N0002418C2406, the 1-year annual trend reflects obligations of 85.95 million in FY2025 across 41 awards. This indicates a moderate concentration of obligated value within a relatively limited award count over the period. With only one year of data provided, no year-over-year trend can be assessed from this section alone.

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.

Start 7-Day Trial Learn More