Attachment6_Divestment_Tracker.xlsx

XLSX spreadsheet 184 KB Posted

Attached to
T-1A Trainer Aircraft COMBS
Solicitation number
FA810625RB001
Issued by

About this file

This is a divestment tracking spreadsheet detailing the schedule and status for divesting 177 T-1A aircraft across multiple locations, including 104 Legacy Aircraft, 52 AMP Aircraft, and 21 CSO Aircraft. The tracker shows planned divestments from 2022 through 2027, with aircraft allocations across Randolph (16 aircraft), Columbus (67 aircraft), Laughlin (41 aircraft), Vance (32 aircraft), and Pensacola (21 aircraft).

The schedule includes key milestones such as AMARG partial runway closure from March 2026 to November 2026 and full runway closure from November 2026 to June 2027. The divestment plan shows a gradual reduction in active tails from 177 to 0, with various aircraft dispositions including transfers to AMARG, LESO, Museums, Static Display, and Foreign Military Sales to countries including Ecuador, Peru, Philippines, Morocco, and Tunisia. The tracker includes detailed weekly planning schedules, aircraft induction dates, and tracks both cumulative divested tails and remaining active tails throughout the divestment period.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

AMARG Schedule_Current (2)

ActualTodaySubmit AFSC Form 501MOA/Div Plan SignedPCOL Due Back from VTXNotional Released PB23/NDAAFY23 Requirements FinalizedStrike Board/WLA & SOW FinalizedFunding In PlaceAMARG Quote Received100% SE On-siteFY23 Divestment DPEM Funds RecAMARG on ContractEngine Run TrainingForm 913First Aircraft DeliveryCMB Sends First Legacy AircraftCOMBS Contract Requirement DevelopmentCOMB Req LockedCBM Sends Last AircraftDLF Sends First AircraftRND Sends First AircraftRND Sends Last AircraftCOMBS Contract End/Follow On AwardsCMB Sends First AMP AircraftEND Sends First AMP AircraftEND Sends Last AMP AircraftCMB Sends Last AMP AircraftDLF Sends Last Aircraft
Induction Date12/18/248/30/221/31/222/15/222/15/223/1/223/15/228/2/225/15/227/31/228/1/228/3/229/3/229/15/2210/1/2210/1/2212/1/226/1/239/30/2310/1/231/1/249/30/2412/1/241/1/251/1/259/30/259/30/2512/21/25
Action5333333333333333333333333333

Induction Date Today Submit AFSC Form 501 MOA/Div Plan Signed PCOL Due Back from VTX Notional Released PB23/NDAA FY23 Requirements Finalized Strike Board/WLA & SOW Finalized Funding In Place AMARG Quote Received 100% SE On-site FY23 Divestment DPEM Funds Rec AMARG on Contract Engine Run Training Form 913 First Aircraft Delivery CMB Sends First Legacy Aircraft COMBS Contract Requirement Development COMB Req Locked CBM Sends Last Aircraft DLF Sends First Aircraft RND Sends First Aircraft RND Sends Last Aircraft COMBS Contract End/Follow On Awards CMB Sends First AMP Aircraft END Sends First AMP Aircraft END Sends Last AMP Aircraft CMB Sends Last AMP Aircraft DLF Sends Last Aircraft 45644 44803 44592 44607 44607 44621 44635 44775 44696 44773 44774 44776 44807 44819 44835 44835 44896 45078 45199 45200 45292 45565 45627 45658 45658 45930 45930 46012 Action Today Submit AFSC Form 501 MOA/Div Plan Signed PCOL Due Back from VTX Notional Released PB23/NDAA FY23 Requirements Finalized Strike Board/WLA & SOW Finalized Funding In Place AMARG Quote Received 100% SE On-site FY23 Divestment DPEM Funds Rec AMARG on Contract Engine Run Training Form 913 First Aircraft Delivery CMB Sends First Legacy Aircraft COMBS Contract Requirement Development COMB Req Locked CBM Sends Last Aircraft DLF Sends First Aircraft RND Sends First Aircraft RND Sends Last Aircraft COMBS Contract End/Follow On Awards CMB Sends First AMP Aircraft END Sends First AMP Aircraft END Sends Last AMP Aircraft CMB Sends Last AMP Aircraft DLF Sends Last Aircraft 5 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3

Aircraft rollup

*Estimated Divestment Tracker
CompletedAMARG Partial Runway Closure Mar 26 - Nov 26AMARG Full Runway Closure Nov 26- Jun 27
Upcoming/delayedRestricted 8K ft RunwayFull Runway Closure
202220232024202520262027
JulOctJanAprJulOctJanAprJulOctJanAprJulOctJanAprJulOctJanAprJul
Legacy
104 Aircraft1111919301819122
Amp
52 Aircraft181212127
CSO
21 Aircraft5124
Total Active Tails1771761651461271241241068674695743311970
Total Divested Tails111191930182012512141212127177

