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.
N748EVSkywest Airlines Inc · St George, UTN748RRWilmington Trust Co Trustee · Wilmington, DEN748SKSkywest Airlines Inc · Saint George, UTN750BDWilmington Trust Co Trustee · Wilmington, DEN750EVSkywest Airlines Inc · St George, UTN750SKSkywest Airlines Inc · Saint George, UTN751ABWilmington Trust Co Trustee · Wilmington, DEN751EVSkywest Airlines Inc · St George, UTN751SKSkywest Airlines Inc · Saint George, UTN752SKSkywest Airlines Inc · Saint George, UTN753EVSkywest Airlines Inc · St George, UTN753SKSkywest Airlines Inc · St George, UTN754EVSkywest Airlines Inc · St George, UTN754SKSkywest Airlines Inc · Saint George, UTN755SKSkywest Airlines Inc · Saint George, UTN756SKSkywest Airlines Inc · Saint George, UTN758CCCtb Inc · Milford, INN758EVSkywest Airlines Inc · St George, UTN759EVSkywest Airlines Inc · St George, UTN760EVSkywest Airlines Inc · St George, UTN761NDSkywest Airlines Inc · Saint George, UTN765WTW W Tichenor & Co Inc · San Antonio, TXN767SASlate Aircraft Company LLC · Johnstown, PAN770WWBravo Aviation LLC · Santa Rosa Beach, FLN77195Wells Fargo Trust Co Na Trustee · Salt Lake City, UTN774JGWilmington Trust Co Trustee · Wilmington, DEN776MSWilmington Trust Company Trustee · Wilmington, DEN777GUGug LLC · Doral, FLN778RHWilmington Trust Co Trustee · Wilmington, DEN779RNWilmington Trust Co Trustee · Wilmington, DEN782SMWilmington Trust Co Trustee · Wilmington, DEN783LCWilmington Trust Co Trustee · Wilmington, DEN785BRWilmington Trust Co Trustee · Wilmington, DEN786SMWilmington Trust Co Trustee · Wilmington, DEN7886Polar Bear Express II LLC · Las Vegas, NVN788CJWilmington Trust Co Trustee · Wilmington, DEN789SSWilmington Trust Co Trustee · Wilmington, DEN790MKWilmington Trust Co Trustee · Wilmington, DEN792JBWilmington Trust Co Trustee · Wilmington, DEN794JHWilmington Trust Co Trustee · Wilmington, DEN794SCAloft Aviation Services LLC · Spartanburg, SCN798CCWilmington Trust Co Trustee · Wilmington, DEN7PSInnovation First Transportation Inc · Greenville, TXN800WCKpat LLC · Menlo Park, CAN805AYLogos Aviation Inc · Fort Lauderdale, FLN807DDFalcon Aviation Z LLC · Great Neck, NYN80DXSsc Enterprises LLC · Camarillo, CAN810DWings Of Time LLC · Carlsbad, CAN810GT8ten LLC · Tulsa, OKN810MDUmb Bank Na Trustee · Salt Lake City, UT
Back to GE CF34 series