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 SWAA2018072423728Light · inoperativeLT OVERWING EXIT LIGHT INOP. RELAMPED LAMP PER MM.SDR SWAA2018072423725Light · inoperativeLT EMERGENCY EXIT LIGHT BACKLIGHTING SIDEWALL LIGHT INOP. R&R LIGHT PER AMM.SDR SWAA2018072423701Light · inoperativeLT LIGHT ABOVE EMERGENCY EXIT DOOR INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018072423700Light · inoperativeRT EMERGENCY OVERWING EXIT SIDEWALL LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA2018072423694Light · inoperativeLT OVERWING EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR CALA2018072301682Battery · dischargedDURING EMER LT CAPACITY TEST, FOUND DOOR 3R FWD POWER PACK M33404 LOW VOLTAGE. DOOR 3R FWD POWER PACK M33404 BATTERY PACK REPLACED, O/P TEST CARRIED OUT FOUND NORMAL REF AMM 33-51-06-960-802 REV83.SDR CALA2018072301681Battery Pack · dischargedDURING EMER LT CAPACITY CHECK FOUND DOOR 3L AFT POWER PACK M33045 CANNOT LAST 15 MINUTES (P/N:ADD717-01-100). DOOR 3L AFT POWER PACK M33045 BATTERY PACK REPLACED, O/P TEST CARRIED OUT FOUND NORMAL REF AMM 33-51-06-960-802 REV83.SDR CALA2018072301680Battery Pack · dischargedDURING EMER LT CAPACITY TEST FOUND DOOR 4R AFT POWER PACK M33409 LOW VOLTAGE. DOOR 4R AFT POWER PACK M33409 BATTERY PACK REPLACED, O/P TEST CARRIED OUT FOUND NORMAL REF AMM 33-51-06-960-802 REV83.SDR CALA2018072301679Battery Pack · dischargedDURING EMER LT CAPACITY TEST FOUND DOOR 2R FWD POWER PACK M33097 LOW VOLTAGE. DOOR 2R FWD POWER PACK M33097 BATTERY PACK REPLACED, O/P TEST CARRIED OUT FOUND NORMAL REF AMM 33-51-06-960-802 REV83.SDR CALA2018072301678Lens · missingEXTERIOR EMERGENCY LIGHT LENS MISSING AFT OF DOOR 1L. M/E 29-3351-3-0044 IPC 33-51-04-06 INSTALLED LENS ASSY M/E 29-3351-3-0044, OPS CHECK NORMAL. REF AMM 33-51-04. ITEM IS NOT IDT OR RII, DOES NOT REQUIRE INSPECTION.SDR CALA2018072301677Battery Pack · dischargedDURING EMER LT CAPACITY TEST FOUND DOOR 3R AFT POWER PACK M33401 LOW VOLTAGE. DOOR 3R AFT POWER PACK M33401 BATTERY PACK REPLACED, O/P TEST CARRIED OUT FOUND NORMAL REF AMM 33-51-06-960-802 REV83.SDR AALA201807239029Epsu · no testTHE AIRCRAFT WAS NOT GROUNDED. FORWARD EPSU WILL NOT TEST. REPLACED FORWARD EPSU PER AMM 33-51-38. OPERATIONS CHECK GOOD.SDR AALA201807249004Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. DURING 2908 WORKCARD, ROW 15DEF EMERGENCY SIDEWALL LIGHT WENT OUT. REPLACED BATTERY PACK PAC5026 AT POSITION M1694 AS PER AMM 33-51-06. OPERATIONS CHECKS NORMAL.SDR AALA201807249003Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. DURING 2908 WORKCARD, RIGHT HAND SIDE OF AIRCRAFT ROWS 15-22 UPPER EMERGENCY LIGHTS WENT OUT. REPLACED BATTERY PACK PAC5026 AT POSITION M1695 AS PER AMM 33-51-06. OPERATIONS CHECKS NORMAL.SDR AALA201807249002Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. DURING 2908 WORKCARD, LEFT HAND SIDE OF AIRCRAFT ROWS 12-30 LOWER AND UPPER EMERGENCY LIGHTS WENT OUT. REPLACED BATTERY PACK PAC5026 POSITION M1671 AS PER AMM 33-51-06. OPERATIONS CHECKS NORMAL.SDR AALA201807249001Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. DURING 2908 WORKCARD, R2 DOOR EMERGENCY LIGHTS WENT OUT. REPLACED BATTERY PACK PAC5026 POSITION M1670 AS PER AMM 33-51-06. OPERATIONS CHECKS NORMAL.SDR SIMA20180721003Light · inoperativeEMERGENCY EXIT LIGHTS FOR LT OVER WING EXIT. TWO BULBS ARE BURNED OUT. REPLACED TWO BULBS FOR LT OVER WING EMERGENCY EXIT LIGHTS IN REFERENCE TO AMM 33-51-05. OPC GOOD.SDR MASA2018072113420Light · inoperativeROW 18 CEILING LVL EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR CALA2018082001815Charger · inoperativeDURING AN EMERGENCY LIGHT CAPACITY TEST, FOUND THE R2 DOOR AFT POWER PACK M33098 INOPERATIVE. THE POWER PACK BATTERY CHARGER WAS REPLACED, OPS TEST CARRIED OUT, FOUND NORMAL IAW AMM 33-51-06-960-803, REV 83.SDR AALA201807249025Ballast · inoperativeFORWARD EMERGENCY EXIT LIGHTS BALLAST WAS INOPERATIVE. COCKPIT EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BALLAST IAW MM 33-53-00. OPS CHECKED GOOD.SDR SWAA2018072423740Battery Pack · dischargedFORWARD EMERGENCY EXIT LIGHTS INOP AT LOCATION M1674. R&R BATTERY PACK PER AMM.SDR DALA2018072404667Lens · brokenON LANDING EXIT SIGN LENS COVER OVER DOOR 2R FELL & BROKE. REPLACED LENS PER AMM 33-51. LIGHT OPS OK.SDR DALA2018072404646Lens · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE, LOCATIONS:903. REPLACED LENS CKS GOOD.SDR DALA2018072404645Lens · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE, LOCATIONS:901. REPLACED LENS CKS GOOD.SDR DALA2018072404643Fuse · blownON SVC CHK FOUND SEAT 10 THRU 12 EMERG LIGHTS INOP. RECHECKED FUSES AT CHARGER M33098. FOUND 1 EA FUSE BLOWN. REPLACED, OPS CHKD ALL NOW NML PER AMM 33-51.SDR CALA2018072301676Battery Pack · dischargedDURING EMER LT CAPACITY TEST FOUND 3L FWD POWER PACK M33400 LOW VOLTAGE. THE DOOR 3L FWD POWER PACK M33400 BATTERY PACK REPLACED, O/P TEST CARRIED OUT FOUND NORMAL REF AMM 33-51-06-960-802 REV83.SDR CALA2018072301675Charger · inoperativeDURING EMER LT CAPACITY TEST FOUND DOOR 4L FWD POWER PACK BASE INOP. THE DOOR 4L FWD POWER PACK M33407 CHARGER REPLACED, O/P TEST CARRIED OUT FOUND NORMAL REF AMM 33-51-06-960-803 REV83.SDR CALA2018072301674Charger · inoperativeDURING EMER LT CAPACITY TEST FOUND DOOR 2R AFT POWER PACK M33098 INOP. THE DOOR 2R AFT POWER PACK M33098 BATTERY CHARGER REPLACED, O/P TEST CARRIED OUT FOUND NORMAL REF AMM 33-51-06-960-803 REV83.SDR CALA2018072301670Light · inoperativeON CHK FOUND 2EA EMERGENCY LT INOP. LOCATED LT SEAT 41D AND 46D 2EA EMERGENCY LIGHT ASSY. REPLACED AND LIGHT TESTED OK IAW AMM 33 -51-05. INSPECTION CARRIED OUT CHECK ''SATIS''.SDR AALA201807239037Cids · malfunctionedTHE EMERGENCY LIGHT DISAGREES WITH ARM POSITION SWITCH. ACCOMPLISHED A CIDS RESET IAW AMM 23-73-00. CHECKED OK.SDR AALA201807239034Lens · damagedL4 DOOR EMERGENCY LIGHT LENS WILL NOT STAY SECURE. REPLACED THE LENS. OK FOR SERVICE.SDR AALA201807239033Cover · missingSEAT 9D EMERGENCY EXIT LIGHT COVER MISSING. REPLACED THE COVER.SDR DALA2018072304611Battery Pack · dischargedTHE EMERGENCY OVERWING LIGHT WOULD NOT TURN OFF. REPLACED OVERWING LIGHT BATTERY PACK PER AMM 33-51-06.SDR DALA2018072304601Battery · dischargedEMERERGENCY CELLING LIGHTS ARE INOPERATIVE ROW 31 TO THE TAIL. B5-107 BATTERIES DEAD. THE BATTERIES WERE REPLACED PER AMM 33-53. OPERATIONAL CHECK WAS GOOD.SDR 29GA2018072300001Light · looseFLIGHT 0119 MHH/FLL REPORT: FA REPORTED THAT EMERGENCY ESCAPE LIGHT STRIPS ON THE FLOOR ARE COMING LOOSE. SECURED EMERGENCY ESCAPE LIGHT STRIP IAW 33-50-03 AMM.SDR SCNA20180720095Battery Pack · dischargedOVERHEAD BIN EMERGENCY LIGHTS FROM ROW 15DEF TO 22 DEF INOP. REPLACED EMERGENCY LIGHTS BATTERY PACK AT ROW 20DEF. OK FOR SERVICE.SDR VNAA2018071911101Light · inoperativeCABIN CEILING LEVEL EMERG FLOOD LIGHTS THIRD OVHD EMERGENCY FLOOD LIGHT INOP. DEFERRED PER MEL 33-51-1-2A CAT C. C/W REPLACEMENT OF THE CEILING EMERGENCY FLOOD LIGHT BULB IAW CRJ 700 AMM. OPS CHECK GOOD. NO DEFECTS NOTED AT THIS TIME. THIS CLEARS MELSDR SWAA2018072623837Lens · looseRT EXTERNAL FUSELAGE OVERWING ESCAPE LIGHT LENS LOOSE AT BS 651, WL 226. R&R LENS ASSEMBLY IAW AMM.SDR AALA2018072549045Battery Pack · no testBOTH LEFT AND RIGHT OVERWING EXIT LIGHTS GO OFF, 20 - 30 SECONDS INTO TEST. ALL OTHER EMERGENCY LIGHTS ON. REPLACED THE BATTERY CHARGERS M737 AND M734 IAW AMM 33-51-07. REPLACED THE BATTERY PACKS.SDR AALA2018072549044Charger · no testBOTH LEFT AND RIGHT OVERWING EXIT LIGHTS GO OFF, 20 - 30 SECONDS INTO TEST. ALL OTHER EMERGENCY LIGHTS ON. REPLACED BATTERY CHARGERS M737 AND M734 IAW AMM 33-51-07. REPLACED THE BATTERY PACKS. OPS CHECKED OK.SDR AALA2018072549043Battery Pack · no testBOTH LEFT AND RIGHT OVERWING EXIT LIGHTS GO OFF, 20 - 30 SECONDS INTO TEST. ALL OTHER EMERGENCY LIGHTS ON. REPLACED THE BATTERY CHARGERS M737 AND M734 IAW AMM 33-51-07. REPLACED THE BATTERY PACKS. OPS CHECKED OK.SDR AALA2018072549024Charger · no testBOTH LEFT AND RIGHT OVERWING EXIT LIGHTS GO OFF 20 - 30 SECONDS INTO TEST. ALL OTHER EMERGENCY LIGHTS ON. REPLACED THE BATTERY CHARGERS M737 AND M734 IAW AMM 33-51-07. REPLACED THE BATTERY PACKS.SDR AALA201807251002Battery Pack · inoperativeTHREE EMERGENCY LIGHTS AT THE AFT ENTRY WERE INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-53-00.SDR AALA201807251001Battery Pack · no testEMERGENCY LIGHT FAILED A DUAL FEED CHECK. REPLACED THE BATTERY PACK IAW AMM 33-60-98.SDR SWAA2018072423745Battery Pack · dischargedFORWARD CABIN EMERGENCY LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR REXA2018072400641Light · wornEMERGENCY PATH LIGHTING STRIPS IN FRONT OF WARDROBE AND FWD LAV ARE WORN. REMOVED AND REPLACED EPL WARDROBE AND FWD LAV IAW AMM 33-51-01-000-801 A021 AND 33-51-01-400-801-A021.SDR R61A2018072490823Light · crackedR2 DOOR FLOOR LEVEL EMERGENCY EXIT LIGHT CRACKED. R&R R2 DOOR FLOOR LEVEL EMERGENCY EXIT LIGHT ASSEMBLY IAW 25-23-11.SDR CALA2018072301669Sign · crackedCABIN DOOR 3L AFT EXIT IDENT LT BASE CRACKED (P/N:702409-1001). CABIN DOOR 3L AFT EXIT IDENT LT ASSEMBLY REPLACED, O/P TEST CARRIED OUT FOUND NORMAL REF AMM 33-51-01-960-802 REV83.SDR CALA2018072301668Light · crackedCABIN DOOR 1L AFT EXIT IDENT LT CRACKED. CABIN DOOR 1L AFT EXIT IDENT LT ASSEMBLY REPLACED, O/P TEST CARRIED OUT FOUND NORMAL REF AMM 33-51-01-960-802 REV83.SDR CALA2018072301667Light · crackedCABIN DOOR 4L AFT EXIT IDENT LT CRACKED. CABIN DOOR 4L AFT EXIT IDENT LT ASSY REPLACED, O/P TEST CARRIED OUT FOUND NORMAL REF AMM 33-51-01-960-802 REV83.
Back to JASC 3350