N706PC
Airworthiness directives that may apply · 195
Matched by this aircraft’s airframe and engine models. Each AD’s applicability may narrow it by serial number, part number or equipment.
Query with SQL
duckdb -csv -c "SELECT d.ad_number, d.status, d.subject, d.effective_date, m.matched_by
FROM (
SELECT ad_id, min(rank) AS rank, arg_min(matched_by, rank) AS matched_by
FROM (SELECT ad_id, 1 AS rank, 'airframe' AS matched_by FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE aircraft_model_code = '138366C')
GROUP BY ad_id
) m JOIN 'https://openairdocs.org/data/latest/faa_directive.parquet' d USING (ad_id)
ORDER BY d.status = 'Historical', m.rank, 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, m.matched_by FROM ( SELECT ad_id, min(rank) AS rank, arg_min(matched_by, rank) AS matched_by FROM (SELECT ad_id, 1 AS rank, 'airframe' AS matched_by FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE aircraft_model_code = '138366C') GROUP BY ad_id ) m JOIN 'https://openairdocs.org/data/latest/faa_directive.parquet' d USING (ad_id) ORDER BY d.status = 'Historical', m.rank, 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.
| 1961 | 2 |
|---|---|
| 1962 | 6 |
| 1963 | 5 |
| 1964 | 15 |
| 1965 | 14 |
| 1966 | 11 |
| 1967 | 2 |
| 1968 | 3 |
| 1969 | 4 |
| 1970 | 7 |
| 1971 | 3 |
| 1972 | 2 |
| 1974 | 2 |
| 1975 | 4 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 1 |
| 1979 | 2 |
| 1980 | 3 |
| 1981 | 1 |
| 1982 | 3 |
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 3 |
| 1987 | 3 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 3 |
| 1993 | 4 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 4 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 4 |
| 2005 | 5 |
| 2007 | 3 |
| 2008 | 4 |
| 2009 | 3 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 3 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 3 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 3 |
| 2026 | 2 |