Homer, AK
Registered aircraft · 199
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 = 'HOMER' 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 = 'HOMER' 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.
N100PCCessna T207A · S/N 20700467N10196Hiller UH-12B · S/N 340N104BMDehavilland DHC-3 · S/N 118N1070LLake LA-4-200 · S/N 663N1083HAeronca S15AC · S/N 15AC-102N10CMCubcrafters CC11-160 · S/N CC11-00423N121LLCessna U206G · S/N U20603756N14621Cessna L-19A · S/N 21056N1557PPiper PA-18-135 · S/N 18-3711N15DJDJI PHANTOM 3 STANDARD · S/N P5ADDL280R01RRN1618MCessna A185E · S/N 18501834N1782DCessna 170B · S/N 20350Registration pendingN180EADehavilland BEAVER U-6A · S/N 1011N180MMCessna 180J · S/N 18052574N185GMCessna 185A · S/N 185-0424N1880PPiper PA-18-150 · S/N 18-4160N193ALBell Helicopter Textron Canada 206L-4 · S/N 52344N206CTCessna TU206G · S/N U206-06090N206GMCessna U206G · S/N U20606837N206JCessna U206C · S/N U2060965N206JWCessna TU206G · S/N U20606283N2241XCessna T206H · S/N T20608736N2294APiper PA-22-135 · S/N 22-679N2311KSilvaire LUSCOMBE 8A · S/N 5038N233WRCessna U206G · S/N U20603574N24187Cessna A185E · S/N 18502031N2423UCessna 172D · S/N 17250023N2449VCessna 140 · S/N 14701N2470MPiper PA-12 · S/N 12-1551N2518YCessna 172D · S/N 17249818N254AWDehavilland DHC-3 · S/N 254N25ELuscombe 8E · S/N 5244N27024Piper J3L-65 · S/N 4332N2703GCessna 182B · S/N 52003N2707GCessna 182B · S/N 52007N2722XCessna 180H · S/N 18051522N2760PPiper PA-22 · S/N 22-3070N2797JCessna A185E · S/N 185-1555N2801KCessna 180K · S/N 18053072N295BHelio USAF U-10D · S/N 1252N2978ACessna 180 · S/N 30178N305MHBell 206-L4 · S/N 52292N308MHBell 407 · S/N 53647N309MHBell Helicopter Textron Canada 407 · S/N 53728N30WBBaechler William F GS1 · S/N 5726N311MHBell 206-L4 · S/N 52055N312MHBell Helicopter Textron Canada 407 · S/N 53740N314MHBell 206-L4 · S/N 52119N314SRRoesler Scott D ROESLER GLASAIR · S/N 314N316MHBell Helicopter Textron Canada 206L-4 · S/N 52323
Back to Homer, AK