Kokomo, IN
Registered aircraft · 75
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 = 'KOKOMO' 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 = 'KOKOMO' 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.
N1039BMooney M20J · S/N 24-1119N1040HPiper PA-32R-300 · S/N 32R-7780124N107SSSean P Sweeney DR 107 - ONE DESIGN · S/N SPS 1401N1175NFairchild M-62A-3 · S/N FT-635N1239XMooney M20E · S/N 112N126BBAviat S-2C · S/N 6046N1280BLuscombe 8A · S/N 5907N1428BSchempp-Hirth VENTUS-B · S/N 37N15250Piper PA-28R-200 · S/N 28R-7335043N15544Piper PA-28-140 · S/N 28-7325094N15944Piper PA-28-180 · S/N 28-7305193N162BJCessna 182Q · S/N 18266440N1679APiper PA-22 · S/N 22-441N1827HCessna 310C · S/N 35927N191SKBuckeye Industries DREAM MACHINE 503 · S/N 4204N1989KWilliams Rodney B BABY GREAT LAKES · S/N 001N19AXMooney M20K · S/N 25-0504N1FPCooner G Steve WAG AERO SPORT TRAIN · S/N 4863N2345QBeech 23 · S/N M-416N234SDBeech A36TC · S/N EA-200N244BJJapundza Bob VANS ACFT RV6 · S/N 22977N2554FDJI AGRAS T40 · S/N 64TBL61002003EN2919SCessna 150G · S/N 15066819N3008BPiper PA-28-181 · S/N 28-7990135N3061YPiper PA-28-181 · S/N 28-7990388N3113HWaco UPF-7 · S/N 5848N3330RPiper PA-28-180 · S/N 28-5659N333MKMooney M20M · S/N 27-0172N3505NPiper J3C-65 · S/N 22734N3619RPiper PA-28-180 · S/N 28-5714N414WHDJI AGRAS T50 · S/N 1581F6BUB249S001NZG4N4192HMooney M20J · S/N 24-0660N42873Letts Robert L CP328 EMERAUDE · S/N L1000N42971Piper J3C-65 · S/N 15330N431EComer James C VANS RV7A · S/N 70423Registration pendingN469CJCessna 421C · S/N 421C1018N5042BBeech F35 · S/N D-4309N5057CBellanca 8KCAB · S/N 544-79Non-citizen corporation, flight hours not reportedN5105TChampion 7ECA · S/N 502N5145CBeech B35 · S/N D-2430N5176LPiper PA-28-180 · S/N 28-4462N519RGPiper PA-28R-200 · S/N 28R-35097Registration pendingN530NHDJI AGRAS T100 · S/N 1581F8ZLC257G002W1PDN53997Bell 47G-2A-1 · S/N 3778N5501WPiper PA-28-160 · S/N 28-587N580MWExtra Flugzeugbau EA 300/S · S/N 031N5820SBeech S35 · S/N D-7724N5922UPiper PA-28-140 · S/N 28-26408N5937WPiper PA-28-150 · S/N 28-3437N6044ABuckeye BREEZE · S/N 16429
Back to Kokomo, IN