Award Number

Award Number 9700 / FA820518F0001 Federal Contract Action Summary (Last Year)

Award number FA820518F0001 for agency 9700 shows 4 award actions in the last full year with total obligations of -$7.54 million.

This page summarizes federal procurement activity for award number FA820518F0001 during the last full year. The record shows 4 actions and total obligated funds of -$7,535,038.29.

Generated at 03/20/2026

Analysis period: Last full year

Amounts are shown as reported for the selected analysis window and may reflect deobligations or other negative funding adjustments.

Agency ID
9700
PIID
FA820518F0001
Type
Award
Total Obligated
-7.54 million
-7,535,038.29
Actions
4
Average Action Value
-1,883,759.57

Overview

In the last full year, award number FA820518F0001 associated with agency 9700 recorded 4 award actions. The total obligated amount was -$7,535,038.29, with an average action value of -$1,883,759.57. The negative total indicates net reductions in obligated funds over the period.

How to use this page

Use this page to review the award-level funding pattern for FA820518F0001 within the selected window. The action count and average action value help indicate how obligation changes were distributed across the four recorded actions.

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 1 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 -7,535,038.29 -7.54 million 4

Insight

Over the past 1 year, obligations for PIID FA820518F0001 are concentrated entirely with the DEPT OF THE AIR FORCE (agency ID 5700). This agency accounts for 4 awards and a net total obligated amount of -$7.54 million, indicating a downward adjustment or deobligation pattern within the period. The absence of other agencies in the provided rows suggests no cross-agency distribution for this award in the window reviewed.

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 1 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 -7,535,038.29 -7.54 million 4

Insight

Within the 1-year window for award FA820518F0001, all reported obligated dollars in this top-vendor view are concentrated in a single vendor, LOCKHEED MARTIN CORPORATION (CAGE 81755). The vendor is associated with 4 awards and a net total obligated value of -$7.54 million, indicating that obligations were net downward over the period. With no other vendors listed, the distribution is fully concentrated and provides no evidence of a broader vendor mix in this view.

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 1 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 -7,535,038.29 -7.54 million 4

Insight

For FA820518F0001 over the past year, obligations are fully concentrated in NAICS 336411, Aircraft Manufacturing. This category accounts for all reported activity in the section, with 4 awards totaling -$7.54 million in obligated amount. The negative total indicates net deobligations or downward adjustments within this NAICS, rather than net new obligation growth.

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 1 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 -7,535,038.29 -7.54 million 4

Insight

Obligations for this award are fully concentrated in PSC J016, Maintenance/Repair/Rebuild of Equipment – Aircraft Components and Accessories. Over the 1-year window, four actions in this category account for total obligations of -$7.54 million, indicating all recorded spending and adjustments are tied to a single PSC. The negative obligated amount suggests net deobligation or downward adjustment activity rather than net positive funding.

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 1 YEAR
    AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC
Year Total Obligated Readable Actions
2025 -7,535,038.29 -7.54 million 4

Insight

In the 1-year window, this award recorded -$7.54 million in obligated value across 4 awards in FY2025. Obligation activity is concentrated in a single year, with a negative total indicating deobligations or downward adjustments rather than net new funding. The low award count suggests the fiscal-year activity was limited but materially affected overall obligation trends.

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 full year view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.