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 DALA2016102807925Battery Pack · not reportedDURING TEST FOUND PER WORK CARD 3350-7413, EMERGENCY LIGHTING BATTERY PACK AT ROW 23 D,E,F. MAINTENANCE REMOVED AND REPLACED EMERGENCY LIGHTING BATTERY PACK AT ROW 23 D ,E,F PER AMM 33-51-06.SDR DALA2016102807924Lens · unsecureDURING INSPECTION FOUND EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. MAINTENANCE SECURED LENS. CHECKED OK.SDR AALA20161028009Sign · looseAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT DOOR L3 IS NOT SECURE. ACCOMPLISHED ADJUSTMENT OF EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161028005Battery Pack · failedAIRCRAFT NOT GROUNDED. EMERGENCY ESCAPE PATH MARKING BATTERY PACK AB5-3 FAILED TEST. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-60-98. OPERATIONAL CHECK GOOD.SDR IPXA2016102609937Lens · brokenINSPECTION TYPE: UNARMED EMERGENCY LT INDICATOR SWITCH BROKEN. INSTALLED A NEW UNARMED LENS IAW M 33-16-02 & TESTED IAW MM 33-51-00 OPS CHECKED OK.SDR IPXA2016102609936Power Supply · inoperativeDURING EMERGENCY LIGHT TEST, THE EMERGENCY LIGHT BATTERY 1 LOW, LEVEL 1 ALERT DISPLAYED. R & R BATTERY POWER SUPPLY IAW AMM 33-51-01-401-00-802. OPS CHECKED GOOD.SDR SWAA2016102809156Battery · dischargedR1 DOOR EMERGENCY LIGHT INOP. R&R BATTERY PER AMM.SDR DALA2016102707849Light · damagedSEAT MOUNTED EMERGENCY LIGHT SEAT 21C DAMAGED, EMERGENCY LIGHT REPAIRED.SDR DALA2016102707832Fuse · inoperativeINTERNAL EMERGENCY LIGHTS AT SEATS 6D-9D ARE INOPERATIVE. MAINTENANCE FOUND A FUSE BLOWN IN POWER PACK M9011 AND REPLACED. SYSTEM OPERATION IS NORMAL.SDR DALA2016102707831Lamp · inoperativeEXIT LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE LAMPS. SYSTEM OPERATION IS NORMAL.SDR DALA2016102707830Light · inoperativeINTERNAL EMERGENCY LIGHTS AT SEAT 1A ARE INOPERATIVE. REPLACED LIGHT ASSEMBLY.SDR DALA2016102707827Contactor · inoperativeL1 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REPLACED THE LIGHT CONTACTOR. SYSTEM OPERATION IS NORMAL.SDR SWAA2016102709144Cover · missingCEILING EMERGENCY LIGHT COVER MISSING BETWEEN ROW 9 TO ROW 10. INSTALLED COVER IAW AMM.SDR AALA20161027003Pin · missingR3 DOOR EMERGENCY EXIT SIGN BRACKET MISSING INSTALLATION PINS. ACCOMPLISHED INTERIM REPAIR IAW ENGINEERING AUTHORIZATION 264846.SDR AALA20161026017Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK IS LOW AND WILL NOT CHARGE. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA20161026016Battery Pack · inoperativeEMERGENCY LIGHTING BATTERY PACK IS LOW AND WILL NOT CHARGE. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA20161026015Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK LOW AND WILL NOT CHARGE. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR DALA2016102707789Lens · damagedEMERGENCY LIGHT LENS DAMAGED. REPAIRED.SDR SIMA20161026004Lamp · inoperativeAISLE EMERGENCY LIGHT NR 2, FAILED TO ILLUMINATE. R & R THE LAMP IAW AMM 33-50-08. OPS CHECKED GOOD.SDR SIMA20161026003Lamp · inoperativeMAIN PAX DOOR EMERGENCY LIGHT FOUND INOPERATIVE. REMOVED AND REPLACED THE LAMP. OPS CHECKED GOOD IAW AMM 33-50-10.SDR MASA2016102612477Light · inoperativeAFT OVERHEAD EMER EXIT LIGHT INOP. REPLACED BULB.SDR HNAA2016102600336Battery Pack · malfunctionedTWO ADJACENT RED FLOOR EMERGENCY LIGHTS ILLUMINATED, THEN EXTINGUISHED. REMOVED AND REPLACED BATTERY. OPS CHECKED GOOD.SDR MASA2016102612476Light · inoperativeAFT CEILING EMERGENCY FLOOD LIGHT INOPERATIVE.SDR HNAA2016102600334Contact · dirtyRIGHT UPPER EMERGENCY SIDEWALL LIGHT AT EXIT ROW IS INOPERATIVE. REMOVED THE EMERGENCY EXIT LIGHT. CLEANED CONTACTS AND CHECKED FOR PROPER VOLTAGE. REINSTALLED LIGHT ASSY, OPS CHECKED GOOD IAW MM 33-50-13-04. OK FOR SERVICE.SDR SWAA2016112209893Light · brokenBROKEN EMERGENCY EXIT LIGHT ON WALL AT FWD GALLEY AREA. REPLACED THE LIGHT ASSY IAW MM.SDR REXA2016102502127Lamp · inoperativeNR 1 CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-16. OPS TESTED GOOD IAW AMM 33-51-00.SDR AALA201610319017Lens · missingEMERGENCY LIGHT LENS AT SEAT 7D MISSING. REPLACED LIGHT LENS.SDR AALA201610319016Lens · missingEMERGENCY LIGHT LENS AT SEAT 5D MISSING. REPLACED LIGHT LENS.SDR AALA201610319015Lens · missingEMERGENCY LIGHT LENS AT SEAT 3C MISSING. REPLACED THE LENS.SDR AALA201610269026Cover · missingEMERGENCY LIGHT AT SEAT 1C MISSING. REPLACED THE COVER.SDR CALA2016102800816Lens · missingLENS COVER MISSING FROM EXIT PATH LIGHTING BY DOOR 712 ON F/C CLOSET. INSTALLED LENS, ON PROXIMITY LIGHT, TEST OK AMM 33-51-00-710-801, CMM 25-20-23,33-51-02. OKSDR ASOA201610250615Battery · dischargedCREW REPORTED THE EMERGENCY LIGHTS WOULD NOT TURN ON. THE EMERGENCY LIGHT SYSTEM WAS CHARGED AND FAULT NO LONGER EXIST. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR AALA201610269032Light · brokenAIRCRAFT WAS NOT GROUNDED. BROKEN EMERGENCY LIGHT ON AISLE AT ROW 12 ABC. REPLACED EMERGENCY LIGHT PER CMM 25-22-52.SDR AALA201610269031Lens · unsecureAIRCRAFT WAS NOT GROUNDED. ESCAPE PATH LENS COVER AT 34C CAME OFF. REINSTALLED LENS COVER.SDR AALA201610269030Cover · unsecureAIRCRAFT WAS NOT GROUNDED. EXIT LIGHT COVER BY 2L CAME OFF. MAINTENANCE REPLACED LIGHT COVER.SDR AALA201610269025Lens · missingAIRCRAFT WAS NOT GROUNDED. R4 PAX DOOR MISSING EXIT SIGN LENS COVER. REPLACED EXIT SIGN LENS COVER AMM 33-51-16.SDR AALA201610269024Lens · unsecureAIRCRAFT WAS NOT GROUNDED. EMERGENCY LENS FELL OFF AT DOOR 4L. MAINTENANCE REPLACED EMERGENCY LENS.SDR UHLA201610250477Light · out of positionTHE EMERGENCY LIGHT STRIP FOR ROW 7DC IS OUT OF POSITION. ADJUSTED THE EMERGENCY LIGHT IAW AMM 33-50-21.SDR SWAA2016102709135Lens · looseFORWARD ENTRY DOOR EXIT LIGHT COVER LENS LOOSE. SECURED LENS IAW AMM.SDR AALA20161027001Light · inoperativeEMERGENCY SLIDE OVERWING LIGHT AT EXTERIOR R3 DOOR INOPERATIVE. REMOVED AND REPLACED THE LIGHT IAW AMM 33-51-04. OPS CHECKED GOOD.SDR ASAA2016102518477Light · detachedFA REPORTED THE EMERGENCY LIGHTING COMING UP FROM THE FLOOR AT ROW 12. ACFT GROUNDED. SECURED THE LIGHT.SDR DALA2016102607734Battery Pack · inoperativeFWD OVERWING, OVERHEAD EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERIES AS REQUIRED IAW AMM 33-50. OPS CHECKED GOOD.SDR ASOA201610253060Inverter · inoperativeDURING ROUTINE MAINTENANCE, THE EMERGENCY EXIT SIGN BY THE SERVICE DOOR WAS FOUND INOPERATIVE. MAINTENANCE REPLACED THE INVERTER. OPS CHECKED GOOD.SDR SWAA2016102609104Battery Pack · dischargedFORWARD LT EMERGENCY LIGHTS INOP. R&R BATTERY PACK ASSEMBLY IAW MM.SDR AALA20161026012Lens · unsecureAIRCRAFT NOT GROUNDED. FORWARD GALLEY SERVICE DOOR EMERGENCY EXIT LIGHT LENS COVER WILL NOT STAY ON. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161025007Battery · faultyAIRCRAFT NOT GROUNDED. FORWARD LEFT EMERGENCY POWER SUPPLY UNIT BATTERY INOPERATIVE. REMOVED AND REPLACED BATTERY IAW AMM 33-51-38. OPERATIONAL TEST GOOD.SDR YENA20161025946Battery Pack · no testDURING ROUTINE MAINTENANCE, THE EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R & R EMERGENCY POWER SUPPLY IAW AMM 33-50-01. OPS CHECK PASSED.SDR DALA2016102507643Lamp · inoperativeSLIDE INDICATOR LIGHT INOPERATIVE FORWARD TO MCO. REPLACED THE LAMP.SDR YENA20161025945Connector · damagedDURING ROUTINE MAINTENANCE, THE EMERGENCY LIGHT INOPERATIVE, SEAT 23A WAS FOUND TO BE INOPERATIVE. ; REPAIRED UNDER SEAT CONNECTOR. PERFORMED OPS CHECK. OPS CHECK PASSED.SDR MASA2016102512475Light · inoperativeESCAPE PATH LIGHTING BY FWD GALLEY INOPERATIVE. PLACED ON MEL.
Back to JASC 3350