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 AALA20170118012Light · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT ON G2 GALLEY IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-14. OPERATIONAL CHECK GOOD.SDR AALA20170116017Power Supply · inoperativeAIRCRAFT WAS GROUNDED. CAPTAINS COCKPIT INTERIOR EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33424 IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA20170116005Power Supply · inoperativeAIRCRAFT NOT GROUNDED. L1 DOOR EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33430 IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170116002Light · inoperativeAIRCRAFT NOT GROUNDED. EXTERIOR EMERGENCY EXIT LIGHT AT L4 POSITION IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR REXA2017011600051Battery · dischargedEMERGENCY SWITCH LEFT ON FA PANEL EMERGENCY LIGHTS WILL NOT COME ON. CHARGED A/C BATTERIES FOR MINIMUM 6 HOURS IAW CMM 33-21-70. OPS CHECK NORMAL A/C OK FOR SVC.SDR AALA20170118022Sign · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT R3 DOOR IS DETACHED. ADJUSTED EXIT SIGN INBOARD BOLT. OPERATIONAL CHECK GOOD.SDR YENA201701160036Epsu · failedFLT 822, PBI-BOS. FORWARD EMERGENCY LIGHTS WERE INOPERATIVE. R & R EPSU AND BATTERY AT FWD PASSENGER DOOR PER AMM 33-51-38. PERFORMED OPS CHECK. OPS CHECK PASSED.SDR YENA201701160035Battery · dischargedFLT 822, PBI-BOS. FORWARD EMERGENCY LIGHTS WERE INOPERATIVE. R & R EPSU AND BATTERY AT FWD PASSENGER DOOR PER AMM 33-51-38. PERFORMED OPS CHECK. OPS CHECK PASSED.SDR DALA2017011800469Light · unknownEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. RELAMPED EMER FLOOR LIGHTING PER AMM 33-51.SDR AALA201701179009Lens · crackedAIRCRAFT IN BASE MAINTENANCE. FORWARD LEFT WINDSCREEN EMERGENCY LIGHT LENS IS CRACKED. REPLACED WINDSCREEN EMERGENCY LIGHT HOUSING PER AMM 33-51-18.SDR DALA2017011800466Sign · brokenDURING INSPECTION FOUND RIGHT EXIT DOOR EMERGENCY EXIT SIGN BROKEN. MAINTENANCE R AND R RT EXIT SIGN. CKS GOOD PER AMM 33-51.SDR SWAA2017011811256Sign · brokenR2 DOOR EMERGENCY EXIT SIGN BROKEN. R & R THE SIGN IAW MM.SDR ASAA2017011619413Lens · missingLIGHT COVER IS MISSING. ACFT GROUNDED. REPLACED AFT LEFT LAV FLOOR PROXIMITY LIGHT LENS, IAW AMM 33-51-14. OK FOR SERVICE.SDR DALA2017011800441Lamp · inoperativeEMERGENCY OVERHEAD LIGHT IN AISLE FIRST ROW OF SEATS INOPERATIVE. REPLACED THE LAMPS AND SECURED.SDR DALA2017011800440Battery Pack · inoperativeEMERGENCY LIGHT ABOVE THE AFT CABIN DOOR IS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW MM.SDR DALA2017011800439Light · unsecureEMERGENCY LIGHT UNSECURE AT ROW 26A. SECURED THE LIGHT.SDR DALA2017011700438Power Supply · faultedFWD EPSU (10WL) FAULTING, R & R EPSU WITH BATTERYSDR DALA2017011700423Battery · dischargedEPSU INT LOAD AFT L ON SERVICE CK, R AND R EPSU WITH BATTERY 13WL.SDR SWAA2017011711225Lens · missingRIGHT OVERWING EMERGENCY EXIT LOWER LENS MISSING. INSTALLED THE LENS IAW AMM.SDR SWAA2017011711205Sign · missingLEFT OVERWING LOWER EMERGENCY EXIT SIGN EXIT MISSING. INSTALLED THE SIGN IAW SIP.SDR SWAA2017011711203Sign · looseCENTER AISLE EXIT SIGN LOOSE. SECURED SIGN IAW MM.SDR DALA2017011700008Light · inoperativeOVERHEAD EMERGENCY LIGHT INOPERATIVE AT ROW 42 RIGHT. REPLACED DOME LED LIGHT.SDR CALA2017011600127Battery · dischargedDURING EMERG LIGHT TEST FAULTED LT & RT AFT EPSU. REPLACED LT & RT AFT EPSU BATTERY PACKS, TEST OK.SDR CALA2017011600126Battery · not seatedWHILE TESTING EMERGENGY LIGHT SYSTEM, LEFT FWD EPSU BATTERY FAULTED AND WILL NOT TEST. HAD FWD LEFT EPSU FAULT, RESEATED EPSU BATTERY, TEST OK.SDR CALA2017011600125Battery · dischargedEMERGENCY LIGHT TEST FAILED FOR EPSU BATTERY AFT L. REPLACED BATTERY FOR AFT L. OPS CK GOOD. REF AMM 33-51-38/401SDR CALA2017011600123Light · inoperativeLEFT AFT OVER WING EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM 33-51-04. OPS CHECK GOOD.SDR CALA2017011600121Sign · inoperativeEMERGENCY EXIT SIGN DOES NOT TURN ON. 3B EXIT LIGHT FELL OFF. OPS CHECK ON EMERGENCY EXIT SIGN NORMAL. OK TO CONTINUE.SDR CALA2017011600119Light · inoperativeR2/L1 EXTERIOR EMERGENCY LIGHTS INOP. RELAMPED L1 DOOR EMERGENCY EXT LIGHT. REPLACED FUSE IN R2 DOOR EMERGENCY LIGHT PWR SUPPLY SYSTEM. OPS CHECKED NORMAL REF AMM 33-51-06.SDR CALA2017011600118Light · inoperativeEMERGENCY CEILING LIGHT INOP 36F AND 43D. RELAMPED EMERGENCY CEILING LIGHT AT POS 36F(RT) AND 43D(LT). SYS OPS CHECKED NORMAL REF AMM 33-51-04.SDR CALA2017011600117Unknown · malfunctionedEMERGENCY EXIT WINDOW LIGHTS ON BOTH SIDES WHERE ON FOR ABOUT 45 AFTER T/O INTERMITTENT NORMAL OPS AFTER POWER SHUTDOWN.SDR HNAA2017011600018Bulb · inoperativeEMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR JJBA20170116012Bulb · inoperativeEMERGENCY LIGHT ABOVE FLT ATT JUMP SEAT INOPERATIVE. RESEATED BULB OPS CHECKED GOOD.SDR ASOA201701163002Battery Pack · dischargedDURING ROUTINE MAINTENANCE THE EXTERNAL EMERGENCY LIGHTS WOULD NOT ILLUMINATE. MAINTENANCE REPLACED THE NR 4 EMERGENCY BATTERY CHARGER AND BATTERY PACK. OPERATIONAL CHECKED GOOD.SDR AALA20170118032Lens · crackedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT IDENTIFIER AT L2 DOOR HAS A CRACKED LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR VNAA2017011500017Switch · malfunctionedEMERGENCY LIGHT TURNED ON AND OFF MULTIPLE TIMES IN FLIGHT. REMOVED AND REPLACED COCKPIT EMERGENCY LIGHT SWITCH.SDR AALA20170118025Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT L2 DOOR HAS A MISSING LENS COVER. REPLACED LENS COVER IAW AMM 33-20-00. OPERATIONAL CHECK GOOD.SDR AALA20170115009Light · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT L1 DOOR IS BROKEN. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201701169004Cover · missingAIRCRAFT WAS NOT GROUNDED. MISSING EMERGENCY LIGHT COVER AT 1R DOOR. MAINTENANCE REPLACED LIGHT COVER AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201701169002Lens · missingAIRCRAFT WAS NOT GROUNDED. AFT RIGHT HAND EMERGENCY EXIT LENS MISSING AT L4 DOOR. MAINTENANCE REPLACED EXIT LIGHT LENS PER AMM 33-51-13.SDR AALA201701169001Lens · detachedAIRCRAFT WAS NOT GROUNDED. DOOR 4R EXIT LIGHT LENS FELL OFF. MAINTENANCE REPLACED EXIT LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR 2017F00032Light · inoperativeRIGHT AFT OVERWING EMERGENCY LIGHT INOPERATIVE.SDR DALA2017011700422Light · inoperativeFOURTEEN EXIT LOCATION SIGN LIGHT BULBS ARE INOP, REPLACED BULBS.SDR DALA2017011700421Light · inoperativeTWELVE EXIT MARKING SIGN LIGHT BULBS ARE INOP, REPLACED BULBS.SDR DALA2017011600419Pin · out of positionEPSU COMM EMER L SHOWN AFTER TEST OF EMER LIGHTS. INSPECTED TB 7225VT AND FOUND PIN PULLED OUT OF 6G POSITION, RESECURED SAME.SDR ASAA2017011519395Lens · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN AT L-1 DOOR HAS BROKEN LENS. GROUNDED - YES. REMOVED AND REPLACED LENS AND TESTED LIGHT ASSY PER AMM 33-51-01-960-801 - OPS NORMAL.SDR ASAA2017011519394Light · inoperativeEMERGENCY LIGHT OVERWING EXIT HANDLE FLOODLIGHT AT LEFT AFT OVERWING EXIT HAS BOTH LAMPS INOP. GROUNDED - YES. RELAMPED AND TESTED PER AMM 33-51-01-960-801 - OPS NORMAL.SDR ASAA2017011519393Light · inoperativeEMERGENCY LIGHT OVERWING EXIT HANDLE FLOODLIGHT AT LEFT FORWARD OVERWING EXIT HAS FORWARD LAMP INOP. GROUNDED - YES. RELAMPED AND TESTED PER AMM 33-51-01-960-801 - OPS NORMAL.SDR ASAA2017011519392Light · missingEXIT LIGHTING TRACK AT ROW 12DEF SIDE MISSING. GROUNDED - YES. INSTALLED NEW TRACK LT AT ROW 12DEF. OK FOR SERVICE.SDR DALA2017011700412Fuse · blownDURING SVC FOUND EMERGENCY LIGHTS IN SEATS 10-12 AB INOP. REPLACED BLOWN FUSE ON EMERGENCY POWER SUPPLY M33098 IAW AMM 33-51.SDR SWAA2017011711227Cover · detachedR2 DOOR EMERGENCY EXIT LIGHT LENS COVER FELL OFF. R & R THE COVER IAW SIP.
Back to JASC 3350