The wood i-beams are rotten on the outer edges, and about 2 inches of the outside floor board, but the framing and the center of the floor boards seem 99% ok. I had to stop as I have a little family issue in the evening, but
I think it's not as bad as it seemed on the surface.
I'm thinking that I need to reinforce/replace the outer supports, cut away and replace the rotten the outer plywood. The install new Tyvek, (i cut away a bit of the black tar paper as it was falling apart, but it was there), and then top it with some siding?
Before we get into the fix, we should be on the same page for your final
result. So just a bunch of stuff that rolls around in my head.
1. We can see LSL rim board absorbs water and some of that water wicks up into structure above it so the lower siding should be removed for inspection for the rest of the exposed area.
If the framing above is in good shape, 4" holes could be cut in the rim so a cameras could be used for inspection of the joists.
I would expect damage under the door to be similar to the bump out and the rim should be removed.
2. Lag bolts have never been a good system for hanging the deck.
There are 3 things they do for bolting the deck all requested by the engineer on our job.
Replace that rim with LVL instead.
Or drill drill thru and use nuts and bolts to attach the ledger.
Or put 2x10 blocks inside the rim so regular lag bolts will work.
You have non of those.
3. If you remove some are all of the rim below the door, that will give you access to do a better repair on the first joist under the bump out.
4. The new deck should be 6" below the floor inside and that would allow you to bolt the new ledger to the concrete.
5. Find a real door shop and make an appointment with them so you can drop you door off in the morning and pick it up in the afternoon with a new jam. You need to understand rainscreening or door pan and how to tie that into the flashing for the new ledger before you install the door jam.
Comment?? I would like to be on the same page with you so we are going in the same direction.