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 SWAA2013070117767Light · missingAFT LAV FWD WALL EMERGENCY EXIT LIGHT MISSING. INSTALLED LIGHT PER SOPM.SDR SWAA2013081219103Door Frame · crackedR1 DOOR CUTOUT STUB FRAME CRACKED AT STATION 295. R&R CUTOUT IAW DRAWING & SRM.SDR SWAA2013080818959Channel · corrodedFWD LAVATORY SERVICE PAN INTERIOR SURFACE UPPER CHANNEL CORRODED. R&R CHANNEL IAW SRM & DRAWING.SDR SWAA2013073018661Door Frame · corrodedFWD CARGO DOOR CUT OUT FWD FRAME CLOSURE WEB CORRODED AT STATION 400, STRINGER 23R. REPAIRED WEB IAW SRMSDR SWAA2013072218414Attach Bracket · crackedFS FRAME TO OVERHEAD DUCT RT ATTACHED BRACKET CRACKED AT STATION 907. R&R BRACKET IAW SRM & DRAWING.SDR SWAA2013072218413Attach Bracket · crackedFS FRAME TO OVERHEAD DUCT LT ATTACHED BRACKET CRACKED AT STATION 907. R&R BRACKET IAW SRM & DRAWING.SDR SWAA2013062717660Fitting · crackedR1 DOOR AFT SIDE OF DOOR CUTOUT STIFFENER CLIP CRACKED, JUST AFT OF DOOR STOP AT FRAME. R&R CLIP IAW SRM & DRAWING.SDR SWAA2013080818958Crease Beam · corrodedRT CREASE BEAM WEB CORRODED BETWEEN STATION 747 & STATION 767. REPAIRED WEB IAW SRM.SDR SWAA2013071818329Strap · crackedRT CREASE BEAM INBD ANGLE SPLICE STRAP CRACKED AT STATION 530, RBL 53. R&R STRAP IAW DRAWING & SRM.SDR SWAA2013071718301Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 482, STRINGER 16L. R&R CLIP IAW SRM & DRAWING.SDR SWAA2013070217829Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 907, STRINGER 8L. R&R CLIP IAW DRAWING & SRM.SDR SWAA2013070117764Stringer Clip · crackedSTRINGER CLIP CRACKED AT STA 380, STR 8R. R&R CLIP IAW SRM AND DWG.SDR SWAA2013062717661Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400, STRINGER 8L. R&R CLIP IAW DRAWING & SRM.SDR SWAA2013071118119Crease Beam · corrodedLT CREASE BEAM WEB UPPER SURFACE CORRODED AT BS 869. REPAIRED WEB IAW SRM.SDR SWAA2013070117762Crease Beam · corrodedLT CREASE BEAM WEB UPPER SURFACE CORRODED AT BS 450. R&R WEB IAW SRM AND DWG.SDR SWAA2013070117761Crease Beam · corrodedLT CREASE BEAM WEB UPPER SURFACE CORRODED AT BS 403. R&R SHEAR WEB IAW SRM & DWG.SDR SWAA2013070117763Crease Beam · corrodedLT CREASE BEAM WEB UPPER SURFACE CORRODED AT BS 757. R&R WEB IAW SRM.SDR SWAA2013062417482Lens · looseLT EMERGENCY EXIT BULLNOSE LIGHT LOOSE AT ROW 3. SECURED LENS IAW MM.SDR SWAA2013080818957Skin · crackedRT MAIN WW OUTER STRAP CRACKED AT STATION 727, STRINGER 18A. REPAIRED SKIN IAW EA.SDR SWAA2013080818954Frame · crackedRT MAIN WW FRAME STATION 727 FWD FLANGE, CRACKED AT FWD LOWER HOLE & UPPER AFT HOLE COMMON TO STRINGER 18A. R&R CHORD IAW EA.SDR SWAA2013080818953Frame · crackedLT MAIN WW FRAME STATION 727 FWD FLANGE, CRACKED AT FWD LOWER HOLE COMMON TO STRINGER 18A. R&R CHORD IAW EA.SDR SWAA2013072218412Bracket · crackedVERTICAL "L" BRACKET CRACKED AT STATION 986, STRINGER 3L. R&R "L" BRACKET IAW SRM.SDR SWAA2013071118108Attach Angle · crackedVERTICAL ''Z'' ANGLE FLOOR SUPPORT WEB ATTACH ANGLE CRACKED BETWEEN STATION 927 & STATION 947, BETWEEN STRINGER 24R & STRINGER 25R. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013070918044Door Frame · crackedAFT CARGO PIT BS 794 FORWARD DOOR FRAME UPPER CLOSE OUT WEB LOWER EDGE CRACKED. R&R WEB IAW SRM & DRAWING.SDR SWAA2013070817975Stringer Clip · corrodedSTRINGER CLIP CORRODED AT STATION 794, STRINGER 26R. R&R CLIP IAW SRM & DRAWING.SDR SWAA2013070817974Angle · corrodedSTRINGER ANGLE CORRODED AT STATION 794, STRINGER 25R. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013070517947Intercostal · corrodedFLOOR SUPPORT INTERCOSTAL WEB CORRODED BETWEEN STATION 787 - STATION 794, STRINGER 25R. R&R INTERCOSTAL IAW SRM & DRAWING.SDR SWAA2013062517577Stringer Clip · crackedAFT SIDE OF FRAME STRINGER CLIP CRACKED AT BS 947, STRINGER 25R. R&R STRINGER CLIP IAW SRM & DRAWING.SDR SWAA2013080718931Retainer · crackedNR 2 PYLON PLASTIC NUTPLATE RETAINER FOR PANEL 58710R CRACKED AT AFT INBD EDGE. R&R RETAINER IAW SRM & AMM.SDR SWAA2013080118729Floor Support · corrodedFLOOR SUPPORT UPPER SURFACE CORRODED AT STATION 980 - 2, LBL 18. R&R SUPPORT IAW SRM & DRAWING.SDR SWAA2013072418527Web · corrodedLAVATORY PAN WEB CORRODED BETWEEN STATION 986 TO STATION 1006, LBL 36. R&R WEB IAW SRM & DRAWING.SDR SWAA2013071818322Skin · crackedFS SKIN CRACKED AT STATION 853, STRINGER 24L. REPAIRED SKIN IAW SRM.SDR SWAA2013071218170Crease Beam · corrodedRT CREASE BEAM INNER CHORD CORRODED AT STATION 294. R&R BEAM IAW SRM.SDR SWAA2013080118738Crease Beam · corrodedRT CREASE BEAM INNER CHORD CORRODED BETWEEN STATION 947 TO STATION 992. R&R CHORD IAW SRM & DRAWING.SDR SWAA2013072918659Floorbeam · corrodedFLOOR BEAM CORRODED AT BS 986, LBL 4 TO LBL 15. REPAIRED BEAM IAW SWA EA..SDR SWAA2013072918658Floor Support · corrodedLONGITUDINAL FLOOR SUPPORT CORRODED AT BS 967 TO BS 986, RBL 18. REPAIRED SUPPORT IAW SRM.SDR SWAA2013071518251Skin · delaminatedLT WING INBD TE FORE FLAP UPPER SKIN DELAMINATED. REPAIRED SKIN IAW SRM & AMM.SDR SWAA2013070117760Channel · corrodedAFT CARGO COMPARTMENT FLOOR STRUCTURE FLOOR PANEL SUPPORT CHANNELS CORRODED AT STA 727B+6, RBL 3. REPAIRED CHANNEL IAW SRM AND EA.SDR SWAA2013062717659Stringer · crackedSTRINGER CRACKED AT BS 907, STRINGER 4L. R&R STRINGER IAW SRM & DRAWING.SDR SWAA2013062617619Strip · crackedL1 DOOR FWD UPPER CORNER OF DOOR CUTOUT COVER ATTACH STRIP CRACKED JUST BELOW STR 6L. REPAIRED STRIP IAW SRM & DRAWING.SDR SWAA2013062517576Channel · crackedLT WING UPPER T/E PANEL SUPPORT CHANNEL CRACKED. R&R CHANNEL IAW SRM & DRAWING.SDR SWAA2013062517575Angle · crackedRT WING FIXED T/E UPPER INBD PANEL INBD ANGLE LOWER AFT ATTACH POINT CRACKED. R&R ANGLE IAW SRM.SDR SWAA2013062417483Bracket · crackedLT WING TRAILING EDGE, AFT OF AILERON CABLE TURN AROUND SPRING, COVE PANEL OB ATTACH ANGLE CRACKED. R&R BRACKET IAW SRM & DRAWING.SDR SWAA2013062417481Skin · crackedFUSELAGE SKIN CRACKED AT BS 785, STRINGER 22L. REPAIRED SKIN IAW SRM.SDR SWAA2013072418526Frame · crackedFRAME CRACKED AT STATION 482, STRINGER 20L. REPAIRED FRAME IAW SRM.SDR SWAA2013062817721Light · inoperativeLT EMERGENCY EXIT BULLNOSE LIGHT INOPERATIVE AT ROW 6. R&R BULB IAW AMM.SDR SWAA2013062817720Skin · crackedFUSELAGE SKIN VERTICAL CRACKED AT BS 907, STRINGER 3L. REPAIRED DOUBLER IAW EA.SDR SWAA2013062617618Battery Pack · dischargedR1 DOOR EMERGENCY LIGHTS INOPERATIVE. R&R BATTERY PACK IAW AMM.SDR SWAA2013070117759Cover · crackedL2 DOOR CUTOUT WARNING SWITCH COVER CRACKED. REMOVED AND REPLACED COVER IAW AMM.SDR SWAA2013061817215Fan · faultyDIVERSION/DECLARED EMERGENCY AT CRUISE FL 370, F/A REPORTED STRONG ELECTRICAL BURNING SMELL IN FWD GALLEY AREA. R & R AIR RECIRCULATION FAN IAW MM.
Back to Boeing 737-5H4