Air Tractor Inc
Registered aircraft · 38
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
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 = 'AIR TRACTOR INC' OR list_contains(g.other_registrant_names, 'AIR TRACTOR 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 = 'AIR TRACTOR INC' OR list_contains(g.other_registrant_names, 'AIR TRACTOR 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.
N194CAAir Tractor AT-802A · S/N 802A-1350N196CFAir Tractor AT-802A · S/N 802A-1277N22ATAir Tractor AT-1002A · S/N 1002A-0002N316LAAir Tractor AT-802A · S/N 802A-1316N335LAAir Tractor AT-802 · S/N 802-1335N344VAAir Tractor AT-802A · S/N 802A-1344N347BMAir Tractor AT-802A · S/N 802A-1347N347REAir Tractor AT-802A · S/N 802A-1331N350DAAir Tractor AT-802A · S/N 802A-1354N3636BAir Tractor AT-502B · S/N 502B-3636N445HAAir Tractor AT-802 · S/N 802-0633N5008YAir Tractor AT-802 · S/N 802-4066N5009PAir Tractor AT-802 · S/N 802-4058N50102Air Tractor AT-802 · S/N 802-4068N50105Air Tractor AT-802 · S/N 802-4059N5011DAir Tractor AT-802A · S/N 802A-1342N5011HAir Tractor AT-802 · S/N 802-4060N5011VAir Tractor AT-502A · S/N 502A-3646N5012GAir Tractor AT-802 · S/N 802-1349N5012LAir Tractor AT-802 · S/N 802-4069N5012TAir Tractor AT-802 · S/N 802-4070N5012XAir Tractor AT-802 · S/N 802-4061N5013FAir Tractor AT-802 · S/N 802-4062N5013MAir Tractor AT-802 · S/N 802-4063N5013VAir Tractor AT-802 · S/N 802-4064N5013ZAir Tractor AT-802 · S/N 802-4065N5014FAir Tractor AT-802 · S/N 802-4067N5014NAir Tractor AT-802A · S/N 802A-1327N514FAAir Tractor AT-802A · S/N 802A-1334N526FAAir Tractor AT-802A · S/N 802A-1338N656FAAir Tractor AT-502B · S/N 502B-3647N780NAAir Tractor AT-802A · S/N 802A-1333N800NZAir Tractor AT-802A · S/N 802A-1323N803MSAir Tractor AT-802A · S/N 802A-1296N818ASAir Tractor AT-802A · S/N 802A-1319N842NFAir Tractor AT-802A · S/N 802A-1332N8509SAir Tractor AT-802A · S/N 802A-0164N893BMAir Tractor AT-802A · S/N 802A-1352
Back to Air Tractor Inc