In case someone is writing a book:
You don't need an FAA Pilot
Certificate to receive dual in the USA from an FAA Certified Flight Instructor (CFI), though technically TSA is supposed to know about it ahead of time. I'm sure you couldn't care less what a federal agency like the TSA thinks.
You don't need an FAA pilot
Certificate to act as PIC of an N-registered aircraft in Canada.
As the holder of a Canadian Pilot
Licence you can get an FAA Pilot
Certificate two different ways:
FAR 61.75 allows any holder of an ICAO PPL/CPL/ATPL to obtain an FAA Private Pilot
Certificate which relies upon the foreign licence. No medical, no written test, no flight test. Valid for night, SEL, MEL as appropriate. If you write the IFP you can get an instrument rating on it. All you have to do is fill out the verification form and take the letter the FAA mails you, to a FSDO.
Now for something completely different. The IPL allows you, as the holder of a Canadian PPL/CPL/ATPL, to obtain a normal, self-standing (different from a 61.75 above) corresponding FAA Private/Commercial/ATP
Certificate. Same verification letter. You need to do an FAA medical (and keep it valid). You also need to write a little test. Same visit to the FSDO.
PS I'm not sure why people feel they are entitled to the above sort of information, for free. Reminds me of a certain federal Liberal Cabinet Minister:
http://en.wikipedia.org/wiki/David_Dingwall
When questioned while giving testimony before Parliament as to why he felt he should receive a severance package after the voluntary resignation, he remarked "I'm entitled to my entitlements."