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 = 'ATLAS AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'ATLAS AIRCRAFT CORP') 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 = 'ATLAS AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'ATLAS AIRCRAFT CORP')
  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 = 'ATLAS AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'ATLAS AIRCRAFT CORP')
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.

N9363RAero Commander 680-E · S/N 680E-878-88Cancelled Jul 19, 2011 · Expired dealer · Built 1960 · Long Beach, CA N107VLBeech C-50 · S/N CH-163Cancelled Mar 21, 2011 · Expired dealer · Built 1955 · Long Beach, CA N414EAero Commander 680-F · S/N 680F-968-26Cancelled Mar 8, 2011 · Expired dealer · Built 1960 · Long Beach, CA N855ACEmbraer EMB-110P1 · S/N 110222Cancelled Nov 6, 1997 · Triennial form not returned · Miami, FL N76012Cessna 207A · S/N 20700661Cancelled Jun 28, 1985 · Exported to New Zealand · Long Beach, CA N5594RDouglas DC-6 · S/N 43064Cancelled Dec 9, 1982 · Miami, FL N230WMAero Commander 500-B · S/N 500B99829Cancelled May 21, 1982 · Exported to Colombia · Long Beach, CA N863TADouglas DC-6 · S/N 45177Cancelled Apr 23, 1982 · Exported to Canada · Miami, FL N846TAConvair 340 · S/N 236Cancelled Jan 27, 1982 · Exported to Bolivia N4817CConvair 340 · S/N 123Cancelled Dec 23, 1981 · Miami, FL N849TAConvair 640 · S/N 460Cancelled Dec 18, 1981 · Exported to Canada · Miami, FL N854TAFairchild FH-227 · S/N 534Cancelled Jul 1, 1981 · Exported to Belgium · Miami, FL N847TAConvair 440 · S/N 474Cancelled May 12, 1981 · Exported to Mexico · Miami, FL N915PRAero Commander 500-B · S/N 500-B1582-202Cancelled Oct 20, 1980 · Exported to Colombia · Long Beach, CA N8071XDouglas DC3 · S/N 4292857Cancelled Oct 2, 1980 · Exported to Germany · Miami, FL N8071YDouglas DC3 · S/N 43-48285Cancelled Oct 2, 1980 · Exported to Germany · Miami, FL N8071ZDouglas DC3 · S/N 42-68819Cancelled Oct 2, 1980 · Exported to Germany · Miami, FL N851TAFairchild FH-227 · S/N 528Cancelled Sep 2, 1980 · Exported to United Kingdom · Built 1966 · Miami, FL N852TAFairchild FH-227 · S/N 532Cancelled May 14, 1980 · Exported to United Kingdom · Built 1967 · Miami, FL N853TAFairchild FH-227B · S/N 533Cancelled May 14, 1980 · Exported to United Kingdom · Miami, FL N7711WAero Commander 680-E · S/N 680E-715-25Cancelled Jul 10, 1979 · Exported to Colombia · Long Beach, CA N3701FAero Commander 681 · S/N 6053Cancelled Dec 27, 1978 · Exported to Colombia · Built 1971 · Long Beach, CA N789TADouglas DC-6A · S/N 44107Cancelled Dec 14, 1978 · Exported to Venezuela · Miami, FL N9359RAero Commander 680-E · S/N 680E-879-89Cancelled Feb 16, 1978 · Long Beach, CA N43883Douglas DC-6A · S/N 44594Cancelled May 10, 1977 · Exported to Dominican Republic · Miami, FL N15431Piper PA-28 · S/N 28-7310044Cancelled Jun 26, 1973 · Denver, CO N6767YPiper PA-23-250 (6PCLM) · S/N 27-4098Cancelled Jun 26, 1973 · Denver, CO N9089WPiper PA-28-235 · S/N 28-10695Cancelled Aug 27, 1970 N7600ZPiper PA-25 · S/N 25-3691Cancelled Jun 9, 1966 · Exported to Mexico · Denver, CO N2203SDouglas DC3C · S/N 25441Cancelled Sep 14, 1965 · Exported to Western Samoa · Goleta, CA N6870CDouglas DC3C · S/N 25537Cancelled May 20, 1965 · Goleta, CA

Back to Atlas Aircraft Corp