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 SWAA2015011235643Light · brokenFORWARD GALLEY EMER EXIT LIGHT WIRE RECEPTACLE BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015010235414Stringer Clip · damagedSTRINGER CLIP DAMAGED AT STATION 727A, STRINGER 9L. R & R CLIP IAW SRM.SDR SWAA2015010235412Stringer Clip · damagedSTRINGER CLIP DAMAGED AT STATION 727B, STRINGER 9L. R & R CLIP IAW SRM.SDR SWAA2014121935160Lens · unsecureFORWARD EXIT LIGHT LENS FELL OFF. REINSTALLED LENS IAW MM.SDR SWAA2014121735116Pressure Gauge · defectiveINFLIGHT SHUTDOWN, AIR TURN BACK & DECLARED EMER. NR 1 ENG OIL PRESS LOW ON TAKEOFF & CLIMB OUT, INDICATED IN YELLOW BAND. NO OIL PRESS LIGHT ILLUMINATED. R & R NR 1 ENG OIL PRESS GAUGE IAW MM.SDR SWAA2014121735105Wire · brokenAFT EMER EXIT LIGHT LOCATOR INOPERATIVE. REPAIRED BROKEN WIRE IAW AMM.SDR SWAA2015012135928Tie Clip · crackedSTRINGER TIE CLIP CRACKED AT BS 320, STRINGER 20L. R & R TIE CLIP IAW SRM.SDR SWAA2015011935870Tie Clip · crackedSTRINGER TIE CLIP CRACKED AT BS 328, STRINGER 20L. R & R TIE CLIP IAW SRM.SDR SWAA2015011535773Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 660, LBL 24.8. REPAIRED BEAM IAW ER & EA.SDR SWAA2015011435728Strap · crackedFLOORBEAM STABILIZING STRAP CRACKED AT BS 328, BL 10. REPAIRED STRAP IAW SRM.SDR SWAA2015010635498Strap · crackedFLOORBEAM STABILIZING STRAP AT CRACKED AT BS 328, BL 0. REPAIRED STRAP IAW SRMSDR SWAA2015010235416Stringer Clip · brokenSTRINGER CLIP BROKEN AT STATION 727A, STRINGER 1. R & R CLIP IAW SRM.SDR SWAA2014121635083Cover · looseL1 DOOR LOWER EXIT SIGN COVER LOOSE. SECURED COVER IAW SIP.SDR SWAA2015011235642Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 360, STRINGER 19R. R & R SPLICE IAW SRM.SDR SWAA2015010635497Stringer · crackedSTRINGER CRACKED AT BS 360, STRINGER 2L. R & R STRINGER IAW SRM.SDR SWAA2015010235436Frame · corrodedLEFT WING A FRAME NR 8 CORRODED AT BORES. REPAIRED FRAME IAW CMM.SDR SWAA2015010235435Frame · corrodedRIGHT WING A FRAME NR 7 CORRODED AT BORES. REPAIRED FRAME IAW CMM.SDR SWAA2015010235434Frame · corrodedLEFT WING A FRAME NR 1 CORRODED AT BORES. REPAIRED FRAME IAW CMM.SDR SWAA2015010235433Frame · corrodedLEFT WING A FRAME NR 2 CORRODED AT BORES. REPAIRED FRAME IAW CMM.SDR SWAA2015010235418Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 380, STRINGER 22L. R & R CLIP IAW SRM.SDR SWAA2014122335240Skin · crackedFUSELAGE SKIN CRACKED AT STATION 443, STRINGER 1L. REPAIRED SKIN IAW EA.SDR SWAA2015012235976Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 360, STRINGER 24L. R & R SPLICE IAW SRM & DWG.SDR SWAA2015012235975Keelbeam · corrodedFORWARD CARGO LT KEEL BEAM LOWER CHORD CORRODED AT BS 500D. REPAIRED CHORD IAW EA & ER.SDR SWAA2015011235641Support Angle · crackedLEFT PYLON NACELLE SUPPORT ANGLE CRACKED ON NACELLE STRUT INBD SIDE AT STATION 277.24. R & R ANGLE IAW SRM & DWG.SDR SWAA2014121635060Fuse · blownL1 OVERHEAD EMER EXIT LIGHT INOPERATIVE. R & R FUSE IAW AMM.SDR SWAA2014121635059Fuse · blownR2 OVERHEAD EMER EXIT LIGHT INOPERATIVE. R & R FUSE IAW AMM.SDR SWAA2014121534986Light · inoperativeLEFT BULLNOSE EMER EXIT LIGHTS INOPERATIVE BETWEEN ROW 3 TO 6. R & R BULB IAW AMM.SDR SWAA2014121534985Light · inoperativeL1 DOOR EXTERNAL EMER EXIT LIGHT INOPERATIVE. RE LAMPED LIGHT IAW MM.SDR SWAA2014121534980Light · inoperativeRIGHT BULLNOSE EMER EXIT LIGHTS INOPERATIVE AT ROW 16. R & R BULB IAW AMM.SDR SWAA2014121534977Windshield · crackedL1 WINDOW ARCED & CRACKED. R & R WINDSHIELD IAW MM.SDR SWAA2015012636054Frame · crackedFRAME CRACKED AT BS 348.2, STRINGER 16L. REPAIRED FRAME IAW EA.SDR SWAA2015012336014Attach Fitting · crackedLEFT WING RSS 553 WIPER WEB ATTACH CLIP CRACKED. R & R CLIP IAW SRM.SDR SWAA2015011935871Skin · crackedLEFT WING EXTERNAL SKIN ON FIXED LE UPPER SURFACE CRACKED AT STATION 208. REPAIRED SKIN IAW SRM.SDR SWAA2015011535791Floorbeam · corrodedFLOORBEAM UPPER CHORD CORRODED AT BS 986.5, BETWEEN LBL 5 TO LBL 44. REPAIRED CHORD IAW EO & EA.SDR SWAA2015011535777Floorbeam · corrodedFLOORBEAM UPPER CHORD CORRODED AT BS 986.5, RBL 43. REPAIRED CHORD IAW EO & EA.SDR SWAA2015011535785Floorbeam · corrodedFLOORBEAM UPPER CHORD CORRODED AT BS 986.5, BETWEEN RBL 13 TO RBL 20. REPAIRED CHORD IAW EO & EA.SDR SWAA2015011335711Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STRINGER 2L. R & R SPLICE IAW EO & EA.SDR SWAA2015011235640Web · corrodedWEB CORRODED BETWEEN BS 420 TO 440, STRINGER 17R. R & R WEB IAW SRM & DWG.SDR SWAA2015011235639Stringer · corrodedSTRINGER CORRODED BETWEEN BS 907+5 TO 927+5, STRINGER 21R. R & R STRINGER IAW SRM & DWG.SDR SWAA2015010835566Structure · corrodedR2 DOOR INNER CHORD CORRODED BETWEEN BS 947.5+9 TO 986.5+8, STRINGER 17R. R & R CHORD IAW SRM & DWG.SDR SWAA2015010635496Structure · corrodedINNER CHORD CORRODED BETWEEN BS 294.5 TO BS 344, STRINGER 17L. R & R CHORD IAW SRM & DWG.SDR SWAA2015010635489Skin · crackedRIGHT WING EXTERNAL SKIN CRACKED ON FIXED LE UPPER SURFACE IN LEVEL WBL 157.00. REPAIRED SKIN IAW EA.SDR SWAA2015010535470Shear Tie · corrodedFUSELAGE SHEAR TIE CORRODED AT STATION 807, STRINGER 26L TO 27L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015010235442Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 787, BETWEEN STRINGER 26L & 27L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2014121935168Floorbeam · corrodedFLOORBEAM CORRODED AT STATION 986.5, RBL 60 TO BL 0. REPAIRED BEAM IAW SRM.SDR SWAA2014121835137Floorbeam · corrodedFLOORBEAM T CAP CORRODED AT BS 986.5 OTBD AREA. REPAIRED T CAP IAW SRM.SDR SWAA2014121535029Access Panel · leakingDIVERSION, FLUID LEAK AT RT WING ACCESS PANEL DURING FLIGHT. R & R FULL PANEL 8817R IAW MM.SDR SWAA2014121534995Battery Pack · dischargedLEFT BULLNOSE EMER LIGHT INOPERATIVE AT ROW 18. R & R BATTERY PACK IAW AMM.SDR SWAA2014121534994Strap · crackedLEFT INBD STRAP CRACKED AT BS 340 INSIDE E & E ACCESS. REPAIRED STRAP IAW SRM.SDR SWAA2015012636052Beam · crackedLONGITUDINAL BEAM UPPER CHORD CRACKED AT BS 667, LBL 24.8. REPAIRED CHORD IAW ER & EA.
Back to Boeing 737-3H4