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 CALA2017071002161Lamp · inoperativeL3 DOOR EXTERIOR EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM TASK 33-51-06-962-001-002. OPS TESTED SATISFACTORY.SDR CALA2017071002160Cover · detachedEMERGENCY EXIT LIGHT COVER AT THE L2 DOOR IS DETACHED. ATTACHED THE COVER IAW AMM 33-51-00.SDR CALA2017071002159Cover · looseEMERGENCY EXIT SIGN NEXT TO SEAT 21A WILL NOT STAY ATTACHED TO THE WALL. R & R THE EMERGENCY EXIT SIGN COVER.SDR CALA2017071002158Lamp · inoperativeRIGHT OVERWING EMERGENCY LIGHT ABOVE HATCH HAS 9 BULBS BURNED OUT. REPLACED THE LAMPS, OK TO CONTINUE.SDR CALA2017071002156Lamp · inoperativeLEFT SIDE EMERGENCY LIGHT INOPERATIVE DURING TEST AT BS 1197+33 AND 1230. LIGHTS ARE AFT OF WING TO BODY FAIRING. REPLACED THE LAMPS, LIGHTS TESTED OK.SDR CALA2017071002155Lamp · inoperativeR1 DOOR EMERGENCY LIGHT DOES NOT COME ON DURING TEST. REPLACED THE LAMP, OPS CHECKED OK.SDR CALA2017071002154Sign · unsecureEMERGENCY EXIT SIGN ABOVE EXIT THE R2 DOOR IS LOOSE. SECURED THE SIGN. CHECKED GOOD IAW AMM 33-51-03.SDR CALA2017071002151Battery Pack · inoperativeNO EMERGENCY LIGHTS, REPLACED THE BATTERY PACK M33409 IAW WDM 33-51-58 AND AMM 33-51-06-9 60-802.SDR CALA2017071002146Light · damagedR1 LAVATORY EMERGENCY LIGHT STRIP ON OUTSIDE WALL DAMAGED. REPAIRED THE EMERGENCY LIGHT IAW MM 33-50-00, OPS CHECKED OK.SDR CALA2017071002144Light · damagedEMERGENCY LIGHT AT THE L2 GALLEY WALL DAMAGED. REPLACED. SYS CHECKED GOOD IAW GMM 9-10-05.SDR CALA2017071002143Light · damagedFOUND EMERGENCY LIGHT ASSY DAMAGED AT THE R1 DOOR, REPLACED THE LIGHT, TESTED OK. INSPECTED THE EMERGENCY LIGHT. INSTALLED, SECURED, AND OPS CHECKED GOOD.SDR CALA2017071002142Light · damagedEMERGENCY LIGHT AT FWD CREW REST AT L5 FOUND DAMAGED. REPLACED THE LIGHT ASSY, AND ACCOMPLISHED AN IDT INSPECTION OF LIGHT REPLACEMENT AND VERIFIED OPS CHECK GOOD IAW DMCB 787-A-33-27-03-01V-941A-D.SDR CALA2017071002177Lens · brokenFORWARD CABIN DOOR SIDE EMERGENCY LIGHT COVER BROKEN. INSTALLED A NEW LENS.SDR FDEA201707101897Warning Light · false activationEMERGENCY LIGHT BATTERY ONE LOW ALERT DURING EMERGENCY LIGHT TEST. PERFORMED EMERGENCY LIGHT TEST IAW FIM 33-51-02-00, FIGURE 104, AND AMM 33-51-01-5. NO FAULTS NOTED AND OPS CHECKED GOOD, NO HISTORY. ACFT OK TO CONTINUE.SDR DALA2017071205404Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 34 INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-05.SDR DALA2017071205391Light · inoperativeOVERWING ESCAPE ROUTE LIGHTING INOPERATIVE, REPLACED BOTH OVERWING EMERGENCY EXIT HANDLE LIGHTS.SDR AALA201707119015Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE FLOOR PATH LIGHT AT THE FORWARD GALLEY CROSS AISLE HAS A DETACHED LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201707109063Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHTS FROM RIGHT SIDE ROW 26 TO AFT GALLEY ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK PER AMM 33-51-07-902-001. OPERATIONAL CHECK GOOD.SDR AALA201707109056Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L2 DOOR HAS A DETACHED LENS COVER. INSTALLED AND SECURED LENS COVER PER AMM 33-25-00. OPERATIONAL CHECK GOOD.SDR SWAA2017071214969Light · inoperativeRT AFT EMERGENCY AISLE LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR AALA201707119020Sign · damagedEMERGENCY EXIT SIGN BY THE R1 DOOR IS DAMAGED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-00. OPS CHECKED GOOD.SDR ASAA2017070921331Lens · missingFA REPORTED AN EXIT LIGHT LENS WAS MISSING IN AFT GALLEY, AIRCRAFT GROUNDED. REPLACED L2 DOOR EMERGENCY EXIT LIGHT LENS IAW AMM 33-51-01. OPS NORMAL.SDR SIMA20170709002Lamp · inoperativeLEFT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMPS IAW AMM 33-50-10-000-801, AND 33-50-10-400-801. OPS CHECKED GOOD.SDR DALA2017071005375Fuse · inoperativeROW 27-32 ISLE EMERGENCY LIGHT FOUND INOPERATIVE. REMOVED AND REPLACED THE FUSES IN THE BATTERY PACK M11488. OPS CHECKED GOOD.SDR DALA2017071005374Cover · unsecureEMERGENCY EXIT SIGN COVER LOOSE. SECURED THE LENS, OK FOR SERVICE.SDR IPXA2017071019144Power Supply · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-07-201. OPS CHECKED GOOD.SDR AALA201707109074Sign · detachedEMERGENCY EXIT SIGN RIGHT SIDE BETWEEN FIRST CLASS AND COACH IS DETACHED. REATTACHED EXIT SIGN IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201707109070Guard · out of adjustAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS SWITCH GUARD TURNS SWITCH TO OFF POSITION WHEN IT IS DOWN. ADJUSTED GUARD. OPS CHECKED GOOD.SDR AALA201707109069Sign · missingEMERGENCY EXIT SIGN BY THE L2 DOOR IS MISSING. REPLACED THE EXIT SIGN IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201707109061Lens · looseEMERGENCY EXIT LIGHTS IN THE CEILING HAVE LOOSE LENSES. SECURED THE LENSES IAW AMM 33-50-00. OPS CHECKED GOOD.SDR AALA201707109058Light · detachedEMERGENCY EXIT LIGHT IN THE FORWARD CABIN IS DETACHED FROM HOLDER. REPLACED LIGHT ASSEMBLY IAW AMM 33-53-14. OPS CHECKED GOOD.SDR SWAA2017071114923Lens · looseR1 DOOR LOWER EXIT LIGHT LENS LOOSE. SECURED LENS PER SIP.SDR SWAA2017071114917Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR AALA201707109049Battery · no testCIDS BITE TEST SHOW BATTERY FAULT AT 13WL AFT OF EMERGENCY LIGHT SYSTEM. REPLACED THE BATTERY 13WL IAW MM 33-50-00.SDR AALA201707109048Battery · faultyCIDS 1 EMERGENCY POWER SUPPLY UNIT SYSTEM TEST (12WL) FAULTED. REPLACED THE BATTERY IAW MM 33-51-38 AND MM 33-51-00.SDR AALA201707109044Battery · faultyDURING CHECK, 12WL FAILED CIDS TEST. REPLACED BATTERY 12WL IAW AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170709002Battery · no testEMERGENCY POWER SUPPLY UNIT BATTERY 15WL FAILED DURING A-CHECK TEST. REPLACED THE BATTERY IAW AMM 33-51-38. ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR DALA2017071105347Light · inoperativeEMERGENCY LIGHTS ON CATWALK NEED RELAMPED SEVERAL LOCATIONS. RELAMPED CATWALK EMERGENCY LIGHTS SEVERAL LOCATIONS PER AMM 33-52. CKS GOOD.SDR DALA2017070905318Battery Pack · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE BATTERY AND CHARGER.SDR SWAA2017071014902Sign · brokenRIGHT OVERWING DOOR EXIT SIGN LENS BROKEN OFF. R & R THE SIGN IAW MM.SDR AALA201707109034Lens · brokenSEAT MOUNTED EXIT LIGHT COVER BROKEN. REPLACED SEAT MOUNTED EXIT LIGHT PER AMM 33-51-18.SDR AALA201707109033Lens · brokenR1 DOOR WALL MOUNTED EMERGENCY LIGHT COVER BROKEN. REPLACED R1 DOOR WALL MOUNTED EMERGENCY LIGHT COVER.SDR AALA201707109031Strap · brokenFLASHLIGHT BRACKET SEAL FOUND BROKEN DURING FA PREFLIGHT. REPLACED THE FLASHLIGHT BRAKE-A-WAY STRAP WITH SERVICEABLE UNIT. AIRCRAFT GROUNDED.SDR AALA201707109030Lens · missingRED AISLE EMERGENCY LIGHT LEN MISSING AT 9D. REPLACED EMERGENCY LIGHT AT 9D.OK FOR SERVICE.SDR AALA201707109029Director · intermittentAFTER LANDING, EXPERIENCED UNCOMMANDED ACTIVATION OF EMERGENCY LIGHTS. RESET CIDS IAW TSM 24-00-00-810-818ASDR AALA201707109023Lens · detachedR1 EMERGENCY LIGHT LENS DETACHED. REPLACED THE LENS IAW AMM 33-51-00SDR AALA201707109068Lens · detachedEMERGENCY EXIT SIGN AT THE L2 DOOR HAS A DETACHED LENS. SECURED THE LENS. OPS CHECKED GOOD.SDR AALA201707109055Lens · brokenEMERGENCY EXIT LIGHT AT THE L2 DOOR HAS A BROKEN LENS. REMOVED AND REPLACED THE LENS IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201707109053Lens · abnormalEMERGENCY EXIT SIGN AT THE RIGHT AFT GALLEY HAS AN UPSIDE DOWN LENS. REMOVED AND REPLACED THE EXIT SIGN IAW AMM 33-51-03. OPS CHECKED GOOD.SDR AALA201707109052Light · damagedEMERGENCY EXIT LIGHT AT THE R2 DOOR IS DAMAGED. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.
Back to JASC 3350