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 XMXR20191211022Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR XMXR20191211021Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR R61A201909101000Power Unit · failedEMERGENCY LIGHT POWER UNIT (ELPU)#2 FAILED 15 FUNCTIONAL TEST. REMOVED AND REPLACED ELPU #2 IAW 33-50-01-400-801-A. OPS CHECKED GOOD. SEE 40000653-7000-0003 AWS FOR TESTING INFO.SDR SWAA2019092437157Lens · crackedR-2 HEADER PANEL EXIT LENS CRACKED. R&R LENS IAW AMM.SDR SIMA20190910005Light · inoperativeSUPPLEMENTAL # 4 FLOOR EMERGENCY LIGHT STRIP INOP. C/A- DEFERRED PER MEL 33-30. REMOVED AND REPLACED #4 EMERG FLOOR STRIP IAW AMM 33-50-12 OPS CHECK GOOD MEL RESTORED.SDR UIEA2019091605505Light · inoperativeEMERGENCY LIGHTS INOP AT SEATS 3AC, 13AC, 21AC, 27AC, AND 30AC. REMOVED AND REPLACED 1317 LAMP AT SEATS 3AC, 13AC, 21AC, 27AC, AND 30 AC IAW AMM 33-50-00.<SDR REXA2019091001338Housing · defectiveOVERHEAD EXIT LIGHT OUT. REMOVED AND REPLACED EXIT LIGHT HOUSING ASSY IAW 33-55-07. PN ON/OFF BF5-0820-903SDR AALA201909129019Epsu · failedAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EPSU 13WL FAILED EPSU SYSTEM TEST. REPLACED EPSU 13WL IAW AMM 33-51-38.SDR DALA2019091105287Lens · missing(AIRCRAFT 5635, L/P 6615806) ON SVC CHECK LT OVER WING EMERGENCY LENS MISSING. INSTALLED NEW LENS A/C OK FOR SERVICE.SDR SWAA2019091236832Power Supply · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. R&R POWER SUPPLY IAW AMM.SDR SWAA2019091236831Battery Pack · failedEMERGENCY LIGHT BATTERY M1672 FAILED TO ILLUMINATE. R&R BATTERY PACK IAW AMM.SDR ASAA2019091030655Battery · dischargedR1 EMERGENCY LIGHTS INOP. GROUNDED - YES. T/S AND FOUND R1 DOOR EL BATTERY CHARGER AND BATTERY BAD, REMOVED AND REPLACED M1674 R1 DOOR EL BATTERY CHARGER AND BATTERY IAW AMM33-51-06, OPS CHECKED GOOD IAW AMM 33-51-06-960-806.SDR SWAA2019091136764Battery Pack · dischargedAFT RIGHT SIDE EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2019091136763Light · inoperativeRT OVERWING EMERGENCY LIGHT INOP. R&R EMERGENCY LIGHT PER AMM.SDR SIMA20190910003Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT IAW AMM TASK 33-50-10-000-801-A AND 33-50-10-400-801-A. OPC GOOD. END.SDR SIMA20190910002Light · inoperativeDURING PS1 FOUND LT FORWARD EMERGENCY LIGHT INOP. C/A-REMOVED AND REPLACED EXTERNAL EMERGENCY LIGHT LAMP IAW AMM-33-50-10. OPS CHECK GOOD.SDR SIMA20190910001Inverter · inoperative#1 FLOOR PROX EMERG LIGHT STRIP IS INOP. C/A-REMOVED AND REPLACED #2 DC/AC EMERGENCE EXIT LIGHTING INVERTER. OPS CHECKED GOOD IAW AMM 33-50-11.SDR IPXA2019091046567Battery Pack · dischargedINSPECTION TYPE:N/A EMERGENCY EXIT LIGHTS INOP. R&R BATT PACK PER AMM 33-51-07 OPS CHK GOOD. ESR: IPC 33-51-07-32.SDR DALA2019091105268Battery · dischargedSEAT MOUNTED EMERGENCY LIGHTS INOP AT 15 ABC ,16ABC, 19 ABC , 20ABC, REPLACED EPCU BATTERY 14WL AND EPSU ASSEMBLY 11WL.SDR DALA2019091105267Light · missingEMERGENCY SEAT MOUNTED LIGHT MISSING AT ROW 26BC, REPLACED EMERGENCY LIGHT AT 26BC.SDR DALA2019091100138Light · looseSEAT 4J EMERGENCY LIGHT LOOSE. RE-INSTALLED LIGHT IN WALL. LP 6228446SDR ASOA201909104050Power Supply · inoperativeIAH - FLIGHT 4035 THE CREW REPORTED THAT THE AISLE OVERHEAD EMERGENCY FLOOD LIGHT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE #4 EMERGENCY LIGHT POWER SUPPLY UNIT, OPERATIONALLY TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVISDR AALA201909119002Charger · faultyAIRCRAFT NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS DIM FROM SEATS 9D THRU 15D. REPLACED BATTERY AND CHARGER M10952 IAW AMM 33-51-07. SEAT MOUNTED LIGHTS 9D THRU 15D CHECK NORM.SDR AALA201909119003Charger · faultyAIRCRAFT NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE FROM SEATS 16D THRU 25D. REPLACED BATTERY AND CHARGER M10953 REF AMM 33-51-07. SEAT MOUNTED EMERGENCY LIGHTS 16D-25D CHECK NORM.SDR AALA201909119009Battery · failedAIRCRAFT NOT GROUNDED: EMERGENCY LIGHT BATTERY 12WL FAILED TEST ON PS CHECK. REPLACED EMERGENCY LIGHT BATTERY 12WL IAW AMM 33-51-38. OPS CHECKED GOOD.SDR DALA2019091005256Battery · discharged(LOG 6060170) DURING INSPECTION FOUND EMERGENCY LIGHTS INOP AT L1 DOOR COCKPIT DOOR AND DOME LIGHT. REMOVED AND REPLACED EMER LIGHT BATTERY PACK BATTERY M1675 AND TESTED PER AMM 33-51.SDR DALA2019091005255Fuse · blown(LOG 6224909) DURING INSPECTION FOUND 1-5CD SEAT MOUNTED EMERGENCY LIGHTS OUT. FOUND ONE FUSE BAD ON POWER SUPPLY M2816. REPLACED SAME PER AMM 33-51-06. OPS CK GOOD.SDR QXEA2019091000350Light · contaminatedFLUORESCENT LIGHTSTRIP BY 2A NOT WORKING OR VERY DIM IF IT IS. REMOVED FROM SERVICE. WATER FOUND IN FLUORESCENT LIGHT STRIP. R AND R FLUORESCENT LIGHT STRIP BY SEAT 2A. REF AMM 33-50-21-000-801-A AND 33-50-21-400-801-A. OPS TEST GOOD. AIRCRAFT RETURNED TO SERVSDR AALA202001299017Flashlight · inoperativeAIRCRAFT IN BASE VIVIT: FLIGHT ATTENDENT SEAT 1RH WITH FLASH LIGHT INOPERATIVE. REPLACED FLASHLIGHT IAW AMM 25-64-01.SDR SWAA2019091236836Battery Pack · failedEMERGENCY EXIT LIGHT BATTERY PACK M1672 ASSOCIATED LIGHTS FAILED OPERATIONS CHECK. RESTORED CONNECTIONS ON BATTERY PACK IAW AMM.SDR SWAA2019091136813Lens · missingR2 DOOR EMERGENCY EXIT LIGHT MISSING LENS. R&R LENS PER AMM.SDR SWAA2019091136812Lens · missingR2 DOOR EMERGENCY EXIT LIGHT MISSING LENS. R&R LIGHT BASE PER AMM.SDR SWAA2019091136803Cover · unsecureRT DOOR EMERGENCY EXIT SIGN COVER FELL OFF. SECURED LIGHT COVER PER SIP.SDR SWAA2019091136768Sign · looseEMERGENCY EXIT OVERHEAD SIGN MID CABIN LOOSE. SECURED LIGHT ASSEMBLY IAW MM.SDR SWAA2019091136765Sign · brokenAFT OVERHEAD EMERGENCY EXIT SIGN BROKEN. R&R EMERGENCY EXIT SIGN IN AFT GALLEY IAW AMM.SDR AALA201909109006Battery · dischargedAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY LIGHT BATTERIES FAIL TEST WHILE ACCOMPLISHING JOB CARD 33C20033002. REMOVED AND REPLACED ALL 8 BATTERIES WITH FULLY CHARGED UNITS IAW AMM 33-51-00. OPS CHECK NORMAL.SDR IPXA2019091046560Battery · dischargedINSPECTION TYPE:N/A EMERGENCY LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED EMERG LIGHT BATTERY IAW MM 33-51-07-902-0001 BATTERY PACK TEST SATISFACTORY P/N ON 2013-1A P/N OFF 2013-1A S/N ON 50991 S/N OFF 49082.SDR DALA2019091005276Lens · unsecure(AIRCRAFT 6702, L/P 6025598) FRC 335102 DOOR 2R EMERGENCY COVER DIFFUSER LENS FELL OFF. REINSTALLED EMERGENCY COVER DIFFUSER LENS PER AMM 52-22.SDR DALA2019091005275Sign · unsecure(AIRCRAFT 5802, L/P 6060538) OVERHEAD EXIT SIGN ABOVE ISLE BETWEEN ROWS 37-38 MUST BE RE-SECURED. RESECURED EXIT SIGN.SDR DALA2019091005272Switch · inoperative(AIRCRAFT 5646, L/P 6089925) L1 DOOR EMERGENCY LIGHT TEST SWITCH INOP. REMOVED AND REPLACED L1 DOOR EMERGENCY LIGHT TEST SWITCH REF WDM 33-51-12. LIGHTS CHECK GOOD.SDR UIEA2019090805456Light · inoperativeMAIN DECK CEILING EMERGENCY LIGHT LEFT SIDE APPROX 430 INOP. RELAMPED, TESTED GOOD.SDR SWAA2019091036759Light · looseOVERHEAD EXIT LIGHT WAS HANGING DOWN. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2019091036758Sign · unsecureOVERHEAD/OVERWING EXIT SIGN KNOCKED OUT OF BRACKET. SECURED EXIT SIGN PER MM.SDR DALA2019090905243Battery Pack · dischargedBOTH FWD OVERWING UPPER EMERG EXIT SIGNS AND CTR AISLE EMERG EXIT SIGN FOR OVERWING EXITS OUT. REPLACED BATTERY PACK IN OVERHEAD BIN 25 D/C PER AMM 33-51 -03, OPS CK GOOD. (LP# 6079462)SDR CALA2019090901513Battery Pack · dischargedWHILE PERFORMING 2SVC FOUND E-LIGHTS AT 1L AND 2R THRESHOLD AND KICK PLATE LIGHTS INOP SUSPECT INDEPENDENT BATTERY PACK AT BOTH LOCATIONS THE ISSUE, PER SSM 33-51-11 SH1-2 AND 33-51-12, 33-51-141 PG 106 AND 105 R ESPECTIVELY. BATTERY PACK PN D717-01-100 ME 99-SDR QXEA2019090900349Battery · dischargedEMERGENCY LIGHTS DS2, DS3 (OVER HEAD AISLE), EXIT SIGNS DS13, DS17, DS20 (FWD RT PAX), AND EGRESS LIGHT DS9 FOUND TO BE INOP DURING OPS TEST. REMOVED AND REPLACED EPS2 EMERGENCY LIGHT POWER SUPPLY AND BOTH ASSOCIATED BATTERIES. REF: AMM TASKS 33-51-01-000-801,SDR DALA2019090905205Battery · dischargedL & R AFT OVERTWING DOOR EMERGENCY LTS INOP. REMOVED AND REPLACED BATTERIES PER AMM 33-53 OPS CHECK NORMAL. (LP5485996)SDR VNAA2019090811102Charger · failedR/H FWD OVERWING EMERGENCY EXIT LIGHT INOP. R+R #2 EMERGENCY LIGHT CHARGER ASSEMBLY IAW CRJ 200 AMM 33-51-05-000/400-801. OPS CHECK GOOD AT THIS TIME.SDR DALA2019091205301Battery · dischargedL4 AND R4 INTERIOR EMERGENCY LIGHTS ARE INOPERATIVE. REPLACED M1210 CHARGER AND BATTERY. SYSTEM OPERATION IS NORMAL.SDR YENA201909080523Unknown · malfunctionedFLT 225, JFK-TPA. DURING WEEKLY (EMER LIGHT TEST ) FOUND FWD R1 DOOR ESCAPE SLIDE LIGHTING FAULTED (ESCAPE SLIDE LIGHTING). PERFORMED AN OPS CHECK IA AMM 25-62-44-710-064A. OPS CHECK OK AS WELL AS AMM 33-51-00-710-001-A OPS CHECK OK. MDDR CLEAR MS-4 UPDATED PL
Back to JASC 3350