Jersey City, NJ

Cancelled registrations · 42

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 = 'NJ' AND d.registrant_city = 'JERSEY CITY'
  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.

N650WKLockheed 18-56 · S/N 2339Cancelled Apr 16, 2021 · Revoked, canceled · Built 1942 · Sandalwood CorpN2652APiper PA-22-135 · S/N 22-921Cancelled Feb 12, 2020 · Revoked, pending cancellation · Built 1952 · Latzko George JN226PSSukhoi SU-26 · S/N 06-10Cancelled Mar 11, 2019 · Exported to Russia · Built 1993 · Barsukov KirillN33730Aeronca 65-TL · S/N L9321TCancelled Jan 15, 2019 · Revoked, canceled · Built 1941 · Hagevik Donald MN23116Cessna 150H · S/N 15068735Cancelled Jul 21, 2017 · Registration expired, pending cancellation · Built 1968 · Cabrera Carlos DBAN46559Cessna 172K · S/N 17257350Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1968 · Carlos Cabrera DBAN53BABrennan Joseph P STARDUSTER SA300 · S/N 101ACancelled Sep 13, 2013 · Registration expired, pending cancellation · Brennan Joseph PN366YStits Flut-R-Bug SA6B · S/N P-2066Cancelled Sep 12, 2012 · Revoked, canceled · Built 1964 · Hagevik Donald MN521BCYakovlev YAK-55M · S/N 961007Cancelled Oct 6, 2011 · Built 1996 · Barsukov KirillN38758Piper PA-28-181 · S/N 287790583Cancelled Jan 5, 1998 · Triennial form not returned · Freedom Air IncN7063WPiper PA-28-180 · S/N 28835Cancelled Apr 1, 1994 · Triennial form not returned · Freedom Air IncN2409LCessna 172N · S/N 17255609Cancelled Apr 29, 1983 · Built 1966 · Schlager John JN8119ZCessna 210-5 · S/N 205-0119Cancelled Sep 12, 1980 · Exported to Costa Rica · Aviles Flor De MariaN10165Briegleb Glider BG-12A · S/N 12008Cancelled Aug 18, 1971 · Popp FrancisN60998Pratt Read PR-G1 · S/N PRG-01-28Cancelled Mar 22, 1966 · Sail Flights IncN4081CMachtinger Michael A QD CTY ULT CHLNGR II · S/N 1Cancelled Sep 3, 1965 · Built 1963 · Dodd Thomas Nelson JrN3029VBeech 35 · S/N D-433Cancelled Oct 11, 1957 · Exported to Switzerland · Built 1947 · Ricksen Robert EN1556VDouglas C-54 · S/N 10380Cancelled May 9, 1957 · Exported to France · Air World Leases IncN46154Aeronca 0-58B · S/N 058B-1092Cancelled Oct 10, 1955 · Dowick StanleyN6219KRepublic RC-3 · S/N 422Cancelled Apr 15, 1952 · Greene Elliot HN1698KLuscombe 8A · S/N 4425Cancelled Apr 5, 1951 · Napolean HarryN70298Piper J-3 · S/N 17461Cancelled Apr 28, 1949 · Jersey Skyports IncN29274Culver LCA · S/N 143Cancelled Aug 9, 1948 · Built 1940 · Richier Robert YarnallN83NAlliance ARGO · S/N 120Cancelled Jun 9, 1948 · Alexander Stanley C/Hula Joseph/Orlowski Alex/DonoN14241Northrop DELTA 1D · S/N 38Cancelled Aug 3, 1937 · Vimalert Co Ltd IncN14266Northrop DELTA 1D · S/N 41Cancelled Jul 28, 1937 · Built 1934 · Vimalert Co LtdN14251Vultee V-1A · S/N 15Cancelled Jul 21, 1937 · Built 1935 · Vimalert Company LtdN14255Vultee V-1A · S/N 21Cancelled Jul 15, 1937 · Built 1935 · Vimalert Company LtdN17325Vultee V-1A · S/N 24Cancelled Feb 24, 1937 · The Vimalert Co LtdN318NAeromarine-Klemm L-26-A · S/N 2-57Cancelled Nov 20, 1936 · Exported to France · Serafin EdmundN9769Crescent A · S/N 1Cancelled Feb 10, 1933 · Crescent Aircraft CorpN816WHeath SUPER PARASOL · S/N TFM-27-SOCancelled Jan 24, 1933 · Marsh Thomas FN7426Lockheed VEGA 1 · S/N 14Cancelled Jan 15, 1933 · Chamberlin Flying Service IncN9092Cessna AW · S/N 152Cancelled Jul 1, 1932 · Schneider Eddie AN8401Ford 4-AT-E · S/N 63Cancelled Jan 15, 1931 · Built 1929 · Intercontinent Aviation IncN523NCurtiss-Robertson THRUSH J · S/N 1002Cancelled Oct 4, 1930 · Exported to Cuba · Intercontinent Aviation IncN5287Travel Air Mfg 2000 · S/N 487Cancelled Sep 24, 1930 · Tonnel Aircraft CorpN738Curtiss Wright JN4D · S/N 214Cancelled May 1, 1930 · Fort AlbertN1069National Airways System AIR KING · S/N 120-ACancelled Mar 7, 1930 · Schneider Fred WN1094American Eagle A-1 · S/N 128-JCancelled Aug 30, 1929 · Jones John MeredithN1387American Eagle A 129 · S/N 45Cancelled May 31, 1929 · Coons Chester AN3705Waco 9 · S/N 319Cancelled Oct 18, 1928 · Trnka Otto A
Back to Jersey City, NJ