How to search for a Z

Georges1

Well-Known Member
First Name
George
Joined
Apr 3, 2021
Threads
1
Messages
167
Reaction score
251
Location
Cypress, TX
Car(s)
1972 Datsun 240Z
Occupation
Safety Engineer
Thanks. Good info. Appreciate you sharing this.
 
OP
OP
bpeckham

bpeckham

Well-Known Member
First Name
Bill
Joined
Feb 11, 2023
Threads
38
Messages
923
Reaction score
895
Location
San Diego
Car(s)
2023 Z Performance 6MT Blue/Graphite
Using the zip codes in the map at the beginning of this post, here's a spreadsheet that shows the inventory within the circles (more or less):

Inventory Spreadsheet

I'll try to update it once a week. Sorry @Georges1, still no red.
 
Last edited:

Georges1

Well-Known Member
First Name
George
Joined
Apr 3, 2021
Threads
1
Messages
167
Reaction score
251
Location
Cypress, TX
Car(s)
1972 Datsun 240Z
Occupation
Safety Engineer
Using the zip codes in the map at the beginning of this post, here's a spreadsheet that shows the inventory within the circles (more or less):

Inventory Spreadsheet

I'll try to update it once a week. Sorry @Georges1, still no red.
Thanks for checking. I was denied access trying to open the spreadsheet.
 

Georges1

Well-Known Member
First Name
George
Joined
Apr 3, 2021
Threads
1
Messages
167
Reaction score
251
Location
Cypress, TX
Car(s)
1972 Datsun 240Z
Occupation
Safety Engineer
Is there similar inventory info for Texas & areas nearby?
 
OP
OP
bpeckham

bpeckham

Well-Known Member
First Name
Bill
Joined
Feb 11, 2023
Threads
38
Messages
923
Reaction score
895
Location
San Diego
Car(s)
2023 Z Performance 6MT Blue/Graphite
Is there similar inventory info for Texas & areas nearby?
I've created this for the area in which I'm willing to buy (the Southwest). I'm in San Diego, and it stretches as far east as Amarillo and El Paso in Texas. If you give me a list of zip codes to search, I can add them.

But, in general, it's not really geo-based. That would be a lot of effort to do well.

What surprises me is that there are only 60ish cars in the Southwest, and that number drops rapidly if you pick a manual, and lower still if you want a specific color.

It'll be interesting to see how this evolves over the coming weeks and months.
 

trackratZ

Well-Known Member
First Name
August
Joined
Mar 23, 2021
Threads
62
Messages
1,861
Reaction score
4,166
Location
So CA
Car(s)
240Z RB26DETT,Glady Rubi, Model Y LR, 987 Cayman S
Occupation
Software security
I've created this for the area in which I'm willing to buy (the Southwest). I'm in San Diego, and it stretches as far east as Amarillo and El Paso in Texas. If you give me a list of zip codes to search, I can add them.

But, in general, it's not really geo-based. That would be a lot of effort to do well.

What surprises me is that there are only 60ish cars in the Southwest, and that number drops rapidly if you pick a manual, and lower still if you want a specific color.

It'll be interesting to see how this evolves over the coming weeks and months.
Your list includes Zs already in dealer lots or in transit also? Thx for the spreadsheet, requesting access.

Edit: Got the access thanks Bill! Only two Boulder Grays but Auto in the West huh?
 
Last edited:

Jughead

