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 AALA2018071219003Lens · detachedEMERGENCY LIGHT LENS DETACHED. REPLACED THE LENS.SDR SWAA2018071123385Sign · missingL1 DOOR EXIT SIGN MISSING RED ARROW. R&R SIGN PER CMM.SDR SWAA2018071123380Light · brokenLT EMERGENCY EXIT LIGHT BROKEN. R&R LIGHT ASSEMBLY PER MM.SDR AALA2018071219007Cover · missingROW 1C EMERGENCY LIGHT COVER MISSING. REPLACED THE COVER IAW AMM 33-51-18.SDR ASOA201807105162Light · malfunctionedPILOT REPORTED THE EMERGENCY LIGHT INSIDE EXIT ROW WAS NOT ILLUMINATING. MX PREFORMED A SYSTEM RESET AND PERFORMED OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR REXA2018071000616Charger · inoperativeREAR FACING EMERGENCY EXIT SIGN UNDER OVERHEAD BIN 4C/D INOP. REMOVED AND REPLACED NR 1 E-LIGHT CHARGER IAW AMM 33-51-17. OPS CHECK GOOD.SDR MYWA2018071100095Battery Pack · dischargedFORWARD RIGHT HAND PASSENGER CABIN EMERGENCY LIGHTS INOPERATIVE. THE BATTERY PACK WAS REPLACED.SDR MASA2018071013399Light · inoperativeROW 6 EMERGENCY FLOOD LIGHT INOP. REPLACED BULB.SDR MASA2018071013397Light · inoperativeROW 15 CEILING EMER FLOOD LIGHT INOP. RELAMPED.SDR DALA2018071004436Light · inoperativeENTRY LIGHT FWD INOP. F/A REPORT ENTRY L1 DOOR LT BULB INOP. RE-LAMPED ENTRY WAY BULB AT L1 DOOR. OPS GOOD OK FOR SVC.SDR SWAA2018071723589Battery · dischargedEMERGENCY EXIT LIGHT BATTERY PACK M1674 INOP. R&R BATTERY PER MM.SDR SWAA2018071723509Battery · dischargedEMERGENCY EXIT LIGHT BATTERY PACK M1675 INOP. R&R BATTERY PER MM.SDR DALA2018071304479Charger · inoperativeEMERGENCY LIGHTS FOR FORWARD MID SECTION FOUND U/S DURING SERVICE CHK. REMOVED AND REPLACED CHARGER AND BATT FOR M11486 IAW AMM 33-51.SDR DALA2018071104477Lens · missingEMERGENCY EXIT SIGN AT 2 LEFT DOOR DIFUSER LENS MISSING. REPLACED DOOR EXIT LIGHT LENS OPS CHECKS GOOD.SDR AALA2018071329020Power Supply · inoperativeOVERHEAD EMERGENCY LIGHTS INOPERATIVE FROM ROWS 31H TO 40H. THE AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE POWER SUPPLY IAW 33-51-06, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR HALA2018071000205Sign · unsecureEXIT SIGNS AT DOOR 2L CAME OFF. INSTALLED EXIT SIGN AT DOOR 2L.SDR SWAA2018071223465Battery Pack · dischargedEMERGENCY EXIT LIGHT BATTERY PACK INOP AT LOCATION M1674. R&R BATTERY PACK PER AMM.SDR SWAA2018071223460Battery Pack · dischargedEMERGENCY EXIT LIGHT BATTERY PACK INOP AT LOCATION M1675. R&R BATTERY PACK PER AMM.SDR DALA2018071204455Switch · brokenEMERGENCY LIGHTS SWITCH IS BROKEN. REPLACED EMERGENCY LIGHT SWITCH GUARD. SYSTEM OPERATION IS NORMAL.SDR SWAA2018071123422Lens · looseFORWARD EMERGENCY EGRESS FLOOR WHITE LIGHT COVER LOOSE. SECURED LENS IAW AMM.SDR SWAA2018071123400Lens · brokenG4 GALLEY EMERGENCY EXIT LIGHT LENS BROKEN. R&R LENS PER AMM.SDR SWAA2018071123387Lens · fadedLT EMERGENCY DOOR OVERHEAD LIGHT LENS FADED. R&R COVER PER AMM.SDR SWAA2018071123386Lens · fadedRT EMERGENCY DOOR OVERHEAD LIGHT LENS FADED. R&R LENS PER AMM.SDR SWAA2018071123378Sign · looseRT EMERGENCY EXIT SIGN AT EXIT ROW LOOSE. R&R SIGN IAW AMM.SDR ASOA201807095161Inverter · inoperativeDURING MX INSPECTION THE LOWER EMERGENCY LIGHT ON THE SERVICE DOOR WAS INOP. MX REMOVED AND REPLACED THE NR 2 INVERTER WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2018071104445Light · damaged11D FLOOR PROX EMERGENCY PATH LIGHT DAMAGED. LIGHT STILL WORKS. REPLACED EMERGENCY LIGHT ASSY AT 11D. EMERGENCY LIGHT 11D OPS NORMAL PER AMM 33-51.SDR AALA201807109036Housing · brokenAIRCRAFT WAS NOT GROUNDED. SEAT 13ABC, 18ABC, 20ABC EMERGENCY LIGHT HOUSING BROKEN. REPLACED SEAT 13ABC, 18ABC, 20ABC EMERGENCY LIGHT HOUSING PER CMM 25-22-52 OPERATIONS CHECK SATISFACTORY. THIS SDR IS FOR SEAT 20ABC. (SEE CONTROL AALA201807109032 AND AALA2018SDR AALA201807109035Housing · brokenAIRCRAFT WAS NOT GROUNDED. SEAT 13ABC, 18ABC, 20ABC EMERGENCY LIGHT HOUSING BROKEN. REPLACED SEAT 13ABC, 18ABC, 20ABC EMERGENCY LIGHT HOUSING PER CMM 25-22-52 OPERATIONS CHECK SATISFACTORY. THIS SDR IS FOR SEAT 18ABC. (SEE CONTROL AALA201807109032 AND AALA2018SDR AALA201807109032Housing · brokenAIRCRAFT WAS NOT GROUNDED. SEAT 13ABC, 18ABC, 20ABC EMERGENCY LIGHT HOUSING BROKEN. REPLACED SEAT 13ABC, 18ABC, 20ABC EMERGENCY LIGHT HOUSING PER CMM 25-22-52 OPERATIONS CHECK SATISFACTORY. THIS SDR IS FOR SEAT 13ABC. (SEE CONTROL AALA201807109035 AND AALA2018SDR C77A2018071000001Power Unit · inoperativeEMER LT BATT FAULT EICAS MSG, MULTIPLE EMER LTS INOP. REPLACED ELPU NR 1 ON LT FWD POSITION IAW AMM 33-50-01. A/C OK FOR SVC.SDR FDEA201807091657Battery Pack · dischargedDURING PREFLIGHT FOUND LT 1 EMERGENCY EXIT LIGHT BATTERY OFF LOAD. LT 1 EMERGENCY BATTERY PACK REPACED PER AMM 33-51-07-2. TEST SATIS.SDR MASA2018070913393Light · inoperativeROW 6 OVHD EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR MASA2018070913392Light · inoperativeROW 15 CEILING EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR MASA2018070913391Light · inoperativeROW 12 CEILING EMER FLOOD LIGHT INOP. PLACED ON MEL.SDR IPXA2018070931492Light · inoperativeEMERGENCY LIGHT INOP EXIT. FOUND ALL BULBS BURNED OUT. RELAMPED ASSY PER MM 33-51-01-962-0001 OPS CHECKS NORMAL.SDR FDEA201807091647Light · inoperativeON PREFLIGHT CHECK, FOUND EMERGENCY LIGHT DOES NOT ILLUMINATE DURING EMERGENCY LIGHT TEST AND ALSO WHEN S/W SELECTED ON. IDENTIFIED PARTS EMERG EXIT LIGHTS MPN: 60-4411-5 CPN: 3300197. WHILE TROUBLESHOOTING EMER LIGHTS RAN R-T-S ON MSC, ONCE TEST PASSED OPS CHSDR DALA2018072304630Lens · missingABOVE R2 DOOR EMERGENCY EXIT COVER ONE DIFFUSER LENS MISSING. REPLACED EXIT SIGN AND DIFFUSER AT R2 DOOR IAW AMM 33-51-01.SDR SWAA2018071623525Lens · looseAFT OVER WING EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR AALA201807109022Battery · failedAIRCRAFT WAS NOT GROUNDED. WHILE PERFORMING ESPU SYS TEST, ESPU 10WL FWD FAILED. REPLACED EPSU BATTERY 10WL FWD PER AMM 33-51-38.SDR AALA2018071109018Lamp · dimOVERWING EMERGENCY EXIT SIGNS WAS DIM. REPLACED THE LAMP. OPS CHECKED GOOD.SDR AALA201807109001Light · malfunctionedAIRCRAFT WAS NOT GROUNDED. 2R DOOR EMERGENCY LIGHT ILLUMINATED, ALL OTHERS OFF. RESET EMERGENCY LIGHTS. OPERATIONS CHECK NORMAL PER AMM 33-51-00.SDR AALA2018071099054Light · unknownAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT REPORTS RED EXIT LIGHT OVER 1L CLOSET DOOR DOESN'T APPEAR TO BE NORMAL. REPLACED 1L CLOSET RED EXIT LIGHT AS REQUIRED. OPERATIONS CHECK GOOD PER AMM 33-51-18.SDR AALA201807099028Light · unknownROW 24 EMERGENCY LIGHT WAS INOPERATIVE. EXAMINED ROW 24 EMERGENCY LIGHT, NO FAULT FOUND. PERFORMED AN OPS CHECK, TESTED GOOD IAW AMM 33-51-00-710-001A.SDR AALA201807099059Housing · brokenROW 13 SEAT EMERGENCY LIGHT HOUSING BROKEN. REMOVED AND REPLACED THE EMERGENCY LIGHT HOUSING IAW CMM 25-22-52. OPS CHECKED GOOD.SDR AALA201807099038Housing · brokenROW 12 SEAT EMERGENCY LIGHT HOUSING BROKEN. REMOVED AND REPLACED THE EMERGENCY LIGHT HOUSING IAW CMM 25-22-52. OPS CHECKED GOOD.SDR SIMA201808067006Light · inoperativeEMERGENCY LIGHT STRIP NR 8 WAS INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT STRIP IAW AMM 33-50-12.SDR SWAA2018071123434Battery Pack · dischargedL2 DOOR EMERGENCY EXIT SIGN INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018071123376Battery Pack · dischargedL2 DOOR EXTERNAL EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018071123358Sign · inoperativeRT OVERWING EXIT SIGN LIGHT INOP AT ROW 12. RELAMPED SIGN IAW MM.SDR AALA2018071109013Lens · brokenAFT RIGHT EMERGENCY LIGHT LENS BROKEN. REPLACED THE LENS IAW AMM 33-51-00. THE AIRCRAFT WAS GROUNDED.
Back to JASC 3350