OpenAirDocs.org
Kalitta Air LLC

Registered aircraft · 39

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

N242CKBombardier CL-600-2B16(CL601-3R · S/N 5181Built 1995 · Ypsilanti, MIN243CKRaytheon B200 · S/N BB-1596Built 1997 · Ypsilanti, MIN244CKDassault/Sud FAN JET FALCON · S/N 369Built 1977 · Ypsilanti, MIN245CKCanadair CL-600-2B16 · S/N 5139Built 1993 · Ypsilanti, MIN329ZABoeing 747-438 · S/N 32914Built 2003 · Ypsilanti, MIN700CKBoeing 747-4R7F · S/N 25868Built 1997 · Ypsilanti, MIN701CKBoeing 747-4B5F · S/N 26416Built 2000 · Ypsilanti, MIN702CKBoeing 747-4B5F · S/N 26411Built 2000 · Ypsilanti, MIN703CKBoeing 747-412 · S/N 24226Built 1990 · Ypsilanti, MIN705CKBoeing 747-4B5F · S/N 26413Built 2001 · Ypsilanti, MIN706CKBoeing 747-4B5F · S/N 27073Built 2001 · Ypsilanti, MIN707CKBoeing 747-4B5 · S/N 26395Built 1992 · Ypsilanti, MIN708CKBoeing 747-4B5 · S/N 25275Built 1991 · Ypsilanti, MIN709CKBoeing 747-4B5 · S/N 26396Built 1993 · Ypsilanti, MIN710CKBoeing 747-4B5F · S/N 26406Built 1997 · Ypsilanti, MIN712CKBoeing 747-4B5F · S/N 26414Built 2002 · Ypsilanti, MIN713CKBoeing 747-4B5F · S/N 32808Built 2003 · Ypsilanti, MIN715CKBoeing 747-4B5F · S/N 32809Built 2002 · Ypsilanti, MIN716CKBoeing 747-4B5F · S/N 26408Built 1998 · Ypsilanti, MIN740CKBoeing 747-4H6 · S/N 24405Built 1989 · Ypsilanti, MIN741CKBoeing 747-4H6 · S/N 24315Built 1989 · Ypsilanti, MIN742CKBoeing 747-446 · S/N 24424Ypsilanti, MIN743CKBoeing 747-446 · S/N 26350Built 1993 · Ypsilanti, MIN744CKBoeing 747-446 · S/N 26353Built 1993 · Ypsilanti, MIN745CKBoeing 747-446 · S/N 26361Built 1998 · Ypsilanti, MIN760CKBoeing 767-341 · S/N 24753Built 1990 · Ypsilanti, MIN761CKBoeing 767-341 · S/N 24752Built 1989 · Ypsilanti, MIN762CKBoeing 767-3P6 · S/N 26236Built 1992 · Ypsilanti, MIN763CKBoeing 767-3P6 · S/N 26233Built 1993 · Ypsilanti, MIN764CKBoeing 767-3P6 · S/N 26234Built 1994 · Ypsilanti, MIN765CKBoeing 767-3P6 · S/N 26238Built 1992 · Ypsilanti, MIN766CKBoeing 747-481F · S/N 34016Built 2005 · Ypsilanti, MIN767CKBoeing 747-481F · S/N 34017Built 2005 · Ypsilanti, MIN768CKBoeing 747-481F · S/N 34018Ypsilanti, MIN782CKBoeing 747-4HQF · S/N 37304Built 2009 · Ypsilanti, MIN783CKBoeing 767-346 · S/N 24782Built 1990 · Ypsilanti, MIN785CKBoeing 747-4B5 · S/N 26404Built 1997 · Ypsilanti, MIN786CKBoeing 747-4B5 · S/N 26407Built 1998 · Ypsilanti, MIN787CKBoeing 767-346 · S/N 28838Built 1997 · Ypsilanti, MI
Back to Kalitta Air LLC