# Earlier aircraft under this name: Joda Partnership

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

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

- [N1037D](https://openairdocs.org/deregistered/N1037D-1999-07-27.md): Cessna 208B · S/N 208B0332 · Cancelled Jul 27, 1999 · Triennial form not returned · Town & Country, MO
- [N77PA](https://openairdocs.org/deregistered/N77PA-1999-07-07.md): Beech F90 · S/N LA-89 · Cancelled Jul 7, 1999 · Exported to Argentina · Town & Country, MO
- [N16GA](https://openairdocs.org/deregistered/N16GA-1999-04-21.md): Beechcraft-Hawker BH-125-600A · S/N 256018 · Cancelled Apr 21, 1999 · Exported to Mexico · Town And Country, MO
- [N645JD](https://openairdocs.org/deregistered/N645JD-1999-03-01.md): British Aerospace JETSTREAM 3108 · S/N 645 · Cancelled Mar 1, 1999 · Exported to Sweden · Town And Country, MO
- [N5105N](https://openairdocs.org/deregistered/N5105N-1998-11-24.md): Hughes Helicopters HUGHES 369D · S/N 911055D · Cancelled Nov 24, 1998 · Town & Country, MO
- [N867MA](https://openairdocs.org/deregistered/N867MA-1998-09-01.md): Swearingen SA226TC · S/N TC393 · Cancelled Sep 1, 1998 · Exported to Argentina · Chesterfield, MO
- [N26LE](https://openairdocs.org/deregistered/N26LE-1998-07-15.md): Beech 200 · S/N BB214 · Cancelled Jul 15, 1998 · Exported to Peru · Town & Country, MO
- [N863MA](https://openairdocs.org/deregistered/N863MA-1998-04-22.md): Fokker F.27-200 · S/N 10181 · Cancelled Apr 22, 1998 · Exported to Peru · Chesterfield, MO
- [N193CJ](https://openairdocs.org/deregistered/N193CJ-1998-01-27.md): Cessna 525 · S/N 5250193 · Cancelled Jan 27, 1998 · Exported to Germany · Chesterfield, MO
- [N27KG](https://openairdocs.org/deregistered/N27KG-1997-08-21.md): Gates Learjet 25D · S/N 357 · Cancelled Aug 21, 1997 · Exported to Argentina · Town & Country, MO
- [N7205L](https://openairdocs.org/deregistered/N7205L-1997-08-07.md): Swearingen SA226TC · S/N TC419 · Cancelled Aug 7, 1997 · Exported to Argentina · Town & Country, MO
- [N839MA](https://openairdocs.org/deregistered/N839MA-1997-05-02.md): Cessna 208 · S/N 2080198 · Cancelled May 2, 1997 · Town And Country, MO
- [N3114H](https://openairdocs.org/deregistered/N3114H-1997-02-18.md): Fairchild SA227-AC · S/N AC584 · Cancelled Feb 18, 1997 · Exported to Argentina · Chesterfield, MO
- [N55AK](https://openairdocs.org/deregistered/N55AK-1996-11-19.md): S N I A S AS350D ASTAR · S/N 1164 · Cancelled Nov 19, 1996 · Exported to Canada · Town And Country, MO
- [N502MH](https://openairdocs.org/deregistered/N502MH-1996-06-19.md): Gates Lear Jet 25C · S/N 25C098 · Cancelled Jun 19, 1996 · Exported to South Africa · Town & Country, MO
- [N1289N](https://openairdocs.org/deregistered/N1289N-1996-04-15.md): Cessna 208 · S/N 20800240 · Cancelled Apr 15, 1996 · Exported to New Zealand · St Louis, MO
- [N77LB](https://openairdocs.org/deregistered/N77LB-1995-05-17.md): Learjet 24 · S/N 135 · Cancelled May 17, 1995 · Exported to Argentina · St Louis, MO
- [N9045P](https://openairdocs.org/deregistered/N9045P-1994-02-17.md): Douglas C-118A · S/N 44644 · Cancelled Feb 17, 1994 · Exported to Mexico · Chesterfield, MO
- [N602MM](https://openairdocs.org/deregistered/N602MM-1993-11-02.md): Beechcraft-Hawker BH-125-600A · S/N 256002 · Cancelled Nov 2, 1993 · Exported to Mexico · Chesterfield, MO
- [N777AN](https://openairdocs.org/deregistered/N777AN-1993-10-14.md): Cessna 500 · S/N 5000027 · Cancelled Oct 14, 1993 · Exported to Brazil · Chesterfield, MO
- [N374R](https://openairdocs.org/deregistered/N374R-1992-07-21.md): Cessna 402C · S/N 402C0420 · Cancelled Jul 21, 1992 · Exported to Colombia · Highland Park, IL
- [N775GP](https://openairdocs.org/deregistered/N775GP-1992-03-17.md): Cessna 404 · S/N 4040607 · Cancelled Mar 17, 1992 · Exported to Colombia · Highland Park, IL
- [N372R](https://openairdocs.org/deregistered/N372R-1992-03-09.md): Cessna 402C · S/N 402C0403 · Cancelled Mar 9, 1992 · Exported to Mexico · Highland Park, IL
- [N6785Z](https://openairdocs.org/deregistered/N6785Z-1991-12-24.md): Cessna 402C · S/N 402C0409 · Cancelled Dec 24, 1991 · Exported to Germany · Naples, FL
- [N45US](https://openairdocs.org/deregistered/N45US-1991-12-06.md): Beech C90 · S/N LJ1004 · Cancelled Dec 6, 1991 · Exported to Brazil · Highland Park, 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 = 'JODA PARTNERSHIP' OR list_contains(d.other_registrant_names, 'JODA PARTNERSHIP')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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