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 SWAA2019062133958Light · inoperativeFORWARD CABIN EMERGENCY LIGHT STRIP AISLE INOP. R&R STRIPS PER MM.SDR SWAA2019062033949Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS FAILED CAPACITY CHECK AT M01675. R&R BATTERY PACK PER AMM.SDR DALA2019062003695Lamp · inoperativeALL FOUR OVERWING EXIT DOOR PULL HANDLE LIGHTS INOP, RELAMPED ALL 4 OVERWING EXIT DOOR PULL HANDLE LIGHTS.SDR DALA2019062003692Sign · damaged(LOG 5439370) DURING INSPECTION FOUND AFT GALLEY EMERGENCY EXIT LIGHT SIGN IS DAMAGED. R/R EXIT LIGHT ASSEMBLY IAW B737-800 AMM 33-51. OPS NML.SDR SIMA2019062019002Bulb · inoperativeLEFT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED L/H OVERWING EMERGENCY LIGHT BULB IAW AMM 33-50-10. OPS CHECKED GOOD.SDR HNAA2019062000177Bulb · inoperativeRH AFT EXTERIOR EMERGENCY EXIT LIGHT DOES NOT ILLUMINATE.... FIX: R&R D RH AFT EMERGENCY LIGHT,OPS CHCK GOOD IAW AMM TASK 33-50-10-000/400-801-ASDR VNAA2019100161102Light · inoperativeLH EXTERIOR EMER LIGHT AFT OF PAX DOOR INOP. REMOVED/REPLACED LH EXT. EMER LIGHT AFT OF PAX DOOR, IAW CRJ900 AMM 33-51-15-000/400-801. OPS CHECK GOOD AT THIS TIMESDR YENA2019062480337Lens · missingLOWER EMERG EXIT LIGHT AT 1L DOOR LENSE COVER MISSING; REPLACED WITH SERV LENSE. OPS CHK NORMAL. ADVISED MCC BOB.SDR R61A2019062180638Power Supply · inoperativeCEILING EMERGENCY LIGHT OUT. R&R THE NR 3 POWER UNIT OF THE EMERGENCY LIGHTS SYSTEM IN REF TO AMM 33-50-01.SDR SWAA2019062033947Cover · looseOVERHEAD CEILING EXIT ROW SIGN FRONT COVER LOOSE. SECURED COVER PER AMM.SDR AALA2019062099003Battery · no testAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS WERE DIM 26-36D. MAINTENANCE REPLACED BATTERY PER AMM 33-51-07 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2019062099005Power Supply · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTING INOPERABLE AT 26L, 27L, 28L, 28 CEILING, 31L, 32L, 35L, 36L, 36 CEILING, LAVATORY D WALL, 36 AISLE EXIT, L4 DOOR UPPER AND LOWER EXIT, AND R4 DOOR UPPER AND LOWER EXIT. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY USDR ASAA2019061989742Lamp · inoperativeR2 SLIDE/ EMERGENCY LIGHT INOP. GROUNDED - YES. REMOVED AND REPLACED R2 EMERGENCY SLIDE LAMP. REF B737-900 AMM 33-51-04. OPS CHECK GOOD.SDR DALA2019061903662Lens · missingREAR GALLEY EMERGENCY LIGHT (CROSS ISLE POSITION) LENS MISSING. REPLACED REAR GALLEY EMERGENCY LIGHT LENS FOR LEFT CROSS ISLE.SDR IPXA2019061983450Bulb · inoperativeEMERGENCY LIGHT HAS FOUR INOP BULBS.RELAMPED FOUR BULBS IN EMERGENCY LIGHT PER AMM 33-51-01-2.SDR SWAA2019061933914Battery · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1673. R&R BATTERY PER AMM.SDR MASA2019061981915Bulb · inoperative14DF EMER DOOR LWR EXT SIGN LIGHT. REPLACED BULB.SDR MASA2019061981914Bulb · inoperative14AB EMER DOOR LWR EXT SIGN LT. REPLACED BULBSDR MASA2019061811913Light · inoperativeROW 11 CEILING EMR FLOOD LT INOP.SDR DALA2019061803626Power Supply · inoperativeEMERGENCY EXIT LIGHTS AT ROW 34 OVERHEAD AND EXIT SIGN LIGHT AT ROW 34 INOP. R/R BATTERY AND POWER SUPPY AT ROW 32 AND BATTERY AND POWER SUPPLY AT ROW 35 IAW AMM 33-51. OPS CHECKS NORMAL. EMERGENCY POWER SUPPLY B5-231.SDR AALA2019062099002Sign · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN HANGING FROM CEILING MID CABIN. MAINTENANCE SECURED EMERGENCY EXIT SIGN FROM CEILING MID CABIN AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER 25-00-00 AWM.SDR AALA2019062099014Battery · no testAIRCRAFT IN BASE MAINTENANCE, EPSU SYSTEM TEST FAILED. REPLACED EPSU BATTERY PER AMM 33-51-38 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2019062099015Light · inoperativeAIRCRAFT IN BASE MAINTENANCE, R2 EMERGENCY DOOR EXIT LIGHT LOWER BULB INOPERABLE. REPLACED MARKER LIGHT ASSEMBLY PER AMM 33-51-18.SDR DALA201906203678Sign · detachedEXIT SIGN CENTER AISLE ROW 20 DAMAGED. RESECURED EXIT SIGN AT ROW OPS CK GOOD.SDR ASAA2019061979745Lens · detachedEXIT SIGN OVER L2 DOOR FELL OFF. GROUNDED - YES. REPLACED LENS OPS NORMAL.SDR SIMA201906187004Light · inoperativeROW 16 CEILING EMERGENCY LIGHT INOP. REMOVED AND REPLACED ROW 16 CEILING EMERGENCY LIGHT IAW AMM 33-50-08-000-801-A AND 33-50-08-400-801-A. OPS CHECKED GOOD.SDR SIMA201906187003Inverter · inoperativeCABIN RH EMERGENCY EXIT IDENTIFIER INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT DC/AC INVERTER #5 IAW AMM 33-50-11. EMERGENCY LIGHT OPERATIONAL CHECK GOOD.SDR SIMA201906187007Light · inoperativeDURING PS-1 CHECK FOUND SERVICE DOOR EXIT FLOOR PROX LIGHT INOP-C/A-REMOVED AND REPLACED SERVICE DOOR EXIT FLOOR PROX LIGHT IAW AMM 33-50-12. OPS CHECK GOODSDR SWAA2019061833891Sign · missingR/H OVERWING EXIT LOWER LEFT EXIT SIGN MISSING. / R&R LIGHT ASSEMBLY PER AMM.SDR AALA201906189005Battery · no testAIRCRAFT WAS NOT GROUNDED: OPERATIONAL TEST OF EMERGENCY LIGHTS FAILED BATTERY 11WL DISPLAYED ON MCDU. MAINTENANCE REPLACED BATTERY OF EPSU PER AMM 33-51-38.SDR AALA201906189014Light · out of positionAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT 27C WAS HANGING OUT OF POSITION. MAINTENANCE REPLACED EMERGENCY LIGHT AT 27C PER AMM 33-51-18.SDR AALA201906189015Battery · no testAIRCRAFT WAS NOT GROUNDED: OPERATIONAL TEST OF EMERGENCY LIGHTS FAILED BATTERY (11WL) DISPLAYED ON MCDU. MAINTENANCE REPLACED BATTERY OF EPSU PER AMM 33-51-38.SDR MASA2019061711912Light · inoperativeROW 23 EMER FLOOD LIGHT INOP. PLACED ON MELSDR MASA2019061711911Light · inoperativeROW 13 OVHD EMER LIGHT INOP. RELAMPEDSDR MASA2019061711910Light · inoperativeROW 9 CEILING LEVEL EMER FLOOD LIGHT INOP. PLACED ON MELSDR MASA2019061711909Light · inoperativeROW 1 CEILING LEVEL EMER FLOOD LIGHT INOP. PLACED ON MELSDR QXEA2019061700252Cover · looseESCAPE PATH LIGHTING AT FWD R/H EMERGENCY EXIT IS LOOSE AND PLASTIC COVER IS COMING OFF. R/R EMERGENCY FLOOR PATH LIGHT ASSEMBLY AT FWD R/H EMERGENCY EXIT REF Q400 AMM TASKS 33-51-16-000-801 AND 33-51-16-400-801.SDR DALA2019061703585Lamp · inoperativeDURING SERVICE CHECK FOUND ALL 4 OVERWING EXIT DOOR PULL HANDLE LIGHTS INOP, RELAMPED LEFT FORWARD AND AFT AND RIGHT FORWARD PULL HANDLE LIGHTSSDR DALA2019061703581Battery Pack · inoperativeFWD GALLEY CEILING EXIT LIGHTS INOP. REPLACED BATTERIES IN POWER SUPPLY IN FWD DROPDOWN CEILING IAW MD88 AMM 33-50. OPS CHECK GOOD.SDR DALA2019061703578Battery Pack · inoperativeEMERGENCY LIGHTS AFT OF ROW 31 INOP. REPLACED BATTERY PACKS BATTERIES FOR B5-28 AND B5-107. CKS GOOD REF MD88 AMM 33-53.SDR SWAA2019062134003Fuse · inoperativeR2 DOOR HEADER PANEL EMERGENCY EXIT LIGHT INOPERATIVE. R&R POWER SUPPLY FUSE IAW AMM.SDR AALA2019061879014Battery · no testAIRCRAFT WAS GROUNDED: CABIN EMERGENCY LIGHTING BATTERY CAPACITY CHECK FAILED. MAINTENANCE REPLACED EMERGENCY LIGHTING BATTERY PER AMM 33-51-39.SDR AALA2019061879019Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN LENS AT 15F FELL OFF IN FLIGHT DECK. MAINTENANCE REPLACED EXIT SIGN AT 15F PER AMM 33-50-51.SDR SWAA2019061833888Battery Pack · inoperativeL/H FORWARD EMERGENCY LIGHT INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2019061833869Charger · inoperativeL/H FORWARD EMERGENCY LIGHT INOP. / R&R CHARGER IAW AMM.SDR SWAA2019061833791Light · inoperativeL/H EMERGENCY EXIT LIGHT INOP AT ROW 17. R&R LIGHT PER MM.SDR REXA2019061860910Light · detachedEMER LIGHTING STRIP IN CABIN IS PULLED UP. R&R'D EMER. LIGHTING STRIP @ 7A IAW AMM 33-51-01. OPC GOOD. OK FOR SVCSDR DALA2019061873627Charger · inoperativeDURING SVC, FOUND EMERGENCY LIGHT AT LEFT AFT OVERWING EXIT DOOR OUT. R/R BATTERY CHARGER PER MD90 AMM 33-51, OPS CHECK GOOD.SDR DALA2019061763612Light · inoperativeEMERGENCY ESCAPE PATH LIGHT INOPERATIVE AT SEAT 16H. REPLACED EMERGENCY LIGHT.SDR DALA2019061763611Light · inoperativeEMERGENCY ESCAPE PATH LIGHT INOPERATIVE AT SEAT 25A. REPLACED EMERGENCY LIGHT EEPMS.
Back to JASC 3350