OpenAirDocs.org
West Lafayette, IN

Cancelled registrations · 53

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 = 'WEST LAFAYETTE'
  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.

N349TGMoni 349t MONI · S/N 349TCancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 2007 · Parker Michael AndrewN688YPDJI PHANTOM 3 PROFESSION · S/N P76DCJ14A26913Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Purdue UniversityN764PSPurdue School Avn/Trnspn Tech SATT 3D-2019 · S/N 2019-001Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Purdue School Of Aviation & Transportation TechN50703Cessna 150J · S/N 15069495Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Trustees Of Purdue UniversityN312ELGulfstream Aerospace G-IV · S/N 1105Cancelled May 22, 2021 · Sale reported, canceled · Built 1989N660LPPrecisionhawk HAWKEYE · S/N 14HE03077Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Purdue UniversityN62085Cessna 172P · S/N 17275209Cancelled Aug 26, 2019 · First renewal notice · Purdue Aviation LLCN660VPPurdue University NG-1 · S/N 1965Cancelled Jul 2, 2019 · Registration expired, pending cancellation · Purdue UniversityN613GRMichael Leasure RH-1 · S/N 1963Cancelled May 6, 2019 · Registration expired, pending cancellation · Purdue UniversityN16PUMichael Leasure TH-1 · S/N 1964Cancelled May 4, 2019 · Registration expired, pending cancellation · Purdue UniversityN636CUMichael Leasure SPREADINGWINGS S1000 · S/N 1966Cancelled May 2, 2019 · Registration expired, pending cancellation · Purdue UniversityN636RUMichael Leasure DJI 1000 · S/N 1967Cancelled May 2, 2019 · Registration expired, pending cancellation · Purdue UniversityN388TYCGS HAWK ARROW II · S/N H-A-II-150-TR1-F30Cancelled Mar 2, 2019 · Registration expired, pending cancellation · Built 2002 · Jacobs Michael PN13PUPrecisionhawk USA LANCASTER · S/N 14HE03069Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Purdue UniversityN580PUCirrus Design SR20 · S/N 2039Cancelled Jul 25, 2018 · Built 2010 · Trustees Of Purdue UniversityN665NZ3D Robotics SOLO · S/N 121ACancelled May 31, 2018 · Sale reported, canceledN92975Commonwealth 185 · S/N 1708Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 1946 · Sorton Melvin RN1986PHead Balloons AX8-88 · S/N 123Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1986 · Baitinger William EN3432YCessna 310R · S/N 310R0835Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1976 · Purdue UniversityN54971Cessna 172P · S/N 17275095Cancelled Jan 30, 2013 · First renewal notice · Built 1981 · Lafayette Aviation IncN11EBBuck ROADAIRE 1 · S/N 1Cancelled Mar 17, 2011 · Sale reported, pending cancellation · Built 1970N241WWilson Herbert A QUICKIE Q-2 · S/N 2612Cancelled Oct 27, 2010 · Sale reportedN546PUDehavilland DHC-1 CHIPMUNK 22 · S/N C1-0650Cancelled Oct 12, 2010 · Exported to United Kingdom · Purdue UniversityN6118LCameron Balloons US V-77 · S/N 5548Cancelled Jan 26, 2009 · Triennial form not returned · Built 1990 · Eismin Thomas KN999SKPiper PA-28R-200 · S/N 28R-7535284Cancelled Apr 28, 2005 · Triennial form not returned · Built 1975 · Lafayette AviationN5213BCessna 152 · S/N 15283804Cancelled Mar 14, 2000 · Triennial form not returned · Lafayette Aviation IncN9051UBoeing 737-222 · S/N 19932Cancelled Jun 15, 1999 · Purdue UniversityN18562Beech 76 · S/N ME431Cancelled Oct 29, 1998 · Triennial form not returned · Purdue UniversityN525PUPiper PA-28-161 · S/N 2841190Cancelled Jun 16, 1992 · Purdue UniversityN2959RPiper PA-28-161 · S/N 287916586Cancelled Apr 28, 1992 · Purdue Pilots IncN737WJCessna 172N · S/N 17269729Cancelled May 22, 1981 · Exported to Canada · Reid Airways IncN290PHiller OH-23D · S/N 61-3125Cancelled Nov 18, 1980 · Trustees Of Purdue UniversityN82344Piper PA-25-235 · S/N 25-7656090Cancelled May 4, 1977 · Exported to Canada · Built 1976 · Reid Airways IncN5486ZPiper PA-22-108 · S/N 229269Cancelled Apr 8, 1976 · Exported to Canada · Onderka Detlef KN10761Cessna 150 · S/N 150-75015Cancelled Aug 25, 1975 · Exported to Canada · Built 1973 · Reid Airways IncN6036GCessna 150K · S/N 15071536Cancelled May 15, 1975 · Exported to Canada · Avtech Flying Club IncN1711RPiper PA-23-250 · S/N 27-2747Cancelled Sep 18, 1974 · Weber Richard HN60788Cessna 150 · S/N 15070580Cancelled Aug 22, 1973 · Reid Airways IncN7416MCessna 175 · S/N 55716Cancelled Dec 7, 1970 · Martin Joe MN79113Corcoran TG-1A · S/N 2-25Cancelled May 20, 1965 · Purdue Glider ClubN38277Piper J3F-65 · S/N 6904Cancelled Mar 5, 1956 · Built 1941 · Marquardt Richard E Et AlN22475Aeronca 65-C · S/N C-4219Cancelled Nov 8, 1955 · Built 1939 · Jackson LowellN61786Aeronca 0-58B · S/N 058B-11723Cancelled Oct 25, 1955 · Hildebrand Richard EN46941Fairchild M-62A · S/N T42-1958Cancelled Oct 24, 1955 · Hertwig Lee JN69951Fairchild M-62C · S/N FE-44Cancelled Apr 18, 1955 · Taylor Martin W & Richard C ScalN39735Waco UPF-7 · S/N 5868Cancelled Aug 22, 1951 · Purdue Aeronautics CorpN87429Engineering & Research ERCOUPE 415-C · S/N 602Cancelled Jun 7, 1951 · Cole IraN39728Waco UPF-7 · S/N 5861Cancelled Jan 4, 1949 · Purdue Aeronautics CorporationN34243Frankfort GLIDER B · S/N B-1-8Cancelled Nov 24, 1948 · Purdue Glider ClubN14102Gross Sailcraft GROSS F-5 · S/N 1Cancelled Apr 1, 1948 · Built 1934 · Purdue Glider Club
Back to West Lafayette, IN