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 SWAA2017121318433Sign · brokenMID CABIN OVERWING EXIT SIGN BROKEN. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2017121318415Light · inoperativeRT FORWARD EMERGENCY AISLE LIGHT INOP. R&R LIGHT PER AMM.SDR MASA2017121312828Battery Pack · inoperativeFWD LEFT & RIGHT EXT EMERG OVERWING LIGHTS INOP. REPLACED BATTERY AND CHARGERSDR SWAA2017121818504Battery Pack · inoperativeFORWARD ENTRY EXIT LOCATOR EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR AALA20171213007Sign · inoperativeDURING MAINTENANCE FOUND LEFT EXIT IDENTIFIER SIGN AT DOOR 1L INOPERATIVE. REPLACED LEFT EXIT SIGN/LIGHT IAW AMM 33-51-03.SDR AALA201712159002Charger · no testAIRCRAFT WAS NOT GROUNDED: BATTERY PACK FOR EMERGENCY LIGHTS IN FIRST CLASS NOT TESTING. MAINTENANCE REPLACED CHARGER AND PERFORMED SUCCESSFUL OPERATIONAL CHECK.SDR AALA201712139025Sign · intermittentAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT EMERGENCY EXIT SIGN FLASHED ON AND OFF INTERMITTENTLY AT 3L DOOR. MAINTENANCE RESET EMERGENCY LIGHT SYSTEM PER 33-51-10 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201712139024Cover · missingAIRCRAFT WAS NOT GROUNDED: MISSING EMERGENCY PATH LIGHTING COVER AT SEAT 30C. MAINTENANCE REPLACED EMERGENCY LIGHTING COVER AT PASSENGER ROW 30ABC AND PERFORMED SUCCESSFUL OPERATIONAL CHECK.SDR AALA20171212001Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: BATTERY PACK FOR EMERGENCY LIGHTS IN FIRST CLASS NOT TESTING. MAINTENANCE REPLACED POWER SUPPLY BATTERY PACK AND PERFORMED SUCCESSFUL OPERATIONAL CHECK.SDR IPXA2017121324503Battery · dischargedINSPECTION TYPE:N/AEMERGENCY LIGHT LEFT BTRY 1 LOW MSG ON DURING TESTREPLACED BTRY PACK NO HELP ALL LIGHTS WORK PLACE TEST FUNCTION INOP PER MEL 33-50-2. C/W DMP 33-50-2. MM33-51-01-4.SDR U2RA201712120001Battery Pack · no testDURING ACCOMPLISHMENT OF SCHEDULED MAINTENANCE TASK FOUND EMERGENCY ISLE LIGHTS AND CEILING EMERGENCY EXIT SIGN LIGHTS IN ZONE WOULD NOT TEST. REMOVED AND REPLACED POWER SUPPLY BATTERY PACK IAW AMM 33-51-07. EMERGENCY EXIT LIGHTS OPS CHECKED GOOD.SDR AALA201712139023Lens · missingAIRCRAFT WAS NOT GROUNDED: MISSING EXIT LIGHT LENS AT L4 DOOR. MAINTENANCE REPLACED LENS AS REQUIRED AND PERFORMED SUCCESSFUL OPERATIONAL CHECK.SDR AALA201712139022Lens · brokenAIRCRAFT WAS NOT GROUNDED: BROKEN EXIT LIGHT LENS AT L1 DOOR. MAINTENANCE REPLACED LENS AS REQUIRED AND PERFORMED SUCCESSFUL OPERATIONAL CHECK.SDR AALA201712139021Cover · missingAIRCRAFT WAS NOT GROUNDED: MISSING EMERGENCY EXIT LIGHT COVER AT 4L. MAINTENANCE REPLACED LENS AT EXIT 4L.SDR AALA201712149037Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT 3E MISSING LENS FOR EMERGENCY ESCAPE PATH LIGHTING. INSTALLED LENS EMERGENCY ESCAPE PATH PER AMM 33-51-11.SDR AALA201712149036Lens · missingAIRCRAFT WAS NOT GROUNDED. DURING A-CHECK THERE WAS ONE MISSING EMERGENCY LIGHT LENS ON THE CEILING ABOVE ROW 18. REPLACED MISSING EMERGENCY LIGHT LENS PER AMM 33-51-00.SDR DALA2017121308605Light · broken(AIRCRAFT 5809, L/P 4134764) 22E EMERGENCY LIGHT ASILE ILLUMINATION SUPPORT BROKEN. REPLACED EMERGENCY LIGHT ASSY AT SEAT 22E PER B757 AMM 33-51.SDR DALA2017121308604Lens · loose(AIRCRAFT 6700, L/P 0336261) EMERGENCY EXIT SIGN COVER LOOSE / LOCATIONS:604. RE-SECURED EMER EXIT SIGN COVER AS NECESSARY.SDR AALA201712139011Sign · detachedAIRCRAFT NOT GROUNDED. 2R DOOR EXIT SIGN FELL OFF. REINSTALLED EMERGENCY EXIT SIGN AT 2R DOOR PER MM 33-51-01. OPERATIONS CHECK NORMAL.SDR AALA201712139013Power Supply · faultyAIRCRAFT WAS NOT GROUNDED. AFT GALLEY ENTRY & R4 DOOR EMERGENCY LIGHT WILL NOT STAY ON PAST 5 SEC. REPLACED POWER SUPPLY PER AMM 33-51-07.SDR CALA2017121304422Light · brokenEMERGENCY EXIT LIGHT BROKEN AT AISLE 15 ABC. REMOVED AND REPLACED AISLE 15 ABC SEAT ROW LIGHT ASSY REF MM 33-51-11. VERIFIED REPLACEMENT EMERGENCY LIGHT ASSY ON ROW 15 ABC. OPS CHECK GOOD.SDR CALA2017121304421Charger · inoperativeEMERGENCY LIGHTS AT ROW 20 ABC OUT, REQUIRES BATTERY CHARGER. REPLACED BATTERY CHARGER AT 33-51-06-96-806 OPS CK GOOD.SDR SIMA20171212002Charger · inoperativeRH FWD OVERWING EMERG, AND OVRHD ISILE EMERG LIGHTS ARE OUT.-C/A-REMOVED AND REPLACED #2 EMER POWER SUPPLY AND CHARGER IAW EMB-145 AMM 33-50-04. OPS CHK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 105196SDR AALA201712139010Lens · missingAIRCRAFT NOT GROUNDED. EXIT SIGN COVER BY1R SERVICE DOOR IS MISSING. REPLACED EXIT SIGN ASSEMBLY AND COVER AT 1R DOOR PER MM 33-51-01.SDR AALA201712139009Battery Pack · inoperativeAIRCRAFT NOT GROUNDED. R1 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK M1674 AT FORWARD GALLEY CEILING CENTER RIGHT SIDE PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201712139006Power Supply · failedAIRCRAFT NOT GROUNDED. EMERGENCY LIGHTS POWER SUPPLY FAILED DURING L2 SLIDE CHANGE. REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38.SDR DALA2017121308556Power Supply · no testDURING ESPU SYSTEM TEST, FAULTED ESCAPE SLIDE LIGHT (17WL) DOOR 4. REPLACED DOOR 4L SLIDE. LP 9837855.SDR CALA2017121204412Lens · missingEMERGENCY LAMP PLASTIC LENS MISSING COVER AT CLOSET AFT SIDE NEAR SEAT 1,B. REPLACED LENS COVER. EMERGENCY LIGHTING OPERATES NORMALLY .SDR CALA2017121204411Power Supply · inoperativeRIGHT AFT OVERWING EXIT EXTERNAL EMERGENCY EXIT LIGHT AND THE RIGHT GROUND ILLUMINATION EMERGENCY LIGHT AFT OF THE WING ARE INOP. REMOVED AND REPLACED POWER SUPPLY FOR EMERGENCY EXIT LIGHTS AT APPROX STA 727. OPS CHECK GOOD. REF AMM 33-51-06-960-806.SDR CALA2017121204410Fuse · blownEMERGENCY EXIT LIGHTS (SEAT MOUNTED) INOP ROWS 27 TO 31. REPLACED BLOWN FUSE ON BATTERY PACK M1670. OPS CHECK GOOD.SDR CALA2017121204408Sign · unsecureEMERGENCY EXIT SIGN DANGLING FROM THE CEILING IN OVERWING POSITION. REINSTALLED EXIT SIGN.SDR CALA2017121204407Sign · unsecureEMERG EXIT ROW SIGN A/C RIGHT FALLING OFF. RESECURED EMERG EXIT ROW SIGN, NO DEFECTS NOTED.SDR CALA2017121204406Battery Pack · faultyEMER EXIT LIGHT DOOR 1L BLINKING. REPLACED BATTERY PACK M1557. OP CK GOOD.SDR CALA2017121204405Cam · missingCAM ASSY FOR EMERG EXIT LIGHT SIGN BAR IS MISSING AT DOOR 3R. INSTALLED NEW CAM ASSY FOR EMERG EXIT LIGHT SIGN ON DOOR 3R, EMERG EXIT LIGHT SIGN SECURED.SDR AALA201712139014Cover · missingAIRCRAFT WAS NOT GROUNDED. EXIT SIGN LIGHT COVER MISSING FROM RIGHT SIDE AFT CABIN DOOR. REPLACED EXIT SIGN IDENTIFIER AT RT AFT CABIN DOOR PER AMM 33-51-01.SDR REXA2017121101244Bulb · burned outAFT FACE OF CREW STORAGE FLOOD LIGHT BULBS BURNT OUT.
CONNECTED P337 TO J337 BEHIND GALLEY G2, RELAMPED D85515 AND D5159
FLOOR LEVEL EMERGANCY FLOOD LIGHTS. OPERATIONAL TEST OF THE FLOOR
LEVEL EMERGANCY FLOODLIGHTS CHECKS GOOD IAW CRJ900 AMM 33-51-11SDR R61A201712110946Light · missingLUMINESCENT LIGHT STRIP MISSING ON FLOOR NEAR SEAT 1A. REALIGNED LUMINESCENT STRIP IAW AMM 33-50-21. OPS CHECK GOOD.SDR AALA201712139031Charger · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS AT FIRST CLASS DID NOT TURN OFF AFTER POWER SHUT DOWN. MAINTENANCE REPLACED BATTERY CHARGER (CONTROL MODULE) PER AMM 33-51-07 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20171211007Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS AT FIRST CLASS DID NOT TURN OFF AFTER POWER SHUT DOWN. MAINTENANCE REPLACED BATTERY PER AMM 33-51-07 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201712139018Battery · faultedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY (11WL) FAULT PRESENT ON EMERGENCY LIGHTING SYSTEM TEST. REPLACED BATTERY PER AMM 33-51-38.SDR AALA201712139017Light · brokenAIRCRAFT WAS NOT GROUNDED. DURING WALK AROUND FOUND R1 DOOR EMERGENCY EXIT LIGHT BROKEN. REPLACED CABIN WALL-MOUNTED EMERGENCY EXIT LIGHT PER AMM 33-51-13.SDR AALA201712129004Trim Panel · crackedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT LOCATED AT DOOR 1L ON LEFT FLOOR BOTTOM HAS CRACKED TRIM. LED STRIP WITH WIRES EXPOSED. REPLACED EMERGENCY LIGHT.SDR AALA201712139008Battery Pack · inoperativeAIRCRAFT NOT GROUNDED. FIRST CLASS EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK M1674 AT FORWARD GALLEY CEILING CENTER RIGHT SIDE PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR UIEA2017121302397Sign · dislodgedEMERGENCY EXIT SIGN AT L1 DOOR FELL DOWN OFF LINER.(<DIV>FOUND EXIT SIGN ATTACH BRACKET DISCONNECTED. RE-ATTACHED MOUNT BRACKET ON INSTALLED LIGHT ASSY AS PER AMM 33-51-01. OPS CHK OK</DIV>)SDR AALA201712129055Light · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT GUIDE LIGHT MISSING AT 1R CLOSET (FLOOR LEVEL). SECURED GUIDE LIGHT AT 1R CLOSET. OK FOR SERVICE PER MM 33-51-01.SDR AALA201712129050Light · inoperativeAIRCRAFT WAS NOT GROUNDED. LIGHT BULBS INOPERATIVE, EMERGENCY EXIT LIGHTS NOT ARMED, AND EQUIPMENT COOLING SUPPLY OFF. RELAMPED OVERHEAD EMERGENCY LIGHT AND EQUIPMENT COOLING LIGHT PER MM 33-10-00.SDR AALA201712129017Light · damagedAIRCRAFT WAS NOT GROUNDED. DURING INTERIOR CABIN CHECK, AFT LEFT EXIT LIGHT ASSEMBLY, WAS FOUND DAMAGED. REPLACED EXIT LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR DALA2017121108541Receptacle · defectiveEMERGENCY LIGHTS AT ROW 33-41FG ARE INOPERATIVE. MAINTENANCE REPLACED M9010 BATTERY RECEPTACLE. SYSTEM OPERATION IS NORMALSDR SIMA20171211005Lamp · inoperativeSERVICE DOOR EMERGENCY LT INOP-C/A-REMOVED AND REPLACED SERVICE DOOR EMERGENCY LAMP IN REFERENCE WITH EMB AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. NO FURTHER DISCREPANCIES FOUND. END.SDR SIMA20171211004Battery Pack · inoperativeBOTH EXTERIOR OVERWING EMERGENCY LTS INOP-C/A-REMOVED AND REPLACED #4 EMERGENCY BATTERY AND POWER SUPPLY IAW ENVOY W/C 33-700-19 AND 33-700-17 OPS CHECK GOOD. BATTERY CHARGER ASSY P/N 11-0049 S/N 12701
Back to JASC 3350