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 ('4470728')
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 ('4470728')
ORDER BY n_numberRun 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.
N9034FStuart Aviation Inc · Wilmington, DEN9052FMotivated Air LLC · Felton, DEN9107FUp Rite Aviation LLC · Zeeland, MIN9113QSea Corp Helicopters Inc · Wilmington, DEN9118FCook Jeffrey G Trustee · Ventura, CAN9132FHorizon Aviation LLC · Glastonbury, CTN9146FBerling Robert E · Mooresville, INN9166FNorthstar Marine LLC · Lewes, DEN9176F76f LLC · Calhoun, GAN9177FRotor View Inc · Wilmington, DEN9196FAsbill Jimmy T · Winnsboro, TXN9233FC & D Helicopters LLC · Spanish Fork, UTN9260FRjo LLC · Kenansville, FLN9267FManulwa Airways Inc · Hilo, HIN926ESRoyal Helicopter Services LLC · Exeter, CAN9677NDat Aircraft LLC · Lewes, DEN98369Diamond X LLC · Elko, NVN990SRBlue Penguin LLC · Lockhart, TXN9HAMiracle Robert B Sr · Perkasie, PA
Back to Hughes 369HS