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 DALA201908234931Power Supply · inoperativeEMERGENCY LIGHTS INOP ROW 12-15. REPLACED BATTERY - NO HELP. REPLACED POWER SUPPLY PER B757 AMM 33-51.SDR YENA2019082319466Cover · unsecureFT 504, EMERG EXIT LIGHT COVER CAME OFF NEAR L1 DOOR; SECURED EMERGENCY EXIT LIGHT COVER AT L1 DOOR IAW AMM 33-50-00.SDR SIMA201908219005Battery Pack · inoperativeFA FWD FLASHLIGHT NOT WORKING. REMOVED AND REPLACED FLASHLIGHT BATTERY AS REQUIRED OPC GOOD.SDR SWAA2019082136165Lamp · unsecureL/H AFT EMERGENCY LIGHT ON EXTERNAL FUSELAGE INOP. SECURED LAMP PER AMM.SDR DALA2019082004881Lens · missingTHE FORWARD FACING LENS FROM THE CENTER AISLE EMERGENCY EXIT SIGN AT THE OVERWING EXIT IS MISSING. MAINTENANCE INSTALLED THE CENTER AISLE FORWARD FACING LENS AT THE OVERWING EXITS PER B717 AMM 33-51. (LP #6167025)SDR SIMA20190819003Light · inoperativeLH OVER WING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LH OVER WING EMERGENCY LIGHT IAW AMM 33-50-07-000-801-A AND 33-50-07-400-801-A.SDR SWAA2019082036125Lens · brokenL/H EMERGENCY EXIT OVERWING FORWARD BROKEN OFF. R&R LIGHT LENS IAW AMM.SDR KCSA201908191200Light · inoperativeEXIT LIGHT BEHIND COCKPIT INOPSDR SWAA2019081936020Charger · inoperativeAFT L/H ENTRY DOOR EMERGENCY LIGHT INOP. R & R THE BATTERY PACK CHARGER ASSEMBLY IAW AMM.SDR MASA2019081912008Bulb · inoperativeSERVICE DOOR EXIT SIGN-3 BULBS INOP. RELAMPEDSDR MASA2019081982007Light · inoperativePHOTO LUMNISC STRIP ROW 1 D/N LIT UP. REPLACED STRIP.SDR AALA201908199018Power Supply · inoperativeAIRCRAFT NOT GROUNDED: NINE EMERGENCY CABIN LH SEAT LIGHTS INOPERATIVE. FOUND LT SIDE POWER SUPPLY CABIN EMERGENCY UNIT FAULT. REMOVED AND REPLACED POWER SUPPLY UNIT IAW AMM 33-50-00 OPS CKS NORMAL.SDR REXA2019081901246Lamp · inoperativeEXTERIOR EMERGENCY LIGHT @ PAX DOOR FOUND INOP. REMOVED AND REPLACED EMERG LIGHT LAMP IAW AMM 33-51-15. OPS CHECK GOOD.SDR SIMA20190818004Light · inoperativeCABIN FWD 2 EMERGENCY LIGHT STRIPS REQUIRE REPLACEMENT-C/A-COMPLETE:REMOVED REPLACED CABIN FWD W EMERGENCY LIGHT STRIPS IAW EMB 175 AMM 33-50-21. OPS CHECK GOOD.SDR FDEA201908181932Power Supply · inoperativePREFLT EMERGENCY LIGHT TEST RECEIVED A LEVEL 1 EMERGENCY LIGHT BATTERY 1 LOW. REMOVED AND REPLACED EMERGENCY LIGHTING BATTERY POWER SUPPLY, IAW AMM 33-51-01-4. OPS CHECKED GOOD, A/C OK FOR SERVICE.SDR FDEA2019082081933Battery Pack · inoperativePREFLT EMERGENCY LIGHT TEST RECEIVED A LEVEL 1 EMERGENCY LIGHT BATTERY 1 LOW. REMOVED AND REPLACED EMERGENCY LIGHTING BATTERY POWER SUPPLY, REF AMM 33-51- 01-4. OPS CHECKS GOOD, A/C OK FOR SERVICE.SDR R61A2019082218861Light · inoperativeEMERGENCY LIGHT INOP, 4TH LIGHT OVER AISLE. TROUBLESHOT EMERGENCY LIGHT #4 BETWEEN SEAT 15 ABCD CONNECTION, PLUGS, AND GROUND IAW WM 33-21-53, OPS CHECK GOOD.SDR DALA2019082284896Lamp · inoperativeROW 35 & 42 CEILING EMER LIGHTS INOP. RELAMPED. OPS CHECK GOOD.SDR AALA201908209012Power Supply · failedAIRCRAFT NOT GROUNDED: REF WC 25-94-03 EPSU 14WL FAILED. REMOVED AND REPLACED EPSU 14WL OPS CK NORMAL IAW AMM 33-51-38.SDR AALA201908209013Power Supply · failedAIRCRAFT NOT GROUNDED: REF WC 25-94-03 EPSU FAIL. REMOVED AND REPLACED EPSU 13WL, OPS CK NORMAL IAW AMM 52-17-67.SDR SWAA2019081936092Sign · inoperativeR/H SIDE AFT OVERWING EMERGENCY EXIT SIGN INOP. R&R EMERGENCY EXIT SIGN ASSEMBLY PER MM.SDR AALA201908199013Battery · no testAIRCRAFT IN BASE VISIT: EMERGENCY LIGHT TEST FAILED BATTERIES AT 2L AND 3R DOORS. REMOVED AND REPLACED EPSU BATTERIES 13WL AND 16WL IAW AMM 33-51-38-000-802/400-802.SDR HNAA2019081900229Bulb · inoperativeR/H LATERAL PANEL EMERGENCY LIGHT INOP. R & R LIGHT BULB FOR RH LATERAL PANEL EMERGENCY LIGHTSDR REXA2019081981245Sign · brokenEXIT SIGN IN ROW 13 CD IS BROKEN, STATES FLIGHT ATTENDENTS. PERFORMED OPS CHECK OF EMERGENCY LIGHTS IAW AMM 33-51-00. OPS CHECK GOOD.NO DEFECTS NOTED.SDR AALA201908180002Battery Pack · inoperativeLIGHTS ASSOCIATED WITH EMERGENCY EXIT LIGHT BATTERY PACK M1673 IS INOP.SDR QXEA2019082100321Unknown · malfunctionedWITH EXTERNAL POWER AVAILABLE, BUT DESELECTED, AND AIRCRAFT SHUTDOWN (TERMINATED) IF YOU SELECT THE GROUND SERVICE POWER ON OUTSIDE COCKPIT DOOR ALL EMERGENCY LIGHTS TURN ON. REMOVED FROM SERVICE. PERFORMED OPS TEST OF EMERGENCY LIGHTING IAW AMM TASK 33-50-00-SDR REXA2019082171247Lamp · inoperativeFOUND RH FORWARD (OUTSIDE) EMERGENCY LIGHT INOP DURING ROUTINE CHECK. REPLACED THE LAMP IAW AMM 33-51-21 OPS CHECK GOOD .SDR UIEA2019082195223Lens · missingISLE RED EMERGENCY PATH LIGHTING LENS MISSING @ L4 LAV. (<P>REPLACED MISSING RED ESCAPE PATH LENS IAW AMM 33-51-10.</P>)SDR DALA2019082084876Light · inoperativeEMERG. LIGHT AT ROW 35 ABC IS INOP, REPLACED FLOOR PROXIMITY LIGHT ASSYSDR DALA2019082084875Light · brokenEMERGENCY EXIT LIGHT BROKEN, REPLACED LIGHT ASSYSDR DALA2019082074873Light · inoperativeSEAT ROW 24 EEPLS INOP.SDR DALA2019081904870Lens · missingDURING INSPECTION FOUND MISSING RED FWD EMERGENCY LIGHTING COVER FIRST CLASS. MAINTENANCE INSTALLED LENS.SDR ASAA2019081973424Lamp · inoperativeL2 SLIDE LIGHT INOP. GROUNDED - YES. RELAMPED. OPS CHECK GOOD IAW B737-900 AMM 33-51-04.SDR SWAA2019081936070Battery Pack · dischargedEMERGENCY BATTERY PACK M01674 DISCHARGED AT FORWARD CEILING R/H BETWEEN L1 AND R1 DOOR. R&R EMERGENCY BATTERY PACK M01674 PER AMM.SDR AALA201908199015Power Supply · no testAIRCRAFT IN BASE VISIT: EPSU (12WL) FAILED CIDS1 EPSU SYSTEM TEST DURING T/C 26L00025011. REMOVED AND REPLACED EPSU (12WL) IAW AMM 33-51-38 OPS CHECK. GOOD OK FOR SVC IAW AMM 33-51-38.SDR AALA201908199019Power Supply · no testAIRCRAFT IN BASE VISIT: EMERGENCY POWER SUPPLY UNIT AT LOCATION 11WL BATTERY FAILED EPSU SYS TEST IN REFERENCE WITH JOB CARD 26L00005062. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY AT LOCATION 11WL IN REFERENCE WITH AMM 33-51-38, OPERATIONAL TESDR AALA201908199020Battery · no testAIRCRAFT IN BASE VISIT: EMERGENCY BATTERY LIGHTING AT 15WL FAILED EPSU SYS TEST. EMERGENCY LIGHTING BATTERY AT LOCATION 15WL REMOVED AND REPLACED IAW AMM 33-51-38. OPS TEST GOOD. IAW AMM 33-51-38.SDR MASA2019081712005Battery · dischargedCENTER OVERHEAD EXIT SIGN INOP. CHARGED BATTERIESSDR AALA201908170001Battery · faultedBATTERY FAULT NOTED AFTER AN L2 SLIDE CHANGE ON CIDS. PART INDICATED A BATT FAULT.SDR AALA2019112709010Power Supply · inoperativeAIRCRAFT NOT GROUNDED: MAINTENANCE REPORTS WHILE PERFORMING JOB CARD 26L00025012, FOUND EPSU BAT FAULT 11WL. REMOVED AND REPLACED EPSU AT 11WL IAW AMM 33-51-38. OPS CHECK GOOD.SDR IPXA2019081645688Light · no testEMERGENCY LIGHT TEST INOPERATIVE. REPLACED THE LIGHT, OPSTESTED SYS MUPTIPLE TIMES IAW AMM 33-51-00. NO DEFECTS NOTED.SDR DALA2019082005138Lens · unknown(AIRCRAFT 7104, L/P 1225231) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:25C / ACARS TEXT: FRC 335201 25C 205 / INTERIOR. REPLACED LEFT LENS COVER @ 3L AND 25C. OPS CHKS GOOD. OK FOR SVC.SDR DALA2019082005137Lens · unknown(AIRCRAFT 7104, L/P 1225229) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:406 / ACARS TEXT: FRC 335201 406 901 / INTERIOR. REPLACED LEFT LENS COVER @ 3R AND 1L. OPS CHKS GOOD. OK FOR SVC.SDR SIMA20190816005Inverter · inoperativeFOUND INVERTER #1 INOP. C/A-REMOVED AND REPLACED INVERTER #1 IAW AMM 33-50-11. OPS CHECK GOOD.SDR DALA2019082204908Light · inoperativeSEAT 29D FLOOR PROXIMITY EMERGENCY ESCAPE PATH MARKING SYSTEM INOP. R/R SEAT-MOUNTED EMERGENCY LIGHT AT SEAT 29D PER B737 AMM 33-51. OPS CK GOOD.SDR AALA201908209018Power Supply · no testAIRCRAFT IN BASE VISIT: EMER LIGHT PWR SUPPLY M33093 ON L1 DOOR FAILED TEST. REMOVED AND REPLACED L1 M33093 PWR SUPPLY, TESTED OK.SDR AALA201908209019Power Supply · no testAIRCRAFT IN BASE VSIT: EMER LIGHT PWR SUPPLY M33409 ON R5 DOOR FAILED TEST. REMOVED AND REPLACED R5 M33409 PWR SUPPLY AND PERFORMED TEST IAW AMM 33-51-06-960-803.SDR AALA201908209020Power Supply · no testAIRCRAFT IN BASE VISIT: EMER PWR SUPPLY M33094 ON DOOR R1 FAILED TEST. REMOVED AND REPLACED R1 PWR SUPPLY M33094 AND PERFORMED TEST IAW AMM 33-51-06-960-803.SDR AALA201908209021Power Supply · no testAIRCRAFT IN BASE VISIT: EMER LIGHT PWR SUPPLY M33407 AT DOOR L5 FAILED TEST. REMOVED AND REPLACED L5 EMER PWR SUPPLY M33407 AT DOOR L5 AND PERFORMED TEST IAW AMM 33-51-06-960-803.SDR AALA201908209022Power Supply · faultyAIRCRAFT IN BASE VISIT: EMER LIGHT PWR SUPPLY M33652 AT STA 741 FAILED TEST. REMOVED AND REPLACED M33652 PWR SUPPLY AT STA 741 AND PERFORMED TEST IAW AMM 33-51-06-960-803.
Back to JASC 3350