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 AALA20180324004Power Supply · inoperativeL2 DOOR EMERGENCY LIGHT POWER SUPPLY INOPERATIVE. REPLACED THE POWER SUPPLY IAW AMM 33-51-06. TESTED GOOD.SDR SWAA2018032620669Sign · brokenRIGHT MID CABIN LOWER LIGHTED EMERGENCY EXIT SIGN BROKEN. R & R THE SIGN IAW AMM.SDR DALA2018032401873Epsu · faultyDIDN'T PASS TEST EPSU, EMERGENCY POWER SUPPLY UNIT 11WL AND 12WL IN PASSENGER CABIN, REPLACED EPSU-EMERGENCY POWER SUPPLY UNIT 11WL AND 12WL.SDR MASA2018032313083Battery Pack · dischargedROWS 3, 12, 13 EMERG EXIT SIGNS INOP. REPLACED NR 3 BATTERY PACK.SDR SIMA20180323003Sign · inoperativeAFT EMERGENCY EXIT ROW 11 A, B, & C CENTER AISLE INOPERATIVE. CONNECTED THE AFT OVERHEAD EMERGENCY EXIT SIGN. OPS CHECKED GOOD.SDR MASA2018032313082Lamp · inoperativeROW 18 OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR CALA2018032300995Light · inoperativeSEAT 1H AFT EMERGENCY LIGHT INOPERATIVE. REPLACED AND OPS TESTED NORMAL IAW AMM 33-51-05.SDR IPXA2018032327740Battery · no testEMERGENCY LIGHTS TEST SHOWED THE NR 1 BATERY LOW. OPS CHECKED THE EMERGENCY LIGHTING BATTERY POWER SUPPLY IAW AMM 33-51-01 CHECKED OKSDR F3LA2018032300298Slide · failedEMERGENCY LIGHT TEST ON PTP FAILED. REMOVED AND REPLACED THE L1 DOOR SLIDE, OPS CHECKED GOOD IAW AMM 25-62-44-400-006-A.SDR SWAA2018040320948Light · inoperativeAFT LAVATORY EMERGENCY LIGHT INOPERATIVE. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2018040320937Fuse · inoperativeR2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE FUSE IAW AMM.SDR SWAA2018040320936Fuse · inoperativeFORWARD WALL OF THE AFT LAVATORY EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE FUSE IAW AMM.SDR REXA2018032200227Charger · overheatedBS 813, STRINGER 1L, EMERGENCY LIGHT PACK SHOWS SIGNS OF OVERHEATING AT THE AFT END. REMOVED & REPLACED THE EMERGENCY LIGHT BATTERY CHARGER NR 5 IAW AMM 33-51-17. REMOVED & REINSTALLED EMERGENCY LIGHT BATTERY NR 5 IAW AMM 33-51-17. OPS CHECKED THE EMERGENCYSDR SWAA2018032720766Battery Pack · inoperativeRIGHT EMERGENCY AISLE STOWBIN LIGHT INOPERATIVE BETWEEN ROWS 6 TO 11. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018032720720Battery Pack · no testAFT RT EMERGENCY EXIT BATTERY PACK FAILED A TEST. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018032720719Battery Pack · no testAFT LEFT EMERGENCY LIGHT BATTERY PACK FAILED TO TEST. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018032720711Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY TEST AT M01669. R & R THE BATTERY PACK IAW AMM.SDR AALA201803239013Bulb · inoperativeEXIT LOCATION SIGN, MAIN AISLE, FORWARD CABIN, BULBS REPLACED IAW AMM 33-51-13. OPS CHECKED GOOD.SDR AALA201803269002Light · damagedFOUND EMERGENCY EXIT LIGHT FORWARD OF R2 ASSEMBLY DAMAGED. REPLACED LIGHT ASSEMBLY IAW AMM 31-51-01-960-802.SDR HALA2018032600121Sign · brokenL3 EMERGENCY EXIT SIGN BROKEN. SECURED THE EMERGENCY EXIT SIGN AND CHECKED NORMAL.SDR AALA201803269004Lens · missingRIGHT FORWARD OVERWING EMERGENCY EXIT SIGN LENS MISSING. REMOVED AND REPLACED THE SIGN IAW MM 33-51-01. OPS CHECKED NORMAL.SDR AALA201803269013Battery Pack · no testEMERGENCY LIGHT LEFT SIDE, ROW 7 THROUGH 23 INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND CHARGER ASSEMBLY IAW AMM 33-51-07 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201803269012Charger · faultedEMERGENCY LIGHT LEFT SIDE, ROW 7 THROUGH 23 INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND CHARGER IAW AMM 33-51-07 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201803269011Battery Pack · no testEMERGENCY LIGHT LEFTHAND SIDE, ROW 7 THROUGH 23 INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND CHARGER IAW AMM 33-51-07 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018032620668Lens · missingRIGHT OVERWING EXIT SIGN LIGHT CAP LOWER LEFT SIDE MISSING. INSTALLED THE LENS IAW AMM.SDR SWAA2018032620644Lamp · inoperativeLEFT SIDE OVERWING EXIT EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR AALA201803269003Light · brokenEMERGENCY LIGHT ASSEMBLY BROKEN ON BULKHEAD AFT OF RIGHT AFT LAVATORY. REPLACED LIGHT ASSEMBLY IAW MM 33-51-01.SDR AALA20180322004Power Supply · inoperativeR2 DOOR EMERGENCY LIGHT POWER ASSEMBLY M33097 IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33097. OPS CHECKED GOOD IAW AMM 33-51-06-960-803.SDR AALA20180322003Power Supply · inoperativeL1 DOOR EMERGENCY BATTERY POWER SUPPLY ASSEMBLY IS INOPERATIVE. REMOVED AND REPLACED L1 DOOR POWER SUPPLY. OPS CHECKED GOOD IAW AMM 33-51-06-960-803.SDR AALA201803239002Lens · brokenEMERGENCY LIGHT LENS BROKEN. INSTALLED A NEW LIGHT LENSSDR AALA201803239001Lens · missingEMERGENCY LIGHT LENS AT SEAT ROW 10L FOUND MISSING. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-19.SDR AALA20180322006Power Supply · inoperativeR4 DOOR EMERGENCY LIGHT POWER SUPPLY ASSEMBLY INOPERATIVE. REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-803.SDR AALA20180322005Power Supply · inoperativeL2 DOOR EMERGENCY LIGHTS POWER SUPPLY ASSEMBLY INOPERATIVE. REPLACED L2 DOOR POWER SUPPLY M33099 IAW AMM 33-51-06-960-803.SDR HALA2018032300102Sign · brokenL3 DOOR EMERGENCY EXIT SIGN BROKEN. REPAIRED THE SIGN.SDR SIMA20180322001Lamp · inoperativeDURING A PS-2 CHECK, FOUND THE AISLE EMERGENCY LIGHT INOPERATIVE AT ROW 12. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-08. OPS CHECKED GOOD.SDR SIMA2018003230002Lamp · inoperativeMAIN DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MAIN DOOR EXTERNAL EMERGENCY LIGHT LAMP IAW AMM 33-50-10-000-801-A, AND 33-50-10-400-801-A. OPS CHECKED GOOD.SDR IPXA2018032327734Bulb · inoperativeEMERGENCY LIGHT HAS SIX INOPERATIVE BULBS. R & R THE LAMPS IAW AMM 33-51-01-02.SDR 2018FA0000115Charger · overheatedEMERGENCY LIGHT CHARGER ASSY SHOWED SIGNS OF OVERHEAT AT AFT END. NO DAMAGE WAS NOTED TO THE BATTERY OR OTHER STRUCTURE DURING THE INSPECTION. NO KNOWN CAUSE OF OVERHEAT. CHARGER/ BATTERY ASSY WERE STILL FUNCTIONING NORMALLY. REQUESTED R&R BY CUSTOMER.SDR MASA2018032213079Light · inoperativeLT AFT EMERG DOOR EXIT LIGHT INOP. REPLACED EPSU 3.SDR QXEA2018032200112Light · malfunctionedWHILE SHUTTING DOWN POWER TO THE ACFT, WITH BOTH EMERGENCY LIGHT SWITCHES IN THE OFF POSITION, EMERGENCY LIGHTS STAYED ON. REMOVED FROM SERVICE. REMOVED THE CONNECTOR FROM THE ADVISORY SIGNS AND PASSENGER WARNING PANEL, PERFORMED GVI, NO DEFECTS NOTED. CONNSDR FDEA201803220751Light · inoperativeFLIGHT DECK DOME/EMERGENCY LIGHT WILL NOT ILLUMINATE DURING TEST. RELAMPED REF MM 33-51-09-3. OPS CHECK NORMAL. A/C OK FOR SERVICE.SDR 29GA2018032200002Battery · dischargedFLIGHT 0117 FLL/FPO REPORT. GATE RETURN DUE TO EMERGENCY LIGHTS INOP ON ROW 3 4 5 6 AND OVERHEAD LIGHTS ON ROW 7. RECHARGHED BATTERY FOR 20 MINUTES IAW AMM 33-50-00 AND PERFORMED AN OPERATIONAL CHECK OF EMERGENCY LIGHTS IAW AMM 33-50-0-05-1, SYSTEM OPERATES NOSDR SWAA2018032720779Lens · brokenAFT GALLEY AFT ENTRY EMERGENCY EXIT LIGHT LENS BROKEN. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2018032720772Light · inoperativeRIGHT EXTERIOR OVERWING EMERGENCY LIGHT INOPERATIVE. R & R THE LIGHT IAW AMM.SDR SWAA2018032720771Lamp · inoperativeRIGHT EMERGENCY AISLE LIGHT INOPERATIVE AT ROW 6. R & R THE LAMP IAW AMM.SDR SWAA2018032720770Lamp · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R THE LAMP IAW AMM.SDR SWAA2018032720716Battery Pack · inoperativeL1 DOOR OVERHEAD EXIT SIGN INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018032720710Lens · brokenR2 DOOR EMERGENCY LIGHT LENS BROKEN. R & R THE LIGHT ASSEMBLY IAW AMM.SDR AALA20180323001Power Supply · no testPERFORMED EMERGENCY POWER SUPPLY SYSTEM TEST, TEST FAILED. REPLACED EMERGENCY POWER SUPPLY IAW MM 33-51-38.SDR AALA201803229026Lens · missingR2 DOOR EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS IAW AMM 33-51-19.
Back to JASC 3350