This page summarizes the award record for PIID 0018 within agency ID 9700. It reflects 8,184 recorded actions and 1.99 billion in total obligated value across the analysis window.
Award Number
Award Number 9700 / 0018 Federal Contract Action Summary (Last 10 Years)
Federal procurement summary for award number 0018 under agency ID 9700, showing activity over the last 10 years.
Amounts shown are based on the provided readable total obligated value of 1,994,989,180.28 and the reported average action value of 243,767.01.
Agency ID
9700
PIID
0018
Type
Award
Total Obligated
1.99 billion
1,994,989,180.28
Actions
8,184
Average Action Value
243,767.01
Overview
The award record for PIID 0018 shows sustained procurement activity across the last 10 years. Its total obligated value is 1,994,989,180.28, with 8,184 award actions recorded and an average action value of 243,767.01. This provides a compact view of the award's scale and transaction frequency within agency ID 9700.
How to use this page
Use this page to review the award at a high level before examining the underlying action history. The totals support basic reporting, trend comparison, and validation against other award-level records. The page is limited to the supplied summary figures and does not infer contract scope or performance details.
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 = '0018'
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 | 576,300,015.00 | 576.30 million | 2,550 |
| 97AS | DEFENSE LOGISTICS AGENCY | 574,220,827.84 | 574.22 million | 2,043 |
| 5700 | DEPT OF THE AIR FORCE | 407,782,761.82 | 407.78 million | 874 |
| 1700 | DEPT OF THE NAVY | 332,449,430.34 | 332.45 million | 1,811 |
| 97AK | DEFENSE INFORMATION SYSTEMS AGENCY (DISA) | 62,388,526.32 | 62.39 million | 188 |
| 97JC | MISSILE DEFENSE AGENCY (MDA) | 39,856,003.57 | 39.86 million | 64 |
| 97ZS | U.S. SPECIAL OPERATIONS COMMAND (USSOCOM) | 38,331,651.38 | 38.33 million | 179 |
| 9761 | DEFENSE THREAT REDUCTION AGENCY (DTRA) | 14,147,635.91 | 14.15 million | 42 |
| 97AZ | DEFENSE COMMISSARY AGENCY (DECA) | 9,100,757.61 | 9.10 million | 47 |
| 9776 | USTRANSCOM | 4,525,432.65 | 4.53 million | 14 |
Insight
Obligations for PIID 0018 over the 10-year window are concentrated among four agencies: the Department of the Army ($576.30M, 2,550 awards), Defense Logistics Agency ($574.22M, 2,043), Department of the Air Force ($407.78M, 874), and Department of the Navy ($332.45M, 1,811). These four account for the vast majority of total obligated value, indicating a strongly defense-oriented award pattern with substantial interagency volume. Remaining obligations are materially smaller and distributed across DISA, MDA, USSOCOM, DTRA, DECA, and USTRANSCOM, each below $63 million.
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 = '0018'
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 |
|---|---|---|---|---|
| OSHKOSH DEFENSE, LLC | 75Q65 | 109,330,582.85 | 109.33 million | 19 |
| GENERAL ELECTRIC COMPANY | 07482 | 106,659,652.42 | 106.66 million | 2 |
| BAE SYSTEMS TECHNOLOGY SOLUTIONS & SERVICES INC. | 99789 | 98,323,449.68 | 98.32 million | 175 |
| RAYTHEON COMPANY | 92,289,711.94 | 92.29 million | 35 | |
| BOEING COMPANY, THE | 0PXV4 | 82,702,996.39 | 82.70 million | 5 |
| GENERAL ELECTRIC COMPANY | 54,861,357.65 | 54.86 million | 6 | |
| ASSURED INFORMATION SECURITY, INC. | 47,929,610.00 | 47.93 million | 3 | |
| ALION SCIENCE AND TECHNOLOGY CORPORATION | 3BM47 | 43,105,901.23 | 43.11 million | 53 |
| ROLLS-ROYCE CORPORATION | 41,627,638.00 | 41.63 million | 4 | |
| CSRA LLC | 52939 | 41,527,051.38 | 41.53 million | 71 |
Insight
Over the 10-year window for award PIID 0018 under agency 9700, obligations are concentrated among a small set of vendors at similar dollar levels, led by OSHKOSH DEFENSE, LLC ($109.33 million) and GENERAL ELECTRIC COMPANY ($106.66 million). Delivery is uneven across the top vendors: BAE SYSTEMS TECHNOLOGY SOLUTIONS & SERVICES INC. and CSRA LLC each received many awards (175 and 71, respectively), while several other vendors reached comparable obligation totals with relatively few awards, including GENERAL ELECTRIC COMPANY (2 and 6 awards across two entries) and BOEING COMPANY, THE (5 awards). The presence of duplicate vendor names with separate entries, such as GENERAL ELECTRIC COMPANY and RAYTHEON COMPANY, suggests obligations are spread across multiple records rather than a single dominant award line.
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 = '0018'
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 |
|---|---|---|---|---|
| 541712 | RESEARCH AND DEVELOPMENT IN THE PHYSICAL, ENGINEERING, AND LIFE SCIENCES (EXCEPT BIOTECHNOLOGY) | 325,140,206.55 | 325.14 million | 555 |
| 541330 | ENGINEERING SERVICES | 279,028,823.64 | 279.03 million | 1,304 |
| 324110 | PETROLEUM REFINERIES | 235,431,249.03 | 235.43 million | 383 |
| 336413 | OTHER AIRCRAFT PARTS AND AUXILIARY EQUIPMENT MANUFACTURING | 213,071,604.36 | 213.07 million | 187 |
| 336411 | AIRCRAFT MANUFACTURING | 112,428,684.99 | 112.43 million | 146 |
| 336212 | TRUCK TRAILER MANUFACTURING | 110,685,407.40 | 110.69 million | 19 |
| 336412 | AIRCRAFT ENGINE AND ENGINE PARTS MANUFACTURING | 110,319,222.55 | 110.32 million | 52 |
| 236220 | COMMERCIAL AND INSTITUTIONAL BUILDING CONSTRUCTION | 74,490,776.21 | 74.49 million | 464 |
| 517110 | WIRED TELECOMMUNICATIONS CARRIERS | 41,595,942.77 | 41.60 million | 41 |
| 315990 | APPAREL ACCESSORIES AND OTHER APPAREL MANUFACTURING | 40,970,452.02 | 40.97 million | 41 |
Insight
Obligations for PIID 0018 under agency 9700 are concentrated in a small set of NAICS codes, led by R&D in physical, engineering, and life sciences ($325.14 million across 555 awards) and engineering services ($279.03 million across 1,304 awards). Manufacturing-related codes also account for substantial funding, including petroleum refineries, aircraft parts, aircraft manufacturing, truck trailer manufacturing, and aircraft engine/parts manufacturing, indicating a strong industrial and technical procurement mix. Award counts are more dispersed than dollars, with engineering services and commercial/institutional building construction carrying high transaction volume but lower average obligations than the largest-dollar NAICS 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 = '0018'
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 |
|---|---|---|---|---|
| 1560 | AIRFRAME STRUCTURAL COMPONENTS | 190,725,999.85 | 190.73 million | 45 |
| 9130 | LIQUID PROPELLANTS AND FUELS, PETROLEUM BASE | 184,360,698.09 | 184.36 million | 247 |
| AZ12 | R&D- OTHER RESEARCH AND DEVELOPMENT (APPLIED RESEARCH/EXPLORATORY DEVELOPMENT) | 174,934,770.50 | 174.93 million | 226 |
| B541 | SPECIAL STUDIES/ANALYSIS- DEFENSE | 113,723,719.84 | 113.72 million | 165 |
| 2320 | TRUCKS AND TRUCK TRACTORS, WHEELED | 109,617,763.15 | 109.62 million | 22 |
| 2840 | GAS TURBINES AND JET ENGINES, AIRCRAFT, PRIME MOVING; AND COMPONENTS | 105,457,661.18 | 105.46 million | 31 |
| 1550 | UNMANNED AIRCRAFT | 96,163,834.96 | 96.16 million | 29 |
| R425 | SUPPORT- PROFESSIONAL: ENGINEERING/TECHNICAL | 93,728,677.45 | 93.73 million | 470 |
| AD93 | R&D- DEFENSE OTHER: OTHER (ADVANCED DEVELOPMENT) | 72,115,014.79 | 72.12 million | 42 |
| 8415 | CLOTHING, SPECIAL PURPOSE | 61,840,029.56 | 61.84 million | 64 |
Insight
Obligations under PIID 0018 over the 10-year window are concentrated in a small set of PSCs tied to aircraft systems, fuels, and research/services. Airframe structural components (1560) is the largest line at $190.73 million across 45 awards, followed closely by liquid propellants and fuels (9130) at $184.36 million across 247 awards and applied R&D (AZ12) at $174.93 million across 226 awards. The distribution also shows a high-volume services component, with engineering/technical support (R425) accounting for 470 awards but only $93.73 million, indicating many smaller obligations relative to the larger hardware and R&D categories.
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 = '0018'
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 | 1,017,439,004.66 | 1.02 billion | 3,562 |
| 2017 | 723,558,873.13 | 723.56 million | 2,696 |
| 2018 | 162,351,405.33 | 162.35 million | 837 |
| 2019 | 53,087,511.59 | 53.09 million | 433 |
| 2020 | 25,448,564.72 | 25.45 million | 235 |
| 2021 | 15,741,117.06 | 15.74 million | 177 |
| 2022 | 7,214,741.69 | 7.21 million | 101 |
| 2023 | -3,012,474.19 | -3.01 million | 60 |
| 2024 | -3,372,042.18 | -3.37 million | 58 |
| 2025 | -3,467,521.53 | -3.47 million | 25 |
Insight
Award activity for PIID 0018 is heavily concentrated in the earlier part of the 10-year window, with obligations declining sharply from $1.02 billion across 3,562 awards in 2016 to $723.56 million in 2017, then to $162.35 million in 2018. After 2018, both obligated dollars and award counts fell to much lower levels, dropping below $10 million by 2022 and below zero in 2023–2025. The negative obligations in the most recent years indicate net deobligations, alongside a further reduction in award volume from 101 awards in 2022 to 25 in 2025.
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.