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 SWAA2013041614887Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 21L. REMOVED AND REPLACED TIE CLIP IAW SRM.SDR SWAA2013041614886Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 26L. REMOVED ANAD REPLACED TIE CLIP IAW SRM AND DRAWING.SDR SWAA2013041614885Channel · crackedCHANNEL CRACKED AT BS 294.5+3, RIGHT SIDE E/E COMPARTMENT. REMOVED AND REPLACED CHANNEL IAW SRM AND DRAWING.SDR SWAA2013041614882Stiffener · crackedSTIFFENER CRACKED BETWEEN BS 294.5 TO BS 303.9, STR 16L. REMOVED AND REPLACED STIFFENER IAW SRM AND DRAWING.SDR SWAA2013041614881Stiffener · crackedSTIFFENER CRACKED BETWEEN BS 294.5 TO BS 303.9, STR 15L. REMOVED AND REPLACED STIFFENER IAW SRM AND DRAWING.SDR SWAA2013041514827Strap · crackedSTRAP CRACKED BETWEEN BS 312 TO BS 344, BL 0. REMOVED AND REPLACED STRAP IAW SRM AND DRAWING.SDR SWAA2013041514826Angle · crackedVERTICAL ANGLE CRACKED AT BS 328, LBL 50. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013041514825Strap · crackedSTRAP CRACKED BETWEEN BS 312 TO BS 360, LBL 50. REMOVED AND REPLACED STRAP IAW SRM AND DRAWING.SDR SWAA2013041514822Support Angle · crackedVERTICAL SUPPORT ANGLE CRACKED AT STA 727+4, RBL 5. REMOVED AND REPLACED ANGLE IAW SRM & DWG.SDR SWAA2013041214796Rub Strip · missingRUB STRIPS MISSING ON CUT OUT OF NACELLE STRUT ACCESS NR 5831R ENGINE NR 2. INSTALLED RUB STRIP IAW DWG.SDR SWAA2013041214795Rub Strip · missingRUB STRIP MISSING ON CUT OUT OF NACELLE STRUT ACCESS NR 5828R ENGINE NR 2. INSTALLED RUB STRIP IAW DWG.SDR SWAA2013041214794Stop Fitting · crackedSTOP PAD FITTING CRACKED BETWEEN BS 616 TO BS 639, STR 11L. REMOVED AND REPLACED FITTING IAW DWG.SDR SWAA2013041214793Rub Strip · missingRUB STRIPS MISSING ON CUT OUT OF NACELLE STRUT ACCESS NR 5827R ENGINE NR 2. INSTALLED RUB STRIP IAW DWG.SDR SWAA2013041114730Flashlight · inoperativeAFT O/B EMERGENCY FLASHLIGHT INOP. RESTOWED FLASHLIGHT AS PER MM.SDR SWAA2013052216360Floorbeam · corrodedFLOORBEAM CORRODED AT BS 328, RBL 45. REPAIRED BEAM IAW SRM AND EA.SDR SWAA2013051716175Floorbeam · corrodedFLOORBEAM CORRODED AT BS 967, BETWEEN BL 0 TO RBL 40. REPAIRED BEAM IAW EA.SDR SWAA2013051516078Frame · crackedSTUB FRAME CRACKED AT BS 296.4, STR 7R. REPAIRED STUB FRAME IAW EA.SDR SWAA2013051315910Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986.5, RBL 45.5. REPAIRED CHORD IAW EA.SDR SWAA2013050815836Plate · crackedFORWARD ENTRY DOOR FWD CORNER OF LOWER TRIM SWEEPER PLATE CRACKED. REMOVED AND REPLACED PLATE IAW SRM AND DRAWING.SDR SWAA2013050715770Skin Panel · crackedSKIN PANEL CRACKED BETWEEN BS 540 TO BS 560. REMOVED AND REPLACED PANEL IAW EA.SDR SWAA2013050715738Angle · corrodedZ-ANGLE CORRODED BETWEEN BS 294.5 TO BS 360, LBL 62. REMOVED AND REPLACED Z-ANGLE IAW SRM AND DWG.SDR SWAA2013050715737Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 500C, STR 26L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013050715718Angle · crackedANGLE CRACKED AT BS 440, STR 26L. REMOVED AND REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013050715717Web · crackedWEB CRACKED AT BS 520+5, BETWEEN STR 22L TO STR 24L. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013050115431Frame · crackedFRAME CRACKED AT BS 986.5, STR 20R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA2013043015347Angle · crackedANGLE CRACKED AT BS 540, STR 22R. REPAIR ANGLE IAW SRM.SDR SWAA2013043015348Stiffener · crackedSTIFFENER CRACKED BETWEEN BS 312 TO BS 328, RBL 30. REMOVED AND REPLACED STIFFENER IAW SRM AND DRAWING.SDR SWAA2013043015346Angle · crackedANGLE CRACKED AT BS 540, STR 22L. REPAIRED ANGLE IAW SRM.SDR SWAA2013042615296Floorbeam · corrodedFLOORBEAM CORRODED AT BS 328, LBL 52. REPAIRED CHORD IAW SRM.SDR SWAA2013042615295Strap · crackedSTRAP CRACKED BETWEEN BS 306 TO BS 348.5, RBL 46. REMOVED AND REPLACED STRAP IAW SRM AND DRAWING.SDR SWAA2013042615294Strap · crackedSTRAP CRACKED BETWEEN BS 306 TO BS 348.5, LBL 33. REMOVED AND REPLACED STRAP IAW SRM AND DRAWING.SDR SWAA2013042615293Strap · crackedSTRAP CRACKED BETWEEN BS 306 TO BS 348.5, LBL 10. REMOVED AND REPLACED STRAP IAW SRM AND DRAWING.SDR SWAA2013042615292Strap · crackedSTRAP CRACKED BETWEEN BS 306 TO BS 348.5, BL 0. REMOVED AND REPLACED STRAP IAW SRM AND DRAWING.SDR SWAA2013042615291Strap · crackedSTRAP CRACKED BETWEEN BS 306 TO BS 348.5, LBL 45.5. REMOVED AND REPLACED STRAP IAW SRM AND DRAWING.SDR SWAA2013042615282Nut Plate · brokenL1 DOOR EMERGENCY EVAC SLIDE SUPPORT NUT PLATE BROKEN. REMOVED AND REPLACED NUT PLATE IAW SRM.SDR SWAA2013042415174Tie Clip · crackedTIE CLIP CRACKED AT BS 500D, STR 26L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DRAWING.SDR SWAA2013040914614Skin · crackedFUSELAGE SKIN CRACKED AT STA 500B +9, ABOVE STR 10R. REPAIRED SKIN PER EA.SDR SWAA2013040914613Skin · crackedFUSELAGE SKIN CRACKED AT BS 500C+14, STR 10L. REPAIRED SKIN PER EA.SDR SWAA2013040814542Lens · missingLEFT OVERWING EMERGENCY EXIT SIGN COVER MISSING. INSTALLED LENS PER MM.SDR SWAA2013052016237Skin · crackedSKIN CUTOUT CRACKED AT BS 328, STR 17R. REPAIRED SKIN IAW SRM.SDR SWAA2013050715798Frame · corrodedFRAME CORRODED AT BS 947.5, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED FRAME PER SRM AND DWG.SDR SWAA2013050715789Web · crackedWEB CRACKED AT BS 712, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013050715788Stiffener · crackedSTIFFENER CRACKED AT BS 727, STR 27R. REMOVED AND REPLACED STIFFENER IAW SRM AND DWG.SDR SWAA2013050715756Crease Beam · crackedCREASE BEAM CRACKED AT BS 520, LBL 63.5. REPAIRED CHORD IAW EA.SDR SWAA2013050715716Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2013050715715Frame · corrodedFRAME CORRODED AT BS 500, BETWEEN STR 28L AND STR 28R. REPAIRED FRAME IAW SRM.SDR SWAA2013050715714Channel · crackedCHANNEL CRACKED BETWEEN BS 500 TO BS 500A, STR 26R. REMOVED AND REPLACED ZEE ANGLE IAW SRM AND DWG.SDR SWAA2013050715713Channel · crackedCHANNEL CRACKED BETWEEN BS 420 TO BS 440, STR 26R. REMOVED AND REPLACED CHANNEL IAW SRM AND DWG.SDR SWAA2013050715712Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 727E, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2013050715711Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 727, RBL 3. REMOVED AND REPLACED ANGLE IAW SRM.
Back to Boeing 737-3H4