West Lafayette, IN
Registered aircraft · 95
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 = 'WEST LAFAYETTE' 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 = 'WEST LAFAYETTE' 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.
N111ACAmerican Champion 7EC · S/N 1026-2008N1208HPiper PA-28-181 · S/N 28-7790296N12XCWilloughby Ralph Eliot SONERAI I · S/N 218N136CDBeech A36 · S/N E-1162N148SSBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1499N150RVHeadrick James C RV-4 · S/N 959N1571HCessna 177RG · S/N 177RG0745N2190BPiper PA-32RT-300 · S/N 32R-7985014N244DBCessna 182P · S/N 18265043N273NDPiper PA-28-161 · S/N 28-42073N277PMRuley Paul B RV-7A · S/N 73461N281DAXag P150 · S/N 186324P18223502981PJN2884LPiper PA-28-161 · S/N 28-7916507N3033TPiper PA-28-161 · S/N 28-7916305N3346ECessna 172N · S/N 17271512N3430BBeech D35 · S/N D-3668N34LBHughes 269C · S/N 780714N35063Cessna 172S · S/N 172S8878N3548NPiper J3C-65 · S/N 22786N374VMEavision EA-J150 · S/N JMZKJ150UAV602596307N386GRXag P150 · S/N 186324P18223502N3H09N4136UCessna 150D · S/N 15060136N4347GPiper PA-28-161 · S/N 28-8416062N4444WCessna 182D · S/N 18253371N448PUIniziative Industriali Italian SKY ARROW 600 SPORT · S/N LSA010N454SBXag P150 · S/N 186324P1822344359S0RN4682SDJI AGRAS T50 · S/N 1581F6BUB243S001FF0FN46982Purdue Univ Vertical Flght SYS BOILER UP · S/N 001N4753VXag P150 · S/N 186324P18223443PW104N51204Cessna 172P · S/N 17274279N519EAFFF EXPRESS 2000 FT · S/N 0001N529NJJeffrey Pete Runyan VANS RV-8 · S/N 83125N5331DCessna 172N · S/N 17272522N560PUPiper PA-28-161 · S/N 2842098N564PUPiper PA-28-161 · S/N 2842169N570PUPiper PA-44-180 · S/N 4496141N571PUPiper PA-44-180 · S/N 4496142N5724JCessna 172N · S/N 17273827N572PUPiper PA-44-180 · S/N 4496583N5737NMooney M20J · S/N 24-1445N573PUPiper PA-44-180 · S/N 4496584N589AGDJI AGRAS T30 · S/N 1581F446LJ6120300CJ0N595TVCirrus Design SR22 · S/N 0485N6119ACessna T210N · S/N 21063502N63366Cessna 172P · S/N 17275426N653PATextron 172S · S/N 172S12163N654PATextron 172S · S/N 172S12141N6605FPiper PA-28-151 · S/N 28-7715171N6618AXag P150 MAX · S/N 186325P18227551U148PN662JVXag P150 MAX · S/N 186325P18227551N6F08
Back to West Lafayette, IN