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 JJBA20171101005Light · inoperativeEMERGENCY LIGHT OVER PAX DOOR INOP. R&R EGRESS LAMP LIGHT BULBS (X15)IAW AMM 33-51-00. NO FURTHER DEFECT.SDR SWAA2017110117535Lens · damagedRT EMERGENCY EXIT LIGHT LENS DAMAGED AT ROW 25. R&R LENS IAW AMM.SDR SWAA2017110117511Lens · damagedLT EMERGENCY EXIT LIGHT LENS DAMAGED BETWEEN ROW 23 TO ROW 27. R&R LENS IAW AMM.SDR SIMA20171101001Battery · dischargedLT AND RT OVERWING EMERGENCY LIGHT INOP. REPLACED NR 4 EMERGENCY BATTERY AND BATTERY POWER SUPPLY IAW AMM 33-50-04 OPS GOOD. BATTERY CHARGER ASSY P/N 11-0049 S/N 19591.SDR MASA2017110112737Light · inoperativeROW 6 EMERG CEIL LIGHT INOP. PLACED ON MEL.SDR I5EA201711010002Battery Pack · dischargedFWD LT EMERGENCY BATTERY LOW ON CHARGE. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-51. OPERATION CHECK NORMALSDR I5EA20171101001Battery Pack · dischargedFED RT EMERGENCY BATTERY LOW ON CHARGE. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-51. OPERATION CHECK NORMAL.SDR MASA2017110112734Battery · dischargedMULTIPLE EMER LIGHTS INOP. CHARGED BATTERIES.SDR AALA201711019038Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT OVERHEAD AISLE ABOVE SEAT 40H IS INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY M33408 PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201711019037Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT AT THE FORWARD GALLEY HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR SWAA2017110317579Battery Pack · inoperativeR1 DOOR SLIDE LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017110317578Battery Pack · inoperativeLEFT FORWARD EMERGENCY EXIT SIGN LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017110317573Battery Pack · inoperativeFORWARD RIGHT EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017110317564Cover · brokenLT OVERWING BULKHEAD EMERGENCY LIGHT COVER BROKEN. REPAIRED COVER PER SIP.SDR SWAA2017110317560Battery Pack · disconnectedRT EMERGENCY EXIT STOWBIN LIGHTS INOP BETWEEN ROW 3 TO ROW 6. RECONNECTED BATTERY PACK PER AMM.SDR SWAA2017110317559Battery Pack · disconnectedG1 GALLEY EMERGENCY EXIT LIGHT INOP. RECONNECTED BATTERY PACK PER AMM.SDR SWAA2017110317558Battery Pack · disconnectedR1 DOOR EGRESS LIGHT INOP. RECONNECTED BATTERY PACK PER AMM.SDR JJBA20171031004Light · inoperativeFWD CABIN BULKHEAD EMERGENCY LIGHT WILL NOT ILLUMINATE. PERFORMED OPS CK IRW AMM 33-50-00.SDR SWAA2017110217494Lens · unsecureCEILING OVERWING EMERGENCY EXIT LIGHT LENS CAME OFF. SECURED LENS ASSEMBLY PER AMM.SDR DALA2017110107918Relay · inoperativeEMERGENCY EXIT SIGN INOPERATIVE, REPLACED THE POWER SUPPLY RELAY.SDR AALA201711019039Lens · crackedR1 DOOR EXIT LIGHT LENS CRACKED. REPLACED EMERGENCY LIGHT LENS.SDR ASOA201711017025Battery Pack · dischargedEMERGENCY LIGHT BATTERY INOPERATIVE. REMOVED AND REPLACED BATTERY, OPERATIONAL CHECK WAS SATISFACTORY IAW AMM 33-50-00.SDR ASAA2017103122371Battery Pack · no testDURING T/C 78233001, EMERGENCY LIGHT SWITCH OPS CHECKED AND BATTERY PACKS FUNCTIONAL CHECKED, R1 DOOR EMERGENCY EXIT SIGN AND R1 FUSELAGE LIGHT FAILED A BATTERY PACK CAPACITY CHECK. ACFT GROUNDED. REPLACED THE BATTERY PACK, M1674 IAW AMM 33-51-06-960-805, SDR DALA2017103107889Battery Pack · dischargedFOUND LT + RT AFT DOORS EMERGENCY EXIT LIGHTS INOP WHEN CHECKING EMERGENCY LIGHT IN CABIN. R&R BATTERY PACK FOR M1210 OPS CHECKS GOOD IAW AMM 33-51.SDR DALA2017103107887Battery · dischargedEMERGENCY EXIT SIGNS AT 4 L&R ATTACHED TO BATT CHARGER M1210 WILL NOT TEST WITH PTT SWITCH. REPLACED POWER SUPPLY M1210 BATTERY REF AMM 33-51. OPS CHECK GOOD. OK FOR SVC.SDR IPXA2017103123128Sign · inoperativeEMERGENCY EXIT SIGN OVER CREW ENTRY DOOR REMARKED FOR MA. REINSTALLED SAME EMERGENCY EXIT SIGN OVER CREW ENTRY DOOR PER AMM 33-51-01-402-003 & OPS CHECKS NORMAL PER SAME AMM OK FOR SERVICE.SDR QXEA2017110100658Light · loosePAX EMERGENCY FLOOR PATH LIGHT STRIP DOES NOT ALIGN PROPERLY ON FLOOR PANEL 133JZ. REPAIRED.SDR KCSA201710311073Light · inoperativeMAIN DECK L1 DOOR EMERGENCY LIGHT INOP.SDR REXA2017103101137Light · burned outPAX ENTRY FLOOR LEVEL EMERGENCY FLOODLIGHT COVER DEGRADED + LAMP BURNT. R&R FLOOR LEVEL EMERGENCY FLOOD LIGHT COVER + RE-LAMPED IAW AMM 33-51-19. OPS CHECK GOOD. P/N BC5-0393-103 / PN 6100928V17023.SDR AALA201710319028Guard · brokenTHE AIRCRAFT WAS NOT GROUNDED. L1 FWD LEFT ENTRY DOOR GUARDED EMERGENCY LIGHT SWITCH INOP. THE GUARD IS BROKEN. REPLACED LI FWD ENTRY DOOR EMERGENCY LIGHT SWITCH GUARD ON F/A PANEL AS REQUIRED. OP CHK GOOD.SDR AALA201710319041Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE L2 DOOR HAS A DETACHED LENS COVER. REPLACED EXIT LIGHT ASSEMBLY PER AMM 33-51-21. OPERATIONAL CHECK GOOD.SDR AALA20171030007Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT THE L1 DOOR HAS A BROKEN LENS COVER. REPLACED LENS COVER PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR CALA2017110303882Battery Pack · inoperativeEMERGENCY AISLE LIGHTS DO NOT ILLUMINATE FROM SEAT ROWS 20DEF TO 26DEF. REMOVED AND REPLACED POWER SUPPLY BATTERY PACK AT M1671 IAW AMM 33-51-06-960-805. OPS CHECKED GOOD.SDR CALA2017110303881Battery Pack · inoperativeRIGHT FUSELAGE EMERGENCY LIGHT AFT OF WING DOES NOT ILLUMINATE. REMOVED AND REPLACED THE POWER SUPPLY BATTERY PACK AT M1671 IAW AMM 33-51-06-960-805. OPS CHECKED GOOD.SDR CALA2017110303880Battery Pack · inoperativeRIGHT AFT OVERWING EMERGENCY EXIT EXTERIOR LIGHT DOES NOT ILLUMINATE. REMOVED AND REPLACED POWER SUPPLY BATTERY PACK AT M1671 IAW AMM 33-51-06-960-805. OPS CHECKED GOOD.SDR YENA201710300881Battery Pack · inoperativeDURING HEAVY MAINTENANCE, EMERGENCY LIGHT BATTERY 10WL FAILS TEST FOR BATTERY. REMOVED AND REPLACED BATTERY PACK, OPS CHECKED GOOD IAW AMM 33-51-38-000-001A.SDR SWAA2017110117529Lens · looseRT OVERWING EMERGENCY EXIT LOWER EXIT SIGN LENS LOOSE. INSTALLED LENS ASSEMBLY PER AMM.SDR JJBA20171030001Battery · dischargedEMERGENCY LIGHTS WILL NOT TURN ON. RECHARGED BATTERIES FOR EMERGENCY LIGHTS IAW AMM 33-50-08.SDR SWAA2017110217492Cover · unsecureMID CABIN OVERHEAD SIGN ASSEMBLY EXIT/SALIDA SIGN LIGHT COVER FELL OFF. SECURED COVER IAW AMM.SDR DALA2017103007908Lamp · inoperativeR1 DOOR SLIDE LIGHT INOPERATIVE. REPLACED THE LAMPS. SLIDE LIGHT OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR DALA2017103107905Lamp · inoperativeCEILING EMERGENCY LIGHT ABOVE SEAT 8A IS INOPERATIVE. REPLACED THE LAMPS, OPS CKS NORMAL.SDR DALA2017103107904Lamp · inoperativeLOWER CREW REST HORIZONTAL EXIT SIGN IS INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED NORMAL.SDR DALA2017103107903Sign · inoperativeLOWER CREW REST VERTICAL EXIT SIGN IS INOPERATIVE.SDR DALA2017103107902Charger · inoperativeSEAT EMERGENCY LIGHTS AT ROWS 32A/F INOPERATIVE. R & R BATTERY CHARGER M9010 IAW AMM 33-51.SDR DALA2017103107890Charger · inoperativePATH LIGHTS 38-45 F & G INOP. R&R BATT CHARGER PER AMM 33-51. OPS CK NML. OK FOR SVC.SDR GTIA2017103002216Power Supply · failedPOWER SUPPLIES 10WL AND 13WL FAILED CAPACITY CHECK. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR GTIA2017103002215Power Supply · no testPOWER SUPPLY 11WL AND 12WL FAILED A CAPACITY CHECK. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-38 OPS CHECKED GOODSDR AALA201710319007Director · erraticDOOR 3L EMER EXIT ON DURING FLIGHT. CYCLED EMERGENCY LIGHTS, OPS CHECK OK PER AMM.SDR AALA201710319002Light · inoperativeSEATS 32C,27C,20C,16C,12C EMERGENCY EXIT LIGHT ARE OUT. REPLACED LIGHT BULBS AND BITE TEST EMERGENCY POWER SUPPLY PER AMM.SDR AALA201710319001Panel · looseNR 1 L1 DOOR FWD EXIT SIN LIGHT PANEL LOOSE. RE-SECURED PANEL PER AMM.
Back to JASC 3350