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 ASAA11410836Torque Link · bindingL2 DOOR BINDS WHILE OPENING AND CLOSING UPPER AND LOWER DOOR ARMS ARE DRAGGING ON CAM PLATES INT MIG2C 277488. FOUND L2 DOOR TORQUE TUBE WORN AND OUT OF LIMITS. RELACED DOOR TORQUE LOWER RADIUS LINK UPPER HINGE LINK AND UPPER CAM PLATE REF 52 13 141 OPS AND SDR ASAA11410820Frame · crackedRT SIDE FRAME 520 CRACKED AT A 1" PENETRATION HOLE. REPAIRED RT FRAME AT STA 520 IAW B737 400 SRM 53 00 07 REPAIR 13. THIS IS A CATEGORY B REPAIR WITH INSP THRESHOLD O 66 000 FLIGHT CYCLES AND 24 000 REPEAT INSP INTERVAL.SDR ASAA11410819Frame · crackedLT SIDE FRAME AT 500D HAS CRACK IN 1" WIRE PENETRATION HOLE AND CRACK IN .5" HOLE. REPAIRED STA 500D LT FRAME IAW EA AD 20112305 400 53 100. THIS IS A CAT B REPAIR WITH INSP THRESHOLD OF 66 000 CYCLES AND REPEAT INSP AT 24 000 FLT CYCLES INTERVAL.SDR ASAA11410818Frame · crackedRT FRAME 500B CRACKED AT .5" HOLE. REPAIRED STA 500B RT FRAME IAW EA AD 20112305 400 53 101 REV NEW ISSUED 12/16/2011. THIS IS A CAT B REPAIR WITH INSP THRESHOLD OF 66 000 FLIGHT CYCLES AND A REPEAT INSPECTION AT 24 000 FLT CYCLES.SDR ASAA11410817Frame · crackedRT FRAME 500F HAS CRACK AT 1" WIDE PENETRATION HOLE. REPAIRED 500F RT FRAME IAW B737 400 SRM 53 00 07 REPAIR 13. THIS IS A CATEGORY B REPAIR WITH INSP THRESHOLD O 66 000 FLIGHT CYCLES AND 24 000 REPEAT INSP INTERVAL.SDR ASAA11410816Frame · crackedLEFT SIDE FRAME 500B CRACK IN 1 INCH WIDE PENETRATION HOLE. REPAIRED 500B LT FRAME IAW B737 400 SRM 53 00 07 REPAIR 13. THIS IS A CATEGORY B REPAIR WITH INSP THRESHOLD O 66 000 FLIGHT CYCLES AND 24 000 REPEAT INSP INTERVAL.SDR ASAA11410815Frame · crackedLEFT SIDE FRAME 500F HAS CRACK IN 1" WIDE PENETRATION HOLE. REPAIRED 500F LT FRAME IAW B737 400 SRM 53 00 07 REPAIR 13. THIS IS A CATEGORY B REPAIR INSPECTION THRESHOLD OF 66 000 CYCLES AND A REPEAT INSP AT 24 000 FLIGHT CYCLES.SDR ASAA11410726Window · bindingCAPTAIN'S SLIDING WINDOW CATCHES AND BINDS OPENING AND CLOSING. REPLACED PILOTS SLIDING WINDOW AS REQ REF AMM 56 12 11, OPS CHECKS GOOD.SDR ASAA11410725Light · looseEMERGENCY LIGHTING STRIP IS LOOSE UNDER SEAT 24D AND HAS BECAME A TRIPPING HAZARD. REMOVED & REPLACED DAMAGED EMERGENCY TRACK STRIP IAW 33 51 91 P/N S68191 1 BATCH 1171677.SDR ASAA11410722Door · lack of lubeAFT ENTRY DOOR (L2) REPORTED "SQUEAKY" AND DIFFICULT TO OPERATE BY FLIGHT ATTENDANT CREW. INSPECTED AND LUBRICATED AFT ENTRY (L2) DOOR. OPS CHECK NORMAL. OK FOR SERVICE.SDR ASAA11410654Battery · dischargedEMERGENCY LIGHTS FAILED OPS CHECK WHILE CHECKING LIGHT FUNCTION. ACCOMPLISHED FUNCTIONAL TEST THE FOLLOWING LIGHTS EXTINGUISHED IN LESS THAN 5 MINUTES. THE REST REMAINED ON FOR 10 MINS. LEFT SIDE OF AIRCRAFT AFT OF L 1 DOOR AFT OF L 2 DOOR. RIGHT SIDE OF ASDR ASAA11410653Sign · crackedL1 DOOR LOWER EMERGENCY EXIT SIGN CRACKED AND WILL NOT STAY IN PLACE. REPLACED L1 DOOR EMERGENCY EXIT SIGN.SDR ASAA11410642Stringer · crackedAFTER REMOVAL OF STR TIE CLIP ON FRAME STA 500B STR 20R HAS A CRACK. REPAIRED STRINGER IAW B737 400 SRM 53-00-03 REPAIR 1 FIG 201.SDR ASAA11410641Skin · dentedDURING PREFLT W/A DAMAGED NOTED ON UNDERSIDE OF RT HORIZ STAB ABOUT 8" FROM ROOT. 2" AFT OF LEADING EDGE. DAMAGED AREA EST TO BE APPROX 6" LONG 3" WIDE & 1/2 TO 3/4" DEEP. DAMAGE DIMENSIONS = .044D X 6"L X 3" W STAB L/E STA 68 LOWER SIDE APPROX 4" DOWN FROM SDR ASAA11410644Frame · crackedFRAME 500F RT SIDE CRACKED AT STAND OFF PEG BELOW STR 21. REPAIRED CRACKED FRAME IAW EA 400 53EA 06775.SDR ASAA11410634Frame · crackedFRAME 500B LT HAS CRACK AT WIRE PENETRATION HOLE. REPAIRED FRAME IAW B737 400 SRM 53 00 07 REPAIR 13.SDR ASAA11410633Frame · crackedFRAME 500B RT SIDE CRACKED AT WIRE PENETRATION HOLE. REPAIRED FRAME AT 500B RT IAW B737 400 SRM 53 00 07 FIG 202 REPAIR 13.SDR ASAA11410601Sign · malfunctionedEMERGENCY EXIT ROW OVERHEAD EMERGENCY EXIT SIGN DID NOT ILLUMINATE WHEN GROUND POWER DROPPED OFF LINE. ALL OTHER EMERGENCY EXIT SIGN ILLUMINATED. RECYCLED ACFT POWER OPS CHECK NORMAL.SDR ASAA11410570Battery Pack · dischargedFORWARD EMERGENCY LIGHT BATTERY PACKS M1132 AND M1133 DO NOT HAVE SUFFICENT CHARGE FOR FUNCTIONAL. REPLACED BATTERY PACKS M1132 AND M1133 AND PERFORMED GOOD INSTALLATION TEST PER M/M 33 51 51 962 015 33 51 51 963 016.SDR ASAA11410571Skin · crackedCRACK IN FUSELAGE LT SIDE AFT OF WING TO BODY FAIRING APPROX 4FT BELOW EMERGENCY LIGHT. REPAIRED LT SIDE SKIN AFT OF WING TO BODY FAIRING APPROX 4FT BELOW EMERGENCY LIGHT IAW SRM 53 00 01 REPAIR 31 PRODUCER V.SDR BJNA20111023003Battery · dischargedINBD EMERGENCY FLASHLIGHT AT L-1 DOOR INOPERATIVE. DEFERRED IAW MEL 25-12-1, DMI 1011. R & R EMERGENCY FLASHLIGHT BATTERY.SDR ASAA11410611Frame · crackedREF AD 20090206 400 53 1 STEP 10 STA 500E LT FRAME HAS A CRACK. REMOVED DAMAGE AREA ON FRAME BOOT AT STR 21L. REPAIRED FRAME REF SRM 53 00 08 REPAIR 13.SDR ASAA11410610Frame · crackedREF AD 20090206 400 53 1 STEP 17 STA 500E RT FRAME HAS A CRACK. REMOVED DAMAGED AREA ON FRAME 500E AT 21R STR. COMPLETED STA 500E FRAME AT STR 21R REF SRM 53 00 07 REPAIR 13 AND EA 400 53EA 06597.SDR ASAA11410561Skin · crackedPOSSIBLE CRACK IN FUSELAGE CUTOUT AFT SIDE FOR EQUIPMENT COOLING EXHAUST. REMOVED CRACK DAMAGE ON FUSELAGE SKIN BS 360 BS 400 STR 27L 28R ANIC AD 2009 19 25. REPAIRED PER EA 400 53 EA 06525.SDR BJNA20111021001Lamp · burned outEMERGENCY FLOOR LIGHT AT ROW 3 INOPERATIVE. RELAMPED AISLE LIGHT AT ROW 3, OPS CHECK GOOD.SDR ASAA11410667Frame · crackedFRAME 520 RIGHT SIDE CRACKED AT WIRE PENETRATION HOLE. REPAIRED STA 520 RT FRAME IAW B737 400 SRM 53 00 07 REPAIR 13.SDR ASAA11410612Frame · crackedFRAME 500B RIGHT SIDE CRACKED AT WIRE PENETRATION HOLE. C/W ASA EA 400 53EA 06699 REV NEW ISSUED 03 NOV 2011.SDR ASAA11410468Light · inoperativeEMERGENCY LIGHT AISLE LIGHT AT ROW 12 RIGHT INOP. RELAMPED AND TESTED PER MM 33 51 81 962 044, OPS NORMAL.SDR ASAA1140465Light · inoperativeEMERGENCY LIGHT EXIT LOCATOR SIGN AT L 1 DOOR HAS MULTIPLE LAMPS INOP. RELAMPED AND TESTED PER MM 33 51 81 962 011, OPS NORMAL.SDR ASAA11410348Skin · crackedCRACK FOUND DURING MFEC RT STA 727D BELOW STR 23R. CUT OUT DAMAGED SECTION. REPAIRED CRACKED SKIN IAW B737 400 SRM 53 00 01 FIG 201 REPAIR 31.SDR ASAA11410385Skin · crackedR2 DOOR CUTOUT LOWER FWD CORNER EXTERNAL SKIN CRACKED. REPAIRED R2 DOOR CUTOUT LOWER EXTERNAL SKIN & BEAR STRAP IAW B737 400 SRM 53 00 01 FIG 201 REPAIR 32 DETAIL V.SDR ASAA11410400Frame · crackedBS 500G RT WIRE PENETRATION HOLE FOUND CRACKED AT INBD 9 O'CLOCK POSITION BETWEEN S 20R AND S 21 R GROUNDED YES. TRIMMED OUT DAMAGE FABRICATED REPAIR DOUBLERS AND INSTALLED IAW B737 400 SRM 53 00 07 REPAIR 13.SDR ASAA11410303Frame · crackedFRAME CRACKED AT PSU ATTACH BRACKAT AT FS 400 BETWEEN STRINGER 8R + 9R. ACCOMPLISHED FRAME REPAIR IAW EA 20062609 400 53 123.SDR ASAA11410293Bearing · failedR1 DOOR STUCK CLOSED. FOUND TORQUE TUBE LOWER HINGE PIN BEARING FAILED. REMOVED & REPLACED LOWER BEARING PER 52 41 41.SDR ASAA11410310Shear Tie · corrodedSHEAR TIE AT STA 767 BETWEEN STR 27L AND 26L CORRODED. REMOVED CORROSION OUT OF LIMITS. FABRICATED TREATED APPLIED FINISH AND INSTALLED REPAIR PARTS IAW B737 400 SRM 53 00 07.SDR ASAA11410290Skin · crackedL1 DOOR ASSEMBLY FOUND THE FORWARD LOWER TORQUE TUBE ACCESS HOLE CRACKED. REPAIRED L1 DOOR INNER SKIN IAW EA 400 52EA 06146 REV NEW ISSUED 8/23/2011.SDR ASAA11410243Baffle · crackedFOUND BAFFLE RT STR 26 FWD SIDE OF STA 500F IS CRACKED. REPLACED BAFFLE AT BS 500F STR 26R IAW SRM 51 40 02 & DWG 69 41473.SDR ASAA11410242Fitting · crackedFOUND CLIP THAT ATTACHES BAFFLE TO FRAME AT STA 500F RT STR 26 IS CRACKED. REMOVED FABRICATED AND INSTALLED CLIP IAW DWG 69 51411 SRM 51 40 05, SRM 51 20 01, SRM 51 40 02, DWG 69 41473 AT BS 500F STR 26RT.SDR ASAA11410238Fitting · crackedWHILE WORKING, FOUND CLIP THAT ATTACHES BAFFLE TO FRAME AT STA 500E STR 26 IS CRACKED. DAMAGE ON CLIP AT BAFFLE AT BS 500E ST26L FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED CLIP IAW SRM 51 40 02 FIG 8 & SRM 51 40 02 STEP 4B C. SDR 120073.SDR ASAA11410237Battery Pack · dischargedSEVERAL BULL NOSE EXIT LIGHTS INOP. REPLACED BATTERY PACK M1479.SDR ASAA11410236Battery Pack · defectiveSEVERAL BULLNOSE EMER EXIT LIGHTS INOP. REPLACED BATTERY PACK M1134.SDR ASAA11410272Stringer Clip · crackedSTRINGER CLIP AT STA 727A STR 6R IS CRACKED. REPLACED STR CLIP IAW B737 400 SRM 51 40 02.SDR ASAA11410271Stringer Clip · crackedSTRINGER CLIP AT STA 520 STR 8R IS CRACKED. REPLACED STRINGER CLIP IAW B737 400 SRM 51 40 02.SDR ASAA11410235Cargo Track · corrodedCORROSION WHILE WORKING TO CLOSE AFT CARGO BAY. FOUND LT CARGO TRACK CORRODED AND SEVERED AT BS 727B+3 LBL 17 WL 156. REPAIRED CARGO TRACK AT BS 727B+3 LBL 17 WL 156 IAW SRM 53 00 53 REPAIR 2 DWG 65 46592.SDR ASAA11410218Frame · crackedLEFT BS 601 FRAME WEB CRACKED AT LBL 64 WL 203. REPAIRED THE BS 601 FRAME WEB AT LBL 64 WL 203 IAW ASA EA 400 53EA 06042.SDR ASAA1140315Shear Tie · corrodedFRAME 767 SHEAR TIE BETWEEN STR 26R AND 27R IS CORRODED. REMOVED CORROSION OUT OF LIMITS. FABRICATED TREATED APPLIED FINISH AND INSTALLED REPAIR PARTS IAW B737 400 SRM 53 00 07.SDR ASAA1140314Shear Tie · corrodedFRAME 767 SHEAR TIE BETWEEN STR 26R AND 25R CORRODED. REMOVED CORROSION OUT OF LIMITS. FABRICATED TREATED APPLIED FINISH AND INSTALLED REPAIR PARTS IAW B737 400 SRM 53 00 07.SDR ASAA11410313Shear Tie · corrodedFRAME 787 SHEAR TIE DOUBLER BETWEENS TR 25L AND 26L CORRODED. REMOVED CORROSION OUT OF LIMITS. FABRICATED TREATED APPLIED FINISH AND INSTALLED REPAIR PARTS IAW B737 400 SRM 53 00 07.SDR ASAA11410312Shear Tie · corrodedAFT CARGO COMPARTMENT SHEAR TIE CORRODED AT STA 847 BETWEEN STR 27L AND 27R. REMOVED CORROSION OUT OF LIMITS. FABRICATED TREATED APPLIED FINISH AND INSTALLED REPAIR PARTS IAW B737 400 SRM 53 00 07.SDR ASAA11410311Frame · corrodedFRAME AT STA 787 SHEAR TIE DOUBLER BETWEEN STR 25R AND 26R IS CORRODED. REMOVED CORROSION OUT OF LIMITS. FABRICATED TREATED APPLIED FINISH AND INSTALLED REPAIR PARTS IAW B737 400 SRM 53 00 07.
Back to Boeing 737-4Q8