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 DALA2018071604511Lens · damagedDURING INSPECTION FOUND EMERGENCY SEAT MOUNTED LIGHTING DAMAGED. MAINTENANCE REINSTALLED LENS OP CKS OK PER AMM 33-51.SDR DALA2018071604510Lens · damagedDURING INSPECTION FOUND EMERGENCY SEAT MOUNTED LIGHTING DAMAGED. MAINTENANCE REINSTALLED LENS. OPS CK OK PER AMM 33-51.SDR DALA2018071604508Light · inoperativeDURING INSPECTION FOUND SEVERAL EMERGENCY LIGHTS, OVERWING EXIT AND ESCAPE LIGHTS INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK AT MI670 PER WDM 33-51-14. OPS CK GOOD.SDR DALA2018071604503Light · inoperativeEMERGENCY PATHWAY LIGHTS INOPERATIVE AT ROWS 22 AND 23. REMOVED AND REPLACED LIGHT ASSEMBLIES. OPERATION CHECKS GOOD.SDR UIEA2018071401461Battery · dischargedL4 EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY ASSY PER MM 32-51-04 OPS CK GOOD.SDR UIEA2018071401460Battery Pack · dischargedEMERGENCY LITES AT DOOR 1R INOPERATIVE. REPLACED BATTERY PACK REF AMM 33-51-01.SDR SWAA2018071623561Lens · looseSIDE WALL EXIT LIGHT LENS LOOSE AT ROW 15 DEF. SECURED LENS PER MM.SDR SWAA2018071623529Light · inoperativeR2 DOOR EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA2018071623527Battery · dischargedRT AFT EMERGENCY EXIT SIGN FAULTY. R&R BATTERY PACK PER MM.SDR SWAA2018071623526Battery · dischargedOVER WING EXIT LIGHT INOP. R&R BATTERY PER MM.SDR SWAA2018071623504Light · inoperativeLT AFT EMERGENCY LIGHT INOP. RELAMPED PER MM.SDR SWAA2018071623498Light · inoperativeLT OVER WING EXIT LIGHT INOP. RELAMPED PER MM.SDR IPXA2018071631659Battery Pack · dischargedINSPECTION TYPE:PS1, EMERGENCY LIGHT INOP. T/S PER FIM 33-51-00-815-803. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK REF AMM 33-51-07-022-001 AND AMM 33-51-07-422-012. OPS CK GOOD. SN ON 55129. SN OFF 105351.SDR DALA2018071604490Light · unsecureTHE FORWARD MOST EMERGENCY EXIT LIGHT IS NOT SECURELY FASTENED TO THE CEILING AS DESIGNED. MAINTENANCE SECURED THE LIGHT ASSEMBLY AS REQUIRED. OK FOR SERVICE.SDR AALA20180715003Control Unit · faultyTHE AIRCRAFT WAS GROUNDED. EMERGENCY PATHWAY LIGHTING AT SEAT ROW 1,2, AND 3. REPLACED WELS CONTROL AND BATTERY UNIT.SDR AALA201807179024Battery Pack · dischargedAIRCRAFT WAS GROUNDED: REGARDLESS OF SWITCH POSITION, EMERGENCY EXIT LIGHTS ON AIRCRAFT LEFT WERE ON INTERMITTENT. MAINTENANCE REPLACED BATTERY PACK EQ M1670 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR DALA2018071604521Light · detachedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP, LOCATIONS:04C. SEAT MOUNTED EMERGENCY LIGHT PUSHED INTO SEAT HOUSING, INTERIOR. RE-ATTACHED, LIGHT CK GOOD.SDR AALA2018071769045Lens · missingEMERGENCY LIGHT LENS AT SEAT 1 AC WAS MISSING. INSTALLED THE LENS. CHECKED GOOD.SDR AALA2018071769031Lens · missingEMERGENCY LIGHT LENS AT SEAT 1AC. WAS MISSING. INSTALLED A NEW LENS . CHECKED GOOD.SDR AALA2018071769030Cover · missingL2 EMERGENCY DOOR EXIT SIGN COVER WAS MISSING. REPLACED THE SIGN COVER IAW AMM 33-51-17.SDR AALA201807169017Cover · missingR4 DOOR EMERGENCY EXIT LIGHT WAS INOPERATIVE. REPLACED THE COVER. OPS CHECKED NORMAL.SDR AALA201807169056Control Unit · inoperativeEMERGENCY LIGHTS AT THE R4 DOOR WAS INOPERATIVE. REPLACED THE WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNIT IAW AMM 33-51-07. ACCOMPLISHED A SOFTWARE LOAD. ALL LIGHTS OPS CHECKED GOOD.SDR ASAA2018071625405Lens · missingFA REPORT EMERGENCY EXIT SIGN COVER ROW 17 ACFT RIGHT SIDE MISSING. GROUNDED - YES. INSTALLED NEW EMERGENCY LIGHT COVER ROW 17 RIGHT SIDE.SDR QXEA2018071600260Battery Pack · dischargedEMERGENCY LIGHTS RUNNING UNDER POWER SUPPLY EPS1, TURN OFF AFTER 30 SECONDS DURING TEST. REPLACED THE BATTERY PACK.SDR DALA2018071604512Lens · crackedDURING INSPECTION FOUND EXIT SIGN CRACKED AND FELLL OFF 2R DOOR. MAINTENANCE REPLACED LENS COVER AT R2 DOOR PER AMM 33-5-01.SDR DALA2018071604509Sign · missingDURING INSPECTION FOUND HALF OF EXIT SIGN MISSING IN ISLE ABOVE ROW 22. MAINTENANCE REPLACED EXIT SIGN NOW CKS GOOD.SDR SWAA2018071623563Battery · failedEMERGENCY LIGHT BATTERY M1673 FAILED TEST. R&R BATTERY PER MM.SDR SWAA2018071623562Battery · failedEMERGENCY LIGHT BATTERY M1670 FAILED TEST. R&R BATTERY PER MM.SDR SWAA2018071623559Battery · failedEMERGENCY LIGHT BATTERY M1675 FAILED TEST. R&R BATTERY PER MM.SDR SWAA2018071623522Battery · failedLT FWD EMERGENCY BATTERY FAILED TEST. R&R BATTERY ASSY PER MM.SDR SWAA2018071623506Battery · failedEMERGENCY LIGHT BATTERY M1672 FAILED TEST. R&R BATTERY PER MM.SDR IPXA2018071331628Light · inoperativeEMERGENCY EXIT LIGHT DIDNT ILLUMINATE WITH GEAR SWITCH DOWN. R&R EXIT LIGHT ASSY PER MM 33-51-13. OPS CK GOOD.SDR DALA2018071604489Cover · missingTHE RIGHT AFT OVERWING EXIT LIGHT COVER IS MISSING. CONTRACT MAINTENANCE INSTALLED A NEW LIGHT COVER. OPERATIONAL CHECK WAS GOOD REF AMM 33-53. AIRCRAFT OK FOR SERVICE.SDR SIMA20180712019Structure · crackedRT #7 FLOOR EXTRUSION IS CRACKED. C/A-COMPLETE:REMOVED REPLACED RT #7 FLOOR EXTRUSION IAW AMM 33-50-12. SEE BOW 298426 FOR INSTALLATION.SDR SIMA20180712012Light · broken#2 CENTER ISLE EMERGENCY LIGHT STRIP BROKEN AT LIGHT CONNECTION. C/A-COMPLETE:RAR #2 CENTER ISLE EMERGENCY LIGHT STRIP IAW AMM 33-50-12. SEE BOW298426 TASK #1 FOR OPERATIONAL CHECK.SDR SIMA20180712010Light · crackedLT #2 LIGHT STRIP EXTRUSION IS CRACKED. C/A-COMPLETE:REMOVED REPLACED LT #2 LIGHT STRIP EXTRUSION IAW AMM 33-50-12 ETN-EM-33-058. SEE BOW 298426 FOR INSTALLATION OPS CHECK.SDR SIMA20180712018Light · inoperativeLT #1 LIGHT STRIP EXTRUSION IS CRACKED. C/A-COMPLETE:REMOVED AND REPLACED LT #1 LIGHT STRIP EXTRUSION IAW AMM 33-50-12 ETN-EM-33-058. SEE BOW 298426 FOR INSTALLATION OPS CHECK.SDR SIMA20180712013Light · crackedLT #5 LIGHT STRIP EXTRUSION IS CRACKED. C/A-COMPLETE:REMOVED REPLACED LT #5 LIGHT STRIP EXTRUSION IAW AMM 33-50-12 ETN-EM-33-058. SEE BOW 298426 FOR INSTALLATION OPS CHECK.SDR SIMA20180712008Light · crackedLT #6 LIGHT STRIP EXTRUSION IS CRACKED. C/A-COMPLETE:REMOVED REPLACED LT #6 LIGHT STRIP EXTRUSION IAW AMM 33-50-12 ETN-EM-33-058. SEE BOW 298426 FOR INSTALLATION OPS CHECK.SDR A8ZR20180921002Light · defectiveRT FWD EMERGENCY EXIT DOOR, LT & RT UNDER WING EMERGENCY EXIT DOOR BETA LIGHTS P/N 1971001 FAILED BRIGHTNESS CHECK REF TASK CARD 3350/02 AND REPLACED REF AMM 33-51-00 REV 38.SDR SWAA2018072323676Battery · dischargedPASSENGER CABIN RT SIDE JUST FORWARD OF THE OVERWING EMERGENCY EXIT LIGHT BATTERY INOP AT BS 600. R&R BATTERY IAW AMM.SDR DALA2018071904564Light · damagedF/A REPORTS SEAT 1C EMER PATHWAY LIGHT IS DAMAGED. LIGHT ASSY LENS DAMAGED AND WILL NOT STAY IN PLACE. REMOVED AND REPLACED LIGHT ASSY REF AMM 33-51. EMER PATHWAY LIGHT ASSY NOW SECURE. OK FOR SVC.SDR DALA2018071804548Lens · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:901 / INTERIOR. PREVIOUSLY COMPLIED WITH -901 LENSES CHECK GOOD.SDR AALA201807169053Sign · detachedAISLE EXIT SIGN AT THE R4 DOOR WAS HANGING LOOSE, POT NUT RIPPED OUT OF CEILING PANEL. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-01, AND ACCOMPLISHED SATISFACTORY OPERATIONAL TEST IAW AMM 33-51-00.SDR DALA2018071604494Light · inoperativeEMERGENCY EXIT SIGNS AT LOCATION 605 INOPERATIVE. REPLACED BULBS.SDR SWAA2018071623560Lens · missingEXIT LIGHT LENS MISSING ABOVE ROW 25 DEF. INSTALLED LENS PER MM.SDR SPAA201807130002Battery Pack · dischargedAFT EMERGENCY LIGHT ABOVE L2 DOOR FAILS TO ILLUMINATE.SDR SPAA201807130001Battery Pack · dischargedAFT EMERGENCY EXIT LIGHT ABOVE R2 DOOR DIM, DOES NOT HOLD CHARGE.SDR SIMA201807132004Power Supply · inoperativeFOUND BATTERY POWER SUPPLY NR 3 TO BE INOP DURING PS-1 CHECK. REMOVED AND REPLACED NR 3 BATTERY POWER SUPPLY IAW AMM 33-50-04 OPC GOOD A/C OK FOR SERVICE.SDR SIMA201807132002Inverter · inoperativeRT FWD BULKHEAD EMERGENCY LIGHT INOP AT ROW 3. R&R NR 3 EMER LIGHT DC/AC INVERTER IN REF TO AMM 33-50-11, AND OPS CHKED EMER LIGHTS OK IN REF TO AMM 33-50-00.
Back to JASC 3350