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 SWAA2012102308708Tie · crackedSTRINGER TIE CRACKED AT BS 500B, STR 3R. REMOVED AND REPLACED TIE IAW SRM AND DWG.SDR SWAA2012102308707Tie · crackedSTRINGER TIE CRACKED AT BS 500B, STR 2R. REMOVED AND REPLACED TIE IAW DWG AND SRM.SDR SWAA2012102308706Tie · crackedSTRINGER TIE CRACKED AT BS 500C, STR 2R. REMOVED AND REPLACED TIE IAW SRM & DWG.SDR SWAA2012102308705Tie Clip · crackedSTRINGER TIE CLIP CRACKED AT BS 500C, STR 2L. REMOVED AND REPLACED TIE CLIP IAW DWG AMD SRM.SDR SWAA2012102308704Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA2012102308691Lens · missingEMERGENCY EXIT SIGN LENS MISSING AT ROW 2. INSTALLED LENS PER MM.SDR SWAA2012102308757Lens · missingFORWARD LEFT LAV EEPLS LENS MISSING. INSTALLED LENS IAW AMM.SDR SWAA2012101908661Sign · looseRIGHT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA2012102308759Pressure Panel · crackedLEFT MAIN WHEEL WELL CEILING BEADED WEB CRACKED AT BS 664, LBL 39. REPAIRED WEB PER EA.SDR SWAA2012102308698Skin · delaminatedRIGHT WING NR 7 SPOILER UPPER SURFACE DELAMINATED OUTBOARD CORNER. REMOVED AND REPLACED NR 7 FLIGHT SPOILER PER MM.SDR SWAA2012102308697Slat · delaminatedRIGHT WING NR 4 SLAT INBOARD TRAILING EDGE CORNER DELAMINATED. REMOVED AND REPLACED NR 4 SLAT PER AMM.SDR SWAA2012101908670Skin · crackedSKIN CRACKED AT BS 758, STR 10R. REPAIRED SKIN IAW EA.SDR SWAA2012101908668Sign · crackedL1 DOOR EMERGENCY LIGHT SIGN CRACKED. REMOVED AND REPLACED SIGN ASSY PER MM.SDR SWAA2012101808647Skin · crackedFUSELAGE SKIN CRACKED AT BS 727B+10, STR 10R. REPAIRED SKIN PER EA.SDR SWAA2013121623291Frame · damagedFRAME DAMAGED AT BS 380, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2012101808646Light · brokenRIGHT EEPLS BROKEN AT ROW 8. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA2012101808642Spoiler · delaminatedLEFT WING NR 1 SPOILER. REMOVED AND REPLACED NR 1 SPOILER PER AMM.SDR SWAA2012101808641Hook · looseL1 DOOR EMERGENCY EVAC SLIDE FORWARD GIRT BAR HOOK LOOSE ON FLOOR. SECURED HOOK PER MM.SDR SWAA2012101808640Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA2012101708587Lens · looseLEFT EMERGENCY EXIT ROW LIGHT LOOSE. SECURED LENS PER AMM.SDR SWAA2012102308756Lens · brokenRIGHT EMERGENCY LIGHT LENS BROKEN. REMOVED AND REPLACED LENS IAW AMM.SDR SWAA2012101808617Actuator · leakingRIGHT WING KRUEGER FLAPS 3 ACTUATOR LEAKED. REMOVED AND REPLACED NR 3 FLAP ACTUATOR PER AMM.SDR SWAA2012101808616Sign · brokenL1 DOOR EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED SIGN PER M/M.SDR SWAA2012101808611Actuator · leakingRIGHT WING KRUEGER FLAPS 4 ACTUATOR LEAKED. REMOVED AND REPLACED NR 4 FLAP ACTUATOR PER AMM.SDR SWAA2012101708596Flap · puncturedLEFT WING I/B FOREFLAP PUNCTURED. REMOVED AND REPLACED FOREFLAP PER AMM.SDR SWAA2012101708595Slat · delaminatedRIGHT WING NR 5 SLAT DELAMINATED ON O/B END. REMOVED AND REPLACED NR 5 SLAT PER AMM.SDR SWAA2012101508538Battery · dischargedFOWARD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER M/M.SDR SWAA2012101508489Hinge · brokenRIGHT WING I/B GROUND SPOILER O/B CENTER HINGE BROKEN. REMOVED AND REPLACED SPOILER PER AMM.SDR SWAA2012101508542Light · looseEEPLS LOOSE AT ROW 8. SECURED EEPLS PER M/M.SDR SWAA2012102308722Battery · dischargedFORWARD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER M/M.SDR SWAA2012101608559Cover · missingLEFT OVERWING EMERGENCY EXIT SIGN LIGHT COVER MISSING. REMOVED AND REPLACED SIGN ASSY PER MM.SDR SWAA2012101508524Sign · looseMID CABIN OVERHEAD EMERGENCY EXIT SIGN LOOSE. SECURED LIGHT ASSY PER M/M.SDR SWAA2012101208484Plate · brokenR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR LATCH BROKEN. SECURED FLOOR PLATE PER M/M.SDR SWAA2012102308742Tie Clip · crackedTIE CLIP AT BS 520, STR 2L. REMOVED AND REPLACED TIE CLIP IAW DWG AND SRM.SDR SWAA2012102308741Tie Clip · crackedTIE CLIP CRACKED AT BS 500A, STR 2L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012102308740Tie Clip · crackedTIE CLIP CRACKED AT BS 500A, STR 2R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012102308739Tie Clip · crackedTIE CLIP CRACKED AT BS 500A, STR 1. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012102308703Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 420, STR 28R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012102308702Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 420, STR 28L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012102308701Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400, STR 27L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012102308700Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400, STR 28L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012101608561Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500A, STR 11R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012101608558Pressure Panel · crackedMAIN WHEEL WELL CEILING BEADED WEB CRACKED AT BS 672, LBL 43. REPAIRED WEB PER EA.SDR SWAA2012101508537Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908, STR 4R. REMOVED AND REPLACED SPLICE IAW BAC DWG.SDR SWAA2012101608568Wedge · delaminatedRIGHT WING NR 5 LEADING EDGE SLAT UPPER TRAILING EDGE WEDGE DELAMINATED. REMOVED AND REPLACED WEDGE PER MT.SDR SWAA2012101608567Wedge · delaminatedRIGHT WING NR 6 LEADING EDGE SLAT UPPER TRAILING EDGE WEDGE DELAMINATED. REMOVED AND REPLACED WEDGE PER MT.SDR SWAA2012101508531Skin · crackedSKIN CRACKED AT BS 520+7, STR 10R. REPAIRED SKIN PER EA.SDR SWAA2012102308721Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN CRACKED BETWEEN STA 97 TO STA 99. REPAIRED SKIN IAW SRM.SDR SWAA2012101608563Frame · crackedFRAME CRACKED AT BS 268.62, BETWEEN STR 23R TO STR 26R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA2012101108421Carriage · corrodedLEFT WING NR 2 SPINDLE CARRIAGE ASSY CORRODED. REMOVED AND REPLACED NR 2 FLAP CARRIAGE ASSY IAW MT.
Back to Boeing 737-3H4