Soldotna, AK
Registered aircraft · 258
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 = 'SOLDOTNA' 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 = 'SOLDOTNA' 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.
N106WTPiper PA-18-150 · S/N 18-5943N1103APiper PA-18-125 · S/N 18-691N1107XS C Humphreys/W C Alsworth SR BEE CRAFT MHV HNTR 3 · S/N 003N1112TCessna 180C · S/N 50713Registration pendingN1124BCessna 182A · S/N 34259N1169YCessna 150B · S/N 15059569N11849Cessna 150L · S/N 15075675N134RTTaylor Robert E BEARHAWK · S/N 78N14167Piper PA-18-150 · S/N 18-7409097N1426Sea & Sky KRUCKER CYGNET · S/N 20111N14298Piper PA-18-150 · S/N 18-7409062N146TPiper PA-18 · S/N 18-2260N1470QCessna A185F · S/N 18503483N150BADehavilland DHC-3 · S/N 15N1565CCessna 180 · S/N 30265N1590APiper PA-20 · S/N 20-826N1610APiper PA-18-125 · S/N 18-1252N1629DCessna 170B · S/N 20271N1671RCessna A185F · S/N 18502394N1685VCessna 140 · S/N 13857N1702CCessna 180 · S/N 30402N170JLCessna 170B · S/N 25560N173MMMickey E Duyck RV-7A · S/N 70363N177ACAeronca 7AC · S/N 7AC-5275N180DTCessna 180 · S/N 31023N180RJCessna 180 · S/N 32414N185CQCessna 185A · S/N 1850400N185SPCessna A185F · S/N 18503175N187WCAaron T Burcham PA 18 · S/N 18-07-3513N18YYCraig Macdonald MAC CUB · S/N 002N1945NCessna 120 · S/N 12185N196ARCessna 172N · S/N 17272023N2025SPiper PA-18-150 · S/N 18-7609097N20495Christen Industries A-1 · S/N 1045N2104FCessna U206 · S/N U206-0304N2192GCessna 182A · S/N 51492N221KMS.O.C.A.T.A. MS894A · S/N 12014N222RLDehavilland DHC 2 MK III · S/N 1570N2349DCessna 170B · S/N 20501N235DAPiper PA-23-235 · S/N 27-582N2431VCessna 206H · S/N 20608093N2432NCessna 140 · S/N 12684N251SKKregal Steven SQ2 · S/N TCQ0904059N252TADehavilland DHC-3 · S/N 252N253TACessna 208 · S/N 20800222N2621APiper PA-18 105 · S/N 18-2168N2623BBlanc Donald R GLASTAR KIT STD HMLT · S/N 5160N26275Stinson 10 · S/N 7559N262DQCessna U206G · S/N U20604479N2640YCessna 180E · S/N 18051140
Back to Soldotna, AK