Bethel, AK
Registered aircraft · 120
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 = 'BETHEL' 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 = 'BETHEL' 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.
N102SYDehavilland BEAVER DHC-2 MK.1 · S/N 1367N1151ZAero Commander 500-B · S/N 1524-186N1301LCessna T207A · S/N 20700641N1322FCessna A185F · S/N 18502825N145ASArcher S E/Archer S K MURPHY ELITE · S/N 556EN148RFPiper PA-32R-300 · S/N 32R-7680076First renewal noticeN1658UCessna 207 · S/N 20700258N172WCessna 172L · S/N 17260099N1750UCessna 207 · S/N 20700350N180YPCessna 180G · S/N 18051349N1827GChampion 7ECA · S/N 587N18NTDehavilland DHC-2 MK. I(L20A) · S/N 222N19771Cessna 172L · S/N 17260739N1994UCessna A185E · S/N 18501761N202GTMaule M-7-235 · S/N 4111CN21015Cessna 172M · S/N 17263888N23CFCessna 207 · S/N 20700276N24165Beech 58TC · S/N TK-78N2526DCessna 170B · S/N 20678N2726PPiper PA-22-150 · S/N 22-3032N2775ECessna 172N · S/N 17271316N2880MPiper PA-12 · S/N 12-1309N29970Cessna 185 · S/N 185-04292N2UVBeech B90 · S/N LJ-480N327CTCessna 207A · S/N 20700535N3439DCessna 170B · S/N 26982N3460LCessna U206B · S/N U206-0760N35497Piper PA-31-350 · S/N 31-8052039N355XMaule M-5-210C · S/N 6179CN3615MPiper PA-12 · S/N 12-2461N37CHBeech A36 · S/N E-1460N3862GCessna U206B · S/N U206-0862N39AKCessna 207A · S/N 20700597N40449Piper PA-32R-300 · S/N 32R-7780519N4112DPiper PA-31-350 · S/N 31-8353004N4112EPiper PA-31-350 · S/N 31-8353005N41189Piper PA-31-350 · S/N 31-8553002N4118GPiper PA-31-350 · S/N 31-8453001N4194WCessna A185E · S/N 1851203N4237VBell UH-1B · S/N 261N4419EBell 47G · S/N K651N44239Taylorcraft BC12-D · S/N 10039N4424LCessna 172G · S/N 17254513N44ACPiper PA-31-350 · S/N 31-8052147N44RTPiper PA-18-150 · S/N 18-8927N4526MPiper PA-11 · S/N 11-31N46FAPiper PA-31-350 · S/N 318152020N4710QCessna A185E · S/N 185-1164N4802ZPiper PA-18-150 · S/N 18-7800N4810GCessna 172N · S/N 17273358
Back to Bethel, AK