OpenAirDocs.org
Advanced Air LLC

Registered aircraft · 20

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

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N15VAEmbraer EMB-145LR · S/N 145072Built 1998 · Statesville, NCN25VAEmbraer EMB-145LR · S/N 145131Built 1999 · Statesville, NCN328GTDornier 328-300 · S/N 3183Built 2001 · Hawthorne, CAN334MSFairchild Dornier DORNIER 328-300 · S/N 3214Built 2002 · Hawthorne, CAN337JBEmbraer ERJ 190-100 IGW · S/N 19000473Built 2011 · Statesville, NCN339JBEmbraer ERJ 190-100 IGW · S/N 19000490Built 2011 · Statesville, NCN350ESHawker Beechcraft B300 · S/N FL-703Built 2010 · Hawthorne, CAN395AABeech B300 · S/N FL39Built 1991 · Hawthorne, CAN395AVRaytheon B300 · S/N FL-375Hawthorne, CAN395MBRaytheon B300 · S/N FL-347Built 2002 · Hawthorne, CAN395MSDornier Luftfahrt DORNIER 328-300 · S/N 3213Built 2002 · Hawthorne, CAN43VAEmbraer EMB-145LR · S/N 145061Built 1998 · Statesville, NCN46VAEmbraer EMB-145LR · S/N 145103Built 1999 · Statesville, NCN47VAEmbraer EMB-145 · S/N 145110Built 1999 · Statesville, NCN49VAEmbraer EMB-145LR · S/N 145.151Built 1999 · Statesville, NCN67VAEmbraer EMB-145LR · S/N 145354Built 2000 · Statesville, NCN70VAEmbraer EMB-145LR · S/N 145397Built 2001 · Statesville, NCN87VAEmbraer EMB-145LR · S/N 145430Built 2001 · Statesville, NCN88AQPilatus PC-12/47E · S/N 1029Built 2008 · Hawthorne, CAN92VAEmbraer EMB-145LR · S/N 145149Built 1999 · Statesville, NC
Back to Advanced Air LLC