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 SIMA202001064005Light · inoperativeLH AFT EXTERNAL EMERG LIGHT INOP-C/A-REMOVED AND REPLACED LH AFT EXTERNAL EMERG LIGHT ASSY IAW AMM 33-50-10. OPS CHECK GOOD.SDR SIMA202001064006Inverter · inoperativeLH OVER WING EMERGENCY LIGHT INOP-C/A-RAR LH OVER WING EEL POWER SUPPLY AND EMERGENCY EXIT SIGN LH OVER WING IAW AMM 33-50-11 OPS CHECK GOODSDR SIMA202001064007Light · inoperativeMAIN DOOR EXTERIOR EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED MAIN DOOR EXTERIOR LIGHT IAW AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPC GOOD. NO FURTHER DEFECTS NOTED. END.SDR MASA2020010400006Battery Pack · dischargedEMERGENCY LIGHTS WILL NOT STAY ON- CHARGED EMERG LIGHT BATTERIESSDR MASA2020010400005Light · inoperativeEMERG CEILING LIGHT ROW 21 INOP- PLACED ON MELSDR SWAA2021062325090Light · delaminatedDELAMINATED PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING AT PASSENGER CABIN (10 EA) / REPLACED PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING AT PASSENGER CABIN (10EA) IAW DWG 33500007 AND B737-700 SRM 51-10-02 ITEM 9SDR DALA2020010500052Battery · failedASPSU TEST FAILED FROM BATTERY 2. REPLACED NBR 2 BATTERY ASPSU. LP 6705949SDR SWAA2020012040530Lens · brokenFORWARD GALLEY AREA EMERGENCY EXIT LENS BROKEN. R&R LENS IAW DWG.SDR ASAA2020010831800Power Supply · failedEMERGENCY LIGHTS COMMON TO L2 DOOR BATTERY PACK DISCHARGE CHECK FAILED. GROUNDED - YES. REMOVED AND REPLACED POWER SUPPLY AND OPS CHECK GOOD IAW ASA B737-900 AMM 33-51-06.SDR DALA2020010800133Light · inoperativeOVHD EMERGENCY LIGHT INOP AT ROW 22, R/R'D CABIN EMERGENCY LIGHT AT ROW 22SDR SWAA2020010740191Powerpack · inoperativeL1 DOOR EMERGENCY LIGHT INOP ON FUSELAGE. / R&R POWER PACK IAW AMM.SDR SWAA2020010740167Lens · brokenLOWER L1 DOOR EMERGENCY LIGHT LENS ASSEMBLY BROKEN AND NOT SECURE. / R&R L1 EMERGENCY LIGHT ASSEMBLY PER AMM.SDR SIMA202001063002Lamp · inoperativeL/H OVER WING EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED L/H OVER WING EMERGENCY LIGHT IAW AMM 33-50-10. OPS CHECK GOODSDR SIMA202001063004Light · damagedFWD, RH PROXIMITY FLOOR STRIP IS DAMAGED.-C/A-REMOVED AND REPLACED RH PROXIMITY STRIP IAW AMM 33-50-12.SDR AALA202001069008Battery · failedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT 15WL BATTERY FAILED BITE TEST IN REFERENCE WITH JOB CARD 26L00005062. MAINTENANCE REPLACED POWER SUPPLY UNIT BATTERY PER AMM 33-51-38.SDR DALA2020010600063Power Supply · inoperativeEXT EMER LET @ DOOR 4L INOP C/A REP PWR SUPPLY & BATT PACK M739 REF B767-400 M/M 33-51. LT OPS CK GOOD. (6221800)SDR DALA2020010300024Battery Pack · discharged(LOG 6335352) DURING INSPECTION FOUND EMERGENCY LIGHT SIGN INOPERATIVE NEAR FLOOR AT 17 A&F. REMOVED AND REPLACED BATTERY PACK AT SEAT 17A IAW B737 AMM 33-51. OPS CK GOOD.SDR DALA2020010300023Fuse · blown(LOG 6401400) DURING INSPECTION FOUND FWD GALLEY EMERGENCY LIGHT INOPERATIVE. REPLACED FUSE IN BATTERY PACK. NOW ALL E-LIGHTS CK GOOD. REF B737-800AMM 33-51.SDR AALA202001039008Light · brokenAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY AISLE LIGHT BEHIND SEAT 4G BROKEN AND INOPERATIVE.***SUPPLEMENTAL ACTION SECT.4 AND 5: INSTALLED EMERGENCY AISLE LIGHT ASSY IAW 33-51-03.***(CLOSED)SDR CALA2020010600075Charger · inoperativeEMERGENCY AISLE PATH LIGHTING FROM ROW 22-15 ARE INOP. INCLUDING RED LITE FOR EMERGENCY EXIT. R/R M1669 CHARGER, OPS CHKD GOOD. REF AMM 33-51-06.SDR ASAA2020010331757Unknown · malfunctionedFWD CARGO EXT LIGHT DOES NOT ILLUMINATE DURING LIGHT TEST. GROUNDED - YES. PERFORMED B737-800 FIM 26-16-TASK 806. UPON INITIAL EVLAUATION CARGO FIRE CONTROL TEST CKS NORMAL. ALL REQURIED LIGHTS ILLUMINATE. NO OTHER DEFECTS NOTED.SDR AALA202001039007Lens · missingAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY LIGHT LENS MISSING AT SEAT 22C. REPLACED EMERGENCY LIGHT ASSY. AT SEAT 22C IAW AMM 33-51-11. OPS CHECK GOOD.SDR AALA202001039005Sign · malfunctionedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN IN OVERWING EXIT ROW UNLIT. MAINTENANCE ACCOMPLISHED RESET AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER TSM 24-00-00-810-818-A.SDR R61A2020010320005Battery · inoperativeEMERGENCY LIGHT UNDER CEILING PANEL 338BLC INOPERATIVE. R&R EMERGENCY LIGHT POWER UNIT UNDER CEILING PANEL 227BLC IAW AMM 33-50-01.SDR R61A2020010320004Battery · inoperative1ST AND 3RD FORWARD CEILING EMERGENCY LIGHTS WILL NOT ILLUMINATE WHEN EMER LT SET TO ON. R&R #2 ELPU IAW AMM 33-50-01, OPS CHECK GOOD.SDR KCSA202001021002Light · inoperativeUPPER DECK CEILING EMERG LIGHT AT STA 550 INOPSDR KCSA202001021001Light · inoperativeMAIN DECK CEILING EMERG LIGHT AT STA 450 I/B OF L-1 DOOR INOPSDR KCSA202001021000Light · inoperativeL-1 DOOR FWD EMERG LIGHT INOPSDR MASA2020010200001Battery Pack · inoperativeFWD EMERGENCY LIGHTS INOP. R&R #1 EPSU BATTERY PACKSDR MASA2020040212215Battery Pack · dischargedFWD EMERGENCY LIGHTS INOP- R&R #1 EPSU BATTERY PACKSDR CALA2020010600072Fuse · blownGENERATING ITEM: 63-3350-1-9300 /// JOB CARD 63-3350-1-9300 DURING OPS CHECK OF EMER LIGHTS, 5TH FROM THE FRONT ON R/H SIDE OF CABIN CEILING FAILED TO OPERATE. REF AMES NR 0637, WHILE T/SING W/REF TO B767 WDM 33-51-12, FOUND A FUSE BLOWN ON POWER SUPPLY M732. SDR AALA202001039009Light · not seatedAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS EMERGENCY LIGHT AT CABIN CEILING POSITION 203WL INOPERATIVE. RESEATED EMERGENCY LIGHT HOUSING AT POS 203WL. OPS CHECK OK.SDR R61A2020010310006Light · damagedFWD GALLEY EMERGENCY PHOTOLUMINESCENT STRIP FADED. R&R FWD GALLEY EMERGENCY PHOTOLUMINESCENT STRIP, OPS CHECK GOOD IAW AMM 33-50-21.SDR DALA2020010300048Battery · dischargedFOUND EPSU FAULT DURING WORKCARD 3351-2291 TEST, R/R EPSU W/O BATTERYSDR DALA2020010300028Power Supply · inoperative(AIRCRAFT 5814, L/P 6697864) L3 DOOR EXIT SIGN LIGHTS INOP. CORRECTIVE ACTION: R/R'D M11490 POWER SUPPLY PER B757 AMM 33-51.SDR DALA2020010200027Fuse · blown(AIRCRAFT 5814, L/P 6697865) FOUND ROW 4-6 EMERGENCY SEAT PATH LIGHTS INOP. CORRECTIVE ACTION: REPLACED M730 POWER SUPPLY FUSE. PER B737 AMM 33-51.SDR SIMA202001021001Lamp · inoperative11A OVERHEAD EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED 11A OVERHEAD EMERGENCY LIGHT LAMP IAW EMB AMM 33-50-08-000-801-A AND 33-50-08-400-801-A. OPS CHECK GOOD.SDR YENA2020010210004Epsu · failedFT # 433, DCA-PBI. EMERGENCY LIGHTS AT 51WL AND 43WL INOP; R & R EPSU AT 11WL IAW AMM 33-51-38 REPLACED EMERGENCY LIGHT ASSY AT 43WL IAW AMM 33-51-17. REPLACED BATTERY TO EPSU AT 11WL IAW AMM 33-51-38 ALL OPS CHECKS OKAY.SDR YENA2020010210003Battery · dischargedFT # 433, DCA-PBI. EMERGENCY LIGHTS AT 51WL AND 43WL INOP; R & R EPSU AT 11WL IAW AMM 33-51-38 REPLACED EMERGENCY LIGHT ASSY AT 43WL IAW AMM 33-51-17. REPLACED BATTERY TO EPSU AT 11WL IAW AMM 33-51-38 ALL OPS CHECKS OKAY.SDR YENA2020010210002Battery · dischargedFT # 433, DCA-PBI. EMERGENCY LIGHTS AT 53WL AND 42WL INOP; R & R EPSU AT (12WL) AND BATTERY A 12WL IAW AMM 33-51-38 OPS CHECK OKAY.SDR YENA2020010210001Epsu · failedFT # 433, DCA-PBI. EMERGENCY LIGHTS AT 53WL AND 42WL INOP; R & R EPSU AT (12WL) AND BATTERY A 12WL IAW AMM 33-51-38 OPS CHECK OKAY.SDR DALA2020010200009Power Supply · inoperativeSEAT MOUNTED EMER LTS INOP FROM SEAT 6A TO L2 DOOR. C/A REP. PWR SUPPLY AND BATTERY PACK M7235 REF B767-400 M/M 33-51. LTS OPS CK GOOD (5372307)SDR K11A2020021240501Light · inoperativeEXIT LIGHT FWD OF R1 DOOR DOES NOT ILLUMINATESDR SIMA2020021131010Light · damaged8EA FLOOR PROXIMITY LIGHT PANELS DAMAGED-C/A-COMPLETE:REMOVED AND REPLACED ALL FLOOR PROXIMITY LIGHT PANELS IAW EMB 145 AMM 33-50-12.SDR SIMA2020021131006Light · damaged#2, #4, #6, #7, AND #8 FLOOR PROXIMITY LIGHT STRIPS DAMAGED-C/A-COMPLETE:REMOVED AND REPLACED #2, #4 , #6, #7, AND #8 FLOOR PROX LIGHT STRIPS IAW EMB-145 AMM 33-50-12.SDR SIMA2020021123107Light · brokenRH CABIN FLOOR EMERGENCY LIGHT STRIPS BROKEN (5 EA)-C/A-COMPLETE:REMOVED AND REPLACED 5 RH FLOOR EMERGNCY LIGHT STRIPS AS REQUIRED.SDR SIMA2020021131008Light · inoperativeEMERGENCY LIGHT UNDER PANEL 233BLC AND COCKPIT STEP UP PANEL INOP-C/A-COMPLETE:REMOVED AND REPLACED WARDROBE EMERGENCY LIGHTS DC/AC INVERTER IAW EMB 145 AMM 33-50-11. OPC GOOD.SDR SIMA2020021123009Light · brokenLH ANGLE EMERGENCY LIGHT STRIP FOR PANEL 231FF IS BROKEN-C/A-COMPLETE:REMOVED AND REPLACED LH ANGLE EMERGECNY LIGHT STRIP FOR PANEL 231FF IAW EMB 145 AMM 33-50-12.SDR AALA2020010329015Light · faultedAIRCRAFT WAS NOT GROUNDED: RED FLASHING EMERGENCY LIGHT AT SEAT 22A. ***SUPPLEMENTAL TO UPDATE SECTION 4 AND SECTION 5. MAINTENANCE REPLACED 22A SIDEWALL LIGHT PER AMM 33-21-00.*** (CLOSED)SDR SWAA2020010740240Power Supply · inoperativeR/H AFTER WING EMERGENCY ESCAPE LIGHT INOP. / R&R POWER SUPPLY PER AMM.
Back to JASC 3350