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 AALA20180327007Light · inoperativeSEAT 3J MOUNTED EMERGENCY LIGHT INOPERATIVE. REPLACED 3J SEAT MOUNTED EMERGENCY LIGHT ASSY IAW AMM 33-51-10. OPS CHECKED NORMAL. AIRCRAFT WAS GROUNDED.SDR AALA201803289022Cover · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT COVER AT SEAT 4C MISSING. INSTALLED LIGHT COVER AT SEAT 4C.SDR AALA201803279012Lens · damagedEMERGENCY LIGHT LENS AT 4ABC DAMAGED. REPLACED EMERGENCY LIGHT ASSY IAW CMM 25-25-53. AIRCRAFT WAS GROUNDED.SDR QXEA2018032700123Battery Pack · inoperativeFORWARD EMERGENCY LIGHTS ARE INOPERATIVE. REPLACED THE BATTERY PACKS IAW AMM 33-51-00-820-801. CHCEKED GOOD.SDR AALA201803279032Lens · brokenOVERHEAD EMERGENCY LIGHT LENS BROKEN AT SEAT, L3 DOOR. REPLACED THE LENS AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR ASOA201803265094Bulb · failedDURING MX INSPECTION, THE GALLEY LOWER AFT EMERGENCY LIGHT WAS FOUND TO HAVE ONE BULB INOPERATIVE. MX REMOVED AND REPLACED THE BULB AND OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA201803265093Bulb · inoperativeDURING MX INSPECTION, THE LEFT, FWD OVERWING EMERGENCY LIGHT WAS FOUND INOPERATIVE. MX REMOVED AND REPLACED THE BULB AND OPS CHECKED GOOD. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA201803265092Bulb · inoperativeDURING MX INSPECTION, THE CEILING ROW 10 EXIT LIGHT WAS FOUND INOPERATIVE. MX REMOVED AND REPLACED THE BULB AND OPS CHECKED GOOD. THE AC WAS APPROVED FOR RETURN TO SERVICE.SDR AALA201803279015Power Supply · faultedEMERGENCY LIGHT TEST FAULTED ON THE FORWARD POWER SUPPLY UNIT. REPLACED THE POWER SUPPLY IAW AMM 35-51-38.SDR AALA201803279014Lamp · inoperativeEMERGENCY AISLE LIGHT AT SEAT 11C HAS AN INOPERATIVE LIGHT. REPLACED THE LAMPS IAW AMM 33-51-09.SDR SIMA20180326001Flashlight · inoperativeFWD CABIN FLASHLIGHT INOP. -C/A-REMOVED AND REPLACED FWD CABIN FLASHLIGHT IAW AMM 33-50-16-000-801-A AND 33-50-16-400-801-A OPC GOOD END.SDR SIMA2018032700002Lamp · inoperativeRIGHT OVERWING EMRGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMPS IAW AMM 33-50-10. OPS CHECKED GOOD.SDR AALA201803279023Lens · missingEXIT LIGHT LENS AT THE L4 DOOR MISSING. REPLACED THE LENS IAW AMM 33-50-00. OPS CHECKED GOOD.SDR MASA2018032613091Light · inoperativeROW 2 OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE.SDR DALA2018032601905Battery Pack · inoperativeTHE EMERGENCY EXIT SIGN ABOVE L1 F/A SEAT IS INOPERATIVE. MAINTENANCE TROUBLESHOT IAW ASM 33-51-0 AND REPLACED THE B5-235 BATTERY PACK IAW AMM 33-51. SYSTEM CHECKED OK.SDR CALA2018032601022Power Supply · no testAFTER EMERGENCY LIGHT CHECK, TWO MESSAGES CAME UP, EPSU UNIT AFT L, AND ESPU BATTERY FWD L. REPLACED THE POWER SUPPLY AND BATTERY IAW MM 31-51-38, AND MM 33-51-00. TESTED OK.SDR CALA2018032601021Lens · missingFOUND EMERGENCY LIGHT LENS MISSING. INSTALLED A NEW LENS IAW AMM 33-51-00.SDR CALA2018032601020Light · detachedROW 15C SEAT MOUNTED EMERGENCY LIGHT HANGING OUT AND INOPERATIVE. REPLACED THE EMERGENCY LIGHT, OPS CHECKED GOOD, OK FOR SERVICE.SDR CALA2018032601019Lens · missingEMERGENCY LIGHT DOES NOT TURN ON, LIGHT MISSING THE LENS. REPLACED LENS.SDR CALA2018032601018Light · brokenSEAT 34C EMERGENCY LIGHT IS BROKEN. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY. OK FOR SERVICE.SDR CALA2018032601015Lens · missingBROKEN EMERGENCY LIGHT, ON DIVIDER, L4 AREA AFT SEAT 41C . LENS MISSING. REPLACED THE LENS. OK.SDR CALA2018032601017Lens · brokenEMERGENCY LIGHT LENS IS BROKEN AT SEAT 20C. REPLACED THE EMERGENCY LIGHT LENS. CHECKED GOOD.SDR DALA2018032601879Lamp · inoperativeSEAT ROW 23 RT EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP. SYSTEM CHECKED GOOD.SDR SWAA2018040420961Housing · looseLEFT OVERWING EMERGENCY EXIT LIGHT HOUSING LOOSE. R & R THE LIGHT HOUSING ASSEMBLY IAW AMM.SDR SWAA2018040320881Battery Pack · inoperativeEMERGENCY LIGHT M1670 BATTERY PACK INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018040320880Battery Pack · inoperativeM1675 BATTERY PACK INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR FDEA201803250780Power Supply · inoperativeACFT FAILED AN EMERGENCY LIGHT TEST. RECEIVED A LVL 1 EMERGENCY BATTERY 1 LOW ALERT DURING TEST. R & R EMERGENCY LIGHT BATTERY POWER SUPPLY IAW AMM 33-51-01-4. OPS CHECKED NORMAL, OK FOR SERVICE.SDR AALA201803299012Battery Pack · no testEMERGENCY POWER SUPPLY UNIT BATTERIES AT 11WL AND 17WL FAILED CAPACITANCE BITE CHECK. REPLACED THE BATTERY PACKS IAW AMM 33-51-38. OPS CHECKED OK.SDR AALA201803299009Battery Pack · no testEMERGENCY LIGHT POWER SUPPLY BATTERIES FAILED A BITE CHECK IAW J/C 33C22033002 AT 17WL. REPLACED THE BATTERY PACK IAW AMM 33-51-38.SDR AALA201803299008Battery Pack · no testEMERGENCY LIGHT POWER SUPPLY BATTERIES FAILED A BITE CHECK IAW J/C 33C22033002 AT 14WL. REPLACED THE BATTERY PACK IAW AMM 33-51-38.SDR AALA201803299006Battery Pack · no testEMERGENCY LIGHT POWER SUPPLY BATTERIES FAILED A BITE CHECK IAW J/C 33C22033002 AT 13WL. REPLACED THE BATTERY PACK IAW AMM 33-51-38.SDR AALA201803279031Light · damagedSEAT 5G EMERGENCY LIGHT LOUVER DAMAGED. AIRCRAFT WAS GROUNDED. REMOVED AND REPLACED EMERGENCY LIGHT LOUVER AND LAMP ASSEMBLY IAW ESO 21377. OK FOR SERVICE.SDR AALA201803279029Light · detachedEMERGENCY EXIT LIGHT AT L3 JUMP SEAT. HANGING BY WIRES ONLY. REPLACED THE EMERGENCY EXIT SIGN IAW AMM 33-51-17. OPS CHECKED GOOD.SDR AALA20180326011Power Supply · inoperativeEMERGENCY POWER SUPPLY INOPERATIVE AT THE R2 DOOR AFT POSITION. REPLACED THE EMERGENCY POWER SUPPLY IAW AMM 33-51-06, OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201803279036Sign · crackedAFT LEFT GALLEY EMERGENCY EXIT LIGHT IDENTIFIER ASSEMBLY CRACKED. REPLACED AFT LEFT GALLEY EMERGENCY EXIT LIGHT ASSEMBLY IAW AMM 33-51-01.SDR AALA201803279035Light · damagedSEAT EMERGENCY LIGHTS DAMAGED AT ROWS 6. REPLACED SEAT EMERGENCY LIGHTS AT ROWS 6 IAW AMM 33-50-00.SDR AALA201803279034Light · damagedSEAT EMERGENCY LIGHTS DAMAGED AT ROW 8. REPLACED SEAT EMERGENCY LIGHT AT ROW 8 IAW AMM 33-50-00.SDR AALA201803279008Lens · brokenEXIT LIGHT COVER ON THE L4 DOOR FOUND BROKEN. REPLACED LIGHT COVER. OK FOR SERVICE. AIRCRAFT WAS NOT GROUNDED.SDR AALA201803279007Light · damagedSEAT EMERGENCY LIGHT DAMAGED AT ROW 12. REPLACED SEAT EMERGENCY LIGHT AT ROW 12 IAW AMM 33-50-00.SDR QXEA2018032700119Light · looseEMERGENCY LIGHT STRIP CAME LOOSE OF FLOOR. OUT OF SERVICE. REMOVED AND REPLACED THE EMERGENCY LIGHT. RETURNED TO SERVICE.SDR AALA201803279024Sign · detachedL4 DOOR OVERHEAD EXIT SIGN WOULD NOT STAY ATTACHED. MAINTENANCE ATTACHED THE SIGN IAW MM 33-50-00, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201803279021Lens · brokenL3 DOOR EXIT LIGHT LENS ON DOOR FRAME BROKEN. REPLACED THE LENS. OPS CHECKED OK.SDR SWAA2018032720707Light · brokenLEFT EMERGENCY EXIT LIGHT HOUSING BROKEN AT ROW 1. R & R THE LIGHT IAW AMM.SDR SWAA2018032720706Battery Pack · inoperativeLEFT FORWARD EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR ASAA2018032524030Lamp · inoperativeEMERGENCY LIGHT RIGHT AFT FUSELAGE SLIDE LIGHT INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-04-960-801. OPS NORMAL.SDR SWAA2018032620674Lens · brokenLEFT AFT GALLEY EMERGENCY EXIT LIGHT COVER BROKEN. R & R THE LIGHT ASSEMBLY IAW AMM.SDR DALA2018032601904Battery Pack · inoperativeEMERGENCY CEILING LIGHTS ARE INOPERATIVE BETWEEN SEAT ROWS 1 AND 13. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-51-03. EMERGENCY LIGHT OPS NORMAL.SDR DALA2018032601880Battery Pack · inoperativeB5-105 BATTERY PACK WON`T TURN ON AFT OVERWING EMERGENCY LIGHTS. REPLACED THE BATTERY PACK. CHECKED GOOD IAW WDM 33-51 AND SPWM 20.SDR AALA201803289002Lens · detachedL1 CABIN EMERGENCY EXIT LIGHT COVER WONT STAY ON. VERIFIED ALL LIGHT LENSES AT THE L1 DOOR AREA ACCOUNTED FOR. NO FAULTS NOTED. LENS SYSTEM OPERATIONS CHECK NORMAL PER MM 33-51-00.SDR YENA201803240151Battery Pack · failedCENTER CEILING EMERGENCY LIGHT INOPERATIVE. R & R THE POWER SUPPLY IAW AMM 33-50-01. OPS CHECKED GOOD.
Back to JASC 3350