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 AALA201901169017Battery Pack · no testEMERGENCY LIGHTS INOPERATIVE FROM SEATS 27G THROUGH 36G. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-51-07, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019011628471Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PACK PER AMM.SDR SWAA2019011628463Cover · unsecureMID CABIN EXIT SIGN COVER FELL OFF. REINSTALLED COVER PER MM.SDR SWAA2019011628462Lens · missingLT EMERGENCY EXIT AISLE OVERHEAD LIGHT LENS MISSING AT ROW 27. R&R LENS IAW AMM.SDR MASA2019011511663Light · inoperativeEMER FLOOD LIGHT INOP ROW 1 AND 3 SWAP TO ROW 14. PLACED ON MEL.SDR DALA2019011500258Battery Pack · dischargedEMERGENCY LIGHTS INOP TO ROW 1A. FOUND SEVERAL LTS OUT IN F/C SECTION OF AIRPLANE/ REMOVED & REPLACED ASSOCIATED BATTERY PACK PER AMM 33-53. OPS NORMAL OK FOR SVC. (LP5001473)SDR UIEA2019011502948Light · inoperativeUPPER DECK EMERGENCY CEILING LIGHTS INOP(<P>RELAMPED UPPER DECK EMERGENCY LIGHTS AND TESTED PER MM 33-21-07-962-001</P>)SDR REXA2019021940153Sign · unsecureTHE EMERGENCY EXIT LIGHT AT THE FA STATION ON THE LEFT AS BORDING THE AIRCRAFT IS LOOSE AND FALLING OUT OF THE WALL. NOTE: REQUIRES SDR REPORT. COMPLETE: SUMMARY OF NRC 00397: THE EMERGENCY EXIT LIGHT DS156 WAS INSTALLED PER CRJ 900 AMM 33-51-05-400-801 (COSDR SWAA2019012128785Battery Pack · inoperativeEMERGENCY EXIT LIGHT BATTERY PACK INOP AT LOCATION M1673. R&R BATTERY PACK PER AMM.SDR SWAA2019012128784Battery Pack · inoperativeEMERGENCY EXIT LIGHT BATTERY PACK INOP AT LOCATION M1670. R&R BATTERY PACK PER AMM.SDR SWAA2019012128727Battery Pack · inoperativeEMERGENCY EXIT LIGHT BATTERY PACK INOP AT LOCATION M1668. R&R BATTERY PACK PER AMM.SDR CALA2019011800110Battery Pack · dischargedREFER NR LP 9130422 B777-33-3-6026 RT DR4 EMER EXIT SIGN CAPACITY CHECK FOUND FAIL DOOR R4 M33408 EMERGENCY LIGHT BATTERY PACK REPLACED AND TESTED, NORMAL AS PER AMM 33-51-06.SDR CALA2019011800109Battery Pack · dischargedREFER NR LP 9130417 B777-33-3-6026 LT DR 3 EXIT SIGN FOUND INOP DOOR R3 M33404 EMERGENCY LIGHT BATTERY PACK REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR CALA2019011800108Power Supply · inoperativeREFER NR LP 9130421 B777-33-3-6026 LT DR 3 EMER AREA LT CAPACITY CHECK FOUND FAIL DOOR R3 M33404 EMERGENCY LIGHT POWER SUPPLY REPLACED AND TESTED NORMAL AS PER AMM 33-51-06.SDR SWAA2019011728598Lens · unsecureR2 DOOR ABOVE EMERGENCY EXIT LIGHT LENS UNSECURE. R&R LIGHT ASSEMBLY IAW AMM.SDR DALA2019011700326Light · inoperativeSHIP 696 ON SVC CHECK FOUND OVERHEAD AISLE EMERGENCY EXIT SIGN AT ROW 26ABC PARTIALLY LIT DURING LIGHT TEST. CORRECTIVE ACTION: REMOVED AND REPLACED OVERHEAD EMER. LIGHT ASSY. (5187828)SDR AALA201901175002Battery Pack · inoperativeEMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE BATTERY PACK. OPS CHECKED GOOD IAW MM 33-51-06-960-802.SDR AALA201901175001Battery Pack · inoperativeEMERGENCY EXIT SIGN ABOVE THE R5 DOOR WAS INOPERATIVE. REPLACED BATTERY PACK IAW MM 33-51-06-960-802. OPS CHECKED GOOD.SDR AALA201901169020Battery Pack · inoperativeEMERGENCY EXIT SIGN RIGHT AISLE WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND PERFORMED A SATISFACTORY OPERATIONAL CHECK PER MM 33-51-06-960-802.SDR AALA201901169013Light · inoperativeROW 33 EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE INSPECTED THE CONNECTOR AND FOUND THE EMERGENCY LIGHT AT SEAT 33D INOPERATIVE AND REPLACED THE LIGHT. MAINTENANCE ALSO PERFORMED A TEST IAW CMM 25-20-79, SATISFACTORY.SDR AALA201901165003Battery Pack · inoperativeLEFT EMERGENCY EXIT SIGN WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND PERFORMED A SATISFACTORY OPS CHECK IAW MM 33-51-06-960-802.SDR JJBA20190114020Charger · inoperativeLT AND RT OVER WING EXTERIOR EMERGENCY LIGHTS INOPERATIVE. EMERGENCY LIGHT BATTERY CRADLE NR 4 FOUND AT FAULT. R&R EMERGENCY LIGHT POWER SUPPLY CHARGER. OPS CHECK FAILED. T/S BLOWN FUSE IN NR 4 BATTERY POWER SUPPLY. REMOVED LIGHT BULBS AND CHECK FOR SHORTS ANDSDR ASAA2019011427784Light · inoperativeWHILE ACCOMPLISHING TASK CARD, EMERGENCY LIGHTS OPS CHECK, LT BULB AFT OF WINGS ON BODY IS OUT. GROUNDED - YES. RELAMPED OVERWING LIGHT ON LT SIDE REF AMM 33-51-04-960-801.SDR REXA2019011400053Light · inoperativeRT AFT EMERGENCY LIGHT INOP. DEFER IAW MEL 33-51-2C REPAIR CAT C PLACARD INSTALLED MM02 UPDATED MOC NOTIFIED 95974. RELAMP RT EMER. LIGHT IAW AMM 33-51-00 OPS CHECK GOOD AT THIS TIME MMO2 UPDATED PLCARD REMOVED MOC#95974 NOTIFIED.SDR HNAA2019011500015Inverter · inoperativeNDIS 652 33-51 0003030 14JAN19 SBY CLOSE FWD CEILING EMERGENCY LIGHT AT ROW 12 INOP. FACT 14JAN19 10:37 SBY R&R NR 6 EMERGENCY LIGHT INVERTER IAW 33-50-11-04. P/N ON INVERTER 1330312 P/N OFF INVERTER 1330312SDR DALA2019011500257Battery · dischargedTHE TAIL COMPARTMENT OVERHEAD AND WALKWAY LIGHTS ARE NOT ILLUMINATING. MAINTENANCE REPLACED THE AFT COMPARTMENT EMERGENCY BATTERY REF AMM 33-51. OPERATIONAL CHECK WAS GOOD. (LP #5545775)SDR SIMA2019020113005Light · inoperativeONE OF THE GALLEY OVERHEAD EMERGENCY LIGHTS IS OUT-C/A-REMOVED AND REPLACED THE GALLEY OVERHEAD EMERGENCY LIGHTS IAW EMB-145 AMM 35-50-09. OPS CHECK GOODSDR DALA2019011400323Lens · missingSHIP 661 FOUND EMERGENCY LENS MISSING AT SEAT 18DC DURING SVC. CORRECTIVE ACTION: INSTALLED LENS COVER PER IPC 35-51. (4326108)SDR AALA201901165004Battery Pack · no testEMERGENCY LIGHTS INOPERATIVE FROM SEATS 27G THROUGH 36G. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-51-07, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019011628478Light · inoperativeCABIN EMERGENCY LIGHTS INOP AT LOCATION M1672. R&R LIGHTS PER AMM.SDR SWAA2019011628477Light · inoperativeCABIN EMERGENCY LIGHTS INOP AT LOCATION M1674. R&R LIGHTS PER AMM.SDR SWAA2019011628473Light · inoperativeCABIN EMERGENCY LIGHTS INOP AT LOCATION M1673. R&R LIGHTS PER AMM.SDR SWAA2019011628470Battery Pack · dischargedR1 FORWARD EMERGENCY LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR AALA201901154001Power Supply · no testEMERGENCY LIGHT POWER SUPPLY 10WL FAILED A PS CHECK SYSTEM TEST. MAINTENANCE REPLACED THE POWER SUPPLY IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2019011528415Light · inoperativeRT OVERWING EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR ASAA2019011327779Light · inoperativeFOUND EMERGENCY AISLE LIGHT INOP AT ROW 6 FOUND EMERGENCY AISLE LIGHT INOP AT ROW 29 GROUNDED - YES. R/R SEAT MOUNTED EMERGENCY LIGHT IAW AMM 33-51-19. OPS CHECK GOOD, OK FOR SERVICE. BUTT SPLICE EMERGENCY AISLE LIGHT WIRE IAW ESPM 20-43-11. OPS CHECK GOOD,SDR QXEA2019010300015Battery Pack · dischargedEMERGENCY LIGHTS AT THE LEFT AND RIGHT FORWARD EXIT SIGNS ARE INOP DURING THE OPERATIONAL CHECK. REPLACED THE BATTERY SUPPLIES IAW AMM 33-51-00-820-801. CHECKS GOOD.SDR DALA2019011400238Battery Pack · dischargedDURING SERVICE CHECK FOUND FLOOR ESCAPE PATH SYSTEM AT SEAT 34B, 36B, AND 41B INOPERATIVE. REPLACED BATTERY PACK 17WL. LP 5543858SDR CALA2019011400101Light · inoperativeFWD CLOSET AFT MONUMENT EEL LIGHT INOP. RELAMPED REF AMM 33-51-14-960-801, OPS CHECKED OK. ACP IDT INSP OF RELAMPING EEL AT FWD CLOSET AFT MONUMENT REF GMM 09-10-05 AND AMM 33-51-14. OPS CK GOOD.SDR CALA2019011400100Light · inoperativeSEAT 8ABC PATHWAY EEL LIGHT INOP. RELAMPED REF AMM 33-51-11. OPS CHECKED OK. ACP IDT INSP OF RELAMPING EPL AT SEAT 8ABC REF 09-10-05 AND AMM 33-51-11. OPS CK GOOD.SDR DALA2019011300217Battery · dischargedFWD OVHD EM LIGHTS IN-OP. REPLACED BATTERIES IN EM LT PWR SUPPLY 5-23 IAW AMM 33-55 CKS GOOD. (LP4753077)SDR MASA2019011311661Light · inoperativeEMER FLOOD LIGHT INOP ROW 17. RELAMPED.SDR SWAA2019021329572Housing · brokenG4 GALLEY EMERGENCY EXIT LIGHT HOUSING BROKEN. R&R LIGHT IAW AMM.SDR YENA201901120026Battery Pack · failedFLT 674, AUA-BOS. EPSU BATTERY PACK FAIL (MID 14WL); R & R EPSU BATTERY PACK (MID 14WL) IAW AMM 33-50-38. OPS CHECK GOOD.SDR YENA201901120025Battery Pack · failedFLT 674, AUA-BOS. EPSU BATTERY PACK FAIL (13WL); R & R EPSU BATTERY PACK ( MID 14WL) IAW AMM 33-50-38. OPS CHECK GOOD.SDR YENA201901120024Battery Pack · failedFLT 674, AUA-BOS. EPSU BATTERY PACK FAIL (11WL); R & R EPSU BATTERY PACK (11WL) IAW AMM 33-51-38. OPS CHECK GOOD.SDR YENA201901120023Battery · dischargedFLT 543, EWR-PBI. DURING WEEKLY FOUND EXIT ROW EMERGENCY EXIT SEAT LIGHTS INOP; R & R EXIT ROW RT EPSU & BATTERY 12WL PER AMM 33-51-38. OPS CHECK OK.SDR YENA201901120022Epsu · failedFLT 543, EWR-PBI. DURING WEEKLY FOUND EXIT ROW EMERGENCY EXIT SEAT LIGHTS INOP; R & R EXIT ROW R/H EPSU & BATTERY 12WL PER AMM 33-51-38 OPS CHECK OK.SDR SWAA2019011628472Light · inoperativeLT SIDE A/C SLIDE EMERGENCY LIGHT AFT OF WING INOP. R&R LIGHT IAW AMM.SDR AALA201901154006Fuse · blownOVERWING EMERGENCY EXIT SIGN WAS INOPERATIVE. MAINTENANCE REPLACED THE FUSE AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-06.
Back to JASC 3350