Learjet 35A
Airworthiness directives that may apply · 35
Matched by model name and maker. Each AD’s applicability may narrow it by serial number, part number or configuration.
Query with SQL
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 ('5170802', '5170711'))
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 ('5170802', '5170711'))
ORDER BY coalesce(d.effective_date, d.publication_date, d.issue_date) DESC, d.ad_number DESCRun 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.
| 1978 | 1 |
|---|---|
| 1980 | 4 |
| 1981 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 3 |
| 1996 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 2 |
| 2018 | 1 |
| 2022 | 1 |