OpenAirDocs.org
Long Island, NY

Cancelled registrations · 71

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 = 'LONG ISLAND'
  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.

N8962RAeronca 7FC · S/N 7FC390Cancelled Feb 2, 2017 · Revoked, pending cancellation · Built 1960 · Deer Park Avn Cntr IncN2106UBrantly B-2 · S/N 152Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1961 · Zissis GeorgeN8PAAdikes SCORPION TOO · S/N 3289Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1975N92972Commonwealth 185 · S/N 1705Cancelled Nov 19, 2012 · Sale reported, pending cancellation · Built 1946N722BHBeech A36 · S/N E444Cancelled Jun 25, 1991 · Triennial form not returned · Fairview FlyersN6461KRepublic RC-3 · S/N 712Cancelled Feb 13, 1981 · Hausman LeoN8620HNorth American NAVION · S/N NAV-4-585Cancelled Oct 18, 1973 · Nicholas G BarryN46851Fairchild M-62A · S/N T43-7004Cancelled Jul 2, 1970 · Frogs Flying Field IncN69220Consolidated Vultee BT-15 · S/N 9511Cancelled Jul 2, 1970 · Frogs Flying Field IncN1447LBeech A23 · S/N M-788Cancelled Jun 5, 1970 · Exported to Sweden · Built 1965 · Berkoski Robert SN6828XCessna 172A · S/N 47728Cancelled Dec 15, 1967 · Bridge Plaza Rental CorpN674UGrumman American Avn. G-164A · S/N 413Cancelled Jun 8, 1966 · Exported to Canada · Grumman Aircraft Engineering CorpN1448LBeech A23 · S/N M-789Cancelled Nov 5, 1965 · Exported to Sweden · Berkoski Robert SN3303PPiper PA-23-160 · S/N 23-1253Cancelled May 21, 1965 · Mattituck Aviation CorpN85048Aeronca 7AC · S/N 7AC-3775Cancelled May 26, 1964 · Edwards Flying Service IncN228NPiper J3C-65S · S/N 12894Cancelled May 14, 1964 · Long Island Group New York Wing Civil Air PatrolN2330DCessna 170B · S/N 20482Cancelled May 17, 1958 · Exported to Germany · Gryl Frank JN77843Luscombe 8A · S/N 3570Cancelled Mar 10, 1958 · Built 1946 · Altman PaulN1112PPiper PA-23 · S/N 23-122Cancelled May 11, 1956 · Exported to Venezuela · Teeny'S Construction CorporationN42813Piper J3C-65 · S/N 15131Cancelled Mar 5, 1956 · Riverhead Airpark Co IncN95452Grumman J2F3 · S/N 511Cancelled Feb 27, 1956 · Pess AirN4620EAeronca 7DC · S/N 7DC-159Cancelled Jan 31, 1956 · East Hampton AirportN51727Ryan Aeronautical ST3KR · S/N 2060Cancelled Jan 24, 1956 · Vincent MarroneN33795Aeronca 65-TL · S/N L9471Cancelled Oct 24, 1955 · Burr Raymond And Burr JosephN2030KLuscombe 8E · S/N 4757Cancelled Oct 4, 1955 · Gooch Harold C Combs W HerbertN4799MPiper PA-11 · S/N 11-313Cancelled Oct 8, 1953 · Built 1947 · Edgemere Aviation CorpN4074HPiper PA-12 · S/N 12-3501Cancelled Mar 17, 1953 · Englert Frank JN4078HPiper PA-12 · S/N 12-3504Cancelled Dec 28, 1951 · Englert Frank JN1431VCurtiss Wright C-46A · S/N 446Cancelled Jul 27, 1951 · Exported to Brazil · Sun Chemical CorpN4039KNorth American NAVION · S/N NAV-4-1039Cancelled Sep 9, 1949 · Deans F BN49567Piper J3C-65 · S/N 10318Cancelled Nov 9, 1948 · Charlotte NilesN33455Piper J3C-65S · S/N 5983Cancelled Sep 19, 1948 · Suburban Air Service IncN34714Porterfield CP-65 · S/N 880Cancelled Aug 17, 1948 · Mcnary Aircraft CorpN13895Waco UKC · S/N 3838Cancelled Jul 26, 1948 · Blumenthal BelleN14544Aeronca C-3 · S/N A-438Cancelled Apr 9, 1948 · Ward Walter RN901VCurtiss H.S.L. 2 · S/N 266Cancelled Feb 26, 1948 · Built 1921 · Homer Wilson & Clifford AllegN6991HPiper J3C-65 · S/N 20236Cancelled Dec 3, 1947 · Built 1946 · Mid-Island Air ServiceN20824Piper J-3 · S/N 2124Cancelled Nov 12, 1947 · Edwards George WN39174North American SNJ-3 · S/N 77-4283Cancelled Apr 8, 1947 · Built 1946 · Robinson Robert HN6831Curtiss Robin 3PCLM · S/N G-3Cancelled Apr 8, 1947 · Frog'S Flying Field IncN87451Republic RC-3 · S/N 1Cancelled Aug 7, 1946 · Built 1945 · Republic Aviation CorpN16014Douglas DC3-G102 · S/N 1552Cancelled Sep 2, 1943 · American Airlines IncN297HCurtiss Wright FLEDGLING · S/N B-61Cancelled Aug 27, 1943 · Safair IncN29021General G1-80 · S/N 8Cancelled Aug 7, 1943 · General Aircraft CorpN796MCurtiss Wright ROBIN J-1 · S/N 703Cancelled Feb 2, 1942 · Rockaway Airport IncN290HCurtiss Wright FLEDGLING · S/N B-55Cancelled Aug 15, 1941 · Hebert Oscar P C/O Safair IncN8012American Airplane & Engine PILGRIM FC-2 · S/N 163Cancelled Mar 1, 1941 · Roosevelt Field IncN25196Brewster FLEET 2 · S/N 38Cancelled Apr 4, 1940 · Exported to Finland · Built 1940 · Brewster Aeronautical CorpN2434Piper E-2 · S/N 65Cancelled Mar 1, 1940 · Denny Daitz Flying CorpN10834Stinson JR. S · S/N 8028Cancelled May 17, 1939 · Denny Daitz Flying Corp
Back to Long Island, NY