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 SWAA2019042532033Battery Pack · inoperativeRIGHT EMERGENCY LIGHT AT FUSELAGE STA 747 INOP. REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY PACK/POWER SUPPLY PER MM.SDR SWAA2019042532032Battery Pack · inoperativeEMERGENCY LIGHT AT SEAT ROW 17 ABC INOP. REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY PACK/POWER SUPPLY PER MM.SDR SWAA2019042532031Battery Pack · inoperativeLEFT EMERGENCY LIGHT AT FUSELAGE STA 747 INOP. REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY PACK/POWER SUPPLY PWER MM.SDR SWAA2019042532030Battery Pack · inoperativeEMERGENCY LIGHT AT SEAT ROW 14 ABC INOP. REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY PACK/POWER SUPPLY PER MM.SDR SWAA2019042532009Lens · looseOVERWING EMERGENCY EXIT LENS FELL DURING FLIGHT. SECURED OVERWING EXIT LENS PER AMMSDR SWAA2019042432007Power Supply · inoperativeRIGHT SIDE EMERG EXIT LOWER LIGHT LIGHT INOP / REPLACED EMERG LIGHT POWER SUPPLY AT R/H EMERG. EXIT IAW AMMSDR SWAA2019042431951Power Supply · inoperativeRIGHT SIDE EMERG EXIT EXTERIOR LIGHT INOP / REPLACED EMERG LIGHT POWER SUPPLY IAW AMMSDR SWAA2019042431950Power Supply · inoperativeLEFT SIDE EMERG EXIT LOWER LIGHT AND EXTERIOR LIGHT INOP / REPLACED EMERG. LIGHT POWER SUPPLY IAW AMMSDR DALA2019042432598Light · inoperativeSEAT 26D EMERGENCY EXIT PATH LIGHT DAMAGED. R&R LIGHT ASSY.SDR SWAA2019042331997Battery · inoperativeNUMEROUS EMERGENCY LIGHTS INOP ON THE EXTERIOR OF THE AIRCRAFT. / REMOVED AND REPLACED AFT LEFT HAND BATTERY PACK. ALL WORK DUE I/A/W MMSDR SWAA2019042331939Light · inoperativeRIGHT HAND LOWER FUSELAGE EMERGENCY LIGHT INOP AFT OF TRAILING EDGE FLAPS. REMOVED AND INSTALLED NEW LAMP AMM 33-51-04-960-801. OPS CHECK GOODSDR SWAA2019042331938Battery · inoperativeNUMEROUS EMERGENCY LIGHTS INOP IN THE CABIN. REMOVED AND REPLACED THE AFT RIGHT HAND POWER SUPPLY/BATTERY PACK.SDR MASA2018042211820Sign · inoperativeROW 14 D/F EMER EXIT SIGN 1 LT INOP. OPS CHECKED GOOD.SDR MASA2018042211819Battery Pack · inoperativeROW 13 CEILING AND EMER EXIT SIGNS INOPERATIVE. BATTERIES ALLOWED TO RE-CHARGE. OPS CK GOODSDR R61A201904220405Battery Pack · dischargedEMERGENCY LIGHTS INOP ENTIRE BACK HALF OF AIRCRAFT. CHARGED UP BATTERIES AND OPS CHECK IAW AMM 33-50-01. OPS CHECK GOOD.SDR VNAA201910021104Guard · not reportedREMOVED AND REPLACED FA EMERGENCY LIGHT SWITCH GUARD.Ï¿½ IAW CRJ 200 AMM 33-23-13-04. OPS CHECK GOOD.SDR YENA201904210221Battery · failedFT # 225, RT EMERG BATTERY 12WL FAILED. REPLACED RT EMERGENCY BATTERY 12WL. CKS OK.SDR AALA201904232003Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK, AFT LEFT DOOR EXTERIOR EMERGENCY LIGHT FAILED TO ILLUMINATE. MAINTENANCE REPLACED BATTERY PACK PER STANDARD PRACTICES AND PEFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201904232002Battery · no testAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK, EMERGENCY LIGHTS ON OVERHEAD CEILING PANELS, FROM STATION 871.5 TO STATION 1197+66, LEFT AISLE FAILED OT ILLUMINATE DURING VISUAL TEST. MAINTENANCE REPLACED EMERGENCY LIGHTING BATTERY PER STANDARD PRACTICES AND PERFOSDR AALA2019042329019Power Supply · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE FOUND INOP EPSU-EMERGENCY POWER SUPPLY UNIT 14WL IN PASSENGER CABIN. REPLACED EMERGENCY POWER SUPPLY UNIT (14WL) IN PASSENGER CABIN IAW AMM 33-51-38-400-001-A. BITE TEST IS OK.SDR HALA2019042320199Power Supply · inoperativeETOPS SIGNIFICATION - LEFT WING EMERGENCY EXIT LIGHT INOP // REMOVED AND REPLACED EMERGENCY LIGHT BATTERY POWER SUPPLY CONTROL MODULE. PER AMM 33-51-03. OPS CHECK OK. OK FOR SVCSDR SWAA2019042331975Cover · looseEXIT SIGN COVER ON THE OVERWING EXIT SIGN FO SIDE. FELL OFF AND WILL NOT RE-ATTACH. REMOVED AND REPLACED RIGHT OVERWING EXIT SIGN COVER PER AMM 33-51-01SDR SWAA2019042331934Sign · inoperativeGALLEY FWD EMERGENCY EXIT SIGN INOP. REPLACED EXIT SIGN ASSY OPS CK GOOD REF AMM 33-51-01SDR SWAA2019042331926Control Panel · faultyEMERGENCY EXIT LIGHTS ILLUMINATED WITH SWITCH IN ARMED POSITION AND AC POWER SUPPLIED / FOUND DEFECTIVE AFT F/A PANEL REMOVED AND REPLACED AFT F/A PANEL PER AMMSDR SWAA2019042331925Battery · inoperativeEMERGENCY EXIT LIGHTS ILLUMINATED WITH SWITCH IN ARMED POSITION AND AC POWER BEING SUPPLIED. REMOVED AND REPLACED A/C BATTERY PER AMM 24-31-11SDR SIMA201904221002Lamp · inoperativePAX DOOR EMERGENCY LIGHT INOP. PAX DOOR EMERGENCY LIGHT LAMP REMOVED AND REPLACED IAW AMM 33-50-10. OPS CHECKED GOOD.SDR DALA2019042202556Battery Pack · inoperativeEMERGENCY LIGHTS OVER THE AFT OVERWING EXIT IS INOPERATIVE. MAINTENANCE FOUND THE BATTERY PACK, B5-230, TO BE BAD. BATTERY PACK B5-230 WAS REPLACED PER B717 AMM 33-51. OPERATIONAL CHECK WAS GOOD. (LP #5041741)SDR DALA2019042202555Battery Pack · inoperativeTHE EMERGENCY LIGHTS AT STA 389 ARE INOPERATIVE. MAINTENANCE INSTALLED A SERVICEABLE BATTERY PACK PER B717 AMM 33-51-03. (LP #5456807)SDR DALA2019042202554Battery Pack · inoperativeDOOR 1L & 1R EMERGENCY EXIT IDENTIFIERS DO NOT LIGHT UP DURING TEST. MAINTENANCE REPLACED THE BATTERY PACK AND CHARGER (B5-118) FOR THE LEFT & RIGHT FWD DOOR EXIT SIGNS PER B717 AMM 33-51-03. PERFORMED OPERATIONAL TEST OF EMERGENCY LIGHTING SYSTEM PER B717 AMMSDR CALA2019042200628Battery · inoperativeEPSU 13WL SHOWS FAULT DURING EMERGENCY LIGHT S BITE TEST, REMOVED AND REPLACED EPSU AND BATTERY IAW AMM 33-51-38-000- 00 AND 33-51-38-400-001, 33-51-38-000-002 AND 33-51-38-400-002 O PS TEST GOOD.SDR R61A201904221404Power Supply · inoperativeEMERGENCY EXIT LIGHTED SIGN ABOVE L1 DOOR INOP. R&R EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01. R&R L1 DOOR CEILING EXIT LIGHT IAW AMM 33-50-05. OPS CHECK GOOD.SDR AALA201904221003Power Supply · inoperativeAIRCRAFT NOT GROUNDED: DURING PSCK FOUND 6 EMERGENCY LIGHTS OUT OF SERVICE(GALLEY G10), REMOVED AND REPLACED EMERGENCY LIGHTING CHARGER (POWER SUPPLY) AT DOOR 4R-AFT POSITION IAW AMM 33-51-06. CKD OK.SDR HNAA2019042200108Lamp · inoperativeNDIS 644 33-51 0005660 21APR19 SBY CLOSE
PAX SIDE HINGED MAIN DOOR EMERGENCY LIGHT IS INOP
29192 00 BRA
FACT 21APR19 09:24 SBY
R&R'ED PAX SIDE HINGED MAIN DOOR EMERGENCY LIGHT LAM
SDR FDEA2019042210874Lamp · inoperativeCOCKPIT OVERHEAD EMER LIGHT R/H LAMP INOP. R AND R'D LAMP AND TESTED PER AMM 33-52-04-2. OK FOR SERVICE.SDR MASA2019042111817Light · inoperative2 SECTIONS OF LUMINESCENT STRIP INOP. PLACED ON MEL.SDR DALA2019042532641Light · inoperativeEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:30D. CORRECTIVE ACTION: RESECURED MOUNT. (1039153)SDR YENA2019042400220Power Supply · no testDURING HEAVY MAINTENANCE, L/H MID EPSU FAILS PTP TEST; REMOVED & REPLACED EPSU IAW AMM 33-51-38. OPS CHECK SATISFACTORY IAW AMM 33-51-00-710-001. SUPPLEMENTAL INFORMATION TO FOLLOW.SDR IPXA2019042464199Power Supply · inoperativeINSPECTION TYPE:N/AEMER LT BAT 1 LO ANNUNCIATED ON PREFLIGHT. DEFERRED PER MEL # 33-50-2 DMI # M667365 ASSIGNED DMP 33-50-2 CW PLACARD INSTALLED OK FOR SERVICE.T/S PER FIM 33-51-00-101 FIG 104 BLOCKS 1, 2, 6, & 7. FOUND "EMER LT BAT 01 LO" R/R BATTERY POWESDR DALA2019042422600Lens · missingEMERGENCY LIGHT LENS @ DOOR R1 MISSING, INSTALLED R1 LIGHT LENSSDR AALA201904231001Battery Pack · inoperativeAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EPL ON SEATS 1H THROUGH 5H IS INOP. REPLACED BATTERY PACK AT M33094 POSITION IAW AMM 33-51-06. OPS TEST OK.SDR DALA2019042302588Handle · inoperativeSHIP 679 RIGHT EMERGENCY WING EXIT HANDLE LIGHTS INOP. CORRECTIVE ACTION: FOUND MISSING GND BETWEEN HANDLE LIGHT M10614 AND CONN D5678. RECONNECTED GND. OPS CK NORMAL. REF B757 WDM SUPPLEMENT 33-51-13 SH 2 OF 2. (5660674)SDR SIMA201904220004Wire · disconnectedEMERGENCY EXIT LIGHT ON THE AFT SIDE OF THE CENTER AISLE IS OUT. FOUND DISCONNECTED WIRE HARNESS. RESECURED CONNECTION. IAW AMM 33-50-11 OPS CHECK GOODSDR SIMA201904220003Light · inoperativeEMERGENCY LIGHT BETWEEN ROW 7 & 9 INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT STRIP FROM ROW 7 8 9 PER 33-50-12 OPS CK GOODSDR AALA2019042219005Battery Pack · no testAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EMERGENCY LIGHT BATTERY PACK M01695 FAILED CAP. TEST IAW WORK CARD 2908. ACCOMPLISHED DEEP CYCLE PROCEDURE IAW AMM 33-51-06, TASK 600-802. OPS CHECK NORMAL.SDR AALA201904219003Battery Pack · weakAIRCRAFT IN BASE VISIT: MAINTENANCE REPORTS EMERGENCY LIGHT BATTERY PACK MO1672 IN AFT GALLEY R/H CEILING FAILED CAPACITY TEST IAW CARD 2908. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK IN THE R/H AFT GALLEY IAW AMM 33-51-06-960-805. OPS CHECKED GOOD.SDR DALA2019042212541Battery Pack · inoperativeDURING INSPECTION FOUND 1L DOOR EMERG EXIT SIGN NOT ILLUMINATING. INSTALLED SERVICEABLE M1675 EMERG LIGHT BATTERY PER B737AMM33-51-06.SDR HNAA2019042200107Light · inoperativeNDIS 647 33-20 0007870 20APR19 RIC CLOSE
EXIT ROW EMERGENCY LIGHT ON RH SIDE WON'T ILLUMINATE
FACT 20APR19 09:51 RIC
REMOVED & REPLACED RH OVERWING EMERGENCY LIGHT IN RE
F TO AMM 33-50-13-000/400-801-A OK FOR SERVISDR DALA2019042102537Lens · incorrectDURING M CHECK, DOOR 2L FORWARD ESCAPE PATH LIGHT WRONG COLOR. DEFERRED PER MEL 33-50-05 UNTIL LIGHT CAN BE REPLACED. LP 5611475.SDR MASA201904211814Lamp · inoperativeTWO EXIT LIGHTS INOP AT ROW 13A. RELAMPEDSDR MASA201904211813Lamp · inoperativeROW 14 EXIT SIGN INOPERATIVE. RELAMPED
Back to JASC 3350