South Bend, IN
Registered aircraft · 62
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 = 'SOUTH BEND' 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 = 'SOUTH BEND' 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.
N14NNCessna TU206G · S/N U20605374N156LZStorch FL-156C · S/N SA-001KN1650CCessna 180 · S/N 30350N1842Charles Florance SONEX · S/N 0845N18HGulfstream Aerospace GV-SP (G550) · S/N 5328N19RHFairchild M-62A · S/N 7583AEN2079SPinkham Lewis CHALLENGER II · S/N CH2-2017N2214MPiper PA-28-181 · S/N 28-7890234N221EMEmbraer-Empresa Brasileira De EMB-500 · S/N 50000025N2399PPiper PA-22-150 · S/N 22-2790N253MAPiper PA 46-350P · S/N 4636353First renewal noticeN2546JBuckeye Industries DREAM MACHINE · S/N 4796N269RPiper PA-46-310P · S/N 8608065N286NCessna 525B · S/N 525B0190N2894KLuscombe 8A · S/N 5621N2946PPiper PA-22-150 · S/N 22-3216N2952YPiper PA-28-181 · S/N 28-7990580N29744Taylorcraft BC12-65 · S/N 2591N310EWCessna T310Q · S/N 310Q0935N321SXHarrington Bruce D SONEX · S/N 321N326EWDassault FALCON 2000EX · S/N 248N35349Cessna 172I · S/N 17256725N3759PPiper PA-22-150 · S/N 22-3481N4378QCessna 172L · S/N 17260278N444AMCessna 525B · S/N 525B0063N44SWTextron 525B · S/N 525B0585N4518HPiper PA-15 · S/N 15292N468NFlight Design CTLS · S/N F-10-08-05N488SADiamond Aircraft Ind DA 40 NG · S/N 40.NC157N5069VVarga 2150A · S/N VAC-58-76N5157NCessna 182Q · S/N 18267549N6079SBeech 95-B55 (T42A) · S/N TC-1877N6292YPiper PA-22-160 · S/N 226300N62CAPiper PA 46-350P · S/N 4636025N630RWaddell Lon D VANS RV7A · S/N 70531N63234Cessna 150M · S/N 15077192N65557Cessna 182T · S/N 18281456N65NGPilatus PC-12/47E · S/N 1365N731PADiamond Aircraft Ind DA 40 · S/N 40.731N756QVCessna TU206G · S/N U20604280N7576EChampion 7FC · S/N 7FC-264N759VYCessna 182Q · S/N 18266305N77221Cessna 140 · S/N 11683N800TMPiper PA-32RT-300 · S/N 32R-7985088N825JBCirrus Design SR20 · S/N 1696N858JACessna TU206F · S/N U20603437N859ALCessna TU206G · S/N U206-04888N8757MBeech 23 · S/N M-545N895UDDJI PHANTOM 4 PRO V2.0 · S/N 11UDH2UR710164N90874Piper PA-28-181 · S/N 28-8690014
Back to South Bend, IN