Roberts Aircraft Co
Earlier aircraft under this name · 35
Cancelled registrations that named this owner when they ended, newest first.
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'ROBERTS AIRCRAFT CO' OR list_contains(d.other_registrant_names, 'ROBERTS AIRCRAFT CO') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'ROBERTS AIRCRAFT CO' OR list_contains(d.other_registrant_names, 'ROBERTS AIRCRAFT CO') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N357TAEurocopter France AS 350 B3 · S/N 4492N352TAEurocopter AS 350 B3 · S/N 4110N9379SAgusta Aerospace AW119 MKII · S/N 14756N9379KAgusta Aerospace AW119 MKII · S/N 14760N56763Boeing A75N1(PT17) · S/N 751167N512TABell 212 · S/N 30863N3128GAerospatiale SA315B · S/N 2488N49550Aerospatiale SA316B ALOUETTE III · S/N 2271N528RAAerospatiale SA316B ALOUETTE III · S/N 1528N7208LAerospatiale SE3160 ALOUETTE III · S/N 1483N371MHAerospatiale SA330J · S/N 1253N330CCAerospatiale SA330J · S/N 1589N315AVAerospatiale SA315B · S/N 2549N48184Aerospatiale SA316B ALOUETTE III · S/N 1906N48HJAerospatiale SA315B · S/N 2341N62339Aerospatiale SA315B · S/N 2401N929JVEurocopter SA315B · S/N 2361N2128ZAerospatiale SA315B · S/N 062014N316HPAerospatiale SA316B ALOUETTE III · S/N 1539N1521KAerospatiale SA316B ALOUETTE III · S/N 1521N49525Aerospatiale SA315B · S/N 2492N607CDAerospatiale SA315B · S/N 2601N5771LS N I A S AS350D ASTAR · S/N 1343N200HES N I A S AS350D ASTAR · S/N 1073N8099RAerospatiale SA316B ALOUETTE III · S/N 1761N10364Aerospatiale SA316B ALOUETTE III · S/N 1773N537S N I A S SE 3130 ALOUETTE II · S/N 1150N330JAAerospatiale SA330J · S/N 1140N5109CAerospatiale SA316B ALOUETTE III · S/N 2201N5170BAerospatiale SA316B ALOUETTE III · S/N 2206N72036Aerospatiale SE3160 ALOUETTE III · S/N 1488N316TAAerospatiale SA316B ALOUETTE III · S/N 1515N820NAEurocopter AS 350 B3 · S/N 3602N6227MAerospatiale SA315B · S/N 2612N7722AAerospatiale AS350B · S/N 2294
Back to Roberts Aircraft Co