Boeing 737-4Q8
Service difficulty reports · 6,250
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 = '7374Q8' 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 = '7374Q8' 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 ASAA0946194Window · crackedF/O R2 WINDOW ARCING WITH LITE SMOKE. TURNED OFF WINDOW HT AND R2 WINDOW OUTER PANE CRACKED. REMOVED R2 WINDOW REF MM 56 12 11. TASK CARD 48156001 COMPLETED. INSTALLED R2 WINDOW REF MM 56 12 11 404 007, OPS NORMAL.SDR ASAA0946007Hinge · stiffR1 DOOR SLIDE DEPLOYED SIDEWAYS DURING TEST. FOUND HINGES ON R1 DOOR ESCAPE SLIDE COMPARTMENT BACKING PAN SHELF VERY STIFF TO MOVE BY HAND. REMOVED AND REPLACED ESCAPE SLIDE COMPARTMENT ASSY WITH NEW SLIDE PACK.SDR ASAA0945816Web · damagedAFT CARGO DOOR CUTOUT LOWER CLOSEOUT WEB SCRATCHED HAS ELONGATED HOLES. REMOVED AND REPLACED WEB.SDR ASAA0945815Frame · misrepairedFRAME AT STA 867 STR 8R HAS PREVIOUS REPAIR WITH DEVIATIONS. REMOVED EXISTING REPAIR, FABRICATED NEW REPAIR PARTS AND INSTALLED.SDR ASAA0945812Frame · misrepairedFRAME STA 907 STR 8L HAS PREVIOUS REPAIR WITH DEVIATIONS. REMOVED EXISTING REPAIR, FABRICATED NEW REPAIR PARTS AND INSTALLED.SDR ASAA0945813Channel · crackedACB FWD BULKHEAD WL 179 BS 727+3 LBL 46 54 CHANNEL ASSY IS BROKEN. REMOVED AND REPLACED CHANNEL.SDR ASAA0945805Mechanism · lack of lubeF/A CANNOT CLOSE L1 DOOR. LUBRICATED GUIDE PLATES LATCH CRANK BEARINGS DOOR COUNTER BALANCE GUIDE ARM UPPER AND LOWER HINGE POINTS REF 737 MM 12 25 21 643 007. ACCOMPLISHED FWD ENTRY DOOR TEST PER 737 MM 52 11 00 755 051 TORQUE CHECK. DOOR OPENS AND CLOSES SDR ASAA0945789Mechanism · lack of lubeF/A CANNOT CLOSE L1 DOOR. LUBRICATED GUIDE PLATES LATCH CRANK BEARINGS DOOR COUNTER BALANCE GUIDE ARM UPPER AND LOWER HINGE POINTS REF 737 MM 12 25 21 643 007. ACCOMPLISHED FWD ENTRY DOOR TEST PER 737 MM 52 11 00 755 051 TORQUE CHECK. DOOR OPENS AND CLOSES SDR ASAA0945775Intercostal · corrodedFOUND INTERCOSTAL STA 747-767 RBL 22, WL 154 CORRODED AT UPPER AND LOWER FLANGES. REMOVED AND INSTALLED NEW INTERCOSTAL.SDR ASAA0945729Web · damagedVERTICAL WEB HAS OVERSIZE FASTENER HOLE AFT CARGO BAY. REMOVED AND INSTALLED NEW VERTICAL WEB.SDR ASAA0945730Stringer Clip · damagedELONGATED HOLE IN STRINGER CLIP. REMOVED AND REPLACED STRINGER CLIP.SDR ASAA0945732Angle · crackedRT WING NR 2 PYLON SUPPORT ANGLE IS CRACKED AT UPPER INBD SIDE OF AFT FRAME. REMOVED AND REPLACED.SDR ASAA0945731Frame · dentedFRAME DENTED ON INBD CROWN FLANGE. REMOVED DENT FROM FRAME FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0945803Hinge · lack of lubeF/A REPORTS MAIN CABIN ENTRY DOOR MAKES GROANING NOISE AND IS DIFFICULT FOR F/A TO OPEN AND CLOSE, CAPT CONCURS. LUBED DOOR HINGES, CHECKED DOOR OPS NORMAL REF MM 52 11 00 705 0650.SDR ASAA0945719Stringer Clip · damagedELONGATED HOLE IN STR CLIP STA 400 STR 8R. REMOVED AND REPLACED STR CLIP WITH NEW.SDR ASAA0945715Support · corrodedAFT CARGO DOOR CUTOUT FLOOR TO SIDEWALL SUPPORT PLATE IS CORRODED BEYOND LIMITS. REMOVED AND REPLACED SIDEWALL SUPPORT PLATE.SDR ASAA0945720Web · puncturedPUNCTURE IN WEB AT BS 1025 LBL 1 WL 208. REMOVED AND REPLACED PUNCTURED WEB PER SRM.SDR ASAA0945714Support Angle · crackedNR 2 SUPPORT ANGLE CRACKED REMOVED AND REPLACED NR 2 SUPPORT ANGLE.SDR ASAA0945699Web · corrodedRT SHEAR WEB CORRODED. REPLACED ON MIG 5.SDR ASAA0945698Intercostal · damagedINTERCOSTAL BS 927 947 BL 0 IS DAMAGED. REMOVED AND REPLACED INTERCOSTAL WITH FABRICATED PART.SDR ASAA0945685Bracket · scratchedFWD CARGO BAY OXYGEN BOTTLE SUPPORT BRACKET SCRATCHED. REMOVED FABRICATED NEW AND REPLACED.SDR ASAA0945687Bracket · damagedFWD CARGO BAY DRILL MARKS AT SCREW HOLES BRACKET. REMOVED AND REPLACED.SDR ASAA0945686Bracket · gougedFWD CARGO BAY GOUGES AT SCREW HOLE BRACKET. REMOVED AND REPLACED.SDR ASAA0945682Structure · damagedFWD CARGO BAY DRILL MARKS AT SCREW HOLES. REMOVED AND REPLACED.SDR ASAA0945684Skin · dentedFORK LIFT LOADER CONTACTED LOWER MAIN CARGO OPENING DENTED. REPAIRED LOWER MAIN CARGO DOOR OPENING.SDR ASAA0945683Skin · dentedMAIN CARGO DOOR SKIN LOWER LIP DAMAGED DENTED. REPAIRED MAIN CARGO DOOR.SDR ASAA0945681Shroud · crackedAPU SHROUD UPPER LT EDGE HAS AREAS BENT AND CRACKED. REPAIRED APU LOWER SHROUD UPPER LT EDGE.SDR ASAA0945680Frame · gougedNR 2 PYLON TE FAIRING UPPER FWD ACCESS PANEL AFT ATTACHMENT AFT APERTURE FRAME GOUGED REMOVED AND REPLACED NR 2 PYLON AFT APERTURE FRAME.SDR ASAA0945678Frame · crackedFRAME AT 727D STR 8R CRACKED AT FASTENER HOLE. REPAIRED FRAME.SDR ASAA0945677Skin · chafedLT WING NR 3 SLAT T/E LOWER SURFACE PREVIOUS REPAIR HAS CHAFING DAMAGE 56 INCHES FROM IB END. REPAIRED CHAFING DAMAGE 56 INCHES FROM IB END ON NR 3 SLAT LWR SURFACE T/E IAW SRM 57 43 02.SDR ASAA0945676Skin · chafedLT WING NR 3 SLAT T/E LWR SURFACE HAS CHAFING DAMAGE AT OB END. REPAIRED CHAFING DAMAGE ON NR 3 SLAT T/E AT OB END IAW SRM 51 10 02.SDR ASAA0945675Doubler · chafedLT WING NR 3 SLAT T/E LWR SURFACE PREVIOUS DOUBLER HAS CHAFING DAMAGE AT IB END. REPAIRED CHAFING DAMAGE AT IB END ON 33 SLAT T/E LWR SURFACE IAW SRM 51 10 02.SDR ASAA0945647Frame · misrepairedFRAME AT 727D STR 8L HAS PREVIOUS REPAIR WITH DEVIATIONS. REMOVED EXISTING REPAIR, FABRICATED NEW REPAIR PARTS AND INSTALLED.SDR ASAA0945646Frame · misrepairedFRAME BS 727F STR 8R PREVIOUS REPAIR HAS DEVIATION. REMOVED PREVIOUS REPAIR PARTS AND INSTALLED.SDR ASAA0945644Skin · damagedSKIN DIMPLED BS 500 BETWEEN STR 24-27L. REPAIRED PER EA 400-53EA-01485.SDR ASAA0945643Web · corrodedFOUND SUB THRESHOLD WEB IB VERTICAL SUPPORT WEB ASSY CORRODED AT FWD END STA 795 RBL 20 WL 158. REMOVED AND REPLACED THRESHOLD WEB PER SRM.SDR ASAA0945642Frame · crackedFRAME CRACKED AT INBD FASTENER HOLE STA 400 BETWEEN STR 8R AND 9R. REPAIRED PER SRM.SDR ASAA0945641Housing · corrodedFWD GALLEY DOOR HANDLE MECHANISM HOUSING CORRODED. REMOVED AND REPLACED HOUSING.SDR ASAA0945640Support Angle · crackedSUPPORT ANGLE CRACKED BS 520 WL 200 LBL 25 REMOVED AND REPLACED SUPPORT.SDR ASAA0945639Sill · corrodedCORROSION ON L2 DOOR CUTOUT MOPSILL. REMOVED AND REPLACED MOPSILL.SDR ASAA0945611Frame · misrepairedPREVIOUS REPAIR ON FRAME WITH DEVIATIONS IAW EA 5310-02439. REMOVED PREVIOUS REPAIR, FABRICATED NEW REPAIR PARTS AND INSTALLED.SDR ASAA0945610Frame · crackedFRAME STA 747, STR 8L CRACK NOTED AT IB FASTENER HOLE REQUIRES REPAIR IAW EA NR 400-53EA-01028. REPAIRED.SDR ASAA0945609Frame · crackedFRAME CRACKED AT AIR CONDITIONING BRACKET. REMOVED DAMAGE FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0945608Frame · crackedFRAME CRACKED AT IB FASTENER HOLE FOR AIR CONDITIONING BRACKET. REMOVED DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0945607Frame · crackedFOUND STA 500 FRAME CRACKED AT NUTPLATE HOLES WL 156 RBL 24.5. REMOVED DAMAGE FROME FRAME FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0945601Skin · crackedLT TAB HAS CRACK AT NR 1 HINGE CUTOUT ON LOWER SURFACE AT FWD EDGE. REPAIRED LT TAB.SDR ASAA0945600Skin Panel · chafedPANEL 9504R HAS INNER SURFACE CHAFING DAMAGE. REPAIRED PANEL 9504R INNER SURFACE.SDR ASAA0945880Stiffener · corrodedCORROSION AFT PRESSURE CHANNEL STIFFENER LT SIDE. REPAIRED AFT PRESSURE BULKHEAD CHANNEL STIFFENER LT SIDE PER EA400 53EA 01476.SDR ASAA0945602Splice Plate · damagedAFT CARGO COMPARTMENT FLOOR SUPPORT SPLICE PLATE HAS DRILL STARTS. REMOVED SUPPORT SPLICE FABRICATED NEW SPLICE AND INSTALLED.SDR ASAA0945606Frame · crackedFRAME AT BS 827, STR 8R CRACKED. REPAIRED FRAME AT BS 827 STR 8R.
Back to Boeing 737-4Q8