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 SWAA2014031025901Shear Tie · corrodedFRAME SHEAR TIE CORRODED AT BS 907, STRINGER 27L TO STRINGER 26L. R & R SHEAR TIE IAW SRM.SDR SWAA2014030725847Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 907, STRINGER 25R. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014030725845Retaining Clip · looseR1 DOOR EMERGENCY EVAC SLIDE RETAINING CLIPS LOOSE. R & R CLIPS IAW SOPM.SDR SWAA2014030725844Retaining Clip · looseL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINING CLIPS LOOSE. R & R CLIPS IAW SRM.SDR SWAA2014030625829Support Angle · crackedLT MLG WW PANEL SUPPORT ANGLE CRACKED AT BS 727, BETWEEN LBL 8 TO LBL 16. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014030525773Web · crackedWEB CRACKED BETWEEN BS 328 TO BS 344, LBL 47.0. R & R WEB IAW SRM & DRAWING.SDR SWAA2014030525772Web · crackedWEB CRACKED BETWEEN BS 312 TO BS 328, LBL 47.0. REPAIRED WEB IAW SRM & DRAWING.SDR SWAA2014030525771Floorbeam · corrodedFLOOR BEAM CORRODED AT BS 986.5, LBL 45. REPAIRED BEAM IAW SRM.SDR SWAA2014030525770Support Angle · crackedRT WING TE SUPPORT ANGLE CRACKED AT WBL 204. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014030425727Window · arcedR1 WINDOW ARCED. R & R WINDOW IAW AMM.SDR SWAA2014030325709Fitting · crackedCLIP CRACKED AT BS 927, STRINGER 11R. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014030325702Angle · crackedSUPPORT TEE CHORD ANGLE CRACKED AT BS 540, LT AIR CONDITIONING BAYS COMPARTMENT. R & R ANGLE IAW SRM.SDR SWAA2014040726874Shear Tie · corrodedAFT CARGO COMPARTMENT FRAME SHEAR TIE CORRODED AT BS 727D, BETWEEN STRINGER 25L TO STRINGER 26L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2014032826596Web · crackedRIGHT NLG WW WEB CRACKED AT STATION 243.7+3.5, WL 169.1. REPAIRED WEB IAW EA.SDR SWAA2014032826595Web · crackedRIGHT NLG WW WEB CRACKED AT STATION 243.7+2.5, WL 169.1. REPAIRED WEB IAW EA.SDR SWAA2014032426449Frame · corrodedAFT CARGO BAY FRAME CORRODED AT BS 767, BETWEEN STRINGER 26R TO STRINGER 26L. REPAIRED FRAME IAW EA.SDR SWAA2014032426448Frame · corrodedAFT CARGO PIT FRAME CORRODED AT BS 787, BETWEEN STRINGER 25L TO STRINGER 26R. R & R FRAME IAW SRM & DWG.SDR SWAA2014032426464Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 663, RBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2014032426450Frame · corrodedAFT CARGO COMPARTMENT FRAME CORRODED AT BS 747, BETWEEN STRINGER 25L TO STRINGER 25R. R & R FRAME IAW SRM & DWG.SDR SWAA2014032426356Web · crackedLT NLG WW WEB CRACKED AT BS 259.5, WL 185. REPAIRED WEB IAW SRM.SDR SWAA2014032426334Bulkhead · crackedDOME CAP WEB CRACKED AT BS 1016, STRINGER 15L. REPAIRED DOME CAP WEB IAW SRM.SDR SWAA2014032026281Skin · crackedRT WING NR 5 SLAT LOWER SURFACE SKIN CRACKED INBD OF STATION 194.01. REPAIRED SKIN IAW SRM.SDR SWAA2014032026247Web · crackedLEFT NLG WW CRACKED AT BS 243.7 + 3.5, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2014032026246Web · crackedLEFT NLG WW WEB CRACKED AT BS 243.7 + 2.5, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2014032026270Light · brokenAFT WALL OF THE FWD LAVATORY EMERGENCY EXIT LIGHT BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2014032026269Skin · crackedRT WING NR 5 SLAT LOWER SURFACE SKIN CRACKED INBD OF STATION 215.4. REPAIRED SKIN IAW SRM.SDR SWAA2014032026264Floorbeam · corrodedFLOOR BEAM UPPER CHORD CORRODED AT BS 967, RBL 41. REPAIRED CHORD IAW ER & EA.SDR SWAA2014032026263Strap · corrodedTHRESHOLD STRAP CORRODED BETWEEN BS 767 TO BS 787, RBL 22. R & R STRAP IAW SRM & DWG.SDR SWAA2014031826176Stringer Clip · corrodedAFT CARGO BAY STRINGER CLIP CORRODED AT BS 767, STRINGER 27L. R & R CLIP IAW SRM & DWG.SDR SWAA2014031726134Structure · corrodedLEFT UPPER CHORD CORRODED AT BS 986.5, LBL 17. R & R CHORD IAW EA.SDR SWAA2014031726101Support Angle · crackedRT WING SUPPORT ANGLE CRACKED AT WBL 71.24 TE. R & R ANGLE IAW SRM & DWG.SDR SWAA2014031726074Frame · corrodedAFT CARGO COMPARTMENT FRAME CORRODED AT BS 727E, BETWEEN STRINGER 26R TO STRINGER 26L. R & R FRAME IAW DWG & SRM.SDR SWAA2014031726073Stringer Clip · corrodedAFT CARGO COMPARTMENT STRINGER CLIP CORRODED AT BS 747, STRINGER 27R. R & R CLIP IAW SRM & DWG.SDR SWAA2014031426056Web · crackedFUSELAGE WEB CRACKED AT STATION 695, RBL 62.5, STRINGER 17R. REPAIRED WEB IAW SRM.SDR SWAA2014031326026Flap · delaminatedRT WING OTBD AFT FLAP DELAMINATED AT INBD END. R & R FLAP ASSEMBLY IAW MM.SDR SWAA2014031326025Wedge · delaminatedNR 5 LE SLAT WEDGE PANEL DELAMINATED. REPAIRED SLAT WEDGE IAW SRM.SDR SWAA2014031125959Skin · delaminatedRT WING NR 6 SLAT WEDGE UPPER AFT INBD CORNER SKIN DELAMINATED. REPAIRED SKIN IAW SRM.SDR SWAA2014031025907Charger · brokenBATTERY CHARGER HOLD DOWN BROKEN AT BS 727+18, 213 LBL. R & R CHARGER IAW AMM.SDR SWAA2014030725852Angle · crackedLT WING REAR SPAR ANGLE CRACKED AT WBL 70.85. R & R ANGLE IAW SRM.SDR SWAA2014030725843Support Angle · corrodedL1 DOOR EMERGENCY EVAC SLIDE GRIT BAR FITTING SUPPORT ANGLE CORRODED AT BS 312, LBL 57. R & R ANGLE IAW SRM.SDR SWAA2014030725842Support Angle · corrodedL1 DOOR EMERGENCY EVAC SLIDE GRIT BAR FITTING SUPPORT ANGLE CORRODED AT BS 344, LBL 57. R & R ANGLE IAW SRM.SDR SWAA2014030425738Angle · crackedLT WING NR 3 FLAP TRACK ANGLE CRACKED AT WBL 183.40. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014030325708Angle · crackedRT WING TE ANGLE CRACKED AT RSS 545. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014022725616Flap · looseRT WING INBD AFT FLAP LOOSE. SECURED AFT FLAP IAW MM.SDR SWAA2014022725615Flap · looseRT WING OTBD AFT FLAP LOOSE. SECURED AFT FLAP IAW MM.SDR SWAA2014022725614Stiffener · crackedRT WING AILERON STIFFENER CRACKED INBD OF NR 2 HINGE. R & R STIFFENER IAW SRM.SDR SWAA2014022825665Crossbeam · crackedAFT CARGO DOOR CROSS BEAM CRACKED AT AFT END. REPAIRED BEAM IAW SWA EA.SDR SWAA2014032626526Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A RT. REPAIRED CHORD IAW EO & EA.SDR SWAA2014032426447Structure · crackedRIGHT CHORD CRACKED AT BS 727, STRINGER 18. REPAIRED CHORD IAW EA.SDR SWAA2014032426355Skin · crackedRT WING LE SKIN CRACKED AT STATION 208. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4