This page summarizes federal award activity for vehicle number tied to PIID DTFAWA17D00034 within Agency ID 6920. The record shows 18 award actions and total obligated dollars of 21.12 million across the analysis window.
Vehicle Number
Vehicle Number 6920 / DTFAWA17D00034 Federal Contract Action Summary (Last 5 Years)
Procurement analysis for vehicle number associated with PIID DTFAWA17D00034 at Agency ID 6920 over the last 5 years.
Amounts are based on the provided exact total obligated value of 21,116,258.24 and an average action value of 1,173,125.46.
Overview
Over the last 5 years, this vehicle number record for PIID DTFAWA17D00034 shows 18 award actions and total obligations of 21,116,258.24. The average action value is 1,173,125.46, indicating repeated use of the vehicle within the same reporting period. This page is limited to the provided award totals and action counts.
How to use this page
Use this page to review the scale and cadence of obligated activity tied to vehicle number under Agency ID 6920. The figures support quick comparison against other PIIDs, especially when evaluating total obligation, action count, and average action value over the same 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 = 'DTFAWA17D00034'
AND content__IDV__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__IDV__purchaserInformation__contractingOfficeAgencyID != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 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 | 21,116,258.24 | 21.12 million | 18 |
Insight
Over the 5-year window, obligations for vehicle PIID DTFAWA17D00034 are fully concentrated in the Federal Aviation Administration (agency ID 6920). The FAA accounts for $21.12 million across 18 awards, indicating a single-agency funding pattern with repeated obligation activity under this vehicle. No other agencies are present in the provided rows, so there is no evidence of broader interagency distribution in this dataset.
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 5 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 5 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 | 21,116,258.24 | 21.12 million | 18 |
Insight
Over the 5-year window for vehicle PIID DTFAWA17D00034 under agency 6920, obligations are fully concentrated in NAICS 561612, Security Guards and Patrol Services. This category accounts for $21.12 million across 18 awards, indicating repeated procurement activity in a single labor/service classification. No other NAICS codes are provided, so diversification across NAICS cannot be assessed from 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 = 'DTFAWA17D00034'
AND content__IDV__productOrServiceInformation__productOrServiceCode IS NOT NULL
AND content__IDV__productOrServiceInformation__productOrServiceCode != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 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 | 21,116,258.24 | 21.12 million | 18 |
Insight
Obligations in the 5-year window are concentrated entirely in PSC S206, HOUSEKEEPING- GUARD, with $21.12 million obligated across 18 awards under PIID DTFAWA17D00034. This indicates a narrow service mix and a clear reliance on a single PSC for this vehicle. The award count suggests recurring procurement activity rather than a one-time obligation.
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 5 YEAR
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC
| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 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 DTFAWA17D00034 were concentrated in 2021 and 2022, with 10 awards totaling $13.64 million in 2021 and 7 awards totaling $7.47 million in 2022. Activity declined sharply in 2023 to a single action with a net obligation of -$6, indicating effectively no positive funding in that year. Over the 5-year window, the vehicle shows a clear downward trend in both award count and obligated dollars after the 2021 peak.
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 5 years view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.