Angola, IN

Cancelled registrations · 27

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_state = 'IN' AND d.registrant_city = 'ANGOLA'
  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.

N177DBAviat A-1C-180 · S/N 3019Cancelled Sep 8, 2025 · Exported to Iceland · Built 2008 · Magley RobertN3713SCessna 172E · S/N 17250913Cancelled Mar 15, 2023 · Registration expired, pending cancellation · Built 1963 · M P Perry Properties LLCN4941DCessna 182A · S/N 51041Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1958 · Molter Tod EN710BXQuicksilver MXL II · S/N 861MHCancelled Jan 23, 2018 · Registration expired, pending cancellation · Hansbarger Mark BN457XByers Michael M3 ORIN · S/N B 1600Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 2005 · Byers Michael AN361MMarckel Mike RAF-1000 · S/N H1-2MCancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 2000 · Marckel Michael LN93230Cessna 210L · S/N 21060315Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1974 · Newnam Tire Service IncN3788JCessna 150G · S/N 15065088Cancelled Jul 21, 2011 · Revoked, canceled · Built 1966 · Flying Thunderbirds IncN9393YBeech N35 · S/N D-6574Cancelled Sep 27, 1999 · Triennial form not returned · Wallace Donald GN5685ECessna 172N · S/N 17271919Cancelled May 20, 1998 · Triennial form not returned · Eyster Marjorie EN23511Yarger JT2 · S/N 57YCancelled May 17, 1976 · Built 1943 · Yarger Archiel AN7428GCessna 172K · S/N 17259128Cancelled May 14, 1975 · Exported to Canada · Flying Education Assoc IncN2265PPiper PA-23 · S/N 23-875Cancelled Sep 24, 1974 · Leininger Clyde RN4840UCessna 210-5A(205A) · S/N 205-0540Cancelled Aug 12, 1974 · Flying Education Association IncN60717Cessna 150J · S/N 15070523Cancelled Apr 23, 1974 · Flying Thunderbirds IncN1093ZPlaymate #2 · S/N 2Cancelled Aug 12, 1971 · Nodine MelvinN24241Aeronca 65-LA · S/N L-7089Cancelled Mar 18, 1971 · Built 1939 · Yarger Archiel AN1749KLuscombe 8E · S/N 4476Cancelled Sep 2, 1970 · Robert Royce ShinaberyN83237Aeronca 7AC · S/N 7AG-1901Cancelled Mar 3, 1967 · Exported to Canada · John F GordenN3573SCessna 172E · S/N 17250773Cancelled Dec 21, 1965 · Flying Thunderbirds IncN46778Piper J3C-65 · S/N 10496Cancelled Mar 19, 1959 · Exported to Canada · Built 1945 · Eyster MarjorieN42317Piper J3L-65 · S/N 14567Cancelled Feb 10, 1959 · Exported to Canada · Sutton DenverN92377Piper J3C-65 · S/N 16839Cancelled Nov 26, 1958 · Exported to Canada · Eyster MarjorieN19782Aeronca KC · S/N KC12Cancelled Mar 4, 1955 · Built 1937 · Clements Robert LN51803Boeing A75N1 · S/N 75-2297Cancelled Nov 26, 1947 · Orville M FlorineN13502Decatur Mead Rhon RANGER · S/N D-1Cancelled Apr 1, 1939 · Built 1933 · Tri-State Glider ClubN1995Waco GXE · S/N 953Cancelled Feb 4, 1933 · Built 1927 · Garvice Clarke/Hammond F L
Back to Angola, IN