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 29GA2019050600001Circuit Breaker · trippedFLIGHT 0064 PNS/MCO REPORT: CIRCUIT BREAKER L-8 POPPED IN FLIGHT. CORRECTIVE ACTION: PERFORMED OPS CHECK OF EMERGENCY LIGHT SYSTEM IAW AMM 33-50-00. OPS CHECK GOOD.SDR MASA2019050311839Battery Pack · dischargedEMER LIGHT WILL NOT STAY ON. CHARGED EMER LIGHTS.SDR R61A201905030472Unknown · malfunctionedEMERGENCY LIGHT BATTERY FAULT EICAS MESSAGE. EMERGENCY LIGHTS WON'T TURN OFF. RESET A/C POWER, PERFORMED EMERGENCY LIGHTS OPS CHECK, OPS CHECK GOOD IAW AMM 33-50-00.SDR UIEA2019050304109Battery Pack · failedFOUND EMERGENCY LIGHT BATTERY PACK DEEP CYCLE FAIL AT M7915, M7919, M7920, M7922, AND M7924.(<P>REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACKS AT M7915, M7919, M7920, M7922, AND M7924 IAW AMM 33-51-04-902-001-001 REV. 95. PERFORMED POWER SUPPLY TEST AND THSDR UIEA2019050304115Battery · failedRQST DISCONNECT ALL OF EMERGENCY LIGHT POWER PACK. (<P>REMOVED CABIN EMERGENCY LIGHT POWER PACK BATTERIES IAW AMM 33-51-04-902-001-001 REV.95 STEP D. INSTALLED CABIN EMERGENCY LIGHT POWER PACK BATTERIES IAW AMM 33-51-04-902-001-001 REV.95, PER STEP E PERFORMEDSDR VNAA2019050211101Light · inoperativeEMERGENCY FLOOD LIGHT ABOVE ROWS 13 & 14 INOP. R/R EMERG CEILING FLOOD LIGHT IAW AMM 33-51-09-000/400-801. OPS CK GOOD.SDR ASOA201905025066Battery Pack · dischargedDURING MX INSPECTION THE EMERGENCY LIGHTS WERE FOUND INOP. MX REMOVED AND REPLACED NR 4 EMERGENCY BATTERY PACK WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2019050632401Light · dimLT EMERGENCY AISLE LIGHT VERY DIM AT SEAT 20. R&R LAMP IAW AMM.SDR DALA2019050202848Power Supply · inoperativeSHIP 694 EMERGENCY LIGHT ROWS 18-22 INOP. CORRECTIVE ACTION: REPLACED BATTERY POWER SUPPLY M733 PER AMM 35-51 ALL EMERGENCY LIGHTS OP CK NML. (5803242)SDR SWAA2019050632319Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1673. R&R BATTERY PER AMM.SDR SWAA2019050632297Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATIONS M1675. R&R BATTERY PER AMM.SDR SWAA2019050632296Light · inoperativeR2 DOOR EXTERIOR EMERGENCY ESCAPE SLIDE LIGHT INOPERATIVE. R&R LIGHT PER AMM.SDR SWAA2019050632291Light · inoperativeR1 DOOR EMERGENCY EXIT LIGHT HAD ONE BULB INOP. RELAMPED LIGHT PER AMM.SDR SWAA2019050632279Light · inoperativeR2 DOOR EMERGENCY LIGHT ONE EACH LAMP INOP. R&R LAMP IAW AMM.SDR YENA201905020256Battery · failedFLT 225, JFK-TPA. EMERGENCY LIGHT TEST FAILED ESPU BATTERY FIN 10WL; REMOVED & REPLACED EMERGENCY LIGHT BATTERY AT FIN 10WL PER AMM 33-51-38.SDR JJBA20190502002Light · inoperativeLT LOWER FAIRING EXTERNAL EMERGENCY LIGHT INOPERATIVE. R&R LT FWD LOWER FAIRING EMERGENCY LIGHT. OPS CHECK SAT.SDR SWAA2019050332267Pin · dirtyRT FORWARD EMERGENCY ESCAPE SLIDE LIGHT INOP. CLEANED AROUND PIN AT GROUND BLOCK PER SWPM.SDR HALA2019050300216Power Supply · inoperativeEMERGENCY EXIT CEILING LIGHT @ ROW 17 INOP. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY POWER SUPPLY PER AMM 33-51-03. BATTERY POWER SUPPLY (B5-120). OPS. CHECK GOOD, OK FOR SVC.SDR CALA2019050300689Battery · discharged(SUPPORT TASK) THE EMERGENCY LIGHT TEST AT THE PTP FAILS WITH TH E MESSAGE ''EPSU BATTERY AFT L?. REFER TO N/R: 9303386. REMOVED AND REPLACED BATTERY & EPSU 13WL AFL LECT. IAW AMM 33-51-38-000-002-A AND 33-51-38-400-002-A. OPERATIONAL TEST GOOD IAW AMM SUBTASKSDR 29GA2019050300001Light · unsecureFLIGHT 0067 FLL/MCO REPORT: BETWEEN ROWS 3+4 ESCAPE PATH LIGHTING FALLS OFF INTO THE AISLE. CORRECTIVE ACTION: RESECURED ESCAPE PATH LIGHTING IAW AMM 33-50-20,SDR MASA2019050211838Sign · inoperativeSERVICE DOOR LT EMER EXIT SIGN INOP. PLACED ON MEL FOR REPO.SDR SWAA2019050832473Battery Pack · failedEMERGENCY LIGHT BATTERY M1675 FAILED CAPACITY CHECK. R&R BATTERY PACK IAW AMM.SDR ASOA201905015065Light · inoperativeDURING MX INSPECTION THE EMERGENCY CEILING LIGHT OVER AISLE A ROW 18 FOUND INOP. MX REMOVED AND REPLACED BULB WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2019050202879Epsu · inoperativeDURING EMER LIGHT TEST, L1 SLIDE LT FAILED ESCAPE SLIDE LIGHTING, REPLACED EPSU AND BATTERY.SDR DALA2019050602878Light · inoperativeSEAT 35D EMERGENCY EXIT LIGHT INOP, REPLACED EMERGENCY LIGHT AND HOUSING AT SEAT 32D.SDR SWAA2019050732418Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT M01673. R&R BATTERY PACK PER AMM.SDR SWAA2019050732417Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT M01672. R&R BATTERY PACK PER AMM.SDR SWAA2019050732416Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT M01670. R&R BATTERY PACK PER AMM.SDR SWAA2019050732415Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT M01675. R&R BATTERY PACK PER AMM.SDR SWAA2019050732376Light · looseLT EMERGENCY AISLE LIGHTENING LOOSE AT ROW 8. SECURED LIGHT PER SIP.SDR SWAA2019050732332Battery Pack · failedEMERGENCY LIGHTING BATTERY PACKS FAILED CAPACITY TEST AT M01669. R&R BATTERY PACK PER AMM.SDR DALA2019050202847Light · inoperativeSHIP 660 ON SVC CK EMERGENCY LIGHT CK BOTH SLIDE ILLUMINATION LIGHTS AT DOOR 4 INOP. CORRECTIVE ACTION: REPLACED ALL FUSES BOTH POWER SUPPLY UNITS PER AMM 33-51 AND RELAMPED BOTH OPS CK'S GOOD. (5770618)SDR AALA20190502011Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: R4 DOOR EMERGENCY ESCAPE SLIDE LIGHT DID NOT ILLUMINATE DURING TEST ON STEP E(2). MAINTENANCE REPLACED BATTERY PACK PER MM 33-51-06.SDR AALA20190502001Battery · dischargedAIRCRAFT IN BASE MAINTENANCE: OVERHEAD TREAD LIGHTS LIGHT 1, 3, 5 AND 7 WERE INOPERATIVE. MAINTENANCE REPLACED POWER SUPPLY BATTERY M33143 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER MM 33-51-06-960-809.SDR SWAA2019050332277Battery · failedEMERGENCY LIGHTING BATTERY FAILED CAPACITY CHECK AT LOCATION M01672. R&R BATTERY PER AMM.SDR SWAA2019050332276Battery · failedEMERGENCY LIGHTING BATTERY FAILED CAPACITY CHECK AT LOCATION M01673. R&R BATTERY PER AMM.SDR SWAA2019050332275Battery · failedEMERGENCY LIGHTING BATTERY FAILED CAPACITY CHECK AT LOCATION M01675. R&R BATTERY PER AMM.SDR SWAA2019050332243Battery · failedEMERGENCY LIGHTING BATTERY FAILED CAPACITY CHECK AT LOCATION M01670. R&R BATTERY PER AMM.SDR AALA201905029018Power Supply · faultyAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EXTERIOR LIGHTS FAULT ILLUMANATED ON TEST. REMOVED AND REPLACED EPSU IAW AMM 33-51-38. OPS TEST GOOD.SDR UIEA2019043004078Light · inoperativeR4 DOOR SLIDE LIGHT INOP.(<P>REMOVED AND REPLACED R4 DOOR LIGHT ASSEMBLY PER AMM TASK 33-51-06-004-046. OPS CHECK GOOD PER AMM TASK 33-51-00-715-105.</P>)SDR UIEA2019043004079Light · inoperativeUPPER DECK SEAT ROW 10 AND 11 PATH LIGHTS REQUIRE RELAMP. (<P>RE-LAMPED UPPER DECK ROW 10 & 11 PATH LIGHTS PER AMM TASK 33-51-12-962-002. OPS CHECK GOOD PER AMM TASK 33-51-00-715-105.</P>)SDR UIEA2019043004080Light · inoperativeG5 PATH LIGHT OTBD RT REQUIRES RELAMP.(<P>RE-LAMPED G5 PATH LIGHT CTR OTBD RT PER AMM TASK 33-51-12-962-002.</P>)SDR UIEA2019043004081Light · inoperativeR3 AND R4 OVERHEAD EMERGENCY EXIT FLOOD LIGHT REQUIRES RE-LAMP.(<P>RE-LAMPED R3 AND R4 OVERHEAD FLOOD LIGHTS PER AMM TASK 33-51-07-962-001. OPS CHECK GOOD PER AMM TASK 33-51-00-715-105.</P>)SDR UIEA2019043004082Light · inoperativeR3 DOOR SLIDE LIGHT INOP.(<P>RE-LAMPED R3 DOOR SLIDE LIGHT PER AMM TASK 33-51-02-962-001. OPS CHECK GOOD PER AMM TASK 33-51-00-715-105.</P>)SDR DALA2019050302800Battery Pack · discharged(LOG 5656654) DURING INSPECTION FOUND FIRST CLASS & FWD GALLEY EMERGENCY LIGHTS INOPERATIVE. REMOVED & REPLACED BATTERY PACK M1674 PER AMM 33-51. BATTERY PACK M1675 OPS. TEST NML PER AMM 33-51.SDR QXEA2019050300204Guard · brokenPLASTIC GUARD OVER F/A EMERGENCY LIGHT SWITCH BY MAIN CABIN DOOR BROKEN. REMOVED FROM SERVICE. PERFROMED REMOVAL & INSTALLATION OF FOWARD LOWER WARDROBE WITH WARDROBE INSERT TO FACILITATE OTHER MTX IAW AMM TASK 25-24-03-000-803/400-803. R&R PLASTIC GUARD OVER SDR SIMA20190501002Battery · failedOVERWING UPPER AND LOWER INTERIOR EMERGENCY EXIT LIGHTS INOP AND EMERGERNCY LIGHT FLOOR STRIPS 4 AND 5 INOP. C/A-FOUND NR 3 EPSU BATTERY WOULD NOT HOLD A CHARGE. RAR NR 3 EPSU BATTERY AND CHARGER ASSY, OPC GOOD IAW AMM 33-50-14. BATTERY CHARGER ASSY P/N 11-00SDR AALA201905029022Light · disconnectedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT DISCONNECTED FROM AFT WALL. MAINTENANCE RECONNECTED EMERGENCY LIGHT AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER MM 33-53-00.SDR AALA201905029021Battery · dischargedAIRCRAFT WAS NOT GROUNDED: NR 1 FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 25-65-00.SDR MASA2019050111837Battery · dischargedALL EMER LIGHTS NOT TESTING/INOP. RECHARGED BATTERIES.
Back to JASC 3350