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 AALA20170210005Pin · missingOVERHEAD EMERGENCY EXIT SIGN BY SEAT 24D IS MISSING A PIN. SECURED IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA20170209006Connector · unsecureEMERGENCY LIGHTS AT SEATS 10DEF AND 13DEF ARE INOPERATIVE. AIRCRAFT WAS GROUNDED. SECURED THE CONNECTOR AT ROW 13 BATTERY PACK IAW AMM 33-51-00. OPS CHECKED GOOD.SDR DALA2017020901066Cover · missingMAINTENANCE DISCOVERED THAT THE EMERGENCY EXIT SIGN DIFFUSER COVER WAS MISSING. MAINTENANCE REPLACED THE COVER AND THE OPS CHECKED GOOD.SDR DALA2017020901126Light · looseEMERGENCY FLOOR LIGHTING DISLODGED, SECURED LIGHT AT 16CSDR REXA2017020800188Lamp · inoperativeDURING WALKAROUND, FOUND LEFT HAND AFT WING EMERGENCY LIGHT NOT ILLUMINATED. REPLACED THE LAMPS IAW AMM 33-51-21. OPS CHECKED GOOD.SDR DALA2017020901104Power Supply · inoperativeON SVC CK FOUND FWD GALLEY EMERG EXIT SIGN INOP AT POSITION (M730). R&R POWER SUPPLY (M730) IAW AMM 33-51. VERIFIED EFFECTIVITY IAW IPC 33-51-07-50 ITEM 058. OPS CK GOOD.SDR DALA2017020901103Light · inoperativeL3/R3 EXTERIOR DOOR EGRESS LIGHTS INOP. R&R L3&R3 EXTERIOR DOOR EGRESS LAMPS IAW AMM 33-51-06-962. OPS CHECKS GOOD.SDR DALA2017020901102Battery Pack · dischargedEGRESS LIGHTS AT RT OVERWING EXIT ROWS TURN OFF AFTER 30 SEC. R&R BATTERY PACK AT SEAT ROW 9A/B IAW AMM 33-51-07-902. OPS CHECKS GOOD.SDR DALA2017020901097Cover · missingEMERGENCY FLOOR LIGHTING RED AND WHITE COVERS MISSING AT 4L & 4R. RED FLOOR PROX COVERS REPLACED AT DR 4L & 4R PER AMM 33-50. WHITE FLOOR PROX COVER INSTALLED PER AMM 33-50.SDR AALA201702099011Lens · looseAFT LEFT GALLEY EMERGENCY EXIT LIGHT LENS LOOSE. INSTALLED THE LENS.SDR AALA201702099009Lens · missingR4 CABIN ENTRY DOOR MISSING THE EXIT SIGN LENS ON LOWER HALF OF DOOR. REPLACED LENS.SDR AALA201702099008Lens · missingR4 DOOR EXIT SIGN LENS MISSING. REPLACED THE LENSSDR DALA2017020901094Lens · missingDURING INSPECTION FOUND ILLUMINATED EMERGENCY EXIT SIGN LENS COVER MISSING AT DOOR 2R. MAINTENANCE REPLACED LENS COVER ON DOOR 2R EMERGENCY EXIT LIGHT REF AMM 33-51.SDR JJBA20170208008Lamp · inoperativeOVERWING EMERGENCY EXIT LIGHT FOR THE LT DOOR INOPERATIVE. REPLACED THE LAMP. OPS CHECKED GOOD.SDR SWAA2017020811755Lens · crackedLT OVERHEAD EMERGENCY LIGHT LENS CRACKED BETWEEN ROW 15 TO ROW 27. R&R LENS IAW AMM.SDR SWAA2017020811734Lens · crackedRT OVERHEAD EMERGENCY LIGHT LENS CRACKED BETWEEN ROW 17 TO ROW 25. R&R LENS IAW AMM.SDR JJBA20170208007Inverter · inoperativeEMERGENCY EXIT LIGHT AT FWD SERVICE DOOR INOPERATIVE. R & R THE INVERTER. OPS CHECKED GOOD.SDR QXEA2017020800048Cover · brokenEMERGENCY LIGHT SWITCH COVER BROKEN AT FORWARD FA STATION. REPLACED THE SWITCH COVER. CHECKS GOOD. RETURNED TO SERVICE.SDR SWAA2017022312059Lens · brokenFORWARD GALLEY AREA EMERGENCY EXIT LIGHT LENS BROKEN. R&R LENS IAW AMM.SDR SWAA2017021311828Lens · crackedRIGHT OVERWING ABOVE DOOR EMERGENCY EXIT LIGHT LENS CRACKED. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2017021311812Lens · missingLEFT OVERHEAD BIN EMERGENCY LIGHT LENS MISSING AT ROW 2. INSTALLED A NEW LENS IAW AMM.SDR SWAA2017021311798Bulb · inoperativeLEFT FORWARD ENTRY THRESHOLD EMERGENCY EXIT LIGHT, BULB INOPERATIVE. REPLACED THE BULB IAW MM.SDR CALA2017021000303Light · inoperativeSEAT 6DG FWD PARTITION EMERGENCY LIGHT FOUND BROKEN. REPLACED THE EMERGENCY LIGHT ASSY AND OPS TESTED AND FOUND NORMAL IAW AMM 33-51-00-710-801 REV .78.SDR SIMA20170207003Light · inoperativeEMERGENCY FLOOR PROXIMITY LIGHTING STRIP AT ROWS 15 AND 16 INOP. REMOVED AND REPLACED EMERGENCY FLOOR PROXIMITY LIGHTING STRIP AT ROWS 15-16 IAW AMM33-50-12. OPS CHECK GOOD.SDR 29EA02092017Battery Pack · faultyDURING DAILY CHECK FOUND EMERGENCY ROW 13, 15, 17 LIGHTS INOP. T/S EMERGENCY LIGHTS AT ROW 13, 15, 17 IAW WDM 33-51-13 FOUND POWER SUPPLY (M1670) BATTERY PACK FAULTY. REMOVED AND REPLACED POWER SUPPLY BATTERY PACK IAW AMM 33-51-06, OPS CHECK NORMAL.SDR SWAA2017020911774Battery Pack · failedAFT GALLEY RT EMERGENCY BATTERY PACK FAILED CAPACITY TEST. R&R BATTERY PACK PER M/M.SDR SWAA2017020911773Battery Pack · failedAFT GALLEY LT EMERGENCY BATTERY PACK FAILED CAPACITY TEST. R&R BATTERY PACK PER M/M.SDR SWAA2017020911772Battery Pack · failedLT EMERGENCY BATTERY PACK FAILED CAPACITY TEST AT ROW 17. R&R BATTERY PACK PER M/M.SDR SWAA2017020911770Battery Pack · failedRT OVER WING EMERGENCY EXIT BATTERY PACK FAILED CAPACITY TEST. R&R BATTERY PACK PER M/M.SDR SWAA2017020911769Battery Pack · failedLT OVER WING EXIT EMERGENCY BATTERY PACK FAILED CAPACITY TEST. R&R BATTERY PACK PER M/M.SDR ASAA2017020719733Lens · detachedF/A REPORTS CENTER AFT EXIT SIGN COVER FELL OFF. GROUNDED - YES. REINSTALLED CENTER AFT EXIT SIGN COVER, NO DEFECTS NOTED, SECURITY CHECK GOOD.SDR N6WA2017020701Light · looseEMERGENCY ESCAPE PATH STRIP LOOSE AT 23CD. REATTACHED EMERGENCY LIGHT STRIP ON AISLE BY SEATS 23CD AS REQ'D.SDR QXEA2017020800047Light · looseF/A REPORTS THAT FLOOR PATH LIGHT STRIP NEAR MAIN CABIN DOOR LOOSE. RE-SECURED THE FLOOR STRIP. CHECKS GOOD. RETURNED TO SERVICE.SDR IPXA2017020713803Relay · false indicationDURING EMERGENCY LIGHT TEST, EMERGENCY LIGHT BATTERY 1 LOW AMBER ALERT APPEARED. RELAY CHANGED IAW SWPM 20-15-46 REV 63.01SDR SIMA20170207002Battery Pack · inoperativeFWD CABIN FLOOR PROXIMITY STRIP LIGHT AND EXTERIOR FWD EMERGENCY LIGHT INOPERATIVE. TROUBLESHOT IAW FIM 33-50-00-810-804-A FOUND NR 2 EMERGENCY BACKUP BATTERY BECAME DISCONNECTED FROM BATTERY HOLDER ASSY AND BENT BATTERY CONNECTIONS. R & R NR 2 EMERGENCY BACKSDR AALA201702089008Lens · missingEMERGENCY LIGHT LENS MISSING. INSTALLED A NEW LENS.SDR AALA201702089007Power Supply · no testAFT ESPU FAILED EMERGENCY LIGHT TEST. REPLACED THE ESPU IAW AMM 33-51-38.SDR AALA201702089006Cover · missingAIRCRAFT NOT GROUNDED. L4 DOOR EMERGENCY LIGHT COVER MISSING. INSTALLED A NEW LIGHT COVER.SDR AALA201702089005Cover · missingR4 DOOR EMERGENCY LIGHT COVER MISSING. INSTALLED THE COVER.SDR AALA201702089004Cover · missingAIRCRAFT R4 DOOR LOWER EMERGENCY EXIT LIGHT COVER IS MISSING. REPLACED THE COVER.SDR AALA201702089003Cover · brokenEMERGENCY LIGHT COVER BROKEN ON SEAT 9D. REPLACED THE COVER.SDR AALA201702089002Lens · brokenR2 DOOR EMERGENCY LIGHT LENS IS BROKEN .INSTALLED A NEW LENS.SDR HNAA2017020800044Lamp · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 2 INOPERATIVE. R & R THE LAMP.SDR HNAA2017020800043Bulb · inoperativeEMERGENCY LIGHT INOPERATIVE RT AFT FUSELAGE. R & R THE BULB.SDR FDEA201702070448Battery Pack · inoperativeDURING PRE FLIGHT CHECK, FOUND RT EMERGENCY EXIT LIGHT AND SLIDE LIGHT INOPERATIVE. WILL NOT TEST. REMOVED AND REPLACED NR 2 EMERGENCY POWER SUPPLY BATTERY PACK. EMERGENCY LIGHTS TEST GOOD IAW AMM 33-51-07-2. ACFT OK FOR SERVICE.SDR HNAA2017020800042Light · inoperativeEMERGENCY LIGHTS INOPERATIVE. R & R THE LIGHT ASSY.SDR HNAA2017020800041Bulb · inoperativeFIRST RED EMERGENCY LIGHT INOPERATIVE AT ROW 1. R & R BULB.SDR MASA2017020712588Lamp · inoperativeROW 15 CEILING LEVEL EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP.SDR AALA20170212007Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. DOOR L1 OVERHEAD PANEL EMERGENCY POWER SUPPLY (PACK) M33424 FAILED. LOADING EMERGENCY LIGHT DO NOT COME ON AND CANNOT RECHARGE BATTERY. REPLACED POWER SUPPLY (PACK) PER AMM 33-51-06.SDR AALA20170212006Power Supply · failedAIRCRAFT IN BASE MAINTENANCE. CABIN R1 DOOR EMERGENCY LIGHT POWER SUPPLY (PACK) M33094 DEEP CYCLE CHECK FAILED. REPLACED POWER SUPPLY (PACK) PER AMM 33-51-06.
Back to JASC 3350