OpenAirDocs.org
US Department Of State

Registered aircraft · 21

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 = 'US DEPARTMENT OF STATE' OR list_contains(g.other_registrant_names, 'US DEPARTMENT OF STATE')
  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.

N194WBBell UH-1N · S/N 159194Melbourne, FLN19WNSikorsky HH-60L · S/N 04-27019Melbourne, FLN274AWBell UH-1N · S/N 158274Melbourne, FLN35WNSikorsky HH-60L · S/N 05-27035Melbourne, FLN36LNSikorsky HH-60L · S/N 05-27036Melbourne, FLN408SNRaytheon 1900D · S/N UE-408Melbourne, FLN563AWBombardier DHC-8-315 · S/N 563Melbourne, FLN568AWBombardier DHC-8-315 · S/N 568Melbourne, FLN569AWBombardier DHC-8-315 · S/N 569Melbourne, FLN7038WBell UH-1V · S/N 74-22380Melbourne, FLN770WLSikorsky HH-60L · S/N 97-26770Melbourne, FLN771WCSikorsky HH-60L · S/N 97-26771Melbourne, FLN774WRBell UH-1N · S/N 158774Melbourne, FLN78970Bell UH-1N · S/N 135126Melbourne, FLN800AWBombardier DHC-8-315 · S/N 573Melbourne, FLN8240XBell UH-1H · S/N 70-16285Melbourne, FLN82419Bell UH-1H · S/N 71-20009Melbourne, FLN875ARSikorsky HH-60L · S/N 00-26875Melbourne, FLN892AWSikorsky HH-60L · S/N 83-23892Melbourne, FLN988WLSikorsky HH-60L · S/N 03-26988Melbourne, FLN990AWSikorsky HH-60L · S/N 03-26990Melbourne, FL
Back to US Department Of State