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 SWAA2014010823877Forging · crackedLT BS 887+10 LOWER FWD CORNER OF WINDOW FORGING CRACKED AT HOLE NR 7. R & R FORGING IAW BAC DRAWING.SDR SWAA2014010723785Window · arcedR2 WINDOW ARCED. R & R R2 WINDOW IAW MM.SDR SWAA2014010223709Light · looseLT OVERWING EMERGENCY EXIT SIGN LIGHT ASSEMBLY LOOSE. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2014012224431Cam · crackedLT WING INBD AFT FLAP DRIVE MECHANISM BOOM CABLE CLUTCH CAM ARM ASSEMBLY CRACKED. R & R CAM ARM ASSEMBLY IAW CMM.SDR SWAA2014012124363Shear Web · crackedSHEAR WEB CRACKED BETWEEN BS 348 TO BS 351 BETWEEN STRINGER 15L TO STRINGER 17L. R & R SHEAR WEB IAW SRM & DRAWING.SDR SWAA2014012024263Tie Clip · crackedTIE CLIP CRACKED AT BS 440 STRINGER 2R. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014011724197Tie Clip · crackedTIE CLIP CRACKED AT BS 440 STRINGER 1. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014011424097Flap Track · crackedLT WING NR 4 FLAP TRACK CRACKED. R & R FLAP TRACK IAW AMM.SDR SWAA2014011324024Angle · crackedLT WING MLG STABILIZER BEAM OTBD AFT CORNER OF ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014010223779Relay · faultyAIR TURN BACK DURING TAKEOFF JUST AFTER THE LG HANDLE WAS SELECTED TO THE UP POSITION, THE "A" SYS ELECT LOW PRESSURE LIGHT ILLUMINATED. R & R RELAY IAW MM.SDR SWAA2014012824643Angle · crackedRT WING TE AILERON BAY 30 INCHES OTBD OF INBD EDGE ANGLE CRACKED. R & R ANGLE IAW AAR EA.SDR SWAA2014012024327Skin · chafedRT WING OTBD FORE FLAP OTBD LOWER SKIN CHAFFED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014012024317Angle · crackedSUB STRUCTURE ANGLE CRACKED AT BS 259 STRINGER 4L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014012024262Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2 STRINGER 17L. REPAIRED CHORD IAW EO & EA.SDR SWAA2014012024213Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 359 STRINGER 4R. R & R SPLICE IAW SWA EA.SDR SWAA2014011624167Skin · delaminatedRT WING OTBD TE FLAP LOWER SKIN DELAMINATED. REPAIRED SKIN IAW SRM.SDR SWAA2014011424096Fitting · crackedFITTING CRACKED BETWEEN BS 291.5 TO BS 294.5 STRINGER 8R. R & R FITTING IAW SRM & DRAWING.SDR SWAA2014011324048Floor Support · crackedCTR WING BOX LONGITUDINAL FLOOR BEAM, UPPER CHORD CRACKED AT BS 727B LBL 45.5. REPAIRED CHORD IAW SWA EA.SDR SWAA2014011324047Floor Support · crackedCTR WING BOX LONGITUDINAL FLOOR BEAM, UPPER CHORD CRACKED AT BS 727B LBL 24.8. REPAIRED CHORD IAW SWA EA.SDR SWAA2014010723796Channel · crackedAFT CARGO COMPARTMENT CHANNEL CRACKED BETWEEN BS 787 TO BS 792.5 RBL 17.48. R & R CHANNEL IAW SRM & DRAWING.SDR SWAA2014010723784Slide · unsecureL1 DOOR EMERGENCY EVAC SLIDE FELL OUT. REINSTALLED SLIDE IAW MM.SDR SWAA2014010223710Support Angle · corrodedR1 DOOR LOWER THRESHOLD CREASE BEAM INNER SUPPORT ANGLE CORRODED AROUND FASTENER HOLE. REPAIRED ANGLE IAW SRM.SDR SWAA2014010223722Battery Pack · dischargedAFT CABIN EMERGENCY EXIT LIGHT INOPERATIVE. R&R BATTERY PACK IAW MM.SDR SWAA2014012124358Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2 LBL 61. REPAIRED CHORD IAW EO & EA.SDR SWAA2014012024341Stiffener · crackedSTIFFENER CRACKED AT BS 1016. REPAIRED STIFFENER IAW EA.SDR SWAA2014012024261Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2 LBL 61. REPAIRED CHORD IAW EO & EA.SDR SWAA2014012024258Frame · crackedFRAME OUTER CHORD CRACKED AT BS 348.2 LBL 63. REPAIRED CHORD IAW EO & EA.SDR SWAA2014011724196Stiffener · crackedSTIFFENER CRACKED AT BS 1016 STRINGER 5R. REPAIRED STIFFENER IAW SWA EA.SDR SWAA2014011624140Access Panel · crackedSKIN ACCESS PANEL CRACKED AT BS 716 BETWEEN STRINGER 27R TO STRINGER 27L. REPAIRED PANEL IAW SRM.SDR SWAA2014011624139Structure · crackedLINING CUTOUT CRACKED AT BS 992.5 STRINGER 15R. R & R CUTOUT IAW SRM.SDR SWAA2014011624138Structure · crackedLINING CRACKED AT BS 332.1 STRINGER 16. REPAIRED LINING IAW SRM & DRAWING.SDR SWAA2014011624137Plate · crackedPLATE CRACKED AT BS 344 LBL 48. R & R PLATE IAW SRM & DRAWING.SDR SWAA2014011624131Stiffener · crackedSTIFFENER CRACKED AT BS 1016 RBL 10. R & R STIFFENER IAW SRM & DRAWING.SDR SWAA2014011324023Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 360 STRINGER 17L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014011324022Shear Tie · crackedSHEAR TIE CRACKED AT BS 967 STRINGER 7L. R & R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2014010923921Access Panel · crackedRT PYLON ACCESS PANEL CRACKED AT BS 235. REPAIRED PANEL IAW SRM.SDR SWAA2014011423869Bracket · crackedBRACKET CRACKED BETWEEN BS 348.2 TO BS 351.0 STRINGER 16L. R & R BRACKET IAW SRM & DRAWING.SDR SWAA2014010823873Skin · crackedLT WING NR 2 SLAT SKIN CRACKED AT OTBD AUXILIARY TRACK. REPAIRED SKIN IAW SRM.SDR SWAA2014010723809Angle · crackedANGLE CRACKED BETWEEN BS 277 TO BS 291.5 STRINGER 10R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014010723805Skin · crackedRT WING NR 5 SLAT SKIN CRACKED AT INBD AUXILIARY TRACK. REPAIRED SKIN IAW SRM.SDR SWAA2014010723804Skin · crackedRT WING NR 6 SLAT SKIN CRACKED AT INBD AUXILIARY TRACK. REPAIRED SKIN IAW SRM.SDR SWAA2014010223740Strap · crackedSTRAP CRACKED BETWEEN BS 312 TO BS 344 LBL 46. R & R STRAP IAW SRM & DRAWING.SDR SWAA2014010223741Strap · crackedSTRAP CRACKED BETWEEN BS 312 TO BS 344, LBL 10. REPAIRED STRAP IAW SRM & DRAWING.SDR SWAA2014012724576Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727 STRINGER 18A RT. REPAIRED CHORD IAW EA.SDR SWAA2014012324450Frame · crackedFRAME CRACKED AT BS 520 BETWEEN STRINGER 20R TO STRINGER 21R. REPAIRED FRAME IAW SRM.SDR SWAA2014012224398Frame · crackedFRAME OUTER CHORD CRACKED AT BS 348.2 LBL 63. REPAIRED CHORD IAW EO & EA.SDR SWAA2014012024245Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 540 STRINGER 24L. R & R ANGLE IAW SRM.SDR SWAA2014012024259Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2 LBL 59. REPAIRED CHORD IAW EO & EA.SDR SWAA2014012024256Skin · crackedFUSELAGE SKIN CRACKED AT BS 908 STRINGER 3R. REPAIRED SKIN IAW EA.SDR SWAA2014011624166Door Frame · crackedFWD ENTRY DOOR AFT FRAME CRACKED AT BS 348 STRINGER 15L. REPAIRED FRAME IAW ER & EA.
Back to Boeing 737-3H4