OpenAirDocs.org

SDR SROM2008015

Open the Markdown

Service difficulty report · Frame · Boeing 737205

FAA SDR system

Difficulty date
April 6, 2008
Submitted
April 11, 2008
Operation
General aviation
Aircraft
N733PA
Make and model
Boeing 737205
Aircraft serial
23466
Aircraft time
39,285 hours, 37,547 cycles
System (JASC)
5311 · Fuselage Main, Frame
Part
Frame
Condition
Cracked
Location
Fuselage
Stage of operation
IN
How discovered
V
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

CRACK ON BODY FRAME INNER CHORD STA BS 616 LEFT HAND AT STUB BEAM LOWER CHORD. REPAIRED BODY FRAME INNER CHORD STA BS 616 LT AT STUB BEAM LOWER CHORD IN ACCORDANCE WITH BOEING SB 737-53A-1254. REFERENCE KELOWNA FLIGHTCRAFT NON-ROUTINE CARD 672, DATED 03/05/08.

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 737-53A1254copycopy held of revision 1
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 ('SROM2008015') 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.