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 SWAA2018090424795Lens · looseR1 DOOR EMERGENCY EXIT LIGHT LENS COVER LOOSE. R&R LIGHT ASSEMBLY PER MM.SDR AALA201808299027Battery · no testEMERGENCY LIGHT INOPERATIVE AT THE CEILING, ROW 17 IN ISLE. REPLACED THE LIGHT BATTERY PACK IAW AMM 33-50-01, AND PERFORMED A SATISFACTORY OPERATIONAL CHECK.SDR REXA2018082860724Lens · damagedRAMP REPORTED DAMAGED EXTERIOR EMERGENCY LIGHT LENS. REMOVED AND REPLACED THE LENS IAW AMM 33-51-15.SDR ASAA2018082865935Battery Pack · dischargedEXTERIOR L1 DOOR, INTERIOR R1 DOOR AND AISLE EMERGENCY LIGHTS INOPERATIVE. DOME LIGHT FLIGHT DECK INOPERATIVE WITH SWITCH IN EMERGENCY POSITION. ACFT GROUNDED. REMOVED AND REPLACED THE BATTERY PACK AT M1675 IAW AMM 33-51-06.SDR DALA2018082875326Power Supply · malfunctionedDURING SERVICE CHECK, FOUND THE EMERGENCY LIGHTS STUCK ON, BUT DIM. R1 & L1 DOORS AND ROWS 1A - 5A FLOOR. REPLACED THE POWER SUPPLY. SYSTEM OPS NORMAL.SDR AALA201808286005Power Supply · no testEMERGENCY LIGHTS FAILED 13WL ON CIDS TEST. THE AIRCRAFT WAS GROUNDED. REPLACED THE SUPPLY POWER BATTERY IAW AMM 33-51-38.SDR AALA201808289005Light · inoperativeROW 11ABC SEAT MOUNTED EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-18.SDR AALA201808289010Sign · detachedEXIT SIGN PANEL ABOVE THE R1 DOOR DETACHED. SECURED THE EXIT SIGN PANEL. OK FOR SERVICE.SDR SWAA2018082724622Light · inoperativeRT SIDE LOWER EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR AALA2018082879065Lens · detachedLENS OVER THE EMERGENCY EXIT LIGHT UNDERNEATH SEAT 25C DETACHED. ATTACHED THE LENS.SDR AALA201808279053Lens · detachedCOVER OVER THE EMERGENCY LIGHT UNDERNEATH SEAT 9C DETACHED. ATTACHED THE LENS.SDR SIMA201808276004Power Supply · failedAFT SERVICE DOOR EXIT SIGN INOPERATIVE. TROUBLESHOT THE AFT SERVICE DOOR SIGN IAW WM 33-50-50 AND FOUND NO POWER TO PIN -M- ON P0546 FOR THE NR 4 EMERGENCY LIGHT POWER UNIT. REMOVED AND REPLACED THE NR 4 EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01, OPS CHECKESDR DALA2018082705276Lens · brokenFOUND THE AFT EXIT SIGN LENS AT THE R4 DOOR BROKEN. REPLACED THE LENS.SDR DALA2018082705267Charger · inoperativeDURING A SERVICE CHECK, MAINTENANCE FOUND THAT THE TAIL COMPARTMENT EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE REPLACED THE CHARGER AND BATTERY B5-260 IAW IAW AMM 33-51-03. OPS CHECKED GOOD.SDR ASAA2018082526334Battery Pack · dischargedLT OVERWING INTERIOR LIGHTS FAILED BATTERY CHECK (M1694) GROUNDED - YES. REPLACED BATTERY PACK PER AMM 33-51-06SDR SIMA201809275004Light · damagedLH EMERGENCY LIGHT EXTRUSION RAMP, 1,2,3,7 AND LAV DAMAGED-C/A-COMPLETE:RAR LH EMERGENCY LIGHT EXTRUSION RAMP, 1,2,3,7 AND LAV IAW EMB145 AMM 33-50-12-04. SEE NRTC BOW300444 FOR INSTALLATION AND OPERATIONAL CHECKSDR ASAA2018082526163Battery Pack · failedRT OVERWING INTERIOR LIGHTS FAILED BATTERY CHECK (M1695) GROUNDED - YES. REPLACED BATTERY PACK S/N 44867 PER AMM 33-51-06.SDR AALA2018082989016Cover · missingL4 DOOR EXIT COVER MISSING. LIGHT, LENS, AND BEZEL DAMAGED. REPLACED EMERGENCY LIGHT COVER IAW AMM 33-51-01. ITEM OK.SDR SWAA2018082824639Power Supply · inoperativeFORWARD RT EMERGENCY BATTERY INOP. R&R POWER SUPPLY IAW AMM.SDR QXEA2018082800309Lamp · inoperativeEMERGENCY LIGHT, LT AFT WAS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-11-000-801.SDR AALA201808279051Lamp · inoperativeEMERGENCY LIGHT AFT OF THE R1 DOOR WAS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-04-960-801.SDR SWAA2018082724620Light · inoperativeRT DOOR EMERGENCY EXIT UPPER SIDEWALL LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA2018082724580Light · inoperativeR2 DOOR EMERGENCY SLIDE EGRESS LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA2018082724578Light · inoperativeRT EMERGENCY EXIT SIDEWALL LIGHT INOP. RELAMPED LIGHT PER AMM.SDR AALA2018082879008Lens · missingEMERGENCY LIGHT LENS AT ROW 9D WAS MISSING. REPLACED EMERGENCY LIGHT. OPS GOOD.SDR AALA2018082879007Lens · missingEMERGENCY LIGHT LENS MISSING AT THE L4 DOOR AREA. REPLACED THE LENS. OPS CHECKED GOOD.SDR SIMA201808275003Bulb · burned outDURING A PS-1 CHECK, FOUND AN EXTERNAL EMERGENCY LIGHT ON THE LT CENTER FAIRING, BURNED OUT. REMOVED AND REPLACED THE BULB IAW AMM 33-50-10. OPS CHECKED GOOD. NO FURTHER DEFECTS NOTED.SDR AALA201808279050Lens · damagedL1 CABIN DOOR EMERGENCY EXIT LIGHT WAS FOUND DAMAGED. REPLACED THE LENS, OPS CHECKED NORMAL IAW AMM 33-51-00.SDR AALA201808279045Sign · looseEXIT SIGN IN THE FIRST CLASS SECTION, RIGHT SIDE, BLINKED DURING TURBULENCE. INSPECTION CHECK DONE AND ATTACHED EXIT SIGN LENS PROPERLY. PERFORMED AN OPS TEST IAW AMM 33-51-01. TESTED OKAY. NO ABNORMALITIES FOUND.SDR AALA201808279043Battery Pack · inoperativeIAW TC 2735, SEVERAL EMERGENGY LIGHTS WERE INOPERATIVE IN THE MAIN DECK. CHECKED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06.SDR AALA201808279037Sign · looseLEFT FORWARD ESCAPE HATCH EMERGENCY EXIT SIGN WAS LOOSE. SECURED THE SIGN COVER IAW AMM 33-51-01.SDR DALA2018082705270Lens · missingTHE FLIGHT ATTENDANT DISCOVERED THE OVERWING EXIT EMERGENCY SIGN COVER WAS MISSING. MAINTENANCE REPLACED THE LENS ASSEMBLY AND THE AIRCRAFT RETURNED TO SERVICE.SDR AALA201808279018Lens · missingEMERGENCY LIGHT ABOVE ROW 27ABC WAS OUT OF THE BRACKET AND MISSING THE LENS. REPLACED LENS ASSEMBLY IAW MM 33-00-00. OPS CHECKED NORMAL.SDR DALA2018082765255Battery Pack · inoperativeROWS 10 - 15, THE EMERGENCY LIGHTS WERE DIM DURING A TEST. REPLACED THE EMERGENCY LIGHT BATTERY AT ROW 12. OPS CHECKED GOOD.SDR DALA2018082765249Unknown · unknownEMERGENCY POWER INOPERATIVE. PERFORMED EMERGENCY LIGHTS TEST IAW AMM 33-53 OPS, TESTED GOOD.SDR MASA2018082513519Power Supply · inoperativeAFT RT SERVICE DOOR EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE POWER SUPPLY.SDR ASOA201808257155Battery · dischargedA/C WAS IN FOR AN A-CHECK WHEN INSPECTION FOUND THE EXIT ROW EMERGENCY LIGHT PROXIMITY LIGHT INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE #3 LIGHT BATTERY IAW EMB 145 AMM 33-50-04. OPS CHECK GOOD AND WAS RELEASED.SDR DALA2018082505246Light · damagedEMERGENCY SEAT MOUNTED LIGHT DAMAGED AT THE R3 DOOR. RESET, OPS CHECKED OK.SDR DALA2018090405426Sign · unsecureEMERGENCY EXIT SIGN AT DOOR 2R NOT SECURED TO CEILING PANEL. REPLACED OVERHEAD EMERGENCY LIGHT ASSEMBLY.SDR REXA2018082840721Charger · inoperativeLEFT & RIGHT FORWARD DOOR EMERGENCY LIGHTS WERE NOT WORKING. R & R THE NR 5 EMERGENCY LIGHT CHARGER, AND POWER SUPPLY ASSY IAW AMM 33-51-17. OPS CHECKED GOOD.SDR AALA201808289026Lens · damagedLIGHT LENS DAMAGED. MAINTENANCE REPLACED THE LENS IAW AMM 20-00-00, AND PEFORMED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201808289025Cover · missingFORWARD GALLEY ENTRYWAY ISLE HAD A MISSING EMERGENCY EXIT LIGHT COVER. MAINTENANCE REPLACED THE FLOODLIGHT AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-53-01.SDR AALA201808284004Light · inoperativeSEAT 4E AFT MOUNTED EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-11 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2018082875322Light · missingDURING AN OVERNIGHT CHECK, FOUND THE SEAT MOUNTED EMERGENCY LIGHT MISSING AT ROW 43DEF. INSTALLED A NEW EMERGENCY LIGHT AT IAW AMM 33-51.SDR DALA2018082875319Power Supply · inoperativeFOUND THE LEFT OVERWING EMERGENCY EXIT SIGN AFT WAS INOPERATIVE DURING A TEST, ALONG WITH EXIT SIGN BETWEEN BOTH DOORS. REMOVED AND REPLACED M10567 POWER SUPPLY IAW AMM 33-51-07, NO CHANGE. UNSECURED KICK PANEL LEFT SIDE FROM ROW 24 - 27. REMOVED THE SPACESDR AALA2018082879069Lens · missingEMERGENCY LIGHT LENS WAS MISSING AT SEAT 8 ABC. REPLACED THE LENS IAW 33-50-00.SDR AALA2018082879068Lens · missingEMERGENCY LIGHT LENS WAS MISSING AT SEAT 8 ABC. REPLACED THE LENS IAW 33-50-00.SDR AALA2018082879067Lens · missingEMERGENCY LIGHT LENS WAS MISSING AT SEAT 8 ABC. REPLACED THE LENS IAW 33-50-00.SDR AALA2018082879066Lens · missingEMERGENCY LIGHT LENS WAS MISSING AT SEATS 3C. REPLACED THE LENS IAW 33-50-00.SDR AALA2018082879029Sign · looseEXIT SIGN BY THE L3 DOOR WAS LOOSE ON ONE SIDE. INSTALLED A PIN AT EXIT SIGN AND APPLIED RTV IAW AMM 33-51-01. OK FOR SERVICE.
Back to JASC 3350