Skip to content

Earlier aircraft under this name · 31

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 = 'BALLOON WORKS' OR list_contains(d.other_registrant_names, 'BALLOON WORKS') 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 = 'BALLOON WORKS' OR list_contains(d.other_registrant_names, 'BALLOON WORKS')
  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 = 'BALLOON WORKS' OR list_contains(d.other_registrant_names, 'BALLOON WORKS')
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.

N64127Balloon Works BARNES SOLAR FIREFLY · S/N 001Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1973 · Statesville, NC N36182Balloon Works FIREFLY 8-24 · S/N F8-042Cancelled Jan 18, 2013 · Expired dealer · Built 1984 · Statesville, NC N71158Balloon Works FIREFLY 7 · S/N F7-416Cancelled Jul 27, 2011 · Expired dealer · Built 1987 · Statesville, NC N27017Balloon Works FIREFLY 7 · S/N 503Cancelled Jul 25, 2011 · Expired dealer · Built 1977 · Statesville, NC N3620ABalloon Works FIREFLY 7 · S/N F7-166Cancelled Jul 25, 2011 · Expired dealer · Built 1984 · Statesville, NC N7008UBalloon Works FIREFLY 7-15 · S/N F7-1066Cancelled Jul 25, 2011 · Expired dealer · Built 1998 · Statesville, NC N9058PBalloon Works FIREFLY 8 · S/N F8-368Cancelled Jul 25, 2011 · Expired dealer · Statesville, NC N90771Balloon Works FIREFLY 6B · S/N F6B-036Cancelled Jul 25, 2011 · Expired dealer · Statesville, NC N9080MBalloon Works FIREFLY 8B-15 · S/N F8B-403Cancelled Jul 25, 2011 · Expired dealer · Built 1992 · Statesville, NC N9086XBalloon Works FIREFLY 7 · S/N F7-715Cancelled Jul 25, 2011 · Expired dealer · Built 1990 · Statesville, NC N36956Balloon Works FIREFLY 8-24 · S/N F8-052Cancelled Jul 22, 2011 · Expired dealer · Built 1984 · Statesville, NC N3771UBalloon Works FIREFLY 8-24 · S/N F8-036Cancelled Jul 20, 2011 · Expired dealer · Built 1984 · Statesville, NC N9082MBalloon Works FIREFLY 8 · S/N F8-377Cancelled Jul 20, 2011 · Expired dealer · Built 1991 · Statesville, NC N3282RBalloon Works FIREFLY 7B-15 · S/N F7B-368Cancelled Jul 19, 2011 · Expired dealer · Statesville, NC N36704Balloon Works FIREFLY 8-24 · S/N F8-019Cancelled Jul 15, 2011 · Expired dealer · Statesville, NC N36923Balloon Works FIREFLY 7 · S/N F7-188Cancelled Jul 15, 2011 · Expired dealer · Built 1984 · Statesville, NC N37052Balloon Works FIREFLY 7 · S/N F7-228Cancelled Jul 15, 2011 · Expired dealer · Statesville, NC N74091Balloon Works FIREFLY 7 · S/N F7-242Cancelled Jul 15, 2011 · Expired dealer · Statesville, NC N1506ABalloon Works FIREFLY 7 · S/N 11163Cancelled Jul 13, 2011 · Expired dealer · Statesville, NC N1541YBalloon Works FIREFLY 7-B · S/N 10232Cancelled Jul 13, 2011 · Expired dealer · Statesville, NC N27137Balloon Works FIREFLY 6B · S/N 6678Cancelled Jun 30, 2011 · Expired dealer · Built 1977 · Statesville, NC N3684GBalloon Works FIREFLY 8-24 · S/N F8-017Cancelled Mar 2, 2011 · Expired dealer · Statesville, NC N4066ABalloon Works FIREFLY 7 · S/N 10016Cancelled May 30, 2007 · Expired dealer · Built 1979 · Statesville, NC N4055NBalloon Works FIREFLY 7 · S/N 10135Cancelled May 7, 2007 · Exported to Australia · Built 1980 · Statesville, NC N7072DBalloon Works FIREFLY 7-15 · S/N F7-1101Cancelled Oct 20, 2005 · Built 2000 · Statesville, NC N7165LBalloon Works FIREFLY 8 · S/N F8-437Cancelled Oct 20, 2005 · Statesville, NC N32890Balloon Works FIREFLY 7-15 · S/N F71034Cancelled Mar 25, 1998 · Statesville, NC N9005QBalloon Works FIREFLY 8-24 · S/N F8137Cancelled Feb 23, 1998 · Exported to Canada · Statesville, NC N40515Balloon Works FIREFLY 7 · S/N 7954Cancelled Sep 29, 1981 · Exported to Colombia · Statesville, NC N1533YBalloon Works FIREFLY 7 · S/N 10177Cancelled Sep 10, 1981 · Exported to France · Built 1980 · Statesville, NC N15248Balloon Works FIREFLY 7-B · S/N 10994Cancelled Jul 31, 1981 · Exported to Canada · Built 1981 · Statesville, NC

Back to Balloon Works