OpenAirDocs.org
Richmor Aviation Inc

Registered aircraft · 17

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

N2999UCessna 172E · S/N 17250599Built 1963 · Hudson, NYN5088LCessna 152 · S/N 15284254Built 1980 · Hudson, NYN5233ECessna 172N · S/N 17271786Built 1978 · Hudson, NYN5357HCessna 152 · S/N 15284092Built 1979 · Hudson, NYN5394BCessna 152 · S/N 15283859Built 1979 · Hudson, NYN5404BCessna 152 · S/N 15283862Built 1979 · Hudson, NYN6379MCessna 152 · S/N 15284701Scotia, NYN63852Cessna 172P · S/N 17275491Built 1981 · Scotia, NYN64281Cessna 172P · S/N 17275541Built 1982 · Scotia, NYN6460LCessna 152 · S/N 15284401Built 1980 · Scotia, NYN68195Cessna 152 · S/N 15282177Built 1978 · Scotia, NYN68920Cessna 152 · S/N 15282403Built 1978 · Hudson, NYN757URCessna 152 · S/N 15280018Built 1977 · Hudson, NYN93529Cessna 152 · S/N 15285510Built 1982 · Hudson, NYN9437DCessna 172RG · S/N 172RG1161Built 1984 · Scotia, NYN94570Cessna 152 · S/N 15285732Built 1983 · Hudson, NYN98795Cessna 172P · S/N 17276357Built 1985 · Scotia, NY
Back to Richmor Aviation Inc