Earlier aircraft under this name · 20

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

N4100HAero Commander 680-E · S/N 680-400-78Cancelled Feb 21, 1966 · Exported to Canada · Built 1959 · Miami, FL N671BCurtiss Wright C-46D · S/N 44-78173Cancelled Nov 26, 1965 · Exported to China · Miami, FL N13500Curtiss Wright C-46D · S/N AF-44-78544Cancelled Sep 27, 1965 · Exported to Taiwan · Miami, FL N155ADouglas DC3C · S/N 2010Cancelled Jul 6, 1965 · Exported to Taiwan · Built 1938 · Miami, FL N843DDouglas DC-7B · S/N 45449Cancelled May 18, 1965 · Miami, FL N4648SDouglas C-54G · S/N 35993Cancelled Apr 15, 1965 · Exported to Colombia · Miami, FL N174ADouglas C-54 · S/N 10826Cancelled Mar 16, 1965 · Exported to Peru · Miami, FL N2777BAero Commander 560-A · S/N 277Cancelled Mar 2, 1965 · Exported to Colombia · Miami, FL N9089RDouglas DC3-G202A · S/N 4174Cancelled Feb 18, 1965 · Exported to Nicaragua · Miami, FL N7056ZPiper PA-25-235 · S/N 25-2829Cancelled Jul 1, 1964 · Exported to Costa Rica · Built 1964 · Miami, FL N5227VBoeing B-17G · S/N 4483861Cancelled May 14, 1964 · Exported to Bolivia · Miami, FL N92887North American B-25J · S/N 5217Cancelled Dec 27, 1963 · Exported to Venezuela N92890North American B-25J · S/N 4430882Cancelled Dec 27, 1963 · Exported to Venezuela N8014North American B-25C · S/N 4430812Cancelled Dec 26, 1963 · Exported to Venezuela · Miami, FL N92876North American B-25J · S/N 5239Cancelled Dec 26, 1963 · Exported to Venezuela N92878North American B-25J · S/N 5229Cancelled Dec 26, 1963 · Exported to Venezuela N92884North American B-25J · S/N 5231Cancelled Dec 26, 1963 · Exported to Venezuela N92885North American B-25J · S/N 5232Cancelled Dec 26, 1963 · Exported to Venezuela N92886North American B-25J · S/N 5233Cancelled Dec 26, 1963 · Exported to Venezuela N88863Douglas C54-DC · S/N 3120Cancelled May 28, 1963 · Exported to Colombia · Miami Springs, FL

Back to Bellomy Aviation Inc