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 AALA201806069024Battery · no testEMERGENCY LIGHT POWER SUPPLY BATTERIES FAULTED. MAINTENANCE REPLACED THE BATTERIES IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201806069023Battery Pack · no testEMERGENCY LIGHTS POWER SUPPLY BATTERIES FAULTED. MAINTENANCE REPLACED THE BATTERIES IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201806069020Battery Pack · no testEMERGENCY LIGHT POWER SUPPLY BATTERIES FAULTED. MAINTENANCE REPLACED THE BATTERIES IAW AMM 33-51-38, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201806069019Cover · displacedEMERGENCY LIGHT AT 8 LEFT, BACK COVER DISPLACED. MAINTENANCE SECURED THE EMERGENCY LIGHT BACK COVER AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201806069018Lamp · inoperativeSEAT 20L EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REPLACED THE LAMP IAW AMM 33-51-19, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR R61A2018060630677Battery Pack · inoperativeCABIN EMERGENCY LIGHTS INOPERATIVE. R & R THE AFT BATTERY PACK IAW AMM 33-50-01.SDR ASAA2018060534907Battery Pack · dischargedEMERGENCY LIGHT ABOVE THE R2 DOOR AND AT THE R2 DO NOT ILLUMINATE. ACFT GROUNDED. REMOVED AND REPLACED THE BATTERY PACK AND CHARGER M1672 IAW AMM 33-51-06-960-805, AND 33-51-06-960-806. OPS CHECKED GOOD IAW AMM 33-51-06-960-805, STEP 405 AND 33-51-06-960-8SDR FDEA201806031382Unknown · malfunctionedEMERGENCY LIGHT WILL NOT TEST. RECYCLED THE EMERGENCY LIGHT TEST SWITCH AS PER SMP AND DID EMERGENCY LIGHT TEST AS PER AMM 33-50-00-5 SEVERAL TIMES. EMERGENCY LIGHT TEST PASSED. NIL FAULT NOTED. A/C OK FOR SERVICE.SDR SWAA2018060422527Cover · looseFORWARD RT EMERGENCY EXIT LENS COVER LOOSE. SECURED COVER IAW MM.SDR SIMA2018060403002Light · inoperativeEMERGENCY LIGHT STRIPS AT ROWS 7 & 8 WERE INOPERATIVE. R & R THE EMERGENCY LIGHT STRIP IAW AMM 33-50-12. OPS CHECKED GOOD. NO DEFECTS NOTED.SDR YENA2018060430234Battery Pack · failedEMERGENCY LIGHT FAILED TO TEST. REMOVED AND REPLACED THE EMERGENCY LIGHT BATTERY AT EPSU 12WL IAW AMM 33-51-38 OPS CHECKED GOOD.SDR ASOA2018060625149Battery Pack · inoperativeDURING A MX INSPECTION, THE NR 2 EMERGENCY LIGHT BATTERY WAS INOPERATIVE. MX REMOVED AND REPLACED THE BATTERY. OPS CHECKED GOOD. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SIMA201806052006Power Supply · inoperativeCABIN INTERIOR CEILING EMERGENCY LIGHT WAS INOPERATIVE AT ROWS 9 - 10 DURING A TEST. REMOVED AND REPLACED THE EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-50-01. PERFORMED AN OPS TEST IAW AMM 33-50-01, THEN PERFORMED OPS TEST OF EMERGENCY LIGHTS IAW AMM 33-50-0SDR AALA201806059032Cover · detachedSEAT 34C AISLE EXIT LIGHT COVER DETACHED. MAINTENANCE SECURED THE ROW 34C AISLE LIGHT COVER AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201806059030Lamp · inoperativeLAVATORY D, RED EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REPLACED THE LAMPS, AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-00-710-007A.SDR DALA2018060543833Fuse · failedEMERGENCY LIGHTS ROWS 31-46 WERE INOPERATIVE. FOUND THE FUSE AT M9010 CHARGER TO BE BLOWN, REPLACED AND THE SYSTEM OPS NORMAL.SDR SWAA2018060422529Lens · looseRT OVERWING EXIT LIGHT COVER LOOSE AT ROW 15. SECURED LENS PER MM.SDR SWAA2018060522504Light · inoperativeLT EMERGENCY EXIT WALL LAMP INOP. R&R LAMP IAW AMM.SDR SWAA2018060422486Battery Pack · dischargedR1 DOOR EXTERNAL EMERGENCY LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SIMA2018060420003Lamp · inoperativeSERVICE DOOR EXTERIOR EMERGENCY LIGHT WAS INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT LAMP IAW AMM 33-50-10-000-801-A, AND 33-50-10-000-801-A. OPS CHECKED GOOD.SDR DALA2018060403791Light · inoperativeLEFT OVER WING EMERGENCY EVACUATION LIGHT INOP. R&R LEFT AND RIGHT EXTERIOR EMERGENCY LIGHT ASSEMBLIES PER AMM 33-51. R&R POWER SUPPLY B5-125 PER AMM 33-51. ALL CHECK GOOD.SDR JJBA201806042001Fuse · failedEMERGENCY LIGHTS FLICKERING ON UNCOMMANDED. FOUND FUSE F0004 BLOWN. R & R THE FUSE F0004. OPS CHECK GOOD.SDR YENA201806042232Epsu · failedDURING HEAVY MAINTENANCE, EMERGENCY LIGHT TEST EPSU (10WL) WAS FOUND INOP; REMOVED & REPLACED EPSU 10WL AS REQUESTED BITE TEST ALL OPS CHECKS OK PER AMM 33-51-38-740-050-B REV 73.SDR DALA2018060403774Light · inoperativeSEAT 19 EMERGENCY LIGHT NOT WORKING. REMOVED AND REPLACED EMERGENCY LIGHT ON SEAT 19 REF AMM 33-53 OPS CHECK GOOD.SDR REXA2018060610447Light · brokenEMERGENCY LIGHT ABOVE THE SERVICE DOOR HAD THE BASE & LENS BROKE. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-13-400-801. OPS TESTED GOOD IAW AMM 33-51-00-710-801.SDR ASOA2018060615147Battery Pack · inoperativeEMERGENCY LIGHTS OVER THE DOORS WOULD NOT LIGHT UP. MX REMOVED AND REPLACED THE NR 3 EMERGENCY LIGHT BATTERY AND OPS CHECKED GOOD. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA201806059019Light · inoperativeEMERGENCY EXIT MARKER AT SEAT 11C WILL NOT ILLUMINATE. REPLACED THE EMERGENCY EXIT MARKER IAW AMM 33-51-19. OPS CHECKED GOOD.SDR AALA201806059017Lens · missing4C EMERGENCY LIGHT LENS MISSING. R EPLACED THE LENS.SDR AALA2018060549036Lens · missingDOOR AFT LEFT SLIDE LIGHT INOPERATIVE AND MISSING THE LENS. REINSTALLED AFT LEFT DOOR SLIDE ARMED LIGHT LENS.SDR DALA2018060523836Charger · inoperativeFOUND THREE OUTSIDE EMERGENCY LIGHTS INOPERATIVE AT THE AFT LEFT FUSELAGE AND AFT LEFT ENTRY DOOR LOCATIONS. REPLACED M739 EMERGENCY LIGHT CHARGER AND BATTERY PACK ASSEMBLE. SYSTEM OPS NORMAL.SDR DALA2018060403825Light · inoperativeDURING S/C FOUND EMERGENCY SEAT LIGHTS INOP FROM ROW 18-ROW 22. REPLACED SAME IAW AMM REF 33-51-07 TEST OK.SDR SWAA2018060522536Battery Pack · dischargedLT AFT CABIN EMERGENCY LIGHT INOP AT ROW 20. R&R BATTERY PACK IAW AMM.SDR SWAA2018060522535Battery Pack · dischargedLT AFT CABIN EMERGENCY LIGHT INOP AT ROW 17. R&R BATTERY PACK IAW AMM.SDR SWAA2018060422534Sign · damagedLT EMERGENCY EXIT DOOR LOWER EXIT SIGN LENS DAMAGED. R&R SIGN PER AMM.SDR SWAA2018060422530Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1668. R&R BATTERY PER AMM.SDR SWAA2018060422510Light · inoperativeL2 DOOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018060522508Battery Pack · dischargedAFT GALLEY LT AFT ESCAPE SLIDE EMERGENCY LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2018060522507Battery Pack · dischargedBULLNOSE EMERGENCY LIGHT INOP AT ROW 4. R&R BATTERY PACK IAW AMM.SDR SWAA2018060522506Battery Pack · dischargedBULLNOSE EMERGENCY LIGHT INOP AT ROW 6. R&R BATTERY PACK IAW AMM.SDR SWAA2018060422503Light · inoperativeL1 DOOR EMERGENCY LIGHT INOP. R&R LIGHT IAW AMM.SDR SWAA2018060522483Battery Pack · dischargedLT AFT CABIN EMERGENCY LIGHT INOP AT ROW 23. R&R BATTERY PACK IAW AMM.SDR SWAA2018060522480Battery Pack · dischargedBULLNOSE EMERGENCY LIGHT INOP AT ROW 1. R&R BATTERY PACK IAW AMM.SDR SWAA2018060522479Battery Pack · dischargedBULLNOSE EMERGENCY LIGHT INOP AT ROW 5. R&R BATTERY PACK IAW AMM.SDR SWAA2018060522478Battery Pack · dischargedR1 DOOR EMERGENCY LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2018060422468Light · inoperativeR2 DOOR LOWER EMERGENCY EXIT SIGN BULB INOP. R&R SIGN PER AMM.SDR ASAA2018060424906Power Supply · no testEMERGENCY LIGHTS TEST FAILED IAW T/C 7823308. REPLACED THE M1673, M1675 AND M1674 POWER SUPPLIES. OPS CHECKED NORMAL IAW AMM 33-51-06-960-806.SDR ASAA2018060424905Battery Pack · failedAISLE EMERGENCY EXIT LIGHTS, BULL NOSE OF STOW BIN, WERE INOPERATIVE ABOVE SEATS 4 DF, 7 DEF AND 10 DEF. ACFT GROUNDED. REPLACED THE M1674 BATTERY PACK, OPS NORMAL IAW MM 33-51-06-960-806.SDR ASAA2018060424904Bulb · inoperativeRIGHT FWD OVERWING EMERGENCY LIGHT INOPERATIVE. ACFT GROUNDED. REPLACED THE LAMP AND REPLACED THE M1674 BATTERY PACK, OPS NORMAL IAW AMM 33-51-06-960-806.SDR ASAA2018060424892Battery Pack · no testDURING TASKCARD 78233001, EMERGENCY LIGHT AT THE L2 DOOR DID NOT STAY ILLUMINATED FOR THE 15 MIN TEST. ACFT GROUNDED. REPLACED THE M1673 BATTERY PACK, OPS NORMAL IAW AMM 33-51-06-960-806.SDR HALA2018060400275Lens · detachedFWD ENTRY DOOR EMERGENCY EXIT SIGN LENS DETACHED. INSTALLED A NEW EMERGENCY SIGN LENS. LIGHT OPS CHECKED OK.
Back to JASC 3350