Skip to content

Spirit Engineering Inc

Registered aircraft · 43

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 = 'SPIRIT ENGINEERING INC' OR list_contains(g.other_registrant_names, 'SPIRIT ENGINEERING 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 = 'SPIRIT ENGINEERING INC' OR list_contains(g.other_registrant_names, 'SPIRIT ENGINEERING 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 = 'SPIRIT ENGINEERING INC' OR list_contains(g.other_registrant_names, 'SPIRIT ENGINEERING 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.

N102ESSpirit Engineering SE-1 · S/N 046Grand Junction, CO N111ESSpirit Engineering SE-1 · S/N 047Grand Junction, CO N112SESpirit Engineering SE-1 · S/N 002Built 2025 · Grand Junction, CO N113SESpirit Engineering SE-1 · S/N 001Built 2024 · Grand Junction, CO N114ESSpirit Engineering SE-1 · S/N 048Grand Junction, CO N120ESSpirit Engineering SE-1 · S/N 049Grand Junction, CO N124ESSpirit Engineering SE-1 · S/N 050Grand Junction, CO N128ESSpirit Engineering SE-1 · S/N 051Grand Junction, CO N132ESSpirit Engineering SE-1 · S/N 052Grand Junction, CO N141ESSpirit Engineering SE-1 · S/N 053Grand Junction, CO N143ESSpirit Engineering SE-1 · S/N 054Grand Junction, CO N145ESSpirit Engineering SE-1 · S/N 055Grand Junction, CO N151ESSpirit Engineering SE-1 · S/N 056Grand Junction, CO N155ESSpirit Engineering SE-1 · S/N 057Grand Junction, CO N177ESSpirit Engineering SE-1 · S/N 058Grand Junction, CO N187ESSpirit Engineering SE-1 · S/N 059Grand Junction, CO N188ESSpirit Engineering SE-1 · S/N 060Grand Junction, CO N302ESSpirit Engineering SE-1 · S/N 061Grand Junction, CO N304ESSpirit Engineering SE-1 · S/N 062Grand Junction, CO N305ESSpirit Engineering SE-1 · S/N 063Grand Junction, CO N308ESSpirit Engineering SE-1 · S/N 064Grand Junction, CO N325ESSpirit Engineering SE-1 · S/N 065Grand Junction, CO N4007PSpirit Engineering SE-1 · S/N 008Built 2025 · Grand Junction, CO N4024VSpirit Engineering SE-1 · S/N 016Built 2025 · Grand Junction, CO N4028FSpirit Engineering SE-1 · S/N 024Grand Junction, CO N5014QSpirit Engineering SE-1 · S/N 029Grand Junction, CO N5014VSpirit Engineering SE-1 · S/N 030Grand Junction, CO N5014YSpirit Engineering SE-1 · S/N 031Grand Junction, CO N5015ASpirit Engineering SE-1 · S/N 032Grand Junction, CO N5015DSpirit Engineering SE-1 · S/N 033Grand Junction, CO N5015ESpirit Engineering SE-1 · S/N 034Grand Junction, CO N5015FSpirit Engineering SE-1 · S/N 035Grand Junction, CO N5015GSpirit Engineering SE-1 · S/N 036Grand Junction, CO N5015JSpirit Engineering SE-1 · S/N 037Grand Junction, CO N5015RSpirit Engineering SE-1 · S/N 039Grand Junction, CO N5015SSpirit Engineering SE-1 · S/N 040Grand Junction, CO N5015USpirit Engineering SE-1 · S/N 041Grand Junction, CO N5015XSpirit Engineering SE-1 · S/N 042Grand Junction, CO N5015YSpirit Engineering SE-1 · S/N 043Grand Junction, CO N5016BSpirit Engineering SE-1 · S/N 044Grand Junction, CO N5016ESpirit Engineering SE-1 · S/N 045Grand Junction, CO N649BBeech D18S · S/N A-454Built 1948 · Grand Junction, CO N9236TCessna 180C · S/N 50736Built 1960 · Grand Junction, CO

Back to Spirit Engineering Inc