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 SWAA2020022641733Lamp · inoperativeAFT SERVICE DOOR EMERGENCY SLIDE LIGHT INOPERATIVE. / R&R LAMP PER AMM.SDR SWAA2020022641732Fuse · inoperativeRIGHT HAND OVERWING EMERGENCY EXIT LOCATOR SIGN INOPERATIVE . / R&R FUSE PER AMM.SDR SWAA2020022641724Bulb · inoperativeEMERGENCY EXIT LIGHT ASSEMBLIES L1070 HAD BULBS OUT. / R&R LIGHT BULBS IAW AMM.SDR HNAA2020022600077Light · inoperativeRH OVER THE WING EMERGENCY LIGHT WONT ILLUMINATE....FIX: REPLACED LIGHT IN REFERENCE TO EMB 145 AMM 33-50-10-000/400-801-A OPS CK GOOD.OK FOR SERVICESDR DALA2020022641424Battery Pack · inoperative(AIRCRAFT 7001, L/P 1499944) EMERGENCY LIGHTS INOP AT DOOR 4 LEFT. CORRECTIVE ACTION: REPLACED EMERGENCY BATTERY PACK - OPS CHECK GOOD.SDR REXA2020022620214Bulb · inoperativeEMER LIGHT AFT OF EXIT SIGN OUT
RELAMPED IAW CRJ200 AMM 33-51-16. OPS CHECK GOODSDR DALA2020022501401Sign · inoperativeSHIP 695 EMERGENCY EXIT SIGNS INOPERATIVE, PLASTIC PARTS FELL OFF BOTH SIDES -OVER WING / INTERIOR. CORRECTIVE ACTION: NO PLASTIC COVER MISSING. OR LOOSE. (1501011)SDR R61A2020022520255Power Supply · inoperativeEMERGENCY LIGHT BATTERY FAULT ON EICAS, SOME EMERGENCY LIGHTS INTERMITTENT ON CEILING AND R2 EXIT. R&R AFT RH INBOARD EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01.SDR R61A2020022554Power Supply · inoperativeR1 AND L2 EMERGENCY EXIT LIGHTS NOT WORKING. R&R RH AFT INBOARD EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01.SDR R61A2020022520254Power Supply · inoperativeR1 AND L2 EMERGENCY EXIT LIGHTS NOT WORKING. R&R RH AFT INBOARD EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01.SDR ASAA2020022432259Lamp · inoperativeEMERGENCY LT AT L2 DOOR INOP. GROUNDED - YES. RELAMPED & PERFORMED OPS TEST OF EMERGENCY LIGHTS. OPS TEST GOOD. REF B737-900 AMM 33-51-04.SDR SWAA2020022441631Lamp · inoperativeL/H OVERWING EMERGENCY LIGHT INOPERATIVE. / RELAMPED LIGHT IAW AMM.SDR QXEA2020022400115Guard · missingFWD FA EMERGENCY LIGHT SWITCH GUARD MISSING. REMOVED FROM SERVICE. INSTALLED SWITCH GUARD OVER FWD FA EMERGENCY LIGHT SWITCH REF Q400 AMM 33-51-05-000-801/400-801. OPS CHECK GOOD. RETURNED TO SERVICE.SDR QXEA2020022400114Light · missingPHOTO-LUMINESCENT STRIPPING MISSING BY FORWARD GALLEY. REMOVED FROM SERVICE. INSTALLED NEW PHOTO-LUMINESCENT EMERGENCY FLOOR-PATH STRIP REF. Q400 AMM TASK 33-51-16-400-801. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR DALA2020022401371Fuse · failed(AIRCRAFT 5814, L/P 7142378) EMERGENCY LIGHTS @ ROW'S 4, 5 AND 6 INOP. CORRECTIVE ACTION: REMOVED AND REPLACED 4 FUSES ON FWD PWER SUPPLY PER B757 AMM 33-51-07.SDR DALA2020022801490Test Button · brokenDURING AMDS CARD 3300-4220 EMG LIGHT BATTERY REPLACEMENT FOUND CHARGER CRADLE M 737 WITH BROKEN TEST BUTTON. REPLACED M737 BATTERY CHARGER CRADLE.SDR SWAA2020022841943Cover · missingL/H OVERWING EXIT LIGHT COVER CAME OFF. / SECURED COVER PER AMM.SDR SWAA2020022654669Lamp · inoperativeEMERGENCY EXIT LIGHT JUST AFT OF AFT SERVICE DOOR INOPERATIVE. / RELAMPED LIGHT PER AMM.SDR DALA2020022541392Fuse · inoperativeEMERGENCY EXIT LIGHTS ROWS 32FG TO 41FG ARE INOPERATIVE. REPLACED BATTERY PACK FUSE. SYSTEM OPERATION IS NORMAL.SDR YENA2020022510195Battery · failedFT # 824, MCO-DCA. DURING OPE CHECK OF EMERGENCY LIGHTS FOUND RH OVERWING FAIRING EMRG LIGHTS INOP; R & R MID LH EMERGENCY LIGHT POWER UNIT. OPS CHECK GOOD REF AMM 33-50-01SDR FDEA202002210369Test Switch · inoperativeALL EMERGENCY LIGHTS INOP ON PREFLIGHT R&R'D EMERGENCY LIGHT TEST SW. ( S10292) I.A.W. SWP MANUAL. OPS CHECK GOOD PER MM 33-51-00-5. CLEARED MEL.SDR CALA2020022400503Battery · dischargedB777-33-3-7019 - R3 DR EMER LT BATTERY PACK M33401 CAPACITY CHECK FAIL.REF NR LP 9130312 R3 DR EMER BATTERY PACK REPLACED AND INSTALLATION TEST CARRIED O UT RESULT NORMAL IAW AMM 33-51-06 ADD EMP:V920591 IDT BY HX215617,APPROVEDSDR CALA2020022400502Battery · dischargedB777-33-3-7019 - R3 DR EMER LT BATTERY PACK M33404 CAPACITY CHECK FAIL.REF NR LP 9130313 R3 DR EMER BATTERY PACK REPLACED AND INSTALLATION TEST CARRIED OUT RESULT NORMAL IAW AMM 33-51-06 ADD EMP:V920591 IDT BY HX215617,APPROVEDSDR CALA2020022400501Battery Pack · dischargedB777-33-3-7031 DR R3 M33401 EMER LIGHT POWER SUPPLY BATTERY PACK CAPACITY LOW REF NR LP 9130152 DR R3 M33401 EMER LIGHT POWER SUPPLY BATTERY PACK REPLACED AND T ESTED NORMAL AS PER AMM 33-51-06 ADD EMP:V898181 IDT INSPECTION OKSDR CALA2020022400500Battery Pack · dischargedB777-33-3-7019 - R2 DR EMER LT BATTERY PACK M33097 CAPACITY CHEC K FAIL.REF NR LP 9130311 R2 DR EMER BATTERY CHARGER REPLACED AND INSTALLATION TEST CARRIED OUT RESULT NORMAL IAW AMM 33-51-06 ADD EMP:V920591 IDT BY HX215617,APPROVEDSDR CALA2020022400499Battery Pack · dischargedB777-33-3-7031 DR L2 EMER LIGHT POWER SUPPLY M33099 BATTERY PACK CAPACITY LOW REF NR LP 9130153 DR L2 EMER LIGHT POWER SUPPLY M33099 BATTERY PACK REPLACED AND T ESTED NORMAL AS PER AMM 33-51-06.SDR CALA2020022400498Battery Pack · dischargedB777-33-3-7031 DR R1 EMER LIGHT POWER SUPPLY M33094 BATTERY PACK CAPACITY LOW REF NR L/P 9130151 DR R1 EMER LIGHT POWER SUPPLY M33094 BATTERY PACK REPLACED AND T ESTED NORMAL AS PER AMM 33-51-06.SDR CALA2020022400497Battery Pack · no testSCEPTRE ENTRY ONLY REF. 2675N219 EMERGENCY LIGHTING BATTERY PACK M1673 FAIL TEST. REF BY PEMCO NR 2675N1483 REPLACED BATTERY PACK M1673 IAW B737 AMM 33-51-06 OPS CKS GOOD.SDR CALA2020022400496Battery Pack · dischargedB777-33-3-7031 DR R3 M33404 EMER LIGHT POWER SUPPLY BATTERY CAPA CITY LOW REF NR LP 9130154 DR R3 M33404 EMER LIGHT POWER SUPPLY CHARGER BATTERY REPLACED AN D TESTED NORMAL AS PER AMM 33-51-06SDR AALA202002249019Light · unsecureAIRCRAFT WAS NOT GROUNDED: 1R SLIDE LIGHT WAS MISSING. MAINTENANCE RELAMPED AND SECURE 1R SLIDE LIGHT AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 25-66-00.SDR AALA202002249009Battery · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY POWER SUPPLY UNIT BATTERY INOPERABLE. REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY 11WL PER AMM 33-51-38-400-802-A.SDR AALA202002249008Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: AFT LEFT DOOR, FORWARD LOWER EMERGENCY LIGHT HAD LEFT SIDE OF SIGN INOPERABLE. REPLACED FORWARD LOWER EMERGENCY LIGHT PER AMM 33-50-15.SDR AALA202002249003Battery · no testAIRCRAFT WAS NOT GROUNDED: EPAS BATTERY TEST INDICATOR LIGHT DOES NOT COME ON AT DOOR 2R. MAINTENANCE REPLACED BACKUP BATTERY PER AMM 52-11-20 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 52-11-20-700-803-002.SDR SWAA2020022441656Power Supply · inoperativeAISLE EMERGENCY ESCAPE LIGHTS INOPERATIVE AT ROWS 9ABC AND 12ABC. / R&R POWER SUPPLY AND BATTERY PACK AT STA 727C + 3 IAW AMM.SDR SWAA2020022441651Charger · inoperativeRIGHT OVERWING EXIT LIGHT INOPERATIVE. / R&R BATTERY CHARGER PER AMM.SDR SWAA2020022441649Battery Pack · inoperativeAISLE EMERGENCY ESCAPE LIGHTS INOPERATIVE AT ROWS 9ABC AND 12ABC. / R&R POWER SUPPLY AND BATTERY PACK AT STA 727C + 3 IAW AMM.SDR SWAA2020022441639Lens · brokenEXIT SIGN NEAR FORWARD ENTRY DOOR BROKEN / REATTACHED LIGHT LENS PER AMM.SDR SWAA2020022441637Cover · unsecureCENTER CABIN EXIT SIGN COVER CAME OFF. / RESECURED COVER PER SIP.SDR SWAA2020022441635Lamp · inoperativeFORWARD SERVICE DOOR EMERGENCY EGRESS LIGHT INOPERATIVE. / RELAMPED LIGHT IAW AMM.SDR SWAA2020022441632Light · inoperativeRIGHT FORWARD PHOTOLUMINESCENT FLOOR STRIP WOULD NOT ILLUMINATE. / R&R PHOTOLUMINESCENT FLOOR STRIP I/A/W MM.SDR WX0A2020022473478Light · inoperativeEMERGENCY EXIT LIGHT DAMAGED AND REMOVED / REPLACED R/H FWD EMERGENCY EXIT LIGHT"SDR DALA2020022431362Light · inoperative(LOG 6189464) DURING INSPECTION FOUND SEAT MOUNTED FLOOR PROXIMITY LIGHT INOPERATIVE AT 13D. FOUND MOLEX PLUG AT 13D DISCONNECTED, RE-CONNECTED. OPS CHECK OK.SDR DALA2020022411361Battery Pack · inoperative(LOG 6669825) DURING INSPECTION FOUND EMERGENCY LIGHTS INOP AT L2 DOOR AND GALLEY. REMOVED AND REPLACED THE EMERGENCY LIGHT BATTERY PACK AT M1673. OPS NML REF B737 AMM 33-51.SDR DALA2020022401345Power Supply · inoperativeTHE COCKPIT EMERGENCY LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT PWR SUPPLY [B5-123] REF B-717 AMM 33-51. OPERATIONAL TEST WAS GOOD. OK FOR SERVICE. (LP #1499012)SDR FDEA202002210365Switch · malfunctionedDURING PREFLIGHT EMER LIGHTS EICAS REMAINED ILLUMINATED AFTER SWITCH TO GUARDED POSITION. CYCLED EMERGENCY LIGHTS SWITCH PER B777 FIM ATA 33-51-00-2. OK FOR SERVICE.SDR SIMA20200221001Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT LAMP IAW EMB 33-50-10-000-801-A AND 33-50-10-400-801-A. OPC GOOD. END.SDR DALA2020022501407Light · inoperativeSHIP 3827 DURING SVC CHECK FOUND SEAT MOUNTED PROXIMITY LIGHT INOP AT 5C . CORRECTIVE ACTION: REMOVED AND REPLACED SEAT MOUNTED FLOOR PROXIMITY LIGHT ASSY PER B737 AMM 33-51. OPS CHECK GOOD. (6497420).SDR YENA2020022400194Battery · no testFT # 391, BOS-TPA. EMERGENCY LIGHT TEST FAILED; R & R EMERGENCY LIGHT BATTERY AT FIN# 11WL PER AMM 33-51-38SDR AALA202002249021Lens · missingAIRCRAFT WAS NOT GROUNDED: DURING CABIN INSPECTION, FOUND R1 DOOR EXIT LIGHT COVER MISSING. MAINTENANCE REPLACED R1 DOOR EMERGENCY LIGHT PER AMM 33-51-01.SDR SWAA2020022441660Battery · no testEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATIONS M1675. / R&R EMERGENCY LIGHT BATTERIES PER AMM.
Back to JASC 3350