Derived table · Payroll Support Program

Payroll Support Program: every recipient in Treasury's three files

Name: Payroll Support Program: every recipient in Treasury's three files
Creator: Pandemic Darlings
Published: 2026-09-30

Treasury's three Payroll Support Program files list 1,575 payments totaling $58.91 billion to airlines, cargo carriers and aviation contractors. Passenger airlines received $53.46 billion of it.

Rows1,584

Columns18

Files4 · 307 KB

FormatCSV, JSON

Source vintageTreasury PSP files dated 2023-08-17 (PSP1) and 2022-07-27 (PSP2, PSP3)

Published byPandemic Darlings

Built2026-09-30

Built fromTreasury's three PSP files

SHA-256e7937588eca1207a7731284f1105780562032b255ca3f62a299ab893fa48d402

RightsCompiled from U.S. government public data; attribution to Pandemic Darlings requested for the compiled table.

Dictionarydictionary.csv

Download CSV 273 KB Data dictionary CSV Figures JSON What the files add up to Before you quote a row

At a glance

Measured on the served file. Note principal is the amount of the promissory note a recipient issued to Treasury, as the file lists it; PSP3's column is headed “Anticipated Note Principal”.

Round	Rows	Rows with a payment above zero	Payroll support	Note principal	Rows with a note
PSP1	611	606	$28,585,576,716	$7,635,133,873	37
PSP2	489	488	$15,666,014,761	$3,945,218,639	20
PSP3	484	481	$14,659,519,496	$3,643,994,099	19
All rounds	1,584	1,575	$58,911,110,973	$15,224,346,611	76

What it is

One row is one row of Treasury's PSP1, PSP2 or PSP3 file, with the file name and line number it came from. Names, cities, states, dates and amounts are as Treasury published them. Added columns give the file and line, a participant class, a cleaned name, any footnote marker, a name key that groups the same company across rounds, and flags.

The name key is the name in capitals with punctuation and trailing corporate words removed. It groups 1,584 rows under 706 keys. It keeps the legal name before any “f/k/a”, “d/b/a” or “a/k/a” clause, so it merges spelling variants of one company, such as the two spellings of Frontier Airlines and Republic Airways' first-round name “f/k/a Republic Airline Inc.”, and it does not merge a parent with its subsidiaries.

How it was built

The three CSVs were read line by line and summed in whole cents. In PSP3 three names end in a digit that reads as a footnote marker with no footnote in the file; the digit is moved to its own column and the name kept as published.

11 rows are flagged and kept: 6 with a payroll support amount of zero, 3 with no amount at all (one of them a row named “OCIO TEST TEST TEST”), and 2 rows with a stray “#REF!” spreadsheet error in one cell. They are listed below.

What the files add up to

Congress made $63 billion available across the three rounds: $32 billion in the CARES Act, $16 billion in the Consolidated Appropriations Act, 2021 and $15 billion in the American Rescue Plan Act (GAO-24-106754). Treasury's files add up to $58,911,110,973, which rounds to the $58.9 billion in payments GAO reported as of December 31, 2023. Each round paid out less than it was given; the files do not say why.

Round	Law or source	Made available	Sum of Treasury's file
PSP1	CARES Act, section 4112	$32 billion	$28,585,576,716
PSP2	Consolidated Appropriations Act, 2021	$16 billion	$15,666,014,761
PSP3	American Rescue Plan Act of 2021	$15 billion	$14,659,519,496
All rounds	GAO-24-106754, as of December 31, 2023	$63 billion available; $58.9 billion paid	$58,911,110,973

Largest recipients

All three rounds, grouped by name key.

