Boeing SB 727-55-82
Service difficulty reports that cite it · 6
Newest first, with the revision each cites, as OpenAirDocs read it from the records’ text. OpenAirDocs read these citations from the records’ text, so one can be misread: check it against the record. A newer revision may exist that no record cites.
Query with SQL
duckdb -csv -c "SELECT s.sdr_id, s.difficulty_date, s.aircraft_make, s.aircraft_model, s.part_name, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions,
bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text
FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' s ON s.sdr_id = c.record_id
WHERE c.document_id = 'boeing/sb-727-55-82' AND c.record_type = 'faa_service_difficulty_report'
GROUP BY ALL
ORDER BY max(c.record_date) DESC"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 s.sdr_id, s.difficulty_date, s.aircraft_make, s.aircraft_model, s.part_name, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions, bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' s ON s.sdr_id = c.record_id WHERE c.document_id = 'boeing/sb-727-55-82' AND c.record_type = 'faa_service_difficulty_report' GROUP BY ALL ORDER BY max(c.record_date) DESC
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.
SDR GAIA01112STSkin · Boeing 727251DURING A ROUTINE INSPECTION BEING PERFORMED AT FLIGHTSTAR AIRCRAFT SERVICES AT JAX, IT WAS DISCOVERED THAT THE RIGHT VERTICAL STABILIZER ROOT AT BS 1342, STRINGER S-10R IS CRACKED. REPAIRED PER BOEINGSDR GAIA01048STSkin · Boeing 7272J0DURING A LTC INSPECTION AT FLIGHTSTAR JAX, THE RIGHT VERTICAL STAB ROOT AT BS 1342 SKIN CRACKED AT STRINGER 10R. ACCOMPLISHED DOUBLER REPAIR IAW B727 SERVICE BULLETIN 727-55-82 FIG 2 AND FIG 3 MATERIASDR AALA20000677Skin · Boeing 727227TUL- VERTICAL STABILIZER SKIN CRACKED AT STA 1340, LEFT SIDE. STOP DRILLED CRACK AND INSTALLED DOUBLER REPAIR PER BOEING SB 727-55-82. (X)SDR AALA991922Skin · Boeing 727223TUL - CRACK IN VERTICAL STABILIZER SKIN LEFT AT BOTTOM APPROXIMATE STA 1343. STOP DRILLED CRACK AND INSTALLED DOUBLER PER SB 727-55-82 AND ESO 11697 DATED 12-10-99. TST: 62,106 HOURS. CYCLES: 37,884. SDR AALA991863Skin · Boeing 727223TUL - VERTICAL STABILIZER RIGHT SIDE SKIN IS CRACKED .5 INCH AT STABILIZER TO FUSELAGE MATE POINT. STOP DRILLED CRACK VISUAL AND NDT VERIFIED STOP DRILL OF CRACK. INSTALLED DOUBLER PER BOEING SERVICE SDR AALA960988Skin · Boeing 727227TUL - CRACK IN SKIN, LEFT SIDE OF VERTICAL STABILIZER (JUST ABOVE FUSELAGE MATE POINT), STA 1342. STOP DRILLED CRACK AND INSTALLED DOUBLER PER SB 727-55-82. TST: 64,997 HOURS. CYCLES, 44,491. (X)
Back to Boeing SB 727-55-82