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 SWAA2013100320751Skin · crackedFS SKIN CRACKED AT BS 400+3 STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2013100320766Coffeemaker · faultyDURING DESCENT STRONG BURNING SMELL IN AFT GALLEY. R & R NR 2 COFFEE MAKER IAW AMM.SDR SWAA2013100820971Tie Clip · crackedTIE CLIP CRACKED AT BS 847 STRINGER 20L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013100220663Cover · crackedLT WING NR 3 FLAP CARRIAGE BUMPER PLATE COVER CRACKED. R & R COVER IAW CMM.SDR SWAA2013100120616Support Angle · crackedLT WING SUPPORT ANGLE AT INTERNAL STRUCTURE CRACKED AT WBL 183.40 OF FLAP TRACK FAIRING. R & R CLIP IAW SRM & DRAWING.SDR SWAA2013092520488Flap · delaminatedRT WING OTBD TE FLAP DELAMINATED. R & R AFT FLAP IAW AMM.SDR SWAA2013092320382Light · inoperativeLT OVERWING EMERGENCY EXIT SIGN BULBS INOPERATIVE. R & R BULBS IAW AMM.SDR SWAA2013092320335Sign · unsecureLT OVERWING EMERGENCY EXIT SIGN FELL OFF. REINSTALLED SIGN IAW AMM.SDR SWAA2013092620541Intercostal · crackedINTERCOSTAL CRACKED AT BS 303.9 STRINGER 4L. R & R INTERCOSTAL IAW SRM.SDR SWAA2013100220679Flap · delaminatedLT WING INBD CORNER OF INBD AFT FLAP DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2013091820229Stringer · crackedSTRINGER CRACKED BETWEEN BS 747 TO BS 767, STRINGER 22L. REPAIRED STRINGER IAW SRM.SDR SWAA2013091120074Shear Tie · crackedSHEAR TIE ANGLE CRACKED AT BS 747, BETWEEN STRINGER 22L TO STRINGER 23L. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013091820228Stiffener · crackedSTIFFENER "Z" CRACKED BS 1016, STRINGER 18L. R & R STIFFENER IAW SRM & DRAWING.SDR SWAA2013092320336Angle · crackedANGLE CRACKED AT BS 1016 + 11 LBL 29. R & R ANGLE IAW SRM.SDR SWAA2013091920314Angle · crackedANGLE CRACKED AT BS 1016 STRINGER 17L. R & R ANGLE IAW SRM.SDR SWAA2013090519881Tab · delaminatedRT WING AILERON TAB DELAMINATED OTBD END. R&R TAB IAW MM.SDR SWAA2013090519873Slat · delaminatedRT WING NR 5 SLAT WEDGE DELAMINATED ON OTB END. R&R NR 5 SLAT PER AMM.SDR SWAA2013090919979Crease Beam · crackedINNER CREASE BEAM CHORD CRACKED AT STATION 947.5 + 11", LBL 53. R&R CHORD IAW SRM & DRAWING.SDR SWAA2013100220674Bulkhead · crackedBULKHEAD WEB CRACKED AT BS 1016 STRINGER 18L. REPAIRED WEB IAW EA.SDR SWAA2013091920313Stringer · crackedL1 DOOR CUTOUT STRINGER CRACKED AT BS 294.5 STRINGER 4L. REPAIRED STRINGER IAW SRM.SDR SWAA2013091020031Strap · crackedRT CREASE BEAM INNER CHORD VERTICAL LEG SPLICE CRACKED AT STATION 540-8. R&R STRAP IAW DRAWING & SRM.SDR SWAA2013091020030Strap · crackedLT CREASE BEAM INNER CHORD VERTICAL LEG SPLICE CRACKED AT STATION 540- 8. R&R STRAP IAW SRM & DRAWING.SDR SWAA2013102821588Skin · crackedSKIN CRACKED AT BS 787 + 15, STRINGER 21L. REPAIRED SKIN IAW EO & EA.SDR SWAA2013100320753Frame · crackedFRAME CRACKED AT BS 520 STRINGER 21R. REPAIRED FRAME IAW EA.SDR SWAA2013100320752Skin · crackedSKIN CRACKED AT BS 400 + 12.5 STRINGER 1L. REPAIRED SKIN IAW EA.SDR SWAA2013102821587Skin · crackedSKIN CRACKED AT BS 787 + 12, STRINGER 19L. REPAIRED SKIN IAW EO & EA.SDR SWAA2013102821586Skin · crackedSKIN CRACKED AT BS 787 + 12.5, STRINGER 8L. REPAIRED SKIN IAW EO & EA.SDR SWAA2013091320116Skin · crackedSKIN CRACKED AT BS 747 + 1.75, STRINGER 18L. REPAIRED SKIN IAW SRM.SDR SWAA2013091320115Skin · crackedSKIN CRACKED AT BS 767 + 12.5, STRINGER 18L. REPAIRED SKIN IAW SRM.SDR SWAA2013091020038Strap · crackedSTRAP CRACKED BETWEEN BS 927 & BS 947.5, BETWEEN STRINGER 16L & STRINGER 17L. R&R STRAP IAW SRM & DRAWING.SDR SWAA2013091020037Tie Clip · crackedTIE CLIP CRACKED AT BS 277, STRINGER 10R. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013091020036Frame · crackedSTUB FRAME CRACKED AT BS 947.5+9, STRINGER 8R. R&R FRAME IAW SRM.SDR SWAA2013090919969Floorbeam · corrodedFLOOR BEAM CORRODED AT BS 344, BL 0. REPAIRED BEAM IAW SRM.SDR SWAA2013090919968Strap · crackedSTRAP CRACKED BETWEEN BS 927 & BS 947.5, BETWEEN STRINGER 16R & STRINGER 17R. R&R STRAP IAW SRM & DRAWING.SDR SWAA2013090919967Tie Clip · crackedTIE CLIP CRACKED AT BS 967, STRINGER 4R. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013102821585Skin · crackedSKIN CRACKED AT BS 787 + 16, STRINGER 18L. REPAIRED SKIN IAW EO & EA.SDR SWAA2013102321418Skin · crackedSKIN CRACKED AT BS 927 + 4.7, STRINGER 23R. REPAIRED SKIN IAW EA.SDR SWAA2013100220695Skin · crackedSKIN CRACKED AT BS 420+6" BETWEEN STRINGER 17R TO STRINGER 18R. REPAIRED SKIN IAW EA.SDR SWAA2013093020568Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 707 RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2013092620544Fitting · crackedFWD GALLEY DOOR CUT OUT FITTING CRACKED AT BS 294.5 STRINGER 8R. REPAIRED FITTING IAW EA.SDR SWAA2013092320383Door Frame · crackedFWD GALLEY DOOR CUTOUT STUB FRAME CRACKED AT BS 294.5, STRINGER 7R. REPAIRED FRAME IAW EA.SDR SWAA2013091220101Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STRINGER 20L TO STRINGER 2L. REPAIRED FRAME IAW SRM.SDR SWAA2013091120073Angle · crackedLT WING NR 3 FLAP TRACK FAIRING ANGLE CRACKED BETWEEN WBL 184.40 TO WBL 202.60. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013091020035Reveal · crackedL1 DOOR CUTOUT AFT LOWER REVEAL CRACKED AT STRINGER 17L. R&R REVEAL IAW SRM & DRAWING.SDR SWAA2013091020034Angle · crackedLT WING NR 3 FAIRING FLAP TRACK ANGLE CRACKED AT WBL 202.40. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013090919966Angle · crackedFWD GALLEY DOOR CUTOUT ANGLE CRACKED AT BS 291.5, BETWEEN STRINGER 12R TO STRINGER 13R. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013090619935Shear Tie · crackedSHEAR TIE CRACKED AT BS 294.5, BETWEEN STRINGER 9L TO STRINGER 10L. R&R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2013090619934Plate · crackedRT WING INBD MID FLAP PLATE CRACKED. R&R PLATE IAW SRM.SDR SWAA2013090319766Angle · crackedR1 DOOR CUTOUT ANGLE CRACKED AT BS 291.5, BETWEEN STRINGER 9R TO STRINGER 10R. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013102221349Angle · crackedRT WING INTERNAL AREA TE ANGLE CRACKED AT RSS 238+7. R & R ANGLE IAW SRM & DRAWING.
Back to Boeing 737-5H4