Boeing 737-3H4
Service difficulty reports · 52,340
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 = '7373H4' 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 = '7373H4' 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 SWAA2016052352000Channel · crackedSPLICE CHANNEL CRACKED AT BS 360, STRINGER 14L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2016051751865Shear Tie · corrodedAFT PIT SHEAR TIE CORRODED AT BS 727E, BETWEEN BL 0 - RBL 6. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2016051351765Skin · delaminatedRIGHT WING INBD FORE FLAP UPPER SKIN DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2016050351505Battery Pack · dischargedAFT LT SIDE EMER LIGHT BATTERY PACK INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2016061352772Skin · crackedLEFT WING UPPER SKIN CRACKED AT WS 208, COMMON TO REAR SPAR UPPER CHORD FORWARD ROW. REPAIRED SKIN IAW EA.SDR SWAA2016060952719Frame · crackedFRAME INNER WEB CRACKED AT BS 639, STRINGER 16R. REPAIRED WEB IAW EA.SDR SWAA2016060652484Spar · crackedLEFT WING REAR SPAR WEB CRACKED AT LSS 222.64, UPPER FASTENER HOLE 5. REPAIRED WEB IAW ER & EA.SDR SWAA2016060652269Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 420 - 440. R & R WEB IAW SRM & DWG.SDR SWAA2016060652268Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 807 - 827. R & R WEB IAW SRM & DWG.SDR SWAA2016060652267Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 400 - 420. R & R WEB IAW SRM & DWG.SDR SWAA2016050351522Lens · defectiveFORWARD ENTRY DOOR EMER EXIT LIGHT COVER INOPERATIVE. R & R LENS IAW SIP.SDR SWAA2016062753231Link Assy · corrodedLT MAIN LANDING GEAR SUPPORT BEAM SWING LINK CORRODED ON AFT FACE AT BUSHINGS. R&R LINK ASSEMBLY IAW EA.SDR SWAA2016062253123Bear Strap · crackedL1 DOOR LOWER AFT CORNER, BEAR STRAP CRACKED. REPAIRED BEAR STRAP IAW SRM & EA.SDR SWAA2016050251489Battery · dischargedFORWARD OTBD EMER FLASHLIGHT INOPERATIVE. R & R BATTERY IAW AMM.SDR SWAA2016061052745Frame · corrodedFRAME CORRODED AT BS 867, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2016060652530Shear Tie · corrodedSHEAR TIE CORRODED AT BS 986.5, BETWEEN STRINGER 27R - 27L. R & R SHEAR TIE IAW DWG & SRM.SDR SWAA2016060652502Shear Tie · corrodedSHEAR TIE CORRODED AT BS 727E, BETWEEN STRINGER 26R - 27R. R & R SHEAR TIE IAW SRM.SDR SWAA2016060652542Web · corrodedAFT CARGO FLOOR WEB CORRODED BETWEEN BS 847 - 867, BETWEEN RBL 22 - 26. R & R WEB IAW SRM & DWG.SDR SWAA2016060652352Spar · crackedRIGHT WING REAR SPAR WEB CRACKED AT RSS 221, UPPER FASTENER ROW, HOLE 3. REPAIRED WEB IAW EA.SDR SWAA2016060652351Spar · crackedLEFT WING REAR SPAR WEB CRACKED AT RSS 221, UPPER FASTENER ROW, HOLE 3. REPAIRED WEB IAW EA.SDR SWAA2016052051968Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 907, STRINGER 20R. R & R SPLICE IAW DWG & SRM.SDR SWAA2016052051967Stringer Splice · corrodedSTRINGER SPLICE CORRODED STRINGER SPLICE AT BS 907, STRINGER 23L. R & R SPLICE IAW DWG & SRM.SDR SWAA2016052051966Shear Tie · corrodedSHEAR TIE CORRODED AT BS 887, BETWEEN STRINGER 21L - 22L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2016051851889Shear Tie · corrodedSHEAR TIE CORRODED AT BS 986.5, BETWEEN STRINGER 26L - 27L. R & R SHEAR TIE IAW DWG & SRM.SDR SWAA2016051851888Angle · corrodedANGLE CORRODED AT BS 867, STRINGER 26R. R & R ANGLE IAW DWG & SRM.SDR SWAA2016051851887Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 747, STRINGER 27L. R & R CLIP IAW SRM & DWG.SDR SWAA2016062253122Structure · crackedRT WING UPPER CHORD CRACKED BETWEEN RSS 221.54 TO RSS 222.64. REPAIRED CHORD IAW ER & EA.SDR SWAA2016062253121Web · crackedRIGHT WING WEB CRACKED BETWEEN RSS 219.54 TO RSS 222.64. REPAIRED WEB IAW ER & EA.SDR SWAA2016060652403Structure · crackedLEFT WING UPPER CHORD CRACKED IN NR 5 HOLE. REPAIRED CHORD IAW ER & EA.SDR SWAA2016051851904Intercostal · crackedINTERCOSTAL WEB CRACKED AT BS 277, STRINGER 14R. R & R WEB IAW EA.SDR SWAA2016051751863Angle · crackedL1 DOOR AFT SIDE UPPER SURFACE ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2016051251736Support Fitting · crackedR1 DOOR SUPPORT FITTING CRACKED AT BS 296, STRINGER 8R. R & R FITTING IAW SRM & DWG.SDR SWAA2016050951606Angle · crackedL1 DOOR CUT OUT AFT TRIM RETAINING ANGLE CRACKED. R & R ANGLE MM.SDR SWAA2016050251479Skin · crackedSKIN CRACKED AT BS 520+9.5, LBL 5. REPAIRED SKIN IAW EA.SDR SWAA2016042951437Regulator · faultyDIVERSION & DECLARED EMER. AT FC 36 DEGREES CABIN ALTITUDE HORN SOUNDED, ALTIMETER LIGHT DID NOT ILLUMINATE. NO MASKED POPPED, OUTFLOW VLV DID NOT OPEN ON THE GND. R & R NR 2 ENG HIGH STAGE PRESS REGULATOR IAW AMM.SDR SWAA2016042951431Slide · openL1 DOOR ESCAPE SLIDE CONTAINER OPEN. R & R SLIDE IAW MT.SDR SWAA2016070553443Rib · crackedRIGHT HORIZONTAL STABILIZER LEADING EDGE INNER RIB CRACKED AT HSS 188.94. REPAIRED RIB IAW SRM & DWG.SDR SWAA2016062453201Spar · crackedRIGHT WING REAR UPPER SPAR CHORD CRACKED AT RSS 224.14. REPAIRED CHORD IAW EA.SDR SWAA2016062453200Spar · crackedLEFT WING UPPER SPAR CHORD CRACKED AT RSS 224.14 ON CHORD. REPAIRED CHORD IAW EA.SDR SWAA2016060852651Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 459, STRINGER 17R. R & R WEB IAW SRM & DWG.SDR SWAA2016060652480Skin · crackedRIGHT WING UPPER WING SKIN CRACKED ABOVE RSS 239. REPAIRED SKIN IAW EA.SDR SWAA2016060652366Reveal · crackedL2 DOOR CORNER REVEAL CRACKED AT BS 951, BETWEEN STRINGER 17L - 16L. R & R REVEAL IAW SRM & DWG.SDR SWAA2016052652159Spar · crackedRIGHT WING AFT SPAR WEB CRACKED AT RSS 221.1 IN UPPER FASTENER HOLE. REPAIRED WEB IAW EA.SDR SWAA2016052652137Skin · crackedRIGHT WING UPPER WING SKIN AFT HOLE CRACKED AT RSS 238. REPAIRED SKIN IAW ER & EA.SDR SWAA2016052652136Skin · crackedRIGHT WING UPPER WING SKIN AFT HOLE CRACKED, BETWEEN RSS 255 - 250.7. REPAIRED SKIN IAW ER & EA.SDR SWAA2016052652130Spar · crackedLEFT WING UPPER REAR SPAR CHORD VERTICAL FLANGE UPPER ROW CRACKED. REPAIRED FLANGE IAW EA.SDR SWAA2016052652129Floorbeam · corrodedFLOORBEAM UPPER FLANGE CORRODED AT BS 947.5, LBL 11. REPAIRED FLOORBEAM IAW EA.SDR SWAA2016052552110Skin · crackedLEFT WING UPPER SKIN STATION RSS 254 AFT, FASTENER HOLE CRACKED. REPAIRED SKIN IAW SRM & EA.SDR SWAA2016052552108Skin · crackedLEFT WING UPPER SKIN TE CRACKED AT STATION RSS 233. REPAIRED SKIN IAW EA.SDR SWAA2016052552107Skin · crackedRIGHT WING UPPER SKIN CRACKED BETWEEN RSS 264.7 - 269. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4