This page summarizes procurement activity tied to vehicle number for agency ID 6920 under PIID DTFAWA12D00013 during the last 10 years. The record shows 150 award actions with total obligated value of 140.59 million and an average action value of 937,241.61.
Vehicle Number
Vehicle Number 6920 / DTFAWA12D00013 Federal Contract Action Summary (Last 10 Years)
FPDS analysis page for vehicle number associated with agency ID 6920 and PIID DTFAWA12D00013 over the last 10 years.
Obligated amounts are shown as provided, with a total obligated exact value of 140,586,241.68.
Overview
Across the last 10 years, this vehicle record is linked to 150 award actions and total obligated value of 140,586,241.68. The average action value is 937,241.61, indicating a procurement stream with repeated obligations over time. The page is scoped to agency ID 6920 and PIID DTFAWA12D00013.
How to use this page
Use this page to review the obligation pattern and action count associated with vehicle number for the specified PIID. The figures support basic trend review, comparison with related awards, and identification of the overall scale of activity in the analysis window.
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 = 'DTFAWA12D00013'
AND content__IDV__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__IDV__purchaserInformation__contractingOfficeAgencyID != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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 | 140,586,241.68 | 140.59 million | 150 |
Insight
Over the 10-year window, obligations for PIID DTFAWA12D00013 are fully concentrated with the Federal Aviation Administration (agency ID 6920). The agency accounts for $140.59 million across 150 awards, indicating sustained use of this vehicle within a single agency rather than broad distribution across multiple agencies. This concentration suggests the vehicle has been a primary contracting mechanism for FAA requirements over the period 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__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 = 'DTFAWA12D00013'
AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
AND content__award__vendor__vendorHeader__vendorName != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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 = 'DTFAWA12D00013'
AND content__IDV__productOrServiceInformation__principalNAICSCode IS NOT NULL
AND content__IDV__productOrServiceInformation__principalNAICSCode != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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 |
|---|---|---|---|---|
| 541330 | ENGINEERING SERVICES | 140,586,241.68 | 140.59 million | 150 |
Insight
Obligations for vehicle PIID DTFAWA12D00013 are fully concentrated in NAICS 541330, Engineering Services, over the 10-year window. This NAICS accounts for $140.59 million across 150 awards, indicating a consistently focused procurement profile rather than a diversified mix of industry categories.
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 = 'DTFAWA12D00013'
AND content__IDV__productOrServiceInformation__productOrServiceCode IS NOT NULL
AND content__IDV__productOrServiceInformation__productOrServiceCode != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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 |
|---|---|---|---|---|
| R425 | SUPPORT- PROFESSIONAL: ENGINEERING/TECHNICAL | 140,586,241.68 | 140.59 million | 150 |
Insight
Over the 10-year window, obligations under PIID DTFAWA12D00013 are fully concentrated in PSC R425, Support–Professional: Engineering/Technical, with $140.59 million across 150 awards. This indicates a high degree of PSC concentration and suggests the vehicle has been used primarily for engineering and technical support services. No other PSCs are provided in the query results, so diversification across product/service codes cannot be assessed from this section.
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 = 'DTFAWA12D00013'
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 YEAR
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC
| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2016 | 22,935,589.57 | 22.94 million | 12 |
| 2017 | 25,563,942.53 | 25.56 million | 16 |
| 2018 | 26,842,809.00 | 26.84 million | 14 |
| 2019 | 27,538,548.13 | 27.54 million | 27 |
| 2020 | 36,433,764.05 | 36.43 million | 24 |
| 2021 | 8,119,997.61 | 8.12 million | 26 |
| 2022 | -4,822,594.52 | -4.82 million | 25 |
| 2023 | -124,813.99 | -124.81 thousand | 2 |
| 2024 | -1,731,031.20 | -1.73 million | 3 |
| 2025 | -169,969.50 | -169.97 thousand | 1 |
Insight
Obligations were concentrated in the earlier part of the 10-year window, rising from $22.94 million in 2016 to a peak of $36.43 million in 2020, with award counts ranging from 12 to 27 per year through 2021. Beginning in 2021, obligated amounts declined sharply to $8.12 million and then turned negative in 2022 through 2025, indicating a material reversal in net obligations for the vehicle. Award activity also contracted at the end of the period, falling to 2 awards in 2023, 3 in 2024, and 1 in 2025.
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 10 years view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.