Palmer, AK
Registered aircraft · 546
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 = 'AK' AND g.registrant_city = 'PALMER' 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 = 'AK' AND g.registrant_city = 'PALMER' 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.
N1007UMaule M-7-235B · S/N 23047CN1008WMaule M-7-235B · S/N 23022CN101MGKinetic Aviation/Montagne Bill MOUNTAIN GOAT · S/N 0010N1042EBellanca 7ECA · S/N 1207-77N104CFGrumman S2F-1 · S/N 144725N10661Cessna 150L · S/N 15074955N1129Piper PA-18-135 · S/N 18-4022N1131HAeronca 15AC · S/N 15AC-146N1134PPiper PA-23 · S/N 23-146N11369Cessna 150L · S/N 15075359N114MNAero Commander 680FL · S/N 1553-107N118UPiper PA-22 · S/N 22-3988N11PAPiper PA-22 · S/N 22-321N12169Cessna 172M · S/N 17261856N1226HAeronca S15AC · S/N 15AC-238N1227HAeronca 15AC · S/N 15-AC239N1233BCessna 182 · S/N 51215N123LUPiper PA-32-260 · S/N 32394N124LRCessna A185E · S/N 18501639N1258VCessna R172K · S/N R1722154N1278APiper PA-18 · S/N 18-1074Registration pendingN1293DCessna 170A · S/N 19869N129CXAmerican Legend AL18 · S/N AL-1216N1300TCessna 172G · S/N 17253731N134CUniversal Stinson 108-2 · S/N 108-3134N1354CPiper PA-18-135 · S/N 18-2518N1364PPiper PA-18-150 · S/N 18-8265N1380APiper PA-18 · S/N 18-1211N149AKPiper PA-12 · S/N 121338N1523FCessna 185D · S/N 185-0866N1531FCessna 185D · S/N 185-0874N157MAshura Michael J FLYBABY 1A · S/N 70-5293N157SCessna 180 · S/N 31840N1596CCessna 180 · S/N 30296N15MMAmerican Champion 8GCBC · S/N 573-2015N1605NFunk B85C · S/N 390N1639DCessna 170B · S/N 20281N1648YCessna 172C · S/N 17249348N1649PPiper PA-22-150 · S/N 22-2465First renewal noticeN164AKJustin Jones L164 · S/N CA 004-080N1686FCessna 172H · S/N 17255081N16PZAmerican Legend AL11 · S/N AL-1129N1722SCessna 172 · S/N 28656N172JLCessna 172K · S/N 17257724N172REReims CESSNA FR172E · S/N 0041N1754UCessna T207 · S/N 20700354N1755CCessna 180 · S/N 30455N175MCessna 175 · S/N 55282N18067Cessna 150L · S/N 15073769N180GLCessna 180F · S/N 18051203
Back to Palmer, AK