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 SWAA2019060433262Sign · faultyR2 DOOR AFT WALL EMERGENCY EXIT SIGN INDICATOR FAULTY. / R&R SIGN PER AMM.SDR ASAA2019060329551Lens · detachedROW 17A EXIT LIGHT COVER MISSING. GROUNDED - YES. FOUND EMER EXIT SIGN (COVER) ON FLT DECK RE-INSTALLED @ ROW 17A.SDR AALA2019060319012Light · brokenAIRCRAFT WAS NOT GROUNDED: EMEGENCY EXIT LIGHT ASSEMBLY BROKEN AT DOOR L1. MAINTENANCE REPLACED LIGHT ASSEMBLY PER MM 33-51-00.SDR AALA2019060319011Light · brokenAIRCRAFT WAS NOT GROUNDED: EMEGENCY EXIT LIGHT ASSEMBLY BROKEN AT DOOR R1. MAINTENANCE REPLACED LIGHT ASSEMBLY PER MM 33-51-00.SDR SWAA2019060333236Sign · missingR/H OVERWING EXIT SIGN MISSING. / R&R SIGN PER AMM.SDR YENA2019060310296Power Supply · inoperativeDURING HEAVY MAINTENANCE, INOP ELPU PN 3400-22-10 SN 007395 AT AFT GALLEY AREA. REPLACED EMERGENCY LIGHT POWER UNIT ELPU AT AFT GALLEY AREA IAW AMM 33-50-01-400-801 A ITEM 3 STEP 6 AND H. OPENSDR JJBA201906031017Light · inoperativeLH FWD OVER WING EMERGENCY EXIT LOCATOR LIGHT INOPERATIVE. R&R LH FWD OVER WING EMERGENCY LOCATOR LIGHT. OPS CHECK SAT.SDR MASA2019053111884Light · inoperativeROW 18 OVHD EMERGENCY FLOOD LIGHT INOP. PLACED ON MEL.SDR CALA2019053100866Power Supply · failed(A3NB-23-3-6018) REMOVE AND REPLACE THE FWD CABIN EMERGENCY POWER SUPPLY. REFER TO N/R: 9619191. CHANGED DUE TO A FAILED BITE TEST. REMOVED AND REPLACED THE FWD CABIN EMERGENCY POWER SUPPLY. REFER TO N/R: 9619191. WORK ACCOMPLISHED. ROTABLE PARTS CHANGE WAS INSDR CALA2019060700887Sign · brokenEXIT SIGN 38C BROKEN. REPLACED LENS COVER. LIGHT ASSY OK.SDR ASOA201906045074Battery Pack · inoperativeDURING MX INSPECTION THE #3 EMERGENCY LIGHT BATTERY WAS FOUND DEAD. MX R/R #3 BATTERY WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA2019060435072Sign · inoperativeDURING MX INSPECTION SEAT 18CD UPPER SIDE WALL EXIT SIGN INOP. MX R/R SIGN WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2019060433287Charger · inoperativeL/H OVERWING EMERGENCY EXIT LIGHT BATTERY CHARGER M1668 INOP. / R&R BATTERY CHARGER PER MT AND WDM.SDR AALA2019060319009Battery · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EPSU BAT FAULT 15WL. REMOVED AND REPLACED BAT AT 15WL IAW AMM 33-51-00. OPS CHECK GOOD.SDR AALA2019060319010Battery · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EPSU BAT FAULT 12WL. REMOVED AND REPLACED BAT AT 12WL IAW AMM 33-51-00. OPS CHECK GOOD.SDR QXEA2019060300231Sign · detachedEMERGENCY EXIT SIGN POPPED OFF AT ROW 2. REMOVED FROM SERVICE. INSPECTED EMERGENCY EXIT SIGN COVER, NO DAMAGE NOTED. REINSTALLED SAME COVER. RETURNED TO SERVICE. NO PARTS REPLACED.SDR REXA2019060300771Battery · inoperativeEMERGENCY EXIT SIGN AT 5DC INOP. R&R EMERGENCY BATTER #2(PS36) AND CHARGER IAW AMM 33-51-17. CHECKS GOOD. OTHER PARTS REMOVED FROM A/C: BATTERY CHARGER P/N 11-0049SDR AALA201906031002Power Supply · no testAIRCRAFT WAS NOT GROUNDED: 15WL EMERGENCY POWER SUPPLY UNIT INOPERATIVE. REPLACED 15WL EMERGENCY POWER SUPPLY UNIT PER STANDARD PRACTICES AND PERFORMED SATISAFACTORY OPERATIONAL CHECK.SDR DALA2019060303373Lens · damagedTHRESHOLD LIGHT LENS COVER DAMAGED ABOVE AFTJUMPSEAT. FORWARD TO MEL 33-52-01. PLACARDS INSTALLED. R&R LENS COVER IAW B717 AMM 33-25. OK FOR SERVICE. MCO/PLAC REMOVED. (LP #1099186)SDR SWAA2019060333299Lens · missingL/H OVERWING EXIT SIGN COVER MISSING. SECURED SIGN LENS PER SIP.SDR REXA2019060300770Light · inoperativeDURING INSPECTION FOUND R/H MID AND AFT EMERGENCY LIGHTS OUT. R/R R/H EMERGENCY LIGHTS IAW AMM 35-51-21. OPS CHECKS GOOD. P/N ON/OFF 1317 NSN ON OR OFF.SDR HNAA2019060300159Sign · inoperativeAFT EXIT SIGN FOR LH OVER THE WING ESCAPE HATCH DOES NOT ILLUMINATE. R & R AFT EXIT SIGN FOR LT OVERWING ESCAPE HATCH AT SEAT 12A IAW AMM 33-50-12-000/400-801-A, OPS CHECKED GOOD. OK FOR SERVICE.SDR DALA2019053103355Light · inoperativeEMERGENCY LIGHT SEAT 39GF INOPERATIVE. INSTALLED SPLICE AND WIRE QUICK DISCONNECT. LIGHT OPERATES NORMAL.SDR AALA201905319009Cover · missingAIRCRAFT WAS GROUNDED: ROW 17 ABC EMERGENCY EXIT LIGHT INOPERATIVE. MAINTENANCE CONNECTED LOOSE EMERGENCY EXIT LIGHT PLUG AND REPLACED MISSING COVER PER AMM 33-51-19.SDR PNSA2019053003Light · inoperativeEMERGENCY LIGHT ON F/A PANEL BURNT OUT. RE-LAMPED ARMED SIDE OF EMERGENCY LIGHT PUSH BUTTON ON F/A PANEL, OPS CHECK OK.SDR SWAA2019053133224Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATIONS M01670. R&R BATTERY PACK PER AMM.SDR SWAA2019053133223Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATIONS M01669. R&R BATTERY PACK PER AMM.SDR SWAA2019053133222Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATIONS M01668. R&R BATTERY PACK PER AMM.SDR SWAA2019053133221Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATIONS M01673. R&R BATTERY PACK PER AMM.SDR SWAA2019053133204Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK AT LOCATIONS M01675. R&R BATTERY PACK PER AMM.SDR SWAA2019053133203Light · looseRT EMERGENCY EXIT BULLNOSE LIGHT LOOSE AT SEAT 3. REINSTALLED LIGHT ASSEMBLY PER AMM.SDR SWAA2019053133202Light · inoperativeL1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. R&R LAMP PER AMM.SDR 29GA2019053100001Power Supply · failedFLIGHT# 0091 FLL/FLL REPORT:C/B L8 (EMER LT CABIN + EXT CTC) POPPED. CORRECTIVE ACTION: R/R EXTERIOR EMERGENCY- LIGHTING POWER SUPPLY (24LN) REF AMM 33-50-10-04. OPERATIONAL TEST OF EMERGENCY LIGHTING GOOD REF AMM 33-50-00.SDR 29GA2019053000002Circuit Breaker · trippedFLIGHT# 0091 FLL/FLL REPORT: C/B L8 POPPED. CORRECTIVE ACTION: RESET C/B L8, OPS CHECK OK IAW 39-50-00 AMM.SDR FDEA201905301187Battery Pack · dischargedMDIS 976 33-50 4847 30MAY19 MCI FACT U THE RIGHT EMERGENCY LIGHTS ARE INOP. REMOVED AND REPLACED THE RIGHT BATTERY PACK PER MM 33-51-07-2. OPS GOOD.SDR JJBA20190530016Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT LAMP AND ASSEMBLY. OPS CHECK SAT.SDR JJBA20190530015Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT LAMP AND ASSEMBLY. OPS CHECK SAT.SDR DALA2019060303383Battery Pack · inoperativeDURING S/C, FOUND AFT CABIN EMERGENCY LIGHTS INOPERATIVE. R/R BOTH LT AND RT AFT CABIN (M736 AND M737) EMERGENCY LIGHT BATTERY PACKS IAW B757 AMM 33-51.SDR DALA2019060303379Light · inoperativeDURING SVC CK FOUND ROW 23 + 37 SEAT EMERGENCY PATH LIGHTING INOP. CORRECTIVE ACTION: REPLACED SEAT EMERGENCY PATH LIGHT ASSY'S AS NEEDED. (4419194)SDR SWAA2019060333277Cover · damagedEMERGENCY LIGHT BUTTON COVER DAMAGED AT AFT ATTENDANT PANEL. / R&R EMERGENCY LIGHT BUTTON PER AMM.SDR DALA2019053003356Fuse · blownFOUND RIGHT SIDE MOST FWD SLIDE LEFT WON'T TURN ON DURING SERVICE CHECK. REPLACED FUSE ON "M733" POWER SUPPLY AND CHECKED.SDR IPXA2019053042601Power Supply · inoperativeINSPECTION TYPE:N/A "EMER LIGHTS BAT 1 LO" L1 MSG ON PREFLIGHT TEST OF EMER LIGHTS QRH PROCEDURES FOLLOWED. EMERG LT BAT 1 LO DEFERRED PER MEL 33-50-4, CNTRL # M 671464 ASSIGNED DMP 33-50-4 C/W PLACARD INSTALLED. REMOVED AND REPLACED EMERGENCY POWER SUPPLY REFSDR CALA2019053100857Battery · dischargedEMERGENCY PATH SEAT MOUNTED LIGHTING IS INOP, ROW 7 THRU 14 ADDED PARTS NEEDED INFO REPLACED BATTERY ON M1676 REF AMM TASK 33-51-06-960-805, OP CHECKS GOOD.SDR SIMA20190529002Light · inoperativeLT EMERGENCY LIGHT ABOVE WING IS INOP. C/A-RAR LT ABOVE WING EMERGENCY LIGHT IAW AMM 33-50-10. OPS CHECK GOOD.SDR SWAA2019053033168Light · inoperativeRT OVERWING EMERGENCY LIGHT INOP. R&R BULB PER AMM.SDR SWAA2019053033165Light · inoperativeRT EMERGENCY LIGHT AFT OF WING LOWER FUSELAGE INOP. RELAMPED LIGHT IAW AMM.SDR VNAA2019052811103Battery Pack · dischargedREMOVED AND REPLACED ALL FOUR EMERGENCY LIGHT BATTERY PACKS IAW CRJ200 AMM 33-51-04-000/400-801. OPS CHECK GOOD AT THIS TIME IAW CRJ200 AMM 33-51-04-740-801. S/N 122912, 76332, 65160, 459376SDR SWAA2019071134745Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PACK AND POWER SUPPLY PER MM.SDR DALA2019052903341Light · faultedEPSU FAULT EXT LOAD EMER RT WING AFT EMERGENCY LIGHT ASSY, REPLACED 2EA BULBS.SDR SWAA2019053133229Battery · dischargedEMERGENCY LIGHTS INOP BETWEEN BS. 449 TO BS. 500. R&R BATTERY IAW AMM.
Back to JASC 3350