Well-Known Member
First Name
Willie
Joined
Feb 6, 2023
Threads
9
Messages
82
Reaction score
140
Location
Nashville
Car(s)
rogue, wrangler
Occupation
Sales Management
Here is a national list of cars labeled at sea/in transit. I will post a couple others here after this one. I can't organize it by area, sorry.
Dealer
Stock#SerialDescriptionTransExtIntMSRPETA
JIM M'LADY NISSAN
311337​
Z PERFORMANCE A/TAUTOGATG
53205​
Month of April
DON MOORE NISSAN
311595​
Z PERFORMANCE A/TAUTOGATG
53205​
Month of April
PIAZZA NISSAN OF ARDMORE
311363​
Z PERFORMANCE A/TAUTOGATB
53205​
Month of April
KAMAAINA NISSAN
311413​
Z PERFORMANCE A/TAUTOGATG
52495​
Month of April
VISION NISSAN WEBSTERWJ93081
311387​
Z PERFORMANCE A/TAUTOGATG
53205​
Month of April
BARBERINO NISSAN
311415​
Z PERFORMANCE A/TAUTOGATA
53205​
Month of April
LOUGHEAD NISSANWJ93122O
311429​
Z PERFORMANCE A/TAUTOGATB
53205​
Month of April
GEORGESVILLE NISSAN, LLCGC908
311463​
Z PERFORMANCE A/TAUTOGATA
53205​
Month of April
VISION NISSAN GREECE
311374​
Z PERFORMANCE A/TAUTOGATG
53205​
Month of April
STEPHANIE MORRIS NIS DUR
311505​
Z PERFORMANCE A/TAUTOGATG
53205​
Month of April
GALESBURG NISSAN, CORP.
311335​
Z PERFORMANCE A/TAUTOGATG
53205​
Month of April
D'ADDARIO NISSAN
311397​
Z PERFORMANCE A/TAUTOGATG
53205​
Month of April
LEGACY NISSAN
311593​
Z PERFORMANCE A/TAUTOGATB
53205​
Month of April
MAGUIRE NISSAN
311392​
Z PERFORMANCE A/TAUTOGATG
53205​
Month of April
NISSAN 112 SALES CORPG2301
311353​
Z PERFORMANCE A/TAUTOGATG
53205​
Month of April
SUBURBAN NISSAN FARM HILL
311501​
Z PERFORMANCE A/TAUTOGATB
53205​
Month of April
TYNAN'S NISSAN INC
311532​
Z PERFORMANCE A/TAUTOGATG
53205​
Month of April
HARR MOTORS5231555
311555​
Z PERFORMANCE A/TAUTOKADA
53205​
Month of April
GATEWAY NISSANVJ54377
311332​
Z PERFORMANCE A/TAUTOKADG
53205​
Month of April
RYAN NISSAN
311542​
Z PERFORMANCE A/TAUTOKADG
53205​
Month of April
NISSAN 422 OF LIMERICK
311364​
Z PERFORMANCE A/TAUTOKADA
53205​
Month of April
REEDMAN TOLL NIS DRE HILL
311431​
Z PERFORMANCE A/TAUTOKADA
53205​
Month of April
JEFF WYLER NISSAN FAIRFLD
311284​
Z PERFORMANCE A/TAUTOKADG
53205​
Month of April
WATERMARK NIS/MADISONVILL
311482​
Z PERFORMANCE A/TAUTOKADG
53205​
Month of April
MOYER NISSAN
311368​
Z PERFORMANCE A/TAUTONBQG
53205​
Month of April
FORT WAYNE NISSAN
311576​
Z PERFORMANCE A/TAUTONBQG
53205​
Month of April
SPITZER NISSAN
310923​
Z PERFORMANCE A/TAUTONBQG
53205​
Month of April
PETER'S NISSAN OF NASHUA
311411​
Z PERFORMANCE A/TAUTONBQG
53205​
Month of April
NISSAN OF COLUMBUS, LLC
311473​
Z PERFORMANCE A/TAUTONBQG
53205​
Month of April
KEN NELSON AUTO PLAZA INC
311540​
Z PERFORMANCE A/TAUTONBQG
53205​
Month of April
KRENZEN NISSANWJ93215
311564​
Z PERFORMANCE A/TAUTOXBFG
54100​
Month of April
COMMUNITY NIS BLOOMINGTON
311590​
Z PERFORMANCE A/TAUTOXBFG
54100​
Month of April
DAVE SYVERSON NISSAN
311219​
Z PERFORMANCE A/TAUTOXBFG
54100​
Month of April
DUTRO NISSAN
311558​
Z PERFORMANCE A/TAUTOXBFG
54100​
Month of April
SANSONE JR'S WINDSOR NISS
311424​
Z PERFORMANCE A/TAUTOXBFG
54100​
Month of April
NISSAN OF CANTON
311550​
Z PERFORMANCE A/TAUTOXEXA
54100​
Month of April
LYNNES NISSAN CITY INC.
311402​
Z PERFORMANCE A/TAUTOXEXG
54100​
Month of April
BENDER HONDA NISSAN
311474​
Z PERFORMANCE A/TAUTOXJRB
54500​
Month of April
SOUTH SHORE NISSAN
311373​
Z PERFORMANCE A/TAUTOXJRG
54500​
Month of April
BOULDER NISSAN
311536​
Z PERFORMANCE A/TAUTOXJRG
54500​
Month of April
NISSAN OF NEW ROCHELLENR22249
311366​
Z PERFORMANCE A/TAUTOXJRG
54500​
Month of April
BRIDGEWATER NISSAN
311401​
Z PERFORMANCE A/TAUTOXJSG
54500​
Month of April
WALSER NISSAN WAYZATA
311447​
Z PERFORMANCE A/TAUTOXJSG
54500​
Month of April
RIVERSIDE NISSAN
311442​
Z PERFORMANCE A/TAUTOXJSG
54500​
Month of April
GARVEY NISSAN
311359​
Z PERFORMANCE A/TAUTOXKJG
54500​
Month of April
NAPOLI NISSANN836523
311399​
Z PERFORMANCE A/TAUTOXKJB
54500​
Month of April
GEORGE HARTE NISSAN, INC.INB11234
311444​
Z PERFORMANCE A/TAUTOXKJA
54500​
Month of April
PERMIAN NISSAN
311341​
Z PERFORMANCE A/TAUTOXKJG
54500​
Month of April
AUTOFAIR NISSAN
311390​
Z PERFORMANCE A/TAUTOXKJG
54500​
Month of April
STATELINE NISSAN
311440​
Z PERFORMANCE A/TAUTOXKJB
54500​
Month of April
MARLBORO NISSANWJ93061
311360​
Z PERFORMANCE A/TAUTOXKJG
54500​
Month of April
TANNER NISSAN
311562​
Z PERFORMANCE A/TAUTOXKJB
54500​
Month of April
BEAU TOWNSEND NISSAN, INC
311330​
Z PERFORMANCE A/TAUTOXKJG
54500​
Month of April
BERLIN CITY NISSAN
311361​
Z PERFORMANCE A/TAUTOXKJG
54500​
Month of April
NISSAN OF LEWISTON
311331​
Z PERFORMANCE M/T6SPDGATG
53205​
Month of April
NISSAN CITY/PORT CHESTER
311362​
Z PERFORMANCE M/T6SPDGATB
53205​
Month of April
CARLOCK NISSAN OF TUPELO
311329​
Z PERFORMANCE M/T6SPDGATB
53205​
Month of April
QUIRK NISSAN, INC.NS45929
311380​
Z PERFORMANCE M/T6SPDGATG
53205​
Month of April
PREMIER NISSAN/METAIRIEWJ93381
311475​
Z PERFORMANCE M/T6SPDGATA
53205​
Month of April
NISSAN OF BISMARCK
311587​
Z PERFORMANCE M/T6SPDGATB
53205​
Month of April
BENNINGTON NISSAN, INC.
311355​
Z PERFORMANCE M/T6SPDGATG
53205​
Month of April
CONCORDVILLE NISSAN
311405​
Z PERFORMANCE M/T6SPDGATG
53205​
Month of April
BAKER NISSAN NORTH
311615​
Z PERFORMANCE M/T6SPDGATG
53205​
Month of April
COEUR D'ALENE NISSAN
311589​
Z PERFORMANCE M/T6SPDGATG
52195​
Month of March
JIM BURKE NISSAN
311441​
Z PERFORMANCE M/T6SPDGATB
53205​
Month of April
EMPIRE NISSAN BAY RIDGE311358O
311358​
Z PERFORMANCE M/T6SPDGATG
53205​
Month of April
CONICELLI NISSANN230585
311389​
Z PERFORMANCE M/T6SPDGATG
53205​
Month of April
MILLER NISSAN
311599​
Z PERFORMANCE M/T6SPDGATB
53205​
Month of April
SOMERSWORTH NISSANN23155
311384​
Z PERFORMANCE M/T6SPDGATB
53205​
Month of April
HOFFMAN NISSAN
311403​
Z PERFORMANCE M/T6SPDGATA
53205​
Month of April
JOHN NORTH NISSAN
311546​
Z PERFORMANCE M/T6SPDGATB
53205​
Month of April
MONKEN DG-CR-PL-JP-NISSAN
311460​
Z PERFORMANCE M/T6SPDKADA
53205​
Month of April
WEST-HERR NISSAN
311407​
Z PERFORMANCE M/T6SPDKADA
53205​
Month of April
HOVE NISSAN INC.VJ54959
311313​
Z PERFORMANCE M/T6SPDKADG
53205​
Month of April
SANSONE NISSAN, INC.PM311344
311344​
Z PERFORMANCE M/T6SPDKADA
53205​
Month of April
MANKATO NISSAN
311253​
Z PERFORMANCE M/T6SPDNBQG
53205​
Month of April
WELCH MOTOR COMPANY
311613​
Z PERFORMANCE M/T6SPDNBQG
53205​
Month of April
SOUTH PARK NISSAN
311217​
Z PERFORMANCE M/T6SPDXBFG
54100​
Month of April
WALSER NISSAN BURNSVILLE
311388​
Z PERFORMANCE M/T6SPDXEXB
54100​
Month of April
BILL SUMMERS NISSAN
311520​
Z PERFORMANCE M/T6SPDXJRG
54500​
Month of April
LITHIA NISSAN OF EUGENE
311468​
Z PERFORMANCE M/T6SPDXJRB
54500​
Month of April
ORR NISSAN OF SEARCY
311348​
Z PERFORMANCE M/T6SPDXJRB
54500​
Month of April
WINDY NISSAN, INC.N484
311472​
Z PERFORMANCE M/T6SPDXJRB
54500​
Month of April
HAWKINSON NISSAN, L.L.C.VJ54818
311319​
Z PERFORMANCE M/T6SPDXJRG
54500​
Month of April
ORR NISSAN / RUSSELLVILLE
311336​
Z PERFORMANCE M/T6SPDXJSG
54500​
Month of April
KINGS NISSAN INC
311420​
Z PERFORMANCE M/T6SPDXJSG
54500​
Month of April
LEWIS NISSAN /GARDEN CITY
311479​
Z PERFORMANCE M/T6SPDXJSG
54500​
04/17/23
STEPHANIE MORRIS NISSAN
311516​
Z PERFORMANCE M/T6SPDXKJB
54500​
Month of April
HUGH WHITE NISSAN ATHENS
311470​
Z PERFORMANCE M/T6SPDXKJB
54500​
Month of April
NISSAN OF GARDEN CITY
311428​
Z PERFORMANCE M/T6SPDXKJG
54500​
Month of April
GATES NISSAN
311382​
Z PERFORMANCE M/T6SPDXKJG
54500​
Month of April
HERTRICH NISSAN OF NEWARK
311432​
Z PERFORMANCE M/T6SPDXKJB
54500​
Month of April
JAMES CERANTI NISSAN
311477​
Z PERFORMANCE M/T6SPDXKJG
54500​
Month of April
EDISON NISSAN
311410​
Z PERFORMANCE M/T6SPDXKJB
54500​
Month of April
GUNN NISSAN OF DENTON LTDD30302
311481​
Z PERFORMANCE M/T6SPDXKJA
54500​
Month of April
MISSOULA NISSAN HYUNDAIN4756
311594​
Z PERFORMANCE M/T6SPDXKJA
54500​
Month of April
BERTERA NISSAN, INC.
311377​
Z SPORT A/TAUTOGATG
42875​
Month of April
COLE NISSAN
311530​
Z SPORT A/TAUTOGATG
42475​
Month of March
CAVENDER NIS SAN MARCOSWJ92971
311486​
Z SPORT A/TAUTOGATG
42875​
Month of April
CHERRY HILL NISSAN, INC.
311371​
Z SPORT A/TAUTOGATG
42875​
Month of April
ROUTE 23 NISSAN
311376​
Z SPORT A/TAUTOXJSG
44170​
Month of April
KEN GARFF NISSAN OF OREM
311333​
Z SPORT A/TAUTOXKJG
43770​
Month of March
PAUL MILLER NISSAN, LLC
311372​
Z SPORT M/T6SPDGATG
42875​
Month of April
ROUTE 33 NISSAN
311375​
Z SPORT M/T6SPDGATG
42875​
Month of April
UNDERRINER NISSAN/ DALLES
311492​
Z SPORT M/T6SPDKADG
42875​
Month of April
WILSON NISSAN
311423​
Z SPORT M/T6SPDKADG
42475​
Month of April
BROWER BROTHERS NISSAN
311287​
Z SPORT M/T6SPDXBFG
43770​
Month of April
JC BILLION NISSAN
311338​
Z SPORT M/T6SPDXKJG
44170​
Month of April
 
