Elkhart, IN
Registered aircraft · 49
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 = 'ELKHART' 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 = 'ELKHART' 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.
N11WNBeech F90 · S/N LA177N130CTCraig S Trout TITAN TORNADO II · S/N D15912COHK0555N1434CPiper PA-22-135 · S/N 22-1189Registration revokedN144AXRobinson Helicopter R44 II · S/N 11827N1498GRobinson Helicopter R66 · S/N 0378N1886VCessna 172M · S/N 17263782N192GMMoore Glenn G VARIEZE · S/N 9-2N251SADiamond Aircraft Ind DA 62 · S/N 62.C077N3521VCessna 140 · S/N 14790N36384Piper PA-28R-201 · S/N 28R-7837277N3900WPiper PA-32-260 · S/N 32-846N39489Piper PA-32RT-300T · S/N 32R-7887096N4253Stits Playmate SA-11A · S/N 151N4478WRobinson Helicopter R66 · S/N 0116N447CHPiper PA46-500TP · S/N 4697374N456KJEnstrom Helicopter 480B · S/N 5238N458EAeronca 11AC · S/N 11AC-1092N45903Luscombe 8A · S/N 2430N4679GCessna 172N · S/N 17273305N482MPTextron 525C · S/N 525C0406N5028SPiper PA-28R-200 · S/N 28R-35772N5156KRyan NAVION B · S/N NAV-4-2056BN537MMAviat A-1 · S/N 1302N539LCCessna 525C · S/N 525C-0114N53GABeech B200 · S/N BB-1201N574CMKehn Bill F1 ROCKET · S/N 99N5866JBeech 35-C33 · S/N CD-925N596LCBombardier BD-100-1A10 · S/N 20596N59AHAerospatiale SA315B · S/N 2588N5HAAirbus Helicopters EC 130 T2 · S/N 8645N6119LAmerican AA-1 · S/N AA1-0319N6245TCessna 150E · S/N 15060945N6271FRidenour Wendell Ray CH-601 HDS · S/N 6-3234N6353PPiper PA-24 · S/N 24-1463N650LMHursh Larry L ZENITH CH650 · S/N 65-7500N6628RBeech C23 · S/N M-1607N717EHCessna 560XL · S/N 560-6008N8275XCessna 172C · S/N 17248775N829SAPilatus PC-12/47E · S/N 1533N85HACessna 560XL · S/N 560-6183N878CHCessna 550 · S/N 550-1067N8841XCessna 182D · S/N 18253241N8861Bellanca 7ACA · S/N 71-73N88PVImhof Paul S RV-8 · S/N 80024N9046YBoeing A75N1(PT17) · S/N 75-2337N9179HCessna 172M · S/N 17265995N93GJPeterson Gary RANS S6ES · S/N 0593499N9632ZCessna TU206G · S/N U20606585N986RVGraf Robert H VANS RV-6 · S/N 22075
Back to Elkhart, IN