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 ('30015')
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 ('30015')
ORDER BY n_numberRun 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.
N712PSAmerican Airlines Inc · Fort Worth, TXN712SKSkywest Airlines Inc · St George, UTN713EVSkywest Airlines Inc · St George, UTN713JMJp Ashley LLC · Lewes, DEN713SKSkywest Airlines Inc · St George, UTN715SKSkywest Airlines Inc · St George, UTN716BBPinnacle Aviation Group LLC · Wilmington, DEN716EVSkywest Airlines Inc · Saint George, UTN716PSUmb Bank Na Trustee · Salt Lake City, UTN716SKSkywest Airlines Inc · St George, UTN716TMTitan Strong LLC · Staten Island, NYN717EVSkywest Airlines Inc · St George, UTN718EVSkywest Airlines Inc · St George, UTN718PSAmerican Airlines Inc · Fort Worth, TXN718SKSkywest Airlines Inc · St George, UTN719EVSkywest Airlines Inc · St George, UTN719PSAmerican Airlines Inc · Fort Worth, TXN719SKSkywest Airlines Inc · St George, UTN71KRLost Highway Touring Inc · Clarkston, MIN720EVSkywest Airlines Inc · St George, UTN720PSUmb Bank Na Trustee · Salt Lake City, UTN721GChallenger Hc LLC · New York, NYN722EVSkywest Airlines Inc · Saint George, UTN723EVSkywest Airlines Inc · St George, UTN723PSAmerican Airlines Inc · Fort Worth, TXN724EVSkywest Airlines Inc · St George, UTN724SKSkywest Airlines Inc · Saint George, UTN725PSAmerican Airlines Inc · Fort Worth, TXN726RFV-Fee Challenger 604 Aviation LLC · Whippany, NJN726SKSkywest Airlines Inc · Saint George, UTN727SKSkywest Airlines Inc · Saint George, UTN728SKSkywest Airlines Inc · Saint George, UTN730BZRegistered aircraftN730EVSkywest Airlines Inc · St George, UTN730SKSkywest Airlines Inc · Saint George, UTN732SKSkywest Airlines Inc · Saint George, UTN736EEAiles Dargent I LLC · Staten Island, NYN738EVSkywest Airlines Inc · St George, UTN739AEWilmington Trust Co Trustee · Wilmington, DEN740EVSkywest Airlines Inc · St George, UTN740MRWilmington Trust Co Trustee · Wilmington, DEN740SKSkywest Airlines Inc · St George, UTN741EVSkywest Airlines Inc · St George, UTN742SKSkywest Airlines Inc · St George, UTN743SKSkywest Airlines Inc · St George, UTN744EVSkywest Airlines Inc · St George, UTN744SKSkywest Airlines Inc · Saint George, UTN745JBWilmington Trust Co Trustee · Wilmington, DEN745SKSkywest Airlines Inc · Saint George, UTN746SKSkywest Airlines Inc · Saint George, UT
Back to GE CF34 series