OpenAirDocs.org
Air Associates Inc

Earlier aircraft under this name · 58

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

N90142Bell 206B · S/N 1592Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1975 · Skokie, ILN245GWDehavilland DHC-6-200 · S/N 129Cancelled Apr 9, 2008 · Triennial form not returned · Built 1968 · Plymouth, MAN712DALockheed L-1011-385-1 · S/N 193C-1088Cancelled Jul 25, 2001 · Stockbridge, GAN787DLLockheed L-1011-385-1 · S/N 193A-1126Cancelled Jul 25, 2001 · Stockbridge, GAN716DALockheed L-1011-385-1 · S/N 193C-1095Cancelled Jul 24, 2001 · Stockbridge, GAN724DALockheed L-1011-385-1-15 · S/N 193C-1151Cancelled Jul 24, 2001 · Stockbridge, GAN725DALockheed L-1011-385-1 · S/N 193C-1162Cancelled Jul 24, 2001 · Stockbridge, GAN752DALockheed L-1011-385-3 · S/N 193W-1172Cancelled Jul 24, 2001 · Stockbridge, GAN783DLLockheed L-1011-385-1 · S/N 193A-1009Cancelled Jul 24, 2001 · Stockbridge, GAN789DLLockheed L-1011-385-1 · S/N 193A-1142Cancelled Jul 24, 2001 · Stockbridge, GAN6KTAerospatiale SA341G GAZELLE · S/N 1390Cancelled Aug 23, 1983 · Exported to France · Skokie, ILN341ATAerospatiale SA341G GAZELLE · S/N 1417Cancelled Aug 22, 1983 · Exported to France · Built 1977 · Skokie, ILN67103Aerospatiale SA315B · S/N 2421Cancelled Jul 28, 1983 · Skokie, ILN29CBAerospatiale SA341G GAZELLE · S/N 1041Cancelled Jul 15, 1983 · Exported to France · Skokie, ILN62416S N I A S SA341G · S/N 1170Cancelled Jul 15, 1983 · Exported to France · Skokie, ILN49543Aerospatiale SA316B ALOUETTE III · S/N 2265Cancelled Dec 15, 1982 · Exported to Switzerland · Chicago, ILN2964NBell 206B-III · S/N 2745Cancelled Aug 23, 1982 · Exported to Taiwan · Skokie, ILN5737NBell Helicopter Textron 206L-1 · S/N 45453Cancelled May 21, 1981 · Exported to Canada · Skokie, ILN9120FHughes 369HS · S/N 1020423SCancelled May 5, 1981 · Exported to Japan · Skokie, ILN1548SSikorsky S-76 · S/N 760130Cancelled Feb 18, 1981 · Exported to Canada · Skokie, ILN8678FHughes Helicopters HUGHES 369D · S/N 870176DCancelled Feb 17, 1981 · Exported to BrazilN58413Hughes Helicopters HUGHES 369D · S/N 480302DCancelled Feb 10, 1981 · Exported to Brazil · Skokie, ILN37738Bell 206B · S/N 280Cancelled Jan 23, 1981 · Exported to Canada · Built 1968 · Skokie, ILN58418Hughes Helicopters HUGHES 369D · S/N 780320DCancelled Nov 21, 1980 · Exported to Brazil · Skokie, ILN2230WBell 206A · S/N 447Cancelled Nov 10, 1980 · Exported to Canada · Built 1969 · Skokie, ILN8342FHughes Helicopters HUGHES 369D · S/N 1260032DCancelled Nov 6, 1980 · Skokie, ILN58300Hughes Helicopters HUGHES 369D · S/N 880335DCancelled Sep 17, 1980 · Exported to Chile · Skokie, ILN90740Messerschmitt-Boelkow-Blohm-Gm BO-105C · S/N S-147Cancelled Aug 6, 1980 · Exported to Germany · Skokie, ILN2234WBell Helicopter Textron 206B · S/N 446Cancelled May 7, 1980 · Exported to Canada · Built 1969 · Skokie, ILN59477Bell 206B · S/N 1088Cancelled Apr 9, 1980 · Exported to Canada · Skokie, ILN4704RBell 206B · S/N 356Cancelled Feb 29, 1980 · Exported to Canada · Built 1969 · Skokie, ILN9275FHughes 369HS · S/N 1250786SCancelled Feb 7, 1980 · Exported to New Zealand · Chicago, ILN9994KBell 206L · S/N 45105Cancelled Feb 7, 1980 · Exported to Canada · Skokie, ILN101TFBell 206A · S/N 616Cancelled Feb 1, 1980 · Exported to Canada · Built 1971 · Skokie, ILN125GWBell 206A · S/N 114Cancelled May 18, 1979 · Exported to Canada · Skokie, ILN7600SFairchild Hiller FH-1100 · S/N 29Cancelled Jan 9, 1979 · Exported to Canada · Built 1967 · Chicago, ILN2281WBell 206B · S/N 478Cancelled Jul 10, 1978 · Exported to Canada · Chicago, ILN58848Bell 47G-4A · S/N 7632Cancelled May 10, 1978 · Exported to Japan · Skokie, ILN54533Bell 47G-4A · S/N 7644Cancelled Apr 11, 1978 · Exported to Japan · Chicago, ILN7996JBell 212 · S/N 30520Cancelled Feb 3, 1978 · Exported to Japan · Shokie, ILN64743Bell 205A-1 · S/N 30163Cancelled Sep 30, 1977 · Exported to Iran · Chicago, ILN83238Bell 206B · S/N 966Cancelled Jan 14, 1977 · Exported to Canada · Chicago, ILN8156JBell 206A · S/N 548Cancelled Oct 14, 1976 · Chicago, ILN2214WBell 47G-5 · S/N 7948Cancelled Aug 4, 1976 · Exported to South Korea · Chicago, ILN49616Bell 205A-1 · S/N 30212Cancelled Dec 12, 1975 · Exported to Brazil · Chicago, ILN33MCBell 206A · S/N 320Cancelled Jul 30, 1975 · Exported to Canada · Chicago, ILN9060FHughes 369HS · S/N 700244SCancelled Jul 17, 1975 · Exported to Canada · Chicago, ILN1429WBell 206B · S/N 354Cancelled Jun 4, 1975 · Exported to Canada · Built 1968 · Chicago, ILN4723RBell 206A · S/N 248Cancelled Nov 19, 1974 · Exported to Canada · Chicago, ILN770GGBell 206A · S/N 410Cancelled Apr 18, 1974 · Exported to Canada · Chicago, IL
Back to Air Associates Inc