The most ubiquitous wood in N. America would be Willow. That would be my prime choice. Poplar, also known as Cottonwood, and Aspen, would be the second choice for both the spindle and the fireboard. Yucca is wonderfully tough, and dry. But, It doesn't grow here in the midwest. I sent off to someone who advertised a Bow and drill "kit" for sale, and they sent a Yucca Fireboard.
So, I have used it, several times, to make fires to demonstrate the technique to others. I believe they included a 3/8" leather "strap" for their bowstring but I don't remember now. I have several old belts that can be cut lengthwise, carefully, and then softened with neatsfoot oil to make them into good bow"strings". If I had to make up a bow and drill in a true survival situation, I would look to the belt I am wearing for such a "strap."
I split my willow spindle out of a tree trunk cutting, using a sledge and wedge. The cut trunk was about 24 inches long, and probably 20 " in diameter. We got a lot of spindles and fire boards out of that one cutting.
Then I made an 1 inch square stave of the spindle, and used my knife to cut facets around the stave to make the " gear teeth". I could have used an axe, but someone else got to it first. You do want the wood to be dry, BTW. But, if you already have a fire going, the spindle can be dried over the heat from the fire rather quickly.