SDR AU000707

Service difficulty report · Stringer · Airbus A320211

Difficulty date: September 1, 2000
Submitted: September 1, 2000
Operation: General aviation
Make and model: Airbus A320211
Engine: Cfmint CFM565A1
System (JASC): 5313 · Fuselage Main, Longeron/Stringer
Part: Stringer
Condition: Cracked
Location: Fuselage
Stage of operation: IN
How discovered: E
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

(AUS) FRONT VERTICAL STRINGER CRACKED AT FRAME 36. FOUND DURING EDDY CURRENT INSPECTION IAW SB A320-57-1017.

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.

Airbus SB A320-57-1017copycopy held of another revision

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

More about the Airbus A320-211