SDR SCNA96148

Service difficulty report · Stringer · Boeing 727225

Difficulty date: May 23, 1996
Submitted: March 26, 2000
Operation: Air carrier
Aircraft: N282SC
Make and model: Boeing 727225
Aircraft serial: 22558
System (JASC): 5313 · Fuselage Main, Longeron/Stringer
Part: Stringer
Part number: BAC1498132
Condition: Corroded
Location: Bs 993
Stage of operation: IN
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 HEAVY MAINTENANCE VISIT, CORROSION WAS FOUND ON STRINGER 29R AT BS 993. FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH SB 727-53-0179, LMAC EO 3775, B727 SRM 53-10-2 FIGURE 5, SHEET 22, ITEM 42, AND SRM 53-30-10.

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 SB 727-53-0179

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