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 SWAA2015011335719Connector · not seatedAFT CABIN EMER EXIT LIGHTS CAME ON. COCKPIT EMER EXIT SWITCH IN ARMED POSITION & AFT GALLEY SWITCH OFF. EMERGENCY EXIT LIGHTS IN FWD CABIN REMAINED OFF. RESEATED CONNECTORS AT EMER LIGHT CHARGERS IAW MM.SDR SWAA2015010935605Battery Pack · dischargedFORWARD EMER LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2015010935597Light · inoperativeLEFT EMER EXIT LIGHT INOPERATIVE AT ROW 22. REPAIRED LIGHT IAW MM.SDR SWAA2015010935595Skin · crackedL1 DOOR INNER SKIN CRACKED BELOW THE TORQUE BOX. REPAIRED SKIN IAW EA.SDR SWAA2015010935587Battery Pack · faultyON CLIMB, ALL EMER LIGHTS FROM OVERWING EXIT AFT WERE ILLUMINATED. FLIGHT DECK SWITCH WAS IN ARMED POSITION & AFT FLIGHT ATTENDANT SWITCH IN NORMAL POSITION. LIGHTS FWD OF OVERWING EXIT REMAINED OFF. R & R BATTERY PACK ASSEMBLY IAW MM.SDR SWAA2015021136526Spar · crackedLEFT WING REAR SPAR UPPER CHORD CRACKED AT RSS 222.2. REPAIRED CHORD IAW ER & EA.SDR SWAA2015021136525Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED AT RSS 222.2. REPAIRED CHORD IAW ER & EA.SDR SWAA2015020536348Structure · corrodedFORWARD CARGO SKIN LOWER CHORD CORRODED AT BS 540, LBL 13. REPAIRED CHORD IAW EA.SDR SWAA2015011435729Plate · crackedLEFT WING TE PLATE CRACKED AT WBL 204. R & R PLATE IAW DWG & SRM.SDR SWAA2015011235653Slat · delaminatedLEFT WING NR 2 SLAT DELAMINATED INBD & OTBD TE. R & R NR 2 SLAT IAW MM.SDR SWAA2015011235688Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 767, STRINGER 2R. R & R CLIP IAW SRM & DWG.SDR SWAA2015010935598Light · inoperativeRIGHT AFT EMER LIGHT BEHIND BODY FAIRING INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2015010835546Lens · missingLEFT EMER LIGHT LENS MISSING AT ROW 17. INSTALLED LENS IAW MM.SDR SWAA2015010835545Flap · delaminatedRIGHT WING OTBD FORE FLAP DELAMINATED AT TE INBD OF NR 7 FLAP TRACK. REPAIRED FORE FLAP IAW MM.SDR SWAA2015011935876Shear Tie · crackedSHEAR TIE CRACKED AT BS 907, STRINGER 2L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015011235687Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 827, STRINGER 2R. R & R CLIP IAW SRM & DWG.SDR SWAA2015010835568Lug · brokenLEFT WING NR 4 INBD GND SPOILER OTBD LUG BROKEN. R & R NR 4 SPOILER IAW AMM.SDR SWAA2015011535790Stringer · crackedSTRINGER CRACKED AT BS 500, STRINGER 14R. REPAIRED STRINGER IAW SRM.SDR SWAA2015011235644Reveal · crackedFORWARD GALLEY DOOR CUT OUT REVEAL CRACKED BETWEEN BS 326.5 TO 330, STRINGER 17R. R & R CUT OUT IAW SRM & DWG.SDR SWAA2015010635488Strap · crackedLOWER FLANGE BEAM STRAP CRACKED AT BS 344, LBL 45.6. R & R STRAP IAW SRM & DWG.SDR SWAA2015012636072Skin · crackedLEFT WING NR 2 SLAT LOWER SURFACE CRACKED. REPAIRED NR 2 SLAT IAW SRM.SDR SWAA2015012035922Skin · crackedSKIN CRACKED AT BS 380, STRINGER 14L. REPAIRED SKIN IAW EA.SDR SWAA2015011935875Skin · crackedSKIN CRACKED AT BS 480, STRINGER 14L. REPAIRED SKIN IAW EA.SDR SWAA2015010635504Light · brokenFORWARD ENTRY EMER EXIT LIGHT BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015010535454Light · brokenBULLNOSE EXIT LIGHT BROKEN AT ROW 2 ABC. R & R LIGHT IAW MM.SDR SWAA2015010535453Light · brokenBULLNOSE EXIT LIGHT BROKEN AT ROW 6 ABC. R & R LIGHT IAW MM.SDR SWAA2015010535449Slide · looseR2 DOOR SLIDE LOOSE. R & R SLIDE ASSEMBLY IAW MM.SDR SWAA2015010535447Skin · crackedL1 DOOR INNER SKIN CRACKED BELOW THE TORQUE BOX AT LOWER HINGE AREA. REPAIRED SKIN IAW EA.SDR SWAA2015010535446Lens · brokenL1 DOOR SLIDE EMER EXIT SIGN LENS BROKEN. R & R LENS IAW MM.SDR SWAA2015010535448Sign · looseOVERHEAD OVERWING EXIT SIGN LOOSE. SECURED SIGN IAW MM.SDR SWAA2015010235415Skin · crackedL1 DOOR INNER SKIN CRACKED BELOW LOWER TORQUE BOX AT LOWER HINGE AREA. REPAIRED SKIN IAW EA.SDR SWAA2015010235409Duct · delaminatedSMELL AROUND ROW 10. TURNED OFF GASPER FAN & SMELL WENT AWAY. FOUND A/C MIX CHAMBER DUCTS ASSEMBLY DELAMINATED & BLOWN OUT. R & R SAME IAW MM.SDR SWAA2015010935599Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 277, STRINGER 4L. R & R CLIP IAW SRM & DWG.SDR SWAA2014123035330Battery Pack · dischargedBULLNOSE EMER LIGHT AT SEAT ROW 22 ABC INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2015010235420Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 639, STRINGER 4L. R & R CLIP IAW SRM.SDR SWAA2015012035921Skin · crackedSKIN CRACKED AT BS 380, STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014123035315Lens · looseL1 DOOR ENTRY EMER EXIT LIGHT LENS LOOSE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014123035313Charger · faultyEMERGENCY EXIT LIGHTS ILLUMINATED IN CABIN DURING APPROACH. R & R BATTERY CHARGER ASSEMBLY IAW MM.SDR SWAA2015012035919Shear Tie · corrodedSHEAR TIE CORRODED AT BS 520, BETWEEN STRINGER 28R TO 28L. R & R SHEAR TIE IAW DWG & SRM.SDR SWAA2014123035352Skin · crackedFUSELAGE SKIN CRACKED AT L1 DOOR, UPPER HINGE CUT OUT, APPROX STATION 315, STRINGER 10L. REPAIRED SKIN IAW EA.SDR SWAA2014123035350Hinge · brokenNUMBER 5 GND SPOILER OTBD HINGE BROKEN. R & R SPOILER ASSEMBLY IAW MM.SDR SWAA2014122335230Skin · crackedL1 DOOR INNER SKIN CRACKED AT LOWER HINGE AREA. REPAIRED SKIN IAW EA.SDR SWAA2014122335229Lens · looseLEFT EMER EXIT LIGHT LENS NOT SECURED. SECURED IAW MM.SDR SWAA2014122335228Lens · looseR2 DOOR EMER EXIT LIGHT LENS LOOSE. R & R LENS IAW MM.SDR SWAA2014122335227Door Frame · crackedL1 DOOR LOWER FRAME CRACKED AT AFT LOWER CORNER. REPAIRED FRAME IAW SRM.SDR SWAA2015010735525Angle · crackedFLOOR STRUCTURE UPPER INTERCOSTAL ANGLE CRACKED BETWEEN BS 927 TO 947, BL 0. INSTALLED ANGLE IAW SRM.SDR SWAA2015010235440Web · crackedFUSELAGE WEB CRACKED AT STATION 500A TO 500B, STRINGER 26L. REPAIRED WEB IAW SRM.SDR SWAA2015010235439Web · crackedFUSELAGE WEB CRACKED AT STATION 500 TO 500A, STRINGER 26L. REPAIRED WEB IAW SRM.SDR SWAA2014123035351Spoiler · delaminatedNUMBER 7 SPOILER DELAMINATED. R & R SPOILER ASSEMBLY IAW MM.SDR SWAA2015010235445Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT STATION 787+10, LOWER FWD CORNER OF WINDOW CUT OUT. REPAIRED SKIN IAW EA & SB.
Back to Boeing 737-3H4