Douglasville, GA
Registered aircraft · 31
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 = 'DOUGLASVILLE' 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 = 'DOUGLASVILLE' 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.
N102SWRobinson Helicopter R66 · S/N 0106N1498TPiper PA-28R-200 · S/N 28R-7235307N21SLCessna 550 · S/N 550-0877N2232LBeech B19 · S/N MB-819N2297MPiper PA-32R-300 · S/N 32R-7880061N2318TPiper PA-28-140 · S/N 28-7125567N25RFCessna 340 · S/N 340-0307N2945UCessna 172D · S/N 17250545N306PLLloyd Shreckengost/John Lafitt SR 3500 MOOSE · S/N 058SRN3413KPiper PA-28-140 · S/N 28-23547N3507VCessna 150M · S/N 15076528N36533Aeronca 65-CA · S/N C16291N4184FCessna 172 · S/N 46084N4468QCessna 152 · S/N 15284723N4506RPiper PA-28-140 · S/N 28-21206N4717JBeech A23-19 · S/N MB-175N51393Cessna 150J · S/N 15069974N523CTRobinson Helicopter R44 II · S/N 13078N5890UPiper PA-28-140 · S/N 28-26786N591WTHawker Beechcraft G36 · S/N E-3939N601PACessna 172N · S/N 17269030N646JMMoyes John P VANS RV-6A · S/N 25513N6622RPhoenix Air Sro U-15 PHOENIX · S/N 19/U15N74TVTVV AIRCAM · S/N AC299-3N817RMBeech A36TC · S/N EA-203N8215LCessna 172H · S/N 17256415N85BECirrus Design SR22T · S/N 2423N8774WPiper PA-28-235 · S/N 28-10317N9140ZMooney M20M · S/N 27-0085N9836HCessna 182R · S/N 18268057N988PSCessna 182 · S/N 33749
Back to Douglasville, GA