Skip to content

Registered aircraft · 258

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

N101FEFederal Express Corp · Memphis, TNBuilt 2013 · S/N 42706 N102FEFederal Express Corp · Memphis, TNBuilt 2013 · S/N 42707 N103FEFederal Express Corp · Memphis, TNBuilt 2013 · S/N 43544 N105FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64055 N106FEFederal Express Corp · Memphis, TNBuilt 2014 · S/N 42709 N107FEFederal Express Corp · Memphis, TNBuilt 2014 · S/N 44377 N108FEFederal Express Corp · Memphis, TNBuilt 2014 · S/N 44378 N109FEFederal Express Corp · Memphis, TNBuilt 2014 · S/N 42710 N110FEFederal Express Corp · Memphis, TNBuilt 2014 · S/N 43542 N112FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 43543 N113FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42711 N114FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42712 N115FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42713 N117FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 44379 N118FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42714 N119FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64057 N120FEFederal Express Corporation · Memphis, TNBuilt 2015 · S/N 44380 N1217AAndromeda Leasing I LLC · Purchase, NYBuilt 1992 · S/N 25865 N121FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 43545 N1229AAndromeda Leasing I LLC · Purchase, NYBuilt 1999 · S/N 28884 N122FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42715 N123FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42716 N124FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 43546 N125FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42717 N126FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42718 N127FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 43547 N128FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 42719 N129FEFederal Express Corp · Memphis, TNBuilt 2015 · S/N 43548 N130FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 42720 N131FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 61205 N1321AAndromeda Leasing I LLC · Purchase, NYBuilt 1995 · S/N 27957 N1327AMsn 26328 LLC · Purchase, NYBuilt 1996 · S/N 26328 N132FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 42721 N133FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 43549 N134FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 43550 N135FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 42722 N136FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64058 N137FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 61206 N1381AMsn 27615 LLC · Purchase, NYBuilt 1997 · S/N 27615 N138FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 42723 N139FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 43538 N1409AMsn 27959 LLC · Purchase, NYBuilt 1996 · S/N 27960 N140FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 43541 N141FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 42724 N1427AAndromeda Leasing I LLC · Purchase, NYBuilt 1996 · S/N 28098 N142FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 42725 N1439AAndromeda Leasing I LLC · Purchase, NYBuilt 1997 · S/N 28495 N143FEFederal Express Corp · Memphis, TNBuilt 2016 · S/N 62497 N144FEFederal Express Corp · Memphis, TNBuilt 2017 · S/N 42726 N146FEFederal Express Corp · Memphis, TNBuilt 2017 · S/N 43551

Back to GE CF6-80C2B6F