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 MASA2017113012803Lamp · inoperativeROW 18 CEILING LEVEL EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS.SDR YENA201711290967Battery Pack · failedFT # 268, PUJ-JFK. FWD "L" + AFT "L" EPSU'S FOUND WITH BATTERY FAULTS DURING EMERGENCY LIGHT TEST; R & R FWD "L" + AFT "L" EPSU BATTERIES IAW AMM 33-51-38. PERFORMED EMERG. LIGHT TEST, TEST OK. SUPPLEMENTAL INFORMATION TO FOLLOW.SDR DALA2017120408434Light · inoperativeEMERGENCY ESCAPE LIGHTS ARE INOPERATIVE AT ROW 37FG. REPLACED SEAT SHROUD AND LIGHT HOUSING. SYSTEM OPERATION IS NORMAL. MCO/PLAC REMOVED.SDR AALA201712019042Battery · dischargedAIRCRAFT WAS NOT GROUNDED: MID CABIN EMERGENCY PATHWAY LIGHTING IS INOPERABLE. REPLACED BATTERY PACK PER AMM 33-51-06. MAINTENANCE PERFORMED SUCCESSFUL OPERATIONS CHECK.SDR AALA201712019034Battery · dischargedAIRCRAFT WAS NOT GROUNDED: MID CABIN EMERGENCY PATHWAY LIGHTING WAS INOPERABLE. REPLACED BATTERY PACK PER AMM 33-51-06. MAINTENANCE PERFORMED SUCCESSFUL OPERATIONS CHECK.SDR SWAA2017120418229Cover · missingLT OVERWING DOOR LOWER EXIT SIGN COVER MISSING DIRECTIONAL ARROWS. R&R COVER PER AMM.SDR SWAA2017120418228Battery Pack · failedEMERGENCY BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01669. R&R BATTERY PACK PER AMM.SDR SWAA2017120418218Light · inoperativeLT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW MM.SDR SWAA2017120418202Cover · brokenAFT EMERGENCY EXIT LIGHT COVER SWITCH SPRING BROKEN. R&R COVER REF SIP.SDR SWAA2017120418201Cover · missingL1 DOOR LOWER EXIT SIGN COVER MISSING DIRECTIONAL ARROWS. R&R COVER PER AMM.SDR SWAA2017120418196Battery Pack · failedEMERGENCY BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01668. R&R BATTERY PACK PER AMM.SDR ASOA201711294062Light · inoperativeIAH - FIGHT 4193, DURING MAINTENANCE INSPECTION THE L/H WING FRONT FUSELAGE FAIRING FORWARD EMERGENCY EXTERNAL LIGHT FAILED TO ILLUMINATE. MAINTENANCE REMOVED THE AFFECTED LIGHT ASSEMBLY, OPERATIONALLY TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR RSDR SWAA2017120418171Lens · crackedLT OVERHEAD BIN EMERGENCY LIGHT CRACKED BETWEEN ROW 23 TO ROW 27. R&R LENS PER AMM.SDR SWAA2017120418163Lens · crackedRT OVERHEAD BIN EMERGENCY LIGHT CRACKED BETWEEN ROW 18 TO ROW 25. R&R LENS PER AMM.SDR SWAA2017120418162Lens · unsecureLT OVERWING EMERGENCY EXIT LIGHT LENS FELL OFF. SECURED LENS PER MM & SIP.SDR SWAA2017120418161Lens · missingLT OVERHEAD BIN EMERGENCY LIGHT LENS MISSING AT ROW 5. INSTALLED LENS PER AMM.SDR AALA201712019035Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT IDENTIFIER AT THE FORWARD SERVICE AREA HAS A BROKEN LENS COVER. REMOVED AND REPLACED IDENTIFIER ASSEMBLY L1186 PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20171129003Battery · no testAIRCRAFT WAS NOT GROUNDED. FORWARD OVERHEAD EMERGENCY EXIT LIGHTS ARE INOPERATIVE. REMOVED AND REPLACED BATTERY ASSSEMBLY B5-23 PER AMM 33-53-00. OPERATIONAL CHECK GOOD.SDR AALA201712019026Battery · dischargedAIRCRAFT WAS GROUNDED: APU AUTO SHUTDOWN AND EMERGENCY EXIT LIGHTS WERE ON, VERY DIM, FOR UNKNOWN DURATION WHEN FOUND. MAINTENANCE PERFORMED SUCCESSFUL BATTERY CAPACITY TEST PER AMM TASK 33-51-00-710-003-A AND EMERGENCY LIGHTS OPERATIONAL TEST.SDR SWAA2017120118126Lens · crackedAFT LT OVERHEAD BIN EMERGENCY LIGHT LENS CRACKED. R&R LENS PER AMM.SDR SWAA2017120118125Lens · crackedRT EMERGENCY EXIT BULLNOSE LIGHT LENS CRACKED BETWEEN ROW 21 TO ROW 25. R&R LENS IAW AMM.SDR AALA201711309009Lens · missingEMERGENCY EXIT LIGHT BY THE L2 DOOR HAS A MISSING LENS. REPLACED THE LENS. OPS CHECKED GOOD.SDR DALA2017113008383Battery Pack · inoperativeLEFT AND RIGHT AFT OVERWING EXIT DOOR EMERGENCY LIGHTS INOPERATIVE. CONFIRMED A BAD BATTERY PACK. REPLACED IAW AMM 33-53. CHECKED GOOD.SDR MASA2017112912802Light · inoperativePAX DOOR EMERGENCY EXIT SIGN ONE BULB INOP. PLACED ON MEL.SDR MASA2017112912801Sign · inoperativeROW 18 FWD FACING EMERG EXIT SIGN INOP. PLACED ON MEL.SDR MASA2017112912800Light · inoperativeROW 8 & 11 EMERG OVERHEAD FLOOD LIGHT INOP. PLACED ON MEL.SDR QXEA2017112900685Battery · dischargedDURING OPERATIONAL TEST OF EMERGENCY LIGHTS, FIRST SET OF LIGHTS WERE INTERMITTENT. REMOVED AND REPLACED SWITCH ON WING BULKHEAD IAW AMM 33-51-05-000-801 AND 33-51-05-400-801. NO HELP. REMOVED AND REPLACED CHARGER IAW AMM 33-51-01-000-801 AND 33-51-01-400-801.SDR DALA2017120608452Charger · inoperativeSEAT MOUNTED EMERGENCY LIGHTS INOP ON ROWS 38-42. REMOVED AND REPLACED BATTERY PACK, NO HELP. REMOVED POWER PACK PER AMM 33-51. REMOVED AND REPLACED BATTERY CHARGING ASSY PER AMM 33-51, OP CK GOOD.SDR DALA2017120408419Power Supply · no testAFT LH EPSU FAILED EMERGENCY LIGHT TEST ON SERVICE CHECK, REPLACED AFT LH EPSU WITH BATTERYSDR SWAA2017120118165Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAIL CAPACITY TEST AT LOCATION M01669. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2017120118151Battery Pack · failedEMERGENCY LIGHT BATTERY PACKS FAIL CAPACITY TEST AT LOCATION M01668. R&R BATTERY PACK PER AMM AND DWG.SDR SWAA2017120118147Cover · brokenFORWARD ENTRY DOOR EMERGENCY EXIT LIGHT COVER BROKEN. R&R LIGHT ASSEMBLY IAW WDM.SDR SWAA2017120118141Battery Pack · dischargedLT OVERWING EMERGENCY LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SIMA20171128004Bulb · inoperativeLH EMERGANCY EXIT EMERGANCY LIGHT AND LAST CEILING PANEL EMERGANCY LIGHT INOP-C/A-REPLACED CEILING PANEL LIGHT BULB IAW AMM 33-50-08 AND RESET CANNON PLUG ON #4 INVERTER IAW AMM 33-50-11. PERFORMED OPERATIONAL CHECK OF THE EMERGANCY LIGHTING SYSTEM IAW AMM 33-SDR AALA201711309020Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN AT THE RIGHT AFT GALLEY HAS A MISSING LENS COVER. INSTALLED LENS COVER PER AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA201711309018Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN ABOVE THE R2 DOOR HAS A MISSING LENS COVER. INSTALLED LENS COVER PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR A6WA2017113045450Battery Pack · inoperativeFLOOR LEVEL EMERGENCY FLOOD LIGHT AT PAX DOOR ENTRY INOPERATIVE. ON FURTHER TROUBLESHOOTING, FOUND CEILING EMERGENCY EXIT SIGN FWD SIDE AT ROW 8 AND EMERGENCY EXIT EXTERIOR LIGHTS JUST FWD OF THE LEFT AND RIGHT OVERWING EXIT LIGHTS ALSO INOPERATIVE. REMOVED SDR AALA201711299044Housing · tornSEAT 9-D EMERGENCY LIGHT HOUSING TORN. REPLACED EMERGENCY LIGHT HOUSING.SDR AALA201711299038Lens · damagedF/A REPORTED THAT THE AISLE EMERGENCY LIGHT LENS WAS DAMAGED ON SEAT 4C. REMOVED AND REPLACED EMERGENCY LIGHT LENS. OPS CHECKED GOOD IAW AMM 35-51-18.SDR SIMA20171128002Charger · failedSERVICE DOOR EMERGENCY LT INOP. R&R SERVICE DOOR EMERGENCY LIGHT LAMP IAW AMM 33-50-10-000-801-A & 33-50-10-400-801-A OPS CHECK FAILED, REMOVED AND REPAIRED NR 2 EMERGENCY BATTERY CHARGER ASSEMBLY AND EMERGENCY BATTERY IAW W/C 33-700-19 OPS CHECK FAILED, TROUBSDR 7C7A2017112800348Battery Pack · dischargedEMERGENCY EXIT SIGN LIGHT INOPERATIVE AT ROW 3 RIGHT. THE BATTERY PACK WAS FOUND DISCHARGED.SDR DALA2017112808381Power Supply · inoperativeSEATS 1 - 11 EMERGENCY LIGHTS INOPERATIVE. R & R THE POWER SUPPLY AND BATTERY IAW AMM 33-20, CHECKED GOOD. OK FOR SERVICE.SDR FDEA201711283315Battery Pack · dischargedEMER LT BAT 1 LO ALERT DISPLAYED DURING EMERGENCY LIGHTS TEST. CHARGED THE BATTIES, PERFORMED AN EMERGENCY LIGHT TEST IAW MM 33-51-01-5, OPS NORMAL, NO FAULTS FOUND.SDR QXEA2017112800684Lamp · inoperativeEMERGENCY LIGHT PANEL LIGHTS INOPERATIVE. REMOVED FROM SERVICE. REPLACED THE LAMPS IN THE PANEL. BACKLIGHTING NOW ILLUMINATES NORMALLY. AIRCRAFT RETURNED TO SERVICE.SDR MASA2017112812798Lamp · inoperativeROW 18 OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE LAMP.SDR SIMA20171128001Panel · inoperativeEMERGENCY LIGHT NOT ARMED, INTERMITTENT ON & OFF AFTER ENGINE START AND INFLIGHT. R & R THE EMERGENCY LIGHT SWITCH PANEL IAW AMM 33-12-01. OPS CHECKED GOOD IAW AMM 33-50-00.SDR AALA2018071829031Battery Pack · inoperativeEMERGENCY EXIT LIGHTS WERE INOPERATIVE. AIRCRAFT WAS GROUNDED. REMOVED AND REPLACED THE BATTERY ASSEMBLY AND FORWARD BATTERY PACK IAW AMM 33-53-00. OPS CHECKED GOOD.SDR SWAA2017120118170Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01673. R&R BATTERY PACK PER MM.SDR SWAA2017120118169Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01672. R&R BATTERY PACK PER MM.SDR SWAA2017120118168Battery Pack · failedEMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK AT LOCATION M01675. R&R BATTERY PACK PER MM.
Back to JASC 3350