Glover William S
Registered aircraft · 22
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 = 'GLOVER WILLIAM S' OR list_contains(g.other_registrant_names, 'GLOVER WILLIAM S') 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 = 'GLOVER WILLIAM S' OR list_contains(g.other_registrant_names, 'GLOVER WILLIAM S') 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.
N1004Curtiss Wright TRAVEL AIR 4000 · S/N 416N1042BNorth American B-25N · S/N 44-30823AN12164Stinson JR. S · S/N 8102N16793Fleetwings F401 · S/N 1N17662Spartan 7W · S/N 28N17MParamount CABINAIRE · S/N 7N20961Waco SRE · S/N 5086N2108PPiper PA-23 · S/N 23-698N2445Antonov AN-2 · S/N 1G11756N250DLockheed 18-56 · S/N 2597N32455Cessna C-165 · S/N 588N3277GCurtiss Wright ROBIN · S/N 237N333LTCook Robert K RV-3 · S/N 495N34DAPiper PA-23-160 · S/N 231469N41HQDouglas DC3A 1830-94 · S/N 2053N656KStearman C3-R · S/N 5007N7286White NEW STANDARD D-25A · S/N 167WN824KMDehavilland DHC-1B-2-S3 · S/N 126-164N86SGGame Composites GB1 GAMEBIRD · S/N 0115N9135Fairchild 71 · S/N 631N9396Fairchild 22 C7F · S/N 1606N9612Ford 4-AT-E · S/N 55
Back to Glover William S