# Registered aircraft: Bear, DE

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

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

- [N1454C](https://openairdocs.org/aircraft/N1454C.md): Cessna 177B · S/N 17702731 · Built 1977 · Freespirit Ventures LLC
- [N204BA](https://openairdocs.org/aircraft/N204BA.md): Icon A5 · S/N 00082 · Built 2019 · Peeples Christopher
- [N300TC](https://openairdocs.org/aircraft/N300TC.md): Israel Aircraft Industries 1124 · S/N 241 · Built 1978 · Orlando Financial Corp
- [N5440](https://openairdocs.org/aircraft/N5440.md): Morane-Saulnier 733 · S/N 40 · Built 1954 · Adventure Air LLC
- [N5474T](https://openairdocs.org/aircraft/N5474T.md): Cessna 172E · S/N 17251374 · Built 1964 · Tisdell Branden L
- [N56JC](https://openairdocs.org/aircraft/N56JC.md): Smith RAND KR2 · S/N TAS-1 · Smith Jonathan L
- [N6154Q](https://openairdocs.org/aircraft/N6154Q.md): Cessna 152 · S/N 15285174 · Built 1981 · Viman LLC
- [N620AJ](https://openairdocs.org/aircraft/N620AJ.md): North American AT-6C · S/N 8814161 · Built 1944 · Fancy Sparks Aviation LLC
- [N630HC](https://openairdocs.org/aircraft/N630HC.md): Piper PA-28-181 · S/N 28-8090268 · Built 1980 · Dgsz Aero Inc
- [N6432K](https://openairdocs.org/aircraft/N6432K.md): Republic RC-3 · S/N 682 · Built 1947 · Dicecco Thomas III
- [N6941S](https://openairdocs.org/aircraft/N6941S.md): Cessna 150H · S/N 15067641 · Browning Stephen D
- [N7005G](https://openairdocs.org/aircraft/N7005G.md): Cessna 172K · S/N 17258705 · Built 1969 · Hamilton Peter D
- [N7066H](https://openairdocs.org/aircraft/N7066H.md): Piper J3C-65 · S/N 20317 · Built 1946 · Hetterly Mark
- [N759F](https://openairdocs.org/aircraft/N759F.md): Compagnie Daher TB 30 EPSILON · S/N 133 · Built 1988 · Silver Fox Aviation LLC
- [N8007X](https://openairdocs.org/aircraft/N8007X.md): Air Tractor AT-802A · S/N 802A-0869 · Built 2020 · Baylee Company Inc
- [N8040G](https://openairdocs.org/aircraft/N8040G.md): Air Tractor AT-802A · S/N 802A-1099 · Built 2024 · Baylee Company
- [N8487S](https://openairdocs.org/aircraft/N8487S.md): Cessna 182H · S/N 18256587 · Built 1965 · Yoder Dwight D
- [N9342F](https://openairdocs.org/aircraft/N9342F.md): Cessna 182S · S/N 18280105 · Built 1998 · Churchill David J
- [N9662Q](https://openairdocs.org/aircraft/N9662Q.md): Cessna 172M · S/N 17265746 · Built 1975 · Homiller Robert S

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

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