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 DALA2017031301969Light · inoperativeSEAT 29 EMERGENCY LIGHT INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY.SDR REXA2017031100345Light · inoperativeFWD EMERGENCY FLOOD LIGHT INOPERATIVE. R & R THE FLOOD LIGHT IAW AMM 33-51-16. OPS CHECKED GOOD. OK FOR SERVICE.SDR MASA2017031112659Light · inoperativeROW 8 CEILING LEVEL EMER FLOODLIGHT INOP. PLACED ON MEL.SDR E07A201802140002Battery Pack · failedEMERGENCY LIGHTS STAYS ON IN ARM POSITION OR FLASHES ON/OFF IN ARM AND ON.SDR AALA20170311001Charger · failedSEAT MOUNTED EMERGENCY LIGHTS FROM SEATS 20AB TO 24AB FAILED TO TEST. REMOVED AND REPLACED BATTERY CHARGER M737 IAW AMM 33-51-07. OPERATIONAL CHECKED GOOD.SDR QXEA2017031400123Battery Pack · dischargedWHILE PERFORMING THE OPERATIONAL CHECK OF THE EMERGENCY LIGHTS, FOUND THE LIGHTS TO BE INOPERATIVE. CHARGED THE BATTERY PACKS IAW TASK 33-51-00-860-007. PERFORMED AN OPS CHECK IAW TASK 33-51-00-710-803. CHECKED GOOD.SDR AALA201703139041Lens · detachedEMERGENCY EXIT LIGHT BY THE R2 DOOR HAS A DETACHED LENS. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201703139040Lens · missingEMERGENCY EXIT LIGHT BY THE R1 DOOR HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201703139039Lens · detachedEMERGENCY EXIT SIGN BY R2 DOOR HAS A DETACHED LENS. INSTALLED THE LENS IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201703139038Tab · brokenEMERGENCY EXIT LIGHT ON FORWARD GALLEY WALL NEAR FORWARD ENTRY HAS BROKEN TABS. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA201703139037Lens · detachedEMERGENCY EXIT LIGHT BY L2 DOOR HAS A DETACHED LENS. SECURED THE LENS. OPS CHECKED GOOD.SDR AALA201703139036Lens · detachedEMERGENCY EXIT SIGN BY THE L1 DOOR HAS A DETACHED LENS COVER. SECURED LENS COVER IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201703139035Light · missingSEAT MOUNTED EMERGENCY LIGHT AT SEAT 7A IS MISSING. REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-10. OPS CHECKED GOOD.SDR DALA2017031302038Light · damagedDURING CABIN CHECK, FOUND SEAT 27GF EMERGENCY LIGHT TRIM DAMAGED. REPLACED BROKEN BUMPER. SYSTEM OPERATION IS NORMAL.SDR SWAA2017031412494Light · inoperativeLT EMERGENCY EXIT LIGHT INOP AT ROW 11 ABC. RELAMPED PER MM.SDR AALA201703139010Bracket · brokenAIRCRAFT NOT GROUNDED. SEAT 9D EMERGENCY LIGHT SIGN BAND BROKEN. REPLACED EMERGENCY LIGHT BRACKET.SDR AALA201703139004Lens · brokenEMERGENCY EXIT LIGHT LENS BROKEN AT ROW 1. REPLACED THE LENS.SDR HALA2017031000057Power Supply · inoperativeEMERGENCY LIGHTS INOPERATIVE. REPLACED EMERGENCY LIGHTS POWER SUPPLY AND BATTERY IAW AMM 31-51-03. OPS CHECK OK.SDR DALA2017031301968Battery Pack · inoperativeROW 25 OVERWING EXIT LIGHTS INOPERATIVE. BOTH SIDES. REPLACED THE BATTERY PACKS IAW AMM 33-53. TESTED GOOD.SDR SWAA2017031312468Lens · damagedEMERGENCY EXIT LIGHT LENS DAMAGED AT SEAT ROW 23C. R & R THE LENS IAW MM.SDR SWAA2017031312467Lens · damagedEMERGENCY EXIT LIGHT LENS DAMAGED AT SEAT ROW 12C. R & R THE LENS IAW MM.SDR SWAA2017031312466Lens · damagedEMERGENCY EXIT LIGHT LENS DAMAGED AT SEAT ROW 25D. R & R THE LENS IAW MM.SDR SWAA2017031312465Lens · damagedEMERGENCY EXIT LIGHT LENS DAMAGED AT SEAT ROW 12C. R & R THE LENS IAW MM.SDR SWAA2017031312457Lens · damagedEMERGENCY EXIT LIGHT LENS DAMAGED AT SEAT ROW 8C. R & R THE LENS IAW MM.SDR SWAA2017031312455Lamp · inoperativeLEFT WING EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS IAW MM.SDR SIMA20170310002Battery Pack · inoperativeFLOOR EMERGENCY LIGHT STRIPS NR 2 AND 3 INOPERATIVE. REMOVED AND REPLACED THE THE CHARGER ASSY AND BATTERY PACK.SDR SIMA20170310001Lamp · inoperativeSERVICE DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. R & R THE LAMP IAW AMM 33-50-10-000-801-A, & 33-50-10-400-801-A. OPS CHECKED GOOD.SDR MASA2017031012658Light · inoperativeEMER FLOOD LIGHT ROW 21 INOP. RE-LAMPED.SDR CALA2017031000573Power Supply · faultyCABIN EMERGENCY LIGHTS OPERATIONAL CHECK FAILED. MSG,"EPSU UNIT AFT L". REF JOB CARD 17-0550-8-0002. REPLACED EPSU AND BATTERY REF AMM 33-51-38-40 1. PERFORMED OP TEST OF EMERGENCY LIGHT SYSTEM REF AMM 33-51-00- 710-001-A. TEST OK.SDR CALA2017031000571Light · inoperativeEXTERIOR EMERGENCY LIGHT INOP AT DOOR 1L. RELAMPED DOOR 1L EXTERIOR EMERGENCY EXIT LIGHT REF MM 33-51-04. LIGHT OP CHECKS GOOD.SDR CALA2017031000569Fitting · brokenEMERGENCY EXIT LITE ABOVE FLIGHT DECK DOOR HAS A BROKEN CLIP AND WILL NOT STAY ON. REPLACED LITE ASSY OP CHKS NORMAL.SDR CALA2017031000566Light · inoperativeL-1 DOOR EXTERIOR EMERG LIGHT INOP RELAMPED. OPS CHECKED OK. REF MM 33-51-00.SDR CALA2017031000565Power Supply · inoperativeTWO EACH EXIT SIGNS AT UPPER DECK DOORS, ONE IN CENTER CEILING FORWARD AND ONE ABOVE THE R/H DOOR STAY ON WHEN EMERGENCY LIGHT SWITCH IS MOVED FROM ON TO ARMED. FOUND POWER SUPPLY M7050 BAD. REPLACED POWER SUPPLY AND BATTERY. OPS CHECK GOOD SYSTEM OPERATES NORSDR CALA2017031000564Light · inoperativeEMERGENCY LIGHTS, LT OUTSIDE SLIDE, TWO EACH BULBS IN EACH OF AFT TWO FIXTURES INOP. ALL BULBS CHECKED GOOD. REF WDM 33-51-42 PG 3 FOUND ALL EXTERIOR SLIDE LTS AND ALL INTERIOR LTS OP CHK OK REF AMM 33-51-00 501 BULB REPLACEMENT CORRECTED FAULT REF WDM 33-51- SDR CALA2017031000563Light · inoperativeAISLE EMERGENCY LIGHT AT SEAT 47H INOP. RPL EMERGENCY LT AT SEAT ISLE 47H PER AMM 33-51-00/001. OP CHK NORMAL.SDR CALA2017031000562Battery · dischargedEMERGENCY LIGHT IN CEILING OF UPPER DECK, JUST AFT OF THE AFT EMERGENCY EXIT SIGN AT THE TOP OF THE STAIRS MOMENTARILY GOES ON THEN GOES OFF AFTER EMERGENCY LIGHT SWITCH IS TURNED ON. BATT WAS REPLACED. INSTALLED LT ASSY AND CHARGED BATT PER AMM 33 -51-07-402SDR CALA2017031000561Power Supply · inoperativeEMERGENCY LIGHT OVERHEAD BIN BETWEEN ROWS 8 & 9 LT SIDE INOP. REMOVED AND REPLACED EMERGENCY POWER SUPPLY PACK. OPS CHECKED GOODSDR AALA201703109020Sign · detachedEMERGENCY EXIT SIGN BY 24H IS DETACHED. SECURED THE SIGN IAW AMM 33-50-00. OPS CHECKED GOOD.SDR AALA201703109019Lens · missingEMERGENCY EXIT SIGN BY L4 DOOR HAS A MISSING LENS COVER. REPLACED LENS. OPS CHECKED GOOD.SDR AALA201703109016Lens · brokenEMERGENCY EXIT SIGN AT THE R2 DOOR HAS A BROKEN LENS COVER. REMOVED AND REPLACED EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR DALA2017030902050Lamp · inoperativeLEFT AND RIGHT EXIT SIGN LAMPS INOPERATIVE. REPLACED THE LAMPS AND OP CHECKED GOOD IAW AMM 33-51.SDR RAIA201703090002Sign · inoperativeCOCKPIT EXIT SIGN INOPERATIVE. R & R THE SIGN, OPS CHECKED GOOD.SDR SWAA2017031412493Battery Pack · dischargedEMERGENCY LIGHTS BATTERY PACK M1668 INOP. R&R BATTERY PACK PER MM.SDR IPXA2017030914922Warning Message · illuminatedEMERGENCY BATTERY 1 LOW. R & R R & R MSC IAW AMM 31-42-01 OPS CHECKED NORMAL.SDR SWAA2017031312471Battery · failedEMERGENCY EXIT LIGHT M1672 BATTERY FAILED TEST. R&R BATTERY PER MM.SDR SWAA2017031312470Battery · failedEMERGENCY EXIT LIGHT M1670 BATTERY FAILED TEST. R&R BATTERY PER MM.SDR SWAA2017031312469Battery · failedEMERGENCY EXIT LIGHT M1675 BATTERY FAILED TEST. R&R BATTERY PER MM.SDR SWAA2017031312464Battery Pack · no testEMERGENCY EXIT LIGHT M1673 BATTERY PACK FAILED TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2017031312463Battery Pack · no testEMERGENCY EXIT LIGHT M1672 BATTERY PACK FAILED TEST. R & R THE BATTERY PACK IAW MM.SDR SWAA2017031312462Battery Pack · no testEMERGENCY EXIT LIGHT M1670 BATTERY PACK FAILED TEST. R & R THE BATTERY PACK IAW MM.
Back to JASC 3350