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 AALA201712219032Shroud · damagedROWS 8C, 9C, 10C, 11C, 12C AND 13C EMERGENCY LIGHT SHROUDS DAMAGED. MAINTENACE REPLACED SHROUDS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201712219031Shroud · damagedROWS 8C, 9C, 10C, 11C, 12C AND 13C EMERGENCY LIGHT SHROUDS DAMAGED. MAINTENACE REPLACED SHROUDS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201712219030Shroud · damagedAIRCRAFT WAS NOT GROUNDED: ROWS 8C, 9C, 10C, 11C, 12C AND 13C EMERGENCY LIGHT SHROUDS DAMAGED. MAINTENACE REPLACED THE SHROUDS AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201712219008Shroud · damagedROWS 8C, 9C, 10C, 11C, 12C AND 13C EMERGENCY LIGHT SHROUDS DAMAGED. MAINTENACE REPLACED EMERGENCY LIGHT SHROUDS AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201712219017Power Supply · inoperativeFLIGHT DECK EMERGENCY LIGHT INOPERATIVE. REPLACED POWER UNIT. AIRCRAFT WAS GROUNDED.SDR AALA20171220001Light · missingFOUND SEAT 3A AFT EMERGENCY LIGHT ASSEMBLY MISSING FROM SEAT. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-19.SDR ASAA2017121922958Lens · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN ADJACENT TO L-1 DOOR HAS BROKEN LENS. GROUNDED - YES. REMOVED AND REPLACED LENS AND TESTED LIGHT ASSY PER MM 33-51-01-960-801 - OPS NORMAL.SDR Q2SA20171219386Light · inoperativeAIRCRAFT GROUNDED. FOUND DURING WALK AROUND EMERGENCY LIGHT ON L1 DOOR INOP. MX REPLACED EMERGENCY BULB. SYSTEM OPS CHECKED GOOD.SDR SWAA2017122018572Lens · looseCEILING OVERWING EMERGENCY EXIT SIGN LENS LOOSE. SECURED LENS PER MM.SDR DALA2017122008766Light · inoperativeSEAT AISLE TRIM DAMAGED AND STICKING OUT IN AISLE AROUND 14D. THE EMERGENCY LIGHT FOUND INOPERATIVE ON AISLE, RED LIGHT CHECKED OK. REPLACED THE AISLE TRIM AND EMERGENCY LIGHT IAW AMM 25-20.SDR HNAA2017122000397Bulb · inoperativeFORWARD GALLEY EMERGENCY LIGHT OUT. R & R THE BULB ANDS SECURED THE COVERSDR DALA2017122008760Power Supply · inoperativeDURING SVC CHECK FOUND EXIT SIGN AT 2L DOOR, AFT STAIR DOOR, AND SEVERAL TAIL COMP EXIT LIGHT INOP. FOUND BATTERY PACK AND POWER SUPPLY B5-212 IN AFT RIGHT OVERHEAD BIN TO HAVE A STRONG BURNT ODOR. REPLACED B5-212 POWER SUPPLY.SDR DALA2017122008761Power Supply · brokenAFT CABIN FOUND EMERG LIGHT POWER SUPPLY B5-27 IN AFT RT LAV HAD A BROKEN TERMINAL BLOCK. REPLACED POWER SUPPLY AMM 33-53.SDR SWAA2017121918567Light · inoperativeOVERHEAD FORWARD ENTRY DOOR EMERGENCY EXIT LIGHT INOP. REPAIRED LIGHT PER MM.SDR SWAA2017121918557Lens · crackedCEILING EMERGENCY LIGHT LENS COVER CRACKED. R&R LENS PER MM.SDR N6WA20171219001Bulb · inoperativeLEFT EMERGENCY EXIT LIGHT INOPERATIVE. ONE BULB INOPERATIVE.SDR DALA2017122008754Lens · detachedDURING INSPECTION, FOUND OVERHEAD EXIT SIGN BY WINGS, DETACHED. MAINTENANCE REINSTALLED THE EXIT SIGN LENS.SDR SIMA20171219001Light · inoperativeFOUND RT OVERWING EMERGENCY LIGHT TO BE INOP DURING PS-1 CHECK. R&R RT OVERWING EMERGENCY LIGHT BULB IAW AMM 33-50-07-04. OPS CHECK GOOD.SDR SIMA20171219002Light · inoperativeDURING PS-1 FOUND EMER PATH LIGHTING STRIP BETWEEN ROWS 5 AND 7 INOP. R&R FLOOR PROXIMITY STRIP LIGHT IAW AMM 33-50-12, OPS CHECK GOOD.SDR CALA2017121904521Light · brokenSEAT ROW 9ABC AISLE SEAT MOUNTED EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED SEAT ROW 9ABC AISLE SEAT MOUNTED EMERGENCY EXIT LIGHT ASSY REF MM 33-51-11 VERIFIED INSTALLATION AND OPERATION EMERGENCY EXIT LIGHT ROW 9ABC.SDR CALA2017121904534Power Supply · faultyWHILE PERFORMING EMER LIGHT BAT TEST, RECEIVED "EPSU EXT LOAD EMER R". T/S TO EPSU. RMVD BOTH OVERWING EXIT EPSU BAT AND RESET. SWAPPED AND EXT LIGHT FAULT FOLLOWED ESPU. RPLD RIGHT OVERWING ESPU SYSTEM CHKS GOOD. REF TSM 33-51-00,AMM 33-51-38, 25-62-42.SDR CALA2017121904532Cover · brokenEMERGENCY LITE COVER ON AFT SIDE OF 1L CLOSET IS BROKEN. REPLACED FWD COAT CLOSET AFT EMERGENCY EXIT LIGHT ASSEMBLY OPS CHECKED NORMAL.SDR CALA2017121904529Lens · brokenEMERGENCY FLOOR PROXIMITY LIGHT COVER BROKEN AT FIRST CLASS CLOSET. REPLACED LIGHT LENS ON FWD COAT CLOSET PATH LIGHT. OK FOR SERVICE.SDR CALA2017121904528Battery Pack · dischargedLT OVERWING EMERGENCY EXIT LIGHTS INOP. REPLACED LT OVERWING EMERGENCY LIGHTS BATTERY PACK IAW AMM 33-51 -06, OPS CHECK IAW AMM 33-51-00 NORMAL, SYSTEM OK.SDR CALA2017121904527Battery Pack · dischargedRT OVERWING EMERGENCY EXIT LIGHTS INOP. REPLACED RT OVERWING EMERGENCY LIGHTS BATTERY PACK IAW AMM 33-51 -06, OPS CHECK IAW AMM 33-51-00 NORMAL, SYSTEM OK.SDR CALA2017121904526Lens · looseCREW REPORTED, EMERGENCY EXIT LIGHT LENS AT L2 DOOR FELL OFF. REPLACED LENS, EMERGENCY EXIT LIGHT AT L2 DOOR OPS CHECK NORMAL.SDR CALA2017121904525Light · brokenDURING CHECK THE EMERGENCY LIGHT FIND THAT THE DOOR 1 CENTER FROM RIGHT FLOOR PROXIMITY LIGHT DAMAGED. REPLACED THE CABIN DOOR NR 1 CENTER RIGHT FLOOR PROXIMITY LIGHT AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-05-960-80 2 REV 81.SDR MASA2017121912844Light · inoperativeCEILING LEVEL EMER LIGHT INOP. PLACED ON MEL.SDR HALA2017121908762Power Supply · no testR4 DOOR SLIDE LIGHT EPSU FAILED SELF TEST WITH EXTERIOR LED RED LIGHT ILLUMINATED. REPLACED THE SLIDE IAW 2561-9403.SDR DALA2017121908744Sign · inoperativeCOCKPIT EXIT SIGN ASSEMBLY INOPERATIVE DURING SERVICE CHECK. REPLACED THE SIGN.SDR AALA201712209013Power Supply · no testEMERGENCY LIGHTS FAILED A SYSTEM TEST. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT 13WL IAW AMM 33-51-38 AND PERFORMED SUCCESSFUL OPERATIONAL CHECK.SDR ASOA201712217033Battery Pack · dischargedFLOOR EMERGENCY LIGHT STRIPS INOP. REMOVED AND REPLACED EMERGENCY BATTERY PACK NR 3 IAW AMM 33-50-04 AND IPC 33-50-04 ITEM 30 FIG 01. OPS CHECKED GOOD.SDR AALA201712199029Sign · detachedAIRCRAFT WAS NOT GROUNDED. OVERHEAD EMERGENCY EXIT SIGN OVER LEFT HAND AISLE FORWARD OF DOOR 2L IS PARTIALLY DETACHED. REPLACED EXIT SIGN PER AMM 33-51-01. OPERATIONAL CHECK OK.SDR SWAA2017122018585Lens · crackedFORWARD ENTRY THRESHOLD EMERGENCY LIGHT LENS COVER CRACKED. R&R COVER PER SIP.SDR DALA2017121908763Lamp · inoperativeWHITE EMERGENCY LIGHTING ON SEAT 30AB INOPERATIVE. REPLACED THE LAMPS.SDR DALA2017122008767Power Supply · inoperativeEMERGENCY EXIT LIGHT FLOOR LEVEL AT THE R1 DOOR WAS ILLUMINATED DURING TAXI. RESET CIDS 1 AND 2, AND REPLACED EPSU, AND SWAPPED WIRES AT 7218VSA7B AND D & E.SDR SWAA2017121918543Lens · brokenR1 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2017121918542Cover · brokenEXTERIOR OVERWING EMERGENCY EXIT SIGN COVER BROKEN. REPAIRED THE COVER IAW AMM.SDR DALA2017121908718Bulb · inoperativeNUMERIOUS EMERGENCY LIGHTS IN THE OVERHEAD CABIN INOPERATIVE. REPLACED THE BULBS.SDR AALA201712199020Lens · brokenAIRCRAFT WAS GROUNDED. EXIT SIGN LENS ABOVE R2 DOOR IS BROKEN. REPLACED EMERGENCY EXIT OVERHEAD SIGN.SDR FDEA201712183406Warning Message · illuminatedDURING A PREFLIGHT CHECK OF EMERGENCY LIGHTS, EMERGENCY LIGHT BATTERY 1 LOW MESSAGE DISPLAYED.SDR DALA2017121908710Light · unsecureEMERGENCY LIGHT AT SEAT 49 DEF IS LOOSE FROM SEAT. SECURED THE LIGHT, OPS NORMAL.SDR AALA201712199028Light · inoperativeAIRCRAFT WAS GROUNDED. R1 DOOR LIGHT INDICATION INOPERATIVE. REPLACED THE LIGHT. OPS CHECKED OK IAW AMM 33-50-00.SDR QXEA2017121900705Lens · separatedEMERGENCY LIGHT STRIP PLASTIC LENS SEPARATED FROM LIGHT. REMOVED FROM SERVICE. REMOVED DAMAGED LIGHT STRIP, REPLACED WITH NEW. OPS CHECKED GOOD. AIRCRAFT RETURNED TO SERVICE.SDR AALA201712199025Lens · missingFORWARD BULKHEAD LEFT INBOARD EDGE EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS. OPS CHECKED GOOD.SDR AALA201712199024Lens · brokenEMERGENCY LIGHT LENS BROKEN THE FORWARD CABIN IN WALL BETWEEN FORWARD GALLEY AND FIRST CLASS. REPLACED THE LENS. OPS CHECKED GOOD.SDR 29GA2017121900001Circuit Breaker · failedFLIGHT ATTENDANT UNABLE TO OPERATE EMERGENCY LIGHTS. COCKPIT EMERGENCY LIGHT SWITCH OPERATES PROPERLY. R & R THE L8 CIRCUIT BREAKER IAW AMM 39-10-42-02 AND AFT EMERGENCY PWR SUPPLY IAW AMM 33-50-10-04-01 OPS CHECK GOOD IAW SAAB AMM 33-50-00.SDR SIMA20171218002Light · inoperativeEMERGENCY LIGHT AT ROW 6 - 7A INOPERATIVE.SDR CALA2017121804520Lamp · inoperative4R SLIDE LIGHT INOPERATIVE. RELAMPED, OP OK.SDR CALA2017121804515Lamp · inoperativeEMERGENCY LIGHTS UNARMED 1/2 LIGHT INOPERATIVE. RELAMPED OPS CK OK.
Back to JASC 3350