It was equipped with a transporter, a holomatrix, and an Emergency Hologram basic installation. The dining area had a replicator and a dedicated beverage replicator, though the ship could replicate items elsewhere, such as on the navigation console.
A few weeks after Picard had hired Rios and retrieved Asha, La Sirena's power was deactivated by an orchid, and the ship crashed onto the surface of the planet Coppelius. However, by the time of the Romulan attack led by the Zhat Vash operative General Oh, La Sirena was restored, and took part in the battle. (PIC: "Et in Arcadia Ego, Part 1", "Et in Arcadia Ego, Part 2")
|La Sirena emergency holograms|
|Emil • Emmet • Enoch • Ian • Mister Hospitality|
- Dr. Soji Asha (2399)
- Elnor (2399)
- Dr. Agnes Jurati (2399)
- Dr. Bruce Maddox (2399)
- Raffi Musiker (2399)
- Jean-Luc Picard (2399)
- Seven of Nine (2399)
The La Sirena set was designed by production designer Todd Cherniawsky. Cherniawsky noted that La Sirena was a non-Federation ship that had become "retrofit[ted] with Federation technology" over time, the holodeck and staterooms in particular. Cherniawsky also suggested the weapons rack had "accumulated a variety of weapons that probably date back as many as 150 years." ("La Sirena Set Tour", TRR: "Away Mission Special")
In a story from his Instagram account, showrunner Michael Chabon said that La Sirena was manufactured at the Kaplan Shifbau on the Hatzeplatz colony world. It had a dedication plaque; however, the plaque was missing by the time Rios acquired the ship. 
Yang produced a number of exterior paint schemes for La Sirena, in which Cherniawsky eventually picked red. Yang later noted "for some reason, red just jumped out at him, so we gave it a very striking paint job."  WhatCulture.com noted the design closely resembles Eddie Van Halen's Frankenstrat guitar. 
According to Issue #1 of the Star Trek Universe: The Official Starships Collection, the La Sirena was launched in the 23rd century.