Skip to content

Ace Aeronautics LLC

Registered aircraft · 56

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

N118TASikorsky UH-60L · S/N 88-26075Built 1988 · Guntersville, AL N121GDSikorsky UH-60A · S/N 82-23701Guntersville, AL N121MXSikorsky UH-60A · S/N 83-23839Guntersville, AL N121UASikorsky UH-60A · S/N 83-23899Guntersville, AL N121XSSikorsky UH-60A · S/N 82-23660Built 1982 · Guntersville, AL N138LBSikorsky UH-60L · S/N 83-23903Guntersville, AL N149JBSikorsky UH-60L · S/N 05-27055Guntersville, AL N170RTSikorsky UH-60L · S/N 02-26960Guntersville, AL N220JBSikorsky UH-60L · S/N 93-26500Guntersville, AL N224YASikorsky UH-60L · S/N 85-24387Built 1985 · Guntersville, AL N226JBSikorsky UH-60L · S/N 84-23962Guntersville, AL N260RTSikorsky UH-60L · S/N 83-23902Guntersville, AL N270RTSikorsky UH-60L · S/N 86-24498Guntersville, AL N280RTSikorsky UH-60L · S/N 88-26034Guntersville, AL N303WESikorsky UH-60L · S/N 87-24623Built 1987 · Guntersville, AL N304WESikorsky UH-60L · S/N 83-23922Built 1984 · Guntersville, AL N305WESikorsky UH-60L · S/N 01-26888Built 2001 · Guntersville, AL N306RTSikorsky UH-60L · S/N 88-26039Guntersville, AL N306WESikorsky UH-60L · S/N 94-26569Built 1995 · Guntersville, AL N307WESikorsky UH-60L · S/N 03-26986Built 2004 · Guntersville, AL N308WESikorsky UH-60L · S/N 84-23949Guntersville, AL N309WESikorsky UH-60L · S/N 86-24554Guntersville, AL N310WESikorsky UH-60L · S/N 84-24000Guntersville, AL N311WESikorsky UH-60L · S/N 85-24439Guntersville, AL N312WESikorsky UH-60L · S/N 84-23973Guntersville, AL N314RTSikorsky UH-60L · S/N 88-26033Built 1988 · Guntersville, AL N319KCSikorsky EH-60A · S/N 86-24573Built 1987 · Guntersville, AL N322RTSikorsky UH-60L · S/N 86-24550Built 1986 · Guntersville, AL N325RTSikorsky UH-60L · S/N 88-26056Guntersville, AL N419GRSikorsky UH-60L · S/N 92-26430Guntersville, AL N438GRSikorsky UH-60L · S/N 92-26446Guntersville, AL N451VKAce Aeronautics UH-60A · S/N 80-23455Built 1980 · Guntersville, AL N494AASikorsky UH-60L · S/N 93-26495Guntersville, AL N497DPSikorsky UH-60L · S/N 94-26580Guntersville, AL N50WESikorsky UH-60L · S/N 06-27091Guntersville, AL N5897ASikorsky UH-60L · S/N 90-26259Guntersville, AL N590DASikorsky UH-60L · S/N 94-26592Guntersville, AL N590RASikorsky UH-60L · S/N 92-26427Guntersville, AL N60PXSikorsky UH-60L · S/N 88-26050Built 1988 · Guntersville, AL N60WKSikorsky UH-60L · S/N 87-24613Guntersville, AL N60YKSikorsky UH-60L · S/N 85-24396Built 1985 · Guntersville, AL N624XTSikorsky UH-60L · S/N 02-26963Guntersville, AL N624YRSikorsky UH-60L · S/N 92-26421Guntersville, AL N6256ASikorsky UH-60L · S/N 99-26829Guntersville, AL N637JASikorsky UH-60L · S/N 87-24628Guntersville, AL N637KASikorsky UH-60L · S/N 84-23933Guntersville, AL N651QASikorsky UH-60L · S/N 90-26260Guntersville, AL N651WASikorsky UH-60L · S/N 06-27093Guntersville, AL N65WESikorsky UH-60L · S/N 89-26180Guntersville, AL N68WESikorsky UH-60L · S/N 90-26307Guntersville, AL

Back to Ace Aeronautics LLC