Boeing SB 727-53-0198
Service difficulty reports that cite it · 28
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-0198' 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-0198' 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 DHL2004753503Skin · Boeing 727223DURING C-CHECK, FWD ENTRY DOOR (L1) LWR HINGE CUTOUT CRACKED NDT VERIFIED BS 310. REMOVED FASTENERS PER ACCESS AT FWD ENTRY DOOR LOWER HINGE IAW B-727 SRM 51-30-2. CUT OUT DAMAGE AREA DIM APPROX 1 INCSDR GAIA02055STSkin · Boeing 7272J0DURING A C-CHECK INSPECTION, IT WAS DISCOVERED THAT THE FUSELAGE SKIN IS CRACKED AT THE FORWARD ENTRY DOOR LOWER HINGE CUT OUT. ACCOMPLISHED FUSELAGE SKIN REPAIR AT THE FORWARD ENTRY DOOR LOWER HINGE SDR DL72S011080Skin · Boeing 727232FUSELAGE / SKIN / L1 DOOR CUTOUT / UPPER HINGE CUTOUT : CRACK REPAIR A .75" CRACK WAS FOUND IN THE SKIN AT THE UPPER HINGE CUTOUTOF THE L1 DOOR OPENING. THE CRACK WAS ROUTED OUT OF THE SKIN AND REPAIRSDR EISA20010091Skin · Boeing 7272M7L-1 LOWER DOOR HINGE AT FUSELAGE SKIN CRACKED. REPAIRED CRACK, ROUTING OUT AND FABRICATING AND INSTALLING REPAIR FILLER AND DOUBLER IAW 727 SB 727-53-0198 REV 1 FIGURE 4 DATED 07-25-1991.SDR AALA20010847Skin · Boeing 727223TUL - FOUND FORWARD ENTRY DOOR LOWER HINGE CUTOUT SKIN CRACKED, FS 303. TRIMMED OUT CRACK, INSTALLED DOUBLER IAW SB 727-53-0198 FIG 4. (M)SDR AALA20010846Skin · Boeing 727223TUL - FOUND FORWARD ENTRY DOOR UPPER HINGE CUTOUT CRACKED. INSTALLED DOUBLER IAW SB 727-53-0198 FIG 4, TRIMMED OUT CRACK. (M)SDR AALA20002112Skin · Boeing 727223TUL - FOUND FUSELAGE SKIN AT FORWARD ENTRY DOOR UPPER HINGE CUT OUT CRACKED. INSTALLED DOUBLER AT UPPER HINGE CUTOUT, FORWARD ENTRY DOOR IAW SB 727-53-0198. (M)SDR DL72E002176Skin · Boeing 727247THE UPPER HINGE CUTOUT OF THE L1 DOOR CUTOUT WAS FOUND WITH A CRACK IN THE SKIN. HFEC INSPECTION OF ADJACENT FASTENER HOLES REVEALED A CRACK INDICATION IN THE BEAR STRAP. THE SKIN CRACK WAS ROUTED OUTSDR GAIA00619Skin · Boeing 7272J0DISCREPANCY: DURING ROUTINE INSPECTION AT FLIGHTSTAR AIRCRAFT SERVICES REPAIR STATION IN JAX IT WAS DISCOVERED THAT THERE WAS A CRACK AT THE FORWARD ENTRY DOOR LOWER HINGE CUT OUT ON THE EXTERIOR SKINSDR DL72S001162Skin · Boeing 727225ATHE LOWER HINGE CUTOUT OF THE FWD PASSENGER DOOR SURROUND SKIN WAS FOUND WITH A .5 TYPICAL CRACK. THE CRACK WAS ROUTED OUT OF THE SKIN AND REPAIRED WITH AN EXTERNAL STEEL DOUBLER PER ER/A 377566-14, RSDR AALA20000938Skin · Boeing 727223TUL - FOUND CRACK IN SKIN AT UPPER HINGE FORWARD ENTRY DOOR, NOT HFEC. CUT AND REMOVED DAMAGED SECTION OF SKIN FABRICATED REPAIR DOUBLER AND FILLER AND INSTALLED SB 727-53-0198 FIG 4. (M)SDR AALA991634Skin · Boeing 727223TUL - FOUND FUSELAGE FORWARD ENTRY LOWER HINGE CUT OUT, SKIN HAS .25 INCH CRACK. ROUTED OUT DAMAGE, INTALLED DOUBLER PER SERVICE BULLETIN 727-53-0198. (M)SDR AALA2000373Skin · Boeing 727223TUL - FOUND CRACK IN FUSELAGE SKIN FORWARD OF FORWARD ENTRY DOOR LOWER HINGE CUTOUT. CRACK REMOVED BY TRIMMING. REPAIR DOUBLER INSTALLED PER SERVICE BULLETIN NR 727-53-0198 NSC1. (M)SDR EISA99237Skin · Boeing 727225ACCOMPLISHMENT OF ROUTINE C-CHECK WORK CARD REVEALED A CRACK IN FUSELAGE EXTERNAL SKIN AT FORWARD ENTRY DOOR LOWER HINGE CUT-OUT. TRIMMED DAMAGED AREA PER SB 727-53-0198. FABRICATED AND INSTALLED DOUBSDR EISA99236Skin · Boeing 727225ACCOMPLISHMENT OF ROUTINE C-CHECK WORK CARD REVEALED A CRACK IN FUSELAGE SKIN AT UPPER HINGE CUT-OUT AT FORWARD ENTRY DOOR. TRIMMED DAMAGED AREA PER SB 727-53-0198. FABRICATED AND INSTALLED DOUBLER PESDR AALA990333Skin · Boeing 727223TUL - FORWARD ENTRY DOOR LOWER HINGE CUT-OUT IS CRACKED. REPAIRED PER SB 727-53-0198 FIG 4. DOUBLER IS .063 INCH AISI 15-5PH HEAT TREATED TO 150-170 KSI CADMIUM PLATED. FASTENERS ARE BACB30KK6A AND BASDR CALA9801377Skin · Boeing 727224INSPECTION FOUND A .5 INCH CRACK AT LEFT SIDE OF FUSELAGE AT CUTOUT FOR L-1 DOOR UPPER HINGE ARM. THE CRACKED AREA WAS CUT OUT. A DOUBLER REPAIR WAS FABRICATED AND INSTALLED IAW ECRA 5330-02675, SRM 5SDR AALA980272Skin · Boeing 727223TUL - FUSELAGE SKIN CRACKED AT FORWARD ENTRY DOOR LOWER HINGE CUT-OUT. INSTALLED REPAIR DOUBLER PER SB 727-53-0198. TST: 48,140 HOURS. CYCLES: 23,835. (X)SDR 98FDEA00074Doubler · Boeing 7272S2FFWD ENTRY DOOR CUTOUT LOWER HINGE CUTOUT HAS BEEN CUTOUT BEYOND FUSELAGE SKIN AND DEEP INTO BEAR STRAP AT FWD SECTION OF HINGE CUTOUT. INSTALLED LOWER HINGE CUTOUT DOUBLER PER S/B 727-53-0198 REV 1 ANSDR 98FDEA00075Doubler · Boeing 7272S2FFWD ENTRY DOOR CUTOUT UPPER HINGE AREA HAS BEEN CUTOUT PAST FUSELAGE SKIN AND DEEP INTO BEAR STRAP AT FWD SECTION OF HINGE CUTOUT. INSTALL UPPER HINGE CUTOUT DOUBLER PER S/B 727-53-0198 REV 1 AND EA 7SDR AALA980208Skin · Boeing 727223TUL - SKIN CRACKED AT FOWARD ENTRY DOOR LOWER HINGE CUT OUT. CUT OUT CRACK, INSTALLED FILLERS AND DOUBLER IAW SB 727-53-0198. TST: 57,178 HOURS. CYCLES: 35,293. (X)SDR AALA971306Skin · Boeing 727223TUL - FORWARD ENTRY DOOR UPPER HINGE CUT-OUT CRACKED. VERIFIED WITH HFEC (MARKED) EXTERNAL. ROUTED OUT CRACK AND INSTALLED DOUBLER AND FILLERS IAW SB 727-53-0198, FIG 4. TST: 43,979 HOURS. CYCLES, 23,SDR AALA970791Skin · Boeing 727223TUL - FORWARD ENTRY DOOR LOWER HINGE CUT-OUT IS CRACKED. REPAIRED PER SB 727-53-0198, FIGURE 4 DETAIL IV. 51,950 HOURS. CYCLES, 32,018. (X)SDR DL72S970474Skin · Boeing 727232THE L-1 DOOR HINGE CUT-OUTS WERE FOUND TO HAVE EXISTING DOUBLER REPAIRS INSTALLED. THE DOUBLERS WERE INSPECTED AND IDENTIFIED AS PERMANENT PER BACO S/B 727-53-0198.SDR AALA961489Skin · Boeing 727227TUL - FOUND FORWARD ENTRY DOOR UPPER HINGE CUT OUT, SKIN CRACKED APPROX .1875 INCH LONG AT 10 O'CLOCK POSITION. INSTALLED DOUBLER AS PER SERVICE BULLETIN 727-53-0198. (M)SDR AALA960884Skin · Boeing 727223TUL - FOUND FUSELAGE SKIN HAS .5 INCH CRACK AT FORWARD END OF FUEL ENTRY DOOR LOWER HINGE CUTOUT. ROUTED OUT CRACK, INSTALLED DOUBLER PER SB 727-53-0198. (M)SDR EISA95281Skin · Boeing 727277FUSELAGE SKIN HAS AN 1.25 INCH LONG CRACK AT TOP HINGE CUTOUT FOR FORWARD ENTRY DOOR. REPAIRED SKIN PER SERVICE BULLETIN 727-53-0198, FIG 3 AND 4. (M)SDR 95ZZZW220Skin · Boeing 727231MCI - DURING CHECK C-1D, FOUND A 1.5 INCH CRACK IN FORWARD FUSELAGE, RUNNING FORWARD TO FASTENER HOLE UPPER HINGE CUTOUT, FORWARD ENTRY DOOR. REPAIRED BY INSTALLING DOUBLER PER S/B 727-53-0198. TOTAL
Back to Boeing SB 727-53-0198