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 SWAA2013031113531Stringer Splice · crackedSTRINGER SPLICE CRACKED AT STA 360 TO STA 367, STR 15L. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA2013030813458Floorbeam · corrodedUPPER CHORD OF FLOORBEAM AT BS 312, BETWEEN BL 0 AND RBL 28 CORRODED. REPAIRED FLOORBEAM PER SRM.SDR SWAA2013030613364Strap · crackedCRACK ON STRAP BETWEEN BS 303 TO BS 344+5, LBL 12.5. REMOVED AND REPLACED STRAP IAW SRM.SDR SWAA2013030613363Web · crackedCRACK ON WEB BETWEEN BS 328 TO BS 344, LBL 47. REMOVED AND REPLACED WEB IAW SRM.SDR SWAA2013030613362Angle · crackedCRACK ON ANGLE LOCATED ON AREA OF RIGHT HORIZONTAL STABILIZER ACCESS PANEL 9226R. REMOVED AND REPLACED ANGLE IAW DWG AND SRM.SDR SWAA2013030613361Rub Strip · crackedCRACK ON RUBSTRIP ON NACELLE STRUT ACCESS PANEL 57700L ENGINE NR 1. REMOVED AND REPLACED RUBSTRIP IAW SRM.SDR SWAA2013030613349Web · crackedCRACK ON WEB BETWEEN BS 344+8.5 TO BS 360, BL 0. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013030513331Tie Clip · crackedCRACK ON TIE CLIP LOCATED BS 380 AND STR 22L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2013030413286Skin · crackedCRACK AT STRINGER 1, BETWEEN BS 446 TO BS 447. REPAIRED SKIN IAW E/A.SDR SWAA2013030413285Skin · crackedCRACK AT STRINGER 1, BETWEEN BS 434 TO BS 437. REPAIRED SKIN IAW E/A.SDR SWAA2013030413284Skin · crackedCRACK AT STRINGER 1, BETWEEN BS 425 TO BS 426. REPAIRED SKIN IAW E/A.SDR SWAA2013030413283Ballast · inoperativeLEFT EMERGENCY OVERWING EXIT SIDEWALL LIGHT IS INOP. REMOVED AND REPLACED BALLAST PER MM.SDR SWAA2013030413235Skin · crackedCRACK AT STRINGER 1, BETWEEN STA 443 TO STA 445. REPAIRED SKIN IAW EA.SDR SWAA2013030413234Skin · crackedA 1.2 INCH CRACK LOCATED AT BS 500D+10 RIGHT SIDE OF STR 1. REPAIRED SKIN PER SRM.SDR SWAA2013030113215Panel · delaminatedKEEL BEAM CLOSURE PANEL BETWEEN A/C DOORS DELAMINATED ON AFT RIGHT END. REMOVED AND REPLACED PANEL PER SRM.SDR SWAA2013030113191Valve · faultyDIVERSION -- FWD CARGO FIRE LIGHT & WARNING CAME ON IN CRUISE. BOTTLE DISCHARGE LIGHT STEADY FOR 6 - 7 MIN THEN FLASHING AGAIN. REMOVED AND REPLACED DIVERTER VALVE AND METERING VALVE PER MM.SDR SWAA2013032113951Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STR 20R AND STR 21R. REPAIRED FRAME IAW SRM.SDR SWAA2013031913809Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STR 20R AND STR 21R. REPAIRED FRAME IAW SRM.SDR SWAA2013031313593Skin · crackedFUSELAGE SKIN CRACKED AT STA 360, STR 2R. REPAIRED SKIN PER SRM.SDR SWAA2013031313592Skin · crackedFUSELAGE SKIN CRACKED AT STA 947.5+ 14, STR 4L. REPAIRED SKIN PER SRM.SDR SWAA2013031313591Tie Clip · crackedTIE CLIP CRACKED AT STA 277, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013030813457Stringer Clip · crackedSTRINGER CLIP CRACKED AT STA 277, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013030813456Stringer Clip · crackedSTRINGER CLIP CRACKED AT STA 277, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013030413290Skin · debondedLEFT WING INBOARD FOREFLAP, UPPER SURFACE, 4"X 5" DISBONDED, 32" INBOARD OF OUTBOARD END. REMOVED & REPLACED FORE FLAP IAW MM.SDR SWAA2013030413240Skin · crackedA 1 INCH CRACK OUTER FUSELAGE SKIN LOWER HINGE DOORWAY CUTOUT AT FWD SERVICE DOOR LOCATION. REPAIRED SKIN PER EA.SDR SWAA2013022813167Holder · unsecureR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FELL OFF. SECURED HOLDER IAW MM.SDR SWAA2013040114263Stiffener · crackedLEFT WING FUEL TANK STRUCTURE STIFFENER CRACKED AT WBL 114.00+6. REPAIRED STIFFENER IAW SRM.SDR SWAA2013040114252Skin · crackedSKIN CRACKED AT BS 328, STR 17R. REPAIRED SKIN IAW SRM.SDR SWAA2013032113938Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STR 25R. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013031913786Tie Clip · crackedTIE CLIP CRACKED AT BS 400, STR 26L. REMOVED AND REPLACED CLIP IAW EA.SDR SWAA2013030813443Angle · crackedLEFT WING T/E ANGLE CRACKED AT RS STA 535. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013030413282Rub Strip · crackedCRACK ON RUBSTRIP LOCATED ON STRUT ACCESS PANEL 58720R ENGINE NR 2. REMOVED AND REPLACED RUBSTRIP IAW SRM AND DWG.SDR SWAA2013030413281Web · crackedCRACK ON WEB LOCATED BETWEEN BS 500 TO BS 500A AND STR 26L. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2013030413280Fitting · crackedCRACK ON CLIP LOCATED ON BS 380 AND STR 26L. REMOVED AND REPLACED CLIP IAW SRM & DWG.SDR SWAA2013022713126Hinge · crackedRIGHT WING NR 5 GROUND SPOILER O/B HINGE CRACKED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA2013022713149Stringer Clip · crackedSTRINGER CLIP AT STA 986, STR 2L IS CRACKED. REMOVED AND REPLACED CLIP IAW DWG & SRM.SDR SWAA2013022713148Stringer Clip · crackedSTRINGER CLIP AT STA 1006, STR 2.5R IS CRACKED. REMOVED AND REPLACED CLIP IAW BAC DWG & SRM.SDR SWAA2013022713147Stringer Clip · crackedSTRINGER CLIP AT STA 927, STR 2R IS CRACKED. REMOVED AND REPLACED CLIP IAW BAC DWG & SRM.SDR SWAA2013022613112Stringer Clip · crackedMAIN CABIN STRINGER CLIP STA 400 S-7R FOUND CRACKED. REMOVED AND REPLACED CLIP IAW SRM AND BAC DWG.SDR SWAA2013022613111Stringer Clip · crackedMAIN CABIN STRINGER CLIP STA 480 AT S-8L FOUND CRACKED. REMOVED AND REPLACED CLIP IAW SRM BAC DWG.SDR SWAA2013022613110Stringer Clip · crackedMAIN CABIN STRINGER CLIP STA 380 S-8L FOUND CRACKED. REMOVED AND REPLACED CLIP IAW SRM AND BAC DWG.SDR SWAA2013040114292Fitting · crackedLEFT WING TRAILING EDGE FITTING CRACKED AT WBL 84.64. REMOVED AND REPLACED FITTING IAW SRM AND DWG.SDR SWAA2013040114251Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 540, BETWEEN STR 28L TO STR 24L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013031913824Cable · frayedL2 DOOR EMERGENCY EVAC SLIDE CABLE FRAYED. REMOVED AND REPLACED CABLE IAW SRM.SDR SWAA2013031913823Cable · frayedR2 DOOR EMERGENCY EVAC SLIDE CABLE FRAYED. REMOVED AND REPLACED CABLE IAW AMM.SDR SWAA2013031913785Frame · corrodedFRAME CORRODED AT BS 500, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM.SDR SWAA2013031413643Gusset · crackedGUSSET CRACKED AT STA 887, BETWEEN STR 20R & STR 21R. REMOVED AND REPLACED GUSSET APR SRM.SDR SWAA2013031313579Angle · crackedCRACK ON ANGLE AT BS 807 BETWEEN STR 26R AND STR 25R AFT. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013031113542Strap · crackedSTRAP BETWEEN BS 312 AND BS 344, LBL 11.10 UPPER STRUCTURE E/E COMPARTMENT CRACKED. REMOVED AND REPLACED STRAP PER SRM.SDR SWAA2013031113541Support Angle · crackedSUPPORT ANGLE AT BS 328, RBL 37 UPPER STRUCTURE E/E COMPARTMENT CRACKED. REMOVED AND REPLACED SUPPORT ANGLE PER SRM.
Back to Boeing 737-3H4