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 ('30070')
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 ('30070')
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.
N8696CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8698ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8709ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8710ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8718ETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8747BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8751DTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8758DTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8771ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8783ESlate Crj Acquisitions I LLC · Johnstown, PAN8790AAm Pm Services LLC Blue Sky Series · Northbrook, ILN8794BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8797AAm Pm Services LLC - Blue Sky Series · Northbrook, ILN8800GTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8808HTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8828DBank Of Utah Trustee · Salt Lake City, UTN8836AGold Coast Aviation · Fort Lauderdale, FLN8847ASlate Crj Acquisitions 1 LLC · Johnstown, PAN8855ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8869BViajet LLC · Johnstown, PAN8877ASlate Crj Acquisitions 1 LLC · Johnstown, PAN8886AGold Coast Aviation · Fort Lauderdale, FLN8891AGold Coast Aviation · Fort Lauderdale, FLN8921BAm Pm Services LLC · Northbrook, ILN8930EBank Of Utah Trustee · Salt Lake City, UTN8933BGold Coast Aviation · Fort Lauderdale, FLN8936AGold Coast Aviation · Fort Lauderdale, FLN8940EAm Pm Services LLC - Adventure Series · Northbrook, ILN8942AViajet LLC · Johnstown, PAN8943AGold Coast Aviation · Fort Lauderdale, FLN8946ABank Of Utah Trustee · Salt Lake City, UTN8960AAm Pm Services LLC - Adventure Series · Northbrook, ILN8964EAm Pm Services LLC - Adventure Series · Northbrook, ILN8969AGold Coast Aviation · Fort Lauderdale, FLN8971AAm Pm Services LLC - Adventure Series · Northbrook, ILN8976ESlate Crj Acquisitions 1 LLC · Johnstown, PAN8980AViajet LLC · Johnstown, PAN8982AGold Coast Aviation · Fort Lauderdale, FLN8986BSlate Crj Acquisitions 1 LLC · Johnstown, PAN924CNCorporate Flight Management Inc DBA · Smyrna, TNN93EAElite Airways LLC · Portland, MEN949SJSierra Delta Romeo LLC · Scottsdale, AZN96EAAuburn-Lewiston Municipal Airport · Auburn, ME
Back to GE CF34-3B1