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 SWAA2017010911026Sign · brokenL2 DOOR EMERGENCY EXIT SIGN ON BULKHEAD BROKEN. R&R SIGN PER MM.SDR QXEA2017010900002Relay · malfunctionedFA REPORTS EMERGENCY LIGHTS ARE REMAINING ILLUMINATED. TRIED CYCLING ALL SWITCHES, NO FIX. CYCLED A/C POWER AFTER SHUTDOWN, NOW HALF OF EMERGENCY LIGHTS ON WHEN SWITCH IS TURNED ON. TROUBLE SHOT EMERG LIGHT SYSTEM AND FOUND LIGHTS ALTERNATE WHEN SWITCHING BETWSDR DALA2017010900194Power Supply · warning messageL4 DOOR EPSU FAULT MESSAGE APPEARED. REPLACED EPSU IAW AMM 33-52.SDR DALA2017010900193Power Supply · warning messageR4 DOOR EPSU FAULT MESSAGE APPEARED. REPLACED EPSU IAW AMM 33-52.SDR SIMA20170108003Light · inoperativeEXTERIOR LEFT LOWER EMERGENCY LIGHT ASSEMBLY INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW 33-50-10. OPS CHECKED GOOD.SDR SIMA20170108002Battery Pack · inoperativeEMERGENCY LIGHT STRIP 2 AND 3 AS WELL AS EXIT SIGN ON BACK OF GALLEY WILL NOT ILLUMINATE. REMOVED AND REPLACED THE NR 2 BATTERY PACK AND POWER SUPPLY IAW AMM 33-50-04 AND CHANGED THE NR 2 AND 3 EMERGENCY LIGHT INVERTER IAW AMM 33-50-11. OPS CHECKED GOOD.SDR DALA2017010900160Light · malfunctionedRIGHT WING EMERGENCY LIGHT INOPERATIVE. REPLACED FUSE. SYSTEM OPERATION IS NORMAL.SDR HALA2017010900003Sign · unsecureDOOR 3R EMERGENCY EXIT SIGN FELL OFF. RE-SECURED DOOR 3R EMERGENCY EXIT SIGN.SDR AALA20170108001Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT JUST AFT OF FORWARD GALLEY HAS A DETACHED LENS COVER. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170110018Sign · crackedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT R1 DOOR IS CRACKED. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA20170108003Epsu · failedAIRCRAFT NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT AT 10WL FAILED TEST. REMOVED AND REPLACED EPSU IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR SWAA2017010911036Lens · brokenL1 EXIT SIGN LENS AT LOWER PORTION BROKEN. R&R LENS PER SIP.SDR DALA2017010800209Lamp · inoperativeSEAT ROW 1CD EMERGENCY LIGHTS INOPERATIVE. REPLACED THE LAMPS. OP'S CHECKED GOOD.SDR ASAA2017010719260Sign · detachedEXIT SIGN BY R1 DOOR DETACHED. ACFT GROUNDED. REMOVED, REPLACED, AND TESTED THE SIGN ASSY L1186 IAW AMM 33-51-01-960-802, OPS NORMAL.SDR AALA201701089005Cover · brokenR4 DOOR EMERGENCY LIGHT COVER BROKEN. MAINTENANCE REPLACED THE COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701089004Cover · brokenL4 DOOR EMERGENCY LIGHT COVER BROKEN. MAINTENANCE REPLACED THE COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701089003Cover · missingL4 DOOR EXIT LIGHT COVER MISSING. MAINTENANCE REPLACED THE COVER IAW AMM 33-51-13.SDR SIMA20170107004Control Panel · inoperativeMAIN DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MAIN DOOR EMERGENCY LIGHT PANEL ASSEMBLY IAW AMM 25-23-04. OPS CHECKED GOOD IAW AMM 33-50-00.SDR SIMA20170107005Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-09. OP CHECKED GOOD IAW AMM 33-50-00.SDR MASA2017010512796Light · inoperativeAFT CEILING LEVEL EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR DALA2017051103789Housing · damagedEMERGENCY LIGHTS HOUSING DAMAGED. REPLACED THE HOUSING. OPS CHECKED GOOD.SDR SWAA2017012311387Lens · brokenFORWARD GALLEY AREA EMERGENCY EXIT SIGN LENS BROKEN. R & R THE LENS IAW AMM.SDR SWAA2017012311376Lens · brokenAFT GALLEY EMERGENCY LIGHT LENS BROKEN. R & R THE LENS IAW AMM.SDR SWAA2017011811235Lens · brokenAFT GALLEY LAVATORY EMERGENCY EXIT LIGHT LENS BROKEN. R & R THE LENS IAW AMM.SDR ASOA201701063004Light · inoperativeDURING ROUTINE MAINTENANCE, THE NR 3 FLOOR EMERGENCY PROXIMITY AISLE LIGHT WAS FOUND INOPERATIVE. MAINTENANCE REPLACED THE THE NR 3 LIGHT STRIP. OPS CHECKED GOOD.SDR SWAA2017011211119Sign · defectiveL1 DOOR LOWER EMERGENCY EXIT SIGN MISSING DIRECTIONALLY ARROW. R&R SIGN ASSEMBLY PER AMM.SDR AALA20170110008Battery · dischargedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHTS AROUND L1 AND R1 DOOR FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY IAW 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA20170110005Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT SEATS 16ABC IS MISSING THE LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170107001Battery Pack · dischargedAIRCRAFT NOT GROUNDED. SEAT MOUNTED EMERGENCY LIGHTS IN FIRST CLASS FAILED TEST. REMOVED AND REPLACED BATTERY PACK M10952 IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR DALA2017010900225Light · damagedEMERGENCY SEAT MOUNTED LIGHT DAMAGED. REPLACED AND SECURED FWD LED LIGHT ASSY, OPS TESTED OK.SDR SWAA2017010911040Lens · crackedL1 DOOR EMERGENCY EXIT LIGHT COVER LENS CRACKED. R&R LENS IAW MM.SDR CALA2017010900037Light · damagedG1 RT WALL MOUNT EEL FOUND DAMAGE (P/N: 8054-1). REPLACED G1 RT WALL MOUNT EEL AND C/O OPERATION TEST FOUND NORMAL AS PER AMM 33-51-12 REV 182.SDR QXEA2017010900003Light · inoperativeFORWARD F/A EMERGENCY LIGHT CONTROL PANEL HAS A LIGHT OUT. RELAMPED THE FORWARD F/A EMERGENCY SWITCH LIGHT. CHECKS GOOD. RETURNED TO SERVICE.SDR AALA20170109029Charger · failedEMERGENCY EXIT LIGHT MOUNTED ON BIN AT ROW 14DEF DID NOT ILLUMINATE DURING TEST. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-51-03, BATTERY PACK M1676 IAW AMM 33-51-06, AND CHARGER IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA20170109028Power Supply · failedEMERGENCY EXIT LIGHT MOUNTED ON BIN AT ROW 14DEF DID NOT ILLUMINATE DURING TEST. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-51-03, BATTERY PACK M1676 IAW AMM 33-51-06 AND CHARGER IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA20170109027Light · failedEMERGENCY EXIT LIGHT MOUNTED ON BIN AT ROW 14DEF DID NOT ILLUMINATE DURING TEST. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-51-03, BATTERY PACK M1676 IAW AMM 33-51-06 AND CHARGER IAW AMM 33-51-06. OPS CHECKED GOOD.SDR REXA2017010600010Lamp · inoperativeFORWARD LEFT EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-51-15. OPSCHECKED GOOD.SDR DALA2017010900195Cover · detachedL3 DOOR EXIT SIGN COVER DETACHED. INSTALLED EXIT SIGN COVER.SDR AALA201701079004Lens · missingMISSING EMERGENCY LIGHT LENS AT ROW 14 LEFT. REPLACED THE LENS ASSEMBLY AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701079002Light · brokenEMERGENCY EXIT LIGHT AT ROW 12 ABC FOUND BROKEN. REPLACED THE LIGHT ASSEMBLY AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017010900172Bulb · missingEMERGENCY LIGHT LENS AND BULB MISSING. REPLACED THE BULB . FOUND THE LENS UNDER SEAT AND INSTALLED.SDR YENA201701060021Battery Pack · inoperativeALL CABIN EMERGENCY LIGHTS WILL NOT ILLUMINATE WHEN POWER IS LOST. R & R THE BATTERY PACKS. OPS CHECK PASSED IAW AMM 33-51-38.SDR YENA201701060020Battery Pack · inoperativeALL CABIN EMERGENCY LIGHTS WILL NOT ILLUMINATE WHEN POWER IS LOST. R & R THE BATTERY PACKS. OPS CHECK PASSED IAW AMM 33-51-38.SDR YENA201701060019Battery Pack · inoperativeALL CABIN EMERGENCY LIGHTS WILL NOT ILLUMINATE WHEN POWER IS LOST. R & R THE BATTERY PACKS. OPS CHECK PASSED IAW AMM 33-51-38.SDR YENA201701060018Battery Pack · inoperativeALL CABIN EMERGENCY LIGHTS WILL NOT ILLUMINATE WHEN POWER IS LOST. R & R THE BATTERY PACKS. .OPS CHECK PASSED IAW AMM 33-51-38.SDR CALA2017010600032Battery · dischargedEMERGENCY EXIT LIGHT BATTERY POSITION L FWD 10WL FAILED CAPACITY TEST PER A CHECK CARD. REPLACED FWD LEFT EMERGENCY EXIT LIGHT BATTERY REF AMM 33-51-00 -710-003. OPS TEST PASSED.SDR CALA2017010600031Battery · dischargedEMERGENCY LIGHTS TEST FAILED AT PTP. REPLACED BATTERY AT 12WL EPSU REF AMM 33-51-38PB401. NOW OK FOR SERVICE.SDR CALA2017010600030Cover · abnormalEMERGENCY EXIT SIGN DOES NOT TURN ON 2L EMERGENCY EXIT SIGN INOP FOUND LOWER EMER. EXIT COVER MISSING, LIGHT OPS GOOD. REPLACED EMER EXIT COVER. A/C OK TO CONTINUE.SDR CALA2017010600029Light · inoperativeFWD GALLEY AISLE WAY FWD EMERGENCY LIGHT INOP AND MISSING COVER. REPLACED LAMP ASSEMBLY AND OP CHK GOOD.SDR CALA2017010600028Battery Pack · dischargedEMERGENCY LIGHTS, SEAT ROW 22-28ABC AISLE LIGHTS INOP. CHARGED EMERGENCY LIGHTS, ALL CHK NORMAL.
Back to JASC 3350