This page summarizes procurement activity for vehicle number DTFAWA17D00034 for agency ID 6920 over the last 10 years. The record shows 71 award actions with total obligations of 71.65 million dollars and an average action value of 1,009,098.88.
Vehicle Number
Vehicle Number 6920 / DTFAWA17D00034 Federal Contract Action Summary (Last 10 Years)
Analyst summary for vehicle number DTFAWA17D00034 under agency ID 6920, covering award activity in the last 10 years.
Obligated amounts are shown as reported, with a readable total of 71.65 million and an exact total of 71,646,020.43.
Overview
Across the last 10 years, vehicle number DTFAWA17D00034 is associated with 71 award actions and $71,646,020.43 in total obligations. The average action value is $1,009,098.88, indicating recurring award activity at a substantial but not uniform value level. This page is intended to support review of obligation totals and action counts tied to agency ID 6920.
How to use this page
Use this page to review the scale and frequency of award activity linked to vehicle number DTFAWA17D00034. The figures support quick comparison across vehicles, periods, or agencies when assessing procurement volume and obligated dollars. It is a summary view only and does not add contract details beyond the provided record.
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 = 'DTFAWA17D00034'
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 | 71,646,020.43 | 71.65 million | 71 |
Insight
Within the 10-year window, obligations for this vehicle are concentrated entirely within the Federal Aviation Administration (agency 6920), which accounts for $71.65 million across 71 awards. This indicates a single-agency funding profile with no visible distribution across other top agencies in the provided rows. The award volume suggests repeated use of the vehicle rather than reliance on a small number of high-dollar actions.
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 = 'DTFAWA17D00034'
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 = 'DTFAWA17D00034'
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 |
|---|---|---|---|---|
| 561612 | SECURITY GUARDS AND PATROL SERVICES | 71,646,020.43 | 71.65 million | 71 |
Insight
Obligations under PIID DTFAWA17D00034 are fully concentrated in NAICS 561612, Security Guards and Patrol Services, with $71.65 million obligated across 71 awards over the 10-year window. This indicates a single-service procurement profile with no diversification across other NAICS codes in the provided data. The award volume suggests repeated use of the vehicle for the same category of service rather than a broad mix of requirements.
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 = 'DTFAWA17D00034'
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 |
|---|---|---|---|---|
| S206 | HOUSEKEEPING- GUARD | 71,646,020.43 | 71.65 million | 71 |
Insight
Obligations for PIID DTFAWA17D00034 are entirely concentrated in PSC S206 (Housekeeping- Guard) over the 10-year window, with $71.65 million obligated across 71 awards. This indicates a high degree of functional specialization in guard services under this vehicle, with no evidence in the provided rows of diversification into other PSC categories. The award count suggests recurring use of the vehicle for the same service type rather than isolated or one-time activity.
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 = 'DTFAWA17D00034'
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 |
|---|---|---|---|
| 2017 | 6,337,068.88 | 6.34 million | 7 |
| 2018 | 14,536,957.40 | 14.54 million | 23 |
| 2019 | 13,584,719.58 | 13.58 million | 11 |
| 2020 | 16,071,016.33 | 16.07 million | 12 |
| 2021 | 13,643,470.17 | 13.64 million | 10 |
| 2022 | 7,472,794.07 | 7.47 million | 7 |
| 2023 | -6.00 | -6.00 | 1 |
Insight
Obligations under PIID DTFAWA17D00034 were concentrated in FY 2018 through FY 2021, when annual funding ranged from $13.58 million to $16.07 million and award counts were highest or near-highest. FY 2017 was lower at $6.34 million, followed by a decline to $7.47 million in FY 2022, indicating reduced activity after the mid-period peak. FY 2023 records a nominal -$6 obligation on one award, which appears to be an adjustment rather than substantive new funding.
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.