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 SWAA2014020424837Panel · crackedAFT CORRUGATED PANEL CRACKED ON KEEL BEAM AREA MAIN WW. R & R PANEL IAW SRM & DRAWING.SDR SWAA2014011324056Skin · crackedFUSELAGE SKIN CRACKED AT BS 482 STRINGER 19R. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012024280Tie Clip · crackedTIE CLIP CRACKED AT BS 767 STRINGER 19L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014011624159Tie Clip · crackedTIE CLIP CRACKED AT BS 787 STRINGER 18L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014011624143Frame · crackedFRAME CRACKED AT BS 482 BETWEEN STRINGER 20 TO STRINGER 21R. REPAIRED FRAME IAW SRM.SDR SWAA2014011624142Skin · crackedSKIN CRACKED AT BS 374 STRINGER 26L. REPAIRED SKIN IAW SWA EA.SDR SWAA2014011324055Skin · crackedFUSELAGE SKIN CRACKED AT BS 465 STRINGER 21R. REPAIRED SKIN IAW EA.SDR SWAA2014011324054Skin · crackedFUSELAGE SKIN CRACKED AT BS 404 STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014012224400Tie Clip · crackedTIE CLIP CRACKED AT BS 767 STRINGER 19L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014010923932Plate · crackedRT WING NR 6 FLAP TRACK FAIRING PLATE CRACKED. R &R PLATE IAW SRM & DRAWING.SDR SWAA2014021024994Attach Fitting · crackedATTACH CLIP CRACKED AT BS 348.2, STRINGER 16L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014020324773Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360, STRINGER 15L. R & R CHANNEL IAW SRM & DRAWING.SDR SWAA2014012024288Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360 STRINGER 14L. R & R CHANNEL IAW SRM & DRAWING.SDR SWAA2014013124722Angle · crackedFWD ENTRY DOOR CUTOUT LOWER AFT CORNER OF REVEAL ANGLE CRACKED AT BS 344, STRINGER 16L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014013024680Angle · crackedCLIP ANGLE CRACKED BETWEEN BS 348.2 TO BS 351.20 STRINGER 16L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014012024287Plate · crackedPLATE CRACKED AT BS 303.9 STRINGER 16L. R & R PLATE IAW SRM & DRAWING.SDR SWAA2014012024286Web · crackedWEB CRACKED BETWEEN BS 294.5 TO BS 303.9 STRINGER 11L. R & R WEB IAW SRM & DRAWING.SDR SWAA2014012024285Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 294.5 STRINGER 11L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014012024282Angle · crackedANGLE CRACKED BETWEEN BS 277 TO BS 291.5 BETWEEN STRINGER 10R TO STRINGER 11R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014011624156Fitting · crackedCLIP CRACKED AT BS 360 STRINGER 10L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014011324063Web · crackedWEB CRACKED BETWEEN BS 294.5 TO BS 303.9 STRINGER 12L. R & R WEB IAW SRM & DRAWING.SDR SWAA2014011324062Web · crackedWEB CRACKED BETWEEN BS 294.5 TO BS 303.9 STRINGER 7. R & R WEB IAW SRM & DRAWING.SDR SWAA2014010923931Angle · crackedVERTICAL ANGLE CRACKED AT BS 967 STRINGER 2R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014010923930Plate · crackedPLATE CRACKED BETWEEN BS 298 TO BS 314 STRINGER 4L. R & R PLATE IAW SRM & DRAWING.SDR SWAA2014010823872Structure · corrodedRT LOWER CHORD CORRODED BETWEEN BS 1112+3" TO BS 1121+17". R & R CHORD IAW SRM & DRAWING.SDR SWAA2014021125002Frame · crackedFRAME CRACKED AT BS 348.2, STRINGER 16L. REPAIRED FRAME IAW EA.SDR SWAA2014021024993Shear Web · crackedSHEAR WEB CRACKED AT BS 348.2, BETWEEN STRINGER 17L TO STRINGER 15L. R & R SHEAR WEB IAW EA.SDR SWAA2014021024992Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2, STRINGER 17L. REPAIRED CHORD IAW EA.SDR SWAA2014021024991Floorbeam · crackedFLOOR BEAM UPPER CHORD CRACKED AT BS 947.5, LBL 53.5. REPAIRED CHORD IAW EA.SDR SWAA2014021024940Structure · crackedFWD ENTRY DOOR STRUCTURE CRACKED AT BS 348.2, STRINGER 16L. REPAIRED STRUCTURE IAW EA.SDR SWAA2014020624904Frame · crackedFRAME CRACKED AT BS 277, BETWEEN STRINGER 15L TO STRINGER 16L. REPAIRED FRAME IAW EO.SDR SWAA2014020624903Frame · crackedFRAME CRACKED AT BS 277, BETWEEN STRINGER 15L TO STRINGER 16L. REPAIRED FRAME IAW EA.SDR SWAA2014020424835Beam · corrodedUPPER FLANGE OF FLOOR STRUCTURE BEAM CORRODED AT BS 328, RBL 49. R & R BEAM IAW SRM & DRAWING.SDR SWAA2014020424836Beam · corrodedUPPER FLANGE OF FLOOR STRUCTURE BEAM CORRODED AT BS 328 LBL 49. R & R BEAM IAW SRM & DRAWING.SDR SWAA2014020324772Beam · corrodedFLOOR STRUCTURE BEAM UPPER FLANGE CHORD CORRODED AT BS 328, BL 0. R & R CHORD IAW SRM & DRAWING.SDR SWAA2014020324771Sill · crackedFWD GALLEY DOOR CUTOUT SILL WEB CRACKED AT BS 294.5, STRINGER 17R. R & R WEB IAW SRM & DRAWING.SDR SWAA2014012924657Support Fitting · crackedSUPPORT FITTING CRACKED BETWEEN BS 291.5 TO BS 294.5 STRINGER 8R. R & R FITTING IAW SRM & DRAWING.SDR SWAA2014012824632Web · crackedWEB CRACKED BETWEEN BS 328 TO BS 344 LBL 44. R & R WEB IAW SRM & DRAWING.SDR SWAA2014012224399Frame · corrodedFRAME CORRODED AT BS 867 BETWEEN STRINGER 26L TO STRINGER 27L. REPAIRED FRAME IAW SRM.SDR SWAA2014012124361Support Angle · crackedRT WING TE SUPPORT ANGLE CRACKED AT RSS 544. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014012024279Strap · crackedAFT CARGO DOOR CUTOUT STRAP CRACKED AT BS 749.3 BETWEEN STRINGER 23R TO STRINGER 25R. R & R STRAP IAW SRM & DRAWING.SDR SWAA2014012024278Rib · crackedRT WING MID FLAP RIB CRACKED AT WBL 82. R & R RIB IAW SRM & DRAWING.SDR SWAA2014012024277Angle · crackedLT WING INBD FIXED TE STRUCTURE ANGLE CRACKED AT WBL 84. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014012024276Angle · crackedLT WING ANGLE CRACKED AT WBL 204.4. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014011624155Flap · delaminatedRT WING AFT FLAP DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2014011624147Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 277 TO BS 291.5 BETWEEN STRINGER 13R TO STRINGER 14R. R & R ANGLE IAW SRM.SDR SWAA2014011624146Tie Clip · crackedTIE CLIP CRACKED AT BS 294.5 STRINGER 12L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014011424105Stiffener · crackedLT WING NR 3 FLAP TRACK FAIRING STIFFENER CRACKED AT WBL 183. R & R STIFFENER IAW SRM & DRAWING.SDR SWAA2014011424101Bracket · crackedBRACKET CRACKED AT BS 294.5 STRINGER 4R. R & R BRACKET IAW SRM & DRAWING.SDR SWAA2014011424100Tie Clip · crackedTIE CLIP CRACKED AT BS 277 STRINGER 10R. R & R TIE CLIP IAW SRM & DRAWING.
Back to Boeing 737-5H4