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 ('1182110')
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 ('1182110')
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.
N803BAWildwest Helicopters Inc · Henderson, NVN811SFN179sf LLC · Chandler, AZN83LPPanther Helicopters Inc · Belle Chasse, LAN83UHelicopters Inc · Wilmington, DEN87JRRoche Gerald Aloysius · KildareN87WPMarks Lloyd L · Lafayette, LAN88BDSouthern Illinois Helicopters LLC · Marion, ILN910BRAir Gov 1 LLC · Rome, NYN911YYCity Of Chicago · Chicago, ILN917SUSouthern Utah University · Cedar City, UTN9245CCh4 Systems LLC · Guaynabo, PRN941SHSummit Helicopters Inc · Salem, VAN94HPPila LLC · Heber City, UTN95PDBeck Aviation LLC · Fort Myers, FLN95TVHelicopters Inc · Wilmington, DEN988BHeli Works Flight Services LLC · Deer Lodge, MTN98CLHeliinc LLC · Linden, NJN995PM5688c LLC · Glendale, AZN997PMPacific Marine Leasing LLC · Jackson, WYN9BQHelicopters Inc · Cahokia, ILN9UJHelicopters Inc · Linden, NJ
Back to Bell 206-L4