Brooks Fuel Inc

Earlier aircraft under this name · 17

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

Query with SQL
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 = 'BROOKS FUEL INC' OR list_contains(d.other_registrant_names, 'BROOKS FUEL 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.

N6374BCessna 182 · S/N 34274Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1957 · Fairbanks, AKN438NADouglas C-54G · S/N 45-578Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1945 · Fairbanks, AKN90251Douglas DC-7 · S/N 45367Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Fairbanks, AKN51802Douglas C-54G · S/N 35930Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1945 · Fairbanks, AKN44911Douglas C54B-DC · S/N 10461Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1944 · Fairbanks, AKN90201Douglas C54-D · S/N 10828Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1945 · Fairbanks, AKN898ATDouglas DC-4 · S/N 42994Cancelled Dec 27, 2016 · Third renewal notice · Built 1946 · Fairbanks, AKN82FADouglas C54G-DC · S/N 35960Cancelled May 6, 2015 · Registration expired, pending cancellation · Fairbanks, AKN67019Douglas C54B-DC · S/N 10520Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1945 · Fairbanks, AKN99ASDouglas C-54 · S/N 56549Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Fairbanks, AKN67017Douglas C-54 · S/N 10438Cancelled Nov 7, 2014 · Registration expired, pending cancellation · Built 1944 · Fairbanks, AKN67018Douglas C54D-DC · S/N 22196Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1945 · Fairbanks, AKN99212Douglas C54-D · S/N 10661Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1943 · Fairbanks, AKN44904Douglas C-54 · S/N 10862Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1945 · Fairbanks, AKN44906Douglas C-54B · S/N 18388Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1944 · Fairbanks, AKN44909Douglas C54E-DC · S/N 27371Cancelled Dec 20, 1999 · Exported to Canada · Fairbanks, AKN898ALDouglas C54G-DC · S/N 35986Cancelled May 21, 1998 · Triennial form not returned · Fairbanks, AK
Back to Brooks Fuel Inc