# Registered aircraft: Airmart Inc

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

- [N157BA](https://openairdocs.org/aircraft/N157BA.md): Beech A36 · S/N E-2339 · Built 1986 · Lexington, KY
- [N161TF](https://openairdocs.org/aircraft/N161TF.md): Piper PA-28-181 · S/N 2881549 · Built 2022 · Lexington, KY
- [N204G](https://openairdocs.org/aircraft/N204G.md): Raytheon 58 · S/N TH-2042 · Lexington, KY
- [N216AM](https://openairdocs.org/aircraft/N216AM.md): Piper PA-28-181 · S/N 2881092 · Lexington, KY
- [N232TF](https://openairdocs.org/aircraft/N232TF.md): Piper PA-28-181 · S/N 2881550 · Built 2022 · Lexington, KY
- [N277CP](https://openairdocs.org/aircraft/N277CP.md): Piper PA-28 · S/N 28-12 · Built 1961 · Lexington, KY
- [N357KF](https://openairdocs.org/aircraft/N357KF.md): Cessna 182S · S/N 18280189 · Built 1998 · Lexington, KY
- [N36965](https://openairdocs.org/aircraft/N36965.md): Raytheon G36 · S/N E-3665 · Lexington, KY
- [N424TF](https://openairdocs.org/aircraft/N424TF.md): Piper PA-28-181 · S/N 2881552 · Built 2022 · Lexington, KY
- [N429M](https://openairdocs.org/aircraft/N429M.md): Beechcraft G58 · S/N TH-2422 · Built 2014 · Lexington, KY
- [N43711](https://openairdocs.org/aircraft/N43711.md): Piper PA-28-151 · S/N 28-7415562 · Built 1974 · Lexington, KY
- [N450TF](https://openairdocs.org/aircraft/N450TF.md): Cessna LC41-550FG · S/N 411025 · Built 2008 · Lexington, KY
- [N469TF](https://openairdocs.org/aircraft/N469TF.md): Piper PA-28-181 · S/N 2881592 · Built 2022 · Lexington, KY
- [N478MD](https://openairdocs.org/aircraft/N478MD.md): Piper PA-32R-301T · S/N 3257376 · Built 2005 · Lexington, KY
- [N613SP](https://openairdocs.org/aircraft/N613SP.md): Cessna 172S · S/N 172S8597 · Built 2000 · Lexington, KY
- [N619AM](https://openairdocs.org/aircraft/N619AM.md): Piper PA-28-181 · S/N 2881093 · Lexington, KY
- [N7CM](https://openairdocs.org/aircraft/N7CM.md): Textron G36 · S/N E-4091 · Built 2016 · Lexington, KY

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

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