Aircraft Allocations

AMARG Partial Runway ClosureAMARG Full ClosureMar 26- Nov 26 Partial ClosureNov 26- Jun 27 Full Closure
202220232024202520262027
JulOctJanAprJulOctJanAprJulOctJanAprJulOctJanAprJulOctJanAprJul
Randolph
16 Aircraft35146
Columbus
67 aircraft110161551010
Laughlin
41 aircraft532415
Vance
32 aircraft1561010
Pensacola777
21 aircraft
Total Active Tails1771761611421271241179977655851515140200
Total Divested Tails1151915371822127700112020177
1111164819261200001000
AMARG110115381425118
AMP MCT1
SPEM ACI1
C-21
Army
LESO4
GITA0
NASA
NMUSAF
Museum1
Static1111
FMS
Ecuador
Peru
Philippnes
Morroco
Tunsia
Disposal1
1

Weekly Div Plan

AMARG RUNWAY CLOSED

2022
FY23Q1
OctNov
SSMTWTRFSSMTWTRFSSMTWTRFSSMTWTRFSSMTWTRFSSMTWTRFSSMTWTR
SUM1-Oct-222-Oct-223-Oct-224-Oct-225-Oct-226-Oct-227-Oct-228-Oct-229-Oct-2210-Oct-2211-Oct-2212-Oct-2213-Oct-2214-Oct-2215-Oct-2216-Oct-2217-Oct-2218-Oct-2219-Oct-2220-Oct-2221-Oct-2222-Oct-2223-Oct-2224-Oct-2225-Oct-2226-Oct-2227-Oct-2228-Oct-2229-Oct-2230-Oct-2231-Oct-221-Nov-222-Nov-223-Nov-224-Nov-225-Nov-226-Nov-227-Nov-228-Nov-229-Nov-2210-Nov-2211-Nov-2212-Nov-2213-Nov-2214-Nov-2215-Nov-2216-Nov-2217-Nov-22
RND
21 Aircraft0
CBM
50 Aircraft50111111111111111111111111111111111111111111111111
DLF
51 aircraft0
END
34 aircraft0
Total Tails Divested50000100000000100000100000100000100100000100000100
Total Active Tails177177177177176176176176176176176176176175175175175175175174174174174174174173173173173173173172172172171171171171171171170170170170170170169169169
Cumulative Divested Tails000111111111222222333333444444555666666777777888
Transfer to PCOLA0
Parts/Disposal0
CANN Birds0
Storage (AMP)0
LESO010 (Laughlin)
ACC06 to 8 (Laughlin/Randolph)
Other0

Sheet3

2022202320242025
JulOctJanAprJulOctJanAprJulOctJanAprJul
Randolph
17 Aircraft467
Columbus
47 Aircraft1010111161010
Laughlin
47 aircraft81010107
Vance
45 aircraft61010
Total Active Tails177167157146127117103877373614121
Total Divested Tails10101119101416140122020

9 10 11 19 10 14 16 14 0 0 0 0

AMARG81011199
LESO46
ACC6
NMUSAF
Museum2
Static111
FMS
Ecuador1
Peru2
Philippnes39
Morroco33
Tunsia22
Disposal1
NO ACC \/ \/ \/
10101119101416140122020
Divesting10101119101416140000
AMARG63910111914
LESO1010
NMUSAF
Museum22
Static413
FMS
Ecuador11
Peru22
Philippnes1239
Morroco633
Tunsia44

AMARG FY23 Flow - OLD

