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 SWAA2019091036745Light · inoperativeRT OVERWING EMERGENCY SIDEWALL LIGHT INOP. RELAMPED LIGHT IAW PER MM.SDR SWAA2019091036743Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2019091036736Cover · looseFORWARD ENTRY EXIT LIGHT COVER LOOSE. SECURED LIGHT COVER PER SIP.SDR SWAA2019091036728Power Supply · inoperativeFORWARD RT EMERGENCY LIGHTS INOP. R&R POWER SUPPLY PER AMM.SDR DALA2019090605242Battery · dischargedSEVERAL EMERGENCY LIGHTS INOP. R/R EMERGENCY LIGHT BATTERY AT FWD LAVATORY AT SEAT 19 D-E-F PER AMM 33-51 OPS CK NORMAL. (LP# 6079454)SDR AALA201909099021Fault Message · false indicationAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS DURING SLIDE CHANGES, FOUND FAULT BAT/EPSU 12WL EXT R. MAINTENANCE RESET POWER ON AIRCRAFT PERFORMED OPS BITE CHECK IAW AMM 33-51-00, FAULT CLEARED.SDR AALA201909099031Power Supply · faultedAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EPSU (13WL) AFT L FAULT MESSAGE ON CIDS. REMOVED/REPLACED EPSU (13WL) PER AMM 33-51-38-400. OPS CHECKS GOOD.SDR DALA2019090905217Light · inoperativeWHILE PERFORMING SERVICE CHECK FOUND 2ND FROM FORWARD EMERGENCY ESCAPE PATH LIGHT ABOVE TAIL CATWALK INOPERATIVE. MAINTENANCE REPAIRED THE WIRE PER SWPM 20 AND THE OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT IS OK FOR SERVICE. (LP #9875618)SDR REXA2019091001284Light · missingEMERGENCY TRACK LIGHT MISSING AT SEATS 1D AND C. INSTALLED NEW TRACK LIGHT AT SEATS 1D AND C IAW AMM 33-51-01. OPS CHECK GOOD. P/N ON: 36491-1.SDR SIMA20190906002Light · inoperativeLT WING EMERGENCY EXIT LIGHT MOUNTED IN PSU COVER IS INOP. C/A-REMOVED AND INSTALL LAMP AT SEAT ROW 12A LT WING EMERG EXIT. REF AMM 33-50-08. OPS CHK GOOD PER AMM TASK 33-50-00-700-801-A/500SDR SIMA20190906004Light · inoperativeEMERGENCY LIGHT MOUNTED IN SERICE DOOR HINGE COVER IS INOP. C/A-REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT ASSY IAW AMM 33-50-10. OPS CK GOOD.SDR SIMA20190906003Light · inoperativeEMERGENCY LIGHT MOUNTED IN MAIN PAX DOOR HINGE COVER IS INOP. C/A-REMOVED AND INSTALL LAMP IN MAIN PAX DOOR EMERG LIGHT. REF AMM 33-50-10. OPS CHK GOOD PER AMM TASK 33-50-00-700-801-A/500.SDR AALA201909099023Light · inoperativeAIRCRAFT IN BASE VISIT: DOOR 1L EMER EXIT LIGHT LEFT SIDE BOTTOM EXIT LIGHT HAS BULBS INOPERATIVE. REMOVED AND REPLACED NEW DOOR 1L EMER EXIT LIGHTS IAW AMM 33-51-13 AND TEST IS GOOD IAW AMM 33-51-13-400-001-A.SDR ASOA201909063045Light · inoperativeTHE CREW REPORTED FLOOR PROXIMITY EMERGENCY LIGHT STRIP @ ROW 10 WAS INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY FLOOR LIGHT STRIP AT ROW 10.SDR DALA2019090605201Light · missingROW 34ED AISLE PATH LIGHT MISSING. INSTALLED MISSING LIGHT IAW AMM 33-53 OPS CHECK GOOD. (LP6016707)SDR HNAA2019090700254Fuse · blownFWD CEILING EMERGENCY LIGHT INOP. FIX: REMOVED #1 EMERGENCY LIGHTING SYS BATTERY, FOUND BAD FUSE ON BATTERY PACK BASE. R&RD FUSE. REINSTALLED #1 BATTERY.SDR HNAA2019090700253Fuse · blownPAX DOOR EMERGENCY LIGHT INOP. FIX: REMOVED #1 EMERGENCY LIGHTING SYS BATTERY. FOUND BAD FUSE ON BATTERY PACK BASE. R&RD FUSE. REINSTALLED BATTERY.SDR AALA2019090600001Housing · cracked3L EMERG EXIT LIGHT HOUSING CRACKED. WON'T HOLD LENS.SDR AALA2019090600000Control Unit · failed3 EXISTING FAULTS ON WELS SYSTEM 33-12113, 33-12111 AND 33-11211.SDR XMXR20191211016Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR SWAA2019100217446Lens · crackedR/H CABIN BIN MOUNTED EMERGENCY LIGHT LENS CRACKED. R & R LENS IAW AMM.SDR SWAA2019100217445Lens · crackedLEFT CABIN BIN MOUNTED EMERGENCY LIGHT LENS CRACKED. R&R LENS PER AMM.SDR AALA201909069034Control Unit · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS 3 EXISTING FAULTS ON THE WELS SYSTEM 33-12113, 33-12111, AND 33-11211. REMOVED AND REPLACED THE WIRELESS CONTROL UNIT IAW AMM 33-51-07 AT DOOR 2L. OPS CHECK GOOD. *** SUPPLEMENTAL INFORMATION: AIRCRAFT REGISTRATION WSDR DALA2019091005302Lens · missingFAA INSPECTOR FOUND RED EMERGENCY LIGHT LENS MISSING FROM AISLE EMERGENCY LIGHT FORWARD OF F/L LAV LEFT SIDE FLOOR LEVEL. REPLACED EMERGENCY PROXIMITY LIGHT ASSEMBLY. SYSTEM OPERATION IS NORMAL.SDR SWAA2019091036690Light · inoperativeLT OVERWING EMERGENCY LIGHT INOP. R&R BULB PER AMM.SDR SWAA2019091036670Sign · looseOVERHEAD EMERGENCY EXIT SIGN AT MID-CABIN LOOSE. REINSTALLED SIGN IAW AMM.SDR IPXA2019090646414Control Panel · defectiveINSPECTION TYPE:N/A EMER LITE CONTROL PANEL DISARMED LIGHT WILL NOT SNAP INTO LOCKED POSITIONREF MM 33 51 08. INSTALLED SERVICES ABLE PANEL ASSY OPS CHECK GOOD SN ON 000050 EFF 31 12 11 51 A.SDR DALA2019090605224Cover · damaged(AIRCRAFT 6717, L/P 1257167) EMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS:302 / ACARS TEXT: FRC335202302 / INTERIOR. REPLACED LIGHT COVER WITH SERVICEABLE. OK FOR SERVICE.SDR REXA2019090501288Light · inoperativeESCAPE PATH LIGHTS IN GALLEY (R & L) BULBS INOP PN OL3071BPEGPL. REPLACED INOP BULBS IAW AMM 33-51-11. OP CK GOOD PN OL3071BPEGPL.SDR IPXA2019090546386Holder · missingINSPECTION TYPE:N/A FLIGHT DECK FWD ENTRY DOOR EMERGENCY EXIT GIN FLOOR ILLUMINATION LAMPS INOP. REMOVED ENTRY DOOR EMERGENCY SIGN LENS FOUND FLOOR ILLUMINATION LAMP HOLDER ASSEMBLY MISSING. R&R'ED EXIT SIGN REF AMM 33 51 01 OPS CKS NORMAL PER SAME.SDR SIMA20190905004Light · inoperativeRT AFT EXTERIOR EMERGENCY LIGHT BAD. C/A-R&R RT AFT EXTERIOR EMERGENCY LIGHT IAW AMM 33-50-10. OPS CHECK GOOD.SDR SIMA20190905005Light · inoperativeCOCKPIT ENTRY EMERGENCY LIGHT INOP. C/A-RAR COCKPIT ENTRY EMERGENCY LIGHT IAW AMM 33-50-05. OPS CHECK GOOD.SDR AALA2019090500000Battery Pack · dischargedWHEN A/C POWER WAS COMPLETELY REMOVED, THE EPL LIGHTS ILLUMINATED ON SEATS ROWS 13 THRU 18.SDR KCSA201909051209Light · malfunctionedEMERGENCY LIGHTS ARE ON WHEN AIRCRAFT POWER IS OFF.SDR MASA2019090512033Light · inoperative13AC EMER EXIT ONE BULB INOP. RELAMPED.SDR VNAA2019100194101Battery Pack · inoperativeCREW REPORT OF SEVERAL EMERGENCY LIGHTS INOP PRIOR TO FIRST FLIGHT OF DAY. INSPECTED SYSTEM AND FOUND #3 EPSU BATTERY BAD.REMOVED AND REPLACED #3 EPSU BATTERY IAW CRJ 900 AMM 33-51-17-0000/400-801 OPS CHECK GOOD AT THIS TIME.SDR IPXA2019090446317Power Supply · faultedINSPECTION TYPE:N/A **SUPPLEMENTAL SDR** EMER LT BAT 1 LO LEVEL ONE ALERT AFTER TEST. DEFERRED PER MEL 33-50-4 ASSIGNED M682153 PLACARD INSTALLED C/W DMP 33-50-4. REPLACED EMERGENCY LIGHTING BATTERY POWER SUPPLY IAW AMM 33-51-01-000-802/33-51-01-400-802. OPS CSDR YENA201909040512Battery · failedFLT 225, JFK-TPA. L EMERG BATT REQUIRES REPLACEMENT. R & R LEFT OVER WING EMERGENCY LIGHT BATTERY IAW AMM 33-51-38. OPS CHECK GOOD.SDR R61A201909040938Battery · failedEMERGENCY BACK UP BATTERY FAILED FUNCTIONAL TEST. R&R EMERGENCY BATTERY PER AMM 22-03-09.SDR DALA2019090505229Lens · missing(AIRCRAFT 6712, L/P 5583330) OVERWING EXIT SIGN AT ROW 27 ABC SIDEWALL PANEL LENS MISSING. INSTALLED AND SECURED NEW EXIT SIGN LENS AS REQUIRED.SDR AALA201909059006Power Supply · failedAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS FAULT EPSU-EMERGENCY POWER SUPPLY UNIT 13WL IN PASSENGER CABIN (1 EA). MAINTENANCE REMOVED AND REPLACED EPSU EMERGENCY POWER SUPPLY UNIT 13WL IN PASSENGER CABIN IAW AMM 33-51-38-400-001-A AND PERFORMED OPERATIONAL CHSDR AALA201909059007Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EPSU (10WL) FAILS BITE CHECK. REMOVED AND REPLACED EPSU (10WL) IAW AMM 33-51-38. REMOVED AND REPLACED BATTERY FOR EPSU (10WL) IAW AMM 33-51-38. BITE CHECKS GOOD. (SEE SDR # AALA201909059018)SDR AALA201909059018Battery · dischargedAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EPSU (10WL) FAILS BITE CHECK. REMOVED AND REPLACED EPSU (10WL) IAW AMM 33-51-38. REMOVED AND REPLACED BATTERY FOR EPSU (10WL) IAW AMM 33-51-38. BITE CHECKS GOOD. (SEE SDR # AALA201909059007)SDR SWAA2019090536612Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2019090536600Light · inoperativeR1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR AALA201909059008Light · brokenAIRCRAFT NOT GROUNDED: EPM EMERG LIGHT AT 16 DEF, LENS FELL OFF. CHANGED LIGHT ASSY. IAW AMM 33-50-00, OPS CHECKED GOOD PER AMM 33-50-00,SDR AALA201909059009Light · inoperativeAIRCRAFT NOT GROUNDED: R3 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELAMPED R3 DOOR EXT SLIDE LIGHT IAW AMM 33-51-06.SDR AALA201909059015Light · brokenAIRCRAFT NOT GROUNDED: R2 DOOR FWD EXIT IDENTIFIER LIGHT ASSY BROKEN. REPLACED R2 DOOR FWD EXIT IDENTIFIER LIGHT ASSY IAW AMM 33-51-10.SDR MASA2019090412032Light · inoperativeROW 14A EXIT SIGN 1 LIGHT BULB INOPERATIVE. PLACED ON MEL.SDR MASA2019090412031Light · inoperativeROW 21 OVHD EMERG FLOODLIGHT INOP. PLACED ON MEL.
Back to JASC 3350