OpenAirDocs.org
Morristown, NJ

Cancelled registrations · 80

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

N1383KDJI AGRAS T40 · S/N 1581F574B22BE0010054Cancelled Jul 11, 2026 · Registration pending, canceledN379SPCessna 172S · S/N 172S9509Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 2003 · 150th Aero Flying Club IncN62VVDiamond Aircraft Ind DA 62 · S/N 62.010Cancelled Oct 13, 2022 · Exported to France · Built 2015 · Crimson Aviation LLCN6874SHawker Beechcraft 390 · S/N RB-231Cancelled Aug 1, 2022 · Exported to India · Ta Jets LLCN116MVAgustawestland AW109SP · S/N 22282Cancelled Jan 21, 2020 · Exported to Isle Of Man · Built 2012 · Wing And Rotor Transportation Holdings LLCN222KCessna 310 · S/N 35211Cancelled Sep 27, 2019 · Revoked, canceled · Built 1955 · Syrek JohnN552WFGulfstream Aerospace G-IV · S/N 1000Cancelled Mar 26, 2018 · Registration expired, pending cancellation · Built 1985 · Stockwood IncN347SPCessna 172S · S/N 172S8271Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1999 · Certified Aviation LLCN74985Davidson Ronald J DAV 54 · S/N 001Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Davidson Ronald JN110EBCirrus Design SR22 · S/N 3423Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 2009 · Photopheresis IncN6644DKelley Stanley RV/6A · S/N 60335Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 2001 · Slifkin TimothyN88284Piper J3C-65 · S/N 15902Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Morris Air IncN96894Cessna 182Q · S/N 18266891Cancelled Aug 26, 2015 · Built 1979 · Westbank CorpN158SDSaab-Scania SF340A · S/N 340A-158Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Associated Airline Leasing CorpN75WMCessna 172P · S/N 17274638Cancelled Sep 25, 2013 · Second renewal notice · Built 1981 · Westbank CorporationN15262Piper PA-28-140 · S/N 28-7325028Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1972 · Century Air IncN37ANBell 206B-III · S/N 3503Cancelled Apr 2, 2013 · Sale reported, canceledN5802SBeech 95-B55 (T42A) · S/N TC-820Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1964N492CTPiper PA-34-200T · S/N 347870200Cancelled Nov 18, 2011 · Exported to GuatemalaN8164ECessna 172N · S/N 17272146Cancelled Apr 27, 2010 · Triennial form not returned · Built 1978 · Westbank CorporationN361JMMassengill James B GLASAIRE III · S/N 3164Cancelled Jul 19, 2007 · Exported to Australia · Built 1994 · Massengill James BN7118LBalloon Works FIREFLY 8B · S/N F8B-135Cancelled Feb 13, 2007 · Triennial form not returned · Built 1988 · Davidson Ronald JN888BEurocopter/France AS355N TWINSTAR · S/N 5570Cancelled Aug 28, 1996 · Exported to Portugal · Lynton Group IncN45FBAgusta A109C · S/N 7676Cancelled Jul 2, 1996 · Exported to Spain · Lynton Group IncN9629ZCessna U206G · S/N U20606582Cancelled Jan 18, 1996 · Exported to Bolivia · Conway Granville EN518RAerospatiale AS350B1 ECUREUIL · S/N 1963Cancelled Jul 28, 1995 · Exported to United Kingdom · Lynton Aviation Services IncN5681YMooney M20J · S/N 241399Cancelled Apr 4, 1995 · Roe David HN57745Aerospatiale AS 355F1 · S/N 5011Cancelled Mar 30, 1994 · Exported to United Kingdom · Lynton Group IncN6814GCessna 402C · S/N 402C0647Cancelled May 13, 1993 · Triennial form not returned · Tartan Leasing CorpN44289Piper PA-28-140 · S/N 287425400Cancelled Jan 30, 1992 · Century Air IncN55685Piper PA-28-140 · S/N 287325457Cancelled Jan 30, 1992 · Century Air IncN6891JPiper PA-28-151 · S/N 287615388Cancelled Sep 9, 1991 · Triennial form not returned · Instrument Flying Service IncN200HHAerospatiale AS-355E TWIN STAR · S/N 5070Cancelled Aug 21, 1991 · Exported to France · Lynton Group IncN888MYSikorsky S-76A · S/N 760268Cancelled Jul 12, 1991 · Exported to South Africa · Lynton Group IncN58019S N I A S AS350D ASTAR · S/N 1330Cancelled Mar 29, 1991 · Exported to United Kingdom · Lynton Group IncN4557QGulfstream American AA-5B · S/N AA5B1234Cancelled Mar 25, 1991 · Triennial form not returned · Century Air IncN6507BCessna 152 · S/N 15283941Cancelled Jan 23, 1986 · Certified Aircraft Sale IncN757PNCessna 152 · S/N 15279897Cancelled Aug 17, 1982 · Certifies Aircraft Sales IncN15942Piper PA-28-140 · S/N 28-7325207Cancelled Apr 15, 1982 · Administratively canceled · Instrument Flying Services IncN1972FCessna 172N · S/N 17273060Cancelled May 8, 1980 · Exported to Denmark · Built 1979 · Cessna Aircraft CoN11215Cessna 150L · S/N 15075259Cancelled Sep 18, 1975 · Built 1973 · Catham Aviation IncN8010SCessna 150F · S/N 15061610Cancelled Aug 12, 1974 · Chatham Aviation IncN7296YPiper PA-30 · S/N 30-336Cancelled Aug 8, 1974 · Franklin Sylvan EN5086QCessna 402 · S/N 402B0350Cancelled Apr 1, 1974 · Princeton American LeasecorpN23415Cessna 150H · S/N 15068936Cancelled Sep 27, 1973 · Exported to Canada · Chatman Aviation IncN8227LCessna 172H · S/N 17256427Cancelled Jul 6, 1973 · Exported to Canada · Built 1967 · Chatham AviationN3096LCessna 310J · S/N 310J0096Cancelled Jun 21, 1973 · Chatham Aviation IncN16100Cessna 150L · S/N 15073476Cancelled Jun 12, 1973 · Exported to Canada · Chatham Aviation IncN3421QCessna 320E · S/N 320E-0021Cancelled Jul 7, 1972 · Chatham Aviation IncN9128NAero Commander 500 S · S/N 3093Cancelled Nov 30, 1971 · Morris Air Transport Inc
Back to Morristown, NJ