SDR USAA990055

Service difficulty report · Channel · Boeing 737301

Difficulty date: January 25, 1999
Submitted: March 26, 2000
Operation: Air carrier
Aircraft: N334US
Make and model: Boeing 737301
Aircraft serial: 23231
System (JASC): 5320 · Fuselage Miscellaneous Structure
Part: Channel
Condition: Cracked
Location: Bs 520
Part time: 37,897 hours
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

CLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND A .20 CRACK AND CORROSION BS 520 VHF NR 2 COMM ANTENNA MOUNT CHANNEL. REMOVED AND REPLACED CHANNEL PER SB 737-53-1159 FIG 1 STEP 1. (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 Special Attention Service Bulletin 737-53-1159copycopy 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 ('USAA990055') 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 ('USAA990055') 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 ('USAA990055') 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.