Windward Aviation Inc
Registered aircraft · 25
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
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_name = 'WINDWARD AVIATION INC' OR list_contains(g.other_registrant_names, 'WINDWARD AVIATION INC') 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_name = 'WINDWARD AVIATION INC' OR list_contains(g.other_registrant_names, 'WINDWARD AVIATION INC') 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.
N10626Curtiss Wright P-40N · S/N 4192N109JMesserschmitt ME 109 G · S/N 392N114HDHughes Helicopters HUGHES 369D · S/N 280261DN154AMEurocopter Deutschland MBB-BK 117-B2 · S/N 7154N2203Coughlin FOKKER OR-1 · S/N 535/17N262WASumma 369D · S/N 790554DN3363GAppleby James S FOKKER E III · S/N AA107N36DVWilliams Arthur A ALBATROS DVA · S/N 0036N38038Windward FOKKER D VII · S/N CFM002N3805ZWindward SOPWITH TRIPLANE · S/N CFM001N3883FWindward SPAD XIII · S/N CFM003N3JBLockheed P-38L · S/N 44-53097N4324Goodyear FG1 · S/N 6163N43CTallman-Pfalz D-12 · S/N 1N5597MSwanson Carl R/Swanson Aero NIEUPORT 27 · S/N S-8N58251Hughes Helicopters HUGHES 369D · S/N 880317DN58252Hughes Helicopters HUGHES 369D · S/N 1080364DN6018Sopwith PUP · S/N A-635N6330Appleby James S SOPWITH CAMEL F1 · S/N AA-105N690WAHughes Helicopters HUGHES 369D · S/N 1170237DN79WWCessna 206H · S/N 20608129N809WAHughes Helicopters HUGHES 369D · S/N 490493DN811WAHughes Helicopters HUGHES 369D · S/N 590517DN828WAMesserschmitt-Bolkow-Blohm BK 117 B-2 · S/N 7219N910AVDavis Thomas C SE5A · S/N 0010
Back to Windward Aviation Inc