Kennesaw, GA
Registered aircraft · 100
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 = 'KENNESAW' 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 = 'KENNESAW' 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.
N10CBShawn M Connell RV-10 · S/N 42116N1225Piper PA-60-601P · S/N 61P05727963249N12XPilatus PC-12/47E · S/N 2204N1321SCessna 182P · S/N 18264885N1370ECessna 172N · S/N 17270972N143DEBeech 200 · S/N BB-585N144JTSocata TBM 700 · S/N 144N1590JPiper PA-28-140 · S/N 28-23999N1723ATextron 172S · S/N 172S13507Registration pendingN180ASSeymour MA 5 CHARGER · S/N 69-1N18VFCessna 560XL · S/N 560-5322N1912EAeronca 7AC · S/N 7AC-5479N1923FCessna 172N · S/N 17273015N1979MPiper J3C-65 · S/N 8901N207FLXag P100 PRO · S/N 8219347V6J94N20AZPiper PA-28-236 · S/N 28-7911153N2159EMooney M20R · S/N 29-0238N230DKBell Helicopter Textron Canada 407 · S/N 54915N2323ERaytheon A36 · S/N E3187N253RVGillespie Byron W VANS RV-10 · S/N 40253N26415Grumman American Avn. AA-5A · S/N AA5A0579N278EHCirrus Design SR22T · S/N 2114N2819FPiper PA-28RT-201 · S/N 28R-7918156N2952Huff Daland DUSTER · S/N 53N311NFXag P100 PRO · S/N 82193485X39NN351JACessna T206H · S/N T20608820N352RRPipistrel D O O VIRUS SW 121 · S/N VSWX1210099N3598JCessna 150E · S/N 15061298N383JPBeech 200 · S/N BB615N404DCTextron 172S · S/N 172S13065N41102Yakovlev YAK 52 · S/N 866508N412ADBell Helicopter Textron Canada 412EP · S/N 36425N4234NCessna 170B · S/N 26263N428CCCirrus Design SR20 · S/N 10780N442LUXag P100 PRO · S/N 8219418PL008N446LGEmbraer EMB-550 · S/N 55000032N44FDPiper PA-23 · S/N 23-500N45163Naval Aircraft Factory N3N-3 · S/N 2885N466DWBell Helicopter Textron Canada 407 · S/N 54815N472JLHawker Beechcraft B300C · S/N FM-50N487NMXag P150 · S/N 186324P1822350203P1QN487YWXag P150 · S/N 186324P182235025DC07N501REPiper PA-30 · S/N 30-194N5035XTextron 172S · S/N 172S13522N5466LGrumman American Avn. AA-5 · S/N AA5-0366N5808Pitcairn PA-5 · S/N 27N619EHLawrence Edward Holst RV-8 · S/N 83260N625JGRocky Mountain Kitplanes S-6ES · S/N 02061730N6340WPiper PA-28-140 · S/N 28-20398N6358LAmerican AA-1A · S/N AA1A-0358
Back to Kennesaw, GA