OpenAirDocs.org
Omega Air Inc

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

N141WEDouglas DC-10-40F · S/N 46661San Antonio, TXN454PCBoeing 707-321B · S/N 18839San Antonio, TXN623RHBoeing 707-338C · S/N 19623San Antonio, TXN624RHBoeing 707-338C · S/N 19624Built 1968 · San Antonio, TXN706PCBoeing 707-323B · S/N 20177San Antonio, TXN707BNBoeing 707-3L6B · S/N 21049San Antonio, TXN707CABoeing 707-351B · S/N 18586San Antonio, TXN8201Douglas DC-10-30F · S/N 48201Selma, TXN8205Mcdonnell Douglas DC-10-30F · S/N 48205Selma, TXN8209Mcdonnell Douglas DC-10-30F · S/N 48209Selma, TXN8222Mcdonnell Douglas DC-10-30F · S/N 48222Selma, TXN82247Mcdonnell Douglas DC-10-30F · S/N 48247Selma, TXN823VVDouglas DC-10-40 · S/N 47823San Antonio, TXN8249Mcdonnell Douglas DC-10-30F · S/N 48249Selma, TXN824VVDouglas DC-10-40 · S/N 47824San Antonio, TXN826VVDouglas DC-10-40 · S/N 47826San Antonio, TXN8306Mcdonnell Douglas DC-10-30F · S/N 48306Selma, TXN8308Mcdonnell Douglas DC-10-30F · S/N 48308Selma, TXN8310Mcdonnell Douglas DC-10-30F · S/N 48310Selma, TXN852VDouglas DC-10-40 · S/N 47852Built 1980 · San Antonio, TXN853VVDouglas DC-10-40 · S/N 47853San Antonio, TXN9218Mcdonnell Douglas DC-10-30F · S/N 48218Selma, TX
Back to Omega Air Inc