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 SWAA2015080742622Cable · misroutedR2 DOOR EMER EVAC SLIDE CABLE MISROUTED. REROUTED CABLE IAW AMM.SDR SWAA2015110645812Skin · crackedFUSELAGE SKIN CRACKED AT BS 827+3, STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2015092344221Intercostal · crackedINTERCOSTAL CRACKED, BETWEEN BS 328 - 344, RBL 27. REPAIRED INTERCOSTAL IAW ER & EA.SDR SWAA2015091443748Skin · crackedFUSELAGE SKIN CRACKED, BETWEEN BS 500 - 500B+2, BETWEEN STRINGER 1R - 2R. REPAIRED SKIN IAW SRM.SDR SWAA2015090343482Skin · crackedFUSELAGE SKIN CRACKED AT BS 344.5, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2015082643233Bracket · corrodedL1 DOOR EMER EVAC SLIDE GIRT BAR BRACKETS CORRODED, BETWEEN BS 312 TO 344. R & R BRACKETS IAW AMM. .SDR SWAA2015082143065Spoiler · corrodedLEFT WING GND SPOILER CORRODED OTBD ACTUATOR. R & R GND SPOILER IAW SRM.SDR SWAA2015081142742Support Bracket · crackedLEFT WING NR 1 FLAP TRACK FAIRING SUPPORT BRACKET CRACKED. R & R BRACKET IAW SRM.SDR SWAA2015080742612Skin · crackedFUSELAGE SKIN CRACKED AT BS 500, STRINGER 1R. REPAIRED SKIN IAW EA.SDR SWAA2015080642566Wedge · delaminatedLEFT WING NR 3 SLAT DELAMINATED INBD AFT WEDGE. REPAIRED WEDGESDR SWAA2015092444243Support Fitting · crackedLEFT REAR WING SPAR, UPPER CHORD CRACKED AT MLG AFT SUPPORT FITTING. REPAIRED FITTING IAW ER & EA.SDR SWAA2015092444242Support Fitting · crackedRIGHT REAR WING SPAR, UPPER CHORD CRACKED AT MLG AFT SUPPORT FITTING. REPAIRED FITTING IAW ER & EA.SDR SWAA2015082743254Skin · crackedFUSELAGE SKIN CRACKED AT BS 489, STRINGER 25R. REPAIRED SKIN IAW SRM.SDR SWAA2015081442851Casting · crackedL1 DOOR UPPER HINGE CASTING CRACKED AT THE LOWER CORNER. REMOVED CASTING IAW SRM & DWG.SDR SWAA2015080742613Skin · crackedFUSELAGE SKIN CRACKED AT BS 827+3, STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2015080642559Skin · crackedR1 DOOR SKIN UPPER HINGE CUT OUT UPPER AFT CORNER CRACKED. R & R R1 DOOR IAW MM.SDR SWAA2015080642558Lens · unsecureFORWARD ENTRY EMER EXIT LIGHT LENS COVER FWD ENTRY FELL OFF. INSTALLED COVER IAW MM.SDR SWAA2015080542543Battery · dischargedFORWARD INBD EMER FLASHLIGHT INOPERATIVE. R & R BATTERY IAW AMM.SDR SWAA2015080542528Wedge · delaminatedLEFT WING NR 3 SLAT WEDGE DELAMINATED. R & R NR 3 SLAT IAW MM.SDR SWAA2015080542513Flap · delaminatedLEFT WING OTBD AFT FLAP DELAMINATED APPROX 78" FROM OTBD EDGE. R & R AFT FLAP IAW AMM.SDR SWAA2015091844044Seat Track · crackedSEAT TRACK FLANGE CRACKED AT BS 727B, RBL 24.8. REPAIRED FLANGE IAW ER & EA.SDR SWAA2015090943533Crossbeam · crackedAFT CARGO DOOR CROSS BEAM E CHORD CRACKED AT 2ND & 3RD FASTENERS FROM FWD END OF VERTICAL FLANGE. REPAIRED T CHORD IAW RO.SDR SWAA2015080542542Light · inoperativeAFT ENTRY DOOR CENTER PANEL EMER LIGHT INOPERATIVE. REPAIRED LIGHT ASSEMBLY IAW MM.SDR SWAA2015080442500Sign · unsecureL1 DOOR EMERGENCY EXIT SIGN FELL OFF. R & R SIGN IAW AMM.SDR SWAA2015091443855Floor Support · crackedLONGITUDINAL FLOORBEAM, UPPER CHORD AFT END AT OTBD FASTENER HOLE, COMMON TO THE ATTACH STRAP CRACKED AT BS 727B, RBL 24.8. REPAIRED CHORD IAW ER & EA.SDR SWAA2015091443769Flap Track · corrodedRIGHT WING FLAP TRACK NR 5, FWD OTBD LUG BORE & FACE CORRODED. REPAIRED NR 5 FLAP TRACK IAW EO & EA.SDR SWAA2015090243456Lug · corrodedRIGHT WING NR 5 FLAP TRACK AFT ATTACHMENT FITTING, LUG CORRODED. REPAIRED LUG IAW CMM.SDR SWAA2015090243455Fitting · corrodedRIGHT MLG BEAM, INBD FWD LINK ASSEMBLY, FWD LUG CORRODED. REPAIRED FITTING IAW CMM, EO & EA.SDR SWAA2015082543177Frame · corrodedFORWARD CARGO BAY, FWD SIDE OF FRAME CORRODED AT BS 500B, BETWEEN STRINGER 26R TO 27R. REPAIRED FRAME IAW SRM.SDR SWAA2015082543176Shear Tie · corrodedFORWARD CARGO BAY FRAME FOOT SHEAR TIE CORRODED AT BS 500A, BETWEEN STRINGER 28L TO 28R. R & R SHEAR TIE IAW SRM.SDR SWAA2015081742883Bracket · crackedRIGHT WING INBD FLAP, OTBD TRACK FAIRING BRACKET CRACKED. R & R BRACKET IAW SRM & DWG.SDR SWAA2015081442848Angle · crackedLEFT WING INBD FLAP OTBD TRACK FAIRING ANGLE CRACKED LOCATED ON INTERNAL AREA. R & R ANGLE IAW SRM & DWG.SDR SWAA2015081242772Pad · corrodedFORWARD CARGO BAY NET ATTACH PAD CORRODED AT BS 495, BETWEEN STRINGER 21L TO 23L. REPAIRED PAD IAW SRM & DWG.SDR SWAA2015081142644Door Frame · corrodedR2 DOOR FWD SIDE, STUB FRAME CORRODED AT BS 947. R & R STUB FRAME IAW DWG.SDR SWAA2015080342417Housing · shortedLEFT EMERGENCY EXIT LIGHT SHORTED. R & R HOUSING IAW AMM.SDR SWAA2015080342406Battery · dischargedR1 DOOR EMERGENCY LIGHT IN FORWARD GALLEY INOPERATIVE AT M1675. R & R BATTERY IAW AMM.SDR SWAA2015100844701Spar · crackedLEFT WING REAR WING SPAR, UPPER CHORD CRACKED AT MLG AFT SUPPORT FITTING. REPAIRED CHORD IAW EA & ER.SDR SWAA2015081842928Web · corrodedWEB CORRODED BETWEEN BS 685 TO 693, STRINGER 18A LT ON UPPER SURFACE. REPAIRED WEB IAW ER & EA.SDR SWAA2015080442506Detector · faultyAIR TURN BACK, UPON DEPARTURE AT 1500 FT, HYDRAULIC SYSTEM AN ELECTRIC LOW PRESSURE LIGHT ILLUMINATED. R & R AN ELECTRIC GND FAULT DETECTOR IAW AMM.SDR SWAA2015080342416Light · inoperativeFORWARD ENTRY OVERHEAD EMERGENCY EXIT LIGHT LAMP INOPERATIVE. RELAMPED IAW AMM.SDR SWAA2015080342412Hook · looseL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOKS LOOSE. SECURED HOOKS IAW SRM.SDR SWAA2015080342411Battery Pack · dischargedFORWARD EMERGENCY LOW LEVEL LIGHT INOPERATIVE AT M9132. R & R BATTERY PACK IAW AMM.SDR SWAA2015080342405Skin · crackedFUSELAGE SKIN CRACKED AT LOWER FORWARD CORNER OF EXTERNAL POWER DOOR CUT OUT. REPAIRED SKIN IAW EA.SDR SWAA2015080342459Spoiler · delaminatedLEFT WING NR 2 SPOILER DELAMINATED. R & R NR 2 SPOILER IAW MM.SDR SWAA2015082543199Fitting · corrodedLEFT MLG BEAM FITTING ASSEMBLY CORRODED. R & R FITTING IAW AMM.SDR SWAA2015073142383Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2015073142371Sign · looseFORWARD ENTRY EXIT SIGN LOOSE. SECURED SIGN IAW SIP.SDR SWAA2015100544529Skin · crackedSKIN CRACKED AT BS 892, STRINGER 2L. REPAIRED SKIN IAW EA.SDR SWAA2015090343471Skin · crackedAFT VERTICAL CHEM MILL SKIN CRACKED AT BS 907, BETWEEN STRINGER 4R TO 5R. REPAIRED SKIN IAW SRM.SDR SWAA2015082042994Skin · crackedFUSELAGE SKIN CRACKED AT BS 478, STRINGER 3L. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4