Norwalk, CT

Cancelled registrations · 70

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 = 'CT' AND d.registrant_city = 'NORWALK'
  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.

N101TMWalsh SCAMP · S/N 13Cancelled Jun 10, 2002 · Second triennial mailing, no response · Built 1975 · Walsh Michael KN202TMWalsh-Michael BAKENG DUCE · S/N 14Cancelled Jun 10, 2002 · Second triennial mailing, no response · Walsh Michael KN313LSEurocopter Deutschland MBB-BK 117 C-1 · S/N 7509Cancelled Dec 19, 2001 · Triennial form not returned · Built 1994 · Debis Financial Services IncN89SMAerospatiale SA365N-1 DAUPHIN · S/N 6282Cancelled May 18, 2001 · Debis Financial Services IncN44NYEurocopter Deutschland EC135P1 · S/N 0019Cancelled Jan 11, 2000 · Debis Financial Services IncN209RSBell 230 · S/N 23003Cancelled Sep 1, 1999 · Exported to Brazil · Debis Financial Services IncN230HMesserschmitt-Bolkow-Blohm BK 117 A-4 · S/N 7136Cancelled May 5, 1999 · Triennial form not returned · Debis Financial Services IncN4507SBeech A36 · S/N E722Cancelled Jan 4, 1999 · Casey Eugene J JrN131CHAerospatiale AS350B · S/N 1735Cancelled May 16, 1995 · Exported to Canada · Debis Financial Services IncN190FWKiska FW-190 · S/N 001Cancelled Feb 6, 1981 · Built 1973 · Kiska Joseph WN4121QCessna 310N · S/N 310N-0021Cancelled Sep 25, 1978 · Revoked, canceled · Built 1967 · R K M Leasing LtdN3085Ferencz MEAD PRIMARY GLIDER · S/N HMS-SG-1Cancelled May 18, 1976 · Ferencz Albert JN3410XMooney M20C · S/N 3393Cancelled Dec 5, 1974 · Exported to Switzerland · Albert FinkN9295Armstead TEENIE TWO · S/N 510086Cancelled Apr 16, 1973 · Armstead BabraraN165CABenner CA-65 · S/N B-131Cancelled Feb 22, 1973 · Benner Karl (Nmi)N476TBeech 35-A33 · S/N CD-302Cancelled Oct 14, 1964 · John D WinninghoffN172LCessna T-50 · S/N 4858Cancelled Apr 7, 1960 · Leibolt JohnN51587Fairchild M-62A · S/N 8673 AECancelled Oct 21, 1955 · Young K P & M E CalvinN9156Loening C-2-C · S/N 224Cancelled Jul 1, 1939 · Built 1929 · Cuyler BartonN1043Curtiss JN4D · S/N 44348Cancelled Apr 30, 1930 · Boyd Miles C Earle L Shaw & Nathaniel F Fillow
Back to Norwalk, CT