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 SWAA2019082766331Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED AT M1670. R&R BATTERY PACK PER AMM.SDR SWAA2019082766330Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED AT M1668. R&R BATTERY PACK PER AMM.SDR SWAA2019082766294Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED AT M1674. R&R BATTERY PACK PER AMM.SDR DALA2019082624970Light · missingROW 37AB SEAT MISSING EMERGENCY SEAT LIGHT, INSTALLED ROW 37AB SEAT MISSING EMERGENCY SEAT LIGHTSDR SWAA2019082636231Light · looseEMERGENCY EGRESS STRIP NEAR L1 DOOR LOOSE. SECURED EGRESS STRIP PER AMM.SDR SWAA2019082636218Sign · missingMID CABIN EMERGENCY EXIT SIGN HAD FALLEN DOWN. REINSTALLED EXIT SIGN IAW AMM.SDR AALA201908239031Battery · no testAIRCRAFT WAS NOT GROUNDED: L1 DOOR EMERGENCY LIGHT WOULD NOT TEST. MAINTENANCE REPLACED DOOR EMERGENCY LIGHT BATTERY PER AMM 33-51-38.SDR RAIA2019082310001Light · inoperativeLEFT AFT WING TO FUSLAGE FAIRING EXTERIOR FLOOD LIGHT NR 5 WAS INOPERATIVE. R & R LEFT OVERWING EMERGENCY LIGHT. OPS CHECKED GOOD.SDR PNSA2019082300001Power Supply · failedEMERGENCY EXIT LIGHT OVERWING INOPERATIVE. R&R POWER SUPPLY 11LN, OPS CHECKED GOOD.SDR CALA2019082301413Charger · failedON CHK FOUND R2 DOOR SERVAL EMERGENCY LT INOP. R2 DOOR 2EA POWER PACK REPLACED AND TEST OK. IAW AMM: 33-51-00SDR DALA2019082214920Light · inoperativeSEAT 7A EMERGENCY LIGHT INOPERATIVE. REPLACED PATH LIGHT. LP 5157824SDR ASAA2019082213444Battery Pack · failedREF T/C 78233001 EMERGENCY LIGHT BATTERY PACKS M1671 AND M1673 FAIL CAPACITY CHECK. GROUNDED - YES. REPLACED EMERGENCY LIGHT BATTERY PACK M1671 AND M1673 REF B737-800 AMM 33-51-06-960-805. OPS CHECK GOOD.SDR SIMA201908221006Charger · failedL/H AND R/H OVER WING EMER. LIGHTS INOP. REMOVED AND REPLACED #4 EMERG. LIGHT CHARGER AND BATTERY ASSYS, OPC GOOD, IAW AMM 33-50-04.SDR SIMA201908221005Light · inoperativeL/H OVERWING EXT EMERGENCY LIGHT INOP.-C/A-REMOVED AND REPLACED THE LH OVERWING EXIT LIGHT IAW EMB 145 AMM 33-50-10. OPC GOOD.SDR DALA2019082204900Light · unsecureEMERGENCY SEAT MOUNTED LIGHTING DAMAGED AT 40E. LIGHT ASSEMBLY FASTENER TO SECURE TO SEAT MISSING. REPLACED SCREW. SYSTEM OPERATION NORMAL.SDR DALA2019082204899Battery Pack · inoperativeEMERGENCY EXIT LIGHT AT R4 ARE INOPERATIVE. REPLACED BATTERY PACK AT POWER SUPPLY M1210. SYSTEM OPERATION IS NORMAL.SDR SWAA2019082236207Battery Pack · inoperativeR/H FORWARD EMERGENCY LIGHTS INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2019082236206Light · damagedR/H PHOTOLUMINESCENT STRIP DAMAGED, FIRST SECTION. R&R PHOTOLUMINESCENT STRIP IAW AMM.SDR SWAA2019082236201Power Supply · inoperativeR/H FORWARD EMERGENCY LIGHTS INOP. R&R POWER SUPPLY IAW AMM.SDR SWAA2019082236191Lamp · inoperativeL/H AFT EXTERIOR EMERGENCY LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR SWAA2019082236190Lens · brokenFORWARD ENTRY EMERGENCY EXIT SIGN FLOOR LEVEL BROKEN/BASE. / SECURED LENS PER EA.SDR SWAA2019082236179Light · damagedL/H PHOTOLUMINESCENT STRIP DAMAGED, FIRST SECTION. R&R PHOTOLUMINESCENT STRIP IAW AMM.SDR SWAA2019082236175Lens · dislodgedKNOCKED OFF EXIT SIGN OF CEILING WITH CAR SEAT. REINSTALLED DISLODGED LENS PER AMM.SDR SWAA2019082236174Battery Pack · inoperativeR/H AFT SECTION EMERGENCY LIGHTS INOP. R&R BATTERY PACK IAW AMM.SDR REXA2019082211250Light · inoperativeFLOOR LEVEL EMERGENCY LIGHT AT THE PASSENGER DOOR IS NOT WORKING. R&R'D FLOOR LEVEL EMERGENCY FLOOD LIGHT ASSY IAW AMM 33-51-19. OPS CHECK GOODSDR AALA20190821278Light · inoperativeR4 DOOR, EXTERIOR EMERGENCY LIGHT IS INOPSDR FDEA201908211991Lamp · inoperativePOST-FLT INSP, ONE OVERHEAD SUPRNMRY EMERGENCY LIGHT INOPERATIVE DURING A LIGHTS TEST. REPLACED THE LAMP, IAW AMM: 33-51-04-2. LIGHT TESTED SATIS, OK FOR SERVICE.SDR MASA2019082112014Bulb · inoperativeGALLEY LEFT LOWER EXIT SIGN 1 BULB INOP. RELAMPEDSDR SWAA2019082136151Cover · brokenR/H OVERWING EXIT SIGN COVER BROKEN. / R&R COVER IAW AMM.SDR REXA2019082101249Light · damagedEMERGENCY TRACK LIGHTING DAMAGED AT ROW 9. REMOVED AND REPLACD DAMAGE FLOOR TRACK LIGHTING IAW AMM 33-51-01. FLOOR TRACK LIGHTING OK FOR SVC IF NECESSARY. P/N OFF/ON - PL1100LH07 P/N OFF/ON - PLI315LH00SDR YENA2019082300471Light · brokenFT # 62, EMERGENCY SEAT LIGHT 1C BROKEN. R & R EMERGENCY LIGHT ASSY IAW AMM 33-51-19, OPS CHECK GOOD.SDR SWAA2019090336546Light · damagedPASSENGER CABIN SIDEWALL 232YHW EMERGENCY EXIT LIGHT DAMAGED. R&R LIGHT IAW MM.SDR AALA2019082219007Light · inoperativeAIRCRAFT NOT GROUNDED: ROW 8 LIGHT FLOOR EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT ASSY AT SEAT 8C. IAW CMM 25-23-54. OPS CK OK.SDR DALA2019082324936Lens · missingR2 DOOR EXIT SIGN MISSING LENSE. CORRECTIVE ACTION: REPLACED MISSING SIGN CHECKS GOOD.SDR SWAA2019082236193Bulb · inoperativeL/H AFT OVERWING EXTERIOR EMERGENCY LIGHT BURNED OUT. R&R BULB AMM.SDR N6WA20190822002Light · brokenCENTER EMERGENCY EXIT LIGHT BROKEN AT ROW 13. CLEANED ELECTRICAL CONNECTER, OPS CHECK GOOD IAW CRJ700 AMM 33-51-00.SDR N6WA20190822001Bulb · inoperativeCEILING EMERG FLOOD LIGHT NEAR ROW 15 INOP. R/R EMERGENCY FLOODLIGHT BULB AT ROW 15 IAW CRJ 700AMM 33-51-09 OPS CHECK GOOD.SDR SWAA2019082136170Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1675. / R&R BATTERY PACK PER AMM.SDR SWAA2019082136169Charger · inoperativeL/H EMERGENCY EXIT LIGHT INOP AT ROW 6. R&R EMERGENCY BATTERY PACK CHARGER PER AMM.SDR SWAA2019082136156Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1668. R&R BATTERY PACK PER AMM.SDR SWAA2019082136155Socket · inoperativeL/H EMERGENCY EXIT LIGHT INOP AT ROW 6. R&R LIGHT SOCKET PER AMM.SDR SWAA2019082136150Lamp · inoperativeAFT R2 EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR AALA201908219006Control Unit · inoperativeEMERGENCY MAIN AISLE MOUNTED PROXIMITY LIGHTS AT POSITION 3D, 4D, 5D, 3H, 4H, 5H ARE INOPERATIVE. REMOVED AND REPLACED WCU UNIT AND BATTERY UNIT IN SEAT ZONE 1 (M2351WG01 CLASS 23) POSITION IAW AMM 33-51-07. PERFORMED OPS EMERGENCY LIGHT TEST OK. ALL EMERGENCYSDR MASA2019082012011Light · inoperativeROW 18 CEILING FLOOD EMER LIGHT INOP. PLACED ON MELSDR MASA2019082012010Light · inoperativeROW 9 CEILING FLOOD EMER LIGHT INOP. PLACED ON MELSDR SIMA20190819008Battery · not reported[PSR] MISC WORK REQUEST: WR-2019-09-04 528-0037 - REMOVE AND REPLACE EMERGENCY BATTERY PN 2013-1A SN 101791-C/A-RAR #4 EMERGENCY BATTERY AND POWER SUPPLY IAW AMM TASK 33-51-17. OPS CHECKS GOOD AT THIS TIME.SDR YENA2019082390470Battery Pack · failedFT # 225, EMERGENCY SLIDES L1 AND R1 FAILED EMERGENCY LIGHT TEST. REMOVED AND REPLACED R1 SLIDE IAW AMM 25-62-44. PERFORMED OPS CHECK IAW AMM 25-62-44-400-007-A. OPS CHECK GOOD.SDR YENA2019082309469Power Supply · failedFT # 225, EMERGENCY SLIDES L1 AND R1 FAILED EMERGENCY LIGHT TEST. REMOVED AND REPLACED R1 SLIDE IAW AMM 25-62-44. PERFORMED OPS CHECK IAW AMM 25-62-44-400-007-A. OPS CHECK GOOD.SDR YENA2019082319468Light · failedFT # 225, EMERGENCY SLIDES L1 AND R1 FAILED EMERGENCY LIGHT TEST. REMOVE AND REPLACED R1 SLIDE IAW AMM 25-62-44. PERFORMED OPS CHECK IAW AMM 25-62-44-400-007-A. OPS CHECK GOOD.SDR DALA201908234932Housing · brokenSEAT 30D EMERGENCY LIGHT HOUSING BROKEN. REPLACED 30D EMER LIGHT HOUSING TESTS OK PER B757 AMM 33-51.
Back to JASC 3350