Fairchild C-119C airworthiness directives

Manufacturer (registry): FAIRCHILD
Model: C-119C
Registry code: 3372106
Registered: 0 aircraft
Type: Fixed wing multi engine
Engines: 2 · Reciprocating
Seats: 52
Weight class: 20,000 lb and over
Cruise speed: 176 mph
Certification: Type certificated
Data sheet: TCDSA21WE
Holder: Aero Union Corporation

Model codes come from the FAA registry’s reference file. ADs are matched to them by model name and maker.

On this page

Airworthiness directives that may apply · 1

ADs whose products match this airframe model. Each AD’s applicability may narrow it by serial number, part number or configuration.

Airframe · Fairchild C-119C

AD 81-18-06Aileron Control SystemEffective Sep 10, 1981

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 ('3372106'))
  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 ('3372106'))
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.

Registered aircraft · 0

No aircraft currently registered with this model

NTSB investigations

No NTSB investigations matched to aircraft with this modelMatched through the registry by N-number, so foreign aircraft and some older cases aren’t counted.

FAA incident reports

No reports matched to aircraft of this modelMatched through the registry by N-number, so foreign aircraft and some older reports aren’t counted.

Service difficulty reports

No reports name this modelGeneral aviation reporting is voluntary.

STCs that may be installed · 5

Approved for this model: the STC’s model list names it on its data sheet, or a series that includes it. The registry doesn’t record which STCs an aircraft has.

STC SA2915WEInstallation of a 2400 gallon fire retardant tank assembly.United Aeronautical Corporation STC SA2996WEInstallation of a 2400 gallon fire retardant tank assembly.United Aeronautical Corporation STC SA2997WEInstallation of a 2400 gallon fire retardant tank assembly.United Aeronautical Corporation STC SA74RMModification of floor and bottom fuselage for water and chemical tank installation.Hawkins & Powers Avn Inc STC SA20RMInstall Westinghouse J-34-WE36 jet engines on top of center line of fuselage.Hawkins & Powers Avn Inc

Query with SQL

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 ('3372106') 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

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 ('3372106')
    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 ('3372106')
  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.