This page summarizes award N0002417C2105 for agency 9700 using the last 10 years of action data. The record shows 2,196 actions with total obligated amounts of 3.04 billion dollars.
Award Number
Award Number 9700 / N0002417C2105 Federal Contract Action Summary (Last 10 Years)
Federal procurement analysis for award N0002417C2105 at agency 9700 over the last 10 years.
Dollar figures are based on the provided total obligated exact value of 3,038,709,104.53 and the stated readable amount.
Agency ID
9700
PIID
N0002417C2105
Type
Award
Total Obligated
3.04 billion
3,038,709,104.53
Actions
2,196
Average Action Value
1,383,747.32
Overview
The award record for N0002417C2105 shows 2,196 actions across the last 10 years, with total obligated funding of 3,038,709,104.53 dollars. The average action value is 1,383,747.32 dollars, which provides a simple measure for comparing activity across the period. These figures are limited to the supplied award and agency context.
How to use this page
Use this page to review the scale and pace of procurement activity tied to award N0002417C2105. The action count, total obligations, and average action value can support basic contract trend checks, spend comparisons, and record-level reference work within agency 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 = 'N0002417C2105'
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 | 3,038,709,104.53 | 3.04 billion | 2,196 |
Insight
Obligations for PIID N0002417C2105 are fully concentrated in one agency: the Department of the Navy. Over the 10-year window, the Navy accounts for $3.04 billion across 2,196 awards, indicating a highly concentrated award relationship with no evidence of meaningful distribution to other agencies in the provided data.
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 = 'N0002417C2105'
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 |
|---|---|---|---|---|
| HUNTINGTON INGALLS INCORPORATED | 43689 | 3,038,709,104.53 | 3.04 billion | 2,196 |
Insight
Over the 10-year window for award N0002417C2105, obligations are entirely concentrated with HUNTINGTON INGALLS INCORPORATED (CAGE 43689). The vendor accounted for $3.04 billion across 2,196 awards, indicating sustained, high-volume funding to a single supplier. This pattern suggests a highly concentrated award profile with limited vendor distribution for this action.
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 = 'N0002417C2105'
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 |
|---|---|---|---|---|
| 336611 | SHIP BUILDING AND REPAIRING | 3,038,709,104.53 | 3.04 billion | 2,196 |
Insight
Across the 10-year window, obligations for award N0002417C2105 are fully concentrated in NAICS 336611, Ship Building and Repairing, with $3.04 billion obligated across 2,196 awards/actions. This indicates a highly specialized procurement profile with no diversification across other NAICS codes in the provided data. The volume and dollar concentration in a single NAICS suggest this award is tied to sustained ship construction or repair activity over time.
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 = 'N0002417C2105'
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 |
|---|---|---|---|---|
| 1905 | COMBAT SHIPS AND LANDING VESSELS | 3,038,709,104.53 | 3.04 billion | 2,196 |
Insight
Over the 10-year window, PSC 1905 (Combat Ships and Landing Vessels) accounted for all observed obligations on this award, totaling $3.04 billion across 2,196 actions. This indicates a highly concentrated procurement profile with no diversification across other PSCs in the provided data. The volume of actions suggests sustained award activity within a single maritime systems 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 = 'N0002417C2105'
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 |
|---|---|---|---|
| 2017 | 1,508,610,290.00 | 1.51 billion | 137 |
| 2018 | 0.00 | 0.00 | 524 |
| 2019 | 1,042,389,710.00 | 1.04 billion | 502 |
| 2020 | 102,150,958.00 | 102.15 million | 394 |
| 2021 | 307,204,343.00 | 307.20 million | 318 |
| 2022 | 74,339,716.60 | 74.34 million | 283 |
| 2023 | 4,014,086.93 | 4.01 million | 21 |
| 2024 | 0.00 | 0.00 | 12 |
| 2025 | 0.00 | 0.00 | 5 |
Insight
Obligations for PIID N0002417C2105 are heavily concentrated in FY 2017 and FY 2019, which together account for the vast majority of the reported dollar value in the 10-year window. After FY 2019, obligated amounts decline sharply, falling from $307.2 million in FY 2021 to $74.3 million in FY 2022 and $4.0 million in FY 2023, with zero obligated dollars reported in FY 2018, FY 2024, and FY 2025. Award counts remain relatively high through FY 2022 despite the declining dollar value, indicating a shift toward smaller obligations over time.
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.