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 R61A201802270274Light · inoperativeROW 8, CENTER AISLE OVERHEAD EMERGENCY LIGHT INOPERATIVE. R & R THE EMERGENCY LIGHT IAW AMM 33-50-13.SDR AALA201803019001Cover · missingR1 DOOR EMERGENCY EXIT LIGHT COVER IS MISSING. REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-51-01.SDR AALA201802289014Power Supply · faultedTHE AIRCRAFT WAS GROUNDED. FAULT ON UNIT POWER SUPPLY CABIN EMERGENCY (EPSU) EMERGENCY EXIT DOOR RIGHT HAND IN PASSENGER CABIN. REPLACED UNIT POWER SUPPLY (EPSU) PER AMM 33-51-38-400-001-A.SDR SIMA20180227002Inverter · inoperativeLEFT EMERGENCY LIGHT EXIT SIGN INOPERATIVE, BY THE LT OVERWING EMERGENCY DOOR IAW PS-1 CHECK. FOUND EMERGENCY LIGHT DC - AC INVERTER NR 4 TO BE BAD. R & R EMERGENCY LIGHT INVERTER IAW AMM 33-50-11. OPS CHECKED GOOD.SDR AALA201803019018Light · damagedEMERGENCY LIGHT ASSEMBLY AT ENTRY AFT DOOR DAMAGED. MAINTENANCE REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 25-63-00, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802289017Lens · missingEMERGENCY LIGHT LENS MISSING ON LEFT ROW 3 SEAT. REPLACED THE LENS IAW AMM 33-51-19.SDR SWAA2018030120172Lens · brokenR1 DOOR EMERGENCY EXIT LIGHTED SIGN LENS BROKEN. R & R THE LENS IAW SIP.SDR SWAA2018030120170Lens · missingR2 DOOR EMERGENCY LIGHT LENS MISSING. INSTALLED LENS IAW SIP.SDR AALA201802289018Light · missingTHE AIRCRAFT WAS NOT GROUNDED. PASSENGER SEAT-MOUNTED ESCAPE PATH LIGHT AT SEAT 23D MISSING EMERGENCY LIGHT ASSEMBLY. CHECKED AND REPLACED THE LIGHT ASSEMBLY. PERFORMED ALL REQUIRED OPERATION CHECKS.SDR AALA201802289030Lens · missingR2 DOOR EXIT LIGHT LENS MISSING. MAINTENANCE REPLACED THE LIGHT LENS IAW AMM 33-51-16 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802289027Sign · detachedEXIT SIGN AT THE L2 DOOR FELL OFF. REPLACED THE DOOR EXIT SIGN.SDR QXEA2018022800079Guard · missingEMERGENCY LIGHT SWITCH GUARD IS MISSING. REPLACED SWITCH IAW AMM 33-51-05-000-801/400-801 AND REPLACED LOWER WARDROBE IAW AMM TASK 25-24-03-000-803/400-803. CHECKS GOOD.SDR QXEA2018022800075Light · looseFLOOR PATH EMERGENCY LIGHT STRIP LOOSE AT ROW 17 LEFT AND ROW 19 RIGHT. RESECURED FLOOR STRIP AS REQUIRED. CHECKS GOOD. RETURNED TO SERVICE. NO PARTS REPLACED.SDR SWAA2018022820158Light · brokenRT OVERWING EMERGENCY EXIT HATCH LIGHT COVER BROKEN. R&R LIGHT PER AMM.SDR SWAA2018022820145Cover · missingRT OVERWING EXIT SIGN COVER MISSING AT ROW 14. R&R SIGN IAW AMM.SDR ASOA201802277025Light · crackedA/C IS IN FOR A C-CHECK WHEN INSPECTION FOUND 10 OF THE EMERGENCY STRIPS CRACKED OR BROKEN. MAINTENANCE REMOVED AND REPLACED ALL THE LIGHT STRIPS IAW AMM33-50-12 AND OPS CHECK WAS GOOD. A/C WILL BE RELEASED AT THE END OF THE CHECK.SDR MASA2018022713015Light · inoperativeEMER LIGHT ABOVE L1 DOOR INOP. OPS CHECK NORMAL, NO DEFECTS FOUND.SDR CALA2018022700826Power Supply · no testEMERGENCY LIGHTS POWER SUPPLY AT ROW 1LK AND 24AB NOT TESTING INDIVIDUALLY IAW TASK CARD 64-3351-1-3800, STEP B. SLAVED GOOD KNOWN BATTERY STILL NO GOOD, SUSPECT POWER SUPPLY. REPLACED THE POWER SUPPLIES AT SEATS 1KL AND 24AB, OPS CHECKED OK.SDR CALA2018022700825Battery · no testRIGHT EMERGENCY LIGHT BATTERIES FAILED CABIN EMERGENCY LIGHTS OPS CHECK IAW TASK CARD 18-2428-1-6192, ITEM 27. REPLACED THE BATTERIES. PERFORMED EMERGENCY LIGHT SYS CHECK AND TESTED GOOD IAW 33-51-38, TASK CARD 18-2428-1-6192, ITEM 27.SDR YENA201802270113Battery Pack · no testEMERGENCY LIGHT EPSU 11WL BATTERY FAILED AN EMERGENCY LIGHTS SYS TEST. REPLACED THE BATTERY IAW AMM 33-51-38, OPS CHECKED GOOD.SDR YENA201802270112Battery Pack · failedFWD EPSU 10WL BATTERY FAILED AN EMERGENCY LIGHTS SYS TEST. REPLACED THE EPSU BATTERY IAW AMM 33-51-38, OPS CHECKED GOOD.SDR DALA2018022701203Battery Pack · failedFOUND WALKWAY EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE FOUND THAT THE BATTERY PACK WAS NOT CHARGING. THE BATTERY PACK WAS REPLACED AND NOW THE LIGHT OPERATE NORMALLY.SDR SIMA201804256005Light · damagedFOUR LT EMERGENCY LIGHT STRIP EXTRUSIONS ARE DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHTS IAW AMM 33-50-12.SDR AALA2018022800002Battery Pack · no testSEAT MOUNTED ESCAPE LIGHTING FAILED DUAL FEED CHECK. REPLACED FORWARD BATTERY IN OVERHEAD LAVATORY AREA IAW AML 33-53-00.SDR DALA2018022601313Lens · missingR1 DOOR EMERGENCY EXIT LIGHT SIGN COVER MISSING. INSTALLED A NEW EMERGENCY LIGHT SIGN.SDR AALA201802280001Battery Pack · faultySEAT MOUNTED EMERGENCY LIGHTS FAILED A DUAL FEED CHECK. REPLACED THE AFT BATTERY IN OVERHEAD GALLEY AREA IAW AML 33-53-00. OPS CHECKED NORMAL IAW AML 33-53-00/601.SDR AALA201802279020Lens · missingSEAT 19G EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201802289026Cover · missingAIRCRAFT WAS NOT GROUNDED: RIGHT AFT EMERGENCY EXIT SIGN COVER MISSING. MAINTENANCE REPLACED RIGHT AFT EMERGENCY EXIT SIGN COVER PER AMM 33-51-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802289025Cover · brokenRIGHT AFT EMERGENCY EXIT LIGHT COVER BROKEN AND WOULDN'T SNAP ON. MAINTENANCE REPLACED RIGHT AFT EMERGENCY LIGHT ASSEMBLY PER 33-51-01 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802279003Connector · disconnectedAIRCRAFT WAS NOT GROUNDED. SEAT 25 MOUNTED EMERGENCY/ESCAPE PATH LIGHT INOPERATIVE. RECONNECTED EMERGENCY LIGHT CONNECTOR THAT HAD COME UNDONE PER AMM 33-51-19.SDR AALA201802279005Light · inoperativeTHE AIRCRAFT WAS NOT GROUNDED. CEILING LIGHT EMERGENCY LIGHT INOPERATIVE AT ROW 18. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY IN CEILING PER AMM 33-51-11. OPERATIONS CHECK GOOD AT THIS TIME.SDR SWAA2018022820152Lens · damagedR1 DOOR HEADER PANEL EMERGENCY EXIT LIGHT LENS DAMAGED. R&R LENS PER AMM.SDR MASA2018022713012Light · inoperativeROW 20 EMER FLOOD LIGHT INOP. RELAMPED.SDR DALA2018022701215Charger · inoperativeRIGHT WING EGRESS LIGHTS INOPERATIVE AT BS 988 AND 1098. REPLACED THE BATTERY CHARGER M731. SYSTEM OPS NORMAL.SDR DALA2018022601170Power Supply · defectiveTHE TAIL CONE EMERGENCY EXIT LIGHT ILLUMINATED ON THE GROUND UNCOMMANDED. MAINTENANCE REPLACED THE AFT CABIN EMERGENCY EXIT LIGHT POWER SUPPLY PER AMM 33-51. THE LIGHT CHECKS GOOD AT THIS TIME.SDR SWAA2018040320929Light · inoperativeR2 DOOR EXTERNAL EMERGENCY EGRESS LIGHT INOPERATIVE. R & R THE LIGHT IAW AMM.SDR AALA20180226011Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK HAS NO POWER OUTPUT, REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06. SYSTEM OPS CHECKED GOOD.SDR AALA201802289031Lens · detachedAIRCRAFT WAS NOT GROUNDED. COVER CLOSE TO FLOOR NEXT TO FIRST CLASS GALLEY OFF. INSTALLED EMERGENCY LIGHT LENS TO THE ABOVE LOCATION DESCRIPTION PER AMM 33-51-00.SDR AALA201802289022Battery Pack · no testEMERGENCY LIGHTS TEST FAILED, EMERGENCY POWER SUPPLY UNIT (12WL). MAINTENANCE REPLACED 12WL BATTERY PACK PER AMM 33-51-38 AND PERFORMED SATISFACTORY OPERATIONAL CHECK. AIRCRAFT WAS GROUNDEDSDR AALA201802289020Lens · missingR4 DOOR SLIDE EMERGENCY EXIT LIGHT LENS MISSING. MAINTENANCE REPLACED THE LENS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802279035Battery Pack · inoperativeEMERGENCY LIGHT ON SEAT 16D-20D IS INOPERATIVE. REMOVED AND REPLACED NUMBER 4 BATTERY PACK PER AMM 33-51-06. OPERATIONS CHECK GOOD. ALSO REMOVED AND REPLACED HARNESS ON SEAT 16F TO RECEPTACAL D12836 IAW ESO60882 THE AIRCRAFT WAS GROUNDED.SDR ASAA2018022523702Sign · unsecureEXIT SIGN IN AFT GALLEY HANGING DOWN. GROUNDED - YES. REMOVED AND REPLACED AFT GALLEY CEILING EXIT SIGN PER AMM 33-51-01. OPS TEST GOOD.SDR DALA2018022601217Light · inoperativeFLOOR EMERGENCY LIGHT INOPERATIVE AT SEAT 23F. SECURED THE EMERGENCY LIGHT.SDR SWAA2018022720142Battery Pack · inoperativeRIGHT LOWER EXTERIOR EMERGENCY EXIT SLIDE LIGHTS INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018022720118Battery Pack · inoperativeLEFT LOWER EXTERIOR EMERGENCY EXIT SLIDE LIGHTS INOPERATIVE. R & R THE BATTERY PACK IAW AMM.SDR AALA201802269073Lens · missingR4 DOOR MISSING EMERGENCY EXIT COVER LENS. INSTALLED R4 DOOR EMERGENCY EXIT COVER LENS AS REQUIRED.SDR AALA201802269059Lens · missingR3 DOOR MISSING EMERGENCY EXIT COVER LENS. INSTALLED R3 DOOR EMERGENCY EXIT COVER LENS AS REQUIRED.SDR DALA2018022701205Battery Pack · inoperativeCEILING EMERGENCY LIGHTS INOPERATIVE AT ROW 16 - 20. REPLACED THE BATTERIES, CHECKED GOOD IAW AMM 33-50.SDR ASAA2018022523682Lens · missingROW 16 ABC LOWER EMERGENCY EXIT LIGHT LENS MISSING. ACFT GROUNDED. INSTALLED A NEW LENS IAW AMM 33-51-01.SDR SWAA2018022620083Battery Pack · dischargedFORWARD ENTRY DOOR EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.
Back to JASC 3350