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 SWAA2013070818009Bulkhead · crackedPRESSURE BULKHEAD VERTICAL BEAM WEB CRACKED AT BS 178, LBL 5.7. REPAIRED WEB IAW SRM.SDR SWAA2013070217868Bracket · crackedBRACKET CRACKED AT BS 380, BETWEEN STRINGER 20L & STRINGER 21L. R&R BRACKET IAW SRM.SDR SWAA2013070117817Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STR 25L. R&R TIE CLIP IAW SRM AND DWG.SDR SWAA2013062817693Skin · crackedLT WING NR 4 SLAT LOWER SKIN CRACKED AT OB AUX TRACK. REPAIRED SKIN IAW SRM.SDR SWAA2013062817692Skin · crackedLT WING NR 3 SLAT LOWER SKIN CRACKED AT OB AUX TRACK. REPAIRED SKIN IAW SRM.SDR SWAA2013062417474Battery Pack · dischargedLT AFT EMERGENCY EXIT LIGHT FOR AFT ENTRY SLIDE INOPERATIVE. R&R BATTERY PACK IAW MM.SDR SWAA2013072418542Rib · crackedLT WING RIB UPPER CHORD CRACKED AT WBL 114.00 AT LEVEL OF S-2. REPAIRED CHORD IAW EA.SDR SWAA2013072418508Web · crackedWEB CRACKED AT BS 710.5, BBL 0.07. REPAIRED WEB IAW EO & EA.SDR SWAA2013072418507Web · crackedWEB CRACKED AT BS 708, BBL 0.07. REPAIRED WEB IAW EO & EA.SDR SWAA2013072418506Web · crackedWEB CRACKED AT BS 707, BBL 0.07. REPAIRED WEB IAW EO.SDR SWAA2013072318493Rib · crackedLT WING RIB LOWER CHORD CRACKED AT WBL 135.5 BETWEEN S-2 TO S-3. REPAIRED CHORD IAW EA.SDR SWAA2013071518262Strap · crackedLT WW AFT POSITION MLG SUPPORT STRAP CRACKED. R&R STRAP IAW SRM & DRAWING.SDR SWAA2013071518248Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED AT STATION 666, LBL 24.8 CENTER WING BOX. REPAIRED CHORD IAW EA.SDR SWAA2013071118129Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 344 - BS 360, LBL 10. R&R CHORD IAW SRM & DRAWING.SDR SWAA2013070918062Lens · crackedFWD LAVATORY EMERGENCY EXIT SIGN LENS ON LOWER SIDE CRACKED. R&R LENS IAW AMM.SDR SWAA2013070818026Lens · crackedFWD GALLEY EMERGENCY EXIT SIGN LENS CRACKED. R&R LENS IAW AMM.SDR SWAA2013070818008Angle · crackedVERTICAL ANGLE CRACKED AT BS 328, RBL34.0. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013070818007Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 366, STRINGER 22L. R&R SPLICE IAW SRM & DRAWING.SDR SWAA2013070818006Web · crackedWEB CRACKED BETWEEN BS 344 - BS 360, BL 0. R&R WEB IAW SRM & DRAWING.SDR SWAA2013070818005Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 294.5, STRINGER 23L. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013070417924Strap · crackedEE COMPARTMENT STRAP CRACKED AT BS 312, RBL 48. R&R STRAP IAW SRM & DRAWING.SDR SWAA2013070217867Web · crackedWEB CRACKED AT BS 338, LBL 48. R&R WEB IAW DRAWING & SRM.SDR SWAA2013070217866Floorbeam · crackedFLOOR BEAM UPPER CHORD CRACKED AT BS 312, BETWEEN RBL 24 & RBL 38. REPAIRED CHORD IAW SRM.SDR SWAA2013070217865Floorbeam · crackedFLOOR BEAM UPPER CHORD CRACKED AT BS 328, BETWEEN LBL 30 - LBL 37. REPAIRED BEAM IAW SRM.SDR SWAA2013070117816Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 23L. R&R TIE CLIP IAW SRM AND DWG.SDR SWAA2013070117812Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 22L. R&R TIE CLIP IAW SRM AND DWG.SDR SWAA2013070117811Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 21L. R&R TIE CLIP IAW SRM AND DWG.SDR SWAA2013070117810Web · crackedWEB CRACKED AT BS 322, LBL 48. R&R WEB IAW SRM AND DWG.SDR SWAA2013062717678Tie Clip · crackedTIE CLIP CRACKED AT BS 328, STRINGER 20L. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013062717677Angle · crackedVERTICAL ANGLE CRACKED AT BS 312, RBL 28. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013062417503Angle · crackedRT WING NR 6 FLAP TRACK FAIRING ANGLE CRACKED AT LEVEL WBL 204.40 O/B SIDE. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013062417477Sign · missingFORWARD ENTRY DOOR EMERGENCY EXIT SIGN MISSING. INSTALLED SIGN IAW MM.SDR SWAA2013073018676Frame · crackedFS FRAME CRACKED AT BS 947, STRINGER 25R. REPAIRED FRAME IAW SRM.SDR SWAA2013072218425Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 710, RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2013072218424Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 709, RBL 24.8. REPAIRED WEB IAW SWA EA.SDR SWAA2013072218423Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 708, RBL 24.8. REPAIRED WEB IAW SWA EA.SDR SWAA2013071918355Fitting · corrodedL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING BASE CORRODED. R&R BASE IAW AMM.SDR SWAA2013071918351Fitting · corrodedR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING BASE CORRODED. R&R BASE IAW AMM.SDR SWAA2013071918350Fitting · corrodedR2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING BASE CORRODED. R&R BASE IAW AMM.SDR SWAA2013071918349Fitting · corrodedL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING BASE CORRODED. R&R BASE IAW AMM.SDR SWAA2013071518247Fitting · crackedFITTING CRACKED BETWEEN BS 291.3 - BS 294.5, STRINGER 8R. R&R FITTING IAW SRM & DRAWING.SDR SWAA2013071218176Fitting · corrodedR2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING BASE CORRODED. R&R BASE ASSEMBLY IAW MM.SDR SWAA2013071218157Fitting · corrodedL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING BASE CORRODED. R&R BASE ASSEMBLY IAW MM.SDR SWAA2013070918060Web · crackedFWD GALLEY DOOR CUT OUT UNDER FLOOR STRUCTURE WEB CRACKED AT BS 297, RBL 57. R&R WEB IAW SRM & DRAWING.SDR SWAA2013070417923Web · crackedWEB CRACKED BETWEEN BS 277 & BS 291.3, STRINGER 14R. R&R WEB IAW SRM & DRAWING.SDR SWAA2013070217863Web · crackedWEB CRACKED AT BS 323, RBL 34.0. R&R WEB IAW SRM & DRAWING.SDR SWAA2013070117803Skin · delaminatedRT WING NR 8 SPOILER DELAMINATED ON UPPER SURFACE. REPAIRED SPOILER IAW SRM.SDR SWAA2013062817691Strap · crackedSIDEWALL SUPPORT STRAP CRACKED AT BS 947 STRINGER 16R. R&R STRAP IAW SRM.SDR SWAA2013062517523Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE IAW AMM.SDR SWAA2013062417486Flap · out of adjustRT WING INBOARD AFT FLAP OUT OF ADJUSTMENT. ADJUSTED AFT FLAP IAW MM.
Back to Boeing 737-3H4