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 SIMA20171211003Battery Pack · inoperativeEMERGENCY EXIT LIGHTS OVER THE WINGS INOP-C/A-REMOVED AND REPLACED FUSE ON #4 EMERGENCY BATTERY IAW RADIANT CMM 25-60-03 AND EMB AMM 33-50-00.OPS TEST OF EMERGENCY LIGHTS GOOD.NO OTHER DEFECTS NOTED AT THIS TIME.SDR AALA201712129035Lens · detachedAIRCRAFT NOT GROUNDED. EMERGENCY LIGHT COVER ASSEMBLY HAS POPPED OFF OF DOOR 4L. REPLACED BROKEN EMERGENCY LIGHT COVER DOOR 4L.SDR AALA201712129034Light · malfunctionedAIRCRAFT NOT GROUNDED. AFT EMERGENCY EXIT LIGHTS ON WITH NORMAL POWER AND SWITCH IN ON POSITION. RESET EMERGENCY LIGHT SYSTEM PER TSM 24-00-00-810-818-A.SDR DALA2017121208528Lens · unsecureEMERGENCY EXIT SIGN COVER LOOSE AT DOOR 3R. RE-INSTALLED EXIT SIGN COVER. LP 0334083SDR DALA2017121208521Bulb · inoperativeSEAT 18D EMERGENCY LIGHT INOP. REPLACED BOLBE AND LIGHT ASSY NO HELP. FOUND EMERGENCY LIGHT DISCONNECTED. RECONNECTED LIGHT. OPS CK GOOD. (LP3019173)SDR AALA201712129022Light · damagedAIRCRAFT WAS NOT GROUNDED. DURING INTERIOR CABIN CHECK, RIGHT AFT EXIT LIGHT ASSEMBLY WAS FOUND DAMAGED. REPLACED AFT RIGHT EXIT LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK OK.SDR DALA2017121208519Battery Pack · inoperative(AIRCRAFT 652, L/P 3944151) EMERGENCY LIGHT FROM ROW 16-19 RT INOP. R/R M736 BATTERY PACK PER B757 AMM 33-51.SDR CALA2017121104401Bracket · deformedSEAT 46G EMERGENCY LIGHT LOOSE. FOUND BRACKET FOR LIGHT DEFORMED, SECURED THE BRACKET & OPS CHECKED OK.SDR CALA2017121104398Battery · failedRIGHT SIDE EMERGENCY BATTERY FAILED EMERGENCY SYSTEM OP CHECK. REPLACED RH BATTERY,EMERGENCY LIGHT SYSTEM PASSED CIDS SYSTEM CHECK.SDR CALA2017121104397Support Bracket · damagedEXIT LIGHT ROW 21DEF INOP REPLACED EMER SIDE WALL LIGHT SUPPORT BRACKET FOR LIGHT(90WL4)AT SEAT ROW 21DEF,OPS NORMAL. INSP INSTALLATION OF EMERGENCY LIGHTING OP CK OKSDR CALA2017121104396Lens · brokenBROKEN EMERGENCY LIGHT FWD BULKHEAD IN FRONT OF SEAT 1B REPLACED MISSING LENS COVER OPS CHK GOODSDR CALA2017121104394Battery Pack · inoperativeEXTERIOR EMERGENGY LIGHTS L548 AND L7 INOP. :REMOVED AND REPLACED EMERGENCY BATTERY PACK AND CHARGERSDR CALA2017121104393Lamp · inoperativeDOOR 4 RIGHT EXTERIOR EMERGENCY LIGHT INOP. REPLACED DOOR 4R SLIDE LIGHT LAMP, REFRENCE: B757-3 AMM TASK 33-51-06-962-001-002. OPERATIONAL TEST SATISFACTORY.SDR CALA2017121104392Lamp · looseDOOR 4R EXTERIOR EMERGENCY LIGHT INOP. FOUND LAMPS NOT INSERTED FULLY IN SOCKET. RE ADJUSTED. OPS CHK G OOD.SDR CALA2017121104391Lamp · looseDOOR 3R EXTERIOR EMERGENCY LIGHT INOP. FOUND LAMPS NOT INSERTED FULLY IN SOCKET. RE-ADJUSTED. OPS CHK G OOD.SDR CALA2017121104390Lamp · inoperativeROW 30 LFT OVRHD EMER EXIT LHT INOP PLACED ON MEL 3315A. TOMCQC REV PERFORMED RELAMPED OVRHD EMER EXIT LIGHT OK TO SERVICESDR CALA2017121104400Light · inoperativeDOOR 1R SLIDE LIGHT INOP. RELAMED AND CHECK OKSDR CALA2017121104399Light · inoperative1L SLIDE LT OUT RELAMPED, CHECKED GIRT BAR FITTING AREA, OPS NORMAL.SDR CALA2017121104395Light · inoperativeROW 39 SEAT EMERGENCY LIGHT INOP REPLACED LIGHT OPS OKSDR MASA2017121012826Lamp · inoperativeROW 6 OVHD EMERG FLOOD LIGHT INOP. RELAMPEDSDR IPXA2017121024352Lens · brokenINSPECTION TYPE:N/ALAVATORY FWD UPPER LIGHT ASSY HAS BROKEN LENS COVER. RELAMPED AND REPLACED LENS REF MM 33-51-00.SDR SWAA2017121518457Sign · looseMID CABIN AISLE EXIT SIGN LOOSE. / R&R EXIT SIGN ASSY PER MM.SDR HNAA2017121500389Power Supply · inoperativeNDIS 640 33-51 0013530 08DEC17 SBY CLOSE
FWD EMERGENCY EXIT LIGHT UNDER COCKPIT DOOR INOP.
FACT 08DEC17 13:29 SBY
SLAVED IN EMERGENCY EXIT LIGHT SIGN NO FIX. R&R EMER
GENCY BATT POWER SUPPLY 1 IAW AMM 33-50-04-000-SDR DALA2017121108610Light · inoperativeSHIP 1814 FLT CREW REPORTED DOOR 1L SLIDE ARM LIGHT INOP. CORRECTIVE ACTION: OPENED DOOR AND CHECKED PATHWAY. NO DEBRIS FOUND. ARMED DOOR 1L SLIDE. ALL IND NML. OK FOR CNT SVC. (3835186).SDR R61A201712100945Battery Pack · inoperativeAFT EMERGENCY EXIT LIGHT INOP. R&R #3 EMERGENCY LIGHT BATTERY IAW AMM 33-50-01. OPS CHECK GOOD.SDR AALA201712139001Bulb · inoperativeAIRCRAFT NOT GROUNDED. DOOR L4 ARM LIGHT INOPERATIVE. REMOVED AND REPLACED BULB AT L4 DOOR SLIDE. INDICATOR OPERATIONAL CHECK GOOD PER AMM 33-13-00.SDR I5EA2017121301Battery Pack · dischargedDISCREPANCY: OVERWING HATCH EMERGENCY LIGHT HAS SHORT ON TIME. CORRECTIVE ACTION: REMOVED AND REPLACED BATTERY CHARGE, P/N 2012-1, S/N 19688, AND BATTERY PACK, P/N 2013-1A, S/N 113276 AT STA. 598R, TEST GOOD IAW B737 AMM 33-51-51SDR AALA201712129051Light · inoperativeAIRCRAFT WAS NOT GROUNDED. SEAT 15F OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED EXIT LIGHT PER AMM 33-51-01. OPERATIONAL CHECK NORMAL.SDR SWAA2017121218373Sign · looseLT OVERWING EXIT SIGN LOOSE. SECURED SIGN PER SIP.SDR SIMA20171210004Battery Pack · failed#4 EMERGENCY BATTERY PACK IS DEAD.-C/A-REMOVED AND REPLACED #4 EMERGENCY BATTERY PACK IAW EMB-140 AMM 33-50-04, OPS CHECK GOOD.SDR AALA201712119043Bulb · inoperativeAIRCRAFT NOT GROUNDED. L4 DOOR ARM LIGHT INOPERATIVE. REPLACED BULB AT L4 DOOR SLIDE INDICATOR PER AMM 33-13-00.SDR AALA201712119041Light · inoperativeAIRCRAFT GROUNDED. SEAT 1E EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LIGHT ASSFEMBLY AT ROW 1E PER AMM 33-51-00.SDR REXA2017121001235Light · inoperativeEMERGENCY LIGHTS SOME BULBS ARE NOT WORKING
PERFORMED OPS TEST OF THE ACCENTS LIGHTS IAW CRJ900AMM 33-21-00 OPS TE
ST GOODSDR DALA2017121208516Lens · loose(AIRCRAFT 6803, L/P 0333558) EMERGENCY EXIT SIGN COVER LOOSE / LOCATIONS:607 / EMERGENCY EXIT SIGN COVER MISSING DOOR 4L / INTERIOR. INSPECTED CABIN. NO SIGN IS LOOSE OR MISSING.SDR AALA201712129025Bulb · inoperativeAIRCRAFT NOT GROUNDED. MID LAV EMERGENCY LIGHT COVER LIGHT INOPERATIVE. INSTALLED NEW EMERGENCY LIGHT COVER IN MID LAV. RELAMPED BULB IN HOUSING OPS CHECK GOODSDR AALA201712119052Light · detachedAIRCRAFT WAS NOT GROUNDED. AFT LEFT EMERGENCY EXIT LIGHT DETACHING. REPLACED AFT LEFT GALLEY SERVICE DOOR L-2 ENTRY EMERGENCY LIGHT ASSEMBLY PER MM 33-51-14.SDR AALA201712119021Lens · brokenAIRCRAFT WAS NOT GROUNDED. A/C LEFT NEAR AFT LAV FACING THE AISLE, EMERGENCY EXIT LIGHT BROKEN. REPLACED MISSING LENS.SDR ASAA2017121022832Bulb · inoperativeEMERGENCY LIGHT EXIT LOCATOR SIGN AT RIGHT AFT OVERWING EXIT HAS SEVERAL LAMPS INOP. GROUNDED - YES. RELAMPED AND TESTED PER B737-900 AMM 33-51-01-960-801 - OPS NORMAL.SDR SIMA20171210003Charger · inoperativeFOUND AFT EXTERIOR RH EMERGENCY LIGHT TO BE INOP DURING PS-1 CHECK-C/A-REMOVED AND REPLACED #4 BATTERY POWER SUPPLY IAW EMB 145 AMM 33-50-04-04. OPS CHECK GOODSDR SIMA20171210001Lamp · inoperativeRH WING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED THE RH WING EXTERNAL EMERGENCY LIGHT LAMP IAW EMB 145 AMM 33-50-10, OPS CHECK GOODSDR DALA2017121108497Lamp · inoperative(AIRCRAFT 5804, L/P 3590773) EXTERIOR EMERGENCY LIGHTS 3R, 3L, 4R, 4L, AND RT FUSELAGE OVERWING 3EA INOP. AT POWER UP, NONLY 2L AND 4R DOOR EMERG EXTERIOR LIGHTS INOP. INTERNAL LTS GOOD. RELAMPED 2L DOOR EXTERIOR EMERGENCY LIGHT PER B757 AMM 33-50. RELAMPED R4SDR YENA201712100991Light · inoperativeFT # 170, FLL-BOS. RED INCANDESCENT EMERGENCY ESCAPE PATH LIGHT MOUNTED ON 9D IS INOP; R & R EMERGENCY LIGHT ASSY ON SEAT 9D I.A.W M.M 33-51-19. OPS CHECK OK.SDR AALA201712119027Bulb · burned outAIRCRAFT NOT GROUNDED. EMERGENCY SEAT MOUNTED LIGHT INOP AT ROW 1A. RE-LAMPED EMERGENCY MOUNTED LIGHTS AT ROW 1A.SDR AALA201712119026Lens · brokenAIRCRAFT NOT GROUNDED. SEAT 3R EXIT SIGN BROKEN. REPACED LENS AT 3R "DOOR", OK FOR SERVICE.SDR DALA2017121008489Power Supply · inoperativeLEFT & RIGHT AFT OVERWING EXIT IDENTIFIERS FOUND TO BE INOPERATIVE. (5 LTS). MAINTENANCE REPLACED THE POWER SUPPLY AND BATTERY (B5-119) PER B717 AMM 33-51. ALL OPERATIONAL CHECKS WERE NORMAL. (LP #3885940)SDR AALA20171211004Power Supply · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT OPERATION TEST FAILED MESSAGE EMERGENCY POWER SUPPLY UNIT (11WL) EXIT LEFT. MAINTENANCE PERFORMED.SDR AALA201712139020Battery · dischargedAIRCRAFT WAS NOT GROUNDED. CIDS1 EMERGENCY POWER SUPPLY (15WL) MID L MESSAGE DISPLAYED. REPLACED POWER SUPPLY BATTERY PER AMM 33-51-38.SDR AALA20171210003Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT INOPERABLE AT ROW 4R. MAINTENANCE REPLACED EMERGENCY LIGHT PER AMM 33-51-00.SDR AALA201712129001Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT LEFT WINDOW INOPERATIVE. RELAMPED EXIT LIGHT AT LEFT WINDOW.SDR AALA20171211001Light · damagedAIRCRAFT WAS NOT GROUNDED. DURING INTERIOR CABIN CHECK FOUND RIGHT AFT EXIT LIGHT ASSEMBLY DAMAGED. REPLACED AFT RIGHT EXIT LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.
Back to JASC 3350