This award page summarizes procurement activity for PIID 0017 under agency ID 9700 across the last 5 years. The record reflects 369 actions and a net obligated amount of -501,969.24.
Award Number
Award Number 9700 / 0017 Federal Contract Action Summary (Last 5 Years)
Award number 0017 for agency 9700 shows 369 recorded actions over the last 5 years, with total obligations of -501.97 thousand.
Total obligated values are shown as provided for the analysis window and may appear negative in the source data.
Agency ID
9700
PIID
0017
Type
Award
Total Obligated
-501.97 thousand
-501,969.24
Actions
369
Average Action Value
-1,360.35
Overview
Over the last 5 years, award number 0017 under agency ID 9700 recorded 369 award actions. The total obligated amount is -501,969.24, with an average action value of -1,360.35. These figures describe the activity captured in the provided award record.
How to use this page
Use this page to review the award-level history for PIID 0017 and to compare action volume with obligated dollars. The summary is useful for quick screening, trend review, and cross-checking the reported totals against source records.
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 = '0017'
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 | 4,284,045.76 | 4.28 million | 114 |
| 5700 | DEPT OF THE AIR FORCE | 2,216,144.12 | 2.22 million | 57 |
| 97AS | DEFENSE LOGISTICS AGENCY | 56,075.11 | 56.08 thousand | 17 |
| 97F5 | WASHINGTON HEADQUARTERS SERVICES (WHS) | 30,678.68 | 30.68 thousand | 6 |
| 97ZS | U.S. SPECIAL OPERATIONS COMMAND (USSOCOM) | -2,517.30 | -2.52 thousand | 1 |
| 97DH | DEFENSE HEALTH AGENCY (DHA) | -151,676.87 | -151.68 thousand | 2 |
| 97AK | DEFENSE INFORMATION SYSTEMS AGENCY (DISA) | -599,141.04 | -599.14 thousand | 27 |
| 97JC | MISSILE DEFENSE AGENCY (MDA) | -888,923.04 | -888.92 thousand | 6 |
| 9761 | DEFENSE THREAT REDUCTION AGENCY (DTRA) | -1,309,034.05 | -1.31 million | 4 |
| 1700 | DEPT OF THE NAVY | -1,753,708.85 | -1.75 million | 57 |
Insight
For PIID 0017 over the 5-year window, obligations are concentrated primarily with the DEPT OF THE ARMY, which accounts for $4.28 million across 114 awards, followed by the DEPT OF THE AIR FORCE at $2.22 million across 57 awards. Smaller positive obligations are spread across DLA and WHS, while several agencies show negative obligated amounts, led by DTRA (-$1.31 million), the DEPT OF THE NAVY (-$1.75 million), and MDA (-$888.92 thousand). The mix of sizable positive and negative amounts indicates substantial post-award adjustments or deobligations across multiple defense agencies rather than a single-agency concentration.
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 = '0017'
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 |
|---|---|---|---|---|
| JOHNSON CONTROLS GOVERNMENT SYSTEMS LLC | 1MN13 | 7,567,519.05 | 7.57 million | 8 |
| ROCKWELL COLLINS, INC. | 84T51 | 2,400,726.00 | 2.40 million | 14 |
| ALION SCIENCE AND TECHNOLOGY CORPORATION | 3BM51 | 1,781,297.00 | 1.78 million | 4 |
| ROCKFORD CORPORATION | 0HW55 | 395,213.00 | 395.21 thousand | 1 |
| XATOR CORPORATION | 393S5 | 351,909.27 | 351.91 thousand | 7 |
| COPPERTOP LEDCOR JV | 5GZP2 | 344,943.99 | 344.94 thousand | 1 |
| AEROSTAR SES LLC | 6LE02 | 290,444.31 | 290.44 thousand | 2 |
| KOMADA, LLC | 60G11 | 262,908.06 | 262.91 thousand | 4 |
| ADAMS COMMUNICATION & ENGINEERING TECHNOLOGY, INC. | 1UN08 | 200,257.82 | 200.26 thousand | 1 |
| XATOR LLC | 393S5 | 199,749.85 | 199.75 thousand | 1 |
Insight
Over the past 5 years, obligations under PIID 0017 are concentrated among a small number of vendors, with JOHNSON CONTROLS GOVERNMENT SYSTEMS LLC receiving the largest share at $7.57 million across 8 awards. ROCKWELL COLLINS, INC. has the highest award count (14) but a lower obligated total of $2.40 million, indicating more frequent but smaller-value awards. The remaining vendors each account for less than $1.8 million, and several are below $400 thousand, reflecting a long tail of relatively small obligations.
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 = '0017'
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 |
|---|---|---|---|---|
| 541330 | ENGINEERING SERVICES | 5,913,770.99 | 5.91 million | 80 |
| 336411 | AIRCRAFT MANUFACTURING | 710,202.59 | 710.20 thousand | 25 |
| 561621 | SECURITY SYSTEMS SERVICES (EXCEPT LOCKSMITHS) | 551,659.12 | 551.66 thousand | 11 |
| 237120 | OIL AND GAS PIPELINE AND RELATED STRUCTURES CONSTRUCTION | 395,213.00 | 395.21 thousand | 1 |
| 236220 | COMMERCIAL AND INSTITUTIONAL BUILDING CONSTRUCTION | 283,343.99 | 283.34 thousand | 3 |
| 562910 | REMEDIATION SERVICES | 275,394.94 | 275.39 thousand | 6 |
| 236210 | INDUSTRIAL BUILDING CONSTRUCTION | 262,908.06 | 262.91 thousand | 4 |
| 532420 | OFFICE MACHINERY AND EQUIPMENT RENTAL AND LEASING | 86,182.94 | 86.18 thousand | 8 |
| 517919 | ALL OTHER TELECOMMUNICATIONS | 77,383.07 | 77.38 thousand | 10 |
| 517410 | SATELLITE TELECOMMUNICATIONS | 61,004.24 | 61.00 thousand | 5 |
Insight
Over the past 5 years, obligations under PIID 0017 are concentrated in NAICS 541330, Engineering Services, which accounts for $5.91 million across 80 awards and far exceeds all other categories. The next largest NAICS, 336411 Aircraft Manufacturing, is an order of magnitude lower at $710.2 thousand across 25 awards, followed by 561621 Security Systems Services at $551.7 thousand across 11 awards. The remaining NAICS codes each represent less than $400 thousand, indicating a long tail of smaller, more discrete obligations across construction, remediation, leasing, and telecommunications activities.
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 = '0017'
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 |
|---|---|---|---|---|
| H999 | OTHER QC/TEST/INSPECT- MISCELLANEOUS | 7,567,519.05 | 7.57 million | 8 |
| AZ12 | R&D- OTHER RESEARCH AND DEVELOPMENT (APPLIED RESEARCH/EXPLORATORY DEVELOPMENT) | 1,451,343.26 | 1.45 million | 21 |
| 1560 | AIRFRAME STRUCTURAL COMPONENTS | 1,014,491.11 | 1.01 million | 20 |
| S211 | HOUSEKEEPING- SURVEILLANCE | 551,659.12 | 551.66 thousand | 11 |
| Z1NA | MAINTENANCE OF FUEL SUPPLY FACILITIES | 395,213.00 | 395.21 thousand | 1 |
| Z2PZ | REPAIR OR ALTERATION OF OTHER NON-BUILDING FACILITIES | 344,943.99 | 344.94 thousand | 1 |
| F999 | OTHER ENVIRONMENTAL SERVICES | 288,539.02 | 288.54 thousand | 5 |
| Y1EZ | CONSTRUCTION OF OTHER INDUSTRIAL BUILDINGS | 262,908.06 | 262.91 thousand | 4 |
| N059 | INSTALLATION OF EQUIPMENT- ELECTRICAL AND ELECTRONIC EQUIPMENT COMPONENTS | 157,391.67 | 157.39 thousand | 7 |
| R699 | SUPPORT- ADMINISTRATIVE: OTHER | 100,224.00 | 100.22 thousand | 1 |
Insight
Over the past 5 years, obligations under PIID 0017 are concentrated in H999, which accounts for $7.57 million across 8 awards and is the clear dominant PSC. The next largest PSCs are much smaller: AZ12 at $1.45 million across 21 awards and 1560 at $1.01 million across 20 awards, indicating a secondary tier of activity with higher award counts but materially lower obligation levels. The remaining PSCs are individually below $0.60 million each, with several appearing only once, suggesting a long tail of limited, specialized obligations.
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 = '0017'
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 | -714,965.75 | -714.97 thousand | 145 |
| 2022 | -2,028,444.63 | -2.03 million | 87 |
| 2023 | -257,544.35 | -257.54 thousand | 53 |
| 2024 | 652,441.91 | 652.44 thousand | 52 |
| 2025 | 1,846,543.58 | 1.85 million | 32 |
Insight
Over the 5-year window, obligations for PIID 0017 under Agency 9700 were negative in 2021 through 2023, with the largest deobligation in 2022 at -2.03 million across 87 awards. Activity then shifted to positive obligations in 2024 and 2025, rising from 652.44 thousand to 1.85 million while award counts declined from 52 to 32. This indicates a recent concentration of obligation growth in fewer awards after a period of net reductions and higher award volume.
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.