OpenAirDocs.org
Ft Wayne, IN

Cancelled registrations · 50

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 = 'FT WAYNE'
  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.

N1982BLuscombe 8A · S/N 6409Cancelled Sep 6, 2019 · Revoked, canceled · Built 1948 · Wahl Gerald RN8107PPiper PA-24-250 · S/N 24-3357Cancelled Jan 9, 2019 · Registration expired, pending cancellation · Built 1962 · Poorman R WilliamN8924PPiper PA-24-260 · S/N 24-4380Cancelled Mar 16, 2018 · Revoked, canceled · Built 1966 · Prop Wash IncN76216Cessna 140 · S/N 10619Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Smith Eugene EN89508Cessna 140 · S/N 8544Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1946 · Dick Randall JN7144ACessna 172 · S/N 29244Cancelled Dec 22, 2014 · Revoked, canceled · Built 1956 · Leininger Ted LN4160MRaven S55A · S/N S55A-1019Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1983 · Gray MarkN75KSSchneider-Kenton PITTS SPECIAL S-1S · S/N 725Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1979 · Schneider Kenton RN717QBeech 65-80 · S/N LD-66Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1962 · George H Bailey Co IncN87123Engineering & Research ERCOUPE 415-C · S/N 296Cancelled Nov 14, 2012 · Sale reported, pending cancellation · Built 1946N30080Balloon GC-1 · S/N 100Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1966 · Craig George AN29738Taylorcraft BC12-65 · S/N 2584Cancelled Aug 30, 2012 · Sale reported, canceled · Built 1941N5851PPiper PA-24-250 · S/N 24-933Cancelled Aug 30, 2012 · Revoked, canceled · Built 1959 · Weldon Henry JN6331TCougar 1 · S/N 1Cancelled Aug 22, 2006 · Triennial form not returned · Built 1964 · Saine Phillip GeneN57239Raven S55A · S/N S55A740Cancelled Aug 1, 1998 · Second triennial mailing, no response · Meekin Ronald DN310DLCessna 310R · S/N 310R1820Cancelled Aug 21, 1997 · Triennial form not returned · D & L Communications Inc.N263AMMrotek Arnold A MINICAB GY-20 · S/N 232ACancelled Jul 25, 1997 · Triennial form not returned · Brewer John AN8082JPiper AEROSTAR 601P · S/N 61P05687963246Cancelled May 7, 1993 · Exported to South Africa · Rupprecht Aero IncN1593ECessna 172N · S/N 17271058Cancelled Mar 13, 1992 · Exported to South Africa · Rupprecht Aero IncN758ZBCessna A152 · S/N A1521026Cancelled Mar 13, 1992 · Exported to South Africa · Rupprecht Aero IncN54742Piper PA-23-250 · S/N 277554056Cancelled Dec 4, 1991 · Exported to VenezuelaN3GVBellanca 7ECA · S/N 113076Cancelled Sep 3, 1991 · Exported to South Africa · Rupprecht Aero IncN41559Piper PA-28R-200 · S/N 28R7435200Cancelled Apr 17, 1991 · Exported to South AfricaN32173Piper PA-28R-200 · S/N 28R7535031Cancelled Jan 24, 1991 · Exported to South Africa · Barry And Gail IncN8309CPiper PA-28R-200 · S/N 28R7635145Cancelled Jan 14, 1991 · Exported to South Africa · Rupprecht Aero IncN77372Cessna 120 · S/N 11813Cancelled Oct 16, 1989 · Second triennial mailing, no response · Marsh Myron LN3213BPiper PA-22-135 · S/N 22-2040Cancelled Nov 29, 1977 · Quinn William EN15CMCessna 310J · S/N 310J0158Cancelled Jul 14, 1977 · Built 1965 · Graham James C EtalN250ULockheed 18 · S/N 2210Cancelled Dec 16, 1976 · Speedbird AircraftN61528Cessna 172M · S/N 17264616Cancelled Feb 4, 1976 · Exported to Canada · Fort Wayne Air ServiceN9491KStinson 108-2 · S/N 108-2491Cancelled May 15, 1974 · O Boyle P DN9459ACessna 140A · S/N 15466Cancelled Jul 7, 1972 · Exported to Canada · Built 1950 · Gamble Gary LN1831VCessna 120 · S/N 14048Cancelled Feb 7, 1972 · Built 1947 · Rybolt Marcus JN3406APiper PA-22-135 · S/N 22-1676Cancelled Sep 28, 1971 · Robert D MapesN619SCassutt III R · S/N 010Cancelled Feb 3, 1971 · Snyder LamonteN69541Cessna T-50 · S/N 2239Cancelled Aug 31, 1970 · Fort Wayne Air Svc IncN9423DPiper PA-22-160 · S/N 22-6397Cancelled Nov 30, 1967 · Exported to Canada · Built 1958 · Sherman Dennis M DBA Sherman Aircraft SalesN2545YCessna 172D · S/N 17249845Cancelled Dec 9, 1965 · Popp Thomas GN1048Luscombe PHANTOM 1 · S/N 116Cancelled Feb 20, 1956 · Built 1937 · Rettig Charles FN9281EAeronca 11AC · S/N 11AC-919Cancelled Nov 16, 1954 · Ducat Allen AN8312KStinson 108-1 · S/N 108-1312Cancelled Nov 3, 1954 · Judd Theron WayneN4806NDouglas R4D-1 · S/N 4441Cancelled Aug 16, 1954 · Exported to Canada · Leeward Albert JN61806Cessna UC-78 · S/N 5314Cancelled Dec 28, 1953 · Leeward Albert J DBA Leeward Aeronautical ServN47005Aeronca 0-58B · S/N 058B-11203Cancelled Apr 21, 1953 · Young FredN9986HConsolidated Vultee BT-13 · S/N 218Cancelled Mar 13, 1953 · Built 1940 · Budd JackN13873Stinson SR-5E · S/N 9252-ACancelled Jan 12, 1953 · Built 1934 · Pinkham Harvey WN47297Aeronca 0-58B · S/N 058B-13224Cancelled Nov 14, 1949 · Mcclurg GeraldN9992HHoward GH-3 · S/N 907Cancelled Jan 27, 1948 · Giessler Byron CN383KRyan B-5 · S/N 220Cancelled Oct 21, 1931 · News Publishing CoN2038Lincoln Standard LS 3 · S/N 115Cancelled Oct 27, 1928 · Sweebrock Aviation
Back to Ft Wayne, IN