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 I5EA2021020900005Battery Pack · no testEMERGENCY BATTERY PACK DEAD AT M1134 DISC D2960 STA 634L.. REMOVED AND REPLACED BATTERY PACK AT M1134 STA 634L IAW B737-300 AMM 33-51-02. OPS CHECK GOOD.SDR I5EA2021020900004Battery Pack · no testEMERGENCY BATTERY PACK DEAD AT M1133 DISC D2958 STA 326L.. REMOVED AND REPLACED BATTERY PACK AT M1133 STA 326L IAW B737-300 AMM 33-51-02. OPS CHECK GOOD.SDR I5EA2021020900003Battery Pack · no testEMERGENCY BATTERY PACK DEAD AT M1137 DISC D2966 STA 975R.. REMOVED AND REPLACED BATTERY PACK AT M1137 STA. 975R IAW B-737-300 AMM 33-51-02. OPS CHECK GOOD.SDR I5EA2021020900002Battery Pack · no testEMERGENCY BATTERY PACK DEAD AT M1197 DISC D3122 STA 960L.. REMOVED AND REPLACED BATTERY PACK AT M1197 STA. M960L IAW B-737-300 AMM 33-51-02. OPS CHECK GOOD.SDR I5EA2021020900001Battery Pack · no testEMERGENCY BATTERY PACK DEAD AT M1135 DISC D2962 STA 622R.. REMOVED AND REPLACED BATTERY PACK AT M1135 STA 622R IAW B-737-300 AMM 33-51-02. OPS CHECK GOOD.SDR WX0A2021031773662Epsu · no testNRC 7000-0007: ALL OUTPUT LIGHT OF EPSU 11WL (MID L/H CABIN) FOUND INOP DURING EMERGENCY LIGHT TEST. / EPSU 11WL (MID L/H CABIN) REPLACED IAW AMM 33-51-38-400-001-A. SEE AWS FOR TESTING."SDR SWAA2021021248135Battery · no testCABIN EMERGENCY LIGHT BATTERY FAILED LONG TEST (MID L/H) / REMOVED AND REPLACED PER AMM.33-51-06SDR UIEA2021020900258Battery · inoperativeCABIN EMERGENCY LIGHTS ARE OUT FROM 30-39RH(<P>REMOVED AND REPLACED EMERGENCY PWR SUPPLY BATTERY IAW AMM 33-51-07 OPS CHECK GOOD</P>)SDR YENA2021021200100Battery · no testFLT # 1141, BDL-PBI. R1 EPSU FAILED OPS TEST ; R & R R1 SVC DOOR POSITION EPSU W/SERVICEABLE ASSY PER AMM 33-50-01. OPS TEST OKSDR DXTA2021020904702Battery Pack · defectiveCABIN EMERG LIGHT: UNDER NORMAL ELECTRICAL POWER, WITH THE EMERGENCY LIGHT SWITCH IN THE ARM POSITION, ALL EMERGENCY LIGHTS ARE ILLUMINATED.///SIGN-OFF///REMOVED AND REPLACED EMERGENCY BATTERIES ON RH RACK AND COCKPIT. IAW EMB AMM 33-52-01-01-010. OPS CHECK SDR AALA202102099004Cover · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT COVER DETACHED AT SEAT 24C. REPLACED EMERGENCY EXIT LIGHT COVER IAW AMM 33-51-11, OPS CHECK GOOD.SDR WX0A2021021073639Epsu · no testEPSU (12WL) FAULTING BATTERY CAPACITANCE TEST / REMOVED AND REPLACED EPSU (12WL) BATTERY IAW AMM 33-51-00. OPS CHECK GOOD.SDR HALA2021020900014Battery Pack · faultedSHIP 0390 4R EPSU 18WL BAT FAULT. NEEDS BATTERY . CORRECTIVE ACTION: REMOVED & INSTALL NEW BATTERY AT 4R EPSU PER AMM 33-51. OPS CK OK. (7267000)SDR HALA2021020900012Battery Pack · faultedSHIP 0390 3L EPSE 15WL BAT FAULT. CORRECTIVE ACTION: REMOVE & INSTALL NEW BATTERY AT 3L EPSU PER AMM 33-51-00. OPS CK OK. (7250399)SDR AALA202102099006Battery · inoperativeAIRCRAFT WAS GROUNDED (LONG TERM STORAGE): CABIN FLASHLIGHT BATTERY IS DEAD. REPLACED BATTERY PER AMM 25-64-01-960-802.SDR AALA202102099005Lens · brokenAIRCRAFT IN BASE MAINTENANCE: EMERGENCY PATH LIGHT LENS BROKE IN AISLE (2EA). REMOVED AND REPLACED 2EA EMERGENCY PATH LIGHT LENS.SDR QXEA2021020800057Switch · malfunctionedEMERGENCY LIGHTS REMAIN ILLUMINATED WITH EMERGENCY LIGHT SWITCH AND BATTERIES IN THE OFF POSITION. REMOVED THE LIGHT SWITCH ON THE WING BULKHEAD IAW AMM 33-51-05-000-801. INSTALLED NEW SWITCH IAW AMM Q400 33-51-05-400-801. EMERGENCY LIGHTS CHECK GOOD IAW Q400 SDR DALA2021020800726Lamp · inoperative(LOG 7518449) DURING INSPECTION FOUND EXTERIOR EMERGENCY LIGHT AT L1 DOOR INOPERATIVE. R/R EXTERIOR EMERGENCY LAMP AT L1 DOOR PER B737 AMM 33-51. OPS CHECK GOOD.SDR R61A2021030100209Light · inoperativeDURING HEAVY CHECK MAINTENANCE FOUND R2 DOOR SURROUND EMERGENCY LIGHT ONLY LIGHTS UP ON TOP HALF. INOPERATIVE EMERGENCY EXIT LIGHT ON R2 DOOR SURROUND REPLACED IAW AMM 33-50-15-400-801A.SDR R61A2021021100155Light · missingSUPPLEMENTAL INFORMATION: FLOOR LIGHTING STRIP MISSING. RESECURED/INSTALLED PHOTOLUMINESCENT STRIP IAW AMM 33-50-21SDR ASAA2021020734062Lamp · inoperativeEMERGENCY EXIT LIGHT BULBS INOP ON FWD INTERIOR SIDE OF R1 DOOR. GROUNDED - YES. RELAMPED R1 DOOR EMERGENCY EXIT LIGHT OPS CHECK GOOD IAW B737-900 AMM 33-51-01-960-801.SDR QXEA2021020800049Sight Tube · looseON DESCENT, WE HIT SEVERE TURBULENCE AND THE SMALL EMERGENCY SIGN IN 2+D/TYPE II/III DOOR CAME LOOSE. REMOVED FROM SERVICE. FOUND EMERGENCY SIGN DISLODGED FROM TYPE II/III DOOR. RE SECURED SIGN AS NECESSARY. AIRCRAFT GOOD FOR SERVICE.SDR QXEA2021020800046Light · looseFA NOTIFIES PHOTOLUMIN STRIP IN FRONT OF ROW 2D IS COMING UP. REMOVED FROM SERVICE. RE SECURED EMERGENCY FLOOR PATH LIGHT IAW Q400 AMM 33-51-16-400-801. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR AALA202102089001Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT OVER R2 DOOR INOPERATIVE AND NOT ILLUMINATING PATH LIGHTING ON SEATS. EMERGENCY POWER SUPPLY UNIT OVER R2 EMERGENCY DOOR REMOVED AND REPLACED PER AMM 33-51-38-400-001-A.SDR DALA2021020800724Fuse · inoperative(LOG 7710351) DURING INSPECTION FOUND OUTSIDE RT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED 2 OF THE 4 FUSES IN POWER PACK M1671 PER B737 AMM 33-51. OPS CHECKS GOOD.SDR CALA2021020800144Lens · brokenPAX CABIN SEAT 20 L/H RED EMERGENCY LIGHT LENS BROKEN. REF. AAR N/R: 9737524 GENERATED BY: V915555 REMOVED AND REPLACED AT SEAT ROW 20 L/H EMERGENCY LIGHT LENS ( RED ) REF. B737 AMM 33-51-11-960-801 AND DRWG#3350DD14973 REV."A" OPERATIONAL TEST NORMAL.REF. AARSDR SIMA20210207001Lamp · inoperativeOVERWING EMERGENCY LIGHT ON ROW 12CB INOP-C/A-RAR LAMP ON OVERWING EMERGENCY LIGHT IN ROW 12CB ABOVE PASSENGER SEATS IN REF WITH EMB 145 AMM 33-50-07. OPS CHECK GOOD.SDR MASA2021020700040Bulb · inoperativePAX DR FLR LVL EXIT SIGN BULB INOP- RELAMPEDSDR MASA2021020700039Lamp · inoperativeROW 13 F FLR LVL EXIT SIGN BULB INOP- RELAMPEDSDR SIMA20210206005Light · unsecureALL BLACK ADHESIVE SPLICES BETWEEN FLOOR EMERGENCY LIGHT STRIPS REQUIRE REPLACEMENT.-C/A-COMPLETE:INSTALLED ALL SPLICES BETWEEN FLOOR EMERGENCY LIGHT STRIPS IAW AMM 33-50-12.SDR SIMA20210206003Light · brokenEXTRUSION FOR #6 AND #8 FLOOR EMERGENCY LIGHT STRIP IS BROKEN.-C/A-COMPLETE:RAR EXTRUSION IAW AMM 33-50-12.SDR SWAA2021021047457Lens · out of positionR1 DOOR EMERGENCY EXIT SIGN ARROW POINTING WRONG DIRECTION / REPLACED R1 DOOR EMERGENCY EXIT LIGHT LENS WIHT CORRECT LENS PER S.I.P.SDR UIEA2021021000277Battery · inoperativeFOUND EMER LIGHT L5731, L5732 CAN NOT STAY 15 MIN (<P>IAW AMM 33-51-04-902-001-001 REV 100 REPLACED EMER LIGHT POWER BATTERY ON M5168 POWER SUPPLY AND CONDITION CHK NORMAL/ IAW AMM 33-51-04-902-001-001 REV 100. PERFORMED INSTALLATION TEST OF M5168 BATTERY PACKSDR DALA2021020900756Battery Pack · defective(LOG 7554173) DURING INSPECTION FOUND EMERGENCY LIGHTS REMAINING ON FOR M1694 REMOVED BATTERY PACK. REPLACED BATTERY & POWER SUPPLY PER B737 AMM 33-51. NOW OPS NORMAL.SDR DALA2021020900755Battery Pack · inoperative(LOG 7554171) DURING INSPECTION FOUND EMERGENCY LIGHTS NO WORKING AROUND LT OVER WING EXIT. ALL LIGHTS WENT TO BATTERY PACK M1694 R/R BATTERY PACK IAW B737 AMM 33-51. OPS GOOD.SDR AALA202102079003Battery · faultedAIRCRAFT WAS NOT GROUNDED: DURING OPERATIONS TEST OF EMERGENCY LIGHTING SYSTEM. FOUND 11WL EMERGENCY POWER SUPPLY UNIT BATTERY FAULTING. REMOVED AND REPLACED 11WL EMERGENCY POWER SUPPLY UNIT BATTERY PER AMM 33-51-38.SDR DALA2021020800714Battery Pack · inoperativeDURING EMERGENCY LIGHTING LOWER LEVEL CREW REST INSPECTION MAINTENANCE REPLACED BATTERY PACK. SYSTEM OPERATION IS NORMAL. (LP 9397499)SDR DALA2021020800710Power Supply · inoperativeCEILING EMERGENCY LIGHTS AT ROWS 4L, 41R AND 45R ARE INOPERATIVE. MAINTENANCE REPLACED POWER SUPPLY M00736 AND RELAMPED L4 DOOR. MCO/PLAC REMOVED SYSTEM OPERATION IS NORMAL. (LP 7683832)SDR DALA2021020800709Light · inoperativeSEAT MOUNT EMERGENCY LIGHTS AT ROW 41 INOPERATIVE. MAINTENANCE REPLACED LIGHT ASSEMBLY. SYSTEM OPERATION IS NORMAL. (LP 5031093)SDR DALA2021020800708Power Supply · inoperativeCEILING EMERGENCY LIGHTS AT ROW 29 ARE INOPERATIVE. MAINTENANCE REPLACED POWER SUPPLY. SYSTEM OPERATION IS NORMAL. (LP 5031092)SDR DALA2021020800707Charger · inoperativeLOWER OVERWING EMERGENCY LIGHTS AT RIGHT AFT INOPERATIVE. MAINTENANCE REPLACED BATTERY CHARGER M11384 SYSTEM OPERATION IS NORMAL (LP 5031091)SDR DALA2021020800703Battery Pack · inoperativeTHE TAILCONE SLIDE EMERGENCY LIGHTS WERE FOUND TO BE INOPERATIVE. MAINTENACE REPLACED THE EMERGENCY LIGHTS BATTERY, B5-116, PER B717 AMM 33-51. (LP #7593826)SDR SIMA20210206001Lamp · inoperativeLH FWD EXTERIOR EMERGENCY LIGHT INOP-C/A-RAR LH FWD EXTERIOR EMERGENCY LIGHT LAMP IAW EMB 145 AMM 33-50-10, NO FIX. PERFORMED TROUBLESHOOTING OF EMERGENCVY LIGHTING SYTEM IAW EMB 145 FIM 33-50-00 AND EMB 145 WM 33-50-50. RAR #1 EMERGENCY LIGHTING BATTERY PACK SDR SWAA2021030948850Battery · inoperativeINOP EMERGENCY EXIT LIGHT BATTERY ON LOWERED CEILING AT AFT GALLEY AREA (2 EA) / REPLACED EMERGENCY EXIT LIGHT BATTERY ON LOWERED CEILING AT AFT GALLEY AREA IAW B737-700 AMM 33-51-06-960-805SDR YENA2021021800101Power Supply · inoperativeDURING HEAVY MAINTENANCE, INOP EPSU 13WL; (REF AEROMAN NR 2021-71/1-2021-59122 ) R & R EPSU 13WL IAW A320 AMM 33-51-38-000-001-A. OPS CHECK GOODSDR SWAA2021021547372Bulb · burned outLH OVERWING SIDEWALL EMERGENCY EXIT SIGN HAS BURNED OUT BULBS / RELAMPED AND PERFORMED A GOOD INSTALLATION TEST OF THE LH OVERWING EMERGENCY EXIT SIGN PER AMM 33-51-01-960-801SDR SWAA2021020947685Battery Pack · inoperativeEMER LIGHT OUT @ ROW 12 + 14 RH SIDE / REMOVED CHARGER AND BATTERY PACK @ STA 500C+7 RH PER 33-51-06 AMM. OPS CK GOOD. PERFORMED SECURITY CHECK IN VENT PANELS AREASSDR SWAA2021020947044Lamp · inoperativeRH AFT EMER LT INOP / RELAMPED RH AFT EMER LT PER AMM 33-51-01SDR SWAA2021020947047Charger · inoperativeEMER LIGHT OUT @ ROW 12 + 14 RH SIDE / REMOVED CHARGER AND BATTERY PACK @ STA 500C+7 RH PER 33-51-06 AMM. OPS CK GOOD. PERFORMED SECURITY CHECK IN VENT PANELS AREASSDR AALA202102089016Cover · inoperativeAIRCRAFT WAS NOT GROUNDED: INOPERATIVE PASSENGER SEAT-MOUNTED ESCAPE PATH LIGHT AT SEAT 21C. REPLACED BULB COVER 21 ABC IAW CMM 25-23-67, OPS CHECK GOOD.
Back to JASC 3350