OpenAirDocs.org
Usda Aphis Ws Atoc

Registered aircraft · 42

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 = 'USDA APHIS WS ATOC' OR list_contains(g.other_registrant_names, 'USDA APHIS WS ATOC')
  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.

N15PQCub Crafters CC18-180 · S/N CC18-0043Built 2010 · Cedar City, UTN2357ZPiper PA-18-150 · S/N 18-8109016Built 1980 · Cedar City, UTN26JKHughes OH-6A · S/N 67-16681Built 1967 · Cedar City, UTN279XCCub Crafters CC19-215 · S/N CC19-0079Built 2023 · Cedar City, UTN3124BBell 206 · S/N 3543Cedar City, UTN3132BBell 206 · S/N 3544Cedar City, UTN313EBBell 206 · S/N 3895Cedar City, UTN313FBBell 206 · S/N 3917Cedar City, UTN332ABHughes 369A · S/N 791231Cedar City, UTN35019MD Helicopters 369FF · S/N 0348FFBuilt 2024 · Cedar City, UTN390XCCub Crafters CC19-215 · S/N CC19-0090Built 2024 · Cedar City, UTN491XCCub Crafters CC19-215 · S/N CC19-0091Built 2024 · Cedar City, UTN5185BHughes OH-6 · S/N 68-17175Cedar City, UTN5187YHughes OH-6 · S/N 6817358Cedar City, UTN58479Hughes 369A (OH-6A) · S/N 67-16036Built 1968 · Cedar City, UTN599XCCub Crafters CC19-215 · S/N CC19-0099Built 2025 · Cedar City, UTN60556MD Helicopters 369FF · S/N 0256FFCedar City, UTN6062MMD Helicopters 369FF · S/N 0262FFCedar City, UTN6063PMD Helicopters 369FF · S/N 0263FFCedar City, UTN6065NMD Helicopters 369FF · S/N 0223FFCedar City, UTN6068TMD Helicopters 369FF · S/N 0215FFCedar City, UTN6100NMD Helicopters 369FF · S/N 0216FFCedar City, UTN6188HHughes OH-6A · S/N 68-17144Cedar City, UTN6637NHughes OH-6A · S/N 6716590Cedar City, UTN6638PHughes OH-6A · S/N 67-16333Cedar City, UTN6638UHughes OH-6A · S/N 6716030Cedar City, UTN6640KHughes OH-6A · S/N 66-16110Cedar City, UTN6640ZHughes OH-6A · S/N 66-16076Cedar City, UTN67001Bell 206B · S/N 5101Built 1993 · Cedar City, UTN67347Bell 206B · S/N 5142Built 1994 · Cedar City, UTN67814Bell 206B · S/N 5209Built 1995 · Cedar City, UTN752Piper PA-18-150 · S/N 18-8219Built 1975 · Cedar City, UTN78XCCub Crafters CC19-215 · S/N CC19-0078Cedar City, UTN8388FHughes 369HS · S/N 760838SCedar City, UTN91187Piper PA-18-150 · S/N 18-8109079Built 1981 · Cedar City, UTN911HUHughes 369A (OH-6A) · S/N 191001Cedar City, UTN916KKBell 206 · S/N 3834Cedar City, UTN917KKBell 206 · S/N 3831Cedar City, UTN918KKBell 206 · S/N 3892Cedar City, UTN919KKBell 206 · S/N 3900Cedar City, UTN920KKBell 206 · S/N 3916Cedar City, UTN9882DPiper PA-18-150 · S/N 18-6904Built 1959 · Cedar City, UT
Back to Usda Aphis Ws Atoc