Service difficulty report · Beam · Cndair CL6002C10

Difficulty date
January 10, 2008
Submitted
March 27, 2008
Operation
Air carrier
Aircraft
N317CA
Make and model
Cndair CL6002C10
Aircraft serial
10055
Aircraft time
13,945 hours, 10,133 cycles
Part
Beam
Condition
Corroded
Location
Fuselage
Stage of operation
IN
How discovered
V
Nature of condition
O
Precautionary procedure
K

As reported to the FAA. Reports are unverified, and codes are left as the FAA publishes them.

What was found

FS 280 TRANSVERSE BEAM CORRODED BEYOND LIMITS AND CRACKED. REPAIRS PERFORMED IN ACCORDANCE WITH BOMBARDIER REO 670-53-11-047 & BOMBARDIER SERVICE BULLETIN SB670-BA-53-026. SUPPLEMENTAL SDR CLOSED 3/27/08.

Service documents this report cites · 1

Manufacturers’ service documents named in its text, as OpenAirDocs read them: check each against the text. “Copy” marks those OpenAirDocs holds.

Query with SQL
duckdb -csv -c "SELECT d.issuer, d.type_label, d.number, c.revision, c.revision_date, c.cited_as, c.incorporated_by_reference, c.in_regulatory_text,
    'https://openairdocs.org/service-documents/' || d.document_id AS page_url
  FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/service_document.parquet' d USING (document_id)
  WHERE c.record_type = 'faa_service_difficulty_report' AND c.record_id IN ('TRAX200800067') AND d.issuer_kind <> 'authority'
  QUALIFY row_number() OVER (PARTITION BY c.document_id, c.revision_key ORDER BY c.record_date DESC) = 1
  ORDER BY c.incorporated_by_reference DESC, c.in_regulatory_text DESC, d.document_id, c.revision_key"

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.