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 SWAA2015070641284Skin · crackedRIGHT WING AFT SPAR UPPER SKIN CRACKED IN AFT FASTENER ROW AT RSS 267. REPAIRED SKIN IAW EA.SDR SWAA2015070641281Skin · crackedLEFT WING UPPER SKIN CRACKED AT UPPER CHORD AT RSS 266. REPAIRED SKIN IAW EA.SDR SWAA2015070141318Spar · crackedLEFT WING REAR SPAR WEB RSS 216, UPPER FASTENER HOLE CRACKED AT AFT EDGE OF WEB. REPAIRED WEB IAW EA.SDR SWAA2015062541126Skin · crackedLEFT WING UPPER SKIN CRACKED AT REAR SPAR, STATION RSS 267. REPAIRED SKIN IAW EA.SDR SWAA2015062541125Skin · crackedLEFT WING UPPER SKIN CRACKED AT REAR SPAR, STATION RSS 266. REPAIRED SKIN IAW EA.SDR SWAA2015062541124Skin · crackedLEFT WING UPPER SKIN CRACKED AT REAR SPAR, STATION RSS 249. REPAIRED SKIN IAW EA.SDR SWAA2015062541123Skin · crackedLEFT WING UPPER SKIN CRACKED AT REAR SPAR, STATION RSS 235. REPAIRED SKIN IAW EA.SDR SWAA2015061040533Skin · crackedLEFT WING AILERON SKIN CRACKED NEAR INBD EDGE. REPAIRED SKIN IAW SRM.SDR SWAA2015060140240Frame · crackedFUSELAGE FRAME CRACKED AT STATION 986, STRINGER 20R. REPAIRED FRAME IAW EA.SDR SWAA2015052640039Web · crackedRIGHT NLG WW BULKHEAD TRUNNION VERTICAL WEB CRACKED AT BS 294.5. REPAIRED WEB ASSEMBLY IAW EA.SDR SWAA2015052239951Angle · crackedINBOARD INTERCOSTAL STIFFENER ANGLE CRACKED AT BS 294.5, STRINGER 16L. R & R ANGLE IAW SRM & DWG.SDR SWAA2015051839812Tab · looseLEFT ELEVATOR TAB HINGE NR 2 OTBD FLANGED HAT BUSHING LOOSE IN HINGE BRACKET CLEVIS. R & R LT TAB IAW AMM.SDR SWAA2015051839804Wedge · delaminatedRIGHT WING NR 5 SLAT UPPER TE WEDGE DELAMINATED AT THE OTBD END. R & R NR 5 LE SLAT IAW MM.SDR SWAA2015051539803Wedge · delaminatedRIGHT WING NR 4 SLAT UPPER TE WEDGE DELAMINATED AT THE INBD END. R & R NR 4 LE SLAT IAW MM.SDR SWAA2015051839802Strip · crackedFORWARD CABIN PAX CABIN FLOOR EGRESS PROXIMITY LIGHTING STRIP CRACKED. R & R STRIP IAW AMM.SDR SWAA2015051839801Cover · missingRIGHT EMER EXIT LENS COVER MISSING. INSTALLED COVER IAW AMM.SDR SWAA2015052840122Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 807, STRINGER 26R. R & R CLIP IAW SRM.SDR SWAA2015052239940Angle · crackedLEFT WING NR 3 FLAP TRACK FAIRING LOWER AFT INBD STIFFENER ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2015051939824Web · crackedWEB CRACKED AT BS 520+8, BETWEEN STRINGER 22L - 24L. R & R WEB IAW SRM & DWG.SDR SWAA2015051539713Battery Pack · dischargedR2 DOOR EMER ESCAPE LIGHT INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2015051539710Lens · dirtyRIGHT EMER EXIT LIGHT LENS COVER DIRTY. R & R LENS IAW MM.SDR SWAA2015051439653Glowstrip · looseRIGHT PHOTO LUMINESCENT STRIP LOOSE AT ROW 9. SECURED STRIP IAW AMM.SDR SWAA2015061740811Skin · crackedFUSELAGE SKIN CRACKED AT AFT END OF EQUIPMENT COOLING EXHAUST. REPAIRED SKIN IAW ER & EA.SDR SWAA2015061640695Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986.5, RBL 5. REPAIRED FLOORBEAM IAW EA.SDR SWAA2015061640694Support Angle · corrodedFORWARD ENTRY DOOR THRESHOLD SUPPORT ANGLE CORRODED ON UPPER SURFACE BETWEEN BS 320 TO 335, LBL 60. R & R ANGLE IAW SRM.SDR SWAA2015052940217Threshold · corrodedTHESHOLD WEB CORRODED AT STATION 950 - 980, STRINGER 17L. REPAIRED WEB IAW SRM.SDR SWAA2015052940216Intercostal · crackedFUSELAGE INTERCOSTAL CRACKED AT STATION 292 - 303, STRINGER 16L. REPAIRED INTERCOSTAL IAW SRM.SDR SWAA2015052840121Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908, STRINGER 4R. R & R SPLICE IAW SRM & ER.SDR SWAA2015052840120Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STRINGER 5L. R & R CLIP IAW SRM.SDR SWAA2015052840119Strap · crackedFLOORBEAM STABILIZING STRAP CRACKED AT BS 328, LBL 11. REPAIRED STRAP IAW SRM.SDR SWAA2015052840118Bulkhead · crackedBULKHEAD VERTICAL BEAM WEB CRACKED AT BS 178, RBL 17.0. REPAIRED WEB IAW SRM.SDR SWAA2015051439678Control Rod · looseRIGHT ELEVATOR TAB INBD CONTROL ROD BOLT LOOSE IN TAB MAST FITTING. R & R CONTROL ROD IAW EA.SDR SWAA2015051439677Sign · loosePASSENGER CABIN CEILING EXIT SIGN LOOSE AT ROW 2. SECURED SIGN IAW MM.SDR SWAA2015051439676Glowstrip · damagedRIGHT PAX CABIN PHOTO LUMINESCENT FLOOR STRIP DAMAGED AT ROW 4. R & R STRIP IAW MM.SDR SWAA2015051439675Glowstrip · damagedRIGHT PAX CABIN PHOTO LUMINESCENT FLOOR STRIP DAMAGED AT ROW 3. R & R STRIP IAW MM.SDR SWAA2015051439674Lug · brokenRIGHT WING NR 5 INBD GND SPOILER INBD LUG BROKEN. R & R SPOILER IAW AMM.SDR SWAA2015061640780Wire · brokenAFT BULLNOSE LIGHTED EXIT SIGN WIRE BROKEN. R & R SIGN IAW AMM.SDR SWAA2015061640779Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED ON UPPER & LOWER SURFACES BETWEEN BS 460 TO 480, BETWEEN RBL 65 TO 70. R & R WEB IAW SRM.SDR SWAA2015060240309Support · corrodedLEFT WING TE MID FLAP NR 2 CARRIAGE FRAME SUPPORT CORRODED. REPAIRED SUPPORT IAW CMM.SDR SWAA2015060240308Support · corrodedLEFT WING TE MID FLAP NR 1 CARRIAGE FRAME SUPPORT CORRODED. REPAIRED SUPPORT IAW CMM.SDR SWAA2015060240292Web · crackedRIGHT NLG WW WEB CRACKED AT STATION 258.5, RBL 11. REPAIRED WEB IAW SRM.SDR SWAA2015052840117Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED ON UPPER SURFACE BETWEEN BS 500A TO 500B. R & R WEB IAW SRM & DWG.SDR SWAA2015052840154Web · crackedLEFT NOSE WW WEB CRACKED VERTICALLY AT BONDED DOUBLER EDGE AT BS 258.5. REPAIRED WEB IAW SRM.SDR SWAA2015051439663Strut · crackedLEFT MLG SHOCK STRUT LUG OTBD HOLE, HAT BUSHING CRACKED. R & R STRUT IAW CMM & AMM.SDR SWAA2015051439673Cover · unsecureFORWARD BULKHEAD EMER EXIT LIGHT LENS COVER FELL OFF. ATTACHED COVER IAW SIP.SDR SWAA2015051239588Lens · missingR2 DOOR EMER EXIT SIGN LENS COVER MISSING. R & R COVER IAW AMM.SDR SWAA2015060340354Wire · deterioratedEMERGENCY EXIT LIGHT ELEC WIRE DETERIORATED AT STATION 907. REPAIRED WIRE IAW SWPM.SDR SWAA2015060240291Pressure Panel · crackedMLG WW PRESS WEB CRACKED AT STATION 672, LBL 42. REPAIRED WEB IAW EA.SDR SWAA2015060240289Frame · corrodedFUSELAGE FRAME CORRODED AT STATION 607, BETWEEN STRINGER 27L & 26R. REPAIRED FRAME IAW SRM.SDR SWAA2015060240288Frame · corrodedFUSELAGE FRAME CORRODED AT STATION 807, STRINGER 26R. REPAIRED FRAME IAW SRM.
Back to Boeing 737-3H4