OP
OP
bpeckham

bpeckham

Well-Known Member
First Name
Bill
Joined
Feb 11, 2023
Threads
38
Messages
923
Reaction score
895
Location
San Diego
Car(s)
2023 Z Performance 6MT Blue/Graphite
Your list includes Zs already in dealer lots or in transit also? Thx for the spreadsheet, requesting access.
Yes, it has a distance_or_date column. The "distance" part is taken from the first found_in_zip. The "date" part is the ETA (the farthest going out to late April). Since the circles overlap, we often find the same car in multiple zip codes.
 

Georges1

Well-Known Member
First Name
George
Joined
Apr 3, 2021
Threads
1
Messages
167
Reaction score
251
Location
Cypress, TX
Car(s)
1972 Datsun 240Z
Occupation
Safety Engineer
Great info. Here are some Zip codes if that helps & it is not too much trouble to get info for. 77001, 77494, 77301, 78363, 78041, 39601, 70737, 76210, 78666. Thanks
 
OP
OP
bpeckham

bpeckham

Well-Known Member
First Name
Bill
Joined
Feb 11, 2023
Threads
38
Messages
923
Reaction score
895
Location
San Diego
Car(s)
2023 Z Performance 6MT Blue/Graphite
Great info. Here are some Zip codes if that helps & it is not too much trouble to get info for. 77001, 77494, 77301, 78363, 78041, 39601, 70737, 76210, 78666. Thanks
Hi @Georges1, can you shrink the list a bit? If a zip code is within 250 miles of another, we can probably drop it, so maybe Dallas, San Antonio, Huston, NOLA. Something like that should give good results, and take less effort.
 

