Skip to content

Anduril Industries Inc

Registered aircraft · 426

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 = 'ANDURIL INDUSTRIES INC' OR list_contains(g.other_registrant_names, 'ANDURIL INDUSTRIES 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 = 'ANDURIL INDUSTRIES INC' OR list_contains(g.other_registrant_names, 'ANDURIL INDUSTRIES 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 = 'ANDURIL INDUSTRIES INC' OR list_contains(g.other_registrant_names, 'ANDURIL INDUSTRIES 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.

N103JWAnduril Industries CPJ-100 · S/N 71Costa Mesa, CA N106AWAnduril Industries ROADRUNNER · S/N 3224Costa Mesa, CA N107AAAnduril Industries FALCON · S/N 630Costa Mesa, CA N108AWAnduril Industries ROADRUNNER · S/N 3225Costa Mesa, CA N108RRAnduril Industries ROADRUNNER · S/N 3119Costa Mesa, CA N117RRAnduril Industries ROADRUNNER · S/N 3120Costa Mesa, CA N118AWAnduril Industries ROADRUNNER · S/N 3226Costa Mesa, CA N121RRAnduril Industries ROADRUNNER · S/N 3121Costa Mesa, CA N126JWAnduril Industries BARRACUDA 100 · S/N PTV-09Costa Mesa, CA N128AWAnduril Industries ROADRUNNER · S/N 3227Costa Mesa, CA N131JWAnduril Industries GHOST · S/N 4430Costa Mesa, CA N132RRAnduril Industries ROADRUNNER · S/N 3118Costa Mesa, CA N133RRAnduril Industries ROADRUNNER · S/N 3123Costa Mesa, CA N134JWAnduril Industries GHOST · S/N 4436Costa Mesa, CA N135AWAnduril Industries ROADRUNNER · S/N 3228Costa Mesa, CA N138AAAnduril Industries FALCON · S/N 631Costa Mesa, CA N141RRAnduril Industries ROADRUNNER · S/N 3124Costa Mesa, CA N144RRAnduril Industries ROADRUNNER · S/N 3125Costa Mesa, CA N145RRAnduril Industries ROADRUNNER · S/N 3126Costa Mesa, CA N149AAAnduril Industries FALCON · S/N 632Costa Mesa, CA N151RRAnduril Industries ROADRUNNER · S/N 3122Costa Mesa, CA N158AAAnduril Industries FALCON · S/N 633Costa Mesa, CA N161RRAnduril Industries ROADRUNNER · S/N 3127Costa Mesa, CA N164PLAnduril Industries ROADRUNNER · S/N 3203Costa Mesa, CA N192RRAnduril Industries ROADRUNNER · S/N 3128Costa Mesa, CA N203RRAnduril Industries ROADRUNNER · S/N 3129Costa Mesa, CA N204RRAnduril Industries ROADRUNNER · S/N 3130Costa Mesa, CA N205RRAnduril Industries ROADRUNNER · S/N 3131Costa Mesa, CA N209RRAnduril Industries ROADRUNNER · S/N 3132Costa Mesa, CA N216AAAnduril Industries BARRACUDA 100 · S/N BTV-03Costa Mesa, CA N216RRAnduril Industries ROADRUNNER · S/N 3133Costa Mesa, CA N219AAAnduril Industries BARRACUDA 100 · S/N BTV-04Costa Mesa, CA N219RRAnduril Industries ROADRUNNER · S/N 3134Costa Mesa, CA N221RRAnduril Industries ROADRUNNER · S/N 3135Costa Mesa, CA N223AAAnduril Industries BARRACUDA 100 · S/N BTV-05Costa Mesa, CA N223RRAnduril Industries ROADRUNNER · S/N 3136Costa Mesa, CA N228RRAnduril Industries ROADRUNNER · S/N 3137Costa Mesa, CA N230RRAnduril Industries ROADRUNNER · S/N 3138Costa Mesa, CA N233RRAnduril Industries ROADRUNNER · S/N 3139Costa Mesa, CA N235RRAnduril Industries ROADRUNNER · S/N 3140Costa Mesa, CA N237AAAnduril Industries BARRACUDA 100 · S/N BTV-02Costa Mesa, CA N238AAAnduril Industries CPJ-100 · S/N 80Costa Mesa, CA N248AAAnduril Industries CPJ-100 · S/N 81Costa Mesa, CA N250PLAnduril Industries ROADRUNNER · S/N 3205Costa Mesa, CA N253AAAnduril Industries CPJ-100 · S/N 82Costa Mesa, CA N259AAAnduril Industries CPJ-100 · S/N 88Costa Mesa, CA N262PLAnduril Industries ROADRUNNER · S/N 3206Costa Mesa, CA N265RRAnduril Industries ROADRUNNER · S/N 3061Costa Mesa, CA N267RRAnduril Industries ROADRUNNER · S/N 3067Costa Mesa, CA N268AAAnduril Industries CPJ-100 · S/N 90Costa Mesa, CA

Back to Anduril Industries Inc