SDR AALA20030688

Service difficulty report · Plate · Boeing 767223

Difficulty date: June 16, 2003
Submitted: October 6, 2003
Operation: Air carrier
Aircraft: N329AA
Make and model: Boeing 767223
Aircraft serial: 22329
System (JASC): 5320 · Fuselage Miscellaneous Structure
Part: Plate
Part number: 111T1002
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

FOUND DURING INSPECTION CF, THE H11 BOLTS THROUGH THE SPLICE PLATE PER BOEING S/B 767-57 A0064, 'C' HOLE WAS FOUND TO BE CORRODED AND REQUIRED OVERSIZING. THE HOLE WAS COMMON TO THE HORIZONTAL FLANGES OF THE OUTBOARD WING SPAR CHORD. REAMED CORRODED 'C'C HOLE TO 0.781 INCH DIAMETER/HFEC INSPECTED 'C' HOLE, HOLE IS CORROSION AND CRACK FREE. INSTALLED A 2ND OVERSIZE, .75 INCH BOLT. SEALED THE FASTENER PER BOEING S/B 757-57A0064. (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.

Boeing ASB 757-57A0064copycopy held of revision 1

Query with SQL

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

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

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

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.