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 SWAA2020010240114Light · damagedFORWARD LAV EMERGENCY EXIT LIGHT DAMAGED. / R&R LIGHT IAW AMM.SDR SWAA2019122339868Light · damagedAFT LOWER SWING DOWN CEILING PANEL EMERGENCY EXIT LIGHT DAMAGED. R&R LIGHT PER AMM.SDR SWAA2019120939446Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK (M1672) WOULD NOT CHARGE. / R&R BATTERY PACK M1672 IAW AMM AND WDM.SDR QXEA2019112700434Switch · brokenFORWARD FLIGHT ATTENDANT EMERGENCY LIGHT SWITCH BROKEN. REMOVED FROM SERVICE. REPLACED SWITCH AND GUARD IAW Q400 AMM 33-51-400-801. RETURNED TO SERVICE.SDR IPXA2019112759349Battery Pack · inoperativeINSPECTION TYPE:N/AEMERGENCY LIGHTS "UNARMED" LIGHT SWITCH PARTIALLY ILLUMINATEDR&R EMERGENCY LIGHTS BATTERY PACK WITH REF. TO AMM 33-51-07 CKS SATISFACTORY. IPC 33-51-11-01SDR SWAA2019112739175Sign · detachedTHE MID CABIN CEILING EXIT SIGN FELL DOWN. / SECURED EXIT SIGN PER SIP.SDR ASAA2019112641456Lens · detachedEXIT SALIDA COVER MISSING EXIT ROW SEAT 16F. GROUNDED - YES. REPLACED EMERGENCY LIGHT COVER AT 16F, REF B737-800 AMM 33-51-01. OK FOR CONT SERVICE.SDR ASAA2020112643455Lens · detachedCREW REPORTS LIGHTED EMERGENCY EXIT SIGN LENS AT ROW 16 RH IS MISSING. GROUNDED - YES. INSTALLED EMERGENCY EXIT SIGN LENS.SDR SWAA2019112639147Lamp · inoperativeR/H EMERGENCY EXIT DOOR SIDEWALL LIGHT INOP AT ROW 12. / RELAMPED LIGHT IAW AMM.SDR DALA2019112506917Cover · missing24D EMERGENCY PATH LIGHT COVER MISSING. R&R LIGHT ASSY PER A319 AMM 33-51. OPS CK NORMAL. OK FOR SVC.SDR QXEA2019112500427Light · loosePHOTOLUMINESCENT STRIP LOOSE. REMOVED FROM SERVICE. RE-SECURED PHOTOLUMINISCENT STRIP NO FURTHER DEFECTS NOTED.SDR SWAA2019112539082Coupling Sleeve · unsecureR2 DOOR LOWER EXIT LIGHT COVER WOULD NOT STAY SECURED. / SECURED LIGHT COVER PER AMM.SDR SIMA201911254001Charger · failedDURING PS-2 FOUND ON AFT GALLEY AERA, EMERGENCY EXIT MARKING AND FLOOR PROXY LIGHT 2 AND 3 OUT.-C/A-REMOVED AND REPLACED #2 BATT CHARGER IAW AMM 35-50-04-04 AND PERFORMED EWIS CLEANING PRACTICES IAW SWPM 20-21-00SDR SIMA201911254002Light · inoperativeRH OVERWING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED RH OVERWING EMERGENCY LIGHT IAW EMB 145 AMM 33-50-10. OPC GOODSDR ASAA2019121131562Power Supply · dischargedLEFT HAND EMERGENCY LIGHT AT ROWS 16-23 OUT AND AFT LEFT OUTSIDE EMERGENCY EXIT LIGHT OUT. GROUNDED - YES. REMOVED AND REPLACED L/H EMERGENCY POWER SUPPLY S/N 45025 STA 727 L/H SIDE OPS CK IS GOOD IAW B737-800 AMM 33-51-06-960-806 AND EMERGENCY LIGHTS CHARGED SDR YENA2019112730683Battery · failedDURING HEAVY MAINTENANCE, EPSU'S 11WL AND 12WL LOW VOLTAGE; (REF LHT NR 5200000690-005000941612-0010) REPLACE EPSU BATTERIES (11WL + 12WL) IAW A321 AMM 33-51-38-400-002-A. OPS CHECK GOOD.SDR YENA2019112730682Battery Pack · failedDURING HEAVY MAINTENANCE, EPSU'S 11WL AND 12WL LOW VOLTAGE; (REF LHT NR 5200000690-005000941612-0010) REPLACE EPSU BATTERIES (11WL + 12WL) IAW A321 AMM 33-51-38-400-002-A. OPS CHECK GOOD.SDR AALA2019112659010Connector · looseAIRCRAFT WAS GROUNDED: ROW 14, 15, AND 16 DEF EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE RECONNECTED LOOSE CONNECTORS AND REVERSED PINS AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER WDW 31-51-13.SDR R61A2019112631339Light · missingPHOTOLUMINESCENT STRIP BY 1D IS MISSING. R&R PHOTOLUMINESCENT STRIP IAW 33-50-21.SDR DALA2019112656931Light · inoperative(AIRCRAFT 658, L/P 1372643) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:19D / INTERIOR. CORRECTIVE ACTION: R/R EMERGENCY LIGHT ASSY AT 19D. OPS CK GOOD.SDR SWAA2019112639136Power Supply · malfunctionedFORWARD CABIN, EMERGENCY EXIT LIGHTS COMMON TO M1675 WERE NOT OPERATING CORRECTLY. / R&R POWER SUPPLY IAW AMM.SDR SWAA2019112639118Battery Pack · malfunctionedFORWARD CABIN, EMERGENCY EXIT LIGHTS COMMON TO M1675 WERE NOT OPERATING CORRECTLY. / R&R BATTERY PACK IAW AMM.SDR AALA201911259018Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS 11WL EPSU FAILED DURING SERVICE CHECK. REMOVED AND REPLACED 11WL EPSU IAW 33-51-38. OPS CHECK NORMAL.SDR ASAA2019112531420Battery Pack · dischargedCABIN RIGHT SIDE EMERGENCY LIGHTS FWD OF OVERWING EXITS AND OUTSIDE R/H LOWER GROUND EMERGENCY LIGHT ONLY STAYED ON FOR < 2 MINUTES BEFORE GOING OUT. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK POWER SUPPLY S/N 47234 AND OPS CHECKED GOOD IAW B737-800 AMMSDR SWAA2019112539093Lamp · inoperativeAFT OF L2 DOOR EMERGENCY LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR SWAA2019112539084Battery · inoperativeSEVERAL AISLE EMERGENCY EXIT LIGHTS INOP ON AFT CAPTAIN SIDE. / R&R M1673 BATTERY IAW AMM.SDR SWAA0255110139083Battery Pack · inoperativeR2 DOOR AFT EMERGENCY LIGHT INOP. / R&R BATTERY PACK PER AMM.SDR DALA2019112506897Charger · inoperativeDURING SERVICE CHECK FOUND AFT 3 LEFT EXTERNAL EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY CHARGER ASSEMBLY. SYSTEM OPERATION IS NORMAL.SDR CALA2019112542058Power Supply · failedCIDS TEST FAILED. MSGS "EPSU EXT LOAD FWD L" REPLACED EPSU P/N 3214-54-10 AND EPSU BATTERY P/N AD3214-31. ORIGINAL MESSAGE GONE. NEW MESSAGE EPSU EXT LOAD FWD L PRESENT. ROTABLE PARTS CHANGE WAS INDICATED - TT # 1104555 SN OFF 8398 POWER SUPPLY, C OFF 31-335SDR CALA2019112542059Light · damagedEMER EXIT PATHWAY LIGHT AT SEAT 34ABC DAMAGED REPLACEDLIGHT ASSY REF AMM 33-51-11 OPS CHECKED OK. ACP''D IDT INSPECTION IAW GMM 09-10-05SDR MASA2019112312155Bulb · inoperativeEMER LIGHT IN GALLEY INOP
REPLACED BULBSDR MASA2019112312154Bulb · inoperativeEMER LIGHT IN EXIT ROW RH SIDE
REPLACED BULBSDR MASA2019112312153Bulb · inoperativeROW 18A EXIT SIGN 1 BULB INOP
MX SECURED THE BULBSDR 2019FA0000383Light · inoperative7A SEAT EMERGENCY LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY IAW AMM 33-51-10. OPS CHECK GOOD.SDR SWAA2019120939486Light · brokenMAIN CABIN OVERWING EMERGENCY CEILING LIGHT BROKEN. / R&R LIGHTS PER AMM.SDR AALA2019112659003Light · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING OPERATIONS CHECK OF EMERGENCY LIGHT, FOUND FLIGHT DECK EXIT EMERGENCY LIGHT INOPERABLE. MAINTENANCE REPLACED EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-00.SDR SWAA2019112639146Cover · brokenAFT GALLEY G4 R/H SIDE EMERGENCY LIGHT COVER BROKEN. / R&R COVER IAW AMM.SDR YENA201911262679Battery Pack · no testREF TC# 33-50-01-720-801- FWD & MID EPSU FUNCTIONAL TEST REQUIRE UNIT TO BE REPLACE; R & R FWD EPSU1 & CTR FWD EPSU PER AMM 33-50-01. SUPPLEMENTAL INFORMATION TO FOLLOW.SDR YENA201911220678Battery Pack · no testREF TC# 33-50-01-720-801- FWD & MID EPSU FUNCTIONAL TEST REQUIRE UNIT TO BE REPLACE; R & R FWD EPSU1 & CTR FWD EPSU PER AMM 33-50-01. SUPPLEMENTAL INFORMATION TO FOLLOW.SDR AALA201911259009Battery · no testAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FLIGHT ATTENDANT SEAT FAILED TEST. MAINTENANCE REPLACED BATTERY OF FLASHLIGHT PER AMM 25-64-00.SDR SWAA2019112539134Light · inoperativeL/H WING EMERGENCY EXIT EXTERIOR LIGHT INOP. / R&R LIGHT IAW AMM.SDR SWAA2019112539133Lamp · inoperativeR2 DOOR EMERGENCY SLIDE LIGHT INOP. / R&R LAMP IAW AMM.SDR SWAA2019112539132Lamp · inoperativeR1 DOOR EMERGENCY SLIDE LIGHT INOP. / R&R LAMP IAW AMM.SDR SWAA2019112539092Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669 IN CABIN. / R&R BATTERY PACK PER AMM.SDR SIMA201911252003Lamp · inoperativeRH OVERWING EMERGENCY LIGHT INOP.-C/A-REMOVED AND REPLACED RH OVERWING EMERGENCY LIGHT LAMP IAW EMB AMM TASK 33-50-07-000-801-A AND 33-50-07-400-801-A OPC GOODSDR SIMA201911252004Battery Pack · inoperativeDURING PS-1 CHECK, FOUND BOTH LH AND RH EXTERIOR OVERWING EMERGENCY LIGHTS INOP-C/A-REMOVED AND REPLACED BATTERY ASSEMBLY AND BATTERY CHARGER ASSEMBLY IAW AMM 33-50-04. OPERATIONAL CHECK GOOD. NO DEFECTS NOTED AT THIS TIME. CHARGEDR ASSY BATTERY P/N BA5-0933-9SDR SIMA201911252002Light · inoperativeEMERGENCY FLOR STRIP 1 LH SIDE INOP-C/A-REMOVED AND REPLACED EMERGENCY FLOOR STRIP 1 LH SIDE IAW ERJ 175 AMM 33-50-21. NO FURTHER DEFECTS FOUND.SDR SIMA201911252001Battery Pack · unknownREFERENCE CANN TAG C83819 CANNED RH FWD EMERGENCY LIGHT POWER UNIT P/N 3400-22-10 S/N 13522 TO N250NN. (CANNED FROM AIRCRAFT)-C/A-INSTALLED RH FWD EMERGENCY LIGHT POWER IAW EMB 175 AMM 33-50-01 SYS CKS GOOD.SDR DALA2019112506908Power Supply · inoperative(AIRCRAFT 6819, L/P 6211426) EMERGENCY ESCAPE LIGHTS FROM ROW 23 TO 26 INOP. CORRECTIVE ACTION: R/R POWER SUPPLY M11383 PER B757 AMM 33-51. OPS CK GOOD.SDR CALA2019112542055Power Supply · inoperativeAAR N/R S/N 9304353.(A3NB-33-6012) L-58-NO DOT, THE EMERGENCY LI GHT TEST FOR THE CIDS FAILS WITH THE MESSAGE"EPSU BATTERY AFT L? ATA33-51-38 REMOVED AND REPLACED EPSU BATTERY AFT L IAW A320 AMM 33-51-38-40 0-002-A. OPS TEST ACCOMPLISHED ON CUST CARD 18-3351-1
Back to JASC 3350