This award record for PIID 0026 under agency ID 9700 covers the last 5 years of observed activity. The file shows 306 award actions and a total obligated amount of -$43,916,016.18, or about -$43.92 million.
Award Number
Award Number 9700 / 0026 Federal Contract Action Summary (Last 5 Years)
Award number 0026 for agency ID 9700 shows 306 recorded actions over the last 5 years with net obligations of -$43.92 million.
Average action value across the period is -$143,516.39, based on the recorded obligated total and action count.
Agency ID
9700
PIID
0026
Type
Award
Total Obligated
-43.92 million
-43,916,016.18
Actions
306
Average Action Value
-143,516.39
Overview
The award record for PIID 0026 reflects activity across a 5-year analysis window with 306 total actions. Net obligated amount is negative at -$43,916,016.18, indicating a cumulative decrease in obligations over the period. The average obligated value per action is -$143,516.39.
How to use this page
Use this page to review the overall action count and obligation pattern associated with award number 0026. The figures support basic historical analysis of award activity for agency ID 9700 without adding details not present in the source data.
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 = '0026'
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 |
|---|---|---|---|---|
| 97AS | DEFENSE LOGISTICS AGENCY | 253,327.03 | 253.33 thousand | 22 |
| 9761 | DEFENSE THREAT REDUCTION AGENCY (DTRA) | 22.26 | 22.26 | 1 |
| 9776 | USTRANSCOM | -170.40 | -170.40 | 1 |
| 97F5 | WASHINGTON HEADQUARTERS SERVICES (WHS) | -8,414.32 | -8.41 thousand | 1 |
| 97DH | DEFENSE HEALTH AGENCY (DHA) | -292,688.32 | -292.69 thousand | 2 |
| 97JC | MISSILE DEFENSE AGENCY (MDA) | -1,299,049.60 | -1.30 million | 5 |
| 97AK | DEFENSE INFORMATION SYSTEMS AGENCY (DISA) | -1,379,820.50 | -1.38 million | 22 |
| 2100 | DEPT OF THE ARMY | -5,545,190.02 | -5.55 million | 69 |
| 9763 | DEFENSE CONTRACT MANAGEMENT AGENCY (DCMA) | -8,167,830.65 | -8.17 million | 51 |
| 5700 | DEPT OF THE AIR FORCE | -9,519,673.51 | -9.52 million | 87 |
Insight
Over the 5-year window for PIID 0026, obligations are highly concentrated in the Department of the Air Force (-$9.52 million across 87 awards), Defense Contract Management Agency (-$8.17 million across 51 awards), and Department of the Army (-$5.55 million across 69 awards). Smaller positive obligations are centered almost entirely in the Defense Logistics Agency, which accounts for $253.33 thousand across 22 awards, while other agencies contribute only marginal amounts. Several agencies show net negative obligations, including DISA, MDA, and DHA, indicating substantial downward adjustments or deobligations that offset earlier funding activity.
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 = '0026'
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 |
|---|---|---|---|---|
| BOOZ ALLEN HAMILTON INC. | 17038 | 1,919,654.43 | 1.92 million | 10 |
| GENERAL ATOMICS AERONAUTICAL SYSTEMS, INC. | 0YJB5 | 1,069,012.48 | 1.07 million | 4 |
| MCCONNELL GROUP, INC. THE | 1B6E9 | 412,014.56 | 412.01 thousand | 5 |
| ROLLS-ROYCE MILITARY AERO ENGINES LTD | K0378 | 298,150.23 | 298.15 thousand | 4 |
| APTIM FEDERAL SERVICES, LLC | 1YQ36 | 243,962.73 | 243.96 thousand | 6 |
| MULTI-MEDIA ENVIRONMENTAL COMPLIANCE GROUP | 7DAN3 | 88,197.00 | 88.20 thousand | 5 |
| ULTISAT, INC. | 3H9E0 | 70,884.24 | 70.88 thousand | 10 |
| APPLIED RESEARCH ASSOCIATES, INC. | 9R446 | 54,520.00 | 54.52 thousand | 1 |
| UNITED STANDARD INDUSTRIES, INC. | 28210 | 20,888.96 | 20.89 thousand | 1 |
| ALLNATIVE SOLUTIONS CORPORATION | 4CZC0 | 15,596.25 | 15.60 thousand | 6 |
Insight
Over the 5-year window, obligations under PIID 0026 are concentrated among a small set of vendors, with Booz Allen Hamilton Inc. leading at $1.92 million across 10 awards and General Atomics Aeronautical Systems, Inc. next at $1.07 million across 4 awards. The remaining vendors each received materially lower totals, ranging from $412.01 thousand to $15.60 thousand, indicating a steep drop-off after the top two suppliers. Award counts are mixed, with some lower-obligation vendors appearing frequently, suggesting a distributed set of smaller awards rather than a single dominant sole source relationship.
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 = '0026'
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) | 1,986,030.06 | 1.99 million | 44 |
| 332991 | BALL AND ROLLER BEARING MANUFACTURING | 298,150.23 | 298.15 thousand | 8 |
| 517919 | ALL OTHER TELECOMMUNICATIONS | 70,884.24 | 70.88 thousand | 10 |
| 332510 | HARDWARE MANUFACTURING | 20,888.96 | 20.89 thousand | 1 |
| 532420 | OFFICE MACHINERY AND EQUIPMENT RENTAL AND LEASING | 15,596.25 | 15.60 thousand | 6 |
| 541511 | CUSTOM COMPUTER PROGRAMMING SERVICES | 6,059.90 | 6.06 thousand | 3 |
| 611710 | EDUCATIONAL SUPPORT SERVICES | 0.00 | 0.00 | 1 |
| 519190 | ALL OTHER INFORMATION SERVICES | 0.00 | 0.00 | 3 |
| 332999 | ALL OTHER MISCELLANEOUS FABRICATED METAL PRODUCT MANUFACTURING | 0.00 | 0.00 | 1 |
| 541990 | ALL OTHER PROFESSIONAL, SCIENTIFIC, AND TECHNICAL SERVICES | 0.00 | 0.00 | 2 |
Insight
Over the past 5 years, obligations under PIID 0026 are heavily concentrated in NAICS 541712, which accounts for 44 awards and $1.99 million, far exceeding every other industry. The next largest categories—332991 at $298.15 thousand across 8 awards and 517919 at $70.88 thousand across 10 awards—are materially smaller, indicating a steep drop-off after the lead NAICS. Remaining NAICS codes are limited to low-dollar activity, with several at zero obligated value, suggesting a narrow procurement pattern centered on research and development services.
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 = '0026'
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 |
|---|---|---|---|---|
| AZ12 | R&D- OTHER RESEARCH AND DEVELOPMENT (APPLIED RESEARCH/EXPLORATORY DEVELOPMENT) | 1,749,851.02 | 1.75 million | 26 |
| R706 | SUPPORT- MANAGEMENT: LOGISTICS SUPPORT | 1,069,012.48 | 1.07 million | 4 |
| R499 | SUPPORT- PROFESSIONAL: OTHER | 387,462.52 | 387.46 thousand | 7 |
| 3130 | BEARINGS, MOUNTED | 298,150.23 | 298.15 thousand | 8 |
| AC51 | R&D- DEFENSE SYSTEM: WEAPONS (BASIC RESEARCH) | 54,520.00 | 54.52 thousand | 1 |
| 5315 | NAILS, MACHINE KEYS, AND PINS | 20,888.96 | 20.89 thousand | 1 |
| W074 | LEASE OR RENTAL OF EQUIPMENT- OFFICE MACHINES, TEXT PROCESSING SYSTEMS, AND VISIBLE RECORD EQUIPMENT | 7,677.45 | 7.68 thousand | 2 |
| 7025 | INFORMATION TECHNOLOGY INPUT/OUTPUT AND STORAGE DEVICES | 6,660.36 | 6.66 thousand | 2 |
| AC21 | NATIONAL DEFENSE R&D SERVICES; ATOMIC ENERGY DEFENSE ACTIVITIES; BASIC RESEARCH | 5,152.68 | 5.15 thousand | 2 |
| AV93 | R&D- MINING: OTHER MINING ACTIVITIES (ADVANCED DEVELOPMENT) | 4,955.76 | 4.96 thousand | 1 |
Insight
Obligations under PIID 0026 are concentrated in R&D-related PSCs, led by AZ12 at $1.75 million across 26 awards. R706 logistics support is the next largest category at $1.07 million across 4 awards, followed by R499 professional support at $387.46 thousand across 7 awards, indicating a mix of high-volume R&D activity and smaller support obligations. The remaining PSCs are individually minor, with no single non-top-three code approaching $300 thousand.
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 = '0026'
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 | -7,810,488.74 | -7.81 million | 112 |
| 2022 | -6,351,743.53 | -6.35 million | 61 |
| 2023 | -16,350,628.72 | -16.35 million | 58 |
| 2024 | -10,207,508.99 | -10.21 million | 50 |
| 2025 | -3,195,646.20 | -3.20 million | 25 |
Insight
For PIID 0026 under agency 9700, obligated amounts are negative in each year from 2021 through 2025, indicating consistent downward net obligations across the period. Activity is concentrated in 2021–2024, with the largest negative obligation in 2023 at -$16.35 million, while award counts decline from 112 in 2021 to 25 in 2025. The pattern suggests a contraction in both award volume and obligated value, with 2025 representing a materially lower level of activity.
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.