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 MASA2020052910087Battery Pack · dischargedROW 12 LT/RT LWR EMER SIGNS INOP. REPLACED BATTERY PACK.SDR FDEA2020052971061Unknown · malfunctionedON PREFLIGHT INSP CREW REPORTED EMERG LIGHT BATT LO ALERT. RESET POWER FOR EMER BATTERY PACK U1-1756, OPS TESTED EMER LIGHTS NORMAL AS MM 33-51-01-5 REQUIRES. A/C OK TO CONTINUE SERVICE.SDR SWAA2020060389010Light · inoperativeEMERGENCY EXIT LIGHTS FORWARD OF LT & RT OWE L1189 & L1188 HAVE BULBS OUT. RELAMPED EMERGENCY EXIT LIGHTS FORWARD OF LT & RT OWE L1189 AND L1188 AND PERFORMED GOOD TEST OF NEW LAMPS PER AMM 33-51-01-960-801.SDR SWAA2020060384262Light · inoperativeEMERGENCY EXIT LIGHTS FORWARD OF LT & RT OWE L1189 & L1188 HAVE BULBS OUT. RELAMPED EMERGENCY EXIT LIGHTS FORWARD OF LT & RT OWE L1189 AND L1188 AND PERFORMED GOOD TEST OF NEW LAMPS PER AMM 33-51-01-960-801.SDR ASAA2020060132765Battery Pack · dischargedR2 DOOR EMERGENCY LIGHTS DO NOT ILLUMINATE. REMOVED AND REPLACED, OPS CHECKED GOOD, R2 DOOR EMERGENCY LIGHTS EMERGENCY POWER SUPPLY AND BATTERY PACK IAW AMM 33-51-06.SDR SWAA2020060187646Cover · looseFORWARD GALLEY OVERHEAD EXIT SIGN COVER LOOSE. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-03.SDR SWAA2020060180978Sign · damagedAFT SERVICE DOOR AND AFT EMERGENCY EXIT SIGN DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01.SDR SWAA2020060181031Battery Pack · dischargedRIGHT OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK ON M1669 RT OVERWING EMERGENCY EXIT POWER SUPPLY. OP'S CHECK GOOD IAW AMM 33-51-06. PN OFF AND ON D717-01-100 SN OFF 33915 AND SN ON 40020.SDR SWAA2020060187636Battery Pack · dischargedEMERGENCY LIGHTS ON ROW 16 & 19 DEF, REMOVED AND REPLACED BATTERY PACK. OPS CHECKED GOOD IAW AMM 33-51-21. PN OFF AND ON D717-01-100, PN OFF 46969 AND SN ON 25797.SDR SWAA2020060184913Battery Pack · dischargedFORWARD RT CABIN EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED FWD RT BATTERY PACK IAW AMM 33-51-09. OPS CHECK GOOD.SDR SWAA2020060180886Battery Pack · dischargedRIGHT AFT OVERWING EMERGENCY EXIT SIGN AND BOTH RIGHT OVERWING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IAW MM 33-51-06. OP CHECK OK.SDR SIMA2020060127002Light · inoperativeRIGHT EXTERNAL EMERGENCY AFT LIGHT IS INOPERATIVE. REMOVED AND REPLACED RT EXTERNAL EMERGENCY AFT LIGHT LAMP IAW AMM 33-50-10. OPERATIONAL CHECK GOOD.SDR FDEA2020052971064Warning System · false activationDURING PREFLIGHT, CREW REPORTED WHEN TESTING EMERGENCY LIGHTS EIS MESSAGE SHOWED EMERGENCY LIGHTS BATTERY LOW. EMERGENCY LIGHTS OPERATIONS CHECK 'SATIS' IAW AMM 33-52-01-5, PLACARD REMOVED.SDR FDEA2020052971059Light · inoperativeR1 SLIDE LIGHT IS INOPERATIVE.SDR J7SA202005297001Unknown · malfunctionedDURING ROUTINE MAINTENANCE, DISCOVERED EMERGENCY LIGHTENING ON WITH SWITCH IN ARM POSITION. REMOVED SUSPECTED FAULTY FWD AND AFT EMERGENCY LIGHT POWER SUPPLIES AND INSTALLED REPLACEMENT POWER SUPPLIES IAW AMM 33-51-01.SDR AALA202005299002Power Supply · failedAIRCRAFT IN BASE MAINTENANCE. EMERGENCY LIGHTS FAILED BITE TEST. REMOVED AND REPLACED EPSU 14WL PER AMM 33-51-38.SDR AALA202005299001Power Supply · failedAIRCRAFT IN BASE MAINTENANCE. EMERGENCY LIGHTS FAILED BITE TEST. REMOVED AND REPLACED EPSU 12WL PER AMM 33-51-38.SDR AALA2020052989004Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE. EMERGENCY LIGHTS OVER FORWARD CABIN COAT CLOSET INOPERATIVE. REMOVED AND REPLACED EPSU (EMERGENCY POWER SUPPLY UNIT) BATTERY PACK PER AMM 33-51-06, OPERATIONAL CHECK OKAY.SDR AALA2020052989003Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE. EMERGENCY LIGHTS, FORWARD CABIN OVER ROWS 1 THRU 5, LT AISLE, INOPERATIVE. REMOVED AND REPLACED EPSU (EMERGENCY POWER SUPPLY UNIT) BATTERY PACK PER AMM 33-51-06, OPERATIONAL CHECK OKAY.SDR AALA2020052989001Power Supply · failedAIRCRAFT IN BASE MAINTENANCE. EMERGENCY LIGHTS FAILED BITE TEST. REMOVED AND REPLACED EPSU 13WL PER AMM 33-51-38.SDR DALA2020052902423Lens · missingDOOR 1R EMERGENCY EXIT SIGN LENS COVER MISSING. INSTALLED NEW EMERGENCY EXIT SIGN LENS AT DOOR 1R.SDR SWAA2020052881029Lens · missingFORWARD ENTRY DOOR LOWER EMERGENCY EXIT LENS MISSING DIRECTIONAL ARROW. REMOVED & REPLACED EMERGENCY EXIT LIGHT LENS REF SIP.SDR SIMA202005287001Battery · dischargedNR 3 AND NR 4 FLOOR PROXIMITY LIGHTS INOPERATIVE. C/A-REMOVED AND REPLACED NR 3 EMERGENCY BATTERY AND CHARGER IAW AMM 33-50-04 OPERATIONS CHECK GOOD.SDR R61A2020052800501Power Unit · inoperativeDURING TEST OF EMERGENCY LIGHTING SYSTEM, SEVERAL LIGHTS IN FORWARD LEFT HAND AREA DID NOT ILLUMINATE. R & R ELPU NR 2 IAW AMM 33-50-01.SDR MASA2020052710086Sign · inoperativeROW 12 LT/RT LWR EMER SIGNS INOP.SDR REXA2020070600578Light · inoperativeFLOOR LEVEL EMERGENCY LIGHT BULB BURN. REMOVED AND INSTALLED FLOOR LEVEL EMERGENCY LIGHT BULB IAW AMM 33-51-11 OPS CHECK GOOD.SDR IPXA2020061056360Light · inoperativeINSPECTION TYPE:N/A EMERGENCY LIGHT EGRESS INOP. R&R LAMP IAW AMM 3351-06-962-001-003. OPS CHECK GOOD.SDR SWAA2020060889307Battery Pack · dischargedLT OVERWING EXIT EMERGENCY SIGN LIGHTS ARE INOP. R&R BATTERY PACK PER AMM 35-51-06.SDR SWAA2020060180751Battery Pack · dischargedMULTIPLE EMERGENCY LIGHTS INOPERATIVE, FWD LT CABIN. REMOVED AND REPLACED FWD LT BATTERY PACK IAW AMM 33-51-04 PN OFF AND ON D717-01-100 SN OFF 46784 SN ON 214336.SDR SWAA2020060180750Battery Pack · dischargedMULTIPLE EMERGENCY EXIT LIGHTS INOPERATIVE AFT RT CABIN. REMOVED AND REPLACED BATTERY PACK AFT LT SIDE IAW AMM 33-51-04. PN OFF AND ON D717-01-100 SN OFF 30244 AND SN ON 28270. PN OFF AND ON D717-01-100 SN OFF 46784 AND SN ON 214336.SDR SWAA2020060180619Power Supply · inoperativeLEFT AFT PORTION OF EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED LT AFT EMERGENCY LIGHTS POWER SUPPLY IAW AMM 33-51-06. OPS CHECK OK.SDR CALA2020053100995Battery Pack · dischargedAISLE EMERGENCY LIGHT AT ROW 29 AND 34 RIGHT SIDE DO NOT ILLUMINATE. REPLACED BATTERY PACK M2627 IAW AMM 33-51-06-960-805. BOTH LIGHTS OPERATIONS CHECK NORMAL..SDR SWAA2020052780909Light · looseEMERGENCY FLOOR LIGHTING STRIP IS LOOSE ON CAPTAIN'S SIDE MID-CABIN. RESECURED EMERGENCY FLOOR LIGHTING STRIP IAW SIP OK TO CONTINUE SERVICE.SDR DALA2020052602419Battery · dischargedEMERGENCY PATH LIGHTS OUT AT ROW 33 THRU 37. CORRECTIVE ACTION: REPLACED BATTERY AT M11648. OK FOR SVC. REF AMM 33-51.SDR AALA2020052979001Power Supply · inoperativeAIRCRAFT WAS GROUNDED, EXTERIOR EMERGENCY EXIT LIGHT, RIGHT FUSELAGE AFT OF TRAILING EDGE, INOPERATIVE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY AT RT MID CABIN PER AMM 33-51-06, OPERATIONAL CHECK GOOD. CLEARED MEL 05-631D-B ON 33-13. ***SUPPLEMENTAL REPOSDR SWAA2020052980197Battery Pack · dischargedEMERGENCY LIGHTS ON OVERHEAD PANEL OUT 14C, 17C, 20C & 23CD. R & R BATTERY PACK IAW 33-51-06. OPERATION CHECK GOOD.SDR SWAA2020052980198Battery Pack · dischargedEMERGENCY EXIT LIGHT AT OVERWING EXIT LOCATOR SIGN IS INOPERATIVE. R & R EMERGENCY LIGHT BATTERY PACK AT POWER SUPPLY M1668 IAW AMM 33-51-06.SDR SWAA2020052780613Lens · brokenFO SIDE EXIT SIGN COVER FOUND ON SEAT. BASE BROKEN / RESECURED OVERWING EXIT LIGHT LENS AS PER M/M 33-51-04.SDR AALA2020052769008Battery · dischargedAIRCRAFT GROUNDED - EPSU 15WL FAILS TEST [SEE ASSOCIATED REPORT #AALA202005269007]. REMOVED AND REPLACED BATTERY IAW AMM 33-51-00, OPERATIONAL CHECK NORMAL, TESTED NORMAL.SDR SWAA2020052680188Lens · brokenRT WING EMER EXIT SMALL AFT LIGHT LENS BROKEN. REPLACED EMERGENCY EXIT LENS ASSY OPS CK GOOD PER AMM 33-51-01.SDR SWAA2020052680394Cover · missingEXIT SIGN AT MID CABIN HAS SMALL PANEL MISSING ON THE BACK SIDE CEILING MOUNTED) ( NEF ITEMS LISTED IN MEL APPENDIX 25-10 NON-ESSENTIAL EQUIPMENT & FURNISHINGS (NEF) ) INSTALLED EXIT SIGN COVER IAW AMM 33-51-01.SDR R61A2020052600497Sign · defectiveL2 DOOR EXIT IDENTIFIER SIGN ONLY HALF WORKS. R&R L2 DOOR EXIT IDENTIFIER SIGN PER AMM 33-50-15.SDR DALA2020052602420Power Supply · inoperativeLEFT EMERGENCY EXIT LIGHT INOP. CORRECTIVE ACTION: R&R EMERGENCY POWER SUPPLY BATTERY PER AMM 33-51, OPS CKS GOOD.SDR QXEA2020052600168Power Supply · malfunctionedAFTER POWER DOWN OF AIRCRAFT AND DURING WALK AROUND FOUND EXTERNAL EMERGENCY LIGHT STILL ON.REMOVED FROM SERVICE. REMOVED AND REPLACED EMERGENCY LIGHTS POWER SUPPLY AND BATTERIES EPS4. RETURNED TO SERVICE.SDR AALA2020052659004Battery · inoperativeAIRCRAFT NOT GROUNDED- EPSU 12WL BATTERY INOPERATIVE. REMOVED AND REPLACED 12WL BATTERY PER AMM 33-51-38, OPERATIONAL CHECK GOOD.SDR SWAA2020052880616Battery Pack · dischargedOVERWING EXIT SIGNS UPPER & LOWER SLIDE OVERWING LIGHT & OVERHEAD EMERGENCY LIGHTS AT ROW 9 CBA & ROW 12 CBA WILL NOT TEST ILLUMINATE. R & R BATTERY PACK AT STA 603 IAW AMM 33-51-06.SDR SWAA2020052680202Sign · unsecureCAPT SIDE OVERWING EXIT LOWER 'EXIT' SIGN FELL OFF. RE-INSTALLED SIGN IAW SIPSDR R61A2020052600498Battery · dischargedSUPPLEMENTAL INFORMATION: EMERGENCY LIGHT BATTERY FAULT. R&R AFT LT AND RT EMERGENCY BATTERIES IAW AMM 33-50-01.SDR AALA2020052659003Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE - EPSU (EMERGENCY POWER SUPPLY UNIT) 12WL INOPERATIVE. REPLACED EPSU 12WL PER AMM TASK 33-51-38-400-001-A. PERFORMED OPERATIONAL CHECK PER AMM TASK 33-51-00-710-00-A, AND BONDING CHECK PER AMM 20-28-00-869-002-A.SDR MASA2020022540083Battery Pack · dischargedEMERGENCY LIGHTS INOPERATIVE. CHARGED SYSTEM FOR 30 MINUTES GROUND TEST NORMAL
Back to JASC 3350