Palmyra, WI
Registered aircraft · 18
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 = 'WI' AND g.registrant_city = 'PALMYRA' 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 = 'WI' AND g.registrant_city = 'PALMYRA' 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.
N1094ZChitwood Baby Ace 1963 · S/N 1N116GTGerald Thiemer QUICK GT400 · S/N 001GTMRRegistration pendingN133FXJunkim Dwight L MOSQUITO XET · S/N MXE1018A07N19625Cessna 172L · S/N 17260619N2913SCessna 150G · S/N 15066813N30433Cessna 177A · S/N 17701251N3141YSims Orval T SMITH MINI-PLANE · S/N 101N400GVQuicksilver GT-400 · S/N 1275N4403KRyan NAVION · S/N NAV-4-1403N4463JPiper PA-28-140 · S/N 28-22878N5032JBellanca 7GCAA · S/N 372-79N5111MTaylorcraft BC12-D · S/N 10411N5597WPiper PA-28-160 · S/N 28-733N649SPEmbraer S A EMB-545 · S/N 55010076N77876Luscombe 8A · S/N 3603N8042FCessna 172M · S/N 17264378N84163Aeronca 7AC · S/N 7AC-2849N91CGPiper PA-28-140 · S/N 28-20214
Back to Palmyra, WI