Skip to content

Offshore Logistics Inc

Earlier aircraft under this name · 48

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 = 'OFFSHORE LOGISTICS INC' OR list_contains(d.other_registrant_names, 'OFFSHORE LOGISTICS 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 = 'OFFSHORE LOGISTICS INC' OR list_contains(d.other_registrant_names, 'OFFSHORE LOGISTICS 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 = 'OFFSHORE LOGISTICS INC' OR list_contains(d.other_registrant_names, 'OFFSHORE LOGISTICS 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.

N5829DBell Helicopter Textron 206L-1 · S/N 45270Cancelled Mar 18, 2002 · Triennial form not returned · Lafayette, LA N7612LSikorsky S-76A · S/N 760054Cancelled Mar 18, 2002 · Second triennial mailing, no response · Built 1980 · Lafayette, LA N90228Bell 206B · S/N 1720Cancelled Mar 18, 2002 · Second triennial mailing, no response · Built 1975 · Lafayette, LA N765ALSikorsky S-76A · S/N 760028Cancelled May 15, 2001 · Triennial form not returned · Lafayette, LA N57ALBell 206B · S/N 1404Cancelled Jan 23, 2001 · Triennial form not returned · Lafayette, LA N5734SBell Helicopter Textron 206L-1 · S/N 45455Cancelled Aug 31, 2000 · Triennial form not returned · Lafayette, LA N59ALBell 206B · S/N 1422Cancelled Mar 15, 2000 · Triennial form not returned · Lafayette, LA N305ALBell 206B · S/N 1968Cancelled Mar 13, 2000 · Triennial form not returned · Lafayette, LA N358EAerospatiale AS 355F1 · S/N 5134Cancelled Feb 4, 2000 · Exported to United Kingdom · Lafayette, LA N115ALBell 206B · S/N 2383Cancelled Oct 8, 1999 · Triennial form not returned · Lafayette, LA N347ALBell 206L-3 · S/N 51381Cancelled Mar 15, 1999 · Triennial form not returned · Lafayette, LA N366ALBell 206L-3 · S/N 51470Cancelled Feb 10, 1999 · Triennial form not returned · Lafayette, LA N360SBell 206B · S/N 2217Cancelled Jan 20, 1999 · Triennial form not returned · Lafayette, LA N57334Bell Helicopter Textron 206L-1 · S/N 45445Cancelled Jan 20, 1999 · Triennial form not returned · Lafayette, LA N2906TMesserschmitt-Boelkow-Blohm BO-105S · S/N S573Cancelled Dec 16, 1998 · Triennial form not returned · Lafayette, LA N375EAerospatiale AS 355F1 · S/N 5209Cancelled Dec 5, 1998 · Triennial form not returned · Lafayette, LA N213ALBell 206B · S/N 1066Cancelled Dec 13, 1997 · Triennial form not returned · Lafayette, LA N5404YSikorsky S-76 · S/N 760146Cancelled Oct 22, 1997 · Triennial form not returned · Lafayette, LA N5018VBell Helicopter Textron 206L-1 · S/N 45239Cancelled Aug 22, 1997 · Triennial form not returned · Lafayette, LA N172ALBell 206-L4 · S/N 52065Cancelled Mar 3, 1997 · Triennial form not returned · Lafayette, LA N1078PBell Helicopter Textron 206L-1 · S/N 45390Cancelled Feb 19, 1997 · Triennial form not returned · Lafayette, LA N378EAerospatiale AS355F TWINSTAR · S/N 5214Cancelled Dec 27, 1996 · Exported to Austria · Lafayette, LA N158ALBell 206B · S/N 1811Cancelled Oct 11, 1996 · Exported to Chile · Lafayette, LA N62ALBell 212 · S/N 30826Cancelled May 30, 1996 · Exported to Colombia · Lafayette, LA N92ALBell 212 · S/N 30828Cancelled Feb 5, 1996 · Triennial form not returned · Lafayette, LA N708ALSikorsky S-76A · S/N 760277Cancelled Oct 27, 1995 · Exported to Brazil · Lafayette, LA N396ALBell 412 · S/N 33169Cancelled Sep 29, 1995 · Exported to Mexico · Lafayette, LA N2071CBell 412 · S/N 33042Cancelled Aug 10, 1994 · Exported to Mexico · Lafayette, LA N3895PBell 212 · S/N 31144Cancelled May 26, 1994 · Exported to Colombia · Lafayette, LA N3895UBell 212 · S/N 31153Cancelled May 26, 1994 · Exported to Colombia · Lafayette, LA N72ALBell 212 · S/N 30672Cancelled Mar 18, 1994 · Exported to Canada · Lafayette, LA N93ALBell 212 · S/N 30829Cancelled Mar 18, 1994 · Exported to Canada · Lafayette, LA N476ALSikorsky S-76A · S/N 760003Cancelled Apr 16, 1993 · Exported to Brazil · Lafayette, LA N5748YBell Helicopter Textron 206L-1 · S/N 45495Cancelled Feb 11, 1993 · Exported to Australia · Lafayette, LA N1082TBell 212 · S/N 31104Cancelled Jul 2, 1992 · Exported to Guatemala · Lafayette, LA N30DBBell 206B · S/N 1299Cancelled Feb 5, 1992 · Exported to New Zealand · Lafayette, LA N764ALSikorsky S-76A · S/N 760027Cancelled Jan 31, 1992 · Exported to Brazil · Lafayette, LA N218ALBell 206B · S/N 1481Cancelled Aug 21, 1991 · Exported to Venezuela · Lafayette, LA N9930KBell 206B · S/N 2027Cancelled Jul 5, 1991 · Exported to Venezuela · Lafayette, LA N353ALBell 206L-3 · S/N 51442Cancelled Apr 18, 1991 · Exported to Mexico · Built 1991 · Lafayette, LA N71ALBell 212 · S/N 30664Cancelled Jun 13, 1986 · Exported to United Arab Emirates · Lafayette, LA N57480Bell Helicopter Textron 206L-1 · S/N 45501Cancelled Oct 25, 1985 · Exported to Venezuela · Lafayette, LA N62ALBell 206B · S/N 1428Cancelled Oct 22, 1984 · Exported to New Zealand · Lafayette, LA N1081HBell Helicopter Textron 206L-1 · S/N 45406Cancelled Jul 22, 1983 · Administratively canceled · Lafayette, LA N5402VSikorsky S-76A · S/N 760142Cancelled May 29, 1981 · Exported to Mexico · Lafayette, LA N1548YSikorsky S-76A · S/N 760138Cancelled Mar 31, 1981 · Exported to Mexico · Built 1981 · Lafayette, LA N141ALBell 212 · S/N 30688Cancelled Jul 25, 1980 · Exported to Mexico · Built 1975 · Lafayette, LA N157ALBell 206B · S/N 1798Cancelled Feb 22, 1978 · Lafayette, LA

Back to Offshore Logistics Inc