OpenAirDocs.org
Airgo Inc

Registered aircraft · 23

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

N172MSCessna 172M · S/N 17263928Built 1974 · Centralia, ILN2012ECessna 172N · S/N 17271117Built 1978 · Centralia, ILN2204XPiper PA-44-180 · S/N 44-7995281Built 1979 · Centralia, ILN2314ECessna 172N · S/N 17271230Built 1978 · Centralia, ILN3082ECessna 172N · S/N 17271435Built 1978 · Centralia, ILN3168VCessna 150M · S/N 15076407Built 1974 · Cetralia, ILN45247Cessna 150M · S/N 15076804Built 1975 · Centralia, ILN47KWPiper PA-34-200T · S/N 34-7970230Centralia, ILN4859GCessna 172N · S/N 17273406Built 1979 · Centralia, ILN49ATPiper PA-44-180T · S/N 44-8107041Built 1981 · Centralia, ILN5344DCessna 172N · S/N 17272532Built 1979 · Centralia, ILN5381QCessna 150L · S/N 15073281Built 1972 · Centralia, ILN6424KCessna 150M · S/N 15077698Built 1975 · Centralia, ILN66739Cessna 150M · S/N 15076243Built 1974 · Centralia, ILN704JRCessna 150M · S/N 15078652Built 1976 · Centralia, ILN714FFCessna 150M · S/N 15079137Built 1976 · Centralia, ILN714MZCessna 150M · S/N 15079293Built 1977 · Centralia, ILN733WSCessna 172N · S/N 17268612Built 1977 · Centralia, ILN7539UCessna 150M · S/N 15077735Centralia, ILN9347UCessna 150M · S/N 15078296Built 1976 · Centralia, ILN9494UCessna 150M · S/N 15078442Built 1976 · Centralia, ILN9626BCessna 172RG · S/N 172RG0927Built 1981 · Centralia, ILN99141Cessna 172P · S/N 17276409Built 1985 · Centralia, IL
Back to Airgo Inc