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 AALA201802089009Charger · inoperativeRIGHT OVERWING EXIT SIGN INOPERATIVE. REPLACED THE BATTERY & CHARGER ASSEMBLY IAW AMM 33-53-00.SDR AALA201802089007Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHTS ROWS 28 TO 31 INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW WDM 33-51-12. OPS CHECKED GOOD.SDR AALA201802089006Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AND CHARGER IAW 33-51-13. OPS CHECKED GOOD.SDR AALA201802089055Connector · not seatedOPS TEST OF THE EMERGENCY LIGHTS FAILED FOR THE POWER SUPPLY. MAINTENANCE TROUBLESHOT IAW TSM 33-51-00-810-807-A. RESEATED THE CONNECTOR ON THE RIGHT CENTER POWER SUPPLY IAW AMM 33-51-38, AND PERFORMED A SATISFACTORY OPS CHECK.SDR AALA201802089033Battery · dischargedFORWARD SEAT MOUNTED EMERGENCY LIGHT HAD A LOW BATTERY, BS 243 OVERHEAD DROP DOWN PANEL. REPLACED THE BATTERY PACK IAW AMM 33-53-00.SDR AALA201802089017Light · detachedTHE AIRCRAFT WAS NOT GROUNDED. THE EXIT LIGHT FELL OFF THE 4L DOOR. REPLACED EMERGENCY LIGHT EXIT AT 4L DOOR PER AMM 33-53-01. OPERATIONS CHECK GOOD.SDR AALA201802119013Lens · missingAIRCRAFT WAS NOT GROUNDED. AFT EMERGENCY LIGHT LENS AT SEAT 7G IS MISSING. INSTALLED AFT EMERGENCY LIGHT LENS AT SEAT 7G PER CMM 25-02-67.SDR AALA201802119012Switch · faultyAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT TEST SWITCH HAS RED LINE INDICATION WHEN SELECTED OFF AT 1L DOOR FLIGHT ATTENDANT SWITCH PANEL (SUSPECT DEFECTIVE SWITCH). REPLACED 1L FLIGHT ATTENDANT PANEL EMERGENCY LIGHT SWITCH PER AMM 33-22-06.SDR AALA201802119011Control Panel · faultyAIRCRAFT WAS GROUNDED. 1L DOOR EMERGENCY LIGHT HAS A RED LINE THROUGH IT. REPLACED L1 DOOR FLIGHT ATTENDANT PANEL ASP PER MM 33-051-00.SDR AALA201802099009Battery Pack · no testOVERHEAD EMERGENCY LIGHTS INOPERATIVE FROM AFT CABIN DOOR THROUGH EMPENNAGE. AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE BATTERY PACK AND CHARGER IAW WDM 33-51-13, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201802099008Charger · faultyFOWARD RIGHT GALLEY EMERGENCY LIGHTS BATTERY PACK AND CHARGER SUSPECTED OF BEING BAD. MAINTENANCE REPLACED THE CHARGER IAW WDM 33-51-15, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802089054Charger · faultyOVERHEAD EMERGENCY LIGHTS INOPERATIVE FROM AFT CABIN DOOR THROUGH EMPENNAGE. AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE BATTERY PACK AND CHARGER IAW WDM 33-51-13 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802089053Battery Pack · no testFOWARD RIGHT GALLEY EMERGENCY LIGHT BATTERY PACK AND CHARGER SUSPECTED OF BEING BAD. MAINTENANCE REPLACED THE BATTERY PACK AND CHARGER IAW WDM 33-51-15 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2018020900798Charger · inoperativeEMERGENCY LIGHTS AT SEATS 27 - 32 INOPERATIVE. R & R THE BATTERY AND CHARGER IAW AMM 33-51. OPS CHECKED GOOD.SDR FDEA201802060312Battery Pack · failedDURING PREFLIGHT OF EMERGENCY LIGHTS RECIEVED LEVEL 1 ALERT EMER LT BAT 1 LO. REMOVED AND REPLACED EMERGENCY LIGHTING BATTERY POWER SUPPLY PER M/M 33-51-01-4. OPS CHECKED NORMAL PER M/M 33-51-01-5. OK FOR SERVICE.SDR ASAA2018020623441Lamp · failedEMERGENCY LIGHT INOPERATIVE AT THE OVERWING EXTERIOR FWD RT. ACFT GROUNDED. REPLACED THE LAMPS, OPS CHECKED NORMAL IAW AMM 33-51-04-960-801.SDR ASAA2018020623435Lamp · failedEMERGENCY LIGHT OUT, AFT OF THE L2 DOOR. ACFT GROUNDED. REPLACED THE LAMPS. OPS GOOD IAW AMM 33-51-04/201.SDR HNAA2018020700026Bulb · inoperativeOVERHEAD EMERGENCY LIGHT AT THE PAX DOOR WAS FOUND INOPERATIVE. R & R THE BULB.SDR DALA2018020700748Light · inoperativeFOUND THE L2 DOOR EMERGENCY LIGHTS INOPERATIVE.SDR DALA2018020700734Battery Pack · no testWHILE PERFORMING AMDS CARD 3350-7202 DISCOVERED THE EMERGENCY LIGHT BATTERY PACKS FAILED TO TEST. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACKS IAW AMM 33-51.SDR 29GA2018020700002Switch · faultyEMERGENCY LIGHT SWITCH ON THE FA PANEL INOPERATIVE. R & R SWITCH IAW AMM 25-25-25-04, & 39-40-50, OPS CHECKED GOOD IAW AMM 33-50-00.SDR 29GA2018020700001Power Supply · failedREAR HALF OF EMERGENCY LIGHTS IN CABIN NOT INOPERATIVE. R & R THE POWER SUPPLY 24LN IAW AMM 33-50-10-04-1, OPS CHECKED GOOD.SDR DALA2018020600713Lens · brokenEXIT SIGN BROKEN AT R1 DOOR. REMOVED AND REPLACED EMERGENCY LIGHT LENS IAW MM. OPERATION CHECKS GOOD.SDR BUEA20180206001Battery Pack · dischargedDURING AIRCRAFT PREFLIGHT, THE CREW REPORTED NONE OF THE EMERGENCY LIGHTS ILLUMINATED. THE CREW UTILIZING THE APU GENERATOR AND THE EMERGENCY ARM SWITCH WAS ABLE TO RECHARGE THE FOUR BATTERIES AND GET ALL EMERGENCY LIGHTS ILLUMINATED.SDR DALA2018020600732Battery Pack · not reportedSHIP 1814 WRKG WC 3350-7453 FOUND EMERGENCY LIGHTING BATTERY PACKS AT M6757 M7236,M737,M732,M6760. CORRECTIVE ACTION: REMOVED & REPLACED EMERGENCY LIGHTING BATTERY PACKS AT LOC M6757,M7236,M737,M732 & M6760. IAW B767-400
AMM 33-51. OK FOR SVC. (4122446).SDR AALA201802069013Battery · faultedEMERGENCY LIGHT POWER SUPPLY BATTERY FAULTED. REPLACED THE BATTERY IAW AMM 33-51-38.SDR SWAA2018021919846Battery · inoperativeEMERGENCY LIGHT BATTERY AT M1674 INOPERATIVE. R & R THE BATTERY IAW AMM.SDR SWAA2018021419666Sign · inoperativeLEFT OVERWING EXIT SIGN INOPERATIVE. REPAIRED THE SIGN IAW MM.SDR SWAA2018021419648Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED A CAPACITY CHECK. R & R THE M01672 BATTERY IAW AMM.SDR SWAA2018021319676Sign · brokenFORWARD DOOR EXIT SIGN BROKEN. R & R THE SIGN IAW AMM.SDR SWAA2018021319635Lens · crackedR2 DOOR EMERGENCY LIGHT LENS CRACKED. R & R THE LENS IAW SIP.SDR AALA201802089005Lens · missingFLOOR EMERGENCY SIGN LENS MISSING IN THE AISLE, RIGHT SIDE. REPLACED THE LENS IAW AMM 33-51-00. OK FOR SERVICE.SDR AALA201802089015Light · detachedEMERGENCY LIGHT AT SEAT 30D IS DANGLING AND PULLED OUT. PERFORMED AN OPS CHECK AND INSTALLED THE SEAT MOUNTED EMERGENCY LIGHT ASSEMBLY IAW MM 33-51-11. OK FOR FURTHER SERVICE.SDR AALA201802089051Lens · missingFLOOR LEVEL EMERGENCY EXIT LIGHT ACROSS FROM FOWARD LAVATORY WAS MISSING THE LENS. MAINTENANCE REPLACED THE LIGHT ASSY IAW WDM 33-51-15, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018020819560Lens · unsecureLEFT EMERGENCY LIGHT LENS FAILED. SECURED THE LENS IAW SIP.SDR SWAA2018020719529Cover · looseFORWARD ENTRY EMERGENCY EXIT SIGN COVER LOOSE. R&R LIGHT ASSEMBLY PER AM.SDR HNAA2018020700027Bulb · inoperativeLEFT AFT EXTRIOR EMERGENCY LIGHT DIM. R & R THE BULB, OPS CHECKED GOOD.SDR AALA201802069014Light · brokenSEAT 21ABC ROW EMERGENCY LIGHT ASSEMBLY BROKEN. REPLACED THE EMERGENCY LIGHT.SDR DALA2018020700723Pin · brokenTAIL COMPARTMENT CENTER CAT WALK EMERGENCY LIGHT INOP. REPLACED BROKEN PIN PER SWPM 20-10-02, CKS GOOD.SDR 7C7A2018020500366Light · inoperativeEMERGENCY EXIT BACKLIGHTING OVER AIRSTAIR INOP.SDR DALA2018020600686Light · inoperativeAFT EMERG LIGHT RT SIDE IN 48 SEC INOP. RELAMPED PER AMM 33-00 OPS CK NORMAL AT THIS TIME.SDR CALA2018020500490Fuse · faultyEMERGENCY SEAT MOUNTED FLOOR PROXIMITY LIGHTS INOP, ROWS 22-31. REMOVED AND REPLACED EMG BATT PK M1670 FUSES AS PER AMM 33-51-06 , SECURED CARPET RISER AND OPS CKS GOOD. ACFT OK TO CONTINUE.SDR CALA2018020500491Lens · missingEEL LENS COVER MISSING ROW 20DEF LOWER SIDEWALL. INSTALLED NEW COVER.SDR QXEA2018020500039Battery Pack · no testFORWARD MOST EMERGENCY LIGHTS BATTERY PACKS FAILED AN OPS CHECK. REMOVED AND REPLACED THE BATTERY PACKS IAW AMM 33-51-00-820-801.SDR AALA201802089016Lens · missingEMERGENCY LIGHT LENS AT SEAT 2E FOUND MISSING. REPLACED THE LENS IAW AMM 33-20.SDR SWAA2018020819604Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT AFT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018020819601Lens · brokenOVERWING EMERGENCY EXIT LIGHT COVER LENS BROKEN. R&R LENS PER AMM.SDR AALA201802079008Battery · dischargedTAMPER TAB MISSING ON EMERGENCY FLASHLIGHT. MAINTENANCE REPLACED THE BATTERY AND TAMPER SEAL IAW MM 26-64-00, AND PERFORMED SATISFACTORY OPS CHECK.SDR AALA201802079007Lens · damagedEXIT SIGN LENS AT THE R2 DOOR WAS FOUND DAMAGED. REPLACED THE LENS IAW AMM 33-51-01.SDR AALA201802079006Lens · missingEMERGENCY LIGHT LENS AT SEAT 1E MISSING. REPLACED THE LENS IAW AMM 33-20.
Back to JASC 3350