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 DALA201812076085Battery Pack · inoperative(AIRCRAFT 7002, L/P 5330055) FOUND EMERGENCY LIGHT AT SEATS ROW 29 AB THROUGH 43 BOTH SIDES INOP. R/R BATTERY PACK AND CHARGER AT 33404 PER B777 AMM 33-51 NOW OPS CH GOOD.SDR DALA2018120607082Battery Pack · not reportedREPLACED EMERGENCY LIGHTING ESCAPE PATH LIGHTING BATTERY PACKS.SDR MASA2018120611579Light · inoperativeROW 18 OVERHEAD EMERG FLOOD LIGHT INOP. PLACED ON MELSDR IPXA2018120536606Panel · malfunctionedEMERGENCY LIGHTS SWITCH PANEL 1/2 BURNED OUT. REPLACED THE EMERGENCY LIGHT SWITCH PANEL LIGHT PLATE IAW AMM 33-13-01-404-023. OPS CHECKED GOOD. NO DEFECTS NOTED.SDR SWAA2018121027562Battery · failedL1 DOOR EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2018121027561Lens · missingL2 DOOR EXIT LENS MISSING DIRECTIONAL ARROWS. INSTALLED LENS PER AMM.SDR SWAA2018121027496Light · inoperativeLT EMERGENCY EXIT DOOR LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2018121027495Battery · failedR2 DOOR EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PER AMM.SDR SWAA2018121027494Charger · failedL1 DOOR EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY CHARGER PER AMM.SDR SWAA2018121027459Lens · missingR2 DOOR EXIT LENS MISSING DIRECTIONAL ARROWS. INSTALLED LENS PER AMM.SDR SWAA2018121027433Light · inoperativeFORWARD ENTRY EMERGENCY EXIT SLIDE LIGHT INOP. REPAIRED LIGHT PER MM.SDR YENA2018121050839Power Supply · failedFT # 1516, SFO-JFK. FOUND LR AND R3 DOOR EMERGENCY SIDEWALL LIGHTS INOP; R & R EPSU (12WL)IAW AMM 33-51-38. OPS CHKS GOODSDR DALA2018120607105Relay · failedEMERGENCY LIGHTS IN CABIN TAXI OUT CYCLED ON, REPLACED RELAY 8WL.SDR AALA201812079020Bracket · brokenEMERGENCY LIGHT BRACKETS 16,17, AND 18DEF WAS BROKEN. THE AIRCRAFT WAS GROUNDED. REPLACED THE BRACKET ASSEMBLY.SDR AALA201812079019Bracket · brokenEMERGENCY LIGHT BRACKETS 16,17, AND 18DEF WAS BROKEN. THE AIRCRAFT WAS GROUNDED. REPLACED THE BRACKET ASSEMBLY.SDR AALA201812079012Bracket · brokenEMERGENCY LIGHT BRACKETS 16,17, AND 18DEF WAS BROKEN. THE AIRCRAFT WAS GROUNDED. REPLACED THE BRACKET ASSEMBLY.SDR DALA2018120707094Power Supply · inoperative(AIRCRAFT 5654, L/P 5096971) ON S/C FOUND SEATS 23-26 EMERGENCY LIGHT INOP AND BOTH LT OVERWING EMERGENCY LIGHT INOP. REPLACED BATTERY PACK POWER SUPPLY M10567 POWER SUPPLY CHARGER-SLED. OPS CHK GOOD.SDR AALA201812069028Lens · missingAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT LENS COVERS MISSING 1L, 4L, 22L. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-19 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018120627416Battery Pack · failedBATTERY PACKS FAILED CAPACITY CHECK AT POSITIONS M1673. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018120627415Battery Pack · failedBATTERY PACKS FAILED CAPACITY CHECK AT POSITIONS M1669. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018120627414Lens · missingR1 LOWER EXIT SIGNS MISSING DIRECTIONAL ARROW. R&R LENS IAW AMM.SDR SWAA2018120627408Battery Pack · failedBATTERY PACKS FAILED CAPACITY CHECK AT POSITIONS M1670. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2018120627400Sign · unsecureR1 DOOR EXIT SIGN FELL OFF. R&R LIGHT ASSEMBLY IAW MM.SDR SWAA2018120627392Lens · missingL1 LOWER EXIT SIGNS MISSING DIRECTIONAL ARROW. R&R LENS IAW AMM.SDR SIMA201812065001Lamp · inoperativeLH EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED LH EMERGENCY LIGHT IAW AMM 33-50-10 OPS CHECK GOOD.SDR DALA2018120607059Battery Pack · inoperativeFOUND 16-24 OVERHEAD EMER LIGHT OUT. R+R BATTERY FOR 16-24 OVERHEAD PANEL EMER LIGHTS. OPS CHECK GOOD. (LP5087857)SDR REXA2018120501175Light · inoperativeDURING LINE CHECK FOUND AFT EMERGENCY FLOOR LIGHTS NOT WORKING. REPLACED AFT TWO EMERGENCY FLOOR TRACK LIGHT STRIPS PN 5946-5 AND PN 36378-2 IAW AMM 33-51-01.SDR MASA2018120541576Lamp · inoperativeROW 17 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE. RELAMPEDSDR XMXR20191211015Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR XMXR20191211014Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON. REPLACED BATTERY PACK.SDR SWAA2018121027504Lens · crackedRT OVERWING EXIT SIDEWALL LIGHT LENS CRACKED AT ROW 12. R&R LENS PER AMM.SDR YENA2018121040837Battery Pack · failedFT # 391, BOS-TPA. EPSU BATTERY 12WL FAILS EMERGENCY LIGHT SYSTEM TEST; R & R BATTERY AT EPSU 12WL IAW AMM 33-51-38, BATTERY AND SYSTEM OPS CHECK GOOD.SDR YENA2018121040836Battery Pack · failedFT # 391, BOS-TPA. EPSU BATTERY 10WL FAILS EMERGENCY LIGHT SYSTEM TEST; R & R BATTERY AT EPSU 10WL IAW AMM 33-51-38, BATTERY AND SYSTEM OPS CHECK GOOD.SDR CALA2018120702516Battery Pack · dischargedREF NR LP 9130047 B777-33-3-6026 CABIN L1 DOOR EMER LT BATTERY PACK M33093 CAP CHK FAIL CABIN L1 DOOR EMERGENCY LIGHT BATTERY PACK M33093 REPLACED AND TESTED,NORMAL,AS PER AMM 33-51-06 IDT: HX284042SDR ASAA2018120427216Lens · detachedEXIT SIGN FROM CENTER AISLE FELL OFF. GROUNDED - YES. REINSTALLED LENS TO THE CENTER AISLE EXIT SIGN AS REQUIRED LIGHT TESTED GOOD REF AMM 33-51-01-01-960-801.SDR AALA201812069021Disk · detachedTHE AIRCRAFT WAS NOT GROUNDED. 8D RED DISK POPPED OFF EMERGENCY LIGHT. RESECURED 8D EMERGENCY LIGHT PER AMM 33-51-18. OPERATIONS CHECK OK.SDR AALA201812069026Battery · dischargedAIRCRAFT WAS NOT GROUNDED: RIGHTHAND NR 2 AFT FLIGHT ATTENDANT FLASHLIGHT WOULD NOT TEST GREEN. MAINTENANCE REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018120627407Sign · unsecureR1 DOOR LOWER EMERGENCY EXIT SIGN COVER FELL OFF. R&R SIGN ASSEMBLY PER AMM.SDR AALA201812069008Battery · failedFORWARD GALLEY EMERGENCY EXIT SIGNS DID NOT ILLUMINATE DURING A TEST. REPLACED THE FORWARD GALLEY EMERGENCY EXIT BATTERY IAW AMM 33-50-07. OPS CHECKED NORMAL.SDR SIMA201812054004Charger · failedON APPROACH THERE WAS A STRONG SMELL OF SMOKE IN THE CABIN AND COCKPIT. WE DECLARED AN EMERGENCY. AND LANDED IN MIA. THERE WAS NOT VISIBLE SMOKE.-C/A-REMOVED AND REPLACED #2 BATTERY POWER SUPPLY AND CHASSIS ASSEMBLY IAW AMM 33-50-04, EMERGENCY LIGHTING SYSTEM SDR SWAA2018120527388Light · inoperativeRT OVERWING EMERGENCY EXIT SIDEWALL LIGHT INOP AT ROW 12. RELAMPED LIGHT PER AMM.SDR SWAA2018120527387Cover · unsecureRT EXIT LIGHT COVER FELL OFF. R&R EXIT LIGHT COVER PER AMM.SDR SWAA2018120527362Battery Pack · failedRT OVERWING EXIT EMERGENCY LIGHT FAILED CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2018120527360Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2018120527359Light · inoperativeR2 DOOR EXTERIOR SLIDE LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SIMA20181204005Battery Pack · crackedBATTERY POWER SUPPLY NR 2 BATTERY PACK FOUND CRACKED. REMOVED AND REPLACED NR 2 BATTERY POWER SUPPLY AND CHASSIS ASSEMBLY IAW AMM 33-50-04, EMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK SATISFACTORY IAW AMM 33-50-00. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 10SDR AALA201812059022Sign · inoperativeAIRCRAFT WAS NOT GROUNDED: EXIT SIGN ASSEMBLY INOPERABLE AT R1 DOOR FRAME. MAINTENANCE REPLACED EXIT SIGN PER AMM 33-59-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201812059020Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT FORWARD LEFT FAULT ON THE PROGRAMMING AND TEST PANEL 110RH. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT AND BATTERY PER AMM 33-51-38 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201812059007Light · malfunctionedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANTS REPORT EMERGENCY EXIT LIGHT ON AFTER TAKEOFF. TRIED COCK PIT SWITCH ALL POSITIONS AND NO CHANGE. FLIGHT ATTENDANT PANEL SWITCH APPEARS NORMAL. PERFORMED DEACTIVATION/ACTIVATION OF CABIN EMERGENCY LIGHT SYSTEM PER AMSDR DALA2018120507042Battery Pack · inoperative(AIRCRAFT 7002, L/P 5330049) SEAT 10-12 EMERGENCY ESCAPE PATH LIGHTING IS INOP - BOTH SIDES. REPLACED EMERGENCY BATTERY AND BATTERY PACK (M33098) PER B777 AMM 33-51. TEST OK.
Back to JASC 3350