OpenAirDocs.org
Amityville, NY

Cancelled registrations · 34

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 = 'AMITYVILLE'
  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.

N271WDCessna P210N · S/N P21000428Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1979 · Windmiller DavidN990VPiper PA-23 · S/N 23-561Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1956 · Reservation Leasing LtdN5965XBrantly B-2 · S/N 107Cancelled Mar 26, 2013 · Revoked, canceled · Built 1961 · Eastern States Helicopters IncN711GAGrumman American Avn. GA-7 · S/N GA7-0011Cancelled Oct 3, 2000 · Triennial form not returned · Hutchinson Kenneth LN5076DCessna 182A · S/N 51176Cancelled May 5, 2000 · Exported to Mexico · Reinhard CarlN6584PPiper PA-24 · S/N 24-1705Cancelled Aug 19, 1983 · Warm William FN8076NPiper PA-28-140 · S/N 28-25327Cancelled Apr 24, 1974 · Amityville Flying Service IncN6253GCessna 150K · S/N 15071753Cancelled Jun 27, 1973 · Sig Uyldert Flying School IncN1507NPiper J3C-65 · S/N 23037Cancelled Jun 5, 1973 · Amityville Flying Service IncN3283NPiper J-3 · S/N 22483Cancelled Apr 25, 1972 · Amityville Flying Service IncN6689JPiper PA-28-140 · S/N 28-24379Cancelled Feb 28, 1972 · Amityville Flying Service IncN68937Piper J3C-65 · S/N 13709Cancelled Feb 28, 1972 · Built 1949 · Amityville Flying Service IncN7325HPiper J3C-65 · S/N 20584Cancelled Feb 23, 1972 · Amityville Flying Service IncN92239Piper J3C-65 · S/N 16684Cancelled Feb 23, 1972 · Amityville Flying Service IncN79319Cessna 172K · S/N 17258044Cancelled May 24, 1971 · Built 1969 · Hil-Ren Aviaation CorpN8951SCessna 150F · S/N 15062251Cancelled Feb 17, 1971 · Sig Uyldert Flying School IncN46138Aeronca 0-58B · S/N 058B-13143Cancelled Dec 31, 1970 · Built 1944 · Callejo JosephN4150HPiper PA-15 · S/N 15-35Cancelled Oct 6, 1970 · Downey CharlesN6744JPiper PA-28-140 · S/N 28-24461Cancelled Sep 10, 1970 · Built 1968 · Amityville Flying Service IncN4502RPiper PA-28-140 · S/N 28-21201Cancelled Aug 4, 1970 · Amityville Flying Service IncN42579Piper J3C-65 · S/N 14860Cancelled May 20, 1965 · Amityville Flying Service IncN2184MPiper J-3 · S/N 20973Cancelled May 19, 1965 · Amityville Flying Service IncN51816Fairchild M-62A · S/N T42-1704Cancelled Apr 11, 1962 · Lyons RobertN182TPiper PA-18-105 SPECIAL · S/N 18-2296Cancelled Dec 12, 1957 · Exported to Argentina · Built 1953 · Amityville Flying Service IncN41825Consolidated Vultee BT-13B (SNV-2) · S/N 79-1277Cancelled Mar 5, 1956 · Wendell RobertN2190MPiper J3C-65 · S/N 20979Cancelled Oct 4, 1955 · Built 1946 · Zahn-Hoffmann-Looner IncN88079Piper J3C-65 · S/N 15695Cancelled Jul 25, 1955 · Exported to Venezuela · Murphy Thomas MN3619NPiper J3C-65 · S/N 22871Cancelled Dec 4, 1952 · Zahn Hoffman Looney IncN36952Cessna T-50 · S/N 2630Cancelled Aug 21, 1952 · Zahn Hoffmann Looney IncN71359Luscombe 8A · S/N 2786Cancelled Jan 16, 1952 · Zahn-Hoffmann-Looney IncN51752Fairchild M-62A · S/N T41-1036Cancelled Feb 15, 1949 · Built 1941 · Hoffmann Walter HN33545Piper J3C-65 · S/N 13983Cancelled Mar 28, 1947 · Tyler Flight Service CorpN715Waco 9 · S/N 214Cancelled Jan 8, 1929 · Built 1926 · Lee John GN5268LPiper PA-28-180 · S/N 28-4566Cancellation date not recorded · Amityville Flying Service Inc
Back to Amityville, NY