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 ('06102D6')
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 ('06102D6')
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.
N979LUPixis Drones LLC · Alexandria, VAN979MUPixis Drones LLC · Alexandria, VAN979NUPixis Drones LLC · Alexandria, VAN979PUPixis Drones LLC · Alexandria, VAN979QUPixis Drones LLC · Alexandria, VAN979RUPixis Drones LLC · Alexandria, VAN979SUPixis Drones LLC · Alexandria, VAN979TUPixis Drones LLC · Alexandria, VAN979UUPixis Drones LLC · Alexandria, VAN979VUPixis Drones LLC · Alexandria, VAN979WUPixis Drones LLC · Alexandria, VAN979XUPixis Drones LLC · Alexandria, VAN979YUPixis Drones LLC · Alexandria, VAN979ZUPixis Drones LLC · Alexandria, VAN9801UPixis Drones LLC · Alexandria, VAN9803UPixis Drones LLC · Alexandria, VAN9804UPixis Drones LLC · Alexandria, VAN9806UPixis Drones LLC · Alexandria, VAN9808UPixis Drones LLC · Alexandria, VAN980AUPixis Drones LLC · Alexandria, VAN980BUPixis Drones LLC · Alexandria, VAN980CUPixis Drones LLC · Alexandria, VAN980DUPixis Drones LLC · Alexandria, VAN980EUPixis Drones LLC · Alexandria, VAN980FUPixis Drones LLC · Alexandria, VAN980GUPixis Drones LLC · Alexandria, VAN980HUPixis Drones LLC · Alexandria, VAN980JUPixis Drones LLC · Alexandria, VAN980KUPixis Drones LLC · Alexandria, VAN980LUPixis Drones LLC · Alexandria, VAN980MUPixis Drones LLC · Alexandria, VAN980NUPixis Drones LLC · Alexandria, VAN980PUPixis Drones LLC · Alexandria, VAN980QUPixis Drones LLC · Alexandria, VAN980RUPixis Drones LLC · Alexandria, VAN980TUPixis Drones LLC · Alexandria, VAN980UUPixis Drones LLC · Alexandria, VAN980VUPixis Drones LLC · Alexandria, VAN980WUPixis Drones LLC · Alexandria, VAN980XUPixis Drones LLC · Alexandria, VAN980YUPixis Drones LLC · Alexandria, VAN980ZUPixis Drones LLC · Alexandria, VAN9812UPixis Drones LLC · Alexandria, VAN9813UPixis Drones LLC · Alexandria, VAN9814UPixis Drones LLC · Alexandria, VAN9817UPixis Drones LLC · Alexandria, VAN981AUPixis Drones LLC · Alexandria, VAN981BUPixis Drones LLC · Alexandria, VAN981CUPixis Drones LLC · Alexandria, VAN981JUPixis Drones LLC · Alexandria, VA
Back to Uvify 810-00028