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 SWAA2013012311717Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 500B, STR 26L CARGO COMP. R & R ANGLE IAW SRM & DWG.SDR SWAA2013012111625Structure · damagedNR 6 SLAT INBD SLAT CAN DAMAGED DUE TO CONTACT WITH SLAT TRACK/STOP. R & R NR 6 SLAT CAN IAW SRM AND DWG.SDR SWAA2013012111624Structure · damagedTRANSFERRED FROM NRC C797469 " NR 1 SLAT INBOARD SLAT CAN DAMAGED FROM CONTACT WITH SLAT TRACK/STOP". REMOVED & REPLACED NR 1 SLAT I/B CAN AND PERFORMED SATISFACTORY FUEL LEAK CHECK IAW SRM 51-40-02-01-0G-0 AND BAC DWG 65-45320 AND MM 28-11-00-658-148.SDR SWAA2013012111617Skin · crackedFUSELAGE SKIN CRACKED 7.00" AT VHF-3 ANTENNA ATTACH POINT, STA 727D+7.00" BETWEEN STR 27L AND 27R. COMPLIED WITH EA 1-353-21485.SDR SWAA2013012111586Support Angle · crackedRT WING T/E SUPPORT ANGLE CRACKED AT RSS 520 AND RSS 537. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013021112495Frame · corrodedFRAME CORRODED AT BS 500 AND LEVEL STR 26R CARGO DOOR CUT OUT. REPAIRED FRAME IAW EA.SDR SWAA2013020412272Web · crackedCRACK ON WEB LOCATED ON BS 500A STR 26R FLOOR STRUCTURE OF FWD CARGO COMP. REPLACED WEB LOCATED ON BS 500A STR 26R TO BS 500B FLOOR STRUCTURE OF FWD CARGO COMPARTMENT IAW SRM B737-30 51-10-02, 51-40-02 AND DRAWING 69-41473.SDR SWAA2013020412259Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STR 20L AND 21L. REPAIRED FRAME IAW SRM.SDR SWAA2013020112193Frame · crackedFRAME CRACKED AT BS 500D, BETWEEN STR 20R AND STR 21R. REPAIRED FRAME IAW SRM.SDR SWAA2013013012114Angle · crackedANGLE CRACKED AT BS 344, BETWEEN STR 8L AND 9L. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013012912052Doubler · crackedCRACK ON INTERNAL DOUBLE BETWEEN BS 360 TO 380+6 AND BETWEEN STR 27L TO STR 28R. REPAIRED DOUBLER IAW SRM.SDR SWAA2013012912051Web · crackedWEB CRACKED BETWEEN BS 927 TO 947.5 AND BL 0 MAIN DECK FLOOR STRUCTURE. REPLACED WEB IAW SRM AND DWG.SDR SWAA2013012811937Spindle · flakingFLAKED THERMAL COATING ON CARRIAGE SPINDLE NR 8. R & R SPINDLE ASSY NR 8 IAW AMM.SDR SWAA2013012811936Spindle · crackedLT WING OTBD T/E FLAP OTBD SPINDLE CARRIAGE CRACKED. R & R SPINDLE ASSY IAW AMM.SDR SWAA2013012811927Tie · crackedTIE CRACKED BETWEEN BS 348.2 AND BS 355 AT LEVEL OF STR 16L FWD PAX CABIN. R & R TIE IAW SRM AND DWG.SDR SWAA2013012811926Stiffener · crackedSTIFFENER CRACKED AT BS 727 AND RBL 45.5 MAIN DECK FLOOR STRUCTURE. REPLACED STIFFENER IAW SRM AND DRAWING.SDR SWAA2013012511830Shear Tie · corrodedCORROSION ON SHEAR TIE ANGLE LOCATED ON BS 827 STR 27R AFT CARGO COMP. REPLACED SHEAR TIE ANGLE LOCATED ON BS 827 STR 27R AFT CARGO COMP IAW SRM B737-300 51-10-02 ITEM 8 SRM B737-300 51-40-02 AND DRAWING 65-46552.SDR SWAA2013012311729Plate · brokenBROKEN PLATE BETWEEN BS 787 AND 793.5 AND STR 22R AND STR 25R CARGO COMPARTMENT. R & R PLATE IAW SRM AND DWG.SDR SWAA2013012311725Shear Tie · corrodedCORROSION ON SHEAR TIE LOCATED AT FRAME BS 500 BETWEEN STR 28L TO STR 28R FWD CARGO COMPARTMENT. REPLACED SHEARTIE LOC AT FRAME BS 500 BETWEEN STR 28L TO STR 28R FWD CARGO COMPARTMENT IAW SRM B737-300 51-10-02 ITEM 8 51-40-02 AND DWG 65-465.SDR SWAA2013012311720Stringer Clip · crackedCRACK ON TIE CLIP LOCATED AT BS 927 AND S-19L AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOCATED AT BS 927 AND S-19L AFT CARGO COMPARTMENT IAW B737-300 SRM 51-10-02, ITEM 8 SRM 51-40-02 AND DRAWING NR 65-46559.SDR SWAA2013012311716Tie Clip · crackedCRACK ON TIE CLIP LOCATED BS 887 AND S-18R IN AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOCATED BS 887 AND S-18R IN AFT CARGO COMPARTMENT IAW B737-300 SRM 51-10-02 ITEM 8 DRAWING 65-46557 AND B737-300 SRM 51-40-02.SDR SWAA2013012111616Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BS 727A AND S-25L AFT CARGO COMPARTMENT. REPLACED ON TIE CLIP LOCATED AT BS 727A AND S-25L AFT CARGO COMPARTMENT IAW SRM B737-300 51-10-02 ITEM 8 51-40-02 AND DWG 65-46595.SDR SWAA2013012111615Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BS 787 AND S-23R AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOCATED AT BS 787 AND S-23R AFT CARGO COMPARTMENT IAW SRM B737-300 51-10-02 ITEM 8 51-40-02 AND DWG 65-46550.SDR SWAA2013011811551Angle · crackedRIGHT WING I/B NO-STEP PANEL I/B ANGLE IS CRACKED AT THE AFT END. REMOVED AND REPLACED RIGH WING NO STEP ANGLE PER SRM 51-40-02.SDR SWAA2013011811550Retainer · crackedLEFT WING T/E LOWER PANEL SEAL RETAINER CRACKED JUST O/B OF THE NR 1 PYLON. REMOVED AND REPLACED RETAINER IAW SOPM.SDR SWAA2013021112497Skin · crackedSKIN CRACKED AT BS 360, STR 1R. REPAIRED SKIN PER EA.SDR SWAA2013020112226Frame · crackedCRACK ON FRAME LOCATED BS 947.5 AND S-18L IN AFT CARGO COMPARTMENT. REPLACED SECTION OF FRAME LOCATED BS 947.5 BETWEEN STR 17L TO STR 24L IAW B737-300 SRM 51-10-02 PAR 8 51-40-02 AND DWG 365-46947SDR SWAA2013012811925Bracket · crackedBRACKET CRACKED AT BS 887, STR 20R. REPLACED BRACKETS IAW SRM AND DWG.SDR SWAA2013012811907Web · crackedCRACK ON WEB LOCATED BETWEEN BS 348.2 TO BS 351.20 AND S-16L FWD PAX CABIN. REPLACED WEB LOCATED BETWEEN BS 348.2 TO BS 351.20 AND S-16L FWD PAX CABIN IAW SRM B737-300 51-10-02- 0G-0 PAGE 8 PARAGRAPH 8 AND SRM 51-40-02 DRAWING 65-45800.SDR SWAA2013012511832Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED AT BS 380 AND BETWEEN STR 25L RO STR 26L FWD CARGO COMPARTMENT. REPLACED SUPPORT ANGLE AND FASTENERS LOCATED AT BS 380 AND BETWEEN STR 25L TO STR 26L FWD CC IAW B737-300 DWG 69-18388 SRM 51-40-02.SDR SWAA2013012111592Tie Clip · crackedTIE CLIP CRACKED AT BS 927, STR 20R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2013012111585Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BS 787 AND S-22R AFT CARGO COMP. REPLACED TIE CLIP LOCATED AT BS 787 AND S-22R AFT CARGO COMPARTMENT IAW B737-300 SM 51-10-02 ITEM 8 B737-300 SRM 51-40-02 AND DWG 65-46550 DWG 69-35352.SDR SWAA2013011611456Spindle · corrodedLEFT WING NR 7 FLAP SPINDLE HAS EVIDENCE OF BASE METAL CORROSION AT THE LOWER SURFACE OF THE SPINDLE PORTION OF THE ROOT. REMOVED AND REPLACED RIGHT OTBOARD MIDFLAP INBOARD (NR 7) CARRIAGE PER MT #327-51-08.SDR SWAA2013020412265Flap · delaminatedDELAMINATED O/B AFT FLAP AT LEVEL FLAP TRACK FAIRING NR 1 LEFT WING. REMOVED AND REPLACED AFT FLAP ON CARD.SDR SWAA2013012912050Skin · crackedNLG W/W AROUND FASTENER HEAD CRACKED AT WL 169.1+3" AND BS 259.5. REPAIRED SKIN IAW SRM.SDR SWAA2013012812012Skin · crackedNLG W/W AROUND FASTENER HEAD CRACKED AT BS 243.7+3.5" AND WL 169.1. REPAIRED SKIN IAW SRM.SDR SWAA2013012811924Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED AT BSTA 827 AT LEVEL S-25R AFT CARGO COMPARTMENT. REPLACED SUPPORT ANGLE LOCATED AT BSTA 827 AT LEVEL S-25R AFT ARGO COMPARTMENT IAW B737-300 SRM 51-10-02 DRAWING 65-47957 AND B737-300 SRM 51-40-02.SDR SWAA2013012811923Skin · crackedPERFORMED HFEC INSP ON THE LEFT SIDE OF THE NLG WHEEL WELL AROUND FASTENER HEAD. CRACK INDICATION FOUND IN BS 243.7+4.5 AND WL 169.1 CRACK LENGHT=0.2006". PERFORMED REPAIR ON LEFT SIDE OF THE NLG WHEEL WELL LOCATED BETWEEN BS 230 TO BS 259.5+4" AND BTW WSDR SWAA2013012811922Shear Web · corrodedCORROSION ON LOWER FACE OF SHEAR WEB LOCATED BETWEEN BSTA 767 TO BSTA 787 AT S-17R. REPLACED SHEAR WEB LOCATED BETWEEN BSTA 767 TO BSTA 787 AT S-17R IAW SRM B737-300 51-10-02-0G-0 PAGE 8 PARAGRAPH 8 AND SRM 51-40-02 AND DRAWING 65-55885.SDR SWAA2013012511817Tie Clip · crackedCRACK ON TIE CLIP LOCATED BSTA 986.5 AT S-27L AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOCATED BS 986.5 AT S-27L AFT CARGO COMPARTMENT IAW 737-300 SRM 51-10-02 PARAGRAPH 8, SRM 51-40-02 AND DRAWING 65-46564.SDR SWAA2013012511816Tie Clip · crackedCRACK ON TIE CLIP LOCATED BSTA 986.5 AT S-26L AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOCATED BS 986.5 AT S-26L AFT CARGO COMPARTMENT IAW 737-300 SRM 51-10-02 PARAGRAPH 8 SRM 51-40-02 AND DRAWING 65-46564.SDR SWAA2013012111614Frame · corrodedFRAME CORRODED AT BS 500C, BETWEEN STR 28R AND STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013012111591Tie Clip · crackedCRACK ON TIE CLIP LOCATED ON BSTA 727E AT S-26R AFT CARGO COMPARTMENT. REPLACED TIE CLIP AND FASTENERS ON BSTA 727E AT S-26R AFT CARGO COMPARTMENT IAW B737-300 SRM 51-10-02 ITEM 8 SRM 51-40-02 AND DRAWING 65C25230.SDR SWAA2013012111590Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 947.5+12, BETWEEN STR 25L TO STR 26L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013012111589Tie Clip · crackedCRACK ON TIE CLIP LOCATED ON BSTA 787 AT S-23L AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOC ON BS 787 AT S-23L AFT CARGO COMP IAW SRM B737-300 51-40-02, 51-10-02 ITEM 8 AND DWG TIE CLIP.SDR SWAA2013011811552Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STR 26R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2013011611462Skin · crackedA .5 INCH SUBSURFACE CRACK ABOVE S5R 1006-5. REPAIRED PER E/A 1-353-21462 FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2013011611461Stringer Clip · crackedAFT CARGO COMPARTMENT STATION 947 STRINGER CLIP AT S25R IS CRACKED. REMOVED AND INSTALLED S-25R CLIP AT BS 947 IAW SRM 51-40-02 AND BOEING DWG 65-46560.SDR SWAA2013021112486Skin · crackedSKIN CRACKED AT BS 430+5, STR 1. REPAIRED SKIN IAW EO.SDR SWAA2013020712351Stringer · corrodedCORROSION ON STRINGER 26R BETWEEN BS 847 TO BS 870 AFT CARGO COMPARTMENT. REPAIRED STRINGER 26R BETWEEN BS 827 AND BS 907 IAW B737-300 SRM 53-00-03 REPAIR 1 DETAIL VII
Back to Boeing 737-3H4