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 ASAA2017012719567Cover · detachedFLT ATTENDANT REPORTS ROW 16DEF 'EXIT' LIGHT COVER FELL OFF. GROUNDED - YES. REINSTALLED ROW 16DEF 'EXIT' LIGHT COVER AS REQUIRED.SDR DALA2017013000739Bulb · missingWHITE EMERGENCY LIGHT AT SEAT 10B, BULBS AND COVER ARE MISSING. REPLACED THE BULBS AND COVER AT SEAT 10B.SDR DALA2017013000738Battery Pack · inoperativeAFT CABIN EMERGENCY LIGHT IS INOPERATIVE. R & R THE BATTERY PACK AMM 33-53. ALL CHECKS GOOD.SDR SIMA20170127002Charger · failedLEFT AFT EXTERIOR EMERGENCY LIGHT AND BOTH RT OVERWING EXTERIOR EMERGENCY LIGHTS FAIL TO ILLUMINATE. REPLACED THE CHARGER ASSY . OPERATIONAL CHECK IAW AMM 33-51-15.SDR DALA2017013000716Charger · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY EXIT SIGNS AT BOTH OF THE FORWARD MAIN CABIN DOORS L1 AND R1 WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY CHARGER FOR B1-118 AND THE LIGHT BASES FOR L2-832 & L2-833. THE LIGHTS RETURNED TO AN OPERATSDR MASA2017012712835Light · inoperativeROW 6 CEILING EMER FLOODLIGHT INOP. PLACED ON MEL.SDR HALA2017012700013Light · unsecureAFT GALLEY EMERGENCY LIGHT UNSECURE. REPLACED THE LIGHT.SDR AALA20170129006Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE. EMERGENCY LIGHT INOPERABLE. REPLACED BATTERY PACK AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2017013011562Light · inoperativeEMERGENCY EXIT STOW BIN LIGHTS INOPERATIVE. REPAIRED THE LIGHT IAW WDM & AMM.SDR AALA20170130017Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY L2 DOOR HAS A BROKEN LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170130014Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT L2 DOOR HAS A MISSING LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170130013Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT ROW 10 OVERHEAD BIN HAS A MISSING LENS COVER. REPLACED LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170130012Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT FORWARD ENTRY HAS A MISSING LENS COVER. REPLACED LENS COVER IAW AMM 25-00-00. OPERATIONAL CHECK GOOD.SDR AALA20170127009Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT ABOVE SEAT 27ABC HAS A MISSING LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20170127002Light · inoperativeAIRCRAFT WAS NOT GROUNDED. FLOOR PROXIMITY EMERGENCY LIGHT AT FORWARD GALLEY WALL AREA ACROSS FROM L1 FLIGHT ATTENDANT POSITION IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA20170127001Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT AT 10WL FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR DALA2017013000741Light · inoperativeDURING INSPECTION, FOUND FORWARD EMERGENCY EXIT LIGHT INOPERATIVE. MAINTENANCE SECURED LIGHT ASSY. LIGHT OPS NORMAL.SDR DALA2017013000740Wire · damagedDURING INSPECTION, FOUND SEAT EMERGENCY LIGHT INOPERATIVE AT SEAT 28DEF. MAINTENANCE REPAIRED THE WIRE IAW WSPM 20-10-13. OPS CHECKED IAW AMM 33-51-00.SDR DALA2017012600719Battery Pack · faultedLEFT MID EMERGENCY LIGHT BATTERY FAULT ON FAP TEST, REPLACED LEFT MID EMERGENCY BATTERYSDR DALA2017012600718Power Supply · faultedEPSU FAULT FWD LEFT DURING SERVICE CHECK, RESET EPSU, CHECKED GOODSDR SWAA2017012711502Lens · looseLT EMERGENCY LIGHT LENS LOOSE AT ROW 14. SECURED LENS IAW AMM.SDR SWAA2017012711500Cover · unsecureL1 DOOR EMERGENCY EXIT FLOOR FLOODLIGHT COVER FELL OFF. REINSTALLED COVER PER SIP.SDR QXEA2017012700031Light · looseUPON WALK THROUGH FOUND MCD ENTRYWAY EMERGENCY LIGHT STRIPS LOOSE AND REQUIRING SEALANT. COMPLIED WITH TASKCARD. REFERENCE TASKCARD FOR WORK ACCOMPLISHED. RESECURED FLOOR STRIP. NO PARTS REPLACED.SDR QXEA2017012700030Light · looseUPON WALKTHROUGH, FOUND EMERGENCY LIGHT STRIP AT SEATS 3AB AND 4AB REQUIRING RESECURING. COMPLIED WITH TASKCARD. REFERENCE TASKCARD FOR WORK ACCOMPLISHED. RESECURED LIGHT STRIP. NO PARTS REPLACED.SDR AALA201701279008Power Supply · failedEMERGENCY LIGHT POWER SUPPLY UNIT EXTERNAL LOAD FAULT ON CIDS. REPAIRED SEAT MOUNTED EMERGENCY LIGHT WIRES AT ROW 7 AND REPLACED 11WL EMERGENCY POWER SUPPLY IAW TSM 33-51-00-810-808-A.SDR AALA201701279005Light · missingMISSING EMERGENCY LIGHT ON SEAT 24C. REPLACED THE EMERGENCY LIGHT IAW CMM 25-22-52.SDR AALA201701279003Light · brokenBROKEN RED AISLE EMERGENCY LIGHT AT 10C. REPLACED THE EMERGENCY LIGHT AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017012700680Battery Pack · inoperativeEMERGENCY SEAT LIGHTS INOPERATIVE AFTER ROW 20. REPLACED THE BATTERY PACK.SDR AALA20170126015Lens · missingSEAT MOUNTED EMERGENCY LIGHT ON SEAT 18D HAS A MISSING LENS. INSTALLED A NEW RED LENS IAW AMM 33-51-05. OPERATIONAL CHECKED GOOD.SDR AALA20170126014Battery Pack · overtempDURING TROUBLESHOOTING OF EMERGENCY LIGHT SYSTEM, FOUND CHARGER AND BATTERY ABOVE L2 DOOR EXCESSIVELY HOT. REMOVED AND REPLACED CHARGER AND BATTERY PACK IAW AMM 33-51-07. OPERATIONAL CHECKED GOOD.SDR AALA20170126013Charger · overtempDURING TROUBLESHOOTING OF EMERGENCY LIGHTS, FOUND THE CHARGER AND BATTERY ABOVE L2 DOOR EXCESSIVELY HOT. REMOVED AND REPLACED CHARGER AND BATTERY PACK IAW AMM 33-51-07. OPS CHECKED GOOD.SDR DALA2017012700676Light · inoperativeDURING INSPECTION FOUND EMERGENCY LIGHT UNDER OVERHEARD BIN INOPERATIVE AT SEAT 10ABC. MAINTENANCE PERFORMED REPAIR PER NR 001-378:3350-7413/002.SDR DALA2017012700675Power Supply · inoperativeDURING INSPECTION FOUND EMERGENCY EXIT LIGHTING INOPERATIVE FORWARD L1 DOOR SIGN AND SLIDE LIGHT. MAINTENANCE R&R EMERGENCY LIGHT POWER SUPPLY REF AMM 33-51 OPS CHECK NORMAL.SDR DALA2017012700666Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHT BATTERY POWER SUPPLY HAD FAILED. REPLACED THE BATTERIES IN THE POWER SUPPLY AND FUNCTIONALLY TESTED THE SYSTEM.SDR JJBA20170126021Inverter · failedEMERGENCY EXIT SIGNS BY F/A JUMPSEAT AND LT EMERGENCY EXIT INOPERATIVE. R & R THE STATIC INVERTER. OPS CHECKED GOOD. NO DEFECTS NOTED.SDR MASA2017012612831Light · inoperativeONE LAMP INOP ROW 12R EMERGENCY EXIT SIGN. RELAMPED.SDR SWAA2017020111601Structure · brokenFORWARD EMERGENCY EXIT CEILING PANEL BASE BROKEN AT BS. 627.5. R & R BASE IAW MM.SDR DALA2017012600756Light · damagedSEAT 45D MOUNTED EMERGENCY LIGHT DAMAGED AND INOPERATIVE. SECURED THE LIGHT ASSY.SDR DALA2017013000755Sign · detachedR2 DOOR EXIT SIGN DETACHED. INSTALLED THE SIGN.SDR AALA20170127008Battery · dischargedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT UNDER L1 SEAT HAS A LOW BATTERY. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-01. OPERATIONAL CHECK GOOD.SDR DALA2017012900721Connector · unsecureEMERGENCY ESCAPE LIGHT AT ROW 22AB ARE INOPERATIVE. GROUND CHECK FOUND CONNECTOR OF SEAT HARNESS LOOSE AND SECURED. SYSTEM OPERATION IS NORMAL.SDR RAIA201701250001Lens · crackedPAX DOOR EMERGENCY LIGHT LENS IS CRACKED. R & R PAX DOOR THE LENS. OPS CHECKED GOOD.SDR SWAA2017012711514Lens · unsecureL1 DOOR EGRESS EXIT SIGN LENS FELL OFF. R&R SIGN BASE PER AMM.SDR SWAA2017012711510Cover · brokenFORWARD ENTRY EMERGENCY EXIT LIGHT COVER BROKEN. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2017012711506Sign · looseRT OVERWING EXIT SIGN LOOSE. R&R LIGHT ASSEMBLY PER SIP.SDR AALA201701269023Power Supply · inoperativeEMERGENCY LIGHT POWER SUPPLY 12WL INOPERATIVE AT R3 DOOR. REPLACED THE POWER SUPPLY IAW AMM 33-51-38.SDR AALA201701269017Lens · missingMISSING EMERGENCY LIGHT LENS COVER AT ROW 22R. REPLACED THE LENS IAW AMM 33-51-18.SDR AALA201701269013Ballast · failedELECTRICAL BURNING ODOR IN THE AFT CABIN. MAINTENANCE FOUND FAULTY BALLAST AT ROW 21DEF AND REPLACED. ACCOMPLISHED CABIN AIR QUALITY CHECK IAW 26L00021001. AIRCRAFT WAS GROUNDED.SDR ASAA2017012519553Power Supply · failedLEFT FWD OVERWING EXIT EMERGENCY LIGHTS FAILED TO COME ON DURING THE EMERGENCY LIGHTS TEST. ACFT GROUNDED. FOUND THE BATTERY PACK & POWER SUPPLY WAS FAULTY. REPLACED BOTH IAW AMM 33-51-06/401. OPS CHECKED GOOD.SDR IPXA2017012613299Battery Pack · false indicationEMERGENCY LIGHTT BATTERY 1 LOW INDICATION ON PREFLIGHT. PERFORMED EMERGENCY LIGHT TEST MM 33-50-00-501. OPS NORMALLY
Back to JASC 3350