Lockheed L-1011-385-1-14

duckdb -csv -c "SELECT d.ad_number, d.status, d.subject, d.effective_date
  FROM 'https://openairdocs.org/data/latest/faa_directive.parquet' d
  WHERE d.ad_id IN (SELECT ad_id FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE aircraft_model_code IN ('5265013'))
  ORDER BY coalesce(d.effective_date, d.publication_date, d.issue_date) DESC, d.ad_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 d.ad_number, d.status, d.subject, d.effective_date
FROM 'https://openairdocs.org/data/latest/faa_directive.parquet' d
WHERE d.ad_id IN (SELECT ad_id FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE aircraft_model_code IN ('5265013'))
ORDER BY coalesce(d.effective_date, d.publication_date, d.issue_date) DESC, d.ad_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.

duckdb -csv -c "SELECT s.saib_number, any_value(s.title) AS title, max(s.issue_date) AS issue_date, any_value(s.status) AS status
  FROM 'https://openairdocs.org/data/latest/faa_saib.parquet' s
  WHERE s.saib_id IN (SELECT saib_id FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_saib.parquet' WHERE aircraft_model_code IN ('5265013'))
  GROUP BY s.saib_number ORDER BY issue_date 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 s.saib_number, any_value(s.title) AS title, max(s.issue_date) AS issue_date, any_value(s.status) AS status
FROM 'https://openairdocs.org/data/latest/faa_saib.parquet' s
WHERE s.saib_id IN (SELECT saib_id FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_saib.parquet' WHERE aircraft_model_code IN ('5265013'))
GROUP BY s.saib_number ORDER BY issue_date 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.

duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
  FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
  WHERE aircraft_model_code IN ('5265013')
  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, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE aircraft_model_code IN ('5265013')
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.

duckdb -csv -c "SELECT s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
  FROM (
    SELECT stc_number, min(matched_model) AS matched_model
    FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet'
    WHERE aircraft_model_code IN ('5265013')
    GROUP BY stc_number
  ) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
  ORDER BY s.status = 'Current' DESC, s.status_date DESC, s.stc_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 s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
FROM (
  SELECT stc_number, min(matched_model) AS matched_model
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet'
  WHERE aircraft_model_code IN ('5265013')
  GROUP BY stc_number
) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
ORDER BY s.status = 'Current' DESC, s.status_date DESC, s.stc_number

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.