JASC 3350
Service difficulty reports · 225,886
Reports filed under 3350 · Emergency Lighting, newest first.
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 jasc_code = '3350' 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 jasc_code = '3350' 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 SIMA20170605001Light · inoperativeSERVICE DOOR ARM EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EXTERIOR EMERGENCY LIGHT IAW AMM 33-50-10-000-801 AND 33-50-10-400-801. OPS CHECKED GOOD.SDR AALA201706069006Sign · missingEMERGENCY EXIT SIGN AT SEAT 20H IS MISSING. REPLACED EXIT SIGN. OPERATIONAL CHECKED GOOD.SDR AALA201706069005Sign · detachedEMERGENCY EXIT SIGN AT ROW 1B IS DETACHED. SECURED EXIT SIGN IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR DALA2017060504511Power Supply · inoperativeEMERGENCY AISLE LIGHTS ARE INOPERATIVE. REPLACED M737 POWER SUPPLY AND BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR DALA2017060604510Lens · missingSEAT 11C EMERGENCY FLOOR PATH LIGHT MISSING LENS. REPLACED LENS.SDR JJBA20170605005Battery Pack · dischargedFWD CENTER ISLE EMERGENCY LIGHT INTERMITTENT. CHARGED EMERGENCY LIGHT BATTERIES AND PERFORMED OPERATIONAL TEST OF EMERGENCY LIGHT SYSTEM. OPS CHECK SAT. NO OTHER DEFECTS NOTED.SDR CALA2017060501734Battery Pack · faultedEMERGENCY LIGHTS AT SEAT ROWS 23, 24. 25, 29, 30, 31, 36, 37, AND 38 WITH LIGHT SWITCH IN OFF POSITION. REMOVED AND REPLACED 11WL BATTERY PACK IAW AMM 33-51-38-000 -002-A AND 33-51-38-400-002-A. OPS CHECKED GOOD IAW AMM 33-5 1-38-710-052-A.SDR CALA2017060501732Battery · faultedRIGHT EPSU BATTERY FAULT LIGHT DURING TEST. REPLACED THE BATTERY IAW AMM 33-51-38, TESTED OK.SDR CALA2017060501729Power Supply · inoperativeRIGHT OVERWING EMERGENCY EPSU INOPERATIVE. REMOVED AND REPLACED EPSU AND BATTERY IAW AMM 33-51-000-001-A, 3 3-51-38-400-001-A, 33-51-38-000-002-A, AND 33-51-38-400-002-A. OPS T ESTED GOOD IAW AMM 33-51-00-710-001-A.SDR CALA2017060501728Battery Pack · no testEMERGENCY LIGHT TEST FAILED A SYSTEM BITE TEST. RESET FWD LT AND MID LT BATTERIES, SYSTEM TESTED OK, IAW AMM 33-00-00SDR CALA2017060501727Lens · missing1L EXIT DOOR LIGHT LENS MISSING. REPLACED THE LENS.SDR CALA2017060501726Power Supply · no testDURING 2 SVC, CABIN EMERGENCY LIGHTS TEST FAILED ON CIDS BY DISPLAYING EPSU BATTERY LT, AND EPSU COMM FWD. LT. REPLACED AFT CABIN EMERGENCY POWER SUPPLY AND BATTERY IAW AMM 33-51-38, TEST NOW PASSES.SDR CALA2017060501725Lens · missingEMERGENCY LIGHT LENS COVER MISSING LOWER SIDEWALL 20F. LIGHTS CHECKED AND WORKING. REPLACED LENS COVERSDR CALA2017060501723Mount · brokenSEAT MOUNTED EMERGENCY LED LIGHT MOUNT BROKEN AT SEAT 28C. REPLACED THE LIGHT ASSY ON SEAT, LIGHT CHECKED OKSDR CALA2017060501722Battery Pack · inoperativeDURING AN EMERGENCY LIGHT TEST, FIRST CLASS FLOOR, R1 DOOR, L2 DOOR, ROWS 27-39 FLOOR AND STOWBIN LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACKS M1673 , M1674, AND M2626. OPS CHECKED OK IAW MM 33-51-06-960-805.SDR CALA2017060501721Socket · inoperativeEMERGENCY SLIDE OVERWING LIGHT DOES NOT COME ON RIGHT . REPLACED OVERWING LAMP AND SOCKET ASSY OPS CHECKED NORMALSDR CALA2017060501720Lens · missingROW 21A EMERGENCY EXIT LIGHT COVER MISSING. ABOUT ANKLE HEIGHT. REPLACED MISSING LENS FOR EXIT LIGHT AT ROW 21A OK TO CONTINUE.SDR CALA2017060501719Battery Pack · inoperativeEMERGENCY LIGHT AT OVERHEAD BIN BULLNOSE IS INOPERATIVE AT ROW 15L ,21L ,12R, AND 15R. REMOVED AND REPLACED THE BATTERY PACK IAW WDM 33-51-13. OPS CHECK OK. ACCOMPLISHED IDT INSPECTION.SDR CALA2017060501718Switch · intermittentDURING AIRCRAFT POWER FAILURE, EMERGENCY LIGHTS ON ROWS 21, 22, 23 DID NOT OPERATE. VERIFIED WITH THE FLIGHT CREW, CYCLED THE LIGHT SWITCH AND EMERGENCY LIGHTS WORKED OK.SDR CALA2017060501716Battery Pack · faultyMULTIPLE EMERGENCY LIGHTS AT THE LT MID CABIN ONLY STAY ON FOR UNDER A MINUTE. REMOVED AND REPLACED THE BATTERY PACK M1670 IAW AMM 33-51-06, OPS CHECKED GOODSDR CALA2017060501714Power Supply · no testEMERGENCY LIGHTNS BETWEEN ROWS 22 AND 31 LEFT SIDE FAILED TO TEST. NOT ILLUMINATING WHEN P-5 SWITCH OR AFT FLIGHT ATTEN DANT TEST SWITCH IS ENERGIZED. REPLACED POWER SUPPLY LOCATED AT BS 727C+13, LEFT SIDE IAW MM 33-51-06-960-805, OPS NORMAL.SDR CALA2017060501713Sign · detachedPLASTIC EXIT SIGN OVER THE CABIN AISLE FOUND DETACHED. THE SIGN WAS REPLACED.SDR CALA2017060501712Lamp · inoperativeTWO EMERGENCY OVERHEAD SIGNS FOUND INOPERATIVE AT THE R1 DOOR AND FIRST CLASS AREA. REPLACED THE LAMPS, RESET SYSTEM, OPS CHECKED NORMAL.SDR CALA2017060501711Battery Pack · inoperativeLEFT OVERWING EMERGENCY EXIT SIGN LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK. OPS CHECKED GOOD IAW AMM 33-51-06.SDR CALA2017060501710Cover · missingMID CABIN EMERGENCY SIGN COVER MISSING. INSTALLED A NEW COVER.SDR CALA2017060501705Light · malfunctionedEMERGENCY LIGHTS ILLUMINATE WITH SWITCH IN THE ARMED POSITION. RESET THE CIRCUIT BREAKER. OPS CHECKED NORMAL IAW 33-51-00.SDR CALA2017060501704Bulb · inoperativeR4 EMERGENCY SLIDE LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-51-00. OPS CHECKED GOOD.SDR CALA2017060501700Light · inoperativeR1 DOOR SLIDE LIGHT INOPERATIVE. REPLACED R1 DOOR SLIDE LIGHT ASSY IAW AMM 33-51-06 OPS CHECKS NORMALSDR CALA2017060501697Light · intermittentEMERGENCY LIGHTS FLICKERED ON INTERMITTENTLY IN FLIGHT WITH SWITCH IN ARMED POS PERFORMED OPERATIONAL TEST IAW AMM 33-51-00-710-801.TEST NORMAL ON GROUND.SDR CALA2017060501696Sign · looseEMERGENCY EXIT LIGHTS LOOSE EMERGENCY EXIT SIGN MOVING AROUND. L3 DOOR SECURED EMERGENCY EXIT LIGHTS SIGNSDR CALA2017060501691Lamp · inoperativeDURING A EMERGENCY LIGHTING OPS CHECK , SEAT 40C INOPERATIVE. REPLACED THE LAMPS AND ACOMPLISHED THE EMERGENCY OPERATIONAL LIGHT TEST IAW AMM 33-51-00-715-004-001. TESTED GOOD.SDR CALA2017060501706Lens · missingL1 DOOR EMERGENCY EXIT SIGN LENS MISSING. INSTALLED A LENS.SDR CALA2017060501703Sign · looseEMERGENCY EXIT SIGN FELL OFF AT ROW 29. SECURED THE EMERGENCY EXIT SIGN COVER AT ROW 29SDR CALA2017060501693Lamp · inoperativeEMERGENCY LIGHT AT LAV 104, INOPERATIVE. REPLACED THE LAMP. OPS NORMAL.SDR CALA2017060501708Sign · detachedEMERGENCY EXIT SIGN OVER THE L2 DOOR FELL OFF. ATTACHED THE SIGN.SDR CALA2017060501707Lamp · inoperativeEXT EMERGENCY LIGHT INOPERATIVE AT DOOR 2 RIGHT. REPLACED THE LAMPS IAW AMM 33-51-06SDR QXEA2017060500405Circuit Breaker · openCABIN EMERGENCY LIGHTS COME ON WITH FLIGHT DECK SWITCH IN ARM POSITION. FOUND CIRCUIT BREAKER E3 LEFT DC MAIN EMERGENCY LIGHTS RELAY OPEN. RESET THE CIRCUIT BREAKER IAW GPM 9-2-2-1. PERFORMED OPERATIONAL CHECK OF EMERGENCY LIGHTS SYS IAW AMM TASK 33-51-00-7SDR JJBA20170605004Battery Pack · dischargedEMERGENCY LIGHTS WILL NOT ILLUMINATE. CHARGED THE BATTERIES. OPS CHECKED GOOD.SDR MASA2017060512351Battery Pack · inoperativeLT AND RT OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED THE NR 1 AND 2 EMERGENCY BATTERY PACKS.SDR MASA2017060512349Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 13 INOPERATIVE.SDR SWAA2017061214258Lens · looseL1 DOOR EXIT LENS COVER LOOSE. SECURED LENS IAW EA.SDR AALA201706069020Sign · missingTHE AIRCRAFT WAS NOT GROUNDED. EXIT SIGN LT ADJACENT FWD GALLEY TRASH BIN IS MISSING (R1 DOOR). REPLACED R1 DOOR EXIT IDENTIFIER PER AMM 33-50-00, OPS NORMAL.SDR AALA201706069019Light · brokenTHE AIRCRAFT WAS NOT GROUNDED. R4 DOOR EMERGENCY EXIT LIGHT IS BROKEN. REMOVED & REPLACED THE R4 EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-01. OPS CHECKS NORMAL.SDR AALA201706059007Lens · brokenEMERGENCY LIGHT PLASTIC COVER FOUND BROKEN ON THE L2 DOOR. REPLACED THE LENS.SDR AALA201706089018Lens · looseR4 DOOR EMERGENCY EXIT LIGHT LENS LOOSE. INSTALLED THE LENS.SDR SIMA20170604001Light · inoperativeRIGHT SIDE AFT EMERGENCY EXTERIOR LIGHT INOPERATIVE. REMOVED AND REPLACED THE RT AFT EMERGENCY EXTERIOR LIGHT IAW STANDARD MAINTENANCE PRACTICES. OPS CHECKED GOOD IAW AMM 35-51-15.SDR SWAA2017060714208Lens · looseR1 DOOR EMERGENCY LIGHT LENS JUST FORWARD LOOSE. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2017060714202Sign · unsecureRT EMERGENCY EXIT DOOR SIGN FELL OFF. R&R LIGHT ASSEMBLY PER MM.SDR YENA201706040463Battery · failedAFT LEFT EPSU BATTERY FAULTED. R & R THE BATTERY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR SIMA20170604002Power Supply · failedCOCKPIT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY BATTERY AND CHARGER IAW AMM TASK# 33-50-04-000-802-A, 33-50-04-400-802-A, 33-50-04-000-801-A, AND 33-50-04-400-801-A. OPS CHECKED GOOD.
Back to JASC 3350