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 ASAA2018103126681Lens · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN AT L1 DOOR HAS BROKEN LENS. GROUNDED - YES. REMOVED AND REPLACED LENS AND TESTED LIGHT ASSY PER AMM 33-51-01-960-801. OPS NORMAL.SDR SIMA20181031002Light · inoperativeRT AFT OVERWING EMERGENCY LIGHT INOP. REMOVED AND REPLACED RT AFT OVERWING EMERGENCY ASSY IAW AMM TASK 33-50-10-000-801-A AND 33-50-10-400-801-A. OPS CHECK GOOD.SDR AALA201811019008Light · looseAIRCRAFT WAS NOT GROUNDED. WHITE EXIT LIGHT SEAT 12A LOOSE. SECURED LIGHT ASSY PER AMM 33-51-18. OPERATIONS CHECK GOOD.SDR AALA201811019007Light · looseAIRCRAFT WAS NOT GROUNDED. EXIT LIGHT SEAT 9C BROKEN AND FLAPPING IN AISLE. SECURED LIGHT ASSY PER AMM 33-51-18. OPERATIONS CHECK GOOD.SDR AALA201811019016Panel · looseTHE AIRCRAFT WAS NOT GROUNDED. LOWER EMERGENCY EXIT LIGHT PANEL BY 1L IS LOOSE. EXIT SIGN IS UPSIDE DOWN. SECURED PANEL AND REMOUNTED LIGHT. OK FOR SERVICE.SDR SWAA2018110126401Battery Pack · failedR2 DOOR EMERGENCY LIGHT FAILED THE CAPACITY CHECK. R&R BATTERY PACK PER AMM.SDR SWAA2018110126400Battery Pack · failedLT OVERWING EMERGENCY LIGHT FAILED THE CAPACITY CHECK. R&R BATTERY PACK IAW AMM.SDR SWAA2018110126382Lens · unsecureAFT GALLEY EMERGENCY EXIT SIGN PLACARD FELL OFF. REINSTALLED LENS PER MM.SDR SWAA2018110126378Battery Pack · dischargedR2 DOOR EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR FDEA201810313064Power Supply · inoperativeEMERGENCY LIGHT TEST. EMER LT BAT 1 LO ALERT. REMOVED AND REPLACED EMERGENCY LIGHTING BATTERY POWER SUPPLY WITH CPN 3300197 S/N 1027 IAW AMM 33-51-01-4-1. OPS CHECKS NORMAL IAW AMM 33-51-01-5.SDR SWAA2018103126366Sign · brokenOVERHEAD CEILING EMERGENCY EXIT SIGN BROKEN AT EMERGENCY EXIT ROW. SECURED SIGN PER SIP.SDR DALA2018103106350Battery · dischargedROW 10-15 CEILING EMER LIGHT OUT. R+R ROW 10-15 CEILING EMER LIGHT BATTERYS PER AMM 33-53. OPS CHECK GOOD. (LP4814589)SDR SIMA2018121030002Bulb · inoperativeCEILING PANEL EMERGENCY LIGHTS INOP AT 12ABC AND 16ABC.-C/A-COMPLETE:REMOVED AND REPLACED CEILING PANEL EMERGANCY LIGHT BULB AT 16BC. 12BC FOUND NO DISCREPANCY. IAW EMB 145 AMM 35-50-08.SDR CALA2018110302253Battery · dischargedDOOR 2R EMER POWER SUPPLY M33097 BATTERY CAPACITY CHECK FAIL. DOOR 2R EMER POWER SUPPLY M33097 BATTERY REPLACED AND TEST CARRIED OUT NORMAL AS PER AMM 33-51-06.SDR CALA2018110302252Power Supply · inoperativeEMER POWER SUPPLY M33407 FAIL CAPACITY CHECK EMER POWER SUPPLY. M33407 POWER SUPPLY ASSY REPLACED AND INSTALLATION TEST CARRIED OUT NORMAL AS PER AMM 33-51-06.SDR CALA2018110302251Charger · inoperativeEMER POWER SUPPLY M33097 BATTERY CHARGER FAIL OP TEST. EMER POWER SUPPLY M33097 BATTERY CHARGER REPLACED AND TEST CARRIED OUT NORMAL AS PER AMM 33-51-06.SDR CALA2018110302250Battery · dischargedCABIN LT AND RT SEAT 16 TO 33 EMERGENCY LIGHT FOUND DIM. DOOR R2 EMERGENCY POWER SUPPLY M33098 BATTERY REPLACED AND INSTALLATION TEST CARRIED OUT NORMAL AS PER AMM 33-51-06.SDR CALA2018110302249Charger · inoperativeDOOR 1L EMER POWER SUPPLY M33424 CAPACITY CHECK FAIL. EMER POWER SUPPLY M33424 CHARGER REPLACED AND TEST CARRIED OUT NORMAL AS PER AMM 33-51-06.SDR CALA2018110302248Battery · dischargedEMER POWER SUPPLY DOOR L2 M33096 BATTERY FAIL CAPACITY TEST. EMER POWER SUPPLY DOOR L2 M33096 BATTERY REPLACED AND INSTALLATION TEST CARRIED OUT NORMAL AS PER AMM 33-51-06.SDR R61A2018110231104Battery Pack · inoperativeEMERGENCY LIGHT BATTERY OVER THE R2 DOOR WAS INOPERATIVE. R & R THE BATTERY PACK IAW AMM 33-50-01.SDR YENA2018110230723Battery · no testEPSU BATTERY 11WL FAILED EMERGENCY LIGHT SYSTEM TEST. R & R THE BATTERY 11WL IAW AMM 33-51-38, EMERGENCY LIGHT SYSTEM CHECKED GOOD.SDR DALA2018110106410Light · noneEMERGENCY LIGHT ABOVE THE L2 DOOR DOES NOT ILLUMINATE. EMERGENCY EXIT LIGHT ABOVE L-2 DOOR OPS CK NORMAL.SDR DALA2018110216408Lens · missingEMERGENCY LIGHT LENS WAS MISSING AT THE MID CABIN. REPLACED THE LENS. OK FOR SERVICE.SDR AALA201811019017Switch · defectiveTHE AIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT REPORTS ALL EMERGENCY LIGHTS ON. OCCURRED WITH COCKPIT SWITCH IN ARM. WITH SWITCH OFF, ALL EMERGENCY LIGHTS EXTINGUISHED. REPLACED EMERGENCY LIGHT SWITCH PER TSM 33-51-00-810-881. OPERATIONS CHECK GOOD.SDR SWAA2018110126410Strip · delaminatedFORWARD ENTRY LT ESCAPE PATH STRIPS DELAMINATED. R&R LIGHT STRIPS PER DWG.SDR SWAA2018110126397Lens · brokenAFT SERVICE EMERGENCY EXIT LENS BROKEN. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2018110126385Strip · delaminatedFORWARD ENTRY RT ESCAPE PATH STRIPS DELAMINATED. R&R LIGHT STRIPS PER DWG.SDR FDEA201810303060Power Supply · failedON PREFLIGHT TEST, EMER LT BAT 1 LOW ANNUNCIATES. REMOVED AND REPLACED BATTERY EMERGENCY POWER SUPPLY, REF AMM 33-51-01-4. OPS CHECK GOOD, REF AMM 33-51-01-5. OK FOR SERVICE.SDR SWAA2018103126376Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01675. R&R BATTERY PER AMM.SDR SWAA2018103126375Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01673. R&R BATTERY PER AMM.SDR SWAA2018103126374Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01670. R&R BATTERY PER AMM.SDR SWAA2018103126367Light · inoperativeCOCKPIT EMERGENCY EXIT DOME LIGHT INOP. RELAMPED LIGHT ASSEMBLY PER MM.SDR SWAA2018103126365Light · brokenFORWARD EMERGENCY EXIT LIGHT BROKEN. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2018103126358Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01669. R&R BATTERY PER AMM.SDR AALA201810319024Control Unit · inoperativeEMERGENCY LIGHTS WILL NOT TURN OFF WITH EMERGENCY LIGHT SWITCH. REPLACED THE AFT CONTROL UNIT IAW AMM 33-51-07.SDR HNAA2018103100272Control Module · faultyPDIS 692 33-51 1640791 30OCT18 TRI CLOSE EMERGENCY LIGHT NOT ARMED EICAS MSG DISPLAYED. PDPU AND CYCLED C/B'S AND SWITCHS WITH NO FIX. 24137 00 RNR FACT 30OCT18 16:21 CLT RNR UNIT CONTROL MODULE IAW AMM 33-21-01-04 OPS CHECK GOOD IAW AMM 33-21-01-05 A/C OK FORSDR AALA201810319018Lens · missingSEAT MOUNTED EMERGENCY LIGHT LENS AT ROW 12L WAS MISSING. INSTALLED THE LENS IAW AMM 33-51-18.SDR MASA2018103011494Light · inoperativeROW 9 OVHD EMER FLOODLIGHT INOP. PLACED ON MEL.SDR MASA2018103011493Light · inoperativeROW 18 OVHD EMER LIGHT INOP. RELAMPED.SDR DALA2018103006338Battery Pack · dischargedCABIN EMERGENCY LIGHT AT ROW 13 TO 23 INOP AND FROM 31 TO AFT EMERG EXIT DOOR ALSO INOP. FOUND CEILING EMERGENCY LIGHT IN FWD AND MID CABIN INOP ALSO. R/R BATTERY AT SEATS 2C, 4DC 25DE, AND 35ED. ALL EMERGENCY LIGHT OPS CK NORMAL REF AMM 33-51 A/C OK FOR SVC. SDR DALA2018110216419Switch · damagedEMERGENCY LIGHT TOGGLE SWITCH CONFIGURATION IMPROPER. REPLACED EMERGENCY LIGHT SWITCH.SDR DALA2018110126382Battery Pack · no test(LOG 0804999) EMERGENCY LIGHT BATTERY PACKS M1671 & M1675 FAILED CAPACITY TEST. REPLACED BATTERY PACK AT M1675 AND M1671. REF B737 33-51-06. OPS CK GOOD.SDR FDEA201810293047Battery · dischargedL1 DOOR EMERGENCY EXIT LIGHTS INOP ON PREFLIGHT. REMOVED AND REPLACED LT EMERGENCY BATTERY PER AMM 33-51-07-2. OP'S CHECK GOOD. BATTERY ASSY P/N ON 2031-1A S/N 79304.SDR AALA201810319034Light · burned outLEFT AFT OVERWING EMERGENCY LIGHT WAS BURNED OUT. MAINTENANCE REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-04, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201810319007Power Supply · no testR4 EXTERIOR EMERGENCY LIGHT NOT ILLUMINATING WHEN TESTED. REPLACED THE POWER SUPPLY IAW AMM33-51-06.SDR SWAA2018103026352Light · inoperativeRT FORWARD EXTERIOR SLIDE EMERGENCY LIGHT INOP. R&R LIGHT PER AMM.SDR SWAA2018103026342Cover · missingCEILING OVERWING EMERGENCY EXIT SIGN LIGHT ACCESS COVER MISSING. INSTALLED COVER IAW AMM.SDR ASAA2018102926664Lens · brokenEMERGENCY LIGHT EXIT LOCATOR SIGN AT R-2 DOOR HAS BROKEN LENS. GROUNDED - YES. REMOVED AND REPLACED LENS AND TESTED LIGHT ASSY PER AMM 33-51-01-960-801 - OPS NORMAL.SDR AALA201810309018Lens · crackedCRACK ON GLASS OF EMERGENCY RT OVERWING LIGHT FORWARD POSITION ON ACCESS PANEL 192DT. REPLACED THE GLASS ON THE LIGHT IAW AMM 33-51-15-400-001-A STEP 4B (2)(C).SDR SWAA2018102926306Battery Pack · dischargedL2 DOOR EMERGENCY LIGHTS INOP. R&R BATTERY PACK PER AMM.
Back to JASC 3350