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 DALA2018031201656Lens · looseEMERGENCY EXIT SIGN LENS LOOSE. SECURED THE LENS. OK FOR SERVICE.SDR DALA2018031201655Lens · missingOVERHEAD EXIT SIGN LENS AT THE OVERWING EXIT DOORS WAS FOUND MISSING. FRONT AND REAR. REPLACED THE SIGN LENSES.SDR UIEA2018031200377Battery Pack · inoperativeENTRYWAY EMERGENGY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY AND BATTERY. OPS CHECKED GOOD IAW AMM 33-51-07-002-006, AND 33-51-07-402-010.SDR UIEA2018031200378Charger · inoperativeENTRYWAY EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY AND BATTERY. OPS CHECK GOOD IAW AMM 33-51-07-002-006 & 33-51-07-402-010.SDR AALA201803129050Light · missingPHOTOLUMINESCENT STRIP AT FORWARD GALLEY AIRCRAFT RIGHT SIDE MISSING APPROXIMATELY 18 INCH PIECE WHERE MOON MAT MEETS CARPET. PHOTOLUMINESCENT LIGHT STRIP INSTALLED AT FORWARD GALLEY AIRCRAFT RIGHT SIDE PER AMM 33-50-21.SDR SIMA20180311002Relay · failedEMER LTS CYCLING ON/OFF WHEN ARMED. FOUND RELAY K135 FAULTY USING WM 33-50-01. REMOVED AND REPLACED RELAY IAW MM 20-42-00 AND 24-06-11 OPS CKS OK.SDR MASA2018031113050Light · inoperativeROW 6 OVHD EMER LIGHT INOP. PLACED ON MEL.SDR MASA2018031113049Light · inoperativeROW 23 CEILING EMER FLOODLIGHT INOP. PLACED ON MEL.SDR MASA2018031113048Epsu · unsecurePAX/SERVICE DOOR EMER EXIT SIGNS INOP. RE-SECURED FWD EPSU.SDR MASA2018031113047Light · inoperativeROW 13-21 OVERHEAD EMERG FLOOD LIGHTS INOP. MX IS TROUBLESHOOTING.SDR SWAA2018032620666Lens · missingRIGHT OVERWING EXIT DOOR EMERGENCY LIGHT LENS MISSING. INSTALLED A NEW LENS IAW AMM.SDR AALA201803129035Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. CABIN DOOR 4L EXIT SIGN MISSING. EXIT SIGN LENS FOUND ON THE FLOOR. SECURED LENS IN PLACE. OPERATIONS CHECK GOOD.SDR AALA201803129034Light · damagedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT FLOOR ENTRY WAY FLOOD LIGHT HOUSING DAMAGED. REPLACED LIGHT ASSEMBLY EMERGENCY FLOOD PER AMM 33-51-01. OPERATIONS CHECK GOOD.SDR AALA201803129032Lens · brokenEMERGENCY LIGHT LENS AND BEZEL DAMAGED. THE LENS ON FLOOR LEVEL THRESHOLD LIGHT AT FWD ENTRY DOOR IS DENTED AND WILL NOT STAY ON. FORWARD ENTRY LIGHT LENS COVER DAMAGED AT L1 DOOR. REPLACED FORWARD EMERGENCY LIGHT LENS IAW STANDARD MAINTENANCE PRACTICES.SDR AALA201803129018Sign · brokenAIRCRAFT WAS NOT GROUNDED. AFT GALLEY DOOR EXIT SIGN COVER FELL OFF. REPLACED 4L DOOR EMERGENCY EXIT SIGN PER MM 33-51-01.SDR AALA201803129026Lens · crackedCRACK IN CEILING THE EMERGENCY LIGHT LENS AT THE L3, AND R3 DOORS. REPLACED LENSES IAW AMM 33-51-17-400-801-A. OPS TESTED OK.SDR AALA201803129016Light · brokenBROKEN EMERGENCY LIGHT BASE ASSEMBLY AT THE LAVATORY L62. REPLACED THE EMERGENCY LIGHT BASE ASSEMBLY IAW AMM 33-51-12-400-809-A. OPS TESTED OK.SDR HALA2018031100080Sign · crackedL2 DOOR EXIT SIGN FOUND CRACKED. REPLACED THE EXIT SIGN.SDR DALA2018031201661Sign · damagedTWO LEFT EXIT SIGNS DAMAGED. REPLACED THE SIGNS IAW TOPP 50-00-25.SDR DALA2018031301629Battery Pack · inoperativeBOTH THE AFT OVERWING EXIT HATCH LOCATION LIGHTS ARE INOPERATIVE. MAINTENANCE FOUND THE BATTERY PACK B5-230 INOPERATIVE. THE BATTERY PACK WAS REPLACED IAW AMM 33-51. OPS CHECKED NORMAL. THE AIRCRAFT RETURNED TO SERVICE.SDR AALA201803129033Lens · missingEMERGENCY AISLE LIGHT LENS AT ROW 24ABC MISSING. INSTALLED A NEW LENS IAW AMM 33-5103.SDR DALA2018031201573Light · missingEMERGENCY LIGHT AT 41G MISSING. REPLACED DAMAGED LIGHT ASSEMBLY. SYSTEM OPERATION IS NORMAL.SDR AALA201803129017Lens · detachedAIRCRAFT WAS NOT GROUNDED: MAINTENANCE FOUND EMERGENCY EXIT LENS ON FORWARD GALLEY TABLE. REPLACED EMERGENCY EXIT SIGN AT R1 DOOR AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER MM 33-51-01.SDR DALA2018031201563Charger · inoperativeDURING INSPECTION, FOUND EMERGENCY LIGHTS INOPERATIVE FROM ROW 23 BACK. MAINTENANCE R & R THE AFT BATTERY PACK AND CHARGER IAW AMM 33-51.SDR 29GA2018031200002Light · inoperativeFLIGHT 0123 EYW/MCO REPORT: NO LIGHTS COMES ON, ON THE FIA PANEL FOR THE EMERGENCY LIGHTS WHEN THEY ARE ARMED. R&R LIGHT BULB ON F/A EMERGENCY LIGHT SWITCH IAW AMM 20-10-00-00, OPS CHECK GOODSDR 29GA2018031200001Light · inoperativeFLIGHT 0093 FLL/EYW REPORT: F/A REPORTS DURING PREFLIGHT EMERGENCY LIGHT SWITCH DOOR INOP. FOUND LIGHT BULB AT FAULT. REPLACED 1 EA EMERGENCY LIGHT SWITCH BULB AT F/A PANEL. REF 33-50-00 OPS CHECK NORMAL.SDR DALA2018031401705Light · missingDURING INSPECTION, FOUND SEAT MOUNTED 14D EMERGENCY LIGHT MISSING.SDR AALA201803149010Battery Pack · inoperativeTAIL COMP EMERGENCY LIGHTS INOPERATIVE. REPLACED THE EMERGENCY LIGHT BATTERY PACKS B5-27 AND B5-28 IAW AMM 33-53-00. TAIL CONE LIGHT CHECKED OK.SDR AALA201803129039Battery Pack · inoperativeTAIL COMP EMERGENCY LIGHTS ARE OUT. REPLACED THE EMERGENCY LIGHT BATTERY PACKS B5-27 AND B5-28 IAW AMM 33-53-00. TAIL CONE LIGHT CHECKED OK.SDR AALA201803139023Battery · faultedFORWARD EMERGENCY LIGHT BATTERY FAULTED. REMOVED AND REPLACED THE BATTERY. OPS CHECKED GOOD IAW AMM 33-51-38.SDR HALA2018031100081Light · detachedEMERGENCY LIGHT PEELING OFF THE FLOOR IN THE AFT GALLEY BETWEEN THE JUMP SEATS, SECTION MISSING. REPLACED THE EMERGENCY LIGHT STRIP IN AFT GALLEY.SDR SWAA2018031320392Charger · inoperativePASSENGER CABIN EMERGENCY LIGHTS INOPERATIVE BETWEEN ROWS 8 TO 13. R & R THE CHARGER IAW AMM.SDR SWAA2018031320388Battery · no testEMERGENCY LIGHT BATTERY FAILED A TEST AT M01675. R & R THE BATTERY IAW AMM.SDR SWAA2018031320384Battery Pack · inoperativePASSENGER CABIN EMERGENCY LIGHTS INOPERATIVE BETWEEN ROWS 8 TO 13. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018031320363Power Supply · inoperativeRIGHT OVERWING EXIT OVERHEAD SIGN INOPERATIVE. R & R THE POWER SUPPLY IAW AMM.SDR DALA2018031301660Housing · damagedSEAT 44D MOUNTED EMERGENCY LIGHT ASSY HOUSING DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHT ASSEMBLY HOUSING IAW AMM 33-51.SDR AALA201803129037Light · unsecureFLOOR LIGHT ATTACHED TO FORWARD CLOSET IS OUT OF THE SOCKET. REPOSITIONED LIGHT ASSY, IAW AMM 33-50-00. OPS CHECKED GOOD.SDR SWAA2018031220341Lens · detachedMID CABIN EMERGENCY EXIT SIGN LENS FELL OFF. REINSTALLED THE LENS IAW AMM.SDR DALA2018031101560Lens · damagedDURING INSPECTION, FOUND FOUND THE EMERGENCY LIGHT LENS ABOVE ROW 32D DAMAGED. MAINTENANCE REPLACED LENS IAW AMM 33-51. OPS CHECKED GOOD.SDR REXA2018030900181Lamp · inoperativeRIGHT WING AFT EMERGENCY LIGHT OUT. REPLACED THE LAMPS IAW AMM 33-51-21. OPS TESTED GOOD.SDR MASA2018030913044Bulb · inoperative3 EMERGENCY LIGHTS WITH ONE BULB INOPERATIVE IN GALLEY AREA. OPENSDR MASA2018030913042Light · inoperativeROW 23 CEILING EMERGENCY FLOOD LIGHT INOPERATIVE. MX IS T/S.SDR MASA2018030913040Bulb · inoperativeEMER FLOOD LIGHTS INOP ROW 6 & 10. REPLACED THE BULB.SDR IPXA2018030927265Power Supply · intermittentDURING DESCENT, EMERGENCY LIGHTS AT THE L1 DOOR WERE ON & OFF INTERMITTENTLY. REMOVED AND REPLACED THE POWER SUPPLY.SDR DALA2018031401704Light · inoperativeLEFT CEILING EMERGENCY EXIT LIGHT AT ROW 17 INOPERATIVE. REPLACED THE LIGHT ASSEMBLY. OPS NORMAL, OK FOR SERVICE.SDR ASOA201803085069Bulb · inoperativeDURING ROUTINE INSPECTION, THE RT OVERWING EMERGENCY LIGHT WAS INOPERATIVE. MX REMOVED AND REPLACED THE BULB, OPS CHECKED GOOD. ACFT APPROVED FOR RETURN TO SERVICE.SDR SWAA2018031320362Spring · brokenAFT FLIGHT ATTENDANT PANEL, EMERGENCY LIGHT SWITCH GUARD SPRING BROKEN. R & R THE SWITCH GUARD IAW CMM.SDR AALA201803129051Lens · missingEMERGENCY LIGHT LENS ON CEILING AT ROW 19 MISSING. REPLACED THE LENS IAW MM 33-51-03.SDR AALA201803129029Lens · missingEMERGENCY LIGHT LENS ON CEILING AT ROW 17 MISSING. REPLACED THE LENS IAW MM 33-51-03.SDR SWAA2018031220356Battery Pack · no testM1672 BATTERY PACK FAILED A CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.
Back to JASC 3350