Boeing 737-924ER
Service difficulty reports · 3,682
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 = '737924ER' 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 = '737924ER' 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 CALA2018091901971Wire · chafedON 2 SVC FOUND SEAT EMERGENCY LIGHTING NOT WORKING FROM ROW 35-39. ROWS 35 THRU 39 LEFT ARE ON CHARGER BATTERY PACK M1673 FOUND THE SEAT ROWS 35-39. BLOWING FUSES FOUND DIRECT SHORT 4 OHMS IN WIRE HARNESS FOR SEATS 35-39 RUNG WIRES FROM WALL TO CHARGER NO SHORSDR CALA2018091901965Lens · unknownEXIT SIGN AT SEAT 21A LOWER SIGN IS BROKEN. SECURED LENS ASSY.SDR CALA2018090701916Floorbeam · corrodedCABIN FLOOR SUPPORT BEAM IS CORRODED AT BS 986.5 11IN RIGHT OF CENTER LINE. REMOVED CORROSION AT FLOORBEAM BS 986.5 11IN RT OF CENTER LINE MAT FOUND OUT OF LIMITS MAT LOSS .032 ORG MAT .150 MAT REMAINING .118. FLAP PEEN BLENDING AREAS FAB REPAIR STRAP AND SHIMSDR CALA2018090401892Transceiver · inoperativePWS FAIL. REMOVED AND REPLACED RECIVER TRANSMITTER WRX SYSTEM REF AMM 34-4 3-41. PERFORMED OPERATIONAL TEST OK ROTABLE PARTS CHANGE WAS INDICATED, TT 1026891 SN OFF 8508 RECEIVER, TRANS OFF 29-3431-9-0012 8508 ON 29-3431-9-0012 4183.SDR CALA2018082001825Fuse · blownEMERGENCY LIGHT BATTERY CHARGER M1694 HAD FOUR BLOWN FUSES. REPLACED THE FUSES IAW AMM 33-51-06. OPS CHECKED OK. ACP IDT INSP OF REPLACED FUSES IAW GM M 09-10-05, AND AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2018082001817Charger · inoperativeEMERGENCY LIGHT BATTERY PACK AND CHARGER M1671 WERE INOPERATIVE. REPLACED THE BATTERY CHARGER IAW AMM 33-51-06. OPS CHECKED OK.SDR CALA2018081701809Structure · bentL1 DOOR AFT EDGE WAS BENT 16 INCHES FROM LOWER CORNER. ACCOMPLISHED A PERMANENT REPAIR TO THE L1 DOOR AFT EDGE IAW ERA 5211-01602.SDR CALA2018081701803Skin · dentedFWD CARGO DOOR, FWD UPPER CUTOUT HAD A DENT WITH A GOUGE AT BS 451, BELOW STRINGER 18R. ACCOMPLISHED ITERIM REPAIR IAW ECRA 5331-02245.SDR CALA2018073001703Skin · damagedSUPERTUG TEAM SPOTTED FUSELAGE DAMAGE AT GATE TOW UP. DAMAGE IS LOCATED 42" FWD OF TOP FWD CORNER OF L1 ENTRY DOOR. SHEET METAL DAMAGE LOCATION BETWEEN SL-5 AND SL-6 AT APROX STATION BS 272. DENT MEASURES 1.6" X 1.2" WITH A DEPTH OF .030". GOUGE ON DENT BLENDESDR CALA2018071901653Skin · dentedDENT ON FUSLAGE EXTERNAL SKIN AT STA 450.5 JUST BELOW STRINGER 18R 3IN FROM FWD CARGO DOOR CUTOUT WITH LOOSE FASTNERS. ACCOMPLISHED FUSLAGE SKIN REPAIR AT FWD CARGO DOOR CUTOUT FWD UPPER CORNER PER ECRA 5331-02236.SDR CALA2018070301543Unknown · odorINTERMITTENT ELEC SMOKE SMELL REPORTED AFT CABIN ON AIRCRAFT LEFT BY BOTH FLT ATTDS AND PAX RAN BOTH ENGINES - ONE AT A TIME - AT HIGH POWER AND FOUND NO ELEC SMOKE SMELL IN ENTIRE MAIN CABIN. AS PER MM 05-51-26-800-801CI C/W INSP OF ELEC SMOKE. NO DEFECT NOTESDR CALA2018062501519Frame · crackedBS 727D FRAME, RIGHT SIDE WAS CRACKED AT PSU RAIL ATTACH BRACKET LOCATED BETWEEN SR-8 AND SR-9. REPAIRED IAW EC/RA5310-07462.SDR CALA2018062201502Frame · corrodedFRAME SECTION AT BS 336, BETWEEN STRINGERS 21L - 23L HAD CORROSION AT THE BOTTOM END. REPAIRED THE FRAME SECTION IAW SRM 53-10-15, AND SRM 51-40-02.SDR CALA2018062211500Stringer · corrodedCORROSION FOUND ON THE E & E BAY STRINGER 23L, BS 291.5 TO 344. REPLACED THE STRINGER IAW SRM 51-40-02.SDR CALA2018062101481Stringer · corrodedSTR 25L CORRODED AROUND RIVETS FROM STA 957 TO 963, REFERENCE HANGAR NON ROUTINE 9601522 STRINGER REPAIRED IN ACCORDANCE WITH SRM 53-00-03 REPAIR 1.SDR CALA2018062101480Skin · crackedLEFT SIDE HORIZONTAL STAB HAD A CRACK APPROXIMATELY 1 INCH LONG HSS 157.10, AND 16.5 INCHES FROM THE TRAILING EDGE. REPAIRED IAW SRM 53-10-01, REPAIR 11.SDR CALA2018062101464Floorbeam · corrodedCABIN FLOORBEAM, BS 986 HAD CORROSION ON THE UPPER TEE, BETWEEN LBL 18 AND RBL 17. REPAIRED THE FLOORBEAM IAW ECRA 5320-02849.SDR CALA2018062101446Lock Bolt · shearedTHE TRAILING EDGE FLAP TRACK BALLSCREW GIMBALS, LOWER BUSHING RETAINING LOCK BOLTS WERE FOUND SHEARED OFF AND/OR BOLT COLLARS MISSING ON THE RT WING NR 5 & 6 T/E FLAP TRACK LOCATIONS.SDR CALA2018060601428Frame · crackedCRACK FOUND ON THE FRAME AT BS 727D, RAIL ATTACH LOCATED BETWEEN STRINGERS 9R AND -8R. TRIMMED OUT THE DAMAGE SECTION OF THE FRAME AND INSTALLED A REPAIR DOUBLER IAW EC/RA 5310-07436, PART 1.SDR CALA2018060531396Floor Support · corrodedMAIN CABIN FLOOR SUPPORT WAS CORRODED, BS 337, LBL 42. REMOVED AND REPLACED IAW SRM 51-40-02, AND DRAWING 141A5730.SDR CALA2018060531395Floorbeam · crackedMAIN CABIN FLOORBEAM WAS CRACK AT BS 321, BL 0 - LBL 45. REMOVED AND REPLACED THE FLOORBEAM IAW.SRM 51-40-02, AND DWG 141A5400.SDR CALA2018060531394Floor Support · crackedMAIN CABIN FLOOR SUPPORT WAS CRACKED, BS 258, BL 0 . REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02, AND DWG 141A5400.SDR CALA2018051501276Skin · crackedRIGHT HORIZONTAL STAB CRACKED ON THE LOWER SKIN, HSS 129.5 AND 138.7. REPAIRED IAW SRM 55-10-01 REPAIR 11, PERFORM INSPECTION IAW SRM, STEP 5, TABLE 204.SDR CALA2018051501275Skin · crackedRIGHT HORIZONTAL STAB LOWER SKIN CRACKED AT HSS 92.7. REPAIRED IAW SRM 55-10-01, REPAIR 11.SDR CALA2018051501254Skin · crackedLEFT HORIZONTAL STAB CRACKED AT THE LOWER SKIN HSS 120.30. REPAIRED IAW SRM 55-10-01, REPAIR 11.SDR CALA2018043001213Skin · gougedFOUND A GOUGE ON THE FUSELAGE SKIN ABOVE THE AFT CARGO DOOR CUT OUT 12 INCHES FROM FWD UPPER EDGE AT BS 807 BETWEEN STRINGERS 18R & 19R. REPAIRED IAW EC/RA 5331-02205.SDR CALA2018042301186Battery Pack · failedEMERGENCY EXIT LIGHTS AT ROWS 28 - 32 INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK M2626 IAW AMM 33-51-06. OPS CHECKED NORMAL.SDR CALA2018040901136Battery Pack · inoperativeFOUND EMERGENCY EXIT LIGHTS INOPERATIVE. FOUND THE BATTERY PACK M1671 DISCHARGED. A NEW BATTERY PACK WAS INSTALLED IAW AMM 33-51-06-960-805, OPS CHECKED GOOD.SDR CALA2018032801040Lens · missingEMERGENCY EXIT LIGHT COVER IS MISSING FROM SEAT 24C. REPLACED THE EMERGENCY EXIT LIGHT ASSY, OPS CHECKED GOOD.SDR CALA2018032601021Lens · missingFOUND EMERGENCY LIGHT LENS MISSING. INSTALLED A NEW LENS IAW AMM 33-51-00.SDR CALA2018032601020Light · detachedROW 15C SEAT MOUNTED EMERGENCY LIGHT HANGING OUT AND INOPERATIVE. REPLACED THE EMERGENCY LIGHT, OPS CHECKED GOOD, OK FOR SERVICE.SDR CALA2018031200897Control Panel · faultyFOUND MASTER FIRE WARNING MODULE IN THE FLIGHT DECK FAULTY TEST SWITCH STUCK IN TEST MODE. REPLACED ENG APU CTL PANEL PER 26-00-01-000-801. INSTALLED PANEL PER 26-00-01-400-801 COMPLIED UP TO SUBTASK 26-00-01-710-001 ROTABLE PARTS CHANGE WAS INDICATED - TT 131SDR CALA2018030800871Packing · leakingNUMBER 1 ENGINE SHUTDOWN DUE TO LOSS OF OIL QUANTITY R&R INNER & OUTER LUBE UNIT SPOOL PACKING REF AMM 79-21-01-000 /400-803-FOO; ALSO R&R 3 MCD PACKING REF AMM 79-21-05-000/400- 806-FOO. PERFORMED TEST 3A IDLE LEAK CK NO LEAKS NOTED. PERFORMED TEST 3A IDLE LESDR CALA2018030600857Transmitter · malfunctionedFLAPS STUCK AT 5. HAD TO ALT EXTEND FLAPS TO 15 FOR LANDING. PREFORMED A BITE CHECK OF FSEU, FOUND FAULT 27-52259. TROUBLESHOT IAW FIM 27-51-00-810-813. FOUND THE LEFT FLAP TRANSMITTER AT FAULT. REMOVED & REPLACED THE LEFT FLAP POSITION TRANSMITTER IAW MMSDR CALA2018030100835Battery Pack · inoperativeAISLE EMERGENCY LIGHTS AT ROW 31 AND ROW 34 RIGHT HAND SIDE ARE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AT ROW 31R IAW AMM 33-51-06, OPS CHECKED GOOD.SDR CALA2018022800831Tire · failedDURING A WALKAROUND, DUE TO BLOWN NOSE TIRE, FOUND NLG HARNESS, BRACKETS DAMAGED. REPLACED THE TAXI LIGHT CONDUIT AND AIR GROUND SWITCH GUARD BRACKET.SDR CALA2018022500815Slide · unsecureSLIDE CAME OUT OF PACK WAS DISARMED L1 DOOR UPON ARRIVAL ON AIRCRAFT FOUND 1L SLIDE PACK DROPPED OUT OF COVER. PERFORMED DETAILED VISUAL INSPECTION ON SLIDE PACK, FOUND TO BE NORMAL IN SERVICEABLE CONDITION, INSPECTED COVER AND HOOKS NO FAULTS FOUND. REINSTALSDR CALA2018022500806Shroud · deterioratedLIGHT LENSES DETERIORATED ON BOTTOM SIDE OF BOTH FWD & AFT LIFE RAFT STORAGE. SHROUD NEEDED NOT LIGHT LED ASSY. M&E 60-3322-3-0012 PER IPC FIGURE 33-22-00-30L LIGHT INSTL-CTR OHVD STOWAGE SHEET 2 ITEM 10. INSTALLED SHROUD.SDR CALA2018022500814Lens · missingSEAT 20C EMERG LT BULB MISSING. REPLACED RED LENS COVER.SDR CALA2018022100727Lens · missingLENS MISSING ON THE EMERGENCY EXIT SIGN ON FLOOR, INSTALLED THE LENS, OK TO CONTINUE.SDR CALA2018022100719Unknown · odorAFT FA REPORTED AN ODOR OF BURNING PLASTIC IN AFT GALLEY. ALL OVENS AND COFFEEMAKERS CIRCUIT BREAKERS PULLED AND ODOR GONE. REMOVED OVENS 423, 425, 430, AND 434. REMOVED ALL OVENS CHECKED FOR BURNED WIRES OR PLASTIC, NONE FOUND. INSTALLED EACH OVEN INDIVSDR CALA2018022000702Bracket · brokenEMERGENCY EXIT FLOOR LIGHT BRACKET BROKEN AT SEAT 9C. REPLACED BRACKET AND LIGHT ASSY. OPS CHECKED NORMAL.SDR CALA2018022000712Slide · defectiveDOOR 1L SLIDE PACK NOT NORMAL. REPACKED L1 DOOR SLIDE IAW MM TASK 25-66-01-400-803 INSPECTION TASKS COMPLETED.SDR CALA2018021900691Light · inoperativeEMERG EXIT LIGHTS INOP AT 34C AND 11C. SECURED EMERGENCY LIGHT AT 34C. REMOVED AND REPLACED LIGHT ASSY AT 11C. OPS CHECK GOOD AT THIS TIME. REF AMM 33-51-11.SDR CALA2018021900698Light · inoperativeOVERWING SLIDE LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-04-960-801.SDR CALA2018021800684Lens · missingEMERGENCY LIGHT AT FWD COAT CLOSET MISSING THE LENS. REPLACED THE LENS IAW MM 33-51-00.SDR CALA2018021600663Lens · brokenEMERGENCY LIGHT LENS BROKEN ON AFT SIDE OF 1L CLOSET DOOR. REPLACED THE LENS.SDR CALA2018021600662Lens · crackedFLOOR EMERGENCY LIGHT LENS CRACKED, AFT OF THE FWD CLOSET, FWD OF SEAT 1B. REPLACED THE LENS.SDR CALA2018021600661Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT 20C. REPLACED THE LENS.SDR CALA2018021600660Lamp · inoperativeREAR INTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED GOOD.
Back to Boeing 737-924ER