This page summarizes award activity for vehicle number tied to PIID DTFAWA09D00062 during the last full year. The record shows 2 award actions with total obligations of -$2.42 million.
Vehicle Number
Vehicle Number 6920 / DTFAWA09D00062 Federal Contract Action Summary (Last Year)
Federal procurement record page for vehicle number under PIID DTFAWA09D00062, showing last full year obligation activity for agency 6920.
Totals are based on the provided exact obligation amount of -2420920.06 and reflect a negative average action value of -1210460.03 across 2 actions.
Overview
For agency 6920, the vehicle number record under PIID DTFAWA09D00062 shows limited activity in the last full year. The total obligated amount was -$2,420,920.06 across 2 award actions, for an average action value of -$1,210,460.03.
How to use this page
Use this page to review the obligation pattern associated with the vehicle number record for the selected period. The figures provide a concise view of action count and funding movement without adding details not present in the source data.
Top Agencies
SELECT
content__IDV__purchaserInformation__contractingOfficeAgencyID AS agency_id,
content__IDV__purchaserInformation__contractingOfficeAgencyID__name AS agency_name,
sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__IDV__contractID__IDVID__agencyID = '6920' AND content__IDV__contractID__IDVID__PIID = 'DTFAWA09D00062'
AND content__IDV__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__IDV__purchaserInformation__contractingOfficeAgencyID != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 YEAR
AND parseDateTimeBestEffortOrNull(content__IDV__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 |
|---|---|---|---|---|
| 6920 | FEDERAL AVIATION ADMINISTRATION | -2,420,920.06 | -2.42 million | 2 |
Insight
Within the 1-year window, obligations under PIID DTFAWA09D00062 are fully concentrated within the Federal Aviation Administration (agency ID 6920). The reported 2 awards account for net obligations of -$2.42 million, indicating a downward adjustment rather than positive funding flow. With no other agencies listed, the activity is entirely single-agency in scope for this vehicle.
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__IDV__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count
FROM fpds.data
WHERE
content__IDV__contractID__IDVID__agencyID = '6920' AND content__IDV__contractID__IDVID__PIID = 'DTFAWA09D00062'
AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
AND content__award__vendor__vendorHeader__vendorName != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 YEAR
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
vendor_name,
cage_code
)
ORDER BY total_obligated DESC
LIMIT 10
| Vendor | CAGE Code | Total Obligated | Readable | Actions |
|---|
Insight
No vendor concentration was available for this analysis window.
Top NAICS
SELECT
content__IDV__productOrServiceInformation__principalNAICSCode AS naics_code,
content__IDV__productOrServiceInformation__principalNAICSCode__description AS naics_name,
sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__IDV__contractID__IDVID__agencyID = '6920' AND content__IDV__contractID__IDVID__PIID = 'DTFAWA09D00062'
AND content__IDV__productOrServiceInformation__principalNAICSCode IS NOT NULL
AND content__IDV__productOrServiceInformation__principalNAICSCode != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 YEAR
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
naics_code,
naics_name
ORDER BY total_obligated DESC
LIMIT 10
| NAICS Code | Description | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| 335921 | FIBER OPTIC CABLE MANUFACTURING | -2,420,920.06 | -2.42 million | 2 |
Insight
Over the 1-year window, obligations for this vehicle are fully concentrated in NAICS 335921, Fiber Optic Cable Manufacturing. The category shows two awards totaling -$2.42 million, indicating all observed activity in this section is tied to a single industry code. This limited distribution suggests no broader NAICS diversification within the available rows.
Top PSC Codes
SELECT
content__IDV__productOrServiceInformation__productOrServiceCode AS psc_code,
content__IDV__productOrServiceInformation__productOrServiceCode__description AS psc_name,
sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__IDV__contractID__IDVID__agencyID = '6920' AND content__IDV__contractID__IDVID__PIID = 'DTFAWA09D00062'
AND content__IDV__productOrServiceInformation__productOrServiceCode IS NOT NULL
AND content__IDV__productOrServiceInformation__productOrServiceCode != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 YEAR
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
psc_code,
psc_name
ORDER BY total_obligated DESC
LIMIT 10
| PSC Code | Description | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| 6150 | MISCELLANEOUS ELECTRIC POWER AND DISTRIBUTION EQUIPMENT | -2,420,920.06 | -2.42 million | 2 |
Insight
Obligations under PIID DTFAWA09D00062 for the 1-year window are fully concentrated in PSC 6150, Miscellaneous Electric Power and Distribution Equipment. This PSC accounts for the entire reported total across 2 awards, with net obligations of -$2.42 million. The negative obligation value indicates a downward adjustment or deobligation activity rather than new funded volume, and there is no visible diversification across other PSCs in the provided data.
Annual Trend
SELECT
toYear(parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate)) AS year,
sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable,
count() AS award_count
FROM fpds.data
WHERE
content__IDV__contractID__IDVID__agencyID = '6920' AND content__IDV__contractID__IDVID__PIID = 'DTFAWA09D00062'
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 YEAR
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC
| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2025 | -2,420,920.06 | -2.42 million | 2 |
Insight
Over the 1-year window, this vehicle shows limited annual activity, with only 2 awards recorded in FY 2025. Obligations are concentrated in a single year and are net negative at -$2.42 million, indicating a downward funding trend for the period. With no additional years in the provided window, there is no evidence of a broader multiyear distribution or sustained obligation pattern.
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.