# Registered aircraft: Bethlehem, CT

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

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

- [N108MM](https://openairdocs.org/aircraft/N108MM.md): Stumpf Paul S MURPHY 54C · S/N 2011-54C-2 · Aer Blarney Balloons LLC
- [N1270E](https://openairdocs.org/aircraft/N1270E.md): Aeronca 7AC · S/N 7AC-4828 · Built 1946 · Steiner Zachary J
- [N1558R](https://openairdocs.org/aircraft/N1558R.md): Grumman American Avn. AA-5B · S/N AA5B-0058 · Built 1975 · Taylor Scott Douglas
- [N208DD](https://openairdocs.org/aircraft/N208DD.md): Paul S Stumpf DECKER 54 · S/N 2014-54-1 · Built 2014 · Aer Blarney Balloons LLC
- [N28691](https://openairdocs.org/aircraft/N28691.md): Fairchild 24W-41A · S/N W41A-201 · Built 1941 · Whelan Thomas M
- [N40287](https://openairdocs.org/aircraft/N40287.md): Lindstrand Balloons 25A · S/N 363 · Aer Blarney Balloons LLC
- [N4192M](https://openairdocs.org/aircraft/N4192M.md): Raven S55A · S/N S55A-893 · Built 1982 · Whelan Farms Airport LLC
- [N424AB](https://openairdocs.org/aircraft/N424AB.md): Ultramagic M-90 · S/N 90/227 · Built 2025 · Aer Blarney Balloons LLC
- [N571FL](https://openairdocs.org/aircraft/N571FL.md): Piper PA-28-140 · S/N 28-7125416 · Built 1971 · Simpson Michael J
- [N72891](https://openairdocs.org/aircraft/N72891.md): Cessna 140 · S/N 10085 · Steiner Zachary J
- [N750SH](https://openairdocs.org/aircraft/N750SH.md): Cameron Balloons CAMERON SONIC-90 · S/N 2896 · Built 1992 · Aer Blarney Balloons LLC
- [N772AB](https://openairdocs.org/aircraft/N772AB.md): Ultramagic S A DH-14 · S/N 14/01 · Built 2025 · Aer Blarney Balloons LLC
- [N77330](https://openairdocs.org/aircraft/N77330.md): Cessna 140 · S/N 11772 · Built 1946 · Steiner Zachary J
- [N8745V](https://openairdocs.org/aircraft/N8745V.md): Bellanca 7KCAB · S/N 502-75 · Built 1975 · Whelan Thomas M
- [N89BX](https://openairdocs.org/aircraft/N89BX.md): Brian J Boland POCKET BLIMP · S/N A-3 · Built 1994 · Aer Blarney Balloons LLC
- [N906AB](https://openairdocs.org/aircraft/N906AB.md): Aer Blarney Balloons ATHLONE · S/N AB-002 · Aer Blarney Balloons LLC
- [N945P](https://openairdocs.org/aircraft/N945P.md): Cirrus Design SR22 · S/N 1909 · Built 2006 · Ss Leasing LLC

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

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