# Registered aircraft: Berry Aviation Inc

A list on [Berry Aviation Inc](https://openairdocs.org/faa-owner/BERRY%20AVIATION%20INC.md).

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

- [N229SW](https://openairdocs.org/aircraft/N229SW.md): Embraer EMB-120ER · S/N 120.305 · Built 1995 · San Marcos, TX
- [N233SW](https://openairdocs.org/aircraft/N233SW.md): Embraer EMB-120ER · S/N 120.307 · Built 1995 · San Marcos, TX
- [N235SW](https://openairdocs.org/aircraft/N235SW.md): Embraer EMB-120ER · S/N 120310 · San Marcos, TX
- [N290SW](https://openairdocs.org/aircraft/N290SW.md): Embraer EMB-120ER · S/N 120317 · Built 1996 · San Marcos, TX
- [N297SW](https://openairdocs.org/aircraft/N297SW.md): Embraer EMB-120ER · S/N 120.327 · Built 1996 · San Marcos, TX
- [N406AV](https://openairdocs.org/aircraft/N406AV.md): Dehavilland DHC-8-202 · S/N 460 · Built 1996 · San Marcos, TX
- [N480AV](https://openairdocs.org/aircraft/N480AV.md): Dehavilland DHC-8-202 · S/N 484 · Built 1997 · San Marcos, TX
- [N492BA](https://openairdocs.org/aircraft/N492BA.md): Dehavilland DHC-8-202 · S/N 492 · Built 1997 · San Marcos, TX
- [N561SW](https://openairdocs.org/aircraft/N561SW.md): Embraer EMB-120ER · S/N 120335 · Built 1998 · San Marcos, TX
- [N584SW](https://openairdocs.org/aircraft/N584SW.md): Embraer EMB-120ER · S/N 120352 · Built 1999 · San Marcos, TX
- [N586SW](https://openairdocs.org/aircraft/N586SW.md): Embraer EMB-120ER · S/N 120354 · Built 1999 · San Marcos, TX
- [N606BA](https://openairdocs.org/aircraft/N606BA.md): Berry GERY HAWK · S/N NM47FV3202106071135 · San Marcos, TX
- [N608BA](https://openairdocs.org/aircraft/N608BA.md): Berry GERY HAWK · S/N NM47FV3202106071600 · San Marcos, TX
- [N650CT](https://openairdocs.org/aircraft/N650CT.md): Embraer EMB-120ER · S/N 120.198 · Built 1990 · San Marcos, TX
- [N651CT](https://openairdocs.org/aircraft/N651CT.md): Embraer EMB-120ER · S/N 120.197 · San Marcos, TX
- [N653WW](https://openairdocs.org/aircraft/N653WW.md): Cessna T206H · S/N T20608521 · Built 2005 · San Marcos, TX
- [N662AV](https://openairdocs.org/aircraft/N662AV.md): Dehavilland DHC-6-300 · S/N 662 · Built 1980 · San Marcos, TX
- [N675BA](https://openairdocs.org/aircraft/N675BA.md): Dehavilland DHC-6-300 · S/N 675 · Built 1980 · San Marcos, TX
- [N707TG](https://openairdocs.org/aircraft/N707TG.md): Embraer EMB-120ER · S/N 120.182 · Built 1990 · San Marcos, TX
- [N957BA](https://openairdocs.org/aircraft/N957BA.md): Fairchild SA227-DC · S/N DC866B · San Marcos, TX

## 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 = 'BERRY AVIATION INC' OR list_contains(g.other_registrant_names, 'BERRY AVIATION INC')
ORDER BY g.n_number
```

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