Registered aircraft · 23

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

N1173QCessna T210L · S/N 21059673Moon Mitchell L N182PUCessna 182P · S/N 18262689Built 1973 · Rdl Aviation LLC N221CECirrus Design SR22T · S/N 0021N221ce LLC N326PTCessna 310Q · S/N 310Q0968Built 1974 · Jt Aero LLC N40WTCessna 180 · S/N 30324Built 1953 · Pritchett Thomas A N4294XNanchang China CJ-6A · S/N 2532060Built 1968 · Jenkins Michael D N5084GStinson 108 · S/N 108-570Garvey Joseph D N52748Cessna 182P · S/N 18262816Built 1974 · Hall Howard S N5353TCessna 172E · S/N 17251253Registration pendingBuilt 1964 N5424GQuad City Ultralight Acft CHALLENGER II · S/N BH050424Lewis Billie N5698LFerguson FERGY II · S/N 00112Built 1995 · Jolley John A N6369NChampion 7KCAB · S/N 44Built 1967 · Eberhart Royce R N6371LAmerican AA-1A · S/N AA1A-0371Built 1972 · Keeling Jonah David N666WPCessna 182Q · S/N 18266914Built 1979 · Hamilton Stuart E N72AABoeing A75N1(PT17) · S/N 75-5867Built 1941 · Eberhart Royce R N735EHCessna 182Q · S/N 18265362Built 1977 · Law Offices Of Jorge Luis Flores LLC N7667TCessna 172A · S/N 47267Built 1960 · Hembree Roy C Jr N76BEChampion 7KCAB · S/N 168Built 1969 · Brown Darrell W N8568EChampion 7FC · S/N 7FC-356Built 1959 · Cochran Brandon N882BCCessna 414 · S/N 414-0470Built 1973 · Technology Aviation Services LLC N9254GCessna 182N · S/N 18260794Built 1971 · Stowe Henry L N97365Cessna 182Q · S/N 18267069Built 1979 · Sugg Robert Michael N992MRBell 206B · S/N 3265Built 1981 · Platinum Rigging & Hvac Consulting LLC

Back to Covington, GA