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 29GA2018091100002Light · looseFLT 0061 FLL/MCO REPORT: EMERGENCY STRIP LIGHT ON ROW 12 LOOSE. SECURED LOOSE EMERGENCY LIGHT STRIP AS REQUIRED OPS CHECK GOOD IAW AMM 33-50-20-04 ROW 12.SDR QXEA2018091000325Light · looseEMERGENCY LIGHTS AT ROW 9DE ARE LOOSE. RESECURED FLOOR PATH LIGHTING STRIP AT 9DE AND 10AB. NO DEFECTS NOTED. RETURNED TO SERVICE.SDR MASA2018091013558Light · inoperativeSERVICE DOOR EXIT SIGN 3 BULBS INOP. RELAMPED.SDR MASA2018091013557Light · inoperativeROW 1 OVHD EMER FLOOD LIGHT INOP. RELAMPED.SDR DALA2018091005506Battery · dischargedTAIL COMPARTMENT WALKWAY CENTER EMERGENCY LIGHT OUT. REFERENCED WDM 33-51-13. FOUND NO POWER AT LAMP. REPLACED BATTERIES IN POWER SUPPLY B5-28 (LOCATED IN AFT RIGHT LAVATORY CEILING). OPS CHECK OK. PN'S OFF AND ON TWO 41B004AD07G3 BATTERIES.SDR ASMF20180902718Battery Pack · failedDURING TRANSIT CHECK, THE CENTER EMERGENCY LIGHTS ROWS 29 TO 33 TURNED OFF. MAINTENANCE PERSONNEL PERFORMED REVISION DETECTING THE BATTERY PACK FAILED; SO THE BATTERY PACK WAS REPLACED IAW AMM DMC-B787-A-33-51-07-02B-520A-A / 720A-A AND EMERGENCY LIGHT TEST WASDR N6WA201809140901Sign · inoperativeFRONT SIDE RED LIGHT ON EMERGENCY EXIT SIGN NOT ILLUMINATING.SDR SWAA2018091225035Cover · missingRT LOWER EXIT SIGN COVER MISSING. R&R COVER PER MM.SDR ASAA2018091226093Power Supply · inoperativeEMERGENCY EXIT LIGHT POWER SUPPLY M1695 REQUIRES REPLACEMENT. GROUNDED - YES. REMOVED AND REPLACED M1695 POWER SUPPLY IAW AMM 33-51-06. OPS CHECK GOOD. SUPPLY, EMERGENCY POWER ( BATTERY).SDR ASAA2018091226092Power Supply · inoperativeEMERGENCY EXIT LIGHT POWER SUPPLY M1670 REQUIRES REPLACEMENT. GROUNDED - YES. REMOVED AND REPLACED M1670 POWER SUPPLY IAW AMM 33-51-06. OPS CHECK GOOD MECH.SDR ASAA2018091226091Power Supply · inoperativeMAIN CABIN EMERGENCY LIGHT NOT OPERATING CORRECTLY THRU OUT CABIN. GROUNDED - YES. REMOVED AND REPLACED 3 EMERGENCY LIGHTS POWER SUPPLIES IAW AMM 33-51-06. OPS CHECKS GOOD.SDR AALA201809129033Connector · unsecureEMERGENCY LIGHTS AT SEATS 39H, 40H, AND 41H WERE INOPERATIVE. MAINTENANCE FOUND THE CONNECTOR LOOSE AT ROW 38HJ. CONNECTED THE CONNECTOR AND PERFORMED SATISFACTORY OPS CHECK IAW AMM 33-51-00.SDR AALA201809129029Cover · detachedEMERGENCY LIGHT, PLASTIC COVER, AT THE L1 DOOR WAS FALLING OFF. MAINTENANCE SECURED THE LIGHT COVER IAW AMM 25-00-00.SDR ASAA2018091126090Power Supply · defectiveMAIN CABIN EMERGENCY LIGHTS NOT OPERATING CORRECTLY GROUNDED - YES. REMOVED AND REPLACED M1675 AND M1694. OP CHECK GOOD IAW AMM 33-51-06.SDR YENA2018091190337Battery · failedFLT 2633, BDL-TPA. AFT EMERGENCY LIGHT TEST FAILED FIN 13WL BATTERY. REMOVED & REPLACED EMERGENCY LIGHT BATTERY AT FIN 13WL PER AMM 33-51-38.SDR YENA2018091190336Switch · faultyFLT 882, UVF-JFK. CABIN EMERG EXIT LIGHTS REMAIN ILLUMINATED ALL FLIGHT. FOUND EMERG LIGHT SWITCH TO BE AT FAULT. REPLACED LIGHT SWITCH REF ESPM 20-45-00 & OPS CHK GOOD.SDR SWAA2018091124937Sign · unsecureEMERGENCY EXIT SIGN FELL OFF. REINSTALLED SIGN PER MM.SDR SWAA2018091124930Light · inoperativeAFT LT FUSELAGE EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR YENA2018091190334Epsu · failedFLT 405, BOS-LGB. DURING EMERG LIGHT TEST LT OVWNG EPSU FAILS. REMOVED AND REPLACED FIN 11WL EPSU AS PER AMM 33-51-38. OPS CKS NORMAL.SDR DALA2018091105563Light · unknownEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:405 / INTERIOR. RESECURED OPS GOOD.SDR AALA201809119018Lens · missingWALL MOUNTED EMERGENCY EXIT SIGN LENS WAS MISSING. REPLACED THE LENS IAW AMM 33-51-13-400-001-A. OPS TESTED NORMAL.SDR REXA2018091100818Sign · inoperativeOVERWING EMER EXIT SIGN NOT FUNCTIONING AIRCRAFT RIGHT. R&R LOWER RT EMERGENCY FLOOR LEVEL LIGHT SIGN IN EMERGENCY EXIT ROW IAW AMM 33-51-10 OPS CK GOOD . P/N OFF ON 6020-5.SDR AALA2018091109025Lens · missingEMERGENCY LIGHT LENS AT ROW 11L MISSING. REPLACED EMERGENCY LIGHT LENS.SDR DALA2018091005515Light · unsecureSEAT MOUNTED EMERGENCY PATH LIGHT AT 2C IS PUSHED IN. RESECURED SEAT MOUNTED PATH LIGHT AT SEAT 2C.SDR DALA2018091005513Battery Pack · dischargedEMERGENCY LIGHTS FROM AFT OVERWING EXIT TO AFT LAVS ARE INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY BATTERY PACKS AT B5-230 & B5-231. OPERATION IS NOW NORMAL IAW AMM 33-51. AIRCRAFT IS OK FOR SERVICE.SDR F3LA2018091000427Battery · failedBATTERY 10WL FAILED EPSU TEST. REPLACED BATTERY AT EPSU 10WL IAW AMM 33-51-38 PB401. OPS NORMAL NO FAULTS NOTED.SDR DALA2018090905505Light · inoperativeLEFT EXTERIOR EMERGENCY LIGHT IS OUT. R&R LT EMERGENCY EXTERIOR LIGHT IAW AMM 33-41, OP CKS GOOD.SDR 29GA2018091000001Sign · detachedFLIGHT 0067 FLL/MCO REPORT: EMERGENCY EXIT SIGN ON FORWARD STARBOARD DOOR DETACHED. RE-ATTACHED EMERGENCY EXIT SIGN IAW AMM 51-30-00.SDR MASA2018090913555Light · inoperativeEXIT AT 14F 1 BULB INOP. PLACED ON MEL.SDR SIMA2018100508005Power Supply · inoperativeFLOOR PROXIMITY LIGHTS 6-8 ARE INOPERATIVE-C/A-REMOVED AND REPLACED BATTERY POWER SUPPLY NR 4 IAW AMM-33-50-04. OPS CHECK GOODSDR DALA2018091205567Light · inoperativeCABIN OVERHEAD EMERGENCY LIGHTS INOP AT ROW 14 & 22, REPLACED EMERGENCY LIGHT FIXTURES ON BOTH ROWS 14 AND 22.SDR AALA201809119010Battery · no testDURING AN EMERGENCY LIGHT TEST, THE 14WL BATTERY FAULTED DURING A TEST. REPLACED EMERGENCY LIGHT BATTERY IAW AMM 33-51-38. OPS CHECKED OK.SDR AALA201809119006Battery Pack · no testEMERGENCY LIGHT TEST FAILED . REPLACED THE POWER SUPPLY BATTERY PACK 10WL IAW MM 33-51-00. OPS NORMAL.SDR AALA2018091109043Light · inoperativeEMERGENCY LIGHT BY THE L4 DOOR WAS INOPERATIVE. MAINTENANCE REPLACED LENS AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018091109042Lens · missingAISLE EMERGENCY LIGHT 12C LENS WAS MISSING. MAINTENANCE REPLACED LIGHT AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-18.SDR SWAA2018091125017Light · inoperativeLT OVER WING AFT EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2018091124943Power Supply · inoperativeLT OVERWING EMERGENCY LIGHT INOP AT BS 603, WL 212. R&R POWER SUPPLY IAW AMM.SDR SWAA2018091124925Cover · brokenL1 DOOR EMERGENCY EXIT LOWER SIGN BROKEN. SECURED COVER IAW AMM.SDR R61A2018091180928Power Unit · faultyEMERGENCY LIGHTS WON'T SHUT OFF. TROUBLESHOT PER FIM 33-50-00-810-803-A AND FOUND AFT RT IB EMERGENCY LIGHT POWER UNIT TO BE AT FAULT. R&R AFT RT IB EMERGENCY LIGHT POWER UNIT REF AMM 33-50-01.SDR AALA2018091109027Cover · detachedR2 EMERGENCY LIGHT COVER DETACHED. ATTACHED THE COVER IAW MM 33-51-00. OPS CHECKED OK.SDR AALA201809109019Cover · damagedEXIT LIGHT COVER AT THE L1 DOOR WAS DAMAGED. INSTALLED EXIT LIGHT COVER IAW AMM 52-20-00.SDR I5EA2018091100000Battery Pack · dischargedPASSENGER CABIN (2 EACH ) EMERGENCY LIGHTS BATTERY INOPERATIVE. REMOVED AND REPLACED 2 EACH BATTERY PACK OF EMERGENCY LIGHT IAW AMM 33-51-51, PAGE 202, OPERATIONAL CHECK GOOD IAW AMM 33-51-51, PAGE 204. REMOVED UNITS S/N: 35570 AT STA 753L AND S/N: 53156 AT SSDR SWAA2018091024903Lens · unsecureMID CABIN OVERHEAD EMERGENCY EXIT SIGN LENS FELL OFF. INSTALLED LENS PER SIP.SDR SWAA2018091024887Charger · defectiveFORWARD EMERGENCY LIGHT CHARGER CIRCUIT BREAKER POPPED. R&R CHARGER PER AMM.SDR SWAA2018091024886Battery Pack · defectiveFORWARD EMERGENCY LIGHT CHARGER CIRCUIT BREAKER POPPED. R&R BATTERY PACK PER AMM.SDR AALA201809109037Light · damagedEMERGENCY LIGHT NEAR THE L2 DOOR WAS DAMAGED. REPLACED THE EMERGENCY LIGHT ASSEMBLY. TESTED OK IAW AMM 33-51-00.SDR SIMA2018091008001Charger · failedCABIN FLOOR EMER LIGHT 1,2 & 3 INOP. R&R NR 2 BATT PACK AND CHARGER IAW AMM 33-50-04. OP CK GOOD. EMERGENCY LIGHTING BATTERY P/N 2013-1A S/N 84695.SDR AALA201809109030Cover · damagedEMERGENCY LIGHT COVER AT SEATS 27 DAMAGED. THE AIRCRAFT WAS GROUNDED. REPLACED THE SEAT EMERGENCY LIGHT COVER.SDR AALA201809109010Cover · damagedEMERGENCY LIGHT COVER AT SEATS 23 WAS DAMAGED. THE AIRCRAFT WAS GROUNDED. REPLACED SEAT EMERGENCY LIGHT COVER.SDR DALA2018090905504Power Supply · inoperativeFWD CABIN EMERGENCY LIGHT BATTERY PWR SUPPLY INOP. REPLACED BATTERY PWR SUPPLY REF AMM 33-53. OP CK GOOD.
Back to JASC 3350