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 DALA2017091806934Lens · missingR1 DOOR EMERGENCY LIGHT MISSING THE LENS. REPLACED THE LENS, CHECKED GOOD.SDR DALA2017091807072Charger · inoperativeEMERGENCY LIGHTS INOPERATIVE AT 4AB - 6AD AND 13B-20B. REPLACED M9011 BATTERY AND CHARGER. SYSTEM OPERATION NORMAL.SDR SWAA2017092516587Lens · crackedLT EMERGENCY LIGHT LENS COVER TRIM CRACKED BETWEEN ROW 8 TO ROW 23. R&R COVER IAW AMM.SDR AALA201709189051Sign · inoperativeAIRCRAFT WAS GROUNDED. EMERGENCY EXIT SIGN AT THE R3 DOOR/CEILING IS INOPERATIVE. INSTALLED NEW EMERGENCY EXIT SIGN EXTRUSION (BACKSHELL) PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201709189048Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE R2 DOOR HAS A DETACHED LENS COVER. REPLACED LENS COVER PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR DALA2017091907011Light · brokenEMERGENCY ESCAPE PATH LIGHT AT SEAT 1C BROKEN, REPLACED 01C EMERGENCY ESCAPE PATH LIGHT ASSY.SDR AALA20170917005Sign · brokenAIRCRAFT WAS GROUNDED. CEILING MOUNTED EMERGENCY EXIT SIGN BY THE R3 DOOR IS BROKEN, HANGING FROM WIRES. REMOVED AND REPLACED EXIT SIGN PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201709209004Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. DURING CHECK PERFORMED OPERATIONAL TEST OF EMERGENCY LIGHTS. INOPERATIVE BATTERY ON EMERGENCY POWER SUPPLY UNIT (11WL). REPLACED BATTERY PACK PER AMM 33-51-38.SDR DALA2017091906984Fuse · failedDURING A SERVICE CHECK, FOUND EMERGENCY LIGHTS WOULD NOT ILLUMINATE IN BOTH AISLES FROM ROWS 10-12. REPLACED THE FUSE IN THE POWER SUPPLY IAW AMM 33-51, AND ASM 33-51.SDR DALA2017091906979Lens · missingDURING SVC CHECK FOUND EMERGENCY LIGHT DIFFUSER LENS MISSING AT SEAT 12B. FWD TO NEF 33-51-02. REPLACED MISSING LENS COVER.SDR I5EA201709190001Battery Pack · inoperativeEMERGENCY LIGHTS INSIDE AND OUTSIDE OF CABIN ARE INOPERATIVE. REMOVED AND REPLACED BATTERY PACKS AT BS 753L AND 598R. OPERATIONAL CHECKED GOOD.SDR SWAA2017091916459Battery Pack · dischargedR1 DOOR EMERGENCY LIGHT INOP BETWEEN ROW 3 TO ROW 6. R&R BATTERY PACK IAW MM.SDR SWAA2017091916455Battery Pack · dischargedRT EMERGENCY LIGHT INOP BETWEEN ROW 3 TO ROW 6. R&R BATTERY PACK IAW MM.SDR SWAA2017091916449Light · inoperativeLT OVERWING EMERGENCY EXIT SIDEWALL LIGHT BULB INOP. R&R BULB PER MM.SDR SWAA2017091916445Light · inoperativeLT OVERWING EMERGENCY EXIT SIDEWALL LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2017091916440Light · inoperativeRT EMERGENCY LIGHT INOP AT ROW 19. R&R LIGHT PER AMM.SDR QXEA2017091900577Power Supply · malfunctionedON ARRIVAL, FOUND AFT EMERGENCY LIGHTS ON WITH SWITCH IN THE OFF POSITION. REMOVED SEALING PANEL 245GZ AND DISCONNECTED EMERGENCY LIGHTS BATTERYS 3L &3R. MCD EMERGENCY EXIT LIGHT INOP. REMOVED LIGHT POWER SUPPLY UNIT AND INSTALLED SERVICEABLE POWER SUPPLY. OSDR AALA201709189012Cover · missingEMERGENCY LIGHT, WHITE COVER AT BOTTOM RIGHT NEAREST THE DOOR, IS MISSING. REPLACED THE COVER IAW AMM.SDR ASAA2017091721948Power Supply · no testEMERGENCY LIGHT BATTERY PACK M1670 FAILED TO TEST. ACFT GROUNDED. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-806, OPS NORMAL.SDR ASAA2017091721947Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS M1675 AND M1695 FAILED TO TEST. ACFT GROUNDED. REMOVED, REPLACED, AND TESTED THE BATTERY PACKS, OPS NORMAL IAW AMM 33-51-06-960-805SDR YENA201709170771Battery Pack · no testDURING A WEEKLY EMERGENCY LIGHT TEST, THE SYSTEM FAILED. FOUND THE EPSU BATTERY AT FAULT 10WL AND 13WL. R & R BOTH BATTERY PACKS IAW AMM 33-51-38. OPS TESTED OK.SDR YENA201709170770Battery Pack · no testDURING A WEEKLY EMERGENCY LIGHT TEST, THE SYSTEM FAILED. FOUND EPSU BATTERY AT FAULT 10WL AND 13WL. R & R BOTH BATTERY PACKS IAW AMM 33-51-38. OPS TESTED OK.SDR HALA2017091800235Sign · detachedEXIT SIGN AT THE L2 DOOR FELL OFF. SECURED THE EXIT SIGN.SDR MASA2017091712636Light · inoperativeFWD CLOSET FLOOR EMERGENCY LIGHT WILL NOT ILLUMINATE. REPLACED THE EMERGENCY LIGHT.SDR MASA2017091712634Light · inoperativeEMERGENCY LIGHT AT ROW 4 INOPERATIVE.SDR SWAA2017100216785Housing · looseLT STOWBIN BULLNOSE EMERGENCY EXIT LIGHT HOUSING LOOSE BETWEEN ROW 4 TO ROW 5. SECURED LIGHT IAW SOPM.SDR DALA2017091806996Light · inoperativeEMERGENCY LIGHTS AT CEILING PANELS POSITION 18F 20F, AND 20B ARE INOPERATIVE. REPLACED BULBS, SYSTEM OPERATION IS NORMAL.SDR DALA2017091806992Light · inoperativeDURING SERVICE CHECK FOUND EMERGENCY LIGHT AT 30F INOPERATIVE. REPLACED LIGHT ASSEMBLY. SYSTEM OPERATION IS NORMAL.SDR DALA2017091806989Light · inoperativeDURING SERVICE FOUND FLIGHT DECK EMERGENCY INOPERATIVE. REPLACED ASSEMBLY SYSTEM OPERATION IS NORMAL.SDR IPXA2017091821834Light · inoperativeRT AFT FLIGHT DECK EMERGENCY EXIT LIGHT INOP. RELAMPED IN REFERENCE TO AMM 33-51-11, OPS NORMAL.SDR SWAA2017092016484Cover · missingL2 DOOR EMERGENCY LIGHT COVER MISSING. REINSTALLED COVER PER AMM.SDR AALA201709189042Sign · missingEMERGENCY EXIT SIGN AT ROW 15ABC IS MISSING. REPLACED THE SIGN IAW AMM 33-51-01. OPS CHECKED GOOD.SDR DALA2017091806977Cover · brokenEMERGENCY EXIT SIGN COVER DOOR 1R BROKEN. SIGN REPLACED.SDR SWAA2017091916458Charger · inoperativeLT EMERGENCY OVERHEAD AISLE LIGHT INOP BETWEEN ROW 14 TO ROW 17. R&R BATTERY CHARGER IAW MM.SDR SWAA2017091916457Light · inoperativeRT OVERWING EMERGENCY EXIT SIDEWALL LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2017091916447Battery Pack · dischargedLT EMERGENCY OVERHEAD AISLE LIGHT INOP BETWEEN ROW 14 TO ROW 17. R&R BATTERY PACK IAW MM.SDR SWAA2017091916444Lens · unsecureL1 DOOR EXIT SIGN PLACARD FELL OFF. SECURED LENS COVER PER MM.SDR SWAA2017091916423Light · inoperativeLT OVERWING EMERGENCY EXIT SIDEWALL LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR DALA2017091806967Lens · damagedSEAT 41D EMERGENCY LIGHT LENS DAMAGED. REPLACED THE LENS. OK FOR SERVICE IAW MM 12-88-70.SDR AALA201709189033Lens · brokenL1 DOOR EMERGENCY LIGHT LENS BROKEN. REPLACED THE LENS.SDR DALA2017091806955Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHTS INOPERATIVE ABOVE FIRST CLASS AND ECONOMY. REPLACED THE BATTERIES ABOVE ROWS 4 AND 12 IAW AMM 33-53, CHECKED GOOD.SDR SWAA2017091816412Lens · looseR1 DOOR LOWER EMERGENCY EXIT LIGHT LENS COVER LOOSE. R&R LIGHT ASSEMBLY PER AMM.SDR REXA2017091601007Bulb · inoperativeLIGHT BULBS INOPERATIVE FORWARD EMERGENCY EXIT SIGN. R & R THE BULBS, OPS CHECKED GOOD IAW AMM 33-50-00. OK FOR SERVICE.SDR UIEA2017091801687Bulb · inoperativeEXTERIOR EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BULBS. OPS CHECKED NORMAL IAW AMM 33-51-07.SDR UIEA2017091801686Battery Pack · dischargedEMERGENCY LIGHT (EXTERIOR) AFT L DOOR SLIDE (L397) INOPERATIVE. CHARGED EMERGENCY BATTERY PACK M378. EMERGENCY LIGHT L397. OP CHECK NORMAL IAW AMM 33-51-07.</P>)SDR UIEA2017091801685Battery Pack · dischargedTHE EXTERIOR EMERGENCY LIGHTS, MID L, TYPE 1, AND SLIDE INOPERATIVE. CHARGED BATTERY PACK M378-EMERGENCY LIGHT (L1089) OP CHECK NORMAL IAW B 767 AMM 33-51-01.</P>)SDR HNAA2017091801Power Supply · burnedDURING TROUBLESHOOTING OF SEQ 3, FOUND THE POWER SUPPLY BASE AT 3351-P4 HAS A BURNED ODOR AND APPEARS TO HAVE A BURNED RESISTOR. R & R THE EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-51-00.SDR HNAA20170918317Battery Pack · inoperativeLEFT FUSELAGE MOUNTED EMERGENCY LIGHTS INOPERATIVE. R & R THE POWER SUPPLY AND BATTERY AT 3351-PS3 IAW AMM 33-51-00.SDR DALA2017091806932Charger · inoperativeAFT EMERGENCY LIGHT ON INTERMITTENTLY. ALL EMERGENCY LIGHTS FLASHED ON LOADING. FOUND B5-260 CHARGER INOPERATIVE. R & R IAW AMM 33-51. ALL CHECKED GOOD. OK FOR SERVICE.SDR DALA2017091806990Light · inoperativeEMERGENCY LIGHTS AT ROWS 4-20 ON LEFT SIDE ARE INOPERATIVE. REPLACED EMERGENCY LIGHT PACK M9011. SYSTEM OPERATION IS NORMAL.
Back to JASC 3350