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 SIMA20161023003Lamp · inoperativeRT EXTERIOR EMERGENCY LIGHT JUST AFT OF EMERGENCY EXIT DOOR INOPERATIVE. REMOVED AND REPLACED THE LAMP.SDR DALA2016103108096Light · inoperative4R EXTERIOR EMERG LIGHT RELAMP. REPLACED DOOR 4R SLIDE LIGHT ASSY PER AMM33-51. VISUALLY CHECKED ELEC WIRE BEHIND THE LIGHT ASSY THEN NTF. ALSO CHECKED GRD/PWR WITH MULTIMETER, NTF REF WDM33-51 CHECKED.SDR DALA2016102607690Light · damagedDURING INSPECTION FOUND SEAT 28D ESCAPE PATH LIGHTING ASSY DAMAGED. MAINTENANCE PLACED ITEM ON MEL.SDR REXA2016102202011Light · missingFLOOR EMERGENCY TRACK LIGHTING PIECE IS MISSING NEAR SEAT 12B. RESECURED EMERGENCY LIGHT STRIP ON SEAT 12B IAW AMM 33-51-01. OK FOR SV
C.SDR AALA201610239005Lens · missingR3 CROSS ISLE WALL MOUNTED LIGHT UNIT MISSING LENS COVER. INSTALLED MISSING LENS COVER.SDR DALA2016102407587Light · brokenAFT GALLEY RIGHT STORAGE TRIM EMERGENCY LIGHT BROKEN. RELAMPED AFT GALLEY RIGHT STORAGE TRIM EMERGENCY LIGHT.SDR AALA201610239007Light · brokenAIRCRAFT WAS NOT GROUNDED: RED EMERGENCY LIGHT ASSEMBLY BROKEN AT ROW 22L. REPLACED RED EMERGENCY LIGHT ASSEMBLY AT ROW 22L AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201610239006Cover · missingEMERGENCY EXIT LIGHT COVER MISSING IN AFT GALLEY. INSTALLED LIGHT COVER AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201610239004Lens · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT LENS MISSING FROM DOOR 2R. INSTALLED MISSING LENS.SDR SWAA2016102509066Light · inoperativeCENTER PEDESTAL OVERHEAD PANEL EMERGENCY EXIT LIGHTS INOP. R&R LIGHT PER SIP.SDR SWAA2016102408984Sign · detachedL1 DOOR EXIT SIGN FELL OFF. SECURED THE SIGN IAW SIP.SDR QXEA2016102400674Lamp · inoperativeAFT LEFT EMERGENCY EGRESS LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-11-000-801 AND 33-51-11-400-801. CHECKED GOOD.SDR AALA20161022002Battery · failedRIGHT AFT GALLEY FLIGHT ATTENDANT JUMPSEAT EMERGENCY FLASHLIGHT FAILED TEST. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-00. OPS CHECKED GOOD.SDR DALA2016102407478Lens · missingMID CABIN CEILING EMERGENCY EXIT LENS COVER MISSING. REINSTALLED THE LENS.SDR DALA2016102407470Lens · wrong partDURING SERVICE CHECK, FOUND THE RT FWD OVERWING EXIT SIGN WITH THE INCORRECT LENS INSTALLED. INSTALLED THE CORRECT LENS.SDR DALA2016102407461Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING FOR THE TAIL COMPARTMENT WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACKS AND THE OPS CHECKED GOOD.SDR JJBA20161022030Light · inoperativeEMERGENCY LIGHT OVER ROW 18A INOPERATIVE. SEATED THE LIGHT STRIP. OPS CHECKED GOOD.SDR DALA2016110108090Lens · damagedEMERGENCY FLOOR LIGHTING DAMAGED. REPLACED THE LENS.SDR DALA2016110108085Lens · missingAFT GALLEY ACROSS FROM R4 DOOR AT FLOOR LEVEL EMERGENCY LIGHT LENS MISSING. INSTALLED LENS.SDR DALA2016110108084Lens · missingAFT GALLEY ACROSS FROM L4 DOOR AT FLOOR LEVEL EMERGENCY LIGHT LENS MISSING. INSTALLED LENS.SDR DALA2016110108083Lamp · inoperativeSEAT 11C EMERGENCY LIGHT INOPERATIVE AND LENS MISSING. REPLACED THE LAMP AND INSTALLED LENS.SDR AALA201610229017Power Supply · shortedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER 13WL FAILED DUE TO SEAT ROW 22ABC WIRING HARNESS SHORTED TO SEAT, DURING HEAVY MAINTENANCE CHECK FAILURE SELF INDUCED. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT 13WL AND ACCOMPLISHED A SATISFACTORYSDR DALA2016102407620Lamp · inoperativeEMERGENCY LIGHT ARE INOPERATIVE AT DOOR R1 EXTERIOR. MAINTENANCE REPLACED THE LAMPS. SYSTEM OPS NORMAL.SDR DALA2016102407619Lamp · inoperativeEMERGENCY LIGHTS INOPERATIVE ON LEFT SIDE BETWEEN AFT/BODY FAIRING OF L2 DOOR. REPLACED THE LAMP. SYSTEM OPS NORMAL.SDR AALA201610229012Lens · crackedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN DOOR SURROUND PANEL 226 CREW EXIT LIGHT LENS IS CRACKED. REMOVED AND REPLACED MAIN CABIN DOOR SURROUND PANEL 226 CREW EXIT LIGHT LENS AND PERFORMED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-50-15 & 33-50-00-710-801.SDR AALA201610229011Lens · crackedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN DOOR SURROUND PANEL 252 HRW EXIT LIGHT LENS COVER IS CRACKED. REMOVED AND REPLACED MAIN CAB EXIT LIGHT ASSEMBLY PANEL 252 AT MAIN DOOR SURROUND AND PERFORMED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-50-00-710-801.SDR AALA201610229010Light · crackedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN DOOR SURROUND PANEL 251 HLW EXIT LIGHT LENS COVER IS CRACKED. REMOVED AND REPLACED MAIN CAB DOOR SURROUND PANEL 251 HLW EXIT LIGHT AND PERFORMED A SATISFACTORY OPERATIONAL CHECK PER 33-50-15 AND 33-50-00-710-801.SDR RAIA201610210002Bulb · inoperativeCEILING EMERGENCY EXIT LIGHT AT ROW 3 INOPERATIVE. R & R THE BULB. OPS CHECKED GOOD.SDR RAIA201610210001Light · malfunctionedLEFT AFT OVERWING EMERGENCY LIGHT IS INOPERATIVE. OPS CHECKED GOOD.SDR SWAA2016102509082Lens · dirtyLT OVERWING ESCAPE LIGHT LENS DIRTY BETWEEN BS 547 TO BS 757, LBL 51. R&R LENS ASSEMBLY IAW AMM.SDR SWAA2016102509063Cover · misalignedL2 DOOR EMERGENCY EXIT LIGHT COVER MISALIGNED. ALIGNED COVER IAW AMM.SDR DALA2016102407553Cover · loose(LOG 8862596) DURING INSPECTION FOUND EMERGENCY LIGHTS CHECK FOUND 2R DOOR EXIT SIGN LENS COVER MISSING. MAINTENANCE REPLACED MISSING EMERGENCY EXIT SIGN LENS.SDR DALA2016102107549Light · inoperativeFOUND EMERGENCY LIGHT IN CEILING OF FIRST CLASS INOPERATIVE. REPLACED THE LIGHT ASSEMBLY IN CEILING AT ROWS 1AB.SDR AALA201610229014Light · brokenPASSENGER SEAT 1H EMERGENCY LIGHT HAS BROKEN CONTACT PIN. REPLACED LIGHT IAW AMM 33-51-12-00-814-A, AMM 33-51-12-400-814-A AND ACCOMPLISHED SATISFACTORY CHECK.SDR DALA2016102407544Battery · dischargedCEILING EMERGENCY LIGHTS INOP BETWEEN ROW 21 AND 34. REPLACED BATTERIES IN EMERGENCY POWER PACK FOR LIGHTS AT ROW 21-34 CHECKS GOOD IAW AMM 33-53.SDR SWAA2016102409060Cover · crackedLT EMERGENCY LIGHT COVER CRACKED BETWEEN ROW 12 TO ROW 23. R&R COVER PER MM.SDR SWAA2016102409024Cover · looseR1 DOOR EMERGENCY EXIT LIGHT COVER LOOSE. R&R COVER PER MM.SDR SWAA2016102408990Lamp · inoperativeRIGHT OVERWING DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWAA2016102408987Battery Pack · no testRIGHT EMERGENCY LIGHT FAILED CAPACITY TEST. R & R THE BATTERY PACK IAW DWG.SDR SWAA2016102408985Lens · looseR1 DOOR EMERGENCY SLIDE LENS LOOSE. R & R THE LENS IAW MT & AMM.SDR SWAA2016102408983Cover · missingR1 DOOR LOWER EXIT SIGN LENS COVER MISSING DIRECTIONAL ARROW. R & R THE COVER IAW CMM.SDR SWAA2016102408978Lens · missingRT AFT EMERGENCY EXIT SIGN LENS MISSING. INSTALLED LENS IAW AMM.SDR DALA2016102407495Power Supply · inoperativeDURING SERVICE CHECK, HAD AFT LEFT EPSU MESSAGE ON F/A PANEL. REPLACED EMERGENCY POWER SUPPLY UNIT AND BATTERY AT AFT LEFT POWER SUPPLY,SDR ASAA2016102118446Power Supply · failedDURING EMERGENCY LIGHTS TEST, FOUND THE RT AFT EMERGENCY POWER SUPPLY INOPERATIVE. ACFT GROUNDED. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06/201. OPS CHECK GOOD. OK FOR SERVICE.SDR SIMA20161021001Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-10-000-801-A & 33-50-10-400-801-A. OPS CHECKED GOOD.SDR DALA2016102407476Cover · missingOVERWING CEILING EMERGENCY EXIT COVER MISSING. INSTALLED THE COVER.SDR N6WA2016102102Bulb · inoperativeROW 12 EMERGENCY CEILING LIGHT INOPERATIVE. R & R THE BULB IAW AMM 33-51-04. OPS CHECKED GOOD.SDR CALA2016102100799Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED L2 EXTERIOR EMERGENCY LIGHT BULB IAW AMM 3 3-51-00. OPS CHECK GOOD.SDR QXEA2016102100672Battery Pack · malfunctionedALL OF EPS3 EMERGENCY LIGHTS COME ON WHEN AIRCRAFT POWER IS OFF. REPLACED EPS3 BATTERY PACK IAW AMM 33-51-01. CHECKS GOOD. RETURNED TO SERVICE.SDR A6WA201644451Light · inoperativeAFT SECTION FLOOR EMERGENCY LIGHTS INOP. ROWS 9 -12.
Back to JASC 3350