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.
N9680UPixis Drones LLC · Alexandria, VAN9682UPixis Drones LLC · Alexandria, VAN9686UPixis Drones LLC · Alexandria, VAN9688UPixis Drones LLC · Alexandria, VAN968DUPixis Drones LLC · Alexandria, VAN968EUPixis Drones LLC · Alexandria, VAN968GUPixis Drones LLC · Alexandria, VAN968HUPixis Drones LLC · Alexandria, VAN968JUPixis Drones LLC · Alexandria, VAN968KUPixis Drones LLC · Alexandria, VAN968LUPixis Drones LLC · Alexandria, VAN968MUPixis Drones LLC · Alexandria, VAN968NUPixis Drones LLC · Alexandria, VAN968QUPixis Drones LLC · Alexandria, VAN968RUPixis Drones LLC · Alexandria, VAN968SUPixis Drones LLC · Alexandria, VAN968TUPixis Drones LLC · Alexandria, VAN968UUPixis Drones LLC · Alexandria, VAN968VUPixis Drones LLC · Alexandria, VAN968WUPixis Drones LLC · Alexandria, VAN968XUPixis Drones LLC · Alexandria, VAN968YUPixis Drones LLC · Alexandria, VAN968ZUPixis Drones LLC · Alexandria, VAN969AUPixis Drones LLC · Alexandria, VAN969HUPixis Drones LLC · Alexandria, VAN9715UPixis Drones LLC · Alexandria, VAN9716UPixis Drones LLC · Alexandria, VAN971ZUPixis Drones LLC · Alexandria, VAN9720UPixis Drones LLC · Alexandria, VAN9722UPixis Drones LLC · Alexandria, VAN9724UPixis Drones LLC · Alexandria, VAN9726UPixis Drones LLC · Alexandria, VAN972AUPixis Drones LLC · Alexandria, VAN972BUPixis Drones LLC · Alexandria, VAN972CUPixis Drones LLC · Alexandria, VAN972DUPixis Drones LLC · Alexandria, VAN972FUPixis Drones LLC · Alexandria, VAN972GUPixis Drones LLC · Alexandria, VAN972HUPixis Drones LLC · Alexandria, VAN972JUPixis Drones LLC · Alexandria, VAN972KUPixis Drones LLC · Alexandria, VAN972LUPixis Drones LLC · Alexandria, VAN972MUPixis Drones LLC · Alexandria, VAN972NUPixis Drones LLC · Alexandria, VAN972PUPixis Drones LLC · Alexandria, VAN972QUPixis Drones LLC · Alexandria, VAN972RUPixis Drones LLC · Alexandria, VAN972SUPixis Drones LLC · Alexandria, VAN972TUPixis Drones LLC · Alexandria, VAN972UUPixis Drones LLC · Alexandria, VA
Back to Uvify 810-00028