Hammond, LA
Registered aircraft · 52
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 = 'LA' AND g.registrant_city = 'HAMMOND' 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 = 'LA' AND g.registrant_city = 'HAMMOND' 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.
N12796Cessna 172M · S/N 17262267N1288HPiper PA-28-161 · S/N 28-7716011N153LMPiper PA-23-250 · S/N 27-7754019N1588AST Amant Sidney L KITFOX IV · S/N 1588N182KPCessna 182D · S/N 18253296N201MFMooney M20J · S/N 24-0096N20932Cessna 172M · S/N 17263872Registration pendingN216RAMooney M20R · S/N 29-0519N2205QFirefly Balloons FIREFLY 7-15 · S/N F7-2056N270GGPiper PA-23-250 (6PCLM) · S/N 27-7554085N3072DPiper PA-28-161 · S/N 28-7916161N32RWPiper PA-23-250 · S/N 27-4667N3315KGlobe GC-1B · S/N 1308N331DVHonda HA-420 · S/N 42000043N3730MPiper PA-28R-201 · S/N 28R-7837133N401PJPiper PA-23-250 · S/N 27-4112N4080KNorth American NAVION · S/N NAV-4-1080N436NDPiper PA-28-161 · S/N 2842213N5054CBellanca 7GCBC · S/N 1148-79N5156WPiper PA-28-160 · S/N 28-187N52012Cessna 172P · S/N 17274393N5356FPiper PA-28-151 · S/N 28-7715107Non-citizen corporation, flight hours not reportedN54739Cessna 172P · S/N 17275045N54951Cessna 172P · S/N 17275087N55211Cessna 172P · S/N 17275135N5979FPiper PA-34-200T · S/N 34-7770029N62266Cessna 172P · S/N 17275239N62332Cessna 172P · S/N 17275251N62654Piper PA-23-250 · S/N 27-7654120N63763Piper PA-23-250 · S/N 27-7754096N654JMMach John MURPHY REBEL · S/N 574RN66VEBell OH-58C · S/N 68-16870N6963JPiper PA-28-151 · S/N 28-7615411N712JTPiper PA-23-250 · S/N 27-7954057N7178QCessna 172L · S/N 17260478N7209BBeech 58 · S/N TH-1428N765TXTillery Jack L VANS RV-8 · S/N 80991N76SRPiper PA-23-250 · S/N 27-7304976N80118Cessna 172M · S/N 17266382N80UMPiper PA-28RT-201 · S/N 28R7918090N81149Piper PA-28-161 · S/N 28-8216110N827ADPiper PA-34-200T · S/N 34-7970317N82BLPiper PA-23-250 · S/N 27-7754049N83542Aeronca 7BCM · S/N 7AC-2218N84863Cessna 172K · S/N 17258644N888TGPiper PA-23-250 · S/N 27-7654032N902KKDJI AGRAS T30 · S/N 3U5BJ4H00100T2N914ZCessna 172M · S/N 17264444N96403Cessna 182Q · S/N 18266708N96462Cessna 182Q · S/N 18266728
Back to Hammond, LA