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.
N972VUPixis Drones LLC · Alexandria, VAN972WUPixis Drones LLC · Alexandria, VAN972XUPixis Drones LLC · Alexandria, VAN972YUPixis Drones LLC · Alexandria, VAN972ZUPixis Drones LLC · Alexandria, VAN9732UPixis Drones LLC · Alexandria, VAN9737UPixis Drones LLC · Alexandria, VAN973AUPixis Drones LLC · Alexandria, VAN973BUPixis Drones LLC · Alexandria, VAN973CUPixis Drones LLC · Alexandria, VAN973DUPixis Drones LLC · Alexandria, VAN973EUPixis Drones LLC · Alexandria, VAN973FUPixis Drones LLC · Alexandria, VAN973GUPixis Drones LLC · Alexandria, VAN973JUPixis Drones LLC · Alexandria, VAN973KUPixis Drones LLC · Alexandria, VAN973LUPixis Drones LLC · Alexandria, VAN973MUPixis Drones LLC · Alexandria, VAN973NUPixis Drones LLC · Alexandria, VAN973PUPixis Drones LLC · Alexandria, VAN973QUPixis Drones LLC · Alexandria, VAN973RUPixis Drones LLC · Alexandria, VAN973SUPixis Drones LLC · Alexandria, VAN973TUPixis Drones LLC · Alexandria, VAN973UUPixis Drones LLC · Alexandria, VAN973VUPixis Drones LLC · Alexandria, VAN973WUPixis Drones LLC · Alexandria, VAN973XUPixis Drones LLC · Alexandria, VAN973YUPixis Drones LLC · Alexandria, VAN973ZUPixis Drones LLC · Alexandria, VAN9740UPixis Drones LLC · Alexandria, VAN9742UPixis Drones LLC · Alexandria, VAN9743UPixis Drones LLC · Alexandria, VAN9746UPixis Drones LLC · Alexandria, VAN974AUPixis Drones LLC · Alexandria, VAN974BUPixis Drones LLC · Alexandria, VAN974CUPixis Drones LLC · Alexandria, VAN974DUPixis Drones LLC · Alexandria, VAN974EUPixis Drones LLC · Alexandria, VAN974FUPixis Drones LLC · Alexandria, VAN974GUPixis Drones LLC · Alexandria, VAN974HUPixis Drones LLC · Alexandria, VAN974JUPixis Drones LLC · Alexandria, VAN974KUPixis Drones LLC · Alexandria, VAN974LUPixis Drones LLC · Alexandria, VAN974MUPixis Drones LLC · Alexandria, VAN974UUPixis Drones LLC · Alexandria, VAN974VUPixis Drones LLC · Alexandria, VAN974WUPixis Drones LLC · Alexandria, VAN974YUPixis Drones LLC · Alexandria, VA
Back to Uvify 810-00028