Skip to content

Registered aircraft · 690

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 = 'HYLIO INC' OR list_contains(g.other_registrant_names, 'HYLIO INC') 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 = 'HYLIO INC' OR list_contains(g.other_registrant_names, 'HYLIO INC')
  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 = 'HYLIO INC' OR list_contains(g.other_registrant_names, 'HYLIO INC')
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.

N101HYHylio HYL-150 · S/N 17906150377Richmond, TX N103HHylio HYL-300 · S/N 17906130279Richmond, TX N105HYHylio HYL-150 · S/N 17906150356Richmond, TX N107HYHylio HYL-150 · S/N 17906110667Richmond, TX N108HYHylio HYL-150 · S/N 17906110633Richmond, TX N108NAHylio HYL-150 · S/N 17906150313Richmond, TX N110HYHylio HYL-150 · S/N 17906110669Richmond, TX N123GRHylio HYL-300 · S/N 17906130244Richmond, TX N123HYHylio HYL-150 · S/N 17906110622Richmond, TX N128HAHylio AG 230 · S/N 17906100220Richmond, TX N1307AHylio AG 230 · S/N 17906100221Richmond, TX N142HYHylio HYL-150 · S/N 17906150390Richmond, TX N1449HHylio AG-272 · S/N 17906070254Richmond, TX N145PHHylio AG 230 · S/N 17906100224Richmond, TX N1468HHylio AG 230 · S/N 17906100218Richmond, TX N14791Hylio AG-130 · S/N 050003Richmond, TX N147BHHylio AG 230 · S/N 17906100225Richmond, TX N155HYHylio HYL-150 · S/N 17906150358Richmond, TX N161HHylio HYL-300 · S/N 17906130284Richmond, TX N167HYHylio HYL-300 · S/N 17906130237Richmond, TX N1942HHylio AG 230 · S/N 17906100002Richmond, TX N1944HHylio AG-216 · S/N 17906090001Richmond, TX N196BHHylio AG-216 · S/N 17906090002Richmond, TX N219HYHylio HYL-150 · S/N 17906110621Richmond, TX N221HYHylio HYL-150 · S/N 17906110678Richmond, TX N223HYHylio HYL-150 · S/N 17906110618Richmond, TX N224HYHylio HYL-150 · S/N 17906110665Richmond, TX N232HYHylio HYL-150 · S/N 17906110589Richmond, TX N235HYHylio HYL-150 · S/N 17906110570Richmond, TX N236HYHylio HYL-300 · S/N 17906130365Richmond, TX N238HYHylio HYL-300 · S/N 17906130375Richmond, TX N239HYHylio HYL-300 · S/N 17906130354Richmond, TX N241HYHylio HYL-300 · S/N 17906130353Richmond, TX N242HYHylio HYL-300 · S/N 17906130388Richmond, TX N243HYHylio HYL-300 · S/N 17906130391Richmond, TX N244HYHylio HYL-300 · S/N 17906130396Richmond, TX N245HYHylio HYL-300 · S/N 17906130392Richmond, TX N246HYHylio HYL-300 · S/N 17906130395Richmond, TX N248HYHylio HYL-300 · S/N 17906130352Richmond, TX N249HYHylio HYL-300 · S/N 17906130389Richmond, TX N251HYHylio HYL-300 · S/N 17906130359Richmond, TX N252HYHylio HYL-150 · S/N 17906150312Richmond, TX N253HYHylio HYL-150 · S/N 17906150257Richmond, TX N254HYHylio HYL-150 · S/N 17906150278Richmond, TX N255HYHylio HYL-150 · S/N 17906150206Richmond, TX N256HYHylio HYL-150 · S/N 17906150315Richmond, TX N257HYHylio HYL-150 · S/N 17906150275Richmond, TX N258HYHylio HYL-150 · S/N 17906150282Richmond, TX N259HYHylio HYL-150 · S/N 17906150268Richmond, TX N260HYHylio HYL-150 · S/N 17906150310Richmond, TX

Back to Hylio Inc