# Registered aircraft: Blanchard, OK

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

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

- [N132HB](https://openairdocs.org/aircraft/N132HB.md): Gregory C Campbell II GSS EXP SUPERCUB · S/N GSS-1 · Campbell Gregory C II
- [N156WT](https://openairdocs.org/aircraft/N156WT.md): Williamsburg Zodiac Flyers ZENITH ZODIAC CH601X · S/N 001 · Built 2007 · Mccurdy Michael
- [N18KF](https://openairdocs.org/aircraft/N18KF.md): Beech A36 · S/N E-1251 · Built 1978 · Nelco Inc
- [N18YZ](https://openairdocs.org/aircraft/N18YZ.md): Cessna 150M · S/N 15076721 · Built 1975 · Hightower Ronny
- [N25998](https://openairdocs.org/aircraft/N25998.md): Cessna 152 · S/N 15280905 · Carlin Delbert J
- [N2669Q](https://openairdocs.org/aircraft/N2669Q.md): Cessna 182K · S/N 18257869 · Built 1966 · Banks Ron E
- [N288RZ](https://openairdocs.org/aircraft/N288RZ.md): Cub Crafters CC18-180 · S/N CC18-0053 · Built 2011 · Bkjm LLC
- [N333LS](https://openairdocs.org/aircraft/N333LS.md): Cessna 172N · S/N 17271006 · Built 1978 · Brown Richard G
- [N335BE](https://openairdocs.org/aircraft/N335BE.md): Canadian Light Acft Sales &Svc BUSHCADDY EXPLORER · S/N BCLSA(AT)148 · Built 2008 · Murphy Lloyd Kevin
- [N42UP](https://openairdocs.org/aircraft/N42UP.md): Hughes Aero PREDATOR · S/N PC090753W403 · Built 2007 · White Gil R
- [N4727S](https://openairdocs.org/aircraft/N4727S.md): Piper PA-32-260 · S/N 32-1166 · Built 1969 · Carlin Delbert J
- [N559MC](https://openairdocs.org/aircraft/N559MC.md): Cessna A185F · S/N 18503479 · Built 1978 · Bkjm LLC
- [N5687T](https://openairdocs.org/aircraft/N5687T.md): Cessna 172E · S/N 17251587 · Built 1964 · Schultz Josh
- [N612CG](https://openairdocs.org/aircraft/N612CG.md): Cessna 421B · S/N 421B0416 · Built 1973 · Casa Grande Homes Inc
- [N6357V](https://openairdocs.org/aircraft/N6357V.md): Alon A2 · S/N A-33 · Built 1965 · Self Robert B
- [N701TS](https://openairdocs.org/aircraft/N701TS.md): Terrance Jeffrey Samsa CH701SP · S/N 7-6005 · Built 2016 · Nobles Columbus A Jr
- [N712AP](https://openairdocs.org/aircraft/N712AP.md): Powrachute AIRWOLF 912ULS · S/N A257ULS · Built 2016 · Holliday Terry A
- [N8100W](https://openairdocs.org/aircraft/N8100W.md): Piper PA-28-180 · S/N 28-2195 · Built 1965 · Waggoner Alan L
- [N85433](https://openairdocs.org/aircraft/N85433.md): Aeronca 7AC · S/N 7AC-4173 · Built 1946 · Sturgell James A
- [N9347N](https://openairdocs.org/aircraft/N9347N.md): Piper PA-28R-200 · S/N 28R-35048 · Built 1969 · Davis Braeden L
- [N984SW](https://openairdocs.org/aircraft/N984SW.md): Piper PA-28-180 · S/N 28-5415 · Built 1969 · Waits Paul C

## 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 = 'OK' AND g.registrant_city = 'BLANCHARD'
ORDER BY g.n_number
```

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