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.
N420AWCsi Aviation Inc · Killeen, TXN421ZWAir Wisconsin Airlines LLC · Appleton, WIN423AKKm Operations LLC · Alpharetta, GAN423AWAir Wisconsin Airlines LLC · Appleton, WIN424AWAir Wisconsin Airlines LLC · Appleton, WIN425AWCsi Aviation Inc · Killeen, TXN426AWSpire Aviation II LLC · Mooresville, NCN426PFFlorida Challenger Acquisition LLC · Clearwater, FLN427ZWAir Wisconsin Airlines LLC · Appleton, WIN428AWUmb Bank Na Trustee · Salt Lake City, UTN429AWSpire Aviation II LLC · Mooresville, NCN429WGLaufer Wayne L · Fort Myers, FLN430AWAir Wisconsin Airlines LLC · Appleton, WIN430SWSkywest Airlines Inc · St George, UTN431AWAir Wisconsin Airlines LLC · Appleton, WIN432AWAir Wisconsin Airlines LLC · Appleton, WIN433AWAir Wisconsin Airlines LLC · Appleton, WIN433SWBank Of Utah Trustee · Salt Lake City, UTN434AWAir Wisconsin Airlines LLC · Appleton, WIN435AWCsi Aviation Inc · Killeen, TXN435SARi Cl600 LLC · Beverly, MAN436AWAir Wisconsin Airlines LLC · Appleton, WIN436DMShooter And Butts Aviation LLC · Sheridan, WYN438AWCsi Aviation Inc · Killeen, TXN438SWCorporate Flight Management Inc DBA · Smyrna, TNN439AWCsi Aviation Inc · Killeen, TXN439SWBank Of Utah Trustee · Salt Lake City, UTN440AWAir Wisconsin Airlines LLC · Appleton, WIN440SWSkywest Airlines Inc · Saint George, UTN441SWSkywest Airlines Inc · St George, UTN441ZWUmb Bank Na Trustee · Salt Lake City, UTN442AWAir Wisconsin Airlines LLC · Appleton, WIN442SWSkywest Airlines Inc · St George, UTN443AWAir Wisconsin Airlines LLC · Appleton, WIN444CZPelo Aviation LLC · Miami, FLN444ZWUmb Bank Na Trustee · Salt Lake City, UTN445AWAir Wisconsin Airlines LLC · Appleton, WIN445SWSkywest Airlines Inc · Saint George, UTN446AWAir Wisconsin Airlines LLC · Appleton, WIN446SWSkywest Airlines Inc · Saint George, UTN447AWAir Wisconsin Airlines LLC · Appleton, WIN447SWSkywest Airlines Inc · St George, UTN448AWAir Wisconsin Airlines LLC · Appleton, WIN448SWSkywest Airlines Inc · St George, UTN449AWAir Wisconsin Airlines LLC · Appleton, WIN449SWSkywest Airlines Inc · St George, UTN44UAShiloh International Inc · Orland Park, ILN450AWAir Wisconsin Airlines LLC · Appleton, WIN451AWAir Wisconsin Airlines LLC · Appleton, WIN452AWSpire Aviation II LLC · Mooresville, NC
Back to GE CF34 series