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 AALA201802239005Power Supply · no test11WL EMERGENCY POWER SUPPLY UNIT FAILED TO TEST. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-38.SDR AALA201802269005Lens · missingR2 DOOR EMERGENCY EXIT LOWER LIGHT COVER BRACKET MISSING. REPLACED THE LENS.SDR AALA201802269004Cover · brokenL2 DOOR WHITE SLIDE ARM LIGHT COVER IS BROKEN. SECURED THE LENS COVER.SDR AALA201802239012Lens · missingL4 DOOR EXIT LIGHT COVER MISSING. REPLACED EXIT LIGHT COVER IAW AMM 33-51-16.SDR AALA201802239011Lens · brokenL4 DOOR EXIT LIGHT LENS BROKEN. REPLACED THE LENS.SDR DALA2018022301105Battery Pack · inoperativeFWD EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERIES.SDR YENA201802220109Sign · inoperativeRIGHT EMERGENCY EXIT SIGN INOPERATIVE. R & R THE SIGN IAW AMM 33-50-15. OPS CHECKED GOOD.SDR YENA201802220108Battery Pack · failedEMERGENCY LIGHT NR 3 BATTERY PACK FAILED. R & R NR 3 BATTERY PACK IAW AMM 33-50-01. OPS CHECKED GOOD.SDR MASA2018022213004Light · inoperativeAFT OVHD EMERG FLOOD LIGHT INOP. REPLACED BULB.SDR CALA2018022200755Lens · looseAISLE EMERGENCY LIGHT LENS FALLING OFF. SECURED THE LENS.SDR CALA2018022200754Cap · missingEND CAP FOR EMERGENCY EXIT LIGHT ABOVE 21C NEEDS TO BE REINSTALLED T ASSY AND OPS CK OK TO CONTINUE. REMOVED AND REPLACED ROW 21C WITH NEW EMERGENCY RED LIGHT.SDR CALA2018022200752Lens · missingAISLE CEILING PANEL EMERGENCY LIGHT LENS IS MISSING AT 26B. INSTALLED MISSING LENS/BEZEL AS REQUIRED, REF IPC 33-51-04.SDR SWAA2018022219985Sign · inoperativeRT OVERWING EMERGENCY EXIT SIGN LOWER SIDE INOP AT ROW 14. RELAMPED SIGN PER AMM.SDR SWAA2018031220325Battery Pack · inoperativeFORWARD GALLEY AREA L1 DOOR UPPER EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018031220324Battery Pack · inoperativeRIGHT SIDE FUSELAGE, R1 EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR REXA2018022100186Sign · crackedTHE EXIT SIGN ON THE FWD WARDROBE AND GALLEY G2 ARE CRACKED. REMOVED AND REPLACED THE EXIT SIGN IAW AMM 33-51-05-400-801-A01.SDR DALA2018022201199Lens · missingDURING INSPECTION, FOUND EMERGENCY CEILING LIGHT DIFFUSER LENS MISSING AT SEAT 24E.SDR AALA201802269041Lens · brokenRIGHT AFT OVER WING EMERGENCY LIGHT EXIT LENS IS BROKEN. REMOVED AND REPLACED THE LENS. OPS CHECKED OK, AND OK FOR SERVICE IAW AMM 33-51-04.SDR SWAA2018022620089Battery Pack · no testEMERGENCY LIGHT BATTERY PACK CAPACITY CHECK FAILED AT LOCATION M1672. R & R THE BATTERY PACK IAW MM.SDR SWAA2018022620088Battery Pack · no testEMERGENCY LIGHT BATTERY PACK CAPACITY CHECK FAILED AT LOCATION M1670. R & R THE BATTERY PACK IAW MM.SDR SWAA2018022620087Battery Pack · no testEMERGENCY LIGHT BATTERY PACK CAPACITY CHECK FAILED AT LOCATION M1675. R & R THE BATTERY PACK IAW MM.SDR SWAA2018022620086Battery Pack · no testEMERGENCY LIGHT BATTERY PACK CAPACITY CHECK FAILED AT LOCATION M1673. R & R THE BATTERY PACK IAW MM.SDR SWAA2018022620085Lens · looseOVERWING OVERHEAD EXIT LIGHT LOOSE. SECURED THE LENS IAW AMM.SDR SWAA2018022620080Light · looseOVERWING OVERHEAD EXIT LIGHT LOOSE. SECURED LIGHT PER AMM.SDR SWAA2018022620057Strip · delaminatedEGRESS STRIPS BETWEEN AFT WHEELCHAIR CLOSET AND G3 GALLEY DELAMINATED. R&R STRIPS PER DWG.SDR SWAA2018022620034Light · inoperativeRT OVER WING EXIT FORWARD LOWER EMERGENCY EXIT LIGHT BULB INOP. R&R BULB IAW AMM.SDR SWAA2018022620022Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK CAPACITY CHECK FAILED AT LOCATION M1674. R&R BATTERY PACK PER MM.SDR AALA201802269043Lens · detachedEXIT SIGN LENS OVER L2 DOOR CAME OFF. MAINTENANCE REPLACED THE SIGN LENS IAW AMM 33-50-00, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180222006Lens · missingSEAT 29D CEILING EMERGENCY LIGHT LENS MISSING. MAINTENANCE REPLACED THE LENS IAW AMM 33-53-00, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR IPXA2018022226758Light · damagedDURING AN EMERGENCY LIGHT TEST OF FWD L1 DOOR HANDLE, EMERGENCY LIGHTS WERE FOUND DAMAGED. THE LIGHT ASSY WAS REPLACED IAW AMM 33-52-02-201, REV 90.04. TESTED GOOD.SDR REXA2018022100134Relay · malfunctionedEMERGENCY LIGHT STATUS MESSAGE. CABIN EMERGENCY LIGHTS COME ON AND OFF ON THEIR OWN WHILE ARMED. REMOVED AND REPLACED EMERGENCY LIGHT RELAY K198 IAW AMM 33-51-19. OPS CHECKED GOOD.SDR DALA2018022301078Battery · dischargedEMERGENCY LIGHTS ABOVE EXIT ROW SEATS INOP. REPLACED BATTERIES IAW AMM 33-53.SDR SIMA20180221003Light · inoperativeNR 4 AISLE EMERGENCY LIGHT INOP PER PS-2 CHECK. REMOVED AND REPLACED LAMP ON NR 4 AISLE EMERGENCY LIGHT IAW AMM 33-50-08. OPS CHECK GOOD.SDR DALA2018022201076Lens · missingDURING INSPECTION, FOUND A RED EMERGENCY LIGHT LENS MISSING AT ROW 16D. MAINTENANCE REPLACED THE LENS AND OPS CHECKED NORMAL OK FOR SERVICE.SDR DALA2018022201067Power Supply · inoperativeLEFT HAND AFT EMERGENCY EXIT OVERWING IDENTIFIER IS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY POWER SUPPLY IAW AMM 35-51. OPERATIONAL CHECKS NORMAL. OK FOR SERVICE.SDR CALA2018022100729Power Supply · no testRT OVERWING EPSU FAILED TO TEST. FOUND RIGHT POWER SUPPLY AT FAULT. REPLACED THE EPSU IAW AMM 33-51-38-400-001. PERFORMED BITE TEST AND FOUND EMERGENCY LIGHTS OPS CKS GOOD.SDR CALA2018022100728Battery · inoperativeWITH EMERGENCY LIGHT SWITCH ARMED, AND POWER OFF AIRCRAFT, EMERGENCY LIGHTS BY DOOR 1L AND 1R DO NOT ILLUMINATE. REPLACED THE BATTERY. OPS GOOD.SDR CALA2018022100727Lens · missingLENS MISSING ON THE EMERGENCY EXIT SIGN ON FLOOR, INSTALLED THE LENS, OK TO CONTINUE.SDR CALA2018022100725Light · brokenSEAT ROW 15C EMERGENCY EXIT LIGHT BROKEN FROM SEAT. REPLACED THE LIGHT ASSEMBLY, OPS CHECKED GOOD. MM 33-51-00. ACCOMPLISHED IDT INSPECTION IAW GMM 09-10-05 & AMM 33-51-00. NO DEFECTS NOTED.SDR CALA2018022100723Light · inoperativeFLIGHT DECK EMERGENCY EXIT LIGHT, INOPERATIVE. INSTALLED AND TURNED ON EMERGENCY LIGHTS, LIGHT CHECKED GOOD IAW AMM 33-51-00.SDR CALA2018022100722Light · inoperativeEMERGENCY LIGHT ABOVE COCKPIT DOOR INOPERATIVE. REMOVED AND REPLACED LIGHT ASSY TESTS PASSED.SDR CALA2018022100720Battery Pack · inoperativeWHILE TROUBLESHOOTING THE EMERGENCY LIGHT INBOUND AHM ITEM, FOUND THE L2 DOOR EMERGENCY LIGHTS INOPERATIVE. REPLACED BOTH CONTROL UNIT BATTERIES IAW MM 33-51-07-02B-720A-A, OPS NORMAL.SDR QXEA2018022100064Light · unknownFORWARD CABIN EMERGENCY LIGHTS ILLUMINATED AFTER AIRCRAFT POWERED DOWN. REMOVED FROM SERVICE. APPLIED EXTERNAL POWER TO ACFT TO TURN OFF EMERGENCY LIGHTS. EMERGENCY LIGHTS OPS TESTED GOOD IAW AMM 33-51-00-710-803. NO DEFECTS NOTED. AIRCRAFT RETURNED TO SERVISDR HALA2018022100031Battery Pack · faultedDURING COMPLETION OF WORK CARD 3351-7008, EPSU BATTERY 14WL FAULTED AT THE NR 2 DOOR. REPLACED THE BATTERY EPSU 14WL.SDR AALA20180220027Light · damagedG2 GALLEY AISLE LIGHT DAMAGED. REPLACED LIGHT ASSEMBLY.SDR DALA2018022101113Power Supply · inoperativeEMERGENCY EXIT SIGN, OVER THE L1 DOOR INOPERATIVE. REPLACED THE POWER SUPPLY IAW AMM 33-51-07.SDR DALA2018022001110Lamp · inoperativeSEAT EMERGENCY LIGHT AT ROW 48 INOPERATIVE. REPLACED THE LAMP. OPS CHECKED OK.SDR AALA201802229025Battery · inoperativeAFT RIGHT FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. MAINTENANCE REPLACED THE BATTERY IAW MM 25-23-00, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802229031Power Supply · inoperativeAIRCRAFT WAS IN HEAVY CHECK. R4 DOOR EMERGENCY POWER SUPPLY (M33408) INOPERABLE. REPLACED EMERGENCY LIGHT POWER SUPPLY (M33408) PER AMM 33-51-06. (SEE CONTROL AALA20180220026)SDR AALA201802219060Lens · missingAIRCRAFT WAS NOT GROUNDED. 1R DOOR EXIT INDICATION LENS COVER IS MISSING. INSTALLED LENS COVER.
Back to JASC 3350