Mcdonough, GA
Registered aircraft · 32
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 = 'MCDONOUGH' 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 = 'MCDONOUGH' 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.
N14732Bellanca 17-30A · S/N 75-30756N213WXRobert C Daniel SLING TSI · S/N 208SKN213YKelly Douglas E KITFOX IV 1200 · S/N 1663N2333NCessna 140 · S/N 12573N235TLPiper PA-28-235 · S/N 28-10769N295CCBell OH-58C · S/N 71-20592N3176XCessna 150G · S/N 15064576First renewal noticeN3195UCessna 182F · S/N 18254595N3287GBalloon Works FIREFLY 7-15 · S/N F71014N38693Piper J3F-65 · S/N 7201N4197FCessna 172 · S/N 46097N427TJBell 407 · S/N 53673N44039Taylorcraft BC12-D · S/N 9839N497NMCessna 680 · S/N 6800507Registration pendingN5097YPiper PA-23-250 · S/N 27-2122N5190LPiper PA-28-180 · S/N 28-4479N553RSGuided Systems Technologies IN V-10ET · S/N GST518N5895Aerostar International S-60A · S/N S60A-3290N5895LAmerican AA-5 · S/N AA5-0095N604JGGay John E PIETENPOL · S/N 001N6236PPiper PA-24-250 · S/N 24-1341N659XHGuided Systems Technologies IN V-10ET · S/N GST731N714SGCessna 150M · S/N 15079393N748JBBenton James H JR CHALLENGER II · S/N CH2-1103-2401N76719Cessna 140 · S/N 11151N8090FPiper PA-28-181 · S/N 28-7790233N9093NAerostar International RXS-8 · S/N RXS8-3005N9116MAerostar International RX-9 · S/N RX9-3013N938GCEmbraer EMB-550 · S/N 55020193N9639TPiper PA-38-112 · S/N 38-78A0149N96501Taylorcraft BC12-D · S/N 8801N993SGRaytheon HAWKER 800XP · S/N 258377
Back to Mcdonough, GA