Skip to content

Spartan Education LLC

Registered aircraft · 54

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 = 'SPARTAN EDUCATION LLC' OR list_contains(g.other_registrant_names, 'SPARTAN EDUCATION LLC') 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 = 'SPARTAN EDUCATION LLC' OR list_contains(g.other_registrant_names, 'SPARTAN EDUCATION LLC')
  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 = 'SPARTAN EDUCATION LLC' OR list_contains(g.other_registrant_names, 'SPARTAN EDUCATION LLC')
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.

N152SQCessna 152 · S/N 15284185Built 1980 · Tulsa, OK N2168DCessna 172S · S/N 172S9649Built 2004 · Tulsa, OK N225WSCessna 172S · S/N 172S9800Built 2005 · Tulsa, OK N24708Cessna 152 · S/N 15280332Built 1977 · Tulsa, OK N25CWCessna 172S · S/N 172S9875Built 2005 · Tulsa, OK N268DAPiper PA-44-180 · S/N 4496135Built 2002 · Tulsa, OK N3103EPiper PA-44-180 · S/N 4496188Built 2004 · Tulsa, OK N315DMCessna 172S · S/N 172S9574Built 2004 · Tulsa, OK N406JACessna 172S · S/N 172S10628Built 2007 · Tulsa, OK N48568Cessna 152 · S/N 15283350Built 1979 · Tulsa, OK N505SCPiper PA-28-181 · S/N 2881420Built 2020 · Tulsa, OK N507SCPiper PA-28-181 · S/N 2881421Built 2020 · Tulsa, OK N517SCPiper PA-28-181 · S/N 2881264Built 2019 · Tulsa, OK N522NDCessna 172S · S/N 172S10977Built 2009 · Tulsa, OK N524SCPiper PA-28-181 · S/N 2881265Built 2019 · Tulsa, OK N526NDCessna 172S · S/N 172S11063Built 2010 · Tulsa, OK N527SCPiper PA-28-181 · S/N 2881319Tulsa, OK N5290VCessna 172S · S/N 172S11025Built 2010 · Tulsa, OK N530PSCessna 172S · S/N 172S9859Built 2005 · Tulsa, OK N5335SCessna 172S · S/N 172S9349Built 2003 · Tulsa, OK N534SCPiper PA-28-181 · S/N 2881320Tulsa, OK N536SCPiper PA-28-181 · S/N 2881321Tulsa, OK N537NDCessna 172S · S/N 172S10990Built 2009 · Tulsa, OK N538SCPiper PA-28-181 · S/N 2881431Built 2021 · Tulsa, OK N546NDCessna 172S · S/N 172S11045Built 2010 · Tulsa, OK N547NDCessna 172S · S/N 172S11049Built 2010 · Tulsa, OK N547SCPiper PA-28-181 · S/N 2881322Tulsa, OK N548SCPiper PA-28-181 · S/N 2881340Built 2020 · Tulsa, OK N549NDCessna 172S · S/N 172S11051Built 2010 · Tulsa, OK N549SCPiper PA-28-181 · S/N 2881341Built 2020 · Tulsa, OK N553SCPiper PA-28-181 · S/N 2881342Built 2020 · Tulsa, OK N556SCPiper PA-28-181 · S/N 2881343Built 2020 · Tulsa, OK N561NDCessna 172S · S/N 172S11099Built 2011 · Tulsa, OK N561SCPiper PA-28-181 · S/N 2881399Built 2020 · Tulsa, OK N562NDCessna 172S · S/N 172S11100Built 2011 · Tulsa, OK N563SCPiper PA-28-181 · S/N 2881400Built 2020 · Tulsa, OK N570SCPiper PA-28-181 · S/N 2881401Built 2020 · Tulsa, OK N578SCPiper PA-28-181 · S/N 2881402Built 2020 · Tulsa, OK N584SCPiper PA-28-181 · S/N 2881403Built 2020 · Tulsa, OK N589SCPiper PA-28-181 · S/N 2881407Built 2020 · Tulsa, OK N593SCPiper PA-28-181 · S/N 2881408Built 2020 · Tulsa, OK N596SCPiper PA-28-181 · S/N 2881409Built 2020 · Tulsa, OK N597SCPiper PA-28-181 · S/N 2881410Built 2020 · Tulsa, OK N598SCPiper PA-28-181 · S/N 2881411Built 2020 · Tulsa, OK N619SCPiper PA-28-181 · S/N 2881432Built 2021 · Tulsa, OK N632SCPiper PA-28-181 · S/N 2881433Built 2021 · Tulsa, OK N635SCPiper PA-28-181 · S/N 2881434Built 2021 · Tulsa, OK N667SCPiper PA-28-181 · S/N 2881435Built 2021 · Tulsa, OK N670SCPiper PA-28-181 · S/N 2881436Built 2021 · Tulsa, OK N673SCPiper PA-28-181 · S/N 2881438Built 2021 · Tulsa, OK

Back to Spartan Education LLC