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 DALA2018102906392Bezel · unsecureEMERGENCY AISLE LIGHTING HANGING BY WIRES AT SEATS 19B, 23B, 27G, 30G. SECURED BEZEL AND REPLACED TRIM.SDR SWAA2018102626238Battery Pack · failedLT FRONT EMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK. R&R BATTERY PACK IAW AMM.SDR SWAA2018102626234Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK AT ROW 17. R&R BATTERY PACK PER MM.SDR DALA2018102606316Light · brokenWIRE BUNDLE HANGING BELOW SEAT 15B. FOUND EMERGENCY LIGHT ASSEMBLY BROKEN OFF THE SEAT. REPLACED EMERGENCY LIGHT ASSEMBLY.SDR AALA201810269008Flashlight · inoperativeFORWARD GALLEY FLIGHT ATTENDANT`S SEAT FLASHLIGHT INOPERATIVE. REPLACED THE FLASHLIGHT IAW AMM 25-65-00.SDR AALA201810269006Battery · dischargedEXTERIOR EMERGENCY LIGHT FORWARD OF LEFT AFT ENTRY DOOR INOPERATIVE. REPLACED THE BATTERY AND CHARGER IAW MM 33-51-07. CHECKED NORMAL.SDR AALA201810269002Battery · dischargedEXTERIOR EMERGENCY LIGHT AFT OF LEFT WING TRAILING EDGE WAS INOPERATIVE. REPLACED BATTERY AND CHARGER IAW AMM 33-51-07. CHECKED NORMAL.SDR AALA201810264006Charger · failedEXTERIOR EMERGENCY LIGHT FORWARD OF LEFT AFT ENTRY DOOR INOPERATIVE. REPLACED BATTERY AND CHARGER IAW MM 33-51-07. CHECKED NORMAL.SDR AALA201810264005Charger · failedEXTERIOR EMERGENCY LIGHT AFT OF LEFT WING TRAILING EDGE INOPERATIVE. REPLACED THE BATTERY AND CHARGER IAW AMM 33-51-07. CHECKED NORMALSDR QXEA2018102500383Circuit Breaker · poppedEMERGENCY LIGHTS ILLUMINATED IN THE CABIN WHEN THE SWITCH POSITION IS ON ARM. REMOVED FROM SERVICE. FOUND CB E3 LT "EMERGENCY LIGHT REMLAT" POPPED. RESET CB PER GPM 9.2.2.1. OPS CHECK GOOD IAW AMM 33-51-00-710-802. RETURNED TO SERVICE. NO PARTS REPLACED.SDR AALA201810259023Light · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING PERIODIC SERVICE CHECK, STEP 20, EMERGENCY LIGHT TEST FAULT EXTERNAL AFT LEFT. MAINTENANCE REPLACED AFT LEFT EMERGENCY SLIDE ASSEMBLY RAFT PER AMM TASK 25-62-44-400-007-A.SDR AALA201810259020Battery · dischargedAIRCRAFT WAS NOT GROUNDED. COACH CLASS SEAT MOUNTED EMERGENCY LIGHTS ARE INOPERABLE. REPLACED EMERGENCY LIGHT BATTERIES FOR COACH CLASS PER MM 33-51-07.SDR AALA201810259019Battery · dischargedAIRCRAFT WAS NOT GROUNDED. FIRST CLASS SEAT MOUNTED EMERGENCY LIGHTS ARE INOPERABLE. REPLACED EMERGENCY LIGHT BATTERIES FOR FIRST CLASS PER MM 33-51-07.SDR DALA2018102506287Battery Pack · dischargedR4 OVER DOOR EXIT SIGN, L4 LWR FWD EXIT SIGN AND 4 LAST ROWS SEAT MOUNTED EXIT LIGHTS INOP. FOUND BATTERY PACK M736 AT FAULT. REPLACED BATTERY PACK PER AMM 33-51. ALL EMERGENCY LIGHTS AND SIGNS NOW CKS GOOD.SDR DALA2018102406267Fuse · blownALL EMERGENCY EXIT LIGHT IN F/C AND FWD ENTRY INOP. TROUBLESHOT FWD SECTION EMERGENCY LIGHTS FOUND B5-211 BATTERY PACK OVER ROW 3 CD FUSE BAD REPLACED PER WIRING DIAGRAM MAN 33-51-14. CKS GOOD PER AMM 33-53-01.SDR SIMA20181023001Light · inoperativeRT AFT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED RT AFT OVERWING EMERGENCY EXIT LIGHT BULB IAW AMM 33-50-07. OPS CHECK GOOD.SDR SWAA2018102426216Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2018102426215Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2018102426214Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1669. R&R BATTERY PER AMM.SDR SWAA2018102426213Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PER AMM.SDR SWAA2018102426190Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PER AMM.SDR SWAA2018102426189Battery Pack · failedLT OVERWING EMERGENCY EXIT LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2018102426188Battery Pack · failedAFT LT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R&R BATTERY PACK PER MM.SDR SWAA2018102426182Cover · missingR2 DOOR EXIT LIGHT COVER MISSING. INSTALLED COVER IAW AMM.SDR AALA201810249007Cover · missingFLOOR EMERGENCY LIGHT COVER AT ROW 34 WAS MISSING. INSTALLED THE COVER IAW AMM 33-51-11.SDR AALA201810249008Fuse · failedRIGHT OVERWING AFT EXIT EMERGENCY LIGHT AT DOOR AND LOWER FUSELAGE WAS INOPERATIVE. REPLACED THE FUSES.SDR AALA201810243005Fuse · failedRIGHT OVERWING, AFT EXIT EMERGENCY LIGHT AT DOOR AND LOWER FUSELAGE WAS INOPERATIVE. REPLACED THE FUSES.SDR REXA2018102320968Light · inoperativeFLOOR TRACK EMERGENCY LIGHTS 9 THRU 12 INOP
REMOVED AND REPLACED AFT EMERGENCY LIGHT CABLE ASSEMBLY AND #10 EMERGENCY LIGHT STRIP IAW CRJ 200 AMM 33-51-01. OPS CHECKS GOOD.SDR AALA201810262005Battery Pack · inoperativeAFT CABIN EMERGENCY EXIT SIGN WAS INOPERATIVE. REPLACED THE POWER SUPPLY BATTERY PACK IAW MM 33-51-06-960-802. OPS CHECKED GOOD.SDR AALA201810239028Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED: BATTERY PACK AT OFCR INOPERABLE. MAINTENANCE REPLACED BATTERY AT OFCR PER AMM 33-29-10-960-810 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201810239027Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT AT 2L DOOR INOPERABLE. MAINTENANCE RELAMPED LIGHT PER AMM 33-50-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20181023002Light · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS INOPERABLE FROM SEATS 20AB TO 22AB. MAINTENANCE SECURED CONNECTOR ON SEAT 23AB AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-10.SDR IPXA201810245287Battery Pack · inoperativeAN EMERGENCY LIGHT TEST FAILED, EMERGENCY LIGHT BATTERY 1 LOW. R & R THE BATTERY PACK IAW MM 33-51-01. OPS CHECKED GOOD.SDR DALA2018102406251Power Supply · defectiveWHILE PERFORMING OPS CHECK OF EMERGENCY LIGHT BATTERY PACKS, C/B Z37 EMERGENCY LIGHT CHARGING AND A14 EMERGENCY LIGHTS ARM AND CHARGE POPPED. REMOVED AND REPLACED BATTERY RECHARGEABLE POWER SUPPLY AND BATTERY AFT CARGO PER AMM 33-51-03 AND IPC 33-51-00. OPS TESDR SWAA2018102326163Cover · missingRT EMERGENCY AISLE LIGHT COVER MISSING AT ROW 5. R&R COVER IAW AMM.SDR FDEA201810222967Light · inoperativeRIGHT SIDE EMERGENCY SLIDE LIGHT INOP. RELAMPED RT EMERGENCY EVACUATION SLIDE LIGHT AS PER AMM 33-51-06-2-1. OPS CHECK GOOD. AIRCRAFT OK FOR SERVICE.SDR SWAA2018102226160Lens · brokenEXIT LIGHT COVER BROKEN. R&R LENS COVER PER AMM.SDR AALA201810239016Lens · missingFLOOR LEVEL EMERGENCY LIGHT LENS MISSING AT SEAT 9D. REPLACED LENS. OK FOR SERVICE.SDR AALA201810239014Lens · detachedEXIT LIGHT LENS FELL OFF THE R2 DOOR, RETAINED IN COCKPIT. REPLACED THE LENS.SDR AALA201810239013Lens · missingEMERGENCY LIGHT LENS MISSING ON SEAT 9D. REPLACED THE LENS, OPS CHECKED GOOD IAW AMM 33-51-18.SDR REXA2018102310967Light · inoperativeFOUND EXTERIOR EMERGENCY LIGHT 2 INOP.
REMOVED AND REPLACED EXTERIOR EMERGENCY LIGHT 2 IAW CRJ 200 AMM 33-51-21.SDR AALA201810249017Battery Pack · faultyAIRCRAFT WAS GROUNDED. 4R DOOR OUTSIDE EMERGENCY LIGHT SWITCH WAS IN ARM POSITION. MAINTENANCE REPLACED 4R DOOR EMERGENCY LIGHT BATTERY PACKS FORWARD (SEE AALA201810239024) AND AFT PER AMM 33-51-06 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201810249011Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT (13WL) FAULT. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY PER AMM 33-51-38 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201810249009Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT (12WL) FAULT. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY PER AMM 33-51-38 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201810239024Battery Pack · faultyAIRCRAFT WAS GROUNDED. 4R DOOR OUTSIDE EMERGENCY LIGHT SWITCH WAS IN ARM POSITION. MAINTENANCE REPLACED 4R DOOR EMERGENCY LIGHT BATTERY PACKS FORWARD AND AFT (SEE AALA201810249017) PER AMM 33-51-06 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018102426180Lens · missingRT LOWER EMERGENCY EXIT PLACARD MISSING. INSTALLED LENS PER SIP.SDR DALA2018102406260Lens · unsecureDOOR 2 R EXIT SIGH COVER FELL OFF MOUNTING. REINSTALLED EXIT SIGH LENS AT 2R.SDR IPXA2018102425264Bulb · inoperativeEMERGENCY LIGHT AT THE L1 DOOR WAS INOPERATIVE. REMOVED AND REPLACED THE BULBS AND LENS IAW AMM 33-51-17-0401. OPS CHECKED NORMAL.SDR AALA201810239010Sign · brokenR2 DOOR AFT LOWER EMERGENCY EXIT SIGN WAS BROKEN. REPLACED THE SIGN IAW AMM 33-51-13.SDR AALA201810239009Sign · brokenR1 DOOR FORWARD LOWER EMERGENCY EXIT SIGN WAS BROKEN. REPLACED THE SIGN IAW AMM 33-51-13.
Back to JASC 3350