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 MASA2018012812941Sign · inoperativeROW 3/4 AFT FACING EMER EXIT SIGN INOP. CHARGED WITH EXTERNAL POWER.SDR CALA2018012800365Light · odorELECTRICAL BURNING SMELL COMING FROM G2 LOWER ESCAPE PATH LIGHT ASSY (LT SIDE). REMOVED AND REPLACED G2 LOWER ESCAPE PATH LIGHT ASSY AT RIGHT SIDE. OPS CHECK OK. REF WDM 33-51-19.SDR CALA2018012800374Light · unsecureROW 32 AND 34 EMERGENCY LIGHTS HANGING. EMERGENCY LIGHT HAVE BEEN FIXED.SDR CALA2018012800373Lens · missingAFT FWD. LAV MISSING EMERGENCY LIGHT LENS. REPLACED EMERGENCY LIGHT LENS IN AFT FWD LAV.SDR CALA2018012800372Light · inoperativeLEFT HAND OVERWING EMERGENCY LIGHT INOP. RELAMPED LT OVERWING EMERGENCY LIGHT, OPS CK GOOD REF AMM 33-51-04-960-801.SDR CALA2018012800371Light · looseSEAT 35D EMERGENCY ESCAPE PATH LIGHT ASSY LOOSE. REMOVED AND REPLACED SEAT 35D EMERGENCY ESCAPE PATH LIGHT ASSY. OPS CHECK OK. REF WDM 33-51-19.SDR CALA2018012800370Light · missingEMERG FLOOR LIGHTS AT 4R IN GALLEY MISSING LIGHT ASSY. FOUND MISSING PIECE, REINSTALLED.SDR 7C7A2018013000358Bulb · inoperativeEMERGENCY LIGHT INOPERATIVE. REPLACED THE BULB.SDR AALA201801309012Sign · detachedR3 DOOR EXIT SIGN DETACHED. ATTACHED AND SECURED THE EXIT SIGN. OK FOR SERVICE.SDR AALA201801309011Switch · defectiveEMERGENCY LIGHTS NOT ARMED AND FLASHED ON AND OFF DURING FLIGHT. THE AIRCRAFT WAS GROUNDED. REMOVED AND REPLACED EMERGENCY LIGHTS SWITCH S1-177 PER WDM 33-51-11. TESTED GOOD.SDR SWAA2018013019435Light · inoperativeRT EMERGENCY OVERWING EXIT LIGHT FORWARD THRESHOLD LIGHT INOP. R&R LIGHT PER AMM.SDR SWAA2018013019424Light · inoperativeLT EMERGENCY LIGHT INOP AT ROW 20. R&R BULB PER AMM.SDR AALA20180128004Battery Pack · inoperativeSEATS 27D TO 36D EMERGENCY LIGHTS, EXIT SIGNS AT THE R4 AND L4 DOORS, AND THE AFT R4 DOOR EXTERNAL EMERGENCY LIGHT WERE INOPERATIVE. REPLACED THE BATTERY PACK IAW MM 33-51-07.SDR AALA201801299018Light · malfunctionedALL EMERGENCY LIGHTS ARE ON IN CABIN WITH SWITCH IN THE ARMED POSITION. RESET POWER CIRCUIT FOR EMERGENCY EXIT LIGHTS LOGIC. ALL TESTS PASSED, IAW AMM 33-51-00.SDR DALA2018012900479Power Supply · inoperativeDURING AN EMERGENCY LIGHT CHECK, FOUND THE SEAT LIGHT INOPERATIVE AFT CABIN ROWS 23 THRU 33. R & R THE POWER SUPPLY AT M1672 IAW IAW MM 33-51 LIGHT CHECKED OK.SDR DALA2018012900478Bulb · inoperativeEXTERIOR EMERGENCY LIGHT BULB INOPERATIVE AT FORWARD LEFT WING EMERGENCY EXIT DOOR. REPLACED THE LAMPS IAW MM 33-51, LIGHT CHECKED OK.SDR AALA201801299004Lens · brokenEMERGENCY LIGHT LENS AT SEAT 14L BROKEN. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-19.SDR AALA201801299003Light · inoperativeEMERGENCY LIGHT AT SEAT 3C INOPERATIVE. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-19, PB 401.SDR AALA201801299002Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT 8 ABC. INSTALLED A NEW LENS.SDR N6WA2018012701Lens · detachedLEFT OVERWING EMERGENCY LIGHT LENS DETACHED. SECURED THE LENS IAW AMM 51-22-61.SDR DALA2018012900467Light · inoperativeEMERGENCY LIGHT ON CAT WALK INOP. RETERMINATED EMERGENCY LIGHT CAT WALK PER SPWM CHAPTER 20 AND EWIZ.SDR MASA2018012712940Battery Pack · dischargedCLASS DIVIDER EMER SIGN INOP. REPLACED 1 AND 3 EPSU BATTERY PACKS. OPS CHECK GOOD.SDR CALA2018012700363Battery · faultyFWD LT EMERGENCY POWER SUPPLY UNIT BATTERY FOUND FAULTY DURING EMERGENCY LIGHT TEST. REPLACED EMERGENCY LIGHT BATTERY PER AMM 33-51-38, OPERATIONAL TEST GOOD, OK FOR SERVICE.SDR CALA2018012700361Switch · faultyEMERGENCY LIGHT TEST SWITCH ABOVE L2 DOOR INOP. REMOVED AND REPLACED MID FWD EMERGENCY LIGHT TEST SWITCH S10293 P/N:2100-7. OPS CHECK GOOD. REF WDM:33-51-13.SDR CALA2018012700360Light · inoperativeR2 AND L4 DOOR EXTERIOR EMERGENCY LIGHTS INOP. RELAMPED R2 AND L4 DOOR EXTERIOR EMERGENCY LIGHTS. OPS CHECK GOOD.SDR FDEA201801260244Battery Pack · no testAFTER EMER LT. TEST: LVL 1 ALERT EMERGENCY LIGHT BATTERY LOW. REPLACEMENT OF EMERGENCY LIGHT BATTERY, OPS CHECKED GOOD.SDR SWAA2018013019446Light · inoperativeL2 DOOR EMERGENCY LIGHT INOP. R&R BULB PER AMM.SDR SWAA2018013019441Light · brokenCENTER CABIN OVERHEAD EMERGENCY EXIT LIGHT BROKEN. R&R LIGHT IAW AMM.SDR AALA20180126004Power Supply · dischargedR1 DOOR EMERGENCY EXIT SIGN FORWARD UPPER, FORWARD LOWER, AND AFT LOWER EMERGENCY SIGNS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW.AMM 33-51-07. OPS CHECKED NORMAL.SDR SWAA2018012919368Cover · unsecureMID CABIN EMERGENCY EXIT CEILING LIGHT COVER FELL OFF. SECURED COVER PER AMM.SDR DALA2018012900493Lens · damagedSEAT MOUNTED EMERGENCY LIGHT LENS DAMAGED. INSTALLED A NEW EMERGENCY LIGHT LENS.SDR AALA201801299012Lens · missingL4 DOOR EMERGENCY EXIT LIGHT HAD A MISSING LENS. INSTALLED LENS IAW AMM 33-51-13.SDR SIMA20180126005Battery · dischargedLT AND RT OVERWING EXTERNAL LIGHTS FAIL TO ILLUMINATE. REMOVED AND REPLACED NR 4 EMERGENCY POWER SUPPLY BATTERY AND CHARGER IAW AMM 33-50-04. OPS CHECK GOOD. BATTERY CHARGER ASSY P/N 11-0049 S/N 15271.SDR SIMA20180126006Light · inoperativeLT AND RT OVERWING EXTERNAL LIGHTS FAIL TO ILLUMINATE. REMOVED AND REPLACED LT AND RT OVERWING EXTERNAL LAMPS IAW AMM 33-50-10. OPS CHECK FAILED. CHARGER ASSY BATTER P/N BA5-0933-901 S/N C01638.SDR SIMA20180126002Power Supply · failedLT/RT OVERWING EMERGENCY LIGHT INOP. REMOVED AND REPLACED NR 4 EMERGENCY POWER SUPPLY UNIT IAW AMM 33-50-04 OPC GOOD. BATTERY CHARGER ASSY P/N 11-0049 S/N 24340. LIGHT EMERGENCY L/H P/N 30-2510-3.SDR DALA2018012900458Battery Pack · dischargedEMERGENCY LIGHTS IN OVERWING EXIT SIGNS AT ROW 24, LEFT AND RIGHT, INOP. SWAPPED LAMPS NO HELP. REMOVED AND REPLACED B5-103 BATTERY PACK PER AMM 33-53. ALL TEST GOOD.SDR MASA2018012612936Sign · inoperativeEMERGENCY ESCAPE LIGHTING AT ROW 2C INOP. PLACED ON MEL.SDR CALA2018012600348Warning Message · false activationAFTER EMERGENCY LIGHT TEST, A MESSAGE FOR THE EPSU EXTERNAL LOAD, FWD LEFT DISPLAYED ON PTP. SHUTDOWN. EMERGENCY LIGHT OPS TESTED IAW 33-51-00-710-001- A. TESTED OK.SDR CALA2018012600346Lens · missingEMERGENCY LIGHT LENS MISSING AT ROWS 26ABC AND 32ABC. INSTALLED A NEW LENS. OK FOR SERVICE.SDR CALA2018012600345Light · detachedSEAT 30C EMERGENCY LIGHT DETACKED. INSTALLED THE LIGHT. OPS OKSDR CALA2018012600344Lens · missingMISSING EMERGENCY LIGHT LENS IN THE FIRST CLASS CABIN. INSTALLED A NEW LENS.SDR CALA2018012600343Lens · brokenEMERGENCY EXIT SIGN LENS BROKEN. INSTALLED A NEW LENS IAW AMM 33-51-14.SDR CALA2018012600342Lamp · inoperativeEMERGENCY LIGHT DOES NOT TURN ON. REPLACED THE LAMPS IAW AMM 33-51-14-960-801, OPS CHECKED GOOD.SDR CALA2018012600341Light · inoperativeSEATS 28C & 36C EMERGENCY LIGHT INOPERATIVE. INSTALLED NEW EMERGENCY LIGHTS. OPS OK.SDR CALA2018012600340Lamp · inoperativeSEAT EMERGENCY LIGHTS INOPERATIVE AT 26C. REPLACED THE BULBS AND LENS, LIGHT OPS CHECKED NORMAL.SDR CALA2018012600339Lamp · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED OK.SDR CALA2018012600338Light · missingEMERGENCY LIGHT MISSING AT SEAT 12C. INSTALLED THE LIGHT ASSY, OPS CHECKED OK.SDR CALA2018012600337Lamp · inoperativeLEFT AFT ENTRY DOOR SLIDE LIGHT INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED GOOD IAW WD 33-51-14.SDR CALA2018012600336Battery Pack · inoperativeAFT SEAT EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805, AND WD 33-51-14. LIGHTS OPS CHECKED GOOD.SDR CALA2018012600335Battery Pack · inoperativeROWS 35, 36, 37, 38, 39, AND THE L2 DOOR EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805. OPS CHECKED GOOD.
Back to JASC 3350