# Earlier aircraft under this name: Lambert Leasing Inc

A list on [Lambert Leasing Inc](https://openairdocs.org/faa-owner/LAMBERT%20LEASING%20INC.md).

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

- [N107XJ](https://openairdocs.org/deregistered/N107XJ-2018-01-09.md): Saab-Fairchild 340A · S/N 340A-107 · Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Sterling, VA
- [N251CJ](https://openairdocs.org/deregistered/N251CJ-2015-04-28.md): Saab 340B · S/N 340B-251 · Cancelled Apr 28, 2015 · Built 1991 · Sterling, VA
- [N429XJ](https://openairdocs.org/deregistered/N429XJ-2014-09-25.md): Saab-Scania SAAB 340B · S/N 340B-429 · Cancelled Sep 25, 2014 · Exported to United Arab Emirates · Built 1997 · Sterling, VA
- [N456XJ](https://openairdocs.org/deregistered/N456XJ-2014-01-30.md): Saab SAAB 340B · S/N 340B-456 · Cancelled Jan 30, 2014 · Exported to Sweden · Built 1998 · Sterling, VA
- [N255AJ](https://openairdocs.org/deregistered/N255AJ-2011-11-02.md): Saab SAAB 340B · S/N 340B-255 · Cancelled Nov 2, 2011 · Exported to Thailand · Built 1991 · Sterling, VA
- [N35SZ](https://openairdocs.org/deregistered/N35SZ-2010-05-28.md): Saab-Scania SF340A · S/N 340A-035 · Cancelled May 28, 2010 · Triennial form not returned · Built 1985 · Sterling, VA
- [N99VC](https://openairdocs.org/deregistered/N99VC-2009-12-07.md): Saab-Scania SF-340-A · S/N 340A-099 · Cancelled Dec 7, 2009 · Exported to Bahamas · Sterling, VA
- [N217JJ](https://openairdocs.org/deregistered/N217JJ-2009-05-01.md): Saab SAAB 340B · S/N 340B-217 · Cancelled May 1, 2009 · Exported to Argentina · Sterling, VA
- [N288JJ](https://openairdocs.org/deregistered/N288JJ-2009-04-24.md): Saab SAAB 340B · S/N 340B-288 · Cancelled Apr 24, 2009 · Exported to Argentina · Sterling, VA
- [N121CQ](https://openairdocs.org/deregistered/N121CQ-2009-03-23.md): Saab-Scania SF340A · S/N 340A-121 · Cancelled Mar 23, 2009 · Exported to Bahamas · Built 1988 · Sterling, VA
- [N285DC](https://openairdocs.org/deregistered/N285DC-2008-10-03.md): Saab SAAB 340B · S/N 226 · Cancelled Oct 3, 2008 · Exported to Argentina · Sterling, VA
- [N284DC](https://openairdocs.org/deregistered/N284DC-2008-09-04.md): Saab SAAB 340B · S/N 340B-270 · Cancelled Sep 4, 2008 · Exported to Argentina · Sterling, VA
- [N98XJ](https://openairdocs.org/deregistered/N98XJ-2008-01-04.md): Saab-Fairchild 340A · S/N 340A-098 · Cancelled Jan 4, 2008 · Exported to Bahamas · Built 1987 · Sterling, VA
- [N43SZ](https://openairdocs.org/deregistered/N43SZ-2006-11-17.md): Saab-Fairchild 340A · S/N 340A-043 · Cancelled Nov 17, 2006 · Exported to Canada · Built 1985 · Sterling, VA
- [N340SZ](https://openairdocs.org/deregistered/N340SZ-2006-04-03.md): Saab-Fairchild 340A · S/N 340A-004 · Cancelled Apr 3, 2006 · Exported to Canada · Built 1984 · Sterling, VA
- [N360SZ](https://openairdocs.org/deregistered/N360SZ-2006-03-16.md): Saab-Fairchild 340A · S/N 340A-006 · Cancelled Mar 16, 2006 · Exported to Canada · Built 1984 · Sterling, VA
- [N103VN](https://openairdocs.org/deregistered/N103VN-2006-02-23.md): Saab-Fairchild 340A · S/N 340A-103 · Cancelled Feb 23, 2006 · Triennial form not returned · Sterling, VA
- [N107EA](https://openairdocs.org/deregistered/N107EA-2006-02-17.md): Saab-Fairchild 340A · S/N 094 · Cancelled Feb 17, 2006 · Exported to Canada · Sterling, VA
- [N363JJ](https://openairdocs.org/deregistered/N363JJ-2006-01-04.md): Saab 340B · S/N 340B-363 · Cancelled Jan 4, 2006 · Exported to Sweden · Sterling, VA
- [N13UV](https://openairdocs.org/deregistered/N13UV-2005-12-22.md): Saab-Scania SF340A · S/N 340 A-013 · Cancelled Dec 22, 2005 · Exported to Kuwait · Built 1984 · Sterling, VA
- [N818GL](https://openairdocs.org/deregistered/N818GL-2003-06-27.md): Fairchild SA227-DC (C26B) · S/N DC-818B · Cancelled Jun 27, 2003 · Exported to Australia · Sterling, VA
- [N823MM](https://openairdocs.org/deregistered/N823MM-2002-10-22.md): Fairchild SA227-DC · S/N DC-823B · Cancelled Oct 22, 2002 · Exported to Australia · Sterling, VA
- [N822MM](https://openairdocs.org/deregistered/N822MM-2002-07-24.md): Fairchild SA227-DC · S/N DC-822B · Cancelled Jul 24, 2002 · Exported to Australia · Sterling, VA
- [N808SK](https://openairdocs.org/deregistered/N808SK-2002-06-06.md): Fairchild SA227-DC (C26B) · S/N DC808B · Cancelled Jun 6, 2002 · Exported to Australia · Sterling, VA
- [N75UW](https://openairdocs.org/deregistered/N75UW-2001-03-28.md): Saab-Fairchild 340A · S/N 340A-075 · Cancelled Mar 28, 2001 · Exported to Canada · Sterling, VA
- [N257PX](https://openairdocs.org/deregistered/N257PX-1996-06-19.md): Saab SAAB 340B · S/N 340B-257 · Cancelled Jun 19, 1996 · Exported to Australia · Built 1991 · Sterling, VA

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

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