OpenAirDocs.org
Clayton, MO

Registered aircraft · 21

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

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N100HGGulfstream Aerospace G-V · S/N 625Built 2000 · Harbour Group Industries IncN12126Embraer EMB-145XR · S/N 145693Built 2003 · Avtran LLCN18114Embraer EMB-145XR · S/N 145664Built 2002 · Enterprise Aircraft Finance LLCN21130Embraer EMB-145XR · S/N 145704Built 2003 · Avtran LLCN221VLCirrus Design SR22T · S/N 11405Built 2026 · Lumen Air Holdings LLCN226BKBeech C90A · S/N LJ1340Built 1993 · Avtran LLCN25RMBeech 58P · S/N TJ-459Sky Travel LLCN3446TCessna 177 · S/N 17700746Built 1968 · R & B Air LLCN388JECessna 560XL · S/N 560-5605Built 2006 · Enterprise Lease Finance LLCN42987Piper PA-32R-301 · S/N 32R-8313017Built 1983 · Gman Air LLCN430GWPiper PA46R-350T · S/N 4692208Built 2014 · Avtran LLCN4342ABeech V35B · S/N D-9133Built 1970 · R&B Air LLCN496CDCirrus Design SR22 · S/N 1612Built 2005 · Cirrus Skies LLCN500DYPiper PA 46-350P · S/N 4636865Built 2025 · Enterprise Aircraft Finance LLCN599AHPiper PA-31-350 · S/N 31-8452019Built 1984 · Avtran LLCN8639HNorth American NAVION · S/N NAV-4-639Built 1947 · Nielsen Eric KN89FADouglas C-54 · S/N 27249South African Air Lease LLCN911CPHughes Helicopters 369E · S/N 0105EBuilt 1984 · St Louis County Police DepartmentN911MUMD Helicopters 369E · S/N 0614EBuilt 2012 · St Louis County Police DeptN911PHMcdonnell Douglas Helicopter 369E · S/N 0217EBuilt 1987 · St Louis County Police DepartmentN97CPCirrus Design SF50 · S/N 0035Built 2018 · Maria Squared Aviation LLC
Back to Clayton, MO