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 AALA202111248361Light · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT LENS MISSING AT SEATS 12D, 11G, AND 8G. REPLACED EMERGENCY PATH LIGHT ASSEMBLIES WITH NEW (AALA202111245734, AALA202111248755) IAW CMM 25- 02-67, OPS CHECK GOOD.SDR AALA202111245734Light · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT LENS MISSING AT SEATS 12D, 11G, AND 8G. REPLACED EMERGENCY PATH LIGHT ASSEMBLIES WITH NEW (AALA202111228361, AALA202111248755) IAW CMM 25- 02-67, OPS CHECK GOOD.SDR AALA202111248755Light · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT LENS MISSING AT SEATS 12D, 11G, AND 8G. REPLACED EMERGENCY PATH LIGHT ASSEMBLIES WITH NEW (AALA202111228361, AALA202111245734) IAW CMM 25- 02-67, OPS CHECK GOOD.SDR AALA202111241333Flashlight · faultyAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT FOUND ON. **SUPPLEMENTAL REPORT FOR AALA202111231333: REPLACED FLASHLIGHT.** (CLOSED)SDR AALA202111248841Bracket · brokenAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT BRACKET BROKEN. **SUPPLEMENTAL REPORT FOR AALA202111238841: REPLACED MOUNTING BRACKET.** (CLOSED)SDR SWAA2021112446511Battery Pack · inoperativeRT SIDE EMERGENCY EXIT ROW SIGNS INOP ; / [01] R&R EMERGENCY LIGHT BATTERY PACK AT STATION 565RT. OPS CK GOOD. PER AMM 33-51-06SDR SWAA2021112446526Power Supply · inoperativeEMER LIGHT BATTERY PACK M1671 (RIGHT MID AFT) LIGHTS WILL NOT COME ON ; / [01] R&R M1671 EMER POWER SUPPLY AND BATTERY PACK IAW AMM 33-51-06. OPS CHECK GOOD.SDR SWAA2021112447376Battery Pack · inoperativeEMER LIGHT BATTERY PACK M1671 (RIGHT MID AFT) LIGHTS WILL NOT COME ON ; / [01] R&R M1671 EMER POWER SUPPLY AND BATTERY PACK IAW AMM 33-51-06. OPS CHECK GOOD.SDR SWAA2021112446527Battery Pack · inoperativeEMER LIGHT BATTERY PACK M1676 (RIGHT MID FWD) WILL NOT HOLD A CHARGE ; / [01] R&R M1676 EMER BATTERY PACK IAW AMM 33-51-06. OPS CHECK GOOD.SDR DALA2021112407227None · noneSHIP 689 L1 FWD EXIT SIGN MISSING. CORRECTIVE ACTION: INSTALLED NEW EXIT SIGN. OPS CHK GOOD. (7085610)SDR HALA2021112300211None · noneSHIP 396 CEILING EMERGENCY EXIT SIGN 3L DOOR HELD IN PLACE BY TAPE. CORRECTIVE ACTION: RESECURED EXIT SIGN. (7247804)SDR ASAA2021112136669Battery Pack · inoperativeBOTH AFT (L2 AND R2) EMERGENCY BATTERIES TEST BAD. GROUNDED - YES. REMOVED AND REPLACED LEFT AND RIGHT AFT BATTERY PACKS AND POWER SUPPLIES, S/N 414761 & S/N 412851. OPS CK GOOD IAW B737-900 AMM 33-57-06-960-805 STEPS 4.E(1-3(E))(4-6), F(4) AND AMM 33-51-06-96SDR DALA2021112307213None · noneSHIP 3324 EXIT SIGN AT 3L FELL OFF. CORRECTIVE ACTION: SECURED EXIT COVER AT 3L. (8347684)SDR AALA202111238841None · noneAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT BRACKET BROKEN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202111231333None · noneAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT FOUND ON. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR ASAA2021112136663Battery · inoperativeUPON ACCOMPLISHING TASK CARD 78233001 EMERGENCY BATTERY PACK FUNCTIONAL CHECK FOUND L2 EXTERNAL LIGHT, BOTH R/H OVER WING EXIT LIGHTS, & R/H SIDE INTERIOR ROW 17-24 LIGHTS INOP. SUSPECT POSSIBLE BAD BATTERY PACKS. GROUNDED - YES. REMOVED AND REPLACED EMERGENCYSDR AALA202111224448Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND 10WL BATTERY FAULT DURING EMERGENCY POWER SUPPLY UNIT TEST. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY PER AMM 33-51-38. OK FOR SERVICE.SDR AALA202111229921Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY BATTERY RIGHT FAULT WHILE ACCOMPLISHING JOB CARD 26L20025014. REQUIRES REPLACEMENT. REMOVED AND REPLACED RIGHT EMERGENCY LIGHT BATTERY PER AMM 33-51-38. OPERATIONS CHECK NORMAL.SDR AALA202111224496Wire Harness · shortedAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT TEST, ROWS 3, 4, 8, 16, 19 AND 20 HAVE NO ESCAPE PATH LIGHTING. REPAIRED SHORTED WIRES AT SEAT ROW 16ABC.SDR AALA202111228602Power Supply · failedAIRCRAFT WAS GROUNDED: EMERGENCY POWER SUPPLY UNIT 15WL FAILED TEST. CIDS FAIL MESSAGE. REPLACED POWER SUPPLY UNIT PER AMM 33-51-38.SDR SIMA20211121002None · noneFA EMERGENCY FLASH LIGHT MISSING AFT CABIN-C/A-FLIGHT CREW PLACARDED AFT CABIN EMERGENCY FLASHLIGHT M PROCEDURES C/W AUTH# 110312M-C REF# 25-32 MOC# 206396SDR DALA2021112207153None · noneTHE EMERGENCY CEILING LIGHT AT ROW 15-19 IS INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHTS BATTERY AT LOCATION B5-120 & B5-121 PER B717 AMM 33-51. OPERATIONAL CHECK WAS GOOD. (LP #8084079)SDR MASA2021112000310Bulb · inoperativeEMER EXIT LIGHT ABV ROW 15 INOP
REPLACED BULBSDR SWAA2021112346605Light · inoperativeSUPPLEMENTAL INFORMATION: EXTERIOR EMERGENCY LIGHT BY L1 DOOR INOP. ; / [01] RELAMPED PER AMM 33-51-04.SDR SWAA2021112446298Light · inoperativeSUPPLEMENTAL INFORMATION: RIGHT OVERWING SLIDE LIGHT DOES NOT ILLUMINATE. ; RIGHT OVERWING SLIDE LIGHT DOES NOT ILLMINATE. / [01] REPLACED RIGHT OVERWING SLIDE LIGHT LAMP AND PERFORMED SATISFACTORY TEST OF NEW LAMP PER AMM 33-51-04-960-801; NO DEFECTS NOTED.; SDR SWAA2021112346082Light · looseSUPPLEMENTAL INFORMATION: PHOTO LUMINESCENCE LIGHT STRIPE I FLIGHT AT SEAT 8/9 BOTH SIDES ; / [01] SECURED PHOTO IIIMINESCENCE EXIT LIGHT AT ROW 8/9 PER AMM 33-51-15SDR DALA2021112407226None · noneSHIP 5812 EMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS:27F. CORRECTIVE ACTION: COULD NOT DUPLICATE FAULT, OPS CK NML ON GROUND. (2024485)SDR DALA2021112407225None · noneSHIP 5812 EMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS:27E. CORRECTIVE ACTION: COULD NOT DUPLICATE, OPS CK NORMAL ON THE GROUND. (2024484)SDR DALA2021112407224None · noneSHIP 5812 EMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS:27D. CORRECTIVE ACTION: COULD NOT DUPLICATE FAULT, OPS CK NML ON GROUND. (2024483)SDR HALA2021112300210None · noneSHIP 361 FWD GALLEY PHOTOLUMINESCENT LIGHTING STRIP IS DETACHED. CORRECTIVE ACTION: REATTACHED FWD GALLEY PHOTOLUMINESCENT LIGHTING STRIP. (7744650)SDR DALA2021112407217None · noneSHIP 1814 3L EXIT ROW SIGN HANGING, CORRECTIVE ACTION: REATTACHED NEW HARDWARE FOR EXIT SIGN. EXIT SIGN RE-SECURED. OK FOR SVC. (8119496)SDR DALA2021112407216None · noneSHIP 1815 EMERGENCY SEAT MOUNTED LIGHTING DAMAGED. CORRECTIVE ACTION: PERFORMED EMERGENCY LIGHT TEST REF B767 AMM 33-51 OPS CHK NORMAL. (2024278)SDR DALA2021112307206None · noneWHILE WORKING WORK CARD 32-0533-8-0075 FOUND EPSU (12WL)FAULT MSG ESCAPE SLIDE LT/EPSU (12WL) EXT R. REPLACED 3R SLIDE ASSY PER AMDS CARD 2561-4001-3R REF LOG 2025481. WIP 906371 EPSU TEST OK. MEL AND PLACARDS REMOVED. RII INSPECION C/W QC5219. (LP# 8385312)SDR DALA2021112307202Housing · damaged(LOG 7812486) DURING INSPECTION FOUND SEAT 34D EMERGENCY ESCAPE PATH LIGHT INOP. REPLACED EEPL HOUSING AT SEAT 34D PER B737 AMM 33-51. EEPL OPS CHECK GOOD.SDR DALA2021112307199Light · damaged(LOG 8157634) DURING INSPECTION FOUND AFT EXIT SIGN LIGHT ASSEMBLY DAMAGED. REMOVED AND REPLACED AFT EMERGENCY EXIT SIGN PER B737 AMM 33-51-01. OPS CK GOOD.SDR AALA202111220994Light · out of positionAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT SAYS WIRES HANGING DOWN FROM SEAT 19C. REPLACED BROKEN EMERGENCY EXIT LIGHT ASSEMBLY ON PASSENGER SEAT 19C PER AMM 33-51-19.SDR AALA202111223495Battery · fault messageAIRCRAFT WAS NOT GROUNDED: FORWARD EMERGENCY POWER SUPPLY UNIT BATTERY FAULT. REPLACED FORWARD EMERGENCY POWER SUPPLY UNIT (1OWL) BATTERY PER AMM 33-51-38.SDR AALA202111227249Switch · brokenAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY LIGHT GUARD SWITCH BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT GUARD SWITCH PER AMM 33-51-00.SDR SWIA2021112262669Light · arcedCOCKPIT FLOOD LIGHTS WENT INOP, SMOKE AND BURNING SMELL (FLIGHT 5974 - FILED CLOSED) TROUBLESHOOT COCKPIT FLOOD LIGHTS INOP, FOUND R/H AFT FLOOD LIGHT PANEL WITH SIGNS OF ARCHING AND BURN MARKS. REMOVED AND REPLACED R/H AFT MOST FLOOD INSTRUMENT LIGHT PASDR DALA2021112207176None · noneSHIP 689 2R EXIT SIGN CAME OFF ON TAXI IN. CORRECTIVE ACTION: RESECURED 2R EXIT SIGN, OPS CHK GOOD. (7085606)SDR AALA202111228449Battery Pack · faultyAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT L3 BATTERY FAULT. REPLACED BATTERY PACK PER AMM 33-51-38 .SDR AALA202111225643Cover · detachedAIRCRAFT WAS NOT GROUNDED: COVER OFF EXIT SIGN BY ROW 17. RE-SECURED EXIT SIGN COVER PER AMM 25-63-00.SDR AALA202111226457Lens · missingAIRCRAFT WAS NOT GROUNDED: CENTER AISLE OVERWING EMERGENCY EXIT LIGHT MISSING LENS. INSTALLED LIGHT LENS PER AMM 33-51-00.SDR WX0A2021112273880Epsu · failedEPSU 12WL BATTERY FAILED DURING CAPACITY CHECK / REMOVED AND INSTALLED NEW EPSU 12WL IAW AMM 33-51-38-000-002-A AND AMM 33-51-38-400-002-A"SDR WX0A2021112273879Epsu · failedEPSU 11WL BATTERY FAILED DURING CAPACITY CHECK / REMVOED AND INSTALLED NEW EPSU 11WL BATTERY IAW AMM 33-51-38-00-002-A AND AMM 33-51-38-400-002-A"SDR WX0A2021112273878Epsu · failedEPSU BATTERY (13WL) FAILED BITE TEST. / REPLACED EPSU BATTERY 13WL REF. AMM 33-51-38 PB 401. OP TEST GOOD AT THIS TIME."SDR WX0A2021112273877Epsu · failedEPSU BATTERIES FAIL CAPACITY TEST (10WL, 11WL, 12WL, 13WL) / REMOVED AND REPLACED EPSU BATTERIES REF. AMM 33-51-38 PB 401 OP TEST GOOD FOR 10WL, 11WL, 12WL"SDR SIMA20211120003None · noneRH AFT OVERWING EMERGENCY LIGHT INOP REF MEL 33-22 LG PG 4589780 ITEM 3-C/A-RAR OVERWING EMERGENCY LIGHT ASSY IAW AMM 33-50-10 OPC GOOD MEL RESTOREDSDR SIMA20211120001None · noneAFT CABIN EMERGENCY FLASHLIGHT HOLDER BROKEN.MEL 25-32 AUTH. #110172M-C ORIGINAL AML P. 4590238 ITEM #1.-C/A-RAR AFT CABIN EMERGENCY FLASHLIGHT ASSY.IAW AMM 33-50-16 OPC CHECK GOOD MEL 25-32 RESTOREDSDR SIMA20211120002None · noneAFT FLIGHT ATTENDANT EMERGENCY FLASHLIGHT INOP-C/A-FLIGHT CREW PLACARDED AFT EMERGENCY FLIGHT ATTENDENT FLASHLIGHT M PROCEDURES C/W AUTH 11029M-C REF 25-32MOC 630997
Back to JASC 3350