/var/www/html/nox-modules/prints
/lib/action/frontend
/printsSearchDefaultAction.action.php
main
SELECT COUNT(*) as `count` FROM prints_set WHERE id IN(SELECT DISTINCT set_id FROM prints_set_vector WHERE vector_id IN(28325,30849,30850,30851,30852))
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT DISTINCT set_id FROM prints_set_vector WHERE vector_id IN(28325,30849,30850,30851,30852)) LIMIT 0, 30
SELECT `prints_set`.`id`, `prints_set`.`url`, `prints_set`.`name_full`, COUNT(`vector_id`) c, MIN(`price`) price, IF((SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1) IS NOT NULL, (SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1), (SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1)) as preview, IF((SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1) IS NOT NULL, 1, 0) as vector FROM `prints_set` LEFT JOIN `prints_set_vector` ON `prints_set`.`id` = `prints_set_vector`.`set_id` LEFT JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set`.`id` IN(36214, 34980) GROUP BY `prints_set`.`id` ORDER BY IF(MAX(`prints_vector`.`preview`) IS NOT NULL AND MAX(`prints_vector`.`preview`) != '', 0, 1), `prints_set`.`name_full`
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 36214 AND `prints_set_vector`.`vector_id` IN(28325,30849,30850,30851,30852) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 34980 AND `prints_set_vector`.`vector_id` IN(28325,30849,30850,30851,30852) AND `prints_vector`.`bundle` = 0
SELECT `prints_vector`.* FROM `prints_vector` LEFT JOIN `prints_set_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `id` IN(28325,30849,30850,30851,30852) AND `set_id` IS NULL ORDER BY IF(`prints_vector`.`preview` IS NOT NULL AND `prints_vector`.`preview` != '', 0, 1), `prepay`, `prints_vector`.`full_name` LIMIT 28
?q=American&page=###page###
68
SELECT `id`, `name`, `type` FROM nox_group

Search Results for "American"

 

VECTOR

Ready-made editable vector blueprints available for instant download.


CUSTOM ORDER

Order a custom vector blueprint with a fixed price. Production and delivery within 3-7 work days.


REQUEST

This blueprint is not available as a ready-made item. You can request a custom order for this vehicle.

 

Search Results

We found: 2 sets of blueprints - 5 vector blueprints - 36 free blueprints (view free blueprints).

AAR Eagle blueprint AAR Eagle blueprint
Set of items
AAR Eagle
Collection of 3 blueprints
Starting at $36

 

Blue Bird All American blueprint Blue Bird All American blueprint
Set of items
Blue Bird All American
Collection of 4 blueprints
Starting at $24

 

All search results - 68 items

This list includes all items: free bitmap blueprints, requested items, pre-order and ready vector blueprints.

  Model Views
