Earlier aircraft under this name · 53

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

N33371Douglas DC3A · S/N 7409Cancelled Jan 29, 1947 · New York, NY N735NAmerican Airplane & Engine PILGRIM 100A · S/N 6615Cancelled Sep 20, 1935 · Exported to Mexico · Built 1932 · Chicago, IL N968VAmerican Airplane & Engine PILGRIM 100A · S/N 6601Cancelled Sep 5, 1935 · Exported to Mexico · Chicago, IL N997VAmerican Airplane & Engine PILGRIM 100A · S/N 6602Cancelled Jun 3, 1935 · Exported to Costa Rica · New York, NY N12113Stinson U · S/N 9001Cancelled May 9, 1935 · Chicago, IL N415HFord 5-AT-C · S/N 75Cancelled Feb 28, 1935 · Exported to Honduras · Chicago, IL N11155Stinson SM-6000-B · S/N 5022Cancelled Feb 11, 1935 · Built 1931 · Chicago, IL N12395Curtiss Wright AT-32B · S/N 47Cancelled Dec 19, 1934 · Chicago, IL N12285Lockheed ORION 9D · S/N 197Cancelled Nov 15, 1934 · Built 1933 · Chicago, IL N11120Stinson SM-6000-B · S/N 5019Cancelled Nov 6, 1934 · Built 1931 · Chicago, IL N871MBellanca CH300 PACEMAKER · S/N 163Cancelled Nov 2, 1934 · Chicago, IL N10892Stinson SM-6000-B · S/N 5052Cancelled Sep 28, 1934 · Exported to Mexico · Built 1931 · Chicago, IL N7VSikorsky S-38-C · S/N 314-11Cancelled Jul 18, 1934 · Chicago, IL N6490Stearman C-3-MB · S/N 188Cancelled Jul 17, 1934 · Robertson, MO N12354Curtiss-Wright T-32-C CONDOR II · S/N 22Cancelled Jun 9, 1934 · Built 1933 · Chicago, IL N710YPilgrim PITTS SPECIAL S-1 · S/N 6606Cancelled Mar 6, 1934 · Chicago, IL N982MAmerican Airplane & Engine PILGRIM 100A · S/N 6611Cancelled Feb 12, 1934 · Chicago, IL N378VPitcairn PA-6 · S/N 142Cancelled Oct 17, 1933 · Chicago, IL N9790Fokker F-10-A(FXA) · S/N 1036Cancelled Oct 17, 1933 · Chicago, IL N12194Stinson U · S/N 9020Cancelled Oct 3, 1933 · Chicago, IL N8829Stearman LT-1 · S/N 2001Cancelled Aug 3, 1933 · St Louis, MO N8832Stearman LT-1 · S/N 2002Cancelled Aug 3, 1933 · Exported to China · St Louis, MO N8833Stearman LT-1 · S/N 2003Cancelled Aug 3, 1933 · St Louis, MO N9128Fokker SUPER UNIVERSAL · S/N 846Cancelled Aug 3, 1933 · Exported to Mexico · Robertson, MS N9132Fokker UNIVERSAL · S/N 850Cancelled Aug 3, 1933 · Exported to Mexico · Dallas, TX N9134Fokker UNIVERSAL · S/N 852Cancelled Aug 3, 1933 · Exported to Mexico N805EFokker F-10-A(FXA) · S/N 1034Cancelled Jul 1, 1933 · Chicago, IL N489EFokker F-10-A(FXA) · S/N 1020Cancelled Jun 29, 1933 · St Louis, MO N802EFokker F-10-A(FXA) · S/N 1031Cancelled Jun 29, 1933 · St Louis, MO N9167Fokker F-10-A(FXA) · S/N 1039Cancelled Jun 15, 1933 · Built 1929 · Dallas, TX N880EFokker F-10-A(FXA) · S/N 1047Cancelled Jun 1, 1933 · Built 1929 · Robertson, MO N881EFokker F-10-A(FXA) · S/N 1048Cancelled May 12, 1933 · Built 1929 · Robertson, MO N732NAmerican Airplane & Engine PILGRIM 100A · S/N 6612Cancelled Apr 7, 1933 · Chicago, IL N146HFairchild 42 · S/N 2Cancelled Mar 24, 1933 · Built 1929 · St Louis, MO N490WStearman 4CM-1 · S/N 4038Cancelled Feb 3, 1933 · Chiacago, IL N801EFokker F-10-A(FXA) · S/N 1030Cancelled Feb 2, 1933 N738NAmerican Airplane & Engine PILGRIM 100B · S/N 6702Cancelled Jan 24, 1933 · Built 1932 · Chicago, IL N9127Fokker SUPER UNIVERSAL · S/N 845Cancelled Jan 23, 1933 · St Louis, MO N651EFokker F-10-A(FXA) · S/N 1025Cancelled Jan 12, 1933 · St Louis, MO N804EFokker F-10-A(FXA) · S/N 1033Cancelled Jan 12, 1933 N581KFokker F-10-A(FXA) · S/N 1055Cancelled Dec 28, 1932 · St Louis, MO N9169Fokker F-10-A(FXA) · S/N 1038Cancelled Dec 13, 1932 · Dallas, TX N800EFokker F-10-A(FXA) · S/N 1029Cancelled Nov 1, 1932 N10818Stinson SM-6000-B · S/N 5037Cancelled Oct 3, 1932 · Built 1931 · Chicago, IL N9716Fokker F-10-A(FXA) · S/N 1009Cancelled Sep 27, 1932 N9166Fokker F-10-A(FXA) · S/N 1037Cancelled Sep 19, 1932 · St Louis, MO N11124Stinson SM-6000-B · S/N 5017Cancelled Jun 17, 1932 · Exported to Canada · Built 1931 · New York, NY N652EFokker F-10-A(FXA) · S/N 1027Cancelled Mar 21, 1932 N708YAmerican Airplane & Engine PILGRIM 100A · S/N 6604Cancelled Jan 18, 1932 · Chicago, IL N5365American Airplane & Engine PILGRIM FC-2 · S/N 101Cancelled Dec 22, 1931 · Cincinnati, OH

Back to American Airways Inc