Registered aircraft · 21

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

N121KTDehavilland DHC-2 MK. I(L20A) · S/N 1407Built 1958 · Anchorage, AK N122KTPiper PA-32-300 · S/N 32-7940190Anchorage, AK N125KTCessna A185F · S/N 18503494Built 1977 · Anchorage, AK N1292FCessna A185F · S/N 18502668Built 1975 · Anchorage, AK N232KTDehavilland DHC-2 MK 1 · S/N 52Built 1948 · Anchorage, AK N2740XDehavilland-Kenmore DHC-2 · S/N 579Built 1953 · Anchorage, AK N2899JDehavilland DHC-3 · S/N 425Built 1961 · Anchorage, AK N320KTDehavilland DHC-3 · S/N 73Built 1956 · Anchorage, AK N343KTDehavilland DHC 2 MK III · S/N 1623TB-14Built 1965 · Anchorage, AK N424KTDehavilland DHC-3 · S/N 338Built 1958 · Anchorage, AK N4444ZDehavilland DHC-2 · S/N 1307Built 1958 · Anchorage, AK N4596UCessna U206G · S/N U20604990Built 1979 · Anchorage, AK N4661ZCessna U206G · S/N U20605998Built 1980 · Anchorage, AK N4891ZCessna U206G · S/N U20606044Built 1980 · Anchorage, AK N4899RDehavilland Canada DHC-3 · S/N 353Built 1960 · Anchorage, AK N626KTCessna U206G · S/N U20604426Anchorage, AK N636KTDehavilland DHC-3 · S/N 451Anchorage, AK N727KTDehavilland DHC-3 · S/N 419Built 1961 · Anchorage, AK N865HPCessna 208 · S/N 20800289Built 1998 · Anchorage, AK N929KTDehavilland DHC-3 · S/N 461Built 1965 · Anchorage, AK N99GAGippsaero PTY GA8 TC-320 · S/N GA-8-TC320-12-173Built 2012 · Anchorage, AK

Back to Rustair Inc