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 = 'GA' AND g.registrant_city = 'HAZLEHURST' 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 = 'GA' AND g.registrant_city = 'HAZLEHURST'
  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 = 'GA' AND g.registrant_city = 'HAZLEHURST'
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.

N120JGGunnerson Tom MXL-2 · S/N 1208Bailey James M N1713GBeech P35 · S/N D-6939Built 1962 · Right Away Trucking Inc N1973MPiper J3C-65 · S/N 21572Scruggs John S N224KCCessna S550 · S/N S550-0104Built 1985 · Beasley Timber Co In N3040HEngineering & Research ERCOUPE 415-D · S/N 3665Built 1946 · Smith Raymond E N314DCessna 320C · S/N 320C-0067Built 1965 · Brantley Hugh Lawton N47JYCarson Robert T GLA-STAR · S/N 5183Built 2024 · Linse John W N521FTBeech 200C · S/N BL-012Built 1980 · R & G Aviation LLC N5492QCessna 150L · S/N 15073392Built 1972 · Marchant Colby Z N553HAmerican AA-1A · S/N AA1A-0295Built 1971 · Brantley Hugh L N5901TCessna 150D · S/N 15060601Built 1964 · Williams Terry A N5ZRRaytheon 58 · S/N TH-2128Built 2005 · Beasley Timber Co Inc N601DMBeech C90 · S/N LJ825Built 1979 · R & G Aviation LLC N6867NMooney M20C · S/N 680146Built 1968 · Knox Robert W Jr N7682BBellanca 14-19-2 · S/N 4033Brantley Hugh L N7853FCessna 150F · S/N 15063953Built 1966 · Edwards Michael J N854CRaytheon 58 · S/N TH-2018Built 2001 · Beasley Timber Co Inc N9103VMooney M20F · S/N 690022Built 1969 · Mullis Stephen P Jr N911DWPiper PA-32R-301T · S/N 3257133Built 2000 · Ocmulgee Outdoors Inc N923DJClifford E Massey AR-1 · S/N 0002Built 2016 · Wooley II John G N9498JPiper PA-28-180 · S/N 28-3738Brantley Hugh L N99MXRobinson Helicopter R66 · S/N 0443Built 2013 · R&G Aviation LLC

Back to Hazlehurst, GA