# Registered aircraft: Pelham, AL

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

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

- [N1043Z](https://openairdocs.org/aircraft/N1043Z.md): Mooney M20J · S/N 24-1337 · Built 1982 · Jones Property Services Inc
- [N1206T](https://openairdocs.org/aircraft/N1206T.md): Piper PA-28-180 · S/N 28-7205266 · Built 1972 · Cps 1 LLC
- [N130DG](https://openairdocs.org/aircraft/N130DG.md): Piper PA-28R-200 · S/N 28R-7235127 · Built 1972 · Dixie Aviation LLC
- [N222TB](https://openairdocs.org/aircraft/N222TB.md): Vans RV-12IS · S/N 12102 · Built 2021 · Bevers Bruce S
- [N314TC](https://openairdocs.org/aircraft/N314TC.md): Raytheon HAWKER 800XP · S/N 258400 · Built 1999 · Top Cat Aviation LLC
- [N333CD](https://openairdocs.org/aircraft/N333CD.md): Mooney M20J · S/N 24-3057 · Built 1988 · Ict Flyilng LLC
- [N344RC](https://openairdocs.org/aircraft/N344RC.md): Beech 58 · S/N TH-1412 · Built 1984 · Home Perfection General Contractors Inc
- [N35206](https://openairdocs.org/aircraft/N35206.md): Cessna T182T · S/N T18208089 · Built 2001 · Mosaic Aviation LLC
- [N4581J](https://openairdocs.org/aircraft/N4581J.md): Piper PA-28R-180 · S/N 28R-30450 · Built 1968 · N634mm LLC
- [N4711M](https://openairdocs.org/aircraft/N4711M.md): Piper PA-11 · S/N 11-220 · Built 1947 · Folsom Aubrey C
- [N471MD](https://openairdocs.org/aircraft/N471MD.md): Cessna 525 · S/N 525-0122 · Built 1995 · Citation Management LLC
- [N4945Z](https://openairdocs.org/aircraft/N4945Z.md): Piper PA-22-108 · S/N 22-8541 · Built 1961 · Willis James
- [N531TH](https://openairdocs.org/aircraft/N531TH.md): Cessna 550 · S/N 5500990 · Built 2001 · Crimson Skies LLC
- [N63BE](https://openairdocs.org/aircraft/N63BE.md): Hanson Brian K VANS RV-4 · S/N 2812 · Sutton John S
- [N8009G](https://openairdocs.org/aircraft/N8009G.md): North American/Courtesy A/C T28D · S/N 189-2 · Built 1952 · Boudreaux James S
- [N81140](https://openairdocs.org/aircraft/N81140.md): Grumman American Avn. AA-5B · S/N AA5B0437 · Built 1977 · Ellison Jason Todd
- [N87LP](https://openairdocs.org/aircraft/N87LP.md): Cirrus Design SR22 · S/N 0279 · Built 2002 · Southeastern Transportation LLC
- [N9215S](https://openairdocs.org/aircraft/N9215S.md): Beech C23 · S/N M1711 · Built 1973 · Garner James L DBA
- [N999RK](https://openairdocs.org/aircraft/N999RK.md): Cessna 414 · S/N 414-0610 · Built 1974 · Tcg Aviation 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 = 'AL' AND g.registrant_city = 'PELHAM'
ORDER BY g.n_number
```

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