Sharpsburg, GA
Registered aircraft · 39
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 = 'GA' AND g.registrant_city = 'SHARPSBURG' 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 = 'SHARPSBURG' 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.
N1022YVans RV-12IS · S/N 12127N1051HAeronca 15AC · S/N 15AC-66N1267EChampion 7AC · S/N 7AC-4825N1369YCessna 172C · S/N 17249069N15423Piper PA-28-140 · S/N 28-7325064N1966ASlaughter Clay B PELICAN PL · S/N 505-01N1994XCessna 182H · S/N 18256094N199MMMckinzey Michael MJ1 · S/N 1N2006NCessna 140 · S/N 12242N2324LBeech 23 · S/N M-150N251SRCirrus Design SR20 · S/N 8862N2549ZBellanca 8KCAB · S/N 352-77N29497Aeronca 65-CA · S/N C10440N311AWPiper PA-28-140 · S/N 28-7525015N33170Piper PA-28-180 · S/N 28-7505129N346BRArion LIGHTNING LS-1 · S/N 88N35308Cessna 172I · S/N 17256704N387APCirrus Design SR22T · S/N 10090N42768Cessna 182L · S/N 18259183N428APCirrus Design SR22 · S/N 11406N42BSJames Stutson CH750 CRUZER · S/N C75-11128N4304UCessna 150D · S/N 15060304N4428UCessna 150D · S/N 15060428N4517APiper PA-22-150 · S/N 22-3823N4629FCessna P206A · S/N P206-0229N5269SCessna R182 · S/N R18201531N558PPKingsley B Owen VANS RV9A · S/N 91087N5825QMooney M20E · S/N 778N6482HPiper J3C-65 · S/N 19664N6870UMooney M20C · S/N 2574N7740NPiper PA-28-180 · S/N 28-5184N7783ECessna 150 · S/N 17583N7870WPiper PA-28-180 · S/N 28-1892N8006YPiper PA-30 · S/N 30-1112N8092GPiper PA-28-181 · S/N 28-8090095N8448WPiper PA-28-180 · S/N 28-2654N84JFVans RV-12 · S/N 120680N902QBeech 35-A33 · S/N CD-372N97077Cessna 182Q · S/N 18266966
Back to Sharpsburg, GA