Skip to content

Kalitta Charters LLC

Registered aircraft · 51

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

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 CHARTERS LLC' OR list_contains(g.other_registrant_names, 'KALITTA CHARTERS LLC') ORDER BY g.n_number

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

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 CHARTERS LLC' OR list_contains(g.other_registrant_names, 'KALITTA CHARTERS LLC')
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N100ASDassault/Sud FAN JET FALCON · S/N 274Built 1969 · Ypsilanti, MI N163CKGates Learjet 35A · S/N 163Built 1978 · Ypsilanti, MI N192CKDassault Breguet FALCON 20-D · S/N 192Ypsilanti, MI N217CKGates Learjet 35A · S/N 217Built 1978 · Ypsilanti, MI N220CKGates Learjet 35A · S/N 120Built 1977 · Ypsilanti, MI N226CKDassault/Sud FAN JET FALCON SER D · S/N 226Built 1970 · Ypsilanti, MI N227CKDassault/Sud FAN JET FALCON · S/N 227Built 1970 · Ypsilanti, MI N229CKDassault/Sud FAN JET FALCON SER D · S/N 229Built 1970 · Ypsilanti, MI N237CKGates Learjet 35A · S/N 237Built 1979 · Ypsilanti, MI N240CKDassault/Sud FAN JET FALCON · S/N 24Built 1966 · Ypsilanti, MI N264CKGates Learjet 35A · S/N 264Built 1979 · Ypsilanti, MI N273LPLearjet 45 · S/N 185Built 2001 · Ypsilanti, MI N290CKLearjet 35A · S/N 090Built 1976 · Ypsilanti, MI N295CKLearjet 35A · S/N 295Built 1980 · Ypsilanti, MI N298CKGates Learjet 35A · S/N 298Built 1980 · Ypsilanti, MI N325NWGates Learjet 35A · S/N 325Built 1980 · Ypsilanti, MI N352CKLearjet 35A · S/N 313Built 1980 · Ypsilanti, MI N353CKGates Learjet 35A · S/N 081Built 1976 · Ypsilanti, MI N354CKGates Learjet 35A · S/N 353Built 1980 · Ypsilanti, MI N355CKGates Lear Jet 35 · S/N 062Built 1976 · Ypsilanti, MI N357CKGates Learjet 35A · S/N 323Built 1980 · Ypsilanti, MI N35WLGates Learjet 35A · S/N 438Built 1981 · Ypsilanti, MI N396CKDassault/Sud FAN JET FALCON SER F · S/N 396Built 1979 · Ypsilanti, MI N431CKGates Learjet 35A · S/N 431Built 1981 · Ypsilanti, MI N438SJDassault-Breguet MYSTERE FALCON 20-F5 · S/N 438Built 1981 · Ypsilanti, MI N451CKLearjet 45 · S/N 063Built 1999 · Ypsilanti, MI N452CKLearjet 45 · S/N 105Built 2000 · Ypsilanti, MI N453CKLearjet 45 · S/N 187Built 2001 · Ypsilanti, MI N45KXLearjet 45 · S/N 233Built 2003 · Ypsilanti, MI N47LPDassault-Breguet FALCON 20 · S/N 457Built 1981 · Ypsilanti, MI N581CKBeech 58 · S/N TH-1183Built 1980 · Ypsilanti, MI N583CKBeech 58 · S/N TH-1291Built 1981 · Ypsilanti, MI N584CKBeech 58 · S/N TH-319Built 1973 · Ypsilanti, MI N585CKBeech 58 · S/N TH-1299Built 1981 · Ypsilanti, MI N586CKBeech 58 · S/N TH-1084Ypsilanti, MI N587CKBeech 58 · S/N TH-1189Built 1980 · Ypsilanti, MI N588CKBeech 58 · S/N TH-965Built 1978 · Ypsilanti, MI N600CDDassault-Breguet MYSTERE FALCON 20-F5 · S/N 377Built 1978 · Ypsilanti, MI N644CKLearjet 35A · S/N 644Built 1988 · Ypsilanti, MI N717AJGates Learjet 35A · S/N 183Ypsilanti, MI N71CKGates Lear Jet 36A · S/N 035Built 1977 · Ypsilanti, MI N73CKGates Learjet 35A · S/N 092Ypsilanti, MI N76CKGates Learjet 35A · S/N 076Built 1976 · Ypsilanti, MI N808CKDassault/Sud FAN JET FALCON · S/N 108Built 1967 · Ypsilanti, MI N820CKDassault/Sud FAN JET FALCON · S/N 120Built 1967 · Ypsilanti, MI N824CKGates Learjet 35A · S/N 124Built 1977 · Ypsilanti, MI N870CKGates Learjet 35A · S/N 170Built 1978 · Ypsilanti, MI N881MJLearjet 45 · S/N 076Built 2000 · Ypsilanti, MI N905CKGates Lear Jet 36 · S/N 005Built 1975 · Ypsilanti, MI N913CKGates Lear Jet 35 · S/N 013Built 1975 · Ypsilanti, MI

Back to Kalitta Charters LLC