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 YENA2019081960465Battery Pack · failedEMER L BAT ON PTP EMERGENCY LIGHT TEST; R & R EMERGENCY LIGHT BATTERY (11WL) IAW AMM 33-51-38. OPS CHECK SAT.SDR YENA2019081960464Battery Pack · failedEMERGENCY LIGHT BATTERY 10WL FAILS TEST; R & R BATTERY 10WL IAW AMM 33-51-38. OPS CKS OK.SDR SWAA2019081936109Bulb · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. R&R LIGHT BULB PER AMM.SDR SWAA2019081936096Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M02816. R&R BATTERY PER AMM.SDR SWAA2019081936094Light · inoperativeL/H EMERGENCY EXIT DOOR LIGHT INOP. R&R LIGHT PER MM.SDR SWAA2019081936044Sign · looseL2 DOOR EXIT IDENTIFIER LOOSE. REINSTALLED IDENTIFIER PER AMM.SDR SWAA2019081936024Battery · no testR/H OVERWING EMERGENCY EXIT LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2019081936023Battery · no testL/H OVER WING EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R & R BATTERY PER AMM.SDR SWAA2019081936022Battery · no testAFT L/H EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R & R BATTERY PER AMM.SDR AALA201908199008Battery · inoperativeAIRCRAFT NOT GROUNDED: OVERWING EMERGENCY EXIT HATCH R/H SIDE FWD EXIT O/H LIGHT INOPERATIVE. ADJ BATT PACK FOR R/H O/W EMERGENCY EXIT LIGHT OPS CHECKED GOOD IAW MM 33-50-00.SDR AALA201908199009Battery · inoperativeAIRCRAFT NOT GROUNDED: OVERWING EMERGENCY EXIT HATCH L/H SIDE FWD EXIT O/H LIGHT INOPERATIVE. ADJ BATT PACK FOR L/H O/W EMERGENCY EXIT LIGHT OPS CHECKED GOOD IAW AMM 33-50-00.SDR DALA2019081904854Power Supply · malfunctionedTHE AFT CABIN EMERGENCY LIGHTS ARE FLASHING IN THE ARMED POSITION. MAINTENANCE REPLACED THE AFT CABIN EMERGENCY LIGHT BATTERY AND POWER SUPPLY PER B717 AMM 33-51. OPERATIONAL CHECK IS NORMAL. (LP #6142124)SDR DALA2019081874843Lens · damagedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP. INSTALLED NEW LENS. OK FOR SVC.SDR AALA201908169008Cids · malfunctionedAIRCRAFT NOT GROUNDED: OVERWING EMERGENCY EXIT LIGHT INOP LEFT SIDE. ACCOMPLISHED RESET OF CIDS , SYSTEM TEST GOOD. AT THIS TIME. NOFAULT FOUND. TSM 23-73-00-810-955 AMM 23-73-00-740-005.SDR SWAA2019082036095Sign · detachedEXIT SIGN IN THE MIDDLE OF THE CABIN FELL OFF ON LANDING. SECURED EXIT SIGN IAW AMM.SDR SWAA2019081936121Battery Pack · inoperativeL/H AFT OF WING GROUND ILLUMINATION LIGHT INOP AT BS. 727C+13, LBL 68. R&R EMERGENCY LIGHT BATTERY PACK M1670 PER AMM AND WDM.SDR SWAA2019081936119Battery Pack · inoperativeL/H OVERWING EMERGENCY EXIT LIGHT INOP. / R&R BATTERY PACK M1668 PER AMM.SDR SWAA2019081936108Battery Pack · inoperativeR/H AFT OF WING GROUND ILLUMINATION LIGHT INOP. / R&R EMERGENCY LIGHT BATTERY PACK M1670 PER AMM AND WDM.SDR SWAA2019081936107Battery Pack · inoperativeR1 DOOR OVERHEAD EMERGENCY LIGHT INOP. / R&R EMERGENCY LIGHT BATTERY PACK M1675 PER AMM AND WDM.SDR SWAA2019081936069Lens · damagedR2 DOOR HEADER PANEL EXIT SIGN LENS DAMAGED. R&R R2 DOOR LIGHT ASSEMBLY PER AMM.SDR SWAA2019081936043Battery Pack · inoperativeL/H EMERGENCY AISLE LIGHT AT SEAT 6 INOP. R&R BATTERY PACK M1668 PER AMM.SDR DALA2019081964856Lens · unsecureEMERGENCY EXIT SIGN COVER LOOSE. REINSTALLED LIGHT COVER.SDR AALA201908199003Battery · faultyAIRCRAFT NOT GROUNDED: DURING CHECK, FOUND EMERGENCY BATTERY 13WL FAULT. REPLACED EMERGENCY BATTERY 13WL IAW 33-51-38. BITE AND OPS CHECK NORMAL.SDR SWAA2019081635997Cover · missingR/H OVERWING EXIT SIGN LOWER COVER FELL OFF. SECURED COVER PER SIP.SDR SWAA2019081635971Lamp · inoperativeR/H SIDE OVERWING EMERGENCY LIGHT INOPERATIVE. RELAMPED THE LIGHT PER AMM.SDR IPXA2019081655640Battery Pack · no testINSPECTION TYPE:18FO, UPPER DECK EMERGENCY LIGHT L1533,L5733,L5767 AND M4915 INOPERATIVE IAW AMM 33-51-04-902-001-001 REV 96.01, REPLACED EMERGENCY LIGHT BATTERY M5169, AND PERFORMED EMERGENCY LIGHT TEST,RESULT WAS SATISFACTORY.SDR R61A2019081650845Power Supply · faultedEMERGENCY LIGHTS NUMBER 1 AND 3 NOT ILLUMINATING. R&R FWD LH EMERGENCY LIGHTS POWER UNIT IAW AMM 33-50-01.SDR AALA201908169062Lens · missingAIRCRAFT IN BASE VISIT: SEAT 7D AFT EMERGENCY EXIT LIGHT LENS MISSING. REMOVED AND REPLACED SEAT 7D EMERGENCY EXIT LIGHT ASSY AND PERFORMED TEST IAW AMM 33-51-05-960-802. OPS OK.SDR REXA2019081651244Light · brokenFLOOR PATH LIGHTING STRIP COMING UP AT ROW 5C AND 0. REPLACED BROKEN FLOOR PATH LIGHT STRIP COVER I/A/W CRJ200 AMM CH 33-51-01. OPS CHECK GOOD.SDR SWAA2019081535957Sign · missingR/H OVERWING EXIT DOOR FORWARD ESCAPE DOOR DIRECTION SIGN MISSING. / INSTALLED SIGN PER MM.SDR SWAA2019081535956Sign · missingR/H OVERWING EXIT DOOR FORWARD ESCAPE DOOR DIRECTION SIGN MISSING. / INSTALLED SIGN PER MM.SDR JJBA20190815006Light · inoperativeMAIN CABIN DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MAIN CABIN EMERGENCY LIGHT ASSEMBLY. OPS CHECK GOOD.SDR YENA2019081940463Battery Pack · failedFT # 324, FOLLOWING EPSU'S FAILED EMER LIGHT TEST - 10WL , 11WL, 12WL, 13WL; REPLACED LISTED EPSU BATTERIES AS REQUIRED 10WL,11WL,12WL,13WL AMM 33-51-38. T/S IAW AMM 33-51-04.SDR YENA2019081940462Battery Pack · no testFT # 324, LAX-JFK. FOLLOWING EPSU'S FAILED EMER LIGHT TEST - 10WL , 11WL, 12WL, 13WL; REPLACED LISTED EPSU BATTERIES AS REQUIRED 10WL,11WL,12WL,13WL AMM 33-51-38. T/S IAW AMM 33-51-04.SDR YENA2019081940461Battery Pack · no testFT # 324, FOLLOWING EPSU'S FAILED EMER LIGHT TEST - 10WL , 11WL, 12WL, 13WL; REPLACED LISTED EPSU BATTERIES AS REQUIRED 10WL,11WL,12WL,13WL AMM 33-51-38. T/S IAW AMM 33-51-04.SDR SWAA2019081936042Battery Pack · inoperativeAFT EMERGENCY EXIT LIGHT INOP. / R&R BATTERY PACK M1673 PACK PER AMM.SDR YENA2019081940460Battery Pack · no testFT 324, FOLLOWING EPSUS FAILED EMERGENCY LIGHT TEST - 10WL , 11WL, 12WL, 13WL, REPLACED THE EPSU BATTERIES AS REQUIRED 10WL,11WL,12WL,13WL AMM 33-51-38. T/S IAW AMM 33-51-04.SDR DALA2019081654817Charger · inoperativeEMERGENCY EXIT LIGHTS AT SEAT 17GF, AND 33GF-41GF INOPERATIVE. MAINTENANCE REPLACED BATTERY CHARGER M733. SYSTEM OPERATION IS NORMAL.SDR SWAA2019081635979Bulb · inoperativeR/H OVERWING DOOR MOST FORWARD BULB INOP JUST BELOW EMERGENCY EXIT SIGN. R&R BULB IAW AMM.SDR R61A2019081640846Light · inoperativeFWD 2 RH PHOTOLUMINESCENT STRIPS INOP. R&R FWD 2 RH PHOTOLUMINESCENT STRIPS IAW AMM 33-50-21.SDR AALA201908169004Cids · no testAIRCRAFT NOT GROUNDED: EPSU (10WL) FWD L FAULT (CLASS 1) DURING CIDS TEST. RESET CIDS 1 OPS CHECKED EPSU NO FAULTS NOTED TEST OK PER MM 23-73-00.SDR CALA2019081601368Lamp · inoperativeEMERGENCY EXIT CEILING LIGHT BETWEEN BOTH AFT LAVS INOP. RELAMPED, REF AMM 33-51-03, OPS CHECKED OK. ACCOMPLISHED THE INSPECTION OF EMERGENCY EXIT CEILING LIGHT BETWEEN BOTH AFT LAVS.SDR CALA2019081601366Sign · inoperativeEMERGENCY EXIT SIGN AT DOOR 2R INOP. REPLACED LIGHT ASSY REF AMM 33-51-01-960-802. OPS GOOD. ACCOMPLISHED THE INSPECTION OF EMERGENCY EXIT LIGHT AT DOOR 2R.SDR CALA2019081601365Fuse · failedEMERGENCY PATH LIGHTS ON ROWS 7-31 ARE INOP. RELAMPED EMERGENCY ESCAPE PATH LIGHTS ON ROWS 7 AND 8 AND REMOVED AND REPLACED PATH LIGHT ASSY. AT ROW 12 IN REF. WITH AMM 33-51-11. WHILE TROUBLESHOOTING FOUND POWER SUPPLY FUSES OPENED ON M10919 AND M10699 POWER SSDR CALA2019081601364Light · inoperativeEMER EXIT FLOOR PATHWAY LIGHT ON SEAT 8ABC INOP. RELAMPED REF AMM 33-51-11, OPS CHECKED OK. ACCOMPLISHED THE INSPECTION OF EMERGENCY FLOOR PATHAWAY LIGHT ON SEAT 8ABC.SDR DALA2019081504802Power Supply · inoperativeEMERGENCY LIGHTS THAT OPERATE ON EPSU 13WL INOP. REMOVED AND REPLACED THE EPSU (13WL) AND BATTERY PACK. REF A320 AMM 33-51.SDR DALA2019081504795Light · malfunctionedTHE EMERGENCY 'ON' LIGHT IS ILLUMINATED WITH THE SWITCH SET TO OFF ON THE FWD FLIGHT ATTENDANT PANEL. TRIED CIDS RESET NO HELP THE EMERGENCY LIGHTS ALL CAME ON AS DEMANDED...DOWN POWERED THE AIRCRAFT AND THE LIGHT WENT OUT AND LIGHTS CHECKED NORMAL A319 AMM 33SDR 29GA2019081500002Power Supply · inoperativeL-8 CB (EMERGENCY LIGHT CONTROL) POPPED IN FLIGHT. CORRECTIVE ACTION: UNABLE TO DUPLICATE. CHECKED WIRES AT FLIGHT ATTENDANT PANEL FOR CONDITION AND SECURITY, NO DEFECT NOTED.
SUSPECT 24LN POWER SUPPLY AT FAULT AS MENTIONED IN ENGINEERING GROUP EMAIL OF WORK SDR FDEA2019081541895Lamp · inoperativeAT POST FLT, FOUND RT DOOR EMERGENCY EXIT SIGN NOT FULLY ILLUMINATED. FOUND 7 LAMPS NOT WORKING. LAMPS REPLACED IAW AMM 33-51-01-2, REV 123.25. FUNCTION TEST OK.SDR MASA2019081412002Sign · inoperativeMID CABIN EMERGENCY EXIT SIGN INOPERATIVE, FWD SIDE.
Back to JASC 3350