This award page summarizes procurement activity tied to award number 0007 for agency ID 9700 over the last 10 years. The record includes 22,801 actions and 11.04 billion in total obligated value.
Award Number
Award Number 9700 / 0007 Federal Contract Action Summary (Last 10 Years)
Federal procurement summary for award number PIID 0007 under agency ID 9700, covering the last 10 years of recorded actions and obligations.
Totals are shown as provided, with readable and exact obligated amounts both available for the same analysis window.
Agency ID
9700
PIID
0007
Type
Award
Total Obligated
11.04 billion
11,036,039,411.03
Actions
22,801
Average Action Value
484,015.59
Overview
Across the last 10 years, award number 0007 under agency ID 9700 shows 22,801 recorded actions and total obligated value of 11,036,039,411.03. The average action value is 484,015.59, which provides a simple per-action context for the award’s overall activity.
How to use this page
Use this page to review the award-level procurement footprint for PIID 0007 and compare activity across the analysis window. The action count, obligated totals, and average action value support basic trend review and record-level screening.
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 = '0007'
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 |
|---|---|---|---|---|
| 2100 | DEPT OF THE ARMY | 5,644,623,022.49 | 5.64 billion | 8,336 |
| 5700 | DEPT OF THE AIR FORCE | 2,826,148,960.64 | 2.83 billion | 2,871 |
| 1700 | DEPT OF THE NAVY | 1,378,477,189.29 | 1.38 billion | 4,866 |
| 97AS | DEFENSE LOGISTICS AGENCY | 620,985,372.80 | 620.99 million | 4,586 |
| 97ZS | U.S. SPECIAL OPERATIONS COMMAND (USSOCOM) | 359,890,202.11 | 359.89 million | 407 |
| 97AK | DEFENSE INFORMATION SYSTEMS AGENCY (DISA) | 115,774,013.52 | 115.77 million | 315 |
| 97JC | MISSILE DEFENSE AGENCY (MDA) | 75,354,807.81 | 75.35 million | 259 |
| 9761 | DEFENSE THREAT REDUCTION AGENCY (DTRA) | 38,818,520.36 | 38.82 million | 111 |
| 97DH | DEFENSE HEALTH AGENCY (DHA) | 11,242,203.69 | 11.24 million | 58 |
| 9776 | USTRANSCOM | 10,116,465.74 | 10.12 million | 61 |
Insight
Obligations under PIID 0007 over the 10-year window are highly concentrated in three components: the Department of the Army ($5.64B), Department of the Air Force ($2.83B), and Department of the Navy ($1.38B), which together account for the vast majority of the listed obligations. The Defense Logistics Agency is a distant fourth at $620.99M, followed by USSOCOM at $359.89M; all remaining agencies each obligate less than $120M. Award counts are more dispersed, with the Army, Navy, and DLA each receiving thousands of awards, indicating a broad award base alongside concentrated dollar value.
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 = '0007'
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 |
|---|---|---|---|---|
| KELLOGG BROWN AND ROOT SERVICES INCORPORATED (1250) | 3GJU9 | 1,914,147,160.34 | 1.91 billion | 125 |
| MASSACHUSETTS INSTITUTE OF TECHNOLOGY | 3G050 | 1,472,893,238.59 | 1.47 billion | 208 |
| DYNCORP INTERNATIONAL LIMITED LIABILITY COMPANY (7126) | 1SMB2 | 699,598,343.57 | 699.60 million | 94 |
| GENERAL ATOMICS AERONAUTICAL SYSTEMS, INC. | 371,196,915.76 | 371.20 million | 8 | |
| KELLOGG BROWN AND ROOT SERVICES INCORPORATED (1250) | 252,450,991.28 | 252.45 million | 17 | |
| ALLIANT TECHSYSTEMS OPERATIONS LLC | 1PHL2 | 221,258,370.23 | 221.26 million | 25 |
| MASSACHUSETTS INSTITUTE OF TECHNOLOGY | 121,207,802.10 | 121.21 million | 15 | |
| THE BOEING COMPANY | 77272 | 103,899,122.71 | 103.90 million | 57 |
| TELECOMMUNICATION SYSTEMS, INC. | 0HAL7 | 102,915,752.31 | 102.92 million | 103 |
| BOOZ ALLEN HAMILTON INC. | 17038 | 100,313,569.28 | 100.31 million | 216 |
Insight
Over the 10-year window for agency 9700, obligations are concentrated among a small set of vendors, led by Kellogg Brown and Root Services Incorporated at $1.91 billion across 125 awards and the Massachusetts Institute of Technology at $1.47 billion across 208 awards. The next tier drops materially to DynCorp International at $699.60 million, followed by General Atomics Aeronautical Systems at $371.20 million and Alliant Techsystems Operations at $221.26 million, indicating a steep decline after the top three recipients. Award activity is also dispersed across multiple records for the same vendor name with different CAGE codes or blanks, suggesting the need to review vendor normalization when assessing concentration.
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 = '0007'
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 |
|---|---|---|---|---|
| 561210 | FACILITIES SUPPORT SERVICES | 2,974,995,158.68 | 2.97 billion | 917 |
| 541712 | RESEARCH AND DEVELOPMENT IN THE PHYSICAL, ENGINEERING, AND LIFE SCIENCES (EXCEPT BIOTECHNOLOGY) | 2,516,154,295.32 | 2.52 billion | 2,819 |
| 541330 | ENGINEERING SERVICES | 917,890,382.13 | 917.89 million | 2,822 |
| 336411 | AIRCRAFT MANUFACTURING | 633,221,013.79 | 633.22 million | 505 |
| 236220 | COMMERCIAL AND INSTITUTIONAL BUILDING CONSTRUCTION | 340,814,729.93 | 340.81 million | 1,292 |
| 324110 | PETROLEUM REFINERIES | 311,278,161.25 | 311.28 million | 473 |
| 332992 | SMALL ARMS AMMUNITION MANUFACTURING | 228,280,641.82 | 228.28 million | 33 |
| 334511 | SEARCH, DETECTION, NAVIGATION, GUIDANCE, AERONAUTICAL, AND NAUTICAL SYSTEM AND INSTRUMENT MANUFACTURING | 188,216,885.95 | 188.22 million | 462 |
| 334290 | OTHER COMMUNICATIONS EQUIPMENT MANUFACTURING | 180,438,567.10 | 180.44 million | 207 |
| 332993 | AMMUNITION (EXCEPT SMALL ARMS) MANUFACTURING | 174,547,878.67 | 174.55 million | 94 |
Insight
Over the 10-year period, obligations under PIID 0007 are concentrated in a few NAICS categories, led by Facilities Support Services at $2.97 billion and R&D in the physical, engineering, and life sciences at $2.52 billion. Engineering Services follows at $917.89 million, with the remaining top categories each below $634 million, indicating a steep drop-off after the top two fields. Award counts are also dispersed across high-volume service and technical categories, with Engineering Services (2,822 awards) and R&D (2,819 awards) showing much higher activity counts than the largest-dollar category, Facilities Support Services (917 awards).
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 = '0007'
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 |
|---|---|---|---|---|
| R706 | SUPPORT- MANAGEMENT: LOGISTICS SUPPORT | 2,844,544,446.97 | 2.84 billion | 553 |
| AC61 | R&D- DEFENSE SYSTEM: ELECTRONICS/COMMUNICATION EQUIPMENT (BASIC RESEARCH) | 1,653,608,277.17 | 1.65 billion | 352 |
| R425 | SUPPORT- PROFESSIONAL: ENGINEERING/TECHNICAL | 735,932,171.53 | 735.93 million | 1,939 |
| 1550 | UNMANNED AIRCRAFT | 400,436,150.77 | 400.44 million | 28 |
| 9130 | LIQUID PROPELLANTS AND FUELS, PETROLEUM BASE | 341,732,168.55 | 341.73 million | 341 |
| R499 | SUPPORT- PROFESSIONAL: OTHER | 249,452,109.37 | 249.45 million | 798 |
| AZ12 | R&D- OTHER RESEARCH AND DEVELOPMENT (APPLIED RESEARCH/EXPLORATORY DEVELOPMENT) | 238,869,996.55 | 238.87 million | 461 |
| 1305 | AMMUNITION, THROUGH 30MM | 226,411,036.37 | 226.41 million | 30 |
| 6910 | TRAINING AIDS | 192,701,675.57 | 192.70 million | 172 |
| D307 | IT AND TELECOM- IT STRATEGY AND ARCHITECTURE | 128,649,464.94 | 128.65 million | 123 |
Insight
Obligations under PIID 0007 are concentrated in a few PSCs, led by R706 support-management logistics support at $2.84 billion across 553 awards and AC61 defense electronics/communications R&D at $1.65 billion across 352 awards. The next largest categories are materially smaller: R425 engineering/technical support at $735.93 million, 1550 unmanned aircraft at $400.44 million, and 9130 liquid propellants and fuels at $341.73 million. Activity is also distributed across many awards in support services, with R425 carrying the highest award count in this set (1,939), indicating broad tasking alongside a relatively small number of high-dollar 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 = '0007'
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 |
|---|---|---|---|
| 2016 | 3,583,749,893.18 | 3.58 billion | 9,204 |
| 2017 | 2,553,885,160.57 | 2.55 billion | 6,734 |
| 2018 | 1,904,474,275.43 | 1.90 billion | 2,807 |
| 2019 | 1,267,592,834.88 | 1.27 billion | 1,525 |
| 2020 | 1,133,048,805.00 | 1.13 billion | 1,026 |
| 2021 | 284,064,173.32 | 284.06 million | 636 |
| 2022 | 186,235,768.97 | 186.24 million | 353 |
| 2023 | 167,794,448.58 | 167.79 million | 254 |
| 2024 | -31,122,054.82 | -31.12 million | 169 |
| 2025 | -13,683,894.08 | -13.68 million | 93 |
Insight
Obligations for PIID 0007 under Agency 9700 declined sharply over the 10-year window, falling from $3.58 billion across 9,204 awards in 2016 to $13.68 million net obligated across 93 awards in 2025. The downward trend is sustained, with both obligations and award counts dropping materially after 2017 and remaining under $300 million from 2021 onward. Negative net obligations in 2024 and 2025 indicate deobligations exceeded new obligations in those 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 10 years view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.