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 SWAA2017010410909Cover · brokenAFT LAVATORY MOUNTED EMERGENCY LIGHT COVER BROKEN. R & R THE COVER IAW MM.SDR SWAA2017010410901Cover · brokenG4 GALLEY MOUNTED EMERGENCY EXIT LIGHT COVER BROKEN. R & R THE COVER IAW MM.SDR SWAA2017010410900Cover · brokenG1 GALLEY MOUNTED EMERGENCY LIGHT COVER BROKEN. R & R THE COVER IAW MM.SDR SWAA2017010410899Cover · brokenFORWARD LAVATORY MOUNTED EMERGENCY EXIT SIGN COVER BROKEN. R & R THE COVER IAW MM.SDR AALA20161229018Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. AFT CABIN DOOR 2R EMERGENCY LIGHT POWER PACK M33098 FOUND INOPERABLE. REPLACED POWER PACK M33098 PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2016123010850Battery Pack · inoperativeLEFT OVERWING EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK ASSY IAW MM.SDR SWAA2016123010849Battery Pack · inoperativeRIGHT OVERWING EXIT LIGHT INOPERATIVE. R & R THE BATTERY PACK ASSY IAW MM.SDR AALA201612299012Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY SEAT LIGHT INOPERATIVE AT ROW 23 LEFT. REPLACED ROW 23 EMERGENCY LIGHT HOUSING PER AMM 33-50-00.SDR AALA201612279011Lens · missingAIRCRAFT WAS NOT GROUNDED. MISSING EMERGENCY LIGHT LENS AT ROW 9 RIGHT. REPLACED EMERGENCY LIGHT COVER PER AMM 33-50-00.SDR AALA20161228023Light · brokenEMERGENCY EXIT LIGHT AT R1 DOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR N6WA2016122601Light · unknownEXIT LIGHT ON MAIN CABIN DOOR INOPERATIVE. PERFORMED OPS CHECK OF EMERGENCY LIGHTS IAW AMM 33-51-00. OPS CHECKED GOOD.SDR AALA201612279009Lens · missingMISSING COVER ON EXIT LIGHT BY RIGHT AFT EMERGENCY SLIDE. REPLACED EXIT LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201612279007Light · no testRIGHT FLOOR EMERGNECY LIGHT INOPERATIVE, ROWS 1 TO 11. REPLACED THE LIGHT AND ACCOMPLISHED SATISFACTORY OPEARTIONAL CHECK.SDR AALA201612279006Light · defectiveTHREE RIGHT EXTERIOR DOOR EXIT LIGHTS INOPERTIVE. SECURED THE EXTERIOR EXIT LIGHTS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR YENA201612261118Light · malfunctionedDURING TAXI OUT, WITH BOTH ENGINES RUNNING, THE CABIN EMERGENCY LIGHT SYSTEM ACTIVATED ; RESET ALL POWER EMERGENCY EXIT LIGHTS. OPS CHECK NORMAL IAW AMM 24-38-00.SDR HALA2016122710095Cover · detachedEMERGENCY LIGHT STRIP DETACHED AT 44/45. INSTALLED AND SECURED THE LIGHT STRIP COVER.SDR HALA2016122710094Sign · detachedEXIT SIGN FELL OFF AT DOOR 2R. REPLACED DOOR 2R EXIT SIGN.SDR ASAA2016122619169Lens · detachedEMERGENCY LIGHT EXIT SIGN LENS FALLING OFF OF LIGHT ASSY AT L-2 DOOR. ACFT GROUNDED. REMOVED AND REPLACED THE LENS AND TESTED LIGHT ASSY IAW AMM 33-51-01-960-801 - OPS NORMAL.SDR A6WA2016122844699Light · malfunctionedALL EMERGENCY LIGHTS WILL TURN ON FOR 3 SECONDS, THEN ALL TURN OFFSDR ASOA201612263089Battery · inoperativeDURING ROUTINE MAINTNENACE, BOTH OVERWING EMERGENCY LIGHTS WERE FOUND INOPERATIVE. MAINTENANCE REPLACED THE NR 4 EMERGENCY LIGHT BATTERY. OPERATIONAL CHECKS WERE GOOD.SDR YENA201612261107Battery Pack · failedR2 DOOR LOWER RED EMERGENCY EXIT LIGHT INOPERATIVE. R & R EMERGENCY EXIT SIGN & EPSU BATTERY. OPS TEST PASSED IAW AMM 33-50-01 & 33-50-15.SDR MASA2016122612774Bulb · inoperativeONE BULB AT 14AC LOWER EXIT SIGN INOPERATIVE.SDR ASMF201612018Battery Pack · dischargedDURING TRANSIT CHECK, FLOOR EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE DETECTED THE BATTERY PACK DISCHARGED IAW AMM 33-51-00. THE BATTERY PACK WAS CHARGED IAW AMM 33-51-00, TESTED CORRECT.SDR DALA2016123010165Light · inoperativeRED EMERGENCY LIGHT BY CREW REST DOOR INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW WDM 33-51-57 AND WSPM 20-30-12.SDR AALA201612269003Lens · missingEMERGENCY EXIT LIGHT LENS AT THE R1 DOOR MISSING. INSTALLED A NEW LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201612269002Light · detachedLOWER RIGHT EXIT LIGHT ON THE L4 DOOR HAS BEEN KNOCKED OFF. REPLACED EXIT LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201612269001Lens · missingSEAT MOUNTED EMERGENCY LIGHT AT ROW 14 MISSING IT`S LENS. INSTALLED THE LENS IAW AMM 33-51-19. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECKS.SDR AALA20161228020Lens · brokenEMERGENCY EXIT SIGN LENS COVER OVER THE R4 DOOR IS BROKEN. REPLACED LENS COVER. OPERATIONAL CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA20161228019Lens · missingEMERGENCY EXIT SIGN NEAR L1 DOOR FORWARD GALLEY BULKHEAD FLOOR HAS A MISSING LENS COVER. INSTALLED NEW LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20161228018Sign · looseEMERGENCY EXIT SIGN BY R3 DOOR OVERHEAD NEAR SEAT 26H IS LOOSE. SECURED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20161228008Lens · detachedEMERGENCY EXIT SIGN AT L4 DOOR HAS A DETACHED LENS COVER. REINSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR ASAA2016122519143Bulb · failedEMERGENCY LIGHT EXIT LOCATOR SIGN AT LEFT FORWARD OVERWING EXIT HAS MULTIPLE LAMPS INOPERATIVE, ALSO AT LEFT AFT OVERWING EXIT AND EMERGENCY LIGHT EXIT LOCATOR SIGN AT R-2 DOOR. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-01-960-801. OPS NORMASDR ASAA2016122519142Lens · missingROW 16DEF EMERGENCY EXIT LIGHT MISSING LENS COVER. ACFT GROUNDED. REMOVED & REPLACED THE EMERGENCY LIGHT ASSY IAW 33-51-01-960-802. OPS CHECKED GOOD.SDR SWAA2016122710795Lens · looseFWD ENTRY EXIT LIGHT LENS LOOSE. SECURED THE LENS IAW MM.SDR UIEA2016122701054Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACKS IAW AMM 33-51-07. OPS GOOD.SDR JJBA20161225022Battery Pack · unsecureCEILING EMERGENCY LIGHT AT ROW 7 INOPERATIVE. RESEATED EMERGENCY EXIT BATTERY.SDR DALA2016122610065Power Supply · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTS FOR THE CATWALK WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY AND POWER SUPPLY FOR THE NOTED LIGHTED AREAS AND THE OPERATIONAL CHECK WAS GOOD. (LP #9077376)SDR AALA20161225001Powerpack · inoperativeAIRCRAFT IN BASE MAINTENANCE. DOOR 2L OVERHEAD POWERPACK (M33096)EMERGENCY LIGHTS WILL NOT COME ON AND CANNOT RECHARGE BATTERY. REPLACED OVERHEAD POWERPACK (M33096) PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161223020Light · inoperativeAIRCRAFT IN BASE MAINTENANCE. CABIN ZONE 1 RIGHT HAND EMERGENCY LIGHT ASSEMBLY (L33873) FOUND INOPERABLE. REPLACED EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-00.SDR ASOA201612241377Light · inoperativeEMERGENCY LIGHT OVERWING RT SIDE INOPERATIVE. REMOVED & REPLACED RT SIDE OVERWING AFT LIGHT ASSY IAW AMM 33-51-15 OPS CHECKED GOOD.SDR SWAA2016122910843Battery Pack · no testEMERGENCY LIGHT FAILED A CAPACITY CHECK. R & R THE BATTERY PACK IAW MM.SDR SWAA2016122910842Battery Pack · no testEMERGENCY LIGHT FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW MM.SDR SWAA2016122910841Battery Pack · no testEMERGENCY LIGHT FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW MM.SDR AALA201612259004Battery · no testEMERGENCY POWER SUPPLY UNIT FAILS TEST. REPLACED THE BATTERY AT 15WL IAW 33-51-38-401.SDR AALA201612259003Battery · no testEMERGENCY POWER SUPPLY UNIT FAILS TEST. REPLACED BATTERY AT 18WL IAW 33-51-38-401.SDR AALA20161228006Sign · brokenEMERGENCY EXIT SIGN AT AFT EXIT DOOR IS BROKEN. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20161228004Pin · brokenEMERGENCY EXIT SIGN AT SEAT 24J HAS A BROKEN MOUNT. REPLACED ROLL PINS AT MOUNT IAW AMM 33-51-01. OPERATIONAL CHECK GOOD. AIRCRAFT NOT GROUNDED.SDR SCNA20161228380Power Supply · inoperativeEMERGENCY EXIT LIGHT POWER SUPPLY M1694 AT BS 595, WL 213, LBL 68 IS INOPERATIVE. REPLACED POWER SUPPLY. OPS CHECK PERFORMED. OPS CHECK GOOD.SDR REXA2016122402496Light · inoperativeLEFT FORWARD EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R THE EMERGENCY LIGHT IAW AMM 33-51-15. OP CHECKED GOOD.SDR REXA2016122402495Battery Pack · inoperativeDURING WALK AROUND FOUND CABIN LT OVERWING EMERGENCY LIGHTS ON. EVEN SWITCH WAS IN OFF POSITION. REMOVED & REPLACED THE BATTERY PS 37 IAW AMM 33-51-17. OPS CHECKED GOOD
Back to JASC 3350