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 SWAA2013032514026Skin · crackedSKIN CRACKED AT BS 847+13, STR 22L. REPAIRED SKIN IAW SRM.SDR SWAA2013040114306Frame · crackedFRAME CRACKED AT BS 452.4, STR 24R. REMOVED AND REPLACED FRAME IAW EO AND EA.SDR SWAA2013040114307Frame · crackedFRAME CRACKED AT BS 452.4, STR 24R. REMOVED AND REPLACED FRAME IAW EO AND EA.SDR SWAA2013022713143Lens · missingFORWARD ENTRY EMERGENCY EXIT LIGHT LENS MISSING. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA2013030113198Fan · faultyUNUSUAL SMELL IN CABIN, WENT AWAY WHEN GASPER & RECIRC FANS TURNED OFF. REMOVED AND REPLACED RECIRC AND GASPER FANS PER MM.SDR SWAA2013031313606Lens · crackedEMERGENCY EXIT LIGHT LENS CRACKED AT FWD GALLEY. REMOVED AND REPLACED LENS PER MM.SDR SWAA2013031413665Frame · crackedFUSELAGE FRAME CRACKED AT STA 400, BETWEEN STR 15L & STR 16L. REPAIRED FRAME PER SRM.SDR SWAA2013031413656Frame · crackedFUSELAGE FRAME AT BS 400 BETWEEN STR 15L AND STR 16L CRACKED. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA2013031413655Angle · crackedANGLE AT BSTA 328, BETWEEN STR 22R AND STR 23R CRACKED. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013022713144Skin · crackedCRACK IN FUSELAGE SKIN CHEM-MILL AT BS 360+2, BETWEEN STRINGER 1 AND 2R. REPAIRED SKIN IAW SRM.SDR SWAA2013031913834Angle · corrodedZ-ANGLE CORRODED BETWEEN BS 219.8 AND BS 227.8, BL 0. REMOVED AND REPLACED Z-ANGLE IAW SRM AND DWG.SDR SWAA2013031413658Tie Clip · crackedTIE CLIP AT BS 663.75, STR 10L CRACKED. REMOVED AND REPLACED TIE CLIP PER SRM.SDR SWAA2013032614168Structure · crackedRT WING CRACK ON LOWER CHORD OF WBL 135.50 AT LEVEL OF STR 2 LOWER SURFACE IN FUEL TANK. REPAIRED CHORD IAW EA.SDR SWAA2013031413646Angle · crackedANGLE AT BS 947+12", BETWEEN STR 25L AND STR 26L AFT CARGO COMPARTMENT CRACKED. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013030813470Angle · crackedANGLE CRACKED AT BS 947.5, BETWEEN STR 25L AND STR 26L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013022212985Lens · loosePASSENGER CABIN EMERGENCY LIGHT LENS AT 11ABC IS UNSECURED. RE-SECURED PER MM.SDR SWAA2013022212984Cable · misroutedAFT ENTRY DOOR SLIDE CABLE IS ROUTED INCORRECTLY. REROUTED CABLE PER TASK CARD MT325-61-06.SDR SWAA2013022212983Slide · looseAFT SERVICE DOOR EMERGENCY EXIT SLIDE IS LOOSE. TIGHTEN AFT SERVICE DOOR EMERGENCY EXIT SLIDE ATTACH BOLTS PER MM.SDR SWAA2013032614167Support Bracket · crackedSUPPORT BRACKET CRACKED AT BS 380, BETWEEN STR 20L TO STR 21L. REMOVED AND REPLACED BRACKET IAW SRM.SDR SWAA2013032614166Skin · crackedFUSELAGE SKIN CRACKED AT BS 360+12, STR 15R. REPAIRED SKIN IAW EA.SDR SWAA2013031413649Channel · crackedVERTICAL CHANNEL AT STA 312+8", FWD ELECTRONIC RACK RIGHT SIDE E/E COMPARTMENT CRACKED. REMOVED AND REPLACED VERTICAL CHANNEL PER SRM.SDR SWAA2013030813469Channel · crackedVERTICAL CHANNEL CRACKED AT BS 294.5 FWD ELECTRONIC RACK RIGHT SIDE E/E COMPARTMENT. REPLACED VERTICAL CHANNEL PER SRM.SDR SWAA2013030513339Web · crackedWEB CRACKED BETWEEN BS 312 TO BS 324, LBL 4. REMOVED AND REPLACED WEB IAW SRM AND DRAWING.SDR SWAA2013022813175Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BSTA 827 STR 16R. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013022112952Skin · crackedTHERE APPEARS TO BE A CRACK IN THE FUSELAGE ABOVE THE FWD CARGO DOOR AT APPROX STA 440 ABD SL 16R. TRANSFERRED FROM LOG PAGE 0008542862. REPAIRED PER SRM 53-00-01-2R-31 AND EA 1-553-21833.SDR SWAA2013040114266Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907, STRINGER 4R. REMOVED AND REPLACED SPLICE IAW EA.SDR SWAA2013040114265Stringer · crackedSTRINGER CRACKED AT BS 1016, STR 4L. REPAIRED STRINGER IAW EA.SDR SWAA2013032614162Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED SPLICE IAW EA.SDR SWAA2013032614161Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED SPLICE IAW EA.SDR SWAA2013031913835Frame · crackedFRAME WEB CRACKED AT BS 328, BETWEEN STR 20R TO STR 21R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013031913829Attach Fitting · crackedATTACHMENT CLIP CRACKED AT BS 348.2, STR 15L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2013031413645Support Angle · crackedSUPPORT ANGLE AT STA 294.5, STR 23L CRACKED. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013030613379Angle · crackedCRACK ON ANGLE LOCATED AT FWD ELECTRONIC RACK LEFT SIDE E/E COMPARTMENT. REMOVED AND REPLACED ANGLE IAW SRM.SDR SWAA2013031913833Web · crackedWEB CRACKED AT BS 294+3, RBL 56. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013031913832Stringer · corrodedSTRINGER CORRODED BETWEEN BS 1112 AND BS 1121, TORQUE BOX RIGHT SIDE. REMOVED AND REPLACED STRINGER IAW SRM AND DWG.SDR SWAA2013031413654Web · crackedWEB AT STA 967, LBL 20 FLOOR STRUCTURE AFT PAX CABIN CRACKED. REMOVED AND REPLACED WEB PER SRM.SDR SWAA2013022713146Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BS 380 AND STR 21L. REPLACED CLIP IAW SRM AND DRAWING.SDR SWAA2013040114308Stringer · crackedSTRINGER CRACKED BETWEEN BS 1006 AND BS 1016, STR 4L. REPAIRED STRINGER IAW EA.SDR SWAA2013040114269Floorbeam · crackedFLOORBEAM CRACKED AT BS 947.5, LBL 53. REPAIRED CHORD IAW EA.SDR SWAA2013031413648Support Angle · crackedSUPPORT ANGLE AT BS 947.5 BETWEEN STR 15R AND STR 17R CRACKED. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013040114254Access Panel · crackedLEFT WING ACCESS PANEL 5753L CRACKED. REMOVED AND REPLACED PANEL IAW SRM.SDR SWAA2013040114268Frame · crackedFRAME CRACKED AT BS 360, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME IAW EO AND EA.SDR SWAA2013032614165Plate · crackedLEFT WING UPPER SURFACE PLATE CRACKED BETWEEN WBL 254 TO 279.25. REMOVED AND REPLACED PLATE IAW DWG AND SRM.SDR SWAA2013032514028Frame · crackedWEB CRACKED STUB FRAME BS 277, BETWEEN STR 15L AND STR 16L. REPAIRED WEB IAW EA.SDR SWAA2013032113947Frame · crackedSTUB FRAME CRACKED AT BS 294.5, STR 17R. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013031913836Stiffener · crackedSTIFFENER CRACKED AT BS 332.1 STR 8R. REMOVED AND REPLACED STIFFENER IAW SRM AND DWG.SDR SWAA2013031913831Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 348.2, STR 15L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013031413657Angle · crackedLEFT WING FIXED TRAILING EDGE ANGLE CRACKED AT WS 537.872. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013031413653Angle · crackedLEFT WING FIXED TRAILING EDGE ANGLE CRACKED AT WS 531. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013031413647Tie Clip · crackedTIE CLIP AT BS 277 AND STR 15L FWD CRACKED. REMOVED AND REPLACED TIE CLIP PER SRM.
Back to Boeing 737-5H4