How to search for a Z

[Georges1]

Thanks. Good info. Appreciate you sharing this.

 

[bpeckham]

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.

 

[Georges1]

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.

 

[bpeckham]

Thanks for checking. I was denied access trying to open the spreadsheet.

Try again. You should have access now.

 

[Georges1]

Try again. You should have access now.

It works. Thank You

 

[Georges1]

Is there similar inventory info for Texas & areas nearby?

 

[bpeckham]

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]

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?

 

[Jughead]

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#	Serial	Description	Trans	Ext	Int	MSRP	ETA
JIM M'LADY NISSAN		311337​	Z PERFORMANCE A/T	AUTO	GAT	G	53205​	Month of April
DON MOORE NISSAN		311595​	Z PERFORMANCE A/T	AUTO	GAT	G	53205​	Month of April
PIAZZA NISSAN OF ARDMORE		311363​	Z PERFORMANCE A/T	AUTO	GAT	B	53205​	Month of April
KAMAAINA NISSAN		311413​	Z PERFORMANCE A/T	AUTO	GAT	G	52495​	Month of April
VISION NISSAN WEBSTER	WJ93081	311387​	Z PERFORMANCE A/T	AUTO	GAT	G	53205​	Month of April
BARBERINO NISSAN		311415​	Z PERFORMANCE A/T	AUTO	GAT	A	53205​	Month of April
LOUGHEAD NISSAN	WJ93122O	311429​	Z PERFORMANCE A/T	AUTO	GAT	B	53205​	Month of April
GEORGESVILLE NISSAN, LLC	GC908	311463​	Z PERFORMANCE A/T	AUTO	GAT	A	53205​	Month of April
VISION NISSAN GREECE		311374​	Z PERFORMANCE A/T	AUTO	GAT	G	53205​	Month of April
STEPHANIE MORRIS NIS DUR		311505​	Z PERFORMANCE A/T	AUTO	GAT	G	53205​	Month of April
GALESBURG NISSAN, CORP.		311335​	Z PERFORMANCE A/T	AUTO	GAT	G	53205​	Month of April
D'ADDARIO NISSAN		311397​	Z PERFORMANCE A/T	AUTO	GAT	G	53205​	Month of April
LEGACY NISSAN		311593​	Z PERFORMANCE A/T	AUTO	GAT	B	53205​	Month of April
MAGUIRE NISSAN		311392​	Z PERFORMANCE A/T	AUTO	GAT	G	53205​	Month of April
NISSAN 112 SALES CORP	G2301	311353​	Z PERFORMANCE A/T	AUTO	GAT	G	53205​	Month of April
SUBURBAN NISSAN FARM HILL		311501​	Z PERFORMANCE A/T	AUTO	GAT	B	53205​	Month of April
TYNAN'S NISSAN INC		311532​	Z PERFORMANCE A/T	AUTO	GAT	G	53205​	Month of April
HARR MOTORS	5231555	311555​	Z PERFORMANCE A/T	AUTO	KAD	A	53205​	Month of April
GATEWAY NISSAN	VJ54377	311332​	Z PERFORMANCE A/T	AUTO	KAD	G	53205​	Month of April
RYAN NISSAN		311542​	Z PERFORMANCE A/T	AUTO	KAD	G	53205​	Month of April
NISSAN 422 OF LIMERICK		311364​	Z PERFORMANCE A/T	AUTO	KAD	A	53205​	Month of April
REEDMAN TOLL NIS DRE HILL		311431​	Z PERFORMANCE A/T	AUTO	KAD	A	53205​	Month of April
JEFF WYLER NISSAN FAIRFLD		311284​	Z PERFORMANCE A/T	AUTO	KAD	G	53205​	Month of April
WATERMARK NIS/MADISONVILL		311482​	Z PERFORMANCE A/T	AUTO	KAD	G	53205​	Month of April
MOYER NISSAN		311368​	Z PERFORMANCE A/T	AUTO	NBQ	G	53205​	Month of April
FORT WAYNE NISSAN		311576​	Z PERFORMANCE A/T	AUTO	NBQ	G	53205​	Month of April
SPITZER NISSAN		310923​	Z PERFORMANCE A/T	AUTO	NBQ	G	53205​	Month of April
PETER'S NISSAN OF NASHUA		311411​	Z PERFORMANCE A/T	AUTO	NBQ	G	53205​	Month of April
NISSAN OF COLUMBUS, LLC		311473​	Z PERFORMANCE A/T	AUTO	NBQ	G	53205​	Month of April
KEN NELSON AUTO PLAZA INC		311540​	Z PERFORMANCE A/T	AUTO	NBQ	G	53205​	Month of April
KRENZEN NISSAN	WJ93215	311564​	Z PERFORMANCE A/T	AUTO	XBF	G	54100​	Month of April
COMMUNITY NIS BLOOMINGTON		311590​	Z PERFORMANCE A/T	AUTO	XBF	G	54100​	Month of April
DAVE SYVERSON NISSAN		311219​	Z PERFORMANCE A/T	AUTO	XBF	G	54100​	Month of April
DUTRO NISSAN		311558​	Z PERFORMANCE A/T	AUTO	XBF	G	54100​	Month of April
SANSONE JR'S WINDSOR NISS		311424​	Z PERFORMANCE A/T	AUTO	XBF	G	54100​	Month of April
NISSAN OF CANTON		311550​	Z PERFORMANCE A/T	AUTO	XEX	A	54100​	Month of April
LYNNES NISSAN CITY INC.		311402​	Z PERFORMANCE A/T	AUTO	XEX	G	54100​	Month of April
BENDER HONDA NISSAN		311474​	Z PERFORMANCE A/T	AUTO	XJR	B	54500​	Month of April
SOUTH SHORE NISSAN		311373​	Z PERFORMANCE A/T	AUTO	XJR	G	54500​	Month of April
BOULDER NISSAN		311536​	Z PERFORMANCE A/T	AUTO	XJR	G	54500​	Month of April
NISSAN OF NEW ROCHELLE	NR22249	311366​	Z PERFORMANCE A/T	AUTO	XJR	G	54500​	Month of April
BRIDGEWATER NISSAN		311401​	Z PERFORMANCE A/T	AUTO	XJS	G	54500​	Month of April
WALSER NISSAN WAYZATA		311447​	Z PERFORMANCE A/T	AUTO	XJS	G	54500​	Month of April
RIVERSIDE NISSAN		311442​	Z PERFORMANCE A/T	AUTO	XJS	G	54500​	Month of April
GARVEY NISSAN		311359​	Z PERFORMANCE A/T	AUTO	XKJ	G	54500​	Month of April
NAPOLI NISSAN	N836523	311399​	Z PERFORMANCE A/T	AUTO	XKJ	B	54500​	Month of April
GEORGE HARTE NISSAN, INC.	INB11234	311444​	Z PERFORMANCE A/T	AUTO	XKJ	A	54500​	Month of April
PERMIAN NISSAN		311341​	Z PERFORMANCE A/T	AUTO	XKJ	G	54500​	Month of April
AUTOFAIR NISSAN		311390​	Z PERFORMANCE A/T	AUTO	XKJ	G	54500​	Month of April
STATELINE NISSAN		311440​	Z PERFORMANCE A/T	AUTO	XKJ	B	54500​	Month of April
MARLBORO NISSAN	WJ93061	311360​	Z PERFORMANCE A/T	AUTO	XKJ	G	54500​	Month of April
TANNER NISSAN		311562​	Z PERFORMANCE A/T	AUTO	XKJ	B	54500​	Month of April
BEAU TOWNSEND NISSAN, INC		311330​	Z PERFORMANCE A/T	AUTO	XKJ	G	54500​	Month of April
BERLIN CITY NISSAN		311361​	Z PERFORMANCE A/T	AUTO	XKJ	G	54500​	Month of April
NISSAN OF LEWISTON		311331​	Z PERFORMANCE M/T	6SPD	GAT	G	53205​	Month of April
NISSAN CITY/PORT CHESTER		311362​	Z PERFORMANCE M/T	6SPD	GAT	B	53205​	Month of April
CARLOCK NISSAN OF TUPELO		311329​	Z PERFORMANCE M/T	6SPD	GAT	B	53205​	Month of April
QUIRK NISSAN, INC.	NS45929	311380​	Z PERFORMANCE M/T	6SPD	GAT	G	53205​	Month of April
PREMIER NISSAN/METAIRIE	WJ93381	311475​	Z PERFORMANCE M/T	6SPD	GAT	A	53205​	Month of April
NISSAN OF BISMARCK		311587​	Z PERFORMANCE M/T	6SPD	GAT	B	53205​	Month of April
BENNINGTON NISSAN, INC.		311355​	Z PERFORMANCE M/T	6SPD	GAT	G	53205​	Month of April
CONCORDVILLE NISSAN		311405​	Z PERFORMANCE M/T	6SPD	GAT	G	53205​	Month of April
BAKER NISSAN NORTH		311615​	Z PERFORMANCE M/T	6SPD	GAT	G	53205​	Month of April
COEUR D'ALENE NISSAN		311589​	Z PERFORMANCE M/T	6SPD	GAT	G	52195​	Month of March
JIM BURKE NISSAN		311441​	Z PERFORMANCE M/T	6SPD	GAT	B	53205​	Month of April
EMPIRE NISSAN BAY RIDGE	311358O	311358​	Z PERFORMANCE M/T	6SPD	GAT	G	53205​	Month of April
CONICELLI NISSAN	N230585	311389​	Z PERFORMANCE M/T	6SPD	GAT	G	53205​	Month of April
MILLER NISSAN		311599​	Z PERFORMANCE M/T	6SPD	GAT	B	53205​	Month of April
SOMERSWORTH NISSAN	N23155	311384​	Z PERFORMANCE M/T	6SPD	GAT	B	53205​	Month of April
HOFFMAN NISSAN		311403​	Z PERFORMANCE M/T	6SPD	GAT	A	53205​	Month of April
JOHN NORTH NISSAN		311546​	Z PERFORMANCE M/T	6SPD	GAT	B	53205​	Month of April
MONKEN DG-CR-PL-JP-NISSAN		311460​	Z PERFORMANCE M/T	6SPD	KAD	A	53205​	Month of April
WEST-HERR NISSAN		311407​	Z PERFORMANCE M/T	6SPD	KAD	A	53205​	Month of April
HOVE NISSAN INC.	VJ54959	311313​	Z PERFORMANCE M/T	6SPD	KAD	G	53205​	Month of April
SANSONE NISSAN, INC.	PM311344	311344​	Z PERFORMANCE M/T	6SPD	KAD	A	53205​	Month of April
MANKATO NISSAN		311253​	Z PERFORMANCE M/T	6SPD	NBQ	G	53205​	Month of April
WELCH MOTOR COMPANY		311613​	Z PERFORMANCE M/T	6SPD	NBQ	G	53205​	Month of April
SOUTH PARK NISSAN		311217​	Z PERFORMANCE M/T	6SPD	XBF	G	54100​	Month of April
WALSER NISSAN BURNSVILLE		311388​	Z PERFORMANCE M/T	6SPD	XEX	B	54100​	Month of April
BILL SUMMERS NISSAN		311520​	Z PERFORMANCE M/T	6SPD	XJR	G	54500​	Month of April
LITHIA NISSAN OF EUGENE		311468​	Z PERFORMANCE M/T	6SPD	XJR	B	54500​	Month of April
ORR NISSAN OF SEARCY		311348​	Z PERFORMANCE M/T	6SPD	XJR	B	54500​	Month of April
WINDY NISSAN, INC.	N484	311472​	Z PERFORMANCE M/T	6SPD	XJR	B	54500​	Month of April
HAWKINSON NISSAN, L.L.C.	VJ54818	311319​	Z PERFORMANCE M/T	6SPD	XJR	G	54500​	Month of April
ORR NISSAN / RUSSELLVILLE		311336​	Z PERFORMANCE M/T	6SPD	XJS	G	54500​	Month of April
KINGS NISSAN INC		311420​	Z PERFORMANCE M/T	6SPD	XJS	G	54500​	Month of April
LEWIS NISSAN /GARDEN CITY		311479​	Z PERFORMANCE M/T	6SPD	XJS	G	54500​	04/17/23
STEPHANIE MORRIS NISSAN		311516​	Z PERFORMANCE M/T	6SPD	XKJ	B	54500​	Month of April
HUGH WHITE NISSAN ATHENS		311470​	Z PERFORMANCE M/T	6SPD	XKJ	B	54500​	Month of April
NISSAN OF GARDEN CITY		311428​	Z PERFORMANCE M/T	6SPD	XKJ	G	54500​	Month of April
GATES NISSAN		311382​	Z PERFORMANCE M/T	6SPD	XKJ	G	54500​	Month of April
HERTRICH NISSAN OF NEWARK		311432​	Z PERFORMANCE M/T	6SPD	XKJ	B	54500​	Month of April
JAMES CERANTI NISSAN		311477​	Z PERFORMANCE M/T	6SPD	XKJ	G	54500​	Month of April
EDISON NISSAN		311410​	Z PERFORMANCE M/T	6SPD	XKJ	B	54500​	Month of April
GUNN NISSAN OF DENTON LTD	D30302	311481​	Z PERFORMANCE M/T	6SPD	XKJ	A	54500​	Month of April
MISSOULA NISSAN HYUNDAI	N4756	311594​	Z PERFORMANCE M/T	6SPD	XKJ	A	54500​	Month of April
BERTERA NISSAN, INC.		311377​	Z SPORT A/T	AUTO	GAT	G	42875​	Month of April
COLE NISSAN		311530​	Z SPORT A/T	AUTO	GAT	G	42475​	Month of March
CAVENDER NIS SAN MARCOS	WJ92971	311486​	Z SPORT A/T	AUTO	GAT	G	42875​	Month of April
CHERRY HILL NISSAN, INC.		311371​	Z SPORT A/T	AUTO	GAT	G	42875​	Month of April
ROUTE 23 NISSAN		311376​	Z SPORT A/T	AUTO	XJS	G	44170​	Month of April
KEN GARFF NISSAN OF OREM		311333​	Z SPORT A/T	AUTO	XKJ	G	43770​	Month of March
PAUL MILLER NISSAN, LLC		311372​	Z SPORT M/T	6SPD	GAT	G	42875​	Month of April
ROUTE 33 NISSAN		311375​	Z SPORT M/T	6SPD	GAT	G	42875​	Month of April
UNDERRINER NISSAN/ DALLES		311492​	Z SPORT M/T	6SPD	KAD	G	42875​	Month of April
WILSON NISSAN		311423​	Z SPORT M/T	6SPD	KAD	G	42475​	Month of April
BROWER BROTHERS NISSAN		311287​	Z SPORT M/T	6SPD	XBF	G	43770​	Month of April
JC BILLION NISSAN		311338​	Z SPORT M/T	6SPD	XKJ	G	44170​	Month of April

 

[bpeckham]

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]

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

 

[bpeckham]

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]

Thanks. This should work better: 77001, 78209,75237, 70003. Those zip codes cover Houston, Dallas, San Antonio, and New Orleans. Appreciate the help.

 

[bpeckham]

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.

 

[bpeckham]

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