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 SWAA2019122639935Power Supply · inoperativeR/H AFTER WING EMERGENCY ESCAPE LIGHTS INOP. R&R POWER SUPPLY M1670 IAW AMM.SDR SWAA2019122639916Power Supply · inoperativeL/H AFTER WING EMERGENCY ESCAPE LIGHTS INOP. R&R POWER SUPPLY M1670 IAW AMM.SDR SWAA2019122639915Sign · inoperativeL/H OVERWING EMERGENCY EXIT SIGNS UPPER AND LOWER POSITION INOP. ACCOMPLISHED DISCREPANCY ON N/R 2015426/ 1000/ 0148SDR SWAA2019122639914Power Supply · inoperativeL/H OVERWING EMERGENCY EXIT SIGNS UPPER AND LOWER POSITION INOP. R&R POWER SUPPLY PER AMM.SDR SWAA2019122639913Lamp · inoperativeL/H EMERGENCY OVERHEAD BINS LIGHTS INOP AT POSITIONS 6 TO 12. RELAMPED LIGHT PER AMM.SDR SWAA2019122649887Lens · brokenL/H EMERGENCY LIGHT COVER BROKEN UNDER L/H OVERWING EXIT. R&R COVER PER AMM.SDR REXA2019122621781Light · inoperativeRIGHT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-21. OPS CHECKED GOODSDR AALA2019122439015Battery · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS WHILE ACCOMPLISHING JOB CARD 33C20033002 FOUND BATT FAULT FOR 17WL EPSU. REPLACED 17WL EPSU BATT IAW AMM 33-51-38-401.SDR AALA2019122439018Connector · damagedAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS SEAT ROW 2EF EMERGENCY PATH LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED SEAT ROW 2EF EMERGENCY PATH LIGHTING CONNECTOR AT THE SIDEWALL IAW SWPM 20-42-01. OPS CHECKED GOOD.SDR AALA2019122439019Light · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS CEILING EMERGENCY LIGHT AT 3L DOOR INOP. REPLACED 3L DOOR CEILING EMERGENCY LIGHT IAW 33-51-00.SDR VNAA2019122321104Light · unknownEMERGENCY LIGHTS ARE NOT WORKING - C/W OPERATIONAL CHECK OF EMERGENCY LIGHTS. OPS CHECKS GOOD.SDR VNAA2019122321102Lens · missingEMERGENCY EXIT SIGN IN AISLE ABOVE EXIT ROW MISSING - REPLACED LIGHT COVER.SDR MASA2019122212200Battery Pack · inoperativeLAST 3 CEILING EMER LIGHTS INOPERATIVE. R & R NR 3 EMERGENCY BATTERY PACK.SDR MASA2019122212199Battery Pack · inoperativeRIGHT EMERGENCY EXIT LWR LIGHT INOPERATIVE. R & R THE NR 3 EMERGENCY BATTERY PACK.SDR MASA2019122212198Battery Pack · inoperativeLEFT EMERGENCY EXIT LWR/UPPR LIGHT INOPERATIVE. R & R THE NR 3 EMERGENCY BATTERY PACK.SDR MASA2019122212195Battery · dischargedALL EMERGENCY LIGHTS INOP- CHARGED BATTERIES WITH CREWSDR SWAA2019123069988Cover · brokenEMERGENCY EXIT LIGHT LENS BASE BROKEN AT R2 DOOR ON G4 GALLEY. R&R BASE COVER IAW AMM.SDR SWAA2019122639912Sign · damagedAFT L/H DOOR EXIT SIGN HOUSING DAMAGED AT LOWER FORWARD SIDE. R&R SIGN HOUSING PER AMM.SDR DALA2019122307519Light · inoperativeLLCR FWD EMERGENCY EXIT LIGHT INOPERATIVE, FOUND THE POWER TO LIGHT ASSY. NEEDS LIGHT ASSY FWD TO MEL 33-51-01D REPLACED LLCR LIGHT ASSY AT AFT CREW REST EXIT LIGHT IAW CMM 25-29-02.OK FOR SVC.SDR SWAA2019122339892Lens · brokenR2 DOOR ON G4 GALLEY EMERGENCY EXIT LIGHT LENS BASE BROKEN. SECURED THE LENS COVER TO BASE IAW EA.SDR SIMA201912231003Lamp · inoperativeFOUND RH EXTERNAL UPPER WING EMERGENCY LIGHT INOP.-C/A-REMOVED AND REPLACED RH EXTERNAL UPPER WING EMERGENCY LAMP IAW EMB AMM 33-50-10. OPC GOOD.SDR SIMA201912231004Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT LAMP IAW AMM 33-50-10-000-801-A AND 33-50-10-400-801-A NO FIX. T/S WIRES FOUND BROKEN WIRE. REPAIRED WIRE IAW SWPM 20-21-00 OPC GOOD. NO FURTHER DEFECTS NOTED.SDR JJBA201912231008Charger · inoperativeLEFT AND RIGHT HAND AFT OVER WING EMERGENCY LIGHT INOPERATIVE. TROUBLESHOT OVER WING EMERGENCY LIGHTS AND FOUND #4 BATTERY CHARGER ASSEMBLY INOPERATIVE. R&R #4 CHARGER ASSEMBLY. OPS CHECK SAT.SDR FDEA201912203274Light · inoperativeDURING SERVICE CHECK FOUND RT EXTERIOR EMERGENCY LIGHT INOP. SERVICED RIGHT EMERGENCY SLIDE LIGHT WITH NEW BULB P/N 767 AS PER MM 33-51-06-2-1. ALL TEST PASSED, MEL CLOSED.SDR SWAA2019122639890Lamp · inoperativeCEILING OVERWING EXIT SIGN HAD LAMPS OUT. RELAMPED SIGN IAW AMM.SDR N6WA20191224001Sign · inoperativeGALLEY AREA OVERHEAD EMERGENCY EXIT SIGNS NOT WORKING.SDR DALA201912237509Battery Pack · inoperativeFOUND OVERHEAD EMERGENCY LIGHTS AT SEATS 39 LEFT INOPERATIVE. REPLACED BATTERY PACK AT M739. SYSTEM OPS NORMAL.SDR DALA2019122317507Light · detachedEMERGENCY LIGHT UNDER SEAT 15D FELL OFF, SECURED THE EMERGENCY LIGHT ASSY.SDR DALA201912237494Battery Pack · inoperativeL2 DOOR EMERGENCY LIGHTS INOP. R&R BATTERY PACK PER AMM 33-51.SDR SIMA201912230003Light · damagedNUMEROUS FLOOR PATH LIGHT STRIP PROFILE PIECES ARE DAMAGED. EVALUATED AND RECIEVED NEW FLOOR PATH LIGHT STRIP PROFILE PIECES FROM PARTS. INSTALLED FLOOR PATH LIGHT STRIPS IAW AMM 33-50-12 OPS TEST GOOD AT THIS TIME.SDR SIMA201912230002Battery · inoperativeRH -LH OVERWING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED EMERGENCY BATTERY ASSY AT POSITION #4 IAW ENVOY MTX WC 33-700-13 AND 33-700-19. OPC GOOD. CHARGER ASSY BATTERY P/N BA5-0933-901 S/N C00959SDR CALA2019122102258Charger · inoperativeEMERGENCY ESCAPE PATH LIGHTING FROM SEAT ROWS 22-38 ABC ARE OUT AS WELL AS CLOSE IN PROXIMITY OVERHEAD BIN BULL NOSE AND EXTERIOR AFT EMERGENCY LIGHTS. SUSPECT 1 OR 2 BATTERY PACK/CHARGER ASSEMBLIES. R/R''D M1670 BATTERY CHARGER AND BATTERY PACK MM 33-51-03. SDR CALA2019122102253Power Supply · inoperativeCEILING EMERGENCY LIGHTS ON IN ARMED POSITION FOUND CB P18-3 B10 POPPED CAUSED BY BATTERY CHARGER AT DATO PANEL 27F INOP AND SMOKING, WILL NEED TO BE REPLACED, LEFT TWO NEW BATTERIES IN COCKPIT FOR BAD BATTERY CHARGER. REPLACED POWER SUPPLY AT SEAT ROW 27 RESDR CALA2019122102251Light · crackedTHE FLOOR PROXIMITY LIGHT ON OFCR L/H FWD LOWER ATTACHMENT WAS CRACKED, REPLACED THE FLOOR PROXIMITY LIGHT ON OFCR LT FWD LOWER ATTACHMENT, PERFORMED OPERATIONAL TEST OF EMERGENCY LIGHT, THE RESULT WAS GOOD, IAW AMM 33-51-00-00E-320A- A AND AMM 33-51-06-00A-7SDR CALA2019122102250Light · inoperativeSEAT 29ABC EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LIGHT ASSY REF AMM 33-51-11 OPS CHECKED GOOD. ACOMPLISHED AN IDT INSPECTION IAW GMM 09-0-05.SDR MASA2019122012191Bulb · inoperativeROW 15 CEILING LVL EMER FLOOD LT INOP
REPLACED BULBSDR DALA2019122007465Battery Pack · inoperative(LOG 6327321) DURING INSPECTION FOUND EMERGENCY LIGHTS AT L1 DOOR INOPERATIVE. REPLACED L1 DOOR BATTERY PACK PER B737 AMM 33-51. OPS CKS GOOD.SDR VNAA20191220111Light · inoperativeFRONT TWO EMERGENCY GREEN EXIT SIGNS INOP. R+R WARDROBE EMERGENCY BETA LIGHT IAW CRJ 200 AMM 33-51-10-000/400-801 OPS CHECK GOOD.SDR JJBA20191220007Light · inoperativeLH EXTERIOR OVER WING EMERGENCY LIGHT INOPERATIVE. R&R LH EXTERIOR OVER WING EMERGENCY LIGHT. OPS CHECK SAT.SDR XMXR20201118009Battery Pack · failedEMERGENCY LIGHTS FLICKERING. REPLACED EMERGENCY LIGHTS BATTERY PACK.SDR SWAA2019122339866Lamp · inoperativeL2 DOOR EMERGENCY SLIDE LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019122339858Nut Plate · looseLEFT EXTERIOR OVERWING EXIT LIGHT LENS LOOSE. R&R NUTPLATE RING ASSEMBLY ON LIGHT ASSEMBLY IAW SIP.SDR SWAA2019122339857Lens · brokenEMERGENCY EXIT ROW LIGHT COVER BROKEN OFF. / R&R LENS COVER PER AMM.SDR AALA201912209003Battery · no testAIRCRAFT WAS NOT GROUNDED: 2L FLASHLIGHT INOPERABLE. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 25-00-00.SDR AALA201912209008Power Supply · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS DURING OPERATIONAL TEST OF EMERGENCY LIGHT SYSTEM MCDU SHOWS EPSU 3L (15WL) / DEU B (300RH5) IN PASSENGER CABIN. REPLACED EPSU 3L(15WL) IN PASSENGER CABIN IAW AMM 33-51-38-400-801-A AND PERFORMED OPERATIONAL TEST IASDR AALA201912209011Power Supply · no testAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY LIGHT TEST FAILED FWD LEFT ON FAP. REMOVED AND REPLCAED EMER LT POWER SUPPLY AND BAT ON FWD LT(L1) IAW AMM 33-51-38. OPS TEST GOOD.SDR DALA2019122097443Lens · wrong part(AIRCRAFT 681, L/P 6732288) R/H FWD O/WING EMERG LIGHT COVER INCORRECT. CORRECTIVE ACTION: EMERGENCY LIGHT COVER LENS P#BC5-0393-106 FITTED AT R/H FWD O/ WING EXIT. IAW B757 AMM 33-51.SDR DALA2019121907425Battery Pack · inoperative4L OVERHEAD EMERGENCY EXIT LIGHT AND EMERGENCY LIGHT OUTSIDE 4L DOOR INOP R/R BATTERY AND CHARGER IAW B767 AMM 33-51 AT 4R DOOR NO HELP R/R BATT PACK FOR 4L DOOR IAW B767-400 AMM 33-51 AND RELAMPED EXT LIGHT OPS CK GOOD (6389839)SDR ASAA2019122081647Battery Pack · no testM1694 AND M1670 EMERGENCY BATTERY PACKS FAILED CHARGING CAPACITY GROUNDED - YES. REMOVED, REPLACED AND PERFORMED SUCCESSFUL SYSTEM OP CHECK ON EMERGENCY BATTERY PACKS M1694 AND M1670 IAW B737NG AMM 33-51-06-960-805.SDR DALA2019122097463Light · inoperative(LOG 6408469) DURING INSPECTION FOUND EMERGENCY EXIT LIGHT AT 11D INOPERATIVE. REPLACED ASSY. OPS CHECS GOOD PER B737 AMM 33-51.
Back to JASC 3350