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 SWAA2013082119392Fastener · crackedLT WING UPPER SURFACE NR 1 ENGINE PYLON PANEL INBD ATTACH SKATE ANGLE FORWARD FASTENER HEAD CRACKED. R&R FASTENER IAW SRM & DRAWING.SDR SWAA2013081419174Valve · faultyAIR TURNBACK AFTER LIFTOFF, SHORTLY AFTER LANDING GEAR UP, BOTH "A" ELECTRIC & ENGINE DRIVEN HYDRAULIC LOW PRESSURE LIGHTS CAME ON. HYDRAULIC PRESSURE & QUANTITY ON GAUGES NORMAL. ELECTRIC DRIVEN LIGHT WENT OUT IN ABOUT 5 SECONDS, THEN ENGINE DRIVEN LIGHT WSDR SWAA2013081219018Cover · missingLT EMERGENCY EXIT LIGHT LENS COVER MISSING AT ROW 15. INSTALLED COVER IAW MM.SDR SWAA2013100320750Flap Track · corrodedLT WING NR 4 INBD FLAP TRACK CORRODED. REPAIRED FLAP TRACK IAW EA & EO.SDR SWAA2013082619533Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908 STRINGER 4R. R&R SPLICE IAW DRAWING & SRM.SDR SWAA2013082619536Web · crackedWEB CRACKED BETWEEN BS 351.2 & BS 360 RBL 2.0. R&R WEB IAW SRM & DRAWING.SDR SWAA2013082619534Strap · crackedUPPER STRAP CRACKED AT BS 908 STRINGER 3R. R&R STRAP IAW DRAWING & SRM.SDR SWAA2013090919975Skin · crackedFS SKIN CRACKED AT BS 908, STRINGER 3R. REPAIRED SKIN IAW EA.SDR SWAA2013090619932Skin · crackedFS SKIN CRACKED AT BS 360, BETWEEN STRINGER 1 & STRINGER 2L. REPAIRED SKIN IAW EA.SDR SWAA2013090319763Stringer · crackedSTRINGER CRACKED AT BS 767+11.250, STRINGER 18L. REPAIRED STRINGER IAW SRM.SDR SWAA2013083019737Angle · crackedAFT CARGO COMPARTMENT FWD FACE BULKHEAD ANGLE CRACKED AT BS 727, BETWEEN STRINGER 26L TO STRINGER 27L. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013082319468Angle · crackedSPLICE ANGLE CRACKED AT BS 767+6.5 STRINGER 17L. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013082319467Shear Tie · crackedSHEAR TIE CRACKED AT BS 787 STRINGER 18L. R&R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2013081919303Lens · damagedFWD LAVATORY EMERGENCY EXIT LIGHT LENS DAMAGED. R&R LENS IAW AMM.SDR SWAA2013081219009Skin · crackedFS SKIN CRACKED AT STATION 827, STRING 24L. REPAIRED SKIN IAW SRM.SDR SWAA2013090919974Skin · crackedLT WING INBD FIXED LE SKIN CRACKED AT WBL 213. REPAIRED SKIN IAW EA.SDR SWAA2013090919973Skin · crackedRT WING INBD FIXED LE SKIN CRACKED AT WBL 213. REPAIRED SKIN IAW EA.SDR SWAA2013082619532Fitting · crackedCLIP CRACKED AT BS 320 BETWEEN STRINGER 20L TO STRINGER 21L. R&R CLIP IAW SRM & DRAWING.SDR SWAA2013082619531Fitting · crackedCLIP CRACKED AT BS 344 BETWEEN STRINGER 20L TO STRINGER 21L. R&R CLIP IAW SRM & DRAWING.SDR SWAA2013082619530Fitting · crackedCLIP CRACKED AT BS 328, BETWEEN STRINGER 20L TO STRINGER 21L. R&R CLIP IAW SRM & DRAWING.SDR SWAA2013082119391Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STRINGER 20L. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013081619271Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STRINGER 22L. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013081219100Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STRINGER 21L. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013090919972Web · crackedLT NLG WW WEB CRACKED AT BS 243.7+3.5, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2013081419211Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908, STRINGER 4L. R&R SPLICE IAW SRM & DRAWING.SDR SWAA2013090919971Skin · crackedAFT ENTRY DOOR CUTOUT CRACKED AT BS 947.5+10.5, STRINGER 17L-3.5. REPAIRED SKIN IAW EO & EA.SDR SWAA2013082619529Floorbeam · crackedFLOOR BEAM WEB CRACKED BETWEEN BS 380 TO BS 400, RBL 24.8. R&R WEB IAW SRM & DRAWING.SDR SWAA2013082619528Strap · crackedSTRAP CRACKED AT BS 540 BETWEEN LBL 45.5 TO LBL 62.5. R&R STRAP IAW SRM & DRAWING.SDR SWAA2013082619539Strap · crackedSTRAP CRACKED AT BS 540 BETWEEN RBL 24.8 & RBL 45.5. R&R STRAP IAW SRM & DRAWING.SDR SWAA2013081219099Channel · crackedCHANNEL CRACKED AT BS 540, BETWEEN BL 0.0 TO LBL 24.8. R&R CHANNEL IAW SRM & DRAWING.SDR SWAA2013080918986Fitting · corrodedL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FLOOR FITTING BOTH ADAPTER PLATES CORRODED. R&R FITTINGS IAW AMM.SDR SWAA2013080919005Fitting · corrodedR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FLOOR FITTING BOTH ADAPTER PLATES CORRODED. R&R FITTINGS IAW AMM.SDR SWAA2013090619931Skin · crackedFS SKIN CRACKED AT BS 908, BETWEEN STRINGER 3R TO STRINGER 4R. REPAIRED SKIN IAW EA.SDR SWAA2013082619527Tie Down · crackedTRACK TIE DOWN CRACKED AT BS 460 LBL 18.2. R&R TIE DOWN IAW SRM & DRAWING.SDR SWAA2013082619526Tie Down · crackedCARGO TRACK TIE DOWN CRACKED AT BS 482, RBL 13.8. REPAIRED TIE DOWN IAW SRM.SDR SWAA2013082619525Web · crackedWEB CRACKED BETWEEN BS 344 TO BS 360 BL 0. R&R WEB IAW SRM & DRAWING.SDR SWAA2013082119390Tie Clip · crackedTIE CLIP CRACKED AT BS 747, STRINGER 16R. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013082019360Strap · crackedSTRAP CRACKED BETWEEN BS 294.3 TO BS 360, LBL 51. R&R STRAP IAW SRM & DRAWING.SDR SWAA2013081919302Tie Clip · crackedTIE CLIP CRACKED AT BS 907, STRINGER 8L. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013081919301Tie Clip · crackedTIE CLIP CRACKED AT BS 663.75, STRINGER 4L. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013081919300Tie Clip · crackedTIE CLIP CRACKED AT BS 460, STRINGER 16L. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013081619272Skin · crackedSKIN CRACKED AT STATION 362, STRINGER 6R. REPAIRED SKIN IAW EA.SDR SWAA2013081519242Tie Clip · crackedTIE CLIP CRACKED AT BS 482, STRINGER 16L. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013081519241Tie Clip · crackedTIE CLIP CRACKED AT BS 440, STRINGER 8R. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013081319161Tie Clip · crackedTIE CLIP CRACKED AT BS 663.75, STRINGER 10L. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013081219102Flap · delaminatedRT WING INBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2013081219101Flap · delaminatedLT WING INBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2013081219098Angle · crackedANGLE CRACKED BETWEEN BS 887 TO BS 907, RBL 45.5. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013081219059Strap · crackedSTRAP CRACKED BETWEEN BS 294.3 TO BS 360, RBL 45.50. R&R STRAP IAW SRM & DRAWING.SDR SWAA2013081219058Strap · crackedSTRAP CRACKED BETWEEN BS 294.3 TO BS 360, RBL 31.60. R&R STRAP IAW SRM & DRAWING.
Back to Boeing 737-5H4