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 SWAA2018042021301Power Supply · inoperativeMID CABIN EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE POWER SUPPLY IAW MM.SDR SWAA2018042021296Lens · missingAFT GALLEY EXIT SIGN MISSING THE LENS. REPLACED THE LENS IAW MM.SDR AALA201804199029Housing · brokenPLASTIC EMERGENCY LIGHT HOUSING BROKEN ON SEATS 9L, 10L, 12L, AND 14L. REPLACED THE EMERGENCY LIGHT HOUSINGS IAW CMM 25-22-52.SDR SIMA201804194006Switch · brokenSWITCH FOR OVERHEAD PANEL EMERGENCY LIGHTS BROKE OFF. REPLACED THE LIGHT SWITCH IAW AMM 20-13-03 & OPS CHECKED IAW AMM 33-50-00. SYSTEM WORKING PROPERLY.SDR RAIA2018041901Bulb · inoperativeRIGHT AFT OVERWING EMERGENCY LIGHT NR 6 IS INOPERATIVE. R & R THE BULB. OPS CHECKED GOOD.SDR DALA2018041802638Battery Pack · inoperativeL4 EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE BATTERY AND CHARGER M736 IAW WDM 33-51.SDR U2RA20180419001Bulb · inoperativeWITH THE EMERGENCY LIGHTS ON , THE AFT LEFT EXIT SIGN HAS ONLY 3 LIGHT BULBS WORKING.. REPLACED THE BULBS IAW AMM 33-51-10. OPS TESTED SATISFACTORY.SDR MASA2018041813152Light · inoperativeCEILING EMERGENCY FLOOD LIGHT INOPERATIVE AT ROW 11.SDR MASA2018041813151Light · inoperativeCEILING FLOOD EMERGENCY LIGHT INOPERATIVE AT ROW 9.SDR MASA2018041813150Light · inoperativeFWD GALLEY PHOTOLUMINCSENT LIGHTS INOPERATIVE. REPLACED THE LIGHT.SDR MASA2018041813149Lamp · inoperativeEMERGENCY FLOOD LIGHT INOPERATIVE AT ROW 15. REPLACED THE LAMPS.SDR MASA2018041813148Light · inoperativeEMERGENCY FLOOD LIGHT INOPERATIVE AT ROW 18.SDR CALA2018041801178Light · inoperativeEMERGENCY LIGHTS INOPERATIVE AT SEAT ROWS 7 - 14, 29 - 38, RT OVERWING EXITS AND RT AFT DOOR. FOUND BLOWN FUSES IN THE POWER SUPPLYS M1694, M1695, AND M1672. A BAD BATTERY AT M1676. REPLACED THE BATTERY CHARGERS M1694, M1695, M1672, AND REPLACED BATTERY AT SDR DALA2018041802583Light · inoperativeSEVERAL CEILING EMERGENCY LIGHTS WERE FOUND TO BE INOPERATIVE. MAINTENANCE RELAMPED THEM ALL PER AMM 33-51. OPERATIONAL CHECK WAS GOOD.SDR AALA201804239014Lens · missingSEAT 1E MISSING THE EMERGENCY LIGHT LENS ON THE ARM REST. REPLACED THE LENS. THE AIRCRAFT WAS GROUNDED.SDR AALA201804209010Lens · missingSEAT 3E MISSING EMERGENCY AISLE LIGHT LENS AFT OF SEAT ARM REST. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED MISSING LENS IAW AMM 33-51-11, AND PERFORMED A SATISFACTORY OPS CHECK.SDR AALA201804209009Lens · missingSEAT 2E AISLE EMERGENCY LIGHT LENS MISSING AFT OF SEAT ARM REST. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE LENS IAW AMM 33-51-11, AND PERFORMED A SATISFACTORY OPS CHECK.SDR AALA2018042009008Light · unknownEXIT LIGHTS OVER DOORS IN CABIN WOULD NOT ILLUMINATE WHEN CABIN LIGHTS TURNED OFF. MAINTENANCE PERFORMED AN EMERGENCY LIGHT TEST IAW AMM 33-51-00 AND PERFORMED A SATISFACTORY OPS CHECK.SDR AALA201804199020Lens · missingLAVATORY L53 EXTERIOR EMERGENCY LIGHT LENS MISSING. REPLACED EMERGENCY LIGHT LENS.SDR HALA2018041700148Light · detachedFLOOR EMERGENCY LIGHT STRIP IN THE FIRST CLASS GALLEY, FOUND LOOSE FROM THE FLOOR. SECURED THE LIGHT STRIP.SDR HALA2018041800178Light · unsecureEMERGENCY LIGHT STRIP AT THE FIRST CLASS GALLEY FLOOR. UNSECURE. SECURED THE LIGHT STRIP, CHECKED GOOD. OK TO CONTINUE.SDR DALA2018041802601Fuse · inoperativeEMERGENCY LIGHTS AT ROWS 38AB AND AFT ARE INOPERATIVE. REPLACED THE F3 FUSE ON THE BATTERY PACK. SYSTEM OPS NORMAL.SDR SWAA2018041821289Battery Pack · inoperativeL1 DOOR UPPER EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018041821260Battery · inoperativeLEFT FORWARD EMERGENCY LIGHT BATTERY INOPERATIVE. R & R THE BATTERY IAW AMM.SDR SWAA2018041821257Cover · detachedOVERWING AISLE EXIT SIGN LIGHT COVER DETACHED. REINSTALLED THE SIGN COVER IAW MM.SDR UIEA2018041700723Battery Pack · inoperativeHALF OF THE GALLEY EMERGENCY LIGHTS INOPERATIVE. SWAPPED THE BATTERY PACKS IAW AMM 33-51-07. OPS CHECKED GOOD.SDR CALA2018041801179Bulb · inoperativeFWD LT WINDSCREEN EMERGENCY LIGHT NOT FUNCTIONAL. REPLACED THE BULBS IN THE EMERGENCY LIGHT, OPS CHECKED GOOD IAW AMM 33-51-20-400-001C3.SDR DALA2018041802584Bracket · damagedFOUND THE EMERGENCY LIGHT BATTERY PACK BRACKET TO BE DAMAGED. MAINTENANCE REPLACED THE EMERGENCY LIGHTS POWER SUPPLY PER AMM 33-51. OPERATIONAL CHECK WAS NORMAL.SDR SIMA201805316013Light · crackedNR 1, 2, 4, AND 6 LT EMERGENCY LIGHT STRIP WERE CRACKED. R & R THE EMERGENCY LIGHTS IAW AMM 33-50-12.SDR SWAA2018042421320Lens · missingFWD EMERGENCY EXIT LIGHT LENS MISSING AT BS 480. INSTALLED LENS IAW MM.SDR SWAA2018042321352Housing · crackedMID CABIN OVERWING EMERGENCY EXIT LIGHT HOUSING CRACKED. R & R THE EMERGENCY LIGHT HOUSING IAW MM.SDR SWAA2018042321319Battery Pack · inoperativeEMERGENCY LIGHTS BATTERY PACK M1675 INOPERATIVE. R & R THE BATTERY PACK IAW MM.SDR AALA20180417014Battery · inoperativeDURING A PS CHECK, FOUND ALL SEAT EMERGENCY LIGHTS INOPERATIVE, AFT OF 3L AND R DOORS. REPLACED M33406 EMERGENCY POWER SUPPLY ASSY IAW AMM 33-51-01. AIRCRAFT WAS GROUNDED.SDR AALA2018042009018Lens · missingTHE L4 DOOR EMERGENCY LIGHT LENS WAS FOUND MISSING. REPLACED THE LENS.SDR AALA2018042000002Light · inoperativeEMERGENCY LIGHT FOUND INOPERATIVE AT SEAT 7D. REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-51-10.SDR AALA201804199015Lens · missingFWD DOOR EMERGENCY LIGHT MISSING THE LENS. REPLACED THE LENS IAW AMM 33-50-00.SDR DALA2018041702606Battery Pack · inoperativeAISLE EMERGENCY LIGHTS DIDN`T TEST AT ROWS 21-31 ON BOTH SIDES. REPLACED THE BATTERY PACK. SYSTEM OPS NORMAL.SDR DALA2018041702600Light · detachedEMERGENCY EXIT SIGN IS BROKEN AT SEAT 13G. MAINTENANCE FOUND THE BRACKET DETACHED ON THE OUTBOARD SIDE AND ATTACHED THE LIGHT.SDR AALA201804189025Cover · detachedEMERGENCY EXIT SIGN COVER FELL OFF IN AFT GALLEY NEAR THE LT ENTRY DOOR. REPLACED THE EXIT SIGN ASSEMBLY IAW AMM 33-51-01.SDR SWAA2018041821269Spring · missingAFT ENTRY CONTROL PANEL EMERGENCY EXIT LIGHT SWITCH COVER SPRING MISSING. R & R THE COVER PER SWPM.SDR AALA201804183Battery Pack · inoperativeEMERGENCY LIGHT AT FORWARD LT ESCAPE SLIDE FOUND INOPERATIVE. REPLACED THE BATTERY PACK M02816 IAW AMM 33-51-06.SDR HNAA2018041800082Light · inoperativeRT SERVICE DOOR EMERGENCY LIGHT INTERMITTENT. R & R THE LIGHT ASSY.SDR SIMA20180416003Inverter · inoperativeSECTION 6, 7, 8 EMERGENCY LIGHTS INOPERATIVE. TROUBLE SHOT IAW FIM 33-50-00-810-804-A. REMOVED AND REPLACED NR 6 INVERTER IAW AMM 33-50-11-000-801-A, AND 33-50-11-400-801-A, OPS CHECKED GOOD.SDR DALA2018041702556Lens · missingDURING INSPECTION, FOUND THE EMERGENCY LIGHT RED LENS MISSING FROM AFT POSITION BY AFT RIGHT LAVATORY DOOR. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT ASSY IAW CMM 25-45-51, ITEM 915. OP'S CHECKED OK.SDR SWAA2018041721240Sign · detachedOVERHEAD OVERWING EXIT SIGN DETACHED. REINSTALLED THE SIGN IAW AMM.SDR SWAA2018041721236Lens · missingLEFT OVERWING EMERGENCY EXIT SIGN LENS MISSING. R & R LENS IAW AMM.SDR MASA2018041613145Sign · inoperativeEXIT SIGN LIGHT FWD FA SEAT FLOOR LEVEL INOPERATIVE. REPLACED THE EXIT SIGNSDR UIEA2018041600715Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT 20J. INSTALLED A NEW LENS IAW AMM 38-51-10, CHECKED NORMAL.SDR MASA2018041613142Lamp · inoperativeROW 9, OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR CALA2018041601167Power Supply · no testCABIN EMERGENCY LIGHTS FAILED TO TEST, EPSU REMOVED & REPLACED IAW AMM 33-50-00, OPS CHECKED GOOD.
Back to JASC 3350