Skip to content

Hiller Aviation

Earlier aircraft under this name · 79

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'HILLER AVIATION' OR list_contains(d.other_registrant_names, 'HILLER AVIATION') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_name = 'HILLER AVIATION' OR list_contains(d.other_registrant_names, 'HILLER AVIATION')
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
WHERE d.registrant_name = 'HILLER AVIATION' OR list_contains(d.other_registrant_names, 'HILLER AVIATION')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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.

N3210FHiller UH-12E4 · S/N 2313Cancelled Sep 27, 2012 · Registration expired, pending cancellation · Built 1976 · Porterville, CA N4030THiller UH-12E · S/N 5157Cancelled Jul 25, 2011 · Expired dealer · Built 1981 · Porterville, CA N6005PFairchild Hiller FH-1100 · S/N 504Cancelled Jul 20, 2011 · Expired dealer · Porterville, CA N503HAHiller UH-12E · S/N 5003Cancelled Nov 9, 1999 · Administratively canceled · Porterville, CA N65156Hiller UH-12E · S/N 1403Cancelled Oct 23, 1984 · Exported to Argentina · Porterville, CA N60080Hiller UH-12E · S/N 5220Cancelled Nov 8, 1983 · Exported to Thailand · Porterville, CA N4035KHiller UH-12E · S/N 5194Cancelled Feb 2, 1983 · Exported to Japan · Built 1983 · Porterville, CA N40345Hiller UH-12E · S/N 5191Cancelled Sep 22, 1982 · Exported to Egypt · Built 1982 · Porterville, CA N4034SHiller UH-12E · S/N 5189Cancelled Sep 22, 1982 · Exported to Egypt · Built 1982 · Porterville, CA N40365Hiller UH-12E · S/N 5213Cancelled Sep 22, 1982 · Exported to Egypt · Built 1982 · Porterville, CA N6003LHiller UH-12E · S/N 5214Cancelled Sep 22, 1982 · Exported to Egypt · Porterville, CA N6003NHiller UH-12E · S/N 5215Cancelled Sep 22, 1982 · Exported to Egypt · Porterville, CA N60035Hiller UH-12E · S/N 5216Cancelled Sep 21, 1982 · Exported to Egypt · Porterville, CA N4035PHiller UH-12 · S/N 5197Cancelled Aug 31, 1982 · Exported to Egypt · Built 1982 · Porterville, CA N4035THiller UH-12 · S/N 5198Cancelled Aug 31, 1982 · Exported to Egypt · Built 1982 · Porterville, CA N4035UHiller UH-12 · S/N 5200Cancelled Aug 31, 1982 · Exported to Egypt · Built 1982 · Porterville, CA N40361Hiller UH-12 · S/N 5211Cancelled Aug 31, 1982 · Exported to Egypt · Built 1982 · Porterville, CA N40364Hiller UH-12 · S/N 5212Cancelled Aug 31, 1982 · Exported to Egypt · Built 1982 · Porterville, CA N4036YHiller UH-12 · S/N 5210Cancelled Aug 31, 1982 · Exported to Egypt · Built 1982 · Porterville, CA N6004CHiller UH-12E · S/N 5217Cancelled Aug 30, 1982 · Exported to Egypt · Porterville, CA N40351Hiller UH-12E · S/N 5203Cancelled Aug 19, 1982 · Exported to Egypt · Porterville, CA N40353Hiller UH-12E · S/N 5204Cancelled Aug 19, 1982 · Exported to Egypt · Built 1982 · Porterville, CA N40357Hiller UH-12E · S/N 5205Cancelled Aug 19, 1982 · Exported to Egypt · Built 1982 · Porterville, CA N4035YHiller UH-12E · S/N 5202Cancelled Aug 19, 1982 · Exported to Egypt · Built 1982 · Porterville, CA N4036KHiller UH-12E · S/N 5207Cancelled Aug 19, 1982 · Exported to Egypt · Built 1982 · Porterville, CA N4036LHiller UH-12E · S/N 5208Cancelled Aug 19, 1982 · Exported to Egypt · Built 1982 · Porterville, CA N4036THiller UH-12E · S/N 5209Cancelled Aug 19, 1982 · Exported to Egypt · Built 1982 · Porterville, CA N4034DHiller UH-12E · S/N 5187Cancelled May 12, 1982 · Exported to Australia · Built 1982 · Porterville, CA N4031GHiller UH-12E · S/N 5153Cancelled Apr 30, 1982 · Exported to Panama · Built 1981 · Porterville, CA N40327Hiller UH-12E · S/N 5176Cancelled Mar 2, 1982 · Exported to Taiwan · Built 1981 · Porterville, CA N4033UHiller UH-12E · S/N 5185Cancelled Feb 19, 1982 · Exported to Argentina · Built 1981 · Porterville, CA N5332VHiller UH-12E · S/N 2004Cancelled Oct 13, 1981 · Porterville, CA N5365VHiller UH-12E-L · S/N 2053Cancelled Oct 13, 1981 · Porterville, CA N4032JHiller UH-12E · S/N 5173Cancelled Sep 9, 1981 · Exported to Japan · Built 1981 · Porterville, CA N4032SHiller UH-12E · S/N 5174Cancelled Sep 9, 1981 · Exported to Japan · Built 1981 · Porterville, CA N4033JHiller UH-12E · S/N 5184Cancelled Sep 8, 1981 · Exported to Germany · Built 1981 · Porterville, CA N40320Hiller UH-12E · S/N 5179Cancelled Aug 21, 1981 · Exported to Paraguay · Built 1981 · Porterville, CA N40297Hiller UH-12E · S/N 5151Cancelled Jul 22, 1981 · Exported to South Africa · Built 1980 · Porterville, CA N4031MHiller UH-12E · S/N 5168Cancelled Jun 29, 1981 · Exported to Argentina · Porterville, CA N4031SHiller UH-12E · S/N 5171Cancelled Jun 29, 1981 · Exported to Argentina · Built 1981 · Porterville, CA N4031THiller UH-12E · S/N 5172Cancelled Jun 29, 1981 · Exported to Argentina · Built 1981 · Porterville, CA N4028YHiller UH-12E · S/N 5083Cancelled Aug 28, 1979 · Exported to Australia · Built 1979 · Porterville, CA N40269Hiller UH-12E · S/N 5064Cancelled May 21, 1979 · Exported to Japan · Porterville, CA N533HAHiller UH-12E · S/N 5033Cancelled Aug 25, 1978 · Exported to Japan · Porterville, CA N534HAHiller UH-12E · S/N 5034Cancelled Aug 25, 1978 · Exported to Japan · Porterville, CA N532HAHiller UH-12E · S/N 5032Cancelled Aug 24, 1978 · Exported to Japan · Porterville, CA N519HAHiller UH-12E · S/N 5019Cancelled Jul 20, 1978 · Exported to Switzerland · Porterville, CA N538HAHiller UH-12E · S/N 5038Cancelled Jun 30, 1978 · Porterville, CA N536HAHiller UH-12E · S/N 5036Cancelled Jun 29, 1978 · Exported to Venezuela · Porterville, CA N537HAHiller UH-12E · S/N 5037Cancelled Jun 29, 1978 · Exported to Venezuela · Porterville, CA

Back to Hiller Aviation