OpenAirDocs.org
Kitty Hawk Corp

Registered aircraft · 22

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 = 'KITTY HAWK CORP' OR list_contains(g.other_registrant_names, 'KITTY HAWK CORP')
  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.

N239HVKitty Hawk HEAVISIDE 2 · S/N H2.2-009Palo Alto, CAN240HVKitty Hawk HEAVISIDE 2 · S/N H2.2-010Palo Alto, CAN241HVKitty Hawk HEAVISIDE 2 · S/N H2.2-011Palo Alto, CAN242HVKitty Hawk HEAVISIDE 2 · S/N H2.2-012Palo Alto, CAN243HVKitty Hawk HEAVISIDE 2 · S/N H2.2-013Palo Alto, CAN244HVKitty Hawk HEAVISIDE 2 · S/N H2.2-014Palo Alto, CAN245HVKitty Hawk HEAVISIDE 2 · S/N H2.2-015Palo Alto, CAN246HVKitty Hawk HEAVISIDE 2 · S/N H2.2-016Palo Alto, CAN247HVKitty Hawk HEAVISIDE 2 · S/N H2.2-017Palo Alto, CAN248HVKitty Hawk HEAVISIDE 2 · S/N H2.2-018Palo Alto, CAN901KHKitty Hawk K1 · S/N K1-001Palo Alto, CAN902KHKitty Hawk K1 · S/N K1-002Palo Alto, CAN903KHKitty Hawk K1 · S/N K1-003Palo Alto, CAN906KHKitty Hawk K1 · S/N K1-006Palo Alto, CAN908KHKitty Hawk K1 · S/N K1-007Palo Alto, CAN910KHKitty Hawk K1 · S/N K1-009Palo Alto, CAN914KHKitty Hawk HEAVISIDE 2 · S/N H2.2-020Palo Alto, CAN915KHKitty Hawk HEAVISIDE 2 · S/N H2.2-021Palo Alto, CAN917KHKitty Hawk HEAVISIDE 2 · S/N H2.2-023Palo Alto, CAN918KHKitty Hawk HEAVISIDE 2 · S/N H2.2-024Palo Alto, CAN921KHKitty Hawk HEAVISIDE 2 · S/N H2.2-025Palo Alto, CAN927KHKittyhawk KHP-4 · S/N KHP-4-004Palo Alto, CA
Back to Kitty Hawk Corp