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.
N974ZUPixis Drones LLC · Alexandria, VAN9754UPixis Drones LLC · Alexandria, VAN9755UPixis Drones LLC · Alexandria, VAN9756UPixis Drones LLC · Alexandria, VAN9758UPixis Drones LLC · Alexandria, VAN975AUPixis Drones LLC · Alexandria, VAN975BUPixis Drones LLC · Alexandria, VAN975CUPixis Drones LLC · Alexandria, VAN975DUPixis Drones LLC · Alexandria, VAN975GUPixis Drones LLC · Alexandria, VAN975PUPixis Drones LLC · Alexandria, VAN975QUPixis Drones LLC · Alexandria, VAN975RUPixis Drones LLC · Alexandria, VAN975SUPixis Drones LLC · Alexandria, VAN975TUPixis Drones LLC · Alexandria, VAN975VUPixis Drones LLC · Alexandria, VAN975WUPixis Drones LLC · Alexandria, VAN975XUPixis Drones LLC · Alexandria, VAN9761UPixis Drones LLC · Alexandria, VAN9764UPixis Drones LLC · Alexandria, VAN9765UPixis Drones LLC · Alexandria, VAN9766UPixis Drones LLC · Alexandria, VAN9768UPixix Drones LLC · Alexandria, VAN9769UPixis Drones LLC · Alexandria, VAN976AUPixis Drones LLC · Alexandria, VAN976JUPixis Drones LLC · Alexandria, VAN976KUPixis Drones LLC · Alexandria, VAN976RUPixis Drones LLC · Alexandria, VAN976SUPixis Drones LLC · Alexandria, VAN976TUPixis Drones LLC · Alexandria, VAN976UUPixis Drones LLC · Alexandria, VAN976VUPixis Drones LLC · Alexandria, VAN976WUPixis Drones LLC · Alexandria, VAN976XUPixis Drones LLC · Alexandria, VAN976YUPixis Drones LLC · Alexandria, VAN976ZUPixis Drones LLC · Alexandria, VAN9771UPixis Drones LLC · Alexandria, VAN977AUPixis Drones LLC · Alexandria, VAN977BUPixis Drones LLC · Alexandria, VAN977CUPixis Drones LLC · Alexandria, VAN977DUPixis Drones LLC · Alexandria, VAN977EUPixis Drones LLC · Alexandria, VAN977FUPixis Drones LLC · Alexandria, VAN977GUPixis Drones LLC · Alexandria, VAN977HUPixis Drones LLC · Alexandria, VAN977JUPixis Drones LLC · Alexandria, VAN977KUPixis Drones LLC · Alexandria, VAN977LUPixis Drones LLC · Alexandria, VAN977MUPixis Drones LLC · Alexandria, VAN977NUPixix Drones LLC · Alexandria, VA
Back to Uvify 810-00028