Award Number

Award Number 9700 / N0001915C0004 Federal Contract Action Summary (Last 5 Years)

Federal procurement profile for award number N0001915C0004 under agency ID 9700, covering actions in the last 5 years.

This page summarizes obligation activity for award number N0001915C0004 within agency ID 9700 over the last 5 years. The record shows 13 award actions with total obligated amount of -4.56 million.

Last full year Last 5 years Last 10 years

Generated at 03/20/2026

Analysis period: Last 5 years

Totals are based on the provided exact obligated value of -4564159.25 and average action value of -351089.17.

Agency ID

9700

PIID

N0001915C0004

Type

Award

Total Obligated

-4.56 million

-4,564,159.25

Actions

Average Action Value

-351,089.17

Overview

The award record for N0001915C0004 shows 13 actions during the last 5 years, with total obligated value of -4564159.25. The average action value is -351089.17, which indicates the obligation pattern across the reported action history. This page is limited to the inputs provided and does not add unreported contract details.

How to use this page

Use this page to review the award-level obligation total, action count, and average action value for N0001915C0004 under agency ID 9700. The figures support basic FPDS-style analysis of how activity is distributed across the 13 actions in the analysis window.

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 = 'N0001915C0004'
    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)	-2,163,662.99	-2.16 million	3
1700	DEPT OF THE NAVY	-2,400,496.26	-2.40 million	10

Insight

Over the past 5 years, obligations associated with PIID N0001915C0004 are concentrated in two agencies: the Department of the Navy and the Defense Contract Management Agency. The Department of the Navy accounts for the larger share of negative obligated amount, at -$2.40 million across 10 awards, compared with DCMA’s -$2.16 million across 3 awards. This indicates the activity is distributed across multiple awards, but the funding impact is dominated by these two agencies.

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 = 'N0001915C0004'
        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
UNITED TECHNOLOGIES CORPORATION	52661	-4,564,159.25	-4.56 million	13

Insight

Obligations for PIID N0001915C0004 over the 5-year window are fully concentrated with UNITED TECHNOLOGIES CORPORATION (CAGE 52661), which accounts for the only listed vendor in this section. The vendor is associated with 13 awards and net obligated value of -$4.56 million, indicating a negative funding balance over the period. This pattern suggests the award’s obligated activity is narrowly distributed and dominated by a single vendor relationship.

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 = 'N0001915C0004'
    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
336412	AIRCRAFT ENGINE AND ENGINE PARTS MANUFACTURING	-4,564,159.25	-4.56 million	13

Insight

The award’s obligational activity is concentrated entirely in NAICS 336412, Aircraft Engine and Engine Parts Manufacturing, with 13 actions totaling -$4.56 million over the 5-year window. This indicates a highly focused procurement profile in aircraft engine-related work rather than a diversified NAICS mix. The negative obligated amount suggests net deobligations or downward funding adjustments within this category.

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 = 'N0001915C0004'
    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
2840	GAS TURBINES AND JET ENGINES, AIRCRAFT, PRIME MOVING; AND COMPONENTS	-4,564,159.25	-4.56 million	13

Insight

Obligations under PIID N0001915C0004 over the 5-year window are concentrated entirely in PSC 2840, with 13 awards totaling -$4.56 million. This indicates a single-category spend profile focused on aircraft gas turbine and jet engine components, with no evidence of PSC diversification in the provided data. The negative obligated total should be interpreted as deobligation or net downward adjustment activity within this PSC.

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 = 'N0001915C0004'
    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	-9,178,720.97	-9.18 million	3
2022	4,614,561.72	4.61 million	2
2023	0.00	0.00	2
2024	0.00	0.00	6

Insight

Obligations under PIID N0001915C0004 are concentrated in 2021 and 2022, with a net negative obligation of -$9.18 million in 2021 across 3 awards followed by $4.61 million in 2022 across 2 awards. Activity continues in 2023 and 2024 with 2 and 6 awards respectively, but reported obligated amounts are $0.00 in both years, indicating award activity without associated obligations in the provided data. Overall, the 5-year window reflects a shift from obligated funding to award action without recorded obligation value in the most recent 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.

Start 7-Day Trial Learn More