/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(4114,28125,28325))
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(4114,28125,28325)) 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) 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(4114,28125,28325) 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(4114,28125,28325) 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 29
?q=AAR Eagle&page=###page###
26
SELECT `id`, `name`, `type` FROM nox_group

Search Results for "AAR Eagle"

 

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: 1 sets of blueprints - 3 vector blueprints - 13 free blueprints (view free blueprints).

Try separate words to find more results: AAR or Eagle.

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

 

All search results - 26 items

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

  Model Views
1966 - 1966 AAR Eagle 101 F1 Formula CUSTOM ORDER F T R S
1967 - 1967 AAR Eagle 104 F1 Formula CUSTOM ORDER F T R S
1966 - 1966 AAR Eagle Mk1 (T1G) F1 GP Anglo American Racers Formula CUSTOM ORDER F T R S
2015 AAR Eagle 4 REQUEST F T R S
1966 AAR Eagle Climax F1 REQUEST F T R S
1969 AAR Eagle Indy 500 REQUEST 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
2025 AAR Eagle Suv REQUEST F T R S
1975 AAR Eagle-Offenhauser Indy 500 REQUEST F T R S
1968 AAR Eagle-Offenhauser Indy 500 REQUEST F T R S
1967 AAR Eagle-Weslake F1 REQUEST F T R S
1967 AAR Eagle-Weslake F1 GP REQUEST F T R S
1966 AAR Eagle 101 F1 Formula  F T R S
1967 AAR Eagle 104 F1 Formula  F T R S
1966 AAR Eagle Climax F1 TEST-DELETE-SIGN Formula  F T R S
1969 AAR Eagle Indy 500 American Airlines Formula  F T R S
1969 AAR Eagle Indy 500 Formula  F T R S
1969 AAR Eagle Indy 500 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
1968 AAR Eagle-Offenhauser Indy 500 Formula  F T R S
1975 AAR Eagle-Offenhauser Indy 500 Formula  F T R S
1967 AAR Eagle-Weslake F1 Formula  F T R S
1967 AAR Eagle-Weslake 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
de
Deutsch
fr
Français
es
Español
it
Italiano
nl
Nederlands
se
Svenska
jp
日本語
OK
Log in or Create account
For quick login use:
 
or
Forgot password?
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.