1966 - 1966 AAR Eagle Mk1 (T1G) F1 GP Anglo American Racers Formula CUSTOM ORDER F T R S
1989 - 2003 Blue Bird All American 1 Gen ∙ Classic Type D ∙ School Bus ∙ FE / RE Bus CUSTOM ORDER F T R S
2004 - 2013 Blue Bird All American 2 Gen Type D ∙ School Bus Bus CUSTOM ORDER F T R S
2014 - 2022 Blue Bird All American 3 Gen Type D ∙ School Bus Bus CUSTOM ORDER F T R S
2023 - 2026 Blue Bird All American 4 Gen Type D ∙ School Bus ∙ Electric Bus CUSTOM ORDER F T R S
1969 AAR Eagle Indy 500 American Airlines REQUEST F T R S
1966 AAR Eagle Mk I Anglo American Racers REQUEST F T R S
1964 AMC Rambler American 2 Doors REQUEST F T R S
1967 AMC Rambler American 220 2-door REQUEST F T R S
1967 AMC Rambler American 220 4-door REQUEST F T R S
1967 AMC Rambler American 220 Station REQUEST F T R S
1965 AMC Rambler American 440 2-door REQUEST F T R S
1967 AMC Rambler American 440 2-door REQUEST F T R S
1967 AMC Rambler American 440 2-door Hardtop REQUEST F T R S
1967 AMC Rambler American 440 4-door REQUEST F T R S
1967 AMC Rambler American 440 Station REQUEST F T R S
1967 AMC Rambler American Rogue 2-door Hardtop REQUEST F T R S
1967 AMC Rambler American Rogue Convertible REQUEST F T R S
1927 American LaFrance American Lafrance REQUEST F T R S
1927 American LaFrance Antonio Lomonaco REQUEST F T R S
American LaFrance Custom REQUEST F T R S
American LaFrance Fire REQUEST F T R S
1922 American LaFrance Fire REQUEST F T R S
1969 American LaFrance Ladder Chief REQUEST F T R S
1981 American LaFrance Ladder Fire REQUEST F T R S
1917 American LaFrance Type 75 Pumper REQUEST F T R S
2006 Ferrari 599 GTB Pan American Brazil REQUEST F T R S
2006 Ferrari 599 GTB Pan American USA REQUEST F T R S
2008 Lola American Le Mans REQUEST F T R S
Other American Lafrance Custom 10 Firetruck REQUEST F T R S
1968 Other Anglo-American Eagle T1G F1 GP REQUEST F T R S
1967 Other Anglo-American Eagle T1G F1 GP REQUEST F T R S
1969 AAR Eagle Indy 500 American Airlines Formula  F T R S
1966 AAR Eagle Mk I Anglo American Racers Formula  F T R S
1966 AAR Eagle Mk1 (T1G) F1 GP Anglo American Racers Formula  F T R S
1966 AAR Eagle Mk1 (T1G) F1 GP Anglo American Racers Formula  F T R S
1967 AMC Rambler American 220 2-door Sedan  F T R S
1963 AMC Rambler American 220 2-Door Station Wagon Wagon  F T R S
1967 AMC Rambler American 220 4-door Sedan  F T R S
1967 AMC Rambler American 220 Station Wagon  F T R S
1967 AMC Rambler American 440 2-door Hardtop Coupe  F T R S
1965 AMC Rambler American 440 2-door Sedan  F T R S
1967 AMC Rambler American 440 2-door Sedan  F T R S
1967 AMC Rambler American 440 4-door Sedan  F T R S
1963 AMC Rambler American 440 4-Door Station Wagon Wagon  F T R S
1967 AMC Rambler American 440 Station Wagon  F T R S
1962 AMC Rambler American DeLuxe 4-Door Sedan Sedan  F T R S
1967 AMC Rambler American Rogue 2-door Hardtop Coupe  F T R S
1967 AMC Rambler American Rogue Convertible Cabriolet  F T R S
American LaFrance Aero Chief 1000 Series Heavy Truck  F T R S
American LaFrance Americam LaFrance Eagle Fire Pumper Truck Heavy Truck  F T R S
2000 American LaFrance Condor 880S Heavy Truck  F T R S
American LaFrance Custom Heavy Truck  F T R S
American LaFrance Custom Pumper 1000 Series Heavy Truck  F T R S
American LaFrance Eagle Fire Truck Heavy Truck  F T R S
American LaFrance Eagle Heavy Truck  F T R S
American LaFrance Eagle Pumper Heavy Truck  F T R S
American LaFrance Fire Heavy Truck  F T R S
1922 American LaFrance Fire Heavy Truck  F T R S
1969 American LaFrance Ladder Chief Heavy Truck  F T R S
1981 American LaFrance Ladder Fire Heavy Truck  F T R S
Eagle American Airlines Indy 500 Tag  F T R S
2006 Ferrari 599 GTB Pan American Brazil Coupe  F T R S
2006 Ferrari 599 GTB Pan American USA Coupe  F T R S
2008 Lola American Le Mans Formula  F T R S
Other American Lafrance Custom 10 Firetruck Heavy Truck  F T R S
1967 Other Anglo-American Eagle T1G F1 GP Formula  F T R S
1968 Other Anglo-American Eagle T1G F1 GP Formula  F T R S


Search Tips

Please write a vehicle make or brand name (e.g., Ford) or just a model name (e.g., Transit) or both make and model name (e.g., Volkswagen Golf). For better search results, please follow these simple rules:

  • ● Check if the brand or model name is written correctly
  • ● Do not specify your search with version (such as GT or Mk.2)
  • ● Do not specify a year (such as 68 Mustang) - just write Mustang
  • ● Please do not enter words such as blueprints, drawings, templates, PDF, etc.
eng
English
arrow
OK
Log in or Create account
For quick login use:
 
or
Create account or Log in
Gmail / Google+
By pressing this button you accept our terms and conditions
or
Use Email
Facebook
Register with FB or go back
Enter your email address to receive personal notifications.
Register with Email or go back
Create your account with an email.
I forgot password or go back
Enter your email address to reset your password.
Enter new password
Enter your new password.