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 SWAA2012101708586Rib · crackedLEFT HORIZONTAL STABILIZER RIB LOWER CHORD CRACKED AT STA 120.30. REMOVED AND REPLACED CHORD IAW SRM AND DWG.SDR SWAA2012101508523Angle · crackedANGLE CRACKED AT BS 303.9+5, STR 8L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012101208483Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 303.9+6, STR 15L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012100908335Slat · chafedNR 4 SLAT AFT UPPER INBOARD END CHAFED THROUGH PREVIOUS REPAIR. REPAIRED SLAT PER SRM.SDR SWAA2012100808313Flap · delaminatedRIGHT WING OUTBOARD AFT FLAP DELAMINATED ON TRAILING EDGE. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA2012100408278Lens · brokenR1 DOOR FLOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS ASSY PER MM.SDR SWAA2012100408271Lens · brokenL1 DOOR EMERGENCY EXIT LENS BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA2012100408270Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA2012102408801Web · crackedVERTICAL STABILIZER WEB CRACKED AT STA 13.33. REMOVED AND REPLACED WEB PER SRM AND DWG.SDR SWAA2012101908685Web · crackedNLG WHEEL WELL WEB CRACKED AT BS 243.7+3.5, RBL 16.0. REPAIRED WEB IAW EA.SDR SWAA2012101708591Frame · corrodedFRAME CORRODED AT BS 360, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA2012101508522Fitting · crackedCLIP CRACKED AT BS 348.9, STR 16L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012101208481Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 360, STR 27L. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.SDR SWAA2012101108432Angle · crackedANGLE CRACKED AT BS 348.2, STR 16L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012100408279Sign · brokenR2 DOOR EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED SIGN PER AMM.SDR SWAA2012100308237Light · inoperativeRIGHT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA2012100308225Charger · inoperativeAFT EMERGENCY LIGHTS INOP BETWEEN ROWS 21 TO ROW 23. REMOVED AND REPLACED BATTERY PACK CHARGER ASSY IAW MM.SDR SWAA2012102308709Skin · crackedFUSELAGE SKIN CRACKED AT AFT GALLEY DOOR CUTOUT FORWARD LOWER CORNER. REPAIRED SKIN IAW EO AND EA.SDR SWAA2012101808643Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STR 25R. REMOVED AND REPLACED CLIP IAW EO AND EA.SDR SWAA2012101608562Bulkhead · crackedBULKHEAD WEB CRACKED AT BS 1016, BETWEEN STR 7L TO STR 21R. REPAIRED WEB IAW SRM.SDR SWAA2012101508540Bulkhead · crackedAFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, STR 15R. REPAIRED WEB IAW SRM.SDR SWAA2012101208480Skin · crackedLEFT WING NR 2 SLAT SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2012100908349Pressure Panel · crackedMAIN WHEEL WELL CEILING BEADED WEB CRACKED STATION 673, LBL 32. REPAIRED WEB PER SRM.SDR SWAA2012100808328Skin · delaminatedNR 2 SLAT DELAMINATED O/B END UPPER SURFACE. REMOVED AND REPLACED SLAT ASSY PER MM.SDR SWAA2012100108206Sign · crackedL1 DOOR EMERGENCY EXIT SIGN CRACKED. REMOVED AND REPLACED SIGN PER M/M.SDR SWAA2012102308773Floorbeam · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708, LBL 24.8. REPAIRED WEB IAW EO AND EA.SDR SWAA2012102308754Web · crackedWEB CRACKED BETWEEN BS 705 TO BS 710, RBL 24.5. REPAIRED WEB IAW EA AND EO.SDR SWAA2012102308753Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 645 TO BS 685, RBL 24.5. REPAIRED CHORD IAW EA AND EO.SDR SWAA2012102308713Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 665 TO BS 670, LBL 24.5. REPAIRED CHORD IAW EA AND EO.SDR SWAA2012101808651Stiffener · crackedRIGHT WHEEL WELL STIFFENER CRACKED AT BS 663, RBL 6.15 WHEEL WELL AREA. REPAIRED STIFFENER IAW EA.SDR SWAA2012101708590Skin · crackedRIGHT WING FORE FLAP INBOARD LOWER SKIN CRACKED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2012101508543Spoiler · delaminatedRIGHT WING NR 9 SPOILER DELAMINATED. REMOVED AND REPLACED SPOILER IAW MM.SDR SWAA2012101508539Frame · corrodedFRAME CORRODED AT BS 867, BETWEEN STR 26R AND STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012101108424Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 25L AND STR 26L. REPAIRED FRAME IAW SRM.SDR SWAA2012101008409Channel · corrodedCHANNEL CORRODED AT BS 747, RBL 3.0. REPAIRED CHANNEL IAW EA.SDR SWAA2012100408269Strap · crackedSTRAP CRACKED AT BS 727B, RBL 24.5. REMOVED AND REPLACED STRAP IAW SRM AND DWG.SDR SWAA2012100108211Skin · crackedFUSELAGE SKIN CRACKED AT BS 727D + 6, STR 4L. REPAIRED SKIN PER EA.SDR SWAA2012100108210Lens · missingFORWARD EMERGENCY EXIT SIGN MISSING. INSTALLED LENS PER M/M.SDR SWAA2012100108205Cover · missingR2 DOOR EMERGENCY EXIT LIGHT COVER MISSING. REMOVED AND REPLACED COVER PER MM.SDR SWAA2012100108204Wedge · delaminatedRIGHT WING NR 5 SLAT TRAILING EDGE WEDGE DELAMINATED. REMOVED & REPLACED NR 5 SLAT IAW AMM.SDR SWAA2012100108203Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA2012101908681Skin · crackedSKIN CRACKED AT BS 360+18, BETWEEN STR 28L TO STR 28R. REPAIRED SKIN IAW EO AND EA.SDR SWAA2012101108423Web · crackedWEB CRACKED BETWEEN BS 344 TO BS 360, BBL 0. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012100408275Strap · crackedSTRAP CRACKED BETWEEN BS 307 TO BS 353, LBL 10. REMOVED AND REPLACED STRAP IAW SRM AND DWG.SDR SWAA2012100108224Clamp · looseDIVERSION/DECLARED EMERGENCY. CABIN ALTITUDE WARNING HORN SOUNDED AT CRUISE 37,000, CABIN ALTITUDE CLIMBED. FOUND KEEL BEAM BOOT CLAMP LOOSE AND REMOVED AND REPLACED BELLY DRAINS PER MM.SDR SWAA2012100108146Battery · dischargedR1 DOOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY IAW WDM & AMM.SDR SWAA2012100108145Light · inoperativeL1 DOOR EXTERNAL EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BULB IAW AMM.SDR SWAA2012102908910Frame · crackedFRAME CRACKED AT BS 787, RBL 13. REPAIRED FRAME IAW EA.SDR SWAA2012102508839Slat · delaminatedRIGHT WING NR 5 SLAT O/B END DELAMINATED. REPAIRED NR 5 SLAT IAW SRM.SDR SWAA2012101208479Skin · crackedL2 DOOR AFT UPPER CORNER OF CUTOUT CRACKED IN BEAR STRAP. REPAIRED SKIN IAW SRM.
Back to Boeing 737-3H4