# Registered aircraft: San Juan Aviation LLC

A list on [San Juan Aviation LLC](https://openairdocs.org/faa-owner/SAN%20JUAN%20AVIATION%20LLC.md).

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

- [N1075W](https://openairdocs.org/aircraft/N1075W.md): Bell Helicopter Textron 206L-1 · S/N 45377 · Built 1980 · Wilmington, DE
- [N176ET](https://openairdocs.org/aircraft/N176ET.md): Sikorsky S-76 · S/N 760095 · Built 1980 · Wilmington, DE
- [N17LA](https://openairdocs.org/aircraft/N17LA.md): Bell 412 · S/N 36044 · Built 1992 · Wilmington, DE
- [N196SJ](https://openairdocs.org/aircraft/N196SJ.md): Bell 206B · S/N 3198 · Wilmington, DE
- [N204AV](https://openairdocs.org/aircraft/N204AV.md): Bell 206A · S/N 158 · Built 1969 · Wilmington, DE
- [N207SJ](https://openairdocs.org/aircraft/N207SJ.md): Bell 407 · S/N 53721 · Wilmington, DE
- [N208SJ](https://openairdocs.org/aircraft/N208SJ.md): Aerospatiale SA315B ALOUETTE III · S/N 225245 · Wilmington, DE
- [N210SJ](https://openairdocs.org/aircraft/N210SJ.md): Aerospatiale SA315B · S/N 2426 · Wilmington, DE
- [N218SJ](https://openairdocs.org/aircraft/N218SJ.md): Aerospatiale SA315B ALOUETTE III · S/N 2272/29 · Wilmington, DE
- [N220SJ](https://openairdocs.org/aircraft/N220SJ.md): Aerospatiale SA315B · S/N 2657 · Wilmington, DE
- [N256SJ](https://openairdocs.org/aircraft/N256SJ.md): Cessna R172K · S/N R1723166 · Built 1979 · Wilmington, DE
- [N277RL](https://openairdocs.org/aircraft/N277RL.md): Bell 206B · S/N 3277 · Built 1981 · Wilmington, DE
- [N316SP](https://openairdocs.org/aircraft/N316SP.md): Bell Helicopter Textron 206L-1 · S/N 45768 · Built 1983 · Wilmington, DE
- [N3538T](https://openairdocs.org/aircraft/N3538T.md): Messerschmitt-Boelkow-Blohm BO-105S · S/N S-350 · Registration expired, pending cancellation · Built 1977 · Wilmington, DE
- [N385RL](https://openairdocs.org/aircraft/N385RL.md): Bell Helicopter Textron Canada 206L-4 · S/N 52385 · Built 2008 · Wilmington, DE
- [N407SJ](https://openairdocs.org/aircraft/N407SJ.md): Bell 407 · S/N 53608 · Built 2004 · Wilmington, DE
- [N430CF](https://openairdocs.org/aircraft/N430CF.md): Bell 430 · S/N 49118 · Built 2006 · Wilmington, DE
- [N430CG](https://openairdocs.org/aircraft/N430CG.md): Bell 430 · S/N 49062 · Wilmington, DE
- [N430CM](https://openairdocs.org/aircraft/N430CM.md): Bell 430 · S/N 49090 · Wilmington, DE
- [N512SC](https://openairdocs.org/aircraft/N512SC.md): Bell 206B · S/N 3967 · Built 1987 · Wilmington, DE
- [N58003](https://openairdocs.org/aircraft/N58003.md): Bell 206B · S/N 1020 · Built 1983 · Wilmington, DE
- [N58140](https://openairdocs.org/aircraft/N58140.md): Bell 206B · S/N 1108 · Built 1973 · Wilmington, DE
- [N67SJ](https://openairdocs.org/aircraft/N67SJ.md): Bell 206L-3 · S/N 51098 · Wilmington, DE
- [N7963J](https://openairdocs.org/aircraft/N7963J.md): Bell 206A · S/N 685 · Built 1971 · Wilmington, DE
- [N9190Y](https://openairdocs.org/aircraft/N9190Y.md): Messerschmitt BO 105CB · S/N S-669 · First renewal notice · Built 1987 · Wilmington, DE

## The whole list in SQL

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

```sql
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_name = 'SAN JUAN AVIATION LLC' OR list_contains(g.other_registrant_names, 'SAN JUAN AVIATION LLC')
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-owner/SAN%20JUAN%20AVIATION%20LLC/aircraft

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
