OpenAirDocs.org
Souther Field Aviation Inc

Registered aircraft · 17

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 = 'SOUTHER FIELD AVIATION INC' OR list_contains(g.other_registrant_names, 'SOUTHER FIELD AVIATION 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.

N1009LAir Tractor AT-502 · S/N 502-0036Built 1989 · Americus, GAN1036WAir Tractor AT-502 · S/N 502-0041Built 1989 · Americus, GAN210MECessna T210L · S/N 21061123Americus, GAN3982QCessna 172L · S/N 17260082Built 1971 · Americus, GAN4336MCessna A188B · S/N 18802472TBuilt 1975 · Americus, GAN4422SAir Tractor AT-301 · S/N 301-0082Americus, GAN4849QCessna A188B · S/N 18802585TBuilt 1976 · Americus, GAN4930RCessna A188B · S/N 18802447TBuilt 1975 · Americus, GAN53319Cessna A188B · S/N 18801758TFirst renewal noticeAmericus, GAN5531ACessna T210N · S/N 21063484Americus, GAN758BLPiper PA-34-200 · S/N 34-7350318Americus, GAN82656Piper PA-36-300 · S/N 36-7760134First renewal noticeBuilt 1977 · Americus, GAN8421VRockwell International S-2R · S/N 2181RAmericus, GAN8999GCessna A188B · S/N 18801344First renewal noticeBuilt 1973 · Americus, GAN902XCWinter J T/ Johnson W KITFOX III · S/N 907Built 1992 · Americus, GAN92JAThrush S2R-T34 · S/N T34-505DCBuilt 2020 · Americus, GAN9837GCessna A188B · S/N 18801613TFirst renewal noticeBuilt 1974 · Americus, GA
Back to Souther Field Aviation Inc