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 SWAA2017072415182Lens · looseFORWARD ENTRY LOWER EMERGENCY EXIT LIGHT LENS LOOSE. SECURED THE LENS IAW EA.SDR SWAA2017072415166Cover · missingROW 21 CEILING EMERGENCY EGRESS LIGHT LENS COVER MISSING. INSTALLED COVER IAW SIP.SDR DALA2017071905635Lens · missingEXIT SIGN COVER MISSING NEAR L2 DOOR. INSTALLED CENTER AISLE CEILING EXIT SIGN COVER. CHECKED GOOD IAW AMM 33-51.SDR AALA201707249002Light · brokenL1 DOOR EMERGENCY LIGHT BROKEN. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707209036Sign · missingTHE AIRCRAFT WAS NOT GROUNDED. DURING CABIN CHECK FOUND R1 DOOR EXIT SIGN MISSING NEXT TO TRASH COMPARTMENT. REMOVED & REPLACED EXIT SIGN ASSY AT R1 DOOR IAW 33-51-01 AMM. CKD OK.SDR AALA201707209035Light · brokenTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT ILLUMINATION LIGHT COVER INSIDE FWD ENTRY DOOR FOUND ON FLOOR WITH GLASS BROKEN. REMOVED AND REPLACED LIGHT ASS PER AMM 33-51-00 OPS CKD GOOD.SDR AALA201707209034Cover · unsecureAIRCRAFT WAS NOT GROUNDED. RIGHT AFT ENTRY DOOR EXIT SIGN COVER FELL OFF IN FLIGHT. CHANGED EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-01.SDR AALA201707209033Cover · unsecureAIRCRAFT WAS NOT GROUNDED. AFT ENTRY DOOR LEFT EXIT SIGN COVER FELL OFF IN FLIGHT. CHANGED EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-01.SDR AALA201707209032Shroud · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT FIRST CLASS GALLEY WALL AT FLOOR LEVEL, BRACKET BROKEN. LIGHT WORKS, BUT MOUNT BROKEN AT MOUNT SCREWS. REPLACED EMERGENCY EXIT LIGHT (FLOOR PROXIMITY SHROUD) PER AMM 33-51-14.SDR AALA201707219030Module · not seatedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 20D IS INOPERATIVE. RESEATED LIGHT MODULE PER AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR DALA2017072005601Power Supply · damagedBATTERY MOUNT BAD ON CENTER LIGHT EMERGENCY BATTERY POWER SUPPLY, REPLACED THE POWER SUPPLY UNIT.SDR AALA201707219012Lens · crackedA CRACKED EMERGENCY LIGHT LENS, BOTTOM LEFT AT LAVATORY D. REPLACED SIDEWALL EMERGENCY LIGHT IAW AMM 33-51-18.SDR AALA201707209039Panel · unsecureEMERGENCY EXIT PANEL OVER RT DOOR DETACHED. SECURED THE PANEL.SDR AALA201707209029Light · unsecureEMERGENCY EXIT LIGHT STRIP AT ROW 17 IS UNSECURE. SECURED THE LIGHT. OPERATIONAL CHECKED GOOD.SDR R61A201707190539Battery · inoperativeOVERHEAD COCKPIT EMERGENCY LIGHT INOPERATIVE. R & R THE BATTERY IAW AMM 33-50-01-4. OPS CHECKED GOOD.SDR DALA2017072005590Sign · inoperativeEMERGENCY EXIT SIGNS INOPERATIVE. SECURED EMER EXIT SIGN. OPN CKS NORM.SDR DALA2017072005589Battery · dischargedEMER LIGHTS (CELING) ROWS 11-14 INOP. FOUND BATTERIES IN B5-101 DEAD. R&R SAME PER AMM 33-53. OPS CK SAT.SDR AALA201707209020Battery · no testEMERGENCY POWER SUPPLY UNIT BATTERY FAULT INDICATED AT 10WL. REPLACED BATTERY IAW AMM 33-51-00.SDR AALA201707209006Lens · looseROW 17H EXIT SIGN LENS IS LOOSE. MAINTENANCE SECURED THE EXIT SIGN LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707209005Lens · missingR4 DOOR AFT EXIT SIGN MISSING THE LENS. REPLACED THE LENS IAW MM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR JJBA201707190222Sign · inoperativeAISLE EMERGENCY LIGHT DID NOT ILLUMINATE. ON BACK SIDE. R & R THE SIGN ASSY OPS CHECKED SAT.SDR SWAA2017072515187Lens · crackedR1 DOOR LOWER EMERGENCY LIGHT LENS CRACKED. R & R THE LENS IAW AMM.SDR AALA20170724004Lens · damagedEMERGENCY EXIT SIGN AT THE R1 DOOR HAS A DAMAGED LENS. REMOVED AND REPLACED THE LENS IAW AMM 33-51-01. OPS CHECKED GOOD.SDR SWAA2017072415214Cover · detachedL1 DOOR EMERGENCY EXIT LIGHT COVER FELL OFF. REINSTALLED THE COVER IAW SIP.SDR DALA2017071905642Sign · detachedROW 38 OVERHEAD EXIT SIGN DETACHED. INSTALLED THE SIGN.SDR AALA201707249016Light · brokenBROKEN R4 DOOR EMERGENCY EXIT LIGHT ASSEMBLY. REPLACED LIGHT ASSEMBLY PER MM 33-51-13. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201707209022Sign · detachedR1 DOOR EMERGENCY EXIT SIGN LOWER FASTENER LIBERATED FROM SIGN. REPLACED EXIT SIGN IAW AMM 33-51-13.SDR REXA2017071800799Light · malfunctionedEMERGENCY LIGHTS CAME ON BRIEFLY, THEN TURNED OFF. PERFORMED OPS TEST OF THE EMERGENCY LIGHTS OPS TESTED GOOD.SDR REXA2017071800798Light · inoperativeFLOOR EMERGENCY LIGHT STRIP IN THE MIDDLE SECTION INOPERATIVE. R & R THE EMERGENCY LIGHT STRIP IAW AMM 33-51-01, OPS CHECKED GOOD.SDR DALA2017071905575Lens · missingEMERGENCY FLOOR LIGHTING MISSING AT POSITION 4053. RE-INSTALLED LENS.SDR DALA2017071905574Lens · missingEMERGENCY FLOOR LIGHTING LENS MISSING AT POSITION 406. INSTALLED LENS.SDR DALA2017071905572Power Supply · faultyDURING WORKING WORKCARD 0591-0115 FOUND ESPU 18WL FAULTING. REPLACED EMERGENCY POWER SUPPLY UNIT 18WL.SDR AALA201707209031Light · detachedFWD GALLEY DOOR LOWER EXIT SIGN KNOCKED OFF. REPLACED FWD GALLEY DOOR EMERGENCY EXIT LIGHT ASSY IAW MM 33-51-00, OP CHECKED OK.SDR AALA201707199011Lens · missingEXIT LENS MISSING IN AFTER GALLEY. REPLACED THE LENS. OPS CHECKED NORMAL IAW AMM 33-51-00.SDR AALA201707199009Sign · damagedL2 DOOR EMERGENCY EXIT SIGN DAMAGED. REPLACED THE SIGN ASSY IAW AMM 33-51-01, OPS CHECKED GOOD.SDR AALA201707199008Lens · missingEMERGENCY EXIT LIGHT LENS MISSING IN FIRST CLASS GALLEY NEXT TO FWD SERVICE DOOR. REPLACED THE LENS IAW AMM 35-51-01.SDR GTIA2017071802086Light · inoperativeOVERHEAD EMERGENCY LIGHT AT FIN 207WL WILL NOT ILLUMINATE. PSEU OPS TESTED NORMAL. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSMBLY IAW AMM 33-51-11. OPS CHECKED GOOD.SDR AALA201707199016Lens · missingL2 DOOR EMERGENCY EXIT LIGHT LENS MISSING. REPLACED THE LENS.SDR SIMA20170718002Light · inoperativeMAIN DOOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED MAIN DOOR EMERGENCY LIGHT ASSY IAW AMM 25-23-04. OPS CHECK GOOD.SDR DALA2017071905542Power Supply · inoperativeEXTERNAL EMERGENCY LIGHT AT LT BODY INOP. REPLACED POWER SUPPLY M7919 IAW AMM 33-51 & OK.SDR SWAA2017071915163Lens · crackedAFT GALLEY RT SIDE EMERGENCY LIGHT LENS CRACKED. R&R LENS PER AMM.SDR SWAA2017071915162Light · inoperativeMID CABIN OVERHEAD EMERGENCY EXIT LIGHT INOP. R&R LIGHT HOUSING PER MM.SDR AALA20170719003Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT SYSTEM TEST FAILS BATTERY PACKS AT 10WL. REPLACED BATTERY PACK 10WL PER AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR 29GA2017071900001Light · brokenEMERGENCY LIGHT ASSY BROKEN AT SEAT 3A. REPLACED THE EMERGENCY DOME LIGHT. OPS CHECKED GOOD IAW AMM 33-50-55-04.SDR MASA2017071812471Charger · inoperativeFWD BULKHEAD FWD FACING SIGN INOP. REPLACED NR 1 BATT CHARGER.SDR AALA201707209012Lens · brokenEMERGENCY LIGHT AT THE G5 GALLEY RIGHT SIDE HAS A BROKEN LENS COVER. REMOVED AND REPLACED THE LENS IAW ESO 41073 AND CMM 25-37-59. OPS CHECKED GOOD.SDR SWAA2017072515228Lamp · inoperativeLEFT OVERWING FORWARD EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR REXA2017071700794Light · inoperativeFLOOR LEVEL EXIT LIGHT NEXT TO LEFT EMERGENCY EXIT DOOR INOP. REMOVED AND REPLACED EXIT LIGHT IAW AMM 33-51-10.SDR AALA201707189010Lamp · inoperativeL1 DOOR WINDSCREEN FLOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP.SDR AALA201707189009Light · inoperativeAFT GALLEY EMERGENCY LIGHT INOPERATIVE. REPLACED THE AFT GALLEY EMERGENCY LIGHT.
Back to JASC 3350