# Registered aircraft: Rick Aviation Inc

A list on [Rick Aviation Inc](https://openairdocs.org/faa-owner/RICK%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.

- [N139ER](https://openairdocs.org/aircraft/N139ER.md): Cessna 172P · S/N 17276532 · Built 1985 · Newport News, VA
- [N52438](https://openairdocs.org/aircraft/N52438.md): Cessna 172P · S/N 17274522 · Built 1980 · Newport News, VA
- [N52720](https://openairdocs.org/aircraft/N52720.md): Cessna 172P · S/N 17274592 · Built 1981 · Newport News, VA
- [N53794](https://openairdocs.org/aircraft/N53794.md): Cessna 172P · S/N 17274816 · Built 1981 · Newport News, VA
- [N54357](https://openairdocs.org/aircraft/N54357.md): Cessna 172P · S/N 17274962 · Newport News, VA
- [N54576](https://openairdocs.org/aircraft/N54576.md): Cessna 172P · S/N 17275003 · Newport News, VA
- [N5463K](https://openairdocs.org/aircraft/N5463K.md): Cessna 172P · S/N 17274129 · Built 1980 · Newport News, VA
- [N55179](https://openairdocs.org/aircraft/N55179.md): Cessna 172P · S/N 17275128 · Built 1981 · Newport News, VA
- [N5528G](https://openairdocs.org/aircraft/N5528G.md): Cessna 150J · S/N 15071028 · Built 1969 · Newport News, VA
- [N5UZ](https://openairdocs.org/aircraft/N5UZ.md): Piper PA-44-180T · S/N 44-8107008 · Built 1980 · Newport News, VA
- [N6412F](https://openairdocs.org/aircraft/N6412F.md): Cessna 172N · S/N 17273220 · Built 1979 · Newport News, VA
- [N676TG](https://openairdocs.org/aircraft/N676TG.md): Beech 95-B55 (T42A) · S/N TC-676 · Built 1964 · Newport News, VA
- [N7320F](https://openairdocs.org/aircraft/N7320F.md): Cessna 172N · S/N 17273243 · Built 1979 · Newport News, VA
- [N733AG](https://openairdocs.org/aircraft/N733AG.md): Cessna 172N · S/N 17268140 · Built 1976 · Newport News, VA
- [N733QJ](https://openairdocs.org/aircraft/N733QJ.md): Cessna 172N · S/N 17268463 · Built 1976 · Newport News, VA
- [N737GR](https://openairdocs.org/aircraft/N737GR.md): Cessna 172N · S/N 17269411 · Built 1977 · Newport News, VA
- [N738HX](https://openairdocs.org/aircraft/N738HX.md): Cessna 172N · S/N 17270000 · Built 1977 · Newport News, VA
- [N8264F](https://openairdocs.org/aircraft/N8264F.md): Piper PA-44-180T · S/N 44-8107027 · Built 1980 · Newport News, VA
- [N9035S](https://openairdocs.org/aircraft/N9035S.md): Beech 95-B55 (T42A) · S/N TC-956 · Built 1965 · Newport News, VA
- [N9262C](https://openairdocs.org/aircraft/N9262C.md): Piper PA-28R-201 · S/N 28R-7837183 · Built 1978 · Newport News, VA
- [N97358](https://openairdocs.org/aircraft/N97358.md): Cessna 172P · S/N 17276180 · Built 1984 · Newport News, VA
- [N97883](https://openairdocs.org/aircraft/N97883.md): Cessna 172P · S/N 17276237 · Built 1984 · Newport News, VA

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

This list as a web page: https://openairdocs.org/faa-owner/RICK%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.