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.
N907SALead And Steel 2 LLC · Fountain Valley, CAN907WRIal Corp · Lewes, DEFirst renewal noticeN908EVSkywest Airlines Inc · St George, UTN908FJSkywest Airlines Inc · St George, UTN908SWSkywest Airlines Inc · St George, UTN909EVSkywest Airlines Inc · St George, UTN909SWSkywest Airlines Inc · Saint George, UTN910EVSkywest Airlines Inc · St George, UTN910FJSkywest Airlines Inc · Saint George, UTN910JRegistered aircraftN910SWSkywest Airlines Inc · St George, UTN911FJSkywest Airlines Inc · Saint George, UTN912EVSkywest Airlines Inc · St George, UTN912FJSkywest Airlines Inc · St George, UTN912SWSkywest Airlines Inc · St George, UTN913EVSkywest Airlines Inc · St George, UTN914EVSkywest Airlines Inc · St George, UTN915EVSkywest Airlines Inc · St George, UTN916EVSkywest Airlines Inc · St George, UTN916SWSkywest Ailines Inc · St George, UTN917EVSkywest Airlines Inc · Saint George, UTN918FJSkywest Airlines Inc · St George, UTN919EVSkywest Airlines Inc · St George, UTN919FJSkywest Airlines Inc · St George, UTN919SWCorporate Flight Management Inc DBA · Smyrna, TNN919VEOrlando Plane Partners LLC · Orlando, FLN91KHRhema Bible Church Inc · Broken Arrow, OKN920EVSkywest Airlines Inc · St George, UTN920FJSkywest Airlines Inc · St George, UTN920SWCorporate Flight Management Inc DBA · Smyrna, TNN921EVSkywest Airlines Inc · St George, UTN921FJBank Of Utah Trustee · Salt Lake City, UTN922EVSkywest Airlines Inc · St George, UTN922FJBank Of Utah Trustee · Salt Lake City, UTN923EVSkywest Airlines Inc · St George, UTN923FJBank Of Utah Trustee · Salt Lake City, UTN923SWSkywest Airlines Inc · St George, UTN924FJBank Of Utah Trustee · Salr Lake City, UTN924SWSkywest Airlines Inc · St George, UTN925EVSkywest Airlines Inc · St George, UTN925FJBank Of Utah Trustee · Salt Lake City, UTN925SWCorporate Flight Management Inc DBA · Smyrna, TNN926ECJcpe LLC · Boston, MAN926EVSkywest Airlines Inc · St George, UTN926LRBank Of Utah Trustee · Salt Lake City, UTN926SSJcpe LLC · Boston, MAN926SWSkywest Airlines Inc · St George, UTN927EVFrontera Flight Holdings Inc · Dover, DEN927LRBank Of Utah Trustee · Salt Lake City, UTN927SWSkywest Airlines Inc · St George, UT
Back to GE CF34 series