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 DALA2022021501004None · noneSHIP 687 EXIT SIGN COVER ABOVE 2R DOOR FELL OFF. CORRECTIVE ACTION: RESECURED 2R DOOR EXIT SIGN. (8395470)SDR DALA2022021501003None · noneSHIP 687 EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS:604. CORRECTIVE ACTION: RESECURED R-2 EMERGENCY EXIT COVER. (2120816)SDR DALA2022021500992None · noneFLOOR PROXIMITY EMERGENCY ESCAPE PATH MARKING SYSTEM AT 20ABC INOP. RE-SECURED CONNECTOR AT SEAT 20ABC. REF A321 AMM 33-52. OPS CK GOOD. (LP# 6172872)SDR AALA202202156672Light · misinstalledAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT PATH LIGHT ON LAVATORY D LOOSE/ LANDING ON WIRES. CORRECTLY INSTALLED EMERGENCY EXIT PATH LIGHT ON LAVATORY D PER AMM 33-51-18-400-001-A.SDR DXTA2022021456730Not Reported · not reportedCABIN EMERG LIGHT: THE LIGHT UNDER SEAT 10 AND THE EMERGENCY EXIT SIGN BY THE MAIN CABIN DOOR REMAIN ILLUMINATED WITH BATTERIES UNPLUGGED - " CORRECTIVE ACTION" C/Q CESSNA 680A EMERGENCY LIGHTING POWER SUPPLY BATTERY EXERCISE PROCEDURE IAW NJA TASK CARD TC-FLTSDR DXTA2022021456740Not Reported · not reportedEMERGENCY LIGHTING: DURING POWER UP EMERGENCY LIGHT TEST, THE EMERGENCY LIGHTS WOULD NOT SHUT OFF WHEN BATTERIES WERE SELECTED ON. ALL LOCATIONS REMAINED ILLUMINATED. "CORRECTIVE ACTION" ALL EMERGENCY LIGHT S TURNED ON AS REQUIRED AND TURN OFF AS REQUIRED. AS SDR AALA202202147422Battery · failedAIRCRAFT WAS GROUNDED: EMERGENCY POWER SUPPLY UNIT 14WL BATTERY FAILED CIDS SYSTEM 1 TEST. REPLACED BATTERY PER AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202202147018Bulb · out of adjustAIRCRAFT WAS GROUNDED: AFT MAIN AISLE OVERHEAD EXIT SIGN INOPERATIVE. ADJUSTED BULBS PER A319/1320 AMM 33-51-16.SDR SIMA20220213001None · noneAFT CABIN EMERGENCY FLASHLIGHT CLAMP BROKEN-C/A-RAR AFT CABIN EMERGENCY FLASHLIGHT CLAMP IAW EMB 145 CMM 25-60-14.SDR MASA2022021300047None · noneSERVICE DOOR EMER LIGHT INOP. PLACED ON MEL.SDR SWAA2022032271913Light · brokenBROKEN SIDEWALL PANEL 232YHW EMERGENCY LENS AT PASSENGER CABIN (1 EA) 2022-79982 / [01] REPLACED SIDEWALL PANEL 232YHW EMERGENCY LENS AT PASSENGER CABIN (1 EA) IAW B737-700 AMM M 33-51-01-960-802 STEP 3C (5)(D) AND 3C(10);[02] CORRECTED STEP 1.REPLACED SIDEWALSDR DALA2022022301198None · noneFOUND ROW 34 CEILING EMERGENCY LIGHT INOP. REMOVED AND REPLACED EPSU 12WL PER A320/321 AMM 33-51. (LP# 8482118)SDR AALA202202175126Fuse · blownAIRCRAFT IN BASE MAINTENANCE: EMERGENCY SEAT PROXIMITY LIGHTS INOPERATIVE AT RH ROWS 16-21. REPLACED FUSE WITH NEW IN M1671 BATTERY PACK CHARGER IAW AMM B737-NG 33-51-06, OPS CHECK GOOD.SDR DALA2022021601032Housing · damaged(LOG 8765101) DURING INSPECTION FOUND ROW 20 SEAT FORWARD EMERGENCY ESCAPE PATH LIGHT HOUSING DAMAGED. R/R FWD EMERGENCY ESCAPE PATH HOUSING PER CMM 25-22-56. AND B737 AMM 33-51.SDR DALA2022021501009None · noneSHIP 196 EMERGENCY EXIT SIGN COVER LOOSE / LOCATIONS: 2R, CORRECTIVE ACTION: SECURED EXIT LENS AT DOOR 608. OK FOR SVC PER B767 MM 33-51. (2119932)SDR HALA2022021500060None · noneSHIP 396 EXIT SIGN COVER AT 3R DOOR IS LOOSE .CORRECTIVE ACTION: RESECURED EXIT SIGN COVER AT 3R. (7721777)SDR AALA202202158039Light · brokenAIRCRAFT WAS NOT GROUNDED: LOOSE PART HANGING BELOW SEAT 21C. REPLACED BROKEN EMERGENCY LIGHT AISLE MARKER ASSEMBLY AT SEAT 21C AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA202202156597Light · detachedAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT NEAR 2L IS HANGING DOWN. REPAIRED LIGHT PANEL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR ASAA2022021237412Unknown · unknownEMERGENCY EXIT SIGN FROM CABIN CIELING FELL OFF IN FLIGHT. GROUNDED - YES. EMERGENCY EXIT SIGN COVER REINSTALLED REF B737-800 AMM 33-51-00.SDR SWAA2022021471733Light · inoperativeFWD LEFT HAND EMERGENCY LIGHT AFT OF L1 DOOR INOP ; / [01] RELAMPED FWD LEFT HAND EMERGENCY LIGHT AFT OF L1 DOOR OPS CK GOOD IAW AMM 33-51-04SDR SWAA2022021471764Lens · looseEMERGENCY EXIT SIGN MID CABIN FELL OFF ; / [01] REINSTALLED EMERGENCY EXIT SIGN LENS PER S.I.P.SDR SWAA2022021471801Light · inoperativeLH EMERGENCY EXIT EXTERIOR LIGHT INOP ; / [01] RELAMPED LH EXTERIOR EMERGENCY EXIT LIGHT. OPS CHECK GOOD. REF AMM 33-51-04SDR SWAA2022021471739Lens · missingOVERWING CEILING EMERGENCY LENS M.I.A. ; / [01] FOUND LEN?S RESECURRED PER S.I.P.SDR SWAA2022021471878Lens · delaminatedEMERGENCY EXIT LIGHT LENS BETWEEN 13/14DEF IS SEPARATING FROM OVERHEAD BIN BULLNOSE. ; EMERGENCY EXIT LIGHT LENS BETWEEN 1314DEF IS SEPARATING FROM OVERHEAD BIN BULLNOSE. / [01] INSTALLED EMERGENCY LITE COVER LENS BETWEEN SEATS 13/14 DEF PER AMM 33-51-03; [02]SDR SWAA2022021472168Battery Pack · inoperativeEMERGENCY LIGHTS ON M1673 INOP ; / [01] REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY PACK ON M1673 IAW AMM 33-51-06. OPS TEST OK.SDR AALA202202146249Housing · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT FALLING OFF AT SEAT 16C. REPLACED ESCAPE LIGHT HOUSING WITH NEW IAW CMM 25-23-67, OPS CHECK GOOD.SDR AALA202202146477Housing · detachedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT DETACHED AT SEAT 13C. SECURED LIGHT HOUSING IAW CMM 25-23-67, OPS CHECK GOOD.SDR AALA202202148778Light · out of positionAIRCRAFT WAS NOT GROUNDED: SEAT 27C EMERGENCY LIGHT LEFT ON SEAT. RE-SECURED LIGHT PER AMM 20-50-11.SDR AALA202202142773Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY LIGHT AT ROW 25 ABC INOPERATIVE. SECURED SEAT MOUNTED EMERGENCY LIGHT CONNECTOR. OPERATIONS CHECKS NORMAL PER AMM 33-51-19.SDR AALA202202140080Light · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY LIGHT AT ROW 24 ABC INOPERATIVE. SECURED SEAT MOUNTED EMERGENCY LIGHT CONNECTOR. OPERATIONS CHECK NORMAL PER AMM 33-51-19.`SDR AALA202202140041Light · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY LIGHT AT ROW 13 ABC INOPERATIVE. REPLACED SEAT MOUNT EMERGENCY LIGHT ASSEMBLY PER AMM 33-5119-000-003.SDR CALA2022021400370Battery · inoperativeFWD LEFT ESPU BATTERY FAULT (10WLA) REPLACE BATTERY REPLACED FWD EPSU BATTERY L1 DOOR IAW AMM 33-51- 38 AND OPS TEST GOOD IAW AMM 33-51-00. ACCOMPLISHED BY EMP#V9339 55 AT BFM ST AEROSPACE MOBILE. NR#0021991SDR SIMA20220212001None · noneAFT EMERGENCY FLASHLIGHT HOLDER BROKEN REF: LOGPAGE 4804373 ITEM 2 MEL 2532 - AUTH# 020124M-C -C/A-RAR AFT FLASHLIGHT HOLDER IAW EMB 145 AMM 33-50-16. OPS CHECK GOOD MEL RESTOREDSDR SIMA20220212002None · noneAFT CABIN EMERGENCY FLASHLIGHT CRADLE BROKEN-C/A- "TRANSFERRED TO AML PAGE 4768415 ITEM 2"SDR SIMA20220212004None · noneAFT CABIN EMERGENCY FLASHLIGHT CRADLE BROKEN-C/A- "TRANSFERRED TO AML PAGE 4839880 ITEM 1"SDR SIMA20220212003None · noneSERVICE DOOR EMERGENCY LIGHT INOP-C/A-RAR SERVICE DOOR EMERGENCY LIGHT LAMP IN REFERENCE WITH EMB AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPC GOOD. END.SDR MASA2022021200045None · nonePAX DOOR FLOOR LEVEL EXIT SIGN-2 BULBS INOP. PLACED ON MEL.SDR MASA2022021200044None · noneLH FWD EXT OVERWING EMER LIGHT LT INOP. PLACED ON MELSDR FDEA202202110749None · noneMDIS 115 33-50 6883 11FEB22 BOG DURING POSFLIGHT CHECK FOUND DOOR EMERGENCY LIGHT TOO DIM. FOUND WRONG LAMP INSTALLED. RELAMPED DOOR EMERGENCY LIGHT IAW AMM33-51-03-2 AND PROPER LAMP PART NUMBER IAW IPC 33-51-50-01.SDR SWAA2022022171545Battery Pack · inoperativeEMERGENCY LIGHTS AT CENTER CABIN ARE INOP M1675 BATTERY PACK FAULTY. / [01] REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK M1675 REF B737 AMM 33-51-06-960-805<BR>P/N OFF D717-01-100SMI S/N OFF 01060<BR>P/N ON D717-01-100SWA S/N ON 311562;[02] EMERGENCY LIGHSDR AALA202202158433Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: RIGHT OVERWING AFT EXIT DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED RIGHT OVERWING AFT EXIT DOOR EXTERIOR EMERGENCY LIGHTBULB PER AA B737NG AMM 33-51-04-960-801.SDR DALA2022021500994None · noneSHIP 685 DURING S/C FOUND CEILING EMERG LIGHT INOP AT 33D. CORRECTIVE ACTION: RPLCD BULB. SECURED WIRE TERMINAL AT GND STUD GD486-DC. TEST OPS CHK GOOD. REF. B757 WDM 33-51-14. (8241159)SDR DALA2022021500959None · noneSHIP 3303 SEAT 22H WHITE FLOOR PROXIMITY ESCAPE PATH LIGHT INOP. CORRECTIVE ACTION: FOUND PIN PULLED FROM CONNECTOR AT SEAT TRACK AT 22H. REINSTALLED PIN PER A330 AMM 25-21. (8724530)SDR DALA2022021500958None · noneSHIP 3303 SEAT 15H WHITE PROXIMITY FLOOR ESCAPE PATH LIGHT INOP, CORRECTIVE ACTION: FOUND PIN PULLED FROM CONNECTOR AT SEAT TRACK. REINSTALLED PIN PER A330 AMM 25-21. (8724529)SDR AALA202202151503Connector · unsecureAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT ROW 16 INOPERATIVE. SECURED LIGHT ASSEMBLY CONNECTOR FOR SEAT ROW 16 EMERGENCY LIGHTS AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00,SDR AALA202202158747Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 13C EMERGENCY LIGHT PANEL NEEDS RE ATTACHED. RE-ATTACHED EMERGENCY LIGHT PANEL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR DALA2022021500950None · noneCEILING PANEL 1 EMERCENCY LIGHT IS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY IN THE EMERGENCY LIGHT POWER SUPPLY B5-235. OPERATIONAL CHECK WAS GOOD REF B717 AMM 33-51. (LP #8405291)SDR SWAA2022021471500Lens · missingLOWER LEFT OVERWING EXIT INDICATOR LENS MISSING. ; / [01] INSTALLED LOWER LEFT OVERWING EXIT INDICATOR LENS PER A.M.M. 33-51-02.SDR SWAA2022021471231Cover · looseEXIT ROW LIGHT COVER LOOSE ; / [01] RESECURED EXIT ROW LIGHT COVER REF SIPSDR AALA202202141479Lens · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT COVER MISSING AT AFT LH SERVICE DOOR. REPLACED LENS WITH NEW, OPS CHECK GOOD.
Back to JASC 3350