# Registered aircraft: Crestwood, KY

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

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

- [N1403S](https://openairdocs.org/aircraft/N1403S.md): Cessna 182P · S/N 18264963 · Built 1976 · Farnsworth Scott
- [N187MF](https://openairdocs.org/aircraft/N187MF.md): David Robert Bernard RV-8 · S/N 83162 · Built 2017 · Sherwood Jeffrey W
- [N20RG](https://openairdocs.org/aircraft/N20RG.md): Bombardier BD-700-1A11 · S/N 9190 · Built 2006 · Bsr Aviation LLC
- [N2226X](https://openairdocs.org/aircraft/N2226X.md): Piper PA-28-161 · S/N 28-7916355 · Built 1979 · Omar Rawhi A
- [N230WJ](https://openairdocs.org/aircraft/N230WJ.md): Cirrus Design SR22 · S/N 2539 · Built 2007 · Center Ice Scouting LLC
- [N3213E](https://openairdocs.org/aircraft/N3213E.md): Aeronca 7DC · S/N 7AC-6747 · Redmon Ronald D
- [N3LN](https://openairdocs.org/aircraft/N3LN.md): Cessna 340 · S/N 340-0301 · Built 1973 · Allen Jeffrey W
- [N4142M](https://openairdocs.org/aircraft/N4142M.md): Piper PA-12 · S/N 12-3041 · Built 1947 · Middleton William A Jr
- [N456D](https://openairdocs.org/aircraft/N456D.md): Mosher Rick VANS RV-6A · S/N 21569 · Built 1993 · Slesser Carl J
- [N495CD](https://openairdocs.org/aircraft/N495CD.md): Cirrus Design SR22 · S/N 1605 · Built 2005 · Jl Aviation LLC
- [N50009](https://openairdocs.org/aircraft/N50009.md): Head Balloons AX8-88 · S/N 469 · Built 2019 · Steinbock Thomas C
- [N5789W](https://openairdocs.org/aircraft/N5789W.md): Piper PA-28-150 · S/N 28-1693 · Built 1964 · Lewandowski Robert G
- [N7408P](https://openairdocs.org/aircraft/N7408P.md): Piper PA-24-250 · S/N 24-2595 · Built 1961 · Jeffrey Thomas James
- [N79807](https://openairdocs.org/aircraft/N79807.md): Mooney M20C · S/N 2922 · Built 1964 · Mooney 79807 LLC
- [N841RS](https://openairdocs.org/aircraft/N841RS.md): Dornier DO28 A-1 · S/N 3012 · Built 1961 · Vintage Pursuits LLC
- [N8DQ](https://openairdocs.org/aircraft/N8DQ.md): Williams David C VANS RV-8 · S/N 1003 · Built 2005 · Millett Phillip
- [N9131](https://openairdocs.org/aircraft/N9131.md): Burril Bert A BI-FLY BABY · S/N B1FB · Built 2011 · Redmon Ronald D
- [N926JP](https://openairdocs.org/aircraft/N926JP.md): American Champion 7GCAA · S/N 490-2004 · Built 2004 · Jl Aviation LLC
- [N9306M](https://openairdocs.org/aircraft/N9306M.md): Mooney M20E · S/N 1239 · Built 1966 · V1 Consulting Co
- [N9389V](https://openairdocs.org/aircraft/N9389V.md): Mooney M20C · S/N 700027 · Built 1969 · Allen Jeffrey W

## 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 = 'CRESTWOOD'
ORDER BY g.n_number
```

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