Hunter Aviation International Inc
Registered aircraft · 19
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 = 'HUNTER AVIATION INTERNATIONAL INC' OR list_contains(g.other_registrant_names, 'HUNTER AVIATION INTERNATIONAL INC') 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 = 'HUNTER AVIATION INTERNATIONAL INC' OR list_contains(g.other_registrant_names, 'HUNTER AVIATION INTERNATIONAL INC') 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.
N324AXHawker Aircraft Factory HAWKER HNTR FMK 58 · S/N 41H-697390N325AXHawker Siddeley HAWKER HUNTER MK 58 · S/N 41H697462N326AXHawker Siddeley HAWKER HUNTER MK 58 · S/N XE-68N328AXHawker HAWKER HUNTER MK.58 · S/N 41H-697398N330AXHawker HAWKER HUNTER MK.58 · S/N 41H-697457N331AXHawker HAWKER HUNTER MK.58 · S/N 41H-697439N334AXHawker HAWKER HUNTER MK.58 · S/N 41H-679904N336AXHawker HAWKER HUNTER MK.58 · S/N 41H-697396N339AXHawker Aircraft Factory HAWKER HUNTER MK 58A · S/N 41H697427N340AXHawker HAWKER HUNTER MK.58 · S/N 41H697464N341AXHawker HAWKER HUNTER MK.58 · S/N 41 H 697440N344AXHawker Siddeley HUNTER MK.58 · S/N 41H-697429N345AXHawker HAWKER HUNTER MK.58 · S/N 41HR-HABL003115N346AXHawker HUNTER MK.68 · S/N HABL/003215N348AXHawker Hunter MK 58 · S/N 41H697453N350AXHawker HAWKER HUNTER F.6A · S/N S4/U/3361N353AXHawker Hunter MK 58 · S/N 41H697395N354AXHawker HAWKER HUNTER MK.58 · S/N 41H-697424N98YCDassault FALCON 900 EX · S/N 11
Back to Hunter Aviation International Inc