This page summarizes the federal award record for PIID N0001923F0002 under agency ID 9700. In the last full year, the award posted 5 actions totaling $36,118,099.60, with an average action value of $7,223,619.92.
Award Number
Award Number 9700 / N0001923F0002 Federal Contract Action Summary (Last Year)
Analysis of award number N0001923F0002 for agency ID 9700 over the last full year, with 5 actions and $36.12 million obligated.
Amounts are shown as reported and the readable total may differ slightly from the exact obligated amount.
Agency ID
9700
PIID
N0001923F0002
Type
Award
Total Obligated
36.12 million
36,118,099.60
Actions
5
Average Action Value
7,223,619.92
Overview
The award record for PIID N0001923F0002 shows activity across 5 actions during the last full year. Total obligated funding was $36,118,099.60, which is presented on the page as $36.12 million. The average action value was $7,223,619.92.
How to use this page
Use this page to review basic award-level obligation activity for N0001923F0002. The figures support quick comparison of total obligated dollars, action count, and average action value for the selected analysis window.
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 = 'N0001923F0002'
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 |
|---|---|---|---|---|
| 1700 | DEPT OF THE NAVY | 36,118,099.60 | 36.12 million | 5 |
Insight
Obligations under PIID N0001923F0002 in the 1-year window are concentrated entirely with the DEPT OF THE NAVY, which accounts for 36.12 million across 5 awards. This indicates a single-agency distribution with no observed obligation spread to other agencies in the provided data. The concentration suggests the award activity is narrowly focused within one federal customer.
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 = 'N0001923F0002'
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 | 36,118,099.60 | 36.12 million | 5 |
Insight
Obligations for PIID N0001923F0002 in the 1-year window are fully concentrated in a single vendor, LOCKHEED MARTIN CORPORATION (CAGE 81755). The vendor received 5 awards totaling $36.12 million, indicating a highly concentrated award distribution with no other vendors represented in this slice. This pattern suggests the action is narrowly assigned to one contractor rather than distributed across a broader vendor base.
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 = 'N0001923F0002'
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 | 36,118,099.60 | 36.12 million | 5 |
Insight
Obligations for PIID N0001923F0002 are fully concentrated in NAICS 336411, Aircraft Manufacturing, over the 1-year window. This category accounts for $36.12 million across 5 awards, indicating a narrow industrial base and limited NAICS diversification within the award record. The pattern suggests procurement activity tied to a single aircraft manufacturing classification rather than a broad mix of sectors.
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 = 'N0001923F0002'
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 |
|---|---|---|---|---|
| K016 | MODIFICATION OF EQUIPMENT- AIRCRAFT COMPONENTS AND ACCESSORIES | 36,118,099.60 | 36.12 million | 5 |
Insight
Obligations for this award are concentrated in PSC K016, Modification of Equipment - Aircraft Components and Accessories, totaling $36.12 million across 5 actions in the 1-year window. This indicates the award’s activity is narrowly focused on aircraft-related modification work rather than a broad mix of product or service categories. The distribution suggests a clear dependence on a single PSC for the observed period.
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 = 'N0001923F0002'
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 | 36,118,099.60 | 36.12 million | 5 |
Insight
Over the 1-year window, obligations for PIID N0001923F0002 were concentrated entirely in 2025, with $36.12 million obligated across 5 awards. This indicates all observed activity in the period is clustered in a single fiscal year rather than distributed over multiple years. The average obligation per award is roughly $7.2 million, suggesting relatively high-value awards within the observed window.
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.