Boeing 737-5H4
Service difficulty reports · 8,230
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 = '7375H4' 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 = '7375H4' 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 SWAA2013111122084Frame · crackedFRAME CRACKED AT BS 947.5, STRINGER 18R. R & R FRAME IAW ER & EA.SDR SWAA2013111322293Structure · crackedFWD CARGO COMPARTMENT DOOR CUTOUT CRACKED AT BS 452.4, STRINGER 25R. REPAIRED CUTOUT IAW SRM.SDR SWAA2013103021691Fitting · crackedCLIP CRACKED AT BS 348.2, STRINGER 15L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2013112022614Stringer · crackedSTRINGER CRACKED AT BS 463, STRINGER 2L. REPAIRED STRINGER IAW EA.SDR SWAA2013103021690Flap · delaminatedRT WING FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2013102821583Cover · brokenBROKEN COVER OF EMERGENCY LIGHT AT AFT LAVATORY. R & R COVER IAW AMM.SDR SWAA2013102321421Skin · crackedSKIN CRACKED AT BS 767+1, STRINGER 19L. REPAIRED SKIN IAW EA.SDR SWAA2013102321420Skin · crackedSKIN CRACKED AT BS 747, STRINGER 19L. REPAIRED SKIN IAW EA.SDR SWAA2013102221347Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 663.75, STRINGER 4L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2013111322305Skin · crackedFUSELAGE SKIN CRACKED AT BS 907, STRINGER 3R. REPAIRED SKIN IAW EA.SDR SWAA2013111222269Frame · crackedFRAME CRACKED AT BS 277, BETWEEN STRINGER 15L & STRINGER 16L. REPAIRED FRAME IAW EO & EA.SDR SWAA2013111122093Frame · crackedFRAME CRACKED AT BS 480, BETWEEN STRINGER 15L TO STRINGER 16L. REPAIRED FRAME IAW SRM.SDR SWAA2013111122092Strap · crackedSTRAP CRACKED AT BS 344, BETWEEN STRINGER 10L TO STRINGER 15L. R & R STRAP IAW SRM & DRAWING.SDR SWAA2013111122091Floorbeam · corrodedFLOOR BEAM CORRODED AT BS 312, BETWEEN RBL 11 TO LBL 20. REPAIRED BEAM IAW SRM.SDR SWAA2013110521973Fitting · crackedFWD GALLEY DOOR FITTING CRACKED AT BS 294.5, STRINGER 8R. R & R FITTING IAW SRM & DRAWING.SDR SWAA2013110421851Angle · crackedLT WING REAR SPAR ANGLE CRACKED AT WBL 71.24 + 15.5. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013110421838Support Angle · crackedRT WING TE SUPPORT ANGLE CRACKED AT WS 537.806. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013110421837Angle · crackedRT WING TE ANGLE CRACKED AT WS 537.806. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013110421836Reveal · crackedR1 DOOR UPPER CORNER CUTOUT CRACKED BETWEEN BS 294.5 TO BS 294.5+ 10, BETWEEN STRINGER 7R TO STRINGER 8R. R & R REVEAL IAW SRM & DRAWING.SDR SWAA2013110421835Strap · crackedL1 DOOR UPPER CORNER STRAP CRACKED BETWEEN BS 303.5 TO BS 328, BETWEEN STRINGER 6L TO STRINGER 7L. R & R STRAP IAW SRM & DRAWING.SDR SWAA2013110421834Frame · crackedFRAME CRACKED AT BS 277, STRINGER 16R. R & R FRAME IAW SRM & DRAWING.SDR SWAA2013110421825Web · crackedWEB CRACKED BETWEEN BS 294.5 TO BS 303.9, STRINGER 15L. R & R WEB IAW SRM & DRAWING.SDR SWAA2013110421824Tie Clip · crackedTIE CLIP CRACKED AT BS 294.5, STRINGER 12L.. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013110421823Beam · corrodedFWD CABIN FLOOR STRUCTURE LOWER SURFACE OF CHORD BEAM CORRODED AT BS 312, BETWEEN RBL 12 & RBL 50. REPAIRED BEAM IAW SRM.SDR SWAA2013110421822Fitting · crackedCENTER SECTION HORIZONTAL STABILIZER RT UPPER CHORD FITTING CRACKED T LEVEL BS 1121. R & R FITTING IAW SRM & DRAWING.SDR SWAA2013110421821Shear Tie · crackedSHEAR TIE CRACKED AT BS 277, BETWEEN STRINGER 9L TO STRINGER 10L. R &R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2013102821582Cover · crackedAFT GALLEY DOOR CUTOUT CRACKED ON COVER LOCATED AT BS 993. R & R CUTOUT IAW AMM.SDR SWAA2013102221348Angle · crackedRT WING TE ANGLE CRACKED AT WBL 204.40. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013111322304Support Angle · crackedRT WING NR 6 FAIRING TRACK SUPPORT ANGLE CRACKED AT INBD WBL 183.40. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013110421820Stiffener · crackedLT WING NR 3 INBD FLAP TRACK FAIRING STIFFENER CRACKED. R & R STIFFENER IAW SRM & DRAWING.SDR SWAA2013110421819Link · crackedLT WING OTBD FORE FLAP CENTER LINK CRACKED. R & R LINK IAW SRM & DRAWING.SDR SWAA2013102821591Skin · crackedSKIN CRACKED AT BS 887, STRINGER 19L. REPAIRED SKIN IAW EO & EA.SDR SWAA2013102821590Skin · crackedSKIN CRACKED AT BS 867, STRINGER 19L. REPAIRED SKIN IAW EO & EA.SDR SWAA2013102321419Skin · crackedSKIN CRACKED AT BS 747 + 13, STRINGER 19L. REPAIRED SKIN IAW EA.SDR SWAA2013111222268Skin · crackedFUSELAGE SKIN CRACKED AT BS 360, STRINGER 5R. REPAIRED SKIN IAW EA.SDR SWAA2013111222267Pressure Deck · crackedMAIN WW PRESSURE DECK CRACKED AT BS 663.75+8.5, LBL 45.50-5. REPAIRED WEB IAW EA.SDR SWAA2013111222266Pressure Deck · crackedMAIN WW PRESSURE DECK CRACKED AT BS 663.75+8, LBL 45.50-6. REPAIRED WEB IAW EA.SDR SWAA2013111222265Pressure Deck · crackedMAIN WW PRESSURE DECK CRACKED AT BS 663.75, LBL 45.5-6". REPAIRED WEB IAW EA.SDR SWAA2013111122090Pressure Deck · crackedMAIN WW PRESSURE DECK CRACKED AT BS 663.75, RBL 24.5-3. REPAIRED DECK IAW EO & EA.SDR SWAA2013111122089Flap · delaminatedLT WING OTBD AFT FLAP DELAMINATED. R & R AFT FLAP IAW AMM.SDR SWAA2013101521216Skin · crackedR1 DOOR INNER SKIN CRACKED AT CUTOUT CORNER BELOW CONTROL ROD FWD ATTACH POINT. REPAIRED SKIN IAW SRM.SDR SWAA2013111322303Skin · crackedFUSELAGE SKIN CRACKED AT BS 908+14, STRINGER 23L. REPAIRED SKIN IAW EA.SDR SWAA2013111222264Skin · crackedSKIN CRACKED AT BS 887+ 13, STRINGER 25R. REPAIRED SKIN IAW SRM.SDR SWAA2013111222263Skin · crackedFUSELAGE SKIN CRACKED AT BS 747+6.5, STRINGER 19L. REPAIRED SKIN IAW SRM.SDR SWAA2013111222262Skin · crackedFUSELAGE SKIN CRACKED AT BS 787+3.5, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2013111222261Skin · crackedFUSELAGE SKIN CRACKED AT BS 440+6, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2013111222260Skin · crackedFUSELAGE SKIN CRACKED AT BS 360+12, STRINGER 15R. REPAIRED SKIN IAW EO & EA.SDR SWAA2013111222259Skin · crackedFUSELAGE SKIN CRACKED AT BS 380+13, STRINGER 15R. REPAIRED SKIN IAW EO & EA.SDR SWAA2013111222286Scuff Plate · crackedAFT CARGO COMPARTMENT DOOR CENTER SCUFF PLATE ON CUT OUT CRACKED. REPAIRED SCUFF PLATE IAW EA.SDR SWAA2013111122149Skin · crackedSKIN CRACKED AT BS 867+ 6.5, STRINGER 24R. REPAIRED SKIN IAW SRM.
Back to Boeing 737-5H4