Skip to content

American Aviation Inc

Earlier aircraft under this name · 37

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

N8244BPiper PA-28-161 · S/N 28-8216179Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1982 · Salt Lake City, UT N21170Piper PA-28-161 · S/N 28-7916029Cancelled Jan 16, 2018 · Registration expired, pending cancellation · Built 1978 · Salt Lake City, UT N5589ECessna 172N · S/N 17271894Cancelled Aug 26, 2015 · Built 1978 · Salt Lake City, UT N7311UCessna T207A · S/N 20700395Cancelled Jun 30, 2015 · First renewal notice · Salt Lake City, UT N566TCBeech B200 · S/N BB1145Cancelled Oct 31, 2013 · Exported to Australia · Built 1983 · Brooksville, FL N737ZYCessna 172N · S/N 17269813Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1977 · Dunn Loring, VA N399CWRaytheon B200 · S/N BB-1646Cancelled Sep 13, 2013 · Exported to Iceland · Built 1999 · Brooksville, FL N4837TPiper PA-28R-200 · S/N 28R-7235121Cancelled Feb 26, 2013 · First renewal notice · Built 1972 · Salt Lake City, UT N2569LPiper PA-38-112 · S/N 38-79A0684Cancelled Feb 11, 2013 · Registration expired, pending cancellation · Built 1979 · Brooksville, FL N4764JCessna 172N · S/N 17273674Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1979 · Northbrook, IL N2447FPiper PA-38-112 · S/N 38-79A0454Cancelled Sep 6, 2012 · Registration expired, pending cancellation · Built 1979 · Brooksville, FL N250WHBeech B200 · S/N BB1275Cancelled Apr 8, 2011 · Exported to Australia · Built 1987 · Brooksville, FL N938PRPiper PA-44-180 · S/N 4496200Cancelled Sep 12, 2008 · Exported to Germany · Built 2005 · Brooksville, FL N25348Cessna 152 · S/N 15280607Cancelled Jun 20, 2007 · Exported to Brazil · Built 1977 · Salt Lake City, UT N54202Cessna 172P · S/N 17274914Cancelled Jun 29, 2005 · Triennial form not returned · Built 1981 · Peyton, CO N6269QPitts Special S-1C · S/N BD-1Cancelled Jun 20, 2002 · Triennial form not returned · Built 1972 · Brookville, FL N733BWCessna 172N · S/N 17268177Cancelled Mar 29, 2002 · Triennial form not returned · Built 1976 · Peyton, CO N4703CCessna T210N · S/N 21063592Cancelled Nov 21, 2001 · Exported to Mexico · Built 1979 · Brooksville, FL N82208WSK PZL Mielec M-18A · S/N 1Z02521Cancelled Jul 22, 1996 · Exported to Canada · Greenwood, MS N6959JPiper PA-28R-200 · S/N 28R7635367Cancelled Oct 17, 1994 · Salt Lake City, UT N44989Piper PA-34-200T · S/N 347770382Cancelled Oct 8, 1991 · Exported to Germany · Brooksville, FL N80THCessna 340A · S/N 340A0767Cancelled May 31, 1991 · Exported to Mexico · Brooksville, FL N84375Piper PA-34-220T · S/N 348133237Cancelled May 8, 1991 · Exported to United Kingdom · Brooksville, FL N21537Piper PA-28-181 · S/N 28-7990053Cancelled Jul 13, 1984 · Administratively canceled · Brooksville, FL N4889MCessna 152 · S/N 15284488Cancelled Jul 30, 1982 · Exported to Austria · Built 1980 · Northbrook, IL N3136PConsolidated Aeronautics LAKE LA-4-200 · S/N 986Cancelled May 21, 1982 · Exported to Canada · Built 1979 · Brooksville, FL N9603GCessna A188B · S/N 18801554TCancelled Dec 10, 1979 · Exported to South Africa · Walnut Ridge, AR N80166Cessna 172M · S/N 17266414Cancelled Jun 1, 1979 · Exported to Canada · Peyton, CO N8831HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1542Cancelled Apr 4, 1978 · Exported to Canada · Walnut Ridge, AR N1573XPiper PA-28-180 · S/N 28-7505242Cancelled Jun 28, 1976 · Built 1975 · Peyton, CO N83846Aeronca 7AC · S/N 7AC-2527Cancelled May 27, 1976 · Built 1946 · Kansas City, MO N588BBeech D18S · S/N A-429Cancelled Aug 30, 1974 · Exported to Guatemala · Dallas, TX N9276JPiper PA-28-180 · S/N 28-3355Cancelled Aug 19, 1974 · Exported to Iceland · Peyton, CO N9417LAmerican AA-1B · S/N AA1B-0017Cancelled Oct 18, 1973 · Kansas City, MO N5155UCessna 206 · S/N 206-0155Cancelled Mar 7, 1972 · Renton, WA N9374KStinson 108 · S/N 1082374Cancelled Sep 24, 1947 · New Brighton, MN N2079North American GA-15 · S/N A-15-1Cancelled Dec 30, 1935 · Built 1935 · Washington, DC

Back to American Aviation Inc