OpenAirDocs.org
Collum Aviation LLC

Registered aircraft · 19

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 = 'COLLUM AVIATION LLC' OR list_contains(g.other_registrant_names, 'COLLUM AVIATION LLC')
  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.

N2510GChampion 7ECA · S/N 403Built 1967 · Milton, FLN2YPPiper PA-30 · S/N 30-452Milton, FLN36516Piper PA-32RT-300T · S/N 32R-7887048Built 1978 · Milton, FLN38599Piper PA-28-161 · S/N 28-7716271Milton, FLN4122JPiper PA-28-140 · S/N 28-22440Built 1966 · Milton, FLN422SMPiper PA-28-161 · S/N 28-8116127Milton, FLN4264EAeronca 7AC · S/N 7AC-7161Built 1947 · Milton, FLN43PFPiper PA-28-161 · S/N 28-7916362Built 1979 · Milton, FLN5768FPiper PA-28-140 · S/N 28-25072Built 1968 · Milton, FLN6670VBellanca 17-30 · S/N 30021Milton, FLN7166YPiper PA-30 · S/N 30-187Built 1963 · Milton, FLN7690SBellanca 8GCBC · S/N 224-76Built 1976 · Milton, FLN802RCPiper PA-28R-180 · S/N 28R-30299Built 1967 · Milton, FLN8548Bellanca 8KCAB · S/N 72-73Built 1973 · Milton, FLN8664VBellanca 8GCBC · S/N 169-75Built 1975 · Milton, FLN8687VBellanca 8KCAB · S/N 184-75Built 1975 · Milton, FLN86928Bellanca 8GCBC · S/N 32-74Built 1974 · Milton, FLN86959Bellanca 7ECA · S/N 1029-74Built 1974 · Milton, FLN95997Taylorcraft BC12-D · S/N 8297Built 1946 · Milton, FL
Back to Collum Aviation LLC