DEFENSE LOGISTICS AGENCY currently leads this ranking. The top 10 account for 23.75% of the value in this result set, indicating a low concentration pattern.
Agencies
Agencies Using IDIQ the Most
Agencies Using IDIQ the Most shows which federal agencies rank highest by Primary Metric in FPDS-based procurement data.
Analysis
DEFENSE LOGISTICS AGENCY currently leads this ranking. The top 10 account for 23.75% of the value in this result set, indicating a low concentration pattern.
Why it matters: Use this page to identify leaders, compare major participants, and understand how activity is distributed across this segment of the federal market.
Methodology: The query groups FPDS records by the ranked entity, calculates the main metric, and orders results from highest to lowest. Supporting columns add context to the leaderboard.
Key Findings
- DEFENSE LOGISTICS AGENCY holds the top position.
- The top 10 account for 23.75% of the value in this result set.
- FEDERAL ACQUISITION SERVICE appears in the second position.
Limitations
- Interpretation depends on the SQL scope and selected filters.
- This page reflects only the returned query result set.
Query Used
-- Agencies Using IDIQ the Most
SELECT
content__award__purchaserInformation__contractingOfficeAgencyID AS agency_id,
anyHeavy(content__award__purchaserInformation__contractingOfficeAgencyID__name) AS agency_name,
count() AS idiq_award_count,
formatReadableQuantity(count()) AS idiq_award_count_readable,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable,
uniq(content__award__awardID__referencedIDVID__PIID) AS unique_vehicles,
formatReadableQuantity(uniq(content__award__awardID__referencedIDVID__PIID)) AS unique_vehicles_readable
FROM fpds.data
WHERE
contract_type = 1
AND content__award__awardID__referencedIDVID__PIID IS NOT NULL
AND content__award__awardID__referencedIDVID__PIID != ''
AND (
content__award__contractData__referencedIDVType = 'B'
OR positionCaseInsensitive(content__award__contractData__referencedIDVType__description, 'indefinite delivery') > 0
OR positionCaseInsensitive(content__award__contractData__referencedIDVType__description, 'idiq') > 0
)
AND content__award__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
GROUP BY content__award__purchaserInformation__contractingOfficeAgencyID
ORDER BY idiq_award_count DESC
LIMIT 100
Ranking Table
This table ranks results by Primary Metric from highest to lowest.
| # | Agency Id | Agency Name | Idiq Award Count | Idiq Award Count Readable | Total Obligated | Total Obligated Readable | Unique Vehicles | Unique Vehicles Readable |
|---|---|---|---|---|---|---|---|---|
| 1 | 97AS | DEFENSE LOGISTICS AGENCY | 37862697 | 37.86 million | 867262988376.86 | 867.26 billion | 481247 | 481.25 thousand |
| 2 | 4,732.00 | FEDERAL ACQUISITION SERVICE | 3940112 | 3.94 million | 83721305180.55 | 83.72 billion | 2546 | 2.55 thousand |
| 3 | 1,700.00 | DEPT OF THE NAVY | 3683539 | 3.68 million | 1155806520453.1 | 1.16 trillion | 320057 | 320.06 thousand |
| 4 | 2,100.00 | DEPT OF THE ARMY | 3368985 | 3.37 million | 1467166507532.5 | 1.47 trillion | 347047 | 347.05 thousand |
| 5 | 5,700.00 | DEPT OF THE AIR FORCE | 1979120 | 1.98 million | 1074202384079.7 | 1.07 trillion | 226805 | 226.81 thousand |
| 6 | 4,730.00 | FEDERAL ACQUISITION SERVICE | 1357336 | 1.36 million | 18550296324.83 | 18.55 billion | 7451 | 7.45 thousand |
| 7 | 3,600.00 | VETERANS AFFAIRS, DEPARTMENT OF | 1339888 | 1.34 million | 471732013435.83 | 471.73 billion | 77936 | 77.94 thousand |
| 8 | 1,540.00 | FEDERAL PRISON SYSTEM | 683580 | 683.58 thousand | 28278292758.03 | 28.28 billion | 15071 | 15.07 thousand |
| 9 | 97AK | DEFENSE INFORMATION SYSTEMS AGENCY (DISA) | 538640 | 538.64 thousand | 83842936038.98 | 83.84 billion | 3023 | 3.02 thousand |
| 10 | 4,740.00 | PUBLIC BUILDINGS SERVICE | 399958 | 399.96 thousand | 25678728990.87 | 25.68 billion | 10420 | 10.42 thousand |
| 11 | 1,900.00 | STATE, DEPARTMENT OF | 325582 | 325.58 thousand | 85110773156.53 | 85.11 billion | 14793 | 14.79 thousand |
| 12 | 6,800.00 | ENVIRONMENTAL PROTECTION AGENCY | 263886 | 263.89 thousand | 26669111657.89 | 26.67 billion | 4331 | 4.33 thousand |
| 13 | 12C2 | FOREST SERVICE | 223846 | 223.85 thousand | 13944359610.24 | 13.94 billion | 18129 | 18.13 thousand |
| 14 | 8,000.00 | NATIONAL AERONAUTICS AND SPACE ADMINISTRATION | 206119 | 206.12 thousand | 87533805883.97 | 87.53 billion | 2541 | 2.54 thousand |
| 15 | 7,008.00 | U.S. COAST GUARD | 191126 | 191.13 thousand | 31547952841.92 | 31.55 billion | 4515 | 4.51 thousand |
| 16 | 7,529.00 | NATIONAL INSTITUTES OF HEALTH | 177090 | 177.09 thousand | 40850659604.94 | 40.85 billion | 4340 | 4.34 thousand |
| 17 | 2,036.00 | BUREAU OF THE FISCAL SERVICE | 155271 | 155.27 thousand | 3468049534.98 | 3.47 billion | 1041 | 1.04 thousand |
| 18 | 9,763.00 | DEFENSE CONTRACT MANAGEMENT AGENCY (DCMA) | 149377 | 149.38 thousand | 4634409876.39 | 4.63 billion | 15122 | 15.12 thousand |
| 19 | 97AZ | DEFENSE COMMISSARY AGENCY (DECA) | 140539 | 140.54 thousand | 58144766396.67 | 58.14 billion | 6337 | 6.34 thousand |
| 20 | 6,920.00 | FEDERAL AVIATION ADMINISTRATION | 130001 | 130.00 thousand | 41547114047.14 | 41.55 billion | 3171 | 3.17 thousand |
| 21 | 1,524.00 | DRUG ENFORCEMENT ADMINISTRATION | 114258 | 114.26 thousand | 5245933581.17 | 5.25 billion | 914 | 914.00 |
| 22 | 2,050.00 | INTERNAL REVENUE SERVICE | 100042 | 100.04 thousand | 27218778018.75 | 27.22 billion | 2114 | 2.11 thousand |
| 23 | 1,501.00 | OFFICES, BOARDS AND DIVISIONS | 98241 | 98.24 thousand | 19210166721.49 | 19.21 billion | 1708 | 1.71 thousand |
| 24 | 97ZS | U.S. SPECIAL OPERATIONS COMMAND (USSOCOM) | 97792 | 97.79 thousand | 49887879937.43 | 49.89 billion | 1769 | 1.77 thousand |
| 25 | 2,400.00 | OFFICE OF PERSONNEL MANAGEMENT | 88612 | 88.61 thousand | 8785016274.2 | 8.79 billion | 1159 | 1.16 thousand |
| 26 | 1,443.00 | NATIONAL PARK SERVICE | 87303 | 87.30 thousand | 5061977549.48 | 5.06 billion | 3591 | 3.59 thousand |
| 27 | 9,776.00 | USTRANSCOM | 77823 | 77.82 thousand | 79254007129.43 | 79.25 billion | 1143 | 1.14 thousand |
| 28 | 6,938.00 | MARITIME ADMINISTRATION | 76948 | 76.95 thousand | 14572383360.48 | 14.57 billion | 624 | 624.00 |
| 29 | 1,544.00 | U.S. MARSHALS SERVICE | 75525 | 75.53 thousand | 14717095681.4 | 14.72 billion | 1077 | 1.08 thousand |
| 30 | 1,406.00 | DEPARTMENTAL OFFICES | 74637 | 74.64 thousand | 13710416648.85 | 13.71 billion | 3452 | 3.45 thousand |
| 31 | 8,900.00 | ENERGY, DEPARTMENT OF | 72653 | 72.65 thousand | 28554070695.64 | 28.55 billion | 1977 | 1.98 thousand |
| 32 | 7,022.00 | FEDERAL EMERGENCY MANAGEMENT AGENCY | 71419 | 71.42 thousand | 30295461346.1 | 30.30 billion | 1368 | 1.37 thousand |
| 33 | 7,001.00 | OFFICE OF PROCUREMENT OPERATIONS | 62145 | 62.15 thousand | 34454847140.58 | 34.45 billion | 1228 | 1.23 thousand |
| 34 | 7,523.00 | CENTERS FOR DISEASE CONTROL AND PREVENTION | 61728 | 61.73 thousand | 13700314021.08 | 13.70 billion | 1828 | 1.83 thousand |
| 35 | 4,735.00 | FEDERAL ACQUISITION SERVICE | 61571 | 61.57 thousand | 13669584259.77 | 13.67 billion | 3091 | 3.09 thousand |
| 36 | 1,330.00 | NATIONAL OCEANIC AND ATMOSPHERIC ADMINISTRATION | 59800 | 59.80 thousand | 13613599727.75 | 13.61 billion | 3212 | 3.21 thousand |
| 37 | 6,925.00 | FEDERAL HIGHWAY ADMINISTRATION | 48448 | 48.45 thousand | 6102662716.96 | 6.10 billion | 1507 | 1.51 thousand |
| 38 | 1,422.00 | BUREAU OF LAND MANAGEMENT | 48420 | 48.42 thousand | 3396448411.5 | 3.40 billion | 2756 | 2.76 thousand |
| 39 | 1,434.00 | GEOLOGICAL SURVEY | 47833 | 47.83 thousand | 4197066694.77 | 4.20 billion | 1489 | 1.49 thousand |
| 40 | 2,800.00 | SOCIAL SECURITY ADMINISTRATION | 47787 | 47.79 thousand | 12652824638.01 | 12.65 billion | 2830 | 2.83 thousand |
| 41 | 1,448.00 | U.S. FISH AND WILDLIFE SERVICE | 46176 | 46.18 thousand | 2300023690.22 | 2.30 billion | 2337 | 2.34 thousand |
| 42 | 7,014.00 | U.S. CUSTOMS AND BORDER PROTECTION | 44729 | 44.73 thousand | 45117818555.05 | 45.12 billion | 1152 | 1.15 thousand |
| 43 | 6,950.00 | UNITED STATES COAST GUARD | 44151 | 44.15 thousand | 2744022510.94 | 2.74 billion | 2692 | 2.69 thousand |
| 44 | 7,012.00 | U.S. IMMIGRATION AND CUSTOMS ENFORCEMENT | 43664 | 43.66 thousand | 24826101143.02 | 24.83 billion | 1033 | 1.03 thousand |
| 45 | 7,527.00 | INDIAN HEALTH SERVICE | 42603 | 42.60 thousand | 5190157586 | 5.19 billion | 1675 | 1.68 thousand |
| 46 | 97JC | MISSILE DEFENSE AGENCY (MDA) | 41496 | 41.50 thousand | 40013598906.81 | 40.01 billion | 1376 | 1.38 thousand |
| 47 | 1,226.00 | FOREST SERVICE | 37755 | 37.76 thousand | 1565577065.61 | 1.57 billion | 5024 | 5.02 thousand |
| 48 | 1,549.00 | FEDERAL BUREAU OF INVESTIGATION | 34109 | 34.11 thousand | 11240319170.98 | 11.24 billion | 2343 | 2.34 thousand |
| 49 | 97F2 | DEPT OF DEFENSE EDUCATION ACTIVITY (DODEA) | 32697 | 32.70 thousand | 3674151716.68 | 3.67 billion | 1473 | 1.47 thousand |
| 50 | 2,044.00 | UNITED STATES MINT | 31817 | 31.82 thousand | 42515345410.48 | 42.52 billion | 1215 | 1.22 thousand |
| 51 | 1,542.00 | FEDERAL PRISON INDUSTRIES / UNICOR | 31021 | 31.02 thousand | 2282365826.41 | 2.28 billion | 779 | 779.00 |
| 52 | 6,901.00 | OFFICE OF THE SECRETARY | 29371 | 29.37 thousand | 6696256596.11 | 6.70 billion | 886 | 886.00 |
| 53 | 9,761.00 | DEFENSE THREAT REDUCTION AGENCY (DTRA) | 29141 | 29.14 thousand | 17169310352.98 | 17.17 billion | 4365 | 4.37 thousand |
| 54 | 1,425.00 | BUREAU OF RECLAMATION | 27408 | 27.41 thousand | 2076088152.8 | 2.08 billion | 1319 | 1.32 thousand |
| 55 | 8,600.00 | HOUSING AND URBAN DEVELOPMENT, DEPARTMENT OF | 26838 | 26.84 thousand | 5585392777.84 | 5.59 billion | 1351 | 1.35 thousand |
| 56 | 7,200.00 | AGENCY FOR INTERNATIONAL DEVELOPMENT | 26703 | 26.70 thousand | 53179437692.5 | 53.18 billion | 1553 | 1.55 thousand |
| 57 | 7,524.00 | FOOD AND DRUG ADMINISTRATION | 26175 | 26.18 thousand | 8131961581.08 | 8.13 billion | 1458 | 1.46 thousand |
| 58 | 97F5 | WASHINGTON HEADQUARTERS SERVICES (WHS) | 25114 | 25.11 thousand | 13619027137.98 | 13.62 billion | 835 | 835.00 |
| 59 | 7,530.00 | CENTERS FOR MEDICARE AND MEDICAID SERVICES | 24680 | 24.68 thousand | 48090572564.46 | 48.09 billion | 652 | 652.00 |
| 60 | 1,450.00 | BUREAU OF INDIAN AFFAIRS | 23680 | 23.68 thousand | 2948376873.53 | 2.95 billion | 1123 | 1.12 thousand |
| 61 | 7,570.00 | OFFICE OF THE ASSISTANT SECRETARY FOR ADMINISTRATION (ASA) | 23660 | 23.66 thousand | 8850830808.94 | 8.85 billion | 804 | 804.00 |
| 62 | 7,013.00 | TRANSPORTATION SECURITY ADMINISTRATION | 23230 | 23.23 thousand | 20181966408.09 | 20.18 billion | 657 | 657.00 |
| 63 | 1,344.00 | PATENT AND TRADEMARK OFFICE | 22512 | 22.51 thousand | 9169826926.49 | 9.17 billion | 655 | 655.00 |
| 64 | 97AD | IMMEDIATE OFFICE OF THE SECRETARY OF DEFENSE | 21655 | 21.66 thousand | 9526320621.81 | 9.53 billion | 13326 | 13.33 thousand |
| 65 | 7,015.00 | FEDERAL LAW ENFORCEMENT TRAINING CENTER | 21594 | 21.59 thousand | 1479950544.68 | 1.48 billion | 544 | 544.00 |
| 66 | 1,341.00 | NATIONAL INSTITUTE OF STANDARDS AND TECHNOLOGY | 21437 | 21.44 thousand | 2530497951.48 | 2.53 billion | 1386 | 1.39 thousand |
| 67 | 97DH | DEFENSE HEALTH AGENCY (DHA) | 20744 | 20.74 thousand | 23628450335.23 | 23.63 billion | 719 | 719.00 |
| 68 | 12K3 | ANIMAL AND PLANT HEALTH INSPECTION SERVICE | 19970 | 19.97 thousand | 1942713933.31 | 1.94 billion | 1573 | 1.57 thousand |
| 69 | 6,400.00 | TENNESSEE VALLEY AUTHORITY | 19461 | 19.46 thousand | 12038332000 | 12.04 billion | 1894 | 1.89 thousand |
| 70 | 96CE | U.S. ARMY CORPS OF ENGINEERS - CIVIL PROGRAM FINANCING ONLY | 16814 | 16.81 thousand | 2264024000 | 2.26 billion | 2842 | 2.84 thousand |
| 71 | 7,003.00 | U.S. CITIZENSHIP AND IMMIGRATION SERVICES | 15179 | 15.18 thousand | 9369634741.47 | 9.37 billion | 446 | 446.00 |
| 72 | 3,100.00 | NUCLEAR REGULATORY COMMISSION | 15105 | 15.11 thousand | 1499124529.94 | 1.50 billion | 481 | 481.00 |
| 73 | 2,041.00 | BUREAU OF ENGRAVING AND PRINTING | 14704 | 14.70 thousand | 7547231195.23 | 7.55 billion | 951 | 951.00 |
| 74 | 12H2 | AGRICULTURAL RESEARCH SERVICE | 14246 | 14.25 thousand | 1204138715.22 | 1.20 billion | 747 | 747.00 |
| 75 | 7,520.00 | PUBLIC HEALTH SERVICE | 13684 | 13.68 thousand | 326019641.75 | 326.02 million | 1498 | 1.50 thousand |
| 76 | 9,100.00 | EDUCATION, DEPARTMENT OF | 13451 | 13.45 thousand | 18409653807.95 | 18.41 billion | 436 | 436.00 |
| 77 | 2,026.00 | FINANCIAL CRIME ENFORCEMENT NETWORK | 12535 | 12.54 thousand | 2321365100.01 | 2.32 billion | 501 | 501.00 |
| 78 | 6,940.00 | NATIONAL HIGHWAY TRAFFIC SAFETY ADMINISTRATION | 12456 | 12.46 thousand | 2560917731.19 | 2.56 billion | 640 | 640.00 |
| 79 | 12K2 | AGRICULTURAL MARKETING SERVICE | 12290 | 12.29 thousand | 6864969183.2 | 6.86 billion | 1043 | 1.04 thousand |
| 80 | 3,300.00 | SMITHSONIAN INSTITUTION | 11300 | 11.30 thousand | 1844138247.28 | 1.84 billion | 1120 | 1.12 thousand |
| 81 | 1,528.00 | IMMIGRATION AND NATURALIZATION SERVICE | 10927 | 10.93 thousand | 3006700067 | 3.01 billion | 695 | 695.00 |
| 82 | 97AB | NATIONAL GEOSPATIAL-INTELLIGENCE AGENCY (NGA) | 10362 | 10.36 thousand | 3105609168 | 3.11 billion | 1697 | 1.70 thousand |
| 83 | 12C3 | NATURAL RESOURCES CONSERVATION SERVICE | 10232 | 10.23 thousand | 399983058.44 | 399.98 million | 618 | 618.00 |
| 84 | 4,720.00 | INFORMATION TECHNOLOGY SERVICE | 9975 | 9.97 thousand | 3618652000 | 3.62 billion | 499 | 499.00 |
| 85 | 9,771.00 | DEFENSE MICROELECTRONICS ACTIVITY (DMEA) | 9905 | 9.90 thousand | 16649723101.26 | 16.65 billion | 92 | 92.00 |
| 86 | 7,526.00 | HEALTH RESOURCES AND SERVICES ADMINISTRATION | 9659 | 9.66 thousand | 1804093243.47 | 1.80 billion | 329 | 329.00 |
| 87 | 1,435.00 | BUREAU OF OCEAN ENERGY MANAGEMENT | 9540 | 9.54 thousand | 1214312733.35 | 1.21 billion | 765 | 765.00 |
| 88 | 97BZ | DEFENSE FINANCE AND ACCOUNTING SERVICE (DFAS) | 9342 | 9.34 thousand | 2808601003.15 | 2.81 billion | 367 | 367.00 |
| 89 | 1,605.00 | OFFICE OF THE ASSISTANT SECRETARY FOR ADMINISTRATION AND MANAGEMENT | 9123 | 9.12 thousand | 2240512837.87 | 2.24 billion | 489 | 489.00 |
| 90 | 6,840.00 | ASSISTANT ADMINISTRATOR FOR RESEARCH AND DEVELOPMENT | 8857 | 8.86 thousand | 918049000 | 918.05 million | 1827 | 1.83 thousand |
| 91 | 5,800.00 | FEDERAL EMERGENCY MANAGEMENT AGENCY | 8756 | 8.76 thousand | 1413625624 | 1.41 billion | 327 | 327.00 |
| 92 | 1,236.00 | FARMERS HOME ADMINISTRATION | 8644 | 8.64 thousand | 278288000 | 278.29 million | 1076 | 1.08 thousand |
| 93 | 5,000.00 | SECURITIES AND EXCHANGE COMMISSION | 8319 | 8.32 thousand | 2811391142.85 | 2.81 billion | 471 | 471.00 |
| 94 | 7,009.00 | U.S. SECRET SERVICE | 8277 | 8.28 thousand | 2194115675.62 | 2.19 billion | 605 | 605.00 |
| 95 | 1,301.00 | OFFICE OF THE SECRETARY | 8276 | 8.28 thousand | 1336068633.07 | 1.34 billion | 427 | 427.00 |
| 96 | 12D2 | FARM SERVICE AGENCY | 8208 | 8.21 thousand | 4492087370 | 4.49 billion | 487 | 487.00 |
| 97 | 1,323.00 | US CENSUS BUREAU | 8153 | 8.15 thousand | 2638934308.79 | 2.64 billion | 566 | 566.00 |
| 98 | 1,560.00 | ATF ACQUISITION AND PROPERTY MGMT DIV | 7586 | 7.59 thousand | 2539704175.75 | 2.54 billion | 417 | 417.00 |
| 99 | 1,205.00 | USDA, DEPARTMENTAL ADMINISTRATION | 7009 | 7.01 thousand | 1135328504.17 | 1.14 billion | 304 | 304.00 |
| 100 | 9,568.00 | UNITED STATES AGENCY FOR GLOBAL MEDIA, BBG | 6742 | 6.74 thousand | 530962758.14 | 530.96 million | 602 | 602.00 |
How This Ranking Is Built
Build a ranked FPDS view for "Agencies Using IDIQ the Most" using aggregated procurement data.
Query structure
- Results are sorted from highest to lowest by the main ranking metric.
- Grouping is used to combine FPDS records into comparable entity-level results.
Included fields
- agency_name — Defines the ranked agency.
- agency_id — Defines the main ranking metric: Primary Metric.
- idiq_award_count — Adds supporting context to the leaderboard.
- total_obligated — Adds supporting context to the leaderboard.
- unique_vehicles — Adds supporting context to the leaderboard.
How to use this ranking
- Supports fast market review.
- Helps compare leaders and close competitors.
- Adds context beyond a raw transaction list.
Computed Metrics
Top Entities
| # | Entity | Value |
|---|---|---|
| 1 | DEFENSE LOGISTICS AGENCY | — |
| 2 | FEDERAL ACQUISITION SERVICE | 4.73K |
| 3 | DEPT OF THE NAVY | 1.7K |
| 4 | DEPT OF THE ARMY | 2.1K |
| 5 | DEPT OF THE AIR FORCE | 5.7K |
| 6 | FEDERAL ACQUISITION SERVICE | 4.73K |
| 7 | VETERANS AFFAIRS, DEPARTMENT OF | 3.6K |
| 8 | FEDERAL PRISON SYSTEM | 1.54K |
| 9 | DEFENSE INFORMATION SYSTEMS AGENCY (DISA) | — |
| 10 | PUBLIC BUILDINGS SERVICE | 4.74K |
Related Pages
Use FPDS Query for deeper ranking analysis
Go beyond the published leaderboard with custom SQL, broader filters, saved queries, and deeper procurement market analysis across agencies, vendors, industries, PSC categories, and time windows.
Continue from this ranking into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.