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.
N964MUPixis Drones LLC · Alexandria, VAN964NUPixis Drones LLC · Alexandria, VAN9655UPixis Drones LLC · Alexandria, VAN9660UPixis Drones LLC · Alexandria, VAN9661UPixis Drones LLC · Alexandria, VAN966BUPixis Drones LLC · Alexandria, VAN966CUPixis Drones LLC · Alexandria, VAN966DUPixis Drones LLC · Alexandria, VAN966EUPixis Drones LLC · Alexandria, VAN966FUPixis Drones LLC · Alexandria, VAN966GUPixis Drones LLC · Alexandria, VAN966HUPixis Drones LLC · Alexandria, VAN966JUPixis Drones LLC · Alexandria, VAN966KUPixis Drones LLC · Alexandria, VAN966LUPixis Drones LLC · Alexandria, VAN966MUPixis Drones LLC · Alexandria, VAN966NUPixis Drones LLC · Alexandria, VAN966PUPixis Drones LLC · Alexandria, VAN966QUPixis Drones LLC · Alexandria, VAN966RUPixis Drones LLC · Alexandria, VAN966SUPixis Drones LLC · Alexandria, VAN966TUPixis Drones LLC · Alexandria, VAN966UUPixis Drones LLC · Alexandria, VAN966VUPixis Drones LLC · Alexandria, VAN966WUPixis Drones LLC · Alexandria, VAN966XUPixis Drones LLC · Alexandria, VAN966YUPixis Drones LLC · Alexandria, VAN966ZUPixis Drones LLC · Alexandria, VAN967AUPixis Drones LLC · Alexandria, VAN967BUPixis Drones LLC · Alexandria, VAN967CUPixis Drones LLC · Alexandria, VAN967DUPixis Drones LLC · Alexandria, VAN967EUPixis Drones LLC · Alexandria, VAN967FUPixis Drones LLC · Alexandria, VAN967GUPixis Drones LLC · Alexandria, VAN967HUPixis Drones LLC · Alexandria, VAN967JUPixis Drones LLC · Alexandria, VAN967KUPixis Drones LLC · Alexandria, VAN967LUPixis Drones LLC · Alexandria, VAN967MUPixis Drones LLC · Alexandria, VAN967NUPixis Drones LLC · Alexandria, VAN967PUPixis Drones LLC · Alexandria, VAN967RUPixis Drones LLC · Alexandria, VAN967SUPixis Drones LLC · Alexandria, VAN967TUPixis Drones LLC · Alexandria, VAN967UUPixis Drones LLC · Alexandria, VAN967VUPixis Drones LLC · Alexandria, VAN967WUPixis Drones LLC · Alexandria, VAN967XUPixis Drones LLC · Alexandria, VAN967YUPixis Drones LLC · Alexandria, VA
Back to Uvify 810-00028