OpenAirDocs.org
Waterloo, IA

Cancelled registrations · 280

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 = 'IA' AND d.registrant_city = 'WATERLOO'
  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.

N961SPCessna 172S · S/N 172S8163Cancelled May 7, 2004 · Exported to United Kingdom · Built 1999 · Tim Mccandless IncN957SPCessna 172S · S/N 172S8157Cancelled Feb 11, 2004 · Exported to United Kingdom · Built 1999 · Tim Mccandless IncN4495XPiper PA-28-151 · S/N 28-7615020Cancelled Sep 16, 2003 · Exported to France · Built 1975 · Tim Mccandless IncN279EMBeech 76 · S/N ME-279Cancelled Dec 10, 2002 · Exported to Canada · Tim Mccandless IncN107GPiper PA-31 · S/N 31-109Cancelled Feb 6, 2002 · Exported to Canada · Built 1968 · Tim Mccandless IncN5314BCessna 152 · S/N 15283834Cancelled Dec 3, 2001 · Triennial form not returned · Built 1979 · Reeves Robert CN787GMPiper PA-34-200T · S/N 34-7870021Cancelled Oct 3, 2001 · Exported to Canada · Built 1978 · Tim Mccandless IncN66555Cessna 150M · S/N 15076120Cancelled Jul 26, 2001 · Exported to Spain · Arcadia Aviation LtdN6133PBeech 76 · S/N ME-343Cancelled Oct 12, 2000 · Exported to United Kingdom · Tim Mccandless IncN31UVCessna 310R · S/N 310R1572Cancelled Feb 4, 2000 · Triennial form not returned · Tim Mccandless IncN209WBCessna TU206G · S/N U20605506Cancelled Dec 17, 1998 · Exported to Mexico · Tim Mccandless IncN7583ZCessna U206G · S/N U20606377Cancelled Aug 31, 1998 · Exported to Mexico · Tim Mccandless IncN848HPGrumman G-21A · S/N 1153Cancelled May 22, 1998 · Exported to Canada · Peier IncN17RQCessna P210N · S/N P21000282Cancelled Feb 19, 1997 · Triennial form not returned · Z-PaperN741TPiper PA-31-350 · S/N 318052106Cancelled Jan 31, 1997 · Exported to Canada · Tim Mccandless IncN4330BPiper PA-31-310 · S/N 317300904Cancelled Jan 7, 1997 · Exported to Gabon · Tim Mccandless IncN174EPiper PA-31-350 · S/N 317852128Cancelled Sep 5, 1996 · Exported to Canada · Tim Mccandless IncN732YYCessna 210M · S/N 21061892Cancelled Jul 2, 1996 · Exported to France · Tim Mccandless IncN734ANCessna 172N · S/N 17268704Cancelled Jun 14, 1996 · Exported to Germany · Nordic Air L L CN4206PPiper PA-23-160 · S/N 231696Cancelled Jan 27, 1996 · Triennial form not returned · Hawkeye Community CollegeN5432XPiper PA-31-350 · S/N 317852111Cancelled Dec 12, 1995 · Exported to South Korea · Tim Mccandless IncN704VQCessna 150M · S/N 15078911Cancelled Nov 17, 1995 · Exported to Netherlands · Ar IncN98976Cessna 340A · S/N 340A0716Cancelled Oct 5, 1995 · Exported to Denmark · Tim Mccandless IncN9914CCessna T303 · S/N T30300236Cancelled Sep 1, 1995 · Exported to Netherlands · Tim Mccandless IncN8275ECessna 172N · S/N 17272162Cancelled Jul 25, 1995 · Exported to Germany · Tim Mccandless IncN739LFCessna 172N · S/N 17270622Cancelled Jun 30, 1995 · Exported to Germany · Hebo Travel IncN3271QCessna 401 · S/N 4010071Cancelled Jun 7, 1995 · Triennial form not returned · Tim Mccandless IncN1154PMooney M20K · S/N 250636Cancelled May 23, 1995 · Exported to Luxembourg · G K Aircraft IncN8603GCessna 340A · S/N 340A0707Cancelled Mar 31, 1995 · Exported to Germany · Tim Mccandless IncN9209BPiper PA-28-161 · S/N 2841342Cancelled Nov 25, 1994 · Exported to Senegal · Tim Mccandless IncN2169XPiper PA-31-350 · S/N 31-7952245Cancelled Nov 10, 1994 · Exported to Canada · Built 1979 · Tim Mccandless IncN2287JPiper PA-31-350 · S/N 318052077Cancelled Aug 31, 1994 · Exported to United Kingdom · Tim Mccandless IncN1835PBeech A36 · S/N E1910Cancelled Mar 29, 1994 · Exported to Belgium · Tim Mccandless IncN9215QPiper PA-28-161 · S/N 2841340Cancelled Dec 22, 1993 · Exported to Germany · Tim Mccandless IncN451JBCessna 210C · S/N 21061562Cancelled Dec 3, 1993 · Exported to Canada · Tim Mccandless IncN97586Cessna 182Q · S/N 18267140Cancelled Nov 30, 1993 · Exported to Germany · Tim Mccandless IncN2427QPiper PA-28-161 · S/N 288616003Cancelled Nov 26, 1993 · Exported to Netherlands · Tim Mccandless IncN6180MMaule M-5-235C · S/N 7183CCancelled Nov 4, 1993 · Exported to United Kingdom · Ste IncN7082YPiper PA-31-325 · S/N 31-7400990Cancelled Nov 2, 1993 · Exported to Canada · Tim Mccandless IncN80WWCessna P210N · S/N P21000054Cancelled Sep 14, 1993 · Exported to Mexico · Tim Mccandless IncN991TMMarfield Terry Joe KR-2 · S/N 8434Cancelled Aug 5, 1993 · Maxfield Terry JN756KECessna TR182 · S/N R18201091Cancelled Jul 6, 1993 · Exported to Germany · Tim Mccandless IncN8240GPiper PA-34-220T · S/N 348333004Cancelled Jun 7, 1993 · Exported to Switzerland · Tim Mccandless IncN8326BPiper PA-28-181 · S/N 288190151Cancelled Jun 4, 1993 · Exported to Germany · Tim Mccandless IncN800WCCessna P210N · S/N P21000585Cancelled May 11, 1993 · Triennial form not returned · Tim Mccandless IncN6196CPiper PA-31-350 · S/N 31-7752101Cancelled Apr 23, 1993 · Exported to Canada · Tim Mccandless IncN7346XCessna R182 · S/N R18200082Cancelled Apr 5, 1993 · Exported to Canada · Tim Mccandless IncN66210Cessna 172P · S/N 17275979Cancelled Dec 8, 1992 · Exported to Japan · Tim Mccandless IncN53020Cessna 172P · S/N 17274664Cancelled Dec 4, 1992 · Exported to Germany · Tim Mccandless IncN47809Cessna 152 · S/N 15283254Cancelled Nov 9, 1992 · Exported to Germany · Tim Mccandless Inc
Back to Waterloo, IA