Skip to content

Aviation Activities Inc

Earlier aircraft under this name · 44

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

N67564Cessna 152 · S/N 15281914Cancelled Jul 20, 2011 · Expired dealer · Built 1978 · Valparaiso, IN N4876QCessna A185F · S/N 18503569Cancelled Jul 15, 2011 · Expired dealer · Built 1978 · Valparaiso, IN N1914QCessna A185F · S/N 18503501Cancelled Sep 22, 1978 · Exported to Canada · Valparaiso, IN N704PNCessna 150M · S/N 15078767Cancelled Jun 19, 1978 · Valparatso, IN N734WCCessna 172N · S/N 17269164Cancelled Sep 12, 1977 · Exported to Canada · Valparaiso, IN N734ZLCessna 172N · S/N 17269244Cancelled Sep 12, 1977 · Exported to Canada · Valparaiso, IN N735UKCessna 182Q · S/N 18265693Cancelled Aug 26, 1977 · Exported to Australia · Valparaiso, IN N1288UCessna 172M · S/N 17266982Cancelled Jul 27, 1977 · Exported to Australia · Built 1976 · Valparaiso, IN N736MZCessna R172K · S/N R1722646Cancelled Jun 28, 1977 · Exported to Canada · Valparaiso, IN N736NUCessna R172K · S/N R1722665Cancelled Jun 16, 1977 · Exported to Canada · Valparaiso, IN N1465UCessna 172M · S/N 17267132Cancelled Jun 3, 1977 · Exported to Australia · Valparaiso, IN N80726Cessna 172M · S/N 17266717Cancelled Jun 3, 1977 · Exported to Australia · Valparaiso, IN N733RSCessna 172N · S/N 17268495Cancelled Apr 1, 1977 · Exported to Canada · Valparaiso, IN N75900Cessna 172N · S/N 17268025Cancelled Jan 25, 1977 · Exported to Germany · Valparaiso, IN N80920Cessna 172M · S/N 17266802Cancelled Sep 22, 1976 · Exported to Canada · Valparaiso, IN N53551Cessna 337G · S/N 33701694Cancelled Aug 16, 1976 · Exported to Canada · Valparaiso, IN N1269UCessna 172M · S/N 17266964Cancelled May 24, 1976 · Exported to Canada · Valparaiso, IN N1473UCessna 172M · S/N 17267140Cancelled May 14, 1976 · Exported to Canada N9318HCessna 172M · S/N 17266083Cancelled Mar 23, 1976 · Exported to Canada · Valparaiso, IN N6435KCessna 150M · S/N 15077703Cancelled Mar 12, 1976 · Exported to Canada · Valparaiso, IN N1221FCessna A185F · S/N 18502783Cancelled Sep 25, 1975 · Exported to Canada · Built 1975 · Valparaiso, IN N5062HCessna 172M · S/N 17265323Cancelled Sep 11, 1975 · Exported to Canada · Valparaiso, IN N5074HCessna 172M · S/N 17265332Cancelled Sep 11, 1975 · Exported to Canada · Valparaiso, IN N64207Cessna 172M · S/N 17265088Cancelled Sep 11, 1975 · Exported to Canada · Valparaiso, IN N5013HCessna 172M · S/N 17265302Cancelled Sep 8, 1975 · Exported to Canada · Valparaiso, IN N64012Cessna 172M · S/N 17264959Cancelled Aug 18, 1975 · Exported to Canada · Valparaiso, IN N5454HCessna 172M · S/N 17265448Cancelled Jul 25, 1975 · Exported to Canada · Valparaiso, IN N61921Cessna 172M · S/N 17264886Cancelled Jun 23, 1975 · Exported to Canada · Valparaiso, IN N61768Cessna 172M · S/N 17264786Cancelled Jun 16, 1975 · Exported to Canada · Valparaiso, IN N9916NCessna 180J · S/N 18052571Cancelled Jun 10, 1975 · Exported to Canada · Valparaiso, IN N64325Cessna 172M · S/N 17265166Cancelled May 9, 1975 · Exported to Canada · Valapraiso, IN N21555Cessna 172M · S/N 17263971Cancelled Oct 24, 1974 · Exported to Australia · Valparaiso, IN N1740RCessna A185F · S/N 18502460Cancelled Sep 10, 1974 · Exported to Canada · Built 1974 · Valparaiso, IN N4330RCessna 172M · S/N 17263083Cancelled Apr 22, 1974 · Exported to Canada · Built 1974 · Valparaiso, IN N21312Cessna 182P · S/N 18261554Cancelled Feb 27, 1974 · Valparaiso, IN N408CCessna A150K · S/N A1500224Cancelled Oct 25, 1973 · Valparaison, IN N58737Cessna 182P · S/N 18262266Cancelled Oct 12, 1973 · Exported to Germany · Valparaiso, IN N12099Cessna 172M · S/N 17261809Cancelled Jul 17, 1973 · Exported to Canada · Valparaiso, IN N42352Cessna 180J · S/N 18052342Cancelled Jul 10, 1973 · Exported to Canada · Valparaiso, IN N92802Cessna 172M · S/N 17261622Cancelled Jul 10, 1973 · Exported to Canada · Valparaiso, IN N2154XCessna 337 · S/N 337-0054Cancelled Sep 13, 1971 · Valparaiso, IN N1685MCessna A185E · S/N 18501872Cancelled Jun 2, 1971 · Exported to Canada · Built 1971 · Valparaiso, IN N117LCessna 185 · S/N 185-01778Cancelled Aug 7, 1970 · Exported to Canada · Valparaiso, IN N4660UCessna 180G · S/N 18051360Cancelled Sep 24, 1969 · Exported to Canada · Valparaiso, IN

Back to Aviation Activities Inc