Registered aircraft · 22

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 = 'GILMER' 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 = 'GILMER'
  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 = 'GILMER'
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.

N1433RGrumman American Avn. AA-1B · S/N AA1B-0533Nickell Stan A N1676FCessna 172H · S/N 17255071Brunson Tim R N17039Cessna 150L · S/N 15073597Davidson Luke H N17790Beech 95-B55 (T42A) · S/N TC-2055Built 1977 · Tds Property Holdings LLC N202SWCessna 414A · S/N 414A0515Built 1980 · Mar Jar LLC N2048HEngineering & Research ERCOUPE 415-C · S/N 2671Built 1946 · Lund Patrick N2130LBeech 58TC · S/N TK-25Built 1976 · Tds Property Holdings LLC N245RHRichard Hawkinberry MH1 · S/N MH12013-01Hawkinberry Richard K N301DYRenwick Dennis E SONERAI II · S/N 1127 DER 1Built 1987 · Renwick Dennis E N3860TPiper PA-28R-180 · S/N 28R-30183Built 1967 · Tds Property Holdings LLC N414FCCessna 414A · S/N 414A0039Built 1978 · Taff Logistics LLC N436SKRobinson Helicopter R22 · S/N 2954Built 1999 · Tds Property Holdings LLC N4869JBeech 95-C55 · S/N TE-281Built 1966 · Dls Aviation LLC N503JMBeech 200 · S/N BB-712Built 1980 · Dls Aviation LLC N51417Aerostar International RX-7 · S/N RX7-3336Green Kevin M N7171RPiper PA-28-140 · S/N 28-21881Built 1966 · Youngblood Steven H N7695YPiper PA-30 · S/N 30-777Built 1965 · Griffith David B N8510UCessna 172F · S/N 17252410Built 1964 · Tds Property Holdings LLC N86082Aeronca 11AC · S/N 11AC-504Built 1946 · Renwick Dennis E N86CBBeech 95-B55 (T42A) · S/N TC-1383Sweeney David P N8857MBeech A23 · S/N M-597Dunn Brady N90JXHawker Beechcraft C90GT · S/N LJ-1845Built 2007 · Dean Lumber Co Inc

Back to Gilmer, TX