Columbus, MS
Registered aircraft · 48
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 = 'MS' AND g.registrant_city = 'COLUMBUS' 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 = 'MS' AND g.registrant_city = 'COLUMBUS' 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.
N10349Dehavilland DHC-2 MK. I(L20A) · S/N 1302N117JRRamsey John A STEEN SKYBOLT · S/N 1001N1277PPipistrel D O O SINUS 912 · S/N 1277 SFNM 912 LSAN13500Cessna 180K · S/N 18053168N136GBBeech V35 · S/N D-8557N1893GChampion 7ECA · S/N 619N199TSDiamond Aircraft Ind DA 42 · S/N 42.AC003N214CPCirrus Design SR22 · S/N 3146N2155HPiper PA-32-300 · S/N 32-7940016N220WRBeech A36 · S/N E-2909N2609CGolden Circle Air T-BIRD · S/N 001N271CFDiamond Aircraft Ind DA 62 · S/N 62.C057N30JBBalbierer John M VANS RV-6 · S/N 23892N3136PBeech A36 · S/N E-2380N319SShafer David H GLASAIR II S FT · S/N 2015N3255WPiper PA-32-260 · S/N 32-77N3458WPiper PA-32-260 · S/N 32-327N3780FCessna 172H · S/N 17255275N3803VQuicksilver SPRINT · S/N 0491N41867Piper PA-28-151 · S/N 28-7415340N42581Piper J3C-65 · S/N 14862N47JHHopf Julian G BUSHBY MUSTANG MM1 · S/N 9811N4JRCessna 150G · S/N 15064844N5009SAir Tractor AT-502B · S/N 502B-0402N501BTPiper PA-32R-300 · S/N 32R-7780039N507GCCessna 680 · S/N 680-0239N507RLAir Tractor AT-502A · S/N 502A-3133N5899TCessna 185D · S/N 1850799N5964FPiper PA-28-151 · S/N 28-7715162N602HPCessna R182 · S/N R18201916N608CWRaytheon 390 · S/N RB-162N60USTextron 525B · S/N 525B0685N650RBRichard A Benson ZODIAC 650 · S/N 65-8783N6569JPiper PA-28-180 · S/N 28-5022N6931XCessna 172B · S/N 17247831N7133VMooney M20C · S/N 20-0034N7219HBeech 58 · S/N TH-1447N7693EChampion 7FC · S/N 7FC-288N78446Piper PA-12 · S/N 12-1960N8113WPiper PA-28-180 · S/N 28-2217N8214FCessna 150F · S/N 15064314N851BFAir Tractor AT-802A · S/N 802A-0996N868MMUhl/Feldman/Van Fleet/Jinright RV-8 · S/N 81733N900XLCessna 560XL · S/N 560-5544N92435Piper J3C-65 · S/N 16902N9286DPiper PA-18A 150 · S/N 18-6592N93535Bellanca 17-30A · S/N 73-30567N9954LMooney M20F · S/N 670487
Back to Columbus, MS