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 CALA2017030600553Battery Pack · dischargedFOUND ON WALK AROUND 2 SVC R2 DOOR EMERGENCY LIGHT INOP. REPLACED BATTERY PACK OPS CKS NORMAL.SDR CALA2017030600552Power Supply · faultyEMERGENCY LIGHTS REMAIN ON WITH SWITCH ARMED AND A/C POWER ESTABLISH FOUND CB "EMER CHGR L" (N35 ON P11) POPS WHEN SWITCH PLACED IN ARMED. TROUBLESHOT TO FORWARD POWER SUPPLY PER AMM 20-60-01. REPLACED POWER SUPPLY PER AMM 33-51-07. WDM 33-51-11.SDR CALA2017030600551Battery Pack · dischargedUPPER DECK LT EMERGENCY LIGHT BATTERY NOT TESTING REPLACED LT BATTERY PACK REF 52-23-14-401. OPS CK GOOD PERFORMED IDT INSPECTION PER GMM AND AMM 52-23-14-401.SDR HNAA2017030600075Bulb · inoperativeEMERGENCY LIGHT BULBS AT AISLE ARE INOPERATIVE. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR HNAA2017030600074Bulb · inoperativeTHIRD AFT EMERGENCY AISLE LIGHT FOUND TO BE INOPERATIVE. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR HNAA2017030600073Bulb · dimLOWER EMERGENCY PAX DOOR LIGHT IS DIM. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR AALA201703089017Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT 11WL FAILED TEST. REMOVED AND REPLACED EPSU BATTERY AT THE LEFT EMERGENCY EXIT IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR SCNA20170305055Light · inoperativeTHE LT FWD OVERWING EXTERIOR EMER LIGHT IS INOP. RELAMPED LT FWD OVERWING EXTERIOR EMERGENCY LIGHT.SDR IPXA2017030514721Wire · pulledEMERGENCY LIGHT BATTERY 1 LOW. FOUND WIRES PULLED FROM CONNECTOR P1-1756B, PINS 5, AND 6. PINNED THE CONNECTOR IAW AMM 20-30-05. EMERGENCY LIGHTS TEST CHECKED GOOD IAW AM 33-51-01.SDR SWAA2017030812397Light · brokenR1 DOOR LOWER EXIT SIGN COVER BROKEN. R & R THE LIGHT ASSEMBLY IAW MM.SDR AALA201703079019Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT RIGHT SIDE ROW 4 HAS A DETACHED LENS COVER. REINSTALLED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201703079003Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 15F HAS A MISSING LENS COVER. REPLACED EXIT LIGHT IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201703079002Lens · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE R2 DOOR HAS A LOOSE LENS COVER. SECURED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2017030712383Lamp · inoperativeLEFT EMERGENCY LIGHT INOPERATIVE AT ROW 1. REPLACED THE LAMPS IAW AMM.SDR SWAA1974030112367Lens · missingLEFT OVERWING EXIT SIDEWALL SIGN LENS MISSING. REPLACED THE LENS IAW AMM.SDR SWAA2017030712365Lens · missingEMERGENCY LIGHT LENS MISSING AT ROW 10. INSTALLED THE LENS IAW MM.SDR QXEA2017030600106Light · inoperativeAFT PASSENGER DOOR EMERGENCY EGRESS LIGHT IS INOP DURING OPERATIONAL TEST. REPLACED.SDR AALA20170306021Lens · detachedCABIN PRESSURE LIGHT AT R4 DOOR HAS A DETACHED LENS COVER. INSTALLED THE LENS. OPERATIONAL CHECKED GOOD.SDR AALA20170306020Lens · missingSEAT 36C MOUNTED EMERGENCY LIGHT HAS A MISSING LENS COVER. INSTALLED A LENS COVER. OPERATIONAL CHECKED GOOD.SDR AALA20170306005Power Supply · no testRIGHT FORWARD OVERWING EMERGENCY EXIT MARKER FAILED TEST. REMOVED AND REPLACED BATTERY PACK AND POWER SUPPLY IAW AMM 33-60-98. OPERATIONAL CHECKED GOOD.SDR AALA20170305006Battery Pack · no testRIGHT FORWARD OVERWING EMERGENCY EXIT MARKER FAILED TEST. REMOVED AND REPLACED THE BATTERY PACK AND POWER SUPPLY IAW AMM 33-60-98. OPERATIONAL CHECKED GOOD.SDR AALA20170305005Battery · no testEMERGENCY EXIT LIGHTS IN THE TAIL COMPARTMENT FAILED TEST. REMOVED AND REPLACED THE BATTERY ASSEMBLY IAW AMM 33-53-00. OPERATIONAL CHECKED GOOD.SDR AALA20170305004Battery · no testEMERGENCY LIGHTS IN THE TAIL COMPARTMENT FAILED TEST. REMOVED AND REPLACED THE BATTERY ASSEMBLY IAW AMM 33-53-00. OPERATIONAL CHECKED GOOD.SDR AALA20170305003Battery · failedOVERHEAD EMERGENCY EXIT LIGHTS BY THE AFT FLIGHT ATTENDANT STATION CAME ON WHEN EXTERNAL POWER WAS DISCONNECTED. REMOVED AND REPLACED THE BATTERY ASSEMBLY B5-10-1 IAW AMM 33-53-00. OPERATIONAL CHECKED GOOD.SDR SIMA20170305001Light · inoperativeRIGHT FWD WING TO FUSELAGE FAIRING EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-10-000-801, AND 33-50-10-400-801. OPS CHECKED GOOD.SDR MASA2017030512647Bulb · inoperativeFLOOR EXIT SIGNS ROW 18A HAD TWO BULBS INOPERATIVE.SDR DALA2017030501779Light · inoperativeEMERGENCY LIGHT AT SEAT 30C INOPERATIVE. REPLACED THE LIGHT ASSY IAW AMM 33-53. OPS NORMAL.SDR N6WA2017030502Lamp · inoperativeEMERGENCY LIGHT AT ROW 16 INOPERATIVE. REPLACED THE LAMP EMERGENCY CEILING FLOOD LIGHT IAW AMM 33-54-09. OPS CHECKED GOOD.SDR CALA2017030500545Battery Pack · dischargedEMERGENCY EXIT LIGHTS ROWS 36 TO 39 LEFT SIDE INOP. JOB ACTION PERFORMED IAW AMM 33-51-11,REMOVED AND REPLACED BATTERY PACK OPS CHECK GOOD AT THIS TIME.SDR CALA2017030500544Charger · faultyEMERGENCY EXIT LIGHTS ROWS 15 TO 24 LEFT SIDE INOP. REMOVED AND REPLACED BATTERY CHARGER AS AMM 33-51-00. OPS CHECK GOOD.SDR CALA2017030500543Light · inoperativeEXTERIOR EMERGENCY LIGHT AT RIGHT LOWER FUSELAGE AFT OF WING IS INOP. RELAMPED RT LOWER BODY EMERGENCY LIGHT, OPS GOOD.SDR CALA2017030500542Lens · brokenROW 28ABC EMERGENCY EXIT PATH LIGHT LENS BROKEN. REPLACED LENS COVERSDR CALA2017030500540Light · inoperativeSHORT BEFORE DEPARTURE FOUND EMERGENCY EXIT LIGHT AT SEAT 19C INOP. REPLACED SEAT EEL LIGHT, OPS CHECK GOOD.SDR MASA2017030512646Light · inoperativeROW 1 CEILING LEVEL EMERGENCY FLOODLIGHT INOP. PLACED ON MELSDR MASA2017030512645Battery · dischargedGALLEY RT EXIT SIGN WILL NOT ILLUMINATE. REPLACED EMER LIGHT BATTERY.SDR MASA2017030512644Battery · dischargedGALLEY LT EXIT SIGN WILL NOT ILLUMINATE. REPLACED EMER LIGHT BATTERY.SDR AALA201703099026Light · unsecureAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH FLOOR LIGHTING AT SEAT 6D IS INOPERATIVE. SECURED LIGHT IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201703079013Switch · faultyAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER TEST FAILS AC EMERGENCY LIGHT ON. REMOVED AND REPLACED EMERGENCY POWER SWITCH IAW AMM 24-23-02. OPERATIONAL CHECK GOOD.SDR AALA201703079012Portable Light · inoperativeAIRCRAFT WAS NOT GROUNDED. L-1 CABIN EMERGENCY PORTABLE LIGHT IS INOPERATIVE. REMOVED AND REPLACED LIGHT IAW AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR SWAA2017030812403Battery Pack · dischargedEMERGENCY EXIT LIGHT INOPERATIVE AT ROW 21. CHARGED THE BATTERY PACK IAW AMM.SDR SWAA2017030812402Battery Pack · inoperativeR/H EMERGENCY EXIT LIGHT INOPERATIVE AT ROW 23. CHARGED THE BATTERY PACK IAW AMM.SDR SWAA2017030812401Battery Pack · dischargedR2 DOOR OVERHEAD INTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. CHARGED THE BATTERY PACK IAW AMM.SDR SWAA2017030812400Battery Pack · dischargedL2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. CHARGED THE BATTERY PACK IAW AMM.SDR SWAA2017030812399Battery Pack · dischargedR2 DOOR EMERGENCY LIGHT INOPERATIVE. CHARGED THE BATTERY PACK IAW AMM.SDR AALA201703079020Battery · failedAIRCRAFT WAS GROUNDED. EMERGENCY POWER SUPPLY UNITS AT 10WL AND 14WL FAILED TEST. REMOVED AND REPLACED EPSU BATTERY AT 10WL AND EPSU BATTERY AT 14WL IAW AMM 33-51-00. OPERATIONAL CHECK GOOD. SEE ALSO AALA201703079007SDR AALA201703079017Sign · looseAIRCRAFT WAS NOT GROUNDED. OVERHEAD EMERGENCY EXIT SIGN NEAR THE AFT GALLEY IS LOOSE. SECURED EXIT SIGN IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201703079016Cap · missingAIRCRAFT WAS NOT GROUNDED. THE NOT ARMED LIGHT NEAR THE EMERGENCY EXIT LIGHT SWITCH IS MISSING. INSTALLED NOT ARMED CAP ASSEMBLY IAW AMM 33-10-00. OPERATIONAL CHECK GOOD.SDR AALA201703079009Roll Pin · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN IN THE FORWARD TOURIST CLASS HAS MISSING PINS. INSTALLED PINS IAW CMM 25-29-63. OPERATIONAL CHECK GOOD.SDR AALA201703079007Battery · dischargedAIRCRAFT WAS GROUNDED. EMERGENCY POWER SUPPLY UNITS AT 10WL AND 14WL FAILED TEST. REMOVED AND REPLACED EPSU BATTERY AT 10WL AND EPSU BATTERY AT 14WL IAW AMM 33-51-00. OPERATIONAL CHECK GOOD. SEE ALSO AALA201703079020SDR SWAA2017030712379Guard · brokenEMERGENCY EXIT LIGHT SWITCH GUARD BROKEN. R & R THE GUARD IAW SOPM.
Back to JASC 3350