Alien captive recorded log

Alien Captive Recordings (called Alien Captive Recorded Log ingame) are items added to Fallout 3 in the add-on Mothership Zeta.

Description
There are a total of 25 recordings. Although they are usually not physical objects, the recordings will appear as holotapes when spawned via console commands and are stored in the Notes section of the Pip-Boy. Collecting all of them will grant the Alien Archivist achievement.

You will need to collect all the recordings while playing through the DLC's storyline, upon completion of the DLC you are only able to access The Bridge and the Engineering Core. All other areas are inaccessible. You can go back up until the death ray so make sure you have all the ones up to that part. But #19 is only accessible until the space walk. So if you're planning on getting all of the recordings, make sure you get the ones in Cryo Lab and Research Lab, because after you complete the final mission, they are locked and you need a key that is impossible to get. Spawning them through console commands will not get you the achievement. Also unlocking the inaccessible doors does not work, if you do not pick up all 25 by searching you need to restart the DLC.

Walkthrough
Without backtracking, the order is roughly:


 * 1) Holding Cells (6 total)
 * 2) * The first three {14, 15, 22} are together to the east of your initial cell on the first level. Don't follow your new friend.
 * 3) *The next three {3, 1, 12} are again found together in the room just east of the quest map marker.
 * 4) Engineering Core (4 total)
 * 5) * The locations of the four recordings on this level {5, 6, 7, 8} correspond to the four individual stasis controls on the pods of the samurai, astronaut, medic, and cowboy.
 * 6) Waste Disposal (via Maintenance Level) (1 total) (note that you can do step 3, 4, and 5 in any order)
 * 7) * The recording {19} is in the southwest portion of the waste disposal map. Make sure you grab the unique General Chase's Overcoat before leaving as you can not return to this area. Also, you will want to pick up the Samurai's Sword which is located in a closet that is full of medical supplies that you encounter just before you teleport from this area.
 * 8) Cryo Lab and Cryo Storage (6 total; 4 in the former, 2 in the latter)
 * 9) * The first recording {4} inside the Cryo Labs is down a short flight of stairs to the right of the level entrance inside a room blocked by a blue stasis field with other earth-based misc loot; to remove the stasis field (so you can enter and collect the recording) you must press an alien switch to the left of the entrance. The second recording {2} is inside the stasis room containing a Raider and a Ghoul. The third and fourth recordings {11, 17} are inside the room with Elliott's squad or (If you do not have Elliott with you) three wastlanders on operating tables. Make sure you get all four from the Cryo Lab before progressing to Cryo Storage. Teleporting back from storage locks doors behind you in the lab.
 * 10) * The first recording inside Cryo Storage {25} is just to the left of the entrance. The second {16}, is in the southwest corner of the map, downstairs.
 * 11) Research Lab (via Cargo Hold) (2 total)
 * 12) * The first recording {13} inside the Research Lab is in the "vehicular" (containing several pre-war cars and a human spacecraft) section on a four-sided console near the human spacecraft. The second recording {21} is located in the first Giddyup Buttercup room; it is in the central portion of the room near four alien consoles, on the opposite side of the room as a closed door containing a Healing Archway.
 * 13)  Weapons Lab (1 total)
 * 14) * The only recording {24} in this location is inside the lab control room. Do not miss the fourth-largest group of 87 Alien Power Cells on a shelf inside this room.
 * 15)  Experimentation Lab (3 total)
 * 16) * The first recording {20} is inside the room with the two large chairs. The second {10} is on the north wall of the observation room. The last {9} is inside the room being observed, next to the Abominations on the operating tables.
 * 17)  Biological Research (1 total)
 * 18) * The penultimate recording {18} is on the second floor of the room in the north west of the map. Before or after you reunite with Sally and the others at the end of this level, do not miss the largest stash of Alien Power Cells on Mothership Zeta (109) located in the adjacent room (after first disabling the door barrier).
 * 19)  Living Quarters (1 total)
 * 20) * The last recording {23} is inside a small room at the opposite end of the hallway from the samurai. When you enter, continue down the hall way. You will enter a large room, continue heading south until you come to a hallway, at this hallway turn right and keep going until you see a room with tables and chairs, it looks like an alien dining room/cafeteria, as soon as you enter this room it will be on your right.

Locations
Please note that this Alien Captive Recordings chart is in order by log number.

Transcripts
The following the recording played during the official trailer for Mothership Zeta:

It is revealed to be an edit of Alien Captive Recorded Log 19, which complete transcript is available here.

Alien Captive Recorded Log 5
Paulson's recording.

Alien Captive Recorded Log 6
Elliot Tercorien's recording.

Alien Captive Recorded Log 7
Toshiro Kago's recording.

Alien Captive Recorded Log 8
The late Colonel Hartigan's recording.

Alien Captive Recorded Log 10
A note about an encounter with Frank.

Alien Captive Recorded Log 12
Possibly Sally's first recording (or Sally's sister).

Alien Captive Recorded Log 17
The human voice is completely silent. The only audio is that of the Alien babbling.

Alien Captive Recorded Log 19
Parts of this recording were used in the official trailer.

Alien Captive Recorded Log 21
Sally's second recording.

Alien Captive Recorded Log 22
Somah's interrogation.

Alien Captive Recorded Log 24
This log is evidently a recording of a Cow or Brahmin.

Behind the scenes
Log 25 probably references two episodes of The Twilight Zone - the famous "To Serve Man" (in which the alien text by that title turns out to be a cookbook) and the somewhat lesser known "People Are Alike All Over" (in which a human astronaut is held captive at a Martian zoo).

Log 24 could be a reference to "Destroy All Humans!" in which the first life form you contact is a cow which are mistaken as the sentient lifeforms.