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 ASAA2017123123064Lens · unsecure17F EMERGENCY EXIT SIGN FELL OFF. GROUNDED - YES. 17F EMERGENCY EXIT SIGN REINSTALLED.SDR AALA201801029022Light · missingFIRST ROW EMERGENCY LIGHT STRIP AT THE R1 DOOR FOUND MISSING. INSTALLED THE LIGHT.SDR UIEA2017123102451Battery Pack · corrodedEXTERIOR EMERGENCY LIGHTS INOPERATIVE ON RT SIDE OF ACFT, AFT OF FLAPS. FOUND CORROSION ON THE F1 OF POWER PACK, CLEANED CORROSION, OPS CHECKED OK IAW AMM 33-51-00.SDR BUEA20180102003Light · noneDURING PREFLIGHT, THE CREW REPORTED THAT HALF OF THE CABIN INTERIOR EMERGENCY LIGHTS WERE ILLUMINATED. THE CREW UTILIZING THE APU GENERATOR AND THE EMERGENCY ARM SWITCH RECHARGED THE FOUR EMERGENCY BATTERIES. ALL EMERGENCY LIGHTS ILLUMINATED.SDR SIMA20171231001Battery Pack · inoperativeBOTH OVERWING EMERGENCY LIGHTS ARE INOPERATIVE. R & R THE NR 4 BATTERY AND CHARGER IAW 33-700-19. OPS CHECKED GOODSDR CALA2017123104716Battery Pack · faultyEMERGENCY L MSG ON EMERGENCY BATT TEST AT CIDS PANEL. REMOVED AND REPLACED EMERGENCY BATT PACK 11WL REF AMM 33-51-38 OPS CHECK GOOD.SDR CALA2017123104715Circuit Breaker · trippedC/B TRIPPED ON OVERHEAD PANEL ECAM. EMER LIGHTS CABIN RESET C/B EMERGENCY LIGHTS CHECK OK.SDR CALA2017123104714Lens · missingCOVER MISSING FROM ESCAPE LIGHTING BY FIRST CLASS CLOSET DOOR. INSTALLED NEW AISLE EMERGENCY LIGHT COVER. OK TO CONTINUE.SDR CALA2017123104713Sign · looseDOOR 2 EMERGENCY EXIT SIGN HANGING LOOSELY SECURED EXIT ROW SIGN, OPS NORMAL.SDR CALA2017123104712Lens · missingEMERGENCY ISLE LIGHTING, WHITE LIGHT PLASTIC COVER MISSING ON SEAT 21D. REPLACED MISSING COVER. LIGHTS CK OK.SDR AALA201801039003Cover · missingAIRCRAFT WAS NOT GROUNDED. DOOR 2L EXIT LIGHT MISSING COVER AND BULBS. INSTALLED EMERGENCY LIGHT COVER AT DOOR 2L AS REQUIRED. OPS CHECK GOOD AT THIS TIME.SDR SWAA2018010418815Sign · missingMID CABIN CEILING EMERGENCY EXIT SIGN PLATE MISSING. INSTALLED SIGN PER AMM.SDR SWAA2018010418814Cover · unsecureOVERWING EXIT ROW SIGN COVER CAME OFF. ATTACHED COVER PER MM.SDR AALA201801029048Light · brokenSEAT 22 LEFT, MOUNTED EMERGENCY LIGHT FOUND BROKEN. REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-51-18.SDR SWAA2018010318779Lens · missingRT UPPER EMERGENCY EXIT LIGHT LENS COVER MISSING. R&R LENS IAW AMM.SDR SWAA2018010318751Light · inoperativeFORWARD GALLEY DOOR EXTERNAL EMERGENCY LIGHT INOP. RELAMPED BULB PER AMM.SDR AALA201801039005Connector · unsecureEMERGENCY LIGHT AT SEAT 22D INOPERATIVE. MAINTENANCE SECURED SIDEWALL CONNECTOR AND PERFORMED SUCCESSFUL OPS CHECK.SDR ASOA201812305007Battery Pack · inoperativePILOT REPORTED THE EMERGENCY LIGHTS ILLUMINATED WHILE IN ARMED POSITION. MX REMOVED AND REPLACED THE NR 1 EMERGENCY LIGHT BATTERY, OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2018010200024Light · damagedEMERGENCY FLOOR LIGHTING DAMAGED. SECURED LIGHT STRIP. OPERATION CHECKS GOOD.SDR REXA2017123001302Light · missingTHE EMERGENCY LIGHT STRIP IS MISSING AT THE ENTANCE TO CABIN ON THE LEFT SIDE, IN FRONT OF GALLEY CART. REPLACED THE EMERGENCY LIGHT IAW 33-51-01. NO FURTHER DEFECTS NOTED.SDR AALA201801029025Lens · detachedEMERGENCY EXIT SIGN LENS AT THE R3 DOOR DETACHED. THE LENS WAS SECURED.SDR AALA20171230005Light · brokenBROKEN EMERGENCY LIGHT AT SEAT 3E. MAINTENANCE REPLACED THE EMERGENCY LIGHT ASSEMBLY AND PERFORMED SUCCESSFUL OPERATIONAL CHECK IAW WDM 33-51-21. AIRCRAFT WAS GROUNDEDSDR DALA2018010200008Light · inoperativeL1 DOOR EMERG LIGHT INOP. RELAMPED IAW AMM 33-50.SDR DALA2017123109013Battery Pack · dischargedEMERGENCY LIGHTS INOPERATIVE AT SEAT 29HJ-30HJ. REPLACED BATTERY PACK FROM CHARGER 16WL.SDR CALA2017123004705Light · brokenM/D 3A-LC LAV DOOR RT 1EA LWR EMER LIGHT FOUND BROKEN. REPLACED THE CABIN 3A-LC LAV AREA RT SIDE 1EA LOWER EMERGENCY LIGHT AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-05-960- 802 REV 81.SDR CALA2017123004704Battery Pack · dischargedDURING EMER LT TEST FOUND R3 DOOR EMER LT PWR PACK (M33404) LOW CAPACITY. REPLACED R3 DOOR EMER LT PWR PACK(M33404) BATTERY AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06-960-802 REV 81.SDR CALA2017123004703Battery Pack · dischargedDURING EMER LT TEST FOUND L1 DOOR EMER LT PWR PACK(M33424) LOW CAPACITY. REPLACED L1 DR EMER LT PWR PACK BATTERY AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06-960-802 REV 81.SDR CALA2017123004702Battery Pack · dischargedDURING EMER LT TEST FOUND R1 DOOR EMER LT POWER PACK (M33094) LOW CAPACITY. REPLACED R1 DOOR EMER LT POWER PACK (M33094) BATTERY AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM33-51-06-960-802 REV 81.SDR CALA2017123004700Battery Pack · dischargedDURING EMER LT TEST FOUND R2 DOOR EMER LT POWER PACK(M33098) LOW CAPACITY. REPLACED THE CABIN R2 DOOR AREA EMERGENCY LT POWER PACK M33098 AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06-960-80 2 REV 81.SDR CALA2017123004699Light · malfunctionedWHITE EMERGENCY LIGHT ABOVE ROWS 12DEF AND 24DEF IS FLASHING. PERFORMED RESET. OPS CHECK GOOD REF AMM 33-51-00.SDR CALA2017123004696Light · inoperativeLT LWR EMERG LITE ON FUSELAGE AFT OF WING BODY FAIRING FAILS TO COME ON DURING EMERG LIGHT TEST RELAMPED LIGHT. OPS CHECK GOOD.SDR CALA2017123004695Battery · dischargedDURING EMER LT TEST FOUND L2 DOOR EMER LT POWER PACK (M33099) LOW CAPACITY. REPLACED THE CABIN L2 DOOR EMERGENCY LT POWER PACK(M33099) BATTERY AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06-960-80 2 REV 81.SDR CALA2017123004693Light · damagedEMERGENCY EXIT LIGHT AT ROW 21 CENTER HAS DAMAGE. REPLACED THE POWER SUPPLY AND LIGHT . CHECKED OK.SDR CALA2017123004692Light · brokenEMERGENCY LIGHT FOUND BROKEN . REPLACED THE EMERGENC Y LIGHT AND OPS TESTED NORMAL IAW AMM 33-51- 05-960-802 REV.81.SDR CALA2017123004691Light · brokenEMERGENY LIGHT FOUND BROKEN. REPLACED THE LIGHT AND OPS TESTED NORMAL IAW AMM 33-51-05-960-802, REV 8 1.SDR CALA2017123004690Lens · crackedEXIT EXIT SIGN LENS FOUND BROKEN. REPLACED THE EXIT SIGN . OPS TESTED OUT, NORMAL IAW AMM 33-51-01-960-802, REV 81.SDR CALA2017123004689Light · brokenGALLEY HAD TWO LOWER EMERGENCY LIGHTS BROKEN. REPLACED THE LIGHTS, TESTED NORMAL AMM 33 -51-05-960-802, REV.81.SDR CALA2017123004686Lens · missingMAIN DECK A4 GALLEY CENTER L&R TWO LOWER EMERGENCY LIGHTT LENS FOUND MISSING. REPLACED THE EMERGENCY LIGHT ASSY AND OP TESTED NORMAL IAW AMM 33-5 1-05-960-802, REV.81.SDR CALA2017123004685Light · brokenEMERGENCY LIGHT LENS BROKEN. INSTALLED A NEW LIGHT OPS CHECKED OK.,SDR MASA2017123012870Light · inoperativeROW 11 OVERHEAD EMERGENCY LIGHT INOPERATIVE.SDR MASA2017123012869Lamp · inoperativeROW 17 OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR MASA2017123012867Light · inoperativeROW 18 AFT OVERHEAD EMERGENCY LIGHT INOPERATIVE.SDR MASA2017123012865Light · inoperativeLEFT OVERWING EXTERIOR EMERGENCY LIGHT INOPERATIVE.SDR 29GA2017122900002Switch · looseFA EMERGENCY ARM LIGHT INOERATIVE. SECURED EMERGENCY ARM SWITCH ON THE FLIGHT ATTENDANT PANEL, EMERGENCY LIGHTING OPS TESTED GOOD IAW AMM 33-50-00-05.SDR AALA201801029045Lens · missingEMERGENCY EXIT SIGN LENS IS MISSING AT SEAT 15DEF. REPLACED THE SIGN ASSEMBLY IAW MM 33-51-01. OPS CHECKED OK.SDR AALA201801039014Cover · brokenTHE COVER ON THE FLOOR EMERGENCY LIGHT, JUST IN FRONT OF SEATS 3E AND 3F ON INBOARD BULKHEAD, IS BROKEN AND COVER WILL NOT ATTACH. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW MM 33-51-14. OK FOR SERVICE.SDR SWAA2018010318832Power Supply · inoperativeRT OVERWING INTERIOR EMERGENCY EXIT DOOR FORWARD LOWER EMERGENCY SIGN INOP AT BS 603, RBL 67. R&R POWER SUPPLY IAW AMM.SDR SWAA2018010318831Sign · defectiveL2 EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROWS. R&R SIGN IAW AMM.SDR SWAA2018010318830Sign · defectiveRT OVERWING EMERGENCY EXIT SIGN MISSING DIRECTIONAL ARROWS. R&R SIGN IAW AMM.SDR SWAA2018010318812Lens · unsecureRT SIDE OVERWING EMERGENCY "EXIT" SIGN LENS FELL OFF. INSTALLED LENS PER SIP.
Back to JASC 3350