This page provides a concise view of the award number N0001920C0006 for Agency ID 9700 across the last 5 years. The award shows 14 actions with total obligations of -$11.35 million and an average action value of -$810,713.18.
Award Number
Award Number 9700 / N0001920C0006 Federal Contract Action Summary (Last 5 Years)
Federal procurement profile for award N0001920C0006 under Agency ID 9700, summarizing obligations and actions over the last 5 years.
Amounts are based on the provided readable and exact totals for the stated analysis window and may reflect deobligations.
Overview
The award record for N0001920C0006 covers 14 reported actions in the last 5 years. Total obligated amount is -$11,349,984.55, or -$11.35 million when rounded to the nearest hundredth of a million. The average action value is -$810,713.18.
How to use this page
Use this page to review the obligation trend and action count associated with award N0001920C0006. The negative obligated total indicates the record includes reductions, so the figure should be read in the context of action-level changes rather than as a simple spend total.
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 = 'N0001920C0006'
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 |
|---|---|---|---|---|
| 9763 | DEFENSE CONTRACT MANAGEMENT AGENCY (DCMA) | 0.00 | 0.00 | 1 |
| 1700 | DEPT OF THE NAVY | -11,349,984.55 | -11.35 million | 13 |
Insight
Obligations on PIID N0001920C0006 are concentrated almost entirely within the DEPT OF THE NAVY, which accounts for 13 awards and a net obligated value of -$11.35 million over the 5-year window. The DEFENSE CONTRACT MANAGEMENT AGENCY (DCMA) is present only once and carries no obligated value, indicating minimal financial activity relative to the Navy. Overall, the award activity is highly concentrated in a single agency with a negative net obligation balance.
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 = 'N0001920C0006'
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 | -11,349,984.55 | -11.35 million | 14 |
Insight
LOCKHEED MARTIN CORPORATION is the only vendor listed for this award over the 5-year window, indicating complete vendor concentration in the observed top-vendor set. The recorded total obligated amount is negative (-$11.35 million) across 14 awards, which suggests net deobligations or downward funding adjustments rather than net new obligation growth.
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 = 'N0001920C0006'
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 | -11,349,984.55 | -11.35 million | 14 |
Insight
For PIID N0001920C0006 at Agency 9700 over the 5-year window, all reported obligations in this section are concentrated in NAICS 336411, Aircraft Manufacturing. The award reflects 14 actions totaling -$11.35 million, indicating a single-industry concentration with net negative obligated value across the period. No other NAICS codes are provided here, so this view does not indicate diversification across industry 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 = 'N0001920C0006'
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 | -11,349,984.55 | -11.35 million | 14 |
Insight
Obligations for PIID N0001920C0006 are concentrated entirely in PSC 1510, Aircraft, Fixed Wing, over the 5-year window. This PSC accounts for -$11.35 million across 14 awards, indicating repeated activity within a single product category rather than a diversified PSC mix. The negative obligated total suggests deobligations or downward funding adjustments in this 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 = 'N0001920C0006'
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 | -3,636,865.00 | -3.64 million | 6 |
| 2022 | 326,257.00 | 326.26 thousand | 1 |
| 2023 | -5,578,379.00 | -5.58 million | 2 |
| 2024 | -2,460,997.55 | -2.46 million | 3 |
| 2025 | 0.00 | 0.00 | 2 |
Insight
Obligations for PIID N0001920C0006 were concentrated in negative net activity across the 5-year window, with four of five years showing deobligations or reduced funding and only 2022 recording positive obligations. The largest annual decrease occurred in 2023 at -$5.58 million, followed by -$3.64 million in 2021 and -$2.46 million in 2024, indicating sustained downward net movement rather than a single isolated adjustment. Award activity was also uneven, ranging from one award in 2022 to six in 2021, with two awards in both 2023 and 2025.
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.