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 SWAA2012070505555Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 380, STRINGER 22L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA2012070505554Angle · corrodedCORROSION ON ANGLE AT STA 360, STR 28L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2012062805384Lens · missingRIGHT AFT SIDE OF AFT BULKHEAD EMERGENCY EXIT SIGN LENS MISSING. INSTALLED LENS PER M/M.SDR SWAA2012062805371Cover · missingAFT CENTER EEPLS COVER MISSING. INSTALLED COVER IAW AMM.SDR SWAA2012062605332Light · inoperativeLEFT BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 10. REMOVED AND REPLACED LAMP IAW AMM.SDR SWAA2012071205774Rib · crackedRIGHT WING O/B FORE FLAP O/B HINGE RIB CRACKED AT WBL 355. REMOVED AND REPLACED RIB IAW SRM AND DWG.SDR SWAA2012071205765Tie Clip · crackedTIE CLIP CRACKED AT BS 400, STR 28L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012071205764Tie Clip · crackedTIE CLIP CRACKED AT BS 767, STR 16R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012062605300Skin · crackedSKIN CRACKED AT BS 727E+3, STR 2R. REPAIRED SKIN PER SRM.SDR SWAA2012062605288Cover · brokenL1 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. REMOVED AND REPLACED LIGHT ASSY PER AMM.SDR SWAA2012072306098Bulkhead · corrodedPRESSURE BULKHEAD SKIN CORRODED AT BS 1016, BETWEEN STR 26L TO STR 27R. REPAIRED SKIN IAW ACO AND DWG.SDR SWAA2012072306097Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STR 24R TO STR 25R. REPAIRED FRAME IAW EA.SDR SWAA2012072306096Angle · crackedANGLE CRACKED AT BS 787+3, BETWEEN STR 18R TO STR 19R. REMOVED AND REPLACED ANGLE PER SRM AND DWG.SDR SWAA2012072006026Angle · crackedRIGHT WING TRAILING EDGE ANGLE CRACKED AT RSS 533+12. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012072006025Stringer · corrodedSTRINGER CORRODED AT BS 952, STR 20R. REPAIRED STRINGER PER SRM.SDR SWAA2012072006024Threshold · corrodedL1 DOOR THRESHOLD WEB CORRODED BETWEEN BS 312 TO BS 344. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012072006021Support Bracket · crackedSUPPORT BRACKET CRACKED AT BS 947.5, BETWEEN STR 24L TO STR 25L. REMOVED AND REPLACED BRACKET IAW SRM AND DWG.SDR SWAA2012071905985Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 727+5, BETWEEN STR 25L TO STR 25R. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012070905648Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 727B, RBL 45.5. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012070905647Web · corrodedWEB CORRODED BETWEEN BS 727D TO BS 727E, STR 17L. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012070905646Web · crackedWEB CRACKED BETWEEN BS 727E TO BS 747, STR 17R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012070205487Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STR 25R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012070205486Tie Clip · crackedTIE CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012070205453Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STR 20R AND STR 21R. REPAIRED FRAME PER SRM.SDR SWAA2012062705350Vsi · malfunctionedSMELL OF ELECTRICAL SMOKE DETECTED BEHIND CAPTAIN'S INSTRUMENT PANEL. REMOVED AND REPLACED LEFT VERTICAL SPEED INDICATOR PER MM.SDR SWAA2012072306095Floorbeam · crackedFLOORBEAM CRACKED AT BS 947.5, LBL 53. REPAIRED BEAM IAW EA AND EO.SDR SWAA2012072306094Skin · crackedSKIN CRACKED AT BS 332, STR 17R. REPAIRED SKIN IAW EA.SDR SWAA2012072306093Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986.5, LBL 35 AND LBL 43. REPAIRED BEAM PER EA AND EO.SDR SWAA2012072306092Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986.5, BETWEEN RBL 20 TO RBL 43. REPAIRED BEAM PER EA.SDR SWAA2012072006023Support Bracket · crackedSUPPORT BRACKET CRACKED AT BS 947.5, BETWEEN STR 24R TO STR 25R. REMOVED AND REPLACED BRACKET IAW SRM AND DWG.SDR SWAA2012072006022Stiffener · crackedSTIFFENER CRACKED AT BS 727, STR 27R. REMOVED AND REPLACED STIFFENER IAW SRM AND DWG.SDR SWAA2012072006020Floorbeam · corrodedFLOOR STRUCTURE BEAM CORRODED AT BS 967, LBL 5. REPAIRED BEAM PER EA.SDR SWAA2012072006019Floorbeam · corrodedFLOOR STRUCTURE BEAM CORRODED AT BS 967, BETWEEN RBL 27 TO RBL 42. REPAIRED BEAM PER EA & DWG.SDR SWAA2012071805940Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012071805939Frame · corrodedFRAME CORRODED AT BS 747, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012071705907Frame · corrodedFRAME CORRODED AT BS 727D, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012071705906Frame · corrodedFRAME CORRODED AT BS 727D, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012071705905Web · crackedSUPPORT WEB CRACKED AT BS 727, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012071605864Web · corrodedWEB CORRODED BETWEEN BS 951 TO BS 986.5, RBL 50. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012070905645Stringer · corrodedSTRINGER CORRODED AT BS 910, STR 27L. REPAIRED STRINGER IAW SRM.SDR SWAA2012070905644Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012070505553Angle · crackedCRACK ON ANGLE BETWEEN STA 277 TO STA 291.5, STR 13R TO STR 14R PAX CABIN. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2012070505552Angle · crackedCRACK ON ANGLE BETWEEN STA 277 TO STA 291.5, STR 11R TO STR 12R PAX CABIN. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2012070505551Angle · crackedCRACK ON ANGLE BETWEEN STA 277 TO STA 291.5, STR 9R TO STR 10R PAX CABIN. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2012070505550Frame · crackedSTUB FRAME CRACKED AT STA 294.5, BETWEEN STR 7R & STR 8R. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA2012070205417Fitting · crackedCLIP CRACKED AT BS 706, STR 11R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012062505240Light · inoperativeRIGHT SIDE EMERGENCY EXIT LIGHT INOP AT ROW 3. RELAMPED LIGHT PER MM.SDR SWAA2012072306091Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 665 TO BS 674, LBL 24.5. REPAIRED CHORD IAW EA AND EO.SDR SWAA2012072006018Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 664.0 AND BS 670, RBL 24.5. REPAIRED CHORD PER EA.SDR SWAA2012072006017Floorbeam · crackedLONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 707 TO BS 712, RBL 24.5. REPAIRED WEB IAW EO AND EA.
Back to Boeing 737-3H4