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 SWAA2019110738667Lamp · inoperativeLEFT HAND EMERGENCY EXIT LIGHT OUT. / RELAMPED IAW M/M 33-51-04.SDR DALA2019110766465Sign · damaged(LOG 6749914) EXIT SIGN ABOVE 22CD DAMAGED. REMOVED AND REPLACED LIGHT ASSY PER B737 AMM 33-51, OPS CHECKS OK.SDR AALA2019110769004Light · inoperativeAIRCRAFT WAS NOT GROUNDED: 1L DOOR EXTERIOR SLIDE LIGHT INOPERABLE. MAINTENANCE RELAMPED LIGHT PER AMM 33-51-06.SDR SWAA2019110638648Light · inoperativeR/H EMERGENCY EXIT DOOR, LOWER AFT LIGHT IS INOP. / RELAMPED R/H EMERGENCY EXIT DOOR, LOWER AFT LIGHT.SDR SWAA2019110638632Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATIONS M1672, M1674 AND M1675. / REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES AT LOCATIONS M1672, M1674 AND M1675 PER AMM 33-51-06.SDR SWAA2019110638629Light · inoperativeR/H OVER WING EXIT DOOR WINDOW LIGHT FWD EMERGENCY LIGHT IS OUT. / RELAMPED R/H OVERWING EXIT DOOR WINDOW LIGHT FWD EMERGENCY LIGHT AND PERFORMED GOOD TEST PER AMM 33-21-00-960-801.SDR AALA201911069015Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT ON OVERHEAD PANEL AT DOOR L4 INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK PER AMM 33-51-06.SDR SIMA20191105003Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED SERVICE DOOR EXTERANAL EMERGENCY LIGHT IAW EMB AMM 33-50-09-000-801 AND 33-50-09-400-801 OPS CHECK GOODSDR SIMA20191105001Power Supply · failedEMERG LT COME OM WHEN YOU UNARM IT TO OFF-C/A-REMOVED AND REPLACED BATTERY POWER SUPPLY 4 IAW ERJ140 AMM 33-50-04. NO FURTHER DEFECTS NOTEDSDR SIMA20191105002Charger · failedBOTH OVERWING EXTERNAL AFT EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED BULBS IAW EMB AMM 33-50-10-000-801-A AND 33-50-10-400-801-A NO FIX, T/S PER WM 33-50-50 SLAVED IN INVERTER IAW EMB AMM 33-50-11-400-801-A NO FIX, T/S FURTHER RAR #4 EMERGENCT BATTERY AND SDR SIMA20191105004Power Unit · inoperativeAFT OVERHEAD EMERGENCY LIGHT INOP.-C/A-REMOVED AND REPLACED EMERGINCY LIGHT POWER UNIT #3 IAW AMM 33-50-01 OPS CHECK GOOD IAW AMM 33-50-01.SDR HALA2019110600467Light · looseLAV A FLOOR LIGHT STRIP CAME LOOSE. // RE-SECURED EMERGENCY ESCAPE PATH FLOOR LIGHT STRIP AT LAV A OK
FOR SERVICE.SDR DALA2019110606423Light · disconnectedROW 20D CEILING EMERGENCY LIGHT INOPERATIVE. MAINTENANCE FOUND THE LIGHT ASSEMBLY DISCONNECTED. ONCE THE LIGHT WAS RECONNECTED THE OPERATION CHECKED GOOD REF B717 WDM 33-51 AND THE AIRCRAFT RETURNED TO SERVICE. (LP #6370942)SDR DALA2019120216984Cover · missingEXIT LIGHT PLASTIC COVER MISSING. REPLACED THE EXIT LIGHT PLASTIC COVER IAW AMM 33-51-01.SDR YENA2019110840640Battery Pack · no testFT # 225, JFK-TPA. EMERGENCY LIGHT BATTERY AT 11WL DID NOT PASS TEST; R & R EMER. LIGHT BATTERY 11WL IAW AMM 33-51-38. OPS CHK GOODSDR VNAA2019110641102Battery · dischargedALL 4 EMERGENCY BATTERIES NEED REPLACED DUE TO BEING LEFT ON. MAINTENANCE REMOVED AND REPLACED ALL 4 BATTERY PACKS OPS CHECK GOOD. ALL BATTERY P/N THE SAME S/N #2 104602 S/N #3 115010 S/N #4 125185SDR SWAA2019110638636Light · inoperativeRIGHT REAR SERVICE DOOR EMERGENCY EXIT LIGHT INOP. / RELAMPED THE RIGHT REAR SERVICE DOOR EMERGENCY EXIT LIGHT REF AMM 33-51-00.SDR SWAA2019110638625Cover · brokenRIGHT OVERWING EXIT LIGHT COVER BROKEN. / REPLACED COVER PER AMM 33-51-01.SDR DALA2019110606449Lens · unknown(LOG 1344970) DURING INSPECTION FOUND EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. REINSTALLED LIGHT LENSE CKS GOOD.SDR DALA2019110406447Battery · not reported(LOG 6398356) REPLACED BATTERY AT BATTERY CHARGER M1674 PER B737 AMM 35-51. OPS CKS GOOD.SDR DALA2019110606446Lens · damaged(LOG 1345765) DURING INSPECTION FOUND THRESHOLD LIGHT LENS / COVER DAMAGED. REPLACED LENS.SDR UIEA2019110205838Light · inoperativeMULTIPLE CABIN SEAT EMERGENCY LIGHTS INOP. (<P>RELAMPED MULTIPLE CABIN SEAT EMERGENCY LIGHTS, OPERATIONAL CHECK GOOD IAW AMM 33-51-12-962-002.</P>)SDR UIEA2019110305843Light · inoperativeMULTIPLE CABIN EMERGENCY FLOOR LIGHTS INOP. (<P>RELAMPED MULTIPLE CABIN EMERGENCY FLOOR LIGHTS. REMOVED AND REPLACED 1 EA LIGHT ASSY IAW AMM 33-51-12-962-002/162.</P>)SDR UIEA2019110305844Light · inoperativeMULTIPLE DOOR SILL EMERGENCY LIGHTS INOP. (<P>RELAMPED MULTIPLE EMERGENCY DOOR SILL LIGHT ASSY PER B747-400 AMM 33-51-05-962-031, OPS CHECK GOOD.</P>)SDR DALA2019110406425Cover · missingTHE CABIN CEILING EMERGENCY EXIT LIGHT IS MISSING AT ROW 22AB. FORWARDED TO MEL 33-51-01A AND THE PLACARD WAS INSTALLED. 06NOV19 LGA INSTALLED EMERGENCY EXIT LIGHT COVER AT ROW 22AB AS PER B717 AMM 33-51. CHECKS OK. MEL AND PLACARD REMOVED. (LP #5955947)SDR SWAA2019110538624Sign · unsecureMID CABIN EXIT SIGN ON CEILING FELL OFF. / REINSTALLED SIGN IAW AMM.SDR SWAA2019110538621Battery Pack · dischargedEMERGENCY AISLE LIGHTS BETWEEN ROW 9 AND 11 INOP. / R&R BATTERY PACK POSITION M1670 PER AMM5.SDR SWAA2019110538608Lens · missingR/H EMERGENCY EXIT LENS MISSING OVER WING. / INSTALLED LENS PER SIP.SDR SIMA20191104003Light · inoperativeLH SIDE CENTER FAIRING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED LH CENTER FAIRING EMERGENCY LIGHT IAW AMM 33-50-10 OPS CHK GOODSDR MASA2019110412120Light · inoperativeSVC DOOR EMER LT EXIT SIGN-2 BULBS INOP.SDR MASA2019110312119Light · inoperative12F LWR EXIT SIGN 1 BULB INOP. PLACED ON MELSDR MASA2019110312118Light · inoperativeROW 10 CEILING LVL EMER FLOOD LT INOP. PLACED ON MELSDR QXEA2019110400402Battery · dischargedOVERHEAD EMERGENCY LIGHT AT ROWS 14,15 INOP. REMOVED FROM SERVICE. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY AND BATTERY #3 PER E175 AMM 33-50-01-000-801-A, 33-50-01-000-802-A, 33-50-01-400-801-A, 33-50-01-400-802-A, OP TEST GOOD. AIRCRAFT RETURNED TO SDR VNAA2019110311102Cap · missingMX PLACED THE LIGHT ON MEL SUPPLEMENTAL INFORMATION: MEL 23-40-12 D ISSUED - MEL ACTIVE. FA EMG LIGHT INOP/MISSING. INSPECTED FA EMERGENCY LIGHT. REPLACED FWD CAP ON THE FA EMERGENCY EXIT LIGHT. MEL CLEARED.SDR YENA2019110730638Battery · failedDURING HEAVY MAINTENANCE, INOP DOOR FRAME EMERGENCY LIGHT RH AT AFT GALLEY AREA; REF AEROMAN N./R 2019-337155. REMOVED AND REPLACED EMERGENCY LIGHT RH (ELPU 6) AT AFT GALLEY AREA IAW E190 AMM 33-50-01-400-801-A OPS CHECK GOOD PER E190-33-50-01-710-801-A, E190 SDR REXA2019110731565Battery Pack · inoperativeDURING FIRST FLIGHT PREPARATIONS, FOUND INTERIOR AND EXTERIOR OVER WING AND FLOOR TRACK LIGHTS INOP
REMOVED AND REPLACED THE #2 AND #3 EMERGENCY LIGHT BATTERY PACKS IAW AMM 33-51-04. OPS CHECK GOODSDR AALA201911049016Light · looseAIRCRAFT IN BASE MAINTENANCE: R4 DOOR EMERGENCY LIGHT LOOSE IN MOUNT. MAINTENANCE REPLACED LIGHT PER AMM 33-51-17.SDR AALA201911039007Light · missingAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT ADJACENT 4L DOOR SLIDE BUSTLE WAS MISSING. MAINTENANCE REPLACED EXIT MARKER ADJACENT TO 4L DOOR PER A321 AMM 33-51-13.SDR DALA2019110306439Battery Pack · discharged(LOG 6585871) DURING INSPECTION FOUND FLOOR AISLE EMERGENCY LIGHTRS @ ROWS 18-23 INOPERATIVE. R&R BATTERY PACK AT LOC M1670. CKS GOOD. A/C OK FOR SVC. REF. B737 AMM 33-51.SDR SWAA2019110538623Sign · missingAFT GALLEY EXIT SIGN FIRST OFFICERS SIDE MISSING COVER. / R&R SIGN ASSEMBLY PER AMM.SDR N6WA2019110301Light · inoperativeFLOOR LEVEL ENTRY EMERGENCY FLOOD LIGHT INOP. DEFERRED PER MEL 33-51-01C-28 CAT C OC#70013589 AUTH BY MXC.SDR SWAA2019110438605Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK ASSEMBLIES WOULD NOT CHARGE AT M2816. / R&R BATTERY PACK PER AMM.SDR SWAA2019110438604Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK ASSEMBLIES WOULD NOT CHARGE AT M1676. / R&R BATTERY PACK PER AMM.SDR SWAA2019110438589Lens · brokenAFT L/H LAV EXTERNAL WALL EMERGENCY LIGHT LENS BROKEN / R&R LENS PER AMM.SDR SWAA2019110438578Light · inoperativeR2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR SWAA2019110438577Battery Pack · defectiveEMERGENCY LIGHT BATTERY PACK ASSEMBLIES WOULD NOT CHARGE AT M1672. / R&R BATTERY PACK PER AMM.SDR SWAA2019110438524Battery Pack · dischargedR1 DOOR SLIDE EMERGENCY LIGHT INOP. / R&R BATTERY PACK IAW AMM.SDR SWAA2019110438483Lens · looseAFT GALLEY EMERGENCY EXIT LENS LOOSE. / SECURED LIGHT ASSEMBLY PER MM.SDR HALA2019110400240Cids · malfunctionedEXITS SIGNS WILL NOT ILLUMINATED. RESET CIDS. LP 5859044SDR AALA201911049026Battery · dischargedAIRCRAFT IN BASE VISIT: CIDS OPERATIONAL TEST FAILED. REMOVED AND REPLACED CIDS BATTERY 12WL.
Back to JASC 3350