This page summarizes federal procurement activity for award FA861108C2897 within agency ID 9700. Over the last 5 years, the award shows 31 actions and total obligated amounts of -$1.94 million.
Award Number
Award Number 9700 / FA861108C2897 Federal Contract Action Summary (Last 5 Years)
FPDS award page for award number FA861108C2897 under agency ID 9700, summarizing obligations and action activity over the last 5 years.
Total obligated is shown as -1935851.6, with an average action value of -62446.83 across 31 actions.
Agency ID
9700
PIID
FA861108C2897
Type
Award
Total Obligated
-1.94 million
-1,935,851.60
Actions
31
Average Action Value
-62,446.83
Overview
Award FA861108C2897 is associated with agency ID 9700 and shows activity across the last 5 years. The record totals -1935851.6 in obligated value across 31 actions, with an average action value of -62446.83. These figures indicate repeated award action activity during the analysis window.
How to use this page
Use this page to review the award's obligation pattern, action count, and average action value over the last 5 years. The summary supports quick comparison against other FPDS award records tied to agency ID 9700 and the same analysis period.
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 = 'FA861108C2897'
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 |
|---|---|---|---|---|
| 5700 | DEPT OF THE AIR FORCE | 263,470.23 | 263.47 thousand | 17 |
| 9763 | DEFENSE CONTRACT MANAGEMENT AGENCY (DCMA) | -2,199,321.83 | -2.20 million | 14 |
Insight
Obligations on this award are concentrated across two agencies, with the Defense Contract Management Agency accounting for the larger share of activity by dollars at -$2.20 million across 14 awards. The Department of the Air Force shows a smaller positive obligation total of $263.47 thousand across 17 awards, indicating more frequent but much lower-value activity. The opposite signs suggest offsetting adjustments or deobligations within the five-year window, resulting in a net pattern dominated by DCMA.
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 = 'FA861108C2897'
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 | -1,935,851.60 | -1.94 million | 31 |
Insight
Within the 5-year window for award FA861108C2897, obligations are fully concentrated with a single vendor: LOCKHEED MARTIN CORPORATION (CAGE 81755). This vendor accounts for 31 awards and a net total obligated amount of -$1.94 million, indicating the award history is highly concentrated and net deobligations exceed obligations over the period. Because no other vendors appear in the provided rows, there is no evidence of broader vendor distribution in this dataset.
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 = 'FA861108C2897'
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 |
|---|---|---|---|---|
| 488190 | OTHER SUPPORT ACTIVITIES FOR AIR TRANSPORTATION | -1,935,851.60 | -1.94 million | 31 |
Insight
The award is concentrated in a single NAICS code, 488190 (Other Support Activities for Air Transportation), which accounts for all reported obligations in this 5-year window. This category is associated with 31 awards totaling -$1.94 million, indicating a net deobligation position rather than positive obligated value. The distribution is not diversified across NAICS codes in the provided data, so the award’s activity is fully centered in this air transportation support 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 = 'FA861108C2897'
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 |
|---|---|---|---|---|
| J016 | MAINT/REPAIR/REBUILD OF EQUIPMENT- AIRCRAFT COMPONENTS AND ACCESSORIES | -1,935,851.60 | -1.94 million | 31 |
Insight
Obligations for PIID FA861108C2897 are entirely concentrated in PSC J016, covering maintenance, repair, and rebuild of aircraft components and accessories. Over the 5-year window, this PSC accounts for -$1.94 million across 31 award records, indicating repeated activity within a single product/service category. The negative obligated total suggests net downward adjustments or deobligations rather than positive funding growth in this line of effort.
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 = 'FA861108C2897'
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 | -2,027,476.77 | -2.03 million | 10 |
| 2022 | 2,052,541.51 | 2.05 million | 6 |
| 2023 | -293,683.00 | -293.68 thousand | 9 |
| 2024 | 0.00 | 0.00 | 3 |
| 2025 | -1,667,233.34 | -1.67 million | 3 |
Insight
Award FA861108C2897 shows volatile annual obligations over the 5-year window, alternating between positive and negative totals. The largest positive obligation occurred in 2022 at $2.05 million across 6 awards, while the largest negative obligations were in 2021 at -$2.03 million across 10 awards and in 2025 at -$1.67 million across 3 awards. Activity was comparatively muted in 2024, with 3 awards and no net obligation, indicating a brief pause before negative obligations resumed in 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.