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 SWAA2015091543905Shear Tie · corrodedSHEAR TIE CORRODED AT BS 867, BETWEEN LBL 4 - RBL 4. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015091543903Skin · crackedLEFT WING TE EDGE UPPER SKIN AT REAR SPAR, CRACKED IN FASTENER HOLE AFT FASTENER ROW AT WS 259. REPAIRED SKIN IAW SRM & EA.SDR SWAA2015091543902Skin · crackedLEFT WING TE UPPER SKIN AT REAR SPAR, CRACKED IN FASTENER HOLE AFT FASTENER ROW AT WS 255. REPAIRED SKIN IAW EA.SDR SWAA2015091443851Skin · crackedLEFT WING TE UPPER SKIN AT REAR SPAR, FOUND CRACKED IN FASTENER HOLE AFT FASTENER ROW AT WS 254. REPAIRED SKIN IAW SRM & EA.SDR SWAA2015091443850Skin · crackedLEFT WING TE UPPER SKIN AT REAR SPAR, FOUND CRACKED IN FASTENER HOLE AFT FASTENER ROW AT WS 239. REPAIRED SKIN IAW SRM & EA.SDR SWAA2015091443849Skin · crackedLEFT WING TE UPPER SKIN AT REAR SPAR, FOUND CRACKED INDICATION IN FASTENER HOLE AFT FASTENER ROW AT WS 236. REMOVED SKIN IAW SRM & EA.SDR SWAA2015091443848Skin · crackedLEFT WING TE UPPER SKIN CRACKED AT REAR SPAR AT WS 231. REPAIRED SKIN IAW EA.SDR SWAA2015091443873Fitting · crackedLEFT AFT MLG BEAM FITTING CRACKED. R & R FITTING IAW SRM.SDR SWAA2015091443852Skin · crackedLEFT WING TE UPPER SKIN AT REAR SPAR FOUND CRACKED IN FASTENER HOLE AFT FASTENER ROW AT WS 267. REPAIRED SKIN IAW SRM & EA.SDR SWAA2015082443092Slide · out of adjustL1 DOOR SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW MT.SDR SWAA2015082143066Flap · damagedRIGHT WING INBD FORE FLAP DAMAGED ON INBD END. R & R FORE FLAP IAW AMM.SDR SWAA2015092344216Fitting · crackedRIGHT WING AFT SPAR, AFT GEAR BEAM FITTING CRACKED. REPAIRED FITTING IAW EA & DWG.SDR SWAA2015092344215Spar · crackedLEFT WING REAR SPAR, WEB CRACKED AT RSS 221. REPAIRED WEB IAW EA.SDR SWAA2015091543904Shear Tie · corrodedSHEAR TIE CORRODED AT BS 947, BETWEEN LBL 4 - RBL 4. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015082143057Slat · delaminatedRIGHT WING NR 5 SLAT OTBD SIDE DELAMINATED. R & R NR 5 SLAT IAW AMM.SDR SWAA2015100544589Skin · crackedRIGHT WING UPPER SKIN CRACKED AT WS 223.0, 5" FWD OF TE. REPAIRED SKIN IAW EA.SDR SWAA2015091043652Web · crackedMAIN CABIN FLOOR WEB CRACKED AT BS 1002, RBL 40. R & R WEB IAW SRM & DWG.SDR SWAA2015091043631Sign · looseRIGHT OVERWING OVERHEAD EMER EXIT SIGN LOOSE. INSTALLED SIGN IAW MM.SDR SWAA2015090243453Cover · brokenG1 EXIT LIGHT COVER BROKEN. R & R COVER IAW AMM.SDR SWAA2015082843282Support Fitting · corrodedLEFT WING REAR SPAR AFT MLG BEAM SUPPORT FITTING CORRODED AT WBL 222. R & R FITTING IAW DWG.SDR SWAA2015080243015Slat · delaminatedLEFT WING NR 3 SLAT DELAMINATED INBD AFT WEDGE. REPAIRED NR 3 SLAT IAW SRM.SDR SWAA2015082043000Sign · looseRIGHT OVERWING EXIT SIGN LOOSE. SECURED SIGN IAW SIP.SDR SWAA2015092844344Skin · crackedAFT RT GALLEY DOOR SKIN CUT OUT CRACKED, LOWER FWD CORNER. REPAIRED SKIN IAW ER & EA.SDR SWAA2015092544281Stringer Splice · crackedFORWARD ENTRY DOOR SURROUND STRUCTURE STRINGER SPLICE, CRACKED AT BS 360, STRINGER 14L. R & R SPLICE IAW SRM & DWG.SDR SWAA2015092244178Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STRINGER 15L. R & R SPLICE IAW SRM & DWG.SDR SWAA2015091443759Skin · crackedSKIN CRACKED AT BS 484, STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2015081842940Circuit Card · faultyAIR TURN BACK, UPON INITIAL GEAR RETRACTION ON TAKEOFF, LT MAIN GEAR RED LIGHT ON WITH GEAR HANDLE UP. WITH GEAR HANDLE OFF, LT MAIN GEAR RED & GREEN LIGHT ON WITH GEAR HANDLE DOWN, ALL 3 GEAR GREEN LIGHTS ON NORMALLY. R & R PC CARDS 986 & 988 IAW MM.SDR SWAA2015081842930Spoiler · delaminatedLEFT WING NR 3 SPOILER DELAMINATED, OTBD OF NR 1 ENG. R & R NR 3 SPOILER IAW MM.SDR SWAA2015101244822Bracket · crackedLEFT WING MLG BEAM ATTACHMENT FITTING BRACKET CRACKED, UPPER SPAR CHORD. R & R BRACKET IAW SRM & DWG.SDR SWAA2015092844343Angle · corrodedSPLICE ANGLE CORRODED AT BS 1016, BETWEEN STRINGER 26R - 27R. R & R SPLICE ANGLE IAW ER & EA.SDR SWAA2015092144105Rib · crackedLEFT WING WBL 114 RIB UPPER CHORD CRACKED. R & R CHORD IAW ER & EA.SDR SWAA2015092144097Fitting · crackedLEFT WING RIB AT WBL 114, STRINGER 2L CRACKED INBD MOST FWD HOLE COMMON TO REAR SPAR CHORD. R & R FITTING IAW DWG & EA.SDR SWAA2015091043647Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED, BETWEEN BS 802 TO 827. REPAIRED WEB IAW SRM & DWG.SDR SWAA2015081742911Relay · faultyDIVERSION, CLIMBING THROUGH FL330 TO FL360, NR 1 BUS OFF LIGHT ILLUMINATED. APU STARTED BELOW FL350 & PLACED ONLINE NR 1 SIDE. HOWEVER, POWER WOULD NOT STAY ONLINE WITH EITHER ENG GEN OR APU SELECTED. ON ITS OWN IT CYCLES ON & OFF;. R & R POWER TRANSFER SISDR SWAA2015092344214Spar · crackedRIGHT WING REAR SPAR, CRACKED IN SPAR UPPER CHORD, IN TOP CHORD ATTACH FASTENER HOLE AT RSS 221. REPAIRED CHORD IAW EA.SDR SWAA2015092344213Spar · crackedRIGHT WING REAR SPAR, CRACKED IN SPAR WEB IN TOP CHORD ATTACH FASTENER HOLE AT RSS 221. REPAIRED WEB IAW EA.SDR SWAA2015082042992Skin · crackedSKIN CRACKED BETWEEN BS 420+16.75 - 420+17.25, STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2015081742877Lens · crackedR1 DOOR OVERHEAD EMER EXIT LIGHT LENS CRACKED. REPAIRED LENS IAW EA.SDR SWAA2015081742864Skin · crackedFUSELAGE SKIN CRACKED AT BS 360+15, STRINGER 8L. REPAIRED SKIN IAW EA.SDR SWAA2015081742863Skin · crackedFUSELAGE SKIN CRACKED AT B5, 500C+6, STRINGER 8L. REPAIRED SKIN IAW EA.SDR SWAA2015092944366Stiffener · crackedVERTICAL STIFFENER CRACKED AT BS 663.75, RBL 6.15. REPAIRED STIFFENER IAW EA.SDR SWAA2015092344219Spar · crackedRIGHT WING REAR SPAR, WEB CRACKED FIRST FASTENER HOLE OTBD OF RSS 224.14. REPAIRED WEB IAW EA.SDR SWAA2015092344218Spar · crackedRIGHT WING REAR SPAR, CHORD CRACKED AT FIRST FASTENER HOLD INBD OF RSS 224.14. REPAIRED CHORD IAW EA.SDR SWAA2015092344217Spar · crackedLEFT WING REAR SPAR, UPPER CHORD CRACKED AT FIRST FASTENER HOLE INBD OF RSS 224-14. R & R CHORD IAW EA.SDR SWAA2015092244177Wire · disconnectedAFT LAVATORY EMER EXIT INDICATOR LIGHT CONNECTOR WIRE D10082 DISCONNECTED. REPAIRED WIRE IAW AMM.SDR SWAA2015092244175Wire · disconnectedAFT LAVATORY EMER EXIT INDICATOR LIGHT CONNECTOR WIRE D10084 DISCONNECTED. REPAIRED WIRE IAW AMM.SDR SWAA2015091443853Spar · crackedLEFT WING CRACKED AT REAR SPAR AFT WEB, FIRST FASTENER HOLD OTBD OF RSS 224-14. REPAIRED WEB IAW EA.SDR SWAA2015090343481Floorbeam · corrodedFLOOR BEAM CORRODED AT BS 967, RBL 26. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2015082042991Skin · crackedSKIN CRACKED AT BS 430 + 8.5, STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2015081742910Engine · faultyDIVERSION, ON INITIAL CLIMB AT APPROX 500 FT, NR 1 ENG EGT APPROX 965' WITH ASSOCIATED RED EGT LIGHT, MOMENTARY LIGHT ILLUMINATED APPROX 1 - 3 SECONDS. R & R NR 1 ENG QEC IAW MT.
Back to Boeing 737-3H4