Skip to content

Hawker Pacific Inc

Earlier aircraft under this name · 39

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 = 'HAWKER PACIFIC INC' OR list_contains(d.other_registrant_names, 'HAWKER PACIFIC INC') 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 = 'HAWKER PACIFIC INC' OR list_contains(d.other_registrant_names, 'HAWKER PACIFIC INC')
  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 = 'HAWKER PACIFIC INC' OR list_contains(d.other_registrant_names, 'HAWKER PACIFIC INC')
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.

N1099SRaytheon 400A · S/N RK-139Cancelled Jun 25, 1999 · Exported to Australia · Sun Valley, CA N3268ZRaytheon B300 · S/N FL146Cancelled Jan 7, 1999 · Exported to Thailand · Sun Valley, CA N3269WRaytheon B300 · S/N FL147Cancelled Nov 20, 1998 · Exported to Thailand · Sun Valley, CA N3252XRaytheon B200 · S/N BB1532Cancelled Mar 3, 1998 · Exported to Philippines · Sun Valley, CA N3268HRaytheon B300 · S/N FL148Cancelled Jun 11, 1997 · Exported to Philippines · Sun Valley, CA N11181Raytheon 58 · S/N TH1801Cancelled May 13, 1997 · Exported to Indonesia · Sun Valley, CA N11113Raytheon 58 · S/N TH1799Cancelled May 12, 1997 · Exported to Indonesia · Sun Valley, CA N11184Raytheon 58 · S/N TH1802Cancelled May 12, 1997 · Exported to Indonesia · Sun Valley, CA N82410Beech B200C · S/N BL140Cancelled Mar 20, 1997 · Exported to Indonesia · Sun Valley, CA N200BKBeech B200 · S/N BB1041Cancelled Jan 14, 1997 · Exported to Australia · Sun Valley, CA N10691Raytheon B300 · S/N FL150Cancelled Dec 18, 1996 · Exported to Australia · Sun Valley, CA N773AMBeech B200 · S/N BB1430Cancelled Jul 23, 1996 · Exported to Australia · Sun Valley, CA N82251Beech F33A · S/N CE1722Cancelled May 23, 1996 · Exported to Australia · Sun Valley, CA N3233JBeech 1900D · S/N UE186Cancelled Feb 15, 1996 · Exported to Indonesia · Built 1995 · Sun Valley, CA N3237HBeech 1900D · S/N UE177Cancelled Feb 1, 1996 · Exported to Indonesia · Sun Valley, CA N1555EBeech B300 · S/N FL118Cancelled Jan 23, 1996 · Exported to Philippines · Sun Valley, CA N80663Beech B300 · S/N FL108Cancelled Jan 16, 1996 · Exported to Taiwan · Sun Valley, CA N43CEBeech B200 · S/N BL72Cancelled Jan 11, 1996 · Exported to Australia · Sun Valley, CA N7071SBritten-Norman BN-2A-21 · S/N 415Cancelled Oct 23, 1995 · Exported to Australia · Sun Valley, CA N7071MBritten-Norman BN-2A-21 · S/N 402Cancelled Sep 13, 1995 · Exported to Australia · Sun Valley, CA N7071CBritten-Norman BN-2A-21 · S/N 400Cancelled Apr 14, 1995 · Exported to Cambodia · Sun Valley, CA N501TRBeech B200 · S/N BB1037Cancelled Mar 22, 1995 · Exported to Australia · Sun Valley, CA N1562ZBeech B300 · S/N FL122Cancelled Feb 7, 1995 · Exported to Australia · Sun Valley, CA N15317Beech 1900D · S/N UE115Cancelled Dec 1, 1994 · Exported to Australia · Sun Valley, CA N82928Beech 1900D · S/N UE102Cancelled Aug 29, 1994 · Exported to Australia · Sun Valley, CA N15509Beech Acft B200T · S/N BT35Cancelled May 20, 1994 · Exported to Malaysia · Sun Valley, CA N80024Beech Acft B200T · S/N BT36Cancelled May 20, 1994 · Exported to Malaysia · Sun Valley, CA N80027Beech Acft B200T · S/N BT37Cancelled May 20, 1994 · Exported to Malaysia · Sun Valley, CA N80048Beech Acft B200T · S/N BT38Cancelled May 20, 1994 · Exported to Malaysia · Sun Valley, CA N7071NBritten-Norman BN-2A-21 · S/N 414Cancelled Feb 9, 1994 · Exported to Cambodia · Sun Valley, CA N7071HBritten-Norman BN-2A-21 · S/N 401Cancelled Jan 12, 1994 · Exported to Cambodia · Sun Valley, CA N81215Beech 58 · S/N TH1675Cancelled Dec 15, 1993 · Exported to Australia · Sun Valley, CA N663PBeech B200 · S/N BB1329Cancelled Jul 16, 1993 · Exported to Australia · Sun Valley, CA N8246QBeech B300 · S/N FL79Cancelled Jul 14, 1993 · Exported to Papua New Guinea · Sun Valley, CA N55626Beech F33A · S/N CE1675Cancelled Jun 8, 1993 · Exported to Australia · Sun Valley, CA N82018Beech F33A · S/N CE1606Cancelled Mar 5, 1992 · Exported to Australia · Sun Valley, CA N82652Beech A36 · S/N E2674Cancelled Dec 9, 1991 · Exported to Australia · Sun Valley, CA N5671TBeech F33A · S/N CE1486Cancelled Sep 30, 1991 · Exported to Australia · Sun Valley, CA N2152NBell 206B · S/N 4064Cancelled Mar 6, 1990 · Exported to United Arab Emirates · Built 1989 · Sun Valley, CA

Back to Hawker Pacific Inc