# Registered aircraft: Advanced Air LLC

A list on [Advanced Air LLC](https://openairdocs.org/faa-owner/ADVANCED%20AIR%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.

- [N15VA](https://openairdocs.org/aircraft/N15VA.md): Embraer EMB-145LR · S/N 145072 · Built 1998 · Statesville, NC
- [N25VA](https://openairdocs.org/aircraft/N25VA.md): Embraer EMB-145LR · S/N 145131 · Built 1999 · Statesville, NC
- [N328GT](https://openairdocs.org/aircraft/N328GT.md): Dornier 328-300 · S/N 3183 · Built 2001 · Hawthorne, CA
- [N334MS](https://openairdocs.org/aircraft/N334MS.md): Fairchild Dornier DORNIER 328-300 · S/N 3214 · Built 2002 · Hawthorne, CA
- [N337JB](https://openairdocs.org/aircraft/N337JB.md): Embraer ERJ 190-100 IGW · S/N 19000473 · Built 2011 · Statesville, NC
- [N339JB](https://openairdocs.org/aircraft/N339JB.md): Embraer ERJ 190-100 IGW · S/N 19000490 · Built 2011 · Statesville, NC
- [N350ES](https://openairdocs.org/aircraft/N350ES.md): Hawker Beechcraft B300 · S/N FL-703 · Built 2010 · Hawthorne, CA
- [N395AA](https://openairdocs.org/aircraft/N395AA.md): Beech B300 · S/N FL39 · Built 1991 · Hawthorne, CA
- [N395AV](https://openairdocs.org/aircraft/N395AV.md): Raytheon B300 · S/N FL-375 · Hawthorne, CA
- [N395MB](https://openairdocs.org/aircraft/N395MB.md): Raytheon B300 · S/N FL-347 · Built 2002 · Hawthorne, CA
- [N395MS](https://openairdocs.org/aircraft/N395MS.md): Dornier Luftfahrt DORNIER 328-300 · S/N 3213 · Built 2002 · Hawthorne, CA
- [N43VA](https://openairdocs.org/aircraft/N43VA.md): Embraer EMB-145LR · S/N 145061 · Built 1998 · Statesville, NC
- [N46VA](https://openairdocs.org/aircraft/N46VA.md): Embraer EMB-145LR · S/N 145103 · Built 1999 · Statesville, NC
- [N47VA](https://openairdocs.org/aircraft/N47VA.md): Embraer EMB-145 · S/N 145110 · Built 1999 · Statesville, NC
- [N49VA](https://openairdocs.org/aircraft/N49VA.md): Embraer EMB-145LR · S/N 145.151 · Built 1999 · Statesville, NC
- [N67VA](https://openairdocs.org/aircraft/N67VA.md): Embraer EMB-145LR · S/N 145354 · Built 2000 · Statesville, NC
- [N70VA](https://openairdocs.org/aircraft/N70VA.md): Embraer EMB-145LR · S/N 145397 · Built 2001 · Statesville, NC
- [N87VA](https://openairdocs.org/aircraft/N87VA.md): Embraer EMB-145LR · S/N 145430 · Built 2001 · Statesville, NC
- [N88AQ](https://openairdocs.org/aircraft/N88AQ.md): Pilatus PC-12/47E · S/N 1029 · Built 2008 · Hawthorne, CA
- [N92VA](https://openairdocs.org/aircraft/N92VA.md): Embraer EMB-145LR · S/N 145149 · Built 1999 · Statesville, NC

## 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 = 'ADVANCED AIR LLC' OR list_contains(g.other_registrant_names, 'ADVANCED AIR LLC')
ORDER BY g.n_number
```

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