# Registered aircraft: Clayton, MO

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

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

- [N100HG](https://openairdocs.org/aircraft/N100HG.md): Gulfstream Aerospace G-V · S/N 625 · Built 2000 · Harbour Group Industries Inc
- [N12126](https://openairdocs.org/aircraft/N12126.md): Embraer EMB-145XR · S/N 145693 · Built 2003 · Avtran LLC
- [N18114](https://openairdocs.org/aircraft/N18114.md): Embraer EMB-145XR · S/N 145664 · Built 2002 · Enterprise Aircraft Finance LLC
- [N21130](https://openairdocs.org/aircraft/N21130.md): Embraer EMB-145XR · S/N 145704 · Built 2003 · Avtran LLC
- [N221VL](https://openairdocs.org/aircraft/N221VL.md): Cirrus Design SR22T · S/N 11405 · Built 2026 · Lumen Air Holdings LLC
- [N226BK](https://openairdocs.org/aircraft/N226BK.md): Beech C90A · S/N LJ1340 · Built 1993 · Avtran LLC
- [N25RM](https://openairdocs.org/aircraft/N25RM.md): Beech 58P · S/N TJ-459 · Sky Travel LLC
- [N3446T](https://openairdocs.org/aircraft/N3446T.md): Cessna 177 · S/N 17700746 · Built 1968 · R & B Air LLC
- [N388JE](https://openairdocs.org/aircraft/N388JE.md): Cessna 560XL · S/N 560-5605 · Built 2006 · Enterprise Lease Finance LLC
- [N42987](https://openairdocs.org/aircraft/N42987.md): Piper PA-32R-301 · S/N 32R-8313017 · Built 1983 · Gman Air LLC
- [N430GW](https://openairdocs.org/aircraft/N430GW.md): Piper PA46R-350T · S/N 4692208 · Built 2014 · Avtran LLC
- [N4342A](https://openairdocs.org/aircraft/N4342A.md): Beech V35B · S/N D-9133 · Built 1970 · R&B Air LLC
- [N496CD](https://openairdocs.org/aircraft/N496CD.md): Cirrus Design SR22 · S/N 1612 · Built 2005 · Cirrus Skies LLC
- [N500DY](https://openairdocs.org/aircraft/N500DY.md): Piper PA 46-350P · S/N 4636865 · Built 2025 · Enterprise Aircraft Finance LLC
- [N599AH](https://openairdocs.org/aircraft/N599AH.md): Piper PA-31-350 · S/N 31-8452019 · Built 1984 · Avtran LLC
- [N8639H](https://openairdocs.org/aircraft/N8639H.md): North American NAVION · S/N NAV-4-639 · Built 1947 · Nielsen Eric K
- [N89FA](https://openairdocs.org/aircraft/N89FA.md): Douglas C-54 · S/N 27249 · South African Air Lease LLC
- [N911CP](https://openairdocs.org/aircraft/N911CP.md): Hughes Helicopters 369E · S/N 0105E · Built 1984 · St Louis County Police Department
- [N911MU](https://openairdocs.org/aircraft/N911MU.md): MD Helicopters 369E · S/N 0614E · Built 2012 · St Louis County Police Dept
- [N911PH](https://openairdocs.org/aircraft/N911PH.md): Mcdonnell Douglas Helicopter 369E · S/N 0217E · Built 1987 · St Louis County Police Department
- [N97CP](https://openairdocs.org/aircraft/N97CP.md): Cirrus Design SF50 · S/N 0035 · Built 2018 · Maria Squared 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 = 'MO' AND g.registrant_city = 'CLAYTON'
ORDER BY g.n_number
```

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