T-1 FY23 Induction Schedule249 daysThu 10/13/22Wed 10/11/23
Task NameDurationStartFinishDate
T-1 Aircraft 140 daysThu 10/13/22Mon 12/12/2210/13/2022
T-1 Aircraft 240 daysWed 10/19/22Fri 12/16/2210/19/2022
T-1 Aircraft 340 daysTue 10/25/22Thu 12/22/2210/25/2022
T-1 Aircraft 440 daysMon 10/31/22Thu 12/29/2210/31/2022
T-1 Aircraft 540 daysWed 11/9/22Tue 1/10/2311/9/2022
T-1 Aircraft 640 daysTue 11/15/22Fri 1/13/2311/15/2022
T-1 Aircraft 740 daysTue 11/22/22Mon 1/23/2311/22/2022
T-1 Aircraft 840 daysTue 11/29/22Thu 1/26/2311/29/2022
T-1 Aircraft 940 daysWed 12/7/22Fri 2/3/2312/7/2022
T-1 Aircraft 1040 daysTue 12/13/22Thu 2/9/2312/13/2022
T-1 Aircraft 1140 daysWed 1/4/23Thu 3/2/231/4/2023
T-1 Aircraft 1240 daysTue 1/10/23Wed 3/8/231/10/2023
T-1 Aircraft 1340 daysTue 1/24/23Tue 3/21/231/24/2023
T-1 Aircraft 1440 daysTue 1/31/23Tue 3/28/231/31/2023
T-1 Aircraft 1540 daysWed 2/8/23Wed 4/5/232/8/2023
T-1 Aircraft 1640 daysWed 2/15/23Wed 4/12/232/15/2023
T-1 Aircraft 1740 daysWed 2/22/23Tue 4/18/232/22/2023
T-1 Aircraft 1840 daysWed 3/1/23Tue 4/25/233/1/2023
T-1 Aircraft 1940 daysWed 3/8/23Tue 5/2/233/8/2023
T-1 Aircraft 2040 daysWed 3/15/23Tue 5/9/233/15/2023
T-1 Aircraft 2140 daysTue 3/21/23Mon 5/15/233/21/2023
T-1 Aircraft 2240 daysTue 3/28/23Mon 5/22/233/28/2023
T-1 Aircraft 2340 daysMon 4/3/23Fri 5/26/234/3/2023
T-1 Aircraft 2440 daysWed 4/12/23Wed 6/7/234/12/2023
T-1 Aircraft 2540 daysTue 4/18/23Tue 6/13/234/18/2023
T-1 Aircraft 2640 daysTue 4/25/23Tue 6/20/234/25/2023
T-1 Aircraft 2740 daysWed 5/3/23Wed 6/28/235/3/2023
T-1 Aircraft 2840 daysTue 5/9/23Wed 7/5/235/9/2023
T-1 Aircraft 2940 daysTue 5/16/23Wed 7/12/235/16/2023
T-1 Aircraft 3040 daysTue 5/23/23Wed 7/19/235/23/2023
T-1 Aircraft 3140 daysWed 5/31/23Wed 7/26/235/31/2023
T-1 Aircraft 3240 daysWed 6/7/23Wed 8/2/236/7/2023
T-1 Aircraft 3340 daysTue 6/13/23Tue 8/8/236/13/2023
T-1 Aircraft 3440 daysWed 6/21/23Wed 8/16/236/21/2023
T-1 Aircraft 3540 daysTue 6/27/23Tue 8/22/236/27/2023
T-1 Aircraft 3640 daysThu 7/6/23Wed 8/30/237/6/2023
T-1 Aircraft 3740 daysWed 7/12/23Wed 9/6/237/12/2023
T-1 Aircraft 3840 daysWed 7/19/23Wed 9/13/237/19/2023
T-1 Aircraft 3940 daysTue 7/25/23Tue 9/19/237/25/2023
T-1 Aircraft 4040 daysWed 8/2/23Wed 9/27/238/2/2023
T-1 Aircraft 4140 daysWed 8/9/23Wed 10/4/238/9/2023
T-1 Aircraft 4240 daysTue 8/15/23Wed 10/11/238/15/2023

Sheet1

11/2/1911/7/1911/27/191/23/202/24/202/20/20
9/18/199/23/1910/13/1912/9/191/10/201/6/20
-11.50-7.0013.5070.50102.0098.00
9/30/199/30/199/30/199/30/199/30/199/30/19
-23.00-14.0027.00141.00204.00196.00
9/17/199/7/199/16/1910/27/192/18/204/21/204/13/20
93-063693-062292-034793-063292-035291-009492-035893-0637
BARTON, BRITTNEY M GS-09 USAF AFMC AFLCMC/WLZW: Laughlin was late to deliver this a/c. AMARG has been ready for induction since 1/22. Delivereved to AMARG on 2/20.91-0090
BARTON, BRITTNEY M GS-09 USAF AFMC AFLCMC/WLZW: Delivered to AMARG 4/9/1993-0623
9/8/1710/17/1712/27/171/25/189/17/1810/16/1811/26/182/28/194/22/195/29/190.3333333333
11/21/172/27/181/24/183/6/1810/23/1811/26/181/14/194/10/196/19/197/16/19121.6666666667
2/8/183/27/182/23/183/18/1811/26/1812/26/182/6/195/1/197/23/198/6/19486.6666666667
3/7/184/24/186/13/189/17/184/29/19
BARTON, BRITTNEY M GS-09 USAF AFMC AFLCMC/WLZW: Work Stoppage for 107 material from 23 Jan to 20Feb5/23/19
BARTON, BRITTNEY M GS-09 USAF AFMC AFLCMC/WLZW: Work stoppage for Seat Rail (error in drawing) from 1/31 to…3/66/28/19

BARTON, BRITTNEY M GS-09 USAF AFMC AFLCMC/WLZW: A/c on "hold" for higher priorty a/c's, from 5/08 to …..?

