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 SWAA2014100932806Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B LBL 45.5. REPAIRED CHORD IAW EA.SDR SWAA2014100932805Frame · crackedFRAME CHORD CRACKED AT BS 727 STRINGER 18A RT. REPAIRED CHORD IAW EA.SDR SWAA2014100932804Frame · crackedFRAME CHORD CRACKED AT BS 727 STRINGER 18A LT. REPAIRED CHORD IAW EA.SDR SWAA2014100332610Pressure Deck · crackedMAIN WW BEADED PRESS DECK CRACKED AT BS 666 BETWEEN RBL 39 TO 41. REPAIRED DECK IAW SRM.SDR SWAA2014100332609Floorbeam · corrodedFLOORBEAM CORRODED AT BS 312 BL 0. REPAIRED BEAM IAW SRM.SDR SWAA2014100232516Angle · crackedTAIL CONE ANGLE CRACKED AT UPPER SURFACE FAIRING APU EXHAUST AREA. R & R ANGLE IAW SRM & DWG.SDR SWAA2014091832090Failsafe · crackedFORWARD CARGO COMPARTMENT FAIL SAFE CHORD CRACKED AT BS 440 BETWEEN STRINGER 14R TO 18R. R & R CHORD IAW SRM & DWG.SDR SWAA2014091632029Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED AT BS 788. REPAIRED WEB IAW SRM.SDR SWAA2014091531977Spindle · corrodedRIGHT WING NR 7 MID FLAP CARRIAGE SPINDLE CORRODED. R & R NR 7 MID FLAP IAW MT.SDR SWAA2014091131845Flap · delaminatedLEFT WING INBD FORE FLAP DELAMINATED. R & R FORE FLAP IAW AMM.SDR SWAA2014100832766Skin · crackedRIGHT WING NR 4 SLAT LOWER LE SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2014092232178Flap · corrodedLEFT WING FORE FLAP CTR TRACK OTBD FACE FWD CORRODED. REPAIRED FORE FLAP IAW CMM.SDR SWAA2014091632028Crease Beam · corrodedCREASE BEAM CORRODED BETWEEN BS 947.5 TO 986.5 RBL 54. R & R CREASE BEAM IAW DWG & SRM.SDR SWAA2014091031783Pump · failedDIVERSION DECLARED EMERGENCY. A HYD SYS FAILED BOTH LOW PRESS LIGHT ILLUMINATED & A QTY DEPLETED. R & R A ELEC HYD PUMP IAW MM.SDR SWAA2014090931744Battery Pack · dischargedLEFT EMER EXIT LIGHT INOPERATIVE AT ROW 22. R & R BATTERY PACK IAW AMM.SDR SWAA2014090931742Battery Pack · dischargedR2 DOOR EMER EXIT LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2014100832760Shear Tie · crackedSHEAR TIE CRACKED AT BS 277 BETWEEN STRINGER 10L TO 11L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014092232160Angle · crackedANGLE CRACKED AT BS 328 LBL 46. R & R ANGLE IAW DWG & SRM.SDR SWAA2014092232158Fitting · corrodedL1 DOOR EMER EVAC SLIDE AFT GIRT BAR FITTING SUPPORT ANGLE CORRODED. R & R FITTING IAW DWG & AMM.SDR SWAA2014091531950Intercostal · crackedFORWARD CABIN FLOOR INTERCOSTAL CRACKED AT BS 344 BL 0. R & R INTERCOSTAL IAW SRM.SDR SWAA2014091531949Floorbeam · crackedCABIN FWD WET AREA FLOORBEAM UPPER FLANGE ANGLE CRACKED AT BS 328, RBL 24. REPAIRED ANGLE IAW SRM.SDR SWAA2014091131827Transmission · corrodedRIGHT WING NR 5 AFT FLAP TRACK TRANSMISSION OTBD CORRODED. REPAIRED AFT FLAP IAW CMM.SDR SWAA2014100232531Frame · crackedFRAME WEB CRACKED AT BS 727D LBL 3 ATTACH FASTENER FOR NR 3 VHF ANTENNA. REPAIRED WEB IAW EA.SDR SWAA2014092532301Door Frame · crackedFRAME AT L1 DOOR INNER CHORD CRACKED AT BS 348.2 STRINGER 17L. R & R CHORD IAW EA.SDR SWAA2014092432251Angle · crackedANGLE CRACKED AT BS 294.5, STRINGER 11L. R & R ANGLE IAW DWG & SRM.SDR SWAA2014092232177Tie Clip · brokenTIE CLIP BROKEN AT BS 887 STRINGER 1. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014092232155Crease Beam · crackedL1 DOOR AREA, CREASE BEAM CRACKED AT BS 348.2 AT ATTACH FASTENER HOLE FOR FRAME INNER CHORD. R & R BEAM IAW DWG & SRM.SDR SWAA2014092232157Angle · crackedANGLE CRACKED AT BS 348 STRINGER 10L. R & R ANGLE IAW DWG & SRM.SDR SWAA2014092232156Attach Fitting · crackedANGLE ATTACH CLIP CRACKED AT BS 348 STRINGER 11L. R & R CLIP IAW SRM & DWG.SDR SWAA2014091832087Skin · corrodedSKIN CORRODED BETWEEN BS 986.5 TO 996 STRINGER 27R. REPAIRED SKIN IAW EA.SDR SWAA2014091832086Skin · corrodedSKIN CORRODED BETWEEN BS 986.5 TO 996 STRINGER 25R. REPAIRED SKIN IAW EA.SDR SWAA2014091531948Angle · crackedANGLE CRACKED AT BS 360 STRINGER 11L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014091531935Floor Support · crackedFLOOR PANEL SUPPORT ANGLE CRACKED BETWEEN BS 927 TO 947, LBL. R & R ANGLE IAW SRM & DWG.SDR SWAA2014091131857Bulkhead · canningPRESSURE BULKHEAD OUTER WEB OIL CANNING AT BS 1016 BETWEEN STRINGER 6R TO 7R. REPAIRED WEB IAW SRM & EA.SDR SWAA2014090931764Light · inoperativeRIGHT EMER LIGHT INOPERATIVE AT ROW 24. RELAMPED LIGHT IAW AMM.SDR SWAA2014090931763Wire · damagedRIGHT EMER LIGHT INOPERATIVE AT ROW 20. REPAIRED WIRE IAW SWPM.SDR SWAA2014090931762Panel · crackedLEFT WING LOWER TE PANEL JUST OTBD PYLON CRACKED. REPAIRED PANEL IAW EA.SDR SWAA2014090931761Panel · crackedRIGHT WING LOWER TE PANEL JUST OTBD PYLON CRACKED. REPAIRED PANEL IAW EA.SDR SWAA2014090931760Strap · crackedSTRAP CRACKED AT BS 344 RBL 40. REPAIRED STRAP IAW SRM.SDR SWAA2014090931712Light · looseLEFT EEPLS LOOSE. SECURED EEPLS IAW SIP.SDR SWAA2014090931710Tab · warpedRIGHT WING AILERON TAB WARPED. R & R TAB IAW MM.SDR SWAA2014090931691Light · looseRIGHT EEPLS LOOSE. SECURED EEPLS IAW SIP.SDR SWAA2014100632647Structure · crackedCHORD CRACKED AT BS 727 STRINGER 18A RT. REPAIRED CHORD IAW ER & EA.SDR SWAA2014100632646Structure · crackedCHORD CRACKED AT BS 727 STRINGER 18A LT. REPAIRED CHORD IAW ER & EA.SDR SWAA2014100232530Bulkhead · crackedAFT PRESS BULKHEAD WEB CRACKED AT BS 1016 BL 0. REPAIRED WEB IAW EA.SDR SWAA2014092232180Attach Fitting · crackedATTACH FITTING CRACKED AT BS 727 LBL 44.5. R & R FITTING IAW SRM.SDR SWAA2014092232154Angle · crackedRIGHT WING NR 6 FLAP TRACK FAIRING INBD SIDE ANGLE AT CROSS BRACE FWD SIDE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014091031799Bulkhead · crackedBULKHEAD WEB CRACKED AT BS 1016 STRINGER 2R. REPAIRED WEB IAW EA.SDR SWAA2014090931765Flap · delaminatedRIGHT WING OTBD TE AFT FLAP DELAMINATED AT OTBD END. R & R AFT FLAP IAW AMM.SDR SWAA2014090931748Battery · dischargedFORWARD ENTRY FLASHLIGHT BATTERY INOPERATIVE. R & R BATTERY IAW MM.
Back to Boeing 737-3H4