Boeing 737-5H4
Service difficulty reports · 8,230
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 = '7375H4' 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 = '7375H4' 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 SWAA2013040114330Mount Fitting · corrodedL1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR MOUNT CORRODED AT BS 313, LBL 55. REMOVED AND REPLACED FITTINGS PER SOPM.SDR SWAA2013041814982Floorbeam · corrodedFLOORBEAM UPPER CHORD CORRODED AT BS 986, BETWEEN BL 0 TO LBL 47. REPAIRED FLOORBEAM PER ER AND EA.SDR SWAA2013041214778Plate · corrodedFLOOR PANEL 2465ZA GIRT BAR SUPPORT PLATE CORRODED. REMOVED AND REPLACED SUPPORT PLATE ASSY IAW SRM.SDR SWAA2013041214777Seat Track · corrodedSEAT TRACK CORRODED BETWEEN BS 986 TO BS 1016, RBL 18. REMOVED AND REPLACED SEAT TRACK PER SRM.SDR SWAA2013041014672Sill · corrodedAFT SERVICE DOOR MOPSILL CORRODED AT BS 976, RBL 48. REMOVED AND REPLACED MOPSILL PER SRM & DWG.SDR SWAA2013041915025Pressure Panel · crackedPRESSURE WEB ABOVE MAIN WHEEL WELL CRACKED AT BS 665, LBL 39. REMOVED AND REPLACED WEB IAW ER AND EA.SDR SWAA2013041814981Pressure Panel · crackedPRESSURE WEB ABOVE MAIN WHEEL WELL CRACKED AT BS 665, RBL 33. REPAIRED WEB PER ER AND EA.SDR SWAA2013041814980Attach Angle · corrodedMAIN WHEEL WELL WEB ATTACH ANGLE CORRODED AT BS 688, RBL 64. REPAIRED ANGLE PER ER AND EA.SDR SWAA2013041614872Web · corrodedMAIN W/W WEB CORRODED AT BS 697, LBL 63. REMOVED AND REPLACED WEB PER SRM.SDR SWAA2013041214776Intercostal · crackedINTERCOSTAL CRACKED AT BS 304, STR 4L. REMOVED AND REPLACED INTERCOSTAL IAW SRM.SDR SWAA2013041214775Strap · crackedSTRAP CRACKED AT BS 304, STR 4L. REMOVED AND REPLACED STRAP IAW SRM.SDR SWAA2013041114747Intercostal · corrodedINTERCOSTAL CORRODED AT BS 716, LBL 62. REPAIRED INTERCOSTAL PER SRM.SDR SWAA2013040914609Angle · crackedRIGHT WING "L" ANGLE CRACKED I/B NR 6 FLAP TRACK FAIRING. REMOVED AND REPLACED L-ANGLE PER SRM.SDR SWAA2013040914604Doubler · crackedINTERNAL DOUBLER CRACKED I/B NR 6 FLAP TRACK FAIRING. REMOVED AND REPLACED DOUBLER PER SRM.SDR SWAA2013040114310Fairing · crackedNR 6 FLAP TRACK FAIRING FWD UPPER CORNER CRACKED. REPAIRED FAIRING PER EA.SDR SWAA2013042415098Frame · crackedFRAME OUTBOARD CHORD FWD FLANGE CRACKED AT BS 727, STR 18A LEFT. REPAIRED FRAME PER ER AND EA.SDR SWAA2013041814979Link · looseLEFT WING NR 4 AFT FLAP TRACK AFT MAIN SUPPORT LINK BEARINGS LOOSE. REMOVED AND REPLACED LINK IAW SOPM AND MM.SDR SWAA2013041714936Skin · crackedSKIN CRACKED BETWEEN BS 436.5 TO BS 437, STR 2R. REPAIRED SKIN PER ER AND EA.SDR SWAA2013041214774Doubler · crackedINTERNAL DOUBLER CRACKED AT LOWER AFT CORNER OF EXTERNAL POWER DOOR CUTOUT. REPAIRED DOUBLER PER EA.SDR SWAA2013041214773Doubler · crackedINTERNAL DOUBLER CRACKED UNDER LOWER HINGE OF EXTERNAL POWER DOOR AT CUTOUT. REPAIRED DOUBLER PER EA.SDR SWAA2013040114329Longeron · crackedLEFT WING NR 1 PYLON INBD FLAP TORQUE TUBE CUTOUT LOWER LONGERON CRACKED. REMOVED AND REPLACED LONGERON PER SRM.SDR SWAA2013040114309Fairing · crackedLEFT WING NR 1 PYLON INBD SKIRT FAIRING HAS A SUSPECTED CRACK IN THE FWD UPPER CORNER. REPAIRED FAIRING PER EA.SDR SWAA2013032814208Bracket · corrodedR2 DOOR EMERGENCY EVAC SLIDE BRACKETS CORRODED. REMOVED AND REPLACED BRACKETS IAW AMM.SDR SWAA2013041814978Shear Tie · corrodedSHEAR TIE CORRODED AT BS 827, BETWEEN STR 27LEFT TO STR 27R. REPAIRED SHEAR TIE PER ER AND EA.SDR SWAA2013041614871Shear Tie · corrodedSHEAR TIE CORRODED AT BS 887, BETWEEN STR 27L AND STR 27R. REPAIRED SHEAR TIE PER ER AND EA.SDR SWAA2013041014669Shear Tie · corrodedSHEAR TIE CORRODED AT BS 727C, BETWEEN STR 25L AND STR 26L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2013040914591Strap · corrodedSTRAP CORRODED BETWEEN BS 827 TO BS 847, RBL 19. REMOVED AND REPLACED STRAP IAW SRM.SDR SWAA2013040914556Shear Tie · corrodedSHEAR TIE CORRODED AT BS 867, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWAA2013032514072Hook · looseR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOKS LOOSE. SECURED HOOKS PER M/M.SDR SWAA2013042415097Web · crackedRIGHT NOSE WHEEL WELL WEB CRACKED AT BS 247, RBL 15.5. REPAIRED WEB PER ER & EA.SDR SWAA2013041714919Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 371 TO BS 372, STR 15R. REPAIRED SKIN PER ER AND EA.SDR SWAA2013032514071Hook · out of adjustR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOKS OUT OF ADJUST. ADJUSTED HOOKS PER MM.SDR SWAA2013032214006Lens · missingRIGHT OVERWING EMERGENCY EXIT LENS MISSING. INSTALLED REPLACEMENT LENS IAW M/M.SDR SWAA2013032614178Strap · crackedSTRAP CRACKED AT BS 452, BETWEEN STR 16R TO STR 28R. REMOVED AND REPLACED STRAP IAW SRM AND DWG.SDR SWAA2013032614177Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED SPLICE IAW EA.SDR SWAA2013031913799Skin · crackedSKIN CRACKED AT BS 812, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA2013031913837Tie Clip · crackedTIE CLIP CRACKED AT BS 747, STR 19L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2013031913798Stringer · crackedSTRINGER CRACKED AT BS 816, 18L. REPAIRED STRINGER IAW SRM AND EA.SDR SWAA2013032614169Strap · crackedSTRAP CRACKED AT BS 452, BETWEEN STR 17R TO STR 24R. REMOVED AND REPLACED STRAP IAW SRM.SDR SWAA2013032614153Angle · crackedACCESS PANEL 5758L ANGLE CRACKED. REMOVED AND REPLACED ANGLE IAW SRM.SDR SWAA2013031913827Skin · crackedFUSELAGE SKIN CUTOUT CRACKED AT BS 797, STR 24R. REPAIRED SKIN IAW SRM AND EA.SDR SWAA2013031413671Support Angle · crackedLEFT WING FLAP FAIRING SUPPORT ANGLE CRACKED. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013031213563Sign · looseEXIT SIGN LOOSE AT FWD GALLEY. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA2013040314423Reveal · crackedR1 DOOR LOWER REVEAL CRACKED AT BS 294.5, STR 17R. REMOVED AND REPLACED REVEAL IAW SRM AND DRAWING.SDR SWAA2013032113946Skin · crackedSKIN CRACKED AT BS 360, BETWEEN STR 2R AND STR 3R. REPAIRED SKIN IAW EA.SDR SWAA2013032113945Skin · crackedSKIN CRACKED AT BS 360, BETWEEN STR 1R AND STR 2R. REPAIRED SKIN IAW EA.SDR SWAA2013032113944Skin · crackedSKIN CRACKED AT BS 360, BETWEEN STR 1L AND STR 2L. REPAIRED SKIN IAW EA.SDR SWAA2013031313600Web · crackedAFT CARGO WEB CRACKED AT STA 792 RIGHT SIDE. REMOVED AND REPLACED WEB PER SRM.SDR SWAA2013031413652Keelbeam · corrodedRIGHT KEEL BEAM FWD SECTION CHORD AT STA 482A + 10", STR 27R CORRODED. REMOVED AND REPLACED BEAM PER EA.SDR SWAA2013032514027Bracket · crackedBRACKET CRACKED AT BS 907, BETWEEN STR 1 TO STR 2R. REMOVED AND REPLACED BRACKET IAW SRM AND DRAWING #.
Back to Boeing 737-5H4