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 SWAA2019012428865Battery Pack · dischargedL1 DOOR SLIDE EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2019012428862Lens · missingLT OVERWING EXIT/SALIDA SIGN LENS COVER MISSING. INSTALLED LENS PER AMM.SDR SWAA2019012428851Cover · unsecureEMERGENCY EXIT SIGN COVER FELL OFF. ADJUSTED COVER PER SIP.SDR DALA2019012400490Power Supply · inoperativeEXTERIOR O'WING EMERGENCY LIGHTS INOP. REPLACED OVERWING EMERGENCY LIGHTS POWER SUPPLY AND BATTERY. AMM 33-51. CKS GOOD. OK FOR SERVICE. (LP# 0915674)SDR DALA2019012300474Light · inoperative(LOG 3715944) DURING SVC FOUND EMERGENCY LIGHT AT SEATS 15 D INOPERATIVE. MAINTENANCE R/R SEAT LIGHT ASSY. PER AMM:33-51-11. OPS CHECK GOOD.SDR SWAA2019012328825Light · brokenCENTER OVERHEAD EMERGENCY EXIT LIGHT BROKEN. R&R LIGHT ASSEMBLY IAW AMM.SDR DALA2019012300440Battery Pack · dischargedTAILCONE EMERGENCY LIGHT IN CEILING INOP. REMOVED AND REPLACED BATTERY PACK IN AFT LAVATORY IAW 33-53 LIGHT CHECK OK. (LP4636327)SDR DALA2019012300609Light · malfunctionedALL CABIN EMERGENCY LIGHTS CAME ON DURING DESCENT. WENT OUT WHEN LANDING GEAR WAS EXTENDED. RAN CIDS TEST AND RESET. NO FAULTS FOUND.SDR DALA2019012300607Light · inoperativeOVERWING ESCAPE ROUTE LIGHTING, LEFT AND RIGHTS LIGHTS WILL NOT TEST. REMOVED AND REPLACED EPSU 12WU AND BATTERY. NO HELP. FWD TO MEL 33-50-04A. RELAMPED RIGHT AND LEFT HAND OVERWING FORWARD AND AFT LIGHT. OPERATION CHECKS OKAY.SDR DALA2019012300549Light · brokenSHIP 6803 EMERGENCY LIGHT AT LOC 31D BROKE OFF FORM THE SEAT MOUNTING. CORRECTIVE ACTION: REINSTALLED EMERGENCY LIGHT HOUSING AT 31D AS PER AMM 33-51. (3742319)SDR YENA201901220038Epsu · failedFLT 857, HPN-PBI. FOUND LOWER EMERGENCY EXIT WALL LIGHTS AT OVERWING EXITS INOP; FOUND ESPU 12WL TO BE AT FAULT. R&R ESPU ASSY. OPS TEST NORMAL IAW AMM 33-51-38.SDR YENA201901220040Battery Pack · dischargedFLT 1973, EWR-TPA. EMERGENCY LIGHT FAILS TEST; REMOVED AND REPLACED EMERGENCY BATTERY PACK IAW AMM 33-51-38 OPS CKS GOOD FIN 11WL AND 13WL.SDR YENA201901220039Battery Pack · dischargedFLT 1973, EWR-TPA. EMERGENCY LIGHT FAILS TEST; REMOVED AND REPLACED EMERGENCY BATTERY PACK IAW AMM 33-51-38 OPS CKS GOOD FIN 11WL AND 13WL.SDR AALA201901259026Battery · dischargedEMERGENCY FLASHLIGHT BY THE L1 DOOR, BATTERY WAS LOW. REPLACED THE FLASHLIGHT BATTERY.SDR AALA201901259025Light · inoperativeEMERGENCY LIGHT WAS INOPERATIVE IN THE AFT GALLEY. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-19-400-003-A.SDR AALA201901249006Light · inoperativeDURING AN EMERGENCY LIGHT OPS CHECK, MAINTENANCE FOUND ROW 30 ISLE LIGHT INOPERATIVE. REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-11.SDR SWAA2019012428866Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PER AMM.SDR AALA201901239006Light · inoperativeEMERGENCY LIGHT WAS INOPERATIVE IN THE AFT GALLEY LEFT OF LAVATORY D DOOR. MAINTENANCE REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-19-400-003-A, PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019012328834Battery Pack · failedLT FORWARD OVERWING EMERGENCY EXIT LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2019012328833Battery Pack · failedAFT RT EMERGENCY BATTERY FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2019012328832Battery Pack · failedFORWARD LT EMERGENCY BATTERY FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR IPXA2019012338210Light · missingINSPECTION TYPE:N/A EMERGENCY EXIT LIGHT MISSING 1 BULB. RELAMPED PER AMM 33 51 01 CHECKS GOOD.SDR IPXA2019012238199Power Supply · inoperativeINSPECTION TYPE:N/A EMERGENCY EXIT LIGHT INOP. R&R'D POWER SUPPLY IAW AMM 33-51-07-201. CK NORMAL.SDR MASA2019012211676Light · inoperative2 AFT CABIN CEILING EMER FLOOD LTS INOP. REPLACED BULBS.SDR R61A201901220106Control Panel · malfunctionedEMERGENCY LIGHT FAULT INDICATION ON EICAS. CHANGED EMERGENCY LIGHT PANEL UNIT IAW AMM 33-50-01. FAULT CLEARED.SDR SIMA2019103121007Light · inoperativeTRANSFERRED FROM TSA LOG PAGE 363038 ITEM #1 FWD FLOOR EMERGENCY LITES INOP-C/A-COMPLETE:REMOVED AND INSTALLED #1 FWD FLOOR EMERGENCY LITE /WITH EXTRUSION IAW EMB 145 AMM 33-50-12 SEE TURNOVER FOR DETAILSSDR SIMA2019103121005Light · damagedLH #6 EMERGENCY LIGHT STRIP SIDEWALL IS DAMAGED.-C/A-COMPLETE:RAR LH #6 EMERGENCY LIGHT STRIP EXTRUSION IAW EMB 145 AMM 33-50-12.SDR SIMA20190121003Structure · crackedNR 4 FLOOR LIGHT STRIP EXTRUSION CRACKED. C/A-COMPLETE:REMOVED AND REPLACED NR 4 FLOOR LIGHT STRIP EXTRUSION IAW AMM 33-50-12.SDR AALA201901231007Power Supply · no testTHE EMERGENCY LIGHTS FAILED A POWER SUPPLY CHECK. MAINTENANCE REPLACED THE POWER SUPPLY AND BATTERY, PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019012328839Light · looseAFT GALLEY FORWARD LT CARPET EGRESS LIGHTING LOOSE. SECURED LIGHT STRIP PER AMM.SDR AALA201901221001Lamp · inoperativeEMERGENCY LIGHTS WERE INOPERATIVE AND THE LENS WAS BROKEN OFF.ON THE CENTER CONSOLE. MAINTENANCE REPLACED THE LAMPS AND REASSEMBLED LENS ASSEMBLY. PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019012228794Battery Pack · dischargedRT EMERGENCY LIGHTS INOP BETWEEN ROW 3 TO ROW 5. R&R BATTERY PACK IAW AMM.SDR SWAA2019012228789Light · inoperativeAFT CARGO DOOR OVERWING EMERGENCY LIGHT INOP. R&R LAMP IAW AMM.SDR DALA2019012200396Lens · missingEXIT SIGN FROM OVERWING/AISLE LOCATION MISSING. MAINTENANCE REPLACED THE EXIT SIGN LENS. (LP #5520022)SDR MASA2019012111673Battery · dischargedALL EMER LIGHTS IN AFT OF A/C INOP. CHARGED BATTERIES.SDR DALA2019012920512Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. CORRECTIVE ACTION: ADJUSTED HOLDING CLIP ON EM EXIT LT COVER OVER 2L DOOR. (0911242)SDR SWAA2019012428863Light · inoperativeLT EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR AALA201901239011Light · brokenDURING AN INSPECTION, FOUND THE SEAT MOUNT EMERGENCY LIGHT TO BE BROKEN AT SEAT 5A. MAINTENANCE CONNECTED THE LIGHT ASSEMBLY. PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00.SDR SWAA2019012328822Light · inoperativeLT EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR QXEA2019012300042Battery Pack · dischargedLAST 2 AFT CEILING EMERGENCY LIGHTS AND AFT CENTER CEILING EXIT SIGN WOULD NOT ILLUMINATE DURING OPS CHECK OF EMERGENCY LIGHTS SYSTEM. REMOVED + REPLACED NR 3 EPSU BATTERY PACKS REF AMM TASK 33-51-00-820-801. OPS CHECK GOOD.SDR AALA201901229020Power Supply · no testLEFT OVERWING EXIT EMERGENCY LIGHT POWER SUPPLY FAILED TO TEST. MAINTENANCE REPLACED THE POWER SUPPLY IAW AMM 33-51-38, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR QXEA2019012200040Light · looseFWD LIGHT STRIP CAME LOOSE. REMOVED FROM SERVICE. RE-ATTACHED FWD STRIP WITH DOUBLE SIDED TAPE. NO OTHER DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE.SDR SWAA2019012228813Light · inoperativeR2 DOOR SLIDE LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019012228795Fuse · blownLT ABOVE OVERWING EMERGENCY EXIT DOOR WINDOW LIGHT INOP BETWEEN ROW 11 TO ROW 12. R&R FUSE IAW AMM.SDR DALA2019012200395Lens · missingEMERGENCY EXIT COVER DIFFUSER LENS MISSING AT 604 INTERIOR. RE-INSTALLED DIFFUSER LENS AT ROW 20. (LP #0911582)SDR SIMA20190120004Battery · dischargedFOUND EXTERNAL EMERGENCY LIGHTS ABOVE WING ON RT & LT INOP. C/A-REMOVED AND REPLACED BATTERY & BATTERY POWER SUPPLY IAW AMM 33-50-04. OPC GOOD. NO FURTHER DEFECTS NOTED AT THIS TIME. BATTERY CHARGER ASSY P/N 11-0049 S/N 18121.SDR SWAA2019012128788Light · disconnectedR1 EXTERIOR DOOR EMERGENCY LIGHT INOP. RECONNECTED LIGHT IAW WDM & AMM.SDR SWAA2019012128787Light · disconnectedL2 EXTERIOR DOOR EMERGENCY LIGHT INOP. RECONNECTED LIGHT IAW WDM & AMM.SDR SWAA2019012128786Light · disconnectedR2 EXTERIOR DOOR EMERGENCY LIGHT INOP. RECONNECTED LIGHT IAW WDM & AMM.SDR SWAA2019012128693Light · disconnectedL1 EXTERIOR DOOR EMERGENCY LIGHT INOP. RECONNECTED LIGHT IAW WDM & AMM.
Back to JASC 3350