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 DALA2017022701601Cover · missingFOUR EMERGENCY LIGHT COVERS MISSING IN ZONE 1. REPLACED THE COVERS.SDR SWAA2017022712098Cover · missingRIGHT OVERWING EMERGENCY LIGHT COVER MISSING. INSTALLED A COVER IAW AMM.SDR CALA2017022500485Light · inoperative5 SEAT MOUNTED FLOOR PROXIMITY EMERGENCY LED LIGHTS INOP SEATS 11C, 15C, 20C, 32C, 14C FLOOR PROXIMITY EMERGENCY LED. REMOVED AND REPLACED 5 SEAT MOUNTED EMERGENCY LIGHTS REF AMM 33- 51-14. OPS CHECK GOOD AT THIS TIME.SDR CALA2017022500483Power Supply · faultedLT EMERGENCY LIGHT UNIT FAULT. REPLACED EMER LT POWER SUPPLY AT LT OVERWING EMER EXT POS. OPS C HECK AND SELF TEST ARE GOOD REF AMM 33-51-38.SDR CALA2017022500482Battery Pack · faultyEMERGENCY LIGHT BATTERY LEFT AFT FAULT REMOVED AND REPLACED LEFT AFT EMERGENCY BATTERY PACK REF AMM 33-51-38. OPS CHECK GOOD.SDR CALA2017022500481Light · not seatedCOCKPIT EMERGENCY LIGHT OVER FLIGHT DECK ENTRY DOOR STAY ON WITH POWER OFF. RESEATED LIGHT REF 33 51 00.SDR AALA20170227015Light · inoperativeCEILING EMERGENCY LIGHT AT ROW 3EF IS INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-22-00. OPERATIONAL CHECKED GOOD.SDR AALA20170227026Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE. DOOR 1L EXTERNAL EMERGENCY LIGHT FOUND INOPERABLE. REPLACED BATTERY PACK M33424 PER AMM 33-51-06.SDR AALA20170227025Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE. MDCR EMERGENCY LIGHT AT DOOR 3L FOUND INOPERABLE. REPLACED BATTERY PACK M33400 PER AMM 33-51-06.SDR AALA20170227024Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE. ZONE B ENVOY SEAT EMERGENCY LIGHT FOUND INOPERABLE. REPLACED DOOR 3R BATTERY PACK M33404 PER AMM 33-51-06.SDR IPXA2017022714455Power Supply · failedEMERGENCY LIGHT BATTERY 1 LOW. R & R THE POWER SUPPLY IAW AMM 33-51-01-4 REV 87. OPS TESTED GOOD.SDR AALA201702259004Cover · missingEMERGENCY LIGHT CABLE ASSEMBLY 740WL10 HAS A MISSING PROTECTIVE COVER. INSTALLED A NEW COVER IAW DRAWING F92393044.SDR AALA201702259003Cover · missingEMERGENCY LIGHT CABLE ASSEMBLY 618WL12 HAS A MISSING PROTECTIVE COVER. INSTALLED A NEW COVER FOR CABLE ASSEMBLY IAW DRAWING F92393044.SDR AALA201702259002Cover · missingEMERGENCY LIGHT CABLE ASSEMBLY 740WL9 HAS MISSING PROTECTIVE COVER. INSTALLED A NEW PROTECTIVE COVER FOR CABLE ASSEMBLY IAW DWG F92393044.SDR SWAA2017022812177Lens · brokenFORWARD ENTRY LOWER EMERGENCY EXIT LIGHT LENS BROKEN. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2017022812171Cover · crackedFORWARD CABIN CENTER AISLE EMERGENCY EXIT LIGHT COVER CRACKED. R & R THE COVER IAW AMM.SDR PNSA20170228001Bulb · inoperativeEMERGENCY LIGHT ON FA PANEL INOPERATIVE. REMOVED AND REPLACED THE BULB.SDR AALA201702259014Wire · brokenLEFT EMERGENCY AISLE LIGHT INOPERATIVE. FOUND THE WIRES AT SIDE WALL CONNECTION BROKEN AT THE CONNECTOR PLUG. REPAIRED THE WIRES IAW ESPM 20-44.SDR AALA201702259008Battery · no testEMERGENCY LIGHT BATTERY 18WL, FLAGGED BY EMERGENCY POWER SUPPLY UNIT TEST. REPLACED THE BATTERY AT 18WL IAW AMM 33-51-38.SDR AALA201702259007Battery · no testEMERGENCY LIGHT BATTERY 14WL, FLAGGED BY EMERGENCY POWER SUPPLY UNIT TEST. REPLACED THE BATTERY AT 14WL IAW AMM 33-51-38.SDR AALA201702259006Battery · no testEMERGENCY LIGHT BATTERY 11WL, FLAGGED BY EMERGENCY POWER SUPPLY UNIT TEST. REPLACED THE BATTERY AT 11WL IAW AMM 33-51-38.SDR AALA201702259001Light · detachedDETACHED EMERGENCY LIGHT STRIP AT SEAT 1D. MAINTENANCE SECURED THE LIGHT STRIP IAW AMM 33-50-21.SDR SWAA2017022712154Lens · brokenRIGHT EMERGENCY LIGHT LENS BROKEN AT ROW 14. R & R THE LENS IAW SIP.SDR SWAA2017022712147Lens · brokenEMERGENCY LIGHT LENS BROKEN BETWEEN ROW 8 TO ROW 12. R & R THE LENS IAW SIP.SDR AALA20170227014Sign · detachedEMERGENCY EXIT SIGN TO THE LEFT OF R4 DOOR IS DETACHED. SECURED EXIT SIGN. OPERATIONAL CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA20170227013Lens · detachedSEAT MOUNTED EMERGENCY LIGHT AT 22D HAS A DETACHED LENS. SECURED THE LENS IAW AMM 33-51-18. OPERATIONAL CHECKED GOOD.SDR AALA20170225001Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT AT SEAT 11C IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-18. OPERATIONAL CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR DALA2017022601578Light · inoperativeEMERGENCY LIGHTS ROW 18 D-E AND 28-D-E INOPERATIVE. REPLACED THE LIGHT ASSY. REPLACED THE LIGHTT EXTENSION 28 D-E. TESTED NORMAL.SDR SWAA2017022712101Sign · brokenL1 DOOR LOWER EMERGENCY EXIT SIGN COVER BROKEN. R & R THE SIGN IAW MM.SDR SWAA2017022712100Lens · detachedRIGHT LOWER EMERGENCY EXIT SIGN LENS FELL OFF. INSTALLED LENS IAW SIP.SDR SIMA20170224001Lamp · inoperativeMAIN ENTRY EMERGENCY LIGHT LAMP INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-10-000-801-A, AND 33-50-10-400-801-A. OPS CHECKED GOOD.SDR CALA2017022400478Power Supply · faultyAFTER EMER LTS TEST, RESULT EPSU FWD LT. REPLACED FWD EPSU AND BATTERY PER MM 33-51-38. OPS CK GOOD.SDR CALA2017022400474Sign · inoperativeBOTH RIGHT SIDE OVER THE WING EMERGENCY EXIT DOORS ELECTROLUMINESCENT EXIT IDENTIFIER SIGN LIGHT INOP. T-S PER WDM 33-51-14 PG 1A S 1, FOUND BOTH EXIT DAIL, R+R EXIT LT'S OPN CHK GOOD PER AMM 33-51-00.SDR CALA2017022400472Battery Pack · dischargedEMERGENCY EXIT EEL SIGNS VERY DIM AT RIGHT OVERWING EMERGENCY EXIT DOORS, LOWER GREEN EXIT SIGNS, AND MID RIGHT LAV FLOOR EEL VERY DIM. SLAVED IN NEW BATTERY PACK. LIGHT TEST GOOD. BATTERY PACK NEED SECURED IN AIRCRAFT REF AMM 33-51-07.SDR CALA2017022400470Power Supply · faultyRIGHT SIDE UPPER OVERWING EMERGENCY LIGHTS 2EA LIGHTS (L1698 & L813) FAILED TO ILLUMINATE DURING EMERGENCY LIGHTS TEST. "A" CHECK JOB CARD 74-3351-1-7105, SSM 33-51-04 PG 103 SHT 1 & WDM 33 -51-41- PG 1 SH 1. AMM 33-51-03. TS PER WDM 33-51-41 PG 1 SHT 1. NR 6SDR CALA2017022400469Battery Pack · dischargedDOOR 4L EMERGENCY LIGHTS INOP. REPLACED EMERGENCY LIGHT SYS CONTROL UNIT AND BATT PACK. SYSTEM CHK OK REF DMCB787-A-33-51--07-02B-520A-A AND DMC-B787-A-33-51- 00-00C-320A-A.SDR CALA2017022400442Battery Pack · weakRT WINDOW ESCAPE EMERGENCY EXIT LIGHT BATTERY WEAK. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK AND PREFORMED OPS TEST NORMAL REF B737 AMM 33-51-06SDR CALA2017022400476Light · inoperativeBULB BURNED OUT ON OVERHEAD PANEL-EMERG EXIT UNARMED LT. RELAMPED CKS OK.SDR REXA2017022400260Bulb · inoperativeLEFT AFT EXTERIOR EMERGENCY LIGHT BULB BURNED OUT AND STUCK IN SOCKET ASSY. REMOVED AND REPLACED LH AFT EXTERIOR EMERGENCY LIGHT ASSY AND REPLACED THE BULB IAW AMM 33-51-21. OPS CHECKED GOOD.SDR R61A201702240175Light · dimMAINTENANCE REPORTED THAT THE FORWARD RIGHT EMERGENCY LIGHT STRIP WAS DIM. MAINTENANCE REMOVED AND REPLACED THE LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201702240174Light · looseMAINTENANCE REPORTED THAT TWO EMERGENCY STRIP HOLDERS WERE NOT SECURE. MAINTENANCE SECURED HOLDERS IAW AMM AND OPS CHECKED GOOD.SDR HNAA2017022400063Bulb · dimLOWER EMERGENCY LIGHT IS DIM BY ROW 4AC. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR HNAA2017022400062Bulb · dimLOWER EMERGENCY LIGHT BY PAX DOOR IS DIM. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR ASOA201802234012Charger · inoperativeDURING MAINTENANCE INSPECTION THE AFT OVERWING EMERGENCY LIGHT WAS FOUND TO BE INOPPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED EMERGENCY LIGHT BATTERY CHARGER, OPERATIONALLY TESTED WITH NO DEFECTS, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVISDR AALA20170228001Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE. DOOR 4R FORWARD BATTERY PACK (M33408) FOUND INOPERABLE. REPLACED BATTERY PACK PER AMM 33-51-06.SDR AALA20170227027Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE. DOOR 4R AFT BATTERY PACK (M33409) FOUND INOPERABLE. REPLACED BATTERY PACK PER AMM 33-51-06.SDR AALA20170227005Light · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT IN RIGHT AFT GALLEY AREA HAS A BROKEN CLIP AND IS DETACHED FROM BRACKET. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT L1191 IAW AMM 33-52-01. OPERATIONAL CHECK GOOD.SDR SWAA2017022812178Lens · crackedFORWARD CABIN OVERHEAD EMERGENCY LIGHT LENS CRACKED AT ROW 2. R & R THE LENS IAW AMM.SDR SWAA2017022812170Battery · inoperativeFORWARD FLASHLIGHT INOPERATIVE. R & R THE BATTERY IAW AMM.SDR SWAA2017022712119Light · damagedL1 DOOR EMERGENCY LIGHT LENS AND CIRCUIT BOARD DAMAGED. R & R THE LIGHT ASSEMBLY IAW MM.
Back to JASC 3350