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 HNAA2021081000354Light · inoperativeAFT CEILING EMERGENCY LIGHT INOPERATIVE. REMOVED ROW 12 CEILING LIGHT COVER PANEL AND ROW 12CEILING PANEL. R&R LIGHT ASSY IAW AMM 33-50-15-04 AND INSTALLED THE CEILING PANEL AND CEILING LIGHT COVER PANEL USING RETAINED HARDWARE.SDR HALA2021080900095Battery Pack · inoperativeEMER EQ - OUTSIDE EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED OVERWING EMERGENCY EVACUATION BATTERY PER AMM 33-51-06. OPS CHK GOOD. OK FOR SERVICE.SDR DALA2021080904516Light · detachedSHIP 3220 EMERGENCY LIGHT AT 11D FELL OFF. CORRECTIVE ACTION: RESECURED. (7765302)SDR AALA202108098666Cover · detachedAIRCRAFT WAS GROUNDED: SEAT 33C ESCAPE PATH LIGHT COVER IS DETACHED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202108096217Light · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT 22C EMERGENCY EXIT LIGHT INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202108090365Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY PATH LIGHT AT SEAT 20 ABC BASE BROKEN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202108096531Lens · detachedAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT LENS AT 2R DOOR FELL OUT. REPLACED LENS.SDR AALA202108092644Cover · missingAIRCRAFT WAS NOT GROUNDED: EXIT SIGN OVER L1 DOOR MISSING COVER. REPLACED SIGN PER AMM 33-51-01.SDR AALA202108091986Cover · detachedAIRCRAFT WAS NOT GROUNDED: UNDER SEAT 19E IS AN EMERGENCY PATH LIGHTING PLASTIC COVER HANGING. REINSTALLED COVER PER AMM 33-51-18.SDR WX0A2021080973806Battery · not reportedALL 4 EPSU BATTERIES REQ REPLACEMENT / R&R 4 CABIN EPSU BATTERIES PER AMM 33-51-38 PB 401 OPS CHECK GOOD"SDR SIMA202108098001Lamp · inoperativeRH OVERWING EMERGENCY LIGHT INOP-C/A-RAR RH OVERWING EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPS CHECKED GOOD. END.SDR SWAA2021091404215Lens · looseOVHD BULLNOSE EMERGENCY LIGHT LENSES NOT SECURED AT ROWS 8DEF AND 22DEF ; / [01] REMOVED AND REPLACED EMERGENCY LIGHT LENSES AT ROWS 8DEF AND 22DEF PER AMM 33-51-03.; [02] INSTALLATION INSPECTION C/W.SDR ASAA2021080735647Cover · detachedWHILE WORKING TASK CARD 78233002 FOUND CENTER AISLE CEILING EMERGENCY EXIT LIGHT MISSING ACCESS COVER PANEL. GROUNDED - YES. INSTALLED NEW ACCESS COVER TO EMERGENCY EXIT CEILING PANEL. REF B737-900 IPC 33-51-01.SDR AALA202108233992Housing · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT HOUSING DAMAGED AT SEAT 13C. REPLACED LIGHT HOUSING WITH NEW IAW AMM 33-51-11, OPS CHECK GOOD.SDR YENA2021081700520Power Supply · faultedDURING HEAVY MAINTENANCE, EPSU 12WL SHOWS UNIT FAULT; PERFORMED TSM 33-51-00-810-A. R & R EPSU 12WL.IAW AMM 33-51-38-400-001-A.SDR AALA202108165790Light · damagedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT AT SEAT 13C DAMAGED. REPLACED LIGHT ASSEMBLY PER CMM 25-23-67.SDR AALA202108161119Light · damagedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT AT SEAT 10C DAMAGED. REPLACED LIGHT ASSEMBLY PER CMM 25-23-67.SDR AALA202108113992Housing · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT HOUSING DAMAGED AT SEAT 13C. (OPEN)SDR SWAA2021081104204Sign · missingCABIN OVERHEAD EXIT SIGN MISSING ; / [01] REPLACED OVERHEAD EXIT SIGN PER B737MM 33-51-01SDR SWAA2021081104280Light · faultedEMERGENCY LIGHT RH ABOVE FWD CARGO DOOR INOP ; 2021-311869 / [01] PERFORMED VISUAL INSPECTION OF THE LIGHT ABOVE FWD CARGO DOOR AND THE LIGHT IN THIS LOCATION IS THE WING ILLUMINATION LIGHT; NOT THE EMERGENCY LIGHT; AND PERFORMED OPERATIONAL TEST OF THE WING ISDR SWAA2021081104773Lamp · inoperativeLH EMERGENCY EXIT BULLNOSE LIGHT @ ROW 13 ABC INOP ; / [01] RELAMPED EMERGENCY EXIT AISLE LIGHT REF AMM 33-51-03SDR SWAA2021081105016Battery Pack · inoperativeMID CABIN L/H EMERGENCY LIGHTS INOP (4); AND (1) MID EXTERIOR EMERGENCY LIGHT INOP / ACCOMPLISHED FIM 33-50 TASK 801. EMERGENCY BATTERY PACK M1670 NOT HOLDING CHARGE. REMOVED AND REPLACED M1670 EMERGENCY BATTERY PACK. EMERGENCY LIGHTS NOW OPS CHECK GOOD.SDR SWAA2021081105048Lens · missingCOVER LENS FOR CENTER AISLE OVERWING EXIT LIGHTS FELL OFF. / REINSTALLED EXIT SIGN LENS PER S.I.P. REF 33-51-01SDR DXTA2021080946640Battery · inoperativeFLOOR EMERG EXIT LIGHT: ALL RED EMERGENCY LIGHTS BELOW SEAT 12 INOP FLOOR EMERG EXIT LIGHT: ALL WHITE EMERGENCY LIGHTS ON BOTTOM OF SEAT 10 INOP // SIGNOFF// GAINED ACCESS TO AIRCRAFT AND APPLIED POWER VERIFIED CABIN FLOORPATH WAY LIGHTS ARE INOP AT SEATS 10SDR AALA202108095790Light · damagedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT AT SEAT 13C DAMAGED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202108091119Light · damagedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT AT SEAT 10C DAMAGED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR CALA2021080901298Battery · dischargedEMERGENCY LIGHTS ON SEAT ROWS 7-14 L/H AND R/H INOP. SUPPORT TASK NSA EMX N/R 00135, HANGER N/R 5866693.SDR CALA2021080901297Battery · dischargedL2 DOOR EMERGENCY EXIT SIGNS INOP. SUPPORT TASK NSA EMX N/R 00136, HANGER N/R 5866694SDR DALA2021080904512Battery Pack · dischargedMAINTENANCE FOUND THAT THE B5235 EMERGENCY BATTERY PACK WAS DEAD. THE B5235 EMERGENCY BATTERY PACK WAS REPLACED. OPERATIONAL CHECK WAS GOOD REF B717 AMM 33-51. (LP #7930220 )SDR SIMA202108087002Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOP-C/A-RAR SERVICE DOOR EMERGENCT LIGHT LAMP IAW EMB AMM 33-50-09-000-801-A AND 33-50-09-400-801-A. OPC GOOD. END.SDR MASA2021080700179Bulb · inoperativeGALLEY DOOR TOP EXIT SIGN 2 BULBS INOP
PLACED ON MELSDR YENA2021081100507Battery · no testFLT 188, SEA-BOS. EPSU (13WL) BATTERY IN NEED OF REPLACEMENT; R & R EMERGENCY POWER SUPPLY UNIT BATTERY (13WL) PER T/C A320-33-51-00-710-003 & AMM 33-51-38-400-002-ASDR YENA2021081100506Battery · no testFLT 188, SEA-BOS. EPSU ( 12WL) BATTERY IN NEED OF REPLACEMENT. R & R EMERGENCY POWER SUPPLY UNIT BATTERY (12WL) PER T/C A320-33-51-00-710-003 & AMM 33-51-38-400-002-ASDR YENA2021081100505Battery · no testFLT 188, SEA-BOS. (11 WL ) EPSU BATTERY IN NEED OF REPLACEMENT; R & R EMERGENCY POWER SUPPLY UNIT BATTERY (11WL) PER T/C A320-33-51-00-710-003 & AMM 33-51-38-400-002-ASDR DALA2021081004583Sign · detachedSHIP 6805 2L EXIT SIGN TORN OFF. CORRECTIVE ACTION: REINSTALLED SIGN. NO DAMAGE NOTED. (7909925)SDR AALA202108092144Lens · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN IN AISLE BY SEAT 4J COVER CAME OFF. REATTACHED LENS PER AMM 33-51-01.SDR SIMA20210806001Bulb · inoperativeRH OVERWING LATERAL PANEL EMERGENCY LIGHT INOP.-C/A-RAR RH OVERWING LATERAL PANEL EMERGENCY LIGHT BULB IAW AMM 33-50-10. OPC GOOD.SDR AALA202108083427Light · missingAIRCRAFT WAS GROUNDED: EMERGENCY SEAT LIGHT AT 9D MISSING. INSTALLED EMERGENCY LIGHT AT SEAT 9D AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-19.SDR SWAA2021091404400Lens · crackedCRACK EMERGENCY LIGHT LENS POSITION 1; 3 ; 4; 5; 6; 7; 8; AND 11 LT SIDE AT PASSENGER CABIN ; 2021-342332 / [01] REPLACED EMERGENCY LIGHT LENS POSITION 1; 3 ; 4; 5; 6; 7; 8; AND 11 LT SIDE AT PASSENGER CABIN IAW B737-700 AMM 3351-03-960-801; [02] TASK COMPLETESDR SWAA2021091404401Lens · crackedCRACK EMERGENCY LIGHT LENS POSITION 5;7;8;10 RT SIDE AT PASSENGER CABIN (4 EA) ; 2021-342343 / [01] REPLACED EMERGENCY LIGHT LENS POSITION 5;7;8;10 RT SIDE AT PASSENGER CABIN (4 EA) IAW AMM 33-51-03-960-801 STEP 2.D (1); (C).; [02] REPLACED EMERGENCY LIGHT LENSDR FDEA202108051998Bulb · inoperativeEMERGENCY LIGHT DOOR 1L (SLIDE GND ILLUMINATION LT) INOP BULB REPLACED ACC AMM 33-51-06-2-1 REV 124.17. OPS TEST SATIS.SDR DALA2021080904546Lens · looseSHIP 5803 EMERGENCY EXIT SIGN COVER LOOSE. CORRECTIVE ACTION: REINSTALLED AND SECURED EXIT SIGN COVER OPS CHECKED GOOD. (1900285)SDR AALA202108098401Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY AISLE LIGHT BROKEN AT SEAT 8C. SECURED LIGHT ASSEMBLY IAW AMM 33-51-03, OPS CHECK GOOD.SDR AALA202108090608Shroud · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT DETACHED AT SEAT 15ABC. REPLACED SHROUD ASSEMBLY WITH NEW IAW CMM 25-23-67, OPS CHECK GOOD.SDR SWAA2021080904893Fuse · burned outOVERWING EXIT ON RIGHT SIDE EXIT LIGHT IS BURNT OUT (COVE LIGHT) ; / [01] VERIFIED RH EMERG EXIT COVE LIGHT (SIDEWALL LIGHT IS INOP)<BR>OK TO CONTINUE PER MEL 33-2-03; SP 1B; AUTH # 21616; [02] REMOVED AND REPLACED FUSE ALSO RE-LAMPED PER AMM 33-21-00SDR SWAA2021080903973Lens · missingROW 17ABC WHITE EMERGENCY EXIT LITE LENSE IS MISSING ; / [01] OK TO CONT. PER MEL 33-15-02.; [02] REF LOG PAGE 1667751. RE-INSTALLED ROW 17 ABC EMERGENCY LIGHT LENSE IAW AMM 33-51-03.SDR DXTA2021080646500Battery · defectiveCABIN EMERG LIGHT: ALL CABIN EMERGENCY LIGHTS FLICKERING DURING FLIGHT WITH SWITCH IN ARM POSITION. THEY ALSO FLICKERED WITH SWITCH IN ON POSITION. REMOVED FAULTY EMERGENCY BATT. #1 P/N 7450L.5-00 S/N 005279. REPLACED EMERGENCY BATT. #1 P/N 745CX..S-OO S/N 00SDR AALA202108090061Lamp · burned outAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT OVER LEFT HAND REAR EMERGENCY EXIT DOOR IS INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202108064518: REPLACED LIGHT COVER AND RELAMPED (AALA202108090061) PER AMM 33-21-00** (CLOSED)SDR AALA202108094518Cover · missingAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT OVER LEFT HAND REAR EMERGENCY EXIT DOOR IS INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202108064518: REPLACED LIGHT COVER AND RELAMPED (AALA202108090061) PER AMM 33-21-00** (CLOSED)SDR AALA202108064518Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT OVER LEFT HAND REAR EMERGENCY EXIT DOOR IS INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)
Back to JASC 3350