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 ('30046')
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 ('30046')
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.
N857FDFederal Express Corp · Memphis, TNN858FDFederal Express Corp · Memphis, TNN859FDFederal Express Corp · Memphis, TNN860FDFederal Express Corp · Memphis, TNN861FDFederal Express Corp · Memphis, TNN862FDFederal Express Corp · Memphis, TNN863FDFederal Express Corp · Memphis, TNN864FDFederal Express Corp · Memphis, TNN865FDFederal Express Corp · Memphis, TNN866FDFederal Express Corp · Memphis, TNN867FDFederal Express Corp · Memphis, TNN868FDFederal Express Corp · Memphis, TNN869FDFederal Express Corp · Memphis, TNN870FDFederal Express Corp · Memphis, TNN871FDFederal Express Corp · Memphis, TNN872FDFederal Express Corp · Memphis, TNN873FDFederal Express Corp · Memphis, TNN874FDFederal Express Corp · Memphis, TNN875FDFederal Express Corp · Memphis, TNN876FDFederal Express Corp · Memphis, TNN877FDFederal Express Corp · Memphis, TNN878FDFederal Express Corp · Memphis, TNN879FDFederal Express Corp · Memphis, TNN880FDFederal Express Corp · Memphis, TNN882FDFederal Express Corp · Memphis, TNN883FDFederal Express Corp · Memphis, TNN884FDFederal Express Corp · Memphis, TNN885FDFederal Express Corp · Memphis, TNN886FDFederal Express Corporation · Memphis, TNN887FDFederal Express Corp · Memphis, TNN888FDFederal Express Corp · Memphis, TNN889FDFederal Express Corp · Memphis, TNN890FDFederal Express Corp · Memphis, TNN891FDFederal Express Corp · Memphis, TNN893FDFederal Express Corp · Memphis, TNN894FDFederal Express Corp · Memphis, TNN895FDFederal Express Corp · Memphis, TNN896FDFederal Express Corp · Memphis, TNN897FDFederal Express Corp · Memphis, TNN898FDFederal Express Corp · Memphis, TNN899FDFederal Express Corporation · Memphis, TNN90VLBank Of Utah Trustee · Salt Lake City, UT
Back to GE GE90-110B1