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 DALA2019061763610Light · inoperativeEMERGENCY ESCAPE PATH LIGHT AT SEAT 29H INOPERATIVE. REPLACED EMERGENCY LIGHT EEPMS.SDR DALA2019061763609Light · inoperativeEMERGENCY ESCAPE PATH LIGHT INOPERATIVE WITH SEAT 38A.SDR DALA2019061703605Lamp · inoperativeDURING INSPECTION, EEPLS AT SEAT ROWS 12AB, 20AB, 20HJ, 25HJ, AND 26HJ IMPERATIVE. RELAMPED SEAT 20AB AND RETERMINATED CONNECTORS AT REMAINING SEATS. LP5958404SDR CALA2019061700970Light · missingAISLE FLOOR PROX EMERGENCY LIGHT MISSING AT SEAT POSITION 17F SINGLE LIGHT ASSY ONLY MISSING MEL APPLIED AS PER 3351T. ATTENDENT PANEL AND FLIGHT DECK SWITCH PLACARDED TO REFLECT.SDR IPXA2019061743344Control Panel · malfunctionedFOUND "EMERGENCY LT " STILL ON EVEN SWITCH BEING IN "OFF" POSITION ON CTRL PANEL .R/R PILOT,S EMERGENCY LT CTRL PANEL AND OPS CHK OK IAW MM 53-51-08/401 IPC : 31-12-11-51A .SDR DALA2019061703577Light · inoperativeEMERGENCY ESCAPE PATH LIGHT INOP AT 16D. REPL LIGHT ASSY OPS CHECK GOOD REF MD88 AMM 33-53. (LP4629489)SDR SWAA2019061933930Fuse · inoperativeR/H EMERGENCY EXIT ROW SIDE WALL LIGHT NOP. R&R FUSE PER MM.SDR ASOA2019062155079Battery Pack · inoperativeMX DISCOVERED SEVERAL EMERGENCY LIGHTS INOPERATIVE IN THE AFT CABIN AND OVERWING. R & R #4 EMERGENCY LIGHT BATTERY PACK, OPERATIONAL CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2019061903661Housing · damagedDURING SERVICE CHECK, FOUND SEAT 14JH EMERGENCY LIGHT HOUSING DAMAGED. REPLACED HOUSING. LP 5482874SDR IPXA2019061974374Lamp · inoperativeINSPECTION TYPE:NAEMERGENCY EXIT LIGHT ABOVE CREW ENTRY DOOR INOPRELAMPED EMERGENCY EXIT LIGHT OPS CHECK GOODSDR YENA2019061950334Battery · no testFLT 391, EMERGENCY LIGHT TEST FAILED AFT EPSU BATTERY. R & R EMERGENCY LIGHT BATTERY AFT 13WL IAW AMM 33-51-38SDR SWAA2019061933929Bulb · dimL/H SIDE OVERWING EMERGENCY EXIT LIGHT DIM. R&R BULB PER AMM.SDR YENA2019061950333Light · malfunctionedFLT 779, EMERGENCY PATH LIGHT NOT WORKING. SYS CHECK PERFORMED REF AMM 33-50-00 ALL CHECKS NORMAL.SDR YENA2019061850332Battery · failedFLT 779, EXIT LIGHT LEFT OVERWING NOT WORKING ( EXIT MARKING SIGNS/BULBS (NO PAX) ); PERFORMED GROUND SCAN OF EMERGENCY LIGHTING SYSTEM AND FOUND EPSU BATTERY PACK EMERGENCY ROW LEFT SIDE PERFORMED BATTERY PACK TEST ON EPSU AND FAIL LIGHT ILLUMINATED. R & R BSDR DALA2019061873634Battery Pack · inoperativeDURING SVC CHECK FOUND 1R DOOR EMERGENCY LIGHTS INOP. R/R BATTERY PACK IAW B757 AMM 33-51. CHECKS GOOD.SDR SWAA2019061833870Cover · brokenEMERGENCY EXIT LIGHT COVER BROKEN ON R/H SIDE EMERGENCY EXIT DOOR. / R&R LIGHT COVER IAW AMM.SDR SWAA2019061833790Battery Pack · inoperativeR/H EMERGENCY EXIT OVERWING GROUND ILLUMINATION LIGHT INOP. R&R BATTERY PACK IAW MM.SDR SWAA2019061833784Power Supply · inoperativeR/H EMERGENCY EXIT OVERWING GROUND ILLUMINATION LIGHT INOP. R&R POWER SUPPLY IAW MM.SDR REXA2019061850911Light · inoperativeDURING ROUTINE CHECK FOUND EMERGENCY FLOOR TRACK LIGHTS 2ND,3RD, AND 4TH STRIPS FROM FWD CABIN GOING AFT INOP. REMOVED AND REPLACED EMERGENCY FOOR TRACK LIGHT STRIPS IAW AMM 33-51-01 OPS CHECK GOOD NO FURTHER DEFECTS NOTED P/N 36262-4SDR N6WA20190618501Battery Pack · inoperativeEMERG LIGHTS NOT WORKING. CHANGED EMERGENCY LIGHT BATTERY PACK IAW CRJ 700 33-51-17. PERFORMED OPS CHECK OF EMEGENCY LIGHTS IAW CRJ 700 AMM 33-51-15 OPS CHECK GOOD.SDR AALA2019061869010Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: COCKPIT EMERGENCY LIGHTS INOPERABLE AFTER BATTERY REPLACEMENT. MAINTENANCE RELAMPED LIGHT ASSEMBLY PER MM 33-53-00.SDR 29GA2019061800002Light · inoperativeFLIGHT 9001, ROWS 3 AND 4 ESCAPE PATH LIGHTING NOT ILLUMINATING. REPAIRED ESCAPE PATH LIGHTING IAW AMM 33-50-20-02, OPS CHECK GOOD.SDR CALA2019061700965Light · inoperativeEMERGENCY LIGHTS IN OFCR DID NOT ILLUMINATE WHEN ACTIVATED. ACCOMPLISHED KEY TRANSFER FOR CLASS 30 WCU. FAULT 33-12130 CLEARED AND OPS CKD GOOD. REF AMM DMC-B787-A-33-51-07-06A-950A-ASDR MASA2019061511905Power Supply · inoperativeROW 12 EMERGENCY FLOOD LIGHT INOP. REPLACED BATTERY POWER SUPPLY #3 AND #4SDR YENA2019061840329Power Supply · no testDURING HEAVY MAINTENANCE, EPSU-EMERGENCY POWER SUPPLY UNIT DONT PASS OPERATIONAL TEST. REPLACED EPSU IAW AMM 33-51-38-400-001-A. PERFORMED OPERATIONAL TEST OF THE EPSU IAW AMM 33-51-00-710-001. TEST IS GOOD AT THIS TIME. SUPPLEMENTAL INFORMATION TO FOLLOW.SDR AALA2019061869001Light · inoperativeAIRCRAFT WAS GROUNDED: SEAT 15ABC EMERGENCY PATH LIGHT INOPERABLE. MAINTENANCE REPAIRED SEAT 15ABC EMERGENCY PATH LIGHT PER TSM 33-51-00.SDR AALA2019061869006Power Supply · no testAIRCRAFT WAS GROUNDED: 15WL FAILED EPSU TEST. MAINTENANCE ACCOMPLISHED BITE TEST OF EPSU PER AMM 33-51-00.SDR AALA2019061869007Power Supply · no testAIRCRAFT WAS GROUNDED: 14WL FAILED EPSU TEST. MAINTENANCE ACCOMPLISHED BITE TEST OF EPSU PER AMM 33-51-00.SDR AALA2019061869008Power Supply · no testAIRCRAFT WAS GROUNDED: 10WL FAILED EPSU TEST. MAINTENANCE ACCOMPLISHED BITE TEST OF EPSU PER AMM 33-51-00.SDR AALA2019061869011Battery · no testAIRCRAFT WAS NOT GROUNDED: L2 AND L3 EPSU BATTERIES INOPERABLE. MAINTENANCE REPLACED BATTERIES AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA2019061869012Battery · no testAIRCRAFT WAS NOT GROUNDED: 11 WL FAILED A CHECK EPSU SYSTEM TEST. MAINTENANCE REPLACED POWER SUPPLY BATTERY UNIT PER AMM 33-51-38.SDR HNAA2019061800175Light · inoperativeLEFT EMERGENCY EXIT ON THE TOP OF EXIT IS NOT WORKING. REMOVED AND REPLACED LIGHTSDR SIMA201906174004Sign · inoperativeDURING PS-1 CHECK FOUND AFT GALLEY EXIT IDENTIFIER SIGN INOP-C/A-REMOVED AND REPLACED EXIT IDENTIFIER SIGN AFT OF GALLEY IAW EMB 140 AMM 33-50-13. OPC FAILED. FURTHER TROUBLESHOOTING REQUIREDSDR SIMA201906174003Charger · failedFLOOR EMERGENCY LIGHT ROWS 7 8 9 10 ILLUMINATED WITH EMER LIGHTS IN OFF POSTION-C/A-TROUBLESHOOTING EMERGENCY FLOOR LIGHTS AND FOUND #3 BATTERY POWER SUPPLY TO BE INOP. RAR #3 BATTERY POWER SUPPLY IAW EMB 140 AMM 33-50-04. OPS CHK OK IAW AMM 33-50-00SDR SIMA201906174002Light · damagedEMERGENCY FLOOR LIGHT STRIPS NEAR ISLES 18, 13RH, 6LH, AND 15 ARE CRACKED-C/A-REPLACED CRACKED AND/OR BROKEN EMERGENCY FLOOR AISLE LIGHT STRIP COVERS AS REQUIRED ROWS 6LH, 13RH, 15 AND 18 IAW AMM 33-51-01.SDR SWAA2019061733782Battery Pack · inoperativeFORWARD R/H EMERGENCY LIGHT BATTERY PACK INOP. R&R BATTERY PACK PER AMM.SDR SWAA2019061733781Light · crackedFORWARD SERVICE CEILING PANEL EMERGENCY EXIT ASSEMBLY CRACKED. / R&R LIGHT ASSEMBLY PER AMM.SDR ASOA2019061743034Inverter · inoperativeMAINTENANCE REPORTED THE EXIT SIGN ABOVE FA JUMPSEAT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE #1 EMERGENCY LIGHT INVERTER. OPERATIONAL CHECKS WERE GOOD.SDR MASA2019061411904Light · inoperativeOVERHEAD EMER FLOOD LIGHTS INOP. OPS CK GOOD.SDR SWAA2019061433777Sign · detachedCEILING EMERGENCY EXIT SIGN AT OVERWING EXIT ROW FELL OFF. R&R SIGN PER AMM.SDR DALA2019061403575Power Supply · inoperativeEMERGENCY LIGHTS FOR ROWS 13-23 ARE INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT BATTERY POWER SUPPLY REF MD88 WDM 33-51-14. OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT IS OK FOR SERVICE. (LP #4695023)SDR DALA2019061403574Power Supply · inoperativeEMERGENCY LIGHTS FOR ROW 31-36 ARE INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY BATTERY POWER SUPPLY PER WDM 33-51-14 MD88. OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT IS OK FOR SERVICE. (LP #4695022)SDR CALA2019061400954Battery Pack · no testAFTER SEAT ROW 21, 2 2, AND 23 ABC INSTALLATION EMERGENCY LIGHTS WILL NOT TEST ON ROW S 10 THRU 20. PERFORMED TS. FOUND BATTERY PACK M1676 DEFECTIVE. AT ROW 7 DEF REMOVED AND REPLACED ATTERY M1676 REF AMM 33-51-06 ALL CHECKS GOOD AT THIS TIMESDR CALA2019061400948Lamp · burned outSUPPORT TASK - OHAR EMER. LIGHT 1EA FOUND INOP REF L/P 9131701 OHAR EMER. LIGHT LAMP 1EA REPLACED AND TESTED NORMAL AS PER AMM 33-51-15 ADD EMP:V896958 IDT OKSDR JJBA20190614012Sign · inoperativeEXIT SIGN ON LH CABIN ESCAPE HATCH INOPERATIVE. R&R EXIT SIGN ON LH CABIN ESCAPE HATCH. OPS CHECK SAT.SDR DALA2019062643868Lens · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. REPLACED EMERGENCY FLOOR LIGHT LENS AT LOCATION 406.SDR DALA201906203671Light · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE AT 19B. 19B EMERGENCY LIGHT DAMAGED OR INOPERATIVE LIGHT ASSY - PHOTO LUMINESCENT [LENGTH 23.90 INCHES] REF IPC 33-51-12-01 ITEM 55. MAINTENANCE REINSTALLED PHOTO LUMINESCENT STRIP REF LOG PAGE #5917548. (LP #112SDR SWAA2019061833811Light · inoperativeR/H FLOOR PHOTOLUMINESCENT STRIP INOP BETWEEN ROW 1 TO ROW 2. / R&R LIGHT TRACK PER MM.SDR DALA2019061763606Cids · malfunctionedEMERGENCY EXIT SIGNS INOPERATIVE. RESET CIDS, OPERATIONAL CHECK OK.SDR SWAA2019061733742Light · looseR/H LIGHTING STRIP ON FLOOR BY LOOSE AT ROW 10. SECURED FLOOR TRACK LIGHTING STRIP PER M/M 33-51-12
Back to JASC 3350