OpenAirDocs.org
Wurtsboro, NY

Cancelled registrations · 17

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 = 'NY' AND d.registrant_city = 'WURTSBORO'
  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.

N912FPFpna A-22 VALOR · S/N H035Cancelled Feb 2, 2018 · Third renewal notice · Built 2010 · Pullman Robert NN704ALCessna 150M · S/N 15078458Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1976 · Wurtsboro Flight Service IncN33936Schweizer SGS 2-33A · S/N 396Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Built 1975 · Wurtsboro Flight Service IncN17885Schweizer SGS 2-33A · S/N 255Cancelled Nov 19, 2009 · Registration pending · Built 1972N17875Schweizer SGS 2-33A · S/N 245Cancelled May 26, 2004 · Exported to Canada · Built 1972 · Wurtsboro Flight Service IncN17895Schweizer SGS 2-33A · S/N 275Cancelled Mar 25, 2004 · Exported to Canada · Built 1973 · Wurtsboro Flight Service IncN3620DSchweizer SGS 1-36 · S/N 20Cancelled Dec 28, 1992 · Triennial form not returned · Wurtsboro Flight Svc IncN7536Schweizer SGS 2-33A · S/N 166Cancelled May 21, 1973 · Exported to Canada · Barone AnthonyN7702SSchweizer SGS 2-33A · S/N 122Cancelled Jun 23, 1972 · Exported to Canada · Built 1968 · Barone Anthony GN7553Schweizer SGS 2-33A · S/N 183Cancelled May 2, 1972 · Barone Anthony GN5773SSchweizer SGS 2-33A · S/N 107Cancelled Jul 16, 1971 · Exported to Canada · Barone Anthony GN2754ZSchweizer SGU 2-22E · S/N 209Cancelled Jan 19, 1971 · Exported to Canada · Built 1965 · Barone Anthony GN85525Aeronca 7AC · S/N 7AC-4265Cancelled Dec 24, 1970 · Barone Anthony GN6574DSchleicher KA 6 CR · S/N 674Cancelled Aug 18, 1970 · Built 1959 · Klesper Fred W SrN61264Cessna T-50 · S/N 4287Cancelled Oct 12, 1955 · Barone Anthony GN33750Aeronca 65-CA · S/N CA13141Cancelled Apr 17, 1951 · North American Flying Service IncN4937Ryan B1 · S/N 91Cancelled Aug 1, 1934 · Orange Co Airways Inc
Back to Wurtsboro, NY