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 AALA201705269016Sign · detachedEXIT SIGN OVER RIGHT AFT GALLEY DOOR FELL OFF. REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201705269015Sign · detachedEXIT SIGN OVER SERVICE DOOR FELL OFF. REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR DALA2017052700181Light · missingEMERGENCY LIGHT ON BOTTOM OF SEAT 25 RIGHT MISSING. REPLACED THE EMERGENCY LIGHT.SDR DALA2017052500175Battery Pack · inoperativeEPSU 17WL CLASS 1 FAULT. REPLACED THE EPSU BATTERY.SDR ASAA2017052520874Battery Pack · failedDURING EMERGENCY LIGHT TEST, FOUND L1 DOOR EXTERIOR LIGHT & OVERHEAD SIGN INOPERATIVE. ACFT GROUNDED. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA201705269009Lens · brokenFOUND EMERGENCY EXIT LIGHT LENS AT R4 DOOR BROKEN & LAYING ON GALLEY COUNTER. REPLACED EMERGENCY EXIT LIGHT LENS AT R4 DOOR IAW AMM 33-51-00. OK FOR SERVICE.SDR AALA201705269008Lens · missingL4 DOOR MISSING THE EXIT SIGN LENS. INSTALLED THE LENS.SDR IPXA2017052617553Light · inoperativeL1 ENTRY DOOR EXIT LIGHT INOPERATIVE. REPAIRED CEILING PANEL EMERGENCY EXIT SIGN HOUSING.SDR SIMA20170525001Lamp · inoperativeSERVICE DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. R & R THE LAMP IAW AMM 33-50-10-000-801-A, AND 33-50-10-400-801-A, OPS CHECKED GOOD.SDR MASA2017052512326Light · inoperativeROW 20 OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE.SDR AALA20170525002Lens · looseEXTERIOR EMERGENCY EXIT SLIDE LIGHT BY THE R1 DOOR HAS A LOOSE LENS. SECURED THE LENS IAW AMM 33-51-04. OPS CHECKED GOOD.SDR AALA20170525001Lens · looseEXTERIOR EMERGENCY EXIT SLIDE LIGHT BY THE L1 DOOR HAS A LOOSE LENS. SECURED THE LENS IAW AMM 33-51-04. OPS CHECKED GOOD.SDR SWAA2017053014019Battery · no testCENTER CABIN EMERGENCY LIGHT BATTERY FAILED CAPACITY TEST. R & R THE BATTERY IAW MM.SDR DALA2017052704303Lens · missingRT OVERWING SLIDE ARMED LIGHT LENS MISSING, INSTALLED A NEW LENS.SDR AALA201705259039Light · brokenEMERGENCY EXIT LIGHT ASSEMBLY AT THE R2 DOOR IS BROKEN. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR AALA201705259038Lens · brokenEMERGENCY EXIT LIGHT AT L2 DOOR AFT GALLEY HAS A BROKEN LENS. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR DALA2017052500179Sign · detachedTHE L3 DOOR EXIT SIGN FELL ON LANDING. SECURED THE EXIT SIGN.SDR DALA2017052500177Battery Pack · inoperativeDURING AMS 0591-0115 FLIGHT COMPARTMENT HFA CHECK FOUND DOOR 3L EPSU FAILED. REPLACED 15WL EPSU BATTERY PACK.SDR R61A201705240375Light · malfunctionedEMERGENCY LIGHTS IN FWD GALLEY WILL NOT TURN OFF. PERFORMED ACFT POWER RESET IAW AMM 24-42-02. EMERGENCY LIGHT OPERATE PROPERLY, NO OTHER DEFECTS NOTED AT THIS TIME.SDR HNAA2017052600186Battery · malfunctionedNR 1 AND 2 FLOOR EMERGENCY LIGHTS WILL NOT STAY ON WHEN EMERGENCY LIGHTS TURNED ON. RACKED THE BATTERY AT 1DF. OPS CHECKED GOOD.SDR SWAA2017052614002Light · looseLEFT OVERWING EXIT LIGHT LOOSE. R & R THE LIGHT ASSY IAW MM.SDR SWAA2017052614001Lamp · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR AALA201705259017Light · brokenL4 DOOR LOWER EMERGENCY EXIT LIGHT FIXTURE BROKEN. REPLACED LOWER EMERGENCY LIGHT IAW AMM 33-51-13.SDR DALA2017052404232Battery Pack · inoperativeDURING A SERVICE CHECK, FOUND THE AFT LT BATTERY PACK FOR EMERGENCY LIGHTS INOPERATIVE, REPLACED THE BATTERY PACK.SDR N6WA2017052401Light · inoperativeEMERGENCY LIGHT IS OUT, CEILING LAST ONE IN REAR.SDR AALA201705259012Lens · missingSEAT ROW 4A EMERGENCY EXIT LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201705259011Lens · missingFOWARD GALLEY EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201705259008Battery Pack · inoperativeEMERGENCY POWER SUPPLY TEST FAILED 12WL. REPLACED THE EMERGENCY LIGHT BATTERY PACK IAW 33-51-38.SDR SIMA2017052400001Light · unknownAFT OVERHEAD EMERGENCY EXIT SIGN NOT ILLUMINATING. PERFORMED AN OPS CHECK OF LIGHTS, OPS CHECKED GOODSDR DALA2017052504209Lens · detachedL1 DOOR EXIT SIGN LENS DETACHED. SECURED THE LENS.SDR MASA2017022412325Battery Pack · dischargedALL EMERGENCY LIGHTS INOP, SWITCH LEFT ON. MX REPLACED THE BATTERY PACKS.SDR MASA2017052412324Battery · dischargedROW 13 BOTH BOTTOM EXIT SIGNS INOPERATIVE. MX REPLACED THE EMERGENCY LIGHT BATTERY.SDR DALA2017052404154Cover · looseEMERGENCY EXIT SIGN COVER AT L3 DOOR LOOSE. SECURED EMERGENCY SIGN EXIT COVER.SDR BJNA20170523005Power Supply · inoperativeEMERGENCY EXIT LIGHT POWERED BY BATTERY PACK AT LOCATION 6ABC. FAIL TO ILLUMINATE. THE BATTERY POWER SUPPLY WAS REPLACED IAW 33-51-51.SDR SIMA20170523002Wire · damagedRIGHT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. REPAIRED A WIRE SPLICE SP8930 IAW SWPM 20-21-00. THE EMERGENCY LIGHT OPS CHECKED GOOD IAW AMM 33-50-00.SDR GTIA2017052601935Light · intermittentR2 DOOR EMERGENCY EXIT LIGHT WILL NOT ILLUMINATE. OPERATIONAL TEST OF THE EMERGENCY LIGHT WAS PERFORMED IAW AMM 33-51-00 TEST OK.SDR AALA201705249035Control Unit · faultedACFT HEALTH MONITORING ALERT MESSAGES FOR AN INTERNAL FAULT ON THE L4 DOOR REMOTE WIRELESS EMERGENCY LIGHT SYSTEM CONTROL UNIT. PERFORMED REMOTE SOFTWARE INSTALLATION IAW DMC-B787-A-33-51-07-01A-750A-A. OPERATIONAL CHECKED GOOD.SDR SWAA2017060114091Lamp · inoperativeAFT F/A'S STATION EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR AALA201705259037Battery Pack · no testLEFT AND RIGHT OVERWING FORWARD EMERGENCY EXIT SIGNS ARE INOPERATIVE. REMOVED AND REPLACED THE BATTERY ASSEMBLY B5-203 IAW AMM 33-53-00. OPERATIONAL CHECKED GOOD.SDR AALA201705259018Battery · no testAFT EMERGENCY LIGHT POWER SUPPLY UNIT BATTERY, FAILED TO TEST. REPLACED THE BATTERY IAW 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170524007Battery Pack · no testFORWARD EMERGENCY LIGHTS DIM. REPLACED THE BATTERY PACK IAW MM 33-51-07. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170524006Light · inoperativeR2 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170524005Light · inoperativeL2 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170524003Light · crackedDIM AND CRACKED EMERGENCY LIGHT ASSEMBLY AT SEAT 5A. REPLACED SEAT MOUNTED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-60-98. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK. THE AIRCRAFT WAS GROUNDED.SDR DALA2017052600178Battery Pack · no testNR 2 ASPSU BATTERY FAILED A BIT TEST. REPLACED THE BATTERIES.SDR R61A201705230374Circuit Breaker · trippedAFT GALLEY EMERGENCY LIGHTS CAME ON, AND NOW HAVE EMERGENCY LIGHT MESSAGE. CIRCUIT BREAKER E14 TRIPPED. FLIGHT DECK EMERGENCY LIGHTS CAME ON. RESET CIRCUIT BREAKER, ALL MESSAGES CLEARED. VERIFYING EMERGENCY LIGHTS OPERATIONAL, OPS CHECKED GOOD. COULD NOT DUPSDR REXA2017052300634Light · brokenROW 1 & 2 EMERGENCY LIGHTS HAS A WHITE WIRE SHOWING AND LIGHT STRIP NOT BONDED TO THE FLOOR. FOUND ROW 1 & 2 EMERGENCY FLOOR LIGHT SPLICE BROKEN. INSTALLED A NEW SPLICE IAW ESPM 20-16-00. REINSTALLED THE EMERGENCY LIGHTS IAW AMM 33-51-01. OPS CHECKED GOOD.SDR REXA2017052300632Battery Pack · inoperativeCABIN EMERGENCY LIGHTS COME ON AND DIE OUT WITHIN A FEW SECONDS. R & R THE BATTERY PACK IAW AMM 33-51-17. R & R THE BATTERY CHARGER IAW AMM 33-51-17. PERFORMED OPS CHECK OF EMERGENCY LIGHT IAW AMM 33-51-00. OPS CHECKED GOOD.
"SDR SWAA2017052614010Light · brokenFWD GALLEY EXIT LIGHT BROKEN. R & R THE LIGHT ASSY IAW MM.SDR N6WA2017052502Light · inoperativeROW 18 OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE.
Back to JASC 3350