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 AALA201809054001Battery · inoperativeEPSU 11WL BATTERY IS INOPERATIVE. REPLACED THE EPSU AND BATTERY IAW AMM 33-51-38. OPS TESTED GOOD.SDR AALA2018090549036Lens · missingR4 EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA2018090549026Charger · inoperativeEMERGENCY LIGHTS AT SEATS 5H, 6H, 7H, 8H, AND 17H WERE INOPERATIVE. REPLACED THE CHARGER IAW 33-51-07. OPS CHECKED OK.SDR AALA2018090549011Battery · inoperativeEMERGENCY LIGHTS AT SEATS 5H, 6H, 7H, 8H AND 17H WERE INOPERATIVE. REPLACED EMERGENCY THE BATTERY IAW 33-51-07. OPS CHECKED OK.SDR ASAA2018090425999Light · inoperativeEMERGENCY LIGHT EXTERIOR SLIDE LIGHT ADJACENT TO R2 DOOR INOP. GROUNDED - YES. RELAMPED AND TESTED PER AMM 33-51-04-960-801 - OPS NORMAL.SDR DALA2018090205396Light · inoperativeRED EMERGENCY FLOOR LIGHT INOP FWD OF F/C COAT CLOSET. RELAMPED PER AMM 33-53. OPS CHECK GOOD.SDR DALA2018090405390Cover · missingMID CABIN EMERGENCY LIGHT COVER IS MISSING. MAINTENANCE INSTALLED THE MISSING COVER. OK FOR SERVICE.SDR DALA2018090605457Light · inoperativeEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:25E / INTERIOR. INSTALLED LIGHT ASSY OPS CHK OK PER TOP 50-00-25.SDR DALA2018090505438Light · unknownEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:25F / INTERIOR. INSTALLED LIGHT ASSY OPS CHK OK PER TOP 50-00-25.SDR DALA2018090505437Light · unknownEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:25D / INTERIOR. INSTALLED LIGHT ASSY OPS CHK OK PER TOP 50-00-25.SDR DALA2018090505434Light · brokenON SVC CHECK FOUND SEAT MOUNTED EMERGENCY EXIT LIGHTS AT 3CD, 4CD AND 25FED BROKEN. REMOVED AND REPLACED EMER. EXIT LIGHTS AT SEATS 3CD, 4CD AND 25FED IAW AMM 33-51-11. OPS CHECK GOOD.SDR SWAA2018090424807Battery Pack · dischargedFORWARD CABIN EGRESS LIGHT INOP. R&R BATTERY PACKS IAW AMM.SDR SWAA2018090424796Lens · missingCENTER AISLE OVERWING EXIT SIGN MISSING LENS. R&R LENS PER SIP.SDR DALA2018090405422Light · unsecureEMERGENCY FLOOR LIGHTING INOPERATIVE AT SEAT 24B. RE-SECURED LIGHT. SYSTEM OPERATION IS NORMAL.SDR DALA2018090405421Light · unsecureEMERGENCY FLOOR LIGHTING AT 23B IS INOPERATIVE. MAINTENANCE RE-SECURED LIGHT. SYSTEM OPERATION IS NORMAL.SDR SIMA201809041001Light · inoperativeRT SIDE FUSELAGE TRAILING EMERGENCY LIGHT INOP. REPLACED RT SIDE FUSELAGE TRAILING EMERGENCY LIGHT BULB IAW CMM 33-52-07. OPS TEST OF THE RT TRAILING EXTERIOR LIGHT WAS DONE IAW AMM 33-51-15.SDR SWAA2018090424757Charger · inoperativeFORWARD CABIN EGRESS LIGHT INOP. R&R CHARGER IAW AMM.SDR SWAA2018090424725Lens · unsecureR1 DOOR EMERGENCY EXIT LENS FELL OFF ON TAKEOFF. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2018090424718Sign · brokenREAR EXIT SIGN BROKEN. R&R SIGN ASSEMBLY PER MM.SDR DALA2018090405395Battery Pack · dischargedSEAT 15-23 EMERGENCY LIGHTS INOP. REPLACED EMERGENCY BATTERY PACK IAW AMM 33-53 OP CHECK GOOD. OK FOR SRV.SDR AALA201809049007Portable Light · defectiveAIRCRAFT WAS NOT GROUNDED. L1 DOOR SIDE EMERGENCY LIGHT IS ON. REPLACED L1 DOOR PORTABLE EMERGENCY LIGHT AND OPERATIONS CHECK NORMAL PER AMM 33-53-00.SDR MASA2018090113541Light · inoperativeROW 5 CEILING EMER FLOOD LT INOP. REPLACED BULB.SDR SWAA2018090424804Light · inoperativeLT AFT EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR DALA2018090405429Light · detachedSEAT 43D EMR LIGHT DETACHED. RESECURED LIGHT AT SEAT 43D. OPS NORMAL.SDR DALA2018090405425Light · inoperativeEMERGENCY SEAT MOUNTED LIGHTING INOPERATIVE AT 34B. REPLACED BUMPER SYSTEM OPERATION IS NORMAL.SDR SWAA2018090424746Lens · missingRT WING EXIT DOOR AFT EMERGENCY EXIT LIGHT LENS MISSING. R&R LENS PER AMM.SDR SWAA2018090424717Cover · missingLT SIDE OVERWING EMERGENCY EXIT LIGHT COVER MISSING. R&R COVER PER AMM.SDR SWAA2018090424712Battery Pack · failedLT OVERWING EMERGENCY EXIT LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR AALA201809049054Light · malfunctionedEMERGENCY EXIT LIGHTS WERE ON WITH EXIT LIGHT SWITCH IN ARM POSITION. MAINTENANCE POWERED DOWN AIRCRAFT AND POWERED UP, WAITED FOR POWER-UP AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 24-00-00-710-003-A.SDR AALA2018090329002Light · no testTHE EMERGENCY LIGHTS AT D AND E INOPERATIVE. R & R THE EMERGENCY LIHGTS IAW AMM 33-50-21. OPS CHECKED NORMAL.SDR AALA2018090319002Light · no testTHE EMERGENCY LIGHT D AND E, INOPERATIVE. R & R THE EMERGENCY LIGHTS IAW AMM 33-50-21. OPS CHECKED NORMAL.SDR DALA2018083105380Sign · unsecure(AIRCRAFT 672, L/P 4584655) 26 EXIT ROW SIGN FELL OFF. RESECURED SIGN COVER PER AMM 33-51.SDR DALA2018083105374Battery Pack · discharged(LOG 4945283) DURING INSPECTION FOUND FWD LT EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED BATTERY PACK PER MM 33-51-06, OP CK GOOD.SDR DALA2018083105370Battery Pack · dischargedCATWALK EMERGENCY LIGHTS INOP. REPLACED BATTERY PACK OPS CK OK. (LP# 4682176)SDR SWAA2018090424772Lens · missingL1 EMERGENCY EXIT LOWER LIGHT LENS MISSING DIRECTIONAL ARROW. R&R LENS PER AMM.SDR SWAA2018090424769Battery Pack · dischargedAFT ENTRY RT AREA EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018090424771Lens · missingR1 EMERGENCY EXIT LOWER LIGHT LENS MISSING DIRECTIONAL ARROW. R&R LENS PER AMM.SDR DALA2018090405406Sign · inoperativeOVERHEAD EMERGENCY EXIT SIGN MID CABIN (ROW 14) THAT FACES AFT IS NOT ILLUMINATED. REPLACED SIGN LIGHT PANEL.SDR SCNA20180830103Battery Pack · dischargedRT AFT EXTERIOR EMG LIGHT AND INTERER EXIT LIGHT INOP. R/R BATTERY PACK. OPS CHK GOOD.SDR AALA201808319039Light · inoperativeRIGHT REAR FUSELAGE EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REPLACED LIGHT BULB PER AMM 33-51-04 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201808319038Light · malfunctionedEMGERGENCY LIGHT ABOVE THE L2 AND R2 DOORS WERE ON WHEN THEY SHOUD BE OFF. ALL OTHER EMERGENCY LIGHTS WERE OFF, COCKPIT EMGERGENCY EXIT LIGHT SWITCH WAS IN ARMED POSITION. MAINTENANCE ACCOMPLISHED BITE TEST OF EMERGENCY POWER SUPPLY UNIT IAW TSM 33-51-00-810-SDR AALA201808319037Lens · missingSEAT 32C EMERGENCY LIGHT LENS MISSING. MAINTENANCE REPLACED THE LENS AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201808319036Cover · detachedEMERGENCY EXIT LIGHT COVER AT THE L1 DOOR CAME OFF, AND WOULD NOT ATTACH. MAINTENANCE REPLACED LIGHT COVER IAW AMM 33-51-00, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR REXA2018083000763Light · inoperativeOVERHEAD EMERGENCY LIGHTS OVER FIRST CLASS ARE INOP, AFTER FIRST CLASS EVERY OTHER LIGHT IS INOP. TROUBLESHOT OVERHEAD EMERGENCY LIGHTS IAW WMM 25-28-01. FOUND PUSHED BACK PIN AT CONNECTOR P5439 PIN K. RESEATED PIN K IAW ESPM 20-24-00. OPERATIONAL TEST OF EMERSDR REXA2018083000761Battery Pack · dischargedDURING OPERATIONAL CHECK OF EMERGENCY LIGHTS NOTED INTERMITTANT ILLUMINATION OF EXIT LIGHTS AT OVERWING EXITS. REMOVED & REPLACED EMERGENCY BATTERY PACK AT POSITION PS43, IAW AMM CH 33-51-17. OPS CHECK GOOD.SDR SIMA20180830003Charger · inoperativeCENTER AFT EMERGENCY EXIT SIGN AND LT WALL MOUNTED EMERGENCY SIGN INOP. C/A-REMOVED AND REPLACED NR 3 EMERGENCY BATTERY AND CHARGER IAW AMM 33-50-04 OP'S CHECK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 24447 POSITION 4.SDR AALA201808319013Lens · brokenR2 DOOR EXIT LIGHT LENS WAS BROKEN. REPLACED THE LENS. LIGHT OPS OK.SDR MASA2018083013535Lamp · inoperativeROW 10 OVERHEAD EMERGENCY FLOOD LIGHT. REPLACED THE LAMPS.SDR JJBA20180830014Light · inoperativeEMERGENCY LIGHT ABOVE ROW 18CD WAS INOPERATIVE. R & R THE EMERGENCY LIGHT ABOVE. OPS CHECKED SATISFACTORY.SDR SWAA2018092625536Sign · crackedAFT LOWERED CEILING PANEL EMERGENCY EXIT SIGN HOUSING ASSEMBLY CRACKED. R&R SIGN IAW AMM.
Back to JASC 3350