Skip to content

Pixis Drones LLC

Registered aircraft · 646

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'PIXIS DRONES LLC' OR list_contains(g.other_registrant_names, 'PIXIS DRONES LLC') ORDER BY g.n_number

duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'PIXIS DRONES LLC' OR list_contains(g.other_registrant_names, 'PIXIS DRONES LLC')
  ORDER BY g.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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_name = 'PIXIS DRONES LLC' OR list_contains(g.other_registrant_names, 'PIXIS DRONES LLC')
ORDER BY g.n_number

Run 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.

N9533UUvify 810-00028 · S/N 213682IFOD01060000561Alexandria, VA N9535UUvify 810-00028 · S/N 213682IFOD01060000563Alexandria, VA N9536UUvify 810-00028 · S/N 213682IFOD01060000564Alexandria, VA N953YUUvify 810-00028 · S/N 213682IFOD01060000562Alexandria, VA N953ZUUvify 810-00028 · S/N 213682IFOD01060000570Alexandria, VA N9543UUvify 810-00028 · S/N 213682IFOD01060000583Alexandria, VA N9544UUvify 810-00028 · S/N 213682IFOD01060000584Alexandria, VA N9545UUvify 810-00028 · S/N 213682IFOD01060000585Alexandria, VA N9549UUvify 810-00028 · S/N 213682IFOD01060000586Alexandria, VA N954AUUvify 810-00028 · S/N 213682IFOD01060000565Alexandria, VA N954CUUvify 810-00028 · S/N 213682IFOD01060000566Alexandria, VA N954DUUvify 810-00028 · S/N 213682IFOD01060000567Alexandria, VA N954EUUvify 810-00028 · S/N 213682IFOD01060000568Alexandria, VA N954FUUvify 810-00028 · S/N 213682IFOD01060000569Alexandria, VA N954GUUvify 810-00028 · S/N 213682IFOD01060000571Alexandria, VA N954MUUvify 810-00028 · S/N 213682IFOD01060000572Alexandria, VA N954NUUvify 810-00028 · S/N 213682IFOD01060000573Alexandria, VA N954RUUvify 810-00028 · S/N 213682IFOD01060000574Alexandria, VA N954SUUvify 810-00028 · S/N 213682IFOD01060000575Alexandria, VA N954TUUvify 810-00028 · S/N 213682IFOD01060000576Alexandria, VA N954UUUvify 810-00028 · S/N 213682IFOD01060000577Alexandria, VA N954VUUvify 810-00028 · S/N 213682IFOD01060000578Alexandria, VA N954WUUvify 810-00028 · S/N 213682IFOD01060000579Alexandria, VA N954XUUvify 810-00028 · S/N 213682IFOD01060000580Alexandria, VA N954YUUvify 810-00028 · S/N 213682IFOD01060000581Alexandria, VA N954ZUUvify 810-00028 · S/N 213682IFOD01060000582Alexandria, VA N9551UUvify 810-00028 · S/N 213682IFOD01060000607Alexandria, VA N9555UUvify 810-00028 · S/N 213682IFOD01060000608Alexandria, VA N9558UUvify 810-00028 · S/N 213682IFOD01060000609Alexandria, VA N955CUUvify 810-00028 · S/N 213682IFOD01060000587Alexandria, VA N955DUUvify 810-00028 · S/N 213682IFOD01060000588Alexandria, VA N955EUUvify 810-00028 · S/N 213682IFOD01060000589Alexandria, VA N955FUUvify 810-00028 · S/N 213682IFOD01060000590Alexandria, VA N955GUUvify 810-00028 · S/N 213682IFOD01060000591Alexandria, VA N955HUUvify 810-00028 · S/N 213682IFOD01060000592Alexandria, VA N955JUUvify 810-00028 · S/N 213682IFOD01060000593Alexandria, VA N955KUUvify 810-00028 · S/N 213682IFOD01060000594Alexandria, VA N955LUUvify 810-00028 · S/N 213682IFOD01060000595Alexandria, VA N955MUUvify 810-00028 · S/N 213682IFOD01060000596Alexandria, VA N955NUUvify 810-00028 · S/N 213682IFOD01060000597Alexandria, VA N955PUUvify 810-00028 · S/N 213682IFOD01060000598Alexandria, VA N955QUUvify 810-00028 · S/N 213682IFOD01060000599Alexandria, VA N955RUUvify 810-00028 · S/N 213682IFOD01060000600Alexandria, VA N955SUUvify 810-00028 · S/N 213682IFOD01060000601Alexandria, VA N955TUUvify 810-00028 · S/N 213682IFOD01060000602Alexandria, VA N955WUUvify 810-00028 · S/N 213682IFOD01060000605Alexandria, VA N955XUUvify 810-00028 · S/N 213682IFOD01060000603Alexandria, VA N955YUUvify 810-00028 · S/N 213682IFOD01060000604Alexandria, VA N955ZUUvify 810-00028 · S/N 213682IFOD01060000606Alexandria, VA N9561UUvify 810-00028 · S/N 213682IFOD01060000632Alexandria, VA

Back to Pixis Drones LLC