Skip to content

Registered aircraft · 24

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

N257UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48451 N258UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48416 N260UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48418 N261UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48805 N262UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48806 N263UPUnited Parcel Service Co · Louisville, KYBuilt 1998 · S/N 48782 N264UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 48800 N265UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48803 N415JNAtares Funding LLC · Fisher Island, FLS/N 48415 N512JNAtares Funding LLC · Fisher Island, FLBuilt 1992 · S/N 48512 N513SNM48513 LLC · Esters, FLBuilt 1994 · S/N 48513 N542KDAtares Funding LLC · Fisher Island, FLBuilt 1994 · S/N 48542 N543JNAtares Funding LLC · Fisher Island, FLBuilt 1994 · S/N 48543 N545JNAtares Funding LLC · Miami Beach, FLBuilt 1995 · S/N 48545 N546JNAtares Funding LLC · Fisher Island, FLBuilt 1995 · S/N 48546 N572FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 48755 N573FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 48769 N575FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48500 N581JNMobility Air LLC · Miami, FLBuilt 1994 · S/N 48581 N625FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 48753 N649FEFederal Express Corp · Memphis, TNBuilt 1999 · S/N 48801 N781SNAtares Funding LLC · Fisher Island, FLBuilt 1998 · S/N 48781 N783SNAtares Funding LLC · Fisher Island, FLBuilt 1998 · S/N 48783 N804SNAtares Funding LLC · Miami Beach, FLBuilt 2000 · S/N 48804

Back to GE CF6-80C2D1F