Skip to content

Firestorm Labs Inc

Registered aircraft · 34

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'FIRESTORM LABS INC' OR list_contains(g.other_registrant_names, 'FIRESTORM LABS INC') ORDER BY g.n_number

duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'FIRESTORM LABS INC' OR list_contains(g.other_registrant_names, 'FIRESTORM LABS INC')
  ORDER BY g.n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_name = 'FIRESTORM LABS INC' OR list_contains(g.other_registrant_names, 'FIRESTORM LABS INC')
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N201TBFirestorm Labs TEMPEST BETA 2 · S/N B2-018San Diego, CA N2025FFirestorm Labs TEMPEST BETA 2 · S/N B2-025San Diego, CA N2026FFirestorm Labs TEMPEST BETA 2 · S/N B2-026San Diego, CA N2034FFirestorm Labs TEMPEST BETA 2 · S/N B2-034San Diego, CA N2036Firestorm Labs TEMPEST BETA 2 · S/N B2-036San Diego, CA N204FLFirestorm Labs TEMPEST BETA 2 · S/N B2-040San Diego, CA N245FSFirestorm Labs TEMPEST BETA 2 · S/N B2-00049San Diego, CA N256FSFirestorm Labs TEMPEST BETA 2 · S/N B2-00048San Diego, CA N326FSFirestorm Labs TEMPEST BETA 2 · S/N B2-00066San Diego, CA N345FSFirestorm Labs TEMPEST BETA 2 · S/N B2-00046San Diego, CA N432FSFirestorm Labs TEMPEST BETA 2 · S/N B2-00065San Diego, CA N475FSFirestorm Labs TEMPEST BETA 2 · S/N B2-00068San Diego, CA N4891FFirestorm Labs TEMPEST BETA 2 · S/N 1849E030AF7EE908E0ASan Diego, CA N4892FFirestorm Labs TEMPEST BETA 2 · S/N 1849E074B839B26DF1PSan Diego, CA N4893FFirestorm Labs TEMPEST BETA 2 · S/N 1849E074B8399FDF9C6San Diego, CA N4894FFirestorm Labs TEMPEST BETA 2 · S/N 1849E074B8399FB280RSan Diego, CA N4895FFirestorm Labs TEMPEST BETA 2 · S/N 1849E074B8399A01A28San Diego, CA N4897RFirestorm Labs TEMPEST BETA 2 · S/N 1849E074B8399FF200VSan Diego, CA N4899FFirestorm Labs TEMPEST BETA 2 TURBO · S/N 1849E074B83999DED4YSan Diego, CA N489YFFirestorm Labs TEMPEST BETA 2 · S/N 1849E074B839B129A34San Diego, CA N490BFFirestorm Labs TEMPEST BETA 2 TURBO · S/N 1849E074B893A03D1DMSan Diego, CA N524NFFirestorm Labs TEMPEST BETA 2 · S/N B2-039San Diego, CA N524QAFirestorm Labs TEMPEST BETA 2 · S/N B2-038San Diego, CA N524UAFirestorm Labs TEMPEST BETA 2 · S/N B2-037San Diego, CA N567FSFirestorm Labs TEMPEST BETA 2 · S/N B2-00047San Diego, CA N589FSFirestorm Labs TEMPEST BETA 2 · S/N B2-00069San Diego, CA N654FSFirestorm Labs TEMPEST BETA 2 · S/N B2-00064San Diego, CA N732FSFirestorm Labs TEMPEST BETA 2 TURBO · S/N B2-00057San Diego, CA N873FSFirestorm Labs TEMPEST BETA 2 · S/N B2-00051San Diego, CA N921FSFirestorm Labs TEMPEST BETA 2 · S/N B2-00067San Diego, CA N9431Firestorm Labs TEMPEST BETA 2 · S/N B2-041San Diego, CA N9431DFirestorm Labs TEMPEST BETA 2 · S/N B2-035San Diego, CA N965FSFirestorm Labs TEMPEST BETA 2 · S/N B2-00050San Diego, CA N987FSFirestorm Labs TEMPEST BETA 2 · S/N B2-00052San Diego, CA

Back to Firestorm Labs Inc