This page summarizes obligation and action activity for award number N0001918C1021 over the last 10 years. The record shows 97 award actions and total obligated amounts of 8.69 billion.
Award Number
Award Number 9700 / N0001918C1021 Federal Contract Action Summary (Last 10 Years)
Federal procurement profile for award number N0001918C1021 under agency ID 9700, covering activity in the last 10 years.
Totals are based on the provided analysis window and may reflect rounded display values alongside exact obligation figures.
Agency ID
9700
PIID
N0001918C1021
Type
Award
Total Obligated
8.69 billion
8,688,654,906.89
Actions
97
Average Action Value
89,573,761.93
Overview
Award number N0001918C1021 is associated with agency ID 9700 and shows 97 recorded actions in the last 10 years. Total obligated amount is 8,688,654,906.89, with an average action value of 89,573,761.93. The readable total is 8.69 billion for display purposes.
How to use this page
Use this page to review obligation volume and action frequency for award number N0001918C1021 across the selected 10-year window. The figures support basic trend review, comparison, and follow-up analysis by analysts working from FPDS query results.
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 = 'N0001918C1021'
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 | 8,688,654,906.89 | 8.69 billion | 91 |
| 9763 | DEFENSE CONTRACT MANAGEMENT AGENCY (DCMA) | 0.00 | 0.00 | 6 |
Insight
Obligations for PIID N0001918C1021 over the 10-year window are highly concentrated in the DEPT OF THE NAVY, which accounts for $8.69 billion across 91 awards. DCMA appears as a secondary awarding agency with 6 awards but no obligated amount recorded. This distribution indicates the award activity is driven almost entirely by Navy obligations, with DCMA involvement limited to administrative or non-obligating actions.
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 = 'N0001918C1021'
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 |
|---|---|---|---|---|
| UNITED TECHNOLOGIES CORPORATION | 52661 | 8,688,654,906.89 | 8.69 billion | 97 |
Insight
United Technologies Corporation is the sole listed top vendor for this award, with $8.69 billion in total obligated dollars across 97 awards over the 10-year window. This indicates a highly concentrated vendor profile for PIID N0001918C1021, with obligation activity dominated by a single contractor. The volume and dollar magnitude suggest sustained, repeated funding relationship rather than a one-time transaction.
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 = 'N0001918C1021'
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 |
|---|---|---|---|---|
| 336412 | AIRCRAFT ENGINE AND ENGINE PARTS MANUFACTURING | 8,688,654,906.89 | 8.69 billion | 97 |
Insight
Over the 10-year window, this award is entirely concentrated in NAICS 336412, Aircraft Engine and Engine Parts Manufacturing. All reported obligations, totaling $8.69 billion across 97 awards, fall within a single NAICS, indicating a highly focused procurement profile with no observable NAICS diversification in the provided data.
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 = 'N0001918C1021'
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 |
|---|---|---|---|---|
| 2840 | GAS TURBINES AND JET ENGINES, AIRCRAFT, PRIME MOVING; AND COMPONENTS | 8,688,654,906.89 | 8.69 billion | 97 |
Insight
Over the 10-year window, this award is concentrated in PSC 2840, with $8.69 billion obligated across 97 awards. PSC 2840 accounts for the full observed obligation in the provided rows, indicating a highly concentrated procurement profile rather than a diversified mix of product/service categories. The volume of awards relative to obligation suggests repeated activity within the same aircraft propulsion 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 = 'N0001918C1021'
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 |
|---|---|---|---|
| 2018 | 636,846,068.45 | 636.85 million | 6 |
| 2019 | 6,580,458,128.96 | 6.58 billion | 29 |
| 2020 | 625,589,217.24 | 625.59 million | 18 |
| 2021 | 5,492,533.68 | 5.49 million | 21 |
| 2022 | 896,954,721.93 | 896.95 million | 11 |
| 2023 | -1,237,519.00 | -1.24 million | 6 |
| 2024 | -939,215.82 | -939.22 thousand | 4 |
| 2025 | -54,509,028.55 | -54.51 million | 2 |
Insight
Obligations under PIID N0001918C1021 are highly concentrated in 2019, when funding reached $6.58 billion across 29 awards, far exceeding all other years in the 10-year window. Subsequent years show a sharp decline and greater volatility, with obligations dropping to $625.59 million in 2020 and then to near-zero levels in 2021 before rebounding to $896.95 million in 2022. From 2023 through 2025, obligations turned negative each year, indicating net deobligations, while award counts also fell to 6, 4, and 2 respectively.
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.