OpenAirDocs.org
Aircraft Section

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 = 'AIRCRAFT SECTION' OR list_contains(g.other_registrant_names, 'AIRCRAFT SECTION')
  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.

N111SPBell 206L-3 · S/N 51325Built 1990 · Lansing, MI · Co-owner with State Of MichiganN243TXPilatus PC-12/47E · S/N 1328Built 2012 · Austin, TX · Co-owner with Texas Department Of Public SafetyN4617ECessna 182R · S/N 18268251Built 1982 · Lansing, MI · Co-owner with State Of MichiganN54741Piper PA-18-150 · S/N 18-7609052Built 1976 · Anchorage, AK · Co-owner with State Of AlaskaN5582CPiper PA-18-150 · S/N 18-8473Anchorage, AK · Co-owner with Alaska Department Of Public SafetyN7051Piper PA-18-150 · S/N 18-2932Built 1953 · Anchorage, AK · Co-owner with State Of AlaskaN7054Piper PA-18-150 · S/N 18-8915Built 1971 · Anchorage, AK · Co-owner with State Of AlaskaN7055Piper PA-18 · S/N 18-8916Built 1971 · Anchorage, AK · Co-owner with State Of AlaskaN7056Piper PA-18 · S/N 18-8917Built 1971 · Anchorage, AK · Co-owner with State Of AlaskaN70714Piper PA-18-150 · S/N 18-7909114Built 1979 · Anchorage, AK · Co-owner with State Of AlaskaN70715Cessna 208 · S/N 20800182Built 1990 · Anchorage, AK · Co-owner with State Of AlaskaN7085Piper PA-18-150 · S/N 18-8069Built 1963 · Anchorage, AK · Co-owner with State Of AlaskaN82732Piper PA-18-150 · S/N 18-7709182Built 1977 · Anchorage, AK · Co-owner with State Of AlaskaN82735Piper PA-18-150 · S/N 18-7709183Built 1977 · Anchorage, AK · Co-owner with State Of AlaskaN82736Piper PA-18-150 · S/N 18-7709184Built 1977 · Anchorage, AK · Co-owner with State Of AlaskaN9380NCessna A185F · S/N 18504344Built 1981 · Anchorage, AK · Co-owner with Alaska Department Of Public SafetyN9452NCessna A185F · S/N 18504359Built 1981 · Anchorage, AK · Co-owner with Alaska Department Of Public Safety
Back to Aircraft Section