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 ASOA201902264008Battery Pack · dischargedIAH - DURING MAINTENANCE INSPECTION SEVERAL EMERGENCY LIGHTS WEER FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NUMBER ONE AND TWO EMERGENCY LIGHT BATTERY PACKS, OPERATIONALLY TESTED WITH NO DEFECTS NOTRED AND THE AIRCRAFT WAS APPROVED FOR RETUSDR U2RA201902260001Lens · crackedDURING CABIN INSPECTION FOUND EMERGENCY EXIT SIGN ABOVE NUMBER 2 LEFT DOOR CRACKED. - DEFERRED PER MEL/NON-ESSENTIAL FURNISHINGS 25-20-01-N12. SUPPLEMENTAL SDR WILL BE FILED UPON REPAIR.SDR ASAA2019022628385Battery Pack · defectiveFWD OVERWING AND OUTSIDE OVERWING BATTERY PACK WOULD NOT CHARGE. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK. OPS GOODSDR AALA201902289007Light · missingEMERGENCY LIGHT MISSING AT THE LEFT G3 GALLEY CLOSET. MAINTENANCE REPLACED EMERGENCY LIGHT IAW MM 33-51-05.SDR AALA201902287006Sign · detachedAFT CEILING EXIT LIGHT WAS FALLING OFF. THE AIRCRAFT WAS GROUNDED. REPLACED THE SIGN ASSEMBLY AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-01.SDR AALA201902827004Connector · brokenCONNECTOR CRACKED AND DETERIORATED UNDER NORMAL PRESSURE WHILE DISCONNECTING. REPLACED THE CONNECTOR IAW STANDARD PRACTICES AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR PNSA2019022601Light · inoperativeFLIGHT ATTENDANT EMERGENCY LIGHTS PANEL "ARMED" BULB BURNED OUT, R&R BULB, OPS OK.SDR PNSA2019022602Light · inoperativeFLIGHT ATTENDANT EMERGENCY LIGHTS PANEL "ARMED" BULB BURNED OUT, R&R BULB, OPS OK.SDR SWAA2019022830108Battery Pack · dischargedR1 DOOR AFT EXTERIOR EMERGENCY EXIT LIGHT INOP. R&R POWER SUPPLY BATTERY PACK PER AMM.SDR AALA201902279010Battery · inoperativeEMERGENCY LIGHTS INOPERATIVE ROWS 3 THROUGH 11. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED WELS BATTERY AT THE R2 DOOR IAW AMM 33-51-07 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201902279008Switch · faultyEMERGENCY LIGHTS ILLUMINATED IN FLIGHT, AND WOULD NOT TURN OFF. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED EMERGENCY LIGHT SWITCH 4WL IAW AMM 33-51-01.SDR AALA201902279006Power Supply · no testINOPERATIVE POWER SUPPLY 13WL. REPLACED THE POWER SUPPLY IAW AMM 33-51-38-400-001-A, AND PERFORMED BITE TEST IAW AMM 33-51-38-400-001-A.SDR DALA2019022761256Battery · inoperativeB5-235 BATTERY WILL NOT ILLUMINATE THE EXIT SIGN OVER FWD FLIGHT ATTENDANT SEAT. MAINTENANCE REPLACED THE BATTERY ASSEMBLY. CHECK WAS NORMAL REF B717 AMM 33-51. (LP #5513762)SDR DALA2019022601246Test Button · intermittentEMERGENCY POWER SUPPLY UNIT, 15WL ABOVE DOOR DOOR 3L PUSH TO TEST BUTTON INTERMITTENT. REPLACED POWER SUPPLY. LP 0960088SDR DALA2019022601218Connector · not seated(LOG 5527914) DURING TEST FOUND EMERGENCY EXIT LIGHTS INOP ROWS 18-23. RESEATED CONNECTOR ON M1695 BATTERY PACK OPERATION OK B737 AMM 33-51.SDR AALA20190301001Battery Pack · no testR4 DOOR EMERGENCY LIGHT BATTERY M33408 WOULD NOT CHARGE. MAINTENANCE REPLACED THE POWER SUPPLY BATTERY PACK IAW AMM 33-51-06-960-802, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2019030128010Battery Pack · no testL3 DOOR EMERGENCY LIGHT BATTERY M33405 WOULD NOT CHARGE. MAINTENANCE REPLACED THE POWER SUPPLY BATTERY PACK IAW AMM 33-51-06-960-802, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR YENA201902250101Battery · failedFLT 391, BOS-TPA. EPSU BATTERY 11WL FAILS EMERG LIGHT SYSTEM TEST; R & R BATTERY AT EPSU 11WL IAW AMM 33-51-38, SYSTEM OPS CHECKS GOOD.SDR DALA2019030101324Light · unsecureSEAT 20 D EMERGENCY EXIT/FLOOR PROX. PATH SYSTEM LIGHT HANGING, RE SECURED EMER/EXIT FLOOR PATH LIGHT.SDR DALA2019022601315Battery · dischargedFLIGHT DECK EMERGENCY EXIT LIGHT SIGN INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERIES SYSTEM OPERATION IS NORMAL.SDR SWAA2019022830127Light · inoperativeLT OVERWING EXIT WINDOW LIGHT INOP. RELAMPED LIGHT PER AMM.SDR AALA201902276001Battery Pack · inoperativeAFT TWO TAILCONE EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK B5-28 IAW MM 33-53-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SIMA201902265002Inverter · failedOVER SERVICE DOOR EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED #2 EMERGENCY LIGHT INVERTER OVER SERVICE DOOR EMERGENCY LIGHT OPC GOOD. BATTERY CHARGER ASSY P/N 11-0049 S/N 19322SDR FDEA2019022650497Battery Pack · weakEMER LT BAT 1 LO. PART 25FEB19 10:27 ICN U IDENTIFIED PARTS EMERG EXIT LIGHTS " RELEASED FOR SERVICE PER MEL : 33-50-04 CATEGORY : C EXPIRATION : 07MAR19 MEL 33-50-04: EMER LIGHTS - INOP." THE PART NIS IN ICN.SDR DALA2019022601208Battery · dischargedTHE OVER WING EXIT EMERGENCY LIGHTS WERE FOUND TO BE INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT BATTERY ASSEMBLY AT STA 726 PER AMM 33-51. OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT IS OK FOR SERVICE.SDR VNAA2019022411101Relay · failedEMERGENCY LIGHTS STARTED CYCLING ON AND OFF DURING FLIGHT. REMOVED AND REPLACED RELAY K135 ON PCB5 IN JB11 IAW CRJ 700 ESPM 20-39-00 OPS CHECK GOODSDR SWAA2019022630021Light · inoperativeAFT GALLEY DOOR EMERGENCY DOWN LIGHT BULB INOP. RELAMPED AFT GALLEY DOOR EMERGENCY DOWN LIGHT IAW AMM.SDR R61A201903010203Power Unit · faultyAFT SERVICE DOOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED EMERGENCY LIGHT POWER UNIT FROM NR 4 POSITION FOR RT AFT SERVICE DOOR EMERGENCY LIGHTS REF AMM 33-50-07-400-801A. OP CHECK GOOD. SEE W/O H6697 SN 017 FOR WORK DETAILS.SDR AALA201902284004Light · inoperativeTHE PORTABLE EMERGENCY LIGHT DOES NOT COME ON. REPLACED THE PORTABLE EMERGENCY LIGHT IAW AMM 33-50-00. OPS CHECKED GOOD.SDR AALA201902284003Battery Pack · inoperativeTHE EMERGENCY LIGHTS ARE OUT AT THE CENTER CEILING PANEL, ROW 20. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK IAW AMM 33-53-00. OPS CHECKED GOOD.SDR AALA201902284002Battery Pack · inoperativeTHE CEILING EMERGENCY LIGHT WAS INOPORATIVE AT SEAT 16DEF. REMOVED AND REPLACED THE BATTERY PACK AT BS 671 IAW AMM 33-53-00. OPS CHECKED GOOD.SDR SWAA2019022730072Light · inoperativeLT EMERGENCY EXIT BIN LIGHT INOP AT ROW 9. R&R LAMP PER AMM.SDR HALA2019022750050Sign · detachedDOOR 3L EXIT SIGN FELL OFF. RE-SECURED DOOR 3L EXIT SIGN. LP 3224359SDR AALA201902269010Battery · faultyEMERGENCY FLASHLIGHT AT THE L4 DOOR FAILED AN OPS TEST. REPLACED EMERGENCY FLASHLIGHT BATTERY IAW AMM 25-64-01. OPS TEST GOOD.SDR FDEA2019022640489Power Supply · no testON PRE-FLT HAD EMER PWR TEST FAIL LEVEL 2 ALERT ATTEMPTED ANOTHER TEST NO DIFFERENCE. PERFORMED RESET L EMERGENCY POWER REF FIM 24-24-00-2. OPS CHECK GOOD.SDR SWAA2019022630022Light · inoperativeRT OVERWING EMERGENCY EXIT DOWN LIGHT AFT BULB INOP. RELAMPED BULB IAW AMM.SDR SWAA2019022629982Charger · inoperativeRT EXTERIOR EMERGENCY EXIT DOOR LIGHT INOP. R&R BATTERY PACK CHARGER PER AMM.SDR REXA2019022540172Lamp · inoperativeRIGHT HAND EMERGENCY LIGHT INOP (OUTSIDE). RE-LAMPED EXTERIOR EMERGENCY LIGHT #6 IAW CRJ 200 CMM 33-52-07. ERFORMED OPS TEST. OS TEST PASSED. A/C OK FOR SVC. MMO2 UPDATED, PLACARD REMOVED. MOC NOTIFIED# 93942 MEL CLEARED.SDR DALA2019022501203Battery Pack · dischargedTHE EMERGENCY LIGHTS AT EXIT ROW 18 ARE INOPERATIVE. MAINTENANCE REPAIRED THE WIRING AT THE OVERHEAD PANEL AND REPLACED THE BATTERY PACK AND BATTERY. OPERATIONAL CHECK WAS GOOD PER B717 WDM 33-51 AND SWPM 20-20.SDR SIMA201902254003Battery Pack · inoperativeBOTH AFT EXTERNAL OVERWING EMERGENCY LIGHTS INOP-C/A-REMOVED AND REPLACED BOTH EMERGENCY LIGHT BATTERY AND CHARGER #4, OPC GOOD IAW EMB AMM 33-50-04. CHARGER ASSY BATTERY P/N BA5-0933-901 S/N C00511SDR R61A2019022540201Power Supply · inoperative2 OVERHEAD EMERGENCY LIGHTS INOP. R&R FWD EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01.SDR DALA2019022501169Lens · missing(LOG 5195502) DURING INSPECTION FOUND EXIT SIGN AT L1 DOOR MISSING. INSTALLED NEW LENS PER B737 AMM 33-51. OPS NORMAL.SDR DALA2019022501157Fuse · failedEMERGENCY LIGHTS AFT OF L2 DOOR INOP. REPLACED FUSE IN BATTERY PACK AND BATTERIES FOR AFT OVERHEAD EMERGENCY LIGHT PER MD88 AMM 33-53. CKS GOOD. (LP5044494)SDR SWAA2019022730101Power Supply · inoperativeRT EMERGENCY LIGHT INOP AT ROW 11. R&R BATTERY SUPPLY PER AMM.SDR SWAA2019022730100Power Supply · inoperativeLT EMERGENCY LIGHT INOP AT ROW 6. R&R BATTERY SUPPLY PER AMM.SDR SWAA2019022730099Power Supply · inoperativeLT EMERGENCY SIDEWALL LIGHT INOP AT ROW 11. R&R POWER SUPPLY PER AMM.SDR SWAA2019022730078Battery Pack · dischargedLT EMERGENCY SIDEWALL LIGHT INOP AT ROW 11. R&R BATTERY PACK PER AMM.SDR SWAA2019022730077Battery Pack · dischargedRT EMERGENCY LIGHT INOP AT ROW 11. R&R BATTERY PACK PER AMM.SDR SWAA2019022730076Battery Pack · dischargedRT EMERGENCY LIGHT INOP AT ROW 13. R&R BATTERY PACK PER AMM.SDR SWAA2019022730075Battery Pack · dischargedRT EMERGENCY LIGHT INOP AT ROW 8. R&R BATTERY PACK PER AMM.
Back to JASC 3350