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.
N981LUPixis Drones LLC · Alexandria, VAN981MUPixis Drones LLC · Alexandria, VAN981PUPixis Drones LLC · Alexandria, VAN981QUPixis Drones LLC · Alexandria, VAN981TUPixis Drones LLC · Alexandria, VAN981UUPixis Drones LLC · Alexandria, VAN981XUPixis Drones LLC · Alexandria, VAN981YUPixis Drones LLC · Alexandria, VAN981ZUPixis Drones LLC · Alexandria, VAN9820UPixis Drones LLC · Alexandria, VAN9825UPixis Drones LLC · Alexandria, VAN9826UPixis Drones LLC · Alexandria, VAN9829UPixis Drones LLC · Alexandria, VAN982AUPixis Drones LLC · Alexandria, VAN982BUPixis Drones LLC · Alexandria, VAN982CUPixis Drones LLC · Alexandria, VAN982DUPixis Drones LLC · Alexandria, VAN982GUPixis Drones LLC · Alexandria, VAN982HUPixis Drones LLC · Alexandria, VAN982JUPixis Drones LLC · Alexandria, VAN982KUPixis Drones LLC · Alexandria, VAN982LUPixis Drones LLC · Alexandria, VAN982MUPixis Drones LLC · Alexandria, VAN982PUPixis Drones LLC · Alexandria, VAN982QUPixis Drones LLC · Alexandria, VAN982RUPixis Drones LLC · Alexandria, VAN982SUPixis Drones LLC · Alexandria, VAN982TUPixis Drones LLC · Alexandria, VAN982UUPixis Drones LLC · Alexandria, VAN982VUPixis Drones LLC · Alexandria, VAN982WUPixis Drones LLC · Alexandria, VAN982XUPixis Drones LLC · Alexandria, VAN982YUPixis Drones LLC · Alexandria, VAN982ZUPixis Drones LLC · Alexandria, VAN9835UPixis Drones LLC · Alexandria, VAN9836UPixis Drones LLC · Alexandria, VAN9837UPixis Drones LLC · Alexandria, VAN9838UPixis Drones LLC · Alexandria, VAN9839UPixis Drones LLC · Alexandria, VAN983AUPixis Drones LLC · Alexandria, VAN983BUPixis Drones LLC · Alexandria, VAN983CUPixis Drones LLC · Alexandria, VAN983DUPixis Drones LLC · Alexandria, VAN983EUPixis Drones LLC · Alexandria, VAN983FUPixis Drones LLC · Alexandria, VAN983GUPixis Drones LLC · Alexandria, VAN983HUPixis Drones LLC · Alexandria, VAN983JUPixis Drones LLC · Alexandria, VAN983LUPixis Drones LLC · Alexandria, VAN983PUPixis Drones LLC · Alexandria, VA
Back to Uvify 810-00028