Arrow Trading Inc
Earlier aircraft under this name · 44
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 = 'ARROW TRADING INC' OR list_contains(d.other_registrant_names, 'ARROW TRADING INC') 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 = 'ARROW TRADING INC' OR list_contains(d.other_registrant_names, 'ARROW TRADING INC') 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.
N209AWIsrael Aircraft Industries GULFSTREAM G150 · S/N 209N168KTAgustawestland A109E · S/N 11831N120DJLearjet 45 · S/N 2039N775ATCessna 525A · S/N 525A0406N482HBBell Helicopter Textron Canada 429 · S/N 57090N210ACessna 210M · S/N 21062082N6451NCessna 210N · S/N 21063026N200JMRobinson Helicopter R44 II · S/N 13122N45149Robinson Helicopter R66 · S/N 0065N787RPPiper PA 46-350P · S/N 4636350N775ATAgusta AW109SP · S/N 22229N312HCPiper PA-32R-301T · S/N 3257095N789ATAgusta A109S · S/N 22106N370JMRobinson Helicopter R44 II · S/N 12560N771PLAgusta A109E · S/N 11744N6QVAgusta A109E · S/N 11219N4495MRobinson Helicopter R44 II · S/N 12670N44982Robinson Helicopter R44 II · S/N 12964N6434QCessna 182T · S/N 18281410N44947Robinson Helicopter R44 II · S/N 12896N22YACirrus Design SR20 · S/N 1209N783AEAmerican Eurocopter AS350B2 · S/N 4764N44405Robinson Helicopter R44 II · S/N 12734N799THRobinson Helicopter R44 II · S/N 11887N44434Robinson Helicopter R44 II · S/N 12782N44536Robinson Helicopter R44 II · S/N 12783N4332BRobinson Helicopter R44 II · S/N 12822N4316TRobinson Helicopter R44 II · S/N 12459N3160GRobinson Helicopter R44 II · S/N 11512N32211Cessna 208B · S/N 208B0907N517JSEurocopter AS 350 B3 · S/N 3786N525CZCessna 525 · S/N 5250120N80WPBeech F90 · S/N LA-228N4881YPiper PA-25-260 · S/N 25-4685N57836Piper PA-36-300 · S/N 36-7760008N2AHAgusta A109E · S/N 11020N121ADEurocopter AS 350 BA · S/N 2875N771ATAgusta A109C · S/N 7662N535RJRobinson Helicopter R22 BETA · S/N 1183N707MMRobinson Helicopter R22 BETA · S/N 2653N40AGBell 206B · S/N 1177N346BCS N I A S AS350D ASTAR · S/N 1470N113TTBeech B90 · S/N LJ460N917JHBell 206L-3 · S/N 51572
Back to Arrow Trading Inc