Rank	Recipient (name key)	PSP1	PSP2	PSP3	All rounds
1	AMERICAN AIRLINES	$5,957,940,109	$3,532,928,551	$3,295,162,461	$12,786,031,121
2	DELTA AIR LINES	$5,593,698,668	$3,290,410,981	$3,068,966,322	$11,953,075,971
3	UNITED AIRLINES	$5,102,033,567	$3,001,196,216	$2,799,215,711	$10,902,445,494
4	SOUTHWEST AIRLINES	$3,353,526,454	$1,986,475,960	$1,852,786,128	$7,192,788,542
5	ALASKA AIRLINES	$1,020,911,166	$612,685,500	$571,451,766	$2,205,048,432
6	JETBLUE AIRWAYS	$962,842,466	$580,235,932	$541,186,053	$2,084,264,451
7	SKYWEST AIRLINES	$450,701,094	$268,069,807	$250,028,709	$968,799,610
8	SPIRIT AIRLINES	$344,426,582	$212,130,753	$197,854,353	$754,411,688
9	HAWAIIAN AIRLINES	$300,925,853	$192,658,000	$179,692,117	$673,275,970
10	FRONTIER AIRLINES	$210,808,088	$161,083,131	$150,242,236	$522,133,455
11	REPUBLIC AIRWAYS	$211,949,425	$130,416,748	$121,639,701	$464,005,874
12	SKY CHEFS	$276,490,264	$93,392,267	$93,392,267	$463,274,798
13	ATLAS AIR	$406,842,820	$0	$0	$406,842,820
14	ALLEGIANT AIR	$176,889,331	$105,521,953	$98,420,326	$380,831,610
15	GATE GOURMET	$160,729,389	$74,750,674	$74,750,674	$310,230,737
16	SWISSPORT USA	$170,172,676	$60,545,677	$60,545,677	$291,264,030
17	WORLDWIDE FLIGHT SERVICES	$135,066,743	$45,622,544	$45,622,544	$226,311,831
18	MESA AIRLINES	$95,144,443	$55,967,320	$52,200,719	$203,312,482
19	G2 SECURE STAFF L L C	$105,058,948	$35,486,578	$35,486,578	$176,032,104
20	DAL GLOBAL SERVICES	$162,373,028	$0	$0	$162,373,028
21	KALITTA AIR	$161,458,421	$0	$0	$161,458,421
22	PROSPECT AIRPORT SERVICES	$94,580,166	$31,947,078	$31,947,078	$158,474,322
23	OMNI AIR INTERNATIONAL	$67,427,857	$43,020,433	$40,125,158	$150,573,448
24	MENZIES AVIATION	$134,577,979	$0	$0	$134,577,979
25	SUN COUNTRY	$62,311,885	$37,039,812	$34,547,032	$133,898,729

By class of recipient

Passenger carriers, cargo carriers and contractors, as Treasury's participant type assigns them.

Class	Rows	PSP1	PSP2	PSP3	All rounds
Passenger carriers	962	$24,916,951,618	$14,771,195,594	$13,767,383,298	$53,455,530,510
Contractors	584	$2,841,583,987	$894,819,167	$892,136,198	$4,628,539,352
Cargo carriers	38	$827,041,111	—	—	$827,041,111

By state

The state is the recipient's address in Treasury's file, not where its employees work.

State	Rows	Payroll support
TX	156	$21,256,173,355
GA	26	$12,300,258,994
IL	60	$11,362,552,398
NY	96	$2,985,390,702
WA	32	$2,366,482,617
FL	181	$1,580,498,101
UT	11	$975,501,511
HI	26	$702,864,972
VA	29	$627,629,270
CO	22	$553,240,478
CA	184	$521,097,698
IN	19	$468,559,760
NV	15	$387,336,213
OH	31	$343,172,989
OK	15	$308,435,377
NC	39	$251,132,431
MI	91	$232,939,028
AZ	22	$232,098,845
MN	21	$175,154,201
AK	135	$166,417,086
MO	11	$153,387,665
WI	25	$139,642,770
MD	21	$125,064,527
LA	11	$110,511,334
OR	22	$93,138,464
NE	10	$65,303,357
MA	20	$55,214,484
WV	6	$50,813,039
NH	23	$47,033,936
PA	31	$47,032,937
ME	12	$30,593,966
AL	14	$25,307,749
NJ	12	$24,590,752
TN	17	$21,630,219
SC	26	$19,261,673
KS	7	$18,186,930
ID	11	$17,638,337
CT	11	$17,243,066
DE	11	$16,311,755
PR	9	$9,405,265
MT	9	$3,750,417
VT	3	$3,265,675
AR	5	$3,005,108
VI	3	$2,984,171
SD	11	$2,868,798
KY	9	$2,846,707
MP	3	$2,822,277
ND	7	$2,707,017
NM	8	$1,771,484
RI	2	$665,022
IA	3	$176,046

Rows flagged and kept

The rows whose amount or name needs care before anyone counts them.

Treasury file	Line	Name as published	Flag
PSP1-08-17-2023.csv	11	YUKON AIR SERVICE INC.	zero_payroll_support
PSP1-08-17-2023.csv	299	BLATTI AVIATION INC.	zero_payroll_support
PSP1-08-17-2023.csv	323	MAXAIR INCORPORATED	zero_payroll_support
PSP1-08-17-2023.csv	373	AIRPAC AIRLINES INC.	zero_payroll_support
PSP1-08-17-2023.csv	498	PRIOR AVIATION SERVICE INC.	zero_payroll_support
PSP2-07-27-2022.csv	182	FLYING FOOD GROUP LLC	stray_cell:#REF!
PSP2-07-27-2022.csv	284	METRO AVIATION INC.	stray_cell:#REF!
PSP2-07-27-2022.csv	342	POLARIS RESEARCH & DEVELOPMENT INC.	no_payroll_support_amount
PSP3-07-27-2022.csv	192	OCIO TEST TEST TEST	test_row;no_payroll_support_amount
PSP3-07-27-2022.csv	193	OHARA AVIATION MANAGEMENT SERVICES L.C.	zero_payroll_support
PSP3-07-27-2022.csv	485	TURBINE ENGINE CENTER, INC	no_payroll_support_amount

