# Earlier aircraft under this name: Joda LLC

A list on [Joda LLC](https://openairdocs.org/faa-owner/JODA%20LLC.md).

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

- [N800MX](https://openairdocs.org/deregistered/N800MX-2018-01-09.md): Beech 1900C · S/N UB48 · Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1985 · Chesterfield, MO
- [N440KM](https://openairdocs.org/deregistered/N440KM-2017-10-05.md): Canadair CL-600-2B16 · S/N 5053 · Cancelled Oct 5, 2017 · Exported to Canada · Built 1989 · Chesterfield, MO
- [N890MA](https://openairdocs.org/deregistered/N890MA-2017-09-27.md): Swearingen SA227-AC · S/N AC485 · Cancelled Sep 27, 2017 · Registration expired, pending cancellation · Built 1982 · Chesterfield, MO
- [N829SE](https://openairdocs.org/deregistered/N829SE-2017-09-26.md): British Aerospace HS 125-700A · S/N NA 0267 · Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Chesterfield, MO
- [N121JE](https://openairdocs.org/deregistered/N121JE-2016-07-29.md): North American NA-265-60 · S/N 306-4 · Cancelled Jul 29, 2016 · Third renewal notice · Built 1967 · Town & Country, MO
- [N31AA](https://openairdocs.org/deregistered/N31AA-2012-09-25.md): Learjet 25 · S/N 041 · Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1969 · Chesterfield, MO
- [N934LK](https://openairdocs.org/deregistered/N934LK-2008-11-05.md): Mcdonnell Douglas DC-9-31 · S/N 48157 · Cancelled Nov 5, 2008 · Exported to Venezuela · Built 1982 · Chesterfield, MO
- [N935DS](https://openairdocs.org/deregistered/N935DS-2008-11-05.md): Mcdonnell Douglas DC-9-31 · S/N 48158 · Cancelled Nov 5, 2008 · Exported to Venezuela · Built 1982 · Chesterfield, MO
- [N30SG](https://openairdocs.org/deregistered/N30SG-2008-07-08.md): Robinson Helicopter R44 · S/N 1723 · Cancelled Jul 8, 2008 · Exported to Netherlands · Built 2007 · Chesterfield, MO
- [N78SG](https://openairdocs.org/deregistered/N78SG-2008-01-03.md): Robinson Helicopter R44 II · S/N 11264 · Cancelled Jan 3, 2008 · Exported to Guatemala · Built 2006 · Chesterfield, MO
- [N925VJ](https://openairdocs.org/deregistered/N925VJ-2006-10-31.md): Mcdonnell Douglas DC-9-31 · S/N 48145 · Cancelled Oct 31, 2006 · Exported to Gambia · Built 1981 · Chesterfield, MO
- [N926VJ](https://openairdocs.org/deregistered/N926VJ-2006-10-31.md): Mcdonnell Douglas DC-9-31 · S/N 48146 · Cancelled Oct 31, 2006 · Exported to Gambia · Built 1981 · Chesterfield, MO
- [N79YV](https://openairdocs.org/deregistered/N79YV-2006-10-05.md): Beech 1900C · S/N UB41 · Cancelled Oct 5, 2006 · Built 1985 · Chesterfield, MO
- [N218LA](https://openairdocs.org/deregistered/N218LA-2006-08-25.md): Aerospatiale AS350B1 ECUREUIL · S/N 2089 · Cancelled Aug 25, 2006 · Exported to Canada · Built 1988 · Chesterfield, MO
- [N160UA](https://openairdocs.org/deregistered/N160UA-2004-03-02.md): Boeing 747-238B · S/N 21237 · Cancelled Mar 2, 2004 · Triennial form undeliverable · Built 1976 · Town & Country, MO
- [N661FA](https://openairdocs.org/deregistered/N661FA-2002-11-13.md): Fairchild SA227-AC · S/N AC-661B · Cancelled Nov 13, 2002 · Exported to Bahamas · Built 1986 · Town & Country, MO
- [N623AC](https://openairdocs.org/deregistered/N623AC-2002-10-30.md): Boeing 737-230 · S/N 23157 · Cancelled Oct 30, 2002 · Exported to Slovak Republic · Built 1985 · Town & Country, MO
- [N78AG](https://openairdocs.org/deregistered/N78AG-2002-07-02.md): Hawker Siddeley DH125-1A/731 · S/N 25101 · Cancelled Jul 2, 2002 · Exported to Mexico · Built 1966 · Chesterfield, MO
- [N621AC](https://openairdocs.org/deregistered/N621AC-2002-05-08.md): Boeing 737-230 · S/N 23156 · Cancelled May 8, 2002 · Exported to Slovak Republic · Built 1985 · Town & Country, MO
- [N16GA](https://openairdocs.org/deregistered/N16GA-2002-03-13.md): Fairchild SA227-AC · S/N AC594 · Cancelled Mar 13, 2002 · Exported to Venezuela · Built 1984 · Town & Country, MO
- [N5339U](https://openairdocs.org/deregistered/N5339U-2002-03-05.md): Piper PA-28-181 · S/N 2843484 · Cancelled Mar 5, 2002 · Exported to United Kingdom · Town & Country, MO
- [N3181B](https://openairdocs.org/deregistered/N3181B-2001-11-30.md): Bell 206B · S/N 3770 · Cancelled Nov 30, 2001 · Exported to New Zealand · Town & Country, MO
- [N3893Y](https://openairdocs.org/deregistered/N3893Y-2001-11-30.md): Bell 206B · S/N 3185 · Cancelled Nov 30, 2001 · Exported to New Zealand · Built 1980 · Town & Country, MO
- [N8061V](https://openairdocs.org/deregistered/N8061V-2001-04-11.md): Bell Helicopter Textron 206L-1 · S/N 45631 · Cancelled Apr 11, 2001 · Town & Country, MO
- [N41848](https://openairdocs.org/deregistered/N41848-2000-10-16.md): Piper PA-28-181 · S/N 2843382 · Cancelled Oct 16, 2000 · Exported to United Kingdom · Town & Country, MO
- [N218CC](https://openairdocs.org/deregistered/N218CC-2000-08-29.md): Cessna 650 · S/N 6500218 · Cancelled Aug 29, 2000 · Exported to Mexico · Town & Country, MO

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

This list as a web page: https://openairdocs.org/faa-owner/JODA%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.