This page summarizes procurement activity for award number N0001917C0001 under agency 9700 during the last 5 years. The award has 95 recorded actions and $451.34 million in total obligations.
Award Number
Award Number 9700 / N0001917C0001 Federal Contract Action Summary (Last 5 Years)
Award number N0001917C0001 for agency 9700 shows obligation activity over the last 5 years.
Totals reflect the provided analysis window and use the exact obligated amount of $451,338,351.
Overview
Award number N0001917C0001 is associated with 95 actions in the last 5 years. The total obligated amount is $451,338,351, with an average action value of $4,750,930.01. These figures provide a compact view of activity for agency 9700 on this award.
How to use this page
Use this page to review obligation totals and action frequency for award N0001917C0001. The summary can help identify how often the award changed and the scale of dollars tied to each recorded 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 = 'N0001917C0001'
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 | 451,338,351.00 | 451.34 million | 60 |
| 9763 | DEFENSE CONTRACT MANAGEMENT AGENCY (DCMA) | 0.00 | 0.00 | 35 |
Insight
Obligations for PIID N0001917C0001 are concentrated almost entirely within the DEPT OF THE NAVY, which accounts for $451.34 million across 60 awards in the 5-year window. DCMA appears in 35 awards but shows no obligated dollars, indicating administrative or oversight activity rather than funded obligation on this PIID. Overall, the funding profile is highly concentrated in a single agency with minimal financial distribution to other listed entities.
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 = 'N0001917C0001'
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 |
|---|---|---|---|---|
| LOCKHEED MARTIN CORPORATION | 81755 | 451,338,351.00 | 451.34 million | 95 |
Insight
Over the 5-year window for award N0001917C0001 under agency 9700, all reported obligated dollars in this section are concentrated with a single vendor: LOCKHEED MARTIN CORPORATION (CAGE 81755). The vendor received 95 awards totaling $451.34 million, indicating a high degree of supplier concentration and no diversification within the provided rows. This pattern suggests sustained reliance on one contractor for obligated activity associated with this award.
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 = 'N0001917C0001'
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 |
|---|---|---|---|---|
| 336411 | AIRCRAFT MANUFACTURING | 451,338,351.00 | 451.34 million | 95 |
Insight
Over the 5-year window, obligations for PIID N0001917C0001 under Agency ID 9700 are fully concentrated in NAICS 336411, Aircraft Manufacturing. The award records 95 actions in this NAICS, with total obligated dollars of $451.34 million, indicating a single-industry procurement profile rather than a diversified NAICS distribution. This concentration suggests the award’s funding is narrowly aligned to aircraft manufacturing activities.
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 = 'N0001917C0001'
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 |
|---|---|---|---|---|
| 1510 | AIRCRAFT, FIXED WING | 451,338,351.00 | 451.34 million | 95 |
Insight
Over the 5-year window for award PIID N0001917C0001 under Agency ID 9700, obligations are concentrated entirely in PSC 1510, Aircraft, Fixed Wing. This PSC accounts for $451.34 million across 95 awards, indicating a sustained procurement pattern centered on fixed-wing aircraft rather than a diversified PSC mix.
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 = 'N0001917C0001'
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 | -39,977,921.20 | -39.98 million | 29 |
| 2022 | 425,533,756.00 | 425.53 million | 35 |
| 2023 | 66,107,679.20 | 66.11 million | 21 |
| 2024 | 788,239.00 | 788.24 thousand | 8 |
| 2025 | -1,113,402.00 | -1.11 million | 2 |
Insight
Obligations for PIID N0001917C0001 are highly concentrated in 2022, when annual obligated value peaked at $425.53 million across 35 awards. Activity then declined sharply, dropping to $66.11 million in 2023 and falling to minimal levels in 2024 and 2025, with only 8 and 2 awards respectively. The 2021 and 2025 negative obligated amounts indicate downward adjustments or deobligations, offsetting some of the positive funding recorded in other years.
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.