Service difficulty report · Plate · Boeing 767223

Difficulty date
June 13, 2003
Submitted
October 6, 2003
Operation
Air carrier
Aircraft
N329AA
Make and model
Boeing 767223
Aircraft serial
22329
Part
Plate
Condition
Corroded
Location
Fuselage
Stage of operation
IN
How discovered
9
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

DURING INSPECTION OF THE H11 BOLTS THROUGH THE SPLICE PLATE PER BOEING S/B 767-57A0064, 'C' HOLE WAS FOUND TO BE CORRODED. REQUIRED OVERSIZING. THE HOLE WAS COMMON TO THE HORIZ FLANTES OF THE OUTBOARD WING SPAR CHORD. REAMED CORRODED 'C' HOLE TO 0.781 INCH DIAMETER. INSTALLED A 2ND OVERSIZE. (M)

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