How many Airspeed Fleet Shadower aircraft are retired?
CREATE TABLE table_824 (
    "Aircraft type" text,
    "National Origin" text,
    "1st Flight" real,
    "In Service" text,
    "Retired" text,
    "# built" text
)
SELECT "Retired" FROM table_824 WHERE "Aircraft type" = 'Airspeed Fleet Shadower'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many Airspeed Fleet Shadower aircraft are retired? ### Input: CREATE TABLE table_824 (
    "Aircraft type" text,
    "National Origin" text,
    "1st Flight" real,
    "In Service" text,
    "Retired" text,
    "# built" text
) ### Response: SELECT "Retired" FROM table_824 WHERE "Aircraft type" = 'Airspeed Fleet Shadower'