Skip to content

Symphony Aircraft Ind SA 160

Registered aircraft · 15

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('05619SU')
  ORDER BY 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.

SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('05619SU')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N320STGuaglione Anthony · El Dorado Hills, CABuilt 2006 · S/N S-10002 N349TWPilot Enterprises LLC · Norfolk, VABuilt 2006 · S/N S-0012 N38KPAero Equity LLC · Boise, IDBuilt 2006 · S/N S-0014 N547GBBarry Edwin R · Apple Valley, CABuilt 2006 · S/N S-10001 N580SKEary Enterprises LLC · Peoria, AZBuilt 2006 · S/N S-0013 N638SAJohnson James W · Panama City, FLBuilt 2005 · S/N S-0001 N639SAAtkins Kelly · Helena, MTBuilt 2005 · S/N S-0002 N640SAMcm Aircraft LLC · San Antonio, TXBuilt 2005 · S/N S-0003 N642SAFlying Time Llp · Fort Mill, SCBuilt 2005 · S/N S-0005 N645SAGerrish Ronald M · San Antonio, TXBuilt 2005 · S/N S-0007 N646SAAbc Aviation LLC · Floresville, TXBuilt 2005 · S/N S-0008 N647SAZelmair Aviation LLC · Leo, INS/N S-0009 N648SAFour Delta Tango LLC · Wilmington, DEBuilt 2005 · S/N S-0010 N649SAHelm Craig Anthony · Graham, TXBuilt 2006 · S/N S-0011 N844SAPart Time Aviation LLC · Douglas, GABuilt 2006 · S/N S-0015

Back to Symphony Aircraft Ind SA 160