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 UIEA2017092201790Battery Pack · inoperativeRIGHT OVERHEAD EMERGENCY LIGHT, ROWS 27 TO 40 INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-51-07. OP CHECKED NORMAL.SDR UIEA2017092201794Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHT RH SIDE ROW 39 INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-01. OP CHECKED OK.SDR UIEA2017092201797Lamp · inoperativeRT OVERWING SLIDE LIGHT INOPERATIVE. REPOSITIONED THE SLIDE LIGHT LAMP. OP CHECKED NORMAL IAW AMM 33-51-16.SDR REXA2017092201027Light · brokenBOARDING LIGHT ON WALL NEAR MAIN CABIN DOOR COVER BROKEN OFF BY PASSANGER BAG WHILE DEPLANING. REMOVED AND REPLACED FLOOR FLOODLIGHT- LEVEL EMERGENCY IAW AMM 33-51-14. OPS CHECKED GOODSDR UIEA2017092501833Lens · brokenMAIN CABIN RIGHT AFT EMERGENCY EXIT LENS HAS A PIECE BROKEN OFF AT BS 1430. REPLACED THE LENS IAW AMM 33-51-01.SDR YENA201709220783Light · failedFAILED MESSAGE FOR THE ESPU DURING AN OPERATIONAL TEST OF EMERGENCY LIGHTS IAW AMM 33-51-00-710-001. R & R LT FWD & AFT OVERWING EMERGY LIGHT ASSEMBLIES 61WL & 63WL IAW AMM 33-51-15. OPS CHECED NORMAL. ACFT OK FOR SERVICE.SDR YENA201709220782Light · failedFAIL MESSAGE ESPU EXT LOAD EMERGENCY LT NOTED UPON COMPLETION OF OPERATIONAL TEST OF EMERGENCY LIGHTS AMM 33-51-00-710-001. R & R LT FWD &AFT OVERWING EMERGY LIGHT ASSY 61WL & 63WL IAW AMM 33-51-15. OPS CHECKED NORMAL. ACFT OK FOR SERVICE.SDR DALA2017092207053Battery · defectiveDURING SERVICE CHK FOUND FWD OVERWING EMER EXIT SIGNS NOT LIGHTING UP. T/S AND FOUND BAD BATTERY CELL FOR FWD OVERWING EMERGENCY EXIT SIGNS IAW AMM 33-50 SYSTEM CHECKS GOOD.SDR DALA2017092307047Battery · dischargedEMERGENCY LIGHTS INOP. R&R BATTERY AT B5-237.SDR CALA2017092203302Battery · dischargedEMERGENCY LIGHT TEST FAILED AT PTP PANEL. REPLACED BATTERY AT EPSU 12WL NOW OK TEST OK FOR SERVICE REF AMM 33-51-38 PB401.SDR CALA2017092203300Battery Pack · no testEPSU BATTERY FWD LT MESSAGE APPEARED DURING CABIN EMERGENCY LIGHTS OPS CHECK. ACCOMPLISHED TEST SEVERAL TIMES WITH SAME RESULTS. REPLACED THE BATTERY IN THE POWER SUPPLY IAW AMM 33-51-38-401. OPS CHECKED GOOD.SDR CALA2017092203297Lens · missingEMERGENCY LIGHT BY THE L1 DOOR IS MISSING THE AFT LENS. REPLACED THE LENS.SDR CALA2017092203296Power Supply · inoperativeTWO FIRST CLASS RIGHT AISLE EMERGENCY LIGHTS INOPERATIVE. REPLACED THE M1674 POWER SUPPLY AND BATTERY PACK.SDR CALA2017092203279Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE ROW 39 HJK. REPLACED THE LAMPS, OP CHECKED GOOD.SDR CALA2017092203278Lamp · inoperativeEMERGENCY SPOTLIGHT INOPERATIVE. REPLACED THE LAMP. OP CHECKED GOOD.SDR CALA2017092203277Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE AT BASE OF STAIRS AND NEAR THE R2 DOOR. REPLACED THE LAMP, OP CHECKED GOOD.SDR CALA2017092203295Sign · missingEMERGENCY EXIT SIGN MISSING AT KNEE AREA OF SEAT 20A. REPLACED EMERGENCY LIGHT ASSY IAW AMM 33-51-01-960-802. OK FOR SERVICE.SDR CALA2017092203294Lens · missingFWD CLOSET AFT EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS. OPS CHECKED GOOD.SDR CALA2017092203293Lamp · inoperativeEMERGENCY LIGHT ABOVE SEAT 11D INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED NORMAL, RETURNED ACFT TO NORMALSDR CALA2017092203290Light · missingFWD LEFT GALLEY MODULE EMERGENCY LIGHT MISSING. REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51- 14. LIGHTS OPS CHECKED GOOD.SDR CALA2017092203289Lens · missingSEAT 12C EMERGENCY LIGHT LENS (WHITE) MISSING. REPLACED THE WHITE LENS. EMERGENCY LIGHTS OPS CHECKED NORMAL.SDR CALA2017092203287Sign · looseEXIT SIGN PANEL ABOVE WINDOW EXIT IS NOT ATTACHED. SECURED THE SIGN.SDR CALA2017092203283Battery Pack · defectiveRIGHT ISLE ROW 9, 10, AND 20, EMRGENCY LIGHTS INOPERATIVE. TROUBLESHOT THE EMERGENCY LIGHTS, AND FOUND M33098 BATTERY PACK DEFECTIVE. REPLACED THE BATTERY PACK IAW AMM 33-51-00. OPS CHECKED GOOD.SDR CALA2017092203281Light · looseR1 DOOR LOWER EMERGENYC LIGHT UNSECURE. REPLACED THE EMERGENCY LIGHT. OPS CHECKED GOOD IAW AMM 33-51-13-962-801, AND WDM 33-51-23. OPS CHECKED GOOD.SDR CALA2017092203291Lens · missingFWD GALLEY, WHITE EMERGENCY LIGHT LENS MISSING. INSTALLED A NEW LENS,SDR CALA2017092203257Lens · crackedEMERGENCY EXIT LIGHT LENS CRACKED ON SIDE OF LAV BY THE L2 DOOR. REPLACED THE EMERGENCY LIGHT ASSY, CHECKED OK.SDR YENA201709220781Power Supply · no testFOUND THE MID, RT FAIRING EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R THE POWER SUPPLY IAW AMM 33-50-01.SDR MASA2017092212652Lamp · inoperativeROW 15 EMERGENCY CEILING LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR MASA2017092212651Battery · discharged4CD BULKHEAD AFT EXIT SIGN INOPERATIVE. CHARGED THE BATTERIES.SDR E07A201802140013Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON.SDR RAIA201709210001Light · inoperativeMAIN PAX DOOR EXTERIOR FLOOD LIGHT (NR 1) INOP. R & R MAIN PAX DOOR EXTERIOR FLOOD LIGHT BULB, OPS CHECK GOOD.SDR AALA201709259032Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT IN THE LEFT AFT CABIN HAS A MISSING LENS COVER. REMOVED AND REPLACED EXIT SIGN ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR SWAA2017092616615Light · inoperativeL1 DOOR OUTER EMERGENCY LIGHT INOP. R&R LIGHT PER AMM.SDR SWAA2017092616612Lens · out of adjustRT EMERGENCY EXIT SIGN LENS OUT OF ADJUST. ADJUSTED LENS PER AMM.SDR DALA2017092107078Lens · damagedSEAT 19C EMERGENCY LIGHT WHITE LENS DAMAGED. INSTALLED A SERVICEABLE WHITE LENS IAW AMM 33-51.SDR DALA2017092107077Lens · damagedR2 DOOR EMERGENCY EXIT SIGN ABOVE DOOR DAMAGED. INSTALLED A NEW EXIT SIGN LENS IAW AMM 33-51.SDR DALA2017092307051Light · brokenSEAT 11D MOUNTED EMERGENCY LIGHT BROKEN, REATTACHED LIGHT MOUNT TO SEAT.SDR DALA2017092207046Lens · missingEMERGENCY EXIT LENS COVER MISSING AT DOOR 1R. INSTALLED NEW EMER EXIT LENS COVER.SDR DALA2017092107041Light · not seatedEMERGENCY EXIT LIGHT INOPERATIVE AT LOCATION 601. RESET EMERGENCY LIGHT.SDR AALA201709229010Light · damagedISLE EMERGENCY LIGHT FIRST ROW SEAT BROKEN. REPAIRED ISLE EMERGENCY LIGHT FIRST ROW IAW AMM.SDR AALA201709229008Lens · detachedEXIT LIGHT COVER FORWARD OF THE L1 DOOR CAME OFF. REPLACED EXIT LIGHT LENS IAW AMM.SDR DALA2017092207033Lens · detachedEMERGENCY EXIT SIGN LENS FELL OFF. REINSTALLED THE LENS ON THE EMERGENCY EXIT SIGN AT ROW 20. OPS NORMAL IAW AMM 33-51.SDR DALA2017092207032Power Supply · inoperativeAFT EMERGENCY DOOR EXIT SIGN IS INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY BATTERY POWER SUPPLY IAW AMM 33-51.SDR IPXA2017092121926Light · inoperativeRIGHT EMERGENCY EXIT LIGHT INOPERATIVE. R & R FWD RT EXIT SIGN LIGHT. TESTED GOOD.SDR DALA2017092207018Battery Pack · inoperativeUPPER DECK ROWS 72 - 75 EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACK IAW AMM 33-51. OPS CHECKED GOOD.SDR DALA2017092207019Unknown · unknownEMERGENCY LIGHTS CAME ON INTERMITTENT IN FLIGHT. STAYED ON AFTER LANDING. OPS TEST OF EMERGENCY LIGHTS PERFORMED SATISFACTORY IAW AMM 33-51.SDR YENA201709210779Power Supply · no testDURING HEAVY MAINTENANCE, EMERGENCY LIGHTS AT SEAT ROWS 9 -11 LT & RT FAILED TO TEST. REMOVED AND REPLACED EMERGENCY POWER SUPPLY 12WL. OPS CHECKED GOOD IAW AMM 33-51-38.SDR YENA201709210776Power Supply · inoperativeROW 1 EMERGENCY LIGHTS FOUND INOPERATIVE. THE FWD POWER SUPPLY WAS FOUND TO BE FAULTY. R & R THE FWD POWER SUPPLY IAW AMM 33-51-00. NO FURTHER PROBLEMS NOTED.SDR MASA2017092112649Bulb · inoperativeROW 3 EMERGENCY LIGHT INOP. REPLACED THE BULB.SDR MASA2017092112648Power Supply · inoperativeR1 DOOR LOWER FWD EMERGENCY SIGN INOPERATIVE. REPLACED THE POWER SUPPLY.
Back to JASC 3350