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 DALA2017052304226Battery Pack · inoperativeRIGHT UPPER DECK EXIT LIGHT AT DOOR IS INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-51.SDR AALA201705249012Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT LENS IS MISSING AT SEAT 30C. REPLACED THE LENS.SDR SWAA2017052513999Lens · looseEMERGENCY EXIT LIGHT LENS LOOSE AT ROW 19 DEF. SECURED LENS PER MM.SDR SWAA2017052513992Light · inoperativeLT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA2017052513991Light · inoperativeEXIT LIGHT INOP AFT OF L1 DOOR. R&R LIGHT ASSY PER MM.SDR SWAA2017052513990Light · inoperativeLT OVERWING EXIT LIGHT INOP. RESECURED LIGHT BATTERY PACK PER MM.SDR SWAA2017052513983Lens · missingR1 DOOR EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA2017052513982Light · inoperativeEMERGENCY EXIT LIGHT INOP ABOVE ROW 4 ABC. RELAMPED PER MM.SDR SWAA2017052513981Light · looseEMERGENCY CEILING EXIT LIGHT LOOSE. R&R LIGHT ASSY PER MM.SDR AALA201705249018Battery Pack · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT LIGHTS FROM ROW 26 BACK ARE DIM. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR DALA2017052404187Power Supply · inoperativeDURING INSPECTION, FOUND THE RT AFT OVERWING EXIT LIGHT INOPERATIVE. MAINTENANCE R & R THE POWER SUPPLY M1671 IAW AMM 33-51. OPS CHECKED GOOD.SDR AALA201705249001Lens · brokenDURING CHECK, FOUND THE LEFT EMERGENCY LIGHT ASSEMBLY BROKEN AT LOWER LEFT CORNER. REPLACED THE LIGHT COVER IAW MM 33-51-13-04.SDR SWAA2017052413975Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT ROW 10D. INSTALLED LENS PER MM.SDR SWAA2017052413974Lens · crackedEMERGENCY LIGHT LENS CRACKED AT SEAT ROW 5C. R&R LENS PER MM.SDR SWAA2017052413973Lens · crackedEMERGENCY LIGHT LENS CRACKED AT SEAT ROW 8C. R&R LENS PER MM.SDR SWAA2017052413972Lens · crackedEMERGENCY LIGHT LENS CRACKED AT SEAT ROW 10D. R&R LENS PER MM.SDR SWAA2017052413971Lens · crackedEMERGENCY LIGHT LENS CRACKED AT SEAT ROW 12C. R&R LENS PER MM.SDR SWAA2017052413970Lens · crackedEMERGENCY LIGHT LENS CRACKED AT SEAT ROW 15C. R&R LENS PER MM.SDR SWAA2017052413969Lens · crackedEMERGENCY LIGHT LENS CRACKED AT SEAT ROW 7D. R&R LENS PER MM.SDR SWAA2017052413968Lens · crackedEMERGENCY LIGHT LENS CRACKED AT SEAT ROW 21D.SDR SWAA2017052413967Lens · crackedEMERGENCY LIGHT LENS CRACKED AT SEAT ROW 23C. R&R LENS PER MM.SDR AALA201705249015Battery · failedFOWARD EMERGENCY BATTERY FAILED. REPLACED THE BATTERY IAW AMM.SDR AALA201705249014Lens · missingEMERGENCY EXIT SIGN LENS MISSING ON THE R4 DOOR. REPLACED THE LENS AT THE R4 DOOR.SDR AALA201705249011Lens · missingL2 DOOR, ENTRY LIGHT LENS MISSING. INSTALLED A NEW LENS.SDR AALA201705249006Light · malfunctionedEMERGENCY LIGHTS ON WILL NOT TURN OFF, WHEN SELECTED OFF. EMERGENCY LIGHT SYSTEM CHECKED NORMAL.SDR SIMA20170524001Battery Pack · dischargedEMERGENCY LIGHTS WON'T STAY ON FOR MORE THAN A FEW SECONDS. CHARGED THE BATTERY WITH APU POWER AND OPS CHECKED IAW AMM 33-51-00, ACFT OK FOR SERVICE.SDR DALA2017052304140Cids · malfunctionedEMERGENCY EXIT SIGNS AT DOOR 3L UNABLE TO EXTINGUISH. RESET CIDS ACC AIM 23-73-00-710.SDR MASA2017052312322Light · inoperativeROW 20-21 OVHD EMER FLOOD LT INOP. RELAMPED.SDR DALA2017052304108Light · contaminatedOVERWING AISLE OVERHEAD EMERGENCY EXIT SIGN PARTIALLY OBSCURED. REMOVED DEBRIS FROM INSIDE BOTH LENS, OPS CHECKED GOOD.SDR DALA2017060504553Battery Pack · inoperativeOVER WING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK. OPERATIONAL CHECKED GOOD.SDR YENA201705220398Battery Pack · no testDURING HEAVY MAINTENANCE, EPSU FWD LT BATTERY FAULT ON PTP TEST. R & R EPSU FWD LEFT BATTERY PACK, OPS CHECKED GOOD IAW AMM 33-51-38.SDR AALA201705259032Lens · missingEMERGENCY EXIT LIGHT AFT GALLEY BY THE L4 DOOR HAS A MISSING LENS. REPLACED THE LENS. OPERATIONAL CHECKED GOOD.SDR AALA20170522010Connector · disconnectedDURING WALK AROUND FOUND AT SEAT 2D EMERGENCY LIGHT DOES NOT WORK, TROUBLE SHOT SEAT 2D EMERGENCY LITE. FOUND LOOSE CONNECTOR AT D-261. RECONNECTED OPS OK IAW ESO 21371. THE AIRCRAFT WAS GROUNDED.SDR DALA2017052304230Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED. REPLACED THE LENS.SDR SWAA2017052513988Light · looseLT OVERWING EXIT LIGHT LOOSE. R&R LIGHT ASSY PER MM.SDR SWAA2017052513984Light · inoperativeRT OVERWING EXIT LIGHT INOP. RELAMPED PER MM.SDR AALA201705249021Lens · brokenAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 30DEF HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR SWAA2017052413965Battery · failedEMERGENCY EXIT LIGHT BATTERY PACK M1675 FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR HNAA2017052200183Bulb · inoperativeEMERGENCY LIGHT BULB INOPERATIVE. R & R THE BULB.SDR DALA2017052204139Battery · dischargedDURING COCKPIT 1A CHECK OPERATION TEST OF EPSU FAILED 3 BATTERIES. REPLACED EPSU BATTERIES 11WL, 12WL, AND 18WL.SDR F3LA2017052300154Power Supply · inoperativeDURING EMERGENCY LIGHT TEST L1 EPSU INOPERATIVE. REMOVED AND REPLACED EPSU 10WL FWD. OPERATIONAL CHECK OK. REFERENCE AMM 33-51-38 PAGE BLOCK 401.SDR F3LA2017052300153Battery · dischargedEPSU BATTERY 12WL RIGHT FAULT. FAILS TEST. REMOVED AND REPLACED BATTERY ASSEMBLY 12WL RIGHT. REFERENCE AMM 33-51-38-000-002A AND AMM 22-51-38-400-002A. EPSU UNIT P/N 3214-62-10 S/N 007451. OPERATIONAL CHECK GOOD.SDR R61A201705220369Battery · malfunctionedEMERGENCY LIGHT FAULT EICAS MESSAGE PRESENT. RESET AFT OUTBOARD EMERGENCY LIGHT BATTERY IAW FIM 33-50-00-810-803-A00. FAULT CLEARED.SDR AALA20170523005Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BATTERY AT L4 DOOR (13WL) FAILED TEST. REPLACED EXIT LIGHT BATTERY PER MM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170523004Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BATTERY AT L3 DOOR (12WL) FAILED TEST. REPLACED EXIT LIGHT BATTERY PER MM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201705239016Power Supply · faultedFIVE EMERGENCY EXIT ROW LIGHTS WERE INOPERATIVE WHEN TESTED. TROUBLESHOT AND FOUND THE EPSU 11WL FAULTED, REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT 11WL IAW AMM 33-51-38-000-001-A.SDR AALA201705239011Lens · mislocatedEMERGENCY LIGHT LENS AT SEAT 1AC FOUND LOOSE. SECURED THE LENS. OPS NORMAL.SDR AALA201705229031Power Supply · faultedFIVE EMERGENCY EXIT ROW LIGHTS WERE INOPERATIVE WHEN TESTED. TROUBLESHOT AND FOUND EPSU 11WL FAULTED , REMOVED AND REPLACED EMERGENCY POWER SUPPLY IAW AMM 33-51-38-000-001-A.SDR DALA2017052304129Battery · dischargedROW 24, BOTH SIDES EMER EXIT LIGHTS ON OVERWING DOOR INOP. REPLACED BATTERIES AT ROW 24 PER AMM 33-53.SDR CALA2017052201538Unknown · malfunctionedEMERG EXIT LIGHTS CYCLING CABIN WITH CABIN ALT WARNINGS NORMAL. OPS TEST OF EMERG LIGHTS TEST GOOD REF AMM 33-51-00-710-001-A.
Back to JASC 3350