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 SWAA2019092637214Light · inoperativeAFT GALLEY EMERGENCY EXIT LIGHT LOCATOR BULB INOP. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2019092637213Light · inoperativeLT OVER WING LOCATOR EMERGENCY EXIT SIGN BULB INOP. RELAMPED SIGN PER AMM.SDR SWAA2019092637212Light · inoperativeLT OVER WING WINDOW EMERGENCY EXIT LIGHT HAD ONE BULB INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019092637211Light · inoperativeFORWARD GALLEY EMERGENCY EXIT LIGHT BULBS INOP. RELAMPED LIGHT PER AMM.SDR DALA2019092600148Sign · out of positionLEFT OVERHEAD EMERGENCY EXIT SIGN MISSING. FOUND SIGN AT A DIFFERENCE DOOR, INSTALLED. LP 5885837SDR AALA201909259007Battery Pack · failedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY POWER ASSIST SYSTEM BATTERY PACK ASSEMBLY M52123 FAILED OPERATIONALTEST. REPLACED BATTERY PACK PER AMM 52-12-19.SDR AALA201909259003Battery · dischargedAIRCRAFT IN BASE VISIT: EPSU 13WL AT DOOR 2L FAILS JOBCARD 33C22033002 "OPS CHECK EMERGENCY LIGHTS VIA MCDU" T/S IAW TSM 33-51-00-810-802-A. REMOVED AND REPLACED BATTERY AT ESPU 13WL IAW AMM 33-51-00. OPS GOOD.SDR E07A20191210006Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR E07A20191210005Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR SWAA2019101657820Sign · brokenPASSENGER COMPARTMENT EMERGENCY EXIT LIGHT AT CENTER CABIN EXIT ROW BROKEN. R&R SIGN IAW AMM.SDR SWAA2019101537814Light · brokenFORWARD LAVATORY, L1 DOOR EMERGENCY EXIT LIGHT BASE BROKEN. R&R LIGHT IAW AMM.SDR SIMA20190923003Profile · damagedMULTIPLE REMOVED EMERGENCY LIGHT STRIP PROFILES DAMAGED.-C/A-REPLACED ALL DAMAGED EMERGENCY LIGHT STRIP PROFILES AS REQUIRED. REF NRWC 697-MQT-04283 FOR REINSTALLATION.SDR SWAA2019092637246Battery Pack · dischargedRT FORWARD ENTRY OVER DOOR EMERGENCY EXIT LIGHT INOP AT M1674. R&R BATTERY PACK PER AMM.SDR SWAA2019092637242Light · inoperativeLT LOWER OVERWING EMERGENCY EXIT AFT ESCAPE LIGHT INOP BELOW WING. RELAMPED LIGHT PER AMM.SDR SWAA2019092637241Battery Pack · dischargedEMERGENCY LIGHT IN COMMON WITH M1673 INOPERATIVE. R&R POWER SUPPLY BATTERY PACK PER AMM.SDR SWAA2019092637235Battery Pack · failedRT OVERWING EMERGENCY EXIT LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2019092637234Battery Pack · failedRT AFT EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2019092637233Battery Pack · failedLT FORWARD EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2019092637232Cover · missingLT EMERGENCY LIGHT LENS COVER MISSING ABOVE SEAT ROW 9. INSTALLED COVER PER SIP.SDR DALA2019092405539Sign · not reported(AIRCRAFT 662, L/P 5447592) EMERGENCY EXIT SIGN OVER 2L NEEDS TO BE REINSTALLED. CORRECTIVE ACTION: REPLACED EXIT SIGN LENS @2L PER AMM 33-50.SDR DALA2019092405529Sign · unsecure(AIRCRAFT 6705, L/P 6632320) CTR AISLE EXIT SIGNS FELL OUT OF BRACKET. CORRECTIVE ACTION: RE-ASSEMBLED CENTER AISLE OVERHEAD EXIT SIGN LENS. OPS CHKS OK IAW AMM 33-51.SDR DALA2019092405528Battery Pack · discharged(AIRCRAFT 5808, L/P 5953873) EMERGENCY LIGHT SEAT 28FED-32FED WILL NOT STAY ON MORE THAN 15 MIN PER WORKCARD 3351-7004. CORRECTIVE ACTION: REMOVED AND REPLACED BATTERY PACK M11488 PER B757 AMM 33-51-07. OPS TEST GOOD.SDR ASOA201909234053Inverter · inoperativeIAH - FLIGHT 4155, DURING MAINTENANCE INSPECTION THE LEFT HAND OVER WING EXIT SHROUD EXIT MARKER FAILED TO ILLUMINATE. MAINTENANCE REMOVED AND REPLACED THE #4 INVERTER, OPERATIONALLY TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2019092405511Power Supply · inoperativeEMERGENCY LIGHTS ON SEATS 32D AND 33D INOP, REPLACED AFT EMERGENCY POWER SUPPLY UNIT.SDR SWAA2019092437179Battery Pack · dischargedEMERGENCY LIGHTS INOP INTERIOR AT M1674. R&R EMERGENCY LIGHT BATTERY PACK PER AMM.SDR SWAA2019092437178Battery Pack · dischargedEMERGENCY LIGHTS INOP EXTERIOR AT M1674. R&R EMERGENCY LIGHT BATTERY PACK PER AMM.SDR SWAA2019092437177Battery Pack · dischargedEMERGENCY LIGHTS INOP INTERIOR AT M1672. R&R EMERGENCY LIGHT BATTERY PACK PER AMM.SDR SWAA2019092437162Battery Pack · dischargedEMERGENCY LIGHTS INOP EXTERIOR AT M1672. R&R EMERGENCY LIGHT BATTERY PACK PER AMM.SDR SIMA20190923001Light · inoperativeDURING PS-1 CHECK, FOUND FORWARD AMBER EMERGENCY LIGHT FLOOR PROXIMITY STRIP AND SERVICE DOOR SMALL EXIT IDENTIFIER SIGN INOP. C/A-R&R FWD AMBER EMERGENCY LIGHT FLOOR PROXIMITY STRIP, OPC BAD, IAW AMM 33-50-12. REF ITEM 2 OF THIS NRWCSDR AALA2019092300001Charger · failedEMERGENCY LIGHT DID NOT TEST.SDR AALA2019092300000Battery Pack · failedEMERGENCY LIGHTS DID NOT TEST.SDR MASA2019092312052Battery · dischargedROW 21 EMER FLOOD LIGHT INOP. CHARGED BATTERIES.SDR MASA2019092312051Battery · dischargedROW 17 EMER FLOOD LIGHT INOP. CHARGED BATTERIES.SDR DALA2019092305442Battery Pack · discharged(LOG 6204177) DURING INSPECTION FOUND EMERGENCY LIGHTS BY L1 DOOR AREA AND EXIT SIGN BY FWD LAV INOPERATIVE. R/R L1 DOOR ARE EMERGENCY BATTERY PACK PER AMM 33-51. OPS CHECK NORMAL.SDR DALA2019092305438Battery Pack · dischargedTHE FORWARD GALLEY EMERGENCY LIGHTS AND THE FORWARD OVERWING EXIT IDENTIFIER EMERGENCY LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT BATTERY PACKS B5-118 AND B5-235 IAW AMM 33-51. OPERATIONAL CHECK WA GOOD. (LP #6074402)SDR SWAA2019102138019Lens · brokenSIDEWALL PANEL 232YHW EMERGENCY EXIT LIGHT LENS BROKEN. / R&R LIGHT ASSEMBLY IAW SIP AND AMM.SDR IPXA2019092347086Power Supply · inoperativeON EMERG LT TEST ON PRE FLIGHT. GET LEVEL 1 ALERT. "EMER LT BATT 1 LO". ITEM PLACED ON MEL 33-50-4, ACCOMPLISHED DNP 33-50-4 OK FOR SVC. REPLACED EMERGENCY POWER SUPPLY IAW MM 33-51-01-401. OPS TEST GOOD. THIS CLEARS M683993SDR SWAA2019092637205Battery Pack · dischargedEMERGENCY EXIT LIGHTS ASSOCIATED WITH BATTERY PACK M1669 INOP. R&R BATTERY PACK PER AMM.SDR DALA2019092405531Cover · unsecure(AIRCRAFT 6702, L/P 6236654) 2L EMERGENCY EXIT LIGHT COVER FELL OFF. CORRECTIVE ACTION: RESECURED SAME. OK FOR SVC.SDR DALA2019092405530Fuse · blown(AIRCRAFT 5653, L/P 6093702) R2 DOOR EMERGENCY DOOR LIGHTS INOP UPPER AND SIDE. CORRECTIVE ACTION: REPLACED FUSES ON EMERGENCY LIGHTS POWER SUPPLY M732 AND OPS CHECKED PER AMM 33-51 ALL OPS CHK. NML. DURING T/S FOUND R2 DOOR EMER LIGHTS LENS COVER IN POOR CONDSDR DALA2019092305524Cover · brokenSEAT 36C EMERGENCY PATH LIGHT BROKEN OFF, REPLACED PATH LIGHTING COVER.SDR AALA201909239009Light · inoperativeAIRCRAFT WAS NOT GROUNDED: CABIN CEILING EMERGENCY LIGHT 202WL INOPERABLE. MAINTENANCE REPLACED CEILING LIGHT PER AMM 33-51-11.SDR ASAA2019092230779Light · inoperativeR1 DOOR HEADER PANEL HAS INOP EMERGENCY LIGHT. GROUNDED - YES. REMOVED AND REPLACED R1 DOOR HEADER PANEL EMERGENCY LIGHT M1674 IAW AMM 33-51-06, SYSTEMS CHECKS GOOD IAW AMM 33-51-06 AND 33-51-00.SDR DALA2019092305492Light · inoperativeIN-SEAT EMERGENCY LIGHTS INOPERATIVE AT SEATS 4D, 5D, 6D. REPLACED ALL EMERG EXIT BULBS AT ROWS 4,5,6D AND OVERHEAD ISLE EXIT SIGNS. REPLACED FUSES ON POWER SUPPLY M9011. SYSTEM OPERATION IS NORMAL.SDR SWAA2019092437141Ballast · inoperativeLT EMERGENCY AISLE LIGHT ABOVE ROW 12 INOP. REPAIRED BALLAST PER MM.SDR DALA2019092300143Light · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE AT SEAT 15AB. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT SEAT 15AB. LP 6205182SDR U2RA201909220002Lens · missingSEAT ROW 22 CLEAR EMERGENCY EGRESS LIGHT LENS MISSING. REPLACED LENS PER AIRCRAFT MAINTENANCE MANUAL 33-51-11.SDR U2RA201909220001Lens · missingSEAT ROW 15D RED EMERGENCY EGRESS LIGHT LENS MISSING. REPLACED LENS PER AIRCRAFT MAINTENANCE MANUAL 33-51-11.SDR MASA2019092312050Battery · dischargedROW 14 EMER FLOOD LIGHT INOP. CHARGED BATTERIESSDR AALA201909239035Power Supply · failedAIRCRAFT WAS GROUNDED: EMERG LTSD TEST FAIL MSF EPSU INT LOAD AFT L. REMOVED AND REPLACED POWER SUPPLY UNIT AT AFT POSITION 13WL IAW AMM 33-51-38 ALL OPS CHECKS OK.
Back to JASC 3350