Boeing SB 727-53-0188
Service difficulty reports that cite it · 9
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-53-0188' 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-53-0188' 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 05FDEA04373Repair · Boeing 727233FOUND PREVIOUSLY INSTALLED REPAIR AT AFT LOWER CORNER OF FWD GALLEY DOOR CUT OUT WAS ACCOMPLISHED IAW SB 727-53-0188, BASED ON AN EXTERNAL VISUAL EVALUATION, CONSISTED OF LOCATION, SHAPE, SIZE, FASTENSDR DL72S011714Skin · Boeing 727225AFUSELAGE / SKIN / FWD GALLEY DOOR CUTOUT / LWR AFT CORNER : CRACK REPAIR THE LOWER AFT CORNER OF THE FWD GALLEY DOOR CUTOUT WAS FOUNDWITH A CRACK EMANATING FROM A FASTENER HOLE. THE CRACK IS TYPICAL OSDR AALA20010196Door Frame · Boeing 727227TUL - FOUND LOWER AFT CORNER OF FORWARD GALLEY DOOR HAS TWO SKIN CRACKS DOOR CUTOUT. STRIPED PAINT INSTALLED DOUBLER PER SERVICE BULLETIN 727-53-0188. (M)SDR AALA20002026Skin · Boeing 727223TUL - FOUND CRACK IN SKIN AND GEAR STRAP AT FORWARD GALLEY DOOR AFT LOWER CORNER, FUSELAGE SKIN. STOP DRILLED CRACK AND INSTALLED DOUBLER PER SERVICE BULLETIN 727-53-0188. (M)SDR AALA20001847Doubler · Boeing 727223TUL - FOUND SMALL CRACK 1 INCH BY 1 INCH EMANATING FROM RADIUS OF BEARSTRAP. ROUTED OUT CRACK AND INSTALLED DOUBLER AND TRIPLER PER BOEING S/B 727-53-0188 AUTHORIZED BY ESO 11697 DATED 10-31-2000. (M)SDR AALA2000776Strap · Boeing 727223TUL - LFEC SHOWS CRACK IN BEAR STRAP AT LOWER AFT CORNER OF FORWARD RIGHT GALLEY DOOR FRAME. REQUIRES REPAIR PER SERVICE BULLETIN 727-53-0188 FIG 3. REPAIRED AFT LWER CORNER PER BOEING S/B 727-53-0188SDR 2000UALA00230Skin · Boeing 727222A CRACK IN THE FUSELAGE SKIN AND BEAR STRAP WAS DETECTED PROPAGATING FROM THE AFT LOWER CORNER OF THE FORWARD GALLEY DOOR OPENING. THE CRACK WAS PROPAGATING UNDERNEATH THE THRESHOLD PLATE. AFTER THE TSDR AALA991541Skin · Boeing 727223TUL - LOWER AFT CORNER OF FORWARD GALLEY DOOR CUT-OUT FUSELAGE SKIN CRACKED. ROUTED OUT CRACK AND INSTALLED DOUBLER PER SB 727-53-0188. TST: 59,297 HOURS. CYCLES: 35,868. (X)SDR AALA990514Skin · Boeing 727223TUL - FOUND SKIN CRACKED AT LOWR AFT CORNER OF RIGHT SERVICE DOOR CUTOUT, FORWARD GALLEY DOOR. REMOVED DAMAGED AREA. INSTALLED DOUBLER REPAIR PER SB 727-53-0188 FIG 2. (M)
Back to Boeing SB 727-53-0188