Service difficulty report · Skin · Boeing 737205

Difficulty date
August 10, 2007
Submitted
September 7, 2007
Operation
General aviation
Aircraft
N736BP
Make and model
Boeing 737205
Aircraft serial
23465
Aircraft time
38,551 hours, 36,808 cycles
Part
Skin
Condition
Cracked
Location
Fuselage
Part time
38,551 hours, 36,808 cycles
Stage of operation
IN
How discovered
V
Nature of condition
Z
Precautionary procedure
K

As reported to the FAA. Reports are unverified, and codes are left as the FAA publishes them.

What was found

NR393 - FUSELAGE SKIN CRACKED AT AIRSTAIR CONTROL HANDLE CUTOUT AT BS 378 BETWEEN STRINGERS 21-L AND 22-L. REPAIR DOUBLER FABRICATED AND INSTALLED IN ACCORDANCE WITH BOEING SB 737-53-1093.

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.

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