Skip to content

Registered aircraft · 310

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 = 'NUWAY AG LLC' OR list_contains(g.other_registrant_names, 'NUWAY AG 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 = 'NUWAY AG LLC' OR list_contains(g.other_registrant_names, 'NUWAY AG 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 = 'NUWAY AG LLC' OR list_contains(g.other_registrant_names, 'NUWAY AG 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.

N104NWDJI AGRAS T100 · S/N 0954Dundee, OH N11NUDJI AGRAS T25P · S/N 1147Dundee, OH N134NWDJI AGRAS T100 · S/N 1888Dundee, OH N135NWDJI AGRAS T100 · S/N 1978Dundee, OH N142BCDJI AGRAS T100 · S/N 1030Dundee, OH N164NWDJI AGRAS T100 · S/N 1379Dundee, OH N17NUDJI AGRAS T25P · S/N 1781Dundee, OH N183DCDJI AGRAS T100 · S/N 1448Dundee, OH N206NWDJI AGRAS T100 · S/N 0202Dundee, OH N20NUDJI AGRAS T25P · S/N 0120Dundee, OH N213NUDJI AGRAS T100 · S/N 0621Dundee, OH N221NUDJI AGRAS T100 · S/N 1874Dundee, OH N221NWDJI AGRAS T100 · S/N 1179Dundee, OH N222NUDJI AGRAS T100 · S/N 1062Dundee, OH N223NUDJI AGRAS T100 · S/N 1752Dundee, OH N223NWDJI AGRAS T100 · S/N 0791Dundee, OH N224NUDJI AGRAS T100 · S/N 1050Dundee, OH N224NWDJI AGRAS T100 · S/N 0810Dundee, OH N225NUDJI AGRAS T100 · S/N 1085Dundee, OH N225NWDJI AGRAS T100 · S/N 1489Dundee, OH N226NUDJI AGRAS T100 · S/N 1438Dundee, OH N227NUDJI AGRAS T100 · S/N 1065Dundee, OH N227NWDJI AGRAS T100 · S/N 0384Dundee, OH N228NUDJI AGRAS T100 · S/N 1100Dundee, OH N229NWDJI AGRAS T100 · S/N 1872Dundee, OH N230NUDJI AGRAS T50 · S/N 1589Dundee, OH N230NWDJI AGRAS T100 · S/N 1132Dundee, OH N232NUDJI AGRAS T50 · S/N 1935Dundee, OH N233NUDJI AGRAS T50 · S/N 1495Dundee, OH N234NUDJI AGRAS T100 · S/N 0687Dundee, OH N235NUDJI AGRAS T100 · S/N 1028Dundee, OH N236NUDJI AGRAS T100 · S/N 1885Dundee, OH N237NUDJI AGRAS T100 · S/N 0763Dundee, OH N238NUDJI AGRAS T100 · S/N 1982Dundee, OH N239NUTalos Drones T60X · S/N 1076Dundee, OH N240NUTalos Drones T60X · S/N 1484Dundee, OH N241NUTalos Drones T60X · S/N 0513Dundee, OH N243NUTalos Drones T60X · S/N 1473Dundee, OH N244NUTalos Drones T60X · S/N 1845Dundee, OH N245NUTalos Drones T60X · S/N 1269Dundee, OH N246NUTalos Drones T60X · S/N 1938Dundee, OH N247NUDJI AGRAS T100 · S/N 1007Dundee, OH N249BCDJI AGRAS T100 · S/N 1482Dundee, OH N254NDDJI AGRAS T40 · S/N 1581F574B225M00100STDundee, OH N269BCDJI AGRAS T100 · S/N 1904Dundee, OH N2767Talos Drones TALOS T60X · S/N 2104F7EZB251J00108UMDundee, OH N279BCDJI AGRAS T100 · S/N 1404Dundee, OH N2808NDJI FLYCART 30 · S/N 1581F7C6B23A5001E853Dundee, OH N290VWDJI AGRAS T40 · S/N 1581F574B227400101Q7Dundee, OH N290ZZDJI AGRAS T50 · S/N 1581F6BUB23AG0018Q28Dundee, OH

Back to Nuway Ag LLC