# Registered aircraft: Mayfield, KY

A list on [Mayfield, KY](https://openairdocs.org/faa-place/KY/Mayfield.md).

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N102JA](https://openairdocs.org/aircraft/N102JA.md): Johnny Allen ALLENCRAFT II · S/N JBA123 · Allen Johnny B
- [N11514](https://openairdocs.org/aircraft/N11514.md): Cessna 150L · S/N 15075476 · Built 1974 · Kickstart Aviation LLC
- [N121WE](https://openairdocs.org/aircraft/N121WE.md): Textron 172S · S/N 172S12322 · Built 2019 · Midwest Aviation Inc
- [N124WE](https://openairdocs.org/aircraft/N124WE.md): Textron 172S · S/N 172S12393 · Built 2019 · Midwest Aviation Inc
- [N19154](https://openairdocs.org/aircraft/N19154.md): Cessna 150L · S/N 15074203 · Built 1972 · Yt Enterprices LLC
- [N20TA](https://openairdocs.org/aircraft/N20TA.md): Piper PA-28-181 · S/N 2843677 · Built 2010 · Midwest Aviation Inc
- [N291KY](https://openairdocs.org/aircraft/N291KY.md): Pilatus PC-12/47E · S/N 2091 · Built 2021 · Valera LLC
- [N441PM](https://openairdocs.org/aircraft/N441PM.md): Cessna 441 · S/N 441-0124 · Built 1980 · Jtg Enterprises LLC
- [N570CA](https://openairdocs.org/aircraft/N570CA.md): American Champion 8GCBC · S/N 528-2010 · Built 2010 · Midwest Aviation Inc
- [N617CC](https://openairdocs.org/aircraft/N617CC.md): Cessna 421C · S/N 421C0897 · Riley Livestock Inc
- [N642WZ](https://openairdocs.org/aircraft/N642WZ.md): Wallace Donald A RV9A · S/N 90536 · Map Enterprises Inc
- [N690BY](https://openairdocs.org/aircraft/N690BY.md): Robinson Helicopter R66 · S/N 1139 · Built 2022 · Kyfab LLC
- [N700AC](https://openairdocs.org/aircraft/N700AC.md): Piper AEROSTAR 601P · S/N 61P08018063412 · Built 1980 · 4sons LLC
- [N732ZU](https://openairdocs.org/aircraft/N732ZU.md): Cessna 210M · S/N 21061912 · Built 1977 · Map Enterprises Inc
- [N747CT](https://openairdocs.org/aircraft/N747CT.md): Cirrus Design SR22 · S/N 4485 · Built 2017 · N747ct LLC
- [N758QV](https://openairdocs.org/aircraft/N758QV.md): Cessna R172K · S/N R1723284 · Built 1979 · Midwest Aviation Inc
- [N85AX](https://openairdocs.org/aircraft/N85AX.md): Hawker Beechcraft G36 · S/N E-3876 · Built 2008 · Midwest Aviation Inc
- [N929DB](https://openairdocs.org/aircraft/N929DB.md): Robinson Helicopter R44 II · S/N 13603 · Riley Livestock Inc

## 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_state = 'KY' AND g.registrant_city = 'MAYFIELD'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/KY/Mayfield/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.