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 HALA2017082900002Light · unsecureFLOOR LIGHTING STRIP PEELING UP NEAR LEFT MID GALLEY FORWARD OF CART STOWAGE. RE-SECURED EMERGENCY PATH LIGHT STRIP AT MID GALLEY.SDR AALA201708309018Cover · missingAIRCRAFT WAS NOT GROUNDED. OVERWING EMERGENCY EXIT LIGHT LENS COVER BY FLOOR MISSING AT SEAT15A. INSTALLED NEW LENS COVER BY SEAT 15A PER AMM 33-51-01.SDR AALA201708299047Battery · dischargedAIRCRAFT WAS NOT GROUNDED. OVERHEAD CEILING EMERGENCY EXIT LIGHTS L2-711, L2-712, L2-713, L2-714, AND L2-715 ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSEMBLY B5-102 PER AMM 33-53-00 AND WDM 33-51-12. OPERATIONAL CHECK GOOD.SDR AALA201708299046Cover · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT COVER BROKEN IN FORWARD GALLEY, ACROSS FROM LAVATORY. REPLACED R1 DOOR EXIT SIGN LIGHT ASSEMBLY PER MM 33-51-01. CHECKS GOOD.SDR SWAA2017083116022Sign · unsecureMID-CABIN OVERHEAD EMERGENCY LIGHT SIGN FELL OFF. REINSTALLED SIGN PER SIP.SDR DALA2017083106483Light · damagedSEAT 3C EMERGENCY LIGHT DAMAGED, REPLACED THE LIGHT.SDR SWAA2017083016010Lamp · inoperativeR/H OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR AALA201708299002Sign · brokenR4 DOOR LOWER EMERGENCY EXIT SIGN BROKEN OFF LOWER FASTENER. REPLACED R4 DOOR EXIT SIGN IAW AMM 33-51-18.SDR AALA201708299013Lens · detached4L EXIT DOOR SMALL EXIT COVER CAME OFF. REINSTALLED AS NEEDED.SDR SIMA20170828001Sign · inoperativeRT OVERWING EXIT SIGN INOP AT SEAT 12 B/C. ALLOWED EMERGENCY SYSTEM CHARGE FOR 30 MIN AND THEN PERFORMED OPERATIONAL CHECK OF EMERGENCY LIGHTS IAW AMM 33-50-00. OPS CHECK GOOD.SDR AALA201708299022Lens · brokenAIRCRAFT WAS NOT GROUNDED. EXIT SIGN 3L FELL OFF. REPLACED 3L EXIT SIGN LENS.SDR AALA201708299021Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT LENS BROKEN AT ROW 6A. REPLACED LIGHT ASSEMBLY AT 6A.SDR AALA201708299020Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT LENS BROKEN AT ROW 11G. REPLACED LIGHT ASSEMBLY AT 11G.SDR AALA201708299042Charger · faultyAIRCRAFT WAS NOT GROUNDED. L3 DOOR EMERGENCY EXIT DOOR LIGHT IS INTERMITTENT. REPLACED BATTERY PACK (AALA201708299023) AND CHARGER IAW AMM 33-51-07 ME-0470.SDR AALA201708299023Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. L3 DOOR EMERGENCY EXIT DOOR LIGHT IS INTERMITTENT, REPLACED BATTERY PACK AND CHARGER (AALA201708299042) IAW AMM 33-51-07 ME-0470.SDR ASAA2017082821743Lens · detachedEXIT PLACARD SIGN FROM 17F FELL OFF. ACFT GROUNDED. REINSTALLED THE SIGN LENS.SDR I5EA2017082900002Battery Pack · dischargedEMERGENCY LIGHTS AT ROW 5 ABC AND L1 DOOR EXTERIOR ARE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACKS. PERFORMED OPS CHECK IAW AMM 33-51-51.SDR CALA2017082802941Lens · missingFWD STOWAGE/AFT EMERG EXIT LITE COVER MISSING. LITE WORKS. REPLACED MISSING LENS ASSY. REF IPC 33-51-05-67ITEM 20-40. ME=25 -3327-3-0006. LIGHT WORKS NORMALLY.SDR CALA2017082802940Light · inoperativeL2 EXTERIOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED LAMP FOR L2 DOOR SLIDE EMERGENCY LIGHT REF AMM 33-51-04, OPS CHECK GOOD.SDR CALA2017082802934Fuse · faultyEXTERIOR DOOR EMERGENCY EXIT LIGHT INOP RT SECOND DOOR FROM REAR. T/S SYSTEM, REF: WDM 33-51-15. FOUND BAD FUSE IN BATTERY PACK M11489, REPLACED THE SAME. DOOR R3 EMERGENCY EXIT LIGHT GROUND TEST GOOD, AMM TASK 33-51-00-715-039.SDR CALA2017082802928Wire · damagedEMERGENCY EXIT LIGHT AT SEAT 57H IS INOP REF AMM 33-51-12-201. TERMINATED WIRES, OPS CHECKED GOOD.SDR CALA2017082802927Light · missingEMERGENCY EXIT LIGHT AT SEAT 52C IS MISSING AND WIRE IS EXPOSED REPLACED LAMP, OPS CHECKED GOOD REF AMM33-51-00.SDR CALA2017082802926Wire · damagedEMERGENCY EXIT LIGHT AT SEAT 19C IS INOP TERMINATED WIRES, OPS CHECKED GOOD REF AMM33-51-00.SDR CALA2017082802935Lens · looseEMERG EXIT LIGHT LENS OFF AT 1R IN FWD GALLEY. RESECURED LENS AS REQ''D.SDR CALA2017082802930Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT 5D. REPLACE LENS.SDR CALA2017082802937Fuse · faultyEMERGENCY LIGHTS INOP ROWS 15,20 AND 21. REPLACED FUSES PER AMM 33-51-06-960-804.SDR CALA2017082802936Lens · loosePLASTIC EMERGENCY EXIT SIGNS FELL DOWN. SECURED SIGN LENS.SDR MASA2017082812578Battery Pack · inoperativeFWD EMERGENCY LIGHTS WILL NOT ILLUMINATE. REPLACED THE BATTERY PACKS.SDR DALA2017082806404Fuse · blownF/C EMER LIGHTS INOP ON TEST. REPLACED FUSE AT BATTERY PACK B5-211. OPS CHECK GOOD REF WDM 33-51-14.SDR AALA201708299045Light · inoperativeAIRCRAFT WAS NOT GROUNDED. OVERWING EXIT LIGHT 14ABC INOPERATIVE. REPLACED WINDOW OVERWING EXIT LIGHT AT 14ABC PER AMM 33-51-04.SDR AALA201708299044Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT ASSEMBLY AT FORWARD SERVICE DOOR DAMAGED. REPLACED LIGHT ASSEMBLY PER AMM 25-63-00, GOOD FOR SERVICE.SDR YENA201708270710Power Supply · failedEMERGENCY LIGHTS INOPERATIVE WHEN POWER REMOVED. R & R THE BATTERIES AND POWER SUPPLY 13WL IAW AMM 33-51-38. OPS CHECKED GOOD. NO DEFECT NOTED. OK FOR SERVICE.SDR YENA201708270709Battery Pack · failedEMERGENCY LIGHTS INOPERATIVE WHEN POWER REMOVED. R & R THE BATTERIES IAW AMM 33-51-38. OPS CHECKED GOOD. NO DEFECT NOTED. OK FOR SERVICE.SDR YENA201708270708Battery Pack · failedEMERGENCY LIGHTS INOPERATIVE WHEN POWER REMOVED. R & R THE BATTERIES IAW AMM 33-51-38. OPS CHECKED GOOD. NO DEFECT NOTED. OK FOR SERVICE.SDR YENA201708270707Battery Pack · failedEMERGENCY LIGHTS INOPERATIVE WHEN POWER REMOVED. R & R THE BATTERIES IAW AMM 33-51-38. OPS CHECKED GOOD. NO DEFECT NOTED. OK FOR SERVICE.SDR YENA201708270706Battery Pack · failedEMERGENCY LIGHTS INOPERATIVE WHEN POWER REMOVED. R & R THE BATTERIES OF THE EMERGENCY POWER SUPPLY UNIT IAW AMM 33-51-38. OPS CHECKED GOOD. NO DEFECT NOTED. OK FOR SERVICE.SDR YENA201708270705Battery Pack · failedEMERGENCY LIGHTS INOPERATIVE WHEN POWER REMOVED FROM ACFT. R & R THE BATTERIES & THE POWER SUPPLY IAW AMM 33-51-38. OPS CHECKED GOOD. NO DEFECT NOTED. OK FOR SERVICE.SDR HALA2017082800218Control Panel · malfunctionedALL EXIT SIGNS ON THE LEFT SIDE OF THE AIRCRAFT ARE INOPERTIVE. RESET CIDS.SDR SWAA2017083016011Light · brokenRIGHT EMERGENCY EXIT SIGN BROKEN. R & R THE LIGHT ASSEMBLY IAW MM.SDR AALA201708289019Battery · not seatedAIRCRAFT WAS NOT GROUNDED. CEILING EMERGENCY EXIT LIGHTS BETWEEN ROWS 12 AND 16 ARE INOPERATIVE. RESEATED BATTERIES IN CHARGER UNIT PER AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR SWAA2017082915957Lens · missingOVERHEAD EMERGENCY LIGHT LENS COVER MISSING AT ROW 10. INSTALLED LENS PER AMM.SDR ASAA2017082721744Lens · missing17A EXIT SIGN LENS MISSING. ACFT GROUNDED. REPLACED THE LENS, OPS NORMAL.SDR AALA201708289048Lens · missingR4 DOOR EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED EMERGENCY EXIT LENS IAW AMM.SDR AALA201708289047Power Supply · inoperativeL3 EMERGENCY LIGHT POWER SUPPLY UNIT INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY IAW AMM.SDR AALA201708289036Bezel · detached15C EMERGENCY LIGHT HANGING DOWN. REPLACED 15C EMERGENCY LIGHT BEZEL IAW CMM.SDR QXEA2017082800542Cover · brokenF/A REPORTS SWITCH LIGHT COVER FOR EMERGENCY LIGHTING IS DAMAGED. AIRCRAFT REMOVED FROM SERVICE. REPLACED SWITCHLIGHT COVER. CHECKS GOOD. RETURNED TO SERVICE.SDR HALA2017082800236Light · missing16A&B EMERGENCY LIGHT STRIP IS MISSING IN COCKPIT. RE-ATTACHED 16AB EMERGENCY LIGHT STRIP OPS CHECKED NORMAL.SDR HALA2017082800235Sign · malfunctionedALL EXIT SIGNS AIRCRAFT LEFT ARE INOP. RESET CIDS OPS OK.SDR SIMA20170827002Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. R & R THE LAMP IAW AMM 33-50-10-000-801-A, AND 33-50-10-400-801-A. OPS CHECKED GOOD.SDR SIMA20170827001Lamp · inoperativeAFT EMERGENCY CEILING LIGHT INOPERATIVE. REMOVED AND REPLACED AFT EMERGENCY CEILING LIGHT LAMP. OPS CHECKED GOOD IAW AMM 33-50-08.
Back to JASC 3350