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 DALA2018101506137Epsu · inoperativeFOUND RIGHT OVERWING EPSU INOP. REMOVED AND REPLACED RIGHT OVERWING EPSU. OPERATION CHECKS NORMAL.SDR SWAA2018101626006Battery Pack · dischargedLT EMERGENCY LIGHT INOP BETWEEN ROW 9 TO ROW 12. R&R BATTERY PACK PER AMM.SDR HNAA2018101700257Light · inoperativeNDIS 635 33-51 0018250 14OCT18 SBY CLOSE EMERGENCY EXIT LIGHT ABOVE SERVICE DOOR INOP. 31254 00 SPE FACT 14OCT18 10:42 SBY R&R EMERGENCY EXIT LIGHT ABOVE SERVICE DOOR & RESET CIRCUIT BREAKER. OPS CHECK GOOD CEILING PANEL RESECURED. P/N ON/OFF 7444-1SDR AALA201810169017Battery Pack · inoperativeR1 FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT WAS INOPERATIVE. MAINTENANCE REPLACED THE FLASHLIGHT BATTERY IAW AMM 25-64-00-00B-921A, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR R61A2018101641035Power Supply · inoperativeEMERGENCY LIGHT BATTERY FAULT EICAS MESSAGE WHEN TURNING ON EMERGENCY LIGHTS. R&R AFT RT INBOARD EMERGENCY POWER SUPPLY UNIT IAW AMM 33-50-01.SDR SWAA2018101525922Cover · brokenRT SIDE "LOWER" OVERWING EXIT LIGHT COVER BROKEN. R&R CHARGER PER AMM.SDR DALA2018101506052Battery Pack · inoperative(LOG 5181344) DURING INSPECTION FOUND FUNCTIONAL CHECK EMERGENCY LIGHTING, SEAT MOUNTED LIGHT FAILED TEST POWERED BY M1669. M1670 & M1672 POWER PACK. R/R POWER SUPPLY M1669, M1670 & M1672 BATTERY PACK PER AMM 33-51-06. OPS CKD OK.SDR DALA2018101506043Lens · unsecureEMERGENCY EXIT AT DOOR 1L HAS A DAMAGED DIFFUSER LENS ON THE EXIT SIGN AND THE COVER FALLS OFF. MAINTENANCE REPLACED THE LIGHT COVER ABOVE DOOR 1L AND INSTALLED A NEW DIFFUSER. CHECKS ARE GOOD. (LP 0784436)SDR DALA2018101506042Sign · damagedON CEILING AT ROW 1, THE EXIT SIGN IS MISSING HALF ALSO CLOSE NOT ILLUMINATED. MAINTENANCE REPLACED THE EXIT SIGN PER AMM 33-51-18. OPERATIONAL CHECK IS GOOD. AIRCRAFT IS OK FOR SERVICE. (LP 4689852)SDR MASA2018101411445Light · inoperativeROW 15 EMER FLOOD LT INOP. PLACED ON MEL.SDR MASA2018101411444Battery · dischargedEMER LIGHTS ROW 13 LT/RT INOP. ALLOWED BATTERIES TO CHARGE.SDR DALA2018102606307Power Supply · inoperative(AIRCRAFT 7110, L/P 4676210) EMERGENCY LIGHTS INOP ON CENTER BOX SEAT ROWS 10B-10C THRU 12B-12C. REPLACED EMERGENCY POWER SUPPLY M33098 AT R2 DOOR PER AMM 33-51-06.SDR ASAA2018102326561Power Supply · inoperativeEMERGENCY BATTERY PACK M1674 INOP. WILL NOT CHARGE. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY BATTERY PACK AND POWER SUPPLY M1674 IAW AMM 33-51-06. OPS CHECK GOOD. CLOSED FORWARD ENTRY LIGHT PANEL. ODR ATTACHED.SDR YENA201810130688Battery · dischargedDURING HEAVY MAINTENANCE, EMERGENCY LIGHT BATTERIES LOW BATTERY CAPACITY AT 10WL,14WL AND 15WL; REF LHT NR 5000798678-0010, INSTALLED EMERGENCY LIGHT BATTERY AT 10WL,14WL,15WL IAW AMM 33-51-38-400-001-A, REV 75. OPS CKS NORMAL. SUPPLEMENTAL INFORMATION TO FOLLSDR YENA201810130687Battery · dischargedDURING HEAVY MAINTENANCE, EMERGENCY LIGHT BATTERIES LOW BATTERY CAPACITY AT 10WL,14WL AND 15WL; REF LHT NR 5000798678-0010, INSTALLED EMERGENCY LIGHT BATTERY AT 10WL,14WL,15WL IAW AMM 33-51-38-400-001-A, REV 75. OPS CKS NORMAL. SUPPLEMENTAL INFORMATION TO FOLLSDR YENA201810130686Battery · dischargedDURING HEAVY MAINTENANCE, EMERGENCY LIGHT BATTERIES LOW BATTERY CAPACITY AT 10WL,14WL AND 15WL; REF LHT NR 5000798678-0010, INSTALLED EMERGENCY LIGHT BATTERY AT 10WL,14WL,15WL IAW AMM 33-51-38-400-001-A, REV 75. OPS CKS NORMAL. SUPPLEMENTAL INFORMATION TO FOLLSDR REXA2018101600961Lens · crackedOPS CHECK OF ALL EMERGENCY EXTERIOR AND CABIN LIGHTS FAILED. LIGHTS DIMMED AND DIED WITHIN 1 MIN OF OPERATION. FOUND RIGHT AFT OVERWING LIGHT INOP, RELAMPED AND REPLACED CRACKED LENS IAW AMM 33-51-15. PERFORMED OPERATIONAL TEST OF EXTERNAL EMERGENCY LIGHTS IAWSDR SWAA2018101525994Power Supply · inoperativeLT OVERWING EMERGENCY EXIT SIGNS INOP. R&R POWER SUPPLY IAW MM.SDR SWAA2018101525984Cover · unsecureAFT FACING EMERGENCY EXIT SIGN FELL OFF. INSTALLED COVER PER SIP.SDR SWAA2018101525983Lens · missingR2 DOOR EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER AMM.SDR SWAA2018101525946Light · inoperativeRT EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR AALA201810159024Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. DURING OPERATIONS TEST OF EMERGENCY LIGHTS - EMERGENCY LIGHTS INOPERATIVE AT RIGHT HAND OUTWING EXIT SIGN AND FORWARD FACING AISLE EXIT SIGN. REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY PACK (12WL) PER CMM 33-51-38. OPERATIONS CHECKSDR AALA201810159022Light · malfunctionedAIRCRAFT WAS GROUNDED. IN ALL POSITIONS EMERGENCY EXIT LIGHTS IN CABIN ON, WILL NOT TURN OFF. RESET CIDS PER AMM 23-73-34. OPERATIONS CHECK GOOD.SDR AALA201810159015Battery Pack · dischargedDURING A WALK AROUND, OBSERVED EMERGENCY LIGHT INOPERATIVE ON THE CEILING PANEL FROM ROW 32 UP TO 42, RIGHT SIDE. FOUND THE POWER SUPPLY AT R4 DOOR TO BE DISCHARGED. REMOVED AND REPLACED POWER SUPPLY IAW AMM 33-51-06. GOOD FOR SERVICE.SDR SWAA2018101525921Cover · missingOVERHEAD AFT ENTRY EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED COVER IAW AMM.SDR DALA2018101506044Cover · missingEXIT COVER LIGHT MISSING AT FIRST CLASS LAVATORY. MAINTENANCE REPLACED THE EXIT SIGN LIGHT COVER AT FIRST CLASS LAVATORY PER AMM 33-51. OK FOR SERVICE. (LP 5130810)SDR DALA2018101506038Battery Pack · dischargedFWD EMER. LIGHT PACK INOP. REMOVED AND REPLACED FWD EMER BATTERY PACK IAW AMM 33-53 OPS CHECKED GOOD. (LP5000750)SDR E07A201912032002Battery Pack · failedEMERGENCY LIGHTS STAY ON WITH AIRCRAFT UNDER POWER AND EMERGENCY LIGHT SWITCH IN AUTO. REPLACED FORWARD AND AFT EMERGENCY LIGHT POWER SUPPLIES.SDR E07A20191203001Battery Pack · failedEMERGENCY LIGHTS STAY ON WITH AIRCRAFT UNDER POWER AND EMERGENCY LIGHT SWITCH IN AUTO. REPLACED FORWARD AND AFT EMERGENCY LIGHT POWER SUPPLIES.SDR SWAA2018103026350Light · damagedOVERWING EMERGENCY EXIT LIGHT ATTACHED TO THE CENTERLINE DIFFUSER DAMAGED. INSTALLED LIGHT IAW AMM.SDR REXA2018101800964Light · crackedNUMERIOUS EMERGENCY PATH LIGHTING STRIPS WORN/CRACKED. REPLACED NUMEROUS EMERGENCY PATH LIGHTING IAW AMM 33-51-01-000
-801-A21 AND AMM 33-51-01-400-801-A21.SDR DALA2018101406140Battery · faultedLEFT AFT EPSU BATTERY FAULT. REPLACED SAME. OPERATION CHECKS GOOD.SDR DALA2018101406139Battery · faultedLEFT EMERGENCY EPSU BATTERY FAULT ON CIDS. REMOVED AND REPLACED BATTERY. OPERATION CHECKS OKAY.SDR AALA2018101659038Battery Pack · no testEMERGENCY LIGHTS AT THE RIGHT FORWARD SIDE OF THE MID GALLEY WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK IAW MM 33-51-06, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018101659037Battery Pack · no testEMERGENCY LIGHTS AT THE LEFT AFT SIDE OF THE MID GALLEY WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-51-06, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018101659036Battery Pack · no testEMERGENCY LIGHTS AT THE AFT WALL OF MID GALLEY WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK IAW MM 33-51-06, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018101525999Light · inoperativeLT AFT OVERHEAD BIN EMERGENCY LIGHT INOP. R&R BULB IAW AMM.SDR SWAA2018101525996Sign · inoperativeRT OVERWING EMERGENCY EXIT SIGN INOP AT FORWARD LOWER CORNER. R&R SIGN IAW AMM.SDR SWAA2018101525976Battery Pack · dischargedRT OVERWING EMERGENCY EXIT SIGN INOP AT FORWARD LOWER CORNER. R&R BATTERY PACK IAW AMM.SDR SWAA2018101525971Light · inoperativeLT AFT OVERHEAD BIN EMERGENCY LIGHT INOP. R&R COVER IAW AMM.SDR SWAA2018101525936Battery Pack · dischargedLT EMERGENCY EXIT ROW LIGHT INOP AT ROW 8. R&R BATTERY PACK PER AMM.SDR ASOA2018101624053Charger · inoperativeIAH - THE CREW REPORTED AN OVERHEAD EMERGENCY LIGHT AT ROW THREE TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED EMERGENCY LIGHT BATTERY CHARGER, OPERATIONALLY TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA201810154002Control Unit · inoperativeBLUE EMERGENCY LIGHTS AT ROWS 6-16 WERE INOPERATIVE. REPLACED NR 5 CONTROL UNIT IAW AMM 33-31-00 AND 25-25-02.SDR AALA201810159035Battery Pack · no testEMERGENCY LIGHTS AT LEFT FORWARD SIDE OF MID GALLEY INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK IAW AMM 33-51-06.SDR AALA201810159034Battery Pack · no testEMERGENCY LIGHTS AT RIGHT FOWARD SIDE OF MID GALLEY WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR DALA2018101506065Lens · missing(AIRCRAFT 6707, L/P 5110761) SEAT 18D MISSING WHITE EMERGENCY LIGHT LENS. RPLD 18D EMERGENCY LIGHT PIGTAIL HARNESS. LIGHT OPN GOOD. REF AMM 33-51.SDR DALA2018101506063Power Supply · inoperative(AIRCRAFT 5815, L/P 4732701) HAND RAIL EMER LTS 18A 19D 20A & 21D INOP. RPLD PWR SUPPLY AND BAT PACK M11486 PER AMM 33-51. OPS NML.SDR AALA201810152006Battery Pack · no testLEFT EMERGENCY LIGHTS L396, L397 AND L645 DID NOT ILLUMINATE ON TEST. REPLACED BATTERY AND CHARGER M738 IAW AMM 33-51-07. OPS TESTED GOOD IAW AMM 33-51-07 AND CARD 2800.SDR AALA201810152005Charger · no testLEFT EMERGENCY LIGHTS L396, L397 AND L645 DID NOT ILLUMINATE DURING TEST. REPLACED THE BATTERY AND CHARGER M738 IAW AMM 33-51-07. OPS TESTED GOOD IAW AMM 33-51-07 AND CARD 2800.SDR CALA2018101302100Battery · dischargedDOOR RT 2 FWD EXIT IDENTIFIER WAS NOT ON WHEN EMERGENCY LIGHT TESTED. DOOR RT 2 M33097 BATTERY CHARGER AND BATTERY REPLACED. C/O EMER LIGHT TEST, THE RESULT FND NORMAL AS EPR AMM 33-51-06-960-803 REV 83 & AMM 33-51-06-960-802 REV 83.
Back to JASC 3350