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.
N977PUPixis Drones LLC · Alexandria, VAN977QUPixis Drones LLC · Alexandria, VAN977RUPixis Drones LLC · Alexandria, VAN977SUPixis Drones LLC · Alexandria, VAN977TUPixis Drones LLC · Alexandria, VAN977UUPixis Drones LLC · Alexandria, VAN977VUPixis Drones LLC · Alexandria, VAN977WUPixis Drones LLC · Alexandria, VAN977XUPixis Drones LLC · Alexandria, VAN977YUPixis Drones LLC · Alexandria, VAN977ZUPixis Drones LLC · Alexandria, VAN9781UPixis Drones LLC · Alexandria, VAN9783UPixis Drones LLC · Alexandria, VAN9784UPixis Drones LLC · Alexandria, VAN9785UPixis Drones LLC · Alexandria, VAN9787UPixis Drones LLC · Alexandria, VAN9789UPixis Drones LLC · Alexandria, VAN978AUPixis Drones LLC · Alexandria, VAN978BUPixis Drones LLC · Alexandria, VAN978CUPixis Drones LLC · Alexandria, VAN978FUPixis Drones LLC · Alexandria, VAN978GUPixis Drones LLC · Alexandria, VAN978HUPixis Drones LLC · Alexandria, VAN978JUPixis Drones LLC · Alexandria, VAN978KUPixis Drones LLC · Alexandria, VAN978LUPixis Drones LLC · Alexandria, VAN978MUPixis Drones LLC · Alexandria, VAN978NUPixis Drones LLC · Alexandria, VAN978PUPixis Drones LLC · Alexandria, VAN978QUPixis Drones LLC · Alexandria, VAN978RUPixis Drones LLC · Alexandria, VAN978SUPixis Drones LLC · Alexandria, VAN978UUPixis Drones LLC · Alexandria, VAN978VUPixis Drones LLC · Alexandria, VAN978WUPixis Drones LLC · Alexandria, VAN978XUPixis Drones LLC · Alexandria, VAN978YUPixis Drones LLC · Alexandria, VAN978ZUPixis Drones LLC · Alexandria, VAN9796UPixis Drones LLC · Alexandria, VAN9797UPixis Drones LLC · Alexandria, VAN979AUPixis Drones LLC · Alexandria, VAN979BUPixis Drones LLC · Alexandria, VAN979CUPixis Drones LLC · Alexandria, VAN979DUPixis Drones LLC · Alexandria, VAN979EUPixis Drones LLC · Alexandria, VAN979FUPixis Drones LLC · Alexandria, VAN979GUPixis Drones LLC · Alexandria, VAN979HUPixis Drones LLC · Alexandria, VAN979JUPixis Drones LLC · Alexandria, VAN979KUPixis Drones LLC · Alexandria, VA
Back to Uvify 810-00028