Skip to content

GE CF6-50 series

Registered aircraft · 9

Aircraft with this engine in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE engine_model_code IN ('30018')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('30018')
ORDER BY 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.

N17085Bc Aircraft Leasing LLC · Albuquerque, NMBuilt 1975 · S/N 47957 N303FEFederal Express Corporation · Memphis, TNBuilt 1973 · S/N 46802 N307FEFederal Express Corp · Memphis, TNBuilt 1986 · S/N 48291 N316FEFederal Express Corp · Memphis, TNBuilt 1988 · S/N 48314 N330AUProject Orbis International Inc · New York, NYBuilt 1973 · S/N 46800 N503AEAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 10021 N522AXBc Aircraft Leasing LLC · Albuquerque, NMBuilt 1988 · S/N 48315 N917KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 46917 N928KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 47928

Back to GE CF6-50 series