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 SWAA012327Fitting · corrodedDURING SCHEDULED D CHECK, FOUND LH MLG SUPPORT BEAM AFT HANGER FITTING CORRODED. R&R FITTING PER MM.SDR SWAA012317Slat · delaminatedDURING SCHEDULED D CHECK, FOUND # 2 L/E SLAT DELAMINATED AT T/E WEDGE OTBD END. REPAIRED SLAT PER SRM.SDR SWAA012272Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STR TIE CLIP CRACKED AT BS 380, STR 10L. REMOVED AND REPLACED STR TIE CLIP PER SRM.SDR SWAA012257Bearing · wornDURING SCHEDULED D CHECK, FOUND RH ELEVATOR TAB ROD END BEARINGS WORN. R&R ELEVATOR TAB ROD END BEARINGS PER OHM.SDR SWAA012216Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED AT STR 8R, BS 400, BS 747, BS 787 & BS 867. REPAIRED FUSELAGE FRAMES PER SRM & BFG ER.SDR SWAA012215Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED AT STR 8L, BS 400, BS 787 & BS 827. REPAIRED FUSELAGE FRAMES PER SRM & BFG ER.SDR SWAA012358Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CRACKED AT BS 277, STR 10R. REPAIRED STR PER SRM.SDR SWAA012240Fitting · brokenDURING SCHEDULED D CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING ANCHOR NUT BROKEN. R&R GIRT BAR FITTING ANCHOR NUT PER MM.SDR SWAA012193Cover · looseEEPLS COVER LOOSE. SECURED EEPLS COVER PER MM.SDR SWAA012186Lens · brokenEMERGENCY EXIT LIGHT LENS BROKEN ABOVE ROW 7 ABC. R&R LIGHT ASSY PER MM.SDR SWAA012200Crease Beam · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM CRACKED AT BS 520, LBL 59. REPAIRED CREASE BEAM PER SRM.SDR SWAA012165Wire · disconnectedEEPLS INOP BETWEEN ROWS 12 & 15. RECONNECTED WIRES PER MM.SDR SWAA012166Light · looseOVERHEAD BIN BULL NOSE EMERGENCY LIGHT LOOSE AT ROW 7 ABC. SECURED LIGHT ASSY PER MM.SDR SWAA012147Wire · disconnectedEEPLS INOP IN NUMEROUS PLACES. RECONNECTED WIRES PER MM.SDR SWAA012158Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 4R. REMOVED STR CLIP PER SRM.SDR SWAA012082Slide · unserviceableFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA012069Cover · looseEEPLS COVER COVER LOOSE AT ROW 10. INSTALLED EEPLS COVER PER MM.SDR SWAA012060Cover · looseEEPLS COVER LOOSE AT ROW 10. SECURED EEPLS COVER PER MM.SDR SWAA012059Slide · out of adjFWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. INSTALLED EVAC SLIDE PER MM.SDR SWAA012027Light · missingDURING SCHEDULED D-CHECK, FOUND EEPLS MISSING AT FWD END. INSTALLED LIGHT ASSY PER MM.SDR SWAA012023Tire · damaged(ABORTED TAKEOFF) SEVERE VIBRATION FELT AT NOSE WHEELS. FOUND TREAD LOSS AT NR 2 NLG TIRE, CAUSING DAMAGE TO THE NLG BY-PASS VALVE, AFT E&E DOOR AND RT MLG DOOR OPEN/CLOSE ROD ASSY. REMOVED AND REPLACED BOTH NLG TIRE AND WHEEL ASSY'S. REMOVED AND REPLACED SDR SWAA012018Actuator · crackedDURING LANDING, LOST HYD SYS A, FOUND # 0 SPOILER ACTUATOR CRACKED. R&R SPOILER ACTUATOR PER MM.SDR SWAA012017Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, LBL 23 & WL 154. REPAIRED FRAME PER SRM.SDR SWAA011939Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 296, RBL 54, WL 209. REPAIRED FRAME PER BFG ER.SDR SWAA011930Chip Detector · dislodged(ENGINE SHUT DOWN, DIVERSON & DECLARED EMERGENCY)…………………………DURING CRUSE # 1 ENGINE OIL PRESS & OIL QUANITY INDICATED OUT OF LIMITS. FOUND # 1 ENG AFT OIL CHIP DETECTOR DISLODGED, SECURED CHIP DETECTOR PER MM.SDR SWAA011906Web · crackedDURING SCHEDULED SPV CHECK, FOUND NLG W/W LH WEB CRACKED AT BS 259.5, WL 180.. REPAIRED WEB PER SWA RA.SDR SWAA011987Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT ENTRY DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER BFG ER & SRM.SDR SWAA011896Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 4L. R&R STR CLIP PER SRM.SDR SWAA011895Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIPS CRACKED AT BS 767, STR 4L & STR 4R. R&R STR CLIPS PER SRM.SDR SWAA011894Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIPS CRACKED AT BS 727C, STR 4R, STR 2R, STR 4L & STR 3L. R&R STR CLIPS PER SRM.SDR SWAA011893Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 3R & STR 4R. R&R STR CLIPS PER SRM.SDR SWAA011892Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 3R. R&R STR CLIP PER SRM.SDR SWAA011883Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED AT STR 16R, BS 400 & BS 480. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA011878Cover · looseEEPLS COVERS LOOSE. SECURED EEPLS COVERS PER MM.SDR SWAA011872Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, LBL 65 , WL 202. REPAIRED FRAME PER T1-153-018.SDR SWAA011943Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 312, WL 208. REPAIRED FLOORBEAM PER SRM.SDR SWAA011884Splice · crackedDURING SCHEDULED D CHECK, FOUND STRINGER SPLICE'S CRACKED AT BS 908, STR 4L & 4R. R&R STRINGER SPLICE'S PER SRMSDR SWAA011857Flashlight · inoperativeEMERGENCY FLASHLIGHT INOP AT AFT UPPER POSITION. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA011850Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947.5, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA011944Skin · crackedDURING SCHEDULED D CHECK, FOUND RH HORIZ STAB LOWER SKIN CRACKED AT STA 124. REPAIRED SKIN PER SWA ACO.SDR SWAA011825Cover · looseEEPLS COVER LOOSE AT ROW 21. SECURED EEPLS COVER PER MM.SDR SWAA011841Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND CENTER LONGITUDINAL FLOORBEAM CRACKED AT BS 660 & BS 663. REPAIRED FLOORBEAM PER SRM.SDR SWAA011848Ballast · inoperativeDURING SCHEDULED D-CHECK, FOUND RT OVERWING EXIT LIGHT INOP AND LENS BROKEN. REMOVED AND REPLACED BALLAST AND LENS PER MM.SDR SWAA011774Window Post · crackedDURING SCHEDULED RON CHECK, FOUND WINDOW POST CRACKED AT CAPT'S #1 WINDOW, UPPER LH CORNER. REPAIRED WINDOW POST PER SRM.SDR SWAA011756Sign · looseAFT SVC DOOR EMERGENCY EXIT SIGN LOOSE. SECURED EXIT SIGN PER MM.SDR SWAA011755Wire · exposedEEPLS WIRES EXPOSED AT ROW 10. SECURED EEPLS WIRES PER MM.SDR SWAA011775Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND CENTER LONGITUDINAL FLOORBEAM CRACKED AT BS 663. REPAIRED FLOORBEAM PER SRM.SDR SWAA011766Bracket · brokenDECLARED EMERGENCY, TOXIC FUMES IN COCKPIT. SOURCE OF ODOR AT, F/O'S NR 5 EYEBROW WINDOW. SENSOR SPRING BRACKET BROKEN, SPRING SHORTED OUT SENSOR WIRES. CONT PER MEL 30-11. ON 16 JUN AT DAL REMOVED AND REPLACED SPRING BRACKET PER MM.SDR SWAA011736Wire · exposedEEPLS WIRES EXPOSED AT ROW 10. SECURED EEPLS WIRES PER MM.SDR SWAA011726Wire · exposedEEPLS WIRES EXPOSED AT ROW 10. SECURED EEPLS WIRES PER MM.
Back to Boeing 737-5H4