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 HNAA2018043000089Lens · brokenMAIN DOOR EMERGENCY LIGHT COVER BROKEN. INSTALLED A NEW COVER IAW AMM 25-23-04-000-801-A. OK FOR SERVICE.SDR DALA2018042902888Light · inoperativeSEAT 14ED EMERGENCY LIGHT WAS FOUND INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-53. OPS CHECKED GOOD.SDR SWAA201805161653Battery Pack · inoperativeM1672 EMERGENCY EXIT LIGHT BATTERY PACK INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR IPXA2018050129159Cover · missingFLIGHT CREW REPORTED EMERGENCY LIGHT COVER ON R1 DOOR FELL OFF. REINSTALLED R1 EMERGENCY LIGHT COVER W/R/T MD11-AM-M-33-27-05.SDR AALA201805019012Battery Pack · dischargedTHE AIRCRAFT WAS GROUNDED. FIRST CLASS CEILING EMERGENCY LIGHTS DO NOT COME ON. REPLACED EMERGENCY LIGHT BATTERY PACK ASSEMBLY B5-100 PER AMM 33-53-00. OPERATIONS CHECK GOOD.SDR DALA2018043002958Lens · missingEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE.REPLACED MISSING LENS COVER.SDR DALA2018043002957Lens · missingEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. REPLACED MISSING LENS COVER.SDR AALA201804309051Power Supply · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY BATTERY PACK M1695 FAILED. REPLACED EMERGENCY POWER SUPPLY PER AMM 33-51-06.SDR AALA201804309050Power Supply · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY BATTERY PACK M1694 FAILED. REPLACED EMERGENCY BATTERY POWER SUPPLY M1694 PER AMM 33-51-06.SDR AALA2018050200001Battery Pack · inoperativeRIGHT MAIN AISLE EMERGENCY LIGHT INOPERATIVE AT SEATS 32-40. REPLACED THE BATTERY PACK ABOVE THE R4 DOOR IAW 33-50-00.SDR QXEA2018050100168Power Supply · inoperativeAFT CABIN EMERGENCY LIGHTS INOPERATIVE. FOUND THE NR 3 POWER SUPPLY BATTERIES DRAINED. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-01-000-801, AND AMM 33-51-01-400-801. R & R THE BATTERY PACKS IAW AMM 33-51-00-820-801. OPS TESTED GOOD.SDR SWAA2018043021579Power Supply · inoperativeLT SIDE EXTERIOR GROUND ILLUMINATION EMERGENCY EXIT LIGHT INOP. R&R POWER SUPPLY PER AMM.SDR SWAA2018043021545Light · inoperativeL2 DOOR EMERGENCY LIGHT SEGMENT INOP. R&R LIGHT PER AMM.SDR SWAA2018043021544Light · inoperativeLT OVER WING EMERGENCY EXIT LIGHT SEGMENT INOP. R&R LIGHT PER AMM.SDR SWAA2018043021493Light · missingAFT ENTRY DOOR EMERGENCY EXIT LIGHT SEGMENT MISSING. RELAMPED LIGHT PER AMM.SDR SWAA2018043021464Lens · missingRT OUTERWING EMERGENCY LENS COVER MISSING. R&R COVER PER SIP.SDR REXA2018042700329Sign · inoperativeLIGHTED OVERHEAD EXIT SIGN IN CABIN HAS REAR BACKLIGHT INOPERATIVE. R & R THE SIGN ASSY IAW AMM 33-51-04. OPS CHECKED GOODSDR AALA2018005019049Battery Pack · failedEMERGENCY LIGHT BATTERY PACK M1672 FAILED. REPLACED THE BATTERY PACK M1672 IAW AMM 33-51-06.SDR AALA201805019028Lens · missingEMERGENCY EXIT LENS ON BULKHEAD OF L53 LAVATORY IS MISSING. INSTALLED LENS ON EMERGENCY LIGHT AT L53 LAVATORY BULKHEAD IAW AMM 33-20-00.SDR AALA2018050109038Lens · missingEMERGENCY LIGHT LENS MISSING AT ROW 34C. REPLACED THE LENS IAW CMM 25-22-50. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR SWAA2018050121578Light · damagedFORWARD CABIN EMERGENCY LIGHT STRIP DAMAGED AT BS 360. R & R THE LIGHT STRIP IAW MM.SDR SWAA2018050121567Connector · unsecureFORWARD ENTRY DOOR LOWER EMERGENCY LIGHT INOPERATIVE. SECURED THE CONNECTOR IAW AMM.SDR SWAA2018050121438Sign · looseOVERHEAD OVERWING EXIT SIGN LOOSE. SECURED THE SIGN IAW SIP.SDR AALA201804309036Lens · missingROW 26 ABC EMERGENCY LIGHT LENS MISSING. MAINTNENANCE REPLACED THE LENS IAW 25-28-72 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018043028004Fuse · failedL1 DOOR EXTERNAL EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REPLACED THE POWER SUPPLY FUSE M33424 IAW AMM 33-51-06-960-801, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR IPXA2018043029028Bulb · inoperativeEMERGENCY LIGHT HAS FOUR BULBS INOPERATIVE. REPLACED THE BULBS IAW AMM 33-51-01-2.SDR REXA2018042700321Battery Pack · inoperativeAFT OVERWING EMERGENCY LIGHTS AND INTERIOR EMERGENCY FLOODLIGHTS FOUND INOPERATIVE. REMOVED & REPLACED THE BATTERY PACKS IAW AMM 33-51-17. OPS CHECKED GOOD.SDR SIMA2018060614Light · detachedCABIN FLOOR EMERGENCY LIGHT DEBONDED FROM STRIP. INSTALLED THE EMERGENCY LIGHT IAW AMM 33-50-12.SDR SIMA201806056011Light · damagedCABIN FLOOR EMERGENCY LIGHT STRIP NR 1 WAS DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHT STRIP IAW AMM 33-50-12.SDR SIMA201806056010Light · inoperativeCABIN FLOOR EMERGENCY LIGHT STRIP NR 6 WAS DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-50-12.SDR SWAA201805161636Circuit Breaker · malfunctionedRIGHT OVERWING DOOR LOWER EMERGENCY LIGHT INOPERATIVE. RESET THE CIRCUIT BREAKER IAW AMM.SDR SWAA2018050161621Circuit Breaker · malfunctionedAFT GALLEY CEILING EMERGENCY EXIT SIGN INOPERATIVE. RESET THE CIRCUIT BREAKER IAW AMM.SDR SWAA201805161620Circuit Breaker · malfunctionedRIGHT OVERWING DOOR EMERGENCY ESCAPE SLIDE LIGHT INOPERATIVE. RESET THE CIRCUIT BREAKER IAW AMM.SDR SWAA201805161618Circuit Breaker · malfunctionedRIGHT OVERWING DOOR UPPER EMERGENCY EXIT LIGHT INOPERATIVE. RESET THE CIRCUIT BREAKER IAW AMM.SDR SWAA201805161615Light · inoperativeLEFT EMERGENCY AISLE LIGHTS INOPERATIVE BETWEEN ROWS 17 TO 23. R & R THE LIGHT IAW AMM.SDR SWAA201805161614Circuit Breaker · malfunctionedRIGHT EMERGENCY AISLE LIGHTS INOPERATIVE BETWEEN ROWS 8 TO 19. RESET THE CIRCUIT BREAKER IAW AMM.SDR SWAA201805161583Light · inoperativeLEFT OVERWING EMERGENCY LIGHT UNDER EXIT SIGN INOPERATIVE. R & R THE LIGHT ASSEMBLY PER AMM.SDR SWAA2018051521914Light · damagedAFT LOWERED CEILING EMERGENCY EXIT LIGHT INSERTS DAMAGED. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2018043021575Light · inoperativeRT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018043021467Cover · looseR1 DOOR EXIT LIGHT COVER NEAR BOTTOM OF LOOSE. R&R EXIT SIGN ASSEMBLY PER MM.SDR AALA2018050109057Lens · missingEMERGENCY LIGHT LENS MISSING AT ROW 7DEF. INSTALLED A NEW LENS IAW MM 33-51-03. GOOD FOR SERVICE.SDR AALA201805019021Battery Pack · no testEMERGENCY LIGHTS FUNCTIONAL TEST FOUND EMERGENCY LIGHTS ZONES M1694, M1695 AND M1672 DID NOT MEET REQUIRED CAPACITY CHECK. REPLACED BATTERY PACK AS REQUIRED. THIS SDR IS FOR ZONE M1672 BATTERY PACK.SDR AALA201805019020Battery Pack · no testEMERGENCY LIGHTS FUNCTIONAL TEST FOUND EMERGENCY LIGHTS ZONES M1694, M1695 AND M1672 DID NOT MEET REQUIRED CAPACITY CHECK. REPLACED BATTERY PACK AS REQUIRED. THIS SDR IS FOR ZONE M1695 BATTERY PACK.SDR AALA201805018003Battery Pack · no testDURING AN EMERGENCY LIGHTS FUNCTIONAL TEST, FOUND THE EMERGENCY LIGHTS AT ZONES M1694, M1695 AND M1672 DID NOT MEET REQUIRED CAPACITY CHECK. REPLACED THE BATTERY PACK.SDR AALA2018050109054Light · brokenAISLE RED EMERGENCY AISLE LIGHT AT SEAT 22D FOUND BROKEN. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-18. OPS CHECKED GOOD.SDR AALA2018050109013Power Supply · failedR1 DOOR EMERGENCY LIGHT POWER SUPPLY 12WL FAILED. REPLACED THE POWER SUPPLY IAW AMM 33-51-38.SDR AALA201804279020Lens · missingEMERGENCY LIGHT AT ROW 10 LEFT MISSING THE LENS. REPLACED LENS IAW AMM 33-51-19.SDR AALA201804300003Battery Pack · inoperativeAFT CABIN R4 EXIT SIGN WILL NOT ILLUMINATE DURING TEST. REPLACED THE BATTERY PACK IAW AMM 33-51-06-201.SDR DALA2018042802887Light · brokenSEAT 11C MOUNTED EMERGENCY LIGHT WAS FOUND BROKEN, REPLACED EMERGENCY LIGHT ASSY.SDR REXA2018042760320Lamp · burned outEMERGENCY EXIT SIGN, FLOOR LEVEL HAS LAMP BURNED OUT. REMOVED AND REPLACED THE LAMPS IAW 33-51-05. OPS CHECKED GOOD.
Back to JASC 3350