OpenAirDocs.org
Kingdom Air Corps

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 = 'KINGDOM AIR CORPS' OR list_contains(g.other_registrant_names, 'KINGDOM AIR CORPS')
  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.

N1419SCessna 182P · S/N 18264975Built 1976 · Sutton, AKN22970Cessna 150H · S/N 15068651Built 1968 · Sutton, AKN2580JCessna 150E · S/N 15061080Built 1964 · Sutton, AKN2745EAeronca 7AC · S/N 7AC-6326Built 1946 · Sutton, AKN33JMPiper PA-28-235 · S/N 28-10305Built 1964 · Sutton, AKN433WCessna 170B · S/N 25962Built 1953 · Sutton, AKN4883DCessna 182A · S/N 34983Built 1958 · Sutton, AKN488ECessna 152 · S/N 15279654Built 1977 · Sutton, AKN5137HPiper PA-14 · S/N 14-147Sutton, AKN54459Piper J5B · S/N 5-928Sutton, AKN591PHMooney M20F · S/N 670041Built 1966 · Sutton, AKN6169GCessna 150K · S/N 15071669Built 1969 · Sutton, AKN75740Cessna 172N · S/N 17267917Built 1976 · Sutton, AKN782SNCessna 172M · S/N 17261341Built 1973 · Sutton, AKN803NGCessna 140 · S/N 9689Built 1946 · Sutton, AKN8316TCessna 175C · S/N 17557016Built 1961 · Sutton, AKN8401JCessna 150G · S/N 15066301Built 1967 · Sutton, AKN84830Aeronca 7AC · S/N 7AC-3546Built 1946 · Sutton, AKN9075ACessna 170A · S/N 18834Built 1949 · Sutton, AK
Back to Kingdom Air Corps