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 AALA20170103015Battery Pack · dischargedAIRCRAFT NOT GROUNDED. EMERGENCY ESCAPE PATH MARKING POWER SUPPLY AB5-3 FAILED TEST. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-60-98. OPERATIONAL CHECK GOOD.SDR AALA20170103014Light · looseAIRCRAFT NOT GROUNDED. EXTERIOR EMERGENCY LIGHT AT R1 DOOR IS INOPERATIVE. RESECURED BULB IN LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170103011Sign · looseAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN NEAR L3 DOOR IS LOOSE. SECURED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SIMA20161230001Lamp · inoperativeMAIN DOOR EXTERNAL 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 AALA20161231004Battery Pack · dischargedAIRCRAFT NOT GROUNDED. SEAT MOUNTED EMERGENCY LIGHTS AT ROWS 9 THRU 15 ARE VERY DIM. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA20161230026Sign · inoperativeAIRCRAFT WAS GROUNDED. AFT GALLEY EXIT SIGN INOPERATIVE DUE TO QUICK DISCONNECT LOOSE IN BETWEEN GALLEY AND SIDE WALL. REMOVED AND REPLACED EXIT SIGN ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161229019Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. MIDDLE CABIN DOOR 3L EMERGENCY LIGHT POWER PACK M33406 FOUND INOPERABLE. REPLACED POWER PACK M33406 PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20161229017Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. FORWARD CABIN DOOR 2R EMERGENCY LIGHT POWER PACK M33097 FOUND INOPERABLE. REPLACED POWER PACK M33097 PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR MASA2016123012784Bulb · inoperativeFWD FLOOR EMERGENCY EXIT SIGN HAD 2 BULBS INOPERATIVE.SDR CALA2016123001201Battery Pack · no testEMERGENCY LIGHT BATTERY AT 3L FAILED CAPACITY CHECK. REPLACED BATTERY IAW MM 33-51-38-400-002-ASDR CALA2016123001200Battery Pack · no testBATTERY PACK AT EMERGENCY EXIT RIGHT FAILED CAPACITY TEST. REPLACED THE BATTERY PACK IAW MM 33-51-38-400-002-ASDR CALA2016123001198Power Supply · inoperativeEMERGENCY LIGHTS TEST FAILED AT PTP PANEL CABIN EMERGENCY POWER SUPPLY AND BATTERY POS 13WL WERE REPLACED IAW AMM 33-51-38 PG BLOCK 401 OP TEST IAW 33-51-38-740-050SDR CALA2016123001196Charger · inoperativeEMERGENCY LIGHTS 23 AFT INOPERATIVE. REPLACED THE BATTERY CHARGER. OPS CHECKED NORMAL.SDR CALA2016123001194Charger · inoperativeFOUND EMERGENCY LITES INOPERATIVE ROW 21,22,22. REPLACED THE CHARGER AND BATTERY AND OPS NORMAL.SDR CALA2016123001195Battery Pack · inoperativeRT OVERWING ESCAPE HATCH AND R2 DOOR EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK,SDR QXEA2016123000813Light · wornEMERGENCY LIGHT AT ROW 2 IS WORN. REPLACED THE LIGHT . RETURNED TO SERVICE.SDR 2D7A201612300001Battery Pack · dischargedDURING MAINTENANCE CHECK, THE EXIT SIGNS WOULD NOT ILLUMINATE. FOUND THE BATTERY PACK DISCHARGED.SDR IPXA2016123012249Lamp · inoperativeCREW DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMP. OPS CHECKED GOOD IAW AMM 33-51-00-0501.SDR DALA2016123010148Battery Pack · dislodgedEMERGENCY LIGHTS AT ROWS 10-14 INOPERATIVE. FOUND BATTERIES DISLOGED FROM POWER PACK. REINSTALLED PER AMM 33-53. CHECKED OK.SDR YENA201612301119Power Supply · no testCABIN EMERGENCY LIGHTS TEST FAILED IN POSITIONS 42WL, 53WL. R & R THE EPSU (12WL) IAW AMM 33-51-38. PERFORMED OPS CHECK. OPS CHECK PASSED. ACFT OK FOR SERVICE.SDR AALA20170101002Ground Wire · shortedAIRCRAFT IN BASE MAINTENANCE. G4 AND G5 GALLEY EMERGENCY EXIT FLOOR PROXIMITY LIGHTS AND CEILING LIGHTS FAILED TEST DUE TO INTERNAL GROUND TO WIRE SHORTAGE. REPAIRED WIRE IAW WDM 33-51-52, ESO 21404, AND AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR DALA2017010300114Housing · looseEMERG LIGHT AT 25D HOUSING LOOSE, REPAIRED EMERGENCY LIGHT HOUSING.SDR DALA2016123010188Battery Pack · inoperativeEMERGENCY LIGHTS OUT AT ROWS 34 AND 35. REMOVED AND REPLACED BATTERY PACK IAW AMM. OPS CHECK GOOD. (LP# 9039441)SDR ASAA2016122919229Battery Pack · failedEMERGENCY EXIT LIGHT BATTERY PACK M1671 FAILED TASK CARD 78233001. GROUNDED - YES. REMOVED AND REPLACED M1671 POWER SUPPLY BATTERY PACK PER AMM TASK 33-51-06.SDR ASAA2016122919228Battery Pack · failedEMERGENCY EXIT LIGHT BATTERY PACK M1670 FAILED TASK CARD 78233001. GROUNDED - YES. REPLACED PACK BATTERIES FOR M1670. OPS CHECK NORMAL, REF B737-900 AMM 33-51-06-960-805.SDR ASAA2016122919211Cover · missingMID CABIN EMERGENCY EXIT SIGN MOUNTED TO CEILING IS MISSING A TRIM COVER ON AFT SIDE. ACFT GROUNDED. INSTALLED TRIM COVER ON CEILING EMERGENCY EXIT SIGN AS REQUIRED.SDR AALA20170103023Light · inoperativeAIRCRAFT NOT GROUNDED. SEAT MOUNTED EMERGENCY EXIT LIGHTS AT ROWS 32H THROUGH 41H ARE INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY AT SEAT 41H IAW AMM 33-51-10. OPERATIONAL CHECK GOOD.SDR AALA20170103007Light · damagedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT FIRST CLASS CLOSET IS DAMAGED. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201612309008Lens · missingEMERGENCY EXIT LIGHT LENS MISSING AT DOOR 4 LEFT. REPLACED MISSING LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201612309004Light · dislodgedDISLODGED EMERGENCY LIGHT UNIT AT SEAT 13C. REPLACED THE EMERGENCY LIGHT HOUSING IAW CMM 25-22-52.SDR AALA20161230020Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT ROW 12ABC IS MISSING LENS COVER. REPLACED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20161230019Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT ROW 10DEF IS MISSING LENS COVER. REPLACED LENS COVER. OPERATIONAL CHECK GOOD.SDR MASA2016122912783Bulb · inoperativeFWD FA SEAT EMERGENCY EXIT SIGN HAD ONE BULB INOPERATIVE.SDR QXEA2016123000812Power Supply · no testBATTERY PACK FOR THE FORWARD LT EMERGENCY LIGHT FAILS AN OPS CHECK. REPLACED THE POWER SUPPLY IAW AMM 33-51-01-00-801 AND 33-51-01-400-801. CHECKED GOOD.SDR AALA20161230021Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN BY L2 DOOR IS MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20161230018Sign · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN MISSING BY SEAT 15A LOWER PANEL. REPLACED EXIT SIGN IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20161230017Sign · detachedAIRCRAFT WAS GROUNDED. EMERGENCY EXIT SIGN BY R3 DOOR ROW 24 IS DETACHED. SECURED EXIT SIGN IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA20161230016Battery Pack · dischargedAIRCRAFT NOT GROUNDED. EMERGENCY FLASHLIGHT AFT RIGHT IS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IAW AMM 25-64-01. OPERATIONAL CHECK GOOD.SDR AALA20161229021Light · brokenAIRCRAFT NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT COVER PANEL WITH CHORD RIPPED OFF OF 5J ARM REST. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-10. OPERATIONAL CHECK GOOD.SDR REXA201612290252Light · inoperativeFLOOR EMERGENCY LIGHTS INOPERATIVE. OPS CHECKED GOOD IAW AMM 33-50-00. OK FOR SERVICE.SDR DALA2016123010163Battery Pack · inoperativeDURING SERVICE CHECK, FOUND UPPER DECK EXIT SIGN INOPERATIVE. FOUND BATTERY WEAK AT POWER SUPPLY M7050. REMOVED AND INSTALLED A NEW BATTERY IAW AMM 33-51.SDR DALA2016123010146Battery Pack · abnormalLT & RT AUX EXIT LIGHTS INOPERATIVE. REPLACED BATTERIES ON EMERGENCY POWER PACK B5-103.SDR SWAA2016123010894Sign · brokenR1 DOOR EXIT SIGN BROKEN. R & R THE SIGN IAW MM.SDR SWAA2016123010885Battery Pack · no testEMERGENCY LIGHT BATTERY M1674 FAILED TEST. R & R BATTERY PACK IAW MM.SDR SWAA2016123010882Lens · missingEXIT LIGHT LENS MISSING AT ROW 6 ABC. INSTALLED A NEW LENS IAW MM.SDR MASA2016122912782Bulb · inoperativeEMERGENCY EXIT SIGN HAD ONE BULB INOPERATIVE.SDR SWAA2016122910874Light · looseR1 DOOR EMERGENCY EXIT LIGHT ASSY LOOSE. SECURED LIGHT ASSY IAW MM.SDR SWAA2016122910873Light · looseEMERGENCY EXIT LIGHT LOOSE AT CENTER AISLE AREA. R & R THE LIGHT ASSY IAW MM.SDR REXA2016122902502Light · inoperativeEMERGENCY LIGHT AT BS 409.00+120.50 IS INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-51-21.SDR AALA20161228032Powerpack · inoperativeAIRCRAFT IN BASE MAINTENANCE. FORWARD CABIN R4 DOOR EMERGENCY LIGHT POWER PACK M33408 FOUND INOPERABLE. REPLACED POWER PACK M33408 PER AMM 33-51-06 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.
Back to JASC 3350