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 SWAA2018122827927Battery · failedEMERGENCY LIGHT BATTERY M1669 FAILED CAPACITY CHECK. R&R BATTERY PER MM.SDR SWAA2018122827926Battery · failedEMERGENCY LIGHT BATTERY M1668 FAILED CAPACITY CHECK. R&R BATTERY PER MM.SDR SWAA2018122827819Battery · failedEMERGENCY LIGHT BATTERY M1675 FAILED CAPACITY CHECK. R&R BATTERY PER MM.SDR AALA201812270005Battery · inoperativeBATTERY ABOVE THE R4 DOOR DOES NOT HOLD A CHARGE. REPLACED THE POWER SUPPLIES M33408 AND M33409. OPS CHECKED GOOD IAW MM 33-51-06.SDR ASOA2018122695353Battery Pack · inoperativeDURING ADS-B MOD LINE THE #2 AND #3 EMERGENCY BATTERY WERE DEAD. MX REMOVED AND REPLACED #2 AND #3 EMERGENCY LIGHT BATTERY PACK WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR AALA201812210003Control Unit · inoperativeDURING AN A-CHECK IAW WC 2803, FOUND THE EMERGENCY LIGHT AT THE L4 DOOR INOPERATIVE. THE AIRCRAFT WAS GROUNDED. PERFORMED FIM 33-50-F1-M8A-421A, AND FOUND THE CONTROL UNIT AT THE L4 DOOR DEFECTIVE. REPLACED THE CONTROL UNIT IAW AMM 33-51-07. OPS CHECKED OKSDR AALA201812210002Fuse · failedTHE LOWER RIGHT FUSELAGE SLIDE LIGHT WAS INOPERATIVE. MAINTENANCE REPLACED FUSE ON THE BATTERY PACK M1671, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-06.SDR DALA201812217352Power Supply · inoperativeSHIP 651 DURING SVC CHECK FOUND EMERGENCY LIGHTS FOR ROW 16-19 AND DOOR 4R NOT ILLUMINATING. CORRECTIVE ACTION: REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK REF B757 AMM 33-51-07. BATTERY CURRENTLY CHARGING. OPS CHECK GOOD. (5117478)SDR DALA2018122197350Battery Pack · inoperativeDURING SERVICE CHECK FOUND PASSENGER EMERGENCY LIGHTS INOPERATIVE AT ROWS 32-40AB. REPLACED POWER SUPPLY AND BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR DALA2018122197337Battery Pack · dischargedEMERGENCY PATH LIGHTS AT ROWS 13AB TO 21 AB GOES OFF AFTER 10 SECONDS DURING TEST. REPLACED BATTERY PACK AT POWER SUPPLY . SYSTEM OPERATION IS NORMAL. (LP 5248247)SDR R61A2018122191251Lens · crackedILLUMINATED EXIT SIGN LENS CRACKED AT R2 DOOR. R&R EXIT SIGN LENS AT R2 DOOR IAW MM 33-50-17.SDR SIMA2018122019001Battery · failedBOTH LH AND RH AFT OVERWING EXIT LIGHTS ARE INOP.-C/A-REMOVED AND REPLACED #4 EMERGENCY LIGHT POWER SUPPLY CHARGER ASSY AND BATTERY HOLDER ASSY IAW AMM 33-50-04. OPS CHECK GOOD. BATTERY CHARGER ASSY P/N 11-0049 S/N 15612SDR DALA2018122007310Battery Pack · failed(LOG 5235926) DURING INSPECTION FOUND LEFT WING AFT EXTERIOR EMERGENCY LIGHT AND ROW 22 OVERHEAD EXIT SIGN INOPERATIVE. FOUND BATTERY PACK M1670 BAD. R+R BATTERY PACK IAW B737 MM 33-5. LIGHT CKS OK.SDR 29GA2018122000001Sign · unsecureFLIGHT# 0088 ELH/FLL REPORT: EMERGENCY EXIT SIGN OVER MAIN CABIN DOOR NEEDS TO BE RESECURED. CORRECTIVE ACTION: RESECURED EXIT SIGN COVER AT MAIN CABIN DOOR IAW SAAB AMM 33-50-50-02,NO DEFECT NOTED.SDR DALA2018121907291Battery · faultedRCVD FAULT FOR EPSU 10WL, REPLACED 10WL BATTERYSDR DALA2018121907290Battery Pack · dischargedTHE FORWARD ENTRYWAY AND COCKPIT DOOR EMERGENCY LIGHT IS INOPERATIVE. MAINTENANCE REPLACED THE FORWARD AREA/COCKPIT DOOR EMERGENCY LIGHT BATTERY PACK REF AMM 33-51. OPERATIONAL CHECK IS GOOD.SDR SWAA2019011527960Guard · damagedCOCKPIT P5 PANEL EMERGENCY EXIT LIGHT SWITCH GUARD DAMAGED. R&R SWITCH GUARD IAW MM.SDR SWAA2019010927862Battery Pack · failedFORWARD ENTRY FUSELAGE EMERGENCY LIGHT BATTERY PACK FAILED THE CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2019010927846Lens · looseL1 DOOR LOWER EMERGENCY EXIT SIGN LENS LOOSE. SECURED LENS PER SIP.SDR SWAA2019010228144Battery · failedEMERGENCY LIGHT BATTERY M1673 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2019010228143Battery Pack · dischargedGROUND EMERGENCY FLOOD LIGHTS INOP. R&R M1670 BATTERY PACK PER MM.SDR SWAA2019010228142Battery Pack · dischargedBULLNOSE EMERGENCY EXIT LIGHT INOP AT STA 560. R&R M1670 BATTERY PACK PER MM.SDR SWAA2019010227907Battery Pack · dischargedBULLNOSE EMERGENCY EXIT LIGHT INOP AT STA 640. R&R M1670 BATTERY PACK PER MM.SDR SWAA2019010227891Lens · looseLT AFT EXIT LIGHT LENS FELL OFF. INSTALLED LENS PER MM.SDR SWAA2019010227872Battery · failedEMERGENCY LIGHT BATTERY M1670 FAILED CAPACITY TEST. R&R BATTERY PER MM.SDR SWAA2018122727919Battery Pack · dischargedL1 DOOR OVERHEAD EXIT LIGHT INOP. R&R M1674 BATTERY PACK PER MM.SDR SWAA2018122727921Battery Pack · discharged2 EA EMERGENCY EXIT AISLE LIGHTS INOP. R&R M1674 BATTERY PACK PER MM.SDR SWAA2018122727830Battery Pack · dischargedL2 DOOR EVAC SLIDE LIGHT INOP. R&R M1674 BATTERY PACK PER MM.SDR ASOA2018122685354Battery Pack · inoperativeDURING MX INSPECTION THE FORWARD CABIN EMERGENCY LIGHT WERE DISCOVERED INOP. MX REMOVED AND REPLACED THE #1 EMERGENCY LIGHT BATTERY PACK WITH OPERATIONAL CHECK GOOD. A/C WAS RELEASED FOR RETURN TO SERVICE.SDR ASOA2018122685352Battery Pack · inoperativePILOT REPORTED EMERGENCY LIGHTS INOP FROM ROW 7 AND AFT.MX REMOVED AND REPLACED #1, #3, AND #4 EMERGENCY BATTERIES WITH OPS CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR REXA2018122181311Light · inoperativeL/H AFT OVERWING WXIT LIGHT INOP
REPAIRED L/H AFT OVERWING EXIT LIGHT GOOD IAW CRJ 900 AMM
33.51.15.710.801SDR AALA2018122019004Power Supply · failedDURING AN EMERGENCY LIGHT TEST, AN MCDU MESSAGE FOR THE BATTERY IN POWER SUPPLY 13WL, ILLUMINATED. MAINTENANCE REPLACED THE POWER SUPPLY AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00.SDR JJBA2018122018022Sign · detachedOVERHEAD EMERGENCY EXIT SIGN AT ROW 18 FELL DOWN. SECURED EMERGENCY EXIT SIGN AT ROW 18. NO DEFECTS NOTED.SDR REXA2018121801271Battery Pack · dischargedEMERG LIGHTS INOP. PERFORMED OPERATIONAL TEST OF EMERGENCY LIGHTS IAW AMM 33-51-17. OPS CHECK FAIL. R&R BATTERY PACKS IAW JOBCARD 33-900-701. BATTERY PACK POSTIIONS R&R PS38, PS37, PS36, + PS35. A/C OK FOR SVC. OPS CHK GOOD.SDR REXA2018121801270Light · inoperativeEXIT ROWS BOTH SIDES EMERGENCY LIGHTS BULBS OUT. REMOVED AND REPLACE EXIT ROW EMERGENCY LIGHT BULBS IAW AMM 33-5
1-00.SDR AALA201812209017Battery Pack · no testIAW AN A CHECK WC 26C00033004. THE EMERGENCY POWER-SUPPLY UNIT BATTERIES 10WL, 11WL, 12WL, AND 13WL FAILED TO TEST. REPLACED THE 10WL BATTERY, IAW WC 2600033004. OK FOR SERVICE TESTED OK.SDR AALA201812209016Battery Pack · no testIAW AN A CHECK WC 26C00033004. THE EMERGENCY POWER-SUPPLY UNIT BATTERIES 10WL, 11WL, 12WL, AND 13WL FAILED TO TEST. REPLACED THE 10WL BATTERY, IAW WC 2600033004. OK FOR SERVICE TESTED OK.SDR AALA201812209015Battery Pack · no testIAW AN A CHECK WC 26C00033004. THE EMERGENCY POWER-SUPPLY UNIT BATTERIES 10WL, 11WL, 12WL, AND 13WL FAILED TO TEST. REPLACED THE 10WL BATTERY, IAW WC 2600033004. OK FOR SERVICE TESTED OK.SDR AALA201812209009Battery · no testFORWARD EMERGENCY LIGHT BATTERY WOULD NOT TEST IAW WC 2215. REPLACED THE BATTERY IAW AMM 31-51-38.SDR AALA201812209007Battery Pack · no testIAW AN A CHECK WC 26C00033004. THE EMERGENCY POWER-SUPPLY UNIT BATTERIES 10WL, 11WL, 12WL, AND 13WL FAILED TO TEST. REPLACED THE 10WL BATTERY, IAW WC 2600033004. OK FOR SERVICE TESTED OK.SDR AALA2018122099018Sign · inoperativeTHE LEFT OVERWING EXIT SIGN WAS NOT ILLUMINATED AT ROW 14A. REPLACED THE SIGN ASSY IAW AMM 35-51-11. OPS TESTED NORMAL.SDR DALA2018122007316Battery Pack · inoperative(AIRCRAFT 6808, L/P 5280304) FIRST CLASS EMERGENCY LIGHTS DIM AND EXTINGUISH IN 2 MINUTES. CORRECTIVE ACTION: REPLACED EMERGENCY LIGHT POWER SUPPLY BATTERY PER B757 AMM 33-51-07.SDR AALA201812199013Shroud · missingAIRCRAFT WAS NOT GROUNDED: SEAT 23C, BACK PLATE, EMERGENCY SHROUD LIGHT MISSING. MAINTENANCE REPLACED LIGHT SHROUD PER CMM 25-22-52 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SIMA20181218001Light · inoperativeLT AND RT EMERGENCY LIGHT OVER WING INOP. REMOVED AND REPLACED LT AND RT OVER WING EMERGENCY LIGHTS OPS CHECK GOOD IAW AMM 33-50-10.SDR SIMA20181218002Light · inoperativeAFT CEILING EMERGENCY LIGHT INOP. REMOVED AND REPLACED AFT CEILING EMERGENCY LIGHT BULB IAW AMM 33-50-10, OPS CHECK GOOD.SDR AALA201812199021Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. 4R CABIN ENTRY DOOR EMERGENCY EXIT LIGHT IS MISSING COVER. INSTALLED NEW COVER ON 4R EMERGENCY EXIT LIGHT.SDR AALA201812199020Cover · brokenTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY COVER AT L4 IS BROKEN. REPLACED EMERGENCY LIGHT COVER AT L4 DOOR PER AMM 25-00-00.SDR MASA2018121811598Battery · dischargedROW 13 EMERGENCY LIGHTS INOP. REPLACED BATTERY.SDR SWAA2019010727832Lens · looseG1 GALLEY EMERGENCY LIGHT LENS LOOSE. R&R LENS IAW CMM.SDR ASAA2018122177499Battery Pack · inoperativeOVER WING FWD EMERGENCY EXIT LIGHTS INOP LH & RH SIDE. GROUNDED - YES. OVERWING FWD EMERGENCY LIGHTS, OPS CHECK GOOD. M1694 BATTERY PACK REPLACED IAW B737-800 AMM 33-51-06-960-806. M1670 BATTERY PACK REPLACED IAW AMM 33-51-06-960-806. OPS CHECK GOOD.
Back to JASC 3350