Monroe, GA
Registered aircraft · 43
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 = 'MONROE' 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 = 'MONROE' 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.
N110UADJI MAVIC PRO · S/N 08Q2F5A00S2148N115UADJI INSPIRE 1 · S/N W13DCC30030119N1374JRockwell International 112A · S/N 374N1761NCessna 120 · S/N 12005N204PCPiper PA-32-300 · S/N 32-7440036N2314XCessna 182H · S/N 18256214N250WWSchempp-Hirth DISCUS CS · S/N 250CSN2549DPiper PA46R-350T · S/N 4692178N2926Glasflugel STANDARD LIBELLE · S/N 84N330VBeech C90 · S/N LJ-811N37BJCessna 337G · S/N 33701503N38QACessna 525A · S/N 525A0214N4602ZPiper PA-22-108 · S/N 22-8116N4740SPiper PA-32-260 · S/N 32-1172N49164Cessna 152 · S/N 15281176N5042GBellanca 7GCBC · S/N 1185-80N541PCSocata TAMPICO TB 9C · S/N 1563N5706VBeech V35 · S/N D-8093N5964TCessna 150D · S/N 15060664N5974ZPiper PA-22-108 · S/N 22-9848N612MGSchleicher ASK-21 · S/N 21544N613XCirrus Design SR22T · S/N 2055N6154RQuicksilver MXLII SPRINT · S/N 305N621MGSchleicher ASK-21 · S/N 21254N6321CBeech A36 · S/N E-2025N6797UMooney M20C · S/N 2509N6934PPiper PA-24-250 · S/N 24-2068N69PRCessna T210H · S/N T210-0321N70421Piper J3C-65 · S/N 17416N70642Piper J3C-65 · S/N 17660N7201TCessna 172A · S/N 46801N72328Cessna 140 · S/N 9508N7285BBeech J35 · S/N D-5647N754RHRobinson Helicopter R44 II · S/N 10957N793GBurkhart Grob Flugzeugbau G102 CLUB ASTIR IIIB · S/N 5636CBN8034WPiper PA-28-180 · S/N 28-2101N8225LCessna 172H · S/N 17256425N837CStinson 108-3 · S/N 108-3837N8594DPiper PA-18 · S/N 18-6258N8723LPiper PA-25-235 · S/N 25-5180N87274Ercoupe 415-D · S/N 447N8745XCessna 182D · S/N 18253145N89168Cessna 140 · S/N 8182
Back to Monroe, GA