Columbus, IN
Registered aircraft · 87
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 = 'IN' 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 = 'IN' 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.
N10ETCessna 310Q · S/N 310Q0415N112CPMaule MT-7-235 · S/N 18062CN1173YCarmean Ralph R R1 · S/N 001N11LYPiper PA-28-235 · S/N 28-10535N123MFPiper PA-32-260 · S/N 32-1069N1526RFirefly Balloons FIREFLY 8B-15 · S/N F8B-2033N1579WBeech G33 · S/N CD-1289N177NWCessna 177 · S/N 17701097N18021Cessna 150L · S/N 15073737N1992HPiper PA-28-161 · S/N 28-7716076N1RQPiper PA46-500TP · S/N 4697112N200CKGulfstream Aerospace GIV-X (G450) · S/N 4304N203CKBombardier BD-100-1A10 · S/N 21089N210AKCessna 210 · S/N 21061627N212WDMooney M20F · S/N 680066N2131Cessna 525B · S/N 525B0297N2171EAeronca 7DC · S/N 7AC-5742N2185CCessna 195B · S/N 16170N231NJMooney M20K · S/N 25-0324N239SXYrineo James SONEX B · S/N SNB-0039N23PMNanchang China CJ-6 · S/N 3832012N25577Balloon Works FIREFLY 7B-15 · S/N F7B-361N26683Taylorcraft BL-65 · S/N 2025N281CEIai GULFSTREAM G280 · S/N 2243N282CEIai GULFSTREAM G280 · S/N 2259N283CEIai GULFSTREAM G280 · S/N 2226N2855MPiper PA-28R-201T · S/N 28R-7803149N2950RPiper PA-28R-200 · S/N 28R-35340N3003Fairchild C-119G-3E · S/N 10737N3039PSocata TB-20 TRINIDAD · S/N 1490N31155Piper J3C-65 · S/N 5369N323JLBeech D55 · S/N TE-608N325KWWiederholt Kermit DAKOTA HAWK · S/N D-40N341SCCessna 340A · S/N 340A1810N3434XMooney M20E · S/N 1126N350AFBeech B300 · S/N FL-184N3847XBeech V35B · S/N D-10368N3868EAeronca 11AC · S/N 11AC-S-68N411NCBell 206B · S/N 3373N4201LMooney M20J · S/N 24-0572N44661Piper PA-32-300 · S/N 32-7540002N4634XCessna 150G · S/N 15064684N4635CCessna 170B · S/N 25579N4849LPiper PA-28-180 · S/N 28-4198N4865ZPiper PA-22-108 · S/N 22-8442N4BHVans RV-12 · S/N 120765N5247CBeech B35 · S/N D-2639N5707XBalony Kubicek Spol Sro BB30Z · S/N 1627N625MTMooney M20E · S/N 867N6292ZBeech A36 · S/N E-2010
Back to Columbus, IN