Registered aircraft · 25

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

Query with 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 = 'TX' AND g.registrant_city = 'GODLEY' ORDER BY g.n_number

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 = 'TX' AND g.registrant_city = 'GODLEY'
  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.

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 = 'TX' AND g.registrant_city = 'GODLEY'
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N119MBMooney M20J · S/N 24-1135Built 1981 · Wagner Mike N11GYYoung G L STARDUSTER II SA300 · S/N 366Built 1972 · Young Layton A N12VEBennight Joe C VARI-EZE · S/N 32365279Built 1983 · Morrison Benjamin Franklin III N131JCJeff Rowland JEFF BUCKER BU131 JU · S/N BU131-1Built 2020 · Cain Jeffrey B N157HDHiram P Douglas DOUGLAS CUB 3 · S/N 003Built 2026 · Douglas Hiram P N1596MCessna 182P · S/N 18264386Built 1975 · Kret Geoffrey W N181RPCessna 180K · S/N 18053180Built 1981 · Cain Jeffrey B N1920JRockwell International 114 · S/N 14020Built 1976 · Derrick James E N2227CPiper PA-18-135 · S/N 18-4011Built 1954 · Cain Jeffrey B N2937Travel Air Mfg 2000 · S/N 185Cain Jeffrey B N3654HMooney M20K · S/N 25-0436Built 1980 · Thompson William D N3825NBeech 35 · S/N D-1062Built 1947 · Morrison Benjamin F N397DCClark James D PATRIOT 300 · S/N 1995DCBuilt 1995 · Clark James D N397HHJames D Clark HO-HAULER · S/N 2012DCBuilt 2013 · Clark James D N446WBWilliam A Beasley ARGON GTL · S/N MLAGL003Built 2024 · Wagner Mike S N46YHPratt Jay R RV6 · S/N 21026Built 2025 · Douglas Hiram P N566KBCessna 560 · S/N 560-0325Built 1995 · T3 Farms LLC N5764ACessna 172 · S/N 28364Built 1956 · Morrison Benjamin F III N597DCJames D Clark PATRIOT 300 II · S/N 2021DCBuilt 2021 · Clark James D N66248Cessna 150M · S/N 15075952Built 1975 · Jeffery Anne Kuba N6997HPiper J3C-65 · S/N 20242Built 1946 · Wagner Mike S N78940Mooney M20C · S/N 1974Gaskins Gregory G N85762Aeronca 7AC · S/N 7AC-4511Built 1946 · Airknockers LLC N8873PPiper PA-24-260 · S/N 24-4330Built 1965 · Tailwind Auditing Group LLC N99NXNoel Lester J WAG AERO SUPER CUBY · S/N 966Built 1998 · Stewart Shelton O

Back to Godley, TX