Gulfstream Aerospace Corp
Registered aircraft · 281
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 = 'GULFSTREAM AEROSPACE CORP' OR list_contains(g.other_registrant_names, 'GULFSTREAM AEROSPACE CORP') 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 = 'GULFSTREAM AEROSPACE CORP' OR list_contains(g.other_registrant_names, 'GULFSTREAM AEROSPACE CORP') 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.
N100GAGulfstream Aerospace GVIII-G800 · S/N 88100N101GAGulfstream Aerospace GVIII-G800 · S/N 88101N102GAGulfstream Aerospace GVIII-G800 · S/N 88102N103GAGulfstream Aerospace GVIII-G800 · S/N 88103N104GAGulfstream Aerospace GVIII-G800 · S/N 88104N112GAGulfstream Aerospace GVIII-G700 · S/N 87112N175GAGulfstream Aerospace GVIII-G700 · S/N 87075N195GAGulfstream Aerospace GVIII-G700 · S/N 87195N26715Grumman American Avn. AA-5A · S/N AA5A0670N28791Grumman American Avn. AA-5B · S/N AA5B0817N329GAGulfstream Aerospace G-IV · S/N 1329N332GAGulfstream Aerospace G-IV · S/N 1332N369GAGulfstream Aerospace GIV-X (G450) · S/N 4369N370GAGulfstream Aerospace GIV-X (G450) · S/N 4370N400GGulfstream Aerospace GVII-G400 · S/N 71001N400GAGulfstream Aerospace GVII-G400 · S/N 71005N402GAGulfstream Aerospace GVII-G400 · S/N 71002N403GAGulfstream Aerospace GVII-G400 · S/N 71003N404GDGulfstream Aerospace GVII-G400 · S/N 71004N431GAGulfstream Aerospace GVII-G500 · S/N 72231N466GAGulfstream Aerospace GIV-X (G450) · S/N 4366N467GAGulfstream Aerospace GIV-X (G450) · S/N 4367N468GAGulfstream Aerospace GIV-X (G450) · S/N 4368N501GAGulfstream Aerospace GVII-G500 · S/N 72201N502GAGulfstream Aerospace GVII-G500 · S/N 72202N503GAGulfstream Aerospace GVII-G500 · S/N 72203N506GAGulfstream Aerospace GVII-G500 · S/N 72206N507GDGulfstream Aerospace GVII-G500 · S/N 72207N508GAGulfstream Aerospace GVII-G500 · S/N 72208N509GAGulfstream Aerospace GVII-G500 · S/N 72209N510GAGulfstream Aerospace GVII-G500 · S/N 72210N511GDGulfstream Aerospace GVII-G500 · S/N 72211N512GDGulfstream Aerospace GVII-G500 · S/N 72212N513GAGulfstream Aerospace GVII-G500 · S/N 72213N514GAGulfstream Aerospace GVII-G500 · S/N 72214N515GDGulfstream Aerospace GVII-G500 · S/N 72215N516GSGulfstream Aerospace GVII-G500 · S/N 72216N517GAGulfstream Aerospace GVII-G500 · S/N 72217N518GDGulfstream Aerospace GVII-G500 · S/N 72218N519GAGulfstream Aerospace GVII-G500 · S/N 72219N520GDGulfstream Aerospace GVII-G500 · S/N 72200N521GAGulfstream Aerospace G-V · S/N 521N521GDGulfstream Aerospace GVII-G500 · S/N 72221N522GSGulfstream Aerospace GVII-G500 · S/N 72222N523GAGulfstream Aerospace GVII-G500 · S/N 72223N524GAGulfstream Aerospace GVII-G500 · S/N 72204N524GDGulfstream Aerospace GVII-G500 · S/N 72224N525GDGulfstream Aerospace GVII-G500 · S/N 72225N526GDGulfstream Aerospace GVII-G500 · S/N 72226N527GDGulfstream Aerospace GVII-G500 · S/N 72227
Back to Gulfstream Aerospace Corp