This award record covers 28 actions under PIID FA820518F0001 during the last 5 years. The total obligated amount is $1,207,482,275.06, with an average action value of $43,124,366.97.
Award Number
Award Number 9700 / FA820518F0001 Federal Contract Action Summary (Last 5 Years)
Award number FA820518F0001 for agency ID 9700 shows $1.21 billion in total obligations across the last 5 years.
Totals reflect the provided analysis window and may not match other reporting periods.
Agency ID
9700
PIID
FA820518F0001
Type
Award
Total Obligated
1.21 billion
1,207,482,275.06
Actions
28
Average Action Value
43,124,366.97
Overview
The award number FA820518F0001 is associated with agency ID 9700 and records 28 actions over the last 5 years. Across that window, total obligated spending is $1,207,482,275.06, which is readable as $1.21 billion. The average action value is $43,124,366.97.
How to use this page
Use this page to review the award-level obligation profile for FA820518F0001 within the stated analysis window. The figures support quick comparison of total obligations, action count, and average action value for this specific award record.
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 = 'FA820518F0001'
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 |
|---|---|---|---|---|
| 5700 | DEPT OF THE AIR FORCE | 1,207,482,275.06 | 1.21 billion | 28 |
Insight
Over the past 5 years, obligations for PIID FA820518F0001 are fully concentrated in one agency: the Department of the Air Force. The award reflects 28 obligations totaling $1.21 billion, indicating a clear single-agency dependency rather than a distributed funding profile. This concentration suggests the award’s funding history is tightly tied to Air Force activity within the observed period.
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 = 'FA820518F0001'
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 |
|---|---|---|---|---|
| LOCKHEED MARTIN CORPORATION | 81755 | 1,207,482,275.06 | 1.21 billion | 28 |
Insight
Over the 5-year window, obligations for PIID FA820518F0001 are fully concentrated with a single vendor, LOCKHEED MARTIN CORPORATION (CAGE 81755). This vendor accounts for $1.21 billion across 28 awards, indicating a highly concentrated award distribution with no other vendors represented in the provided data.
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 = 'FA820518F0001'
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 |
|---|---|---|---|---|
| 336411 | AIRCRAFT MANUFACTURING | 1,207,482,275.06 | 1.21 billion | 28 |
Insight
Obligations for PIID FA820518F0001 are entirely concentrated in NAICS 336411, Aircraft Manufacturing, with $1.21 billion obligated across 28 awards over the 5-year window. This indicates a highly focused procurement profile with no diversification across other NAICS codes in the provided data. The concentration suggests the award activity is aligned to a single industrial base segment rather than a mixed portfolio.
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 = 'FA820518F0001'
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 |
|---|---|---|---|---|
| J016 | MAINT/REPAIR/REBUILD OF EQUIPMENT- AIRCRAFT COMPONENTS AND ACCESSORIES | 1,207,482,275.06 | 1.21 billion | 28 |
Insight
Obligations for this award are fully concentrated in PSC J016, Maintenance/Repair/Rebuild of Equipment—Aircraft Components and Accessories, totaling $1.21 billion across 28 actions over the 5-year window. This indicates a narrow procurement focus on aircraft component sustainment rather than a diversified mix of product or service categories. The award profile reflects repeated funding within a single PSC, suggesting sustained requirement continuity under this contract.
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 = 'FA820518F0001'
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 | 727,073,938.50 | 727.07 million | 10 |
| 2022 | 518,244,467.81 | 518.24 million | 6 |
| 2023 | -24,654,848.48 | -24.65 million | 7 |
| 2024 | -5,646,244.48 | -5.65 million | 1 |
| 2025 | -7,535,038.29 | -7.54 million | 4 |
Insight
Obligations for PIID FA820518F0001 were concentrated in 2021 and 2022, which together account for most of the 5-year total at 727.07 million and 518.24 million, respectively. Activity then turned negative in 2023 through 2025, indicating net deobligations or downward adjustments rather than new positive obligation growth. Award count also declined after 2022, falling from 10 and 6 awards in 2021–2022 to 7, 1, and 4 awards in 2023–2025, suggesting reduced transaction volume alongside the shift in obligated value.
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.