# Registered aircraft: Trussville, AL

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

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

- [N11AW](https://openairdocs.org/aircraft/N11AW.md): Linn Robert LANCAIR IV-PROPJET · S/N LIV-537 · Built 2004 · Roseland LLC
- [N14UA](https://openairdocs.org/aircraft/N14UA.md): Cessna 414 · S/N 414-0605 · Milam Equipment LLC
- [N190](https://openairdocs.org/aircraft/N190.md): N190 AL-18 · S/N AL-408 · Built 2026 · N190 LLC
- [N1PN](https://openairdocs.org/aircraft/N1PN.md): Hanson James B VANS RV-7 · S/N 72349 · Hastings David B
- [N236MS](https://openairdocs.org/aircraft/N236MS.md): Sylvester Michael L KR2S · S/N 1276 · Built 2016 · Sylvester Michael L
- [N23AG](https://openairdocs.org/aircraft/N23AG.md): Beech V35B · S/N D-9834 · Built 1975 · Parker Robert B
- [N278GJ](https://openairdocs.org/aircraft/N278GJ.md): Unander Gary D VELOCITY 173 RG · S/N DMO 275 · Unander Gary D
- [N3184B](https://openairdocs.org/aircraft/N3184B.md): Cessna 170B · S/N 25426 · Built 1952 · Cerisano Kevin
- [N4051A](https://openairdocs.org/aircraft/N4051A.md): Cessna 195 · S/N 7318 · Built 1949 · Vintage Sky LLC
- [N50531](https://openairdocs.org/aircraft/N50531.md): Cessna 150J · S/N 15069377 · Built 1968 · Davies Patrick R
- [N50967](https://openairdocs.org/aircraft/N50967.md): Cessna 172M · S/N 17264221 · Sellers Raymond L
- [N5221S](https://openairdocs.org/aircraft/N5221S.md): Piper PA-32-300 · S/N 32-40915 · 3a LLC
- [N5784F](https://openairdocs.org/aircraft/N5784F.md): Piper PA-28-140 · S/N 28-25090 · Built 1968 · Crocker James Fuller
- [N6173B](https://openairdocs.org/aircraft/N6173B.md): Northwing NAVAJO · S/N 001 · Built 2005 · Long Johnny P
- [N6776D](https://openairdocs.org/aircraft/N6776D.md): Bell 47G-2 · S/N 2439 · Built 1959 · Milam Inc
- [N93067](https://openairdocs.org/aircraft/N93067.md): Bell 47D1 · S/N 5501 · Built 1965 · Milam Inc
- [N9JK](https://openairdocs.org/aircraft/N9JK.md): Schweizer SGS 1-35 · S/N 18 · Built 1975 · Stewart James D

## 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 = 'TRUSSVILLE'
ORDER BY g.n_number
```

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