OpenAirDocs.org
Roach Aircraft Inc

Earlier aircraft under this name · 21

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

N24951Piper J3L-65 · S/N 3559Cancelled Jun 2, 1981 · Denver, CON735GFCessna TU206G · S/N U20604918Cancelled Mar 4, 1980 · Exported to Mexico · Broomfield, CON7569MCessna U206G · S/N U20604516Cancelled May 10, 1979 · Exported to Canada · Broomfield, CON4269CCessna 340A · S/N 340A0520Cancelled Dec 26, 1978 · Exported to Mexico · Built 1978 · Denver, CON3204TCessna 177 · S/N 17700504Cancelled May 3, 1978 · Exported to Denmark · Built 1967 · Denver, CON6826RCessna T210G · S/N T210-0226Cancelled Feb 22, 1977 · Denver, CON9859QCessna 172M · S/N 17265803Cancelled Apr 20, 1976 · Exported to Canada · Built 1975 · Broomfield, CON4255LCessna 172G · S/N 17254324Cancelled Mar 24, 1976 · Exported to Canada · Built 1966 · Broomfield, CON6325FCessna 182P · S/N 18264158Cancelled Nov 28, 1975 · Exported to Canada · Denver, CON1517VCessna 172M · S/N 17263639Cancelled Oct 21, 1974 · Exported to Canada · Broomfield, CON66013Cessna 150L · S/N 15075775Cancelled Sep 19, 1974 · Exported to Canada · Broomfield, CON7755MMooney M20E · S/N 21-0029Cancelled Jul 26, 1974 · Denver, CON3862RCessna 172H · S/N 17255362Cancelled Feb 14, 1974 · Exported to Canada · Denver, CON555TMCessna A150L · S/N A1500317Cancelled Oct 2, 1973 · Exported to Canada · Denver, CON9447VMooney M20C · S/N 700050Cancelled Sep 10, 1973 · Exported to Canada · Denver, CON6553BMooney M20A · S/N 1223Cancelled Apr 14, 1971 · Broomfield, CON5468FAlon A-2A · S/N B-268Cancelled Apr 13, 1971 · Denver, CON9578MMooney M20F · S/N 670155Cancelled Sep 9, 1970 · Built 1966 · Broomfield, CON2726WMooney M20E · S/N 1030Cancelled Jun 16, 1970 · Broomfield, CON4455CCessna 195B · S/N 16040Cancelled Apr 13, 1970 · Built 1953 · Denver, CON3490XMooney M20E · S/N 1160Cancelled Oct 19, 1967 · Exported to Canada · Denver, CO
Back to Roach Aircraft Inc