Skip to content

Registered aircraft · 10

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 ('30085')
  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 ('30085')
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.

N120JMSouth Aircraft Leasing Inc · Wilmington, DEBuilt 1988 · S/N 48311 N235ULAircraft Endeavors LLC · San Antonio, TXBuilt 1976 · S/N 46956 N264DEAircraft Endeavors LLC · San Antonio, TXBuilt 1978 · S/N 46985 N304FEFederal Express Corporation · Memphis, TNBuilt 1978 · S/N 46992 N306FEFederal Express Corp · Memphis, TNBuilt 1985 · S/N 48287 N308FEFederal Express Corp · Memphis, TNBuilt 1986 · S/N 48297 N315FEFederal Express Corp · Memphis, TNBuilt 1988 · S/N 48313 N318FEFederal Express Corp · Memphis, TNBuilt 1979 · S/N 46837 N319FEFederal Express Corp · Memphis, TNBuilt 1980 · S/N 47820 N321FEFederal Express Corp · Memphis, TNBuilt 1980 · S/N 47836

Back to GE CF6-50C2