Augusta, GA
Registered aircraft · 61
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 = 'AUGUSTA' 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 = 'AUGUSTA' 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.
N1044MTextron B300 · S/N FL-1044N10STPiper PA46-500TP · S/N 4697220N1301JRockwell International 112A · S/N 301N132GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 396N1347FCessna 172G · S/N 17254842N1483MCessna 182P · S/N 18264348N155BBeech J35 · S/N D-5701N1664EAeronca 7AC · S/N 7AC-5230N1904Beech C35 · S/N D-2914N2061MTextron 182T · S/N 18283337N20887Cessna T182T · S/N T18208452N22MTBeech C90A · S/N LJ-1368N2435LCessna 172H · S/N 17255635N257PGCirrus Design SR22T · S/N 2454N2625MBeech 95-B55 (T42A) · S/N TC-1586N28542Luscombe 8C · S/N 1370N3081JMurphy D G/Murphy C P AC4-C · S/N 004KN312EHGame Aerospace GB1 GAMEBIRD · S/N 0125N320GSShattuck George W LANCAIR 320 · S/N 393N33255Piper J3C-65 · S/N 5929N332HPBeech F33A · S/N CE1508N36168Taylorcraft BL-65 · S/N 3176Sale reported, canceledN3BMDassault MYSTERE FALCON 50EX · S/N 280N40VBBazan Vasile TEENIE TWO · S/N 15-2418N4109FPiper PA-31-325 · S/N 31-8212027N4174UPiper PA-32R-301T · S/N 3257308N43796Piper PA-32-260 · S/N 32-7700022N451PInfinity COMMANDER · S/N IPP2-127N47MKPiper PA-23-250 · S/N 27-7305122N510EECessna 510 · S/N 510-0275N5182LPiper PA-28-180 · S/N 28-4469N524BQCessna 182S · S/N 18280456N52MRRichardson Michael L RV 4 · S/N 1325N531BRCessna 525 · S/N 525-0264N553TSCessna 425 · S/N 425-0214N5580ECessna 150 · S/N 17080N5GUCessna 525B · S/N 525B0009N6098WPiper PA-28-140 · S/N 28-20112N6234UMooney M20C · S/N 2073N649DFNorth American T-28C · S/N 140649N6996WPiper PA-28-140 · S/N 28-21195N700EFPiper PA-46-701TP · S/N 46020023N727BWBeech B200 · S/N BB-861N744MAPiper PA-46-701TP · S/N 46020073N759AACessna 182Q · S/N 18265828N78WDMitsubishi MU-2B-26A · S/N 368SAN80842Cessna 172M · S/N 17266770N80931Cessna 172M · S/N 17266806N8184NBeech A36 · S/N E-2648N8299WBeech A36 · S/N E-2809
Back to Augusta, GA