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 SWAA2015011935878Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500C, STRINGER 11R. R & R CLIP IAW DWG.SDR SWAA2015011935877Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500B, STRINGER 11R. R & R CLIP IAW DWG.SDR SWAA2015011535789Bracket · crackedRIGHT WING NR 5 GND SPOILER SUPPORT FITTING BRACKET CRACKED. R & R BRACKET IAW SRM & DWG.SDR SWAA2015011535788Strap · crackedSTRAP CRACKED AT BS 344, LBL 11.10. R & R STRAP IAW SRM & DWG.SDR SWAA2015031337432Shear Tie · corrodedFUSELAGE SHEAR TIE CORRODED AT STATION 727D, STRINGER 27L & 27R. R & R SHEAR TIE IAW SRM.SDR SWAA2015031337431Shear Tie · corrodedFUSELAGE SHEAR TIE CORRODED AT STATION 727E, STRINGER 27L. R & R SHEAR TIE IAW SRM.SDR SWAA2015031337430Shear Tie · corrodedFUSELAGE SHEAR TIE CORRODED AT STATION 727E, STRINGER 26R. R & R SHEAR TIE IAW SRM.SDR SWAA2015031237373Shear Tie · corrodedSHEAR TIE CORRODED AT BS 787, BETWEEN STRINGER 27L TO 27R. REPAIRED SHEAR TIE IAW SRM & DWG.SDR SWAA2015030937248Shear Tie · corrodedSHEAR TIE CORRODED AT BS 727B, BETWEEN STRINGER 27L TO 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015030537161Shear Tie · corrodedSHEAR TIE CORRODED AT BS 727E, BETWEEN STRINGER 27L TO 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015030537146Shear Tie · corrodedSHEAR TIE CORRODED AT BS 827, BETWEEN STRINGER 27R TO 26R. REPAIRED SHEAR TIE IAW SRM & DWG.SDR SWAA2015030337064Shear Tie · corrodedSHEAR TIE CORRODED BETWEEN BS 927 TO 943, LBL 2. R & R SHEAR TIE IAW SRM.SDR SWAA2015030337063Shear Tie · corrodedSHEAR TIE CORRODED AT BS 986.5, BETWEEN STRINGER 24R TO 25R. R & R SHEAR TIE IAW DWG & SRM.SDR SWAA2015022436856Shear Tie · corrodedSHEAR TIE CORRODED AT BS 727E, STRINGER 26R. R & R SHEAR TIE IAW SRM.SDR SWAA2015022436855Shear Tie · corrodedSHEAR TIE CORRODED AT BS 727E, STRINGER 27L. R & R SHEAR TIE IAW SRM.SDR SWAA2015020336302Fitting · corrodedLEFT WING AREA COVERED BY PANEL 5735L, FWD & AFT HYD LINES END FITTING CORRODED. REPAIRED FITTING IAW AMM.SDR SWAA2015013036232Lens · looseLEFT EMER LIGHT BULLNOSE LENS LOOSE AT ROW 6. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015012936184Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908, STRINGER 4L. R & R SPLICE IAW DWG.SDR SWAA2015011435731Lens · brokenFORWARD ENTRY DOOR LOWER EMER LIGHT LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2015031237372Flap Track · corrodedRIGHT WING NR 6 FLAP TRACK ASSEMBLY INBD & OTBD TRACK CORRODED FWD END & ALONG THE EDGES. R & R FLAP TRACK ASSEMBLY IAW AMM.SDR SWAA2015030237020Crease Beam · corrodedRIGHT CREASE WEB CORRODED ON LOWER SURFACE AT BS 500B+4. R & R WEB IAW SRM.SDR SWAA2015022736966Angle · crackedRIGHT WING OTBD NR 6 FLAP TRACK ASSEMBLY PYLON COVER ANGLE STRUCTURE CRACKED AT WBL 198.60. R & R ANGLE IAW SRM.SDR SWAA2015020636380Tee Fitting · crackedFORWARD RT PAX CABIN JUST AFT OF 1R DOOR AT STRINGER 8R INNER T CHORD COMMON TO BOTTOM STRINGER WEB CRACKED FWD ATTACH FASTENER. R & R T CHORD IAW SRM & DWG.SDR SWAA2015020536346Angle · crackedLEFT WING TE AT AILERON 3RD HINGE FROM OTBD END ATTACHMENT STRUCTURE, INBD SIDE CURVED ANGLE CRACKED IN LOWER RADIUS. R & R ANGLE IAW SRM & DWG.SDR SWAA2015020436306Fitting · crackedFORWARD PAX CABIN RT FWD OF 1R, STRINGER 8 FITTING COMMON TO UPPER FWD DOOR CORNER PAN & FWD UPPER STOP FITTING CRACKED. R & R FITTING IAW SRM & DWG.SDR SWAA2015012035901Skin · crackedFUSELAGE SKIN CRACKED AT BS 360, STRINGER 2L. REPAIRED SKIN IAW EA.SDR SWAA2015011335713Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STRINGER 26L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015021836689Web · crackedAFT CARGO DOOR LOWER AFT CORNER SIDE FRAME WEB CRACKED. R & R DOOR IAW MM.SDR SWAA2015020436305Floorbeam · corrodedLEFT FWD PAX CABIN FLOORBEAM T CAP CORRODED AT BS 344, LBL 9.5. REPAIRED T CAP IAW SRM.SDR SWAA2015020436304Floorbeam · corrodedFORWARD RT FLOORBEAM T CAP CORRODED AT BS 294.5, RBL 39. R & R T CAP IAW SRM.SDR SWAA2015013036219Crease Beam · crackedRIGHT CREASE BEAM INNER CHORD CRACKED AT BS 639, WL 208. R & R CHORD IAW EA.SDR SWAA2015012636042Crease Beam · corrodedRIGHT AFT SERVICE DOOR CREASE BEAM THRESHOLD SUPPORT ANGLE CORRODED BETWEEN BS 964 - 983. R & R CREASE BEAM IAW SRM & DWG.SDR SWAA2015011435732Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727D, STRINGER 3L. R & R CLIP IAW SRM & DWG.SDR SWAA2015011435730Angle · crackedLEFT WING TE ANGLE CRACKED AT WBL 204. R & R ANGLE IAW SRM & DWG.SDR SWAA2015011235652Flashlight · not seatedAFT EMER FLASHLIGHT INOPERATIVE. RESEATED FLASHLIGHT IN BASE IAW SIP.SDR SWAA2015030337062Frame · crackedFUSELAGE FRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A LOWER FWD OPEN BOLT HOLE. R & R CHORD IAW ER & EA.SDR SWAA2015030337061Frame · crackedFUSELAGE FRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A LOWER FWD OPEN BOLT HOLE. R & R CHORD IAW ER & EA.SDR SWAA2015030237019Flap Track · corrodedRIGHT WING NR 5 FLAP TRACK ROLLER TRACK CORRODED. R & R NR 5 FLAP TRACK IAW SRM.SDR SWAA2015020636374Crease Beam · corrodedR1 DOOR ON INNER CREASE BEAM CORD CORRODED BETWEEN BS 294 TO 332, BETWEEN RBL 53 TO RBL 60. REPAIRED BEAM IAW SRM & DWG.SDR SWAA2015020236279Skin · crackedLEFT BS 747+10 UPPER AFT WINDOW SKIN CORNER CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2015011235689Wire · brokenLEFT EMER EXIT LIGHT ERRATIC. FOUND WIRE BROKEN, REPAIRED IAW AMM.SDR SWAA2015011235651Wire · brokenRIGHT EMER EXIT LIGHT ERRATIC. FOUND WIRE BROKEN, REPAIRED IAW AMM.SDR SWAA2015011235650Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 538, STRINGER 27R. R & R CLIP IAW SRM.SDR SWAA2015011235646Lens · dirtyOVERWING EMER EXIT LIGHT LENS DISCOLORED. CLEANED LENS IAW AMM.SDR SWAA2015011235645Lens · looseLEFT CABIN EMER EXIT LIGHT LENS LOOSE AT ROW 1. SECURED LENS IAW MM.SDR SWAA2015020236269Skin · crackedLEFT BS 520+10 LOWER AFT WINDOW SKIN CORNER CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2015012836157Skin · crackedLEFT BS 520+10 UPPER FWD WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2015012235980Skin · crackedLEFT BS 500B+10 UPPER FWD WINDOW CORNER SKIN CRACKED AT HOLE 3. REPAIRED SKIN IAW SB.SDR SWAA2015012235979Skin · crackedLEFT BS 380+10 UPPER FWD WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2015011335720Battery Pack · faultyCLIMB OUT FROM MCI FLIGHT ATTENDANT ADVISED THAT ALL EMER LIGHTS FROM OVERWING EXIT AFT WERE ILLUMINATED. FLIGHT DECK SWITCH WAS IN ARMED POSITION & AFT FLIGHT ATTENDANT SWITCH IN NORMAL POSITION. LIGHTS FWD OF OVERWING EXIT REMAINED OFF. R & R BATTERY PACK
Back to Boeing 737-3H4