Anchorage, AK
Registered aircraft · 2,527
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 = 'ANCHORAGE' 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 = 'ANCHORAGE' 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.
N1002HMaule M-7-235B · S/N 23038CN1008XPiper PA-28-151 · S/N 28-7515373N1009APiper PA-18 · S/N 18581N1018DDehavilland BEAVER DHC-2 · S/N 293N101AKKodiak KODIAK 100 · S/N 100-0356N101CGCessna 208B · S/N 208B5191N101EECessna TU206G · S/N U20606602N101LJCessna 172M · S/N 17267273N1028FCessna A185F · S/N 18502695N102TPiper PA-18-125 · S/N 18-2216Registration pendingN1041APiper PA-18 · S/N 18-619N10436Cameron Balloons O-77 · S/N 6395N1044LMaule M-7-235C · S/N 25009CN1046VCessna TU206F · S/N U20602418N1047BBeech C18S · S/N 7728N10485Maule M-7-235B · S/N 23042CN104KCessna 207 · S/N 20700122N104LNEurocopter AS 350 B3 · S/N 4094N104RCCessna A185E · S/N 1851098N1051VCessna U206F · S/N U20602421N1058NCessna 208B · S/N 208B0347N1061PCessna U206G · S/N U20606773N107TAPiper PA-32-300 · S/N 32-7540099N1086BRobinson Helicopter R44 II · S/N 14698N1086FCessna 208B · S/N 208B0436N108GStinson 108-1 · S/N 108-1751N1092CRobinson Helicopter R44 II · S/N 14687N1099FCessna A185F · S/N 18502754First renewal noticeN109KSDehavilland BEAVER DHC-2 MK.1 · S/N 1295N109RBPiper PA-28-180 · S/N 282612N109RCCessna U206F · S/N U20602616N11088Zachary Johnson MRJS-11 · S/N 1N11097Cessna 150L · S/N 15075198N110AXBeech 1900C · S/N UC-93N110DMPiper PA-46-600TP · S/N 4698265N110WSRaytheon HAWKER 800XP · S/N 258388N1116WCessna 208B · S/N 208B0411N111AXBeech 1900C · S/N UC-81N111EBDehavilland BEAVER U-6A · S/N 1173N1123EPiper PA-18-150 · S/N 18-7909062N1123FCessna 206H · S/N 20608173N1128APiper PA-18 · S/N 18-721N1129APiper PA-18-125 · S/N 18-722N112PAPiper PA-12 · S/N 12-2158N11312Charles E Miller DRAGONFLY 102 · S/N 1021N1131PPiper PA-23 · S/N 23-141N1138ZCessna 150J · S/N 15069760N113AXBeech 1900C · S/N UC-41N113BCCampbell Reid H SUPER CROW RAVEN · S/N 001N113DUWick Berchmans D RV-8 · S/N 82599
Back to Anchorage, AK