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 AALA2020013099013Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: BATTERY PACK FROM DOOR 5R (FLOOR PROXIMITY LIGHTS) FAILED DURING CAPACITY CHECK, PER CARD 2324. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-06.SDR AALA2020013099012Battery · faultedAIRCRAFT WAS NOT GROUNDED: LEFT AFT EXIT DOOR SIGN FAILED TO ILLUMINATE DURING CHECK A. MAINTENANCE REPLACED BATTERY FOR EXIT SIGN AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-07.SDR SWAA2020013040879Sign · looseEMERGENCY EXIT SIGN CENTER AISLE MID CABIN LOOSE. SECURED SIGN PER AMM.SDR SWAA2020013040876Sign · brokenSECOND WINDOW OF EMERGENCY EXIT ON FIRST OFFICER SIDE HAD A BROKEN EXIT SIGN BRACKET ON FLOOR LEVEL EMERGENCY EXIT SIGN. R&R SIGN ASSEMBLY IAW MM.SDR ASAA2020012982006Bulb · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. GROUNDED - YES. RELAMPED L2 DOOR EXTERIOR LIGHT EMERGENCY LIGHT REF B737-800 AMM 33-51-04. OPS CHECK GOOD.SDR SIMA202001298001Battery Pack · inoperativeLH FWD EMERGENCY LIGHT INOP-C/A-RMOVED AND REPLACED EMERGENCY BATTERY SUPPLY 1 IAW EMB 140 AMM 33-50-04. OPERATIONAL CHECK GOOD ON LH FWD EMERGENCY LIGHT IAW EMB 140 AMM 33-50-00. BATTERY CHARGER ASSY P/N 11-0049 S/N 15055.SDR SIMA202001298002Charger · inoperativeLH FWD OVER WING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED LH FWD OVER WING EMERGENCY LIGHT LAMP IN REFERANCE WITH 33-50-10-000-801-A AND 33-50-10-400-801-A. NO FIX. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY IAW 33-50-10-000-801-A AND 33-50-10-400-801-SDR SWAA2020012940856Sign · damagedFORWARD SERVICE DOOR EXIT SIGN ON GALLEY DAMAGED / R&R LIGHT ASSEMBLY IAW AMM.SDR AALA202001289034Battery Pack · no testAIRCRAFT IN BASE VISIT: DOOR 5R FLOOR EMERGENCY LIGHTS FAIL CAPACITY CHECK FUNCTIONAL TEST. REPLACED BATTERY PACK FOR DOOR 5R IAW AMM 33-51-06.SDR QXEA2020012800060Light · looseEMERGENCY FLOOR PATH STRIP IN ROW 1AB IS OFF/LOOSE. REMOVED FROM SERVICE. PHOTOLUMINESCENT STRIP IN ROW 1AB RESECURED. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR 4TXA202005050002Battery Pack · dischargedOVERWING ESCAPE GROUND ILLUMINATION LIGHT POWER SUPPLY DISCHARGES TOO QUICKLY. REMOVED AND REPLACED EMERGENCY BATTERY PACK. THIS REPORT WAS FILED IN THE SDR SYSTEM ON 1/27/2020 BUT WAS NOT RECORDED IN THE SYSTEM DUE TO FAA IT ISSUES AT THE TIME OF ENTRY.SDR 4TXA202005050001Battery Pack · dischargedOVERWING ESCAPE GROUND ILLUMINATION LIGHT POWER SUPPLY DISCHARGES TOO QUICKLY. REMOVED AND REPLACED EMERGENCY BATTERY PACK. THIS REPORT WAS FILED IN THE SDR SYSTEM ON 1/27/2020 BUT WAS NOT RECORDED IN THE SYSTEM DUE TO FAA IT ISSUES AT THE TIME OF ENTRY.SDR SWAA2020021241360Battery Pack · inoperativeALL EMERGENCY LIGHTS POWERED BY M1672 (AFT R/H BATTERY) WERE INOP. / R&R BATTERY PACK IAW AMM.SDR SWAA2020021241356Power Supply · inoperativeALL EMERGENCY LIGHTS POWERED BY M1672 (AFT R/H BATTERY) WERE INOP. / R&R POWER SUPPLY IAW AMM.SDR YENA2020013170082Battery · failed12WL EPSU BATTERY FAILED. R & R THE EPSU BATTERY IAW AMM 33-51-00. OPS TESTED OK.SDR YENA2020013170081Epsu · no testAFT LH EPSU FAILED DURING A CAPACITY TEST. R & R ESPU IAW AMM 33-51-58. OPS CHECK PASSED. ACFT OK FOR SERVICE.SDR YENA2020013170080Battery · no testBATTERY CAPACITY CHECK FAILED 12WL. R & R.SDR YENA2020013170079Battery · no testBATTERY CAPACITY CHECK 11WL. FAILED. R & R.SDR YENA2020013170078Battery · failedBATTERY CAPACITY CHECK FAILED.SDR YENA2020013170077Battery · no testBATTERY CAPACITY CHECK FAILED A CAPACITY CHECK. R & R THE BATTERY IAW 33-51-38 OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR AALA202001309010Bulb · faultyAIRCRAFT WAS NOT GROUNDED: L2 EMERGENCY EXTERIOR LIGHT INOPERATIVE. MAINTENANCE REPLACED BULB IAW AMM 33-51-04.SDR SWAA2020013040892Charger · inoperativeEMERGENCY LIGHT BATTERY CHARGER M2335 WOULD NOT CHARGE EMERGENCY BATTERY. R&R BATTERY CHARGER M2335 PER AMM.SDR DALA2020013000697Cover · missingTHE EMERGENCY EXIT LIGHT IS MISSING THE COVER. MAINTENANCE REPLACED THE EXIT COVER PER B717 AMM 52-22. OK FOR SERVICE.SDR AALA202001299010Ballast · inoperativeAIRCRAFT WAS NOT GROUNDED: OVERWING LIGHT INOPERATIVE AT RIGHT HAND FORWARD POSITION. MAINTENANCE REPLACED OVERWING LIGHT BALLAST PER AMM 33-21-00-960-807.SDR AALA202001299005Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS AT SEAT ROW 14 DEF INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK AT SEAT ROW 14 DEF PER AMM 33-51-06.SDR AALA2020012989012Light · brokenAIRCRAFT WAS NOT GROUNDED: BROKEN PATH LIGHT MOUNTED ON FORWARD PART OF GALLEY. MAINTENANCE REPLACED LIGHT ASSEMBLY IAW AMM 20-00-00.SDR SWAA2020012940859Sign · incorrectRT SIDE EMERGENCY OVERWING EXIT SIGN ARROW WAS POINTING WRONG. / INSTALLED CORRECT EXIT SIGN PER MM.SDR DALA2020012700665Charger · inoperativeDURING INSPECTION FOUND LEFT SIDE EMERGENCY EXIT LIGHT SIGNS INOPERATIVE. R & R BATTERY AND CHARGER AT ROW 17A IAW AMM 33-51. OPS CHECKED GOOD.SDR R61A2020012870111Light · inoperative1ST ROW RIGHT SIDE PHOTOLUMINESCENT STRIP LIGHT DAMAGED. R&R 1ST ROW SIDE PHOTOLUMINESCENT STRIP.SDR SIMA202001287002Lamp · inoperativeRH LATERAL PANEL EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED RH LATERAL PANEL EMERGENCY LAMP IAW EMB 140 AMM 33-50-10. OPC GOOD.SDR SWAA2020012840830Lamp · inoperativeR/H MOST AFT EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR QXEA2020012800064Light · looseFOUND EMERGENCY FLOOR STRIP NEXT TO FORWARD GALLEY AND CENTER ISLE CARPET NOT SECURE. REMOVED FROM SERVICE. RESECURED EMERGENCY FLOOR LIGHT STRIP AS NEEDED AND SEALED ATTACHING WET FLOORING AS NEEDED. RETURNED TO SERVICE.SDR AALA202001289010Light · no testAIRCRAFT NOT GROUNDED: EMERGENCY EXIT SLIDE INDICATION OVER-WING AIRCRAFT RIGHT NOT ILLUMINATED ON ECAM DOOR PAGE. RESET OVER WING EXIT ARMED/DISARMED SWITCH RIGHT SIDE. OPS CHECKS NORMAL.SDR QXEA2020012800059Light · missingILLUMINESCENT LIGHTING ON FLOOR NEXT TO 4A MISSING. REMOVED FROM SERVICE. REPLACED 3A + 4A PHOTOLUMINESCENT INDICATOR STRIP LIGHT IAW E17 AMM TASK 33-50-21-000-801-A + 33-50-21-400-801-A. PERFORMED OPS TEST IAW E175 AMM TASK 33-50-21-710-801-A. OPS TEST GOOD.SDR QXEA2020012800055Light · looseLUMINESCENT STRIP AND CARPET LOOSE IN FRONT OF FORWARD GALLEY. REMOVED FROM SERVICE. SECURED LOOSE CARPET. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR DALA2020012700599Battery Pack · inoperativeEMERGENCY LIGHTS AT EXIT ROW 24 UPPER INOP. R/R BATTERIES AT PACK B5-125. OPS NML. REF MD88 AMM 33-53. (LP7223878)SDR YENA2020013060075Battery · no testON BATTERY CAPACITY CHECK (12WL) THE BATTERY FAIL, REPLACED THE BATTERY (12WL) IAW AMM 33-51-00.SDR YENA2020013060074Battery · no test15WL BATTERY FAILED A CAPACITY TEST. R & R THE 15WL BATTERY IAW AMM 33-51-38 EPSU TESTED GOOD.SDR YENA2020013060073Battery · no test11WL FAILED EPSU BATTERY FAILED A CAPACITY TEST. R & R THE 11WL BATTERY IAW AMM 33-51-00 EPSU TEST GOOD.SDR YENA2020013060072Battery · no testEPSU BATTERIES 15WL ABD 14WL FAILED A CAPACITY CHECK. R & R EPSU BATTERIES AT 15WL AND 14WL IAW AMM 33-51-38OPS TEST GOOD.SDR YENA2020013060071Battery · failedEPSU BATTERY 15WL AND 14WL FAILED A CAPACITY CHECK. R & R EPSU BATTERIES AT 15WL AND 14WL IAW AMM 33-51-38OPS TEST GOOD.SDR YENA2020013060070Battery · failedEPSU BATTERY 10WL AND 12WL FAILED A CAPACITY CHECK. R & R EPSU BATTER AT 10WL AND 12WL IAW AMM 33-51-38OPS TEST D.SDR YENA2020013060069Battery · no testFT # 1858, AUA-JFK. EPSU BATTERY 10WL ABD 12WL FAILED CAPACITY CHECK. R & R EPSU BATTER AT 10WL AND 12WL IAW AMM 33-51-38OPS TEST D.SDR DALA2020013080715Lens · missingEMERGENCY EXIT COVER DIFFUSER LENS MISSING AT SEAT 38C. FOUND AND RESECURED THE LENS IAW AMM 33-51.SDR AALA2020012989006Battery · no testAIRCRAFT WAS NOT GROUNDED: 12WL FAILED BATTERY TEST. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY AT 12WL IAW AMM 33-51-38.SDR AALA2020012989005Battery · no testAIRCRAFT WAS NOT GROUNDED: 14WL FAILED BATTERY TEST. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY AT 14WL IAW AMM 33-51-38.SDR ASAA2020012861993Bulb · inoperativeRIGHT FWD OVERWING EMERGENCY EXIT LIGHT BULB INOPERATIVE. GROUNDED - YES. REPLACED THE BULB IAW AMM 33-51-04, OPS CHECKED GOOD.SDR AALA202001289003Battery Pack · no testAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT TEST FAILED AND DISPLAYED, EPSU INT LOAD EMER RT MESSAGE. MAINTENANCE REPLACED BATTERY PACK AT 11WL AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA202001289002Battery Pack · no testAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT TEST FAILED AND DISPLAYED, EPSU INT LOAD EMER R MESSAGE. MAINTENANCE REPLACED BATTERY PACK AT 12WL AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR R61A2020012860110Battery · inoperativeFWD 3 EMERGENCY LIGHTS WILL NOT ILLUMINATE. R&R #2 EMERGENCY LIGHT UNIT.
Back to JASC 3350