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 SWAA2015102045166Link · corrodedRIGHT MLG TRUNNION LINK CORRODED. REPAIRED LINK IAW CMM.SDR SWAA2015101945039Floorbeam · corrodedFLOORBEAM UPPER CHORD CORRODED AT BS 328, RBL 12. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2015101645019Flap · delaminatedLEFT WING INBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015101645018Skin · delaminatedLEFT WING OTBD LE NR 2 SLAT, AFT WEDGE UPPER SURFACE SKIN DELAMINATED AT INBD END. REPAIRED SKIN IAW SRM.SDR SWAA2015101544948Flap · delaminatedRIGHT WING INBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015101544947Skin · delaminatedRIGHT WING OTBD FORE FLAP DELAMINATED AT UPPER SURFACE. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015100644627Fitting · corrodedCLIP CORRODED AT BS 500C, BETWEEN STRINGER 28R - STRINGER. R & R CLIP IAW DWG.SDR SWAA2015100544591Skin · crackedRIGHT WING UPPER SKIN CRACKED AT WBL 157, COMING FROM AFT SPAR GOING FWD. REPAIRED SKIN IAW EA.SDR SWAA2015092944390Tail Cone · delaminatedTAIL CONE DELAMINATED AT FWD LOWER SIDE AT DRAIN HOLE. R & R TAIL CONE IAW AMM.SDR SWAA2015101945075Angle · crackedLEFT WING, NR 3 FLAP TRACK FAIRING ANGLE CRACKED AT WBL 198.60. R & R ANGLE IAW SRM & DWG.SDR SWAA2015101945072Angle · crackedRIGHT WING, NR 6 FLAP TRACK FAIRING ANGLE CRACKED AT WBL 198.60. R & R ANGLE IAW SRM & DWG.SDR SWAA2015101444897Angle · crackedLEFT WING NR 3 FLAP TRACK FAIRING ANGLE CRACKED AT LEVEL OF WBL 183.40. R & R ANGLE IAW SRM & DWG.SDR SWAA2015100944731Angle · crackedLEFT WING NR 3 FLAP TRACK ANGLE CRACKED AT WBL 198.60, UPPER AREA INTERNAL STRUCTURE. R & R ANGLE IAW DWG & SRM.SDR SWAA2015102745381Web · crackedAUXILIARY POWER UNIT COMPARTMENT, TORQUE BOX LT WEB CRACKED, BETWEEN BS 1104 - 1121 ON DOOR SURROUND STRUCTURE. REPAIRED WEB IAW EA & EO.SDR SWAA2015101945077Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908, STRINGER 4L. R & R SPLICE IAW DWG & SRM.SDR SWAA2015101945037Tie Clip · crackedTIE CLIP CRACKED AT BS 277, STRINGER 10R. R & R CLIP IAW SRM & DWG.SDR SWAA2015101244809Angle · crackedLEFT WING ANGLE, CRACKED AT INBD FLAP, OTBD TRACK FAIRING. R & R ANGLE IAW SRM & DWG.SDR SWAA2015101244808Bracket · crackedLEFT WING BRACKET CRACKED ON OF INBD FLAP, OTBD TRACK FAIRING INTERNAL AREA. R & R BRACKET IAW SRM & DWG.SDR SWAA2015101244825Fitting · corrodedLEFT MLG SWING LINK FITTING CORRODED. REPAIRED FITTING IAW CMM & DWG.SDR SWAA2015100744666Angle · crackedRIGHT WING INBD FLAP OTBD TRACK FAIRING ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2015100144432Link · corrodedRIGHT MLG FWD TRUNNION LINK, CORRODED AROUND INBD AFT BUSHING. R & R LINK IAW AMM.SDR SWAA2015092544263Sign · looseRIGHT OVERWING EXIT SIGN LOOSE. SECURED SIGN IAW EA.SDR SWAA2015092444232Indicator · faultyDIVERSION, INFLIGHT SHUTDOWN & DECLARED EMER. NR 1 ENG OIL PRESS 10 PSI INFLIGHT. R & R NR 1 ENG OIL PRESS INDICATOR IAW AMM.SDR SWAA2015110445745Strut · corrodedLEFT MLG FWD LUG, FWD LUG SHOCK STRUT BORE CORRODED. R & R LT LG IAW MT.SDR SWAA2015102645320Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986.5, RBL 43. REPAIRED BEAM IAW EA & ER.SDR SWAA2015101945048Web · corrodedAFT CARGO BAY ON FRAME WEB CORRODED BS 907, BETWEEN STRINGER 26R - 27R. R & R WEB IAW SRM.SDR SWAA2015101945047Seat Track · corrodedINTERIOR SEAT TRACK FLANGE CORRODED, BS 1016, RBL 20. R & R SEAT TRACK IAW SRM.SDR SWAA2015101244824Lens · brokenRIGHT OVERHEAD STOWAGE BIN, EMER LIGHT LENS BROKEN AT ROW 1. R & R LENS IAW AMM.SDR SWAA2015100844704Frame · corrodedAFT CARGO BAY ON FRAME WEB CORRODED AT BS 907, BETWEEN STRINGER 27L - 27R. REPAIRED FRAME IAW SRM.SDR SWAA2015100644616Floorbeam · corrodedFLOORBEAM CORRODED AT BS 328, 0 BL. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2015100644615Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 1006, STRINGER 10L. R & R CLIP IAW SRM.SDR SWAA2015100144405Stringer Clip · crackedAFT CARGO BAY STRINGER CLIP CRACKED AT BS 927, STRINGER 25R. R & R CLIP IAW SRM.SDR SWAA2015100144404Structure · crackedINTERIOR FLOOR WEB CUT OUT, CRACKED AT BS 1024, LBL 10. REPAIRED CUT OUT IAW SRM.SDR SWAA2015122347410Skin · crackedRIGHT WING UPPER SKIN CRACKED AT STATION 175, AFT SPAR. REPAIRED SKIN IAW EA.SDR SWAA2015111846142Skin · crackedRIGHT WING UPPER SKIN CRACKED AT AFT SPEED FASTENER, STATION 175. RT SKIN IAW EA.SDR SWAA2015110245641Fitting · crackedLEFT WING AFT BEAM TO SPAR, FITTING CRACKED AT UPPER ROW INBD HOLE. REPAIRED FITTING IAW ER & EA.SDR SWAA2015110245640Fitting · crackedLEFT WING FWD BEAM TO SPAR FITTING CRACKED AT UPPER ROW FASTENER HOLE 2ND FROM INBD EDGE. REPAIRED FITTING IAW ER & EA.SDR SWAA2015102345279Skin · crackedR2 DOOR UPPER HINGE CUT OUT FWD UPPER CORNER CRACKED. REPAIRED CUT OUT IAW EA & ER.SDR SWAA2015101344838Flap Track · corrodedLEFT WING NR 4 FLAP TRACK CORRODED ON 4 ON HOLE. REPAIRED FLAP TRACK IAW CMM.SDR SWAA2015101344837Flap Track · corrodedRIGHT WING NR 5 FLAP TRACK HOLE CORRODED. REPAIRED NR 5 FLAP TRACK IAW CMM.SDR SWAA2015101244807Scuff Plate · crackedL2 DOOR CTR SCUFF PLATE CRACKED. REPAIRED SCUFF PLATE IAW EA.SDR SWAA2015100144460Angle · crackedLEFT WING TE SEAL BULKHEAD LOWER ANGLE CRACKED AT WBL 209. R & R ANGLE IAW SRM.SDR SWAA2015100144459Angle · crackedRIGHT WING TE SEAL BULKHEAD LOWER ANGLE CRACKED AT WBL 209. R & R ANGLE IAW SRM.SDR SWAA2015092844329Skin · crackedRIGHT WING UPPER SKIN CRACKED AT WBL 157, COMING FROM AFT SPAR GOING FWD. REPAIRED SKIN IAW EA.SDR SWAA2015092344223Slide · out of adjustR2 DOOR EMER EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW AMM.SDR SWAA2015092244146Skin · crackedRIGHT WING UPPER SKIN, CRACKED AT AFT SPAR, AFT FASTENER WING STATION 175. REPAIRED SKIN IAW EA.SDR SWAA2015110245650Link Assy · corrodedRIGHT MLG SWING LINK ASSEMBLY CORRODED. REPAIRED LINK ASSEMBLY IAW EO & EA.SDR SWAA2015110245571Link · corrodedLEFT MLG SWING ATTACH LINK ASSEMBLY ON INTERNAL HOLE CORRODED. REPAIRED LINK ASSEMBLY IAW EO & EA.SDR SWAA2015110245542Link · corrodedRIGHT MLG SWING LINK PLATE CORRODED. REPAIRED LINK IAW EO & EA.SDR SWAA2015102745392Fitting · corrodedRIGHT WING MLG SUPPORT BEAM FITTING CORRODED. R & R FITTING IAW AMM.
Back to Boeing 737-3H4