OpenAirDocs.org
Paramus, NJ

Cancelled registrations · 31

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

N704HQCessna 150M · S/N 15078627Cancelled Dec 9, 2025 · Exported to Mexico · Built 1976 · Okechukwu Christopher ON1486Saland Heywood ONEX · S/N ONX0082Cancelled Apr 19, 2017 · Sale reportedN220FBeech C90 · S/N LJ-981Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1981 · Jen Rob Aviation IncN69YCKirby BREEZY RLU-1 · S/N JCK-1Cancelled Dec 22, 2014 · Revoked, canceled · Built 1970 · Eyer Pamela RN6117RCessna 172RG · S/N 172RG0087Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1979 · Genesus One IncN5154CBeech B35 · S/N D-2439Cancelled Mar 25, 2013 · Registration expired, pending cancellation · Built 1950 · Nilsen JackN24956Cessna 152 · S/N 15280471Cancelled Oct 18, 2012 · Registration expired, pending cancellation · Built 1977 · Lurie Aircraft Leasing IncN45424Luscombe 8C · S/N 1951Cancelled Jul 19, 2012 · Revoked, canceled · Built 1945 · Macmillan David GN885KKCessna T182T · S/N T18208085Cancelled Mar 21, 2011 · Exported to Brazil · Built 2001 · R & J Flying Eagles IncN98786Cessna 172P · S/N 17276353Cancelled Feb 28, 2011 · Exported to South Africa · Built 1985 · Genesus One IncN778LPCessna 172S · S/N 172S8778Cancelled Oct 18, 2007 · Triennial form not returned · Built 2001 · R J Ventures LLCN6257RCessna 172RG · S/N 172RG0126Cancelled Feb 23, 2006 · Triennial form not returned · Built 1979 · Genesus One IncN6408HCessna 152 · S/N 15284164Cancelled Oct 18, 2004 · Exported to South Africa · Built 1979 · Lurie Aircraft Leasing IncN69095Cessna 152 · S/N 15282480Cancelled Aug 17, 2004 · Exported to South Africa · Built 1978 · Lurie Aircraft Leasing IncN93327Cessna 152 · S/N 15285468Cancelled Aug 17, 2004 · Exported to South Africa · Built 1981 · Lurie Aircraft Leasing IncN2635ZBell 206B · S/N 852Cancelled Jul 30, 2003 · Triennial form not returned · Built 1972 · Finova Capital CorpN42AHBell 206B · S/N 2935Cancelled Jul 30, 2003 · Triennial form not returned · Built 1980 · Finova Capital CorpN24707Cessna 152 · S/N 15280331Cancelled Mar 21, 2000 · Exported to United Kingdom · Lurie Aircraft Leasing IncN303MACessna 152 · S/N 15279563Cancelled Mar 21, 2000 · Exported to United Kingdom · Lurie Aircraft Leasing IncN49480Cessna 152 · S/N 15281300Cancelled Mar 21, 2000 · Exported to United Kingdom · Lurie Aircraft Leasing IncN901FJDassault-Breguet MYSTERE FALCON 900 · S/N 147Cancelled May 2, 1996 · Exported to Austria · Dassault Falcon Jet CorpN246FJDassault MYSTERE-FALCON 50 · S/N 246Cancelled Dec 6, 1995 · Exported to Turkey · Dassault Falcon Jet CorpN141FJDassault-Breguet MYSTERE FALCON 900 · S/N 141Cancelled Nov 29, 1994 · Exported to Mexico · Falcon Jet CorporationN253MCDornier DORNIER 228-202 · S/N 8071Cancelled Apr 8, 1993 · Exported to Canada · Bell Atlantic Tricon Leasing CorpN254MCDornier DO-228-201 · S/N 8087Cancelled Jul 13, 1992 · Exported to Jamaica · Bell Atlantic Tricon Leasing CorpN474FJDassault MYSTERE FALCON 900 · S/N 114Cancelled Apr 14, 1992 · Exported to Mexico · Falcon Jet CorpN2812PPiper PA-22-150 · S/N 22-3105Cancelled Mar 4, 1977 · Exported to Canada · Macmillan David GN164AXBell 206B · S/N 740Cancelled Nov 14, 1974 · Exported to Brazil · Alexander'S IncN4285JPiper PA-28-140 · S/N 28-22646Cancelled Mar 20, 1972 · Spartan Flying Club IncN3897EAeronca S11AC · S/N 11AC-S-87Cancelled May 18, 1971 · Exported to Canada · David G Mac MillanN3150CCessna 180 · S/N 30949Cancelled Jun 21, 1957 · Exported to New Zealand · Industrial Design & Service Co
Back to Paramus, NJ