This page summarizes federal award activity for award number N0001916C0048 under agency 9700 during the last full year. The record shows 9 award actions and a total obligated amount of -29,841,195.49.
Award Number
Award Number 9700 / N0001916C0048 Federal Contract Action Summary (Last Year)
Award number N0001916C0048 for agency 9700 shows -29.84 million in obligated value across the last full year.
Values reflect the supplied analysis window and obligated totals for this award record.
Agency ID
9700
PIID
N0001916C0048
Type
Award
Total Obligated
-29.84 million
-29,841,195.49
Actions
9
Average Action Value
-3,315,688.39
Overview
The award record for N0001916C0048 shows a total obligated value of -29,841,195.49 over 9 actions in the last full year. The average action value is -3,315,688.39, indicating that the obligation total is distributed across a small number of actions. This page is limited to the supplied award identifier and summary metrics.
How to use this page
Use this page to review the award-level obligation pattern for N0001916C0048 within the stated analysis window. The figures support quick comparison of action count, total obligated value, and average action size for agency 9700.
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 = 'N0001916C0048'
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 | -29,841,195.49 | -29.84 million | 9 |
Insight
Over the past year, obligations for PIID N0001916C0048 are concentrated entirely within the DEPT OF THE NAVY. The single reported agency accounts for 9 awards and a net obligation of -$29.84 million, indicating a concentrated and net-deobligating funding pattern over the window. No other agencies are represented in the provided data, so there is no evidence of distribution across multiple 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 = 'N0001916C0048'
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 |
|---|---|---|---|---|
| SIKORSKY AIRCRAFT CORPORATION | 78286 | -29,841,195.49 | -29.84 million | 9 |
Insight
Obligations in the past year are fully concentrated with SIKORSKY AIRCRAFT CORPORATION (CAGE 78286), which accounts for all reported activity on this award. The vendor total is negative at $29.84 million across 9 awards, indicating net deobligations or downward contract adjustments over the period. This pattern suggests the award experienced substantial funding reductions rather than positive 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 = 'N0001916C0048'
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 | -29,841,195.49 | -29.84 million | 9 |
Insight
Obligations for PIID N0001916C0048 in the past year are fully concentrated in NAICS 336411, Aircraft Manufacturing. The single reported NAICS accounts for 9 awards and a net total obligated amount of -$29.84 million, indicating all observed activity in this window is tied to this industrial classification. The negative obligation total suggests net deobligations or contract adjustments rather than new funding.
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 = 'N0001916C0048'
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 |
|---|---|---|---|---|
| 1520 | AIRCRAFT, ROTARY WING | -29,841,195.49 | -29.84 million | 9 |
Insight
Obligations in the last 1 year are fully concentrated in PSC 1520, Aircraft, Rotary Wing, with a net total of -$29.84 million across 9 awards. This indicates a single-product-area concentration with negative net funding activity rather than a diversified PSC mix. The repeated award activity suggests multiple modifications or transactions within the same PSC category drove the overall net deobligation.
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 = 'N0001916C0048'
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 | -29,841,195.49 | -29.84 million | 9 |
Insight
For PIID N0001916C0048, the 1-year annual trend shows $29.84 million in net deobligation in FY2025 across 9 awards. The negative obligated total indicates downward funding activity rather than net growth during the period. With all reported activity concentrated in a single year, the observed trend reflects a concentrated adjustment pattern rather than a multi-year distribution.
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.