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 SWAA2014071029857Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 747 TO 767. R & R WEB IAW SRM.SDR SWAA2014070929823Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 663.75+2, RBL 24.8. REPAIRED CHORD IAW EA.SDR SWAA2014070729650Shear Tie · crackedSHEAR TIE CRACKED AT BS 360, BETWEEN STRINGER 14L TO 15L. R & R SHEAR TIE IAW SRM.SDR SWAA2014070729649Channel · crackedSPLICE CHANNEL CRACKED AT BS 360, STRINGER 15L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014063029503Mount Bracket · crackedR2 DOOR SLIDE FWD MOUNT BRACKET CRACKED. R & R BRACKET IAW SRM.SDR SWAA2014063029489Slide · out of positionL1 DOOR SLIDE OUT OF POSITION. ADJUSTED SLIDE IAW MM.SDR SWAA2014072830384Frame · crackedRIGHT FRAME INNER CHORD CRACKED AT BS 616 WL 200. REPAIRED CHORD IAW EA.SDR SWAA2014072830408Door Frame · crackedL1 DOOR FRAME INNER CHORD CRACKED AT BS 348 WL 208. REPAIRED CHORD IAW EA.SDR SWAA2014072530318Seat Track · crackedSEAT TRACK CRACKED AT BS 727B RBL 24. REPAIRED SEAT TRACK IAW EA.SDR SWAA2014072530317Crease Beam · crackedRIGHT CREASE BEAM INNER CHORD CRACKED AT BS 639 WL 208. REPAIRED CHORD IAW EA.SDR SWAA2014072130176Angle · corrodedAFT PRESS BULKHEAD STIFFENER ANGLE CORRODED AT BS 1016, BETWEEN RBL 8 TO LBL 9. REPAIRED ANGLE IAW ER & EA.SDR SWAA2014072130149Stiffener · corrodedAFT PRESS BULKHEAD WEB RADIAL STIFFENER CORRODED AT BS 1017 LBL 0.2. REPAIRED STIFFENER IAW ER & EA.SDR SWAA2014072130148Stiffener · corrodedAFT PRESS BULKHEAD WEB RADIAL STIFFENER CORRODED AT BS 1017 RBL 0.2. REPAIRED STIFFENER IAW ER & EA.SDR SWAA2014072130142Bulkhead · corrodedAFT PRESS BULKHEAD WEB CORRODED AT BS 1017 BETWEEN RBL 8 TO LBL 9. REPAIRED WEB IAW ER & EA.SDR SWAA2014071630043Skin · crackedSKIN CRACKED AT BS 727E BETWEEN STRINGER 27L TO 27R. REPAIRED SKIN IAW EA.SDR SWAA2014071530009Crease Beam · buckledLEFT CREASE BEAM WEB BUCKLED BETWEEN BS 360 TO 380 STRINGER 17L. R & R WEB IAW SRM & DWG.SDR SWAA2014071429938Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 847 TO 867. REPAIRED WEB IAW SRM & DWG.SDR SWAA2014070829753Attach Fitting · crackedATTACH CLIP CRACKED AT BS 348.2, STRINGER 16L. R & R CLIP IAW SRM.SDR SWAA2014072530316Crossbeam · crackedAFT CARGO DOOR AFT END CROSSBEAM T CHORD CRACKED INDICATION COMING FROM SECOND AFT FASTENER HOLE COMMON WITH STOP FITTING OTBD FASTENERS. R & R AFT CARGO DOOR IAW AMM.SDR SWAA2014072330246Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 666, LBL 39.5. REPAIRED DECK IAW EA.SDR SWAA2014072230199Floorbeam · looseFLOORBEAM UPPER CHORD LOOSE AT BS 727B RBL 24.8. R & R CHORD IAW EA.SDR SWAA2014072130175Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 666 TO 674, LBL 24.5. R & R CHORD IAW ER & EA.SDR SWAA2014072130151Structure · crackedRIGHT WING LOWER CHORD CRACKED AT WBL 135.5 JUST AFT OF STRINGER 2. REPAIRED CHORD IAW EA.SDR SWAA2014072130146Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT BS 727B RBL 24.8. REPAIRED CHORD IAW EA.SDR SWAA2014071730059Pressure Deck · crackedMAIN WW HORIZONTAL PRESS DECK CRACKED AT BS 673 LBL 42. REPAIRED DECK IAW ER & EA.SDR SWAA2014071530007Skin · crackedR1 DOOR LOWER HINGE FUSELAGE SKIN CUT OUT CRACKED AT BS 291.5. REPAIRED SKIN IAW SRM.SDR SWAA2014071429951Slide · out of adjustR1 DOOR EMER EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW MT.SDR SWAA2014071429950Hook · faultyR1 DOOR EMER EVAC SLIDE COVER AFT GIRT BAR HOOK FAULTY. R & R HOOK IAW SRM.SDR SWAA2014071429949Hook · looseR1 DOOR EMER EVAC SLIDE COVER FWD GIRT BAR HOOK LOOSE. SECURED HOOK IAW SRM.SDR SWAA2014070929824Fitting · crackedAFT CARGO BAY ANGLE CLIP ATTACHED TO INTERCOSTAL CRACKED AT BS 947.5, STRINGER 24L. R & R CLIP IAW SRM & DWG.SDR SWAA2014070829729Access Panel · crackedVERTICAL STABILIZER RETAINER PLATE ACCESS PANEL 9502 CRACKED. R & R PANEL IAW SRM & DWG.SDR SWAA2014062629408Mount Bracket · crackedR2 DOOR SLIDE FWD MOUNT BRACKET CRACKED. R & R BRACKET IAW MM.SDR SWAA2014062629405Mount Bracket · crackedR2 DOOR SLIDE AFT MOUNT BRACKET CRACKED. R & R BRACKET IAW MM.SDR SWAA2014072130141Pressure Panel · corrodedPRESSURE WEB CORRODED AT BS 1016 BL 0-3R. REPAIRED WEB IAW ER & EA.SDR SWAA2014071730058Skin · crackedFUSELAGE SKIN CRACKED AT AFT ENTRY DOOR LOWER FWD CORNER. REPAIRED SKIN IAW SRM.SDR SWAA2014071429969Attach Bracket · crackedLEFT WING TE NR 3 FLAP TRACK FAIRING INTERIOR STRUCTURE RT SIDE FLAP DOOR SPRINGS ATTACH BRACKET CRACKED. R & R BRACKET IAW SRM & DWG.SDR SWAA2014062729447Spindle · corrodedRIGHT WING OTBD FLAP NR 8 CARRIAGE SPINDLE CORRODED. R & R SPINDLE ASSEMBLY IAW MM.SDR SWAA2014072830383Door Frame · crackedFORWARD GALLEY DOOR CUT OUT STRUCTURE OTBD OF FWD UPPER LATCH FITTING CRACKED. R & R STUB FRAME IAW DWG & SRM.SDR SWAA2014072130144Light · missingL1 DOOR LOWER EMER LIGHT MISSING. INSTALLED LIGHT IAW MM.SDR SWAA2014071730057Floorbeam · corrodedFLOORBEAM UPPER FLANGE CORRODED AT BS 986.5 RBL 43. REPAIRED FLANGE IAW ER & EA.SDR SWAA2014071630032Lens · missingRIGHT EELS LENS MISSING AT ROW 7. INSTALLED LENS IAW AMM.SDR SWAA2014071430031Lens · missingRIGHT EEPLS LENS MISSING AT ROW. INSTALLED LENS IAW AMM.SDR SWAA2014071029871Wedge · delaminatedRIGHT WING INBD MID FLAP LOWER SURFACE OF TE WEDGE DELAMINATED. R & R WEDGE IAW AMM.SDR SWAA2014070829752Attach Angle · corrodedAFT CARGO BAY, ON INBD KEEL BEAM TO FRAME ATTACH ANGLE CORRODED AT BS 727E, STRINGER 27R. R & R ANGLE IAW SRM.SDR SWAA2014070729648Access Panel · delaminatedLEFT WING LE ACCESS PANEL 6231 DELAMINATED AT FWD INBD CORNER. REPAIRED PANEL IAW SRM.SDR SWAA2014062629409Bracket · dirtyL1 DOOR GIRT BAR FLOOR CLIP INOPERATIVE. CLEANED GIRT BAR FLOOR BRACKET IAW MM.SDR SWAA2014062529386Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW AMM.SDR SWAA2014062529385Slide · out of positionR1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW AMM.SDR SWAA2014062429341Sliding Window · malfunctionedAIR TURN BACK, CAPTAIN SLIDING WINDOW ARCED SMOKE & FIRE. R & R WINDOW & PIGTAIL IAW AMM.SDR SWAA2014091031794Frame · crackedFRAME OTBD CHORD FWD FLANGE LOWER AFT FASTENER HOLE CRACKED AT BS 727 STRINGER 18A LT SIDE. REPAIRED CHORD IAW EA.
Back to Boeing 737-3H4