Willow, AK
Registered aircraft · 127
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 = 'WILLOW' 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 = 'WILLOW' 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.
N1013HAeronca 15AC · S/N 15AC-15N101ZYPiper PA-12 · S/N 12 1935N11098Champion 7ECA · S/N 7ECA-106N110MKMoll Kenneth R MERLIN GT · S/N KRM001N115CXDehavilland DHC-2 MK. I(L20A) · S/N 1151N1205BCessna 210-5(205) · S/N 205-0190N1283HAeronca 15AC · S/N 15AC-299N13149Cessna 170A · S/N 19356N14187Stinson SR-5E · S/N 9279-AN1493HPiper PA-14 · S/N 14-93N1542UCessna U206F · S/N U20602249N1544Dehavilland BEAVER DHC-2 · S/N 1230N1545Dehavilland DHC-2 MK. I(L20A) · S/N 1493N1606APiper PA-18-150 · S/N 18-1246N16872Fairchild 24 H · S/N 3201N170WTPiper PA-12 · S/N 12-753N1748PPiper PA-22-150 · S/N 22-2539N180RNCessna 180J · S/N 18052561N1842XCessna 182H · S/N 18255942N185KACessna A185F · S/N 18503932N1979TCessna A185F · S/N 18503686N207CWWalls Craig C SNOWYRIVER SPECIAL · S/N 001N2131FCessna U206 · S/N U206-0331N225PZProtzman James C PA-18 · S/N TC0701008N22625Taylorcraft BL-65 · S/N 1273N2376Robinson Helicopter R22 BETA · S/N 2062N25KMPiper PA-18-150 · S/N 188009017N2661DCessna 170B · S/N 20813N2669PPiper PA-18-150 · S/N 18-4393N27440Taylorcraft BL-65 · S/N 2082N2809LCessna 172H · S/N 17256009N280DBSud SA 318C · S/N 1943N2948CCessna 180 · S/N 31730N2962ACessna 180 · S/N 30162N29671Taylorcraft BC-65 · S/N 2515N30520Piper J5A · S/N 5-213N3158BCessna 170B · S/N 25400N31GMRobinson Helicopter R44 · S/N 1117N320SLSayres D/Leady D MONTANA COYOTE · S/N 03206N327LLLudwig Larry E BUSHWACKER · S/N 8939N3422YCessna 180H · S/N 18051922N35937Cessna U206F · S/N U20602812N3698MPiper PA-12 · S/N 12-2643N3828PPiper PA-22-150 · S/N 22-3518N388XMaule M-5-235C · S/N 7018CN401WCCessna A185F · S/N 18502235N404Fairchild 24W-40 · S/N 172N40807Maule M-4-220C · S/N 2076CN4151ZPiper PA-18-150 · S/N 18-8327N4370APiper PA-18-150 · S/N 18-4772
Back to Willow, AK