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.
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
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.
N6374BCessna 182 · S/N 34274N438NADouglas C-54G · S/N 45-578N90251Douglas DC-7 · S/N 45367N51802Douglas C-54G · S/N 35930N44911Douglas C54B-DC · S/N 10461N90201Douglas C54-D · S/N 10828N898ATDouglas DC-4 · S/N 42994N82FADouglas C54G-DC · S/N 35960N67019Douglas C54B-DC · S/N 10520N99ASDouglas C-54 · S/N 56549N67017Douglas C-54 · S/N 10438N67018Douglas C54D-DC · S/N 22196N99212Douglas C54-D · S/N 10661N44904Douglas C-54 · S/N 10862N44906Douglas C-54B · S/N 18388N44909Douglas C54E-DC · S/N 27371N898ALDouglas C54G-DC · S/N 35986
Back to Brooks Fuel Inc