Skip to content

Registered aircraft · 454

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 = 'SHIELD AI INC' OR list_contains(g.other_registrant_names, 'SHIELD AI INC') 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 = 'SHIELD AI INC' OR list_contains(g.other_registrant_names, 'SHIELD AI INC')
  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 = 'SHIELD AI INC' OR list_contains(g.other_registrant_names, 'SHIELD AI INC')
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.

N111VBShield Ai V-BAT · S/N VB-100250Frisco, TX N147VBShield Ai V-BAT · S/N VB-100252Frisco, TX N1826ZShield Ai V-BAT · S/N VB-100121Frisco, TX N1829ZShield Ai V-BAT · S/N VB-100122Frisco, TX N1832ZShield Ai V-BAT · S/N VB-100123Frisco, TX N1841ZShield Ai V-BAT · S/N VB-100124Frisco, TX N1849ZShield Ai V-BAT · S/N VB-100125Frisco, TX N184VBShield Ai V-BAT · S/N VB-100260Frisco, TX N1851ZShield Ai V-BAT · S/N VB-100127Frisco, TX N1853ZShield Ai V-BAT · S/N VB-100126Frisco, TX N1855ZShield Ai V-BAT · S/N VB-100128Frisco, TX N1857ZShield Ai V-BAT · S/N VB-100129Frisco, TX N1863ZShield Ai V-BAT · S/N VB-100130Frisco, TX N188VBShield Ai V-BAT · S/N VB-100251Frisco, TX N2043FShield Ai V-BAT · S/N VB-100146Frisco, TX N204VGShield Ai V-BAT · S/N VB-100147Frisco, TX N2051SShield Ai V-BAT · S/N VB-100157Frisco, TX N2053SShield Ai V-BAT · S/N VB-100166Frisco, TX N2058UShield Ai V-BAT · S/N VB-100158Frisco, TX N2059SShield Ai V-BAT · S/N VB-100152Frisco, TX N205SZShield Ai V-BAT · S/N VB-100165Frisco, TX N205WSShield Ai V-BAT · S/N VB-100164Frisco, TX N2060AShield Ai V-BAT · S/N VB-100161Frisco, TX N2062SShield Ai V-BAT · S/N VB-100160Frisco, TX N2066SShield Ai V-BAT · S/N VB-100154Frisco, TX N2068UShield Ai V-BAT · S/N VB-100151Frisco, TX N206HSShield Ai V-BAT · S/N VB-100167Frisco, TX N206PRShield Ai V-BAT · S/N VB-100163Frisco, TX N206SSShield Ai V-BAT · S/N VB-100162Frisco, TX N206WSShield Ai V-BAT · S/N VB-100156Frisco, TX N206ZSShield Ai V-BAT · S/N VB-100155Frisco, TX N207AAShield Ai V-BAT · S/N VB-100144Frisco, TX N207DSShield Ai V-BAT · S/N VB-100145Frisco, TX N207GTShield Ai V-BAT · S/N VB-100150Frisco, TX N207HSShield Ai V-BAT · S/N VB-100143Frisco, TX N2082SShield Ai V-BAT · S/N VB-100169Frisco, TX N208NSShield Ai V-BAT · S/N VB-100170Frisco, TX N220XBShield Ai X-BAT · S/N XB-001Frisco, TX N224VBMartin Uav V-BAT · S/N VBP-100024Frisco, TX N2262VShield Ai V-BAT · S/N VB-100175Frisco, TX N2269AShield Ai V-BAT · S/N VB-100176Frisco, TX N226WSShield Ai V-BAT · S/N VB-100171Frisco, TX N226XSShield Ai V-BAT · S/N VB-100178Frisco, TX N226YSShield Ai V-BAT · S/N VB-100179Frisco, TX N226ZVShield Ai V-BAT · S/N VB-100177Frisco, TX N2271VShield Ai V-BAT · S/N VB-100181Frisco, TX N2273AShield Ai V-BAT · S/N VB-100187Frisco, TX N2275AShield Ai V-BAT · S/N VB-100189Frisco, TX N227LVShield Ai V-BAT · S/N VB-100184Frisco, TX N227MVShield Ai V-BAT · S/N VB-100193Frisco, TX

Back to Shield Ai Inc