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 SWAA2021080400754Sign · missing'EXIT-SALIDA' SIGN ON REAR SERVICE DOOR MISSING. / R&R AFT SERVICE DOOR EMERGENCY LIGHT FOR EXIT PER AMM 33-51-01SDR DALA2021080304380Battery Pack · inoperative(LOG 7321120) DURING INSPECTION FOUND EMERGENCY ESCAPE PATH LIGHTS INOP ROWS 19-22. RPLD BATTERY PER B737 AMM 33-51. OPS CKS NORMAL.SDR DALA2021080304372Spring · out of positionSHIP 1805 EMERGENCY LIGHT SWITCH WASN'T TO SLIDE INTO ON POSITION WHEN GUARDED SWITCH DOWN. CORRECTIVE ACTION: REPOSITIONED SWITCH GUARD SPRING. SYSTEM OPERATION IS NORMAL. (LP 7546984)SDR DALA2021080304367Guard · deterioratedSHIP 1805 - COCKPIT EMERGENCY LIGHTS WITCH GUARD REPORTED TO BE IN POOR CONDITION. CORRECTIVE ACTION: REPLACED SWITCH GUARD. SYSTEM OPERATION IS NORMAL. (LP 1894524)SDR AALA202108025749Cover · looseAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT LOOSE AT SEAT 12C. SECURED LIGHT COVER IAW AMM 33-51-11, OPS CHECK GOOD.SDR AALA202108021219Cover · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ABOVE SEAT 16A FELL OFF. REATTACHED LIGHT COVER, OPS CHECK GOOD.SDR AALA202108024287Light · missingAIRCRAFT WAS NOT GROUNDED: EXIT SIGN COVER MISSING AT SEAT 17A. INSTALLED NEW EMERGENCY LIGHT AT SEAT 17A IAW AMM 33-51-01-960-802, OPS CHECK GOOD.SDR BAGA20210802002Battery Pack · failedL/H CENTER EMERGENCY BATTER PACK INOP DURING SCHEDULED MAINTENANCE TEST - REPLACED EMERGENCY BATTERY PACK IAW AMM 33-50-01SDR BAGA20210802001Battery Pack · failedR/H CENTER EMERGENCY BATTERY PACK INOP DURING SCHEDULED MAINTENANCE TEST - REPLACED EMERGENCY BATTERY PACK IAW AMM 33-50-01SDR BAGA2021080200001Battery Pack · failedFWD EMERGENCY BATTERY PACK INOP DURING SCHEDULED MAINTENANCE TEST - REPLACED EMERGENCY BATTERY PACK IAW AMM 33-50-01SDR AALA202108029244Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT SYSTEM TEST SHOWS FAULT FOR 11WL UNIT. REPLACED BATTERY FOR 11WL REF AMM 33-51-38.SDR WX0A2021073073801Epsu · no testEMERGENCY POWER SUPPLY (12WL) REQUIRES REPLACEMENT DUE TO BITE TEST FAULT / REMOVED AND REPLACED EMERGENCY POWER SUPPLY (12WL) BITE TEST GOOD REF AMM 33-51-38"SDR AALA202108029906Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING PERIODIC SERVICE CHECK OPERATIONAL TEST OF EMERGENCY LIGHTS FAILED ON PANEL. REMOVED AND REPLACED FORWARD LEFT BATTERY PACK (10WL) OPERATIONS CHECK GOOD PER AMM 33-51-38.SDR AALA202108025532Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS ON FRONT OF MAIN DECK CREW REST INOPERATIVE. REPLACED M33400 BATTERY PACK PER AMM 33-51-06.SDR AALA202108022902Light · looseAIRCRAFT WAS NOT GROUNDED: ROW 19C EMERGENCY LIGHT LOOSE. SECURED EMERGENCY LIGHT PER AMM 33-51-11.SDR AALA202108021533Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT TRIM EMERGENCY LIGHT DETACHED. REATTACHED SEAT TRIM LIGHT PER AMM 25-22-00.SDR AALA202108026390Cover · unsecureAIRCRAFT WAS NOT GROUNDED: SEAT 10C EMERGENCY LIGHT COVER IS NOT SECURE. SECURED LIGHT COVER PER AMM 33-50-00SDR DXTA2021080246130Light · unknownCABIN EMERG LIGHT: EMERGENCY LIGHT OVER SEAT 7 AND TOILET WERE INOPERABLE WITH INITIAL TEST OF EMER LIGHTING SYSTEM (EMER LIGHT SWITCH TO ARM, WITH BATTERIES IN THE OFF POSITION). SEAT 7 AND TOILET EMER LIGHTS ILLUMINATED WITH POWER ON AIRCRAFT. THE LIGHTS STASDR DALA2021080204330Battery Pack · inoperativeTHE EMERGENCY LIGHTS ABOVE THE FWD FLIGHT ATTENDANT SEAT IS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK B5-235. TEST NORMAL PER B717-AMM 33-51-00 710-801. (LP #1895051)SDR SIMA20210801001Power Supply · inoperativeMEL 33-22 ON LOG PAGE# 4734279/1 LH/RH OVERWING EMERGENCY LIGHT INOP. AUTH# 070505D-C"TRANSFERRED TO NRWC 681-DFW-05721"-C/A-REFERENCE NRWC 681-DFW-05721 ITEM 3 REMOVED AND REPLACED #4 BATTERY POWER SUPPLY AND CHARGER ASSY. IAW EMB145 AMM 33-50-04. OPERATIONALSDR SWAA2021091400019Lens · brokenBROKEN EMERGENCY EXIT LENS GALLEY 4 AT AFT GALLEY AREA (1 EA) ; 2021-342241 / [01] REPLACED EMERGENCY EXIT LENS GALLEY 4 AT AFT GALLEY AREA (1 EA) AND PERFORMED OPERATIONAL TEST OK IAW B737-700 AMM 33-51-01-960-802; [02] TASK CARD COMPLETEDSDR SWAA2021081100334Lamp · inoperativeAFT RIGHT HAND EMERGENCY EXIT SLIDE LIGHT IS INOP ; / [01] REPLACED AFT RIGHT HAND EMERGENCY EXIT SLIDE LAMP AND PERFORMED GOOD INSTALLATION TEST OF NEW LAMP. ALL WORK DONE PER AMM 33-51-04-960-801; [02] CERTIFIED ALL WORK WAS PERFORMED AS PER THIS CARD AND AMSDR SWAA2021081100335Bulb · inoperativeR/H OVERWING EXIT EMERGENCY WINDOW EXIT LIGHT HAS A BULB INOP ; / [01] RELAMPED R/H OVERWING EXIT EMERGENCY WINDOW EXIT LIGHT AND PERFORMED GOOD FUNCTIONAL TEST AS PER AMM. 33-51-01-960-801; [02] CERTIFIED ALL WORK WAS PERFORMED AS PER THIS CARD AND AMM 33-51-SDR SWAA2021080500336Bulb · inoperativeAFT SERVICE DOOR EMERGENCY EXIT SIGN HAS BULB INOP. RELAMPED AFT SERVICE DOOR EMERGENCY EXIT SIGN AND PERFORMED GOOD FUNCTIONAL TEST AS PER AMM. 33-51-01-960-801.SDR AALA202108048844Light · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTING LOOSE AT SEAT 28C. SECURED EMERGENCY EXIT LIGHT AT SEAT 28C.SDR DALA2021080304400Lens · missingSHIP 5803 DOOR 2R EXIT SIGN COVER MISSING. CORRECTIVE ACTION: INSTALLED CURRENT LENS PER ER-A 593217-14 SECTION III PERMANENT REPAIR. (7983022)SDR DALA2021080304387Battery Pack · no testSHIP 5645 WHILE PERFORMING SERVICE CHECK L1 DOOR AND ROWS 22,23,24,25 LIGHTS INOP. CORRECTIVE ACTION: REPLACED L1 DOOR BATT PACK AND ROW 22 BATT PACK ALL CHECKS GOOD PER B757 AMM 33-51. (7324854)SDR DALA2021080304382Battery Pack · inoperative(LOG 7840565) DURING INSPECTION FOUND SEAT MOUNTED EMERG LIGHTS INOP. R/R M01674 BATTERY PACK PER B737 M/M 33-51-06 - TEST OK.SDR DALA2021080304385Light · inoperative(LOG 7775098) DURING INSPECTION FOUND FLOOR PROXIMITY EMERGENCY LIGHT ON 35D INOP. INSTALLED LIGHT ASSY AT PAX SEAT 35D IAW B737 AMM 33-51. OPS OK.SDR ASAA2021073035606Battery Pack · failedMULTIPLE EMERGENCY LIGHTS INOP. GROUNDED - YES. REMOVED AND INSTALLED SERVICEABLE EMERGENCY BATTERY PACK M1676 IAW B737-900 AMM 33-51-06-960-805, RELAMPED R/H AFT OVERWING EMERGENCY EXIT LIGHT IAW B737-900 AMM 33-51-04-960-801 AND REPLACED POWER SUPPLY FUSE INSDR AALA202108037098Light · detachedAIRCRAFT WAS NOT GROUNDED: POWER OUTLET IN CEILING AFT OF EMERGENCY EXIT ROW DETACHED IN FLIGHT. SECURED CEILING EMERGENCY EXIT LIGHT.SDR AALA202108035323Sign · missingAIRCRAFT WAS NOT GROUNDED: EXIT SIGN COVER AFT LEFT DOOR MISSING. REPLACED EXIT SIGN IAW AMM 33-51-01.SDR AALA202108031101Light · detachedAIRCRAFT WAS NOT GROUNDED: EXIT CEILING MOUNTED LIGHT HANGING AT DOOR 3L NEEDS REPLACING. REPAIRED EMERGENCY LIGHT ASSEMBLY REF AARD-200. .35-51-01-1SDR SWAA2021080399855Bulb · burned outEXIT SIGN FWD GALLEY CEILING BULB BURNT L/H SIDE . ; / [01] RELAMPED L/H FWD EXIT SIGN GALLEY CEILING BULB AS PER B737 AMM 33-51-01-960-801. TEST OK.<BR><BR>AAR TAG A83643; [02] STEP 1 VERIFIEDSDR SWAA2021080399703Lens · brokenFWD ENTRY DOOR LOWER EXIT LITE COVER BROKEN ; / [01] REATTACHED FWD ENTRY DOOR EXIT LT COVER IAW AMM 33-51-01SDR SWAA2021080300714Lens · unsecureOVERHEAD EMERGENCY EXIT SIGN AT OVERWING-PLASTIC COVERS WILL NOT STAY IN PLACE. FALL OUT INTO CENTER ISLE CREATING A HAZARD / RESECURED OVERWING EMERGENCY EXIT CEILING MOUNTED SIGN COVER IAW AMM 33-51-01SDR SWAA2021080300352Lens · missingAFT GALLEY SERVICE DOOR EXIT SIGN LENS COVER MISSING ; / [01] REPLACED MISSING EMERGENCY COVER IAW AMM 33-51-01SDR SWAA2021080300700Charger · inoperativeAFT LH EMER SLIDE LIGHT INOP / RELAMPED AFT LH EMER SLIDE LIGHT IAW AMM 33-51-04. NO HELP. R+R M1673 BATTERY CHARGER IAW 33-51-06. OPS CHECKS GOOD.SDR JJBA202108030030Lamp · dimMCD EXTERNAL EMERGENCY LIGHT DIM. R&R MCD EXTERNAL EMERGENCY LIGHT. OPS CHECK SATSDR JJBA202108030029Lamp · burned outEMERGENCY LIGHT BELOW SERVICE DOOR INOP R+R LIGHT BULB FOR THE EMERGENCY LIGHT BELOW THE SERVICE DOOR. OPS CHECK SATSDR JJBA202108030028Battery Pack · inoperativeLEFT AND RIGHT OVERWING EMERGENCY LIGHT NOT WORKING. R&R #3 EMERGENCY BATTARY. OPS CHECK SATSDR JJBA20210730027Light · intermittentEMERGENCY LIGHT ON MAIN DOOR IS WORKING INTERMITTENLY. REMOVED AND REPLACED MAIN DOOR EMERGENCY LIGHT ASSY. OPS CHECK GOOD.SDR AALA202108025775Cover · detachedAIRCRAFT WAS NOT GROUNDED: OVERWING EXIT LIGHT COVER DETACHED. REINSTALLED LIGHT COVER IAW AMM 33-51-01, OPS CHECK GOOD.SDR AALA202108023665Sign · detachedAIRCRAFT WAS NOT GROUNDED: OVER WING EXIT ROW SIGN COVER DETACHED. REATTACHED OVER WING EXIT ROW SIGN AS REQUIRED PER AMM 33-50-00.SDR AALA202108026304Light · unsecureAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT COVER NEEDS TO BE SECURED IN AFT GALLEY. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT LEFT SIDE AFT GALLEY PER AMM 33-51-00.SDR AALA202108027222Battery · faultedAIRCRAFT IN BASE MAINTENANCE: FAULT EMERGENCY POWER SUPPLY UNIT BATTERY 13WL IN PASSENGER CABIN 2EA. REPLACED SERVICEABLE EMERGENCY POWER SUPPLY UNIT BATTERY 13WL PER AMM 33-51-38-400-002-A.SDR AALA202108024637Battery · faultedAIRCRAFT IN BASE MAINTENANCE: FAULT EMERGENCY POWER SUPPLY UNIT BATTERY 10WL IN PASSENGER CABIN 2EA. REPLACED SERVICEABLE EMERGENCY POWER SUPPLY UNIT BATTERY 10WL PER AMM 33-51-38-400-002-A.SDR AALA202108022716Battery · faultedAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK CABIN INTERCOMMUNICATION DATA SYSTEM 1 TEST, FOUND BATTERY 15WL FAULT. REMOVED AND REPLACED EMERGENCY LIGHT UNIT 15WL BATTERY PER AMM 33-51-38.SDR AALA202108025251Battery · faultedAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK CABIN INTERCOMMUNICATION DATA SYSTEM 1 TEST, FOUND BATTERY 13WL FAULT. REMOVED AND REPLACED EMERGENCY LIGHT UNIT 13WL BATTERY PER AMM 33-51-38.SDR AALA202108026281Battery · faultedAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK CABIN INTERCOMMUNICATION DATA SYSTEM 1 TEST FOUND BATTERY 15WL FAULT. REMOVED AND REPLACED EMERGENCY LIGHT UNIT 15WL BATTERY PER AMM 33-51-38.
Back to JASC 3350