# Registered aircraft: Richmor Aviation Inc

A list on [Richmor Aviation Inc](https://openairdocs.org/faa-owner/RICHMOR%20AVIATION%20INC.md).

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

- [N2999U](https://openairdocs.org/aircraft/N2999U.md): Cessna 172E · S/N 17250599 · Built 1963 · Hudson, NY
- [N5088L](https://openairdocs.org/aircraft/N5088L.md): Cessna 152 · S/N 15284254 · Built 1980 · Hudson, NY
- [N5233E](https://openairdocs.org/aircraft/N5233E.md): Cessna 172N · S/N 17271786 · Built 1978 · Hudson, NY
- [N5357H](https://openairdocs.org/aircraft/N5357H.md): Cessna 152 · S/N 15284092 · Built 1979 · Hudson, NY
- [N5394B](https://openairdocs.org/aircraft/N5394B.md): Cessna 152 · S/N 15283859 · Built 1979 · Hudson, NY
- [N5404B](https://openairdocs.org/aircraft/N5404B.md): Cessna 152 · S/N 15283862 · Built 1979 · Hudson, NY
- [N6379M](https://openairdocs.org/aircraft/N6379M.md): Cessna 152 · S/N 15284701 · Scotia, NY
- [N63852](https://openairdocs.org/aircraft/N63852.md): Cessna 172P · S/N 17275491 · Built 1981 · Scotia, NY
- [N64281](https://openairdocs.org/aircraft/N64281.md): Cessna 172P · S/N 17275541 · Built 1982 · Scotia, NY
- [N6460L](https://openairdocs.org/aircraft/N6460L.md): Cessna 152 · S/N 15284401 · Built 1980 · Scotia, NY
- [N68195](https://openairdocs.org/aircraft/N68195.md): Cessna 152 · S/N 15282177 · Built 1978 · Scotia, NY
- [N68920](https://openairdocs.org/aircraft/N68920.md): Cessna 152 · S/N 15282403 · Built 1978 · Hudson, NY
- [N757UR](https://openairdocs.org/aircraft/N757UR.md): Cessna 152 · S/N 15280018 · Built 1977 · Hudson, NY
- [N93529](https://openairdocs.org/aircraft/N93529.md): Cessna 152 · S/N 15285510 · Built 1982 · Hudson, NY
- [N9437D](https://openairdocs.org/aircraft/N9437D.md): Cessna 172RG · S/N 172RG1161 · Built 1984 · Scotia, NY
- [N94570](https://openairdocs.org/aircraft/N94570.md): Cessna 152 · S/N 15285732 · Built 1983 · Hudson, NY
- [N98795](https://openairdocs.org/aircraft/N98795.md): Cessna 172P · S/N 17276357 · Built 1985 · Scotia, NY

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

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

This list as a web page: https://openairdocs.org/faa-owner/RICHMOR%20AVIATION%20INC/aircraft

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.