OpenAirDocs.org
Dhs Operations LLC

Registered aircraft · 20

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 = 'DHS OPERATIONS LLC' OR list_contains(g.other_registrant_names, 'DHS OPERATIONS LLC')
  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.

N102HWCessna 172R · S/N 17281058Built 2001 · Wilmington, DEN2111FPiper PA-44-180 · S/N 44-7995153Built 1978 · Wilmington, DEN2369ZCessna 172R · S/N 17280658Built 1999 · Wilmington, DEN3508JCessna 172R · S/N 17281060Built 2001 · Wilmington, DEN428FFCessna 172R · S/N 17281228Built 2004 · Wilmington, DEN429FFCessna 172R · S/N 17281229Built 2004 · Wilmington, DEN456MBCessna 172R · S/N 17280033Built 1997 · Wilmington, DEN480SPCessna 172S · S/N 172S8025Built 1998 · Wilmington, DEN491WSCessna 172S · S/N 172S8305Built 1999 · Wilmington, DEN6024ECessna 172S · S/N 172S10200Built 2006 · Wilmington, DEN613ACessna 172R · S/N 17280248Built 1997 · Wilmington, DEN92228Cessna 172S · S/N 172S11498Built 2014 · Wilmington, DEN9222HCessna 172S · S/N 172S11497Built 2014 · Wilmington, DEN9223CCessna 172S · S/N 172S11499Built 2014 · Wilmington, DEN9223ECessna 172S · S/N 172S11500Built 2014 · Wilmington, DEN9223XCessna 172S · S/N 172S11501Built 2014 · Wilmington, DEN92264Cessna 172S · S/N 172S11502Built 2014 · Wilmington, DEN92266Cessna 172S · S/N 172S11503Built 2014 · Wilmington, DEN9230YCessna 172S · S/N 172S11505Built 2014 · Wilmington, DEN9713FCessna 172R · S/N 17280018Built 1997 · Wilmington, DE
Back to Dhs Operations LLC