Award Number

Award Number 9700 / FA862518F7027 Federal Contract Action Summary (Last 5 Years)

Award number FA862518F7027 for agency ID 9700 summarizes procurement activity over the last 5 years.

This award record covers 43 actions in the last 5 years with total obligated funding of 1.86 billion dollars. The average action value is 43,271,790.49.

Last full year Last 5 years Last 10 years

Generated at 03/20/2026

Analysis period: Last 5 years

Totals reflect the analysis window and the provided readable and exact obligated amounts for award number FA862518F7027.

Agency ID

9700

PIID

FA862518F7027

Type

Award

Total Obligated

1.86 billion

1,860,686,991.20

Actions

Average Action Value

43,271,790.49

Overview

The award number FA862518F7027 record is tied to agency ID 9700 and reflects activity within the last 5 years. It shows total obligated funding of 1,860,686,991.2 across 43 award actions, with an average action value of 43,271,790.49.

How to use this page

Use this page to review award-level obligations and action volume for FA862518F7027 within the selected analysis window. The totals support basic procurement review, comparison, and trend screening without adding details beyond the available 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 = 'FA862518F7027'
    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,860,686,991.20	1.86 billion	43

Insight

For PIID FA862518F7027 over the 5-year window, obligations are fully concentrated in a single top agency: DEPT OF THE AIR FORCE. This agency accounts for $1.86 billion across 43 awards, indicating a highly concentrated award distribution with no other agency represented in the provided rows.

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 = 'FA862518F7027'
        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	98897	1,860,686,991.20	1.86 billion	43

Insight

Over the 5-year window, obligations for award FA862518F7027 are fully concentrated with a single vendor, LOCKHEED MARTIN CORPORATION (CAGE 98897). This vendor accounts for $1.86 billion across 43 awards, indicating a highly concentrated award and obligation profile rather than a distributed vendor base. Such concentration suggests the action is managed through a stable prime relationship with repeated award activity.

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 = 'FA862518F7027'
    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,860,686,991.20	1.86 billion	43

Insight

Obligations for PIID FA862518F7027 in the 5-year window are fully concentrated in NAICS 336411, Aircraft Manufacturing. The award reflects 43 actions totaling $1.86 billion, indicating a highly concentrated procurement profile with no diversification across other NAICS codes in the provided data. This concentration suggests the award is directly tied to aircraft manufacturing requirements.

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 = 'FA862518F7027'
    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
1510	AIRCRAFT, FIXED WING	1,860,686,991.20	1.86 billion	43

Insight

Obligations under PIID FA862518F7027 are fully concentrated in PSC 1510, Aircraft, Fixed Wing, with $1.86 billion across 43 awards over the 5-year window. This indicates a highly focused procurement profile with no evidence of PSC diversification in the provided data. The award count suggests repeated obligations within the same product service category rather than a broad mix of acquisition types.

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 = 'FA862518F7027'
    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	1,157,339,296.64	1.16 billion	21
2022	713,631,301.60	713.63 million	9
2023	5,390,000.00	5.39 million	2
2024	1,285,295.04	1.29 million	5
2025	-16,958,902.08	-16.96 million	6

Insight

Obligations for PIID FA862518F7027 are heavily front-loaded in 2021 and 2022, when funding totaled 1.16 billion across 21 awards and 713.63 million across 9 awards, respectively. Activity then dropped sharply in 2023 and 2024 to 5.39 million and 1.29 million, indicating a steep contraction in both obligated dollars and award volume. In 2025, obligations were negative 16.96 million across 6 awards, suggesting deobligations or downward adjustments after the prior years’ decline.

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.

Start 7-Day Trial Learn More