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 AALA201703179027Power Supply · failedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHTS IN BUSINESS CLASS RIGHT AND LEFT SIDE FAILED TEST. REMOVED AND REPLACED POWER SUPPLY M33098 AT R2 DOOR IAW AMM 33-51-06-960-802. OPERATIONAL CHECK GOOD.SDR AALA201703179023Light · disconnectedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE LIGHT IN CEILING BY L2 DOOR IS DISCONNECTED. RECONNECTED LIGHT IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA201703179012Battery Pack · no testCIDS 1 TEST RESULTED IN EPSU FAULT 12WL. REPLACED THE BATTERY PACK IAW AMM 33-51-38, AND ACCOMPLISHED SATISFACTORY OPS CHECK.SDR DALA2017031702183Light · inoperativeDURING B CHECK AFT LT CABIN DOOR SLIDE FAILED EMERGENCY LIGHT TEST, REPLACED AFT LEFT DOOR EMERG SLIDE.SDR DALA2017031702179Lens · unsecureEMERGENCY EXIT COVER DIFFUSER LENS UNSECURE. INSTALLED THE LENS CORRECTLY IAW AMM 33-51.SDR AALA20170315003Power Supply · no testEMERGENCY EXIT LIGHTS FROM ROW 9 TO 13 BOTH AISLES FAILED TO TEST. REMOVED AND REPLACED POWER SUPPLY M33098 IAW AMM 33-51-06-960-802. OPERATIONAL CHECKED GOOD.SDR AALA20170315002Charger · no testDURING TEST, LEFT AFT GROUND SCAN EMERGENCY LIGHT CHARGER FAILED. REPLACED EMERGENCY LIGHT POWER SUPPLY MODULE (M00738) IAW AMM 33-51-00 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR R61A201703150218Power Supply · inoperativeL2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R L2 DOOR EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01. OPS CHECKED GOOD.SDR IPXA2017031615216Sign · detachedR2 EMERGENCY EXIT SIGN FELL OFF THE DOOR. INSTALLED THE EMERGENCY EXIT LIGHT OVER DOOR.SDR SWAA2017031712557Lens · discoloredLEFT EMERGENCY EXIT LIGHT LENS DISCOLORED. R & R THE EMERGENCY LIGHT LENS IAW MM.SDR SWAA2017031712549Light · inoperativeLEFT EMERGENCY LIGHT INOPERATIVE BETWEEN BS 938 TO 955. R & R THE EMERGENCY LIGHT STRIP IAW MM.SDR SWAA2017031712548Light · inoperativeRIGHT EMERGENCY LIGHTS INOP BETWEEN BS 928 TO 953. R & R THE EMERGENCY LIGHT IAW MM.SDR AALA201703169021Lens · missingAFT GALLEY EXIT LIGHT COVERS MISSING LEFT AND RIGHT. INSTALLED AFT GALLEY EXIT LIGHT COVERS.SDR AALA201703169018Cover · missingAIRCRAFT NOT GROUNDED. EXIT ROW -22D. ROUND PLASTIC COVERING MISSING ON EXIT LIGHT ON SIDE OF SEAT. REMOVED AND REPLACED EMERGENCY LIGHT AT SEAT 22D.SDR QXEA2017031600126Light · unsecureEMERGENCY LIGHT IN FRONT OF SEATS 1 AB LOOSE. SECURED THE LIGHT. RETURNED TO SERVICE.SDR SIMA20170315001Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE LAMP IAW AMM 33-50-10-000-801-A, AND 33-50-10-400-801-A. OPS CHECKED GOODSDR DALA2017031502103Battery Pack · inoperativeDURING A SERVICE CHECK, FOUND THE MID CABIN LOWER EMERGENCY EXIT SIGNS INOPERATIVE. TROUBLESHOT THE EMERGENCY LIGHTS IAW FIM 33-50-00 810-801. R & R THE BATTERY PACK IAW 33-51. OPS CHECKED NORMAL.SDR DALA2017031602102Power Supply · inoperativeCABIN CEILING EMERGENCY LIGHTS OF BS 569, 626, 680, 626, AND 706 EXIT SIGN INOPERATIVE. REPLACED THE B5-120 POWER SUPPLY, OPS CHECKED NORMAL IAW AMM 33-51.SDR DALA2017031602101Power Supply · inoperativeDURING A SERVICE CHECK, FOUND THE EMERGENCY EXIT LIGHTS INOPERATIVE AT THE L1 DOOR AND FWD R1 DOOR. REPLACED THE POWER SUPPLY. OPS CHECKED NORMAL IAW AMM 33-51.SDR SWAA2017032112678Battery Pack · dischargedR1 DOOR EXTERIOR EMERGENCY EXIT SIGN INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2017032112677Battery Pack · inoperativeFORWARD LAVATORY MOUNTED EMERGENCY EXIT SIGN INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017032112676Battery Pack · inoperativeRIGHT FORWARD CABIN STOW BIN BULLNOSE EMERGENCY LIGHTS INOPERATIVE BETWEEN ROWS 1 & 2. R & R THE BATTERY PACK IAW AMM.SDR AALA201703179016Battery · no testEMERGENCY BATTERY AT 11WL FAULTED. REPLACED THE BATTERY IAW AMM 33-51-38 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201703169011Seal · brokenFLIGHT ATTENDANT EMERGENCY FLASHLIGHT BY R4 DOOR JUMPSEAT IS INOPERATIVE. REPLACED THE FLASHLIGHT SEAL IAW AMM 25-64-00. OPERATIONAL CHECKED GOOD.SDR SWAA2017031712552Lens · looseLEFT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED THE LENS IAW MM.SDR SWAA2017031712551Lamp · inoperativeBULL NOSE EMERGENCY EXIT LIGHTS INOPERATIVE JUST AFT OF MID CABIN. REPLACED THE LAMPS IAW MM.SDR SWAA2017031712550Lamp · inoperativeEMERGENCY EXIT SIGN ABOVE THE LT OVERWING EXIT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2017031712531Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK M1674 INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2017031712530Cover · missingEMERGENCY LIGHT STRIP MISSING PROTECTIVE COVER AT 9 DEF. R & R THE EMERGENCY LIGHT STRIP IAW MM.SDR SWAA2017031712518Light · brokenFWD ENTRY EMERGENCY EXIT LIGHT BROKEN. R & R THE LIGHT ASSY IAW MM.SDR SWAA2017031712514Lamp · inoperativeLEFT OVERWING EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SWAA2017031712513Lamp · inoperativeBULL NOSE EMERGENCY LIGHT INOP AT ROW 8 DEF. REPLACED THE LAMPS IAW MM.SDR DALA2017031502137Battery Pack · inoperativeCATWALK EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY IAW MM. OPERATIONAL CHECKED GOOD.SDR ASAA2017031420178Lens · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN AT L-2 DOOR HAS BROKEN LENS. GROUNDED - YES. REMOVED AND REPLACED LENS AND TESTED LIGHT ASSEMBLY PER AMM 33-51-01-960-801. OPS NORMAL.SDR AALA201703159004Power Supply · failedEPSU FAULTS DURING TEST. REPLACED EPSU IAW AMM 33-51-38. OPS CHECKED OK.SDR HALA2017031500096Light · unsecureEMER EXIT FLOOR LIGHTING (SEATS 47HJ) NEEDS TO BE RESECURED TO FLOOR. RESECURED FLOOR WAY ILLUMINESCENT STRIP AT 47HJ.SDR DALA2017031502067Lamp · inoperativeRIGHT EMERGENCY EXIT SIGN AT EXIT DOOR INOPERATIVE, REPLACED THE LAMPS.SDR FDEA201703140872Battery Pack · dischargedDURING EMERGENCY LIGHT TEST, L/H EMERGENCY EXIT SIGN AND SLIDE LIGHT WOULD NOT TEST. REMOVED AND REPLACED POSITION 1 EMERGENCY LIGHT POWER SUPPLY BATTERY PACK, OPS CK GOOD.SDR DALA2017031402014Battery Pack · inoperativeFOUND LEFT AND RIGHTT BS 875 OVERWING FWD EMERGENCY EXIT LIGHTS OUT. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-53. OPS CHECKED NORMAL.SDR AALA20170406017Sign · damagedCABIN DOOR R1 EXIT INDICATOR (AFT) FOUND DAMAGED. EXIT INDICATOR (AFT) REPLACED & TEST NORMAL IAW AMM 33-51-01. AIRCRAFT IN BASE MAINTENANCE.SDR AALA20170406016Sign · damagedCABIN - DOOR R2 EXIT INDICATOR (AFT) FOUND DAMAGED, CABIN - DOOR R2 EXIT INDICATOR (AFT) REPLACED & TEST CARRIED OUT NORMAL IAW AMM 33-51-01. AIRCRAFT IN BASE MAINTENANCE.SDR AALA201703169010Lens · missingAIRCRAFT WAS GROUNDED. COVE BULLNOSE EMERGENCY EXIT LIGHT AT 27ABC HAS A MISSING LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECK GOOD. (CLOSED)SDR HALA2017031600098Battery Pack · no testDURING EPSU TEST 3351-7017 HAL, THE L1 AND R4 DOORS EMERGENCY LIGHT BATTERIES FAILED. REPLACED BATTERY PACKS IAW AMM 33-51-38.SDR SWAA2017031712539Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK M1670 INOPERATIVE. R & R THE BATTERY PACK IAW MM.SDR SWAA2017031712515Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK M1674 INOPERATIVE. R & R THE BATTERY PACK IAW MM.SDR REXA2017031300368Charger · inoperativeFWD ENTRANCE COMPARTMENT AFT WALL AND GALLEY TRIM EMERGENCY EXIT LIGHTS FAILED OPS CHECKS. REMOVED AND REPLACED ON EMERGENCY LIGHT BATTERY CHARGER NR 1 IAW CMM 25-60-03. OPS TESTED GOOD IAW AMM 33-51-00-710-802.SDR AALA201703169014Sign · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN ABOVE R3 DOOR IS DETACHED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201703169008Lens · detachedAIRCRAFT WAS NOT GROUNDED. THRESHOLD LIGHT NEAR FLOOR AT L1 DOOR HAS A DETACHED LENS COVER. REPLACED LIGHT IAW AMM 33-14-00. OPERATIONAL CHECK GOOD.SDR AALA201703169006Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT IDENTIFIER IN THE AFT GALLEY RIGHT SIDE HAS A BROKEN LENS COVER. REMOVED AND REPLACED EXIT IDENTIFIER ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201703169001Lens · detachedSEAT MOUNTED EMERGENCY LIGHT AT SEAT 3A HAS A DETACHED LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-10. OPERATIONAL CHECKED GOOD.
Back to JASC 3350