Award N0002418C2307 recorded 143 award actions in the last full year, with total obligations of 314.62 million dollars. The average action value was 2,200,149.82.
Award Number
Award Number 9700 / N0002418C2307 Federal Contract Action Summary (Last Year)
Federal procurement summary for award number N0002418C2307 under agency ID 9700 covering the last full year of activity.
Total obligated is shown as 314,621,423.89, which is rounded to 314.62 million in readable format.
Agency ID
9700
PIID
N0002418C2307
Type
Award
Total Obligated
314.62 million
314,621,423.89
Actions
143
Average Action Value
2,200,149.82
Overview
During the last full year, award N0002418C2307 under agency ID 9700 showed 143 recorded actions. Total obligated funding reached 314,621,423.89, with an average action value of 2,200,149.82. These figures describe activity for the analyzed period only.
How to use this page
Use this page to review the award’s recent procurement activity at a glance and compare action volume with obligated dollars. The values support basic trend review, award-level filtering, and period-specific reporting for the last full year.
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 = 'N0002418C2307'
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 | 314,621,423.89 | 314.62 million | 143 |
Insight
Within the 1-year window for PIID N0002418C2307, obligations are concentrated entirely with the DEPT OF THE NAVY (agency ID 1700). The Navy accounts for $314.62 million across 143 awards, indicating a highly concentrated funding profile with no other agencies represented in the provided rows. This suggests the award activity is exclusively or overwhelmingly Navy-funded during the period reviewed.
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 = 'N0002418C2307'
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 | 314,621,423.89 | 314.62 million | 143 |
Insight
HUNTINGTON INGALLS INCORPORATED (CAGE 34293) accounted for the full observed obligation for this award over the 1-year window, with $314.62 million across 143 awards. This indicates complete vendor concentration within the provided data and a high volume of transactions tied to a single contractor. No additional vendors appear in the provided rows, so distribution cannot be compared across suppliers.
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 = 'N0002418C2307'
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 | 314,621,423.89 | 314.62 million | 143 |
Insight
Over the 1-year window, obligations are fully concentrated in NAICS 336611, Ship Building and Repairing, with $314.62 million across 143 awards. This indicates the award activity for PIID N0002418C2307 is heavily focused in a single industrial classification, with no other NAICS reported in this section. The distribution suggests a narrow procurement profile rather than diversified spending across multiple sectors.
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 = 'N0002418C2307'
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 | 314,621,423.89 | 314.62 million | 143 |
Insight
Obligations on PIID N0002418C2307 are concentrated entirely in PSC 1905, Combat Ships and Landing Vessels, with $314.62 million obligated across 143 awards in the 1-year window. This indicates a highly focused procurement profile with no observed diversification across other PSCs in the provided data. The volume of awards suggests repeated activity within the same product/service category rather than a broad mix of requirements.
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 = 'N0002418C2307'
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 | 314,621,423.89 | 314.62 million | 143 |
Insight
Over the 1-year window, obligations are concentrated in a single reporting year: FY2025 accounts for $314.62 million across 143 awards. This indicates the award activity for PIID N0002418C2307 is heavily centered in FY2025, with no other years reflected in the provided data for trend comparison. The distribution suggests recent, high-volume obligation activity rather than a multi-year spread.
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.