# Registered aircraft: Kingsburg, CA

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

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

- [N178JL](https://openairdocs.org/aircraft/N178JL.md): Cubcrafters CC11-160 · S/N CC11-00195 · Built 2011 · K Prop LLC
- [N182LE](https://openairdocs.org/aircraft/N182LE.md): Cessna 182P · S/N 18263959 · Built 1975 · Superior Machine Works Inc
- [N261AT](https://openairdocs.org/aircraft/N261AT.md): Cirrus Design SR22T · S/N 9037 · Built 2023 · Dmm Aviation 1 LLC
- [N2647P](https://openairdocs.org/aircraft/N2647P.md): Piper PA-22 · S/N 22-2985 · Built 1955 · Trinkle Aviation LLC
- [N2944W](https://openairdocs.org/aircraft/N2944W.md): Bell 206B · S/N 748 · Built 1971 · Trinkle Avition LLC
- [N3224M](https://openairdocs.org/aircraft/N3224M.md): Piper PA-12 · S/N 12-2023 · Built 1947 · Gazarian Kevin A
- [N34AE](https://openairdocs.org/aircraft/N34AE.md): Bell Helicopter Textron 206L-1 · S/N 45218 · Built 1979 · Trinkle Aviation LLC
- [N377WT](https://openairdocs.org/aircraft/N377WT.md): Piper PA-34-200T · S/N 34-8070283 · Built 1980 · Aaronian Randall
- [N47397](https://openairdocs.org/aircraft/N47397.md): Fairchild M-62A · S/N T411274 · Registration revoked · Built 1941 · Discoe Alexander
- [N602JW](https://openairdocs.org/aircraft/N602JW.md): Air Tractor AT-602 · S/N 602-0409 · Built 1997 · Trinkle Aviation LLC
- [N60BH](https://openairdocs.org/aircraft/N60BH.md): Campbell Collin K BEARHAWK 5 · S/N 5029 · Built 2022 · Landrock Real Estate Inc
- [N6176L](https://openairdocs.org/aircraft/N6176L.md): Air Tractor AT-502A · S/N 502A-0352 · Built 1996 · Trinkle Aviation LLC
- [N61931](https://openairdocs.org/aircraft/N61931.md): Boeing PT-17 · S/N 75-2549 · Trinkle Mark
- [N6258N](https://openairdocs.org/aircraft/N6258N.md): Cessna 340A · S/N 340A0449 · Built 1978 · Tango Victor Aviation LLC
- [N66JP](https://openairdocs.org/aircraft/N66JP.md): Cirrus Design SR20 · S/N 1269 · Built 2003 · Epic Freedom LLC
- [N733SU](https://openairdocs.org/aircraft/N733SU.md): Cessna 172N · S/N 17268519 · Built 1977 · Rosas Milton A
- [N761LG](https://openairdocs.org/aircraft/N761LG.md): Cessna T210M · S/N 21062336 · Trinkle Aviation LLC
- [N778TD](https://openairdocs.org/aircraft/N778TD.md): Crinklaw Farm Service CCX-1865 · S/N CCX-1865-0041 · Built 2006 · Crinklaw Farm Service Inc
- [N8004](https://openairdocs.org/aircraft/N8004.md): Helio H800 · S/N H-4 · Registration pending · Built 1983
- [N885BH](https://openairdocs.org/aircraft/N885BH.md): Cessna 560XL · S/N 560-5717 · Built 2007 · West Star Construction 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 = 'CA' AND g.registrant_city = 'KINGSBURG'
ORDER BY g.n_number
```

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