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 ASAA2012091392871Frame · crackedFRAME 520, RT SIDE HAS 2 CRACKS, 1 INBD BRACKET HOLE BETWEEN STR 8R AND 9R, AND 1 OTBD BRACKET HOLE ABOVE STR 8. ACFT GROUNDED. REPAIRED FRAME 520 RT IAW ASA EA AD20062609 400 53 131.SDR ASAA2012082593078Skin · chafedLT WING L/E NR 3 SLAT LOWER INBD T/E CHAFED THRU REPAIR DOUBLER. ACFT GROUNDED. REPAIRED NR 3 SLAT LWR INBD CORNER DAMAGE IAW SRM 51 70 10 PAR 20, PG 254, REP 4 PG 201.SDR ASAA2012082592876Floor Support · crackedLONGITUDINAL FLOOR SUPPORT RBL 24.5 UPPER CHORD CRACKED AT FS 664. REPAIRED LONGITUDINAL BEAM AT FS 664, RBL 24.5 IAW EA NR AD20080506-400-57-1-101.SDR ASAA2012082692798Strap · corrodedCORROSION FOUND IN FWD CARGO BAY ON STRAP COMMON TO FRAME AT FS 492 AFT SIDE OF DOOR OPENING. ACFT GROUNDED. CORROSION BLENDED OUT AND REMOVED REF SRM 53-30-15, AD-1, PG 105. DEPTH OF DAMAGE WAS .037 OUT OF LIMITS IAW SAID REF REMOVED STRAP. SEVERAL HOLES FSDR ASAA2012082492794Frame · crackedFRAME AT BS 500B RT SIDE HAS A CRACK .375 LONG EXTENDING INBD FROM EDGE OF THE 1.04 WIRE PENETRATION HOLE. ACFT GROUNDED. FRAME REPAIRED IAW SRM 53 00 07, REPAIR 13. THIS IS A CAT B REPAIR.SDR ASAA2012082592790Skin · chafedLT WING L/E NR 3 SLAT LOWER INBD T/E CHAFED. REPAIRED IAW SRM 51-70-10, PARA 20, PG 254, REP 4, PG 201.SDR ASAA2012082492786Skin · crackedLT FUSELAGE SKIN BS 727D HAS A CRACK .75 LONG BELOW STR 23L IN CHEM MILLED AREA. ACFT GROUNDED. REPAIRED SKIN IAW SRM 53-00-01, FIG 201.SDR ASAA2012082692766Door Frame · corrodedFRAME CORRODED. INSTALLED FORWARD CARGO DOOR AFT CORRODED REINFORCEMENT STRAP. ACFT GROUNDED. R & R REINFORCEMENT STRAP.SDR ASAA2012081092700Spindle · corrodedCORROSION FOUND ON SPINDLE DURING INSPECTION, T/C, AD 20121307-400-57 ON THE NR 8 FLAP CARRIAGE SPINDLE, PN 65-46481-122, SN B5159. ACFT GROUNDED. REPLACED NR 8 FLAP CARRIAGE ASSY.SDR ASAA2012072192604Frame · crackedFWD CARGO FWD FRAME AT STR 24 CRACKED. ACFT GROUNDED. R & R FRAME.SDR ASAA2012072192565Frame · crackedFORWARD CARGO FORWARD FRAME AT STR 24 CRACKED. ACFT GROUNDED. REMOVED AND REPLACED FRAME.SDR ASAA2012071992633Angle · crackedAFT CARGO BAY BS 727D TO 727E, BL 0 CHANNEL AND ZEE ANGLE CRACKED. REPLACED ANGLE.SDR ASAA2012071192530Window · failedUNABLE TO CLOSE CAPTAINS SLIDING WINDOW. ACFT GROUNDED. REMOVED WINDOW TO INSPECT FOR DAMAGE. FOUND LOWER AFT ROLLER TO BE ABOUT 1.5 TURNS OUT (LOOSE). TIGHTENED SPECIAL BOLT FOR ROLLER AND TIGHTENED SET SCREW. REF MM 56-12-11 CHECKED ADJUSTMENT OF NR 2 SLSDR ASAA2012071092524Housing · gougedAFT CARGO PIT BUMPER MISSING AND HOUSING GOUGED. HANDLE HOUSING GOUGE MEASURES GREATER THEN .060. REMOVED HANDLE ASSY FOR ACCESS TO HOUSING. REMOVED DAMAGE HOUSING AND INSTALLED NEW REF SRM 51-40-02. PRIMED AND PAINTED AREA REF AMM 51-21-99. INSTALLED INSSDR BJNA201205270002Lamp · unserviceableEMERGENCY LIGHT ABOVE SEAT 13C INOPERATIVE. RE-LAMPED EMERGENCY LIGHT ABOVE SEAT 13C IAW AMM 33-51-21. OPS CHECK GOOD.SDR ASAA12411551Light · brokenR1 DOOR LOWER EMERGENCY EXIT LIGHT ASSY IS BROKEN. REMOVED & INSTALLED R1 DOOR LOWER EMERGENY EXIT LIGHT ASSY OPS NORMAL, REF 33-51-02.SDR ASAA12411463Lens · missingF/A REPORTS R2 EXIT SIGN COVER IS MISSING. ACFT GROUNDED. INSTALLED LIGHT COVER R2 EXIT. LIGHTS OPS GOOD.SDR ASAA1241432Intercostal · crackedINTERCOSTAL WEB, STR 11L, STA 294.5, 303.9 CRACKED AT INBD FWD CORNER FROM FASTENER TO EDGE. REPAIRED INTERCOSTAL WEB AT STA 294.5, STR 11L IAW ASA EA AD20091614-400-53-107.SDR ASAA12411389Skin · chafedRT WING NR 4 SLAT T/E WEDGE INBD END LOWER SURFACE CHAFED. ACFT GROUNDED. REPARIED CHAFED AREA IAW SRM 51-70-10.SDR ASAA12411347Cover · looseR2 DOOR EXIT SIGN COVER FALLING OFF. SECURED EXIT LIGHT COVER ABOVE DOOR. LOOSE HARDWARE TIGHTENED.SDR BJNA201203210003Battery Pack · dischargedR2 DOOR EMERGENCY EXIT LIGHT DOESN`T HOLD CHARGE. R & R BATTERY PACK IN AFT GALLEY RT SIDE. OPS CHECK GOOD IAW AMM 33-51-51.SDR ASAA12411273A/C Pack · lack of lubeL1 DOOR VERY DIFFICULT TO CLOSE. FOUND HANDLE GUIDE PLATE DRY AND BINDING. LUBED GUIDE PLATE PER MM 12 25 21 643 007. OPS TEST GOOD FOR MM 52 11 00 705 065.SDR BJNA201203090302Lamp · inoperative28 VOLT EMERGENCY LIGHT INOPERATIVE AT CEILING FIXTURE ABOVE SEAT 5C. RELAMPED EMERGENCY 28V LIGHT ABOVE SEAT 5C IAW AMM 33-21-03. OPS CHECK GOOD.SDR ASAA12411220Charger · failedEMERGENCY LT AT BULLNOSE ROW 25ABC INOP. REPLACED M1197 EMERGENCY BATTERY PACK CHARGER REF WDM 33 51 15, OPS NORMAL.SDR BJNA2012030800001Battery Pack · inoperativeOVERWING EM (EMERGENCY LIGHT) BATTERY PACKS WILL NOT HOLD A CHARGE. R & R BOTH OVERWING EM LIGHT BATTERY PACKS WITH NEW BATTERY PACKS IAW AMM 33-51-51. OPS CHECK GOOD.SDR ASAA12411184Frame · crackedUPPER FASTENER HOLE OF THE LOWEST ISOLATOR (STR 17) AT STA 500D HAS A CRACK INDICATION RT SIDE. REPAIRED FRAME 500D AT STR 17R IAW ASA EA 400 53EA 07570 REV NEW DATED 01 MAR 12.SDR ASAA12411182Door · noisyL1 DOOR VERY HARD TO CLOSE AND MAKES LOUD SQUEAL AFTER TAKEOFF. INSPECTED DOOR SEAL NO DEFECTS NOTED. PERFORMED FORWARD ENTRY DOOR OPERATIONAL TEST PER 52 11 00 L1 DOOR OPS CHECK NORMAL.SDR ASAA12411139Frame · crackedCRACK FOUND IN FRAME 500F LEFT PROPAGATING FROM THE 1.04 INCH WIRE PENETRATION HOLE INBOARD APPROX .350 LONG. REPAIRED LT FRAME AT STA 500F WIRE PENETRATION HOLE IAW B737 400 SRM 53 00 07 REPAIR 13.SDR ASAA12411138Skin · crackedMFEC SHOWS CRACK INDICATION APPROX 1' LONG IN CHEM MILLED AREA BELOW STR 23L BS 720D+2" BELOW EMER EXIT LIGHT. REPAIRED DAMAGED AREA IAW B737 400 SRM 53 00 01 REPAIR 31.SDR ASAA12411135Bumper · out of positionCAPT SLIDING WINDOW DIFFICULT TO OPEN AND CLOSE. FOUND CAPT SLIDING WINDOW INTERFERING WITH UPPER CRASH PAD REPOSITIONED UPPER CRASH PAD REF B737 400 AMM 20 50 11.SDR BJNA120202Battery Pack · dischargedDURING A-CHECK, FOUND RT OVERWING EXIT BATTERY PACK WOULD NOT HOLD CHARGE. R & R RT SIDE EMERGENCY EXIT BATTERY PACK IAW AMM 31-51-51. OPS CHECK GOOD.SDR ASAA12411114Skin · delaminatedRIGHT OTBD AFT FLAP INBD TRAILING EDGE FOUND TO BE DELAMINATED. REPAIRED IAW SRM 51-70-10 REPAIR 2.SDR ASAA12411115Frame · crackedCRACK FOUND IN FRAME BS 500F, PROPOGATING FROM THE 1.04' WIRE PENETRATION HOLE APPROX 70' LONG. REPAIRED FRAME IAW SRM 53-00-07, CATEGORY B REPAIR.SDR ASAA1241057Sign · looseLEFT "EXIT SIGN" OVER EMERGENCY EXITS CAME LOOSE. INSPECTED LT OVERWING ACCESS PANEL "SIGN". SECURED AND VERIFIED SECURE. OK FOR SVC.SDR ASAA12411107Floorbeam · crackedLONGITUDINAL FLOORBEAM AT RBL 45.5 STA 727B 20A CRACKS .375 LONG. REPAIRED LONGITUDINAL FLOORBEAM RBL 45.5 STA 727B IAW ALASKA AIRLINES EA AD20080506 400 57 108.SDR BJNA201202010001Flashlight · brokenAFT RT EMERGENCY FLASHLIGHT INOPERATIVE. DEFERRED IAW MEL 25-12, DMI 0201. REMOVED AND INSTALLED F/A EMERGENCY FLASHLIGHT BASE. OPERATIONAL CHECK GOOD.SDR ASAA2012013011113Frame · crackedBS 500F FRAME RIGHT STANDOFF TOOLING HOLE IS CRACKED I/B SIDE. REPAIRED FRAME IAW EA 400-53EA-07463.SDR ASAA12411064Frame · crackedSTA 500C LT SIDE WIRE PENETRATION HOLE IS CRACKED I/B AFT SIDE. REPAIRED FRAM STA 500C LT SIDE IAW B737 400 SRM 53 00 0 REPAIR 13.SDR ASAA12411052Frame · crackedSTA 500B LEFT SIDE WIRE PENETRATION HOLE CRACKED INBD SIDE FRONT AND AFT. REPAIRED FRAME STA 500B LEFT SIDE IAW B737 400 SRM 53 00 07 REPAIR 13.SDR ASAA12411047Frame · crackedSTA 500E RIGHT SIDE WIRE PENETRATION HOLE CRACKED INBD SIDE FRONT AND AFT. REPAIRED FRAME AT 500E RT SIDE IAW B737 400 SRM 53 00 07 REPAIR 13.SDR ASAA12411010Handle · lack of lubeL1 DOOR HANDLE IS HARD TO OPEN AND CLOSE. LUBED FWD ENTRY DOOR PER AMM 12 25 21. OPS NORMAL.SDR ASAA12410968Frame · crackedREF T/C AD20090206 400 53 1 WIRE PENETRATION HOLE INSPECTION STATION 500C RT SIDE 1.04 INCH HOLE IS CRACKED. REPAIRED IAW SRM 53 00 07 REPAIR 13.SDR ASAA12410971Frame · crackedREF T/C AD20090206 400 53 1 WIRE PENETRATION HOLE INSPECTION STATION 500C RT SIDE 1.04 IN HOLE IS CRACKED. REPAIRED IAW SRM 53 00 07 REPAIR 13.SDR ASAA12410970Frame · crackedREF T/C AD 20090206 400 53 1 WIRE PENETRATON HOLE INSPECTION STATION 500B RT SIDE .500 HOLE HAS A CRACK. REPAIRED FRAME REF SRM 53 00 07 REPAIR 13 EA 400 53EA 07274 AND IS COMPLETED.SDR ASAA12410969Frame · crackedREF T/C AD 20090206 400 53 1 WIRE PENETRATON HOLE INSPECTION STATION 500B RT SIDE .500 HOLE HAS A CRACK. REPAIRED FRAME REF SRM 53 00 07 REPAIR 13. EA 400 53EA 07274 AND IS COMPLETED.SDR ASAA12410967Frame · crackedFRAME AT 500E RIGHT IS CRACKED AT WIRE PENETRATION HOLE I/B SIDE. REPAIRED FRAME IAW 737 400 SRM 53 00 07 REP 13.SDR ASAA12410966Frame · crackedFRAME AT 500E IS CRACKED AT WIRE PENETRATION HOLE I/B SIDE. REPAIRED FRAME IAW 737 400 SRM 53 00 07 REP 13.SDR ASAA12410965Frame · crackedFRAME AT 500B LEFT IS CRACKED AT WIRE PENETRATION HOLE I/B SIDE. REPAIRED FRAME IAW B737 400 SRM 53 00 07 REP 13.SDR ASAA12410952Guide Arm · wornL2 DOOR IS DIFFICULT TO OPEN. FOUND AFT ENTRY DOOR SNUBBER INOP. REPLACED SNUBBER REF AMM 52 13 71. FOUND GUIDE ARM AND DOWL PIN WORN. REPLACED GUIDE ARM REF AMM 52 13 31. ADJUSTED AFT ENTRY DOOR VERTICAL REF AMM 52 13 00 705 001 PERFORMED AFT ENTRY DOOR SDR ASAA11410865Light · inoperativeWHILE OPS TESTING EMER EXIT LIGHTS FOUND R1 DOOR EXIT LIGHT INOP OUTSIDE. RELAMPED R1 OUTSIDE EXIT LIGHT & OPS TEST GOOD REF MM 33 51 02.
Back to Boeing 737-4Q8