This FPDS query page summarizes award number 0014 for agency ID 9700 over the last 5 years. The award totals $40,611,665.88 in obligations across 669 actions, with an average action value of $60,705.03.
Award Number
Award Number 9700 / 0014 Federal Contract Action Summary (Last 5 Years)
Award number 0014 for agency 9700 shows 669 actions over the last 5 years with $40.61 million obligated.
Totals reflect the stated analysis window and include the exact obligated amount of $40,611,665.88.
Agency ID
9700
PIID
0014
Type
Award
Total Obligated
40.61 million
40,611,665.88
Actions
669
Average Action Value
60,705.03
Overview
Award number 0014 for agency ID 9700 records 669 award actions in the last 5 years. The total obligated amount is $40,611,665.88, which averages $60,705.03 per action. This page is intended to support basic award-level review in FPDS queries.
How to use this page
Use this page to review obligation totals, action volume, and average action value for award number 0014. The figures are useful for comparing activity within the same analysis window or for checking award-level procurement history tied to 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 = '0014'
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 |
|---|---|---|---|---|
| 2100 | DEPT OF THE ARMY | 64,237,845.92 | 64.24 million | 302 |
| 5700 | DEPT OF THE AIR FORCE | 3,018,770.66 | 3.02 million | 66 |
| 97ZS | U.S. SPECIAL OPERATIONS COMMAND (USSOCOM) | 657,279.53 | 657.28 thousand | 9 |
| 97F5 | WASHINGTON HEADQUARTERS SERVICES (WHS) | 54,769.96 | 54.77 thousand | 8 |
| 97F2 | DEPT OF DEFENSE EDUCATION ACTIVITY (DODEA) | -3,337.04 | -3.34 thousand | 1 |
| 97DH | DEFENSE HEALTH AGENCY (DHA) | -21,667.80 | -21.67 thousand | 5 |
| 9761 | DEFENSE THREAT REDUCTION AGENCY (DTRA) | -61,908.67 | -61.91 thousand | 2 |
| 97AS | DEFENSE LOGISTICS AGENCY | -139,499.43 | -139.50 thousand | 35 |
| 97AK | DEFENSE INFORMATION SYSTEMS AGENCY (DISA) | -1,103,656.89 | -1.10 million | 22 |
| 97JC | MISSILE DEFENSE AGENCY (MDA) | -1,399,420.93 | -1.40 million | 9 |
Insight
Over the last 5 years, obligations under PIID 0014 are heavily concentrated in the DEPT OF THE ARMY, which accounts for $64.24 million across 302 awards and far exceeds all other agencies listed. DEPT OF THE AIR FORCE is a distant second at $3.02 million across 66 awards, while USSOCOM and WHS contribute comparatively small positive obligations. Several agencies show net negative obligated amounts, most notably MDA (-$1.40 million), DISA (-$1.10 million), and DLA (-$139.50 thousand), indicating downward adjustments or deobligations within the award record.
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 = '0014'
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 |
|---|---|---|---|---|
| INTUITIVE RESEARCH AND TECHNOLOGY CORPORATION | 1MQC1 | 49,992,886.41 | 49.99 million | 116 |
| JOHNSON CONTROLS GOVERNMENT SYSTEMS LLC | 1MN13 | 27,606,603.63 | 27.61 million | 26 |
| LOCKHEED MARTIN CORPORATION | 04939 | 3,337,953.00 | 3.34 million | 9 |
| NORTHROP GRUMMAN SYSTEMS CORPORATION | 5FVX5 | 1,174,620.78 | 1.17 million | 10 |
| SES GOVERNMENT SOLUTIONS, INC. | 1VKQ6 | 798,888.75 | 798.89 thousand | 5 |
| SOLUTIONS DEVELOPMENT CORPORAT | 1GGR6 | 643,395.48 | 643.40 thousand | 11 |
| THE BOEING COMPANY | 77272 | 616,867.47 | 616.87 thousand | 11 |
| TETRA TECH EC, INC. | 3EG29 | 558,829.91 | 558.83 thousand | 13 |
| PIKA-ARCADIS JV | 6GRJ2 | 459,898.00 | 459.90 thousand | 1 |
| RLF AND TRANSYSTEMS | 60DT1 | 251,512.52 | 251.51 thousand | 5 |
Insight
Over the past 5 years, obligations under PIID 0014 are concentrated primarily among two vendors: Intuitive Research and Technology Corporation ($49.99 million across 116 awards) and Johnson Controls Government Systems LLC ($27.61 million across 26 awards). These two vendors account for the clear majority of the listed obligations, while the remaining vendors each received materially smaller amounts, generally below $3.4 million. Award activity is more distributed among the smaller vendors, with several firms receiving 9 to 13 awards but relatively low obligated values, indicating a mix of higher-volume, lower-dollar awards outside the top two vendors.
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 = '0014'
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 |
|---|---|---|---|---|
| 541712 | RESEARCH AND DEVELOPMENT IN THE PHYSICAL, ENGINEERING, AND LIFE SCIENCES (EXCEPT BIOTECHNOLOGY) | 45,712,805.58 | 45.71 million | 173 |
| 541330 | ENGINEERING SERVICES | 23,474,132.37 | 23.47 million | 151 |
| 336414 | GUIDED MISSILE AND SPACE VEHICLE MANUFACTURING | 2,892,869.96 | 2.89 million | 14 |
| 562910 | REMEDIATION SERVICES | 1,148,416.64 | 1.15 million | 26 |
| 517410 | SATELLITE TELECOMMUNICATIONS | 798,888.75 | 798.89 thousand | 5 |
| 541310 | ARCHITECTURAL SERVICES | 244,988.78 | 244.99 thousand | 16 |
| 236220 | COMMERCIAL AND INSTITUTIONAL BUILDING CONSTRUCTION | 193,677.24 | 193.68 thousand | 7 |
| 532420 | OFFICE MACHINERY AND EQUIPMENT RENTAL AND LEASING | 89,139.08 | 89.14 thousand | 12 |
| 517919 | ALL OTHER TELECOMMUNICATIONS | 45,404.67 | 45.40 thousand | 10 |
| 213112 | SUPPORT ACTIVITIES FOR OIL AND GAS OPERATIONS | 22,015.45 | 22.02 thousand | 5 |
Insight
Obligations under PIID 0014 are highly concentrated in R&D and engineering activity: NAICS 541712 accounts for $45.71 million across 173 awards and NAICS 541330 for $23.47 million across 151 awards, together representing the clear majority of reported obligated dollars over the 5-year window. A much smaller second tier includes guided missile and space vehicle manufacturing ($2.89 million, 14 awards) and remediation services ($1.15 million, 26 awards), while all remaining NAICS codes each account for less than $1 million. Overall, the distribution indicates a strong emphasis on technical and scientific services, with limited spending dispersed across several lower-dollar support categories.
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 = '0014'
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 |
|---|---|---|---|---|
| R425 | SUPPORT- PROFESSIONAL: ENGINEERING/TECHNICAL | 45,995,879.69 | 46.00 million | 184 |
| H935 | OTHER QC/TEST/INSPECT- SERVICE AND TRADE EQUIPMENT | 27,606,603.63 | 27.61 million | 26 |
| 1425 | GUIDED MISSILE SYSTEMS, COMPLETE | 3,337,953.00 | 3.34 million | 9 |
| L014 | TECHNICAL REPRESENTATIVE- GUIDED MISSILES | 1,174,620.78 | 1.17 million | 10 |
| D304 | IT AND TELECOM- TELECOMMUNICATIONS AND TRANSMISSION | 798,618.15 | 798.62 thousand | 6 |
| R498 | SUPPORT- PROFESSIONAL: PATENT AND TRADEMARK | 658,213.97 | 658.21 thousand | 8 |
| L069 | TECHNICAL REPRESENTATIVE- TRAINING AIDS AND DEVICES | 643,395.48 | 643.40 thousand | 11 |
| F108 | ENVIRONMENTAL SYSTEMS PROTECTION- ENVIRONMENTAL REMEDIATION | 515,899.00 | 515.90 thousand | 17 |
| F999 | OTHER ENVIRONMENTAL SERVICES | 447,632.94 | 447.63 thousand | 6 |
| 5820 | RADIO AND TELEVISION COMMUNICATION EQUIPMENT, EXCEPT AIRBORNE | 234,565.77 | 234.57 thousand | 1 |
Insight
Obligations under PIID 0014 in the 5-year window are concentrated in PSC R425, which accounts for $46.00 million across 184 awards, followed by H935 at $27.61 million across 26 awards. These two PSCs together dominate the profile, indicating sustained spending on engineering/technical support and QC/test/inspection services. The remaining PSCs are comparatively small and fragmented, with no other code exceeding $3.34 million and most falling below $1 million, suggesting a long tail of specialized, lower-dollar activity.
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 = '0014'
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 | 62,148,373.63 | 62.15 million | 286 |
| 2022 | -10,703,698.60 | -10.70 million | 145 |
| 2023 | -10,082,947.17 | -10.08 million | 98 |
| 2024 | 803,288.40 | 803.29 thousand | 82 |
| 2025 | -1,553,350.38 | -1.55 million | 58 |
Insight
Obligations for PIID 0014 were heavily concentrated in 2021, when awards totaled $62.15 million across 286 awards. Activity then shifted to net deobligations in 2022 and 2023, followed by only marginal positive obligations in 2024 and a return to net deobligations in 2025. Award volume also declined steadily over the period, from 286 in 2021 to 58 in 2025, indicating a pronounced contraction in both funding and transaction frequency.
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.