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 SWAA2018052922285Battery Pack · dischargedR1 DOOR EMERGENCY LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2018052922284Cover · missingAFT BULKHEAD EMERGENCY LIGHTING COVER MISSING. INSTALLED COVER PER MM.SDR AALA201805299025Power Supply · no testEMERGENCY POWER SUPPLY UNIT WL14 FAILED A SYSTEM TEST. MAINTENANCE REPLACED THE POWER SUPPLY BATTERY AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-38.SDR R61A2018052950621Light · unsecureFLOOR EMERGENYC LIGHT STRIP WAS DISPLACED. SECURED THE FWD RT EMERGENCY LIGHT IAW AMM 33-50-01.SDR SIMA201805295002Light · inoperativeROWS 5 & 6A EMERGENCY LIGHT WAS INOPERATIVE. R & R THE EMERGENCY LIGHT IAW AMM 33-50-12, OPS CHECKED GOOD.SDR SIMA201805295001Lamp · inoperativeROW 16 CEILING EMERGENCY LIGHT WAS INOPERATIVE. R & R THE LAMP IAW AMM 33-50-08. OPS CHECKED GOOD.SDR I5EA2018052900008Charger · inoperativeLEFT ROW 13 INTERIOR EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY CHARGER M1134 IAW AMM 33-51-51, OPS CHECKED GOODSDR I5EA201805290007Charger · inoperativeLEFT FWD OVERWING EXIT EXTERNAL LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY CHARGER M1134 IAW AMM 33-51-51. OPS CHECKED GOODSDR AALA20180525005Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE. L2 DOOR BATTERY PACK FAILS OPERATIONS CHECK. REPLACED L2 DOOR EMERGENCY POWER SUPPLY BATTERY PACK (M33096) PER AMM 33-51-06-960-802. OPERATIONS CHECK GOOD.SDR AALA20180525004Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE. L1 DOOR BATTERY PACK FAILED OPERATIONS CHECK. REPLACED L1 DOOR EMERGENCY LIGHT POWER SUPPLY (M33093) PER AMM 33-51-06-960-802. PERFORMED SATISFACTORY OPERATIONS CHECKS.SDR DALA2018052503603Battery · dischargedCEILING EMER LIGHTS AT ROWS 26-31 INOP. REPLACED BATTERIES AT PACK B5-106. OPS CK OK.SDR DALA2018052503602Battery · dischargedON SERVICE CHECK- EMERGENCY LIGHTS AT L1, R1, AND COCKPIT OVERHEAD DID NOT REMAIN ON. REPLACED EMERGENCY LIGHT BATTERIES IN FWD DROP DOWN PNL. OPS CHECKS GOOD AMM 33-53.SDR MASA2018052513255Light · inoperativeCEILING EMER FLOOD LIGHT INOP ROW 3. REPLACED LIGHT BULBS.SDR HALA0218052500258Cids · malfunctionedTHE R3 DOOR EXIT SIGN WAS FOUND INOPERATIVE. RESET CIDS, PERFORMED AN OPS CHECK OF THE EMERGENCY LIGHTS. OPS CHECKED GOOD. OK FOR SERVICE.SDR DALA2018061504032Light · detachedDURING INSPECTION, FOUND THE EMERGENCY EXIT AISLE LIGHT AT SEAT 23D WAS HANGING DOWN BY THE WIRE. MAINTENANCE REPLACED SEAT SHROUD/BUMPER IAW CMM 25-27-48.SDR CALA2018060531355Battery · dischargedEPSU BATTERY, AFT LEFT 13WL FAILED AN EMERGENCY LIGHTS OPS TEST. REMOVED AND REPLACED THE BATTERY 13WL IAW AMM 33-51-38-4 00-008A. ACCOMPLISHED AN OPERATIONAL TEST OF THE EMERGENCY LIGHTS IAW AMM 33-51-00-710-001A, TESTED OK.SDR SWAA2018053022279Light · inoperativeFLIGHT DECK " EMERGENCY LIGHT" IN CEILING INOP. INSTALLED LAMP IAW AMM.SDR SWAA2018053022243Lens · brokenL2 DOOR EXIT LIGHT COVER BROKEN. SECURED LENS PER EA.SDR YENA201805240227Epsu · failedDURING HEAVY MAINTENANCE, OPERATIONAL TEST OF EMER LIGHTS FAILED DURING TEST. REPAIRED 3 EA EPSU'S AT (10WL-11WL AND 12WL) AND 1 BATTERY AT (10WL) IAW AMM 33-51-38-000-001-A. SYS OPS CKS NORMAL.SDR YENA201805240226Epsu · failedDURING HEAVY MAINTENANCE, OPERATIONAL TEST OF EMER LIGHTS FAILED DURING TEST. REPAIRED 3 EA EPSU'S AT (10WL-11WL AND 12WL) AND 1 BATTERY AT (10WL) IAW AMM 33-51-38-000-001-A. SYS OPS CKS NORMAL.SDR YENA201805240225Epsu · failedDURING HEAVY MAINTENANCE, OPERATIONAL TEST OF EMER LIGHTS FAILED DURING TEST. REPAIRED 3 EA EPSU'S AT (10WL-11WL AND 12WL) AND 1 BATTERY AT (10WL) IAW AMM 33-51-38-000-001-A. SYS OPS CKS NORMAL.SDR YENA201805294224Battery Pack · failedOPS TEST OF THE EMERGENCY LIGHTS FAILED. REPAIRED THREE POWER SUPPLIES, 10WL, 11WL, AND 12WL) AND ONE BATTERY 10WL IAW AMM 33-51-38-000-001-A. SYS OPS CHECKED NORMAL.SDR AALA2018052989019Light · damagedWALL MOUNTED EMERGENCY LIGHT AT THE R1 DOOR WAS FOUND DAMAGED. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-13.SDR AALA2018052989029Light · inoperativeAFT GALLEY FORWARD WALL EMERGENCY PROXIMITY LIGHT INOPERATIVE. REPLACED PROXIMITY LIGHT IAW MM 33-51-06.SDR AALA201805259013Cids · malfunctionedEMERGENCY LIGHTS AT THE L3 DOOR AND CEILING WERE ILLUMINATED. MAINTENANCE RESET CIDS AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-52-00, FAULT COULD NOT BE DUPLICATED.SDR 29GA2018052500003Bulb · inoperativeARM LIGHT ON THE FLIGHT ATTENDANT LIGHT PANEL, THE EMERGENCY LIGHT SWITCH WAS INOPERATIVE. REPLACED THE LIGHT SWITCH BULB. OPS TESTED GOOD.SDR 29GA2018052500001Bulb · inoperativeARM LIGHT ON THE FLIGHT ATTENDANT LIGHT PANEL, THE EMERGENCY LIGHT SWITCH WAS INOPERATIVE. REPLACED FLIGHT ATTENDANT EMERGENCY LIGHT SWITCH BULB, OPS CHECKED GOOD.SDR DALA2018052403539Light · inoperativeLT FWD OVERWING EMER EXIT 1 BULB INOP. REPLACED LT FWD OVERWING EMER EXIT BULB PER AMM 33-50. OPS CHECK GOOD AT THIS TIME.SDR ASOA2018053025139Charger · inoperativeDURING A MX INSPECTION, THE CEILING EMERGENCY LIGHT AT PANEL 253CLC AND 263ALC WERE FOUND INOPERATIVE. MX REMOVED AND REPLACED THE NR 3 BATTERY CHARGER, OPS CHECKED GOOD. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA2018053035138Light · inoperativeDURING A MX INSPECTION, THE ORANGE HALF OF THE FLOOR EMERGENCY LIGHT STRIP WAS NOT ILLUMINATING. REMOVED & REPLACED EMERGENCY LIGHT STRIP, OPS CHECKED GOOD. THE ACFT WAS APPROVED FOR RETURNED TO SERVICE.SDR AALA201805259016Warning Message · false activationEMERGENCY LIGHT POWER SUPPLY, MID RIGHT, FAULT MESSAGE FOUND DURING EMERGENCY LIGHT TEST. MAINTENANCE PERFORMED EMERGENCY LIGHT TEST IAW 33-51-00, SYSTEM BITE TESTED NORMAL, NO FAULT NOTED.SDR AALA201805249011Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT TEST FAILED. REPLACED BATTERY 12WL PER 33-51-38.SDR SWAA2018052422225Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01672. R&R BATTERY PER MM.SDR SWAA2018052422224Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01670. R&R BATTERY PER MM.SDR SWAA2018052422223Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01669. R&R BATTERY PER MM.SDR SWAA2018052422206Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01673. R&R BATTERY PER MM.SDR DALA2018052403538Light · inoperativeDOOR R1 EMERGENCY LIGHT INOP. RELAMPED OPS CHECK GOOD IAW AMM 33-51.SDR MASA2018052313252Lamp · inoperativeROW 8 OVERHEAD EMERGENCY FLOOD LIGHT WAS INOPERATIVE. REPLACED THE LAMPS.SDR REXA201806050444Charger · inoperativeCABIN EMERGENCY LIGHTS DS154, DS156, AND S342 WERE INOPERATIVE. REMOVED AND REPAIRED THE NR 1 EMERGENCY LIGHT BATTERY CHARGER IAW AMM 33-21-17, OPS TESTED GOOD IAW AMM 33-51-17-710-801.SDR AALA2018060523007Connector · brokenFOUND CONNECTOR D40040P BROKEN AT THE L1 DOORWAY HEADER PANEL. REMOVED AND REPLACED THE CONNECTOR IAW SWPM 20-72-24, WDM 35-21-21, 33-51-12, AND 23-31-04. PERFORMED AN OPS TEST IAW AMM 33-51-00, 23-31-01, AND 35-22-00. OPS CHECKED GOOD. THE AIRCRAFT WAS GRSDR AALA201805249013Battery · dischargedTHE AIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY LIGHTS FROM SEAT 29D TO 36D ARE DIM. REPLACED BATTERY FOR AFT CABIN EMERGENCY LIGHTS PER AMM 33-51-07. OPERATIONS CHECK NORMAL.SDR AALA201805249030Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK EMERGENCY LIGHT OVERHEAD PANEL INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK B5-23 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-53-00.SDR DALA2018052303554Battery Pack · dischargedEMERGENCY LIGHTS ON SEAT ROW 27-32 INOP. INSTALLED SERVICEABLE BATTERY PACK & BATTERY UNIT M10568 PER AMM 33-51-07.SDR N6WA2018052202Light · inoperativeOVERHEAD EMERGENCY EXIT LIGHT OUT. REMOVED AND REPLACED NR 3 OVERHEAD EMERGENCY EXIT FLOOD LIGHT AMM 33-51-09.SDR SWAA2018052422211Cover · brokenL2 DOOR EMERGENCY LIGHT COVER BROKEN OFF. R&R LIGHT ASSEMBLY PER AMM.SDR DALA2018052403537Charger · inoperativeON SVC CK FOUND FIST CLASS EMERGENCY LIGHTS INOP. R&R FUSE AT BATTERY CHARGER IN O/H COMP ABOVE 2 CD PER WDM 33-51 AND OPS CK PER AMM 33-53 OPS CK GOOD.SDR IPXA201805239879Battery Pack · inoperativeFOUND THE EMERGENCY LIGHT TEST FAILED. R & R THE BATTERY PACK IAW AMM 33-51-01/401. PERFORMED AN EMERGENCY LIGHT TEST, FOUND TO BE SATISFACTORY.SDR SWAA2018052322203Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01675. R&R BATTERY PER AMM.SDR SWAA2018052322202Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01669. R&R BATTERY PER AMM.SDR SWAA2018052322201Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01670. R&R BATTERY PER AMM.
Back to JASC 3350