FAA incident reports · 17

duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, registry_match
  FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
  WHERE n_number = 'N2718Y' AND (registry_match = 'registration' OR registry_match IS NULL)
  ORDER BY event_date DESC, report_number DESC"

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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, registry_match
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE n_number = 'N2718Y' AND (registry_match = 'registration' OR registry_match IS NULL)
ORDER BY event_date DESC, report_number DESC

Run 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.