Boeing 737-5H4
Service difficulty reports · 8,230
Newest first. General aviation reporting is voluntary.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = '7375H4' ORDER BY difficulty_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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = '7375H4' ORDER BY difficulty_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 SWAA2012111409338Crease Beam · corrodedCORROSION ON WEB LOCATED BETWEEN BS 847 AND BS 867 AT LEVEL OF STR 17R IN AFT PAX CABIN. REPAIRED FUSELAGE CREASE BEAM WEB AT S-17R BETWEEN BS 847 AND BS 867 IAW EA 1-553-21021 REV 0 AND EO AEM-HC53-501/12 REV 0.SDR SWAA2012111309290Web · corrodedWEB CORRODED BETWEEN BS 867 TO BS 887, STR 17R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012111209261Frame · crackedFRAME CRACKED AT BS 947.5, STR 19R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA2012110909186Frame · crackedFRAME CRACKED AT BS 986, STR 20R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA2012110809166Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 907, STR 25R. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.SDR SWAA2012110809163Frame · crackedFRAME CRACKED AT BS 947.5, STR 19L. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2012110109010Web · crackedWEB CRACKED AT BS 294.5, STR 16L. REPAIRED WEB IAW SRM AND DWG.SDR SWAA2012111609553Stringer Clip · crackedPASSENGER CABIN STATION 360, STRINGER 7R, LOWER STRINGER CLIP CRACKED AT FASTENER HOLE. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2012111509508Frame · crackedFRAME CRACKED AT BS 1040, BETWEEN STR 25L AND STR 26L. REPAIRED FRAME IAW EA AND EO.SDR SWAA2012111509407Support Bracket · crackedFORWARD CARGO PIT STATION 460, STRINGER 21L, SIDEWALL SUPPORT BRACKET IS CRACKED AS MARKED. REMOVED AND REPLACED BRACKET IAW SRM.SDR SWAA2012111309289Web · crackedLEFT NLG WHEEL WELL SIDE WEB CRACKED AT BS 243.7+4.5, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2012111309288Web · crackedLEFT NLG WHEEL WELL SIDE WEB CRACKED AT BS 243.7+3.5, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2012111309287Web · crackedLEFT NLG WHEEL WELL SIDE WEB CRACKED AT BS 243.7+2.5, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2012111309286Web · crackedLEFT NLG WHEEL WELL SIDE WEB CRACKED AT BS 243.7-4.5, WL 169. REPAIRED WEB IAW SRM.SDR SWAA2012111309285Web · crackedLEFT NLG WHEEL WELL SIDE WEB CRACKED AT BS 243.7-4.5, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2012111309284Skin · crackedFUSELAGE SKIN CRACKED AT BS 951, STR 11L. REPAIRED SKIN IAW SRM.SDR SWAA2012111209274Web · crackedLEFT NLG WHEEL WELL WEB CRACKED AT BS 259.6, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2012110809162Web · crackedRIGHT NLG W/W SIDE WEB CRACKED AT BS 243.7+3.5, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2012110809161Web · crackedRIGHT NLG WHEEL WELL SIDE WEB CRACKED AT BS 238+3.5, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2012110108997Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908, STR 4R. REMOVED AND REPLACED SPLICE IAW SRM & DWG.SDR SWAA2012102908907Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908, STR 4L. REPAIRED SPLICE IAW SRM.SDR SWAA2012102408804Battery · dischargedEMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER AMM.SDR SWAA2012111509418Plate · crackedCRACK ON PLATE IN LOWER HINGE LOCATED FWD ENTRY DOOR CUTOUT STRUCTURE. REPLACE PLATE (SHIELD) IN LOWER HINGE LOCATED FWD ENTRY DOOR CUTOUT STRUCTURE IAW B737-500 SRM 51-40-02 AND SRM 51-10-02 ITEM 8.SDR SWAA2012111509399Plate · crackedCRACK ON PLATE IN UPPER HINGE LOCATED FWD ENTRY DOOR CUTOUT STRUCTURE. REMOVED AND REPLACED PLATE IN SRM.SDR SWAA2012110108999Tie Clip · crackedTIE CLIP CRACKED AT BS 360, STR 10L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012110108998Tie Clip · crackedTIE CLIP CRACKED AT BS 294.5, STR 12L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012111509507Skin · crackedCRACK ON FORWARD LOWER CORNER AFT ENTRY DOOR CUTOUT LOCATED BS 951+10" ABOVE STR 17L. REPAIRED SKIN IAW EA AND EO.SDR SWAA2012111509417Intercostal · crackedCRACK ON INTERCOSTAL WEB LOCATED BETWEEN BS 294.5 AND BS 303.9, STRINGER 16L, ON FWD STRUCTURE OF FWD ENTRY DOOR. REMOVED AND REPLACED WEB IAW SRM AND DRAWING.SDR SWAA2012111509416Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED AT RSS 533 TRAILING EDGE AREA LEFT WING. REPLACED SUPPORT ANGLE LOC AT RSS533 TRAILING EDGE AREA LEFT WING IAW B737-500 SRM 51-40-02 B737-500 SRM 51-10-02 ITEM8 AND DWG 65-46460.SDR SWAA2012111509415Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED AT WBL 71.24 + 14.5 TRAILING EDGE AREA LEFT WING. REPLACED SUPPORT ANGLE SEAL DEPRESSOR LOCATED AT WBL 71.24+14.5" TIE AREA LEFT WING IAW B737-500 SRM 51-10-02 ITEM 8, 51-40-02 AND DRAWING # 65-50820.SDR SWAA2012111509414Strap · crackedCRACK ON STRAP AT STA 328 LBL 45.6 OF E/E COMPARTMENT UPPER SURFACE. REPLACED STRAP AND FASTENERS LOC STA 312 TO STA 344 OF E/E COMPARTMENT UPPER SURFACE IAW B737-500 SRM 51-10-02 ITEM 8 PAGE 8 DWG 65C33970.SDR SWAA2012111509413Access Panel · crackedCRACK ON ACCESS PANEL 8501R OF RIGHT WING. REPAIRED ACCESS PANEL 8501R RIGHT WING IAW B737-500 SRM 51-70-10-2R-0.SDR SWAA2012111509412Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED AT LEVEL OF RSS 544 TRAILING EDGE AREA OF RT WING. REMOVED AND REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2012111509398Support Angle · crackedCRACK ON SUPPORT ANGLE AT WBL 71.24 LOWER SURFACE RIGHT WING. REPLACED SUPPORT ANGLE (ANGLE ASSY) LOCATED AT WBL 71.24 LOWER SURFACE RIGHT WING IAW SRM B737-500 51-10-02 AND DRAWING #65-50820.SDR SWAA2012111509397Angle · crackedCRACK ON ANGLE LOCATED AT WBL 183 TRAILING EDGE AREA OF RIGHT WING. REPLACED ANGLE AND FASTENERS IAW B737-500 SRM 51-10-02 ITEM 8 PAGE 8 DWG#65-50820 LOCATED AT WBL 183 TRAILING EDGE AREA OF RIGHT WING.SDR SWAA2012111409337Skin · crackedCRACK INDICATION ON AFT UPPER CORNER FORWARD ENTRY DOOR CUTOUT LOCATED BS 344 BELOW STR 6L. CRACK L =0.500" APPROX. REPAIRED FUSELAGE SKIN AT FWD ENTRY DOOR CUTOUT UPPER AFT CORNER LOCATED ON BS 328 TO BS 348.2+10" BETWEEN STR 5L TO STR 9L IAW EA.SDR SWAA2012111509506Floorbeam · crackedCRACK ON THE RBL 24.5 LONGITUDINAL FLOORBEAM WEB AT LEVEL BS 708 IN CENTER WING SECTION STRUCTURE. REPAIRED BEAM IAW EO AND EA.SDR SWAA2012111509505Floorbeam · crackedCRACK ON LONGITUDINAL FLOORBEAM UPPER CHORD DIRECTED DOWNWARD OF OVAL HOLE BS 663 AT LBL 24.5 CENTER WING SECTION STRUCTURE. REPAIRED BEAM IAW EO AND EA.SDR SWAA2012111509411Skin · crackedCRACK ON LEADING EDGE LOCATED AT LEVEL OF WBL 227 LOWER SURFACE LEFT WING. REPAIRED LEADING EDGE AT LEVEL OF WBL 227 LOWER SURFACE LEFT WING IAW SRM 51-70-17-0G-0 PARA 4G REP 7 B737-500.SDR SWAA2012111409336Skin · crackedCRACKS ON EXTERNAL SKIN CUTOUT OF GROUND SERVICE AIR CONDITIONING LOCATED BETWEEN BS 520 TO BS 540 AND STR 28R TO STR 28L. REPAIRED FUSELAGE SKIN BETWEEN STA 482+8" AND STA 540, S-27L TO S-27R IAW EA AEM-HC53-490/12 R0, FOR INSPECTION REQUIREMENTS SEE TLD T02SDR SWAA2012110809159Bulkhead · crackedAFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, BL 0. REPAIRED WEB IAW SRM.SDR SWAA2012112709924Cover · debondedAFT GALLEY DOOR, R2, ESCAPE SLIDE COVER WINDOW HAS DISBONDED FROM COVER. AFT GALLEY DOOR R2 ESCAPE SLIDE COVER WINDOW DISBONDED FROM COVER. REMOVED AND INSTALLED SLIDE IAW MT 325-61-06. REPLACED COMPARTMENT WINDOW IAW AMM 25-61-35.SDR SWAA2012111509406Fitting · crackedNR 1 NACELLE STRUT AFT FAIRING, 2 EACH HEAT SHIELD CLIPS CRACKED. REMOVED NR 1 NACELLE STRUT AFT FAIRING HEAT SHIELD CLIPS IAW EA 1-A54-0920.SDR SWAA2012102608879Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED ON LOWER SURFACE BETWEEN BS 400 TO BS 420. REMOVED AND REPLACED WEB IAW DWG & SRM.SDR SWAA2012102308760Battery · dischargedRIGHT FWD PASSENGER CABIN EMERGENCY EXIT LIGHTING INOP. REMOVED & REPLACED BATTERY IAW AMM.SDR SWAA2012102308751Skin · crackedFUSELAGE SKIN CRACKED AT BS 767, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA2012102308750Skin · crackedFUSELAGE SKIN CRACKED BS 400, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA2012102308749Skin · crackedFUSELAGE SKIN CRACKED AT BS 400, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA2012102608878Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 520, STR 16L. REMOVED AND REPLACED CLIP IAW SRM & DWG.SDR SWAA2012102308778Crease Beam · damagedCREASE BEAM CHORD MISSING AT BS 727A, STR 17L. INSTALLED CHORD IAW SRM & DWG.
Back to Boeing 737-5H4