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 AALA20170814005Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY BATTERY PACK MCM 2908 AT ROW 16 -23 FAILED TEST. REPLACED BATTERY PACK PER AMM 33-51-00. OPERATIONS CHECK NORMAL.SDR AALA20170814004Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY BATTERY PACK MCM2908 AT ROW 7-14 FAILED TEST. REPLACED BATTERY PACK PER MM 33-51-06. OPERATIONS CHECK NORMAL.SDR SWAA2017081615727Light · inoperativeRT AFT EMERGENCY EXIT SIDEWALL LIGHT INOP AT ROW 15. R&R LIGHT IAW AMM.SDR SWAA2017081615725Light · inoperativeRT OVERWING EMERGENCY LIGHT INOP. R&R LIGHT IAW AMM.SDR SWAA2017081615692Light · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR REXA2017081300881Light · inoperativeEMERGENCY LIGHT, EXTERIOR, RT AFT, NOT ILLUMINATING. REMOVED AND REPLACED LIGHT IAW AMM 33-51-2. OPS CHECKED GOOD.SDR AALA201708149027Lens · brokenEMRERGENCY EXIT SIGN LENS BROKEN AT ROW 9C. REPLACED THE LENS IAW AMM.SDR RAIA201708130002Bulb · inoperativeRIGHT AFT WING TO BODY FAIRING EXTERIOR FLOOD LIGHT INOPERATIVE. R & R THE FAIRING EXTERIOR FLOOD LIGHT BULB, OPS CHECKED GOOD.SDR MASA2017081312538Light · inoperativeOH EXIT SIGN AT EXIT ROW INOP. RELAMPED.SDR MASA2017081312534Sign · inoperativeROW 14DF LWR EMER EXIT SIGN INOP.SDR MASA2017081312533Sign · inoperativeROW 4 EMER EXIT SIGN INOP.SDR AALA201708159004Lens · missingAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 3E HAS A MISSING LENS COVER. REPLACED LENS COVER PER AMM 33-51-11. OPERATIONAL CHECK GOOD. (CLOSED)SDR AALA201708159002Control Unit · faultyAIRCRAFT WAS NOT GROUNDED. AIRPLANE HEALTH MONITORING ALERT RECEIVED FOR L4 DOOR REMOTE WIRELESS EMERGENCY LIGHTS SYSTEM CONTROL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WELS CONTROL UNITS. REMOVED AND REPLACED WELS CONTROL UNIT PER AMM DMC-B787-A-33-51-0SDR AALA201708159001Control Unit · faultyAIRCRAFT WAS NOT GROUNDED. AIRPLANE HEALTH MONITORING ALERT RECEIVED FOR L3 DOOR AFT SEAT REMOTE WIRELESS EMERGENCY LIGHTS SYSTEM CONTROL UNIT INTERNAL FAULT. REMOVED AND REPLACED WELS CONTROL UNIT 16 PER AMM 33-51-07. OPERATIONAL CHECK GOOD. (CLOSED)SDR RAIA201708120001Bulb · inoperativeLEFT AFT WING TO BODY FAIRING EXTERIOR FLOOD LIGHT IS INOPERATIVE. R & R THE BULB, OPS CHECKED GOOD.SDR SWAA2017081615748Cover · missingLT OVERWING EXIT DOOR LENS MISSING. INSTALLED COVER PER MM.SDR DALA2017081506273Sign · missingL2 DOOR EXIT SIGN MISSING. INSTALLED. OPERATION CHECKS GOOD.SDR AALA20170813003Sign · brokenAIRCRAFT WAS NOT GROUNDED. EXIT SIGN BY LEFT REAR DOOR IS FALLING OFF. REPLACED LEFT AFT ENTRY DOOR EXIT SIGN IDENTIFIER LIGHT ASSEMBLY PER AMM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170813002Sign · brokenAIRCRAFT WAS NOT GROUNDED. EXIT SIGN BY RIGHT REAR DOOR IS FALLING OFF. REPLACED AFT RIGHT ENTRY DOOR EXIT SIGN IDENTIFIER LIGHT ASSEMBLY PER AMM 33-51-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170813001Cover · brokenAIRCRAFT WAS NOT GROUNDED. ESCAPE PATH LIGHT COVER BEFORE FORWARD GALLEY HAS BROKEN OFF. MAINTENANCE REPLACED EMERGENCY ESCAPE PATH PROXIMITY LIGHT ASSEMBLY PER AMM 33-51-00.SDR SWAA2017081615739Battery Pack · dischargedLT EXTERNAL EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER MM.SDR SWAA2017081615695Battery Pack · dischargedLT AFT OVERHEAD BIN EMERGENCY EXIT LIGHT INOP AT ROW 13. R&R BATTERY PACK PER MM.SDR AALA201708159016Lens · missing1ST CLASS ROW 3C EMERGENCY EXIT LIGHT LENS MISSING. REPLACED THE LENS IAW AMM.SDR AALA201708149043Battery · failedAIRPLANE HEALTH MONITORING ALERT RECEIVED FOR L1 DOOR PRIME WIRELESS EMERGENCY LIGHTS SYSTEM CONTROL UNIT BATTERY POWER FAILURE. REMOVED AND REPLACED BATTERY PER AMM 33-51-07. OPERATIONAL CHECK GOOD.SDR AALA201708149042Battery · inoperativeEMERGENCY FLASHLIGHT IN THE OVERHEAD FLIGHT CREW REST AREA IS INOPERATIVE. REMOVED AND REPLACED THE BATTERY IAW AMM 25-64-00. OPS CHECKED GOOD.SDR AALA201708159038Light · looseTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT LENS COVER ADJACENT TO 4L DOOR IS LOOSE. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-14. OPS CHKS OK.SDR AALA201708159037Light · brokenTHE AIRCRAFT WAS GROUNDED. ESCAPE PATH LIGHT COVER BEFORE FWD GALLEY HAS BROKEN OFF. REPLACED EMERGENCY ESCAPE PATH PROXIMITY LIGHT ASSEMBLY IN FWD GALLEY AISLE AND OPS TEST OK IAW AMM 33-51-00.SDR AALA201708159035Light · unsecureTHE AIRCRAFT IS NOT GROUNDED. FORWARD RIGHT DOOR EXIT LIGHT COVER NOT SECURED. REPLACED EXIT LIGHT ASSY. FOR R1 DOOR IN F/C GALLEY PER AMM 33-51-14. LIGHT ASSY. OPS CHECKS GOOD.SDR AALA201708149029Lens · missingR2 DOOR EMERGENCY LIGHT LENS MISSING. INSTALLED THE LENS AS REQUIRED.SDR AALA201708149025Switch · malfunctionedEMERGENCY EXIT SIGN AT RIGHT OVERWING EXIT IS ALWAYS ON. CYCLED EMERGENCY LIGHT SWITCH ON PANEL. OPS.CHECKED NORMAL.SDR IPXA2017081220438Power Supply · inoperativeEXTERIOR ESCAPE SLIDE EMERGENCY LIGHT INOPERATIVE. R & R THE POWER SUPPLY IAW AMM 33-51-07. OPS CHECKED GOOD.SDR IPXA2017081220437Power Supply · inoperativeLEFT OVERHEAD EMERGENCY LIGHT INOPERATIVE. R & R THE EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-51-07. OPS CHECKED GOOD.SDR Q2SA20170812384Power Supply · inoperativeDURING AN OPS CHECK OF INTERIOR EMERGENCY LIGHTS, FOUND L1 INTERIOR AND EXTERIOR EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY, EMERGENCY POWER SUPPLY, OPS CHECKED GOOD IAW AMM 33-51-51. AIRCRAFT GROUNDED.SDR SIMA20170812001Light · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT, OPS CHECKED GOOD IAW AMM 33-50-10.SDR JJBA20170812012Sign · inoperativeEMERGENCY LIGHTS AT ROW 18 INOPERATIVE. R & R THE SIGN ASSY.SDR MASA2017081212528Light · inoperativeROW 22 CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE.SDR MASA2017081212530Lamp · inoperativeOVERHEAD EMERGENCY CEILING FLOOD LIGHT AT ROW 1 INOPERATIVE. REPLACED THE LAMPS.SDR MASA2017081212531Lamp · inoperativeOVERHEAD EMERGENCY CEILING FLOOD LIGHT AT ROW 6 INOPERATIVE. REPLACED THE LAMPS.SDR DALA2017081706275Power Supply · inoperativeSERVICE DOOR VERTICAL EMERGENCY EXIT SIGN INOPERATIVE. REPLACED POWER SUPPLY B5-241 IAW MM. OPERATION CHECKS GOOD.SDR AALA201708159034Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. AFT RIGHT EXIT SIGN COVER MISSING. REPLACED MISSING LENS COVER PER AMM 33-51-01.SDR AALA201708159033Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT COVER MISSING AT 4R. REMOVED AND REPLACED DR 4R EMERGENCY LIGHT ASSEMBLY PER AMM 33-51-01-960-802.SDR AALA201708159032Sign · unsecureTHE AIRCRAFT WAS NOT GROUNDED. EXIT SIGN BY LEFT REAR DOOR IS FALLING OFF. REPLACED THE LEFT ENTRY DOOR EXIT SIGN IDENTIFIER LIGHT ASSEMBLY AND OPS TEST OK IAW AMM 33-51-00.SDR AALA201708159018Lens · missingEMERGENCY LIGHT LENS MISSING AT THE R2 DOOR. REPLACED THE LENS.SDR AALA201708159017Lens · missingSEAT MOUNTED EMERGENCY LIGHT LENS MISSING SEAT 16L. REPLACED THE LENS IAW AMM.SDR N6WA2017081101Battery Pack · inoperativeEMERGENCY EXIT LIGHTS OUT AT MID CABIN OVERHEAD, FRONT BULKHEAD, AND MAIN CABIN DOOR FLOOR LEVEL FLOOD LIGHT. R & R EMERGENCY BATTERY, OPS CHECKED GOOD IAW AMM 33-51-017,SDR ASAA2017081121610Lens · detachedR1 DOOR EXIT LIGHT COVER FELL OFF GROUNDED - YES. SECURED R1 DOOR EXIT LIGHT LENS COVER.SDR AALA201708149037Lens · brokenLEFT SIDE EMERGENCY EXIT DOOR SIGN HAS A BROKEN LENS. REPLACED THE LENS IAW AMM 25-21-06. OPS CHECKED GOOD.SDR AALA201708149036Lens · missingCEILING EMERGENCY EXIT SIGN AT ROW 20AB AFT LENS MISSING. REPLACED THE LENS IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201708149010Module · malfunctionedSEAT MOUNTED EMERGENCY LIGHTS IN THE FIRST CLASS ARE DIM. REMOVED AND REPLACED BATTERY PACK AND CHARGING MODULE AT M10798 IAW AMM 33-51-07. OPS CHECKED GOOD.SDR AALA201708149006Lens · looseEMERGENCY LIGHT LENS AT FWD OF LAV 74 IS LOOSE. SECURED THE LENS.
Back to JASC 3350