Registered aircraft · 25

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 = 'JSTREAM LC' OR list_contains(g.other_registrant_names, 'JSTREAM LC') 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 = 'JSTREAM LC' OR list_contains(g.other_registrant_names, 'JSTREAM LC')
  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 = 'JSTREAM LC' OR list_contains(g.other_registrant_names, 'JSTREAM LC')
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.

N10728Hiller UH-12C · S/N 798Built 1956 · Sheridan, WY N12UHHiller UH-12E · S/N 1395Built 1962 · Sheridan, WY N1338UCessna 411 · S/N 411-0105Built 1965 · Sheridan, WY N1642NFunk B85C · S/N 422Built 1947 · Sheridan, WY N24166Funk B75L · S/N 191Sheridan, WY N24180Mcclish FUNK B75L · S/N 206Built 1940 · Sheridan, WY N3694SCessna 172E · S/N 17250894Built 1963 · Sheridan, WY N456DWWayne Dwight RV-6 · S/N 21040Sheridan, WY N48847Taylorcraft DC-65 · S/N 4006Built 1941 · Sheridan, WY N51108Cessna 150J · S/N 15069772Built 1968 · Sheridan, WY N51134Cessna 150J · S/N 15069785Built 1968 · Sheridan, WY N5192DCessna 182A · S/N 51292Built 1958 · Sheridan, WY N5326VHiller UH-12C · S/N 865Built 1956 · Sheridan, WY N5822PPiper PA-24-250 · S/N 24-903Built 1959 · Sheridan, WY N60307Cessna 150J · S/N 15070214Sheridan, WY N61120Cessna 150J · S/N 15070814Built 1969 · Sheridan, WY N6114RCessna 210F · S/N T210-0014Sheridan, WY N7156BPiper PA-22-150 · S/N 22-4381Sheridan, WY N77720Funk B85C · S/N 350Built 1946 · Sheridan, WY N77722Mcclish FUNK B85C · S/N 352Built 1946 · Sheridan, WY N7974ECessna 150 · S/N 17774Built 1959 · Sheridan, WY N79896Cessna 172K · S/N 17258231Built 1969 · Sheridan, WY N81108Funk B75L · S/N 238Sheridan, WY N8230TCessna 175B · S/N 17556930Built 1960 · Sheridan, WY N8727GCessna 150F · S/N 15062827Built 1966 · Sheridan, WY

Back to Jstream Lc