This page summarizes federal procurement activity for award number N0001918C1041 under agency ID 9700. The analysis window covers the last full year and reflects three award actions totaling $461,378,864.17.
Award Number
Award Number 9700 / N0001918C1041 Federal Contract Action Summary (Last Year)
Award number N0001918C1041 for agency 9700 shows $461.38 million in obligated value across the last full year.
Totals are based on the provided obligated amount and action count for the last full year.
Agency ID
9700
PIID
N0001918C1041
Type
Award
Total Obligated
461.38 million
461,378,864.17
Actions
3
Average Action Value
153,792,954.72
Overview
For the last full year, award number N0001918C1041 recorded total obligated value of $461,378,864.17, with an average action value of $153,792,954.72 across three award actions. This provides a compact view of the award’s observed procurement activity for agency ID 9700.
How to use this page
Use this page to review the award-level obligation total, action count, and average action value for the selected analysis window. It is intended for structured review of procurement activity tied to PIID N0001918C1041 rather than narrative interpretation.
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 = 'N0001918C1041'
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 | 461,378,864.17 | 461.38 million | 3 |
Insight
All obligated activity in this 1-year window is concentrated in a single top agency: the Department of the Navy, which accounts for $461.38 million across 3 awards. This indicates a highly concentrated funding profile with no visible distribution across other agencies in the provided data. The small award count suggests the obligation volume is driven by a limited number of actions rather than broad agency participation.
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 = 'N0001918C1041'
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 |
|---|---|---|---|---|
| LOCKHEED MARTIN CORPORATION | 81755 | 461,378,864.17 | 461.38 million | 3 |
Insight
LOCKHEED MARTIN CORPORATION is the sole top vendor listed for this award within the 1-year window, accounting for the full observed obligation of $461.38 million across 3 awards. This indicates a highly concentrated vendor distribution, with all reported obligations under this section tied to a single contractor. The pattern suggests this award activity is not broadly dispersed across vendors in the selected period.
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 = 'N0001918C1041'
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 |
|---|---|---|---|---|
| 336411 | AIRCRAFT MANUFACTURING | 461,378,864.17 | 461.38 million | 3 |
Insight
Over the past 1 year, obligations for award N0001918C1041 are fully concentrated in NAICS 336411, Aircraft Manufacturing, with $461.38 million across 3 awards. This indicates a narrow industrial scope and no diversification across other NAICS codes in the provided data. The concentration suggests the award activity is dominated by aircraft manufacturing work within the period reviewed.
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 = 'N0001918C1041'
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 |
|---|---|---|---|---|
| 1510 | AIRCRAFT, FIXED WING | 461,378,864.17 | 461.38 million | 3 |
Insight
Within the 1-year window for award PIID N0001918C1041, PSC 1510 (Aircraft, Fixed Wing) accounts for the full reported obligated amount of $461.38 million across 3 awards. Obligations are therefore completely concentrated in a single PSC category, indicating a highly focused procurement profile rather than a diversified mix of product types. This concentration suggests that the award’s activity in the period was driven entirely by fixed-wing aircraft 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 = 'N0001918C1041'
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 | 461,378,864.17 | 461.38 million | 3 |
Insight
In the 1-year window, obligations for award N0001918C1041 were concentrated entirely in FY2025, with $461.38 million obligated across 3 awards/actions. This indicates a highly concentrated funding profile within the period, with no distribution across other fiscal years in the provided data. The limited count suggests the obligation volume was driven by a small number of transactions rather than broad recurring activity.
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.