Registered aircraft · 23

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

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

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 = 'AAS LLC' OR list_contains(g.other_registrant_names, 'AAS 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.

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 = 'AAS LLC' OR list_contains(g.other_registrant_names, 'AAS LLC')
ORDER BY g.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.

N101VTNorth American AT-6C · S/N 88-13384Built 1958 · Ovid, MI N1025AAir Tractor AT-502 · S/N 502-0075Built 1990 · Ovid, MI N1158YCessna 150B · S/N 15059558Built 1962 · Ovid, MI N144KSAir Tractor AT-400 · S/N 400-0640Built 1986 · Ovid, MI N20034Taylor J-2 · S/N 1834Built 1937 · Ovid, MI N254BColonial C-1 · S/N 14Built 1957 · Ovid, MI N2671GChampion 7ECA · S/N 316Built 1967 · Ovid, MI N2PPBoeing A75N1(PT17) · S/N 75-3412Built 1942 · Ovid, MI N3193NCessna 120 · S/N 13451Built 1947 · Ovid, MI N3661CCessna 180 · S/N 31160Built 1954 · Ovid, MI N38070Piper J5A · S/N 5-857Built 1941 · Ovid, MI N42801Cessna 182L · S/N 18259195Built 1968 · Ovid, MI N444ASAir Tractor AT-400 · S/N 400-0438Built 1982 · Ovid, MI N444MSAir Tractor AT-400 · S/N 400-0444Ovid, MI N445MSAir Tractor AT-502B · S/N 502B-0237Built 1994 · Ovid, MI N45000North American AT-6 · S/N 90787Built 1943 · Ovid, MI N5023YPiper PA-23-250 · S/N 27-2027Built 1962 · Ovid, MI N6230LSchweizer SGU 2-22E · S/N 182Built 1964 · Ovid, MI N6330HPiper J3C-65 · S/N 19512Built 1946 · Ovid, MI N65669Boeing B75N1 · S/N 75-7045Built 1943 · Ovid, MI N6939Waco GXE · S/N 1758Built 1928 · Ovid, MI N7307TAir Tractor AT-400 · S/N 400-0610Built 1985 · Ovid, MI N759JMCessna 182Q · S/N 18266031Built 1977 · Ovid, MI

Back to Aas LLC