Skip to content

Hughes Aero PREDATOR

Registered aircraft · 14

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('05901TG', '05901ZM', '05902DL', '05902KX', '05904U3', '05904H8')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('05901TG', '05901ZM', '05902DL', '05902KX', '05904U3', '05904H8')
ORDER BY 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.

N103FUOvermier Timothy G · Independence, LABuilt 2009 · S/N PC5110631 N1269BMidwest Vertical Vision LLC · Greenwood, MOBuilt 2007 · S/N PC04079SP4 N13YWSahni Irvin · Seguin, TXBuilt 2006 · S/N PC070653W306 N156TXDucote Kendall J · Prairieville, LABuilt 2008 · S/N PC120791P504 N1659SWeesner David F · Apache Junction, AZBuilt 2006 · S/N PC 120553W302 N2053HCowart Ron W · Bay City, TXBuilt 2007 · S/N P040553WA N2572FBailey Corinne · Giddings, TXBuilt 2007 · S/N PC010753W4CR N26327Dean William D Jr · Jasper, GABuilt 2006 · S/N SH010 N2666AMurphy Lawrence L · Shepherd, TXBuilt 2007 · S/N PC09753W401 N42UPWhite Gil R · Blanchard, OKBuilt 2007 · S/N PC090753W403 N458JSSullivan Jim W · Adolphus, KYS/N PC040453W43 N912AMBruening Michael S · Humboldt, SDS/N PC03079XW3 N912ULCarnes Jay P · Texas City, TXBuilt 2007 · S/N PC04070291I3 N936TXSunda Henry J · Douglass, TXBuilt 2008 · S/N PC0208REP401

Back to Hughes Aero PREDATOR