A/c at work stoppage for 4-3 fuel cell from 6/03 to 6/108/6/1912/18/2412/18/24
3/7/184/24/186/13/1812/10/184/29/196/10/198/9/1912/18/24
7/18/188/15/181/4/19

BARTON, BRITTNEY M GS-09 USAF AFMC AFLCMC/WLZW: Completed Gate 4 on 1/4

Started Gate 5: 1/228/20/19
BARTON, BRITTNEY M GS-09 USAF AFMC AFLCMC/WLZW: Work Stoppage for 107 material from 23 Jan to 20Feb9/16/1912/18/2412/18/24
11/1/1811/1/184/5/1912/18/2412/18/24
-97.33333333330.6883561644-0.3116438356
0.7294520548-0.2705479452
0.6575342466-0.3424657534
365
0.75
9/17/1912/2/1912/31/192/10/205/14/207/6/208/12/20
93-063292-035291-009492-035893-0637
BARTON, BRITTNEY M GS-09 USAF AFMC AFLCMC/WLZW: Laughlin was late to deliver this a/c. AMARG has been ready for induction since 1/22. Delivereved to AMARG on 2/20.91-0090

BARTON, BRITTNEY M GS-09 USAF AFMC AFLCMC/WLZW: Delivered to AMARG 4/9/19 BARTON, BRITTNEY M GS-09 USAF AFMC AFLCMC/WLZW: Laughlin was late to deliver this a/c. AMARG has been ready for induction since 1/22. Delivereved to AMARG on 2/20.

BARTON, BRITTNEY M GS-09 USAF AFMC AFLCMC/WLZW: Delivered to AMARG 4/9/19 BARTON, BRITTNEY M GS-09 USAF AFMC AFLCMC/WLZW: Work Stoppage for 107 material from 23 Jan to 20Feb BARTON, BRITTNEY M GS-09 USAF AFMC AFLCMC/WLZW: Completed Gate 4 on 1/4 Started Gate 5: 1/22 BARTON, BRITTNEY M GS-09 USAF AFMC AFLCMC/WLZW: Work stoppage for Seat Rail (error in drawing) from 1/31 to…3/6

BARTON, BRITTNEY M GS-09 USAF AFMC AFLCMC/WLZW: Work Stoppage for 107 material from 23 Jan to 20Feb93-0623
1/25/189/17/1810/16/1811/26/182/28/194/22/195/29/19

AMARG Schedule_Forecast Confirmed Dates Estimated Dates

93-063693-062292-034793-063292-035291-009492-035893-063791-009093-0623
Induction DateERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!4/22/195/29/19
Gate 1 Completion DateERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!4/10/196/19/197/16/19
Gate 2 Completion DateERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!5/1/197/23/198/6/19
Gate 3 Completion DateERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!4/29/195/23/196/28/198/6/1911/11/1911/25/19
QueueERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!4/29/196/10/198/9/199/16/1912/1/191/30/20
Gate 4 Completion DateERROR:#REF!ERROR:#REF!ERROR:#REF!8/19/1910/20/1912/1/191/30/203/8/205/23/207/22/20
RTS DateERROR:#REF!ERROR:#REF!4/5/1911/18/191/19/203/1/204/30/206/7/208/22/2010/21/20% of Confirmed Dates46%
Days to Complete93-063693-062292-034793-063292-035291-009492-035893-063793-062391-0090Running AVG
Gate 1ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!5848Gate 155
Gate 2ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!213421Gate 231
Gate 3ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!97111111Gate 3111
QueueERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!01842412066Queue48
Gate 4ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!174174174174174174Gate 4174
Gate 5 (FCF)ERROR:#REF!ERROR:#REF!ERROR:#REF!92929292929292Gate 5 (FCF)92
Avg Total Time Per A/C511days
TotalERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!4895121year4months
Induction Date93-063693-062292-034793-063292-035291-009492-035893-063793-062391-0090000000004357743614Gate 1
93-063693-062292-034793-063292-035291-009492-035893-063793-062391-0090000000005848Gate 2
93-063693-062292-034793-063292-035291-009492-035893-063793-062391-00900000000213421Gate 3
93-063693-062292-034793-063292-035291-009492-035893-063793-062391-0090000000097111.125111.125Queue
93-063693-062292-034793-063292-035291-009492-035893-063793-062391-00900000018424119.87565.875Gate 4
93-063693-062292-034793-063292-035291-009492-035893-063793-062391-00900000174174174174174174Gate 5 (FCF)
93-063693-062292-034793-063292-035291-009492-035893-063793-062391-009000091.66666666666424191.66666666666424191.66666666666424191.66666666666424191.66666666666424191.66666666666424191.666666666664241#REF!93-063693-062292-034793-063292-035291-009492-035893-063793-062391-00901

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .