# Earlier aircraft under this name: Jssi Parts LLC

A list on [Jssi Parts LLC](https://openairdocs.org/faa-owner/JSSI%20PARTS%20LLC.md).

Cancelled registrations that named this owner when they ended, newest first.

- [N613HA](https://openairdocs.org/deregistered/N613HA-2025-04-14.md): Learjet 60 · S/N 191 · Cancelled Apr 14, 2025 · Built 2000 · Chicago, IL
- [N811MB](https://openairdocs.org/deregistered/N811MB-2024-03-21.md): Cessna 680 · S/N 680-0177 · Cancelled Mar 21, 2024 · Built 2007 · Chicago, IL
- [N282DR](https://openairdocs.org/deregistered/N282DR-2024-03-16.md): Cessna 680 · S/N 680-0111 · Cancelled Mar 16, 2024 · Built 2006 · Chicago, IL
- [N88D](https://openairdocs.org/deregistered/N88D-2023-08-20.md): Bombardier BD-700-1A10 · S/N 9310 · Cancelled Aug 20, 2023 · Built 2008 · Chicago, IL
- [N888RU](https://openairdocs.org/deregistered/N888RU-2023-04-12.md): Bombardier BD-700-1A10 · S/N 9071 · Cancelled Apr 12, 2023 · Built 2002 · Chicago, IL
- [N708FL](https://openairdocs.org/deregistered/N708FL-2022-08-16.md): Cessna 750 · S/N 750-0109 · Cancelled Aug 16, 2022 · Built 1999 · Chicago, IL
- [N13JR](https://openairdocs.org/deregistered/N13JR-2022-02-19.md): Bombardier BD-700-1A10 · S/N 9020 · Cancelled Feb 19, 2022 · Built 1999 · Chicago, IL
- [N352RJ](https://openairdocs.org/deregistered/N352RJ-2022-02-19.md): Gates Learjet 35A · S/N 188 · Cancelled Feb 19, 2022 · Third renewal notice · Built 1978 · Chicago, IL
- [N857AA](https://openairdocs.org/deregistered/N857AA-2021-04-19.md): Cessna 550 · S/N 550-0901 · Cancelled Apr 19, 2021 · Built 2000 · Chicago, IL
- [N241TX](https://openairdocs.org/deregistered/N241TX-2021-03-31.md): Learjet 60 · S/N 086 · Cancelled Mar 31, 2021 · Built 1996 · Chicago, IL
- [N271RA](https://openairdocs.org/deregistered/N271RA-2021-03-31.md): Israel Aircraft Industries GULFSTREAM 200 · S/N 104 · Cancelled Mar 31, 2021 · Built 2004 · Chicago, IL
- [N601MU](https://openairdocs.org/deregistered/N601MU-2021-03-31.md): Canadair CL-600-2B16 · S/N 5160 · Cancelled Mar 31, 2021 · First renewal notice · Built 1994 · Chicago, IL
- [N604SL](https://openairdocs.org/deregistered/N604SL-2021-03-31.md): Learjet 60 · S/N 060 · Cancelled Mar 31, 2021 · Built 1995 · Chicago, IL
- [N625LR](https://openairdocs.org/deregistered/N625LR-2020-11-16.md): Canadair CL-600-2B16 · S/N 5075 · Cancelled Nov 16, 2020 · Built 1990 · Chicago, IL
- [N850TR](https://openairdocs.org/deregistered/N850TR-2020-07-17.md): Bombardier BD-700-1A10 · S/N 9027 · Cancelled Jul 17, 2020 · Built 1999 · Chicago, IL
- [N10JP](https://openairdocs.org/deregistered/N10JP-2018-07-06.md): Dassault FALCON 2000 · S/N 23 · Cancelled Jul 6, 2018 · Built 1995 · Chicago, IL

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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_name = 'JSSI PARTS LLC' OR list_contains(d.other_registrant_names, 'JSSI PARTS LLC')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/JSSI%20PARTS%20LLC/earlier

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