Files

The SHA-256 values are the checksums of the files served here. Treasury's three original files are listed with the checksums of the preserved copies; they match fresh downloads made on September 29, 2026.

File	Rows	Size	SHA-256
`psp-recipients.csv` one row per row of Treasury's three files, each traced to its file and line	1,584	272,514 B	e7937588eca1207a7731284f1105780562032b255ca3f62a299ab893fa48d402	Download ↓
`dictionary.csv` data dictionary for psp-recipients.csv, measured on the file	18	2,064 B	dd08c95fe4c1fd94f59542c320f50a427cf44151089f13c7f6eb8ace8ba8c6c9	Download ↓
`psp-figures.json` every figure on this page and the PSP guide, with its definition and method	—	30,266 B	8cf205fad025385874d92e241d09d5c19b835fcc3a5f9c8e41305b82fc0a97bd	Download ↓
`psp-data-dictionary.csv` every column mapped to Treasury's column	18	1,826 B	1db69e227d65f80930b7e123a59d84347f088a43f5ccb2a6600b7941cd1c1496	Download ↓
`PSP1-08-17-2023.csv` Treasury's PSP1 file, as preserved on 2026-07-21; original at home.treasury.gov	—	56,081 B	0ed8f9d85bed145150aebee687b83f0f5fb57ccb4e843be735ac5da6a7707470	Download (56 KB)
`PSP2-07-27-2022.csv` Treasury's PSP2 file, as preserved on 2026-07-21; original at home.treasury.gov	—	49,516 B	03225823428476fa110233b058c709fd32dae6678c134b1565a9aa8e66c6bee0	Download (50 KB)
`PSP3-07-27-2022.csv` Treasury's PSP3 file, as preserved on 2026-07-21; original at home.treasury.gov	—	44,223 B	cb544f06a8f85d98fa3252cd9270024c06e2e6a2cf0b7bd769fd584ae82516a3	Download (44 KB)

Columns

Column	Type, measured	Blank	Distinct	Range	Meaning
`round`	text	0	3		PSP1, PSP2 or PSP3
`source_file`	text	0	3		Treasury CSV the row comes from
`source_row`	integer	0	611	2 – 612	Physical line number in that CSV (header = 1)
`participant_type`	text	0	4		Participant type as Treasury published it
`participant_class`	text	0	3		participant_type normalized to passenger_carrier, cargo_carrier or contractor
`participant_name_raw`	text	0	790		Name exactly as published
`participant_name`	text	0	787		Name as published, with the trailing footnote digit on PSP3 lines 7, 325 and 326 removed
`footnote_marker`	integer	1,581	3	8 – 9	The digit removed from those three PSP3 names
`name_key`	text	0	706		Grouping key across rounds: the legal name before any f/k/a, d/b/a or a/k/a clause, in capitals, punctuation, trailing corporate suffix words and a leading THE removed
`city`	text	0	389		City as published (the agreement address)
`state`	text	0	51		State as published (the agreement address)
`application_date`	date	1,095	29	2021-01-07 – 2021-06-09	Application date (ISO); PSP2 only
`agreement_date`	date	3	169	2020-04-20 – 2022-02-09	Agreement date (ISO)
`payroll_support_usd`	number	3	1,398	0.00 – 5957940109.00	Total Payroll Support (PSP1, PSP2) or Payroll Support (PSP3) as published; includes any note principal
`note_principal_usd`	number	1,508	71	1656586.00 – 1764849417.00	Note principal as published; PSP3's column is Anticipated Note Principal. Blank = N/A in source
`warrants`	integer	1,547	38	4 – 14107509	Warrants as published; PSP3's column is anticipated. Blank = N/A in source
`warrant_exercise_price_usd`	number	1,547	36	6.36 – 108000.00	Warrant exercise price as published; PSP3's column is anticipated. Blank = N/A in source
`flags`	text	1,573	5		zero_payroll_support, no_payroll_support_amount, test_row, stray_cell:<value>

Type, blanks, distinct count and range are measured on psp-recipients.csv. The same table as CSV: dictionary.csv.

Before you quote a row

Rows are payments, not companies. A recipient that took part in all three rounds has three rows. Group on the name key, and check it by hand for parents and subsidiaries.
State is an address. Payroll support followed employees wherever they worked; the state column is where Treasury addressed the agreement.
Totals are the files' totals. They are what Treasury published per recipient, not what Congress made available, and not net of any repayment Treasury later sought. They include note principal, the part of the assistance that GAO says recipients must repay (GAO-24-106754).

Cite this table. Name the source vintage; the numbers depend on it.

Payroll Support Program recipients, compiled from Treasury's PSP1 (2023-08-17), PSP2 and PSP3 (2022-07-27) files. Pandemic Darlings, https://pandemicdarlings.com/data/psp/, SHA-256 e7937588eca1207a7731284f1105780562032b255ca3f62a299ab893fa48d402