Talkeetna, AK
Registered aircraft · 94
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 = 'TALKEETNA' 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 = 'TALKEETNA' 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.
N100BWDehavilland DHC-3 · S/N 58N1047FCessna A185F · S/N 18502704N108USUniversal Stinson 108-2 · S/N 108-2841N11647Bellanca 7GCBC · S/N 345-72N126GSPiper PA-12 · S/N 12-1270N127GSPiper PA-12 · S/N 12-273N135WKPiper PA-18 · S/N 182160N166TPiper PA-18 105 · S/N 18-2280N180LAAmerican Champion 8GCBC · S/N 368-94N185FKCessna A185F · S/N 18502513N205RCDehavilland DHC-3 · S/N 201N21709Cessna A185F · S/N 18503064N23002Silvaire LUSCOMBE 8A · S/N 929N2515LCessna 172H · S/N 17255715N2526RCessna 182K · S/N 18258226N25791Donald Chapton SUPERCUB · S/N JA2102156N264MAAmerican Champion 7GCAA · S/N 482-2004N2760CCessna 170B · S/N 26304N279TPiper PA-18 105 · S/N 18-2393N2YVDehavilland DHC-3 · S/N 207N3304BPiper PA-22 · S/N 22-2119N3321BPiper PA-22 · S/N 22-2136N3392MPiper PA-12 · S/N 12-2236N3598MPiper PA-12 · S/N 12-2444N3689PPiper PA-18A 150 · S/N 18-4590N3910ZPiper PA-18 · S/N 18-7726N4028HPiper PA-12 · S/N 12-3456N405EWWheeler Evan EXPERIMENTAL HOMEBUI · S/N 001N4111CStinson 108-3 · S/N 108-5111N4180EAeronca 11CC · S/N 11CC-81N4298ZPiper PA-18-150 · S/N 18-8555N4377URobinson Helicopter R44 II · S/N 12814N4380MPiper PA-12 · S/N 12-3316N4427BCessna 170B · S/N 26771N4451APiper PA-22-150 · S/N 22-3783N4564EChampion AERONCA 7CCM · S/N 7CCM-130N48314Dodd BREEZY · S/N 62654-5-AN4QHRobinson Helicopter R44 II · S/N 13773N50390Cessna 150H · S/N 15069269N510PRDehavilland DHC-3 · S/N 250N5119HPiper PA-14 · S/N 14-125N51436Maule M-4-210C · S/N 1101CN515RVCessna A150M · S/N A1500594N5188HPiper PA-14 · S/N 14-506N522EFKen A Felix FELIX FLYER · S/N 83400N540SGZivko Aeronautics EDGE 540 · S/N 0035N549ZWRiley J Martin DOUBLE CUBBLE · S/N 1N54ATArctic S-1B2 · S/N 1005N56366Maule M-5-235C · S/N 7308CN5652HMaule M-6-235 · S/N 7447C
Back to Talkeetna, AK