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 SWAA2013062517513Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, BETWEEN LBL 9 - LBL 11. R&R SHEAR TIE IAW SRM.SDR SWAA2013062517570Failsafe · corrodedAFT CARGO BAY FAIL SAFE ANGLE CORRODED AT BS 947.5, BETWEEN STRINGER 25R - 26R. R&R FAIL SAFE IAW SRM.SDR SWAA2013062517532Threshold · corrodedAFT CARGO BAY, ON SUB-THRESHOLD WEB CORRODED BETWEEN BS 794 - BS 847, BETWEEN RBL 20 - RBL 28. R&R WEB IAW SRM & DRAWING.SDR SWAA2013062417507Light · brokenFORWARD GALLEY EMERGENCY EXIT LIGHT BASE BROKEN. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2013062417506Skin · crackedRT BS 500B+10 LOWER AFT SKIN CUTOUT CRACKED AT HOLES 2,3,5. REPAIRED SKIN IAW EA.SDR SWAA2013062417505Skin · crackedRT BS 500A+10 LOWER AFT SKIN CUTOUT CRACKED AT HOLES 1,2,3,4,7. REPAIRED SKIN IAW EA.SDR SWAA2013062417504Skin · crackedRT BS 420+10 UPPER FORWARD SKIN CUTOUT CRACKED AT HOLES 6,7. REPAIRED SKIN IAW SWA EA.SDR SWAA2013061917375Skin · crackedLEFT PILOTS WINDSHIELD CUTOUT OTBD UPPER CORNER CRACKED IN SKIN. REPAIRED CUTOUT IAW SRM.SDR SWAA2013061917386Bracket · crackedFLOOR STRUCTURE CENTER WING BOX BRACKET CRACKED AT BS 693, BL 0 LT SIDE. R & R BRACKET IAW SRM AND DWG.SDR SWAA2013061817284Skin · crackedRT BS 520+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 4, 6, 7, 11, 12. REPAIRED SKIN IAW EA.SDR SWAA2013061817283Skin · crackedRT BS 500C+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3, 4, 5. REPAIRED SKIN IAW EA.SDR SWAA2013061817282Skin · crackedRIGHT BS 500C+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061817279Skin · crackedRT BS 500A+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLES 1,2,3,9. REPAIRED SKIN IAW SB.SDR SWAA2013061817309Stringer Clip · crackedAFT CARGO BAY STRINGER CLIP CRACKED AT BS 787, STR 20R. R & R CLIP IAW SRM.SDR SWAA2013061817310Stringer Clip · crackedAFT CARGO BAY STRINGER CLIP CRACKED AT BS 792, STR 26R. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013061717189Bulkhead · crackedBULKHEAD WEB CRACKED AT BS 727, RBL 7. REPAIRED WEB IAW ER & EA.SDR SWAA2013061017008Web · corrodedWEB CORRODED BETWEEN BS 727B AND BS 727C, STR 17L. R & R WEB IAW SRM AND DWG.SDR SWAA2013061017007Shear Tie · corrodedSHEAR TIE CORRODED AT BS 360 BETWEEN STR 28LT, STR 27L. R & R SHEAR TIE IAW SRM AND DWG.SDR SWAA2013060716886Skin · crackedRT BS 400+10 LOWER AFT WINDOW CORNER HAS HFEC CRACKED INDICATION AT HOLES 2, 3, 6, 7. REPAIRED SKIN IAW SB.SDR SWAA2013060716885Skin · crackedRT BS 500+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 3,4. REPAIRED SKIN IAW SB.SDR SWAA2013060716897Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 927, STR 20R. R & R CLIP IAW SRM.SDR SWAA2013060316693Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 26L. R & R TIE CLIP IAW SRM AND DWG.SDR SWAA2013053016628Slide · looseR1 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE IAW MM.SDR SWAA2013053016616Sign · looseFWD OVERHEAD EMERGENCY EXIT SIGN LOOSE. SECURED SIGN IAW AMM.SDR SWAA2013070217854Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A LT. REPAIRED CHORD IAW SWA EA.SDR SWAA2013070117790Skin · crackedL1 DOOR EXTERNAL SKIN CRACKED AT AFT UPPER CORNER AT FASTENER LOCATION. REPAIRED SKIN IAW SRM.SDR SWAA2013062517597Stringer Splice · crackedSPLICE STRINGER CRACKED AT BS 907, STRINGER 4L. R&R SPLICE IAW SRM & DRAWING.SDR SWAA2013062517551Plate · crackedL1 DOOR CUTOUT PLATE CRACKED AT BS 303.9, STRINGER 10L. R&R PLATE IAW SRM.SDR SWAA2013061817334Web · corrodedFWD CARGO DOOR CUTOUT SUB THRESHOLD WEB CORRODED BETWEEN BS 447 TO 479, RBL 30. R & R WEB IAW SRM.SDR SWAA2013061817333Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907, STR 6L. R & R SPLICE IAW SRM AND DWG.SDR SWAA2013061717185Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 294.5 TO BS 303.9, STR 16L CUT OUT FWD ENTRY DOOR. R & R ANGLE IAW SRM & DWG.SDR SWAA2013061717183Channel · crackedCHANNEL CRACKED AT BS 673, RBL 39. R & R CHANNEL IAW DWG & SRM.SDR SWAA2013061016951Strap · crackedTENSION STRAP CRACKED AT BS 342, LBL 45. REPAIRED STRAP IAW SRM.SDR SWAA2013060716905Fastener · looseL1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR RETAINER LOOSE. R & R FASTENER IAW SRM.SDR SWAA2013060616836Isolator · crackedL1 DOOR INSULATION BRACKET CRACKED AT BS 360, STR 15L CUTOUT. R & R ISOLATOR IAW SRM AND DWG.SDR SWAA2013060616848Angle · crackedFWD PAX CABIN FLOOR STRUCTURE ANGLE CRACKED BETWEEN BS 380 AND BS 400, BL 0. R & R ANGLE IAW SRM AN DWG.SDR SWAA2013060516824Fitting · crackedCLIP CRACKED AT BS 294, STR 13L. R & R CLIP IAW SRM AND DWG.SDR SWAA2013053116640Spindle · damagedLEFT WING NR 2 SPINDLE HAS CHIPPED/FLANKED THERMAL COATING ON LOWER SURFACE. R & R NR 2 SPINDLE IAW MT.SDR SWAA2013053016613Battery · dischargedAFT INBD EMERGENCY FLASHLIGHT INOP. R & R BATTERY ASSY IAW MM.SDR SWAA2013070817999Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STRINGER 24R & STRINGER 25R. REPAIRED FRAME IAW EO & EA.SDR SWAA2013070417935Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 847, STRINGER 22R. R&R STRINGER IAW SRM & DRAWING.SDR SWAA2013070217850Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 947.5, BETWEEN STRINGER 24R TO STRINGER 25R. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013062817727Angle · crackedRT SIDE WING TO BODY FAIRING ANGLE CRACKED AT BS 540, STRINGER 22R. REPAIRED ANGLE IAW SRM.SDR SWAA2013062817726Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 907, STRINGER 18L. R&R SPLICE IAW SRM & DRAWING.SDR SWAA2013062517596Stringer · corrodedSTRINGER CORRODED BETWEEN BS 907 TO BS 947.5, STRINGER 22L. R&R STRINGER IAW SRM & DRAWING.SDR SWAA2013062417502Stringer · crackedSTRINGER CRACKED AT BS 807+7, STRINGER 10L. REPAIRED STRINGER IAW SRM & EA.SDR SWAA2013061917385Web · crackedAFT CARGO COMPARTMENT WEB CRACKED AT BETWEEN BS 927 TO BS 947.5, BETWEEN STR 25L TO STR 26L. R & R WEB IAW SRM.SDR SWAA2013061917384Bracket · crackedAFT CARGO COMPARTMENT WEB BRACKET CRACKED AT BS 947.5, BETWEEN STR 24L TO STR 25L. R & R BRACKET IAW SRM AND DWG.SDR SWAA2013061917383Rub Strip · crackedNR 1 ENGINE AFT EDGE OF INBD FAN COWL RUBSTRIP CRACKED. R & R RUBSTRIPS IAW SRM AND DWG.SDR SWAA2013060516823Channel · crackedFLOOR STRUCTURE CHANNEL CRACKED AT BS 540, BETWEEN BL 0 AND LBL 24.5. R & R CHANEL IAW SRM AND DWG.
Back to Boeing 737-3H4