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 SWAA2018031920506Lens · looseL1 DOOR EMERGENCY EXIT LENS LOOSE. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2018031920503Light · inoperativeOVERWING EMERGENCY EXIT LIGHT ON SIDEWALL INOPERATIVE. R & R THE LIGHT ASSEMBLY IAW AMM.SDR SWAA2018031920496Sign · brokenOVERWING ROW EMERGENCY EXIT SIGN BROKEN. R & R THE SIGN IAW SIP.SDR YENA201803170135Battery Pack · failedDURING HEAVY MAINTENANCE, EPSU 13WL BATTERY FAILED. R & R THE BATTERY, AND PERFORMED AN OPS CHECK IAW 33-51-38. OPS CHECKED IAW 33-51-00-710-004-A.SDR REXA2018031700200Lamp · inoperativeRT OVERWING EMERGENCY LIGHT NOT WORKING. REPLACED THE LAMPS AMM 33-51-21 OPS CHECKED GOOD. CLEANED THE CONTACTS IAW ESPM 20-17-10.SDR QXEA2018031900098Light · detachedEMERGENCY LIGHT STRIP BECAME DETACHED DURING DEPLANING. REMOVED FROM SERVICE. REINSTALLED THE EMERGENCY LIGHT. NO FURTHER DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE.SDR AALA201803209002Cover · detachedEMERGENCY EXIT SIGN COVER DETACHED FROM THE AFT GALLEY WALL. REPLACED THE AFT EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-01.SDR AALA201803209017Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. REPEAT ITEM AFT RIGHT EMERGENCY EXIT LENS NEXT TO FLIGHT ATTENDANT JUMP SEAT MISSING. ASSEMBLY CLIPS BROKEN. REMOVED AND REPLACED AFT RIGHT EMERGENCY LIGHT ASSEMBLY AND LENS COVER PER AMM 33-51-00. OPERATIONS CHECK NORMAL.SDR SWAA2018032020562Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PER AMM.SDR SWAA2018032020561Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR SWAA2018032020560Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PER AMM.SDR SWAA2018032020554Light · inoperativeRT WING EMERGENCY OVERWING EXIT LIGHT INOP. RELAMPED LIGHT IAW MM.SDR SWAA2018032020551Light · inoperativeLT OVERWING EMERGENCY EXIT SIDEWALL LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018032020530Lens · missingMID CABIN EMERGENCY EXIT SIGN LIGHT HALF OF LENS MISSING. R&R LENS PER MM.SDR SWAA2018032020527Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1672. R&R BATTERY PER AMM.SDR SWAA2018032020521Battery Pack · dischargedLT OVERWING EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR DALA2018031901817Unknown · malfunctionedAFTER LANDING ON TAXI IN F/A'S REPORTED THAT THE EMERGENCY LIGHTS ON THE CAPT'S SIDE ONLY IN THE CABIN WOULD COME ON STEADY PERIODICALLY FOR SAY 1 MINUTE THEN GO OFF FOR HALF A MINUTE THEN CYCLE ON AGAIN. NO LIGHTS CYCLED ON THE F/O SIDE. THE EMERGENCY EXIT LSDR SIMA20180316001Inverter · inoperativeEMERGENCY LIGHT EXIT LOCATOR OVERWING FWD CEILING, INOPERATIVE IAW A PS-1 CHECK. FOUND EMERGENCY LIGHT DC/AC INVERTER NR 6 SUSPECTED TO BE BAD. R & R THE INVERTER IAW AMM 33-50-11. OPS CHECKED GOOD.SDR AALA201803199030Power Supply · no testAFT CABIN EMERGENCY POWER SUPPLY FAULTED DURING CIDS TEST. REPLACED AFT CABIN EMERGENCY POWER SUPPLY IAW AMM 33-51-38.SDR AALA201803199014Cover · damagedTHE AIRCRAFT WAS NOT GROUNDED. DOOR 4L EMERGENCY EXIT LIGHT COVER DAMAGED. REPLACED 4L EMERGENCY EXIT LIGHT COVER. OPERATIONS CHECKS NORMAL.SDR AALA201803199013Cover · brokenTHE AIRCRAFT WAS NOT GROUNDED. EXIT LIGHT LENS COVER IS BROKEN AT R-4. REMOVED AND REPLACED EXIT LIGHT LENS COVER PER AMM 33-51-13.SDR SWAA2018031920504Lens · missingL1 DOOR EMERGENCY EXIT LENS MISSING. INSTALLED A LENS IAW SIP.SDR SWAA2018031920495Cover · detachedMID CABIN EMERGENCY EXIT SIGN COVER DETACHED. SECURED THE COVER IAW SIP.SDR ASAA2018031623942Lens · detachedEMERGENCY LIGHT COVER NEXT TO SEAT 16 RT FELL OFF. GROUNDED - YES. REINSTALLED EMERGENCY LIGHT COVER NEXT TO SEAT 16 RT AS REQUIRED.SDR QXEA2018031900103Light · damagedWHILE PERFORMING ARRIVAL CHECK, FOUND THE EMERGENCY LIGHT STRIP IN FRONT OF PAX SEAT 2DE TO BE DAMAGED. REMOVED EMERGENCY LIGHT IAW AMM 33-61-16-000-801. INSTALLED A NEW EMERGENCY LIGHT IAW AMM TASK 33-51-16-400-801.SDR DALA2018031901794Lamp · inoperativeEMERGENCY LIGHTS AT SEAT 25AB ARE INOPERATIVE. SECURED AND REPLACED THE LAMPS.SDR DALA2018031901778Power Supply · inoperativeL2 DOOR SMALL EMERGENCY EXIT SIGN INOPERATIVE. REPLACED THE POWER SUPPLY & BATTERY.SDR CALA2018031900948Battery Pack · no testDURING AN EMERGENCY LIGHT CAPACITY TEST, FOUND THE R4 DOOR M33408 BATTERY PACK WITH LOW CAPACITY. THE BATTERY PACK WAS REPLACED, TESTED NORMAL IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018031900947Battery Pack · no testDURING AN EMERGENCY LIGHT CAPACITY TEST, FOUND THE M33405 BATTERY WITH LOW CAPACITY. THE BATTERY PACK WAS REPLACED AND TESTED, FOUND NORMAL IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018031900946Battery Pack · no testDURING AN EMERGENCY LIGHT CAPACITY TEST, FOUND THE L3 DOOR M33405 BATTERY WITH LOW CAPACITY. THE BATTERY PACK WAS REPLACED, TESTED AND FOUND NORMAL IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018031900945Battery Pack · no testDURING AN EMERGENCY LIGHT CAPACITY TEST, FOUND THE L3 DOOR M33405 BATTERY HAD LOW CAPACITY. THE BATTERY PACK WAS REPLACED, TESTED AND FOUND NORMAL IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018031900944Battery Pack · no testDURING AN EMERGENCY LIGHT CAPACITY TEST, FOUND THE L2 DOOR BATTERY WITH LOW CAPACITY. THE BATTERY PACK WAS REPLACED, A TEST WAS CARRIED OUT AND FOUND NORMAL IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018031900943Battery Pack · no testDURING AN EMERGENCY LIGHT CAPACITY TEST, FOUND THE L1 DOOR BATTERY PACK HAD LOW CAPACITY. THE BATTERY PACK WAS REPLACED, TESTED AND FOUND NORMAL IAW AMM 33-51-01-960-802, REV 82.SDR CALA2018031900942Battery Pack · dischargedDURING AN EMERGENCY LIGHT CAPACITY TEST, FOUND THE EMERGENCY LIGHT FOR ZONE A, RUN TIME & LIGHT 15 MINUTES. EMERGENCY BATTERY PACK WAS REPLACED, A NEW BATTERY PACK TESTED AND FOUND NORMAL IAW AMM 33-51-06-960-802, REV 82.SDR CALA2018031900941Sign · brokenFOUND LATCHES OF EXIT LIGHT BROKEN AT THE UPPER R2 DOOR. REPLACED THE EXIT SIGN, TESTED NORMAL IAW AMM 33-51-01-960-802, REV 82.SDR IPXA2018031727533Bulb · inoperativeEMERGENCY LIGHT BULBS INOPERATIVE REPLACED THE BULBS AMM 33-51-01-2.SDR 29GA2018031900001Lamp · burned outWHEN ARMING THE EMERGENCY LIGHT SWITCH, THE PANEL CONSOLE ON THE FLIGHT ATTENDANT SIDE DOES NOT ILLUMINATE. REPLACED THE LAMP IN THE EMERGENCY LIGHT SWITCH AT FA PANEL IAW AMM 33-12-00.SDR QXEA2018031600092Lamp · inoperativeFA EMERGENCY LIGHT SWITCH INOPERATIVE. REPLACED THE LAMPS, OP CHECKED GOOD. RETURNED TO SERVICE.SDR DALA2018031601729Battery Pack · inoperativeDURING AN A CHECK, FOUND THE EXIT SIGN B5-231 BATTERY INOPERATIVE. REPLACED THE BATTERY AND CHECKED GOOD.SDR REXA2018031500208Sign · damagedEXIT SIGN ABOVE RT SERVICE DOOR DAMAGED, REPLACED THE SIGN IAW AMM 33-51-05-400-801.SDR IPXA2018031927614Bulb · inoperativeEMERGENCY LIGHT HAS SIX INOPERATIVE BULBS. REPLACED THE BULBS IAW AMM 33-51-01-2.SDR SWAA2018032020550Light · inoperativeEMERGENCY EXIT LIGHT INOP AT ROW 17. R&R BULB IAW AMM.SDR SIMA20180315001Battery Pack · inoperativeNUMEROUS FORWARD EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY AND CHARGER IAW AMM 33-50-04. OPS CHECKED GOOD.SDR SWAA2018031920494Light · inoperativeRIGHT EMERGENCY LIGHT STRIPS WERE INOPERATIVE. R & R THE LIGHT STRIP IAW MM.SDR SWAA2018031920471Cover · brokenR2 DOOR EMERGENCY EXIT SIGN COVER BROKEN. R & R THE COVER IAW AMM.SDR ASAA2018031523937Lens · detachedFLIGHT ATTENDANT REPORTED THE AFT FACING EMERGENCY EXIT COVER HAS FALLEN OFF. ACFT GROUNDED. INSTALLED THE LIGHT COVER.SDR YENA201803150134Lamp · inoperativeDURING HEAVY MAINTENANCE, RT OVERWING FORWARD EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED GOOD IAW AMM 33-51-15.SDR DALA2018031501737Charger · inoperativeFOUND THE EMERGENCY EXIT SIGN ABOVE THE L1 FLIGHT ATTENDANT SEAT INOPERATIVE. TROUBLESHOT IAW ASM 33-51-0. REPLACED THE CHARGER AND BATTERY PACK IAW AMM 33-51. OPS CHECKED GOOD.SDR YENA201803150132Battery Pack · no testEPSU BATTERY 11WL FAILED AN EMERGENCY LIGHT SYSTEM TEST. R & R THE BATTERY IAW AMM 33-51-38. CHECKED OK.SDR AALA201803169013Lens · missingAFT RIGHT EMERGENCY EXIT SIGN IS MISSING THE LENS. REPLACED LIGHT LENS IAW AMM 33-00-00.
Back to JASC 3350