# Airworthiness directives, 1947

FAA airworthiness directives effective in 1947: 2 ADs with their full text, status and the aircraft they apply to.

- [AD 47-30-08](https://openairdocs.org/ad/47-30-08.md): Seat Modification · Gores, William 65-CA (Army L-3F), 65-LA and S-65-CA · Effective Sep 30, 1947
- [AD 74-03-04](https://openairdocs.org/ad/74-03-04.md): Pilot and Co-pilot Window Frame Castings · Kelowna Flightcraft R & D 240 Series with STC SA1054WE · Effective Feb 4, 1947

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT d.ad_number, d.status, d.subject, d.makes, d.models, d.effective_date
FROM 'https://openairdocs.org/data/latest/faa_directive.parquet' d
WHERE year(coalesce(d.effective_date, d.publication_date, d.issue_date)) = 1947
ORDER BY coalesce(d.effective_date, d.publication_date, d.issue_date) DESC, d.ad_number DESC
```

This list as a web page: https://openairdocs.org/ad?year=1947

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
