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 AALA201809179011Battery Pack · no testBATTERY PACK M1695 FAILED A FUNCTIONAL CHECK IAW CARD 2908. REPLACED THE BATTERY PACK IAW MM 33-51-06. OPS CHECKED OK.SDR AALA201809179009Battery Pack · no testBATTERY PACK M1694 FAILED A FUNCTIONAL CHECK IAW CARD 2908. REPLACED THE BATTERY PACK. OPS CHECKED OK.SDR AALA201809179006Battery Pack · no testBATTERY PACK M1674 FAILED A FUNCTION CHECK IAW CARD 2908. REPLACED THE BATTERY PACK IAW MM 33-51-06. OPS CHECKED OK.SDR SWAA2018091725224Cover · abnormalL1 EMERGENCY EXIT SIGN FELL OFF. SECURED COVER PER SIP.SDR DALA2018091705633Lens · unsecureEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. SECURED COVER. OK FOR SERVICE.SDR REXA2018091400857Light · looseEMERGENCY FLOOR LIGHTNING INOP AT EMERGENCY EXIT ROW. FOUND EMER FLOOR LIGHT LOOSE. RESECURED IAW AMM 33-51-01. OP CHECK GOOD, OK FOR SVC.SDR DALA2018091405605Sign · unsecureDOOR 2R EXIT SIGN FELL OFF. REPLACED EXIT SIGN.SDR AALA201809149019Power Supply · faultedDURING AN EMERGENCY LIGHT CIDS CHECK, EMERGENCY POWER SUPPLY UNIT BATTERY EMERGENCY LEFT WARNING MESSAGE ILLUMINATED. MAINTENANCE REPLACED LEFT OVERWING EPSU 11WL IAW AMM 33-51-38-400-001-A.SDR AALA20180914007Power Supply · inoperativePASSENGER CABIN DOOR EMERGENCY EXIT SIGNS WOULD NOT ILLUMINATE DURING A TEST. REPLACED THE POWER SUPPLY M33094 IAW AMM 33-51-06-900-803, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201809149004Lamp · burned outOVERWING EXITS INSIDE EMERGENCY HANDLE LIGHT LAMPS WERE BURNED OUT. REPLACED THE LAMPS IAW 33-50-10. OPS CHECKED GOOD.SDR AALA20180914006Power Supply · inoperativeFLOOR EMERGENCY LIGHTS WERE INOPERATIVE. REPLACED THE POWER SUPPLY M33094 IAW AMM 33-51-06-960-803.SDR AALA201809149007Lens · brokenTHE L1 DOOR EXIT SIGN LENS WAS BROKEN. INSTALLED A NEW SIGN LENS.SDR AALA20180914003Power Supply · inoperativeLEFT AND RIGHT FLOOR EMERGENCY LIGHTS FROM SEATS 26 - 40 WERE INOPERATIVE. REPLACED THE POWER SUPPLY M33401 IAW AMM 33-51-06-960-803. TESTED GOOD.SDR AALA201809143002Battery Pack · inoperativeSEAT EMERGENCY LIGHTS FROM CENTER SEAT 27 TO SEAT 40 WERE INOPERATIVE. REPLACED THE POWER SUPPLY BATTERY PACK M33401 IAW AMM 33-51-00, AND TESTED GOOD IAW AMM 33-5-06.SDR AALA201809143001Battery Pack · inoperativeFORWARD AFT EMERGENCY EXIT SIGN, ADJACENT TO THE R3 DOOR WAS INOPERATIVE. REPLACED THE POWER SUPPLY BATTERY PACK IAW AMM 33-51-00, AND TESTED GOOD IAW AMM 33-51-06.SDR DALA2018091405596Lens · crackedOVERHEAD EXIT SIGN LENS BETWEEN SEAT ROWS 33 HAS CRACKS AT BOTH ENDS. REPLACED LENS AT ROW 33 PER AMM 33-51-10.SDR MASA2018091311367Light · inoperativeROW 11 EMERG OVERHEAD FLOOD LAMP INOP. PLACED ON MEL.SDR DALA2018091305578Battery · dischargedON SVC CHK FOUND LEFT AND RIGHT AFT OVERWING EXIT SIGN IDENTIFIERS LAMPS INOP. REMOVED AND REPLACED BATTERY PACK SUPPLY BATTERIES PER AMM 33-53. OPS CHK GOOD.SDR HALA2018091305603Light · unsecureEMERGENCY LIGHT STRIP LOOSE AT SEAT 1HJ. SECURED THE LIGHT STRIP.SDR CALA2018091701937Charger · burnedSUPPORT TASK-COCKPIT P11 PANEL H18 ''4L & 4R EMER LIGHT'' CIRCUIT BREAKER FOUND AUTO POPPED OUT. BATTERY CHARGER OF DOOR 4R FWD PWR BATT M33408 REPLACED AND OPERATION TEST RESULT NORMAL IAW AMM 33-51-06.SDR SWAA2018091725288Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER MM.SDR SWAA2018091725245Sign · missingOVERWING EXIT SIGN MISSING. INSTALLED SIGN PER SIP.SDR SWAA2018091725229Cover · brokenMID CABIN EMERGENCY EXIT SIGN LIGHT BROKEN. REINSTALLED LIGHT COVER IAW SIP.SDR SWAA2018091725226Lens · unsecureMID CABIN EMERGENCY EXIT SIGN COVER FELL OFF. REINSTALLED LENS PER AMM.SDR SWAA2018091725211Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK OVERRIDE PANEL AT LOCATION M1669 INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018091725209Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER MM.SDR SWAA2018091725208Glowstrip · delaminatedLT PHOTOLUMINESCENCE STRIP DELAMINATED AT ROW 1. R&R STRIP PER AMM.SDR IPXA2018091433918Battery · dischargedLEVEL ONE MSG EMERG LIGHT BAT 1 LOW. R&R EMERGENCY POWER SUPPLY BATTERY IAW AMM 33-51-01-000-802. OPS CK GOOD.SDR IPXA2018091433917Battery · dischargedEMERGENCY LIGHT BAT 1 LO ALERT. EMER LIGHT BATTERY PWR SUPPLY REPLACED IAW AMM 33-51-01. OPS CK OK.SDR AALA201809149024Battery Pack · dischargedDFW - THE AIRCRAFT WAS GROUNDED. REPLACED BATTERY PACK FOR ITEM 2 BS-107. SUSPECT BAD FROM STOCK. BATTERY PACK WAS REPLACED. (SEE ALSO SDR AALA201809149023)SDR AALA201809149023Battery Pack · dischargedDFW - THE AIRCRAFT WAS GROUNDED. CEILING EMERGENCY LIGHTS AT AFT SERVICE DOOR AND ROWS 28-30 INOP. MAINTENANCE REMOVED AND REPLACED BATTERY PACK B5-107 OPS CHECKS GOOD REF WDW 33-51-12. (SEE ALSO SDR AALA201809149024).SDR AALA2018091439034Switch · malfunctionedCABIN EMERGENCY LIGHTS REMAINED ON WITH SWITCH TURNED OFF. MAINTENANCE REPLACED THE SWITCH 4WL AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER ESPM 20-45-21.SDR AALA2018091439032Sign · missingCABIN EMERGENCY EXIT SIGN ON SIDWALL, JUST BEHIND FORWARD GALLEY OVENS, WAS MISSING. MAINTENANCE REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-14 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018091439031Battery Pack · no testDURING WORK CARD 2312 ACCOMPLISHMENT, FOUND THE BATTERY PACK INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-51-06, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR R61A2018091420959Battery · faultedEMERGENCY LIGHT BATTERY FAULT EICAS MESSAGE. R&R EMERGENCY LIGHT POWER UNIT BATTERY IAW AMM 33-50-01.SDR IPXA2018091433903Sign · brokenLEFT ENTRY DOOR EXIT SIGN BROKEN. R&R EXIT SIGN ASSY REF 33-27-01. OPS CHECK GOOD 33-27-01-05.SDR DALA2018091305589Battery Pack · dischargedON S/C FOUND EMER LIGHTS OUT AT ROWS 18-22 AND DOOR 2L. REMOVED AND REPLACED BATTERY PACK AT M732 PER AMM 33-51. CHECKS GOOD.SDR MASA2018091211366Light · inoperativeROW 8 EMERG OVRHD FLOODLIGHT INOP. PLACED ON MEL.SDR U2RA201809110001Sign · damagedUPPER DECK EMERGENCY EXIT SIGN DAMAGED. REPLACED EMERGENCY EXIT SIGN ASSEMBLY PER AIRCRAFT MAINTENANCE MANUAL 33-51-00.SDR YENA2018091310338Battery · faultedFLT 1730, RSW-JFK. WHILE PREFORMING TASK CARD A320-33-51-00-710-003 FOUND ROW II ABC EMERGENCY BATTERY FAULTED. REPLACED EMERGENCY BATTERY AND EPSU.SDR SIMA2018100511004Light · damagedFOUND NR 6 FLOOR LIGHTS AND EXTRUSION DAMAGED.-C/A-REMOVED AND REPLACED NR 6 FLOOR LIGHT AND EXTRUSION IAW SWPM 20-21-00. FOUND DURING OPEN UP.SDR SWAA2018091725145Lens · unsecureEXIT LIGHT COVER FELL OFF. INSTALLED LENS PER SIP.SDR YENA2018091710343Battery · failedFLT 1730, RSW-JFK. WHILE PREFORMING TASK CARD A320-33-51-00-710-003 FOUND 2L DOOR CEILING EPSU FAULTED. REPLACED EMERGENCY BATTERY & EPSU IAW 33-51-38 OPS CK OKAY.SDR YENA2018091710342Epsu · faultedFLT 1730, RSW-JFK. WHILE PREFORMING TASK CARD A320-33-51-00-710-003 FOUND 2L DOOR CEILING EPSU FAULTED. REPLACED EMERGENCY BATTERY & EPSU IAW 33-51-38 OPS CK OKAY.SDR YENA2018091710341Battery · failedFLT 1730, RSW-JFK. WHILE PREFORMING TASK CARD A320-33-51-00-710-003 FOUND 1L DOOR CEILING EPSU FAULTED. REPLACED EMERGENCY BATTERY & EPSU IAW AMM 33-51-38. OPS CK OKAY.SDR YENA2018091710340Epsu · faultedFLT 1730, RSW-JFK. WHILE PREFORMING TASK CARD A320-33-51-00-710-003 FOUND 1L DOOR CEILING EPSU FAULTED. REPLACED EMERGENCY BATTERY & EPSU IAW AMM 33-51-38. OPS CK OKAY. SUPPLEMENTAL INFORMATION TO FOLLOW.SDR DALA2018091205606Light · brokenOVERAWING ESCAPE LIGHT, SEAT 21D, BROKEN. SECURED LIGHT IN NEW HOUSING AND TESTED. CHECKS GOOD.SDR AALA2018091429024Charger · inoperativeEMERGENCY LIGHTS AT SEAT 23B WERE INOPERATIVE. REPLACED THE BATTERY CHARGER.SDR DALA2018091405601Battery Pack · dischargedEMERGENCY ESCAPE PATH LIGHTS FROM SEAT 51F TO 57F INOP. DEEP CYCLED BATTERY PACK PER AMM 33-51-06 AND OK. CONFIRMED ALL LIGHTS WORKS NORMAL.SDR DALA2018091405600Battery Pack · dischargedEMERGENCY ESCAPE PATH LIGHTS FROM SEAT 51F TO 57F INOP. DEEP CYCLED BATTERY PACK PER AMM 33-51-06 AND OK. CONFIRMED ALL LIGHTS WORKS NORMAL.
Back to JASC 3350