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 WX0A2020022073474Epsu · no testWHILE PERFORMING EMERGENCY LIGHT TEST GOT A BAT/ EPSU 13WL AFT L MSG. / REPLACED EPSU BATTERY ON EPSU"SDR AALA2020022099011Power Supply · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTING WAS INOPERABLE AT LEFTHAND FORWARD EXIT SIGN 41WL, SEAT 1C, SEAT 4C, AND CEILING PANELS ROW 1, 4, AND 8. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38.SDR SWAA2020022041606Battery Pack · no testEMERGENCY EXIT LIGHT BATTERY PACK M1670 FAILED BATTERY PACK CAPACITY CHECK. / R&R BATTERY PACK M1670 IAW AMM.SDR SWAA2020022041599Socket · damagedG1 GALLEY LOWER EMERGENCY EXIT LIGHT HAD DAMAGED BULB SOCKET. / R&R LIGHT PER AMM.SDR SWAA2020022041587Battery Pack · no testFORWARD L/H EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. / R&R BATTERY PACK PER MM.SDR SWAA2020022041586Battery Pack · no testAFT R/H EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. / R&R BATTERY PACK PER MM.SDR SWAA2020022041584Sign · detachedFRONT FACE OF OVERHEAD EXIT SIGN WAS DETACHED. / REATTACHED OVERHEAD EXIT LIGHT ASSEMBLY PER AMM.SDR SWAA2020022091543Lens · missingCEILING EMERGENCY EXIT ROW SIGN WAS MISSING THE LENS ON THE REAR SIDE. / REINSTALLED LENS PER MM.SDR WX0A20200219475Power Supply · no testWHILE PERFORMING EMERGENCY LIGHT TEST GOT A BAT/ EPSU 13WL AFT L MSG. / REMOVED AND REPLACED EPSU BATTERY ON EPSU 13WL REF A319 AMM 33-51-58 PB401. OPS CHECK GOOD."SDR SIMA202002198003Light · inoperativeR/H OVERWING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED R/H OVER WING EMERGENCY LIGHT IAW EMB AMM 33-50-07-000-801-A AND 33-50-07-400-801-A OPC GOOD ENDSDR SIMA202002198002Lamp · inoperativeOVERWING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED OVRWING EMERGENCY LIGHT LAMP I.A.W. 33-50-10. OPS GOOD. NO FUTHER DEFECTD NOTED.SDR DALA2020021801205Sign · inoperativeTHE EMERGENCY EXIT SIGN IS INOPERATIVE AT 603. EXIT PLACARD MISSING ON CEILING EXIT SIGN AT WINDOW EXITS. MAINTENANCE FOUND THE MISSING EXIT SIGN LENS AND REINSTALLED IT IN SERVICEABLE CONDITION. OPERATIONAL CHECK WAS GOOD. AIRCRAFT IS NOW OK FOR SERVICE. (LP SDR DALA2020021801204Sign · inoperativeTHE EMERGENCY EXIT SIGN IS INOPERATIVE AT 602. EXIT PLACARD IS MISSING ON CEILING EXIT SIGN AT WINDOW EXITS. MAINTENANCE FOUND THE MISSING EXIT SIGN AND REINSTALLED IT IN SERVICEABLE CONDITION. OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT IS OK FOR SERVICE. (LP #1SDR SIMA2020040617009Light · damagedLH FLOOR EMERGENCY LIGHT STRIP EXTRUSIONS #3,AND #8 ARE DAMAGED-C/A-COMPLETE:REPLACED LH FLOOR EMERGENCY LIGHT STRIP EXTRUSIONS #3,AND #8 IAW AMM 33-50-12SDR SIMA2020040617007Light · inoperativeLH FLOOR EMERGENCY LIGHT STRIP #8 EXTRUSION ARE DAMAGED-C/A-COMPLETE:REPLACED #8 LH FLOOR EMERGENCY LIGHT STRIP EXTRUSION IAW AMM 33-50-12.SDR SIMA2020040617006Light · damagedEMERGENCY FLOOR LIGHTING LH EXTRUSION FOR RAMP PANEL IS DAMAGED.-C/A-COMPLETE:REMOVED AND REPLACED EMERGENCY FLOOR LIGHTING LH EXTRUSION FOR RAMP PANEL IAW AMM 33-50-12.SDR SIMA2020040617008Light · corrodedFORWARD BELLY FAIRING, LH EXTERIOR EMERGENCY LIGHT CORRODED.-C/A-COMPLETE:RRMOVED AND REPLACED RETAINER RING IAW SRM 51-40-02SDR DALA2020022001263Battery Pack · inoperative(LOG 6860718) DURING INSPECTION FOUND EMERGENCY LIGHT BATTERY PACK M1671 AT SIDE WALL ROW 23D FAILED OPERATIONAL CHECK. R/R EMERGENCY LIGHT BATTERY PACK M1671 PER B737 AMM 33-51. OPS CHECK NORMAL.SDR REXA2020022070213Power Supply · inoperativeEMERGENCY FLOOR LIGHTS ROW 9 TO 13 INOP
RESECURED PWR SUPPY STRIP @ AFT CABIN FLOO. OPS CHECK GOOD. C/W IAW 33-51-00.SDR SWAA2020022094559Lamp · inoperativeOUTBOARD LEFT LAMP ON FORWARD CLOSEOUT PANEL EMERGENCY LIGHT ASSEMBLY WAS INOPERATIVE. / RELAMPED LIGHT ASSEMBLY PER AMM.SDR SWAA2020022094558Light · inoperativeBOTH L/H & R/H LOWER EMERGENCY EXIT SLIDE LIGHTS WERE INOPERATIVE. / R&R SLIDE LIGHTS PER AMM AND WDM.SDR SWAA2020022091557Lamp · inoperativeEMERGENCY EXIT DOME LIGHT L00273 IN COCKPIT WAS INOPERATIVE. / R&R LIGHT LAMP PER AMM.SDR SWAA2020022091549Battery Pack · no testEMERGENCY LIGHTING BATTERY PACK AT R/H OVER WING EXIT FAILED CAPACITY CHECK. / R&R BATTERY PACK PER MM.SDR SWAA2020022091548Battery Pack · no testAFT R/H EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. / R&R BATTERY PACK PER MM.SDR SWAA2020022091547Battery Pack · failedAFT L/H EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. / R&R BATTERY PACK PER MM.SDR SWAA2020022091546Lamp · inoperativeFORWARD SERVICE DOOR EMERGENCY LIGHT INOPERATIVE. / R&R (RELAMPED) PER AMM.SDR SWAA2020022091545Lens · detachedEMERGENCY EXIT AISLE LIGHT LENS WAS DETACHED. / REINSTALLED LENS PER SIP.SDR PNSA20200219704Light · unsecureEMERGENCY TRACK LIGHTING AT ROW 2 COMING OFF, RE-SECURED.SAAB SB2000-33-003 ORDERED AND TO BE INSTALLED ASAPSDR AALA202002199012Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS FROM SEAT 16 TO 20 RIGHTHAND, INOPERABLE DURING BATTERY TEST. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-06.SDR SWAA2020021941453Lens · missingMID CABIN FORWARD FACING OVERHEAD EXIT SIGN MISSING. / INSTALLED LENS IAW MM.SDR SWAA2020021984468Lamp · inoperativeFORWARD ENTRY SLIDE EMERGENCY LIGHT INOP. / RELAMPED LIGHT PER MM.SDR ASAA2020021873204Retainer · brokenON PREFLIGHT, F/A REPORTS L2 EXIT/SALIDA SIGN MISSING. GROUNDED - YES. INSPECTED AND FOUND EXIT SIGN COVER RETENTION TAB BROKEN OFF, REMOVED AND REPLACED L2 FLOOR LEVEL EMERGENCY LIGHT ASSY REF B737-900 AMM 33-51-14, OPS CHECK GOOD.SDR QXEA2020021800109Light · detachedPHOTO LUMINESCENT STRIP IN FRONT OF ROW 1 DETACHED. REMOVED FROM SERVICE. REINSTALLED FLOOR STRIP AND SECURED. NO OTHER DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE.SDR DALA2020021801226Lens · missing(AIRCRAFT 7102, L/P 6895794) MULTIPLE RED LENS COVERS MISSING IN CABIN EMERGENCY ESCAPE PATHWAY LIGHTS. CORRECTIVE ACTION: REPLACED MISSING RED LENS COVERS.SDR MASA2020021500068Bulb · inoperativeROW 13 FLOOR EMERG EXIT SIGN 1 BULB INOP- PLACED ON MELSDR YENA2020022060191Light · failedFT # EWR-TPA. L2 DOOR ESCAPE SLIDE LIGHTING FAILED EMERGENCY LIGHT TEST ( ESCAPE SLIDE LIGHTING ); R & R L2 DOOR SLIDE IAW AMM 25-62-44-400-007-A DOOR OPS CHECK OK, EMERGENCY LIGHT SYSTEM TEST OK , THIS CLEARS MDDR#415365, MX-4 UPDATED, PLCARD REMOVED.SDR YENA2020022060190Battery · no testFT # 1054, PBI-JFK. DURING OPS CHK OF EMERGENCY LIGHT BEFORE SLIDE L/H DOOR REPLACEMENT, FOUND 10 WL BATTERY FAULT; R & R EPSU BATTERY 10WL IAW AMM 33-51-58. CHKS NORMALSDR YENA2020022060189Battery · no testFT # 273, EWR-TPA. EMERGENCY LIGHT TEST FAILED; REMOVED & REPLACED EMERGENCY LIGHT BATTERIES 12WL & 13WL PER AMM 33-51-38SDR YENA2020022060188Battery · failedFT # 273, EWR-TPA. EMERGENCY LIGHT TEST FAILED; REMOVED & REPLACED EMERGENCY LIGHT BATTERIES 12WL & 13WL PER AMM 33-51-38SDR SWAA2020022041598Lamp · inoperativeAFT SERVICE DOOR EMERGENCY EXIT INDICATOR (L1191) HAD INOPERATIVE LAMPS. / R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2020022041597Lamp · inoperativeLEFT OVERWING EMERGENCY EXIT INDICATOR (L1189) AND RIGHT OVERWING EMERGENCY EXIT INDICATOR(L1358) HAD INOPERATIVE LAMPS. / REPLACED LAMPS ON LEFT & RIGHT OVERWING EMERGENCY EXIT INDICATORS & PERFORMED A GOOD TEST OF THE NEW LAMPS PER AMM 33-51-01-960-SDR SWAA2020022041596Charger · inoperativeFORWARD ENTRY OVER DOOR EMERGENCY EXIT SIGN (L1067) AND FORWARD SERVICE EMERGENCY EXIT INDICATOR (L1186) HAD INOPERATIVE LAMPS. / REPLACED M1674 BATTERY CHARGER & PERFORMED GOOD TEST PER AMM 33-51-06-960-805. RELAMPED FWD ENTRY OVER DOOR EMERGENCY EXISDR DALA2020021801225Lamp · inoperative(AIRCRAFT 7003, L/P 6432173) DOOR R3 EXT SLIDE/OVERWING LIGHT OUT. CORRECTIVE ACTION: RELAMPED R3 EXT SLIDE/OVERWING LIGHT & CKD OK PER B777 AMM 33-51-04.SDR DALA2020021801224Lamp · inoperative(AIRCRAFT 7003, L/P 6432172) DOOR L1 EXT SLIDE/OVERWING LIGHT OUT. CORRECTIVE ACTION: RELAMPED L1 EXT SLIDE/OVERWING LIGHT & CKD OK PER B777 AMM 33-51-04.SDR DALA2020021761190Housing · damagedROW 32ABC EMERGENCY PATH LIGHT HOUSING DAMAGED, R/R EMERGENCY PATH LIGHT HOUSINGSDR SIMA202002176003Bulb · inoperativeUPPER LH EMERGENCY LIGHT ON THE EXTERIOR OF A/C FOUND INOP-C/A-REMOVED AND REPLACED OF LIGHT BULB IN UPPER LH EXTERIOR OF A/C IAW EMB145 AMM 33-50-11. OPS CHECK GOOD EMERGENCY LIGHT OPERATIVESDR AALA202002179010Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK, EMERGENCY LIGHTS TEST FAILED ON DOOR 4R. MAINTENANCE REPLACED BATTERY PACK ABOVE DOOR 4R PER AMM 33-51-06-960-802.SDR UIEA2020021700261Battery Pack · inoperativeFOUND EMERGENCY BATTERY PACK (M14533) INOP.(<P>IAW AMM 33-51-04-902-001-001 REV. 97, REPLACED EMERGENCY BATTERY PACK AT M14533 AND CONDITION CHECK NORMAL. IAW AMM 33-51-04-902-001-001 REV. 97, PERFORMED POWER SUPPLY TEST AND THE RESULT WAS SATISFACTORY.</P>)SDR SWAA2020030442103Lens · crackedPASSENGER CABIN SMALL EMERGENCY LIGHT LENSE AND RETAINER IN LIGHT BALENCE ABOVE SEAT ROW 23 ABC STOWBIN PLACARD HAS MULTIPLE CRACKS REPLACED LIGHT LENSE ON SEAT ROW (23 ABC) STOWBIN ON BULL NOSE PANEL I/A/W B737-800 AMM 35-51-03-960-803 (A23942)SDR WX0A2020022073473Epsu · no testL/H OVERWING EPSU BATTERY (11WL) FAILED EPSU TEST. / REPLACED EPSU BATTERY"
Back to JASC 3350