Short answer: sometimes, but it depends on the lender. There is no law stopping you financing a Cat N car. In practice, many lenders and dealer finance providers set their own rules and some will not lend against a car with a write-off history. Cat S cars are treated in much the same way.
Many car finance agreements, such as hire purchase, are secured against the car. The lender owns the car until you finish paying, so it cares about the car’s value and risk. A write-off history can mean a lower and less certain value, so some lenders decline or add conditions.
Lenders set their own criteria, so one may refuse while another accepts, and we cannot give a single rule that applies to all of them.
Dealer finance. If you buy from a dealer, ask whether their finance panel will lend on a car with a write-off history, before you fall for the car.
Specialist lenders. Some lenders deal with cars that mainstream lenders avoid. Check they are authorised by the Financial Conduct Authority and compare the total cost.
Personal loan. A personal loan is usually unsecured, so the lender is lending to you rather than against the car. The loan terms depend on your credit, and you own the car from the start. Compare the interest rate against car finance.
Saving or part-paying. If neither works, buying with savings or a smaller loan can be safer than taking on expensive credit.