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 SWAA2012041703175Skin · puncturedLEFT WING I/B FORE FLAP LOWER SURFACE PUNCTURED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2012041603139Web · corrodedR2 DOOR THRESHOLD CENTER FLOOR PAN WEB CORRODED AT STA 980. REMOVED AND REPLACED WEB PER BAC DWG & SRM.SDR SWAA2012043003602Floorbeam · crackedFLOORBEAM WEB CRACKED AT BS 295.5, LBL 53. REPAIRED WEB IAW EA.SDR SWAA2012042703516Skin · crackedSKIN CRACKED AT BS 847, STR 17L. REPAIRED SKIN IAW AAR EA.SDR SWAA2012042703515Skin · crackedSKIN CRACKED AT BS 827, STR 19L. REPAIRED SKIN IAW AAR EA.SDR SWAA2012042703514Skin · crackedSKIN CRACKED AT BS 767, STR 23L. REPAIRED SKIN IAW AAR EA.SDR SWAA2012042703513Skin · crackedSKIN CRACKED AT BS 767, STR 24L. REPAIRED SKIN IAW AAR EA.SDR SWAA2012041203074Web · crackedFWD CARGO DOOR CUTOUT AREA AFT TORQUE BOX LOWER AFT CORNER INNER WEB CRACKED. REMOVED AND REPLACED WEB PER MM, SRM, & BAC DWG.SDR SWAA2012041103013Angle · crackedSHEAR WEB ANGLE CRACKED BETWEEN BS 380 TO BS 400, BL 0. REMOVED AND REPLACED ANGLE PER BAC DWG AND SRM.SDR SWAA2012043003603Floorbeam · crackedMAIN CABIN FLOORBEAM T-CAP CRACKED AT BS 294.5, LBL 52. REMOVED T-CAP IAW SRM.SDR SWAA2012043003601Web · crackedFORWARD CARGO PIT DOOR CUTOUT AREA LOWER TORQUE BOX CRACKED BETWEEN BS 420 TO BS 440, STR 26R. REPAIRED WEB PER EA.SDR SWAA2012043003600Skin · crackedL2 DOOR FUSELAGE SKIN FWD LOWER CORNER CRACKED AT UPPER RADIUS OF CORNER LOWEST FASTENER. REPAIRED SKIN PER EA.SDR SWAA2012042703489Crease Beam · corrodedRT CREASE BEAM WEB CORRODED BETWEEN BS 847 TO BS 86.7. REMOVED & REPLACED WEB IAW BAC DWG, SRM, & AMM.SDR SWAA2012042603432Crease Beam · corrodedLT CABIN CREASE BEAM WEB CORRODED AT BS 370. REMOVED AND REPLACED WEB IAW BAC DWG AND SRM.SDR SWAA2012042403353Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986, RBL 45. REPAIRED FLOORBEAM PER SRM AND EA.SDR SWAA2012042403352Crease Beam · corrodedLT CREASE BEAM CORRODED AT BS 867 TO BS 887. REPAIRED BEAM PER SRM AND BAC DRAWING.SDR SWAA2012041803220Floor Support · corrodedRT FLOOR SUPPORT BS 986.5, RBL 16 CORRODED. REMOVED AND REPLACED FLOOR SUPPORT PER SRM.SDR SWAA2012040902877Web · crackedCOCKPIT FLOOR WEB CRACKED AT BS 247, RBL 23. REMOVED AND REPLACED WEB PER ACO.SDR SWAA2012040202765Flashlight · inoperativeFWD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT IAW MM.SDR SWAA2012050703734Spar · crackedRT HORIZONTAL STABILIZER REAR SPAR WEB CRACKED AT BS 1146, RBL 14. REPAIRED WEB IAW EO AND EA.SDR SWAA2012040302793Skin · crackedFUSELAGE SKIN CRACKED AT BS 787. REPAIRED SKIN PER SRM.SDR SWAA2012050703713Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT BS 663.75+2, RBL 24.5. REPAIRED BEAM IAW EA AND EO.SDR SWAA2012050403701Skin · crackedSKIN CRACKED AT BS 847, STR 18L. REPAIRED SKIN IAW SRM.SDR SWAA2012050403700Skin · crackedSKIN CRACKED AT BS 767, STR 19L. REPAIRED SKIN IAW SRM.SDR SWAA2012050203638Frame · crackedFRAME CRACKED AT BS 460, STR 14L. REPAIRED FRAME IAW EO.SDR SWAA2012050103618Beam · crackedLT BEAM WEB CRACKED AT BS 1096, LBL 8. REPAIRED WEB IAW EO.SDR SWAA2012040302814Skin · crackedLT HORIZONTAL STABILIZER SKIN CRACKED AT STA. 96.6. REPAIRED SKIN PER EA.SDR SWAA2012040302813Skin · crackedFUSELAGE SKIN CRACKED AT BS 360+5, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA2012032902712Toggle · looseAIRCRAFT SHUTTER AND YOKE VIBRATION 210 KTS FLAPS MOVING FROM 2 TO POSITION 5, 2, TO 4 SECONDS. REMOVED AND REPLACED FLAP TOGGLES PER MM.SDR SWAA2012050403699Skin · crackedSKIN CRACKED BETWEEN BS 764 TO BS 765.25, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA2012050303668Frame · crackedFRAME CRACKED AT BS 947.5, AT STR 18L. REPAIRED FRAME IAW EO.SDR SWAA2012040202764Light · inoperativeRT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT INOP BETWEEN ROW 16 TO ROW 17. REPAIRED LIGHT PER MM.SDR SWAA2012050403698Skin · crackedSKIN CRACKED AT BS 827 + 4, STR 19L. REPAIRED SKIN IAW SRM.SDR SWAA2012050303667Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STR 24R TO STR 25R. REPAIRED FRAME IAW EO.SDR SWAA2012042703519Flap · delaminatedLEFT WING O/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2012042503382Skin · crackedRT INBD FORE FLAP LOWER SURFACE CRACKED. REPAIRED FLAP PER SRM.SDR SWAA2012041102999Tie Clip · crackedTIE CLIP CRACKED AT BS 727B, STR 21L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012041102998Skin · delaminatedLT WING AFT FLAP LOWER SURFACE DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2012040902863Tie Clip · crackedTIE CLIP CRACKED AT BS 747, STR 23L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012040302812Bracket · crackedFRAME BRACKET CRACKED AT BS 827, BETWEEN STR 1R AND STR 2R. REMOVED AND REPLACED BRACKET IAW SRM AND DWG.SDR SWAA2012040302811Bracket · crackedFRAME BRACKET CRACKED AT BS 827, BETWEEN STR 1L AND STR 2L. REMOVED AND REPLACED BRACKET IAW SRM AND DWG.SDR SWAA2012040302810Bracket · crackedFRAME BRACKET CRACKED AT BS 847, BETWEEN STR 1R AND STR 2R. REMOVED AND REPLACED BRACKET IAW SRM AND DWG.SDR SWAA2012040302809Bracket · crackedFRAME BRACKET CRACKED AT BS 847, BETWEEN STR 1L AND STR 2L. REMOVED AND REPLACED BRACKET IAW SRM AND DWG.SDR SWAA2012040302808Tie Clip · crackedTIE CLIP CRACKED AT BS 520, STR 9L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012040302807Tie Clip · crackedTIE CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012040302806Tie Clip · crackedTIE CLIP CRACKED AT BS 767, STR 16L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012050403697Skin · crackedSKIN CRACKED AT BS 800, STR 18L. REPAIRED SKIN IAW SRM.SDR SWAA2012050403696Skin · crackedFUSELAGE SKIN CRACKED AT BS 787-3, STR 23L. REPAIRED SKIN IAW REO AND EA.SDR SWAA2012050403695Skin · crackedFUSELAGE SKIN CRACKED BS 787-7, STR 19L. REPAIRED SKIN IAW REO AND EA.SDR SWAA2012050303665Skin · crackedSKIN CRACKED AT BS 807, STR 23L. REPAIRED SKIN IAW SRM & EA.
Back to Boeing 737-5H4