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 IPXA2018071831768Light · inoperativeON PREFLIGHT LVL EMER LT BAT 1 LOW. REMOVED AND REPLACED EMERGENCY LIGHT IAW AMM 33-51-01 MESSAGE REMAINS. DEFERRAL IAW MEL 33-50-4 DMP C/W DI LOG UPDOWN. PLACARD INSTALLED ESR 33-51-20-01SDR SWAA2018071823621Battery Pack · dischargedEMERGENCY EXIT LIGHT INOP AT ROW 6 ABC. R&R BATTERY PACK PER MM.SDR SWAA2018071823617Sign · looseOVER WING CEILING EXIT SIGN LOOSE. SECUREDS SIGN PER MM.SDR SWAA2018071823603Battery Pack · dischargedEMERGENCY EXIT LIGHT INOP AT ROW 9 ABC. R&R BATTERY PACK PER MM.SDR SWAA2018071823602Battery Pack · failedRT MID CABIN EMERGENCY LIGHT BATTERY FAILED TEST. R&R BATTERY PACK PER MM.SDR SWAA2018071823601Battery · failedRT FWD EMERGENCY LIGHT BATTERY FAILED TEST. R&R BATTERY PACK PER MM.SDR SWAA2018071823600Battery · failedLT FWD CABIN EMERGENCY LIGHT BATTERY FAILED TEST. R&R BATTERY PACK PER MM.SDR SWAA2018071823599Light · inoperativeR2 DOOE EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR DALA2018071804542Lens · out of positionEMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP. REPOSITIONED LIGHT LENS WHITE LIGHT CKS OK.SDR MASA2018071713416Sign · inoperativeLT AND RT OVERWING EXIT SIGNS INOP. PLACED ON MEL.SDR YENA201807160287Battery · dischargedFT 824, MCO-DCA. EMERGENCY LIGHTING ABOVE ROW 13 AND AFT MAIN DOOR LINER (RED) LIGHTS INOP. R&R BATTERY & EMERGENCY PWR SUPPLY 5 IAW AMM 33-50-01. OPS CKS GOOD. A/C OK FOR SVC.SDR IPXA2018072031703Battery Pack · dischargedEMERGENCY LT TEST FND BAT 1 LO MSG. CHANGED BATTERY PACK IAW AMM 33-51-01 PB 401 REL 91.00. OPS TEST IAW AMM 33-51-01 PB SUCCESSFUL.SDR SWAA2018071923598Light · crackedCENTER AISLE EMERGENCY EXIT LIGHT CRACKED. R&R LIGHT PER MM.SDR ASAA2018071625450Battery Pack · dischargedFORWARD CABIN LEFT EXIT SIGN, EXIT IDENTIFIER, AND FLIGHT DECK DOME EMERGENCY LIGHTS INOP ON TEST. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK M1675 IAW AMM 33-51-06-960-805. EMERGENCY LIGHTS TEST CHECKS GOOD IAW AMM 33-51-06. CLOSED FWD SDR AALA201807189032Battery · dischargedAIRCRAFT IN BASE MAINTENANCE: AFT CENTER FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT FLASHED RED ON TEST (LEFTSIDE CENTER GALLEY). REPLACED BATTERIES/BATTERY PACK FOR FLASHLIGHT AT FLIGHT ATTENDANT SEAT AFT CENTER LEFT.SDR AALA201807189030Lens · brokenAIRCRAFT WAS NOT GROUNDED: CREW REPORTS EMERGENCY LIGHT LENS BROKEN AT L-1 DOOR FRAME. MAINTENANCE REPLACED EMERGENCY LIGHT LENS AT L-1 DOOR AREA AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-18.SDR AALA201807189024Battery · dischargedPERFORM CIDS ON EMERGENCY POWER SUPPLY UNIT SYSTEM, BATTERY 10WL FORWARD L TEST FAILED. REPLACED BATTERY OF EMERGENCY POWER SUPPLY UNIT 10WL FORWARD L FOR EMERGENCY LIGHTS. PERFORM CIDS1 TEST. TEST OK PER AMM 33-51-38.SDR AALA2018071879007Cover · missingEMERGENCY LIGHT COVER AT THE L4 DOOR WAS MISSING. REPLACED THE COVER IAW AMM 33-51-13.SDR AALA2018071879006Lens · missingEMERGENCY LIGHT LENS WAS MISSING AT SEAT 3AC. REPLACED THE LIGHT ASSY.SDR AALA201807179020Cover · detachedTHE AIRCRAFT WAS NOT GROUNDED. THE EXIT COVER WAS FOUND BY THE FLIGHT ATTENDANTS IN THE FORWARD GALLEY CUPBOARD. REPLACED 1R EMERGENCY EXIT SIGN ASSEMBLY PER AMM 33-51-01. OPERATIONS CHECK NORMAL.SDR AALA201807179033Light · intermittentAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT CAME ON INTERMITTENTLY. MAINTENANCE CLEARED SWITCH AND CHECKED EMERGENCY LIGHT WITH BITE TEST AND PERFORMED OPERATIONAL CHECK PER AMM 33-51-00-710-001.SDR DALA2018071704539Sign · unsecureEXIT SIGN AT 2L WILL NOT STAY ATTACHED. SECURED EXIT SIGN AT 2L. OK FOR SVC.SDR AALA201807179031Battery Pack · failedEMERGENCY POWER SUPPLY BATTERY PACKS FAILED AT DOORS 1L, 2L, AND 3L. REPLACED BATTERY PACKS IAW AMM 33-51-38.SDR AALA201807179030Battery Pack · failedEMERGENCY POWER SUPPLY BATTERY PACKS FAILED AT DOORS 1L, 2L, AND 3L. REPLACED BATTERY PACKS IAW AMM 33-51-38.SDR AALA201807179029Battery Pack · failedEMERGENCY POWER SUPPLY BATTERY PACK FAILED. REPLACED THE BATTERY PACKS IAW AMM 33-51-38.SDR AALA201807179012Bracket · brokenSEAT 9AD EMERGENCY LIGHT ASSEMBLY SUPPORT BRACKET BROKEN. AIRCRAFT WAS GROUNDED. REPAIRED IAW EA 282493.SDR REXA2018071600618Light · inoperativeNR 4 EXTERIOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED NR 4 EXTERIOR EMERGENCY LIGHT IAW AMM 33-51-21 OPS CK GOOD.SDR DALA2018071904579Light · damagedEMERGENCY FLOOR LIGHTING DAMAGED AT 36G. RE-SECURED ROW 36FG LIGHT HOUSING SYSTEM OPERATION IS NORMAL.SDR AALA201807189011Cover · crackedL1 DOOR EXIT SIGN COVER CRACKED. REPLACED THE EXIT SIGN COVER.SDR DALA2018071604556Lens · missingDURING INSPECTION FOUND 17 DEF RECESSED LIGHTING/EMERGENCY AT OVERHEAD BIN MISSING LENS COVER. MAINTENANCE REPLACED DAMAGED LENS COVER.SDR DALA2018071704538Lens · unknownEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. RESECURED LENS. OK FOR SVC.SDR DALA2018071704523Lens · looseEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING, LOCATIONS: 2R EMERG EXIT. COVERED DIFFUSER LENS DAMAGED OR MISSING INTERIOR. SECURED LOOSE LIGHT COVER.SDR SWAA2018071723588Battery Pack · dischargedEMERGENCY EXIT LIGHT INOP AT ROW 14 ABC. R&R BATTERY PACK PER MM.SDR SWAA2018071723581Battery Pack · dischargedEMERGENCY EXIT LIGHT INOP AT ROW 17 ABC. R&R BATTERY PACK PER MM.SDR SWAA2018071723511Light · inoperativeRT OVER WING EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA2018071723510Light · inoperativeLT OVER WING EXIT LIGHT INOP. RELAMPED PER MM.SDR AALA201807179013Cover · missingSEAT 8C AISLE EMERGENCY LIGHT COVER MISSING. INSTALLED A NEW EMERGEMCY LIOGHT. OPS CHECKED GOOD.SDR ASOA201871762015Light · inoperativeOVERHEAD EMERGENCY FLOOD LIGHT AT ROWS 16 AND 18 INOP. RELAMPED OVERHEAD EMERGENCY FLOOD LIGHTS AT ROW 16 AND 18 IAW AMM 33-51-09. OPS CHECK GOOD.SDR AALA201807169040Light · damagedSEAT 3L EMERGENCY LIGHT DAMAGED. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-19. OPS CHECKED OK.SDR SWAA2018071623505Lens · brokenL1 DOOR EMERGENCY LIGHT LENS BROKEN. R&R LIGHT ASSY PER MM.SDR SWAA2018071623497Light · inoperativeL1 DOOR EVAC SLIDE EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR DALA2018071604493Light · damagedTHE EMERGENCY SEAT MOUNTED LIGHTING IS DAMAGED AND INOPERATIVE AT SEAT 27C. MAINTENANCE RESECURED THE PANEL. OK FOR SERVICE.SDR DALA2018071604492Sign · looseTHE EMERGENCY EXIT SIGN COVER AT DOOR 1L IS LOOSE. MAINTENANCE RESECURED EXIT THE EEPL SIGN AT 1L DOOR. AIRCRAT IS OK FOR SERVICE.SDR DALA2018071604487Power Supply · inoperativeTHE AFT DOOR EXIT SIGN IS INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY LIGHT BATTERY POWER SUPPLY IAW AMM 33-51-03. OPERATIONAL CHECK WAS GOOD.SDR IPXA2018071831731Light · inoperativeEMERGENCY LIGHTS INOP. T/S PER FIM 33-51-00-815-803. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK REF AMM 33-51-07-022-001 AND AMM 33-51-07-422-012. OPS CK GOOD. SN ON 55129. SN OFF 10531.SDR DALA2018071804550Lens · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:405 / INTERIOR. REINSTALLED WHITE LENS COVER. OPS NORMAL.SDR DALA2018071804549Lens · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:901 / INTERIOR. REINSTALLED RED LENS COVER. OPS NORMAL.SDR ASOA2018071844038Control Module · inoperativeGSO - FLIGHT 4011, THE CREW REPORTED THAT THE EMERGENCY LIGHT BUTTON ON THE FA PANEL WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE FA CONTROL MODULE, OPERATIONALLY TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA2018071604531Light · unsecureEMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP, LOCATIONS:39D INTERIOR. RESECURED LIGHT ASSY CKS OK.SDR AALA201807169037Warning Message · false activationDURING AN OPERATIONAL TEST OF THE EMERGENCY LIGHTS, PTP SHOWS THE MESSAGE: EPSU EXT LOAD FWD L AT FWD GALLEY AREA. PERFORMED TROUBLESHOOTING IAW TSM 33-51-00-810-808-A AND PERFORMED OPERATIONAL TEST OF THE EMERGENCY LIGHTS IAW AMM 33-51-00-710-001-A AND TEST
Back to JASC 3350