Georges1

Well-Known Member
First Name
George
Joined
Apr 3, 2021
Threads
1
Messages
167
Reaction score
251
Location
Cypress, TX
Car(s)
1972 Datsun 240Z
Occupation
Safety Engineer
Thanks. This should work better: 77001, 78209,75237, 70003. Those zip codes cover Houston, Dallas, San Antonio, and New Orleans. Appreciate the help.
 
OP
OP
bpeckham

bpeckham

Well-Known Member
First Name
Bill
Joined
Feb 11, 2023
Threads
38
Messages
923
Reaction score
895
Location
San Diego
Car(s)
2023 Z Performance 6MT Blue/Graphite
Thanks. This should work better: 77001, 78209,75237, 70003. Those zip codes cover Houston, Dallas, San Antonio, and New Orleans. Appreciate the help.
Okay. I'll try to update it today, but it may be tomorrow.
 
OP
OP
bpeckham

bpeckham

Well-Known Member
First Name
Bill
Joined
Feb 11, 2023
Threads
38
Messages
923
Reaction score
895
Location
San Diego
Car(s)
2023 Z Performance 6MT Blue/Graphite
Okay, it's up. The number of cars in the spreadsheet jumped from 61 to 102.

I ended up using these zip codes:
  • 70119 New Orleans, LA
  • 75201 Dallas, TX
  • 77001 Houston, TX
  • 78204 San Antonio, TX
 
 





Top