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.

N9202HPiper PA-28-161 · S/N 2841292Cancelled Oct 19, 1992 · Exported to France · Tim Mccandless IncN8464ZPiper PA-34-220T · S/N 348233032Cancelled Sep 11, 1992 · Exported to Canada · Tim Mccandless IncN5302DCessna 172N · S/N 17272504Cancelled Aug 10, 1992 · Exported to Germany · Tim Mccandless IncN6164QCessna 152 · S/N 15285178Cancelled Aug 10, 1992 · Exported to Germany · Tim Mccandless IncN36826Piper PA-32RT-300T · S/N 32R7887088Cancelled Aug 7, 1992 · Exported to Canada · James Potts IncN6488SCessna R182 · S/N R18201685Cancelled Jul 22, 1992 · Exported to Switzerland · Tim Mccandless IncN6345DCessna 172N · S/N 17272731Cancelled Jun 11, 1992 · Exported to Turkey · Tim Mccandless IncN7SXCessna T303 · S/N T30300109Cancelled May 28, 1992 · Exported to Germany · Tim Mccandless IncN201ANMooney M20J · S/N 240417Cancelled May 19, 1992 · Exported to France · Tim Mccandless IncN129SCCessna 152 · S/N 15280245Cancelled May 13, 1992 · Exported to Germany · Tim Mccandless IncN5244WCessna P210N · S/N P21000661Cancelled May 8, 1992 · Exported to Germany · Tim Mccandless IncN9457CCessna T303 · S/N T30300177Cancelled Apr 14, 1992 · Exported to Germany · Tim Mccandless IncN734QRCessna P210N · S/N P21000611Cancelled Mar 23, 1992 · Triennial form not returned · Tim Mccandless IncN25937Cessna 152 · S/N 15280868Cancelled Feb 26, 1992 · Exported to Germany · Tim Mccandless IncN82855Piper PA-28-181 · S/N 288190075Cancelled Dec 31, 1991 · Exported to Germany · Tim Mccandless IncN9082XPiper PA-28-161 · S/N 288616053Cancelled Dec 31, 1991 · Exported to Germany · Tim Mccandless IncN14DSPiper PA-31-325 · S/N 318112008Cancelled Dec 4, 1991 · Exported to Guatemala · Tim Mccandless IncN6394RCessna 172RG · S/N 172RG0177Cancelled Dec 3, 1991 · Exported to France · Tim Mccandless IncN69086Piper PA-28-161 · S/N 288516052Cancelled Dec 3, 1991 · Exported to France · Tim Mccandless IncN4370YPiper PA-46-310P · S/N 468408080Cancelled Nov 12, 1991 · Exported to France · Tim Mccandless IncN6518VCessna 172RG · S/N 172RG0745Cancelled Nov 7, 1991 · Exported to Germany · Tim Mccandless IncN6179CCessna T303 · S/N T30300148Cancelled Oct 31, 1991 · Exported to Germany · Tim Mccandless IncN75183Piper PA-32-300 · S/N 327640093Cancelled Oct 29, 1991 · Exported to France · Tim Mccandless IncN4378TPiper PA-46-310P · S/N 468508010Cancelled Sep 24, 1991 · Exported to Germany · Tim Mccandless IncN3083KBeech F33A · S/N CE1243Cancelled Aug 27, 1991 · Exported to Germany · Tim Mccandless IncN1527PBeech F33A · S/N CE1286Cancelled Jul 22, 1991 · Exported to Switzerland · Tim Mccandless IncN98897Cessna 172P · S/N 17276375Cancelled Jul 9, 1991 · Exported to Germany · Tim Mccandless IncN29580Piper PA-28RT-201T · S/N 28R7931200Cancelled Jun 28, 1991 · Exported to Germany · Tim Mccandless IncN5477JCessna 172N · S/N 17273807Cancelled Jun 11, 1991 · Exported to France · Tim Mccandless IncN131AVPiper PA-28-181 · S/N 288490067Cancelled Jun 6, 1991 · Exported to France · Tim Mccandless IncN2236KPiper PA-28-161 · S/N 287916231Cancelled May 31, 1991 · Exported to France · Tim Mccandless IncN2287UCessna 182R · S/N 18267887Cancelled May 29, 1991 · Exported to Germany · Tim Mccandles IncN731ZTCessna P210N · S/N P21000570Cancelled May 15, 1991 · Exported to Germany · Tim Mccandless IncN9091BPiper PA-28-181 · S/N 288690038Cancelled May 8, 1991 · Exported to Germany · Tim Mccandless IncN8461ZPiper PA-28-161 · S/N 288216061Cancelled Apr 19, 1991 · Exported to France · Tim Mccandless IncN58179Cameron Balloons US V-77 · S/N 5027Cancelled Apr 11, 1991 · Triennial form not returned · Schrader ChuckN52352Cessna 172P · S/N 17274499Cancelled Mar 21, 1991 · Exported to Germany · Tim Mccandless IncN62626Cessna 172P · S/N 17275314Cancelled Mar 21, 1991 · Exported to Germany · Tim Mccandless IncN6292PCessna P210N · S/N P21000162Cancelled Mar 20, 1991 · Exported to Germany · Tim Mccandless IncN2255CCessna T303 · S/N T30300079Cancelled Mar 14, 1991 · Exported to Germany · Tim Mccandless BlvdN7223RBeech A36 · S/N E2221Cancelled Dec 26, 1990 · Exported to France · Tim Mccandless IncN8429LPiper PA-34-220T · S/N 348133215Cancelled Dec 26, 1990 · Exported to Germany · Tim Mccandless IncN81879Piper PA-28-236 · S/N 288011100Cancelled Dec 24, 1990 · Exported to Germany · Tim Mccandless IncN12415Hiller OH-23B · S/N 51-16236Cancelled Jul 11, 1984 · Administratively canceled · Hawkeye Institute Of Technology AkaN56PBell HTL-4 · S/N 227Cancelled Dec 6, 1983 · Hawheye Institute Of TechnologyN9200TPiper PA-38-112 · S/N 38-78A0275Cancelled Oct 22, 1981 · Built 1978 · Niederhauser Airways IncN5196PPiper PA-24-180 · S/N 24220Cancelled Oct 28, 1977 · Blow David R DBA Blow & AssocN5570Sikorsky UH-19D · S/N 571633Cancelled Jul 8, 1977 · Hawkeye Instiute Of TechnologyN4232KNavion NAVION A · S/N NAV-4-1232Cancelled Oct 14, 1975 · Built 1948 · Iowa Structures IncN30562Cessna 177A · S/N 17701328Cancelled Oct 6, 1975 · Built 1968 · Hawkeye Institute Of Technology
Back to Waterloo, IA