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 ASAA2019030828569Epsu · failedEMERGENCY LIGHT ON L1 AND R1 DOOR INOP GROUNDED - YES. REMOVED AND REPLACED EPSU 10WL WITH NEW BATT. IAW AMM 33-51-38 , UNIT BITE TEST OK. PERFORMED EPSU SYS TEST , TEST OK. NO FAULT NOTED. ALL EMER. LIGHTS COMES ON. NO FAULT NOTED, OPS CHECK GOOD.PSU P/N OFFSDR ASAA2019030828568Epsu · failedROW 6,9,25 CEILING EMERGENCY LIGHTS INOP GROUNDED - YES. FOUND EPSU 12WL UNIT FAULT. REMOVED AND REPLACED EPSU 12WL IAW AMM 33-51-38. UNIT BITE TEST OK. PERFORMED EPSU SYS TEST. TEST OK. NO FAULT NOTED. ROWS 6,9, AND 25 CEILING EMER. LIGHTS OPS CHECK GOOD.SDR ASAA2019030828557Light · unsecureMID CABIN EXIT SIGN/LIGHT HANGING FROM CEILING. GROUNDED - YES. RESECURED MID CABIN EXIT LIGHT AS REQUIRED OPS CHECK LIGHT PER AMM TASK 33-51-00 OPS NORMAL.SDR DALA2019031001602Sign · missingTHE 1R DOOR EXIT SIGN IS MISSING. MAINTENANCE REINSTALLED THE LENS. (LP #5548399)SDR SIMA20190308002Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP. C/A-RAR SERVICE DOOR EMERGENCY DOOR LIGHT LAMP IAW 33-50-10-000-801-A AND 33-50-10-400-801-A. OPS CHECK GOOD.SDR AALA2019031199003Lens · missingAFT RIGHT GALLEY EMERGENCY EXIT SIGN LENS WAS MISSING. MAINTENANCE REPLACED THE SIGN LENS IAW 33-51-01.SDR DALA2019030801580Battery Pack · discharged(LOG 5343432) DURING INSPECTION FOUND EMERGENCY LIGHTS TEST FOUND RT EXTERIOR LTS INOPERATIVE. RPLD FUSE AND BATTERY FOR PACK M1671. ALL LIGHTS NOW OP CK GOOD PER AMM 33-51.SDR AALA2019031199010Battery Pack · faultedMAINTENANCE FOUND THE R1 DOOR AREA EMERGENCY LIGHT INOPERATIVE. FOUND THE BATTERY PACK FAULTY. REPLACED BATTERY PACK, OPS CHECKED OK IAW AMM 33-51-06SDR AALA2019031108001Battery Pack · inoperativeMAINTENANCE FOUND THE R1 DOOR AREA, EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE BATTERY PACK. OPS CHECKED GOOD IAW AMM 33-51-06.SDR SWAA2019031130524Lens · looseMID CABIN OVHD EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR QXEA2019031100109Light · looseFLOOR STRIP AT 2D/E COMING UP. REMOVED FROM SERVICE. RESECURED FLUORESCENT STRIP @ 2DE WITH TAPE AS REQUIRED. RETURNED TO SERVICE.SDR QXEA2019031100108Light · looseFLORESCENT FLOOR STRIP IN FRONT OF 1B LOOSE. REMOVED FROM SERVICE. RESECURED FLORESCENT FLOOR STRIP IN FRONT OF 1B AS REQUIRED. NO OTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR HNAA2019030900066Light · inoperativeNDIS 649 33-51 0003390 08MAR19 SBY CLOSE LT OVERWING EMERGENCY LIGHT INOP. FACT 08MAR19 10:27 SBY REMOVED AND REPLACED EMERGENCY LIGHT ON LT OVERWING POSITION OPS CHECK GOOD OK FOR SERVICE PART INSTALLED/REMOVED LAMP 1317.SDR DALA2019030800083Charger · inoperativeDURING SERVICE CHECK, 2 UPPER AISLE EMERGENCY LIGHTS WERE INOPERATIVE. REPLACED BATTERY CHARGER M737. LP 5599859SDR SWAA2019030830470Light · inoperativeL2 DOOR EMERGENCY EXIT LIGHT AT LOWER EDGE OF DOOR CUTOUT BULB INOP AT UPPERMOST LOCATION. R&R LAMP PER AMM.SDR VNAA2019100271101Battery Pack · inoperativeEMERGENCY LIGHTS INOP AT OVERWING EMERG EXITS. REMOVED AND REPLACE EMERGENCY BATTERY PACK #4 IAW CRJ 900 AMM 33-51-17-000/400-801-A04. OPS CHECK GOODSDR UIEA2019030803501Guard · defectiveGUARD FOR EMERGENCY LIGHT SWITCH OVERHEAD P5 PANEL INOP (<P>TRANSFERRED TO MDDR 108362 AS PER DDG 25-20-01 NEF FLIGHT DECK (NEW NEF). </P><P>LP 1051442-M3: REMOVED AND REPLACED EMERGENCY LIGHTS GUARD SWITCH ASSEMBLY IAW
AMM 33-51-08. THIS CLEARS MDDR 10836SDR SWAA2019031330566Battery Pack · defectiveRT SIDE AFT OF COCKPIT DOOR EMERGENCY BATTERY PACK M1674 WILL NOT CHARGE. R&R BATTERY PACK PER AMM.SDR SWAA2019031230539Power Supply · inoperativeEMERGENCY EXIT LIGHTS INOP AT LOCATION M1669. R&R POWER SUPPLY IAW AMM.SDR SWAA2019031230484Guard · brokenAFT FLIGHT ATTENDANT CONTROL PANEL EMERGENCY LIGHT SWITCH GUARD SPRING BROKEN. R&R SWITCH GUARD PER AMM.SDR SWAA2019031230479Power Supply · inoperativeEMERGENCY EXIT LIGHTS INOP AT LOCATION M1668. R&R POWER SUPPLY IAW AMM.SDR DALA2019030801564Lens · crackedDURING C3 CHECK, EMERGENCY LIGHT LENS ASSEMBLY CRACKED AT EXTERIOR OF OFCRE AND A4 GALLEY. REPLACED EMERGENCY LIGHT LENS ASSEMBLY. LP 0973670SDR SWAA2019031130537Sign · unsecureAFT GALLEY EXIT SIGN FELL OFF. REINSTALLED EXIT SIGN PER MM.SDR SWAA2019030830472Battery · failedEMERGENCY EXIT LIGHT BATTERY M1675 FAILED CAPACITY TEST. R&R BATTERY IAW AMM.SDR SWAA2019030830467Light · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR IPXA2019030839818Warning System · false activationINSPECTION TYPE:N/A EICAS MESSAGE:EMER LIGHTS WITH LIGHT SWITCH ARMED OR OFF. OP'S CHK'D EMER LIGHT SYSTEM PER MM 33-51-00/501. OP'S GOOD AT THIS TIME, GOOD FOR SVC.SDR MASA2019030711747Battery Pack · dischargedROW 14 BOTH FLOOR LVL EXIT SIGNS INOP. R&R BATT PACK 4.SDR VNAA2019030611101Light · inoperativeR/H AFT EXTERIOR EMERGENCY LIGHT DOES NOT ILLUMINATE. RR RH AFT EXTERIOR EMERGENCY LIGHT IAW CRJ 700 AMM 33-51-15-000/400-801 OPS CHECK GOOD AT THIS TIMESDR SWAA2019032130902Lens · missingLT EMERGENCY STOWBIN LIGHT LENS MISSING AT ROW 22. R&R LENS COVER IAW MM.SDR SWAA2019031230516Battery Pack · dischargedLT BULLNOSE EMERGENCY EXIT AISLE LIGHTS INOP BETWEEN ROW 6 TO ROW 14. R&R BATTERY PACK PER AMM.SDR DALA2019030601594Lens · missingSHIP 5806 EMERGENCY EXIT LIGHT LENS MISSING AT DOOR R1. CORRECTIVE ACTION: LOCATED AND INSTALLED NEW LENS. (5531976)SDR AALA201903116004Lamp · burned outMAINTENCE FOUND THE R2 EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED GOOD IAW AMM 33-51-04-960-801.SDR DALA2019030801566Lens · missingEMERGENCY EXIT COVER DIFFUSER LENS MISSING. REPLACED LENS COVER. LP 0972574SDR DALA2019030800085Lens · missingEMERGENCY EXIT COVER DIFFUSER LENS MISSING. REPLACED EMERGENCY EXIT COVER DIFFUSER HOUSING. LP 0972483SDR 29GA2019030700002Sign · wornFLIGHT 7012 SJU/STX REPORT: EMERGENCY EXIT SIGN OVER FA SEAT RIGHT ARROW WORN. CORRECTIVE ACTION: REPLACED EMERGENCY EXIT SIGN OVER FA SEAT.SDR AALA201903079002Sign · inoperativeFLIGHT ATTENDANTS REPORTED NUMEROUS EMERGENCY EXIT SIGNS IN THE CABIN HAD INOPERATIVE BULBS. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE R2 DOOR SIGN IAW AMM 33-51-17 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201903079001Battery · inoperativeFLASHLIGHT STOPPED BLINKING. MAINTENANCE REPLACED THE BATTERY AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR HNAA2019030700062Light · inoperativeDISCREPANCY: DURING HVY CHK MAINTENANCE FOUND CABIN - THREE FLOOR ESCAPE PATH EMERGENCY LIGHTS AT ROW 11 WILL NOT ILLUMINATE. CORRECTIVE ACTION: REMOVED AND REPLACED CABIN FLOOR ESCAPE PATH EMERGENCY LIGHTS LAMPS WITH NEW ONESSDR SWAA2019030730408Light · inoperativeLT OVERWING EXIT EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2019030730406Cover · detachedL1 DOOR EMERGENCY EXIT LIGHT COVER DETACHED. R&R LIGHT ASSEMBLY COVER PER SIP.SDR HALA2019030700101Sign · unsecure3 L DOOR EXIT SIGN FELL OFF. A/C OK. RE-SECURED 3L DOOR EXIT SIGN LENS. OPS CHECK OK.SDR DALA2019030701518Light · inoperativeVENTRAL STAIRWAY EMERGENCY LIGHT OUT IN CEILING PANEL. RELAMPED CHECKS OK. (LP5758985)SDR QXEA2019030600102Light · looseEMERGENCY EGRESS LIGHT STRIP LOOSE IN FRONT OF TYPE II/III EMERGENCY EXIT. REMOVED FROM SERVICE. REINSTALLED EMERGENCY FLOOR PATH LIGHTING AT FWD EMERGENCY EXIT IAW AMM 33-51-16-400-801. OKAY FOR SERVICE. AIRCRAFT RETURNED TO SERVICE.SDR SWAA2019030630399Relay · inoperativeFORWARD GALLEY CENTER OVERHEAD EMERGENCY LIGHT INOP. R&R RELAY R47 PER SWPM.SDR SWAA2019030630366Relay · inoperativeAFT GALLEY CENTER OVERHEAD EMERGENCY LIGHT INOP. R&R RELAY R47 PER SWPM.SDR MASA2019030511746Light · inoperativeOVERWING LEFT FWD EXIT SIGN MULTIPLE BULBS INOPERATIVE. RELAMPED.SDR DALA2019030601486Battery · dischargedFWD OVERWAY EMER "EXIT INTERIOR LIGHTS LT & RT DO NOT ILLUM. R/R BATTERIES IN PACK FOR SAME. REF AMM 33-53. OPS CK GOOD. (LP5826648)SDR SIMA20190305020Light · damagedRT #8 EMERGENCY LIGHT EXTRUSION IS DAMAGED AND REQUIRES REPLACEMENT. C/A-COMPLETE:COMPLETED INSTALLED THE #8 RT EMERGENCY LIGHT STRIP EXTRUSION. IAW AMM 33-50-12.SDR SIMA20190305021Light · damagedRT #5 EMERGENCY LIGHT EXTRUSION IS DAMAGED AND REQUIRES REPLACEMENT. C/A-COMPLETE:COMPLETED INSTALLED THE #5 RT EMERGENCY LIGHT STRIP EXTRUSION. IAW AMM 33-50-12.SDR SIMA20190305018Light · damagedRT #6 EMERGENCY LIGHT EXTRUSION IS DAMAGED AND REQUIRES REPLACEMENT. C/A-COMPLETE:COMPLETED INSTALLED THE #6 RT EMERGENCY LIGHT STRIP EXTRUSION. IAW AMM 33-50-12.
Back to JASC 3350