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 CALA2017111304060Power Supply · no testOVERWING EPSU FAULT ILLUMINATED DURING AN EMERGENCY LIGHT TEST. REPLACED LEFT OVERWING EPSU. REPLACED THE RT OVERWING EXIT SIGNS AND OVERWING CENTER EXIT SIGN IAW AMM 33-51-38-400-001-A, SYSTEM CHECKED GOOD.SDR CALA2017111304059Lamp · no testEPSU DISPLAYED DURING EMERGENCY LIGHT TEST. REPLACED THE LAMPS IAW MM 33-51-15. OPS TESTED OK.SDR CALA2017111304058Battery Pack · no testEPSU DISPLAYED AFTER EMERGENCY LIGHT TEST. TESTED AFT LEFT EPSU. TEST INDICATED A FAULT. REPLACED THE BATTERY PACK IAW AMM 25-23-45-000-003-A, CHECKED OK.SDR CALA2017111304057Power Supply · faultedAFT CABIN EMERGENCY LIGHT POWER SUPPLY TEST FAULTED. REPLACED THE POWER SUPPLY IAW AMM 33-51-38-400-001-A, TESTED OK.SDR CALA2017111304056Lens · missingEMERGENCY LIGHT AT THE FORWARD GALLEY CLOSET, MISSING THE LENS. INSTALLED A NEW LENS IAW 33-51-14-960-801.SDR CALA2017111304052Battery Pack · dischargedMAIN DECK R3 DOOR EMERGENCY LIGHT POWER SUPPLY M33401 FOUND TO HAVE LOW CAPACITY. REPLACED THE BATTERY, OPS TEST FOUND GOOD IAW AMM 33-51-06-960-802, REV 81.SDR CALA2017111304054Lens · missingEMERGENCY EXIT SIGN LENS MISSING AT THE L2 DOOR. REPLACED THE LENS.SDR MASA2017111312762Light · inoperativeROW 21 EMERGENCY OVERHEAD FLOOD LIGHT INOPERATIVE.SDR MASA2017111312761Battery Pack · dischargedROW 12 EMERGGENCY FLOOD LIGHT INOPERATIVE. CHARGED THE BATTERIES.SDR MASA2017111312760Battery Pack · dischargedROW 12 EMERGENCY EXIT SIGN INOPERATIVE. CHARGED THE BATTERIES.SDR UIEA2017112002265Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE AT R1 DOOR AND ALL LIGHTS RIGHT OF CENTER LIGHT. REMOVED AND REPLACED THE BATTERY PACK M10684 IAW MM 33-51-04-402-D12-001.SDR AALA201711149034Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT OVER LEFT OVERWING EXIT HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201711149031Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE R2 DOOR AND AFT GALLEY HAS A MISSING LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA201711149027Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT IN THE FIRST CLASS AISLE HAS A MISSING LENS COVER. REPLACED LIGHT ASSEMBLY PER AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA201711149025Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE R2 DOOR IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA201711149008Sign · missingTHE AIRCRAFT WAS NOT GROUNDED. THE AFT GALLEY WALL EXIT SIGN NEAR 4L DOOR IS MISSING. MAINTENANCE REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-10.SDR AALA201711149003Lens · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT ON THE AFT LEFT GALLEY EXIT HAS A DAMAGED LENS COVER. REMOVED AND REPLACED EMERGENCY EXIT SIGN PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201711149015Battery · dischargedAIRCRAFT WAS NOT GROUNDED: AFT PASSENGER DOOR EMERGENCY LIGHT BATTERY INOPERABLE DURING CIDS TEST. REPLACED AFT PASSENGER DOOR EMERGENCY LIGHT BATTERY AT 13WL PER AMM 33-561-38. MAINTENANCE PERFORMED SUCCESSFUL OPERATIONS CHECK.SDR AALA20171113002Battery · failedEMERGENCY BACKUP BATTERY 13WL FAILED DURING CIDS TEST. REPLACED EMERGENCY BACKUP BATTERY IAW MM 33-51-38. MAINTENANCE PERFORMED SUCCESSFUL OPS CHECK.SDR SWAA2017111517830Battery Pack · inoperativeR1 DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017111517801Lens · missingRIGHT OVERWING EXIT FORWARD LOWER EMERGENCY EXIT SIGN LENS MISSING. INSTALLED LENS IAW AMM.SDR SWAA2017111517781Bulb · inoperativeL1 DOOR LOWER EMERGENCY LIGHT BULB INOPERATIVE. R & R THE BULB IAW AMM.SDR SWAA2017111517780Light · inoperativeFORWARD GALLEY OVERHEAD DROP DOWN PANEL EXIT LIGHT INOPERATIVE. R & R THE LIGHT IAW AMM.SDR SWAA2017111517775Battery Pack · inoperativeRIGHT EMERGENCY LIGHT INOPERATIVE AT ROW 6. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017111517774Battery Pack · inoperativeFORWARD ENTRY EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017111517773Battery Pack · inoperativeAFT LEFT WING EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR DALA2017111408134Lens · detachedEXIT SIGN LENS ABOVE THE L1 DOOR DETACHES. SECURED THE SIGN LENS. ACFT OK FOR SERVICE.SDR 7C7A2017111300339Light · inoperativeFWD CENTER AISLE CABIN EMERGENCY LIGHT INOPERATIVE.SDR DALA2017111308116Lens · missingEMERGENCY LIGHT LENS MISSING AT 27A. REPLACED THE LENS.SDR HALA2017111308097Sign · detachedL3 DOOR EXIT SIGN DETACHED. SECURED THE SIGN.SDR SWAA2017111317704Sign · brokenMID CABIN CEILING EMERGENCY EXIT SIGN ASSEMBLY FRAME BROKEN. R & R THE SIGN ASSEMBLY IAW AMM.SDR DALA2017111308080Sign · detachedEMERGENCY EXIT SIGN COVER LOOSE. THE LIGHT WAS HANGING BY WIRES. SECURED THE EXIT SIGN.SDR DALA2017111308078Power Supply · inoperativeAFT ACCESSORY EMERGENCY LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY B5-260 IAW AMM 33-51. OPS CHECKED GOOD.SDR MASA2017111212758Battery Pack · dischargedNUMEROUS EXIT LIGHTS INOP. CHARGED BATTERIES.SDR CALA2017111204046Light · intermittent1R SLIDE LIGHT INTERMITTENT WHEN ARMING DOOR. 1R SLIDE INDICATION GROUND CHECKS NORMAL.SDR CALA2017111204044Light · inoperativeEMER LT NOT ILLUMINATED AT 9DC MONITOR SIDEWALL. REPLACED EMER LT ASSY AT 9DC MONITOR SIDEWALL AS PER AMM 33-51-0 5-960-801 REV 81.SDR CALA2017111204043Light · inoperativeDOOR 3R SLIDE EMER LIGHT NOT ILLUMINATED. REPLACED DOOR 3R SLIDE EMER LT LAMP AND OPS TEST FOUND ''NORMAL'' REF AMM 33-51-04-960-801 REV 81.SDR CALA2017111204042Light · looseEEL LIGHTS AT SEAT 10C, 15C AND 35C ARE HANGING DOWN FROM THE SEAT ASSY. REMOVED AND REPLACED PARTS AS REQUIRED TO FIX SEATS 10C 15C 35C OPS CHECK GOOD ON EEL LIGHTS.SDR MASA2017111212757Light · inoperativeROWS 9 & 14 OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2017111212755Battery Pack · inoperativeL2 DOOR EMERGENCY EXIT SIGN WAS INOPERATIVE. TROUBLESHOT TO A BAD BATTERY PACK.SDR SWAA2017120518250Battery Pack · inoperativeL/H OVERWING EMERGENCY EXIT LIGHT INOP AT LOCATION M1668. / R&R BATTERY PACK PER AMM.SDR DALA2017112708369Light · inoperativeFWD CLOSET MOUNTED FLOOR PROX EMERGENCY ESC PATH MARKER LIGHT OUT. REPLACED LIGHT ASSY FWD COAT CLOSET.SDR AALA201711139037Battery · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT 11WL BATTERY FAULT ON EMERGENCY LIGHT TEST. REPLACED EMERGENCY POWER SUPPLY UNIT 11WL BATTERY PER AMM 33-51-38. MAINTENANCE PERFORMED SUCCESSFUL OPERATIONS CHECK.SDR AALA201711159029Nut Plate · damagedLEFT FORWARD OVERWING EXTERIOR EMERGENCY LIGHT HAS A CRACKED LENS AND DAMAGED NUT PLATES. REMOVED AND REPLACED LENS IAW AMM 33-51-04, AND INSTALLED THE NUT PLATES IAW EA#275115. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201711159010Lens · crackedLEFT FORWARD OVERWING EXTERIOR EMERGENCY LIGHT HAS A CRACKED LENS AND DAMAGED NUT PLATES. REMOVED AND REPLACED THE LENS IAW AMM 33-51-04 AND INSTALLED NUT PLATES TO MOUNTING PLATE IAW EA 275115. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201711149028Lens · missingGALLEY MOUNTED EMERGENCY LIGHT ON THE FORWARD RIGHT SIDE, HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-50-00. OPS CHECKED GOOD.SDR AALA201711149039Power Supply · no testEMERGENCY EXIT LIGHTS RIGHT SIDE, ROW 21, AND OVERWING EXIT DOOR ARE INOPERATIVE. REMOVED AND REPLACED MID RIGHT BATTERY PACK, MID LEFT BATTERY PACK, AND MID POWER SUPPLY MODULE IAW AMM 33-60-98. OPS CHECKED GOOD.SDR AALA201711149038Battery Pack · no testEMERGENCY LIGHTS RIGHT SIDE, ROW 21, AND OVERWING EXIT DOOR ARE INOPERATIVE. REMOVED AND REPLACED MID RIGHT BATTERY PACK, MID LEFT BATTERY PACK, AND MID POWER SUPPLY MODULE IAW AMM 33-60-98. OPS CHECKED GOOD.SDR AALA201711149037Lens · missingGALLEY MOUNTED EMERGENCY LIGHT ON THE FORWARD LEFT SIDE HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-50-00. OPS CHECKED GOOD.SDR AALA201711149023Lens · detachedSIDEWALL EMERGENCY LIGHT LENS JUST AFT OF THE LEFT AFT EMERGENCY EXIT DOOR IS DETACHED. INSTALLED THE LENS IAW AMM 33-21-00. OPS CHECKED GOOD.
Back to JASC 3350