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 ('30052')
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 ('30052')
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.
N546GJSkywest Airlines Inc · Saint George, UTN547GJSkywest Airlines Inc · St George, UTN548GJSkywest Airlines Inc · St George, UTN549GJSkywest Airlines Inc · St George, UTN550GJUnited Airlines Inc · Chicago, ILN551GJSkywest Airlines Inc · St George, UTN552GJSkywest Airlines Inc · St George, UTN553GJSkywest Airlines Inc · St George, UTN554GJSkywest Airlines Inc · St George, UTN556GJUnited Airlines Inc · Chicago, ILN557GJUnited Airlines Inc · Chicago, ILN559GJUnited Airlines Inc · Chicago, ILN562GJUnited Airlines Inc · Chicago, ILN563GJUnited Airlines Inc · Chicago, ILN564GJUnited Airlines Inc · Chicago, ILN565GJUnited Airlines Inc · Chicago, ILN566GJUnited Airlines Inc · Chicago, ILN568GJUnited Airlines Inc · Chicago, ILN569GJUnited Airlines Inc · Chicago, ILN570GJSkywest Airlines Inc · Saint George, UTN571GJSkywest Airlines Inc · Saint George, UTN572GJSky West Airlines Inc · Saint George, UTN573GJSky West Airlines Inc · Saint George, UTN574GJSkywest Airlines Inc · Saint George, UTN575GJSkywest Airlines Inc · Saint George, UTN576GJUnited Airlines Inc · Chicago, ILN577GJUnited Airlines Inc · Chicago, ILN578GJUnited Airlines Inc · Chicago, ILN579GJUnited Airlines Inc · Chicago, ILN580GJUnited Airlines Inc · Chicago, ILN583GJUnited Airlines Inc · Chicago, ILN587GJUnited Airlines Inc · Chicago, ILN603SKSkywest Airlines Inc · St George, UTN604SKSkywest Airlines Inc · St George, UTN606SKSkywest Airlines Inc · Saint George, UTN607SKSkywest Airlines Inc · Saint George, UTN608SKSkywest Airlines Inc · Saint George, UTN630SKSkywest Airlines Inc · St George, UTN631SKSkywest Airlines Inc · St George, UTN632SKSkywest Airlines Inc · St George, UTN633SKSkywest Airlines Inc · St George, UTN682SKSkywest Airlines Inc · St George, UTN685SKSkywest Airlines Inc · Saint George, UTN689SKSkywest Airlines Inc · St George, UTN691SKSkywest Airlines Inc · St George, UTN738SKSkywest Airlines Inc · Saint George, UTN758SKSkywest Airlines Inc · Saint George, UTN760SKSkywest Airlines Inc · Saint George, UTN762SKSkywest Airlines Inc · Saint George, UTN763SKSkywest Airlines Inc · Saint George, UT
Back to GE CF34-8C5B1