Columbus, NE
Registered aircraft · 41
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 = 'NE' 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 = 'NE' 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.
N1716BDJI AGRAS T40 · S/N 64TBL3L0020047N1838NCessna 120 · S/N 12082N191YBeech V35 · S/N D-8172N1NPRaytheon B200 · S/N BB1834N20763Cessna 172M · S/N 17263832N2161DPurdy Vernon J RANS S-6S COYOTE II · S/N 09991342N2183XNanchang China CJ-6 · S/N 2951230N223YBDJI AGRAS T40 · S/N 64TBL5H00200CCN2267PPreston Calvin L RV-7 · S/N 73439N230KBDJI AGRAS T40 · S/N 64TBL5H00200CKN2592EKolb MARK 3 · S/N KOLB/TIB227886584N275BCDJI AGRAS T50 · S/N 1581F6BUB248900152L3N282FMDJI AGRAS T40 · S/N 64TBK7H001004AN2850TPiper PA-28R-200 · S/N 28R-7235146N32RNNorton Robert R CHRISTEN EAGLE II · S/N NORTON 0001N459THCessna 182Q · S/N 18267544N47442Piper PA-28R-201T · S/N 28R-7703377Registration pendingN47833Piper PA-28-161 · S/N 28-7816138N502AAEavision EA-J150 · S/N JMZKJ150UAV602595050N515JAPaul M Muhle / Sandra D Muhle DR-107 · S/N 18-608N525SFCessna 421C · S/N 421C0080N557PMMuhle Paul M PITTSS1SS · S/N 2PMN5655KBeech B300 · S/N FL-12N58TNanchang China CJ-6 · S/N 2851208N6204VBeech V35 · S/N D-8564N623SVPowrachute PEGASUS · S/N A0075PEGN62700Convair BT-13A · S/N 1850N65682Edmison Robert J BUCKEYE DREAMMACHINE · S/N 3808N7357CCessna T210N · S/N 21063945N74SMCessna 182Q · S/N 18267216N751TSSpeerstra Thomas E VANS ACFT RV-8 · S/N 81529N7939WPiper PA-28-180 · S/N 28-1981N80476Cessna 172M · S/N 17266609N805NHBeech A36 · S/N E-2699N8334GCessna 150F · S/N 15062434N83614Piper PA-18-150 · S/N 18-7709101N8383HPiper PA-28-161 · S/N 28-8116221N8426NBeech E33A · S/N CE-220N910TPProkop Thomas W RV-6 · S/N 22910N943PDJI INSPIRE 1 · S/N W13DDI22060071N9771LBeech C23 · S/N M-1402
Back to Columbus, NE