This page summarizes award-level procurement activity for FA861120F1010 over the last 5 years. The record shows 96 award actions and total obligated funding of $1.00 billion.
Award Number
Award Number 9700 / FA861120F1010 Federal Contract Action Summary (Last 5 Years)
Federal procurement summary for award number FA861120F1010 under Agency ID 9700, covering obligations and actions in the last 5 years.
Total obligated amount is reported as $1,000,831,590.48, with an average action value of $10,425,329.07.
Agency ID
9700
PIID
FA861120F1010
Type
Award
Total Obligated
1.00 billion
1,000,831,590.48
Actions
96
Average Action Value
10,425,329.07
Overview
This award page aggregates procurement activity for PIID FA861120F1010 within Agency ID 9700 across the last 5 years. The dataset includes 96 actions and total obligations of $1,000,831,590.48, which rounds to $1.00 billion.
How to use this page
Use this page to review the scale and cadence of funding tied to this award number. The average action value of $10,425,329.07 provides a simple benchmark for comparing individual actions within the record.
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 = 'FA861120F1010'
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 | 1,000,831,590.48 | 1.00 billion | 96 |
Insight
For PIID FA861120F1010 over the 5-year window, obligations are entirely concentrated in DEPT OF THE AIR FORCE (agency ID 5700), which accounts for $1.00 billion across 96 awards. This indicates a single-agency award pattern with no other agencies represented in the provided data. The distribution suggests the award relationship is highly concentrated within the Air Force rather than spread 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 = 'FA861120F1010'
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 | 1,000,831,590.48 | 1.00 billion | 96 |
Insight
Within the 5-year window for PIID FA861120F1010 under agency 9700, obligations are fully concentrated with a single vendor, UNITED TECHNOLOGIES CORPORATION (CAGE 52661). This vendor received 96 awards totaling $1.00 billion in obligated value, indicating a highly concentrated award distribution with no diversification across vendors in the provided data. The pattern suggests sustained reliance on one contractor for this award record.
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 = 'FA861120F1010'
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,000,831,590.48 | 1.00 billion | 96 |
Insight
Over the 5-year window, obligations for PIID FA861120F1010 are fully concentrated in NAICS 488190, Other Support Activities for Air Transportation, with 1.00 billion obligated across 96 awards. This indicates a highly focused procurement profile with no observed NAICS diversification in the provided data. The award pattern suggests sustained activity within a single aviation support category rather than a broad distribution across industries.
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 = 'FA861120F1010'
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 |
|---|---|---|---|---|
| J028 | MAINT/REPAIR/REBUILD OF EQUIPMENT- ENGINES, TURBINES, AND COMPONENTS | 1,000,831,590.48 | 1.00 billion | 96 |
Insight
Over the 5-year window, obligations for award FA861120F1010 are fully concentrated in PSC J028, MAINT/REPAIR/REBUILD OF EQUIPMENT- ENGINES, TURBINES, AND COMPONENTS. This PSC accounts for $1.00 billion across 96 awards, indicating a highly focused spend profile with repeated obligating action under a single product service code. The distribution suggests this award is dominated by engine and turbine maintenance/repair activity rather than a diversified mix of PSCs.
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 = 'FA861120F1010'
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 | 587,095,898.98 | 587.10 million | 27 |
| 2022 | 397,065,317.63 | 397.07 million | 46 |
| 2023 | 10,625,929.34 | 10.63 million | 11 |
| 2024 | 4,445,624.00 | 4.45 million | 5 |
| 2025 | 1,598,820.53 | 1.60 million | 7 |
Insight
Obligations for PIID FA861120F1010 under Agency ID 9700 were heavily concentrated in 2021 and 2022, totaling $587.10 million and $397.07 million, respectively. After 2022, obligated dollars declined sharply to $10.63 million in 2023, $4.45 million in 2024, and $1.60 million in 2025, indicating a pronounced tapering in funding. Award counts do not follow the same pattern, peaking at 46 in 2022 before falling to 11 in 2023, 5 in 2024, and 7 in 2025, suggesting smaller and less frequent obligation activity in the later 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.