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 AALA202006309008Sign · unsecureAIRCRAFT WAS NOT GROUNDED: AIRCRAFT MID OVER WING EXIT SIGN IS HANGING BY ITS CORD OVER WALKWAY. SECURED OVERWING EXIT SIGN AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-01.SDR AALA202006309006Cover · abnormalAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT COVER AT ROW 16 LEFT SIDE, FELL OFF. REPLACED LIGHT BASE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR QXEA2020062900198Battery · inoperativeRED EXIT SIGN AT THE FORWARD SERVICE DOOR IS INOP. REPLACED BATTERY.SDR SWAA2020070796137Lamp · inoperativeAFT EMERGENCY LIGHT AT LEFT OVERWING EXIT WINDOW IS INOPERATIVE. REPLACED THE LAMPS AND PERFORMED A GOOD FUNCTIONAL TEST IAW AMM 33-51-01-960-801.SDR SWAA2020070796851Power Supply · inoperativeALL EMERGENCY LIGHTS POWERED BY M1675 DID NOT ULLUMINATE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY (M1675) IAW AMM 33-51-06-960-805, REPLACED THE LAMP AT THE ESCAPE SLIDE LIGHT. PERFORMED A GOOD TEST.SDR REXA2020070200579Light · inoperativeEXTERIOR EMERGENCY LIGHT AFT OF LEFT WING IS INOP. REPLACED BULB IN EXTERIOR EMERGENCY LIGHT AFT OF LEFT WING IAW AMM 33-51-15. OPS CHECK GOOD.SDR DALA2020070202529Battery Pack · dischargedEMERGENCY LIGHTS INOP AT L4 DOOR AND ROWS 46-49. R/R BATTERY PACK AT M737 PER AMM 33-51. OPS CHK GOOD.SDR SWAA2020070195818Light · inoperativeAFT RT EMERGENCY LIGHT INOP. REMOVE AND REPLACE AFT RT EMERGENCY LIGHT PER AMM 33-51-04.SDR SWAA2020070195916Battery Pack · dischargedEMERGENCY EXIT LIGHTS IN OP FWD ENTRY DOOR. R&R EMERGENCY BATTERY PACK AND POWER SUPPLY 33-51-06.SDR SWAA2020070195915Battery Pack · dischargedFWD LEFT OVERHEAD BIN EMERGENCY LIGHTS INOP. R&R'D BATTERY PACK 33-51-06.SDR SWAA2020070196052Light · inoperativeAFT EMERGENCY LIGHT AT LEFT OVERWING EXIT WINDOW IS INOPERATIVE.SDR SWAA2020070196053Light · inoperativeALL EMERGENCY LIGHTS POWERED BY M1675 DO NOT ULLUMINATE.SDR DALA2020070102527Battery · dischargedCABIN LIGHTING EPSU R FAILS TEST. EPSU R INDICATES BAT FAULT. R/R EPSU R BATTERY PER CH 33-51. OPS CHECK GOOD, SYSTEM SERVICEABLE.SDR DALA2020062902523Lens · unsecureDURING INSPECTION FOUND EXIT SIGN CAME OFF ON DOOR 2R. REINSTALLED LENS COVER. CKS GOOD.SDR R61A2020063000540Battery · dischargedAFT GALLEY LT EMERGENCY LIGHTS FAILED FUNCTIONAL CHECK. R/R NR 3 EMERGENCY LIGHT BATTERY PER AMM 33-50-01, OPS CHECK GOOD.SDR SIMA2020063028004Light · missingCABIN AISLE RH PHOTOLUMINESCENT STRIP ELEMENT MISSING AT SEAT 19D. REMOVED AND REPLACED CABIN RH 19D PHOTOLUMINESCENT STRIP IAW EMB 175 AMM 33-50-21. OCK GOOD.SDR UIEA2020063021323Light · inoperativeL2 DOOR AFT SILL EMERGENCY LIGHT NOT ILLUMINATED. REPLACED THE LIGHT AND TESTED NORMAL IAW AMM 33-51-05, REV 98.SDR UIEA2020063041392Battery Pack · no testL5 DOOR EMERGENCY LIGHT BATTERY PACK (M7923) CAPACITY TEST FAILED. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-04.SDR UIEA2020063041393Battery Pack · no testR2 DOOR EMERGENCY LIGHT BATTERY PACK (M7918) CAPACITY TEST FAILED. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-04.SDR UIEA2020063041394Battery Pack · no testEMERGENCY LIGHT BATTERY PACK (M7050) CAPACITY TEST FAILED. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-04.SDR UIEA2020063021395Battery Pack · no testRIGHT EMERGENCY LIGHT BATTERY PACK (M6378) CAPACITY TEST FAILED. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-04.SDR UIEA2020063041396Battery Pack · no testL3 DOOR EMERGENCY LIGHT BATTERY PACK (M7919) CAPACITY TEST FAILED. THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-04.SDR UIEA2020063061410Lamp · inoperativeRIGHT OVERWING NR 1 AND 2 EMERGENCY LIGHTS FOUND NOT ILLUMINATING. THE LAMPS WERE REPLACED AND TESTED NORMAL IAW AMM 33-51-03.SDR UIEA2020063061411Lamp · inoperativeLEFT OVERWING NR 3 & 4 EMERGENCY LIGHTS FOUND NOT ILLUMINATED. LAMPS REPLACED AND LAMPS TESTED NORMAL IAW AMM 33-51-03.SDR UIEA2020063061413Light · no testL2 DOOR EMERGENCY LIGHT TEST FAILED. THE EMERGENCY LIGHT WAS REPLACED AND OPS TESTED NORMAL IAW AMM 33-51-06.SDR UIEA2020063071421Battery Pack · no testUPPER DECK DOOR, RT EMERGENCY SYSTEM FUNCTIONAL TEST FAILED. THE BATTERY PACK WAS REPLACED AND INSTALLATION TESTED NORMAL IAW AMM 52-23-14.SDR AALA202006309012Light · no testAIRCRAFT IN BASE VISIT: OPS CHECK OF ESPU FAILED AT R2 DOOR AFTER R1 DOOR SLIDE CHANGE, (SCHEDULED CHANGE). EXTERNAL LIGHT FAILED REQUIRES R2 SLIDE TO BE REPLACED. REMOVED AND REPLACED R2 SLIDE PER J/C 26L0002512, ESPU OPS CHECK GOOD.SDR AALA202006309013Power Supply · no testAIRCRAFT IN BASE VISIT: EPSU TEST FAILED AFTER SLIDE WAS CHANGE, (SCHEDULED CHANGE). REPLACED EPSU IAW AMM 33-50-01.SDR DALA2020062702533Battery Pack · dischargedSEATS 27DEF THROUGH 32 DEF E-PATH LIGHTS INOP. T/S AND FOUND BATTERY PACK M10568 AT FAULT. REPLACED SAME PER AMM 33-51. E-PATH LIGHTS AT SEATS 27DEF THROUGH 32DEF NOW CKS GOOD.SDR R61A2020063000543Power Unit · inoperativeAFT RT OUTBOARD ELPU BATTERY FAULT. R&R AFT RT OUTBOARD ELPU IAW AMM 33-50-01.SDR AALA2020062989010Battery · defectiveAIRCRAFT NOT GROUNDED - AFT FLIGHT ATTENDANT FLASHLIGHT NO.2 INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY, OPERATIONAL CHECK OKAY.SDR AALA2020062989002Connector · disconnectedAIRCRAFT WAS GROUNDED: L2 DOOR EMERGENCY EXIT LIGHTING, INOPERATIVE. FOUND LIGHT CONNECTOR 7243VC DISCONNECTED. RECONNECTED CONNECTOR 7243VC AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR CALA2020062901032Bulb · burned outEMER EXIT SIGN AT SEAT FWD OF FWD HATCH BULBS BURNT OUT. NEEDS INSPECTION OPERATION CHECK. REPLACED BULBS AND OPS CHECKED GOOD. REF AMM 33-51-11 INSPECTED EMER,EXIT SIGN OPS CHECK GOODSDR CALA2020062901031Lamp · inoperativeEMERGENCY EEL LIGHT AT SEAT 21 A IS NOT ILLUMINATED. RELAMPED EEL LIGHTS PER 33-51-11. OPS CHECK GOOD. INSPECTEC EEL LIGHTSSDR CALA2020062901030Charger · inoperativeM1672 BATTERY CHARGER TEST BUTTON WILL NOT WORK. REPLACED CHARGER REF AMM 33-51-06-960-806 OPS CHECKED GOOD. ACCOMPLISHED THE INSPECTION OF BATTERY CHARGER M1672 INSTALLATION. REF AMM 33-51-06-960-806.SDR CALA2020062901028Battery Pack · dischargedNO EEL PATHWAY LIGHTS FROM SEAT 23 ABC TO BACK OF PLANE. REPLACED BATTERY PACK AT M1672 REF AMM 33-51-06-960-805 OPS CHECKED OK. INSPECTED EEL PATHWAY LIGHTS ROW 23 AFT OPS CHECK GOODSDR CALA2020062901027Bulb · burned outSEATS 1AB FWD EEL LIGHT BULBS BURNT OUT. REMOVED AND REPLACED SEAT 1AB FWD EEL LIGHT BULBS REF AMM 33-51-11 OPS CHECK GOOD INSPECTED SEAT 1AB EEL LIGHTSDR JJBA202006297007Battery Pack · inoperativeRH FWD EXTERNAL LIGHT INOPERATIVE. R&R EMERGENCY LIGHT LAMP. OPS CHECK FAILED. ALSO, FOUND MULTIPLE INTERNAL EMERGENCY SIGNS IN GALLEY AREA TO BE INOPERATIVE AS WELL. TROUBLESHOT TO #2 EMERGENCY BATTERY PACK. R&R #2 BATTERY PACK. OPS CHECK SAT.SDR AALA202006299003Battery Pack · missingAIRCRAFT WAS NOT GROUNDED BUT WAS IN SHORT TERM STORAGE: LEFT HAND AFT ENTRY DOOR EMERGENCY EXIT LIGHT BATTERY PACK MISSING. INSTALLED BATTERY PACK PER AMM 33-51-06.SDR AALA202006289006Battery Pack · missingAIRCRAFT WAS NOT GROUNDED BUT WAS IN SHORT TERM STORAGE: FOUND LEFT HAND EMERGENCY BATTERY UNDER AFT SIDE PANEL TO BE MISSING. INSTALLED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA202006289005Battery Pack · missingAIRCRAFT WAS NOT GROUNDED BUT WAS IN SHORT TERM STORAGE: FOUND LEFT HAND MAIN ENTRY EMERGENCY LIGHT BATTERY PACK MISSING. INSTALLED BATTERY PACK AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA202006289004Battery Pack · missingAIRCRAFT WAS NOT GROUNDED BUT WAS IN SHORT TERM STORAGE: FOUND EMERGENCY BATTERY PACK AT RIGHT HAND OVER WING EMERGENCY EXIT LIGHT MISSING. INSTALLED BATTERY PACK AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR VNAA2020062811102Battery Pack · dischargedLEFT OVERWING LOWER EMERGENCY LIGHT INOPERATIVE. REMOVED & REPLACED EMERGENCY LIGHT BATTERY #4 IAW CRJ 900 AMM 33-51-17-000/400-801. OPS CHECK GOOD.SDR VNAA2020062811101Charger · failedRIGHT HAND OVERWING LOWER EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE NR 4 EPSU BATTERY CHARGER IAW AMM 33-51-17-000/400-802. OPS CHECKED GOOD.SDR ASAA2020071062883Battery Pack · inoperativeALMOST ALL EMERGENCY LIGHTS INOP. AFTER HAVING AIRCRAFT POWER ON FOR OVER TWO HOURS, NO HELP. GROUNDED - YES. CHANGED EMERGENCY LIGHT BATTERY AT FLOOR LEVEL ROW 7 -LH & RH, AND BATTERY AT OVERHEAD BY L-1 DOOR, OPS CHECK GOOD IAW T/C 78233008, STILL SEVERAL MORSDR SWAA2020070195842Battery Pack · dischargedASSOCIATED EMERGENGY LIGHTS WITH BATTERY PACK M1673 ARE INOP. REMOVED AND REPLACED PWR SUPPLY BATTERY PACK OF THE EMERGENCY LIGHTS AT POSITION M1673(AFT LT); OPERATIONAL TEST FOUND NORMAL IAW AMM 33-51-06-960-805 AND WDM 33-51-14 AND 33-51-22.SDR SWAA2020070195843Charger · inoperativeFWD CABIN EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY CHARGER AND BATTERY PACK POS M 1675 AS PER REF AMM 33-51-06-960-805 AND 33-51-06-960-806. PERFORMED OPS CHECK AND FOUND NORMAL.SDR SWAA2020070195844Light · inoperativeEXTERIOR EMERGENGY LIGHT BY AFT OF LEFT WING TO BODY FAIRING INOP. RELAMPED EXTERIOR EMERGENCY LIGHT BY AFT OF LEFT WING TO BODY FAIRING AS PER REF AMM 33-51-04-960-801 OPERATIONAL CHECK FOOUND NORMAL.SDR SWAA2020063095808Light · inoperativeRT OWE DOOR LOWER FWD EMERGENCY EXIT LIGHT INOP. RELAMPED RT OWE DOOR LOWER FWD EMERGENCY EXIT LIGHT AND PERFORMED SATISFACTORY OPERATIONAL TEST PER AMM 33-51-01-960-801.SDR SWAA2020063095355Battery · dischargedFWD GALLEY EMERGENCY LIGHTS L1505;L1063 AND L730 ARE INOP BAD BATTERY M2816. REPLACED EMERGENCY LIGHTS BATTERY M2816 IAW AMM 33-51-06-960-805. EMERGENCY LIGHTS L1505; L1063 AND L703 OPS CHECK GOOD.
Back to JASC 3350