North Pole, AK
Registered aircraft · 157
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 = 'NORTH POLE' 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 = 'NORTH POLE' 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.
N1011HAeronca 15AC · S/N 15AC-13N1072APiper PA-18 · S/N 18-655N1112APiper PA-18-125 · S/N 18-704N116CHHosack Charles R SEAREY · S/N 1DK375CN119CCPiper PA-18-150 · S/N 18-7409126N124GSPiper PA-18 · S/N 5287N1393CPiper PA-20 · S/N 20-980N1404EAeronca 7AC · S/N 7AC-4952N1409DCessna 170A · S/N 19992N1441HAeronca 15AC · S/N 15AC-506N1499NPiper J3C-65 · S/N 23027N1535APiper PA-20 · S/N 20-731N15HJCessna 172N · S/N 17268950N1755PPiper PA-18-150 · S/N 18-4075N180AXCessna 180H · S/N 18051910N181MJMaule M-7-235C · S/N 25014CN18ECTaylorcraft F19 · S/N F-083N2140RRichmond Jim JR1 · S/N 01N21474Cessna 182P · S/N 18261654N2202VCessna 140 · S/N 14432N2259CDrew Bennett J CHALLNGER · S/N CH205951340N22867Cessna 150H · S/N 15068575N228SHRobinson Helicopter R22 BETA · S/N 4014N2376PPiper PA-22-150 · S/N 22-2767N2435DCessna 170B · S/N 20587N246JSOdom James B RV6 · S/N 60201N2474ZPiper PA-18-135 · S/N 18-3592N2487DCessna 170B · S/N 20639N256AKCook Jimmy D. CUBY · S/N 256N2578DCessna 170B · S/N 20730N2586MPiper PA-12 · S/N 12-1047N2610JCessna 150G · S/N 15065610N2683BBrandon J Stephens PA-18 · S/N JA2009145N2746DCessna 170B · S/N 25288N2772XCessna 180H · S/N 18051572N2785MPiper PA-12 · S/N 12-1164N2819CCessna 170B · S/N 26362N2870NCessna 120 · S/N 13131N28973Christen Industries A-1 · S/N 1018N3085ACessna 170B · S/N 25729N3091ACessna 170B · S/N 25735N3092YCessna 182E · S/N 18254092N3179BCessna 170B · S/N 25421N3214SPiper PA-18-150 · S/N 18-8309004N33585Piper J3C-65 · S/N 14062N3377ZPiper PA-18-150 · S/N 18-7258N338VXPaul A Woodward VX CUB · S/N 01VX18N3444CCessna 170B · S/N 26487N3539ECessna 180B · S/N 50398N3570UCessna 182F · S/N 18254970
Back to North Pole, AK